Post Job Free

Resume

Sign in

Data Engineering

Location:
Boston, MA
Salary:
65000
Posted:
January 13, 2021

Contact this candidate

Resume:

KARAN PARIKH

Boston, MA 603-***-**** adjemd@r.postjobfree.com

Education

Northeastern University, Boston, MA December 2020

M.Sc. Industrial Engineering- Relevant Courses: Supply Chain Engineering, Probability and Statistics, Operations Research GPA- 3.71 K.J Somaiya College of Engineering, Mumbai, India May 2017 B.E Mechanical Engineering- Relevant Courses: Supply Chain Management, Project Management, Production Planning CGPA-7.33 Skills

Certification: Lean Six Sigma Green Belt, SAS Business Analytics Professional, Tableau Analyst, Supply Chain Engineering Management, APICS-CPIM Technical: SQL, SAS, Minitab, MS Office, MS Project, Tally-ERP, Tableau, PowerBi, R Studio, Python, Arena, AutoCAD, SolidWorks, Lingo, ANSYS, SAP Professional Experience

Wayfair LLC., Boston, MA Supply Chain Operations Co-op Jul 2019 - Dec 2019

• Ideated weighted outreach to 150+ suppliers/vendors by writing e-mails and communication via phone, increased volume-weighted coverage of assembly guides by 8% (71%->79%), reduced high-cost resolutions with $320,428 potential GIE savings (12.07% GIE/Wholesale cost)

• Troubleshot replacement part lead time discrepancies using VLOOKUP, standardized replacement part lead times and increased fill rate to 93%

• Monitored head supplier key metrics and reported bottlenecks using pivot tables during peak season, to drive continuous improvement

• Analyzed 200 tail suppliers using sensitivity analysis to optimize and set their replacement part lead times based on the analysis, improving lead time related late order deliveries, waterfalling and miss-shipments by 12% for small and large parcel shipments and distribution networks

• Performed root cause analysis on Wayfair Automated Lead Time (WALT) tool to gauge supplier’s performance metrics and Key Performance Indicators

(KPIs) using ad-hoc queries to pull data, resulted in ~2% accurate and scalable lead time settings for supplier portfolio

• Reported WALT performance trends and suggested performance settings improvements to senior management using DMAIC and reporting tools

• Automated WALT supplier coverage to 40% volume by analyzing and adding 4300 suppliers to the logical algorithmic tool- improved advertised lead times, saved ~$340,00 due to late orders and continuously evaluated supplier performance

• Investigated and reported replacement parts cancellation trends which resulted in high-cost resolutions to negotiate supplier replacement part agreement and catalyst a process improvement plan to promote an agile environment

• Prepared a case study for parent-child inventory feed level conflict for 2644 suppliers resulting in 1-day reduction in delivery days for a scope of virtual 2- day delivery badging and increase projected fill rate to 95.6% with $28,260,219 impact on business

• Computed potential annual savings of $3,177,706 in capping strategy for high volume and bulk eligible suppliers by performing logical analysis R.S Trading, Mumbai, India Production Engineer-Trainee Feb 2018- May 2018

• Implemented procurement, strategic sourcing and supply operations-Increased profit by 7.8%, reduced inventory by 10.7% and lead time by 10 days

• Managed business operations and supply/demand planning team of 6, increased overall productivity by 4.3% and efficiency by 1.1%

• Created a VSM model and optimized packaging using truckload for rapid growth into a pull model and worked cross-functionally with other teams

• Streamlined administrative documentation, manufacturing units, supply chain methods, warehouse facility and dispatch process using Tally-ERP Orion Racing India, Mumbai, India Project Associate- Manufacturing and Marketing Apr 2014- Jan 2018

• Improved manufacturing workplace and inventory management, reduced lag time and waste between processes by cooperating and applying problem- solving lean principles like Kanban, 5S, Kaizen, PDCA principles and material planning for JIT manufacturing using Minitab and MS office

• Sourced 3rd party manufacturing of components, adhering to the budget and rating manufacturers on job capability, credibility, cost-effectiveness and capacity to balance workload

• Formulated finances and composed Business Plan Executive Summary for a creative Business Plan Presentations using MS PowerPoint and Macros

• Incorporated a business strategy, forecasting, logistics, warehouse plan, product scheduling and product life cycle concept in the Business Plan

• Developed cost and manufacturing report, C-BOM (Cost-Bill of Materials), process flow charts of system assembly and manufactured parts

• Worked on plant flow, project documentation and production processes using Gantt Chart to adhere to project timelines

• Procured 1.8 million financial sponsorship by branding, public relations, negotiation, collaboration and promotion

• Led the crowdfunding campaign of 3,400,00, improvised the marketing strategies using interpersonal skills in a leadership role Projects

Data Management and Database Design Property Management System SSMS, Toad Data Modeler, SQL, PowerBI

• Designed a database to keep track of property information/attributes to provide hassle-free customer experience using SQL queries

• Collected and analyzed raw data, created a dynamic database and an entity-relationship diagram stating business rules using toad data modeler

• Applied stored procedures, functions, triggers and created a dashboard to visualize customer data for target analytics Seaport and Inventory Model Simulation ARENA Simulation

• Modeled a simulation of port and warehouse inventory using Arena Simulation, optimized profit based on input parameters and desired goal

• Optimized resources available and analyzed reports of inflow of goods from freighters into the port and warehouse till dispatch with time management

• Compiled reports, resulting in an optimal inventory of 3352 units for 1$ product cost, 10% inventory holding cost/day and 10 days replenishment time SAS Visual Business Analytics Professional Certification Orion Star Sports and Outdoors SAS Visual Studio and SAS Data Analytics

• Prepared data and developed reports using visualizations by adding styles, graph level display prompts, ranks and actions on SAS Analytics

• Calculated the impact of delivery times, number of orders and shipping date through online and catalogue channels (E-commerce) which resulted in increasing the availability of fast-moving and high demand products for quicker delivery days near hotspot locations to increase profits

• Forecasted sales, orders, profits and created aggregated measures to calculate yield rate of products

• Provided insights on notes taken by the customer service team using text and sentiment analysis to improve on recurring issues and low NPS AdventureWorks Business Intelligence MySQL, PowerBI, Tableau

• Analyzed AdventureWorks Datawarehouse to provide insights on business requirements, tracking entities in the dimensional model

• Visualized data on the designed Datawarehouse by creating interactive dashboards using rank, calculated fields and geo maps Weightlifting Performance Monitoring Data Mining for Engineers R Studio, MS Excel

• Built a machine learning model, performed data preprocessing on a CSV data set and converted 39243 samples to classify the type of error

• Transformed correlated features on the training data set into principal components for the test data using principal component analysis

• Predicted errors using KNN, Decision Tree, SVM, Neural Network and Random Forest methods and justified the best fit model for the dataset



Contact this candidate