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.• Implemented 271 transactions (Healthcare Eligibility Benefit Response) to reduce claim denials and enhance data accuracy.• Managed and processed Electronic Data Interchange (EDI) transactions, including 835 (Claim Payment/Advice) and 837 (Claim Submission), improving healthcare billing processes.• Utilized 270 transactions (Healthcare Eligibility Inquiry) to streamline patient eligibility and pre-authorization workflows.• Analyzed data sources from Oracle, SQL Server, DB2, XML, Flat files, and COBOL files for migration to Teradata data warehouse.• Participated in JAD (Joint Application Design) sessions to track the flow of data attributes across systems in healthcare and P&C domains.• Created and maintained Logical and Physical Dimensional Data Models using Embarcadero/ER Studio for healthcare data.• Worked with data architects and IT teams to understand data movement, storage, and ensure adherence to healthcare compliance standards.• Developed Source to Target Mapping Matrix containing transformation logic, facilitating ETL processes.• Implemented SCD Type 1 and Type 2 mappings for dimension tables to maintain historical and current records.• Utilized Epic systems for data analysis, providing insights that improved healthcare operational efficiency by 25%.

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.• Implemented ETL processes to integrate P&C insurance data from multiple legacy systems, enabling seamless reporting and analysis across departments.• Streamlined the claims processing workflow by integrating policy and claims data into a centralized data warehouse, improving operational efficiency.• Designed data models for P&C claims, policy, and billing systems to optimize data storage and improve the performance of reporting queries.• Used Snowflake and Informatica to process large volumes of structured and unstructured data, including claims adjuster notes and policy endorsements.• Developed predictive models using machine learning techniques to forecast claims frequency and identify potential fraud in P&C insurance portfolios.• Improved data quality by applying business rules to P&C policy and claims data, addressing data discrepancies and enhancing the accuracy of regulatory filings.• Automated the generation of regulatory reports for P&C insurance filings, ensuring compliance with NAIC (National Association of Insurance Commissioners) requirements.

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.• Used Snowflake functions for semi-structured data parsing entirely through SQL statements.• Created Power BI dashboards with advanced storytelling features like bookmarks, drill-through filters, and custom visualizations using R programming.• Developed machine learning classification models in Python and PySpark to predict binary outcomes based on time-series data.• Wrote JSON scripts for deploying ETL pipelines in Azure Data Factory (ADF) that integrate business models with SQL activity.• Created automated ETL solutions using Databricks, Spark, Python, and Snowflake for unstructured and structured data.• Supported digital product teams by delivering insightful dashboards and data visualizations, driving data-informed decisions.• Worked on data profiling and implemented data quality rules using Informatica Data Quality.• Conducted extensive data validation through complex SQL queries and back-end testing, resolving data quality issues.• Prepared technical specifications for loading data into Data Marts and maintained consistency across environments.• Managed and operationalized Collibra with Azure Rochade for Data Governance and Data Lineage integration.

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 entity.•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.•Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.•Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.•Evaluated and enhanced current data models to reflect business requirements.•Used Power Exchange to create and maintain data maps for each file and to connect Power center to mainframe.•Developed Mappings using Source Qualifier, Expression, Filter, Look up, Update Strategy, Sorter, Joiner, Normalizer and Router transformations.•Integrate Data Stage Metadata to Informatica Metadata and create ETL mappings and workflows.•Involved in writing, testing, and implementing triggers, stored procedures and functions at Database level using PL/SQL.•Migrated repository objects, services, and scripts from development to production environment.•Created UNIX scripts and environment files to run batch jobs.

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 sub-second query response for basic queries.• 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.• Was responsible for ETL and data validation using SQL Server Integration Services.• Defined and deployed monitoring, metrics, and logging systems on AWS.• Defined facts, dimensions and designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.• Evaluated and enhanced current data models to reflect business requirements.• Created Entity Relationship Diagrams (ERD), Functional diagrams, Data flow diagrams and enforced referential integrity constraints and created logical and physical models using Erwin.• Created ad hoc queries and reports to support business decisions SQL Server Reporting Services (SSRS).• Analyze the existing application programs and tune SQL queries using execution plan, query analyzer, SQL Profiler and database engine tuning advisor to enhance performance.• Involved in the Forward Engineering of the logical models to generate the physical model using Erwin and generate Data Models using ERwin and subsequent deployment to Enterprise Data Warehouse.• Given POC of FLUME to handle the real-time log processing for attribution reports.

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.• Developed and tuned all the Affiliations received from data sources using Oracle and Informatica and tested with high volume of data.• Extensively worked on Views, Stored Procedures, Triggers and SQL queries and for loading the data (staging) to enhance and maintain the existing functionality.• Developed Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.• Extracted Data from various sources like Data Files, different customized tools like Meridian and Oracle.