EXECUTIVE SUMMARY

 

·         Masters in Banking & Finance from Columbia University in NYC, NY.

·         8+ years of functional experience in ERP Systems, including design, methodology, implementation and process improvement using Oracle Applications EB-Suite.

·         Completed 8 live Oracle Applications full life cycle implementations.

·         Specialized in the implementation of Oracle Treasury/Cash Management following the AIM & Accenture Delivery Methods for Oracle.

·         International experience including United States, Canada, Mexico & Central America.

·         Excellent communication and team building skills

·         Fully bilingual (English-Spanish)

 

SKILLS SUMMARY

·         Oracle Applications Expertise. Treasury Module & Cash Management

·         Oracle Applications Modules: Have interacted with GL, Purchasing, Payables & Risk Management because of its relationship with the XTR module and business requirements.

·         Oracle Application Releases: 11.5.8, 11.5.9, 11.5.10.2, R12, 12.0.6

 

ORACLE APPLICATIONS PROJECT EXPERIENCE

 

 

Client: The Panama Canal Authority (PCA) Panama City, Panama.

Industry: Public Sector/Maritime Transportation

 

Role: Oracle Treasury Lead consultant Feb 10 – Present

 

Description: Senior Functional Consultant for Oracle Applications Treasury Module Implementation

 

·         Client is implementing Oracle Applications R12.0.6 in order to manage all the Treasury operations derived from the Panama Canal.

·         Work with the client in order to understand the Treasury requirements derived from the Panama Canal operation.

·         Gathered data and analyzed the ACP’s requirements in order to map them to the Treasury module’s functionality.

·         Identified gaps and proposed workarounds

·         Responsible for determining the best accounting coding (JEAs) for Bonds, Short Term Money, Wholesale Term Money, Discounted Securities and FX deals.

·         In charge of drafting all documentation needed for finalizing design, going from mapping business requirements to the XTR module and find gaps, to finish documentation on custom extensions and reports (AIM’s BP080, BR030, BR060, BR110, BR100, MD050, MD055, TE040, etc.)

·         Responsible for developing detailed test scripts for each user (normal TE040s and UPKs) and performed UAT

·         Extensive experience opening, managing, and resolving Oracle Service Requests (TARs or SRs) with Oracle Support

·         In charge of conducting CRP sessions in order to show users how XTR would be handling all their daily activities.

·         Responsible for providing training to users and creating user manuals.

 

 

Client: Oxbow Corp – Hitachi Consulting West Palm Beach, FL.

Industry: Energy and Utilities

 

Role: Oracle Treasury Lead consultant Apr 09 – Jan 10

 

Description: Senior Functional Consultant for Oracle Applications Treasury Module Implementation

 

·         Client is implementing Oracle Applications R12.0.6 globally (US, Argentina, The Netherlands, Luxemburg, Brazil, Egypt, Mexico, Belgium, UK, Germany, Spain, France, Australia, The Bahamas, India, Italy).

·         Analyzed Oxbow’s current/future business processes.

·         Responsible for data gathering for Oxbow’s business requirements.

·         In charge of matching Oxbow’s Treasury deals to Oracle Treasury functionality for revolver credit lines, letters of credit lines, notes, swaps, bonds, FX deals, intercompany funding, etc.

·         Conducted several CRP sessions in order to show users how XTR would be handling all their daily activities.

·         Proposed Accounting Structure (JEA) for all Oxbow’s companies.

·         Worked with the tech team to provide solutions as LCs, and other RICEW components.

·         Drafted all documentation needed for finalizing design, going from mapping business requirements to the XTR module and find gaps, to finish documentation on custom extensions and reports (AIM’s BP080, BR030, BR060, BR110, BR100, MD050, MD055, TE040, etc.)

·         Identified gaps and proposed workarounds for all Oxbow’s companies.

·         Developed detailed test scripts for each user (normal TE040s and UPKs) and performed UAT

·         Worked with tech team in order to generate EFT files and use Oracles functionality to transmit those payment instruction files to banks.

·         Worked closely with Oracle Support through SRs.

 

 

Client: US Steel - Accenture Pittsburgh, PA.

Industry: Steel Industry

 

Role: Oracle Treasury/Cash Management Implementation consultant Oct 08 – March 09

 

Description: Senior Functional Consultant for Oracle Applications Treasury & Cash Management Modules Implementation

 

·         Client is implementing Oracle Applications Release 12 globally (Slovakia, Serbia, US and Canada)

·         Responsible for the Oracle Treasury and Cash Management Modules implementation.

·         TREASURY

o    Work with the users team in order to:

o    Define User Access Levels (Separation of duties and controls)

o    Define System Parameters to match best options for company needs (validate deals for Accounting generation, reporting currency, warnings and limits)

o    Defined & setup all the currencies details and rates (i.e.USD, CAD, SPOT, 1yr Bond)

