Big Data Analyst
- Completed HR Data Science Use Case, which will predict attrition in Bechtel's talent pools. Projected to save $5m.
- Designed and constructed data models from a Data Lake based on Apache Hive/Hadoop.
- These data models form the dashboarding and reporting which provides enterprise - wide analytics using Power BI.
Supply Chain Analyst
- Utilized SQL Server Reporting Services (SSRS) to develop a vendor scorecard used to monitor performance of vendors
- Wrote SQL queries to gather and model data from multiple complex relational databases for dashboarding & management reporting
- Piloted use of Power BI on-project and built business cases/proofs of concept for KPI dashboarding on mobile devices
- Monitored and reported functional quality & performance metrics for the Acquisition Services group
- Led efforts to flow supply chain performance analysis & actions from project to corporate level on a monthly basis for continuous monitoring & improvement
Procurement& Subcontracts OperationsSpecia/ist
- Built and maintained project status dashboarding for use by senior management across a multicompany consortium
- Formed agreements with on-site construction service providers
- Developed procurement & subcontracts procedures for project-wide use
- Developed and maintained pro formas and standard letters for use by subcontracts formation specialists
Confidential, Houston, TX
ProcurementSystems, Purchasing, Expediting
- Provided multi-project support for Bechtel's procurement system, including performing tasks to maintain a complex Oracle database
- Utilized Excel and Visual Basic (VBA) to develop an automated reporting tool to direct efforts of procurement expediting personnel as part of a Six Sigma process improvement project - saved $3.5m over 2 years
- Monitored and reported functional quality & performance metrics across multiple projects for the entire global business unit
- Performed duties in expediting, including ensuring timely delivery of all obligations on the part of vendors & subcontractors