Suraj Gulhane

Senior Ab Initio Developer with 8+ years of experience in designing, developing and supporting enterprise ETL solutions across Banking and Financial Services. Strong expertise in Ab Initio, ETL Development, Performance Tuning, Oracle, Unix Shell Scripting and Production Support. Experienced in delivering scalable data integration solutions while working in Agile environments for large enterprise clients.

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.

Bachelor of Engineering - Computer Science & Engineering - G. H. Raisoni College of Engineering (2013 - 2017)