Summary
Overview
Work History
Education
Skills
Websites
Core Expertise
Professional Summary
Work Right
Personal Information
Timeline
Generic

Sathyanath Gopinathan

Craigieburn

Summary

Seasoned professional with 20+ years of professional experience in data specialist with strong expertise in designing and managing enterprise data architectures. Skilled in data modeling, ,data migration,database management, and data integration. Focused on team collaboration and delivering impactful results. Known for adaptability and reliability in dynamic environments.

Overview

21
21
years of professional experience

Work History

Data Architect

Scyne Advisory
07.2024 - 04.2025
  • Company Overview: (MDBA – Federal Government Project)
  • Lead the hands-on design and implementation of MDBA’s Cloud Data Platform using Medallion Architecture, enabling cross-jurisdictional data collaboration for the Integrated River Modeling Uplift (IRMU) program.
  • Deliver a unified MDIRAS (MDBA Data Integration & Reporting Analytics System) platform to streamline model data processing, governance, and insight.
  • Build end-to-end Azure data solutions using ADLS Gen2, Azure Data Factory (ADF) to ingest, transform, and serve multi-source model data.
  • Design logical/physical data models (dimensional, star schema) aligned with hydrological modeling requirements.
  • Implement Medallion Architecture (Bronze → Silver → Gold layers) for structured data refinement, ensuring traceability, quality, and usability.
  • Develop automated ETL/ELT pipelines in ADF to process varied datasets from state agencies and FIRM Api’s.
  • Enforce data quality rules (Great Expectations, DQ checks in ADF) to validate inputs/outputs for regulatory compliance.
  • Standardize data contracts with state partners (Victoria, NSW, SA) to harmonize schemas, units, and temporal resolutions.
  • (MDBA – Federal Government Project)

Data Migration & MDM Specialist

Cleanaway
06.2023 - 06.2024
  • To achieve the end state of CCR1 (customer connect), Data migration is required in Salesforce lightening and JDE from following source systems. (Salesforce Legacy, Salesforce Lightning, Visual RAMS Pro, JD Edwards, Navision).
  • Worked as Senior Data Migration and MDM specialist to delivery of migration projects CCR1 for clients’ ERP and CRM systems from Sales Force Legacy, JDE9.0, Navision and VRP to MDM for mastering the data and migrate the data to Sales Force Lightening.
  • Key skills utilized – SQL, ADF, SOQL, stakeholder management, migration planning, vendor management and Power BI.
  • Proposed design & technical solutions to improve the project delivery.
  • Performed various Data analysis on all source systems including Gap Analysis and Data Mapping.
  • Flow customer data into the MDM (continuous process).
  • Developing custom Metadata framework for ADF pipeline.
  • Developing ADF pipelines to extract data from various sources.
  • Developed Business reconciliation scripts to fix the DQ issues.
  • Developed DQ validation rules and multiple Dashboards DQ Summary, Account Summary, Business Recon and Technical Recon for DQGC (Data Quality Governance Committee).

Senior Technical Lead

Australian Unity
04.2021 - 06.2023
  • The Project Ruby is planned to ingest various source systems to one Centralized location (EDP) to build the necessary foundation to implement a EDW to Integrate, access, high quality and mastered data providing the foundation for customer journey, reporting and analytics.
  • Work closely with stakeholders to understand their data needs, including key metrics, reporting requirements, and data sources.
  • Leading a development team (BI developers and Data engineers).
  • Created logical and physical data models for EDW.
  • Defined entities and relationships: Identify key entities (e.g., business objects, transactions) and their relationships, and map them to the appropriate components of the Data model.
  • Implement data modelling best practices such as normalization techniques, naming conventions, and data typing, to ensure consistency and scalability of the EDW.
  • Design and develop EDW Data Modelling across different line of business so that conformed dimensions can serve to different business use cases.
  • Design and develop dimension model for EDW and various Data marts, WCM specific business and functional capabilities.
  • Designed and implemented BRE framework for various reporting modules.
  • Successfully delivered solutions for DDO, FATCA and AML reports.

Data Migration Lead

