CHINMAY AROLKAR

adkfk8@r.postjobfree.com www.linkedin.com/in/chinmay-arolkar 857-***-****

* ***** ** ********** ** a Data Analyst with diverse skill set and passion for building optimized analytic solutions

EDUCATION

Northeastern University, Boston, MA Dec 2020

Master of Science in Information Systems

Mumbai University, Mumbai, India May 2016

Bachelor of Engineering in Electronics

SKILLS

Programming languages: SQL, Python, Cypher, Java, Shell Script, Power Shell

Database platforms: MySQL, Microsoft SQL Server, PostgreSQL, SPSS, Oracle, Talend, ER Studio, Neo4j, MongoDB, Hadoop

Visualization/BA tools: Power BI, Tableau, Alteryx

Microsoft Office Suite: Microsoft Excel (V-Lookup, Macros, Pivot Tables), Microsoft Word, Microsoft PowerPoint

Versioning and other tools: Git, Bitbucket, JIRA

PROFESSIONAL EXPERIENCE

Boehringer Ingelheim, Ridgefield, US Jan 2020-Jul 2020

Data Analyst Co-op: Analytics and Insights Information Management

Created ad-hoc and standard reports by utilizing Oracle SQL Server, Excel & Tableau Server, increasing team efficiency by 20%

Led OptumCare project to provide data according to HCO to HCP mapping, improving existing reporting process by 60%

Collaborated with multiple teams across organization to propose solutions to meet business and technology needs

Performed QA, user acceptance & AB testing on multiple platforms within organization, reducing 50% errors before live date

Documented multiple reports, processes, and databases to create step by step guidance for new users within organization

Presented data and conclusions to team to improve benchmarking strategies and operations by converting it to insights

Publicis Media, Mumbai, India Dec 2017-Jun 2018

Data Analyst: Biddable Media

Utilized SPSS to perform co-relation by generating R-values to analyze and discover relationship between attributes of SEM data

Optimized digital marketing platforms by deciding SEM (Search Engine Marketing) strategies and allocated given budget

Created campaigns with ads, keywords on platforms such as Google, Bing, Twitter, Facebook, increasing revenue by 12%

Developed weekly, bi-weekly, monthly, and quarterly reports using Excel to provide insights on performance of keywords & ads

Generated dashboards using DAX in Power BI and multiple panels to provide recommendations, increasing efficiency by 18%

REMI Elektrotechnik Limited, Mumbai, India Jun 2017-Nov 2017

Data Analyst: Volunteer

Exported data to Excel using complex SQL queries further used for daily reporting

Documented medical equipment’s inventory to develop reports in Excel using V-Lookups, Pivot Tables, Filters & Power queries

Managed regular team meetings and suggested changes in routine and ad-hoc tasks to achieve objectives

Executed calculated columns, measure query’s in Power BI to create dashboards for performance tracking to business teams

PROJECTS

Covid-19 Data Analysis using Graph Database Sep 2020-Dec 2020

Performed extensive data wrangling, cleaning, profiling using Python to increase data quality by removing null values & errors

Ingested data in Neo4j for creating nodes, stored properties, and relationships to show mappings of cases to lowest granularity

Demonstrated Python visualizations using graph, histogram, bar & world map to showcase effect of mask & population on cases

Composed automated queries to get technical metadata from Neo4j & test cases to identify mapping & possible issues in model

Alzheimer’s Detection Jul 2019-Aug 2019

Analyzed large data set, including cleaning data, finding relationship between demented and non-demented groups using graphs

Designed Support Vector Machine, Decision Tree, Random Forest, K-Means Cluster and Naïve Bayes models with 91.11 % accuracy

Data Architecture, Warehouse and Visualization Using Talend, Power BI and Tableau Feb 2019-Apr 2019

Integrated raw data in Talend from data servers such as - Oracle, MySQL, SQL Server, and Postgres

Designed a master job including 34 models and performed tuning, helping to reduce time taken for master job by 20 minutes

Performed visualizations in Tableau & Power BI to answer business problems including Hierarchy of products, Top sales brands

Husky Sports Management System using SQL Oct 2018-Dec 2018

Produced detailed analysis of Northeastern University’s sports data by applying normalization & reverse engineering data model

Created procedures, views, and transaction to facilitate the CRUD operations of athlete performance to view in score board

Contact this candidate