Oracle Project

Page * of * Raquel Anamaria Frame Allen

Raquel Anamaria Frame Allen

Senior Principal Consultant

e mail: ***********@*****.***

Telephone: +1-202-***-****

I have over twenty years of experience in all phases of design, development, and

implementation of computer applications. I am fluent in Spanish, and English. I have

worked for clients within manufacturing, communications, retail sales, government and

military (US and Foreign), and banking. I have experience with the US Air Force

Financial, Transportation, and Commissary systems. I was very critical for the

Government of Paraguay to secure IMF Funding. I enabled Paraguay Corporate

Organizations to submit and process corporate taxes and financial documents via the

Internet using Oracle Financials Suite and Customized Applications. I enabled a large

Mexican Manufacturing Center to gain better control and forecasting of Budgets by

consolidating several sets of books to a single corporate set of books. I have in depth

knowledge and expertise in multi language, multi organization and multi currency

business financial structures. My technical area of expertise is Java, Oracle Forms, Oracle

Reports, SQL, PL/SQL, APIs. My areas of functional expertise include Global Oracle

Financials (GL, AP, AR, FA), Enterprise Asset Management (eAM), Oracle

iProcurement/Purchasing, Procure to Pay, Quote to Cash, Order to Cash, Inventory, Oracle

Order Management, Oracle Human Resources, Time & Labor, and Payroll Interface. I am

adept at facilitating sessions defining user requirements, developing and delivering end

user training, creating and maintaining project schedules, and preparing and presenting

project briefings to executives. I have management, functional human resources and

technical application development experience.

Professional Experience

Applications My experience in the area of application development began early in my

career when I graduated from the University of Nebraska at Omaha. My

Development.

first project was in Business Basic on the IBM office computer systems

automating Accounts Payable, Accounts Receivable and Payroll Systems .

In 1987 I began developing applications in Oracle using Forms, Reports,

PL/SQL and SQL. Later I added web enables applications such as Perl,

C, Java, HTML and XML when Oracle moved from 10.7 to 11i. I have

been involved in the teaching of Forms, Reports, PL/SQL, SQL, Java,

Perl, HTML and XML using Dreamweaver. In 1996 I began working

e mail: ***********@*****.***

Page 2 of 5 Raquel Anamaria Frame Allen

with Oracle Applications and APIs to load data in addition to creating

customized forms, reports, functions and procedures in Oracle Financials,

Purchasing, Project Costing/Billing, Order Management and Human

Resource Management System.

Oracle Applications Oracle iProcurement/Purchasing, Projects Costing, Inventory HR

iProcurement/Purchas Core, HR Payroll, HR Self Service, HR Intelligence Technical: I was

ing, Projects Costing, responsible for providing technical and functional support for setups,

configuration and updating the BR100 Setup and Configuration step

Inventory, HR Core,

document. The implementation impacted Procure to Pay, Quote to Cash

HR Payroll, Self

and Order to Cash. I was responsible for creating interfaces for

Service, 11.5.10 and

rd

Rel 12 Commercial uploading and downloading Project and Purchasing information from 3

Sector party systems to and from Oracle Project, Purchasing and Inventory for

Barrick Gold, North America Operations with their gold mine based in

Pueblo Viejo, Dominican Republic. I was responsible for the

globalizations and localizations for the Dominican Republic, multi

currency, US Dollar, Canada Dollar and the Dominican Peso, multi

lingual both English and Spanish. I developed web based, on line help

documentation using Oracle Tutor. I configured work flow for

Purchasing and HR.

Oracle Applications Enterprise Asset Management (eAM), iProcurment/Purchasing,

Enterprise Asset Inventory, Project Costing Technical/Functional Consultant. I

Management (eAM) worked with their clients implementing Oracle eAM along with

iProcurement/Purchasing and Project Costing, Project Billing and Project

Rel 12

Manufacturing. I configured the modules to work with eAM. I also

provided key training for client personnel.

Oracle Applications Oracle HR Core, HR Self Service, HR Intelligence Technical: I was

HR Core, Self Service, responsible for providing technical support for creating triggers for Alert

Manager. Uploading legacy data using Oracle Standard APIs to load

HR Intelligence 11.5.10

Employee, Assignment, Salary, Address, and Absence data. The project

and Rel 12

was for the implementation of HR and Self Service HR for Stolt Nielson

Commercial Sector

Transportation Group in Rotterdam, Netherlands

Oracle Applications Oracle HR Core, Payroll, HR Self Service: I provided Project

HR, Payroll, Self Management support for the implementation project for the Ministry of

Defense implementation in Baghdad, Iraq. I applied the globalizations

Service HR 11.5.10

and localizations for Iraq and multi currency and multi lingual for

Military/Government

English and Arabic. The project was and is being funded under the

Sector

USAF Joint Military programs. I was critical in installing a “Proof of

Concept” out of the box implementation for the Ministry of Defense

e mail: ***********@*****.***

Page 3 of 5 Raquel Anamaria Frame Allen

(MOD) in Baghdad, Iraq. The implementation was a success and was

amended to continue with the implementation of a Production version of

HRMS. The implementation required heavy personalization’s and minor

customizations. My work was conducted remotely and within Baghdad,

Iraq. The system is used to support the MOD troop movement and

planning functionality as well as maintaining pay, identification,

Biographical data and Education information on each member. I was

also responsible for the formation of education modules for HR, Payroll

and Self Service HR in both Arabic and English using Tutor.

Oracle Applications Oracle Financials, Project Accounting, Engineering, Inventory,

Instructor 11.5.10 and Procurement, and Order Management: I provided complete Oracle

Rel 12 Financials (General Ledger, Accounts Receivable, Accounts Payable and

Fixed Assets), Order Management, Engineering, Inventory and Project

