Suraj Ashok Patil

** ********* ******, *** *, Jersey City, New Jersey, 07307 +1-551-***-**** ac6qpz@r.postjobfree.com

EDUCATION

Stevens Institute of Technology, Hoboken, NJ May 2018

Master of Science in Information Systems, 3.75/4

Mumbai University, Don Bosco Institute of Technology, Mumbai, India May 2015

Bachelor of Engineering in Electronics and Telecommunication, 3.3/4

WORK EXPERIENCE

Data Analyst, Harlem Commonwealth Council, New York June 2017-Dec 2017

Designed ETL(SSIS) processes to develop jobs for extracting, transforming and loading data from heterogeneous sources

Optimized queries up to 40% by developing and enhancing SQL modules for data extraction

Reduced manual efforts for data retrieval to 40% by coding and managing SQL stored procedures, functions and views

Optimized and tuned database up to 30% by creating clustered and non-clustered indexes

Performed deep-dive analysis of Minority/Women Business Enterprise (MWBE) data through SQL and Tableau/Power BI to enable comparative insights among business domains. Perform market assessment and comparative analysis to create process documentation. These contributions led to:

o30% increase in MWBE member registration

o$100,000 revenue increase over 7-month period

oSecuring $500,000 grant from Citibank

Data Analyst, IdeaMagix, Mumbai, India Jan 2015-July 2016

Accurately developed and scheduled ad-hoc reporting. Partnered with Technical, finance, legal and delivery teams

Drove 4% improvement in target KPI’s through the development of daily/weekly/monthly reporting for order data

Improved the customer satisfaction through effective data management (collection/modeling/report generation) to reduce related escalations to 0 within 7 months

Analyzed a consumer panel of 15,000 subscribers, defined by A/B testing, and identified KPIs for customer acquisition, retention and loyalty

ACADEMIC PROJECTS

Deadly roads of NYC May 2018

Performed data analysis on NYPD motor vehicle collisions data from 2016 to 2018 and created a Tableau dashboards

Performed data cleaning and developed modules for efficient visualizations using SQL scripts

Visualized the results, identified trends and patterns and analyzed that around 40% of the collisions occurred due to traffic violations

Predictive Analytics for a Bank (Using Python and machine learning) May 2017

Applied classification techniques like CART and Random forest and regression analysis to predict major factors responsible for customer churning rate & customer lifetime value for bank

Conducted data analysis using python packages like numpy, pandas, matplotlib

Process workflow redesign of a Transportation System

Analyzed the current process shortcomings using AS-IS process tool

Proposed a new process to overcome the shortcoming in the existing process using TO-BE process tool

Analyzed the cost benefits and the advantages of the system using Six Sigma methodology

Predict whether a Client will be a defaulter (data mining using R) Dec 2017

Trained the model using exploratory data analysis using ANOVA, clustering and neural networks in R to categorize the customers with respect to the amount of risk associated with each of them

Conducted hypothesis tests, compared the predictive accuracy of probability for default clients to derive customer insight

Data Warehousing and BI Design of Bimbo Bakery May 2017

Developed detailed and high-level bus matrix, as well as opportunity and Priority Matrices

Created aggregation based on dimensions such as location, time and item category

Maneuvered star and snowflake schema with a fact table of sales and different dimension tables

SKILLS

Databases: SQL Server, MySQL (Stanford University certified), MS Access, Oracle

Data mining/visualizations: Tableau, Power BI, MicroStrategy, Python, R programming(RStudio), SPSS Modeler

Tools: MS Office, Google Analytics, MS SharePoint, MS Visio, AWS, Microsoft SQL Server Management Studio, Alteryx, VBA

Contact this candidate