Data Customer Service

Rakesh Reddy Venkatesh

**** * ***** **. ***, Tempe, 85281 www.linkedin.com/in/rakrvenk +1-480-***-**** ********@*****.***

Innovative self-starter and problem solver who tackles challenges far within deadlines with expertise in data driven decision making and analysis, optimizing processes and cutting costs by continuous improvement, seeking full time positions in Data Analytics.

Skill Set[ Proficiency 0-10 scale]

Network optimization[7], Operations Research[8], Forecasting[9], Data Analysis (Mining, Manipulation and Visualization)[8], Analysis of decision process[8], Design of Experiments[8], Supply Chain Models[8], Production Systems [7], Machine Learning[6]

Programming Languages: MySQL[9], VBA[8], R[6], python (Pandas, matplotlib, scikit-learn)[8]

Software proficiency: Excel[9], Tableau[7], MINITAB[8], JMP[8], Access[7], AutoCAD[6]

Experience

Office Aide/Analyst, SFIS ASU Tempe June 2018 – May 2019

Created a database for inventory of 50+ office supplies on Access and dashboard on excel.

Developed easy to use forecasting models, visualizations and dashboards on excel for non-technical staff.

Implemented periodic review policy and power of two policy to manage inventory and orders.

Provided front desk assistance and assistance in shipping and logistics for faculty and staff.

Founder/Analyst, MyTrucky(Startup), Venture Devils, ASU Tempe Dec 2017-Nov 2018

Conceptualized the idea of transporting people and their vehicles to cut transportation costs, time and pollution.

Consulted grad students and few professionals for trailer design and practicality.

Queried, Analyzed and forecasted time series data from various databases using MySQL and Minitab to estimate demand.

Planned optimal route and schedule, estimated costs, conducted surveys and terminated the project.

Bike Tech./Analyst, ASU Tempe Sept 2017-May 2018

Led team of 6 to improve shop ratings from 3.4 to 4.2 on google by streamlining work flow and customer service.

Maintained Access database of employee working hours, customer details, service records, sales and inventory.

Identified key factors affecting staff’s performance and suggested optimal levels.

Forecasted customer data and used simulations to schedule staff and minimize wait times.

Manufacturing Intern, BEML, Bengaluru May 2015 – July 2015

Collected data, evaluated work station layouts and processes to reduce lead time.

Observed manufacturing plant and interacted with workers to gain insights on collected data.

Academic Projects

Supplier and inventory optimization for supermarkets and small scale retailers Sept 2017–Nov 2017

Worked as a team to develop ERP system using Excel, VBA and MySql (Relational Database) to track inventory and billing.

Created interactive dashboards and GUI on excel for inventory management and supplier selection(MIP).

Automated inventory tracking, supplier and order selection by programming (Q,R Model) and MIP on VBA.

Drone Scheduling, Assignment and route optimization for delivering vaccines Sept 2018-Nov 2018

Extracted locations and distances in-between hospitals from google maps and visualized a network.

Formulated MIP (mixed integer programming) for network flow optimization and solved using cplex.

Developed the optimized path, schedule and load for each drone, performed sensitivity and reported tradeoffs.

Data driven decision support for a Manager buying MRI Scanner Sept 2018-Nov 2018

Extracted and transformed data into meaningful dashboards using MySql, VLOOKUP’s, pivot table and VBA.

Forecasted 1-year demand, simulated different scenarios based on probability distribution of forecast.

Optimized decisions by evaluating risks for different scenarios using stochastic modeling and utility theory.

Strategic planning for a Ad company, Business Analytics Capstone Project June 2018-Nov 2018

Analyzed the situation and Proposed experimental design of ads to identify significant attributes.

Suggested user data (clicks, views, use of Adblockers and surveys) as performance indicators.

Identified optimal levels of attributes for Ads to maximize user satisfaction and reduce use of Adblockers.

Predicting property maintenance fines Dec 2018– Feb 2019

Analyzed dataset of 250000 entries with 34 variables, cleansed and extracted data from gov. datasets with python.

Compared various classifiers to predict fine payments, achieved auc of 0.75 with MLPclassifier.

Matching algorithm for allotting parking space to users Jan 2018– April 2018

Developed a database of parking lots, capacity, co-ordinates and prices and computed weights.

Used Hungarians matching algorithm to assign the optimal parking space to user, minimized costs.

Education

Master of Science in Industrial Engineering Expected May 2019 Arizona State University (ASU), Tempe, Arizona, USA CGPA: 3.33

Bachelor of Technology in Automobile Engineering May 2017

SRM University, Kattankulathur, India GPA: 8.7/10

Certifications on MOOC : Business Analytics Specialization, Applied Machine Learning, Applied text mining, Data Science with python, Operations Analytics, People Analytics, Customer Analytics, Accounting Analytics, Digital Prototyping

Contact this candidate