Data Analyst

EDUCATION

YASH KUMAR SHARMA

817-***-**** ***********@*****.*** linkedin.com/in/yashk1

University of Texas at Dallas Dallas, TX

Master of Science in Information Systems (GPA: 3.5/4.0) Aug 2017-May 2019

Coursework: Data Mining, Database Systems, Machine Learning, Data Visualization, Data Modelling, Data Warehouse

Delhi Technological University New Delhi, India

Bachelor of Technology in Software Engineering (GPA: 7.0/10.0) Aug 2013-Jul 2017

Coursework: Data Structures, Algorithm Design, Operating Systems, Computer Networks,

Computer Architecture, Artificial Intelligence, Software Engineering, Database Systems

WORK EXPERIENCE

USAA San Antonio, TX

Data Analyst, People Analytics Sept 2019-Present

Developed and deployed business intelligence solutions to collect, aggregate, and synthesize worker data to produce Diversity and Inclusion metrics

Produced 8+ quarterly briefing reports based on business requirements and collected data from multiple data sources and exporting into

Excel using SQL to support the business issues

Created data visualization solutions for stakeholders and business units to interpret trends in the employee’s diversity datasets using Tableau

Analyzed business problems and ad-hoc queries by gathering data from internal and external data sources including MS Access, SAP Business Objects, MS Excel, and synthesizing data to draw conclusions and make recommendations resulting in implementable analytics strategies

Maintained company’s active database via SQL querying (ETL) that fed information into reporting and analysis

Performed data visualization and Designed dashboards with Tableau and D3.js and provided complex reports, including charts, summaries, and graphs to interpret the findings to the team and stakeholders

Performed extensive Data Validation, Data Verification against Data Warehouse and performed debugging of the SQL-Statements and stored procedures for business scenarios.

Inventive Advertising Pvt. Ltd. Delhi, India

Business Intelligence Analyst – Summer Intern Jun 2016-Aug 2016

Built an end-to-end data pipeline and KPI dashboard for senior leaderships to analyze and visualize company’s customer growth

Designed interactive dashboards of the key indicators to reduce the churn rate of the clients; Enhanced data transparency to improve digital marketing methodologies.

Restructured essential drivers behind customer acquisition cost and reduced customer acquisition cost by 12%

Conducted analysis in assessing customer consuming behaviors and discover value of customers with RMF analysis, applied customer segmentation with clustering algorithms such as K-Means Clustering and Hierarchical Clustering

HCL Infosystems Pvt. Ltd. Delhi, India

Data Analyst Intern Dec 2014-March 2015

Assessed and analyzed disparate sources of large data sets for cleaning purposes to assist ML processes

Executed performance driven SQL queries to perform root cause analysis of raised incidents

Developed 10+ ad-hoc reports and dashboards based on the KPIs to visualize and track insights periodically that helped improve business strategy, which increased quarterly revenue by ~10%

ACADEMIC PROJECTS

Data Mining on Yelp Dataset May 2019-Jul 2019

• Implemented the SON algorithm to discover frequent item-sets using PySpark

• Designed content-based, item-based, and user-based collaborative filtering recommender systems

Predicting US household income using Python May 2018-Jul 2018

Processed approx. 50,000 records with a 74.30% accuracy to predict earnings more than $50k a year

Synthesized 5 attributes to predict future household incomes to allow for informed policy making

Determined Random Forest to outperform other ML algorithms such as Clustering, Classification, Decision Tree and Regression

Movie Recommendation system Aug 2017-Dec 2017

Designed and implemented movie recommendation system based on 200,000 movies using Python

Enabled users to recommend movies based on 30+ data points based on IMDB data by applying various Machine learning algorithms

Marketing Analytics & Digital Marketing using SEO and Ad words Aug 2017-Dec 2017

Measured, analyzed, and improved the bounce rate and Impressions of a Website using google analytics

Improved visibility and executed an online client marketing campaign with 22k+ impressions for a website

Identified project requirements, scope, sales, and marketing model based on market research resulting in 5% more clicks

Twitter sentiment analysis Aug 2017-Dec 2017

Mined more than 500,000 tweets by keywords to analyze positive and negative sentiments for tweets on new product releases (Ex: Iphone7,

Surface Pro, Tesla Model)

TECHNICAL SKILLS

Languages: Java, R, HTML/CSS, Python (Pandas, Numpy, Scikit-Learn, Seaborn, PlotLy, TensorFlow, Stats models)

ML Algos: Regression, Clustering, SVM, Decision Tree, Random Forest, Gradient Boosting, K-NN, K-means

Tools: Tableau, Advanced Excel (VLookup, HLookup, Hypothesis testing, Pivot), Business Objects, MySQL, Dremio, MongoDB, SAP

Certification: AWS- Certified Solution Architect, SAS Data Mining, Google Analytics

Other: Apache Kafka, Docker, Git, A/B testing, Regex, Hadoop

LEADERSHIP AND INVOLVEMENT

Secretary of SAP User’s Group at University of Texas at Dallas

Co-founder/Treasurer of ‘Get Out and Try’, Social Awareness Club, DTU- Organized events, rallies, and workshops to promote and raise awareness about inclusivity, diversity, disabilities and other social issues

Contact this candidate