Data Project

N I K HAR SHAH

**** * ******** **** #***, Tucson, AZ, 85719, USA Mobile: 520-***-**** E-mail:

n *********@*****.*******.***

S umma ry:

• Working as a graduate assistant at the University of Arizona in the field of data analysis and statistics

• Proficient in BI reporting - Extracting, cleansing & processing data using E xcel, SQL, T ableau and SAP

B usiness Objects

• Hands-on experience in data visualization and data management tools like SAP Business Objects, T ableau and

T IBCO Spotfi re

• Developed dashboard (SAP Business Object based) displaying company’s monthly t rends of sales and network

compliance

• Designed frame work of a comprehensive centralized relational database for an event managing company using

O racle SQL

• 2 years of experience in data analysis and business systems analysis

Education:

M aster of Science in M IS, Eller College of Management, University of Arizona GPA: 3.29/4.0

Dec 2014

Bachelor of Engineering in Computer Science, Rajiv Gandhi Technical University, India GPA: 3.52/4.0

May 2012

Software Skills:

• Visualization and Analysis tool - TIBCO Spotfire, Tableau, SAP Business Objects, Rapid Miner

• Basic Teradata Query Language (BTEQ), Oracle SQL, PL/SQL, Advance Microsoft Office, Excel, Visio, MS Project,

Sharepoint

• C, C++, SAS, Core Java, R Programming

Work Experience:

Business I n telligence I nte rn, Freeport-McMoRan Inc. May 2014 -

A ug 2014

• Gathered requirements from infrastructure department on compliance policy and measures to generate compliance

reports

• Extracted data from a complex relational database(Teradata) using visualization tools like SAP Business Objects,

T ableau

• Developed SAP Business Objects reports on KPI’s of network devices and call center of the company using

Teradata and SQL

• BI reports helped company increasing network availability to 98% from 89% and device uptime to 97% from 90%

• Certified with MS Project t raining by Freeport McMoRan - Managed 300 hours project

• Did a presentation on reports for the Vice President and CIO of the company and was appreciated for its tangible

business value

G raduate Assistant, Eller College of Management, University Of Arizona Oct 2013 - May

2014

• Addressed queries and held lab sessions on sample distributions, hypothesis testing and regression analysis

• G raded, optimized course content and maintained a database of 700 students

Software Engineer, Abhyudaya Multimedia, India Aug 2012 -

J une 2013

• Developed web pages and maintained backend databases using SQL, PHP, JSP, and JavaScript

• Enabled the organization to cut costs by $5000/year by installing in house database server compared to third party

server host

P rojects:

Data Analyst - Database Design, B ulls Eye, T ucson, USA A ug

2013 - Dec 2013

• Designed a framework of a comprehensive centralized relational database for an event company B ulls Eye using SQL

• Generated Tableau reports for the analysis, and modeled the complete database on software platform Oracle SQL

B I Analyst - P redictive Analytics for Fleet Maintenance, Republic Services, Phoenix, USA

Jan 2014 - May 2014

• Performed data quality assessment by analyzing f leet maintenance data in data warehouse

• Developed heat maps of database tables using Tableau and provided roadmap for implementation of predictive

analytics

• Presented assessment report to CIO which was appreciated for its real tangible business value

B I Developer - Data extraction and Cleansing, U niversity of Arizona

Jan 2014 - May 2014

• Extracted data from syndicated databases like Nielsen Databases, Source one etc. on customer behavior on

recreational activity

• Performed region wise analysis on areas of investment, developed Tableau report on revenue potential in different

states of US

Data Analyst - F IFA World Cup 2014 P rediction, U niversity of Arizona

Jan 2014 - May 2014

• Developed fully functional website with 10 APIs, frontend and backend database capability using Amazon EC2

p latform

• Developed own API that predicted World Cup 2014 matches based on historical and current team statistics

Certification:

• CNSS-NSA - Certified Information Systems Security Professional • CNSS-NSA - Certified Senior

Systems Managers

• Freeport McMoran Inc. - Certified Microsoft Project Professional

Achievements:

• Received a total of $24000 scholarship from the University of Arizona in spring 2014 and fall 2014

• Won Harvard Business review case competition sponsored by Cognizant held in Eller College of Management

Contact this candidate