MADHAVILATHA GUDIMELLA
Phone: 704-***-**** / 980-***-****
E-mail: ************@*****.***
EXPERIENCE SUMMARY:
Have close to 4 years of experience in which 1 year was in a Big 4. I did my MBA in Finance. Have good experience in Financial Planning and Analysis which involved many areas including preparing Financial Statements, Variance Analysis, planning, costing, preparing and maintaining financial models which are used for cost allocation and planning, automation at an advanced level, GL detail analysis and reconciliation. Hands on experience in various reporting tools raging from Hyperion, SAP, Business Objects to internally developed SQL/Access based tools. Advanced knowledge in Excel and Access VBA for automation.
PROFESSIONAL EXPERIENCE:
AOL, Bangalore, India
Worked as a Financial Analyst from December 2007 to November 2009.
Reporting tools used: Hyperion Essbase, SAP, Business Objects, MS Excel, MS Power point, MS Access, MS Visio, MS Word, VBA
Experience Summary:
? Preparation of Monthly P&Ls / Financial Statements at various levels.
? Variance analysis of Actuals Vs Plan / Forecast
? Preparation of Cost Centre Reports and Preparation and Analysis of GL Detail
? Preparation of Monthly Reporting Deck and Hierarchy File showing Organization Structure
? Preparation of Forecasting Expenses and Head Count and uploading Plan to Hyperion
? Preparation of various Cost Reports (Maintenance, Consulting and Capital Commitment Costs)
? Maintenance of Cost Allocation Model
? Preparation of Billing Reports and Compliance Reports
? Migrating all the reports from SAP BEx to Hyperion and preparation of detailed SOR
? Automating Process where ever possible.
Ernst & Young, Bangalore, India
Worked as a Financial Analyst from October 2006.to November 2007
Reporting tools used: Hyperion Essbase, Business Objects, MS Excel, MS Power point, MS Access, MS Visio, MS Word, VBA
? Preparation of Monthly P&Ls / Financial Statements at various levels.
? Variance analysis of Actuals Vs Plan / Forecast
? Preparation of Expense Reports, Inventory Reports and Score Cards
? Preparation of Head Count and Time Sheet Reports
? Reporting Key Performance Indicators and Utilization Analysis
? Calculating and posting manual Reserve adjustment for month end
? Production of AD Hoc and Monthly Reports.
? Automating Process where ever possible and preparing detailed SOR
Capital IQ, Hyderabad, India
Worked as Junior Business Intelligence Developer from February 2006 to October 2006.
Reporting tools used: MS Excel, MS Power point, MS Access, MS Visio, MS Word and few internal database tools based on Access and .NET
? Preparation of Monthly P&Ls / Financial Statements at various levels.
? Variance analysis of Actuals Vs Plan / Forecast
? Preparation of Expense Reports, Inventory Reports and Head Count Reports
? Utilization Analysis and production of AD Hoc and Monthly Reports.
? Preparing detailed SOR and automating Process where ever possible
ACADEMIC PROFILE:
? Masters in Business administration with Finance as major specialization and Systems as minor specialization from Osmania University, Hyderabad, India.
? Bachelor of Technology in Electrical and Electronics Engineering from Jawaharlal Nehru Technological University, Hyderabad, India.
? Intermediate (M.P.C) from Saadhana Junior College, Hyderabad affiliated to Board of Intermediate..
? Board of Secondary Education (S.S.C) from New Era public school, affiliated to S.S.C. Board.
TECHNICAL SKILLS:
? Expertise in database tools – Hyperion Essbase, SAP and Business Objects
? Expertise in using MS Office tools - MS Excel and MS Access. Hands on experience in advanced applications such as creating Macros, Pivot Tables, and Lookups etc.
? Expertise in VBA for excel and access.
? Knowledge of MS Visio and SQL
PROFESSIONAL STRENGTHS:
? Good Interpersonal Skills
? Capable of handling process Independently and fast learner
? Good Team Player and good communication Skills
PROJECT SUMMARY:
Title: A STUDY ON PROJECT APPRAISAL AT APSFC WITH EMPHASIS ON FINANCIAL APPRAISAL.
Organization : Andhra Pradesh State Finance Corporation Limited.
Duration : 45 days.
Description : The aim of the project is to evaluate the financial viability of the Company using various capital budgeting techniques such as IRR, BEP, DSCR, etc.
PERSONAL PROFILE:
Name : Madhavilatha Gudimella
Permanent Address : 6114 Andrew Thomas Dr, Apt # 221, Charlotte NC 28269.
Phone : 704-***-**** / 980-***-****
DOB : 06/17/1983
Hobbies : Cooking, Painting, and listening to Music.
E – Mail Id : ************@*****.***