Surendra Sai Maddukuri

• Maintained documentation of all the processes related to Data Analysis.
• Developed dashboards with Power BI to monitor key performance indicators.
• Built visualizations that enabled users to quickly interpret results from complex analyses.
• Leveraged SQL queries to extract, transform and load data into databases.
• Translated raw data into meaningful information using statistical techniques.
• Provided data-driven solutions to support decision making.
• Optimized existing database structures for better performance on analytics tasks.
• Analysed large datasets to identify trends, patterns and correlations for business insights.
• Assisted with efforts to track, evaluate and report on impact of programs using multiple data sources.
• Automated many manual tasks using Selenium, OpenPyxl and other python libraries to scrape data from web and modelled data using Power BI which helped many processes. 3.4K CAD as Cost Savings in 2022.
• Applied Weibull and other Probability distributions to predict Life of parts and future failure events.
• Partnered with functional teams to evaluate new data sources and advise on data for mat and data dictionary.
• Proficient in crafting dynamic BI dashboards utilizing supplier , warrant, and invoice data.
• Set up automatic refreshing for authorized dashboards within Power BI Report Server schedule.

Project Description

GE is known for providing software and advisory services around operational technology and infrastructure, jet engines, power plants, and locomotives. The purpose of project is Real time condition monitoring of the mining equipment such as Jaw/Impact crusher using robust statistical techniques and predictive failure detection to prevent unplanned downtime.

Responsibilities

· Performed Data Preparation: Cleaning, transformation and understanding the data.

· Performed EDA.

· Performed Text Pre-processing techniques and analysis using NLTK Library

· Performed various Text analysis techniques to get better accuracy.

· Developed predictive model to predict the right label using machine learning algorithm and various optimization techniques.

· Developed ETL jobs from various sources such as Oracle Database, MySQL Database, Flat Files (Excel and Google Sheet) and loaded into target databases using Talend Open Studio.

· Interact with business community and gathered requirements based on changing needs. Incorporated identified factors into Talend jobs to build the Data Mart.

· Tuning the SQL source queries to restrict unwanted data in ETL process.

· Building Visualizations, reports and interactive dashboards on OLAP Database built as per customer needs.

· Developed Power BI model (Star & Galaxy Schema) to build reports based on customer requirements.

. Modelled Data in Power BI using SQL for performance tuning of reports.

· Built interactive visualizations and configured relative filters, slicers, bookmarks and drill-through from summary to detailed reports.

Environment:Python, Jupyter notebook/Spyder, Linux, Power BI, Windows 7