Data Analysis

SAIDEEPAK PONUGOTI

Open to relocate in U.S Phone: 205-***-**** Email: *************@*****.***

Summary

• Overall 3.5+ years of experience as a Data Engineer with structured and unstructured data, data validation, predictive modelling, and data visualization.

• Generated data visualizations using Python and creating dashboards using tools such as Tableau, Power BI, and MS Excel.

• Worked closely with our project managers, business units, data analysts and other IT teams

• Good knowledge of using various packages in R and Python such as a Pandas, SciPy, NumPy, Matplotlib and Plotly.

• Working knowledge of Microsoft Azure.

• Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.

• Excellent knowledge of multiple databases like NoSQL, and MySQL.

• Ability to Perform data collection, data cleaning, data wrangling, data analysis and building machine learning model on the data sets in both R and Python.

• Performed cleaning and filtering on imported data using Power Query and DAX functions in Power BI.

• Excellent communication skills. Successfully working in fast-paced multitasking environment both independently and in collaborative team, a self-motivated enthusiastic learner. Technical Skills

Languages: Python R C Java Script Data Driven Documents Data Visualization Tools: Power BI Tableau Qlik Sense Microsoft Excel Monitoring Tools: Splunk

Continuous Integration Tools: Jenkins

Bug Reporting Tools: JIRA

Version Control Tools: GIT Hub

Cloud Platforms: Azure

Database: SQL

Other Skills: HTML CSS Statistical analysis Communication & Presentation Skills Work History

Data Analysis and Reporting

Mercedes-Benz, Vance, AL November 2022 - Present

• Performed data acquisition, preparation, cleansing, modeling, and data analysis on complex and large datasets.

• Eliminated manual reporting by analyzing Power BI reporting practices and automated the reports using Power query, DAX expressions and saved 2 hours of daily manual work.

• Created comprehensive Power BI, Power point and Excel reports to support steering committees at all levels of the organization to make data driven decisions.

• Designed, created innovative and valuable visualization to analyze and identify data trends related to failure rates, status, and other information as needed to support the organization.

• Implemented data extraction, cleansing, and moved data from source systems to different data warehouses.

•Collaborated with IT (Data Warehouse Group) to assist in the development of the data warehouse (all information on parts/service objectives, sales, etc.) for reporting and streamline it in Power BI.

• Designed, developed, and maintained infrastructure for various applications used across the plant.

• Supported and owned Operational dashboards, business performance dashboard, interpret the results, and summarize opportunities for improvement and make recommendations to senior leadership.

• Responsible for troubleshooting data source connections, automated data imports, and data transformation for business intelligence reports and dashboards.

• Troubleshoot and support Power BI workspace whenever there are issues in production.

• Created reports and dashboards in Qlik Sense.

Data Engineer

Avalanche Technologies LLC, Irving, TX December 2021- November 2022

• Developed automated data pipeline from various external data sources (web pages, API etc) to internal data warehouse (SQL Server, AWS, Azure).

• Performed Data Analysis on client’s data and created visualizations on data using Power BI.

• Experience with CI (Continuous integration) and CD (Continuous deployment) methodologies with Jenkins.

• Designing and Developing reports from multiple data sources blending data on a single worksheet in Power BI.

• Creating, scheduling, and monitoring Azure Data Factory pipelines on Azure Sql.

• Created Virtual Machines through VMware and Azure Portal. Data Engineer

Netxcell Limited, Hyderabad, India November 2018 - December2019

• Performed data extraction, loading, data cleaning and data visualization.

• Used bug tracking software like JIRA and used it in finding, recording, reporting, managing, and tracking of bugs.

• Designed and developed weekly, monthly reports by using MS Excel Techniques (Charts, Graphs, Pivot tables)

• Created complex data pipelines to handle different sizes of datasets for data extraction and data processing.

• Responsible for troubleshooting and repairing common database performance errors.

• Participated in discussions related to business challenges, provided optimal solutions to real time problems. Data Analyst

Netxcell Limited, Hyderabad, India April 2017-August2017

• Performed Data analysis and data profiling using complex SQL on various sources systems.

• Used advanced Microsoft Excel to create pivot tables and pivot reporting as well as VLOOKUP function.

• Created daily and monthly reports using SQL for Business analysis.

• Creates and maintain high quality documents and adheres to quality standards set by Management.

• Use database management software to analyse consumer trends and update business and marketing strategies accordingly.

Projects

Data Visualization using Immigrants Data: Based on modes of transportation used by immigrants to enter United States I created interactive pie charts, bar plots, line graphs, and visualized insights using Plotly and Seaborn. Heart Disease Prediction: Performed data cleaning and analysis using prevailing heart disease datasets. Built a Machine Learning model using classification techniques such as Random Forests, SVM, KNN, Logistic Regression based on factors such as cholesterol level, age, and smoking habits. Achievements

• Cyber Security Management Certificate (UAB)

• Member of ‘Data Science Student Organization’ at University of Alabama at Birmingham (UAB).

• Sports Secretary for ‘The Association of Indian Students at UAB’.

• Player of UAB Cricket team and won multiple tournaments in Auburn and Birmingham 2020-21.

• Manager for ‘Sports club and events’ in BML Munjal University. Education

Master’s in Data Science - GPA: 3.85

University of Alabama at Birmingham, Alabama. Jan 2020-Dec 2021 Course Work: Data Visualization, Foundation of Data Science, Machine Learning, Advance Algorithms, Database Application Development, Computer Security, Network Security, Cyber Risk Management, Quantitative Analysis for Managers, Inter Statistical Analysis.

Bachelor of Technology, Computer Science Engineering - GPA: 3.6 BML Munjal University, Delhi, India. May 2019

Contact this candidate