Commercial Sector

Accounting (Costing and Billing) training support for a large Solar

Energy company with world wide locations. I developed the training

material used to train users in Oracle Financials (GL, AP, AR, FA),

Order Management, Engineering, Inventory and Project Accounting

(Costing and Billing). I customized the labs and power point slide

presentations provided by Oracle University Spain. Additionally, the

training covered process cycles such as Procure to Pay, Quote to Cash as

well as Order to Cash.

Oracle Financials Oracle Financials: I provided complete Oracle Financials (General

11.5.10 Ledger, Accounts Receivable, Accounts Payable and Fixed Assets)

Implementation and Configuration support for a large Israeli Cell Phone

Commercial Sector

company. I developed APIs used to load Vendor data and Trading

Community Architecture data.

Oracle Applications Oracle Order Management: I held the role of Lead Applications

Instructor Instructor I built custom Instructor and Classroom instruction material

and labs used by a world leading Coffee Distributor and Coffee

Commercial Sector

Restaurant Chain. I lead end user training courses in Oracle Order

Management version 10.5.10

Oracle Applications Oracle Collections : I held the role of Lead Applications Instructor I

Instructor delivered client site training in Oracle Collections version 11.5.10 for a

Leading Airline for Latin America. I was critical in identifying work

Commercial Sector

arounds for client unique processes at their Regional offices in Latin

America.

Oracle Applications Oracle Project Accounting (Costing and Billing), Oracle

Implementation iProcurement/Purchasing, Oracle Financials (General Ledger,

e mail: ***********@*****.***

Page 4 of 5 Raquel Anamaria Frame Allen

Commercial Sector Accounts Payable, Accounts Receivable, Oracle Assets : I held the

position as a Team Senior Functional Consultant with an internationally

recognized Construction firm implementing. Oracle Projects allowed the

client to track costs on projects with rentals, downtime, “Owned Assets”,

across the board for both internal and external projects. I configured

iProcurement and Purchasing to allow buyers to purchase ongoing

standardized construction materials. Implemented On Line XML

Catalogs. The implementation impacted process cycles such as Procure

to Pay, Order to Cash and Quote to Cash.

Oracle Applications Oracle Financials Suite Implementation Consultant: The client was

Implementation maintaining over $5 Million dollars in ‘Return to Vendor’ credit memos

on an Excel SpreadIets. I was tasked to build automated interfaces from

Commercial Sector

their proprietary Inventory, Sales, Procurement system, PIOS to their

proprietary payment receiving system, GetPaid and Oracle Accounts

Payable, Receivable, General Ledger and Fixed Assets. I created an

interface to load Vendors as Customers, match Vendor Invoices to Credit

Memos from Accounts Payable, AP, to Accounts Receivable, AR, to

reduce vendor payments in AP and generate Customer Invoices to

vendors in AR to interface with GetPaid. I created Auto Invoicing and

Auto lockbox processes.

Skills Summary

Oracle Financials General Ledger •

• Accounts Payable

Accounts Receivable

•

Applications • Assets

Databases Oracle 5.X through 10g •

•

Hardware & Windows NT •

• HP UX 11.11

Windows 2000

•

Operating Systems • Sun Sparc Unix

Life Cycle Expertise • IS Strategic Planning • Logical Database Design

• System Architecture • Physical Database Design

Planning and Design Application Development

Requirements Analysis Test Plans

Data Flow Modeling Testing, Capacity Planning

Entity Relationship Modeling Data Conversion

Functional Hierarchical Modeling Computer Operations

Programming Java •

• UNIX

C and C++

•

Languages • HTML

• Perl • COBOL

e mail: ***********@*****.***

Page 5 of 5 Raquel Anamaria Frame Allen

PL/1 FORTRAN

•

XML

Oracle Products Oracle Applications •

• Oracle Financials (General

Implementation and Ledger (GL), Accounts

Customization release 10.7 Payable (AP), Accounts

through 11.5.10 working Receivables (AR), Fixed

with Assets (FA)

• Cash Management • Human Resource

Order Entry (OE) and Management System

Order Management (OM) 11.5.10 (HRMS)

Project Accounting Billing and Costing Inventory (INV)

(PA) Manufacturing (MFG) with (WIP &

iProcurement/Purchasing BOM)

Enterprise Planning and Budgeting Advanced Supply Chain Planning

Oracle Financial Analyzer (OFA) • Oracle Portal

Self Service, Alert Oracle JDeveloper 9i

• AOL, Developer (Reports, Forms, PL/SQL

Oracle Designer through 10g SQL) through 10g

Oracle Application Server through 10g

Other Software • Business Object V5.0 • PSA/PSL

• ER/Win, System Architect

Products • TI IEF

Yourdon Analyst Toolkit

Engagement • Applications Development • Business & Technical

• Data Conversion

Experience Process Reengineering

AIM and CDM Methodology • End User Training

Fit/Gap Analysis Conversion

Testing Configuration

Project Management

Other Accomplishments

Education • BS, University of Nebraska at Omaha

Training • Oracle Release 11 Financial Applications

• Oracle Financials

Oracle iProcurement/Purchasing

Oracle Project Accounting (Costing and Billing)

e mail: ***********@*****.***

Page 6 of 5 Raquel Anamaria Frame Allen

Certifications & • Certified Oracle Master Applications Application Developer

Associations • Certified Master Oracle Applications Functional Project

Team Member

Languages • English, read, write, speak – Native language

• Spanish, read, write, speak – High proficiency

Portuguese, read, write, speak – Low proficiency

German, read – Low proficiency; speak – Low proficiency

e mail: ***********@*****.***

Contact this candidate