Sai Pranay Chitneni
Dallas,TX
Summary
Detail-oriented data engineer with 7+ years of experience designing and implementing scalable data solutions. Expertise in SQL and Python, complemented by a strong background in AWS services including Redshift, SNS, SQS, S3, Lambda, and Cloud Formation. Proven track record of building robust, serverless ETL pipelines, optimizing data warehousing solutions, and automating cloud-based infrastructures to support data-driven decision-making in fast-paced environments.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Data Engineer
Silicon Valley Bank
04.2022 - Current
- Designed and implemented a high-throughput data pipeline processing 10TB of transactional and financial data daily using Amazon EMR, reducing processing time by 30% and enabling faster insights for regulatory reporting.
- Enhanced data quality by refining ETL processes using Python and AWS Glue, reducing data inaccuracies by 15% and ensuring compliance with financial regulations.
- Initiated a data governance strategy using AWS Lake Formation, enhancing data security, compliance, and audit readiness for sensitive financial information.
- Introduced automation in cloud infrastructure management using AWS CloudFormation, saving operational costs by 20% and streamlining deployment processes for financial applications.
Data Engineer
Cloudreach
06.2021 - 03.2022
- Designed and implemented scalable Python based data pipelines using AWS Glue and Apache Airflow to process and transform insurance claims data, reducing processing time by 30%.
- Partnered with business analysts to develop Tableau dashboards and QuickSight reports for real-time insights into policyholder behavior and claims trends.
- Designed and optimized complex SQL queries to extract, transform, and analyze large datasets from AWS Redshift, PostgreSQL, and MySQL databases.
Data Engineer
Northern Trust
06.2020 - 06.2021
- Designed and implemented complex data pipelines using Python for processing financial transactions.
- Developed and maintained distributed computing solutions using PySpark for large-scale risk analytics.
- Using Spark, performed various transformations and actions and the final result data is saved back to HDFS from there 1 target database Snowflake.
- Used AWS services like EC2 and S3 for small data sets processing storage, Experienced in Maintaining the Hadoop cluster on AWS EMR.
Data Engineer
Caterpillar Inc
10.2019 - 06.2020
- Implemented data partitioning on Big data using Azure Databricks, decreasing processing time by 50% for CAT Digital Assets.
- Developed and deployed Big data solutions with Azure HDInsight, improving data processing capacity by 200%.
- Used Azure Synapse Analytics for real-time Big data analytics, reducing the time to insight by 30%.
Data Engineer
Wipro Ltd – India
06.2015 - 07.2017
- Developed and maintained Python scripts for data cleansing and transformation, improving data quality by 40% and reducing manual data processing time by 20 hours per week.
- Implemented automated monitoring and alerting systems using CloudWatch for critical healthcare data workflow.
- Developed in writing Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on SQL and PostgreSQL database.
Education
Masters - Computer Science
University of South Alabama
Mobile, AL05-2019
Bachelors - Computer Science
JNTUH University
Karimnagar, India05-2015
Skills
- Python
- AWS Services
- Azure
- SQL
- PowerBI
- Docker
- GIT
- ETL development
Certification
- Microsoft Certified: Azure Data Scientist Associate, https://www.credly.com/badges/e8fd8eb7-151a-4a0f-8b4e-bb8a2beb5fbc
- MTA: Introduction to Programming Using Python - Certified, 2020, https://www.youracclaim.com/badges/7f44d2de-30b3-4fb0-994a-7c54ec52c028
- AWS Certified Solutions Architect – Associate, https://www.youracclaim.com/badges/50736437-7621-4907-bb4b-3f5c27be1b53
Timeline
Data Engineer
Silicon Valley Bank
04.2022 - Current
Data Engineer
Cloudreach
06.2021 - 03.2022
Data Engineer
Northern Trust
06.2020 - 06.2021
Data Engineer
Caterpillar Inc
10.2019 - 06.2020
Data Engineer
Wipro Ltd – India
06.2015 - 07.2017
- Microsoft Certified: Azure Data Scientist Associate, https://www.credly.com/badges/e8fd8eb7-151a-4a0f-8b4e-bb8a2beb5fbc
- MTA: Introduction to Programming Using Python - Certified, 2020, https://www.youracclaim.com/badges/7f44d2de-30b3-4fb0-994a-7c54ec52c028
- AWS Certified Solutions Architect – Associate, https://www.youracclaim.com/badges/50736437-7621-4907-bb4b-3f5c27be1b53
Masters - Computer Science
University of South Alabama
Bachelors - Computer Science
JNTUH University
Similar Profiles
Johnny CalderonJohnny Calderon
Manager, Operations at Silicon Valley Bank (now a division of First Citizens Bank)Manager, Operations at Silicon Valley Bank (now a division of First Citizens Bank)
Tommaso ManzoTommaso Manzo
Manager/ Supervisor - Mortgage Operations at Silicon Valley Bank- Div. Of First Citizens BankManager/ Supervisor - Mortgage Operations at Silicon Valley Bank- Div. Of First Citizens Bank
Minal MehtaMinal Mehta
Development Lead at Silicon Valley BankDevelopment Lead at Silicon Valley Bank