MACS
06.2017 - 04.2021
  • Data Migration Lead (Migrating the existing SAS system to Synergetic), Design and develop Data Model for ePortal for teachers, leader and parents.
  • Profiling source data to understand its structure, quality, and relationships.
  • Analyzing source systems to identify key entities, relationships, and data transformations required for the Data Vault.
  • Creating comprehensive documentation for the Data Vault model including entity-relationship diagrams, data dictionaries, metadata and Enterprise Bus Matrix.
  • Creating logical and physical model designs using Erwin.
  • Design ETL framework and ADF packages to monitor and control the data load.
  • Design complex stored procedures in SQL to cover varied business rules and validations.
  • Designed and developed data validation and verification frameworks for Data migration.
  • Designed and developed staging, relational and dimensional models to accommodate integration of multiple systems and for self-service reporting.
  • Working closely with Vendors on external data (NAPLAN, AEDC, ACER and Attendance).

Senior Consultant

DXC Technology
09.2016 - 06.2017
  • Company Overview: Ventia is a trusted partner to leading telecommunications and ICT network providers, and industries who rely on mission critical infrastructure.
  • Designed and developed new DW solutions to save on the on-going running cost and possible enhancement cost of the existing report.
  • Break the dependence of the NIFM reports through DW implementation.
  • Developed store procedures, views and functions.
  • Integrate existing information systems and data sources to facilitate access to data.
  • Document functional requirements and prepare technical and user documentation to BI solutions.
  • Investigate improved methods and processes that may improve the quality, integrity, reliability and performance of BI systems.
  • Ventia is a trusted partner to leading telecommunications and ICT network providers, and industries who rely on mission critical infrastructure.

Senior Business Intelligence Analyst (Migration)

Lumo energy
03.2015 - 09.2016
  • The Data Migration of the Lumo mass-market customers to Red’s Gentrack system forms part of an overall Lumo-Red integration program that aims to create one single new Snowy retail organization, keeping both brands alive depending on the state.
  • The aim is to migrate all Lumo customers into Red’s systems over a period of 18-24 months. NSW mass-market was chosen as the first customer base to be migrated.
  • Coordinate cross-functional teams (IT, analysts, stakeholders).
  • Source system and Target system mapping, data structures and dependencies.
  • Identify data quality issues and define cleansing rules.
  • Develop custom framework for ETL.
  • Execute ETL/ELT packages for data extraction.
  • Handled high volume of transaction data and implemented batch processing.
  • Developed complex store procedures, views and functions to transform data to meet target system requirements (formats, standards).
  • Load transformed data into the target environment.
  • Conduct incremental testing during phased migrations.
  • Resolve discrepancies between source and target data.
  • Verify data accuracy, completeness, and consistency post-load.

Microsoft BI Consultant

Oakton Consulting
07.2013 - 02.2015
  • Working on the development of the new requirements and enhancement/support of the existing BI system (SQL Server 2012 SSIS, SSRS, SSAS and MDS) with Agile development methodology.
  • Participating in Agile software development scrums with fortnight sprints.
  • Identified and resolved impediments, worked with product owner to groom the product backlog.
  • Developed ETL packages using SSIS 2012.
  • Developed store procedures, views and functions.
  • Developed customized ETL framework for Audit and Data quality.
  • Designed and developed OLAP cubes using SSAS 2012.
  • Created different types of reports using SSRS 2012/MDX.
  • Created calculated measures and partitions on OLAP cube.
  • Involved in database design and query optimization.
  • Involved in unit and system testing.

Senior Technical Consultant

Aditi Technologies
01.2011 - 05.2013
  • Customer Sales and Service Group Scorecard Metrics (MetLife): Developed reports to analyse the sales information on the products against their actual vs planned values.
  • The source of data for the dashboard application is coming from various systems of records in the form of excels.
  • Leading a team of developers through all phases of project.
  • Participating in Agile software development scrums with weekly sprints.
  • Facilitated release planning, Identified and resolved impediments, worked with product owner to groom the product backlog.
  • I played a business analyst role along with technical lead role to understand the requirement and come up with design and approach.
  • Developed ETL packages using SSIS 2008R2.
  • Designed and developed OLAP cubes using SSAS 2008R2.
  • Created different types of reports using SSRS 2008R2/MDX.
  • Created calculated measures and partitions on OLAP cube.
  • Involved in database design and query optimization.
  • Validate the quality of data and work to improve data quality.
  • Preparing design specification document.
  • Delivered high quality tested software with agile teams.

Associate Consultant

UST Global
01.2010 - 12.2010
  • Point Of Sale (Hanes Brands Inc): HBI had developed POS cube in SQL server 2005 to capture sales information and do an analysis on sales.
  • But the current design doesn’t support their need and the POS cube is shelved without deploying in production.
  • Understand and identify the problem areas in the existing Datawarehouse and reporting layer.
  • Create a presentation on finding a solution to the issues.
  • Perform impact analysis of the changes.
  • Implementing changes in the dimensional model, SSIS data load, and SSAS Multidimensional cube.
  • Provide post-go-live support.

