Pushkar Gupta

Data Analyst

ac32m4@r.postjobfree.com

+1-732-***-****)

https://www.linkedin.com/in/pushkar-gupta-52b5094a/

SUMMARY

Four years of Information Technology experience at Tier 1 multinational organization, Tata Consultancy Services. An expert in Data Analytics, Business Analytics, ETL (Extract Transform Load) & Data Modeling. Comprehensive understanding of Statistical Analysis concepts along with implementation experience. Currently pursuing Masters in Information Systems (with 3.74 GPA) from Pace University (ETA May 2018).

SKILLS & TECHNOLOGIES

Data Analytics/Visualization - (R, Tableau, SPSS, SAS Enterprise Miner, MS Excel)

Statistical Analytics (Clustering &Regressions) - (R, Tableau, SPSS,MS Excel)

Data Mining - (R, MS Excel)

Predictive Modeling - (R, SAS Enterprise Miner, SPSS)

Marketing Research - (SPSS, Google Trends, Google Ngram, Qualtrics)

Project Management - (MS-Project, MS Office, MS-Visio, MS-Excel (Pivot Table, VLOOKUP))

Data Migration / ETL - (SSIS, SSDT)

Database Programming - (SQL server, T-SQL, Oracle PL/SQL)

MS Office – (MS-Excel, MS-Power point, MS-Word)

EXPERIENCE (4 Years)

Pace University

Teaching Assistant: Statistics

Tutoring business statistics & analytics to undergraduate students.

Providing solutions to complex statistical problems.

Academic Project: Data Analysis on Melbourne Housing Market

Performed data mining on unstructured data of Housing market using R to make it technically ready.

Performed linear and multiple regression on the dataset to look out for possible relationship.

Visualized the data using Tableau and applied predictive analytics using KNN, Decision Tree.

Tools Used: R, Tableau, MS-Excel (Pivot Table, Vlook up)

Tata Consultancy Services Dec 2012-Aug 2016

Data Analyst

Bangalore, India

Designed impactful dashboards for management reporting

Performed one-way ANOVA and linear regression on company's legacy data to find out market trends and potential technology glitches for a multinational conglomerate

Designed and built statistical analysis models on large data sets that boosted the sales by 8%

Scrutinized customer behavior& performed marketing research to identify trends & needs

Used statistical techniques for hypothesis testing to validate data and interpretations

Pinpointed relations, patterns & performed Data mining operations for complex data

Successfully interpreted & predicted data using KNN algorithms, Regressions etc. to draw conclusions.

Created data models and ETL programs for data migration

Served as an offshore team lead, coordinated with onsite TCS Team and owned the offshore delivery

Tools Used: R, Tableau, SAS Enterprise Miner, SPSS, Google Trends, Ngram, Qualtrics, Stat Tools, SSIS,

MS-Project, MS Office, MS-Visio, MS-Excel (Pivot Table, Vlook up)

ETL Consultant

Devised Data Extraction/Migration Strategy to an American MNC headquartered at Cupertino

Assisted Data modeling team for the designing the data model

Performed ETL process as per customer’s requirement & delivered the module with near zero defects

Tuned the performance of procedures using indexes & saved time & effort by 60% and cost by 18%

Developed the SQL code based on client’s requirement & enhancements

Performed SQL & Index optimization, database tuning & fixed performance issues

Experience in writing complex SQL queries involving multiple tables inner and outer joins

Performed SQL & Index optimization, database tuning & fixed performance issues

Project Planning, estimation, tracking &preparation of various technical /project documents

Conducted reviews of database designs and system integration issues for further improvements

Implemented procedures for validation, reconciliation of metadata and error handling in ETL process

Tools Used: SSIS, SSDT, Oracle PL/SQL, SQL Server T-SQL

CERTIFICATION

Red Hat Certified Engineer

EDUCATION

Pace University, New York City

Sep 2016 – May 2018

Master of Science in Information Systems

GPA 3.74

SJB Institute of Technology, Bangalore, India

Sep 2008 – July 2012

Bachelor of Engineering, Computer Science

Contact this candidate