Data Analyst Sales

ABHINAV TIWARI

Mountain View, CA +1-513-***-**** adepr0@r.postjobfree.com www.linkedin.com/in/tiwariab EDUCATION

University of Cincinnati, Cincinnati, OH Master of Science in Information Systems December 2019 Graduate Certificate in Data Science GPA: 3.82

SRM University, Chennai, India Bachelor of Technology in Electrical and Electronics May 2016 TECHNICAL SKILLS

Analytics & Visualization Tools: Tableau, Qlik Sense, Power BI, SAS, MS Excel, Google Analytics, Matplotlib, Seaborn

Programming Languages: SQL, R, Python (NumPy, Pandas, Scikit-learn), Spark, PL/SQL, T-SQL, HTML, CSS, Shell Script

Database Systems: Oracle 10g/12c, PostgreSQL, MS SQL Server, MS Access

Tools: Oracle Apex 5.1, SQL Developer 4.0, PL/SQL Developer 12.0, Visual Studio, OBIEE, MS Office Suite, GitHub, Jira, Trello

Statistical Techniques: Random Forest, Logistic Regression, PCA, Decision Tree, Classification, Clustering, Hypothesis Testing

Other Skills: AWS, Database Design, AB Testing, Time Series Forecasting, Scrum Methodology, Requirement Gathering PROFESSIONAL EXPERIENCE

Funding Circle San Francisco, California

Data Analyst (Finance) February 2020 – Present

Worked as Tableau Server Administrator accountable for server management, deployment, and access management

Spearheaded construction of Tableau dashboard which demonstrated Loan Life-Cycle funnel for Paycheck Protection Program

(PPP) which helped the company track $1.7 billion loans and save 33,000 jobs

Created Python Script for fetching data from PostgreSQL and Athena and loading it in AWS S3; used this data (10M records) for the creation of Global Risk MI Dashboard for the finance team

Implemented an end to end solution for Forbearance program consisting of a risk report aiding in enrollment of loans worth

$60 Million and a dashboard for risk and collection teams highlighting any exceptions

Supported ad-hoc data requirements from cross-functional teams by optimizing existing SQL views by 4x through SQL tuning University of Cincinnati Cincinnati, Ohio

Data Analyst (Higher Education) June 2019 – December 2019

Performed regression analysis to assess the impact of different marketing activities and demographic data on the revenue

Automated generation of retention reports through process flows and SQL scripts built on SAS saving 2 days of weekly effort

Performed time series forecasting using R to predict the future student enrollment based upon previous term enrollment

Created marketing reports and interactive dashboards on Tableau for helping in policymaking for student retention

Performed dimensional modeling and requirement gathering to create a Data Warehouse to back-up the CRM tool and OBIEE

Created materialized view and tuned the retention report SQL query; resulting 80% faster report generation

Performed trend analysis for UCO vs. equivalent on-campus programs to measure enrollment using Tableau and Excel reports Cognizant Technology Solutions Data Analyst Mumbai, India Client: Purdue Pharma (Healthcare) June 2016 – July 2018

Performed data cleansing and transformation on healthcare sales data and created interactive dashboards using Tableau to find key performance indicators (KPIs) and helped increasing the adoption rate of new medicine, boosting sales by 30%

Built ARIMA model using R to conduct time series forecasting for future sales of eye-care products based on current sales

Developed a robust rule engine using Oracle APEX and PL/SQL to ease the report generation for business stakeholders which tracked the performance of the sales team and identified high performing individuals; improved sales by 25%

Created a Repository Management System (RMS) with Agile methodologies for project managers using PL/SQL, Oracle Apex to track daily task updates; resulted in quick issue resolution and a change in workplace dynamics

Suggested the migration of old clustered Java website to an open-source application and implemented the project migration to Oracle Apex 5.1; reduced the project cost by $100,000

Enhanced customer sales reports by optimizing SQL queries using indexing and hints; resulted in 40% faster report generation

Used Google Analytics data to analyze and understand the audience better by tracking the screen views, user interaction by designing metric dashboards; suggested improvements in their email campaigns ACADEMIC PROJECTS

Market Basket Analysis using R

Analyzed the transactions data from a retail store by performing Association Mining to propose aisles

Applied Apriori algorithm to suggest recommendations for products bought together frequently Iris Data Analysis using R

Cleaned the dataset and performed exploratory data analysis for analyzing supervised and unsupervised learning models

Implemented supervised (KNN classification) and unsupervised learning (K-Means and Hierarchical Clustering algorithm) Scholarship Funds Database using Oracle SQL

Created a database from the presentation layer to physical implementation with the database normalized to 5th Normal form

Converted the logical model into a physical database containing 10k+ records using SQL developer Computer Cost Prediction using R

Created a linear regression model to predict the price of the computer, based on numeric and indicator variable

Performed data transformation, data clustering, and feature selection to define the accuracy of the model

Contact this candidate