Ambar Singh

Denver, CO *****

720-***-**** adbx49@r.postjobfree.com

www.linkedin.com/in/ambarsingh www.github.com/ambarsingh1611

Summary of Qualifications

Master of Science, Information Systems graduate; relevant coursework includes Database Management System, Data Warehouse and Administration, Text Data Analytics, Statistics for Business Analytics, BI and Financial Modelling, Business Process Management, Information Systems Management Strategy, Project Management, Business Intelligence Systems and Analytics

Multiple data analysis projects using Python and SQL with libraries such as Pandas, Numpy, Seaborn and sklearn

Successful experience working with a software development team for the development of a grooming companion app to be used by >2,000 users across the US for initial launch

Technical Experience

Programming languages: Python, R, SQL

Software and IDE’s: MicroStrategy, Alteryx, Pentaho, JIRA, MS Excel, Tableau, PowerBI

Skills: Data Reporting, Data Profiling, Exploratory Data Analysis (EDA), Data Wrangling, Data Mining, Data Visualization and Dashboards, Machine Learning, Natural Language Processing (NLP), Regression Modelling, Pivot Tables

Knowledgeable in Agile Methodology, SDLC, Kanban, Linear Regression, Logistic Regression, Reporting and Analytics, RDBMS, Business Intelligence (BI), ETL, OLAP, Data Warehousing, SQL Queries, Data Modelling, SSIS, SSRS

Education

University of Colorado Denver, Business School, Denver, CO

Master of Science, Information Systems Major December 2019; 3.54 GPA

Rajiv Gandhi Proudyogiki Vishwavidyalaya, Bhopal, India

Bachelor of Engineering, Information Technology Major May 2013

Publication

Using Data Science to Close Equity Gaps in Learning; UKFIET Conference – University of Oxford, U.K

Co-authored an approach paper on using Machine Learning and Data Science approaches to draw out evidence-based action plans to close equity gaps in learning for education system in India. Contributed as a Data Analyst.

Professional Experience

Qualitest, Bangalore, India, June 2017 – December 2017

Client: Philips Pvt. Ltd.

Test Engineer

Collaborated with developers and stakeholders in an Agile development environment to understand key metrics

Converted business data into user stories, epics, tasks and acceptance criteria in TFS according to business needs

Performed exploratory database testing using SQL and User Acceptance Testing (UAT)

Tested and maintained data pipeline to ensure smooth automation of ETL process

Created dashboards and visualizations in Tableau to explain recommended changes executive format

Indecomm Global Services, Bangalore, India, April 2016 – June 2017

Client: Sony Interactive Entertainment

QA Engineer

Gathered project QA requirements from the client and converted them into user stories and actionable QA elements

Conducted and supervised testing, regression, compliance checks in MS SQL Server

Acted as Point of Contact for cross regional communication with teams in Europe, USA and Japan

Won Sony’s Best Team award of 2017 Q1 for involvement in best-selling title of the year

Pole to Win International Pvt. Ltd., Bangalore, India, July 2014 – April 2016

Test Engineer - Functionality

Wrote extensive product specific and reusable test cases across various projects to increase efficiency by 20%

Managed a team of 6 members using JIRA to complete testing responsibilities and provide deliverables

Defect logging and defect tracking using JIRA; documenting minutes of meeting

Affiliations / Community Service

Officer at Information Systems Association, University of Colorado at Denver, August 2018 – December 2019

Academic Projects

Complete project details listed on LinkedIn and GitHub

Yellowstone National Park Footfall Prediction

Predicted recreational visits in Yellowstone National Park improve budgeting, staffing and increase revenue

Gathered 30-year weather, accommodation, inflation and visitor data of Yellowstone National Park Region

EDA, Data Cleansing, Data Wrangling and Data Preprocessing using python

Carried out regression analysis and created regression model with seasonality in R

Introduced inflation and population growth over years in the model with error rate of 3.2%

Forecasting and Budget Planning for a Call Center

Conducted Variance Analysis of revenue from historical forecasted and actual revenue data

Forecasted revenue for upcoming financial years using linear regression and built Baseline budget

Created and fine tuned the NPV model and created stretch budget to attain 5%, 10% and 15% in increased revenue

Created visual dashboards using MicroStrategy to report organizations regional performance

Created Dossier using MicroStrategy to define product performances and customer analysis of the company

Yelp Review Classification (NLP)

Classification of Yelp reviews into 1 star or 5-star categories based off the text content in the reviews

Exploratory Data Analysis using Python to identify patterns in each star rating of reviews

Classification of review data based on star ratings using Natural Language Processing

Used Pipeline to create a set of functions for building Tfidf matrix and apply Naïve-Bayes classification model

Prediction of a review, based on training data with 93% accuracy

Bank Stocks Analysis

Analyzed over 20 years of stock data of popular banks to identify and create an optimum investment portfolio

Identification of stocks affected and unaffected by stock market crash for increased efficiency of portfolio

Web scrapping using datareader to gather stocks data, multi-indexing and data wrangling using pandas in python

Implemented Linear regression to identify trends and Clustermap to group stocks according to returns and risks

911 Case Analyses

Analysis of 911 calls data to identify patterns in reason of calls to improve efficiency and response time

Created new feature from issue description to analyze the geo-locations of the emergency calls

Aggregated weather data to understand the effect of weather on the reasons of the emergency

Data wrangling using pandas library in python, analysis and visualization using matplotlib and seaborn with python

Database Modelling Orion Industries

Initiated project and created ERD based on organizational requirements

Developed a Relational Database model and implemented in MySQL for 5 cross business functionalities

Created GUI Dashboard using with inbuilt Addition, Modification and Deletion functionalities for ease of use

Developed a Dashboard working with Tableau and Micro Strategy to analyze business critical and financial data

Contact this candidate