o    Configured Counterparty Profiles. All information for companies that we conduct business with. Especially what deals are those companies allow to perform with us (FX, MM, Equity Mkt, Risk Parties, etc)

o    Designed Own company(ies) profiles and their company parameters to match the business needs with XTR functionality (Xchange rates, Interest days, and accounting options like accounting transfer to GL)

o    Determined the best accounting coding (JEAs) for Short Term Money, Wholesale Term Money, Discounted Securities and FX deals.

o    Designed product types for Short Term Money, Wholesale Term Money, Discounted Securities and FX deals based on client’s requirements.

o    Generated and tested journal entries for non-reval/non-accrual and reval/accrual related deals and made sure they apply to the accounting requirements.

o    Designed test scripts and User Acceptance Tests.

o    Extensive experience opening, managing, and resolving Oracle Service Requests (TARs/SRs) with Oracle Support

·         CASH MANAGEMENT

o    Gather user requirements In order to:

o    Define and configure Banks, Bank Branches, Bank Accounts along with control options and parameters for use and reconciling in AP, AR, XTR.

o    Setup for Interest Rate Schedules

o    Setup CE for Bank Account Transfers

o    Load Bank Statements files (BAI2)

o    Import Bank Statement tables into CE and in order to run the Auto-Recon process

o    Run Standard Reports to verify AP, AR, XTR transactions cleared

o    Update Bank Account balances manually when necessary

o    Define and run CASH POSITIONING Worksheet

o    Define and run CASH FORECASTING Template

o    Run different reports For Bank Statements, Cleared transactions, etc.

 

Client: Government of New Brunswick, Canada. Fredericton, NB. Canada.

Industry: Public Sector

 

Role: Oracle Treasury Lead May 07 – Aug 08

 

Description: Lead SME for Oracle Applications Treasury / Cash Management Modules Implementation

 

·         In charge of the Oracle Treasury Module implementation.

·         Participated in the Oracle Cash Management Module implementation.

·         Tested bond issues to find right calculation precision and correct consideration amounts, especially on the re-openings of bonds when accrued interest price applied.

·         Worked with the GL team in order to determine the best accounting coding (JEAs) for Bonds, Wholesale Term deals, Discounted Securities, IACs, IGs, Interest Rate Swaps, FRAs and more.

·         Generated and tested journal entries for non-reval/non-accrual and reval/accrual related deals and made sure they applied to the accounting requirements.

·         Set-up for FX, Short Term, Wholesale, Discounted Securities, Fixed Income (definition, issue, re-sales/re-purchases), Derivatives, Intercompany funding, Inter-Account Transfers deals.

·         In charge of system setup regarding Settlements, Accounting, System Parameters, separation of duties using User Access Levels.

·         Ran reports on Treasury related items in Cash Management CASHFLOW POSITIONING AND CASHFLOW FORECASTING.

·         Assisted users in creating reports for Investment Limits, Portfolio Maturity, etc.

·         Responsible for gathering business requirements regarding users, mapping, data conversion, customizations and testing.

·         Conducted various series of interviews in order to study the current business processes, future business flow & identification of GAP/Workarounds in order to provide an integrated information system solution to meet the business needs of the Treasury Division.

·         Designed test scripts and User Acceptance Tests based on the client’s requirements.

·         Conducted CRPs in order to provide training, conducted practice & additional business requirements sessions.

·         Carried out Users Acceptance Test (UAT), go-live activities and post implementation support.

·         Worked closely with user to improve procedures as well as identifying and solving problems.

·         Extensive experience opening, managing, and resolving Oracle Service Requests (TARs or SRs) with Oracle Support

 

Client: QMT, a Qualcomm subsidiary San Diego, CA

Industry: Telecomm

Role: Sr. Functional Consultant Jan 06 – Apr 07

Description: Oracle Applications Treasury Implementation

 

·         Implementation of Oracle Treasury Applications

·         Study of current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company.

·         Responsible for gathering not only business requirements but also users, mapping, data conversions, customizations and testing.

·         Testing modules setup for inconsistencies and missing steps - Test scripts and User Acceptance Tests (UAT).

·         Worked with the GL team in order to determine the best accounting coding (JEAs) for Bonds, Wholesale Term deals, Discounted Securities, IACs, IGs, Interest Rate Swaps, FRAs and more.

·         Provided training & conducted practice & additional business requirements sessions.

·         Carrying out Users Acceptance Test (UAT), go-live activities and post implementation support.

·         User needs analysis, conferring with users to improve procedures, identifying and solving problems

·         Worked with Oracle Support in order to conduct the opening, managing, and resolving Oracle Service Requests (TARs or SRs).

 

Client: Grupo Bmb Mexico City, Mexico

Industry: Consumer Goods

Role: Functional Consultant Jul 04 – Dec 05

