Skip to content

Vemula Lavanya

Financial Analyst • N. Vaddipalli, Nagavaram, Chitvel Mandal, Annamayya District, Andhra Pradesh - 516110 • l***********@gmail.com • 799****542

Professional Summary

Financial Analyst with practical experience in US equity data processing, RSU and ESPP handling, financial planning and forecasting. Skilled in data extraction and cleaning using Python and web-crawling techniques, building dashboards in Power BI and Tableau, and analyzing financial statements to generate actionable insights. Seeking a role where I can apply analytical skills and domain knowledge to support equity reporting, forecasting and client-facing financial analysis.

Technical Skills

Programming Languages: Python
Frameworks and Libraries: Data cleaning,Pandas,Time series forecasting
Databases: SQL
Data and Analytics: Power BI,Tableau,Dashboard creation,Excel PivotTables, formulas
Tools and Methodologies: MS Office,Report generation,Data validation
Skills: Web scraping
Finance & Accounting: Financial statement analysis,Financial planning and forecasting,Equity data processing,RSU & ESPP processing
Methods & Techniques: KPI tracking,Variance analysis,Data reconciliation

Work Experience

Metrics 4 Analytics
Financial analyst
Tech Stack: Excel, Power BI, Tableau, Python, SQL, Web scraping, Financial statement analysis, RSU & ESPP processing
  • Processed and validated RSU and ESPP datasets for US-market clients, standardizing equity records and ensuring accurate reporting for payroll and advisory teams using Excel, Python and SQL.
  • Developed and executed web-crawling scripts to extract timely stock market and corporate action data, reducing manual data collection and enabling faster updates for client analyses.
  • Built interactive dashboards and visual reports in Power BI and Tableau to present equity positions, vesting schedules and ESPP performance, improving stakeholder visibility and decision-making.
  • Performed financial analysis and forecasting for selected IT companies by analyzing financial statements, KPIs and trend data to produce insights used in strategic and managerial planning.
  • Reconciled discrepancies between market data sources and internal records through SQL queries and pivot reports; implemented data validation rules to improve data quality and audit readiness.
  • Prepared recurring client reports and ad hoc analyses translating complex equity data into concise recommendations and maintained process documentation and standard operating procedures.

Projects

Financial planning and forecasting of selected IT companies in India
Tools Used: Financial statement analysis, Forecasting, Excel, KPI tracking
  • Analyzed financial statements of TCS, Infosys, Sonata Software, eClerx and Subex to identify profitability, liquidity and growth patterns.
  • Applied forecasting techniques to project near-term revenue and profitability trends, highlighting areas of strength and risk for managerial decision-making.
  • Compiled insights and recommendations to support strategic planning and improve financial performance monitoring for selected companies.
Customer satisfaction survey on Clinic Plus shampoo in Andhra Pradesh
Tools Used: Survey analysis, Data interpretation, Report writing, Excel
  • Designed and analyzed a customer satisfaction survey to measure perceptions of product quality, fragrance and availability among users in Andhra Pradesh.
  • Found affordability and availability as key drivers of satisfaction and identified opportunities for product innovation and marketing strategy improvements.
  • Prepared a report summarizing findings and recommendations to help inform brand strategy and customer experience improvements.

Education

Sri Venkateswara University
MBA
BEST INNOVATION UNIVERSITY
BSc. Agriculture
Narayana Junior College
Intermediate
Macca High School
SSC

Powered by Drivetube · Create your own profile at drivetube.ai