SUMMARY
A Reporitng Specialist MBA finance from Dayananda Sagar College and having overall 5 years of extensive experience in MIS Reporting, Data Analysis, VBA developer
• Core expertise in Advanced Excel, VBA/Macro, SQL
• Prepare Dashboard and present to the Management.
• Present the data with Automation & visualization.
• Result oriented, self driven, highly motivated, smart and hungry to learn new methodologies, strategies and processes.
Organization
Working as Reporting Specialist at Great West Global Pvt Ltd and responsible for Dashboard preparation on investements, retirement plans , insurance &staffing capicity planning.
From Oct-3-2016 To April 4-2019
Roles & Responsibility
• Using Statical model for forecasting and trend ofthe participant investment analysis
• Performing testing, maintenance, debugging, and documentation for every process
• Designing client-specific modules for automatic reconciliation and tracking database modification
• Performed extensive analysis to debug, troubleshoot and optimize programs
• Automate the tasks on the basis of client and manager requirements
• Developing and managing staffing forecast models for various Business Units
• Working with process line managers for the progress report of process quality
• Controlling,monitoring and tracking the volume indicator for SlA.
• SQl query to fetch the data of participants investments plans and transfer the raw data into excel sheets and for data analysis , messaging , celaning and munging and prepare the pivotables and dashborad and present to the management.
Employeement History
Mphasis an HP:
Worked as Data Analyst at Mphasis an HP (The Company provides IT services and outsouring and it serves financail services ,telecom ,logistic and technology industries.) Bangalore from Oct-2013 to Nov 2014 and was responsible for Data Analysis.
Roles & Responsibility
• Prepare the MIS report on Product portfolio, Revenue, Employee Production data on daily, weekly and mon