Data Analyst
Resume:
AYUSH SINGAL
***************@*****.***
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