MADHAVI KADAM

903-***-**** adc3gl@r.postjobfree.com linkedin.com/in/madhavi-kadam https://profile-madhavi.herokuapp.com/ Education:

Master of Science, Information Management (Majors: Data Science), Syracuse University (CGPA: 3.69) May 2020 Relevant Courses: Business Analytics, Data Warehouse, Data Analytics, Information Visualization, Systems Analysis, Data Science Bachelor of Engineering, Electronics, University of Mumbai, India May 2016 Relevant Course: Database Administration, Operating System, Cloud Management, Project Management, Risk Management Professional Experience:

Business Data Analyst Intern City of Syracuse with iConsult Jun 2019 – Dec 2019

• Collaborated with ‘City of Syracuse’ finance team, gathered requirements to improve current financial operations of organization

• Collected, cleaned and aggregated data using SQL joins and carried out analysis to allocate funds to the desired department

• Developed an interactive dashboard using Power BI for senior management to monitor KPI’s in real-time

• Recommended changes to the C-Suite which improved the fund allocation efficiency by 30% and reduced variance by 9% Data Analyst Aryan Pumps and Enviro Solutions Pvt. Ltd., India Jan 2017 – Feb 2018

• Created dashboards using Qlik View BI tool by visualizing data from pump sensors to find sensors proficiency of performance

• Built pivot tables, gauge chart, distribution plots to identify defects in suction speed, fuel level and ignition frequency of motors

• Provided KPI analyses for performance verses target of sensors to boost efficiency of machines to 85%; made reports in MS Excel

• Collaborated with team using JIRA software for tracking project development, bug and issue tracking, project management Academic Projects:

Data Warehouse, Online-Retail Database Sept 2019 – Dec 2019

• Designed the ETL pipeline to aggregate data from the source database, performed data collection to data warehouse using SSIS

• Analysed business requirements and designed a database for online departmental retail and online movie rental company

• Created complete star schema including dimension and fact tables by importing and exporting data using MS SQL and Visual studio

• Extracted data from DWH to SSRS; created ad-hoc reports, developed data models and data relationships for optimization Information Visualization, Superstore Dataset Sept 2019 – Oct 2019

• Developed interactive dashboards in Tableau on superstore data to analyse profit based on state, category, year, customer

• Visualized the dataset by creating impactful map charts, trend line graph, bar graphs to identify the profit vs loss trends

• Proposed methods by identifying KPI’s to increase the profits in every year based on categories and states

• Presented MS Powerpoint to make poster presentation and Tableau Server to present the visualization to the class Data Analytics, Airline Satisfaction Survey Dataset Sept 2018 – Dec 2018

• Performed data wrangling, summarised the data using descriptive statistics on a structured dataset having 120k observations in R

• Created heatmap, rule plot, density plot and co-relation matrix visualizations to find factors affection customer satisfaction

• Presented insights solutions to the executives using MS PowerPoint which improved customer satisfaction by 30% Data Science, Mnist Dataset Mar 2019 – Apr 2019

• Implemented Naïve Bayes, K-Nearest Neighbor and SVM to train data for better handwritten character recognition using Python

• Pre-processed the pixel values of the data containing 280k observations by converting them into factor values

• Increased the accuracy of data by performing Bagging and Boosting and reduced training time using Principle Component Analysis Business Analytics, Human Resource Dashboard Feb 2019 – Mar 2019

• Proposed a solution to improve system efficiency to improve the hiring process and retain the valuable employees

• Created visually impactful dashboard in MS Excel for data reporting using VLOOKUP, power pivot and pivot reporting

• Extracted, analysed, interpreted data to identify key metrics and transform raw data into an actionable information Professional Skills:

Data Analysis: Tableau, Power BI, Qlik Sense, Qlik View, Google Analytics, Adobe Analytics, Looker, Python, Jupyter Notebook Data Sciences: RStudio, MS SQL Server, T-SQL, Shiny Apps, SSIS, SSRS, SSAS, HiveQL, NoSQL, Hadoop Apps/Language: Advanced MS Excel, MS Office Suite, MS Access, G Suite, MS Visio, Adobe Illustrator, Java, Ruby on Rails, HTML5 Technologies: AWS, VMware, Cloud Security, Maintenance, Management, SAP ABAP, SAP ERP Business Analytics: Agile Software development, UML Diagrams, SDLC Standards, GAP Analysis, Cost benefit analysis, SWOT analysis Leadership and Volunteer:

Member of Data Science Club Syracuse University

• Collaborated with other members of the Data Science Club to solve problems and gain meaningful insights by providing a platform in data science and data analysis

Head of Publicity Information Technology Student Association

• Coordinated with department managers to set up various inter-college events and led a team to market the events across the state

• Increased sponsorship by 30% for events held in college by pitching all the events and how sponsors would profit