Ravi Kumar Email & Phone Number

• Created different stored procedures based on business requirement to pull the data to create different kinds of reports• Used Indexes to make the SQL query execution faster• Knowledge of different HCM product of SAP SuccessFactors • Responsible for Weekly/Monthly/Quarterly/Yearly data maintenance and productivity of the DCs & Resources • Creating Excel Dashboards & basic dashboards using Tableau • To engage with Different Provisioning teams in SF Operations to achieve process & SLA optimization• Resolution of Operational Requirements like APIs, Interfaces via Regular Sync calls with Development teams• Testing of Given Procedures in Service provider Cockpit (SPC) to find out missing Functionalities out of provisioned Instance of SF Product

• Working on variety of standard & Ad-hoc projects for a US major pharmaceutical client in the analytics domain• Gathering requirements from client & onshore team independently; first understanding and then executing the requirement using SQL, Access & other BI tools and presenting insights via PPT, Tableau & Spotfire Dashboards and Excel Dashboards• Helping client to understand the current market situation by weighing their drug against competitors• Enabling clients via insights provided to take critical decisions for brand management, sales and marketing team • Providing insights to client by doing deep dive analysis like: physician prescribing behavior, market share, comparing metrics at national & geography levels• Generating reports related to o Monitoring performance of New Product launch and Pre launch Surveyso Analysis of absolute sales and market share for competitor products across various categories such as Service, Region and thus identify & prioritize improvement opportunities for business

Bengaluru Area, India

• Preparation of Weekly and Monthly Presentations and Dashboards for IT Round Table Conference (KPI)• Preparing Key Performance Indicators Reports.• Preparing Manual efforts & Utilization Reports.• Preparation premium support report on weekly and monthly basis for different Landscapes and Tools.• Regularly extracting the data from SAP tools to generate the daily, weekly and monthly reports.• Validation of the SLA Report on monthly basis to assure the SLA report accuracy.• Preparation of System Availability and Performance report.• Daily working on Ad-Hoc reports for Senior Management team• Preparation of Average and Lowest availability of Server support systems.• Regularly preparing MS Power Point presentations for Senior Management Team for the business reviews on weekly & Monthly basis.• Preparing demand Analysis for Premium support and SPOC data• Preparation of System Installation and Delivery quality and Software Lifecycle report.• Preparation of Service Request report on Weekly and Monthly basis.• Preparation of incident per System report for Server support team.• Preparation of C & I User report for Global IT-IS

• Mentoring the team in requirement gathering and effective Quality Analysis.• Extensive use of MS-SQL and MS Access concepts for deliverables.• Regular extracting of data from SQL database for Daily and Ad-hoc Reports• Preparation of Monthly National Business Report for Senior Management Team• Preparation for Renewal Persistency Dash Board on monthly basis.• Preparation of Product wise collection on weekly basis.• Preparation of Renewal target (Model/Product) on monthly basis.• Region wise Advisor Productivity Report (Collectable VS Collected) on Weekly Basis• Handling Field Queries through E-Mails and Co Desk by running queries in MS Access & SQL Server 2005• Preparing MS Power Point presentations for Senior Management Team for the business reviews on Monthly basis.• Participate in functional meetings to understand and accordingly structure analysis methods for new MIS reports as and when required.• Preparation of report for Life Insurance Council/ MDRT Association on Monthly Basis.