Summary
Overview
Work History
Education
Skills
Websites
References
Personal Information
Timeline
Generic
Gaurav Kumar

Gaurav Kumar

Melbourne,Australia

Summary

Test Lead and Senior Analyst Engineer specializing in AWS cloud solutions and data integration. Demonstrated success in executing ETL projects that enhance client relationships and lead diverse teams. Skilled in designing robust data architectures and implementing quality assurance processes, driving continuous improvement for superior outcomes.

Overview

10
10
years of professional experience

Work History

Test Lead, Senior Analyst Engineer

National Australia Bank
Melbourne, VIC
11.2024 - Current
  • Working as a Test Delivery Lead on the Databricks platform in ADA Gold Serve layers for data ingestion, processing, and extract generation for various business requirements.
  • Design review, data architectures, ETL processes, and data pipelines, along with delivering solutions for data warehousing, analytics, and BI.
  • Engaged with clients to understand business problems, and develop data-driven solutions.
  • Present technical handover solutions to executive stakeholders.
  • Work as a team lead, providing subject matter expertise in data warehousing, reporting systems, data ingestion, data integration, and cloud engineering.

Test Lead, Senior Analyst Engineer

National Australia Bank
Melbourne, VIC
06.2023 - 10.2024
  • Worked as a Team Lead in an ETL project using AWS S3, Redshift, Glue, Spectrum, Informatica, Airflow, and Python in a customer-facing application integrated within the NAB mobile banking application, impacting approximately 9 million customers.
  • Participate in functional requirement gathering, which involves a review of existing system configuration and operating methodologies, as well as understanding evolving business needs.
  • Technical support during acceptance testing, responsible for all requirement and development checks in the projects, and other technical document preparation.
  • Provide value additions to the application through continuous improvement initiatives, such as perfective, preventive, and adaptive activities.
  • Develop an end-to-end application for ETL projects by applying data transformation logic using the industry's standard coding practices in Informatica PowerCenter.
  • Managed a team of eight employees based in various geographical locations.

Senior Data Engineer

Leaders IT
Melbourne, VIC
03.2021 - 05.2023
  • Worked as a Data Engineer for the client 'NAB' in the Data Lake project using Python, PySpark, AWS S3, Redshift, Glue, Spectrum, and Airflow for the Credit Risk Engine reporting application for various regions such as APRA, RBNZ, and EURO, and processed batch streaming data.
  • Requirement gathering, understanding the data pattern, and helping create the data model to cater to business requirements for APRA reporting.
  • Analyze the current state of the application and infrastructure, designing appropriate solutions, and working with teams to implement them.
  • Designed and implemented data architectures, ETL processes, and data pipelines, along with delivering solutions for data warehousing, analytics, and BI.
  • Build the pipeline for the ingestion and curation of source data into the data lake, and the logic of conformance and content zone layers for dimensional tables and report generation.

Data Engineer

Infosys Limited
Melbourne, VIC
03.2018 - 02.2021
  • Worked as a Data Engineer for the client, NAB, in an ETL project for structured and unstructured data extraction and migration to another vendor using CONNX and SQL Server.
  • Engaged with the client to understand the business requirements, translate them into technical solutions, and develop data-driven solutions.
  • Built a data extraction framework for the extraction of structured and unstructured data for terabytes of data, which consists of all customer data from the last 80 years.
  • Designed and implemented data architectures, ETL processes, and data pipelines.
  • Created an automated script for unstructured data validation and report generation for 100 GB of data.

DevOps Engineer

Infosys Limited
Sydney, VIC
08.2015 - 02.2018
  • Worked on 'The Lending Adviser and Workflow' and 'Live Online Lending Application' projects for the client, 'Westpac Bank,' to build the continuous integration and delivery pipeline.
  • Migrated the legacy codebase of IBM ClearCase to Microsoft Team Foundation Server.
  • Involved in configuring and building CI/CD using tools such as Jenkins, Team Foundation Server, Bitbucket, Jira, Chef, Ansible, and CA Release Automation.

Education

AWS Developer Associate -

Amazon Web Services
Melbourne, Australia
06.2018

Bachelor - Information Technology

Sikkim Manipal Institute of Technology
Sikkim, India
06.2014

Skills

  • AWS cloud solutions
  • ETL processes and data integration
  • Data extraction and processing techniques
  • Data lake architecture and warehousing
  • Cloud engineering expertise
  • Database management systems including SQL server
  • DevOps methodologies and CI/CD workflows
  • Data pipeline construction and delivery management
  • Documentation skills for technical projects
  • Leadership in team development initiatives
  • Client relationship management strategies
  • Quality assurance in testing management
  • Source control using Git and Bitbucket
  • Agile project tracking with Jira
  • Handling unstructured data effectively

References

Available upon request

Personal Information

Gender: Male

Timeline

Test Lead, Senior Analyst Engineer

National Australia Bank
11.2024 - Current

Test Lead, Senior Analyst Engineer

National Australia Bank
06.2023 - 10.2024

Senior Data Engineer

Leaders IT
03.2021 - 05.2023

Data Engineer

Infosys Limited
03.2018 - 02.2021

DevOps Engineer

Infosys Limited
08.2015 - 02.2018

AWS Developer Associate -

Amazon Web Services

Bachelor - Information Technology

Sikkim Manipal Institute of Technology

Similar Profiles

CREATE PROFILE
Gaurav Kumar