Responsibilities• Data architecture: Design and delivery on Delta lake model, Azure API Keys, GIT Hub Action Deploy, Microservices architecture on AWS Lambda and GIT Hub • Environment: Azure, AWS, Snowflake cloud, Data Platform Cloud, Databricks • Migration: Decommissioning from legacy data lake system platform to Snowflake • Normalization: Snowflake schema and data vault, historical tracking architectures and developments • Methodology and tools: Scrum, Mural, Trello, DevOps, Prototype, MS Teams and Agile approaches• BI Tools: DBT, Informatica, StreamSets, VS Code, Python, DBT, Grafana, API, GraphQL, Data Lake and SAP BO, Power Platform – Power BI, Power Automate, Power App, Synapse, Data Factory and SQL DW Azure• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, recommending, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications on Azure and AWS, maintenance activities, Power Point presentations and project managementClients and Projects • Power Health: Azure, Power Platform, Dataverse, Power BI and Data Factory• V8 Performance: Azure IOT, Databricks, ODBII, C#, Power Platform, Power BI Streaming • Stock Funds – : Azure, Python, Azure Synapse, Power BI Streaming • Legal Aid - Form Automation: Azure Architecture, Power App, Power Automate, Power BI, SQL Azure• Woodside - SSUD Decomm Migration: AWS S3, SnowFlake, DBT Pipeline, StreamSets API, Python • Woodside - Competency HR Integration: AWS S3, SnowFlake, DBT Pipeline, StreamSets API, Python• AFG - Data migration: Informatica, DBT, Oracle Analytics, Snowflake, Fivetran• Fortescue - Asset HME Rail IOT Sensors - SSOT: Snowflake, Pipeline Task Orchestration, Kimball, Vertabello• Fortescue - Asset HME Rail IOT Sensors - DA: Snowflake Dashboards, Notebooks, Streamlit, Power BI, DAX

• Data architecture: Design and delivery on Snowflake Delta lake model, Azure and GIT Hub Action • Environment: Azure, Snowflake cloud and Oracle DW • Migration: Oracle DW to Snowflake and Informatica 10 to DBT • Normalization: Snowflake schema, historical tracking architectures and developments • Methodology and tools: Scrum, Miro, Trello, Git, MS Teams and Waterfall approaches• BI Tools: DBT cloud and code, Informatica, FiveTran, VS Code, Python, Power BI and Oracle Analytics • Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, recommending, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications on Azure and AWS, maintenance activities, Power Point presentations and project management• AFG – Informatica ELT/ELT migration to DBT: Informatica 10, DBT, Snowflake, FiveTran, Power BI• AFG – Oracle DW migration to Snowflake: Oracle DW Reports, Snowflake, Fivetran, Informatica, DBT

• Data architecture: Design and delivery on Snowflake Delta lake model, Azure API Keys, GIT Hub Action Deploy, Microservices architecture on AWS Lambda and GIT Hub • Environment: Azure, AWS, Snowflake cloud, • Migration: Decommissioning from legacy data lake system platform to Snowflake • Normalization: Snowflake schema and data vault, historical tracking architectures and developments • Methodology and tools: Scrum, Mural, Trello, DevOps, Prototype, MS Teams and Agile approaches• BI Tools: StreamSets, VS Code, Python, DBT, Grafana, ArcGIS (Spacial Data – ERSI)=., API, GraphQL, Data Lake and SAP BO• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, recommending, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications on Azure and AWS, maintenance activities, Power Point presentations and project managementProjects • AWS Data Lake migration: AWS, SnowFlake, ArcGIS, DBT core, StreamSets API, Python • Competency HR Integration: AWS S3, SnowFlake, DBT Pipeline, StreamSets API, Python, SAP BO

• Data architecture: Design and delivery on Power App on Azure Data Platform cloud• Environment: Azure and Data Platform Cloud• Methodology and tools: Scrum, Trello, DevOps, Prototype, MS Teams and Agile approaches• BI Tools: Power Platform – Power BI, Power Automate, Power App, SQL DW Azure• Data architecture/model: Data warehouse in Power Architect for Power App• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications on Azure Data Platform, maintenance activities, Power Point presentations and project managementClients and Projects • Legal Aid - Form Automation Workflow: Power App, Power Automate, Power BI, SQL Azure

