Manpreet (Marty) Singh

• Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
• Developed and implemented data pipelines using Azure Data Factory resulting in a 50% reduction in processing time. Implemented data governance policies resulting in a 30% reduction in data quality issues.
• Worked in specialized programs within Complex Health Solutions like Special Needs initiatives (SNI) and Dual Special Needs Plan (DSNP) that provided support to families with members having special needs.
• Worked with variety of data sources including Member, Provider, Claims & Calls Data
• Created reporting backend for COVID-19 Dashboard that provided key statistics around the pandemic.
• Worked with Snowflake cloud data warehouse for integrating data from various source systems which include loading nested JSON formatted data into snowflake tables.
• Worked on implementing a Fraud Waste and Abuse (FWA) detection strategic program using Java, Cassandra, Spark, Spark Streaming, Hive on MapR Hadoop distributed environment.
• Created various Java/Spark applications for Social Network Analysis (SNA) to identify community of fraudulent providers and Derived Medical Records for deriving the likelihood of a disease based on other diseases on patient’s recent medical history.
• Secured and restricted data for offshore access using Master Offshore Restriction List for various data sources.

• Optimized data storage and retrieval for faster processing, utilizing distributed database systems such as Hadoop and Spark.
• Streamlined ETL processes for seamless integration of various data sources into a unified system.
• Evaluated emerging big data technologies to stay current on industry trends and maintain competitive advantage.

• Architected and implemented various Att.net and Att.com big data ingestion initiatives at AT&T mainly involving extraction, transformation, loading and analysis of big data using Sqoop, PySpark 2.x, Hive and Spark Streaming from various data sources into Big Data Lake cluster of size 400 nodes with 40 Petabytes capacity.
• Implemented data pipelines in Apache Airflow
• Implemented Hadoop platform as a service (PaaS) on Hortonworks Data Platform (HDP) automating HDP cluster installs with auto generated Ambari blueprints.
• Implemented Metadata Encryption Service (AT&T) for encrypting data in Data Lake and used Apache Ranger for providing column level security for Hive queries
• Performance tuning Spark applications.

• Architected and developed Java Web Services (REST and SOAP) for Opportunity Gateway Manager (OGM) project which provides Lower Cost Alternatives (LCA) to brand medications to 10 million OptumRx members.
• Created data pipelines from Oracle to Hadoop (Hive) Data Lake using Informatica.
• Created a generic Java API Library for integrating IBM Interact with Web Services used in OGM and related projects.
• Awarded Rock Star Performer award for implementing LCA project from start to finish in record time.

· Worked on various big data initiatives involving setting up Hadoop cluster, writing MapReduce jobs and setting up data pipelines.