 Data Modelling & Design – As a Data Modeller, a typical day involves design data assets such as data marts, data warehouse to feed for downstream consumption by exploring and analysing source systems and working with data providers to specify new data needs to support use-cases pertaining to Machine learning, Data Science, Reporting & Analytics Capability & Practice Development – Substantial involvement in setting up the data modelling practice, starting from scratch by way of consistently advocating for a need to have a set of tightly governed data modelling principles & standards and ensuring appropriate adherence to the same by the fellow designers and engineers Data Governance & Architecture – As a data architect, actively involved in formulating data Governance policies to ensure the below pillars of data management are appropriately supportedData AvailabilityData QualityData AssuranceData SecurityData Usability  Vendor Tool Evaluation & Selection – Being a member of the data architecture forum, significantly contributed towards evaluating a multitude of vendor tools to support the data modelling capability within the organisation and constantly been able to provide feedback, thereby ensuring continuous improvement  Product Ownership - Liaise with data users across the business to understand their data needs and are appropriately prioritised into the release pipeline Technical oversight - Work with data engineers to ensure effective deployment of the designs within a Continuous Improvement & deployment (CI/CD) model Agile Delivery management – Manage expectations with key business stakeholders and ensure on-time/on-budget delivery of agreed scope of work using Agile methodology of project delivery Tools & Technologies Involved – AWS Redshift, AWS Athena, Amazon S3, SQL, Apache Airflow, Python, Tableau, Databricks, Ellie (Data Modelling), JIRA and Confluence

 People Management – Managed a team of 4-5 data engineers deployed to handle the BAU aspects of the Business managed data layer (Risk Reporting Data Mart) and to perform in-house enhancements Regulatory & Compliance – Ensure compliance with Data Risk Management regulatory standards such as CPG-235, BCBS-239, General Data Privacy Regulation (GDPR) etc. Product Ownership - Active conduit between the business stakeholders and the BA/technology teams to ensure all business requirements are effectively implemented via a stable and cost-effective solution & Data design using the CI/CD model implemented using the Scaled Agile Framework (SAFe) Stakeholder Engagement & Management – Worked with senior business stakeholders (including the executive leadership & GMs) to understand the intended outcome from the project, manage expectations and resolve ambiguities in terms of translating technical concepts & jargons into simple business terms and thereby ensuring precise communication of the actual business impacts, Prepare and present periodic status reports to the steering committees  Business Data Ownership – Being the data owner designate for the bank’s credit risk data across the landscape, the role involves being accountable/responsible for ensuring the key aspects of data are implemented and maintained as listed by way of working with both the Group Technology Line of business, internal Credit Risk Business team as well as the reporting stakeholders belonging to the wider Westpac community Data Governance & Management – Periodic Review of the Data Governance policies and frameworks, from a business standpoint to ensure no lapse in implementation of the same both from a technology and business perspectives Critical Data Elements (CDEs) – Identify and assess the CDEs from a Data Risk standpoint to ensure accurate Financial Risk reporting that supports the bank to meet the obligations to Australian Prudential Regulatory Authority (APRA)

 Business Data Ownership – As a delegated data owner, had been the primary point of contact and the one responsible for the formulation and implementation of the Data Governance & Data Management policies that falls under the below categoriesData Quality & Assurance – Correctness & CompletenessData Availability – Disaster Recovery and adherence to SLAsData Privacy & Security – Compliance to CPG 235, BCBS239, GDPR etc. Product Ownership - Represent operational risk business in development of an Enterprise Data Warehouse capability for the Bank’s Operational Risk reporting platform (JUNO), thereby act as an interface between the business (Incl. Executive, GM level) stakeholders and technical teams Key programs Worked – Enterprise Operational Risk Reporting – Data transformation  BAU Operations Management - Ensure smooth execution of the daily & monthly data process that populates the Risk Agile Data Labs from the JUNO source system for automated and self-service analysis, discovery and reporting for 1st and 2nd Line operational risk and compliance teams Tools & Technologies Involved – Teradata 12.x on Microsoft Azure Cloud, SQL, Big Data Hadoop, SAS Studio, Power BI, Microsoft VBS, Erwin (Data Modelling), JIRA & Confluence Delivery Methodology – Continuous Integration & Continuous Development driven by the Scaled Agile Framework (SAFe)

 Technical Delivery Management Coordinate and own program level business case presentations and the associated cost estimations (Ball park, High level estimates and detailed estimates) Oversee and coordinate the various activities involved during Program execution from inception till Go-Live and warranty, adopting both Waterfall & Agile ways of working Stakeholder Engagement & Business Analysis  Liaise with the business users (Including Senior executive level stakeholders) to understand the high-level requirements and translate them into technical requirements and vice-versa Work with both technical and business stake holders to resolve any ambiguities with regards to requirements, solution principles and the associated cost implications Data Analysis & Discovery - Perform data analysis and discovery based on the above requirements and document the outcome of the same in the form of source to target mapping Solution Design & Data Modelling - Design & document the Conceptual, logical and physical data model across the three layers (Reflecting a Medallion architecture) of the bank’s Enterprise Data Warehouse (EDW)  People Leadership – Managed a small team of 5-6 developers and solution designers (Both On-shore and Off-shore teams) within a multi-vendor landscape both from an administrative and a mentorship standpoint Tools & Technologies Involved – Teradata 12.x on Microsoft Azure Cloud, SQL, Big Data Hadoop, SAS Studio, Informatica, Power BI, Microsoft VBS, Erwin (Data Modelling), JIRA & Confluence

 The job description is same as the one detailed above for the below listed aspects of the role.Business Analysis Data Analysis & DiscoverySolution Design & Data ModellingPeople Leadership Data Governance & Management - Have been a part of the bank’s data and solution kaizen that reviews and approves the design artefacts and take part in design workshops to understand and evaluate new design patterns Stakeholder Engagement & Management – Worked with senior business stakeholders (including the executive leadership) to understand the intended outcome from the project, manage expectations and resolve ambiguities in terms of translating technical concepts & jargons into simple business terms and thereby ensuring precise communication of the actual business impacts Pre-Sales & Sales - Actively worked on RFPs and represented the vendor organization during various proposal presentations Delivery Methodology – Waterfall & Agile ways of working Tools & Technologies Involved - Teradata 12.x, IBM Datastage, Hyperion Essbase, OBIEE, Erwin (Data Modelling)

