Shilpa Singh

About Shilpa Singh

With over 7 years of experience as a Senior Specialist, I bring a wealth of expertise in…

Experience

1. Senior Specialist - Insurance Operation

   Mercer IMEA

   Jun 2021 — Present · Noida, IN

   o Worked in Singaporean Asia Health Process in the Insurance Domain. o Designing and developing interactive dashboard in Power BI to visualize key performance indicator (KPIs) and metrics. o Create efficient data models in Power BI, including relationship between different tables or datasets, calculated columns, measures and hierarchies.o Data Cleaning and Transformation, Custom visualization, Report publishing and Distribution, Integration and other tools and performance optimization in power BI.o Write the complex SQL queries, Claims management queries, Customer Queries, Agent performance queries, Risk analysis queries.o Handling all kind of reports for the Client, like weekly reports, Monthly Report for production and Accuracy, monthly review reports and quality and old items reduction.o Created Excel-based tools and templates using VBA to streamline data analysis and reporting processes.o Conducted data manipulation, cleansing, and validation using VBA scripts, ensuring data accuracy and consistency.o Collaborated with teams to identify requirements, design solutions, and implement VBA-based applications.o Determining a customer\'s insurance coverageo Reviewing medical records for accuracy and completeness, and making recommendations for further investigation and solutions.o Analyzed and adjudicated healthcare claims, validating information and ensuring adherence to policy guidelines.o Data reconciliation, Underwriting, Data analysis, and then updating the system’s accurate data information. o Cleaning and processing raw insurance underwriting data for modeling or visualization purposes.o Automation and process improvement using python to automate repetitive tasks and develops tools to enhance efficiency in underwriting process and billing process

Education

• Delhi University

  Bachelor of Arts - BA, Political Science and Government

  2015 — 2018

• Indira Gandhi National Open University

  Postgraduate Degree, Political Science and Government

• Narsee Monjee Institute of Management Studies, Mumbai

  Master of Business Administration - MBA, Information Technology