BHAVATHARANI MANOHAR
A detail-oriented Business Analyst with a passion to support decision making within dynamic team, assist in resolving issues that enhances the organization’s growth aligned with their strategic goals in a fast-phased environment.
+1-470-***-**** *****@****.***
LinkedIn GitHub
Skills
•Python (Pandas, Seaborn, Matplotlib)
•Excel (VLOOKUP, SUMIFS, Pivot Tables)
•AWS Cloud
•SQL (Joins, Aggregations)
•R
•Tableau, Looker Studio (GCP)
•SAP
Work Experience
TEACHING ASSISTANT, UNIVERSITY OF PITTSBURGH - USA (PART TIME) Feb 2023 - Jul 2023
●Developed course materials, provided mentoring to team, and conveyed insights to diverse students.
●Equipped students with data visualization skills in Python, fostering a more analytical and insightful approach to problem-solving in data analysis.
TECHNICAL ILLUSTRATOR, BOEING INDIA PRIVATE LIMITED - INDIA Feb 2019 - March 2021
●Built a user-friendly tool in Python and Excel that collects data from multiple sources and displays customized airline and maintenance information, reducing search time for illustrators and driving a 3% increase in user productivity.
●Led a team of engineers in analyzing complex engineering drawings using CATIA software. Assured quality aircraft maintenance procedures by upholding rigorous standards to deliver an error-free manual and ensured client satisfaction.
JUNIOR DESIGN ENGINEER AND TRAINER, OVERSQUARE AUTOMOTIVE - INDIA Aug 2017 - Dec 2018
●Assisted in product development and tested areas of 3D model (buggy – small race car) under real-world conditions using Finite Element Analysis software by applying load and calculating stress.
●Pinpointed areas for optimization and increased buggy performance through an 18% revision to suspension system.
Projects
AIR QUALITY INDEX ANALYSIS - USA April 2023
●Identified seasonal patterns in diverse ozone AQI datasets using time series models.
●Revealed relationship between yearly lags using a lag plot and forecasted data using Holt-Winters method.
●Developed strategies for improving air quality in at-risk areas by employing a machine learning model that clusters sites by state, enabling targeted interventions.
SPSS MODELER FOR ANALYSIS OF GOOGLE PLAY STORE APPS - USA March 2023
●Created a dashboard using Tableau to visualize public Google Play Store data, identifying key factors driving app success and informing strategic app development recommendations.
BEHAVIORAL ANALYTICS FOR YOUTH (CDC’S YRBSS DATASET) - USA Dec 2022
●Uncovered factors affecting student sexual harassment and stress via decision tree analysis, highlighting drug usage as a significant factor.
●Yielded an F1 score of 83% and proposed potential solutions to mitigate both issues.
Education
UNIVERSITY OF PITTSBURGH - USA Dec 2023
Master of Science in Management Information Systems (STEM Designation), GPA: 3.54
BANNARI AMMAN INSTITUTE OF TECHNOLOGY - INDIA April 2017
Bachelor of Engineering in Mechanical Engineering, GPA: 3.42
Certifications
IBM Python Project for Data Engineering (ETL) - USA Dec 2023
AWS Cloud Practitioner Fundamentals Certification - USA Sep 2023
SQL from Afterskills Diving into Data with SQL - USA April 2023
Accomplishments
3rd Place Winner on 2nd T.L. Saaty Decision Making for Leaders Hackathon - USA March 2023
Provided sustainable solution for Kate’s Real Food and Organic Snack Company, focused on developing an eco-friendly snack wrapper using AHP Analysis a Python based decision making framework.
Lean Six Sigma Green Belt Certification - USA April 2023
Analyzed process flow of Mosebach’s ANA unit production that impacts manufacturing throughput and productivity by conducting internal review meetings with a team of 5+ members on a weekly basis to identify bottlenecks.
Leveraged statistical software like Minitab and techniques such as process mapping to identify root cause to streamline process, reduce defects and improve overall quality.