CHALLA GOUTHAM REDDY
Hyderabad,Telangana
Summary
An aspiring and competent individual with 2 years experience in the field of operational excellence and process improvements looking to establish a career as a data analyst with an organization that allows to utilize technical and analytical skills for the desired outcomes of an organization.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Junior Executive
Sudarshan chemical industries limited
pune
09.2020 - Current
- Responsible for performing Process order summarization analysis using Pivot tables in Microsoft Excel and creating meaningful insights from reports which aids SBU heads to take key decisions.
- Investigation of Utility use difference Reports toward finish of each and every month and examination of Current month Standards with Avg Standards of Last year to figure out Performance of Business unit with respect to Last year.
- Automation of Process order Summarization Reports using Power Query Editor in Excel.
- Analysis of Yield data with respect to different raw materials using Box and Whisker plot and also finding out correlation between yield and other parameters affecting yield using scatter plot.
Education
B.Tech - Chemical Engineering
04.2020
Percentage-67.5%
11 & 12th - MPC
03.2016
Percentage-98.1%
High School Diploma -
03.2014
Percentage-100%
Skills
- Excellent hands on Microsoft Excel
- Power BI
- Tableau
- Microsoft SQL
Certification
- Successfully completed MS Excel certification course from Udemy.
- Successfully completed Data analytics Certification course from ExcelR Solutions.
- Data analytics Internship Certification from ExcelR Solutions.
Languages
Telugu
Native language
English
Advanced
C1
Hindi
Upper intermediate
B2
Projects
Industrial combustion energy usage-
- Merging of Industrial combustion energy usage and Manufacturing combustion energy usage datasets using merge option in Microsoft power Query and using Joins in SQL.
- Analyzing KPI's like Total process heating,Unit name trend vs GWH Total & % Share of Direct Uses-Total Nonprocess for each MECS_Region of related to Datasets using Excel,Power BI,SQL and Tableau.
EDTECH Customer Acquisition analysis
- Uploading datasets into Power BI from CSV and building a Data model.
- Removing Outliers from datasets Box and whisker plot.
- Analyzing KPI's like Lead introduction to Successful conversion data using Funnel Chart.
- Reasons for not joining the program using Pie Chart
- Analyzing the Conversion ratio of BDA and BDM using DAX Functions like CALCULATE and FILTER and representing the data in the form of Bar Chart.
Timeline
Junior Executive - Sudarshan chemical industries limited
09.2020 - Current
Visvesvaraya National Institute of Technology - B.Tech, Chemical Engineering
Narayana Junior College - 11 & 12th, MPC
Sri Prakash Residential School - High School Diploma,
- Successfully completed MS Excel certification course from Udemy.
- Successfully completed Data analytics Certification course from ExcelR Solutions.
- Data analytics Internship Certification from ExcelR Solutions.
Similar Profiles
Bradley CarringtonBradley Carrington
Lab Technician at Chemical Industries LimitedLab Technician at Chemical Industries Limited
Jayant KarJayant Kar
Purchase Manager at Sudarshan Group Of IndustriesPurchase Manager at Sudarshan Group Of Industries
NIRAVKUMAR K. MISTRYNIRAVKUMAR K. MISTRY
Sr. Executive - Payroll & HR at Jay Chemical Industries Private LimitedSr. Executive - Payroll & HR at Jay Chemical Industries Private Limited