David Last Email & Phone Number

Wayne, NJ, US

Smithfield, Virginia, US

• As data and integration architect, lead various projects to assess and realize opportunities to streamline business processes and reduce overall IT spend.
• Architected, stood up, and managed a data integration center of excellence using Dell Boomi and IBM APIC on Azure cloud. Coordinated with executives and business users to design a standard set of reusable data services.
• Led SAP data conversion effort to migrate and integrate warehouse systems from a major manufacturing acquisition
• Led the design and implementation of a comprehensive master data management and workflow solution to collect and maintain master to integrate with SAP

Chicago, IL, US

• As global data architect, facilitated company-wide assessment of data systems and landscape to create portfolio of IT enhancement projects.
• Streamlined management and integration of internal and external data
• Managed multiple projects to implement the automation of master data, product lifecycle data, HR data, and sales and operation planning

Purchase, New York, US

• Lead data architect in Pepsi’s company-wide initiative to create a fully connected vending equipment environment.
• Designed data structures and integration methodology to facilitate automatic data collection and inventory reporting from vending equipment around the world
• Collaborated with business leaders, developers and outside vendors to create an overall process, data model, and data governance for collecting and managing equipment data from various equipment types

Greater Chicago Area, IL, US

• Led master data merger effort following Kraft’s purchase of Cadbury
• Project lead and architect for the Cadbury integration effort
• Responsible for merger of Cadbury data into Kraft’s primary master data management system
• Developed business intelligence solution to report on overall global specification data

Stadtkreis 5 Industriequartier, Zurich, CH

Designed SQL Server based operational data store and data warehouse to consolidate trade order management, investment accounting, and custodian account data. Created automated ETL environment using SSIS to facilitate data transfer to and from multiple vendors. Created automated reconciliation routines to provide business with near real-time operational.

Purchase, New York, US

Designed Oracle based data warehouse and transactional database to support completely redesigned customer master system. Performed extensive analysis and JAD sessions with business users and created overall architecture for new system. Worked with Legacy teams and outside vendors to determine what aspects of customer data could be completely redesigned.

Greater Chicago Area, IL, US

Over this period, I worked in several divisions of Kraft Foods on a number of different projects as follows:Responsible for designing a global data warehouse and business intelligence system to provide analytics and product quality alerting to the Consumer Relations and Quality Assurance divisions. Integrated data from over 60 countries’ front-end call.

New York, NY, US

Managed Oracle based reporting effort for EZPass and TCA roadways to develop various financial, operational, and inventory reports for automated toll collection system. Examples of reports include financial reconciliation, general ledger, toll usage, toll violations, and inventory tracking.

London, England, GB

Managed team to develop an Oracle based client/server intranet application to facilitate the reconciliation of defined contribution retirement funds. The application, which takes feeds from different mainframe sources, allows the user to manipulate financial data, perform an on-line reconciliation, and produce a number of reports and proofs.

Des Moines, Iowa, US

Responsible for developing a centralized client-server SQL database and front-end designed to store and manage financial information for defined contribution retirement funds (e.g. 401K funds) administered by Bankers Trust. The system’s primary tasks are to calculate a fund’s unit value and manage reconciliation of a fund’s trust accounting and participant.

New York, US

Developed centralized client-server database system to manage company’s contract proposals, contract administration processes, and contract billing using Microsoft SQL Server, Visual Basic, and Microsoft Access.