Data Engineer

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 3

Venu Dodda

Data Engineer

📞 +1 2342639963 🌐 venudodda97@gmail.com 📍 Kent, Ohio, United States 🌐Venu Dodda

SUMMARY

As a Data Engineer with a master’s degree in business Analytics and over 4 years of relevant experience, I
excel in delivering high-impact data solutions. I have a strong technical foundation in coding languages such
as SQL, and Python, Snowflake, Azure Data Factory, Azure Synapse and tools like Power BI, which enables
me to provide hands-on guidance to ensure best coding practices, code optimization, and data correctness. My
background in data analytics and critical thinking allows me to contribute to all phases of the product
initiative life cycle.

TECHNICAL SKILLS

Programming Languages: Python, SQL, R, Excel, SSIS, Snowflake, Azure Data Factory, Azure Synapse
Data Visualization: Tableau, Power BI, EPIC Report.
Data Manipulation: Data Cleaning, Data Profiling, Transformation, Aggregation, Data Governance, Data
Quality, Management Applications, ETL.
Database Management: SQL Query Optimization
Version Control: Git
Operating Systems: Windows, Linux/Unix

PROFESSIONAL EXPERIENCE

Baxter Health, Chicago, IL.


Data Engineer
January 2023- till date
 Extracted, cleansed, and transformed intricate datasets using Python and SQL, ensuring data
precision and integrity.

 Conducted exploratory data analysis, identifying patterns, anomalies, and pivotal insights, leading to
informed decision-making.
 Created impactful visualizations in Power BI, enhancing data comprehension and facilitating cross-
functional collaboration.
 Collaborated with stakeholders to define and refine data requirements, aligning them with strategic
objectives.
 Extensively utilized the Big Data Platform, including PySpark, Azure Data Lake storage account, and
Data Factory, to handle and process large-scale datasets efficiently.
 Utilized Data Factory pipelines to seamlessly transfer data from Oracle DB to Data Lake storage,
leveraging PySpark scripts and transforming the data into the Parquet format for optimized storage and
processing.
 Developed predictive models for sales forecasting, contributing to a significant 15% enhancement in
accuracy.
 Applied advanced SQL query optimization techniques, reducing query response times by 20%.
 Produced detailed reports encapsulating KPIs and performance metrics, empowering data-driven
decision-making.
 Demonstrated exceptional communication skills and meticulous attention to detail, fostering team
cohesion.

Genex Technologies, Hyderabad, India


Data Engineer May 2019 – August 2022
 Utilized MySQL and MS Excel to review and analysed system data to identify trends.
 Improve efficiency and accuracy by evaluating the model in Python and R
 Performing statistical data analysis and data visualization using Python and Imported the claims data
into Python using Panda’s libraries and performed various data analyses.
 Developing containment scripts for data reconciliation using SQL and Python
 Presented Dashboards to Higher Management for more Insights using Power BI
 Worked with internal client team to structure, analyse and interpret data requests.
 Created visually compelling dashboards for data reporting in Microsoft Power BI and Excel,
incorporating Pivot tables and VLOOKUP for impactful presentation.
 Analysed and Prepared data and identified the patterns on the dataset by applying historical models.
 Developed and completed action plans, implemented control panel structure, conducted audits and
provided technical solutions for a diverse array of issues.

PERSONAL PROJECTS

Dashboard Creation | Portage Animal Protection League (APL) | Microsoft Power BI


 Designed and implemented a relational database using MySQL, resulting in 20% faster data retrieval
and manipulation.
 Developed SQL queries and scripts, leading to a 30% reduction in data processing time.
 Documented the database schema and provided user documentation, contributing to 100% efficient
database utilization.

Public Utility Data Liberation (PUDL) Power Generation | Python


 Designed and implemented a relational database using MySQL, resulting in 20% faster data retrieval
and manipulation.
 Developed SQL queries and scripts, leading to a 30% reduction in data processing time.
 Documented the database schema and provided user documentation, contributing to 100% efficient
database utilization.

SQL Database Implementation| Healthcare | SQL | Excel

 Designed and implemented a relational database using MySQL, resulting in 20% faster data retrieval
and manipulation.
 Developed SQL queries and scripts, leading to a 30% reduction in data processing time.
 Documented the database schema and provided user documentation, contributing to 100% efficient
database utilization.

EDUCATION

Master of Science in Business Analytics


Kent State University August 2022 – August 2023
Bachelor of Science in Aerospace Engineering
Lakireddy Balireddy College of Engineering June 2016 – April 2020

CERTIFICATIONS

• Hacker Rank - SQL Intermediate (Designing, optimizing, and maintaining databases)


• Microsoft Azure Data Fundamentals

You might also like