Himakar Velagala
Summary
Results-driven Marketing and Financial Analyst with over 4 years of experience in campaign performance analysis and multimillion-dollar budget management. Expertise in forecasting marketing ROI to inform strategic decisions. Proficient in financial modeling, ROI analysis, and data visualization using Excel, Power BI, and Google Analytics to enhance profitability.
Overview
7
7
years of professional experience
Work History
Financial Analyst
TechAm Inc
10.2023 - Current
- Utilized Excel functions (VLOOKUP, XLOOKUP, Pivot Tables), Word, and Access to improve data analysis accuracy.
- Directed compliance reporting, including P&L and balance sheet submissions on a monthly and yearly basis.
- Implemented Power BI tracking to enhance user engagement, boosting session duration by 25% and reducing bounce rates by 15%.
- Conducted customer acquisition cost analysis across regions, enhancing spend efficiency by 15%.
- Performed monthly budget versus actuals analysis, presenting cost insights to leadership.
- Supported new campaign strategies by modeling projected ROI and budget implications.
- Reconciled inventory transactions to address purchase price variances and resolve discrepancies.
- Conducted ad-hoc variance analyses, providing insights that supported strategic decision-making.
- Delivered insights from variance analyses to enhance overall performance and guide strategies.
Marketing Performance Analyst
IKEA India Pvt Ltd
Bengaluru, India
06.2018 - 08.2021
- Constructed financial projections and evaluated historical campaign metrics to guide marketing strategies.
- Created reporting templates utilized by various teams to monitor CAC and ROI.
- Managed performance dashboards and expenditure summaries for executive leadership.
- Administered digital ad campaign financials (~$500K) relative to forecasts, streamlining accuracy and operational efficiency.
- Evaluated Google Ads data to identify trends in CPC and conversions, facilitating targeted optimizations.
- Designed Excel dashboards detailing ROI and CAC performance across diverse channels.
- Collaborated cross-functionally to realign budgets from low-ROI initiatives.
- Conducted customer segmentation analyses and proposed spending modifications to optimize LTV/CAC ratio.
- Delivered strategic insights and recommendations to senior management
Education
Master’s in Business Analytics -
Governors State University
Chicago, USA01.2024
Post-Graduation Diploma Management - Finance and Marketing
Dhruva College of Management
Hyderabad, Telangana01.2019
Skills
- Power BI and Excel
- Tableau and Google Analytics
- Google and Meta Ads
- Data Studio and SQL
- Budgeting and forecasting
- ROI and attribution analysis
- Campaign optimization
- Cost analysis
- Customer segmentation
- KPI reporting
- Funnel performance evaluation
- Financial modeling
- Team collaboration
Timeline
Financial Analyst
TechAm Inc
10.2023 - Current
Marketing Performance Analyst
IKEA India Pvt Ltd
06.2018 - 08.2021
Master’s in Business Analytics -
Governors State University
Post-Graduation Diploma Management - Finance and Marketing
Dhruva College of Management
Similar Profiles
Ayesha AnwarAyesha Anwar
Financial analyst at MCB BankFinancial analyst at MCB Bank
Michael ShawMichael Shaw
Financial Analyst at Driscoll Children's Health PlanFinancial Analyst at Driscoll Children's Health Plan
Torey JonesTorey Jones
Financial Analyst at Northrop GrummanFinancial Analyst at Northrop Grumman
Clinton OberleeClinton Oberlee
Financial Analyst at Joink, LLCFinancial Analyst at Joink, LLC
Swati NaikSwati Naik
Data Analyst at SP Web ConnectData Analyst at SP Web Connect