Data Manager

KAVITA SUTAR

Jersey City, NJ ***** 201-***-**** ************@*****.*** www.linkedin.com/in/kavita-sutar

OBJECTIVE:

Motivated and self-driven student from Pace University, New York. I have a strong inclination towards Data Analytics, Business intelligence. Experience in handling large datasets and in depth knowledge of relational databases. Seeking a career path where I can utilize my skills, which would help the organization to grow and further enhance my growth profile

EDUCATION

Pace University, Seidenberg School, New York

Master of Science (MS) in Information Systems

Relevant Coursework

● Database Programming (MySQL) ● Data Warehousing, Mining and Visualization ● Information Security/Control ●Big Data & Information Systems ● Database Design & Dev of Web ● Data Analysis for Decision Making ● IS project and Change Management ● IS planning and policy ● Data Modelling For Decision Making ● Introduction to Geographic Information Systems

TECHNICAL SKILLS

Languages: SQL, XML, HTML, PHP, R-Programming, Python

RDBMS/Data Bases: Oracle, Teradata, Vertica, SQL Server, My SQL, MS Access

Microsoft BI Tools: Informatica, Excel, QlikView, Tableau

IDE Tools: Visual Studio 2012/2010, SSDT, BIDS, MySQL Workbench, R-studio, Jupiter, DBvisualizer,

Teradata client, Toad

MDM tool: Informatica MDM

Other Tools: Hadoop(Pig, Hive),Spark, Tableau, Rapid Miner 7.3,Palisade software( Stat Tools 7.5), Excel for data analysis, MS Visio, Quality Center 9.0,Arcmap 10.3

WORK EXPERIENCE

Coty Inc., New York, NY June2018-Present Data Analyst

Project Description: Coty is multinational beauty company, which develops, manufactures, markets, and distributes fragrances, cosmetics, skin care, nail care, and both professional and retail hair care products. This project is about E-commerce grey market analysis to identity key online grey sellers.

Update internal main tracking file, combining sets of data from different sources and analyzing results.

Collect retail sales data from third parties and analyzing it to find gray market sellers for each luxury fragrances brand like Calvin Klein, Marc Jacobs, Gucci.

Use advanced excel to analyze data trends, pivot tables,v-lookups,charts,graphs etc.

Create Power Point Decks for global marketing quarterly meetings with each brand team.

Created Tableau dashboards as required for presentations.

Partner with internal and external teams to update quarterly distributor scanning report and conduct analysis on results.

Create reports for director, manager writing SQL queries using Access database.

Update broker price list analysis, as information comes from agency.

Additional and ad hoc data synthesis and analysis as necessary.

Technical Skills – SQL, MS Access, Advanced Excel, Power Point,Tableu.

Sirius XM Radio Inc., New York, NY

MDM Data Analyst Intern Jan 2018-May 2018

Project Description: Objective of this project is to improve the total processing time of MDM cycle. Maintain master data of party, device and vehicle by performing analytical activities. Perform root cause analysis to improve data quality.

Participated in the performance improvement of analyzing MDM logs to improve the total processing time for whole MDM cycle (time of completion)

Involved in projects that required analysis, cleansing, improving data quality for the master data elements using Informatica MDM

Involved with the analytic activities to ensure data completeness.

Participated in root cause analysis, including problem definition, investigation and developing correction and prevention processes.

Exposure in analyzing conceptual, logical and physical data models.

Prepared TDR (Technical design Report) and Data lineage document.

Maintained documents in sharepoint.

As part of the MDM team, participated in identifying the discrepancies of data that was inconsistent from the businesses. Once discrepancies had been identified and the analysis was completed, communicated to the hiring manager.

Technical Skills – Informatica, Informatica MDM, Informatica Power center, Oracle, TOAD, PL/SQL, Xcel

Sirius XM Radio Inc., New York, NY Sept 2017-Dec2017

Business Intelligence Intern

