Sreedeep Uppalanchi

Data Engineer
Location: Chicago, IL
Email: [Link]@[Link]
Ph: (309)-205-1150 | LinkedIn : [Link] |

PROFESSIONAL SUMMARY:
 Experienced Data Engineer with around 4 years of software development experience, specializing in Python programming and
data engineering, proficient in Microsoft Excel for data analysis and reporting.
 Proficient in all stages of the Software Development Life Cycle (SDLC), including requirement analysis, implementation, and
timeline estimation.
 Results-oriented Data Engineer with a proven track record of leveraging Python programming and a wide array of data
processing and analysis tools, including Jira for project management, and expertise in Agile Methodology for iterative and
collaborative project execution.
 Proficient in utilizing project management tools such as JIRA for bug/issue tracking and project monitoring.
 Expert in problem-solving, leveraging algorithms, data structures, and optimization techniques to improve system
performance and efficiency.
 Proficient in designing and implementing end-to-end data pipelines, from data ingestion to visualization, utilizing
technologies such as Pandas, NumPy, Matplotlib, and TensorFlow, and incorporating Agile Methodology for project
management.
 Proficient in developing, integrating, and consuming APIs, including RESTful and SOAP APIs, ensuring seamless data exchange
and system interoperability.
 Extensive experience in relational database management, including database schema design, normalization, indexing, and
query optimization to enhance performance and scalability.
 Skilled in database management across both relational and NoSQL databases, with hands-on experience in MySQL, MSSQL,
PostgreSQL (RDBMS) and MongoDB, Cassandra (NoSQL).
 Experienced in big data solutions, including Hadoop ecosystem technologies like MapReduce, Hive, and Pig.
 Proficient in real-time data processing frameworks like Kafka and Flink, with expertise in utilizing Azure for cloud-based data
processing.
 Skilled in data visualization and reporting using tools like Tableau and Power BI, and experienced in scalable data processing
with Scala.
 Proficient in data warehousing concepts and technologies, including cloud-based solutions such as Amazon Redshift, Google
BigQuery, and Azure Data Warehouse.
 Skilled in building scalable Extract, Transform, Load (ETL) processes using tools like Apache NiFi and Talend, ensuring efficient
data flow and transformation across systems, with proficiency in utilizing Azure Data Factory for ETL processes.
 Familiarity with cloud platforms such as AWS, Azure, and Google Cloud Platform (GCP), with hands-on experience in deploying
and managing data solutions in cloud environments.
 Experienced in workflow orchestration and automation using Apache Airflow, implementing DAGs to schedule, monitor, and
manage complex data pipelines efficiently.
 Expert in algorithms and data structures, applying them to optimize performance in data processing, ML pipelines, and
distributed systems.
 Skillfully crafted and optimized SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML, and
User-Defined Functions to implement complex business logic, including creating clustered and non-clustered indexes.
 Employed Jenkins (CI/CD) pipelines for Microservices builds, deployment to Docker registry, and orchestration with
Kubernetes.
 Strong understanding of version control principles and practices using Git, GitHub, ensuring collaboration and traceability in
data engineering projects.
 Detail-oriented with strong problem-solving skills, focused on delivering high-quality data solutions that drive strategic
decision-making and meet business objectives.
 Proven ability to communicate complex technical concepts effectively to both technical and non-technical stakeholders, with
demonstrated leadership in guiding cross-functional teams and mentoring junior engineers.

TECHNICAL SKILLS:
• Programming Languages : Python, Scala, SQL, XML
• Data Processing & Analysis : Pandas, NumPy, Matplotlib, TensorFlow
• Database Management : RDBMS-MySQL, MSSQL, PostgreSQL and NoSQL-MongoDB, Cassandra, Elasticsearch
• Big Data Solutions : Hadoop, MapReduce, Hive, Pig, Kafka, Flink, Databricks
• Data Visualization : Tableau, Power BI
 • Data Warehousing : Amazon Redshift, Google Big Query
