Machine Learning Power Bi

NISHMITHA BILIMAGGA SHASHIDAR

F*-OPT & H*-EAD No sponsorship required 978-***-**** *********************@*****.*** LinkedIn EDUCATION

Masters in Business Analytics Aug 2022-May 2024

University of New Haven, CT, USA GPA: 3.97

Relevant Coursework: Data Visualization & Mining, Operations Management, Machine Learning, Business Forecasting, DBMS, Sports Business Analytics Bachelors in Electronics & Communication Engineering June 2015-May 2019 Visvesvaraya Technological University, India GPA:3.58 TECHNICAL SKILLS

Data Analysis & Visualization: Power BI, Tableau, Excel (Advanced), SQL, Python (Pandas, NumPy), VBA, SAP, ServiceNow Programming & Machine Learning: R, Python (Scikit-learn, PyTorch), C, C++, SAS, Excel, .NET, PostgreSQL, MongoDB Platforms & tools: Azure, Shiny App, Power Query, R-Studio, Jira, MS-Office, Git, ERDPlus, Eclipse, DBeaver, Slate, ERP, ETL processes PROFESSIONAL EXPERIENCE

Graduate Student Analyst – Admissions University of New Haven, CT, USA Aug 2023-May 2024

• Utilized Slate and Ellucian to manage and process over 5000 student records, improving data consistency and accessibility by 30%.

• Designed an interactive Power BI dashboard, used Power Query for preprocessing data from slate to dynamically display visualizations of 10+ key metrics, enhancing data-driven decision-making and reducing response time by 50%.

• Identified trends & patterns among 1200+ applicants, predicting course demand with 85% accuracy, optimizing resource allocation by 25% and pinpointing key areas for marketing with a 40% increase in targeted outreach effectiveness.

• Automated creation of weekly reports in Excel, cutting manual effort by ~4 hours per week & increasing accuracy & timeliness by ~20%. Product Analyst Microsoft (via Infosys Ltd), Mysuru, India Jan 2021-Feb 2022

• Delivered solutions, production, and analytical support for global Microsoft contact centers using Genesys tools improving operational efficiency by 35% and reducing average handle time by 40%.

• Developed visualizations and analytical features for Genesys Interaction Analytics (GIA), an automated speech analytics capability on all recorded customer-agent interactions providing deep insights that improved contact center performance metrics by 25%.

• Leveraged SQL and Power BI for data analysis, enhancing decision-making and increasing operational efficiency by 5%.

• Resolved technical issues in collaboration with clients, ensuring greater than 99% service availability. Data Engineer Genesys (via Infosys Ltd), Mysuru, India Dec 2019-Dec 2020

• Worked on developing Genesys Latitude, a cloud-based debt recovery application using MySQL and .NET.

• Built data pipelines to transform raw data in blob storage to SQL server tables on Genesys cloud. ANALYTICS PROJECTS

Healthcare Trends - EDA

• Created visualizations in Power BI to analyze healthcare trends such as patient demographics, billing amounts, and test results, supporting strategic decision-making in operational efficiency and Healthcare improvement.

• Analyzed healthcare data to identify trends, revealing a 25% prevalence of Diabetes and Hypertension among the patient population, which directly informed strategic planning initiatives to optimize healthcare services in the community.

• Implemented logistic regression and random forest models to predict test results & analyze billing amounts, achieving a 33% accuracy for

“abnormal” test results finding no significant differences across insurance providers (t-tests) or admission types (ANOVA), guiding resource allocation and patient care strategies using R.

Analyzing COVID-19

• Discovered significant age & gender disparities, enhancing pandemic response, forecasted future COVID-19 metrics with 80% accuracy

• Performed Geospatial, & Comparative Analysis in Power BI, visualizing global and regional trends in cases, deaths, & vaccination rates. US Electricity and Natural gas Consumption Analysis

• Applied statistical methods to explore the correlation between population demographics and utility rates using R & Excel.

• Used regression & cluster analysis to dissect complex data, revealing critical insights into usage patterns & pricing strategies.

• Generated visualizations using Power BI, which highlighted regional trends and supported strategic decision-making.

• Emphasizing the need for targeted interventions, suggested energy policy adjustments which could potentially reduce costs by 12%. E-Commerce Data Management

• Engineered a relational DB for an e-commerce platform, detailing structures for product & transaction data management.

• Visualized entity relationships and database design using ERDPlus, aligning with industry standards for clarity & efficiency.

• Formulated and executed SQL schema creation, data entry, and complex queries with aggregate functions for data analysis.

• Initiated a strategic VIEW in SQL to highlight key sales metrics, supporting business intelligence efforts. Business Forecasting: NFL Ticketing & Sponsorship

• Conducted predictive analysis of NFL ticket sales, identifying key pricing strategies by seat level with a focus on demand forecasting for 2020 utilizing ARIMA models in R with >70% accuracy.

• Examined sponsorship effectiveness revealing the impact of team identity on fan loyalty, aiding sponsorship increasing ROI by 15%.

• Translated complex data into strategic insights for pricing and sponsorship, enhancing future business strategies and growth.

Contact this candidate