We provide IT Staff Augmentation Services!

Treasury/cash Management Consultant

2.00/5 (Submit Your Rating)

Experience Summary
technical and functional professional with over 9 years of Industry experience as a FSCM/CFM/Treasury consultant with lead consulting roles in SAP banking and Treasury projects across North America and Latin America, implementing best practices template for Consumer Product, Public Sector, Chemicals, Telecoms, Metals, Insurance and Energy industries.
A proven expert in FSCM industry best practices template with focus on IS-Banking, Collections and Dispute Management, Treasury and Risk Management and In-house Cash for maximizing cash investments, minimizing borrowing, reducing transaction costs and foreign currency risk. He is a motivated self-starter, able to quickly grasp issues and attend to details while achieving optimal result.

Skill Set

  • 9+ full life cycle SAP implementations in the financial and controlling modules and CFM/FSCM Suite.
  • Expert in SAP Treasury - TR: Cash Management, Treasury Management, CML Loans and Market Risk Management, Money Market, Foreign Exchange, Derivatives and Securities
  • Highly experienced in SAP Core Banking - IS Banking / Banking, Bank Customer Accounts (SAP BSA), Loans Management (SAP LM), Collateral Management (SAP CM).
  • Integration specialist with solid business experience in FSCM Suite including but not limited to; Transaction Manager (Money market, Foreign Exchange, Derivatives and Securities Instruments), Hedge Management, Market Risk Analyzer, Credit Risk Analyzer, Collections &Disbursement, Dispute Management, Credit Management, Cash Management-Cash position and Liquidity Forecast and Liquidity Planner.
  • Highly experienced in Bank Communications Management (Batching and Swift Integration)
  • Expert and In-depth understanding of Bank Reconciliation, Inter-company Billing and Settlement using In-house Cash
  • Expert functional and technical knowledge of Bank interfaces (i.e. Lockbox, Electronic Bank Statement, Check and Wire Payments).
  • Expert in FI - GL, AP, AR, banking, treasury, Lockbox and electronic Bank Statement processing.
  • Expert in SD/MM integration with FI (Order to Cash and Procure to Pay)
  • Expert in Swift file format and global bank Correspondence (MT 940/942, MT101 etc)
  • Highly experienced in SAP Treasury Query/Drill Down Report
  • Experience with multiple platforms ECC 4.6, 5.0 & 6.0
  • Strong written and oral communications skills
  • Expert technical understanding of different payment file format (ACH, NACHA, BAI, BAI2 and SWIFT FORMATS)
  • Highly experienced in SAP Public Sector solution
  • Experienced in SAP Tax and Revenue Management for Public Sector with Business Rule Framework (Enhanced Package 4) for tax calculation and data validation

PROFESSIONAL EXPERIENCE

Confidential,Chicago, USA June 2009 – Present
Treasury/Cash Management Consultant
I was contracted to work with business SMEs as Treasury/CFM expert in conducting a project assessment for Accenture SAP treasury transformation and designing a best of breed SAP solution for the treasury operations. Goal was to capture treasury transactions and capital borrowing capacity to fund its major projects by tracking and reporting inter-company loans and cash flow for 150+ affiliates.

• Presented SAP Financial Supply Chain Management features, demonstrated and designed SAP In-house Cash solution for inter-company (I/C) Loans and bill settlement, including transaction manager for money market operations and portfolio management, Cash Position and Liquidity forecast for cash flow reporting to support a centralized Treasury operations.
• Analyzed the “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. and loan transactions to monitor and reconcile I/C cash liabilities and repayments.
• Gathered functional requirements, coordinated and facilitated design workshops and blueprint deliverables.
• Designed and blueprinted a specialized In-House Cash (IHC) solution for centralized payments and inter-company settlement.
•Designed and blueprinted cash management for Cash position Reporting, Cash Forecast Reporting, Liquidity Planner and Transaction Manager for different borrowing and Investment processes
•Developed and maintained business process procedures, performed Finance module configuration and BCM batching rules and integration with swift network for file monitoring.
•Assist in managing and tracking project progress, issues, in order 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 in Transaction Manager.
• Created functional detailed design and testing specs for the IHC and Treasury solutions reporting needs.

