Summary
Overview
Work History
Education
Skills
Timeline
Generic

Nikhila Reddy

Redmond,WA

Summary

AWS Data Engineer with 3 years of comprehensive experience in designing, building, and maintaining robust data infrastructures using Amazon Web Services. Demonstrated expertise in creating scalable ETL pipelines, data lakes, and data warehousing solutions that support complex data analytics and machine learning initiatives. Proficient in leveraging AWS services such as S3, Redshift, Glue, Lambda, and EMR to develop end-to-end data solutions that optimize performance and minimize costs. Involved in multiple full-lifecycle projects, from gathering requirements to deploying and monitoring production systems. Skilled in integrating diverse data sources, ensuring data integrity, and automating data workflows using Python, SQL, and Spark. Adept at implementing best practices in data security, governance, and compliance, including data encryption and IAM role management. Collaborates effectively with data scientists, analysts, and other stakeholders to translate business needs into technical requirements, resulting in actionable insights and improved decision-making. Possesses strong problem-solving skills, with a track record of identifying bottlenecks and optimizing data pipelines for efficiency and reliability. Committed to continuous learning and staying updated with the latest trends in cloud computing and big data technologies. Recognized for delivering high-quality solutions within tight deadlines and driving innovation in data engineering processes.

Overview

4
4
years of professional experience

Work History

AWS Data Engineer

CVS
Dallas, TX
01.2023 - Current
  • Developed and maintained scalable ETL pipelines using AWS Glue and Lambda to process and transform large datasets from various internal systems, ensuring timely data availability for business intelligence and operational reporting
  • Automated data ingestion from CVS's pharmacy and retail systems into Amazon S3 and Redshift, enabling real-time analytics and improving decision-making processes
  • Architected and optimized CVS's data warehouses using Amazon Redshift, focusing on efficient storage and retrieval of structured healthcare and retail data
  • Implemented data partitioning, distribution, and compression strategies to enhance query performance, reduce storage costs, and improve reporting speed
  • Integrated diverse data sources, including pharmacy transactions, patient records, and retail sales data, using AWS Glue and Data Pipeline for data cleansing and transformation, supporting CVS's analytics and reporting needs
  • Developed and executed complex data processing jobs in Apache Spark on AWS EMR to handle large-scale transformations, ensuring data quality and consistency across the organization
  • Led the implementation of a data lake on Amazon S3, consolidating CVS's raw and processed data into a centralized repository, enabling advanced analytics and machine learning use cases
  • Configured AWS Lake Formation to enforce data governance and access control policies, ensuring compliance with HIPAA and other regulatory requirements
  • Tuned ETL jobs and optimized SQL queries in Redshift, resulting in a 30% improvement in processing times for critical business reports
  • Implemented caching strategies with Amazon ElastiCache, reducing data retrieval times for frequently accessed datasets, and improving the performance of customer-facing applications
  • Enhanced data security by implementing encryption at rest and in transit, managing IAM roles, and configuring secure VPCs for data transfer between AWS services, ensuring compliance with CVS's stringent security standards
  • Monitored and audited data access using AWS CloudTrail and Config, ensuring that data usage met regulatory requirements and internal security policies
  • Established monitoring and alerting using Amazon CloudWatch, proactively identifying and resolving data pipeline issues, minimizing downtime and ensuring consistent data flow
  • Automated the deployment and management of AWS resources using CloudFormation, ensuring a reliable and scalable infrastructure for CVS's data engineering needs
  • Worked closely with data scientists, analysts, and business stakeholders to translate CVS's healthcare and retail data needs into technical requirements, delivering high-quality data solutions that supported key business initiatives
  • Identified opportunities for process automation and efficiency improvements, leading to a significant reduction in data processing time and operational costs
  • Actively participated in continuous learning and adoption of new AWS services and big data technologies, contributing to the innovation and enhancement of CVS's data engineering capabilities.

Data Engineer

