GUNA SHANMUKHA GEDEALA

+1(631) 965- 4661 | | Cincinnati, Ohio | LinkedIn

EDUCATION

UNIVERSITY OF CINCINNATI, CARL H LINDNER COLLEGE OF BUSINESS CINCINNATI, UNITED STATES

Master of Science, Business AnalyticsExpected - August 2022

INDIAN INSTITUTE OF TECHNOLOGY BHUBANESWAR BHUBANESWAR, INDIA

Bachelor of Technology (Hons.) in Civil EngineeringMay 2019

PROFESSIONAL EXPERIENCE

DELOITTE CONSULTING INDIA PVT LTD HYDERABAD, INDIA

Business Technology AnalystAugust 2018 – July 2021

  • Led a four-member Agile team to collaborate with management and business teams for requirement analysis, design, development, testing, and documentation of analytical projects for 2 Fortune 50 companies
  • Built data pipeline to extract and transform data and predict the child risk score for major US public sector clients using Linear Regression in Python to achieve a mean error of 7.3%; data pipeline resulted in cutting processing time to 90% of initial estimate
  • Built a real-time data visualization and analytics dashboard using Power BI for Johnson & Johnson to monitor the deployment of finical technology solutions and analyze their burnout rate which saved ~20% of the planned hours
  • Identified customer segments that use branded credit cards using k-means clustering. Determined the factors affecting the consumer propensity towards branded credit cards for major US airlines which drove the overall usage by 7%
  • Developed reports using lease data from IBM TRIRIGA to perform Triage and Root Cause Analysis of Lease Accounting
  • Developed a visual dashboard for a major US retailer using IBM TRIRIGA to monitor various KPIs across their stores in US
  • Mentored new campus hires through hands-on experience of Power BI and SQL as a part of Deloitte Analyst Training courses

POSITIONS OF RESPONSIBILITY

IIT BHUBANESWAR BHUBANESWAR, INDIA

Core Team Lead – Alma Fiesta, The Annual Cultural FestMarch 2015 – May 2016

  • Led a team of 45 members to team to plan and execute the organization of the fest by successfully utilizing 23K USD which saw a footfall of 8000 students from educational institutions across the country
  • Spear-headed operations involving market research, brand development, and Social Media marketing. This played a major role in the increasing popularity of the fest in the consecutive years

Sr. Coordinator – Souls for Solace, NGOFebruary 2016 – May 2017

  • Led a student body of 90 members to conceptualized and instigate various humanitarian drives that generated a funding of 8.5K USD and helping ~250 students and families

SKILLS & ACHIEVEMENTS

  • Programming Languages: Python, C++, Java, HTML, CSS, JavaScript, MATLAB
  • Technical Knowledge: IBM Tririga, Power BI, Tableau, Nuvolo, AutoCAD, Sony Vegas, Adobe Photoshop and After Effects
  • Deloitte Consulting – 3 “ Applause ” awards for outstanding client service and contribution to the firm