Data Analyst Management

Abhijeet Mali Cell: 315-***-****

LinkedIn - www.linkedin.com/in/abhijeetmali Email: *********@*****.*** EDUCATION

Master of Science, Information Management, and Certificate of Advance Study in Data Science – GPA: 3.73 Syracuse University, School of information Studies, Syracuse, NY May 2016 Course Work: Data Warehousing, Applied Data Science, Information Visualization, Managing Information Systems Project, Information System Analysis, Business Analytics, Data Admin Concepts and Database Management Bachelor of Engineering, Electronics and Telecommunication University of Pune, Sinhgad Institute of Technology, Pune, India May 2012 SKILL SET

Technical Skills

Power BI, Tableau, Qlik Sense, R, T-SQL, ETL, SSIS, SSAS, SSRS, SQL Server, Microsoft Access, Power Pivot, Google Analytics, A/B Testing, Microsoft Excel, MS Project, MS Visio, Agile Scrum Functional Skills

Data Modeling/Profiling/Analysis/Reporting, Dimensional Modelling, Web Analytics, Project Management WORK EXPERIENCE

Data Analyst, Nordic Consulting, Madison, WI Jun 2017 – Present

+ Designed KPI’s to identify high & low performing clients to provide tailored solutions to sustain or improve performance

+ Developed interactive dashboards with dynamic filters for slicing & dicing in Tableau & Power BI to support decision making

+ Trained business users on the dashboards in Tableau & Power BI & provided continued support for bug fixes & enhancements

+ Automated reporting for utilization metrics using SSIS & SQL to save more than 40 hours of monthly effort

+ Developed SQL queries using stored procedures, CTE’s, temporary table to support Tableau, Qlik & Power BI dashboards

+ Performed regression analysis & correlation analysis in R to identify causal relationship between the columns of data Data Analyst Intern, M.I.N.D. Lab, Syracuse, NY May 2015 – Aug 2015

+ Validated data using data cleaning, manipulation, and quality control techniques to organize multichannel data efficiently

+ Analyzed existing data to identify patterns, relationships and impact of different advertisements on 50K individuals

+ Assisted in design and development of database solution using SQL and MS Access to organize the data of experiments Data Analyst, Krishi Jeewan, Junnar, India Jun 2013 – May 2014

+ Engaged in requirements elicitation/documentation/analysis/validation & UAT to verify requirements fulfillment

+ Assisted in inventory level optimization by developing a strategy to reduce product inventory by 15% with no effect on sales

+ Developed weekly financial, sales and customer insight reports using SQL & Excel to facilitate strategic decision making Business Analyst, Krushnabagh, Junnar, India Jul 2012 – May 2013

+ Illustrated a business case to highlight the need to expand the business and forecasted the operational contributing factors

+ Recommended business strategy to improve operational efficiency by 20% by analyzing historical business data and reports

+ Identified, mitigated, transferred and accepted the risks due to weather and market conditions to minimize losses PROJECT EXPERIENCE

Data Scientist, [Complete Python & Machine Learning Bootcamp] – Udemy Dec 2017 - Present

+ Used basic concepts such as dictionaries, lists, & functions to develop Tic Tac Toe and Black Jack games in python

+ Performed statistical analysis using Numpy, Pandas and developed data visualizations using Seaborn, Plotly and Matplotlib

+ Implemented machine learning algorithms such as Random Forests, SVM & Logistic Regression to solve complex problems Business Intelligence Developer, [Data Warehouse] – NopCommerce Jan 2016 – May 2016

+ Analyzed requirements to assess viability of business processes to be incorporated in designing data marts for a warehouse

+ Extracted data from multiple disparate data sources, transformed and loaded into dimensional model of DW for analysis

+ Developed ROLAP schema in SQL server, created MOLAP cube from star schema using SSAS to analyze business process

+ Analyzed data to generate reports and dashboard using SQL, SSRS, Power BI to monitor KPIs and improve e-commerce operations Data Analyst, [Applied Data Science] – Mass Shootings Jan 2016 - May 2016

+ Explored USA Mass Shooting dataset to identify missing data and applied pre-processing technique to clean the data in R

+ Developed predictive model using SVM to predict mental illness of the shooter & validated result using confusion matrix in R

+ Analyzed data for Associative Rules of mining to identify association between multiple columns of data with 85% confidence

+ Visualized data for reporting using ggplot2, googleVis in R and presented the findings using multidimensional visualizations Strategy Analyst, [Digital Marketing] – Martin. J. Whitman School of Management Jan 2015 – May 2015

+ Interpreted data to identify KPIs and different improvement opportunities using MS Excel, Tableau and Google Analytics

+ Evaluated web data using descriptive statistics, regressions and time series to understand applicant’s navigation behavior

+ Validated hypothesis by analyzing A/B tests and proposed effective key words and marketing strategy to target potential students LEADERSHIP EXPERIENCE & ACCOMPLISHMENTS

+ Certified Professional Scrum Master I (PSM I) from scrum.org

+ Mentored and educated first year master students on the process of course selection and career paths

Contact this candidate