Project Description: Call Miner is customer case study project which analyze the customer calls to find out, what customers thinks about service and leverage this information to follow best strategies for sales and care calls and deliver best experience for customers.

Developed various mappings for an internal project (Call Miner) using Informatica Flat Files, Vertica, Teradata as sources and targets.

Used transformations such as lookup, expression, SQL, filter transformation as required.

Created sessions and generated workflows.

Configured Workflows with different connections used Teradata fast load utility to load Teradata tables.

Imported and Exported workflows as needed from Informatica.

Tested workflows using Workflow Monitor and debugged using session logs.

Created concurrent workflow and tested it using shell script.

Participated in the data analysis of inbound and outbound sales and care calls to ensure the data quality.

Wrote SQL queries for CALLMINER fact and dimension tables to find the trends in data.

Responsible to run SQL scripts daily to check data quality of CALLMINER and generated reports for manager.

Created executive dashboards and reports for CALLMINER project for business users and collogues.

Attended weekly meetings with team.

Technical Skills – Informatica Power center, Teradata Client, Vertica, Teradata, SQL, Excel,qlikview

Zima Technologies, Agoura Hills, CA

Business and Data Analyst Intern May 2017- Sept 2017

Project Description: Developed Use case for medical practitioner to identify patient population with chronic conditions in early stage.

Designed and developed a big data system to analyze and identify patient’s population on the shift from Low risk to High risk with Chronic Conditions.

Developed and prepared Use Case for client.

Worked with client and business partners to gather and translate business and system requirements.

Assisted data analysts to design UML model diagram (contribute 30% of the design)

Prepared and cleansed data records received from different sources to build the model

Imported and exported data into HDFS and Hive and Implemented dynamic/static partitions and bucketing concepts in Hive to group population in four groups low, medium, high and very high to identify the shift.

Technical Skills – SQL server, R-programming, Excel

ACADEMIC PROJECTS

Identifying NYC's Need for Nature-Based Education Sept 2017- Dec 2017

Collected, analyzed, cleaned data from various sources.

Used ArcMap 10.3 to develop map for New York City.

Created different layer for Schools, Park Facilities and Income per household.

Used selection by Location feature of ArcMap, selected schools with high risk for nature based education,.

Used Data Frames to compare schools with high risk with different boroughs of New York City.

Data Breach Application Jan 2017-May2017

This application generates report for Chief Information security Officer to detect Data Breach.

To detect Data Breach, used Edit Log file in Hadoop Distributed File System and used Hive and Python for developing the application.

Defect Tracking System Jan 2017-May2017

Developed user friendly interface for developers and testers to track the ‘defects’ encountered while developing a software

It has Admin, Tester, Developer modules and has better user account control for security and privacy.

Created using PHP and MySQL RDBMS on windows Platform with XAMPP.

Visualization of Seattle Bike Collision Data using Tableau Sept 2016-Dec 2016

Created executive dashboard using Tableau to visualize the bike accidents reported in Seattle city for a period from 2008-2016.

Audience of dashboard: Seattle Transportation Department.

Human Resources Data Analytics using Logistic Regression Model Sept 2016-Dec 2016

Analyzed 10,000 employee’s data using logistic Regression Model in Rapid Miner Studio 7.3 to predict which valuable employee will leave next.

Took Performance matric of accuracy and confusion matrix into consideration for meaningful insights.

CERTIFICATIONS AND TRAINING

R Programming Coursera

License number: JL49FNQSKF9F

Exploratory Data Analysis Coursera

Online course in Software Testing Certification in Software Testing (ASTQB Foundation Level 2015)

Training in Data Management and Business Intelligence using MS SQL server 2014

VOLUNTEER EXPERIENCE

ChickTech, NYC

ChickTech NYC offers high school girls in the New York City metropolitan area more than 60 hours of hands-on STEM curriculum and mentorship opportunities.

Member of Women In Technology

Contact this candidate