Technology Solution Specialist

Infosys Technologies Ltd
04.2006 - 12.2009
  • FinPulse Data Mart: This data flows from SAP GL module for the actual revenue and expense data.
  • This data is transformed by an expense re-allocation process and hence the margins are computed at different levels in the delivery organization.
  • HR Data Mart: There is information analysis required on various attributes of an employee’s data.
  • The HR data mart addresses the consolidation of data from various sources related to employee data.
  • Analytical solution for request tracking system: Used to analyse performance of service groups within the Service Level Agreements; designed to work for a customer base of 90,000 employees.
  • This project helped in reduction of the support staff from a team of 10 to 3.
  • Requirement gathering, Source system study and Dimension modelling.
  • Understanding of different source systems for the required data.
  • Developed ETL packages using SSIS.
  • Design and developed OLAP cubes using SSAS.
  • Created calculated measures and partitions on OLAP cube.
  • Created SSRS reports and rendered it to SharePoint portal.
  • Validate the quality of data and worked on improvement on data quality.
  • Prepared design specification document.

System Admin

Kilmist Infotech
08.2004 - 04.2006

Education

Master of Science - computer science

Bharathidasan University
TamilNadu. India
04.2003

Skills

  • SQL
  • Redshift
  • Postgres
  • JD Edwards EnterpriseOne 92
  • Salesforce
  • ADF
  • Microsoft Azure
  • AWS
  • Erwin Data Modeler
  • Microsoft Visio
  • T-SQL
  • MDX
  • DAX
  • Git Hub
  • ETL development
  • Lakehouse
  • Data Modeling
  • Data Migration

Core Expertise

Deep proficiency in Microsoft Azure & AWS, designing scalable cloud-native solutions., Expert in Power BI, SQL, MDX, DAX, and C# for data transformation and visualization., End-to-end EDW development, data migration from legacy systems to modernization and Salesforce data migration to cloud-based architectures., Strong command of Scrum, Kanban, and CI/CD pipelines for efficient project delivery., Active Baseline

Professional Summary

Comprehensive experience in all phases of SDLC, including requirements gathering, planning, design, development, testing, deployment, and maintenance., Skilled in designing architecture and structures for various EDW and Data Vault projects., Extensive hands-on experience with relational models, data warehouses, data marts, Data Vault 2.0, and analytical solutions., Proficient in end-to-end BI solutions using Azure Data Factory, SQL DB, MSBI Stack, Power BI, Erwin, and AWS Cloud (S3, Redshift, PostgreSQL)., Adept at implementing row-level and object-level security models, ensuring data integrity and quality through governance processes., Strong knowledge of Agile Scrum, Kanban, and Waterfall methodologies, with experience in CI/CD project approaches., Proficient with GIT, Team Foundation Server, JIRA, Confluence, and SharePoint., Effective in managing stakeholders, mentoring teams, and collaborating across varied industries including Superannuation, Retail, Banking, Finance, Insurance, Healthcare, and HR.

Work Right

Australian Citizen, Active Baseline Clearance

Personal Information

  • Total Experience: Seasoned professional with 20+ years of experience in data-driven consulting, specializing in data analysis, migration, modelling, and enterprise data warehouse (EDW) solutions.
  • Title: Data Architect

Timeline

Data Architect

Scyne Advisory
07.2024 - 04.2025

Data Migration & MDM Specialist

Cleanaway
06.2023 - 06.2024

Senior Technical Lead

Australian Unity
04.2021 - 06.2023

Data Migration Lead

MACS
06.2017 - 04.2021

Senior Consultant

DXC Technology
09.2016 - 06.2017

Senior Business Intelligence Analyst (Migration)

Lumo energy
03.2015 - 09.2016

Microsoft BI Consultant

Oakton Consulting
07.2013 - 02.2015

Senior Technical Consultant

Aditi Technologies
01.2011 - 05.2013

Associate Consultant

UST Global
01.2010 - 12.2010

Technology Solution Specialist

Infosys Technologies Ltd
04.2006 - 12.2009

System Admin

Kilmist Infotech
08.2004 - 04.2006

Master of Science - computer science

Bharathidasan University

Similar Profiles

CREATE PROFILE
Sathyanath Gopinathan