Ajay Christopher Gopinath
Shailer Park,QLD
Summary
Data Management Lead
Worked across various domains like Telecom , Banking, Federal and State Govt.
Area of Focus
- Data Governance Functional and Technical Specialist - Informatica Data Governance
- Alteryx Data Integration Developer
- Power BI Reporting
Overview
18
18
years of professional experience
1
1
Certification
Work History
Data Governance Analyst
Peoples First Bank
11.2024 - 03.2025
- Implementation(Planning and Design) of an Enterprise Data Catalog and Data Quality Solution using Informatica Cloud Data Catalog . This was done in line with the compliance of APRA- CPG 235.
- Creation of the Glossary and Data Catalogue Guide
- Creation of new Data Management Processes to support the Data Governance Operating Model
- Defined the process for identification and management of Critical Data Elements.
- Defined Informatica Cloud Data Catalogue Scanning Requirements - Databricks.
- Defined Informatica Cloud Data Governance configuration for Business Assets like Data Domains and Subdomains, Business Glossary, Business Applications
- Data Analysis of the Banks Retail Banking System for Data Migration.
- Review Conceptual Data Model and Reporting Overlays.
OPTUS Data Management Specialist
Optus Telecommunications
09.2022 - 06.2024
- Enterprise Reference Data Management using Informatica MDM Multi-Domain
- Captured Reference Metadata Definitions via workshops with the Business and Data Stewards.
- Configured MDM Multi-Domain to set up Reference Dataset
- Enterprise Data Catalog – Informatica EDC/AXON
- Configured EDC to scan various source systems using EDC Connectors/Scanners. Scanner Types included Billing systems using ODBC, Service Now - REST API, Salesforce using JDBC, Hive Big Data Platform
- Sensitivity Data Classification and Curation of data elements
- Refinement of Regex Rules for specific Data Domains
- Solution Architecture to capture the current state of the MDM Platform
- Databricks set up to publish Reference Data Management Table
- Setting up Airflow and Control-M for job scheduling
- Visual Source Code for CI/CD code management
- Power BI – Reporting on the Status of Curation and Classification
- Interface to Informatica Enterprise Data Catalogue via Swagger.
- Developed Alteryx Sever Side Applications to build a customised Catalogue verification process.
- Validating Power BI Reporting reqiurmemnts using SQL Queries
Senior Data Quality and Governance Analyst
Apps, CommSec – Commonwealth Bank
01.2022 - 07.2022
- Data Governance – Assessment of Critical Data Elements
- Identification and management of Critical Data Elements through process workshops and Data Risk Management Program of Work
- Business Metadata definition and Data Lineage mapping
- Data Quality Assessment of Critical Data Elements using SQL on a Mircosoft SQL Server Environment.
- Data Quality Rules Refinements
- Used Collibra Data Governance Tool and Ab Initio.
Developer
UiPath Automation
01.2021 - 12.2022
- Developed UI Path Automation for a Health Care system- Employee Shift Alerting Automation
- Features included automated Data Scrapping from websites, data validation, and Email Notification
- Used AWS DevOps and deployed the application to the cloud.
Senior Business Analyst
The University of Newcastle
06.2020 - 12.2020
- Enterprise Data Warehouse project initiated by the University Of New Castle
- Key Responsibilities:
- Interview Senior Business stakeholders and gather reporting requirements
- Document Use cases, User stories
- Engage System SMEs and Data Custodians to identify data sources/data sets/data transformation rules/current system landscape required for reporting
- Performed Data Analysis – Created SQL Scripts to validate data from the customers CRM and Library Management System
- Tested user interface and data across the financial reporting dashboards to validate the numbers being reported at each level of the accounting units
- Tested security policy ensuring that nominated users had access to the right level of data and worksheets on the Dashboards
- Member of Data Governance and Architecture Group
- Provided Reporting and Power BI Dash board requirements to the development team
- Submissions for CIO for approval, this was for the demand that was identified and aligned with Enterprise Data Architecture
Data Migration - Data SME
Lend Lease Services
01.2019 - 06.2020
- Data Impact Analysis
- Source to Target mapping for Salesforce Objects
- Data Quality Analysis
- Informatica Power Centre SME.
- Led the Off Shore Data Migration Team
Data Engineer
Department of Human Services
06.2018 - 12.2018
- Data Ingestion from the ATO using, Data Services
- Developed Data Ingestion for ATO data provided to DHS as part of Fraud Management
- Created SAP HANA Stored Procedures Created Data ingestion jobs, custom functions, and workflows
- Created data cleansing jobs for name and address data
- Provided data for NDIS account matching
- Unit tested the code and provided support for SIT and UAT.
Specialist Data Warehouse and BI Lead
BHP Billiton
01.2017 - 06.2017
- Developed Technical Design to source data extracts from an LMS System called Success Factors
- The Technical Design consisted of the Solutions Design and ETL design specifications for each extract
- Interfaced with 1SAP to source data for the BI Platform using ODATA Web API) interface
- Built ETL using SAP Business Objects 4.2 for a Go-Live Real-time Data Migration for a System called SureSite which was part of a major implementation for the 1SAP site access System
- Lead the onsite delivery on the day of Go-Live
- Worked with vendors to fix and validate data corruption issues from the source extracts and to integrate the data into the BI Platform
- Created an ERD based on the file specifications - 3NF
- Change Management – Created change tickets on the Global Change Management System to ensure that the build would be Design Approved and could be deployed across the environments TEST/QA/PRODUCTION
- Provided ETL, Database Management Scripts for the creation of tables and also for Rollback
- Managed the Change Management Process across all stages to ensure that perquisites were provided for each stage and resources allocated to the ticket were coordinated with the right information for each of their tasks
Senior Consultant
BearingPoint Management and IT Consultants
06.2007 - 01.2010
- Data Migration - Telstra
- Banking Data Warehouse - Bendigo Bank
- Banking Data Warehouse - Westpac
Education
Master of Information Management - Advanced Information Management
Victoria University
12-2001
Skills
- Informatica Enterprise Data Catalog (EDC/AXON)
- Informatica Cloud Data Governance
- Informatica Power Centre
- Informatica MDM Multi Domain - Enterprise Reference Data Management
- Alteryx Development - Apps and Data Integration
- Talend DI 70
- Uipath 61
- SAP HANA SPS04
- Power BI Reporting
Accomplishments
Officially recognised at OPTUS for automating the Data Classification Curation Process.
Certification
Talend Data Integration Developer - 2019
Timeline
Data Governance Analyst
Peoples First Bank
11.2024 - 03.2025
OPTUS Data Management Specialist
Optus Telecommunications
09.2022 - 06.2024
Senior Data Quality and Governance Analyst
Apps, CommSec – Commonwealth Bank
01.2022 - 07.2022
Developer
UiPath Automation
01.2021 - 12.2022
Senior Business Analyst
The University of Newcastle
06.2020 - 12.2020
Data Migration - Data SME
Lend Lease Services
01.2019 - 06.2020
Data Engineer
Department of Human Services
06.2018 - 12.2018
Specialist Data Warehouse and BI Lead
BHP Billiton
01.2017 - 06.2017
Senior Consultant
BearingPoint Management and IT Consultants
06.2007 - 01.2010
Master of Information Management - Advanced Information Management
Victoria University
Similar Profiles
Ajay Christopher GopinathAjay Christopher Gopinath
Data Governance Analyst at Peoples First BankData Governance Analyst at Peoples First Bank
Terri DemersTerri Demers
Senior Customer Service Representative at Peoples United Bank (M&T Bank)Name ChangeSenior Customer Service Representative at Peoples United Bank (M&T Bank)Name Change
Andrea SuarezAndrea Suarez
Banker at Peoples Community BankBanker at Peoples Community Bank
Cassandra PrzygodaCassandra Przygoda
Registered Nurse at Greenslopes Private HospitalRegistered Nurse at Greenslopes Private Hospital
Mitchell TuckerMitchell Tucker
Chef De Cuisine at The Star BrisbaneChef De Cuisine at The Star Brisbane