E-mail (preferred):  david.lee@lee180.com

Phone (US):  +1 407 366 4678

EXPERIENCE SUMMARY

Top senior consultant with 8 years of direct SAP FSCM/CFM/Treasury experience with lead consulting roles in major projects including four global implementations covering North America, Latin America, and Europe in over 22 countries.  An expert in global cash pooling best practices and their integration with SAP functionality with the aim of maximizing cash investments, minimizing borrowing, and reducing transaction costs and foreign currency risk.   Worked for major Fortune 100 and 500 companies and with Big 5 consulting firms.  Specializes in designing global treasury processes that integrates a client’s organization, people, processes, and systems; creating a comprehensive solution -- not just an SAP one.  Work experience spans 15 years in the areas of software engineering, accounts payable and purchase order systems, treasury, accounts receivable, and global process design.  Industries include consumer products, medical, energy, trading, chemical, metals, and mining.

SAP CONFIGURATION AND TECHNICAL SKILLS

SIGNIFICANT PROJECTS

Client:  SunChemical and Accenture:  Cincinnati, OH  USA (Jan 06 to Present)

Role:  Accenture Global Treasury (CFM/FSCM) Process Lead and Subject Matter Expert

·          Designed SunChemical’s (SC) world-class treasury processes covering countries in Americas, Europe, and Africa by leading, driving, and guiding discussions with corporate treasury. Blueprint focused on creating a centralized treasury operation, improving operational efficiencies through a new global cash pool and in-house banking structure, and integrating them both with SC’s shared service centers.    Key characteristics include:

o         A single global banking platform with Citibank:  AP and treasury payments, auto-reconciliation and cash application with electronic bank statement and lockbox.

o         Foreign payments executed by the parent company on behalf of it’s subsidiaries using SAP’s In-House Cash (IHC) module

o         Auto-accounting, reconciliation, and tracking of intercompany transactions (trade, finance, FX, hedging, etc.) and ZBA movements using IHC.

o         A common, standardized global treasury platform whereby SC subsidiaries transact with parent for their treasury needs (FX, investing/borrowing, hedging, etc.).  Parent nets and is the only entity dealing with external counterparties.  Utilize full Transaction Manager functionality.

o         Streamlined and re-engineered processes by integrating with shared services and new global cash pool structure.

o         Introduced new SC processes for better market risk and credit risk management utilizing Market Risk and Credit Risk Analyzers.

o         Transition SC’s hedge accounting to FAS133/IAS39 compliance using Hedge Management.

o         Full integration with accounts payable and accounts receivable.

·          Met key objectives to bring treasury on schedule (brought in-scope 6 mths behind other teams), design global blueprint, resolve integration points with AP/AR teams, implement Citibank banking platform, and prepare for US and Canada rollouts.

·          Canadian (1^st rollout) and US SAP scope:  designed, configured, and tested Transaction Mgr (FX, money mkt), Cash Position/ Liquidity Forecast, AP and Treasury payments, Electronic/Manual Bank Statement, Lockbox, and Exchange Rates.  In-House Cash, Transaction Mgr (derivatives), Credit Risk Analyzer, Market Risk Analyzer, and Hedge Mgmt to be added with European and remaining US rollouts by 7/2007.

·          Led bank interface implementation with Citibank on SunChemical side as SAP subject matter expert to resolve technical and business issues while ensuring project schedules were met.  Involved validating test scenarios through Citibank’s multiple systems – CitiDirect, Worldlink, IMPS, CPS, GXS/CFS, lockbox, electronic bank statement, ETC.

·          Defined treasury and shared services roles for processes and authorization in SAP.  Provided subject matter expertise to develop appropriate training material for each role.

·          Fulfilled the role of Accenture Fix-It lead for integration testing, master data setup, conversions, cutover, and post go-live stabilization.

Client:  SC Johnson and Deloitte Consulting:  Rio de Janeiro, Brazil (Apr 05 to Nov 05)

Role:  SAP Cash Management and Accounts Payable Regional Consultant for Brazil

·          Responsible for the successful rollout of SC Johnson’s Cash Mgmt and Accounts Payable solution for Brazil including requirements analysis (blueprinting and gap analysis), vendor and customer master setup, configuration changes to match local requirements, unit testing, integration testing, cutover, and support/stabilization.

