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

• 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.
• 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.

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.

• 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.