Review and Analyze Business Requirements, Functional Specifications. Create Technical Design Specifications, Delivery Design Documents, Tet Documents, Code Review Checklist, Technical Specification Checklist and troubleshoot any issues.Interacting with client and functional team to get better understanding of the requirement. Involved in migrating existing On-Premise database solutions to Azure Databricks and ADLS in current Microsoft Project Implement solution by leveraging the data in Azure Data Lake Storage and process all the related operations on Azure Databricks Create Data Pipelines for Sales, Inventory and Products at Nike for their Demand Planning SAS Migration Involved in development and support of several internal Microsoft Tools for various groups includes Finance, MS Retail IT Store, CSS and Relevance Teams Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.

Excellent T-SQL development skills to query complex relational databases with the development of Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers Participated to prepare technical design according to functional specifications. Worked on building Data Lakes on AWS S3 buckets as per business needs at Nike Experience on Snowflake Cloud Data Warehouse development Experience creating Airflow Dags using Python Scripts Extensively worked on Data Extractions, Transformations and Loading from various data sources like MS-Excel, Flat files to MS SQL Server using Microsoft SSIS. Thorough knowledge of various SSIS objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc Created SSIS packages to load various Dimensions and Fact tables based on complex business requirements.

Experience in health care sector worked on Claims, Membership data at Group Health.