·          Resolved issues around processing nota fiscals boleto payments for both Accounts Payable and Receivable (AP and AR).

·          Bank and Customer Interfaces:  Integrated SAP payment interface with Citibank’s Paylink system; implemented Electronic Bank Statement processing in SAP with Bank Boston, Citibank, Bank Itau, and Banco do Brasil; and adapted SAP Lockbox functionality to process AR payments for automatic cash application against customer invoices.

Client:  Major European Bank and Accenture: Spain (Feb 05 to Mar 05)

Role:  SAP Corporate Finance Management (CFM) Functional Best-Practices Consultant

·          Served as expert and best-practices consultant to review current worldwide payment and invoicing solution to help resolve critical issues with SAP and its bank interface.

·          Analyzed key global business processes and SAP business roles.  Recommended changes to comply to best-practice internal controls policies for the purpose of developing a world class solution.

·          Documented future client opportunities with CFM, specifically with In-House Cash; setting up a centralized treasury operation; and global cash pooling.  Recommended system changes as preparation for future growth with the goal of providing short-term and longer-term solutions to maximize the client cost savings and ROI.

Client:  Outokumpu Oyj and Accenture: Helsinki, Finland (Oct 03- Feb 05)

Role:  Accenture’s SAP Corporate Finance Management (CFM) Functional Expert Consultant

·          Served as SAP CFM functional expert to replace previous consulting firm and thus responsible for evaluating Outokumpu’s Treasury and In-house Cash (IHC) global template in terms processes, SAP functionality used, and the current state of configuration and development.  Scope covers ~200 sites worldwide.

·          Assessed and continually improving the CFM functionality to achieve a status of a world class treasury system; encompassing global/regional cash pooling, IHC foreign payment services, IHC investment and borrowing services, IHC intercompany payments, global banking interfaces, derivatives and hedging services, managing internal and external counterparty risk (FX, interest rate, credit, etc), global cash and liquidity forecasting, automated electronic bank reconciliation and customer cash application.  Processes include integration with Outokumpu’s regional shared services organization and its outsourced AP payment factory, AR collections, and month-end general ledger processes.

·          Configured 25+ sites in four major European countries.  Covers IHC, Trxn Mgmt Cash Mgmt, Hedge Mgmt, Credit Risk Analyzer, and Market Risk Analyzer.

·          Implemented solution to process customer credit-related payments with legacy sales systems such as bills of exchange, RiBa, down payments, letters of credit, bank guarantees, etc.

·          Member of the rollout team for Germany and UK providing CFM expertise in gap analysis between local requirements and the global template, resolving issues, and implementing the solution.

·          Technical and functional expert for new and existing bank interfaces with five major regional and global banks utilizing various technologies (EDI, treasury workstations) and file formats payments and electronic bank statement processing (EDIFACT, SWIFT, LUM2, SAP IDOC, etc.)

Client:  Wrigley Enterprises and Deloitte Consulting: Munich, Germany (Jul 02- Jul 03)

Role: SAP Corporate Finance Management (CFM) Functional Expert Consultant

·          Assessed Wrigley’s Global Reference Model as Deloitte Consulting’s CFM (Corporate Finance Management) In-House Cash (IHC) Treasury expert covering US, Western/Eastern Europe, and Asia regions (20+ countries).  Led discussions for a global Treasury operation to centralize payments, to further eliminate foreign currency risk, to optimize lending/borrowing, to streamline inter-company sales/purchase transaction settlements, and to define Accounts Receivable processes for applying cash against customer invoices.

·          Managed time and resource planning for Treasury team to coordinate changes in the Global Reference Model while meeting go-live deadlines for US and Western European countries.  Tracked and reported progress in each phase of the project including problems and issues.

·          Redesigned Wrigley’s global Treasury processes and SAP configuration standards for greater flexibility and efficiencies; specifically involving inter-company netting, foreign/domestic payments, electronic bank statement processing and Accounts Receivable cash application, foreign currency hedging, and accounting for automatic zero-balancing account (ZBA) cash movements.

·          Configured and cross-trained CFM Transaction and Cash Mgmt:  electronic bank statement, US lockbox, intra-day bank statement polling, cash position, liquidity forecast, money markets (lending/borrowing), foreign exchange deals, AP F110 payment program, TR F111 payment program, and cash concentration.

