Varditer Hayrapetyan
Los Angeles,CA
Summary
Accomplished Financial Analyst with a proven track record at HSBC Bank, enhancing forecasting, reporting, and financial management through advanced Excel automation and financial modeling. Spearheaded projects that reduced operating costs and improved efficiency by over 50%, showcasing exceptional problem-solving abilities and attention to detail.
Overview
7
7
years of professional experience
Work History
Financial Analyst
Leyleverage LLC
11.2023 - Current
- Built financial models that improved forecasting accuracy by 15%.
- Performed gap, variance, and scenario analysis, contributing to a 10% reduction in operating costs.
- Managed budgeting and forecasting processes, leading to a 20% improvement in budget adherence for client companies.
- Conducted P&L analysis, helping to increase profitability.
- Created 13-week cash flow forecasts, enhancing liquidity management by reducing shortfalls by 40%.
- Automated monthly reporting, cutting report preparation time by 50% and reducing errors by 30%.
Excel Automation Expert
German Sparkassenstiftung for International Cooper
09.2019 - Current
- Automated critical business processes, reducing manual effort by up to 90%.
- Developed over 4 Excel-based automation tools for business games, including "Managing Climate Resilience" and "Farmers Business Game."
- Enhanced existing tools for exercises like Savings Game and Micro Entrepreneurial Simulation Training, improving functionality and user experience.
- Automated complex calculations, report generation, and presentations in up to 20 languages, streamlining multi-language support.
- Implemented automation tools in more than 10 countries, cutting down a 3-day manual process to just 1 hour, greatly increasing efficiency in data input, result calculations, and reporting.
Financial Analyst
SADA Systems
10.2022 - 08.2023
- Implemented 10+ financial and payment models for compensation plans, enhancing accuracy and efficiency.
- Conducted detailed analysis and reconciliation of over 100 monthly commission requests, ensuring accuracy.
- Streamlined commission processes, reducing completion time from 1 week to 1-2 days and 2 days to 2 hours.
- Managed monthly account reconciliations and clearings, improving accuracy and reducing discrepancies.
- Produced precise sales forecasts and delivered comprehensive reports to senior executives.
Financial Reporting Manager
HSBC Bank
06.2021 - 10.2022
- Established a robust control environment for regulatory reporting, ensuring compliance and accuracy.
- Prepared and reviewed 30+ monthly reports, including financial ratio and variance analysis, improving accuracy by 20%.
- Streamlined reporting and reconciliation processes, reducing task time from 8 hours to 2 hours.
- Delivered high-quality financial reports with actionable insights, supporting leadership decisions.
- Conducted detailed analyses, including borrower exposure, currency sensitivity, and balance sheet reconciliations, enhancing risk management.
Reporting and Projects Officer
HSBC Bank
05.2019 - 06.2021
- Automated the complex loan rate change process, reducing it from manual procedures to a 1-hour workflow using advanced Excel tools.
- Managed 15 regular facility reports, ensuring accurate and timely submission to the Central Bank Loan Register and Credit Bureau.
- Tripled efficiency in property and car release processes through targeted automation.
- Conducted daily and monthly data reconciliation across systems, identifying and resolving discrepancies to improve accuracy.
- Led a major migration project from previous regulatory systems to new ones, ensuring a smooth transition and improved system performance.
CRM Analyst
HSBC Bank
07.2017 - 05.2019
- Generated 50+ monthly KPI and sales reports for over 100 salespeople and bank branches.
- Produced management information and data for campaigns, projects, and initiatives.
- Planned and coordinated CRM activities, defining target group objectives.
- Prepared business reports on a daily, weekly, quarterly, and semi-annual basis for local and group use.
- Created reports and dashboards to offer insights into customer behavior and engagement.
Education
No Degree - Data Analysis
Calbright College
Sacramento, CA04.2024
Master of Science - Finance
Armenian State University of Economics
Armenia06.2019
Bachelor of Arts - Finance
Armenian State University of Economics
Armenia06.2017
Skills
- Financial Modeling
- Financial Reporting
- Financial Management
- Financial statement analysis
- Excel Automation
- Reporting Tools
- Data Analysis
- Budgeting and Forecasting
- P&L Analysis
- Cash Flow Analysis
- Reconciliation
- Regulatory Reporting
- Problem-Solving
- Attention to Detail
- Communication
- Project Management
Languages
English
Russian
Armenian
Timeline
Financial Analyst
Leyleverage LLC
11.2023 - Current
Financial Analyst
SADA Systems
10.2022 - 08.2023
Financial Reporting Manager
HSBC Bank
06.2021 - 10.2022
Excel Automation Expert
German Sparkassenstiftung for International Cooper
09.2019 - Current
Reporting and Projects Officer
HSBC Bank
05.2019 - 06.2021
CRM Analyst
HSBC Bank
07.2017 - 05.2019
No Degree - Data Analysis
Calbright College
Master of Science - Finance
Armenian State University of Economics
Bachelor of Arts - Finance
Armenian State University of Economics
Similar Profiles
Ida BeachyIda Beachy
Office Manager/Head Bookkeeper at Sunnybrook Excavating LLC, RHL Logistics LLC, Denny's Trucking LLCOffice Manager/Head Bookkeeper at Sunnybrook Excavating LLC, RHL Logistics LLC, Denny's Trucking LLC
Kimberlie PriserKimberlie Priser
Senior Loan Processor at Acrisure Mortgage, LLC Fka FBC Mortgage, LLCSenior Loan Processor at Acrisure Mortgage, LLC Fka FBC Mortgage, LLC
CHAZ WOODCHAZ WOOD
Owner/Project Manager at Residential Recovery LLC/Holistic Homes LLCOwner/Project Manager at Residential Recovery LLC/Holistic Homes LLC
Grace BonafedeGrace Bonafede
TV Talent Assistant to Andrew Kurland at Creative Artists Agency (CAA)TV Talent Assistant to Andrew Kurland at Creative Artists Agency (CAA)
Christian PalmerChristian Palmer
Manager at Mr. T RestaurantManager at Mr. T Restaurant