Data Analyst Project

PUNITH SHIVA SHANKAR Email – *******.******@*****.*** Phone – 682-***-****

**** ***** *** **, *** 302, Arlington TX 76013. LinkedIn - www.linkedin.com/in/punith-shiva-shankar EDUCATION

Master of Science in Information Systems. May, 2018 University of Texas, Arlington, USA. GPA – 3.91 on 4.00 Scholarship: Wayne Watts Graduate Fellowship.

Bachelor of Engineering in Electronics and Communication May, 2016 Visvesvaraya Technological University, India. GPA – 3.50 on 4.00 CERTIFICATION

Google Analytics Individual Qualification, Google Inc. Valid Until – Jul 2019 TECHNICAL SKILLS

Data Analytics & Visualization R, Weka, SAS, Python: Libraries – Pandas, NumPy, SciPy, Tableau. Database and Data Warehouse Oracle SQL, MySQL, MongoDB, SAP. Data Mining & Machine Learning Classification, Regression, Clustering, Decision Tree, Ensemble method, Dimensionality reduction.

Web Development HTML5, CSS3, Javascript, AngularJS, JQuery. Microsoft Tools MS Excel (Pivot Tables, Macros, VLOOKUP), MS Project, MS PowerPoint, MS Access, Visio

WORK EXPERIENCE

Data Analyst, University of Texas at Arlington May 2017 – May 2018 (1 Year)

• Oversaw and collaborated with team of directors for Leadership Honors Program, analyzed the historical membership data using MS Excel, SQL, conducted focus group and reported as required.

• Improved the membership application by 85% by revising and enhancing program requirements, strategizing targeted web and marketing methods obtained through analysis.

• Bestowed with Best Employee of the year for outstanding contribution to the program. Research Analyst Intern, Indian Space Research Organization, Bangalore Feb 2016 - May 2016 (3 Months)

• Liaised and communicated between the transmitter and antenna design department; Conceptualized and drafted the design requirement report, use case documentation for a prototype design.

• Augmented the prototype design process to 3 weeks by eliminating out of scope requirements.

• Assisted in the research of transmitter subsystem design methodologies; Monitored and documented the simulation results and fabrication process.

ACADEMIC PROJECTS

Market Basket Analysis of Retail Store Items (Python, R) – Developed item frequency plot by Pre-processed the item list of over 120K commodities to determine the association between each item using python. Visualized the item frequency plot of the customers using R. Recommended strategical placement of items, resulting in increase of sales by 15%. Database development of a Furniture Outlet Company (MySQL) – Implemented a relational database by defining Data Definition based on the business requirement using MySQL. Consolidated over 20K customer, shipping and product data into the database. Enhanced Querying capability by 10% by introducing indexing in the database. Sentiment and Topic Analysis of aggregated tweets (Python – TweePy, TextBlob, NumPy, Tableau) – Performed sentimental and topic analysis on the controversy #takeaknee in the US. Developed an automated method to extract 50K tweets instantly using TweePy library and preprocessed in python. Aggregated sentimental polarity of each state using TextBlob module in python and visualized in Tableau. Designed a word cloud obtained from topic analysis in python. Business Intelligence Analysis for Global Bike Inc. (SAP Business Object Analysis) - The businesses objective - overall revenue, profits and loss of the company were computed. The multidimensional source data was refined in Excel, the objectives were tabulated and interpreted and visualized using SAP Business Object Analysis. Drafted business strategies to improve the loss by 5% obtained through analysis. Individual salary prediction in Texas State (Python) – Predicted the salary of citizens in the Texas State based on the obtained census dataset of 2015 with 100K instances. Preprocessed and transformed data to enhance the accuracy of the model. Constructed predictive model using GBM and resulted in 97.3% model performance (accuracy). Improvement of Maintenance Process using CMMI Framework (MS Project, CMMI, Agile) – Referenced CMMI model to improve the maintenance model for the client Campus Living Village. Served as a Project Manager, created WBS using MS Project, strategized to minimize the project duration to 5 weeks by developing eased methods, taking ownership and delegating work based on team strengths, and led the project to completion. Communicated to improve the transparency between the administration and residence and outsourcing of maintenance and pest control to the client.

Contact this candidate