• ETL Tools : Apache NiFi, Talend, Apache Airflow
• Cloud Platforms : AWS, Azure, Google Cloud Platform
• Version Control : Git, GitHub
• Operating Systems : Windows, Linux
• Tools : Docker, Jenkins, Kubernetes

PROFESSIONAL EXPERIENCE:
Barclays, NJ (Data Engineer) Aug 2022 – Present
 Designed and implemented robust data pipelines for a full-scale investment web application, processing data daily and
optimizing data ingestion and analysis workflows using Python, SQL, Snowflake, SnowSQL, and Terraform, reducing data
processing time by 40%.
 Utilized Python for data manipulation, transformation, and cleansing, ensuring 99.9% data accuracy throughout the
pipeline, and leveraged Spark SQL in Lambda functions for AWS Glue ingestion framework, increasing processing efficiency
by 35%.
 Created 20+ spreadsheets, dashboards, and stories using Power BI for data visualization, reducing manual reporting efforts
by 50% and improving real-time decision-making.
 Optimized AWS-based data workflows using S3, Glue, and Athena, reducing query response times by 40% and increasing
operational efficiency.
 Developed and deployed machine learning models using TensorFlow and Databricks, leading to a 30% improvement in
predictive accuracy, enabling better investment strategies.
 Collaborated with cross-functional teams, defining data requirements and designing scalable architectures that supported
multiple business units, ensuring seamless data-driven solutions.
 Created and implemented 10+ ETL workflows using AWS Glue and Databricks, automating data ingestion into AWS Redshift
from external sources including S3, ORC, Parquet, and Text Files, reducing data integration time by 60%.
 Developed and optimized 10+ pipelines in Azure Data Factory, extracting, transforming, and loading data from sources like
Azure SQL, Blob Storage, and Azure SQL Data Warehouse, improving data refresh rates by 45%.
 Established best practices in data engineering, including version control, code reviews, and documentation, ensuring long-
term maintainability and scalability of data solutions.
 Designed 25+ reports and dashboards using Power BI, providing actionable insights that accelerated business growth by
20%.
 Developed and tailored scalable data models for the data warehouse, contributing to ETL architecture and source-to-target
mapping for real-time data integration, enhancing system performance.
 Converted an on-premises Redshift database schema to BigQuery, performing data validation across 100M+ records using
Python and Apache Beam in Cloud Dataflow, reducing data migration errors by 50%.
 Created mapping parameters, SQL overrides, and automated ETL processes using Terraform, extracting, transforming, and
loading data from 10+ sources, ensuring 99.9% data accuracy across analytics workflows.

CMR InfoTech (Junior Data Engineer) Mar 2020- Dec 2021

• Assisted in designing and optimizing data pipelines for various projects, focusing on data processing and analysis tasks
using Python and SQL.
• Conducted data quality checks and validations to ensure accuracy and completeness of data sets, while collaborating
with senior data engineers to implement best practices for data management, storage, and retrieval, enhancing overall
data reliability and efficiency.
• Analyzed and resolved data quality issues, improving data accuracy by 35%, while participating in code reviews and
knowledge-sharing sessions to enhance team collaboration and foster continuous learning.
• Designed and maintained comprehensive data process documentation, translating business needs into actionable
reports using Tableau.
• Developed data models and dictionaries for data warehouses, enabling stakeholders to easily access and report on
critical organizational data, while contributing to team discussions on data strategies and improvements.

EDUCATION DETAILS:
 Master of Science in Data Science, University of North Texas, Texas , USA. (CGPA – 3.6)

 Bachelor in Electronics and Communication Engineering, CVR College of Engineering, India. (GPA – 3.8)
CERTIFICATION:
AWS Academy Data Analytics - Acquired comprehensive knowledge and skills in data analysis, particularly focusing on
leveraging AWS tools and services for data processing, visualization, and interpretation. The training has equipped us to excel in
roles that involve extracting valuable insights from intricate datasets, enabling organizations to make informed decisions based
on data-driven approaches.