ARPAN SHAH

469-***-****; acuako@r.postjobfree.com; https://www.linkedin.com/in/arpanshah2

EDUCATION

The University of Texas at Dallas May 2016

M.S., Information Technology and Management GPA 3.75 University of Pune May 2013

B.E., Information Technology

CERTIFICATIONS & TECHNICAL SKILLS

Certifications: Google Analytics & Google AdWords Certifications - Google Partners Analysis Tools: Google Analytics, MS Excel, MS Access, Tableau, SSRS, SSIS Software Tools: SQL Server Management Studio, Salesforce, MS Project, SharePoint, Visual Basic 6.0 Programming Languages: SQL, HTML, Macros, XML, R Programming, VBA, C BUSINESS EXPERIENCE

Advantix Solutions Group - Richardson, Texas December 2015 – Present Telecom Data Analyst Intern

Optimized telecom expense data and made recommendations which resulted into increased end user’s usage while minimizing the costs

Analyzed monthly usage data to provide useful insights to meet business objectives to maximize opportunities for client savings

Published customized interactive reports and dashboards using Tableau server

Provided monthly data analysis and optimization on usage data and ensure contract compliance

Maintained the quality of data analysis and ensure output from the Data Analysis team meets client and internal requirements for accuracy and delivery, and adheres to internal processes and procedures Ryder Systems, Inc. - Georgetown, Kentucky June 2015 – December 2015 Engineering Intern

Analyzed the business data and restructured the scripts to enhance company driver scorecard which resulted into increased driver retention and enhanced driver management

Gained experience using SQL parameters, triggers, sub queries, creating loop structures, creating stored procedures and complex filters using conditional statements

Worked with cross-functional teams to provide quality information and make recommendations

Generated reports using Report Builder 3.0 that displayed company’s payroll based on flexible date range and enhanced it to streamline management of distribution Mahavir Trading Co. - Mumbai, India September 2013 - May 2014 Trainee Engineer

Generated bi-monthly analytic reports used to make strategic business decisions using MS Excel

Managed company’s inventory data for various deals and schedule basis client’s deliverables

Analyzed trade data along with market data using pivot tables, vLookup, charts, macros and data analysis ACADEMIC PROJECTS

Dedicated Statistics June 2015 – August 2015

Queried remote servers as per the business requirements by writing SQL queries and pass through methods

Created expense reports based on user input time period parameter to monitor cost using Report Builder 3.0 Web Analytics – Google Online Marketing Challenge January 2015 –May 2015

Analyzed and devised an advertising campaign using Google Analytics & AdWords to expand the online presence of our client

Implemented the campaign which resulted in 70,000+ impression and 400+ visits on the clients website in 21 days Business Intelligence: Kaggle dataset, “Give me some credit” August 2014 – December 2014

Analyzed historical data on 150,000 borrowers using SAS Enterprise Miner 13.1 and implemented Logistic regression for predicting whether one will experience financial distress in the next 2 years ORGANIZATIONS

Student Government, UT Dallas, Senator May 2015 - October 2015 Business Intelligence and Analytics Tools Club, UT Dallas September 2014 - August 2015 National Level Event Perception, Event Organizer November 2011 - January 2012

Contact this candidate