Gokulnath Chinnathambi, Senior Data Engineer

• Gather, understand the given requirements from Business Stakeholders and initiate solution workshops to discuss the optimize solutions aligned to business functionalities and scope of the projects under Data Platforms
• Prepare impact assessment document and High-Level Solution Design document detailing about the solution aligned to Westpac standard design principles and patterns.
• Analyzed data using Looker to proactively identify anomalies and limit discrepancies by 26%.
• Prepare a detailed technical design document briefing all the technical aspects and collaborate with Governance team on governance aspects.
• Designed AWS data pipeline workflows for efficient extraction, transformation and loading, which reduced data processing time by 42%
• Deploy and test the constructed code using Continuous Integration and Continuous Deployment in bit-bucket and Jenkins pipeline
• Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
• Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
• Reduced data inaccuracies by 15% and enhanced data quality by refining ETL processes using Python and AWS Glue.
• Developed CI/CD pipelines using GitHub, increasing development efficiency by 34% through automated testing.
• Collaborated with cross-functional teams to define requirements and develop end-to-end solutions for complex data engineering projects.
• Mentored the team members towards the solution outcome and test results
• Implement and Warrant support the code and help run teams to resolve any failures during the warranty period

Achievements:

• Implemented and delivered a critical program called Conflict of Interest where all the HR data fed to My Compliance Office, a third party SAAS consumer application which generates data for Reporting and Analytics on Non-financial Risks
• Performance Optimization of MyComplianceOffice (MCO) application batch jobs.
• Implemented and delivered another critical program called Time Labor Absence Management and Benefits (TLAMB) successfully where we have created a HR data product running Intra-day frequency first time across Westpac Banking Corporation
• Created a single view HR employee profile which simplifies the code construct for all other consumer applications.
• Initiated a data governance strategy using AWS Lake Formation, enhancing data security and compliance.
• Introduced automation in cloud infrastructure management using AWS CloudFormation, saving operational costs by 20%

• Understanding the given requirements and perform Impact analysis and create impact assessment documents
• Analyze, Design and develop code using Informatica PowerCenter 10.4.1, Oracle 19c, Control M V9, Unix/Linux Shell Scripting and IBM Sterling
• Performed unit testing in the Enterprise Information Gateway (EIG) and IBM Sterling applications
• Collaborated with cross-functional teams to identify requirements, design solutions, and deliver integrated systems that met business needs.
• Facilitated knowledge transfer among team members by creating comprehensive documentation on integration processes and best practices.

Achievements:

• Implemented and successfully delivered more than 10 programs on Sterling IBM integration
• Fine-tuned EIG-Enterprise Informatica Gateway batch job in Elumina Care Xpress application
• Optimized system performance by troubleshooting and resolving complex technical issues related to integration, infrastructure, and software components.

• Acted as a Technical Lead and coordinated the team's major implementations like Disaster Recovery testing for all replenishment applications, Informatica on premise and Cloud
• Analyse, Design, Build and code for Replenishment User stories
• Acted as an SME and supported the team by providing application knowledge transition on Fulfilment and Transport Management
• Drive project results by ensuring no SLA breaches on incidents, problems and enhancements
• Created the automation in Replenishment space i.e
• Daily status email for UI availability and Order availability, Replenishment Data Mart reporting availability
• Acted as a Team Lead who managed JDA Replenishment, Transport Management systems, Demand Manager, Lost and Sales Monitor applications
• Transition Coordinator for all the onboarded new applications like JDA TMS 2017, JDA Fulfilment Strategy Project, Lost and Sales Monitor (LSM)
• Application representative and Subject Matter expert for all the Major Network Upgrade, Hardware replacement and OS Patching changes and outages
• Drive the impact analysis and technical verifications as part of all the outages in Replenishment and Transport Management Systems
• Run Weekly meetings with offshore team and ensure no action was missed out and drive towards on time deliverables
• Involved in Major crisis like power failure, power outage and fire at Distribution centre for application restoration from end to end
• Fixed major critical problems in JDA Replenishment, Replenishment Data Mart and Transport Management pace
• Artefact all the major unplanned outages and learnings and created a repository for future use cases.

Achievements:

• Provide strategic solutions on business priority problems by having one-one discussions with Business stakeholders and understood clearly the problem statements
• Led a team of developers to successfully deliver high-quality software projects on time and within budget constraints.
• Maintained close communication with clients throughout project life cycles for accurate progress reporting and prompt issue resolution.
• Enhanced system performance with thorough code reviews, debugging, and optimization techniques.
• Evaluated and recommended new tools and technologies that resulted in increased development efficiency and up-to-date technical skillsets within the team.
• Drive Continuous Service Improvement activities in addition to the problem management to make application systems more reliable
• Implemented Disaster Recovery solutions for all JDA Fulfilment and Transport Management systems and got appreciated by the customers
• Facilitated knowledge sharing sessions, strengthening team expertise and fostering collaborative work environment.
• Coordinated with stakeholders to define project requirements, ensuring alignment with business goals and customer needs.

• Acted as a team member and involved in Incident, Problem, Request and Change Managements for JDA Replenishment, JDA Demand Manager, JDA Fulfilment MASTERS and Transport Management Systems
• Involved in Major Crisis situations like ECDC Location outage and implemented Disaster recovery for the ORACLE NGR Exadata DATABASE machine successfully and got appreciated by customers
• Run all the problem meetings and provided updates to customers in Transport Management Space
• Acted as a team member and maintained business critical applications in a healthy state and fix the issues reported by users
• Provided constant 24X7 technical support for applications to ensure optimal durability and reliability
• Contributed towards Weekly and Monthly governance deck preparation
• Worked closely with JDA MASTER business and fixed more than 10 problems and 5 enhancements
• Identified the gaps in the Solution CARS Data Mart which is a data warehousing solution of BIGW banner in Woolworths
• Contributed to many solutions for stabilizing the system and reduced manual work with automation of monitoring and reporting
• Operational excellence in providing solutions to incidents, Problem Managements
• Trained new support analysts, contributing to the overall growth and success of the team.

Achievements:

• Streamlined support processes for increased efficiency and faster issue resolution.
• Improved customer satisfaction by promptly addressing and resolving support issues.
• Collaborated with cross-functional teams to implement solutions that enhanced system performance.
• Conducted thorough analysis of user requirements, delivering tailored solutions to meet client needs.
• Managed multiple projects simultaneously, ensuring timely completion within scope and budget constraints.