Primary Client: Commonwealth Bank of Australia Sydney, Australia & Chennai, India People Leadership – Managed a team of 15+ developers, technical leads and solution designers (Both On-shore and Off-shore teams) distributed across multiple projects that were primarily executed from offshore delivery centres with minimal on-site presence from vendor organisation Scope of work Estimations – Authored and owned the documentation of the scope of work involved and the associated effort and cost estimations in an Onsite-offshore delivery model Project Execution – Effective execution of projects, ensuring on-time and on-budget delivery Revenue realization & Forecasting - Ensure the Monthly billing requests are made and obtained on time to be reported for the monthly accruals and prepare monthly resource projections based on the project needs Stakeholder Engagement & Management – Manage expectations, Prepare and present periodic status reports to the project steering committees, Head Of’s & other stakeholders including executive leaderships  Pre-Sales & Sales - Actively worked on RFPs and represented the vendor organization during various proposal presentations for a multitude of clients, not limited to the ones listed belowCommonwealth Bank of AustraliaANZ Bank, AustraliaLloyds Bank, United KingdomBoeing, United States of America

 Document low level technical design based on the stipulated high-level solution design specifications Guide the development team to ensure the build is in line with the low level design Perform reviews on the ETL/Reporting code and unit test results Perform hands-on development duties as required during the project life cycle Provide support during various testing phases of the project

• As a member of a Teradata Database Administration team, have managed database access permissions and data load and extraction priorities using TDQM and TASM• Worked on a massive data partitioning exercise in an initiative to improve database performance across board• Involved in various maintenance activities on the warehouse such as quarterly outages and periodic database hardware/software upgrades• Have been involved in designing the enterprise wide data back-up strategy using the Teradata BAR solution• Worked with development teams on a consulting capacity to identify potential performance issues and suggested remedial solutions accordingly

 Document low level technical design based on the stipulated high-level solution design specifications Guide the development team to ensure the build is in line with the low level design Perform reviews on the ETL/Reporting code and unit test results Perform hands-on development duties as required during the project life cycle Provide support during various testing phases of the project

 The job description is same as the one detailed as part of the above role with the below addition Responsible for managing the DBQL data migration from the system database to user-defined database

• Responsible for preparing test environments against which the test scenarios will be tested • Involved in writing test-cases for new Teradata 12 features • Involved in enhancing test scenarios to produce deterministic test results • Completely understand the functionality of the features to be tested and fixing bugs in the concerned test scripts to completely achieve the intent of the test cases