Data Analyst Manager

Suraj Ashok Patil

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

Stevens Institute of Technology, Hoboken, NJ

Master of Science in Information Systems, 3.75/4 May 2018

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

Bachelor of Engineering in Electronics and Telecommunication, 3.3/4 May 2015

Business/Data Analyst

S&P Global Platts, New York, New York February 2019 – Present

BUSINESS SIDE:

Interviewed key stakeholders from Business units like Sales, Marketing, Contract support, Finance etc. to identify business, functional and technical requirements for Salesforce platform

Satisfied ad-hoc analysis and metrics requirements from managers. Iteratively refine metrics by communicating with stakeholders and make sure metrics will help them improve business process

Created User stories and Tasks on Microsoft Azure(VSTS)based on the requirements along with the respective Product owners and prioritized based on business needs

Developed use-cases, test-scripts and documentation for User Acceptance testing (UAT) sessions to debug any errors and push workflows into production

Rendering client satisfaction by having constant interactions with the business stakeholders in understanding and catering to their technical specifications. Involved in Sprint planning sessions as part of Agile methodology and oversee activities in VSTS dashboard

DATA ANALYTICS SIDE:

Maintain the data quality of multiple databases in MySQL and validate the data to ensure accuracy in the output, generate descriptive statistics and extract insights

Saved 150 man-hours by writing reusable SQL queries used for data analysis and validation

Identified key data points and metrics, and developed queries to calculate the Monthly Recurring revenue for Platts products

Developed robust performance reports with critical KPI’s on several platforms, including Excel and Tableau by creating data extracts and scheduled weekly/monthly distribution of reports to stakeholders and analytics users

Developed and automated reporting for Monthly customer subscription renewals which accounts for more than 80% of Platts revenue

Automated Tableau report generation for the enterprise wide Analytics product users

Became the go-to person for colleagues who faced issues on reporting automation or data analysis. Continuously develop new skills to handle challenges from increasing data size

Improved runtime of existing SQL queries by 60% with maintaining code architecture to ensure smoothness and completeness of operations

Acted as a lead for various Data cleaning projects on Salesforce. Utilized SQL, Tableau and custom reports to create scenarios and defined the scope of data cleaning activities like de-duping on enterprise-wide production environment

Financial Transactions Data Analyst

Battea-Class Action Services, Stamford, CT Dec 2018-Feb 2019

Load, analyze and normalize trading data for 400+ clients using Oracle SQL Loader, Toad and ETL process

Deciphered and interpreted patterns and information in consolidated databases using data mining techniques to maximize settlement recoveries

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

Determine eligibility of trades in multi-million-dollar securities class action lawsuits by assessing data quality, detecting patterns, performing gap analysis, and identifying unrelated information

Provided trend and variance analysis by using visualizations on Tableau and identified causes for shifts in Metrics

Data Analyst/Consultant,

Cartesian, Inc. Somerset, NJ Aug 2018-Oct 2018

Automated daily ETL and reporting tasks using SQL, SSIS and tableau reducing 25% of the employee’s workload

Defined and implemented the AWS data pipeline to configure data loads from Sprint’s Data Warehouse to Amazon S3 and Amazon Redshift

Automated reports generation for the Revenue Assurance team at Sprint to track data inconsistencies using Alteryx

Collaborated with global teams to troubleshoot & resolve inconsistencies in wireless mobile data quality and reports

GAP analysis to find the root causes for revenue leakages worth $5 million for 6 million subscribers

Data/Business Analyst Intern

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

Designed ETL(SSIS) processes to develop jobs for extracting, transforming and loading data using workflow manager

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

Designed web scraping system using Python to pull HTML data and convert it to temporally sorted, tabular data

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:

o 30% increase in MWBE member registration

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

o Securing $500,000 grant from Citibank

Data Analyst

IdeaMagix, Mumbai, India Jan 2015-July 2016

Developed dashboards for data streams like Google AdWords, Facebook Ad Manager, Google DFA and twitter on Tableau to visualize KPI’s like Impressions, clicks, cost per view, cost per acquisition

Interpreted data and analyzed the results using statistical techniques and Excel skills like V-lookup’s, Macros, Pivot tables

Conducted various multivariate and A/B tests leading to 4% increase in leads generated, sales, revenue

Tracing cognitive markers over time Dec 2016

Drafted LTV projections and models for user acquisition tactics, game growth projections, user behavior and churn analysis

Designed dashboards in Tableau, developed data visualizations in the form of graphs, trend lines, patterns and maps in Tableau

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, data cleaning and normalization using python packages like numpy, pandas, sci-py, scikit-learn etc

Predict whether a client will be a defaulter Dec 2017

Trained the model using 6 months of historical data of 30000 clients using classification algorithms like the CART and neural networks in R to categorize the customers with respect to the amount of risk associated with each of them

Compared the predictive accuracy of probability for default clients of the two models to derive customer insights and proved the accuracy of neural networks to be 6.5% more than CART

Scrapped Customer reviews from Yelp.com using Python(NLP) May 2018

Related a restaurant with its contextual attributes. Example, restaurant is good for party or dinner

With data extraction and text mining, analyzed the text from the scrapped customer reviews on Yelp.com

These contexts give short information about the restaurant and the reason to visit the restaurant

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

Data mining/visualizations: Tableau, Power BI, Looker, Python, R programming(RStudio)

Tools: MS Office, MS Excel, Google Analytics, MS Visio, AWS, Microsoft SSIS, Alteryx, PostgreSQL, VBA

F1 – STEM OPT

STEM OPT valid until July 2021

Need H1B sponsorship for the 2021 term

EDUCATION

WORK EXPERIENCE

ACADEMIC PROJECTS

SKILLS

VISA STATUS

Contact this candidate