Data Tableau

CHAITALI PAWAR

857-***-**** Boston, MA adhkyf@r.postjobfree.com https://www.linkedin.com/in/chaitalipawar/

EDUCATION

Master of Science in Engineering Management (Concentration: Data Analytics) December 2020

Northeastern University, Boston, MA

Coursework: Database Design, Data Mining, Data Warehousing & Business Intelligence, Statistics, Data Visualization

Bachelor of Technology in Electronics May 2018

SNDT University, Mumbai, India GPA 3.8

TECHNICAL SKILLS

Business Intelligence: Tableau, Microsoft Power BI, Python, R Studio

Data Warehousing: Alteryx, Talend, ER Studio

Database modeling: Relational databases, NoSQL databases, Redshift (AWS)

Business Development: Salesforce, Microsoft office suite, Google suite

PROFESSIONAL EXPERIENCE

Business Operations Analyst, Wayfair. Boston (Data Analytics, Business development) January 2020 - June 2020

Consolidated data from SQL, tableau and Excel for Forward coverage analysis of top-performing stakeholders

Using Salesforce tracked and upgrade the business development programs of partner operations

Developed and monitored target metrics to increase revenue growth by 10%

Analyzed domestic & international inventory levels and created proposals for overall warehouse fulfillment

Implemented strategies to improve drop-ship performance by analyzing KPI’s like badging, turns, inventory level

Created Ad-hoc reports using multiple data sources to optimize sales, shipping time, warehouse lead time

Performed Biweekly reporting scorecards for team’s KPI’s to weekly and monthly cadence with stakeholders

Designed dashboards using tableau and Data Studio for ad-hoc analysis of performance of Suppliers

Developed SQL Scripts to identify supply/demand to improve warehouse level item eligibility

PROJECTS

Certified Tableau Analyst November 2020

Data Warehousing and BI analysis of Regional Schools [Talend, SQL, Power Bi, Tableau] December 2019

Integrated data from various relational databases, CSV, XML files using Talend to map data in end MySQL database.

Created Dimension model using dimension, facts, Causal and Role-Playing dimension into snowflake database

Optimized multiple ETL workflow in Talend to load the source of records in final data warehouse within minutes.

Developed interactive dashboards to analyze KPIs for over 20Mtransactions using SQL, Tableau and Power BI

Reverse Engineered chinook database using ER studio to obtain its physical ER model and sub models

Developed dimensional Model of “AdventureWorks” database, created sub models, DDL scripts (PostgreSQL, Oracle 18c, MySQL) and source to target mappings using ER studio & MS Excel to measure profit margin

Spotify tracks analysis [R Studio] December 2019

Preprocessed & wrangled the raw data for further feature engineering and analysis

Created effective visualization charts and dash to examine the popularity, danceability, tempo varying on artist, genre, duration of songs in library.

Database development and design for SME [Microsoft SQL Server, ER studio] April 2019

Designed a normalized database to eliminate redundancy of old CRM system to increase system efficiency

Created data model using ERD with SSMS to monitor sales, profit and other aspects of the business

Performed ETL operations with DDL features like views, triggers, stored procedures, indexes to maintain the transactional records and constant updating of the business

Analyzed data to predict causes for increase of heart disease and stroke [R studio] May 2019

Feature engineered important variables to preprocess data using (class, gmodels) R packages

Selected KNN models to identify attack/stroke chances with k=10 providing the best accuracy of 85.66 %

Agile Project Management [MS Excel, MS Project, SAFe] May 2019

Led the team of six, drafted project proposal– Business Case, Project Charter, Scope Statement using SAFe

Evaluated risks using quantitative analysis based on probability and impact on financial budget to develop mitigation strategies and presented to the senior leadership management

Contact this candidate