Prateek Mahajan

Experience

• 

  Infosys

  Nov 2010 - Aug 2013

  Systems Analyst

  Improved the system efficiency by migrating the client’s Mainframe application to web application.Implemented different dashboard screens for the managers to analyse the patterns and make decisions.Led team sessions for implementing of defect-prevention strategies to reduce defect infliction rate by 60%.Ensured timely remediation of defects by diagnosing and classifying them.Initiated Defect-Prevention plan in collaboration with team leaders and project manager to be used throughout the business unit Show less

• 

  Newgen Software

  Oct 2013 - Jul 2015

  Business Analyst

  Collaborated with team for developing more than half of the total project modules.Developed and implemented various reports and dashboards to use data to evaluate programs and product solutions.Participate in presentations and consultations to constituents on information services, capabilities and performance results.Created SQL queries to facilitate user authorization for different activities in client application.Led and managed a team of 8 members, delivered 100% of releases before deadline.Conducted knowledge transfer sessions spanning over two weeks for new hires in the project.Created documents and presentations for easy understanding for the new team members. Show less

• 

  Aetna, a CVS Health Company

  Sept 2016 - now

  Sr Informatics Analyst

  Led the plan wide process change, collaborating with systems analysts and IT team to migrate three plans to a new encounters system. Initiated new processes in other departments for existing data cleanups and new data verification and validations.Lead and manage various Medicaid and Medicare plans, submitting the healthcare information to State agencies and CMS to be processed, currently handling 3 Medicare advantage and Duals plans.Perform analysis of varied healthcare data to evaluate programs and product solutions using healthcare medical, pharmacy, lab, survey and utilization data to increase the submission accuracy and timeliness to 99% .Collaborated with the validation and claims analysts to increase the process efficiency and avoided >$500,000 losses in form of sanctions across the plans.Develop and implement various weekly/ monthly recurrent reports and processes to support and shape management decisions. This has led to additional reimbursement of more than $20 million from the state and CMS till date.Develop, validate and execute algorithms and predictive models to solve business problems. Execute univariate and multivariate statistical analyses and interprets results in the context of the business problems or questions.Develop and implement various ad-hoc reports to evaluate accuracy and timeliness of data.Participate in presentations and consultations to constituents on information services, capabilities and performance results.Create and evaluate the data needs of assigned projects and assure the integrity of the data. Show less