Responsibilities • Data architecture: Design and delivery on Hybrid, On-Premise DW, Azure Data Platform and AWS Cloud, Microservices architecture on AWS Lambda and Azure Functions• Environment: SQL Server 2019 On-Premise, Redshift, Snowflake, Azure and AWS Cloud • Normalization: Kimball methodology for Data warehouse dimensional architectures and developments • Data Modeling and Design: Logical and Physical OLTP, Data Warehouse Star Schema dimensional models• Methodology and tools: Scrum, MS Planner, DevOps, Balsamic Prototype, Bitbucket, MS Teams and Agile approaches• BI Tools: SAC SAP Analytics Cloud, Power BI Report Services (SSRS), ETL in Integration Services (SSIS), Anaconda Python and Cloud Azure MS Stack, MS BI Platform• Data Automation: AWS CloudFormation, Power BI DataFlow, AWS Data Fabric• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications on Azure and AWS, maintenance activities, Power Point presentations and project managementClients and Projects • Stellar Consulting: SAC Integration - SAP analytics cloud dashboard, API integration with Binokula • AA Insurance: NZ AWS Implementation – BI Architecture implementation for AWS Cloud in NZ • Wairarapa Moana: Finance and Performance Dashboards - Power BI Data Flow in Data ServerLess• Nano Layr: Production Dashboards - Power BI Data Flow, Salesforce in Data ServerLess• Fonterra: Data Discovery - Power BI with fuzzy data matches and data mining • Toyota NZ: Lexus Finance – DW, SSAS tabular model, SSIS ETL, Power BI Report Services • Toyota NZ: Snap AI – Anaconda, Python, Machine Learning, Predictive Model, Azure VM, Power BI• Toyota NZ: TNZ Accessories – DW, SSAS tabular model, SSIS ETL, Data Quality, Governance

Responsibilities • Data architecture: Design and delivery On-Premise and Azure Cloud Data Hub, Microservices architecture on Rest API Salesforce• Migration: SAP BO and Salesforce report migration to Tableau• Environment: SQL Server 2016 On-Premise and Azure Datahub Cloud Lab• Normalization: Kimball methodology for Data warehouse dimensional architectures and developments • Data Modeling and Design: Logical and Physical OLTP, Data Warehouse Star Schema dimensional models• Methodology and tools: Scrum, MS Planner, Balsamic Prototype, Bitbucket, MS Teams and Agile approaches• BI Tools: Tableau, Report Services (SSRS), ETL in Integration Services (SSIS), Python and Cloud Azure MS Stack, MS BI Platform, Power Apps (concept), Data Automate, SharePoint• Data Automation: Data Automate, Zappysys, Salesforce API DB AMP, Google Analytics, SAP ECC, Oversee and PureCloud API• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications On-Premise and Azure Cloud, maintenance activities, Power Point presentations and project managementProjects • Mobile Geomap API: DW, SSIS Zappysys API, data loading and visualization in Tableau• PureCloud Dashboards: DW, SSIS data loading and visualization in Tableau• Digital Apps Dashboards: DW, SSIS data loading and visualization in Tableau and Power BI• Salesforce Data Automations: DB Amp API, SSIS data loading and controls• TRA Service Centre Data Automations: Zappysys, DB Amp API, SFTP, Email and SSIS data loading • Project Management: MS Teams, SharePoint, SSIS, Tableau dashboards• Retail Data Analysis: DW, Python, SSIS data loading and controls in Salesforce• SAP Retail Finance Data Analysis: SAP ECC integration with BO, BEX Query C# • Azure Data Hub Solution: Purview, Data Synapse, SQL Server Less, Data Lake

Responsibilities • Data architecture: Design and delivery On-Premise and Azure Cloud DW• Environment: SQL Server 2016 Always On, 2017 and 2019 On-Premise and Azure Cloud• Normalization: Kimball methodology for Data warehouse dimensional architectures and developments • Data Modeling and Design: Logical and Physical OLTP, Data Warehouse Star Schema dimensional models• Methodology and tools: Scrum, Trello workflow, DevOps, TFS, Slack and Agile approaches• BI Tools: Power BI, Report Services (SSRS) and ETL in Integration Services (SSIS)• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications on Hybrid, On-Premise and Azure Cloud, maintenance activities, Power Point presentations and project managementProjects • Global BCS BI Portal: Power BI Embedded, Azure DW, Data Lake, Data Factory and Real-Time Dashboards• Planning Tool: Data analysis, ETL and Reports for predictive airport overloads planning in SSRS and Power BI