Confidential,Coral Gables, Fl May 2009 – June 2009
CML Loans Management Consultant
Primarily involved in blueprinting and implementation of SAP IS-Banking Loans Management solution for LAADSA, a private investment and development company with operations in Latin America.
• Provided detailed blueprint session covering loans life-cycle with receivable management and integration with collateral management.
• Prototyped the complete loan process for Loans Given and Loans taken from potential contract to contract disbursement using Transaction Manager and FI integration.
• Helped defined a new process around the foreign currency loans valuations
• Defined a Business Partner grouping and roles and role structure as applicable.
• Documented and created BPP around the different loans product types encompassing contract creation, business operations, rollover, periodic processing and integration with cash management.
• Defined a structured incoming payment processing that facilitate quick receivables management
• Also provided 2nd tier production support for LAAD daily business after Go-Live.

Confidential,Halifax, Canada Feb 2009 – May 2009
Treasury/Loans Management Consultant
Single handedly designed an upgrade roadmap for SAP CMLoans and Treasury modules for the province moving from SAP R/3 4.6c to SAP ECC 6.0. This involves configuration and customization of different treasury and Loans product types to meet the business process design and application requirements, defining testing roadmap, including assembly test of RICEFW work units and system test.
Emphasis on business partner conversion from old to new tables, SAP Tax and Revenue Management integration with BRF (ehp4), collateral management, (RICEFWS) for Banking Services, Custom Development Objects (RICEFWS - Report, Interface, Enhancement, Form, Work flow, Service) and different treasury product types

• Presented a clear blueprint session on major improvements for SAP CML and Treasury module upgrade along with implementation roadmap.
Presented and Implemented SAP Tax and Revenue Management functionality in improving external and internal services and for optimizing receivables management and accounting systems
• Defined and Created different BRF objects for forms validation, advance payment, exception messages, taxpayer registration and tax returns processing
• Defined and reproduced the complete loan process and underlying transactions of contract acquisition from application to contract and managing collaterals (Collateral Value Calculation).
• Built a new process around Loan conditions regarding repayment settlement and Interest on Arrears calculations.
• Revamped the bank statement and payment processes, by providing a structure that allows better hit rate for cash application
• Redefined a robust cash management integration with Loans Management for cash reporting
• Provided upgrade fixes in all areas of configuration in the application areas FI-GL, FI-AP, FI-AR, Treasury and Banking.
• Redefined the flow types for Accruals and Deferrals postings and resetting.
• Maintained all documentation directly related to Loans and Treasury Management including end-to-end process flows, process documentation, functional and technical specifications and configuration documentation that reflects upgrade changes
• Defined Testing procedure and roadmap for a successful upgrade

Confidential,Andover, MA. Oct 2008 – Feb. 2009
Treasury CFM/Cash Management Project Lead
ENEL North America is an energy producing company with global operations. The project was designing its North America SAP AR, AP and Treasury implementation on ECC 6.0 platform with emphasis on SAP Dispute Management for Procurement and Sales Cycle in order to track all invoice disputes within SAP using workflow engines and Treasury/Cash Management for capturing forex trades, mitigating impact of F/X rate fluctuations, streamlining its trading transactions and cash flow management.
Blueprint focused on Dispute Management, Cash Management and Transaction Manager namely Cash Position, Liquidity Forecast, Money Market – (Interest rate instruments- long term loans/fixed term deposit/ deposit at notice and Commercial Paper) Forex and Securities – (Stocks/Bonds) product types, transaction types, condition, structure , formulae, realized profit or loss, accrual/deferral, valuation, cash flows, trading functions, accounting functions, rollover, reversal, position management e.t.c.
• Presented SAP Financial Supply Chain Management, demonstrated its concepts and use in helping the business understand functional requirements and achieving a solution for centralized and efficient Treasury operations.
• Presented Order to Cash/Procure to Pay business scenario in highlighting FI integration with SD and MM
• Led bank interface meetings with Mellon Bank as SAP subject matter expert to define technical and business requirements/scope in ensuring project schedules are met.
• Served as expert and best-practices consultant to review current regional payment and invoicing solution to help resolve critical issues with SAP and its bank interface and designing a solution for cash application using both Lockbox and Electronic bank statement
• Designed a treasury blueprint solution that complies with best practices; setting up a centralized treasury operation and global cash pooling using In-house Cash (IHC).
• Recommended system changes as preparation for future growth with the goal of providing short-term and longer-term solutions for cash management.
• Assessed goals for trading management by gathering business requirements regarding money market and securities trading and defining a competitive solution in processing different 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).
• Designed and configured Transaction Mgr (FX, Money Mkt, Securities and Derivatives), Cash Position/ Liquidity Forecast, AP and Treasury payments, Electronic Bank Statement, Lockbox, and Exchange Rates, Credit Risk Analyzer, Market Risk Analyzer.
• Designed a conversion roadmap for forex open contract and FI balance upload

