Management Sql Server

SUMMARY: Over six years of experience delivering management consulting solutions, performance management, risk consulting including data analysis and cleansing, project reporting, predictive analytics, and business process improvement. Key abilities include:

Strong analytical, technical, and business skills.

Business development and people management.

Developing dashboards and creating reports for clients and business.

Creating RFP (request for proposal), business requirement document, invoice, managing billing details.

Effective interpersonal and verbal & written communication skills.

Experience with data analysis using quantitative and statistical software.

Strong database and programming skills (Excel, VBA, MS Access, Spotfire, SharePoint, SQL, SAS).

EXPERIENCE: Ernst & Young LLP, Gurgaon, India/Mannheim, Germany/London, Reading, UK -June 2013-March 2016

Senior Analyst

Manage end-to-end process improvement efforts and communication for multiple clients, including current state assessments, developing analysis of alternatives, documenting business rules, and implementing process enhancements.

Providing analytics & consulting solutions for various clients and for Human capital team.

Serve as team-lead for multiple engagements; train and supervised four analysts on a weekly basis. Conduct trainings to teach SQL, Excel, VBA and Spotfire.

Lead efforts to develop a management information system to standardize and monitor financial information for key clients across India and Europe (SharePoint).

Design, develop, and implement dashboards and reports for leading airlines with gross revenue of over $4.8 billion, improving data quality, transparency, and increasing visibility into global financial operations (Spotfire & MS Excel).

Develop and test automation tools utilizing SQL, SAS, and VBA macros; presented analysis to senior management. Review and perform quality control on key deliverables for multiple engagements.

Award and Recognition-

Extra Miler Award – Excellence Performance during Q1 Jul-Sep’15

Cognizant Technology Solutions, Gurgaon, India. August 2009 - May 2013

Associate

Developed dashboards and reporting infrastructure to monitor sales and marketing efforts for major pharmaceutical firms (gross revenue exceeding $23 billion) in the U.S and Europe.

Designed a Return on Investment (ROI) regression model to help major pharmaceutical firms target marketing campaigns and measure success for different geographic locations (SAS, Excel, SQL, and VBA). Provided recommendations on whether marketing strategies could be implemented on a broader level, in other geographies.

Developed a regression analysis on a new drug to understand the impact of changing factors which influenced drug performance before a major product launch (SAS).

Designed a reporting dashboard and reporting tool to monitor the performance of Oncology brands and perform a comparative analysis with leading competitors. 300 reports were delivered through email to key stakeholders on a weekly basis.

Developed drill-down capabilities which allowed users to monitor performance by state, locality, and zip code.

Mentored, trained, and supervised team of five analysts. Performed quality control on deliverables.

Developed excel based reporting tools with MS Access databases for Eli Lilly (MS Access).

Award and Recognition-

Promotion– Promoted to Associate in 2012

Info Edge India Pvt. Limited, Noida, India. December 2008-August 2009

Executive

Web Analysis - Handled operations for Naukri Gulf site, posting jobs, banners for clients.

Prepared, maintained and performed quality assurance for key MIS systems.

Provided the backend/data entry team with details regarding the jobs to be posted for recruiters/clients.

Provided IT support for leading recruitment website in India (SQL Server, HTML).

EDUCATION: Amity University, Noida, India. May 2008.

BTech, Electronics and Communication

Graduated with Highest Distinction

SOFTWARE: Microsoft Excel, VBA, MS Access, Word, PowerPoint, SQL Server, SAS, Spotfire, SharePoint.

CERTIFICATIONS:

Part of the Cognizant’s 4-member SQL Core Training group.

Certificate from Amity Institute of English and Communication on Communication skills.

Certificate from Amity Institute of Psychology and Allied Sciences for Behavioral Science course.

Elementary knowledge of French and German.

Contact this candidate