Data Analysis, Business Intelligence, Business Analysis, Python, R

SNEHAL SANJAY GHATPANDE

********@***.*** 315-***-**** www.linkedin.com/in/ghatpandesnehal

EDUCATION

Master of Science in Information Management, Syracuse University, GPA: 4.0 August 2019 – May 2021

Coursework: Data Science, Data Analysis and Decision Making, Business Analytics, Data Analytics, Managing

Information Systems Projects, Data Administration Concepts and Database Management

B. Engineering in Information Technology, Cummins College, India, GPA: 3.5 July 2013 – May 2017

Coursework: Machine Learning, Advanced Database Management Systems, Internet of Things, Cloud Computing,

Information Storage and Retrieval, Software Modelling and Design, Operation System, Computer Networks, BI

PROFESSIONAL EXPERIENCE

SAP BI Consultant, Accenture, Pune, India September 2017 – June 2019

Worked in AMS to efficiently solve problems related to report and data by using RCA and ensuring that SLAs are met

Developed complete BW flows according to business requirements through data modelling

Experienced in ETL from multiple source systems and SAP R/3 systems using LO extract structures

Designed queries for reporting using BEX Query Designer that helped business analyze the data in BEX Analyzer

Migrated data flows from 3.x to 7.x and the database to SAP HANA which improved the data load speed by 56%

Brought about 70% optimization of data loads by SQL performance tuning in BI transformation and field routines

Mentored & trained new resources that joined the project on areas such as data reporting and handling issues

Project Intern at Persistent Systems, Pune, India June 2016 – May 2017

Developed a system to set up a cluster of a server and multiple clients using Hadoop

Collaborated to apply LFSR algorithm to the data being loaded and transferred to encrypt it and provide security to it

Stored the data to the cloud service provider upon its encryption

Leveraged SHA algorithm to make sure that the integrity of the file is maintained

ACADEMIC PROJECTS

Data Analysis on Customer Retention System in Airline Industry August 2019 – December 2019

Conducted initial cleaning and preprocessing on survey dataset of over 130,000 customer responses

Performed statistical and data analysis to identify key factors in flight patterns for insight generation

Built linear regression models using R to analyze links between customer information and customer survey results

Recommended business strategies to leverage customer satisfaction improvements for increased revenue and profit

Healthcare Database Management System August 2019 – December 2019

Constructed an ER model to implement business requirements using MS Visio and populated tables using MS SQL

Implemented database applications and ad-hoc reports in MS Access to keep a track of patient records

Developed queries in SQL to generate reports to provide an abstraction layer for the user’s easier access

Project Management - City of Syracuse Mobile App August 2019 – December 2019

Gathered requirements for developing and integrating a Syracuse City mobile app with the existing Cityworks system

Harnessed information on different tasks and developed a work-breakdown structure and designed a project charter

Managed the allocated budget effectively and generated a final executive report with all deliverables

Twitter Sentiment Analysis Project January 2017 – May 2017

Utilized Twitter API in Java to extract tweets from the Twitter website and display the tweets to the Eclipse console

Used queries to store the data extracted in the back-end MongoDB database

Performed clustering using k-means, agglomerative hierarchical, mean-shift algorithms on the data using Weka

SKILLS

Project Management: Agile, Scrum, SDLC, Project Charter, Case Analysis, Gantt Chart, SharePoint, WBS

Database Management: MySQL, SQL, MongoDB, MS SQL

Enterprise Applications: MS Project, MS Visio, MS Access, MS PowerPoint, MS Word, MS Excel

Programming Languages: R, Python, SAP ABAP, C++, C, JavaScript

Software: Jupyter, R Studio, Tableau, SAP HANA Studio, Weka, Hadoop, Eclipse, SAP BO Analysis for Office, BEX Analyzer, BEX Query Designer, Cisco Packet Tracer, MS Visual Studio, MS Azure

Soft Skills: Team player, strong communication skills, time management, critical thinking, flexibility

LEADERSHIP SKILLS

Organized cultural events for college students and faculty as the Cultural events head June 2015 – March 2017

Conducted technical events by engaging students in workshops and coding activities June 2015 – March 2017

Advertised technical events at colleges across Pune to encourage student participation March 2014- March 2017

Contact this candidate