Ananya Gampala
Denton,TX
Summary
Adept at leveraging advanced data engineering and analysis skills, I significantly improved Troube shooting efficiency at Humana. My expertise in Azure DevOps, SQL, and collaborative problem-solving drives operational excellence and innovation. Skilled in transforming complex datasets into actionable insights, I excel in fast-paced environments, ensuring data integrity and performance.
Overview
5
5
years of professional experience
Work History
Data Engineer /System Administration
Humana
Louisville, KY
04.2024 - Current
- Designed and implemented data pipelines using Azure Data Factory (ADF), Data Lake Storage, and Azure Databricks for efficient data ingestion and transformation
- Responsible for troubleshooting and clearing the tickets generated by application teams through Service now and was responsible for resolving issues
- Automated deployment processes using dbt Cloud or CI/CD pipelines, enabling seamless integration of dbt models into production environments
- Optimized database performance and ETL pipelines, integrating DevOps practices for data engineering workflows
- Utilized JIRA to manage project
- Scheduled and managed jobs with UNIX/Linux Commands crontab, automating routine tasks and ensuring timely execution of data pipelines
- Designed, scheduled, and automated complex batch jobs using Control-M to ensure timely data processing and operational efficiency
- Monitored Control-M job executions, resolved job failures, and ensured minimal downtime by troubleshooting errors effectively
- Designed and implemented CI/CD pipelines using Jenkins, GitHub Actions, and Azure DevOps, automating software builds and deployments
- Optimized slow-running SQL queries by restructuring joins, indexing, and analyzing execution plans, improving performance by up to 25%
- Utilized advanced Excel functions and formulas, including VLOOKUP, INDEX-MATCH, and pivot tables, to perform detailed data analysis
Data Engineer
PepsiCo
Plano, Texas
08.2023 - 04.2024
- Worked on end-to-end workflow creations and Decision Making to migrate the ERP systems data and Data from SAP to Azure Data Lake
- Proficient in the design and implementation of data ingestion pipelines that can efficiently handle scheduled and event-based triggers which Include fail-fast schema validation into planned and event-triggered ingestion operations, increasing data reliability and accuracy and integrating KPI
- Implemented ETL and ELT processes within Azure Databricks (ADB) notebooks using python, Scala and PySpark to transform and load data from raw bronze storage into structured silver tables, adhering to defined schemas and business rules
- Knowledge and experience working on RDBMS
- Developed Azure Databricks (ADB) PySpark notebooks to help with the ingestion of data from bronze-level storage into predefined silver-level tables, assuring data quality and reliability
- Experience working on Snowflake Data Marts in dimensional data modelling using star and snowflake schemas
- Developed, designed, and maintained complex reports using SQL Server Reporting Services (SSRS) to meet diverse business requirements
- Deployed the silver notebook changes and workflow changes accordingly in Azure DevOps
- Optimized UNIX shell scripts to automate batch jobs and monitor data pipeline execution
- Utilized advanced DAX (Data Analysis Expressions) functions and Power Query to transform and model data for comprehensive business intelligence solutions
Data Analyst
Acholyte
Tempe, Arizona
01.2023 - 05.2023
- Queried the data using SQL operations to transform the data types and to extract the required data in SQL server relational Database
- Analyzed the complex data and developed Data visualizations, charts and Dashboards using Tableau and Power BI, QlikView
- Designed and developed interactive Tableau dashboards to visualize complex data sets, enhancing data comprehension and decision-making processes
- Integrated data visualizations and charts from Excel and Tableau into PowerPoint slides to provide comprehensive data insights
- Impact Improved the performance of sending mail API by creating a web job and altered the stored procedure in SQL and Utilized SharePoint
Data Engineer
Zensar Technologies
Hyderabad, INDIA
05.2020 - 11.2021
- Worked on Dimension Data modelling concepts like Star Join Schema modelling, Snow-Flake modelling, FACT and Dimensions Tables, Physical and Logical Data Modelling using slowly changing Dimensions (SCD)
- Ensured data accuracy and quality using validation scripts written in Python and SQL on GCP and UNIX-based systems
- Developed a scalable ETL pipeline in GCP using PySpark and SQL to process and transform large datasets
- Automated data workflows with Cloud Composer (Apache Airflow), ensuring reliability and on-time data delivery
- Good understanding of Big Data Hadoop (HDFS) and Yarn architecture along with various Hadoop Demons such as Job Tracker, Task Tracker, Name Node, Data Node, Resource/Cluster Manager, and Kafka and Maintained branches and s repositories for facilitating code integration
- Extracted the data from MySQL into HDFS using Sqoop
- Advanced experience using Microsoft’s SQL Server SSRS and Microsoft Sql Server Analysis Services
- Maintained branches and GIT repositories in GIT and GITHUB for facilitating code integration
- Connected Power BI and QlikView and Qlik sense to various data sources, such as databases, cloud platforms to import and transform data
Education
Master’s - Information Technology
University of Memphis
Memphis, TN05.2023
Bachelor of Engineering -
Osmania University
Hyderabad, INDIA08.2021
Skills
- SQL
- PL/SQL
- Python
- HiveQL
- SQL Server
- Hive
- PySpark
- XML
- Excel
- UNIX
- Git
- Azure DevOps
- Azure Storage Explorer
- Azure Data Lake Gen2
- Azure Databricks
- ETL
- Power BI
- Tableau
- Kafka
Projects And Leadership
Graduate Assistant, University of Memphis, Memphis, TN, 01/22, 12/22, Evaluated the assignments and provided feedback on the content and assessed the accuracy, clarity, and relevance to the course objective.
Timeline
Data Engineer /System Administration
Humana
04.2024 - Current
Data Engineer
PepsiCo
08.2023 - 04.2024
Data Analyst
Acholyte
01.2023 - 05.2023
Data Engineer
Zensar Technologies
05.2020 - 11.2021
Master’s - Information Technology
University of Memphis
Bachelor of Engineering -
Osmania University