ALEXANDER BAIN

Des Plaines, IL ***** – 312-***-**** – ad4j99@r.postjobfree.com

Summary of Qualifications:

SCM experience in US Army, Automotive, Consumer Packaged Goods, Defense industry

SAP, MS Excel, Word, PowerPoint, PeopleSoft, Oracle, CADSTAR, ISE, Citrix, TcEnterprise

EXPERIENCE

Consultant Nov 2019 – Current

CDC (Procurement, Contract)

Preparation of documentation for the procurement of materials and services across Department of Health

Enforcement of price reasonableness through full and open competition or sole/limited source solicitations

Developed strategies in partnership with the IT team to support global supply chain operations.

Provides strategic counsel to senior management, and employees by maximizing efficiency, driving productivity, and application of the company’s Lean Management system. Accepts direction from senior management.

Configure Microsoft Dynamics 365 enterprise resource planning implementation projects.

Collaborate in a team and with the client to complete configuration tasks, problem solve system solutions, ensure functionality, train new users, and provide post-project support.

Construction of procurement packages in support of Program/Contracting Officers in laboratory environments

Recording and maintaining documentation of strict Agency compliance to FARS regulations for future audits

British Petroleum - (Renewable Energy/Carbon Tax Credit Manager, Contract), Chicago, IL

Inventory Calculation and Reconciliation of Renewable Item Numbers (RINs), Low Carbon Fuel Source (LCFS) and Carbon Fuel Source (CFS) credits

Created and posted Journal entries for Transactions concerning Renewable Energy Credits among Refineries, Supply Chain Management and Trading and Shipping

Abbott Molecular (Commercial Excellence, Contract), Des Plaines, IL

Assignment due to Covid-19 overstressed compacity of supplying Oncology tests to Abbott customers

Without the supply necessary to meet market demand, allocated available materials to customer purchase orders based on calculated demand from Abbott Link testing volume data and real-time history of consumption

Reported to Congress, Senate and White House the number of Covid-19 tests sold, shipped and conducted

Northrop Grumman (Supply Chain Planner) Rolling Meadows, IL Dec 2011 – Nov 2019

Mentored new employees onboarding, training on SAP, BI, BO, RFQ, RFI, BOE, etc… standard processes

SAP Business Objects / Business Intelligence (BO/BI) was used to identify material and material cost ownership, through BO report I changed my forecast of material receipts on a monthly basis based on the intelligence I gathered

Managed procurement of semi-constructed components and indirect materials for multiple (12+ simultaneous) design programs, sourced material and developed new suppliers to manufacture per Engineering design drawings

Cost Account Manager for labor and material accounts, (Supply Chain Program Managers, Technical Design Team Analysts, Category Managers, Sub-Contract Managers, Requisition Writers and Mission Assurance personnel),

Ensured that program functional areas stayed within budget, calculated (EAC) estimates at completion and modified (CTC) cost to complete throughout programs’ POP, (total expenditures: $660k - $22.7MM)

Primary liaison among Program Office, Contracts Representative, Program Finance Office (SCM Material and Labor), All Sub-Contract Managers and All Suppliers for each individual program

Drafted and executed (PIEA) Proprietary Information Exchange Agreements with other companies in cooperation with (NGSC) Northrop Grumman Systems Corporation legal team, External Suppliers and NG Programs

Implemented MS Excel Macro programs, on my own initiative, to ‘clean’ SAP replenishment reports into a useable format for all the Supply Chain functional employees for use on their own individual programs of responsibility

Produced monthly reports; on time/late to deliver orders, material cost and historical cost comparison, actual expenditures, purchase order commitments, material not yet committed to and estimated cost at program completion

Attended Sector level business conferences in Baltimore MD, Buffalo NY, Apopka FL and St. Augustine FL

Followed the Standard Operating Procedures to properly evaluate and document Sole Source Justifications, In House Manufacturing Cost Estimates, Similar to Material Analysis comparisons and Price Justifications

Completed dozens of developments and build to print programs, incorporating new product design with frequent revision notifications, drawing changes and added BOM items to be sourced, price estimated, quoted and procured

Accepted $100MM+ responsibility outside of my organization to satisfy lack of manpower due to employee turnover

Provided $20MM+ financial spend plan forecast with explanation of variance to previous month forecast and actuals

Posted financial and material status charts to program boards every morning before 8am, tracked expenditure overages and maintained supplier relationships to stay informed of long lead parts, rework issues and late shipments

Administrator responsible for all Internal Work Orders (IWO) of the Rolling Meadows Northrop Grumman Mission Systems entity; creation of IWO, Requisition, placement of Purchase Order, documentation of Terms and Conditions, compliance to FARS/DFARS regulation, documented Statement of Work and activated IWOs

Reconciled and adjusted more than $10 Million of ‘parked documents’; (journalized accounting transactions) from a program’s material/labor cost account back onto the correctly associated Purchase Order account for the Program

Established new vendors of obsolete parts ($25k authority), bartered agreements with NGSC Terms & Conditions

United Airlines (IT Finance, Contract) Chicago, IL Aug 2010 – May 2011

Merger Consultant $421.6MM financial model for integrating United and Continental Airlines’ IT systems

Financial Model for the merger was created across 16 MS Excel Worksheets all interacting without necessity of refreshing a pivot table through the use of formulas

Developed procurement services process mapping documentation for strategy, planning and measurements

Researched One Time Costs necessary to discontinue current IT services in favor of scaling up those of Continental

Compiled retirement costs related to the elimination of existing programs and legacy applications

Built future scenarios and baseline cost models using actual historical spend, budgeted and forecasted amounts

Audited vendor invoice records, actual payment releases and Project Portfolio Management for accuracy

Kraft Foods (Supply Chain Financial Analyst) Northfield, IL Feb 2009 – May 2010

North American Finished Goods Inventory Control Team

Navistar (Senior Financial Analyst) Warrenville, IL May 2006 – Oct 2008

United States Army (Captain) May 2000 – Oct 2004

EDUCATION

Michigan State University, Eli Broad Graduate School of Management, East Lansing, MI

MBA, Finance & Supply Chain Management 2004 - 2006

Bachelor of Arts, Accounting 2000

APICS: Chicago Chapter, CSCP Course completion

Volunteer: Habit for Humanity, Feed My Starving Children, American Red Cross, Bet-El Mission Center Tijuana Mexico

Contact this candidate