Shubham R.

Experience

• 

  Data Edge

  Apr 2018 - Mar 2022

  Data Analyst

  Deployed Agile methodology and actively participated in daily stand-up, showcase, and sprintretrospective meetings, resulting in 100% on-time project delivery.Constructed SQL and Python scripts for data reconciliation, achieving a 20% enhancement indata accuracyand reducing reconciliation time by 15%.Conducted Exploratory Data Analysis using pandas, NumPy,seaborn, SciPy, Matplotlib, andScikit-learn packagesin Python, uncovering valuable insights and patterns that led to a 25%boost in revenue.Executed ETL processes using Informatica mappings,ensuring seamless data integrationwithinthe Data Warehouseand reducing data integration errors by 30%.Created multiple data visualization solutions during the Power BI business previewphase,enhancing data representation and enabling stakeholders to make informed decisions, and40% increase in data visualization.Successfully worked with variousAWS services such as EC2, IAM, S3, Cloud Watch,Redshift,Glue, Athena,optimizing resource utilization and reducing infrastructure costs by 20%.Managed SQL Serverdatabases, maintaining data security and compliance with a 100% dataconfidentiality rate.Utilized advanced Excel functionsto generate spreadsheets and pivot tables forreportgeneration, reducing report generation time and improving data accuracy. Show less

• 

  Avita Solution

  Jan 2023 - now

  Data Engineer

  Developed python programs for Master Data management and Extract- Transform-Load(ETL), ELT pipelines using Python, PySpark, SQL on the Azure platforms like Databricks,Data Factory, Storage Explorer.Implemented software development life cycle (SDLC)methodologies (Agile, Waterfall) toenhance team productivity by 15%, achieved profound knowledge of data modeling,assessing data sources, and data warehousing.Conducted statistical analysisand modeling usingPython.Optimized data processing usingPython integrated development environments (IDEs)such as PyCharmand Visual StudioCode, along with data manipulation libraries likematplotlib, NumPy, and Pandas, reducing data cleaning time by 20%.Produced impactful data visualizations, reports,and schedules usingPowerBI, boostingdata visualization efficiency by 25%.Transferred data to Azure data lake and utilizedAzure synapse for data manipulation,yielding a 30% improvement in data processing speed.Led extract, transform, load (ETL) procedures with Azure Data Factoryand Azuresynapse,integrating diverse data sources into a centralized data warehouse andenhancing data availability by 40%.Applied data analysisskills, including extracting and mapping data from MySQL, toenhancedata accuracy and consistency by 15%.Developed machine learning modelssuch as Linear Regression, LogisticRegression,Random Forest,and K-Nearest Neighbors (KNN), achieving a 20% boost in predictiveaccuracy and optimizing decision-making processes Show less