Tutor, TA, REL, python, SQl, tableau, Excel

RONAK KEJRIWAL

linkedin.com/in/ronak-kejriwal/ adjkuy@r.postjobfree.com 480-***-**** Tempe, AZ

Education:

Arizona State University, Tempe, AZ December 2020

W. P. Carey School of Business (Concurrent Degree) GPA 3.65/4.00

• Bachelor of Science in Business Data Analytics

• Bachelor of Science in Supply Chain Management

Computer Skills: Python, SQL, R, Tableau, JMP, Advanced Excel, ETL, PowerPoint, Machine Learning, A/B Testing, Basic SEO Certification: Lean Six Sigma – Yellow Belt, College Readiness and Learning Association Certificate Projects and Competitions:

RTA Predictive Preventive Maintenance, RTA, W. P. Carey School of Business August 2020 – December 2020

• Predicted dates for maintenance of vehicles using historical data. Predictions made by vehicle class

• Designed and developed dashboards to display the maintenance required on each vehicle on specific days

• Helped save costs up to $1 million on excess maintenance and preventing vehicles from damage SQL Server project, W. P. Carey School of Business August 2019 – December 2019

• Designed database of a piano company from scratch and managed all their records in SQL Server

• Implemented indexes on data tables to reduce query execution time by more than 30% while ensuring data integrity

• Developed transactions, triggers and procedures to maintain SLAs on data

• Provided insights on complex business questions using advanced querying skills with joins and nests

• Developed Tableau dashboards to share analytical findings with business teams Medtronic Supply Chain Case Competition, SCMA, Arizona State University October 2019

• Achieved 1st rank for reducing lead times by 50% and costs by 35%

• Proposed centralization of distribution centers and optimized the supply chain to the most efficient routes

• Recommended new packaging and new routes for reverse logistics to save transportation costs with no additional investment Intel Smartboard Supply Chain, W. P. Carey School of Business August 2019 – December 2019

• Prototyped an end-to-end supply chain of Intel Smartboards generating profit margin of 30%

• Optimized for quality and costs while maintaining high levels of customer satisfaction

• Proposed production schedules using Gantt charts and presented to the supplier base for complete transparency

• Analyzed lead times from each supplier to develop efficient order placement cycle and eliminate excess holding costs Supply Chain Capstone, W. P. Carey School of Business August 2019 – December 2019

• Modeled and proposed new plant locations while overcoming existing business constraints.

• Minimized costs and met demand levels by calculating Economic Order Quantity from each supplier

• Developed decision tree models to investigate the most suitable organization for outsourcing Dell Case competition, Dell, W. P. Carey School of Business April 2019

• Improved the supply chain of raw materials and made plans to help manage the center for holding repair parts

• Recommended Multi-Vendor Support Service model because of perfect application and need Work Experience:

Student Tutor, ASU, Tempe, Arizona January 2020– December 2020

• Certified through College Readiness and Learning Association to tutor undergraduate students in the subjects of Economics, Mathematics and Computer Information Systems

• Served as peer and academic mentor in 1:1 and large group settings to facilitate continual student success

• Helped students break down complex problems to individual learning levels Mathematics Instructional Aide, ASU – School of Mathematical and Statistical Sciences August 2019 – December 2020

• Graded coursework of 75 students, monitored weekly progress for coursework completion and held 100+ office hours. Residential Engagement Leader, Arizona State University - W. P. Carey School of Business January 2019 – December 2019

• Established rapport with first year students in the residential halls by engaging them in programs to enhance academic success, professional development, and college connections by organizing semi-monthly events

• Exhibited high communication skills with the Undergraduate Programs Office, Student Engagement, and W. P. Carey Finance team by promptly responding to emails and submitting paperwork by its deadline Export-Import Assistant, Shekhawati Geotech Pvt. Ltd., Surat-India June 2018 – September 2018

• Responsible for finding new customers globally through online B2B trade portals

• Transacted and communicated with international customers and ensured customer satisfaction

• Developed a new system to prepare and manage internal customer records

Contact this candidate