Objective: A challenging senior level Business Analyst position utilizing my exceptional analytical, technical and communication skills

Education:

• Masters in Business Administration (Major in MIS)
• Bachelors in Mechanical Engineering

Summary of skills

• 5+ years of experience in quantitative business analysis, data management and reporting in fast-paced and dynamic environments
• Strong analytical, problem solving, and statistical skills complemented with effective presentation skills
• Proven successful in managing Strategic initiatives in collaboration with multi-functional teams
• Experienced in understanding business processes and implementing that knowledge to solve critical project issues
• Experienced in using SQL, Access and Excel to extract data, manipulate, analyze, report and document
• Excellent multi-tasking, organization, communication and inter-personal skills
• Adept at developing and maintaining a strong relationship between the partnership teams

Work Experience:

Business Analyst, Confidential. (Jun'08 - Jun' 11)

• Responsible for Leading Business Analysis initiatives and provide strategic solutions for Sales growth, Pricing optimization and Marketplace research.
• Built full year Labor forecasting models and developed resource allocation plans for a $300MM budget; and tracked it against actuals by month, presented spending reports to divisional heads.
• Analyzed the financial impact of $25 prescription transfer offer and assessed the effectiveness of the program by conducting pre and post promotion Statistical Analysis.
• Conducted Journal level deep dive investigations to reconcile variances in expenses, accruals and balanced the entries using Essbase / Hyperion.
• Acted as a liaison and led meetings with Marketing, Finance, IT and District managers to identify growth opportunities and also to resolve key operational risk issues.
• Developed and implemented MIS reporting to monitor expenses and optimized dollar spread across various job categories using Spectrum tool and Access Databases.
• Applied Inventory Data Analytics to develop optimized Flu-shots allocation schedule for 2010 and reduced $1MM in wastage over Prior Year 2009.
• Delivered ad-hoc quality Analytics using SAS, SQL and Excel leveraging multiple databases to support the daily Business and aided Field Managers.

Data Analyst, Confidential (Jun'07 - May'08)

• Responsible for Sales and Marketing analyses to determine campaign effectiveness and optimize ROIs.
• Analyzed Survey and Problog data to improve Panelist Static Yield, a Six Sigma Green Belt project to reduce incentive resolution cycle times.
• Prepared recurring data quality Reports in Access to test the quality and consistency of the data submitted by vendors and users.
• Conducted marketing analysis to develop marketing strategies using qualitative and quantitative market data.
• Developed SQL queries for panelist segmentation activities in response to internal clients' requests.
• Acted as a single point of contact for various teams including offshore team in India to fulfill data requirements.
• Consulted with various partnering teams for improving the projects and implementing changes.

Process Improvement Analyst, Confidential (Aug'06 - Dec'06)

• Improved business processes by interpreting sub-companies' data using statistical analysis and provided business solutions to Senior Executive team.
• Prepared Scorecard for reporting performance of 38 corporate metrics against service level goals for monthly CEO review.
• Analyzed the Money Back Guarantees denial rates and built a "Dependency Report" to monitor and propose changes in Business Rules.
• Utilized Six sigma tools and SPCXL software to process map and analyze business processes and documented.

Marketing Analyst Intern, Confidential (Mar'06 - Jul'06)

• Analyzed the sales data for various categories and developed a sales strategy to promote overhaul kits vs. complete engine sales and identified incremental opportunities.
• Studied key market trends in HDT and identified drivers of sales to develop a marketing program.
• Developed and maintained Control Parts tables and database using Microsoft Access.
• Reported weekly orders and sales summaries using SAS and Oracle.

Sales Analyst Intern, Confidential (Jun'05 - Aug'05)

• Developed and analyzed testing scripts for tracking, signature proof of delivery, pickups on fedex.com using Load runner, Mercury testing tools.
• Aided the tracking team improve performance of tracking strategies by intertwining various data sources.
• Created Testing team's intranet web pages using Microsoft Front Page and Dream Weaver.

Skills

Programming Language : SQL, SAS, SPSS,C, C++ Operating System : Windows, Unix, Mainframes Web Development: HTML, ASP, Microsoft Front Page Databases: MS-Access, Oracle

Masters Projects:

Marketing Research for AutoZone:

• Analyzed and interpreted the results from customer survey data to help improve the overall store performance.
• Developed Sales reporting using Excel and Access to report Retail sales by category, division and market level.
• Ran ad-hoc what-if scenarios, simulations to model and evaluate the marketing plans and optimize spending.
• Performed regression analysis, forecasting, factor analysis, frequencies and cross tabulations using SAS.

System analysis and design of US Election System at Shelby County, Memphis, TN:

• Developed a business process re-engineering plan which involved creating one centralized database to prevent one citizen voting many times and also from being registered at multiple locations.
• Studied the present as-is system, its business requirements and identified where it needs to be consolidated. The designed prototype lays a framework for internet accessible voting system.

Honors and Activities:

• Contributed as an active member of Asian Network Association
• Awarded a Non-Service fellowship
• Stood among top 5 in the Department of Mechanical Engineering