Responsibilities • Data architecture: Design and delivery On-Premise Cluster DW and Azure Data Platform Cloud• Environment: SQL Server 2012, 2014, 2016, 2017 in Enterprise Cluster high availability, Logshipping and Always On;• Normalization: Kimball methodology for Data warehouse dimensional architectures and developments • Data Modeling and Design: Logical and Physical OLTP, Data Warehouse Star Schema dimensional models• Methodology and tools: Scrum, Trello workflow, TFS, Jira, Slack, Confluence documentation and Agile approaches• BI Tools: Tableau, real-time Power BI, Report Services (SSRS), Report Mobile, ETL in Integration Services (SSIS), C# and Python, Machine Learning in R Studio and with SQL 2017• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications On-Premise SQL Cluster, Microsoft Dynamics CRM and Navision applications, maintenance activities, Power Point presentations and project managementProjects • Dashboard Performance Monitoring: Real-time in Power BI using Rest-API, Mobile App, C# and Json• Dashboard Sales Commission: Tableau Gauge, KPI’s, Scored Card, Charts and Reports • Elastic Search Concept: ETL in Python, Rest API, SQL CLR and Java Script jQuery• Prediction Sales Price: C# Machine learning and T-SQL in R • ETL - DW Loading: in Python for Call Centre loading• Database Architecture Migration – SQL Cluster High Availability Enterprise Architecture

Responsibilities • Data architecture: Design and delivery On-Premise, AWS Cloud DW, Shiny Server in R Studio in Linux Ubuntu and Google Data analytics• Environment: SQL Server 2005, 2008, 2012, 2014 Always On and Oracle 10G in On-Premises and AWS Cloud• Normalization: Kimball methodology for Data warehouse dimensional architectures and developments • Data Modeling and Design: Logical and Physical OLTP, Data Warehouse Star Schema dimensional models• Methodology and tools: Scrum, Trello workflow, TFS, Agile approaches• BI Tools: Power BI, Power Pivot Table, Report Services (SSRS), Analysis Service (SSAS) and Integration Services (SSIS)• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications on Hybrid, On-Premise and AWS Cloud, maintenance activities, Power Point presentations and project managementProjects • Marketing BI Portal: SharePoint BI Portal - Dynamic Reports, Charts, Dashboards, KPIs and Data mining• BI Project Concept: Shiny Server in R Studio in Linux Ubuntu and Google Data analytics• Big Data Concept Project: Big Data Cassandra and SQL Server Integration • Power BI Concept Project: Microsoft Power BI Dashboards and KPIs• Customer Churn: ETL development and data analysis working with marketing team

Responsibilities • Data architecture: Design and delivery On-Premise Cluster DW• Environment: SQL Server 2005, 2008, 2012 in Enterprise Cluster high availability and Oracle 10G, Oracle 11G• Normalization: QVDs QlikView methodology for data architectures and developments • Data Modeling and Design: Logical and Physical OLTP, QVDs data models• Methodology and tools: Change request, action plan and TFS• Security: Auditing, integrity of data and access administration• BI Tools: Report Services (SSRS) and QlikView 11• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications On-Premise, maintenance activities, Power Point presentations and project managementClients and Projects • Shell SA: Ethanol Production - Data analysis and insight in QlikView dashboards and QVDs ETL Models• HCor Hospital: Hospital Equity – Data analysis developed in SSRS and support for managers in QlikView

Responsibilities • Data architecture: Design and delivery On-Premise Cluster DW• Environment: SQL Server 2008, 2012 in Enterprise Cluster high availability• Infra: Datacenter, Windows and SAN Storage EMC, VMWare Cluster • Normalization: Kimball methodology for Data warehouse dimensional architectures and developments • Data Modeling and Design: Logical and Physical OLTP, Data Warehouse Star Schema dimensional models• Methodology and tools: Scrum, change request, action plan and TFS• Security: Auditing, integrity of data and access • BI Tools: ETL SQL in (SSIS) Integration Services, Report Services (SSRS) and Qlikview• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications on On-Premise, maintenance activities, Power Point presentations and project managementProjects • DW Implementation - Data Staging, Data Mart (DM) and Data Warehouse (DW), Qlikview, MS ETL SSIS and SSRS• Data Architecture - Data migration to SQL Enterprise cluster in high availability and big data • Population Diseases - Data design, visualization and analysis for screening team in SSIS, SSRS and QlikView

Responsibilities • Data architecture: Design and delivery On-Premise Cluster • Environment: SQL Server 2005 in Enterprise Cluster high availability• Normalization: Kimball methodology for Data warehouse dimensional architectures and developments • Methodology and tools: Change request, action plan and TFS • Security: Auditing, integrity of data and access administration• Administration: upgrades and migrations, security, troubleshoot and administer databases, capacity planning and documentation• Support: database schema design, activities to advise staff with relevant technical help, assigned projects, applications, incidents, problems, changes and releases• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications on On-Premise, maintenance activities, Power Point presentations and project managementProjects • Data Architecture Performance Enhancement - Tuning and high performance for OLTP environments• ERP Migration and Integration - Database Model Architecture and Design for a newEnterprise Resource Planning system

