Abhishek Kumar

Experience

• 

  Ebix

  Dec 2008 - May 2011

  Data Analyst & Sr. Quality Auditor

   Done single handed transition right from the solution identification, setting up benchmarking metrics, SLAs for the one of the leaders in Gas & Energy Market. Prepared all SOP’s & did Risk (FMEA) Analysis & design dashboards. Implemented Six sigma and leans tools like VSM, 5S & VM to remove waste, variations & defects from the different processes. Actively involved with their WFM department and their daily activity. Identify areas for improvement, scope projects and involve relevant others. Create enthusiasm for the process. Worked in different projects Based on predictive modeling or forecasting strategy and worked on to automate different reports with the help of macros. Automated different reports which helped us in tracking performance to achieve measurable business objectives in lesser time.  Learn how to develop a project management plan, define scope and determine project requirements. Made various report for my organization which helped in maintaining data, also prepared dashboards reports and design their front end, helped in making strategies based on business trends, client inventory, floor staffing.  After that we received one by one other business related to this project during this time period I design process steps for several account. Generate more than 50 Lean Ideas for Process improvement. And implement these ideas into the project. Key Member of Content Data Analysis Team, which delivers Reports, timely & accurately according to client requirement.  Generate queries (SQL)according to Organizational requirement & Clients Support  Make a quality report, Production report etc. Show less

• 

  Artech Information Systems

  May 2011 - Jan 2012

  Data Analyst

   Performing quartile analysis for them to see where we stand, what needs to be done.  Meeting client Goals, ROR’s & staffing levels to ensure maximum profitability in line with organizational objective. Learn how to develop a project management plan, define scope and determine project requirements. Made various report for my organization which helped in maintaining data, also prepared dashboards reports and design their front end, helped in making strategies based on business trends, client inventory, floor staffing.  Proficient in managing teams and contributing towards improved financial performance & heightened productivity. Increase the effectiveness and efficiency of Support Services through coordination and communication between functions. Develop SQL queries for fetch out real time data from database. Show less

• 

  GENPACT LLC

  Jan 2012 - now

  Analyst

  Since Jan’12 Genpact India Pvt. Ltd., GurgaonGrowth Path:Jan’12 – Jun’15 Management TraineeJul’15 – Till Date Assistant ManagerKey Result Areas:• Simplifying & streamlining procurement & supply chain project in Genpact Patna for GE Transportation and Indian Railways • Preparing Material Tracking Report, Inventory Report and various others reports on Tableau• Developing Excel Macro to automate the reports as per business requirement• Analysing data to determine understand the business requirement to showcase Benefit at Category and Sub Category level • Providing quality control standards being embedded in the data preparation processes (i.e. existence of source data, duplication of data, automatic log checks, error handling mechanism, and so on)• Coordinating with management for analysing, data creation, data extraction, cleansing, manipulation, transformation, exploration, summarization and visualization• Communicating key analytic findings to client and addressing client's analytic concerns• Building & implementing Motor Benefit Model, Hire Car Model, Towing Model & Home Benefit Models using SAS, Regression & Forecasting Techniques• Designing Score Card Models to assess the supplier’s capabilities which help Category Managers to decide upon which one is to be chosen for the given work• Manipulating & preparing pricing data and extracting data using SAS, SQL, Excel & Access• Combining data sets like concatenating and merging SAS data setsAccomplishments:• Facilitated other team members in automating Business Processes and LEAN Projects• Managed multiple projects of different teams at Genpact level• Bagged multiple appreciations from client for the successful completion of work well within the tight timelines• Created ETL package to integrate data from multiple data source using MSBI SSIS• Developed SSAS cube and reports by using SSRS Show less