SATYAM SINGH

Mclean, Virginia

469-***-****,addjmy@r.postjobfree.com

www.linkedin.com/in/satyamsingh30

Self Motivated problem solver and a quick

learner with three years of experience working as

a Data and Product Analyst. Data enthusiast,

proficient in statistical modeling, data science

and visualization with a drive to enable data

driven decisions.

Summary

Academic Projects

Consumer behavior perception using Text Mining (Hadoop, Pyspark) Worked on text mining using big data modelling techniques, involving PySpark and Hive to classify half million reviews of customers and also understood consumer behavior and product perception.

Credit Risk and Audit Score Prediction (Python, SQL) Designed a regression and classification model to predict the credit risk and audit score, calculated best parameters for Linear SVM and SVM with Kernel trick, logistic, KNN using grid search and cross validation and improved score with the help of gradient boosting and AdaBoost.

Education

THE UNIVERSITY OF TEXAS AT DALLAS

M.S in Business Analytics - Data Science

December 2019, Dallas,Texas

B.Tech in Computer Science

June 2016, Noida, India

JAYPEE INSTITUTE OF INFORMATION TECHNOLOGY

Programming Languages: R (ggplot2, tidyverse,

dplyr, data.table, ISLR, caret), Python (pandas,

numpy, matlplotlib, Scikit-Learn, Scipy), SQL,

SAS.

Software: MS Excel(Pivot Tables, Vlookup,

Solver), Big Data (Hadoop, HDFS, Hive, Pyspark),

Tableau, Adobe Analytics, Git, Jupyter Notebook

Database: MySQL, MS SQL Server, AWS Redshift

Machine learning : Linear Regression,

Other: TCP/IP Networking, Linux Administration

and troubleshooting

Logistic, KNN, K Means, Ridge, Lasso, SVM,

Random Forests, XG Boost, Neural Network

Skillset

Business Analytics with R

Statistics and Data Analysis

Econometrics and Time series Analysis

Machine Learning

Prescriptive Analytics

Database Analytics

Spreadsheet Modeling and Analytics

Predictive Analytics using SAS

Marketing Web Analytics

Coursework

Professional Experience

HILTON

Build predictive model using python (Logistic Regression) to predict the Hilton Honors signup Classified text reviews from Data Lake using NLP technique (Topic Modeling) to understand Analyzed product performance trend, created dashboards in Adobe Analytics and presented insights to stakeholders.

Performed analysis of digital data sets and developed hypothesis for A/B testing. rate and understand the key drivers in the booking funnel customer feedback and created dashboards in Tableau to visualize it. Analytics Intern

June 2019-December 2019, Dallas, Texas

WIPRO

Data Analyst

August 2016-July 2018, Hyderabad, India

Implemented Six Sigma on the legacy system using Statistical Modeling by collecting and analyzing data and deriving insights using R and Excel.

Used SSIS to perform ETL functions and scheduled refreshes on databases. Used Python to perform complex ETL operations and data cleansing on the servers Designed requirements specification, developed the backend and maintained the module (testing, pre- release and post release)

Evaluated the database reporting needs and formulated them into powerful SQL queries to extract data and compile it into meaningful reports.

Consolidated and standardized 20 reports into Tableau dashboards consisting of numerous KPIs and product information of ~$20M SMS 800 system to increase market penetration. Created macros and used existing macros to develop SAS programs for clinical data analysis Intern

Feb 2016-June 2016, Noida, India

Migrated data from 30+ Excel backend data to SQL table achieving 40% efficiency by reducing 5 days of manual intervention of cleaning and structuring the data. Developed SQL queries to retrieve data from the database using JDBC improving efficiency by 10%. Tableau Desktop Specialist

Python for Data Science

Big Data Fundamentals via Pyspark

Certifications

Remediating scripts and building reports by leveraging amazon redshift data to support Hilton- Amex cobranded credit cards acquisition reporting and performance analytics Performing ad-hoc analysis to support leadership teams with data consultation, data gathering and data analysis using SQL, Python, Tableau

Supporting Data Science team with the development of Customer LTV model(BG/NBD) for Hilton honors members

Working closely across cross functional teams on file transfers between Hilton and American express ensuring process are followed and timelines are met. Analyst, Cobrand Analytics

February 2020-Present, Mclean, Virginia

Contact this candidate