Confidential,Omaha, Nebraska: April 2008 – October 2008
Treasury CFM/Cash Management Project Lead
Designed ConAgra Food’s world-class treasury processes covering countries in Americas, Europe, and Asia by leading, driving, and guiding discussions within corporate treasury and AR department. Project focused on creating a centralized treasury operation, improving AR/AP operational efficiencies using SAP Dispute Management, Lockbox and Electronic bank Statement and replacing JP Morgan’s Insight with SAP Cash Management and implementing In-House Cash for payment netting:

• Presented SAP Dispute Management and Treasury/ Cash Management to the business during blueprinting for requirements gathering.
• Designed, configured and tested Dispute Areas, Service Providers, element types, Element and different processor /Reason codes for dispute case processing automation
• Designed, configured, and tested Cash Management and Transaction Mgr (FX, Money Market, Securities and Derivatives Instruments), Cash Position/ Liquidity Forecast, AP and Treasury payments, Electronic Bank Statement, Lockbox.
• Designed and configured a foreign payments strategy executed by the parent company on behalf of its subsidiaries using SAP In-House Cash (IHC) module
• Designed an automated investment and borrowing trading processes using different product types (Loans, Fixed Term Deposit, Deposit at Notice, Commercial Paper, Stocks, Bonds and different Derivatives Instruments).
• Designed and developed an in depth Inter-company settlement procedures, bank statement and AR/AR reconciliation process (Manual and Automatic), Lockboxes, Liquidity forecast & planning processes.
• Designed and configured lockbox and Electronic Bank Statement functionality for A/R incoming automated payments
• Reorganized treasury department by setting up new procedures for cash forecasts and also designing a single global banking platform with JP Morgan for centralized EBS reporting and treasury payments.
• Developed detailed functional specifications, enhancements and modifications documentation.
• Led bank interface implementation with JPMorgan as technical and functional expert in resolving technical and business issues while translating business needs to ABAP and ensuring project schedules were met.
• Stabilized post-implementation and resolved production downs/issues for Treasury, AP, and Bank Reconciliation.

Confidential,Tennessee March 2008 – April 2008
Treasury/Cash Management Consultant
Served as expert and best-practices consultant to review and revise Propex’s SAP treasury implementation, specifically their forex and Money Market trading, global cash management activities and invoicing solution.

• Helped resolve critical issues with SAP and bank interface.
• Recommended changes that comply with best-practices policies on trading and cash management processes. (Electronic bank statement processes, implementation of services and foreign exchange activities, and funding of foreign operations.)
• Analyzed key global business processes and complex business requirements in areas of Transaction Management, Cash Management, In-house Cash, Bank Accounting, Cash Management and mapping them to standard SAP processes.
• Reviewed the company’s Global bank entities & advised on plan and strategy on consolidation, future SAP In-house Cash implementation for centralized payments
• Developed various reports related to payment card processing.
• Provided required expertise in design validation, and making sure delivered implementation is based on best practice, standards, methodology and guidelines.
• Provided required expertise in design validation of Dispute Management Module.

Confidential,Denver, Colorado September 2007 – March 2008
Senior SAP FSCM Project Lead
Single-handedly designed and implemented the SAP Financial Supply Chain Management module. A key objective was to bring treasury on schedule (brought in-scope 6 months after project start), by designing a global blueprint for treasury and dispute managements.
This requires assessing JM’s different payment deductions, trading and cash management requirements, defining a roadmap that meets treasury, A/P and A/R business needs and ensuring configuration matches these requirements for financial budgeting.

• Led discussions for a global Treasury operation in eliminating foreign currency risks, optimize lending/borrowing process, streamline inter-company loans, sales/purchase transaction settlements, and liquidity forecast in cash planning.
• Facilitated FI AR, AP and Cash workshops and prototyped business requirements.
• Reviewed the company’s Global bank entities & advice on plan and strategy on consolidation, implementing SAP In-house Cash for centralized payments across foreign entities
• Responsible for all aspects of cash management, AR and AP including payment card processing, requirement analysis, requirements gatherings, system customizing and testing, legacy data conversion, user training, and report development.
• Defined and configured the structure required for short term and medium term liquidity monitoring using Grouping Structures and Planning levels for cash position and forecast with value-dating for Cash funding and investment.
• Redesigned Johns Manville’s dispute management processes for greater flexibility and efficiencies; specifically AR and AP payment deductions
• Worked with developers to design and test custom 1099 tax reporting transactions and related reports.
• Designed and configured EBS/Lockbox for processing account receivables and cash application using different reason codes
• Designed different SAP Query reports for account statements and aging reports.