·          Mapped and setup interfaces for electronic payment and bank statement/lockbox processing with Wrigley banks (Bank One, Northern Trust, Nordea, others) using SWIFT MT101 and BAI2 standards.  Wrote ABAP specs for special auto-clearing of ACH payments.

·          Redesigned Treasury authorization and roles for separation of duties requirements and tighter security controls.  Included areas in Accounts Payable and Receivable.

·          Ensured smooth go-live/cutover for each rollout wave – developed cutover plans, conducted end-user training, wrote detailed process documentation, and provided hypercare support for system stabilization.

·          Organized and conducted Power User training for the Eastern European regions on SAP CFM/Treasury transactions and the Wrigley Global Reference Model processes.  Created training material and exercises for a one-week comprehensive course.

Client: Sithe Energies and Accenture:  New York, NY, USA (Dec 01 - Jun 02)

Role:  SAP Treasury and Finance Consultant for Specialized In-house Cash Solution

·          Conducted project assessment as Accenture’s SAP Treasury expert to discuss potential Treasury solutions with Sithe’s existing SAP implementation for the purpose of maximizing efficiencies.  Presented SAP Treasury and Corporate Finance Management (CFM) features and demonstrated the concepts of an In-House Bank solution for inter-company (I/C) netting and cash flow reporting on SAP to support Sithe’s centralized Treasury operations.

·          Designed a specialized In-House Cash (IHC) and Cash Budget Mgmt (TR-CBM) solution without CFM to maximize Sithe’s return on investment on its 4.5b system.  Goal was to increase Sithe’s capital borrowing capacity to fund its major utility projects by tracking and reporting inter-company cash flow for 150+ affiliates.

·          Analyzed Sithe’s “as-is” business processes and how transactions were posted into SAP to determine necessary changes for proper inter-company (I/C) cash flow tracking and reporting.  Included treasury, accounting, payroll, and I/C power marketing processes.  Applied I/C invoicing and loan transactions to monitor and reconcile I/C cash liabilities and repayments.

·          Assisted in managing and tracking project progress, issues, and resource allocation to meet required key milestone dates.

·          Designed and wrote detailed spec for customized ABAP programs to automatically generate inter-company (I/C) loans for Accounts Payable, I/C, and payroll payment runs.  Included CO internal order settlements.

·          Created functional, detailed design, and testing specs for the IHC and TR-CBM solutions.

·          Configured TR-CBM and set up appropriate master data (e.g. commitment item hierarchies) to ensure compliance to client requirements.  Led and conducted unit and integration testing, conversion, cutover, and support.

Client:  Sempra Energy Trading Corp:  Stamford, CT, USA (Mar 01- Dec. 01)

Role: SAP Treasury and Finance Consultant for Electronic Invoice Presentment and Payment System

Functional Consulting

·          Assessed goals for Sempra’s Electronic Invoice Presentment and Payment (EIPP) web application and its interface to SAP.  Gathered business requirements, valuated options, and recommended a competitive solution to process e-invoices generated from trade settlements covering major commodities and product types within the energy trading industry (physical oil, natural gas, electricity, financial swaps, options, delivery costs, brokerage fees, etc).

·          Applied ASAP methodology to create initial project plan.

·          Consulted on the Accounts Payable payment,  bank reconciliation, and Accounts Receivable cash application processes and their impacts to liquidity forecasting.

·          Provided solution to maintain accounting requirements for trade books in SAP:  P&L reporting and interest generated from lending / borrowing with the parent company.

·          Led and managed the successful SAP 4.0b to 4.6c upgrade project.

·          Configured FI and TR-CM modules:  electronic bank statement, payment confirmation, Accounts Receivable, company code, and master data setup.

·          Identified new SAP business roles and transactions to support EIPP system.

Technical Consulting (SAP Business Connector)

·          Developed the XML interface between the EIPP web application and SAP R/3 using the SAP Business Connector (SBC).

·          Mapped XML invoices, bank statements, payments, and GL postings to appropriate IDOC’s, BAPI’s, and RFC’s for automatic upload and clearing into SAP R/3.

·          Configured technical  settings on both SAP R/3 (partner profiles) and SBC sides (server setup).

