Uploaded File
add photo
Philip
philipd.drost@gmail.com
954-256-3262
Orlando, FL 32804
BA/ PM
15 years experience W2
0
Recommendations
Average rating
4
Profile views
Summary

Business Analyst * Project Manager * Supply Chain Management

Proven track record of improving IT infrastructure and operations for the manufacturing, retail and distribution verticals. Successfully planned and deployed operations for new customers as a Logistics Engineer that reduced cost. Applied information technology and rigorous analysis in delivering high value planning and implementation services to achieve improved operating results. International experience in business Supply Chain operations and systems including TMS, WMS and Trade Compliance.

Skilled in: Warehouse Management / Inventory Control / SC Network Development / Project Management / Order Management / Data Integration and Mapping/ Transportation Management / International Experience /

Experience
Independent Contractor
Jan 2014 - present
Customer facing roles on various projects and programs in the Supply Chain/IT area. Electronic Commerce, systems integrations, catalog pricing files, transportation rate analysis, SDLC enhancements to existing applications and data analysis. Skilled in MS Office products, SQL and Access.
  • Developed a quarterly agent commission report utilizing several data sources (Sequel DB, Oracle BI, Avaya CMS, QA reports) to extract data summarized in Excel using pivot tables to meet company requirements.
  • Revised methodology for a KPI sourcing report to manage monthly purchasing activities. Used Teradata SQL queries, SAP Business Objects and Excel to summarize the data into a PowerPoint presentation delivered to executive managers.
Avaya Data Analysis SDLC SQL Systems Integration Oracle Microsoft Excel Business Objects
Remove Skill
Supply Chain Business Analyst
Jan 2010 - Jan 2014
Managed supply chain programs including on-line parts exchanges, order management and warehousing systems. Used SQL queries to analyze data, reviewed WSDLs for building web interfaces, built pricing files, led WMS application upgrades or enhancements including requirements definitions, use cases, design, testing, user training, user acceptance and implementation to production. Collaborated with business to document and verify processes, identifying alternatives and implementing improvements.
  • Developed and administered a WMS training program for new employees/users. Included slide presentation, hands on application training and user certification.
  • Created pricing files from several Access DBs (joining files) manipulated data into a positional file layout for uploading to a 3rd party parts exchange via FTP.
  • Managed the SDLC for a modification to the existing proprietary WMS, enabling electronic submission of work orders to vendors (and subsequent vendor responses). Included JAD sessions, requirements definition, SOW, Unit and Integration testing, User acceptance testing, and go-live support.
Business Analysis SQL Database Upgrades SDLC
Remove Skill
Senior BA/Integration Consultant
Jan 2005 - Jan 2009
Constructed demos for pre-sales conducted conference room pilots created training programs (concept and configuration) developed integration/interface requirements and configuration with Host systems (SAP, Oracle, QAD, JDEdwards) collaborated with client on future state processes, including transportation Rules and Rulebooks, Electronic Routing Guide configuration, Transportation rates/rating, and compliance control for imports/exports.
  • Member of the on-site team at seven customer facing implementations.
  • Revised the methodology for creating and uploading transportation rates into the Precision TMS application, which reduced the process by 50 percent.
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
English Literature
Illinois Wesleyan University
Record has not been verified.
Kent School of Business
Record has not been verified.
Training
Illinois Institute of Technology
Record has not been verified.
Certifications
CSCMP SCpro Fundamentals Comprehensive Certification, Broward College, Miramar, FL
Skills
SDLC
2021
10
SQL
2021
10
Avaya
2021
6
Business Objects
2021
6
Data Analysis
2021
6
Microsoft Excel
2021
6
Oracle
2021
6
Systems Integration
2021
6
Business Analysis
2014
4
Database Upgrades
2014
4
Data Integration
0
1
Warehouse Management
0
1