Shivali Naik

315-***-**** ac56fo@r.postjobfree.com https://www.linkedin.com/in/shivalinaik/ https://github.com/shivalinaik EDUCATION

M.S., Information Management, Syracuse University, NY (Certification in Data Science) May 2018 (GPA 3.9) B.E., Computer Engineering, University of Mumbai, India May 2015 (GPA 3.5) PROFESSIONAL EXPERIENCE

Data Intern, Syracuse University, NY June 2018 - Present

• Utilized Salesforce for analysis, reporting and documenting of data to better understand student’s usage pattern year wise

• Migrated data from database to data warehouse and performed Business Intelligence on star schema structure using MS SQL

• Presented graphically usage patterns using Tableau desktop on user demographics to development and external stakeholders Quality Assurance Intern, CBS Interactive, CA June 2017 - Dec 2017

• Identified data integrity and quality issues by querying in Fiddler and verified the source to target mapping of data

• Documented business requirements in stakeholder meetings for SDLC and delivered improved integration solutions to engineers

• Detected faults in web/mobile application prototypes on Invision and suggested changes for web-nav to meet design specifications

• Translated business requirements into process flows by developing user stories in JIRA and used emulator for testing products

• Visualized graphically web traffic using Google Analytics and recommended changes for better UI/UX for specific ages Associate Software Engineer, Tech Mahindra Ltd, India Dec 2015 - June 2016

• Consulted on product KPI using data analysis report and ensured high revenue from websites by performing A/B testing

• Developed process diagrams in Confirmiq based on stakeholder meetings, to envision CRM product development ACADEMIC PROJECTS

Data Visualization - Sentiment Analysis of Twitter Post Aug 2016 - Dec 2017

• Performed US Airlines Sentiment Analysis on 15000 rows to quantify user feedbacks for top 5 US airlines using R

• Analyzed data to gain insight, built statistical models to support decision making using kMeans, correlation and regression

• Visualized structured and unstructured data in R and Illustrator to develop spider chart, word cloud and dot density map SQL and PLSQL - Database Management Sell and Buy Aug 2016 - Dec 2017

• Developed ‘Online Trading’ database using SQL server, access and Visio along with Access for front end data entry

• Database could be queried by buyer, seller and admin to gain reports and perform specific buy and sell operation

• Initialized trigger to update the product table based on the buyer and seller requirement Business Intelligence - Data Warehouse Jan 2018 - May 2018

• Developed High level dimensional model and detailed dimensional model for performing analysis based on star schema

• Staged the data in MS Server by understanding the source data and verified if the model solves the business problem

• Loaded the stage data to data warehouse by migrating the fact and dimension tables and used SAS for reporting System Analysis - myFico Financial Aug 2016 - Dec 2017

• Performed Industry Analysis on myFico to perform benefit validation of system for online lending and medical rewards

• Developed use cases, ERD, DFD, activity, swimlane and system architecture of myFico to better understand the product Risk Compliance and Management - M.I.N.D Labs Jan 2017 - May 2017

• Audited and identified risk in M.I.N.D labs risk cycle predicting 18% process improvement in instrument functioning in 6 months

• Assisted in recommendations based on independent judgment of corrective action and suggested improvements to operations iSchool EMPLOYMENT/ LEADERSHIP

Faculty Assistant, Project Management & Cloud Management Course, Syracuse University Aug 2017 - May 2018

• Configured lab settings and documentation and acted as troubleshoot support to about 100 students in lab

• Tested volatile labs such as AWS, VMware, GCP, Docker, IBM, Azure and documented lab steps and troubleshooted queries Secretary at Society of Women Engineers (SWE), Syracuse University Aug 2016 - May 2018

• Anchored 5 events at SWE regional conference (Syr) by introducing guest speakers and organized networking games for 500 people

• Organized group events by entering into agreements and contracts with agencies on behalf of student organization ACHIEVEMENTS

• Won second rank for VFFA at Compete CNY, the regional pitch qualifier for the New York State Business Plan Competition

• Conceptualized a personalized TV Guide mobile application and created Life of an intern video at CBS Interactive Internship

• Won second rank in entry level technical training program which had 1000 newly hired employees of TechMahindra SKILLS

R SQL PLSQL Access Google Analytics Salesforce Tableau Illustrator Visio Fiddler Jira SPSS & SAS Keynote

Contact this candidate