·          Defined XML specifications for bank statement and invoice uploads.

·          Programmed HTTP connection between EIPP web application and SBC for XML communication.

Client:  Enron Corp:  Houston, TX, USA (Aug 00 - Jan 01)

Role:  SAP Treasury and Finance Consultant

·          Consulted Enron Integrated Solutions Center payment and bank reconciliation processes for invoices generated from energy trading systems.

·          Maximized the Accounts Payable payment process to automate and reduce payment runs, implemented payment warehousing solution, and automated configuration of new companies (>1000 in system).

·          Proposed cash pooling solution to eliminate inter-company payments and reduce FX and bank statement transactions.

·          Stabilized post-implementation and resolved production downs/issues for Treasury, AP, and Bank Reconciliation.

·          Configured 20 company codes for Treasury/AP payment processing for major North American and European business units.

Employer:  Procter & Gamble:  Cincinnati, OH, USA (Jun 96 – Aug 00)

Role:  IT Financial Systems Analyst

Global SAP IT Manager for Treasury and Accounts Payable – Corporate Finance Mgmt (CFM-IHC)

·          Key member of global Treasury Cash Management team to create a worldwide CFM In-House Cash template solution for cash pooling/concentration, liquidity forecast reporting, electronic bank statement reconciliation, and a centralized regional payment process for Treasury and Accounts Payable.  Part of SAP project to save P&G $1 billion per year.

·          Implementations in Peru, Mexico, Canada, 7 European countries, and Malaysia. 

·          SAP configuration:  CFM-IHC Cash Mgmt (F111 TR payments, cash concentration, cash position, liquidity forecast, electronic bank statement, check deposit); FI (F110 AP payments), Treasury Management (TR payments, FX, Money Market)

·          Led IT detailed design to centralize payments for each region (North America, Latin America, Europe, Asia).  Gathered and analyzed requirements to define and implement global payment methods in all countries.

·          Led lead-site integration testing and qualification for Treasury team:  bank interface testing and SAP touchpoints (AP, PO, AA, Travel, Global Data Client). 

·          Team to define Mercator map to translate payment IDOC’s to EDIFACT PAYMUL and ANSI X.12 formats for transmission to regional banks.

·          Conducted and executed volume testing for Treasury and RFC (remote function call) performance for CFM In-House Cash SAP product co-developed with P&G.

·          Designed and wrote Autotester scripts to automate configuration testing for ~100 legal entities.

Global SAP IT Security Manager for Treasury (CFM-IHC), Accounts Payable, Purchasing, and Business-to-Business

·          Led task force to ensure all Treasury global systems and processes have quality control measures in place so Internal Controls can audit Treasury with a minimum 8 (out of 10) rating.

·          Resolve system security issues around SAP user profiles, encryption, Mercator payment map changes, preventing payment file rerouting and manipulation, separation of duties, testing with the regional bank’s production system, etc.

US Accounts Payable and Purchase Ordering Technical Support Specialist

·          Provided expert level support for P&G’s US regional Dunn & Bradstreet/GEAC Millennium AP/PO mainframe system.

·          Year 2000:  Primary technical contact for unit and batch parallel testing for a 117-job, 12-hour batch cycle.

·          Special projects:  Managed two disaster recovery drills; year-end processing; Tambrands acquisition.

OTHER WORK EXPERIENCE

Employer:  Nanoptics Inc:  Gainesville, FL, USA (Summer 95)

Role:  Business Plan Owner (MBA Intern)

·          Organized, planned, and wrote a business plan for Nanoptics’ new digital, plastic fiber optic, general radiography system – a $250K product competing in a $434 million market.

Employer:  Cardiac Control Systems:  Palm Coast, FL, USA (Jul 90 – Jun 94)

Role:  Research and Development Software Engineer

·          Prototyped next generation of pacemaker programmers using object-oriented analysis, design, and programming.  Emphasized rapid prototyping, maintenance, and graphical user-interfaces.  C++, CASE tools, etc.

SYSTEMS AND PROGRAMMING SKILLS

EDUCATIONAL BACKGROUND

UNIVERSITY OF FLORIDA, Gainesville, FL.

Master of Business Administration – Concentration in Finance - May, 1996.

Bachelor of Science Engineering - Computer Information Sciences - December, 1989.