SANKET DEEPAK VICHARE

adcmks@r.postjobfree.com 315-***-**** https://linkedin.com/in/sanket-vichare/

EDUCATION

M.S. in Information Management C.A.S. in Data Science (3.82/4.00), Syracuse University May 2020 Coursework: Data Science, Information Visualization, Database Management, Cloud Management, Risk Management B.E. in Computer Engineering (3.50/4.00), University of Mumbai Jun 2016 Coursework: Data Warehousing and Mining, Distributed Databases, Applied Mathematics and Statistics TECHNICAL SKILLS

Database: SQL Server Management Studio, MySQL, MS Visual Studio (SSDT), Oracle Database 11g, MS Access Data Analysis: Decision Trees, Random Forests, Naive Bayes, KNN, K Means Clustering, Apriori, Regression Analysis Languages: Python (Pandas, NumPy, Scikit-learn, Seaborn, Matplotlib), R, SQL, VBA script, Java BI Tools: SAS Enterprise Guide, Tableau, MS Power BI, Adobe Illustrator, Advanced Excel, Google Analytics PROFESSIONAL EXPERIENCE

Data Analyst Intern, Excellus BCBS, Syracuse, USA Jun 2019-Present

• Developed an efficient healthcare data analyzer tool in Power BI for a set of more than 120,000 medical records

• Performed Data Munging using Proc SQL queries on the clinical member data by extracting it from the EDW in SAS

• Designed interactive dashboards and powerful visualizations in Power BI to find trends in the reported HEDIS rates

• Analyzed the gap data in Power BI to identify that around 28% of health measures were performing lower than expected

• Implemented a centralized specification dashboard to minimize the time for searching the NCQA Measure Specs by 50%

• Revamped the Rate Analysis and Reporting System for the Quality Measurement team by establishing KPIs with slicers to proactively calculate the compliant health plan members required to reach a 95th percentile benchmark value Application Development Analyst, Accenture Solutions, Bangalore, India Aug 2016-Apr 2018

• Automated an SSIS package execution using SQL server which saved 60 minutes per week of manual work for the client

• Used ETL pipelines (SSIS) for extracting, cleaning, transforming, and loading data into the company’s data warehouse

• Built Tableau reports to help the client visualize how investors annually increased by about 10% in the European countries

• Formulated SQL scripts to load new data and perform exploratory data analysis in the production and test environments

• Mentored a team of 5 new recruits to cross-train them in Tableau and numerous technical aspects of the project

• Collaborated with 6 Business Managers and the Project Manager to provide effort estimations of the client change requests

• Reduced and eliminated critical incident tickets by 80% through root-cause analysis to ensure the SLA compliance ACADEMIC PROJECTS

Data Analysis of Customer Satisfaction on Airlines R, Tableau Jan 2019-May 2019

• Detected and cleaned inaccurate records from the feedback dataset of 200,000 people to analyze their satisfaction levels

• Attained an accuracy of 85% on the test dataset using SVM, Association Rules and Regression Analysis techniques in R

• Harnessed Tableau to infer that the elderly gave 54% of low ratings and presented actionable insights to improve them Syracuse Walmart Data Warehouse Visual Studio(SSDT), SQL Server, Power BI Sep 2019-Dec 2019

• Created the DDS enterprise bus architecture of conformed dimensions for Syracuse Walmart to gain insights across two business processes: sales reporting and inventory analysis

• Produced source to target mappings and ETL designs for integration of relevant data streams into the data warehouse

• Generated BI Reports and produced visualizations in Power BI to help in better decision making for senior leadership Data Visualization of Global Suicide Rates R, Power BI Aug 2019-Dec 2019

• Implemented Linear Modeling to help discover a positive correlation between a country’s GDP and its suicide rate

• Visualized the data in R to infer that ages 35-54 committed most suicides in top 5 countries with highest suicide count

• Illustrated the data in Power BI to indicate that the global suicide rate for men was about 3.2% higher than the women LEADERSHIP

• Led a team of 25+ members as the Vice President of the E-Cell committee to motivate students about entrepreneurship