Systems Engineer Supply Chain

DHRUV PANCHAL, BS, MS, PMP

US Citizen - Secret Security Clearance **************@*****.*** +1-201-***-**** NJ, NYC Willing to relocate/travel PROFESSIONAL EXPERIENCE

Product/Systems Engineer Lockheed Martin NJ Aug ‘23 – Present

● Managed all phases of SDLC with expertise in ETL tools, Microsoft Business Intelligence Suite - SQL Server Integration Services(SSIS), SQL server reporting services (SSRS), Alteryx with data blending, data manipulation, data sets

● Designed user-centric and deployed detailed visualizations using PowerBI including live connections with databases like Excel, SAP Hana, SAP BW, SQL, Hadoop, Alteryx etc.

● Salesforce CRM: Managing customer accounts, creation, manipulation and increasing retention by 20%

● Salesforce CPQ (Configure, Price, Quote): Prediction of accurate pricing based on given product configuration portfolio. Tech Consultant EY NYC [Clients: Retail, CPG, Life Sciences, Tech] Nov ‘21 – Jul ‘23

● Qualtrics Analytics – Conducted an end to end 4-week survey of ~200 Lamb Weston employees from IT and Business functions worldwide using PowerBI and Python analytics using different graphs like Bar charts, Stacked, Combo, Waterfall, pie/donut chart, Scatter charts etc. 85% of the survey results leaned towards maturity in the client’s IT processes and org initiatives

● Conducted Sentiment analysis of 900 comments leveraging sales and marketing tactics by 45%, found gaps and loopholes in IT stakeholders thought process with Importance and Maturity rating, requiring urgent need for CDO, CIO hierarchy restructuring

● Conducting 10-15 interviews, collecting artifacts, contracts, and performing So-what analysis with critical reasoning demonstrating various dashboards creating a compelling story to showcase current state and steps to attain desired future state

● Used stores procedures, triggers and views to provide structured data to business units by combining millions of data rows from 12 data sources and automating a Tableau Server report saving 40 manual labor hours monthly

● Successfully eliminated duplicate reporting by 99% to restructure siloed business unit teams, designing above 100 reports transitioning 500 technical and functional users with no service interruption, along with making change request to improve a workflow system reducing coordination and run time by 60% and Implemented a 24/7 workplace services effort saving 70% Systems Engineer Northrop Grumman FL Jun ‘19 - Oct 21

● Systems Eng: Increased efficiency by 32% of Live and Synthetic Air Domain Network (L&SADN) systems that support $490 million DMON for US Air Force, leading 5-10 teams, including Software Sustainment, PIE, Integration and Test, Exercise Support

● Project Management: Info, materials, cash flow of 1200 NPI Dassault BizJet tools saving $20k/day across supply chain.

● Translated business decisions into quantitative queries, evaluating data pipelines over 5 TB daily for over $10M budget project.

● QL to Supply Chain Buyer: Created 30% RFP, RFQ, contract docs in SAP aligning with strategic sourcing, indirect procurement

BI: Utilized Power BI dashboarding product/business metrics for internal/external reporting using unstructured data sets.

Data retrieving with queries and manipulation, mining columns of 3.5k work packages, 3k tool orders using SQL queries

Built ETL that ingested supply chain/mfg data from a web app with with 10000 daily active users that saved $90k annually

Traced whereabouts of tools in Microsoft Project leading execution of contracted work and flowchart on Visio saving $100k

Coordinated with the Director of Tool Engineering ensuring the planning, budgeting, scheduling, cost reporting of the Dassault tool orders, reducing tool lead time by 150 days per tool and increasing supply chain efficiency by 30% Product Ops Engineer Tata Consultancy Services CA [Client: Johnson and Johnson Medical Devices] Jan ’16 - May ‘18

Network Optimization Project: Led out-transferring 100+ capital equipment from company warehouse to external manufacturer Jabil converting from make to buy process

CCB, Reluctant cross-functional teams: Completed a master ECN by getting approvals from Finance, Regulatory Affairs, DCC, R&D, Ops, Supply Chain, Production, Warehousing, Plant/Supplier Quality, Mfg by explaining technical concepts using Tableau, Alteryx, Looker density, Gantt maps and dashboard to actionable objectives in less than expected time.

Completed in-depth analyses for business-optimization projects, reporting tools, strong KPIs, back-office programs and equipment transfer gains and losses. Measurable outcomes:

EDUCATION

Duke University, Durham NC Graduate Teaching Assistant, Data Analytics/Visualization Graduation: Dec ‘19 Master of Engineering Management Courses: Strategy, Operations, Supply Chain, Decision Sciences, Marketing/Sales New Jersey Institute of Technology, Newark NJ ASME President, Pi Tau Sigma Honors Society Graduation: Aug ‘15 B.S. Mechanical Engineering (Cum Laude), Minor: Applied Math Courses: Linear Algebra, Adv statistics SKILLS

Certifications: PMP - pmi.org, PSM - scrum.org, SAFe POPM, Data Viz: Tableau, Adv Excel, AI Foundation: ML, Python for Data Science bootcamp BI: PowerBI, Tableau, Looker, Alteryx Coding: Python 3.0 (Data analysis libraries: Numpy, Seaborn, Pandas), MATLAB Data: DDL, DML, DQL, TCL, DCL with MySQL, PostGRE, MS SQL, ETL, Kafka, Cassandra Cloud: AWS: EC2, S3, Redshift, IAM, Lambda, VPC, API Integrations Tools: ServiceNow CMDB, SAP IBP/EWM/ERP, Salesforce CRM Leadership: bias to action, deep diver, reliable, on-time, ownership, inventive, creative, curious, self-starting, disciplined, value-driven, team-player, negotiator, detail oriented, thinks big,

“make-life-easier”, entrepreneurial, collaborative, thrives in ambiguity, high pressure work

Contact this candidate