Domain : Banking & Superannuation
- Participated in multiple projects at the same time and lead of team of 5 from end to end ( requirement gathering to Prod live) and performed activities including stakeholder engagement and getting acceptance signoff's)
- Designed and created ETL pipelines using IBM Infosphere Datastage to extract data from multiple source systems into EDW run on Oracle-Exadata for multiple projects including AML/FATCA/PBOP (Personal banking Origination platform)
- Lead data reconciliation exercise to ensure data consistency between upstream, EDW and downstream systems ; identified areas where inconsistency existed along with reasoning and suggested fixes for the same.
- Created user forms on RESTfull Web API Oracle APEX for multiple business users and integrated the application with EDW ETL framework enabling user API call driven pipeline execution for multiple projects including APRA Reporting/Campaigning initiatives.
- Collaborated with cross-functional teams to develop innovative technology solutions for business challenges.
- Creating data pipelines to process real-time data and calculations based on values enter by user through Oracle APEX forms.
- Created Source to Target mapping documents for various projects and data lineage
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability
- Employed data cleansing methods, significantly Enhanced data quality
- Created reports, dashboard for business application on Tableau
- Prepared user documentation for hands on training for end user community.
- Used Bash/Linux shell scripting to design and update databases
- Managing the change management process using BMC Remedy tool, Git