Subaru
New jersey, NY
08.2021 - 11.2022
  • Assisted in the design, development, and maintenance of ETL pipelines to process and integrate data from various automotive systems and third-party sources into Subaru’s data warehouses
  • Collaborated with senior engineers to implement data ingestion processes using tools like Apache Airflow, AWS Glue, and Python scripts, ensuring data was processed efficiently and accurately
  • Participated in data cleansing and transformation efforts to ensure the quality and consistency of vehicle performance, sales, and customer data
  • Utilized SQL and Python to clean, normalize, and transform data for use in analytics and reporting, supporting Subaru’s business intelligence efforts
  • Assisted in the maintenance and optimization of data warehouses, ensuring that data was properly stored, indexed, and accessible for reporting and analysis
  • Supported data modeling efforts by helping design and implement star schemas and snowflake schemas based on business requirements
  • Monitored data pipelines and performed regular data quality checks to ensure data accuracy and completeness, quickly identifying and resolving any discrepancies
  • Worked with cross-functional teams to address data quality issues and implement improvements in data processing workflows
  • Collaborated with data scientists, analysts, and other stakeholders to understand data requirements and provide support in accessing and interpreting data
  • Documented data engineering processes, pipeline workflows, and data models to facilitate team collaboration and future maintenance
  • Engaged in continuous learning to stay updated on the latest data engineering tools and techniques, contributing to the team’s overall efficiency and innovation
  • Assisted in evaluating new data tools and technologies, providing feedback and insights to senior engineers on potential integrations
  • Provided support in the creation and maintenance of dashboards and reports, ensuring accurate and timely data delivery for Subaru’s business decision-making processes
  • Assisted in the automation of routine data tasks, improving the efficiency of data operations and reducing manual intervention.

Data Engineer (Internship)

Tek Systems
San Francisco, CA
06.2021 - 08.2021
  • Assisted in developing and maintaining ETL pipelines, writing Python scripts and SQL queries to process and integrate data
  • Participated in data cleaning and transformation, ensuring the accuracy and consistency of datasets
  • Supported data warehouse operations by optimizing database schemas and performing basic performance tuning
  • Monitored data pipelines and addressed issues to maintain data integrity and workflow efficiency
  • Collaborated with team members on data-driven projects and documented processes for future reference.

IT Intern

Costco Wholesale
Issaquah, WA
01.2021 - 04.2021
  • Our hardware support team delivers technical services to all Costco warehouses, depots, and business delivery locations across the US and Canada
  • On a typical day, the service desk escalates tickets to our team, which we resolve using knowledge-based articles
  • Experienced in providing technical support via phone and email
  • Skilled in assisting vendors, installers, and end users
  • Handled tickets related to iPads, Chromebooks, membership card printers, and thermal label printers
  • Proficient in installing POS software and hardware
  • Provided on-call support after hours for warehouses and gas stations
  • Assisted in conducting root cause analysis for reported issues
  • Troubleshot issues using tools like AirWatch and Carts+
  • Identified, tracked, and resolved support and deployment issues within the required service level agreement
  • Ensured that POS systems were always operational
  • Managed orders for iPads, Chromebooks, and thermal label printers in case of physical damage
  • Experienced in updating and tracking data such as system uptime, device status, exceptions, and turnover reports
  • Ensured all assigned tickets were resolved and updated in Carts+.

Education

Master of Science - Embedded Software Engineering

12.2020

Bachelor of Technology - Electronics and Communication Engineering

05.2018

Skills

  • AWS
  • Data Engineering
  • Data Science
  • Big Data Analytics
  • Database Systems
  • Python
  • SQL
  • Spark
  • ETL Operations
  • Data Migration
  • Data Modeling
  • Data Cleaning
  • Advanced Analytics
  • RDBMS
  • NoSQL
  • Machine Learning
  • Software Development Life Cycle (SDLC)
  • Requirement Gathering
  • Testing
  • Debugging
  • Documentation
  • Production Support
  • Cloud Technologies
  • AWS Glue
  • AWS Data Lake Storage
  • IAM
  • Dynamo DB
  • Quick Sight
  • AWS Lambda
  • EC2
  • EMR
  • S3
  • SNS
  • Kinesis
  • Redshift
  • RDS
  • ETL Processes
  • Big Data Solutions
  • Apache Spark
  • AWS EMR
  • Hadoop
  • HDFS
  • Kafka
  • Hive
  • Airflow
  • HBase
  • Data Analytics
  • Data Visualization
  • Tableau
  • App Insights
  • Power BI
  • Terraform
  • Big Data Technologies
  • Databases
  • IDE's
  • Version Control Tools

Timeline

AWS Data Engineer

CVS
01.2023 - Current

Data Engineer

Subaru
08.2021 - 11.2022

Data Engineer (Internship)

Tek Systems
06.2021 - 08.2021

IT Intern

Costco Wholesale
01.2021 - 04.2021

Master of Science - Embedded Software Engineering

Bachelor of Technology - Electronics and Communication Engineering

Similar Profiles

CREATE PROFILE
Nikhila Reddy