AYUSH SINGAL

214-***-****

ac4wjz@r.postjobfree.com

https:/www.linkedin.com/in/singal-ayush

Summary

Data Analyst with 5+ years of experience in interpreting and analyzing data for driving business solutions. Proficient knowledge in statistics, mathematics, and analytics.

Experience in Statistical Analysis and inference of Regression, Bagging, Boosting, Ensemble and hypothesis testing

Skilled in computational programming and machine learning with R [used ggplot2, dplyr, tidyverse] and SAS

Used advanced Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel functions

Proficient in design and development of various Dashboards, utilizing tools like Tableau, Power BI like bar graphs, scatter plots, pie-charts, Geographic’s and other making use of actions, local and global filters, cascading filters, context filters, Quick filters, parameters according to the end user requirements.

Experience

Analytics Practicum American Heart Association, Dallas Aug 2017- Dec- 2017

Responsibilities:

Predicted if the participants will donate in the AHA event or not and recommended an approach to turn non-donors into donors using R, SQL and Tableau

Used Segmentation Analysis and Logistic Regression Analysis to study the behavior of the participants in the events conducted

Recommended the financial implication and findings to AHA executives

Deftly designed dashboard which included bar charts, waterfall charts, score cards, Gantt charts, Bubble charts, Word maps, Geospatial visualizations, network charts etc to intuitively discern the insights

Environment: Tableau Server, R, SQL Server, Microsoft Office Suite (Word, Excel, Power Point)

Data Analyst Tata Consultancy Services Oct 2012 – July 2016

Client - Bank of America

Responsibilities:

Designed and prepared interactive and intuitive year end dashboards and reports using Tableau to show the test case performance by the engine this year

Developed “Automated Engine” using R-programing to identify discrepancies in the production and development codes using quality, cost, human resources and Technical debt as metrics (KPI), reduce the production cost by 30%

Analyzed data before and after changes in the operating server environment, to critically determine weaknesses, including errors in processes; and make recommendations to improve performance.

Used SQL queries for data-analysis and data extraction from database landscape and comprehend the data to perform sensitivity analysis

Performed Data profiling to examine the pattern of data coming from existing source systems for collecting the statistics and information about the data

Promoted to team leader, supervised and cross-trained 11 members and made them ready for projects in pipeline

Environment: R Studio, MySQL DB, MS Excel, Tableau

Data Analyst Intern Altima Systems Private Limited, India June 2011 – Dec 2011

Responsibilities:

Maintained inventory transactions in oracle and performed analysis to minimize payments defaults and reduced losses by 6%

Performed regression Analysis to see the factors causing payment defaults using Microsoft Excel

Created interactive dashboard and reports to analyze daily market sales and compared them with target sales

Assisted database team in revamping the database from scratch and created ETL workflows on the existed data

Environment: MS Excel, Tableau. Oracle

Technical Skills

Statistical Tool: R-Programming, Advanced Excel, SAS, STATA, Python, MATLAB

Reporting Tools: Tableau, PowerBI, MicroStrategy, QlikView

DBMS: SQL Server, MS Access, Oracle 10g

Big Data Analytics: Linux, Hadoop, MapReduce,

Hive, Sqoop, Flume, Pig

ETL Tools: SSIS, SSAS, Informatica, Alteryx

Programming: SQL, VB Scripts, C, Java

Education

M.S. in Business Analytics University of Texas, Dallas, GPA 3.7 Aug 2016 – Dec 2017

B.Tech in Electronics Maharshi Dayanand University, GPA 3.8 Aug 2008 – May 2012

Bachelor of Engineering in Electronics (Recipient of Dean’s Excellence Scholarship)

Independent Case studies

Marketing Analytics – JO-ANN Fabrics Using SAS

Using marketing communication and product items data, we propose a strategy to increase the revenue

Performed segmentation analysis using K-means clustering to target potential segment, analyzed the impact of price and communication channels on each segment using price elasticity and Marcomm valuation

Health Insurance Client – Humana (using SAS, Excel, Power Point)

Customer would like to explore, the impact of increasing awareness and number of visitors on the total sales. They also wanted to know which media vehicle drives the Units, awareness and Visitors and by how much

Identify customer risk profiles, model shopping behavior and potential customer segments

To analyze the impact awareness on units and visitors, we use (2SLS) Simultaneous equations

Tobit Analysis, to account for “Window”, since sales occurs only during “Window”

Marcom Analysis, for financial impact to see where company should invest the money.

The Hertz Corporation (Using SAS, Tableau Desktop, MySQL)

Client would like segment the customers according to their purchase preference and to predict the number of days vehicle rented

Identify the influential observation, check for collinearity and check for missing values

Optimally segment the customers according to their preference using latent class analysis

Estimate the number of days a vehicle rented using Poisson analysis

Result-If we target potential group of customers the probability to increase the number of days will increase by ~7%.

Academic Projects

Forecast Customer Purchase Behavior for Snacks Company using SAS programming and PowerBI

Performed Data Exploration, handled missing as well as dirty data and class imbalance problem

Deftly used SAS to run models like linear and logistic regression, panel effects to identify the variables affecting purchase

Demonstrate the findings and insights visually using power BI

Created Database for NGO using MS Access and MS SQL Server

Designed various user input forms with validation checks, Summary reports and Sub-reports using MS access

Stored the data at the backend in database by establishing connections between MS access and SQL server

Marketing Predictive Analytics Using SAS – VCA Animal Hospitals

Accomplished data cleaning, data pre-processing and clustering on the data from VCA Animal Hospital

Implemented statistical analysis including linear regression, simultaneous equation, price elasticity and Panel Data Analysis

Leadership Experience and Organizations

Intelligence Analytics Society, University of Texas – Dallas Sep 2016 – Oct 2017

YMCA Cricket Club- Captain, Faridabad Jun 2010 – May 2012

Contact this candidate