Description: Oracle Applications Implementation for Bmb.

 

·         Functional Consultant for full cycle Oracle Treasury Application Implementation.

·         Gathered requirements for customizing/formatting Reports and customized reporting requirements.

·         Defined user responsibilities gathered requirements on custom menus based on user responsibilities.

·         Provided training to end users on Treasury Module.

·         Drafted BR100 document from business requirements.

·         Unit tested all deal types used by the company.

 

 

Client: Visa International Foster City, CA.

Industry: Telecomm

Role: Functional Consultant Jul 03 – Jun 04

Description: Oracle Applications Treasury Implementation

 

·         Implementation of Oracle Treasury Applications

·         Setup responsibilities & users for the implementation.

·         Study of current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company.

·         Treasury actual process analysis required to implement Oracle Applications.

·         Customization analysis required to implement Oracle Applications Treasury as well as the applications involved with it.

·         Testing modules setup for inconsistencies and missing steps - Test scripts and User Acceptance Tests (UAT).

·         Provided training & conducted practice & additional business requirements sessions.

·         Carrying out Users Acceptance Test (UAT), go-live activities and post implementation support.

·         User needs analysis, conferring with users to improve procedures, identifying and solving problems

·         Prepared training manuals, End-User Guides for Treasury Module and all related documentation of the Project.

·         Provided post implementation support

 

 

Client: Hitachi Data Systems Santa Clara, CA.

Industry: Data Storage Solutions

Role: Functional Consultant Jun 02 – Jul 03

Description: Oracle Applications Treasury Implementation

 

·         Implementation of Oracle Treasury and worked with Cash Mgmt, Payables, Receivables, General Ledger

·         Study of current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company.

·         Functional design & development of workflow process to streamline Treasury transactions.

·         Conducted investigative troubleshooting in Oracle Treasury.

·         Prepared training manuals, End-User Guides for Treasury Module and all related documentation of the Project.

·         Provided post implementation support

 

 

OTHER EXPERIENCE

 

1998 - 2002 CONTI-GROUP (2^nd largest U.S. private company as of 1998) New York, NY

Trade Finance Department

TRADE FINANCE ASSOCIATE

• Worked with the trade finance Director in establishing credit-investment guidelines for international divisions.
• Involved in trade negotiations and the negotiation of letters of credit with banks.
• Conducted comprehensive sovereign-country risk analysis and drafted executive proposals based on results.
• Worked with financial models and forecasted future growth and opportunities for the firm.
• Prepared and presented detailed financial reports on international banking systems for senior officers.
• In charge of monitoring and following financial-economical-political events that could affect the company’s positions worldwide.

 

1995 – 1997 RGC STEELS Monterrey, Mexico

International Division

EXPORTS & SALES DIRECTOR

• Directed international sales organization and was responsible for direct sales, client development, import-export operations, logistics and credit.
• Identified and resolved costing export practices. This reengineering process resulted in an increase in sales from 720 to 8,400 tons/year and a reduction of delivery time from 14 to 6 days

• Played a key role expanding U.S. and Central American customer base by 115%.

 

1994 – 1995 PASM-SPR (Agribusiness Co.) Sinaloa, Mexico

GENERAL MANAGER

• Negotiated legal contracts with produce-distributing companies in the U.S.
• Responsible for procurement. Selected suppliers based on quality, delivery time, price and credit terms.
• Forecasted sales planned manpower, implemented controls and reviewed capital requests.
• Tracked daily financial activity, forecasted future growth, and targeted new areas of opportunity.
• In charge of getting funds for working capital with U.S. banks as well as produce distributors in the U.S.

 

 

1992 – 1994 BANORTE (FINANCIAL SERVICES GROUP) Monterrey, Mexico

ACCOUNT EXECUTIVE

·         Negotiated contract terms and interest rates with corporations.

·         Closed major deals for newly established and expanding companies.

·         Revised loans contracts and drafted reports.

 

EDUCATION

 

1997 – 1999 COLUMBIA UNIVERSITY New York, NY

Masters in International Banking & Finance

1991 – 1994 UNIVERSITY OF MONTERREY Monterrey, Mexico

Bachelor in International Commerce

 

Summer 1993 CARLETON UNIVERSITY Ottawa, Canada

Studies of the Economic Impact of the NAFTA

 

CERTIFICATION/TRAINING

 

2007 ORACLE UNIVERSITY New Brunswick, Canada

11i Implement Treasury Management Ed. 2

Enrollment ID. 1684597

 

2007 ORACLE UNIVERSITY New Brunswick, Canada

11i Implement and Use Cash Management Ed. 2

Enrollment ID. 1665448

 

LANGUAGES

 

·         Native Spanish speaker, Fluent in English, Conversant in Portuguese.

 

PERSONAL

 

·         Enjoy kite-boarding, waterskiing & fishing.