OM S

IT BI professional specialized into Healthcare, e- commerce, insurance, etc

• Involved in Data Mapping activities for the data warehouse.
• Produced PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• Designed and developed Security Framework to provide fine grained access to objects in AWS S3 using AWS Lambda, DynamoDB.
• Performed end- to-end Architecture & implementation assessment of various AWS services like Amazon EMR, Redshift, S3.
• Used AWS EMR to transform and move large amounts of data into and out of other AWS data stores and databases, such as Amazon Simple Storage Service (Amazon S3) and Amazon DynamoDB.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using ER Studio.
• Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.

• Transformed the data using AWS Glue dynamic frames with PySpark; cataloged the transformed the data using Crawlers and scheduled the job and crawler using workflow feature
• Implemented AWS Step Functions to automate and orchestrate the Amazon SageMaker related tasks such as publishing data to S3, training ML model and deploying it for prediction.
• Integrated Apache Airflow with AWS to monitor multi-stage ML workflows with the tasks running on Amazon Sage Maker.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Designed Logical/ Physical Data Model for E-Delivery System Using ER-Studio.
• Created SQL Loader Scripts, table sizing, indexing, table partition, SQL tuning.
• Created/ Tuned PL/SQL Procedures, SQL queries for Data Validation for ETL Process.