Senior Associate – Technology - Synechron Technologies - Pune
(2023-03)
Client: Citibank | Private Banking and Customer Hub | Technologies: Ab Initio, Oracle, Unix, Shell Scripting, Autosys
- Developed and enhanced Ab Initio ETL graphs for loading Oracle tables from multiple source systems.
- Developed Day-0 full-load and data extraction ETL processes and provided production support.
- Performed Ab Initio performance tuning, achieving up to 90% reduction in execution time for production processes.
- Implemented database changes including new tables, columns, views and indexes.
- Provided L3 production and UAT support, including issue analysis and resolution.
- Developed Unix Shell scripts for automated housekeeping, file compression and purging.
- Managed production deployments and ServiceNow change requests.
- Worked in Agile methodology while following ETL and SDLC standards.
- Used GitHub for source code management, branch management, code reviews and release activities.
Senior Consultant - Saksoft Limited - Pune
(2021-04 - 2023-03)
Client: TransUnion CIBIL | Alternate Data | Technologies: Ab Initio, PostgreSQL, Hadoop, Hive, Unix, Shell Scripting
- Designed and developed Ab Initio ETL plans and graphs following enterprise ETL standards.
- Led a team of 5 developers, providing technical guidance and design support.
- Used Ab Initio Metaprogramming and PDL to generate runtime DMLs and XFRs for multiple scenarios.
- Monitored and supported production batches through Control Center.
- Developed Shell scripts to improve batch monitoring and operational efficiency.
- Developed Ab Initio processes for generating dynamic email reports using HTML.
Programmer - Bitwise Inc - Pune
(2018-04 - 2021-04)
Client: Discover Financial Services | Enterprise Rewards | Technologies: Ab Initio, Oracle, Unix/Linux, Shell Scripting, Maestro, Bitbucket, IBM TWS
- Developed and enhanced Ab Initio ETL graphs and performed performance optimization.
- Created and maintained Maestro jobs and scheduling processes for batch execution.
- Developed Shell scripts to automate repetitive operational activities and reduce manual intervention.
- Automated Maestro job creation and database loading for testing environments.
- Monitored batch status and supported production processes.
- Performed unit and regression testing, defect analysis and resolution.
- Contributed to the migration of ETL workflows from Ab Initio to Talend Open Studio by developing and enhancing jobs using core Talend components.