Confidential,Philadelphia, PA June 2006 –August 2007
SAP SENIOR FICO CONSULTANT (FI, FSCM)
Public Sector, Chemicals, Metals, Telecoms and Energy Industries
Designed and implemented FI modules (GL, AP, AR, Payment Card, FSCM /CFM) for various industries with focus on IS- Banking CML, Collections and Dispute Management, Cash Management and global treasury processes covering countries in Americas and Europe by leading, driving, and guiding discussions within corporate treasury, A/P and A/R departments. Involved in many full life cycle Implementations from Blueprinting to Go-live for different clients with focus on treasury and cash management implementations for improved operational efficiencies through a new global cash management and in-house banking structure if required.
Interfaced with several global banking platforms primarily with JP Morgan Chase, Scotia bank Inverlat, Scotia bank Canada, Deutsche Bank, Wells Fargo, HSBC and Bank of America: AP and treasury payments, Payment Card auto-reconciliation and cash application with electronic bank statement and lockbox (ACH, BAI2, MT940, NACHA etc)

• Implemented FSCM Module BP template on different projects (Collections & Dispute Management, Cash Management, and In-house Cash) from Blueprinting to Go-live for different industries.
• Implemented SAP IS-Banking solution for a public sector organization specicifically Loans Management
• Implemented SAP’s In-House Cash (IHC) for foreign payments on behalf of subsidiary Company Codes
• Implemented SAP Tax and Revenue Management with Business Rules Framework Integration
• Defined and created different business rule sets for taxpayer registration, Billing and Invoicing, Advance payments and refunds
• Designed and implemented 3 full lifecycle projects in different industries including a public sector project with common, standardized global treasury platform (FX, investing/borrowing, hedging, etc.) with parent entity dealing with external counterparties utilizing full Transaction Manager Functionality.
• Designed, configured, and tested Transaction Mgr (Money Market, Securities, Forex and Derivatives), Cash Position/ Liquidity Forecast, AP and Treasury payments, Electronic/Manual Bank Statement, Lockbox, Exchange Rates, In-House Cash, Transaction Mgr, Credit Risk Analyzer, Market Risk Analyzer, and Hedge Mgmt.
• Modified the ECCS Hierarchy and created a new Tax Hierarchy to reflect new Legal Corporate Organizational Structure, and Corporate Tax Structure to include many domestic entities namely each states in the US
• Led bank interface implementation with different banks as SAP expert to resolve technical and business issues while ensuring project schedules were met.
• Developed Foreign Currency strategy for Document and payment application
• Configured Account Payables as related to SAP best practices (House banks, Payment Program, Manual payment, Vendor Master, tolerances etc.)
• Configured and Defined business rules on Account Receivables as related to SAP best practices (Payment terms, Dispute/Reason Codes, A/R Tolerances, Credit Management, Tolerances, Customer Master etc Dunning)
• Legacy data conversion using LSMW for data conversion/upload.

Confidential, Jan 2001 – February 2006
SAP SENIOR FICO CONSULTANT

Was part of a team in a nationwide and global implementation of SAP FICO module for a telecommunication company, involved in all phases of the project from Preparation to Go Live. This project involved the implementation of SAP 4.6 on a 3 phase global roll-outs in different markets with interfaces to the existing legacy systems which include the conversion of Customer master and Accounts Receivable and an interface from Legacy system to SAP.
A key member of global Treasury Cash Management team that designed a solution for centralized treasury operation, improving the company’s investment and borrowing operational processes and re-engineering its cash management processes.
Implementations were in Peru, Mexico, Chile, Argentina and Brazil.
• CFM-IHC Cash Mgmt (F111 TR payments, cash concentration, cash position, liquidity forecast, electronic bank statement, check deposit); FI (F110 AP payments), Transaction Management (TR payments, FX, Money Market Instruments)
• 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.
• Responsible for developing blueprint documentation, configuration (FSCM, Treasury Banking, AR, AP, GL and SPL configuration) and test cases for system testing
• Helped produced and reviewed BPPs (Business Process Procedures)
• Defined and configured Customer master data for A/R and Cash processing, credit Management, Collections Management and Dunning.
• Implemented SAP Dispute Management for processing customer invoice complaints.
• Developed day/month-end bank reconciliation and close procedures. Provided training and production support for business users.
• Defined and configured house banks, down payments, outgoing payments, Bank statement processing and exchange rates according to best practices and business needs

EDUCATION & TRAINING

  • B.S. degree in Architecture
  • Certified FICO Consultant

We'd love your feedback!