Data Analyst
Resume:
Pushkar Gupta
Data Analyst
**************@*****.***
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