- Environment: SQL Server 2000, 2005 in Enterprise Cluster high availability and Oracle 9i - Normalization: Kimball methodology for Data warehouse dimensional architectures and developments - Data Modeling and Design: Logical and Physical OLTP, Data Warehouse Star Schema dimensional models- Methodology: Scrum, change request, Share Point, action plan, TFS and HP ITIL system workflow- Security: Auditing, integrity of data and access administration- BI Tools: ETL SQL SSIS and Cognos Business Intelligence- Leader: Planning, coordinating and managing the lifecycle execution of database projects and applications, maintenance activities, Power Point presentations and project administrations

Responsibilities • Data architecture: Design and delivery On-Premise Cluster High Performance• Environment: SQL Server 7.0, 2000 and 2005 in Enterprise Cluster high availability and Oracle 9i• Infra: Windows Linux, Solaris e SAN Storage EMC• Normalization: Kimball methodology for Data warehouse dimensional architectures and developments • Data Modeling and Design: Logical and Physical OLTP, Data Warehouse Star Schema dimensional models• Methodology and tools: ITIL, change request, action plans and TFS• Security: Auditing, integrity of data and access administration • BI Tools: ETL SQL DTS, Analysis Services (SSAS) - OLAP with VBA Advanced Excel Pivot Table• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications on On-Premise, maintenance activities, Power Point presentations and project managementProjects • Database Architect - Database design and high available architectures for critical operational and archive environments • Server Monitoring - Automatic check-list in ASP, WebDev, JS, design and development • Fraud Operation Audits: Data analysis to identify gaps and frauds for bank operations in SSAS

Responsibilities • Data architecture: Design and delivery On-Premise DW Cluster High Performance and Availability• Environment: SQL Server 7, 2000 in Enterprise Cluster high availability and Oracle 9i• Infra: Metaframe, Windows and SAN Storage DELL in high availability architectures• Normalization: Kimball methodology for Data warehouse dimensional architectures and developments • Data Modeling and Design: Logical and Physical OLTP, Data Warehouse Star Schema dimensional models• Methodology and tools: ITIL, change request and action plans and TFS• BI Tools: ETL SQL DTS, Analysis Services (SSAS) - OLAP with VBA Advanced Excel Pivot Table• Development: ETL in SQL DTS, T-SQL, Crystal Reports, VBScript Advanced Excel, MDX in SSAS Multidimensional OLAP• Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications on On-Premise, maintenance activities, Power Point presentations and project managementProjects • Database Architect - Database design and high available architectures for critical operational environments • DW Loading - Design, architecture and development of ETL in SQL DTS from OLTP to Data Warehouse and Data Marts• Sales Performance - Data mining, visualization and analysis in SSAS OLAP and Crystal Reports developments

Responsibilities • Data architecture: Design and delivery On-Premise Centralized Repository • Environment: SQL Server 6.5, 7 and 2000 Enterprise and Oracle 8• Normalization: Kimball methodology for Data warehouse dimensional architectures and developments• Data Modeling and Design: Logical and Physical OLTP, Data Warehouse Star Schema dimensional models• Methodology and tools: ITIL, change request and action plans• BI Tools: Data analysis in Folio Views, Crystal Report and Business Objects Intelligence• Development: ETL in SQL DTS, CGI Perl, ASP, ASP.Net, VB6, JavaScript, PL SQL and TSQL, • Crystal Reports and Business Objects • Leader: Provisioning of advice on suitable architecture of business solutions, designing, integrating, guiding, planning, coordinating, reviewing, documenting and managing the lifecycle execution of database projects and applications on On-Premise, maintenance activities, Power Point presentations and project management Projects • Global BI Portal - Data architecture, design and analysis, SQL DTS, JS, ASP.Net and CGI Perl development• HR People Management - System Analysis and development in VB6, T-SQL and JS• Tribunal and Justice document Archiving - System Analysis and Software Development in VB6• DW Data Modeling - Data architecture design and migration from Folio to MS SQL Data Warehouse• New Business - Data mining, visualization and analysis in Business Objects, Crystal Report and Folio Views development

- Novel Network administration- Technical support for systems- Technical infrastructure in hardware- License governance and storage

- Technical system support - System tester and reporting- Analysis and technical functional requirements- Implementation, training and support- Troubleshoot analysis