Ajay Gopinath

ButterflyEffect was created to move organisations towards a more pragmatic approach to manage their data risk that is backed by my years in consulting and data governance. It's effective and focuses on the immediate need to secure your data and help organisations derive value from their information assets.

• Developed comprehensive business strategies to enhance operational efficiency and market reach.
• Established key partnerships to drive brand recognition and customer engagement initiatives.
• Built the companies website to ensure that potential customers could have the options to select a short 6 week data strategy engagement or a longer more comprehensive onsite offering.

• APRA -CPG235 Compliance - ensuring that our Data Management policy was supported by an effective Data Risk Management framework.
• Planning and Design of an Enterprise Data Catalog and Data Quality Solution using Informatica Cloud Data Catalog .
• 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.

• 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

• 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.

• 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.

• 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 Impact Analysis
• Source to Target mapping for Salesforce Objects
• Data Quality Analysis
• Informatica Power Centre SME.
• Led the Off Shore Data Migration Team

• 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.

• 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

• Data Migration - Telstra
• Banking Data Warehouse - Bendigo Bank
• Banking Data Warehouse - Westpac