Summary
Overview
Work History
Education
Skills
Certification
Training
Expertise
Timeline
Generic

Sai Vinooth Rachamalla

Summary

Highly motivated and results-driven Data Engineer with 4+ experience in designing and implementing scalable data solutions across various platforms. Proficient in leveraging cutting-edge technologies such as Hadoop, Spark, AWS, and Azure to deliver efficient data processing, analytics, and storage systems. Demonstrated expertise in developing robust ETL pipelines, optimizing data processing performance, and integrating diverse data sources while maintaining data integrity.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Data Engineer

Hasbro
Rhode Island, USA
09.2023 - Current
  • Developed and managed scalable data pipelines using Azure Data Factory and Databricks built and maintained CI/CD pipelines with Azure DevOps and Git for streamlined deployments
  • Automated data workflows, reducing manual processes
  • Improved data reliability through robust monitoring and alerting solutions using Azure Monitor
  • Collaborated with cross-functional teams to enhance data governance and compliance
  • Built a near-real-time data pipeline integrating Azure Event Hubs, Databricks, and Power BI for real-time insights
  • Effectively implemented and automated complex data workflows, incorporating job scheduling, monitoring, and error handling within the Azure Databricks environment

Data Analyst

Amazon
Hyderabad, India
04.2021 - 10.2021
  • Improving 90% of US address data sets by cleaning the unstructured data in MS Excel using Vlookups, Hlookups, and formulae, strings, and functions to make large datasets structured
  • Collaborated with cross-functional teams, including auditors, managers, and stakeholders, to provide data-driven insights in Slack teams
  • Performed quality analysis on over 50K US addresses using SQL, improving address standardized match rates from 88% to 95%
  • Work with stakeholders and engineers to improve LMAQ product data quality and analysis

Data Engineer

Magsway
Hyderabad, India
08.2019 - 10.2020
  • Reduced 25% of data inconsistencies and errors by cleaning and preparing the sales data with MS Excel
  • Leveraged Azure Data Factory (ADF) for ETL processes to extract, transform, and load sales data from multiple sources into a centralized data warehouse
  • Increased 12% of sales revenue by conducting sales data analysis using Python which led to identifying key insights and trends
  • Created dynamic and interactive sales dashboards in Power BI, enabling real-time monitoring of sales performance and KPIs for senior management

Data Analyst

Accenture
Hyderabad, India
11.2017 - 06.2019
  • Designed, developed, and implemented ETL processes using SSIS for data integration from various sources into SQL Server databases, ensuring data quality, performance, and error handling
  • Applied data modeling principles, incremental loading strategies, and performance tuning techniques, including buffer size optimization and parallel execution
  • Developed interactive reports using SSRS with complex calculations, drilldowns, and ad-hoc features while managing report deployments and security configurations
  • Worked closely with business stakeholders to gather requirements, design report layouts, and deliver visually appealing, high-quality reports

Education

Master’s - applied Statistics and Decision Analytics

WESTERN ILLINOIS UNIVERSITY
08.2023

Bachelor of Commerce - Computer Science

OSMANIA UNIVERSITY
05.2017

Skills

  • Python
  • SQL
  • NoSQL
  • Scala
  • Spark
  • Hive
  • Databricks
  • Hadoop
  • MapReduce
  • Amazon Redshift
  • Azure SQL Data Warehouse
  • Google BigQuery
  • Kafka
  • AWS Kinesis
  • Azure Data Lake
  • Amazon S3
  • MySQL
  • PostgreSQL
  • MongoDB
  • Oracle
  • SQL Server
  • AWS RDS
  • DynamoDB
  • GitHub
  • Docker
  • Kubernetes
  • JIRA
  • Trello
  • Bitbucket
  • Agile
  • Scrum

Certification

  • Dataops Platform Developer
  • Dataops Fundamental

Training

  • Accountancy
  • Business Statistics
  • Computer Programming
  • DBMS

Expertise

Python, SQL, NoSQL, Scala, Spark, Hive, Databricks, Hadoop, MapReduce, Amazon Redshift, Azure SQL Data Warehouse, Google BigQuery, Kafka, AWS Kinesis, Azure Data Lake, Amazon S3, MySQL, PostgreSQL, MongoDB, Oracle, SQL Server, AWS RDS, DynamoDB, GitHub, Docker, Kubernetes, JIRA, Trello, Bitbucket, Agile, Scrum

Timeline

Data Engineer

Hasbro
09.2023 - Current

Data Analyst

Amazon
04.2021 - 10.2021

Data Engineer

Magsway
08.2019 - 10.2020

Data Analyst

Accenture
11.2017 - 06.2019

Master’s - applied Statistics and Decision Analytics

WESTERN ILLINOIS UNIVERSITY

Bachelor of Commerce - Computer Science

OSMANIA UNIVERSITY
  • Dataops Platform Developer
  • Dataops Fundamental

Similar Profiles

CREATE PROFILE
Sai Vinooth Rachamalla