Sudhir Deshmukh

About Sudhir Deshmukh

excellent work experience on various ETL tools and programming languages to extract, clean, transform and load data for reporting and data warehouses. Worked on business requirements gathering, requirement cleansing and documentation along with project plans creation and source to target documentation creation. Have created ETL applications using Ab Initio GDE 3.x/4.x, Ab Initio Continuous > Flows, Ab Initio Express>it, Batch, Python programming and SAS Data Integration Studio. Have worked on end to end development of Ab Initio batch applications, Graphs creation, Scripts and Schedules/Jobs. Have worked on creation of Web Service using Ab Initio Continuous>Flows, converting SOAP Services to REST. Have worked on creating documentations for unit testing, integration testing and production validations. Developed various shell scripts to reduce mundane work as well as production deployment scripts, batch scripts and data migration scripts. Worked on various databases such as Oracle, Teradata, Hive, SAS tables, MySQL. Worked on Hadoop ecosystem- HDFS and Sqoop for HIVE in migration project. Worked on slowly changing data (SCD1, SCD2, SCD3) to load Oracle and Teradata tables. Worked on writing complex SQLs and oracle procedures. Have worked on production support under L1/L2 and L3. POC on Transparent Application Failover (TAF) for Ab Initio web services continuity due todatabase connection fluctuations. POC on JWT implementation using external Java package in Ab Initio web services. Managing offshore and work assignments using Jira stories.

Experience

1. Module Lead (Abinitio)

   Mphasis

   Jan 2024 — Present · Houston, TX, US

Education

• University of Nevada-Las Vegas

  Master of Science - MS, Computer Science

  2018 — 2020

• University of Mumbai

  Bachelor's degree, Computer Engineering

  2011 — 2015