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
Explore Drivetube
- Drivetube Profile — 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.
- Free Job Board — verified openings crawled ATS-by-ATS from 100,000+ real company career pages across 35 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.
- Job Hunt Program — managed job hunting, a one-time purchase from $199.99. JobScout matches verified roles to your real experience band, Blend AI writes a uniquely tailored resume and cover letter for every application, and the Autofill extension fills the form — or Let Us Apply submits it for you. Documentation.
- Resume Writing Services — 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.
- Community Membership — from $4.99/month (₹1,999/year in India). Unlocks the gated job-board filters — visa sponsorship, security clearance, workplace and application time — plus Job-Scout AI matching, Resume Report AI, Interview AI prep sheets, Recruiter Outreach AI sent from your own Gmail, Apply or Skip triage, a daily market feed and a $10,000+ library including 23 ATS-validated resume templates. Documentation.
- Drivetube Hire — for employers — 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.
Full product documentation — every product explained, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.
The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.