Sampreeth M Email & Phone Number

United States

• Led the analysis of OLTP Source Systems and Operational Data Stores to identify key entities required for healthcare and P&C projects.
• Designed measures, dimensions, and fact matrix documents for efficient data modeling and reporting.
• Created detailed data flowcharts and attribute mapping documents, ensuring adherence to stringent data standards.
• Proficient in using FACETS for healthcare claims processing, membership, and provider management.
• Extensive experience working with Nasco systems for claims adjudication and healthcare data management.
• Led claims data analysis to identify trends, reducing processing errors by 20% and saving $1.5 million annually.

Columbus, Ohio, United States

• Developed data pipelines to process P&C claims data from policy administration systems to data warehouses, ensuring accurate and timely reporting.
• Performed data validation and transformation on policy, billing, and claims data to ensure compliance with state and federal regulatory requirements.
• Analyzed underwriting data and claims history to identify trends and improve risk assessment models for P&C insurance products.
• Automated the ingestion of policy and claims data from third-party vendors into internal systems using Python and AWS Lambda.
• Collaborated with actuaries to analyze claims data, calculating loss reserves and developing models for P&C insurance pricing strategies.
• Created dashboards in Power BI to visualize key P&C metrics such as premium growth, claims frequency, and loss ratios, helping business leaders make informed decisions.

Oak Brook, Illinois, United States

• Analyzed functional and non-functional data elements for profiling, mapping, and source-to-target data transformation in various environments.
• Conducted data profiling for multiple sources, providing insights to business users for complex decision-making.
• Utilized data discovery and mapping tools to scan and investigate records across disparate data sources.
• Developed pipelines in Azure Data Factory (ADF) using Linked Services/Datasets to extract, transform, and load (ETL) data from various sources like Azure SQL, Blob Storage, and Data Warehouse.
• Played a key role in Master Data Management (MDM) projects, creating Data Dictionaries and Source-to-Target mappings within the MDM Data Model.
• Automated jobs using UNIX shell scripts and scheduled cron jobs for seamless execution with Crontab.

Greenwood Village, Colorado, United States

• Identifying the business-critical Measures by closely working with the SME.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed, and sent to an external.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Tested several stored procedures and wrote complex SQL syntax using case, having, connect by etc.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved based on using defect reports.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.

Hyderabad, Telangana, India

• Designing and building multi-terabyte, full end-to-end Data Warehouse infrastructure from the ground up on Confidential Redshift for large scale data handling Millions of records every day
• Generated, wrote and run SQL script to implement the DB changes including table update, addition or update of indexes, creation of views and store procedures.
• Implemented Work Load Management (WML) in Redshift to prioritize basic dashboard queries over more complex longer-running ad-hoc queries. This allowed for a more reliable and faster reporting interface, giving.
• Used Hive SQL, Presto SQL and Spark SQL for ETL jobs and using the right technology for the job to get done.
• Implementing and Managing ETL solutions and automating operational processes.
• Wrote various data normalization jobs for new data ingested into Redshift.

Hyderabad, Telangana, India

• Used ETL to extract files for the external vendors and coordinated that effort.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Oracle and Informatica Power Center.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Done analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database.
• Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs.
• Extensively used Oracle ETL process for address data cleansing.