Education

Master’s in Industrial and Systems Engineering August 2018 – May 2020

North Carolina State University, Raleigh, NC

Bachelor’s in Mechanical Engineering July 2012 – May 2016 Birla Institute of Technology, Mesra, India

Professional Experience

Operations Intern, KORE Wireless – an IoT Company August 2020 – Present

Designed a HR Training Database Module in MS Access using SQL to track training schedules of employees

Optimized the inventory holding arrangements of different SIM SKUs and reduced holding costs by 17%

Performed E2E analysis of production systems and created user reports to ensure processes align with business needs Supply Chain - Technology Coop, Bosch Home Appliance Corporation January 2020- May 2020

Increased the warehouse storage capacity by 10% by optimizing inventory storage arrangement

Ensured accurate inventory movement by improving the ERP functionality of the ‘Voice to Pick Inventory’ system

Identified and proposed new cardboard waste train route to reduce cycle time from 45 minutes to 32 minutes

Created compelling dashboards using Microsoft PowerBI to perform a procurement spend analysis

Optimized the ordering lot sizes of materials from 2 new suppliers by analyzing the storage capacity and material needs

Reduced the rejection of requisitions requests by 15 % by customizing the material specification module Business Process Analyst, American Red Cross July 2019- September 2019

Improved supplier evaluation policies to ensure portfolios of best in class suppliers are available

Developed high level process maps and flowcharts of the supply chain procedures using Microsoft Visio

Streamlined the supply chain procedures using the industry best practices to eliminate redundancies

Ensured compliance of processes with the healthcare regulatory bodies (FDA, AABB) Associate Consultant, KPMG – Technology Advisory Services April 2018- July 2018

Developed RFPs and assisted in selling advisory services by contributing for raise in revenue of over $100,000

Streamlined inspection, work order, payment, and inventory modules to improve the ERP system functionality

Drove a review of the asset management system for a leading Oil Refinery to align processes with the firms business

Delivered presentations to senior management of over 15 clients and suggested remediation measures for gaps detected Technology Analyst, KPMG Risk Consulting - Technology Advisory Services July 2016- March 2018

Performed completeness and accuracy testing of large datasets transferred to different applications to ensure data integrity

Audited compliance of IT systems with the mandated information security policies for a leading private sector bank

Verified data controls concerning system integration, batch management, program development,user acceptance testing (UAT), SDLC reviews (Waterfall and Agile) to reduce financial risks and risk of fraudulent transactions

Generated and analyzed data from MS Access and Oracle databases using SQL to ensure of accurate extraction of data

Created test cases and security controls to ensure tests scenarios adequately met the business requirement of clients

Improved GRN processing functionality in the SAP system to ensure GRNs are created for only approved items. Professional Affiliation

Certified Lean Six Sigma Green Belt Certification (CLSSGB)- NC State University May 2019 Key Skills

Data Analysis and Visualization Tools : Power BI, MS Excel, MS PowerPoint, MS Word, MS Visio

Programming Languages : SQL, Python, SAS, VBA

Relevant Course Work: Lean Six Sigma, Database Applications, Python Programming, Operations Research, Supply Chain Modelling, Stochastic Modelling, Applied Engineering Economy Academic Projects

Highway Crash Information system August 2019- November 2019

Developed an information system tool to update crash database using VBA, SQL queries and Macros

Fetched information from database for accident reporting and advanced analysis

Improved efficiency of highway authorities in allocating resource Norstar Infrastructure- Renewable Energy Project Investment Model September 2019- December 2019

Analyzed real time datasets using Python (pandas library) to assess the status and fuel sources of the renewable energy projects

Created a geographical visualization using plotly and seaborn libraries to categorize the potential projects basis their location

Performed an internal rate of return analysis of the potential projects to screen the most cost-effective investment options.

Identified top 13 most viable and cost-effective renewable energy projects Pratyush Prabhat

2780 Stantonsburg Road, Apt 2E, Greenville, NC 27834, USA +1-984-***-**** adgmg3@r.postjobfree.com needs

Contact this candidate