Experience

• 

  Cognizant

  Feb 2007 - Dec 2009

  Programmer analyst

  - Worked for NetApp Inc, GAP Inc., Linksys clients to design, develop and implement their datawarehousing solutions using DataStage, Oracle DB, Teradata, Informatica.

• 

  Mindtree

  Jan 2010 - Aug 2011

  Senior engineer

  - Worked for CIT Bank client to design, develop and implement datawarehousing & Datamart solutions using DataStage, Oracle DB, SAP BO.

• 

  Dxc technology

  Sept 2011 - Oct 2022

  Application designer

  - Worked for clients – Kaiser Permanente, AT&T and Target to build their datawarehouses, integrate data and create reports for business users using various tools and technologies – DataStage, SAP BODS, Informatica, Oracle, PL/SQL, Azure Data solutions, SAP BO, Python etc.,

• 

  Econvergence inc

  Nov 2022 - Nov 2023

  Data engineer

  Worked as Data Engineer to modernize existing systems to cloud technologies – Matillion, Snowflake, Postgres, AWS, Python Collaborate & work with various business and technical teams to gather requirements and analyze the data for better understanding Understand the existing system and migrate the logic and applications into cloud platform. Create end to end data pipelines using AWS Glue, Snowflake, Matillion, Python. Extract and load data from AWS S3 to Snowflake, create stored procedures to load the end to end data between different layers – Raw, Stage, Merge, Curated and EDW. Worked extensively in building data pipelines using Python, Snowflake, SnowSQL, Tasks, Streams, Stored Procedures, views Responsible for developing, tuning, and debugging complex SQL queries. Responsible for data migration from legacy DW platforms to Snowflake cloud data warehouse. Writing complex views, functions and procedures based on business requirements Performing Exploratory Data Analysis using Python libraries Numpy, Pandas and share the data insights with the business Test end to end data pipelines for the data accuracy with the existing data in production Show less

• 

  Kentucky farm bureau insurance

  Nov 2023 - now

  Data engineer

  -Working as Data Engineer to modernize existing systems to cloud technologies – Matillion, Snowflake, Postgres, AWS, Python -Collaborate & work with various business and technical teams to gather requirements and analyze the data for better understanding -Understand the existing system and migrate the logic and applications into cloud platform. -Create end to end data pipelines using AWS Glue, Snowflake, Matillion, Python. -Extract and load data from AWS S3 to Snowflake, create stored procedures to load the end to end data between different layers – Raw, Stage, Merge, Curated and EDW. -Worked extensively in building data pipelines using Python, Snowflake, SnowSQL, Tasks, Streams, Stored Procedures, views -Responsible for developing, tuning, and debugging complex SQL queries. -Responsible for data migration from legacy DW platforms to Snowflake cloud data warehouse. -Writing complex views, functions and procedures based on business requirements Show less