Summary
Overview
Work History
Education
Skills
Technical Skills
Timeline
Generic

Sukrit Sharma

Melbourne,Australia

Summary

Accomplished Data Consultant with a passion for delivering valuable data driven solution through analytical functions and data retrieval methods with strong communication, and interpersonal skills, as well as a strong eye for detail. Over 5 years of experience in ETL, data manipulation, and integration operations on major cloud platforms like AWS GCP and Cloudera ecosystems. Data Visualisation Tools like Tableau and PowerBI. Successfully implemented Python-based automation tools to increase productivity and efficiency for over 50 clients across different sectors while managing their technical requirements.

Overview

7
7
years of professional experience

Work History

Senior Consultant (Data and Analytics)

Capgemini
06.2023 - 09.2023
  • Successfully orchestrated and tested Airflow patterns for Data Ingestion and Transformation for scheduling and monitoring automated job execution
  • Created and optimized custom scripts for data transformation and manipulation as per business requirements for reporting using Python and Jupyter notebook on AWS platform.
  • Collaborated with internal teams to develop customized solutions that addressed unique client needs.
  • Performed data migration from AWS RDS to Redshift using glue services and Redshift spectrum
  • Exposure to data modelling and data mapping on Databricks platform along with creating delta live tables.

Data Engineer

Tech Mahindra
03.2022 - 06.2023
  • Successfully implemented transformation and ingestion pipelines using processing technologies Spark and Scala and working on ingestion technologies like Sqoop
  • Implemented storage solutions for structured and unstructured data types using HDFS, HBase, and Hive with proficiency in data profiling, data mappings, ETL development, SQL optimisation and testing.
  • Experienced in building Spark SQL and Spark DataFrame API-based applications for Data transformation.
  • Effectively engineered database and middle-ware solutions as per client requirements and adept in solution architecture, design, and development/deployment
  • Exposure in developing big data analytics solutions for high-volume batch and (near) real-time processing data (Kafka)
  • Created transformed tables in GCP using BigQuery as per custom business requirements for reporting
  • Worked on Natural Language Processing to develop custom intent workflow in CX dialog-flow for Automated Voice Assistant
  • Built interactive Tableau dashboards to highlight KPIs and growth trends to enable data-driven decisions.

Data Consultant

ITANZ
07.2021 - 02.2022
  • Successfully configured data manipulation and integration tasks using SQL and Python to perform ETL operations on data from different sources into the Oracle DB and align it with the application while working closely with the Lead Solution Architect
  • Generate insightful analytical reports to aid performance improvement for the clients and provide commercially focused recommendations to support business decisions
  • Implementing and testing batch jobs using shell script to generate data feeds from data tables at regular intervals
  • Generating and Maintaining version-controlled documents and collaborating with Team Members using Confluence
  • Demonstrated advanced skills in writing and tuning SQL queries
  • Provided exceptional support to complete all reporting requirements within the Service Level Agreement using JIRA to achieve timely resolutions of issues and caveats faced by clients
  • Exhibited strong aptitude to investigate, analyze, debug and amend, and provide an alternative recommendation.

Associate Data Consultant

Ernst and Young
04.2016 - 02.2019
  • Implemented end-to-end parameterised ETL pipelines using AWS Redshift, S3, and Glue to ingest data in AWS Data Lake and scheduled them using Ozzy to optimise the workflow
  • Applied data transformations using Pyspark to produce quality data from various data sources to load in data lakes
  • Responsible for set-up, maintenance and ongoing development of continuous build/ integration infrastructure on cloud AWS based environment for improving solution delivery in a variety of large-scale projects
  • Facilitated workshops with stakeholder groups to gain consensus on priorities and approaches for tackling identified issues or opportunities.
  • Spearheaded the development and deployment of EY's E-GRC tools such as Risk and Control Assessment Manager, Controls Manager, Internal Audit Remediate, Compliance, and Litigation Manager based on Python, SQL that were implemented across 30+ organisations globally
  • Undertook business and solution analysis to assist clients to achieve proficiency in technology adoption and optimise their cost savings and operational efficiency by an estimated 40%
  • Developed data reports using Power-BI & MS-SQL that were extensively used by the audit committee for the data performance evaluation and risk analysis
  • Collaborated with cross-functional global teams to develop and deploy informative, compelling, and engaging dashboards using Tableau that enabled the business to visualize and track KPI.

Education

Masters Data Science -

Monash University
01.2021

Skills

  • Data Engineering
  • Data Warehousing
  • Data Modeling
  • Machine Learning
  • ETL
  • Data Analysis
  • Agile Scrum
  • Internal & External Stakeholder Management
  • Cloud Technologies
  • Business Process Improvement

Technical Skills

Github, Pycharm, Confluence, Bit-Bucket, Jira, Shell, Oracle SQL Developer, Visual studio, Teradata, SOAP-UI, Jenkins, MongoDB, IntelliJ, MS-SQL server, PowerBI, Tableau, Pyspark, Apache Spark, Scala, S3, EC2, Redshift, Hive, Impala, Oozie, Airflow, Athena, EMR, Glue, Lambda, Data lake, Azure, Quicksight

Timeline

Senior Consultant (Data and Analytics)

Capgemini
06.2023 - 09.2023

Data Engineer

Tech Mahindra
03.2022 - 06.2023

Data Consultant

ITANZ
07.2021 - 02.2022

Associate Data Consultant

Ernst and Young
04.2016 - 02.2019

Masters Data Science -

Monash University

Similar Profiles

CREATE PROFILE
Sukrit Sharma