Christopher Weber Email & Phone Number

San Antonio, TX

Technical lead, End to end Digital Warehouse development: Technical discovery, Consult with internal team, Establish project goals, Development, Implementation, Testing, Client approval, Documentation and training

• For SPOT Analytics at Advanced Operations Partners (AOPartners)
• Served as the Technical Lead on a data warehouse project for a major wine manufacturer
• Resulting solution merged data from the client's main ERP and multiple Excel based sources
• The management team used the tool to report on production (plan vs actual), run rate, inventory, months of supply, raw material needs, and financials. The solution provided one data source for all departments to.

• For Advanced Operations Partners (AOPartners)
• Served as the Technical Lead on a data warehouse project for a major medical laboratory instrument manufacturer
• Leveraging a preconfigured data warehouse template, the normal stand up development time was reduced from eight weeks to two, allowing the team to quickly start receiving, consolidating, and normalizing data
• Resulting solution merged data from two ERP instances, Salesforce, third party vendors, and Excel based sources
• The management team used the tool to report on sales, top customers and products, and attachment rate. The attachment rate calculation was used to better predict the pull through value of consumables after an.
• Data was orchestrated through Azure Data Factory, stored in SQL Server, and visualized through Microsoft Power BI

• For Advanced Operations Partners (AOPartners)
• Served as the Technical Lead on a inventory right-sizing project for a major restaurant supply company
• Leveraging a preconfigured data warehouse template, the normal stand up development time was reduced from eight weeks to two, allowing the team to quickly start receiving, consolidating, and normalizing data
• Resulting solution monitored inventory data from five divisions and allowed the management team to decrease overall inventory volume, meeting true demand, and normalize back to levels consistent with pre-pandemic values
• Data was orchestrated through Azure Data Factory, stored in SQL Server, and visualized through Microsoft Power BI

• For Advanced Operations Partners (AOPartners)
• Served as the Technical Lead on a data warehouse project for a major milk producer
• Resulting solution consolidated information from 24 legal entities and multiple third-party applications
• Orchestrated data through Azure Data Factory, and visualized information through Microsoft Power BI, covering segments: Safety, Human Resources, Quality, Service, Accounting, and Environmental

• For Advanced Operations Partners (AOPartners)
• Served as the Technical Lead on a multi-year, large scale transformation project for a major private label food manufacturer
• Resulting data warehouse consolidated information from 13 internal ERPs and multiple third-party applications, visualized data through Microsoft Power BI, and generated reports for executives and employees throughout.
• Solution Covered: Procurement, Supply Chain, Forecast, Production, Warehouse, Sales, Open Orders, Transportation, Quality Assurance, Environmental, Health, & Safety, Human Resources, and Training

• For McDaniel + Cullen
• Served as the Technical Lead on a merger and acquisition project for a major energy company
• Resulting data cube consolidated invoice and PO information from both organizations, visualized data through QlikSense, and generated reports to assist with the identification of synergies between the two companies
• Solution Covered: Invoices, PO, Vendor, Category

• For McDaniel + Cullen
• Served as the Data Manager for an SAP ERP data migration project for a major energy company
• Mapped out all existing data collection processes, extracted and consolidated data to a central database, and populated pre-defined templates for upload to SAP
• Solution Covered: Invoices, PO, Vendor, Customer, Item, Bill of Material

• For McDaniel + Cullen
• Served as the Technical Lead on a spend cube and strategic sourcing project for a major energy company
• Resulting data cube consolidated invoice and PO information from both organizations, visualized data through QlikView, and generated reports to assist with the identification strategic vendors and categories that would.
• Solution Covered: Invoices, PO, Vendor, Category

• For Boston Consulting Group
• Developed an optimization application for a major pharmaceutical manufacturer
• The tool uploaded product, line, and changeover data, identified high volume/low volatility products, determined economic order quantity, applied constraints to an optimization formula, determined optimal product line.

• For Kearney
• Developed dozens of direct, indirect, and MRO strategic sourcing applications
• My innovation was the development of a flexible database structure that can quickly mold itself to any unique commodity
• Resulting applications allow for commodity specific data elements to be incorporated into a standard reporting model
• This foundation allows for fast and reliable analysis of bids, consistent forms of communication with external suppliers, and a normalized reporting structure for internal managers