Jun 2021 – Jan 2023 · 1 yr 7 mos · Bengaluru, Karnataka, India

• Driving the co-ordination between onshore and offshore for requirements gathering and to
• understand the requirement from ETL end.
• Preparing the impact analysis documents of ETL Code and aware the client about the impacted
• components/Reports as per their requirements.
• Owning the responsibilities of ETL Job design and preparing Functional, High level and technical
• design documents.
• Design the flow from AWS to ETL DataStage and how the Kafka should work as a Live Streaming
• of the data using Topics.
• Performing Unit testing and hand over to QA team for Regression and performance testing.
• Provides the estimation for the enhancements and change requests in different possible
• scenarios.

Aug 2019 – Jun 2021 · 1 yr 10 mos · gurugram

• Single Handedly hiring and onboarding of all the resources in
• business analysis team for the Project.
• Automated Error Handling in Daily Jobs which reduced Production
• issues by 70% by adding a new I/O Threshold Limit.
• SME of numerous critical activities which includes DataStage Admin
• related tasks.
• Optimized Existing code and reduced daily load time to more than 40%
• which resulted in job completion within SLA.
• Being a key resource of the team, mentored the new joiners with the
• existing process along with my allocated tasks.
• Developed parallel jobs using the stages like Transformer, Sort, Lookup,
• Sequential file and Dataset etc.
• Used Control-M scheduling tool to monitor the jobs and resolved
• Production issues without any escalation.
• Involved with BA’s in providing strategic reporting to customers.
• Worked in full-fledged Agile methodology.

Aug 2015 – Aug 2019 · 4 yrs

• Leading operational team, remotely, in Chennai to reduce manual
• workload of team
• Building,publishing customized interactive reports and
• dashboards,report scheduling using Tableau server.
• Created action filters,parameters and calculated sets for preparing
• dashboards and worksheets in Tableau.
• SPOC for process improvement tasks from the team.
• Automated many manual time-consuming tasks in an optimized manner
• using UNIX and DataStage reducing turnaround time by over 80%.
• Handling additional tasks of helping run team in key ETL issues/major
• enhancements and managerial responsibilities such as leave plan,
• project plan charter, time sheet management, etc.
• Experience in Designing, Developing, Documenting and Testing of ETL
• Jobs in Data Stage to populate tables in Data warehouse and Data marts.
• Access and transform massive datasets through filtering, grouping,
• aggregation, and statistical calculation