Skip to content

Vemula Lavanya

Financial Analyst • N. Vaddipalli, Nagavaram, Chitvel Mandal, Annamayya District, Andhra Pradesh - 516110

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 Language: Python,SQL
Frontend Technologies: Web scraping
Data Analysis & Visualization: Data Cleaning,Pandas,Power BI,Tableau,Dashboard creation,Microsoft Excel,PivotTables,Forecasting,Equity data processing,RSU & ESPP processing,KPI tracking
Machine Learning & AI: Time Series Forecasting
Data Integration & ETL: Data Validation
Project Management & Collaboration: MS Office
Clinical Data Management: Data Reconciliation
Financial Planning & Analysis (FP&A): Variance Analysis,Financial Statement Analysis

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

Everything on Drivetube

Six products, two of them free forever. Start wherever you are.

Read the docs →
  • Your free digital resume

    at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept.

    Documentation
  • Verified jobs, posted in the last 3 days

    verified openings crawled ATS-by-ATS from 160,000+ real company career pages across 50+ ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed.

    Documentation
  • Written by senior career writers

    human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile.

    Documentation
  • Drivetube OneFrom $39.99 / 3 mo

    Daily matched jobs, tailored resumes, or we apply for you

    Drivetube's paid service. Community sends daily Jobsheets of fresh jobs matched to your profile on WhatsApp and email, with the Drivetube Community ($39.99 for 3 months or $69.99 for 6 months; ₹999 or ₹1,899 in India). Jobhunt is one-time application credits with Community included: one credit tailors one resume and its cover letter (100 for $99 with 3 months of Community, 250 for $199 with 6 months). Let Us Apply is an add-on to Jobhunt: a human expert applies 250 times for you on your credits ($0.60 each, $150). Everything lives on one dashboard at drivetube.ai/drivetubeone.

    Documentation
  • For employers — no job postings, no applications

    hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do.

    Documentation
  • Documentation

    every product explained in full, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.

  • Playbooks

    tactical job-search guides. Each post is one named tactic with the situation it applies to, the exact steps, a copy-paste message and honest failure modes. Free, no account.

The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.

Pricing is identical on the web, iOS and Android — no app-store markup. Monthly Community membership is purchased in the iOS app only; the website sells annual plans. The Android app has no in-app purchase, so Android members subscribe on drivetube.ai and then sign in to the app with full access. Membership follows your account, not your device.