Prateek Mahajan

Prateek Mahajan Email and Phone Number

Sr. Informatics Analyst at Aetna @ Aetna
hartford, connecticut, united states
Prateek Mahajan's Location
Greater Phoenix Area, United States
Prateek Mahajan's Contact Details

Prateek Mahajan personal email

n/a
About Prateek Mahajan

I am a goal driven individual and believe in smart work combined with hard work.I am working as part of the encounters team at Aetna in capacity of Sr Informatics Analyst. My previous software experience as well as the learning and experience at SUNY Buffalo has assisted me to be successful in this role. My work involves strict coherence with the HIPAA guidelines and compliance of various state specific and CMS requirements. It includes development, implementation and improvement of processes and reporting(both recurrent and ad-hoc) in order to optimize different business metrics such as efficiency, accuracy and timeliness.My experience in software development and analysis has helped me hone the analytical, technical and leadership skills. Working independently and in team in various projects has improved my communication skills and team management. I worked closely with the onshore team business analyst and subject matter experts in the Insurance and Telecommunication domains and was offshore business analyst for my team. We used data analytics tools such as SAS and Tableau to help analyze and control losses for telecom companies due to various customer issues and complaints; modeled and visualized the dashboards to analyze and learn from the real time trends. During my Masters in MIS from School of Management, State University of New York at Buffalo, I took courses such as Data warehousing and Big Data that helped me enhance my knowledge and skills in data analysis. Systems Analysis and Design, Management of IT projects and Enterprise Modelling have helped me better understand the business side of the industry and the efforts that I can put into the same. I believe, using my past experience along with the skills learnt and honed during this course, I will be able to be an invaluable asset to the future projects and will be able to gain from the experiences yet to come.Contact Information:Email: prateek.mhjn8@gmail.comPhone: 973-906-3301

Prateek Mahajan's Current Company Details
Aetna

Aetna

View
Sr. Informatics Analyst at Aetna
hartford, connecticut, united states
Website:
aetna.com
Employees:
39880
Prateek Mahajan Work Experience Details
  • Aetna
    Sr Informatics Analyst
    Aetna Sep 2016 - Present
    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.
  • Newgen Software Inc
    Business Analyst
    Newgen Software Inc Oct 2013 - Jul 2015
    Noida Area, India
    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.
  • Infosys Technologies Ltd
    Systems Analyst
    Infosys Technologies Ltd Nov 2010 - Aug 2013
    Mysore, India
    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

Prateek Mahajan Skills

Sdlc Javascript Java Sql Test Planning Oracle Sql J2ee Application Development Requirements Analysis Junit Business Analysis Clearquest Software Development Life Cycle Clearcase Microsoft Sql Server Team Leadership Gap Analysis Oracle Tableau Microsoft Office Sas Certified Base Programmer Analytical Skills Project Management Systems Analysis User Acceptance Testing Agile Methodologies Microsoft Excel Visual Basic .net Internet Information Services Team Management Leadership User Stories

Prateek Mahajan Education Details

Frequently Asked Questions about Prateek Mahajan

What company does Prateek Mahajan work for?

Prateek Mahajan works for Aetna

What is Prateek Mahajan's role at the current company?

Prateek Mahajan's current role is Sr. Informatics Analyst at Aetna.

What is Prateek Mahajan's email address?

Prateek Mahajan's email address is pr****@****oft.com

What schools did Prateek Mahajan attend?

Prateek Mahajan attended State University Of New York At Buffalo - School Of Management, Uttar Pradesh Technical University, Asn Sr Sec School, Mayur Vihar-I, New Delhi.

What are some of Prateek Mahajan's interests?

Prateek Mahajan has interest in Science And Technology, Environment, Education, Children.

What skills is Prateek Mahajan known for?

Prateek Mahajan has skills like Sdlc, Javascript, Java, Sql, Test Planning, Oracle Sql, J2ee Application Development, Requirements Analysis, Junit, Business Analysis, Clearquest, Software Development Life Cycle.

Who are Prateek Mahajan's colleagues?

Prateek Mahajan's colleagues are Casey Salamone, James Goodnight, Ellyn Carvalho, Kimberly Clarridge, Vanessa Jackson, Sara Macleod-Arena, Stephanie Delgrande.

Not the Prateek Mahajan you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.