Pranavi Anchuri

Pranavi Anchuri

Data Engineer
United States of America

About Me

Data Engineer with 3+ years’ experience managing large-scale data environments, optimizing data pipelines, and architecting resilient Data Warehouses. Proficient driving data-driven strategies, enhancing operational effi…

Experience

Data Engineer

JPMorgan Chase
Jul 2023 - Present · 3 years

● Created Azure Data Factory pipelines to import data from text files & on-premises databases into Azure SQL data warehouse, reducing
data ingestion time by 30%.
● Engineered data pipelines for ETL processes, loading data from various sources into Azure data services like Azure Data Lake, Azure SQL
Database, or Azure Synapse Analytics, managing 10TB+ of data. Enabled in-depth analysis and led to a remarkable 10% increase in
customer retention.
● Pioneered the implementation of Databricks notebooks using Python (PySpark) and Spark SQL for transforming the data stored in Azure
Data Lake store Gen2 from Raw to Stage and Curated zones.
● Collaborated with cross-functional teams to identify and resolve data quality issues, leading to a significant decrease in data errors by
50% and contributing to a 70% increase in stakeholder satisfaction.
● Transformed Hive/SQL queries into efficient Spark transformations using Spark RDDs and Python, resulting in a 40% reduction in data
processing time and improved overall data pipeline performance.
● ETL/ELT technologies and scripting languages are used to develop and maintain workflows for real-time data processing.

Data Engineer

JPMorgan Chase, California
Jul 2023 - Present · 3 years

Created Azure Data Factory pipelines to import data from text files and on-premises databases into Azure SQL data warehouse, reducing data ingestion time by 30%.
Engineered data pipelines for ETL processes, loading data from various sources into Azure data services like Azure Data Lake, Azure SQL Database, or Azure Synapse Analytics, managing 10TB+ of data.
Enabled in-depth analysis and led to a remarkable 10% increase in customer retention.
Pioneered the implementation of Databricks notebooks using Python (PySpark) and Spark SQL for transforming the data stored in Azure Data Lake store Gen2 from Raw to Stage and Curated zones.
Collaborated with cross-functional teams to identify and resolve data quality issues, leading to a significant decrease in data errors by 50% and contributing to a 70% increase in stakeholder satisfaction.
Transformed Hive/SQL queries into efficient Spark transformations using Spark RDDs and Python, resulting in a 40% reduction in data processing time and improved overall data pipeline performance.
Used ETL/ELT technologies and scripting languages to develop and maintain workflows for real-time data processing.

Data Engineer

Tata Consultancy Services, India
Jan 2020 - Jul 2022 · 2 years 6 months

Led development of an open-source tool that prints 50+ Cloudera-hosted Hadoop Cluster health and monitoring metrics such as Hadoop, HDFS, Hive, HBase, Zookeeper, Kafka, Apache Spark, and MapReduce using Shell Scripting, Cloudera API, and Python Libraries.
Conducted auditing, inspecting, and visualizing S3 server access logs using AWS Lambda and AWS Athena.
Automated resulting scripts and workflow using Apache Airflow and shell scripting to ensure daily execution in production.
Utilized AWS Glue for transformations and AWS Lambda, SQS, and SNS to automate processes and worked on AWS Data Pipeline to configure data loads from S3 to Redshift.
Spearheaded development and implementation of data pipelines in Snowflake, automating processes and reducing manual intervention by 99%, while empowering business users with enhanced data ownership.
Worked on Source/Version control Tools using Github, validate the change sets code changes, Check-in/Out, and versioning and developed CI/CD pipelines using Jenkins on AWS to create, test, and deploy code to higher environments.
Authored in-depth analysis of network element functionality trends by executing advanced python and SQL queries on data warehouse (Snowflake) including predictive modeling using scikit-learn.
Conducted 50+ code reviews and mentored 12 junior developers on various projects.

Data Analyst

Embedded RF Technologies, India
Mar 2018 - Oct 2018 · 7 months

Analyzed S2TM with table descriptions, schema details for both source and target, data types of both source and target while mapping columns, transformations, and Teradata target table structure.
Employed Pig and Hive Scripts to transform raw data based on given transformation provided in S2TM.
Prepared Source and target DDL's based on S2TM and designed tables accordingly in Hive and Hbase.
Solved performance issues in Pig scripts and Hive Scripts with understanding of Joins, Groups, and aggregation.
Developed Tableau dashboards for real-time insights and utilized Apache Airflow for ETL orchestration, ensuring data consistency.

Skills

Data Extraction Python Pandas NumPy Seaborn Scikit-learn SQL Java Scala Tableau Power BI Jira Excel MySQL MongoDB Redshift SQL Server AWS EC2 S3 Azure AWS Glue Snowflake Docker Maven Jenkins Git Kubernetes ETL Hadoop Airflow Apache Beam Spark Hive Pig MapReduce HBase Data Modeling Apache Kafka Amazon Kinesis PySpark Spark SQL Azure Data Factory Azure SQL Data Warehouse Azure Data Lake Azure SQL Database Azure Synapse Analytics Databricks Shell Scripting Cloudera API AWS Lambda
Report this Profile?