Jothsna Praveena Pendyala
Summary
Ex-Electrical Engineer transitioning into a Data Analyst role after completing IBM Professional Data Analyst course by coursera and several data analyst Bootcamps. Over 7 years of experience managing cross functional teams of 25-30 people and working with Executives. Core skills include data cleaning, analysis and exploration and providing actionable insights through creation of powerful dashboards and reports.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Assistant Electrical Engineer
TNEB
Tuticorin
07.2019 - Current
● Developed efficient solution to reduce power interruption by analyzing previous records and supervised the team of about 25 employees to replace approximately 500 insulators.
● Designed an excel sheet with advanced formulae to calculate distribution energy losses and took necessary action to maintain losses within 15%.
● Led the data storage to a paperless practice by utilizing Microsoft excel to record hourly values of various meters and to derive insights about load flow with ease and accurately and reduced office overhead by 10%.
Assistant Professor
07.2015 - 05.2019
- Mentored 50 students by providing academic advice and guidance during this period
- Analyzing student performance through continuous assessments and calculating course outcomes and program outcomes of each student
- Developed and executed special program to learners whose course outcomes are less than 50%
- Designed a statistical model with their marks and identifying students with less than mean marks and students with similar marks to find if any malpractice happened or not.
Education
Master of Technology - Power Systems
Sardar Vallabhbhai National Institute of Technology
Surat08.2015
Bachelor of Technology - Electrical And Electronics Engineering
Jawaharlal Nehru Technological University
Kakinada04.2013
Skills
- Data Visualization/Engineering:
- PowerBI
- IBM Cognos Analytics
- Techniques:
- Data Analysis with SQL
- And Python
- Statistics
- Tools and Frameworks:
- Excel
- Python(Numpy,Pandas,JupyterNote)
- Databases (MySQL)
Additional Information
Volunteered in a Virtual Internship in PWC in collaboration with Forage (2022).
- Performed 4 different tasks to analyze call centre data.To illustrate,
- Calculated total calls as 5000 and derived number of calls accepted and rejected.
- Interpreted Call Centre Trends by Visualising customer and agent behavior. Metrics such as average speed of answer, resolved rate, retention% with respect to Customer demographics has been calculated. Created a dashboard with visualisations and drawn insights such as which agent has attended and resolved maximum and minimum calls.
Developed Instagram user analytics project.
- User analysis is the process by which a team track how users engage and interact with their digital product (software or mobile application) in an attempt to derive business insights for marketing, product & development teams.
- DBfiddle.com which is an online platform has been used to query the data and to get useful insights.
- Top 5 users are determined to reward them as Most Loyal Users.
- Similarly using SQL analysis has done to determine inactive, fraud, most liked photo and the best time to launch any advertisement campaigns.
Certification
IBM Data Analyst Professional Certification:
Coursera, Online(2022)
- Studied Excel Basics for Data Analysis and developed a project in excel using car sales dataset from kaggle with 156 rows.
- Data cleaning and formatting is performed on the dataset. Data Visualization and Dashboards are created with Excel and IBM Cognos with a car dataset from kaggle and derived a few insights like retention such as if the value is greater than 65% then the car is considered as good.
- Created Databases and tables using Structured Query Language(SQL) in IBM DB2 console,MySQL. Using SQL magic, implemented SQL queries in Jupyter note.
- Pandas,Numpy,Matplotlib, seaborn,scikitlearn,statsmodels libraries in Python are studied. Hands on Explorartory Data Analysis using these 6 libraries.
Microsoft Power BI Certification Course:
Growth School,Online(2022)
- Built Power BI dashboard using data from Super store sales data set to visualize core. business KPIs (e.g. Total Sales, Most Purchased product,least purchased product, Profit by year ), saving 10 hours per week of manual reporting work
Timeline
Assistant Electrical Engineer
TNEB
07.2019 - Current
Assistant Professor
07.2015 - 05.2019
Master of Technology - Power Systems
Sardar Vallabhbhai National Institute of Technology
Bachelor of Technology - Electrical And Electronics Engineering
Jawaharlal Nehru Technological University
Similar Profiles
SHANMUGAM SSHANMUGAM S
MANAGIN DIRECTOR TANTRANSCO at TNEBMANAGIN DIRECTOR TANTRANSCO at TNEB
KALIDOSS TAMILARASANKALIDOSS TAMILARASAN
Senior Draughtsman at TANGEDCO (Tamilnadu Electricity Board Limited - TNEB Ltd.)Senior Draughtsman at TANGEDCO (Tamilnadu Electricity Board Limited - TNEB Ltd.)
Jothsna Praveena PendyalaJothsna Praveena Pendyala
Assistant Engineer at TNEB LTDAssistant Engineer at TNEB LTD
Alexis QuerecutoAlexis Querecuto
Assistant Electrical Engineer at UAT TEAMAssistant Electrical Engineer at UAT TEAM
KANHAIYA LALKANHAIYA LAL
Assistant Electrical Engineer at Vidyut Engineers (Authorized KOEL CARE Dealer)Assistant Electrical Engineer at Vidyut Engineers (Authorized KOEL CARE Dealer)