Resume

Sign in

Information Technology Data

Location:
Ypsilanti Charter Township, Michigan, United States
Salary:
45000
Posted:
October 25, 2016

Contact this candidate

Resume:

Shipra Gupta Linkedin: https://www.linkedin.com/in/guptashipra1

**** ******* ***** ** *** 12 Email: acw8am@r.postjobfree.com

Ann Arbor MI 48108 Contact: 682-***-****

SUMMARY

Experienced Data Analyst and Business Analyst professional

Hard-working individual with an impressive educational background and strong experience in complex data analysis

Experienced in utilizing various technical tools and languages such as Excel, Python, R, Tableau, SQL, Hive, Pig, Hadoop, TIBCO clarity and SAP to perform business analysis, data analysis and managing large-scale datasets

EDUCATION

Master of Science in Information Systems August 2014 - May 2016

University of Texas, Arlington GPA: 3.60

Master of Business Administration in Information Technology Management/Marketing August 2012 -May 2014

Delhi Technological University (DCE) GPA: 3.80

Bachelor of Technology in Information Technology August 2008- May 2012

Maharshi Dayanand University GPA: 3.50

TECHNICAL SKILLS

Analytical Tools : WEKA, R, Python, Tableau, SAS, SAP, Google Analytics, TIBCO Clarity, Excel

Programming Languages : Python, R, SQL, Hive, Pig, Java, JavaScript, HTML, JSON, C, C++, Pl/SQL

Database : MySQL, NoSQL.

Big Data Technologies : Hive, Hadoop, HDFS, MapReduce, Pig, Zookeeper, Sqoop

Big Data Distributions : Cloudera, MapR

Algorithms : J48, Naïve Bayes, JRip, ZeroR, Sentiment Analysis, Natural Language processing

Others Microsoft Project, Microsoft Office Suite, SAP B.I., EVIEWS, ANACONDA

PROFESSIONAL EXPERIENCE

Acquiro, Denver, CO, US July 2016 – August 2016

Data Analyst (TIBCO, SQL SERVER 2014)

Analyzed complex dataset, finding patterns and cleaning the data for the data analysis purpose.

Worked on TIBCO clarity software. Code and automate dynamic data-cleansing programs using GREL.

Latakoo, Austin, TX, US September 2015-Feburary 2016

Data Analyst Intern (Python, Excel, JSON)

Directed a variety of technical functions with a concentration on data analytics which included using Python in order to obtain JSON queries for both data analysis and report generation

Played an integral role in the development and implementation of a comprehensive analytical tool which was used in the organization’s website and provided customers with the ability to monitor their use of the organization’s file upload/download

State Bank of India, India June 2013 – August 2013

Business Analyst Intern (Excel, Survey Analyzer, Pareto Analysis)

Facilitated several managerial functions within the organization which included performing in-depth business analysis which focused on customer satisfaction levels

Utilized various analytical tools such as Pareto in order to identify key factors within customer satisfaction levels in addition to providing recommendations on how to increase customer service

PROJECTS

NATURAL LANGUAGE PROCESSING PROJECT (YELP DATASET) (Python, R, Tableau and WEKA)

Successfully solved the Yelp Dataset Challenge which was focused on guessing a reviewer rating based just on text alone and Yelpers are sarcastic bunch or not

MARKET BASKET ANALYSIS (R, Python)

Designed a program which concentrated on market basket analysis on supermarket data

ADVERTISING DATA PROJECT USING PIG, Hive (Pig, Hive, Hadoop, Cloudera)

Performed complex analysis of marketing data through the use of 2 files which were pre-processed using PIG, HIVE script

Completed company charges based on user clicks, identified sites that had the lowest total cost of using keywords, and highlighted the top 10 high-cost keywords using PIG,HIVE

SAP BI MODULE PROJECT (SAP BI Module, SAP HANA)

Developed a data mart using SAP business warehouse which required creating reporting scenarios in the form of information cubes, information objects, authorization roles, and queries

DATA MINING PROJECT (WEKA)

Utilized several data mining algorithms using WEKA on bird strike data which was collected through various airports with a concentration on determining the best algorithm to use in an effort to reduce bird strike levels at airports

DATA MODELING AND DATABASE DESIGN FOR VIDEO RENTAL COMPANY (SQL Server 2008)

Created relationship matrix, E-R diagrams, relational schema, data dictionary, tables in SQL SERVER for our application.



Contact this candidate