Ayih Sitti
Ottawa,ON
Summary
- Results-driven professional with 8 years of experience in Reporting, Reconciliation, Data Analytics, and Data Visualization. Proven ability to manage stakeholders effectively while maintaining strong work ethics and values. Holds a bachelor's degree in finance and demonstrates proficiency in SQL, Google BigQuery, Tableau, and Python. Recognized for high productivity and exceptional problem-solving skills in financial data analysis and payment processing.
Overview
14
14
years of professional experience
Work History
Senior Payment Analyst
Lightspeed
Gatineau, Canada
12.2022 - Current
- Company Overview: www.lightspeed.com
- Use advance SQL query to pull daily revenue and cogs.
- Refine data processes, set up tools, and create automation to improve operational efficiency.
- Produce monthly Profit & Loss report and make recommendations for improvements.
- Conduct various projects and maintain relationship with various partners.
- Execute analyses to identify revenue optimization opportunities and improve business performance.
- Assist with daily operations and analytics as needed.
- Review cash reconciliation and sign off the month-end reports.
- Perform clients' rate analysis using Excel Power pivot and IF formula to identify the gaps.
- Create various reports using Excel Power Pivot, Power query, SQL, etc…
- Prepare and present Weekly and Monthly Business review.
- Explain and document any discrepancies in our control.
- Produce and submit monthly compliance files to the auditors.
- Www.lightspeed.com
Payment Reconciliation Analyst
Lightspeed
Gatineau, Canada
03.2020 - 12.2022
- Company Overview: www.lightspeed.com
- Create reports for management and perform data analytics for weekly and monthly business review.
- Queried SQL database using advance SQL to pull Sales volumes and Revenue.
- Built models to evaluate the effectiveness of our cost.
- Perform analytic on our cost and provide recommendation.
- Create monthly Profit and Loss report for management and highlight key points to focus on.
- Ad-hoc reporting and analysis (potential churned clients, Partner compensation, etc.…)
- Weekly and Monthly Business review with Power Point presentation.
- Created Excel VBA macro to automate some tasks.
- Automated daily reconciliation tasks by using Excel Power query, Power Pivot & Data Model.
- Use Python- Pandas to transform data and make it easy to analyze.
- Www.lightspeed.com
Financial Analyst
Paymentus
Toronto, Canada
08.2013 - 03.2020
- Company Overview: www.paymentus.com
- Performed monthly margin analysis and provided key information to the company board.
- Achievements: My Analysis showed that high-cost credit cards negatively impact our margin and the board decided to re-negotiate our contract with some clients.
- Worked closely with payment processor (WorldPay, Paymentech, Moneris, etc.…) to on board new clients.
- Bank reconciliation to ensure that all our revenue get deposited into our bank account and our processing fees align with invoices we received.
- Retrieved each client payments transactions and applied the rate as per their contract to calculate their monthly invoice.
- Retrieve chargebacks transaction, apply the rate as per each client contract.
- Book entry.
- Point of contact of clients who wish to add American Express or PayPal as payment method.
- Create and update documentation related to Finance team procedures.
- Generate reports to make sure credit card transactions are not above the limit as per contract.
- Add account receivable in Quickbook and Sage.
- Follow up with clients with past due balance.
- Www.paymentus.com
Financial Advisor
Desjardins Bank
Montreal, Canada
11.2011 - 01.2013
- Company Overview: www.Desjardins.com
- Analyzed the mortgage application and approved mortgage loans.
- Pulled client's credit bureau and background check.
- Analyzed risk associated to client and approved or denied loans.
- Assisted customers with loan consolidation applications and approved applicants with strong credit records or escalated the decision to my manager.
- Created and continually reviewed clients' financial plans that included strategies designed to help them reached their long-term goals.
- Brought new customers to the bank by conducting kiosk and conferences.
- Involved in processing client account documentation, maintaining client files and database, assisting in writing and processing clients' letters and proposals.
- Participated in different training courses that involved customer service, like Negotiations Techniques, Customer Care, Sales Strategies and Techniques.
- Made sure all credit applications adhere to our compliance policies.
- Reviewed delinquent accounts and negotiated satisfactory payment plan with the clients.
- Reviewed, analyzed, and followed-up with clients to resolve delinquent accounts.
- Www.Desjardins.com
Education
Microsoft Power BI Couse -
03.2023
Data Science Certificate - Statistics, Machine learning algorithms with Python, R, ETL, Data normalization, etc.…
Sheridan College
Montreal, Canada03.2022
SQL query course -
12.2019
Certificate in Personal Finance -
HEC Montreal
Montreal, Canada01.2013
Investment Funds in Canada (IFIC) -
CSI
Montreal, Canada08.2011
Master's degree in business administration - Finance and statistics
01.2007
Skills
- SQL querying
- Data analysis
- Profit and loss reporting
- Financial modeling
- Process automation
- Cash reconciliation
- Compliance reporting
- Attention to detail
- Microsoft Excel
- Data analytics
- Internal controls
- SOX compliance
Languages
English
Full Professional
French
Full Professional
Timeline
Senior Payment Analyst
Lightspeed
12.2022 - Current
Payment Reconciliation Analyst
Lightspeed
03.2020 - 12.2022
Financial Analyst
Paymentus
08.2013 - 03.2020
Financial Advisor
Desjardins Bank
11.2011 - 01.2013
Microsoft Power BI Couse -
Data Science Certificate - Statistics, Machine learning algorithms with Python, R, ETL, Data normalization, etc.…
Sheridan College
SQL query course -
Certificate in Personal Finance -
HEC Montreal
Investment Funds in Canada (IFIC) -
CSI
Master's degree in business administration - Finance and statistics
Similar Profiles
Hunter LeederHunter Leeder
Self-Directed Trader at LightspeedSelf-Directed Trader at Lightspeed
Jennifer MiguelJennifer Miguel
Financial Services Support Specialist II at LightspeedFinancial Services Support Specialist II at Lightspeed
Yazmeen BobadillaYazmeen Bobadilla
Sales Coordinator at LightspeedSales Coordinator at Lightspeed
Mostafa Saad AwadMostafa Saad Awad
Food Service Attendant at Bruyere HealthFood Service Attendant at Bruyere Health
Trinidad ElmerTrinidad Elmer
Bindery Supervisor at Doculink InternationalBindery Supervisor at Doculink International