Detailed Resume 1 Apr 2009

Raquel Anamaria Frame-Allen

[email protected]

Raquel Anamaria Frame-Allen Senior Principal Consultant e-mail: [email protected] Telephone: +1-202-657-5414 Work Experience: Inversiones Frame SA, Senior Principal Consultant 10/00 - Present Oracle Corporation, Principal Consultant, Oracle Federal Consulting 01/96 10/00 Computer Technologies Associates, Senior Systems Analyst, 02/95 - 01/96 BDM Federal, Senior Systems Analyst, 06/93 - 02/95 Century Technologies, Inc., Technical Manager, 04/92 - 04/93 Booz, Allen & Hamilton, Inc., Consultant, 06/91 - 03/92 Global Associates, US Army Supply Systems Analyst, 06/90 - 06/92 Computer Sciences Corporation, Senior Systems Analyst, 06/89 - 06/90 Computer Data Systems Inc., Task Leader/Senior Systems Analyst, 06/87 06/89 Evaluation Research Corporation, Senior Systems Analyst, 09/86 - 11/86 Yourdon, Incorporated, Consultant/Instructor, 03/86 - 09/86 Computer Sciences Corporation, Senior Systems Analyst/Programmer, 06/82 03/86 Skills Highlight: Senior Functional/Technical Oracle Applications Consultant with over 24 years experience in the IT industry, 15 years experience working with Oracle Designer/Developer through 10g with 8 years technical and functional experience in Oracle Applications, Financials (General Ledger, Accounts Payable, Accounts Receivable, Assets, Enterprise Planning and Budgeting), iProcurement/Purchasing, Project Accounting and Manufacturing implementation and customization for versions 10.7 through 11.5.10. I have a broad background of experience to draw from for the development and implementation of IT solutions. Language Skills: Fluent in both Spanish, English. Oracle Products: Oracle Applications Implementation and Customization release 10.7 through 12 working with Oracle Financials (General Ledger (GL), Accounts Payable (AP), Accounts Receivables (AR), Fixed Assets(FA)); Enterprise Asset Management (eAM), Cash Management; Order Entry (OE) and Order Management (OM) 11.5.10; Human Resource Management System (HRMS); Project Accounting Billing and Costing (PA); Inventory (INV); Manufacturing (MFG) with (WIP & BOM); iProcurement/Purchasing; iStore; iPayment; Advanced Supply Chain Planning, Oracle Financial Analyzer (OFA); Self Service, Alert Manager, AOL, Oracle Portal, Oracle JDeveloper 9i, Java, Perl, HTML, XML, Oracle Designer and Developer (Reports, Forms, PL/SQL SQL) through versions 10g, Oracle RDBMS 5 through 10g, Oracle Application Server 9i Release 1 and 2, SQL, SQL*PLUS, SQL*Loader, Business Object, e-mail: [email protected]

Page 1 of 15

Raquel Anamaria Frame-Allen

[email protected]

Discoverer, Toad. Other Software Products: Business Object V5.0, ER/Win, System Architect, Yourdon Analyst Toolkit, PSA/PSL, TI IEF, MS Word, MS Project, MS Excel, Power Builder V3.0, Super base 2.0, FoxPro V2.0, dBase III & dBase IV, COBOL, FORTRAN, PL/1, C and C++. Operating Systems: VAX VMS, IBM OS/2, Honeywell, GCOS, UNIX and MS Windows 2000, NT etc. Hardware: HP True64, Sun Sparc, IBM 370/148, HP 9000/750, DEC MicroVAX, DEC VAX, Tandem TXP, Honeywell GCOS Model 400, IBM Personal Computer and AT&T 3B2. Management/Leadership Skills: Project Management, Technical Team Leader, Design Team Leader, Hardware/Software Installation Team Leader and Client Lead Consultant. Life Cycle Expertise: IS Strategic Planning, System Architecture Planning and Design, Requirements Analysis, Data Flow Modeling, Entity Relationship Modeling, Functional Hierarchical Modeling, Logical Database Design, Physical Database Design, Application Development, Test Plans, Testing, Capacity Planning, Data Conversion, Computer Operations. Specialty Skills: Data Warehouse Design, Designer 2000 Database Design; Application Design and Development; Application Documentation, Client/Server Architecture Application Development, Application Migration, System Installation/Conversion, Application Client Training, UNIX System Administration, Object Analysis and Design, EDMS Data Migration. Methodologies: Oracle CASE*Method, James Martin Information Engineering, Yourdon Analysis and Design Methodology. Used and taught Oracle consultants and clients in Oracle Application Implementation Method (AIM) and Oracle Custom Development Methodology (CDM). Both methodologies are used to guide and speed the implementation and development of software within an organization. Both methodologies allow the client and consultant to document the current system and better plan the transition and new system startup. Other Products: Business Object V5.0, ER/Win, System Architect, Yourdon Analyst Toolkit, PSA/PSL, TI IEF, MS Word, MS Project, MS Excel, Power Builder V3.0, Super base 2.0, FoxPro V2.0, dBase III & dBase IV, COBOL, FORTRAN, PL/1, C and C++.

e-mail: [email protected]

Page 2 of 15

Raquel Anamaria Frame-Allen

[email protected]

Communications: TCP/IP, Novel Netware, Telnet, DEC Net and Electronic Data Interchange (EDI). Project Experience: IFPA, SA: Senior Oracle Principal Consultant March 2001 to Present Client: Signum Group, Atlanta, Georgia Enterprise Asset Management (eAM), iProcurment/Purchasing , Inventory, Project Costing Technical/Functional Consultant. I am working with their clients implementing Oracle eAM along with iProcurement/Purchasing and Project Costing, Project Billing and Project Manufacturing. I configure the modules to work with eAM. I am also key for training of client personnel. Client: Barrick Gold, North American Division, Salt Lake City, Utah iProcurment/Purchasing, Inventory, Project Costing Technical/Functional Consultant. I was a team member responsible for the setup, configuration of the Oracle iProcurement/Purchasing, Inventory, and Project Costing modules for the Pueblo Viejo Mining operations in the Dominican Republic. The project required globalizations and localizations for the Dominican Republic and multi-currency for the US Dollar, Canada Dollar and the Dominican Peso and multi-lingual for Spanish and English. Additionally, I was responsible for the data interfaces from 3rd party software for Purchasing and Project Costing. I did the implementation in Spanish and English. The implementation impacted processes such as Quote to Cash, Order to Cash and Procure to Pay. I developed and presented labs covering those process cycles. Client: Stolt Nielson Transportation Group, Rotterdam Netherlands HRMS Technical Consultant for the Oracle HR, Payroll, Self-Service Implementation Project for Stolt Nielson Transportation Group managed by Oracle Netherlands. I was the Senior Technical Consultant implementing Oracle Alerts using Oracle Alert Manager. I applied the globalizations and localizations for The Netherlands for multi-currency and multi-lingual, English and Dutch. Responsible for loading of Employee, Address, Assignment, Absence, Salary data from the legacy system using Oracle Standard APIs. Client: Torres – Advanced Enterprise Solutions, Baghdad, Iraq HRMS Functional Consultant for the Oracle HR, Payroll, Self-Service Implementation Project for the Ministry of Defense, Baghdad, Iraq. I managed the project developing the Project Plan, Project Scope, Implementation Configuration Setup procedures. I was responsible for the application of globalizations and localizations for Iraq both e-mail: [email protected]

Page 3 of 15

Raquel Anamaria Frame-Allen

[email protected]

multi-currency and multi-lingual in English and Arabic. Additionally, I developed the HRMS Executive and Functional Courseware material. We implemented a standard Oracle HR, Self-Service HR and Oracle Payroll systems for the Ministry of Defense in Baghdad, Iraq. The implementation required over 100 personalization’s, loading of People, Organizations, Jobs, Positions, Absence, Payroll and other related information for over 300,000 employees, both military and civilian. Client: British Petroleum Solar, Madrid, Spain. Lead Senior Principal Consultant providing Oracle Applications Training in Oracle Financials (GL, AP, AR and FA), Order Management, Procurement, Project Accounting, and Engineering and Inventory client training for version 11.5.10. I developed courseware to reflect globalizations and localizations for Spain, India, The Philippines, England and the United States. The classes consisted of both experienced and novice Oracle users. The training course was developed using the labs and power point slide presentations provided by Oracle University Spain to several key BP Solar installations in Spain, India, Australia and the US. Additionally, labs covered processes to include Procure to Pay, Order to Cash and Quote to Cash. Client: Oracle Corporation USA. Lead Senior Principal Consultant for Oracle Applications both technical and functional, providing iProcurment/Purchasing and Oracle Financials (GL, AP, AR and FA) client training for version 11.5.10. Additionally, I am responsible for conducting pre-implementation, implementation and post-implementation support for Oracle CRM Modules, ERP Modules to include Order Management, iProcurement/Purchasing, Project Accounting (Costing and Billing), Collections and Oracle Financials (GL, AR, AP). Client: Comverse and Oracle Israel in Tel Aviv, Israel. Lead applications technical consultant, providing API development support for loading Supplier, Trading Community Architecture tables in Oracle Applications 11.5.10. The support role is for the Oracle Financials module (GL, AP, AR). Client: IT Department Personnel of the Perish of Baton Rouge, Baton Rouge, LA. Lead training consultant, providing training in Oracle Forms 10g to the IT Department Personnel of the Perish of Baton Rouge. Training and providing hands on experience on a current software development project in conjunction with their learning experience. I received high evaluations and was invited back to teach Advanced Oracle Forms 10g. Client: Starbucks Coffee Company, Seattle, WA. Lead training consultant to Starbucks Coffee Company providing Order e-mail: [email protected]

Page 4 of 15

Raquel Anamaria Frame-Allen

[email protected]

Management 11.5.10 Training to the Customer Services Representatives for the Canada and US operations in Seattle, WA. Client: TACA Airlines, El Salvador. Lead training consultant to TACA Airlines providing Oracle Collections 11.5.10 Training to the Accounts Receivable Collections staff in San Salvador, El Salvador. The center managed collections for all Central and South American territories. Client: Mortenson Construction, Minneapolis, Minnesota. Functional Consultant with Mortenson Construction implementing Oracle Project Accounting (Costing and Billing), Oracle iProcurement/Purchasing, Oracle Financials (General Ledger, Accounts Payable, Accounts Receivable), Oracle Assets. Oracle Projects allowed Mortenson to track costs on projects with rentals, downtime, “Owned Assets”, across the board for both internal and external projects. Configured iProcurement/Purchasing to allow buyers to purchase ongoing standardized construction materials. I was responsible for the implementation of On-Line XML Catalogs. Client: Agilysys. Agilysys was maintaining over $5 Million dollars in ‘Return to Vendor’ credit memos on an Excel Spreadsheets. I was tasked to build automated interfaces from their proprietary Inventory, Sales, Procurement system, PIOS to their proprietary payment receiving system, GetPaid and Oracle Accounts Payable, Receivable and General Ledger. 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. Client: Georgia Department of Transportation. Developed and delivered the training program of GDOT personnel using Oracle SQL, PL/SQL, Forms and Reports versions 6i and 9i using lesson material from Sideris. The classes were for the application development on both client server bases systems as well as web based systems. Additionally, I trained Sideris clients in Forms, Reports, PL/SQL and SQL version 6i and 9i throughout the US. Client: United Nations Development Program, Paraguay. Project manager and key consultant working on a 9i RDBMS and 9i AS implementation and migration contract with the United Nations and the Ministerio de Hacienda in Paraguay. The client is currently running 2,000 forms version 3.2 and 1,000 reports version 1.1 with the 7.3.4 RDBMS on a IBM RS/6000 AIX (64 bit) machine. I implemented and configured 9i rel2 RDBMS in Real Application Cluster (RAC) configuration and 9iAS rel2 with forms, and reports 6i e-mail: [email protected]

Page 5 of 15

Raquel Anamaria Frame-Allen

[email protected]

running web servlet. The team and I converted the forms and reports allowing government employees and taxpayers in Paraguay to pay corporate taxes and receive tax reports using the web browser from any web browser on any pc. The team upgraded the forms and reports to run straight 9i rel 2 on both the RAC and the 9iAS Applications Server using Single Sign On and Oracle Portal. Client: IFPA, Panama, Panama. Designed and implemented a Procurement, Sales, Returns, Inventory, and General Ledger system running on a NT server using Forms 6i with PL/SQL and Reports 6i using Oracle RDBMS 8i. The system is designed to accommodate a organization with multiple companies. The system is currently implemented in Panama with plans to implement the system throughout Latin America. The system was developed for the Spanish market. Client: Grupo Industrial Saltillo; Saltillo, Mexico. Developing Consolidation Sets of Books in General Ledger version 11.5.6 for the Industrial Group in Saltillo, Mexico. The group has 5 subsidiary sets of books each with the same Currency, Calendar and Account Segment Structure. Each subsidiary set of books has 5 to 10 companies with estimated revenues of 1 Billion US dollars. I was the key consultant developing their Consolidation System for improved financial control and reporting. Assisted in the configuration and installation of iProcurement with Purchasing 11i. Client: General Electric Information Services; Albany, NY. Involved with the maintenance, upgrade and support services for Oracle iProcurement, Purchasing, Workflow and language support in Spanish, Chinese, Brazilian Portuguese and English. I assist the developers of each the GE Companies in the support of Oracle Forms, Reports, PL/SQL, SQL and Workflow in addition to both technical and functional support for iProcurement, Procurement and Workflow. I am the key person for support of GE technical and end users in Spanish and English. Perform business analysis in functional and technical areas publishing those findings for both the technical and user communities. Provide team mentoring, project leadership and marketing of support service to the various General Electric Companies. Client: Sybron Dental Specialties; Orange, CA. Responsible for the coordination and planning of the user training for over 700 users migrating from Oracle Applications Financials, Purchasing, Project Accounting and Manufacturing version 10.7 to version 11i. Manage and monitor the Conference Room Pilot (CRP) process for user level software acceptance of Oracle Applications version 11i. I was responsible for user support and training for Project Accounting Costing and Billing for migration from 10.7 to 11i. Created budgets to control project costs and task structures to monitor project status. Created both internal (Costing) and external e-mail: [email protected]

Page 6 of 15

Raquel Anamaria Frame-Allen

[email protected]

projects (Billing). Assigned key members and assets to projects for internal and external billing of labor and expenses. Client: Applied Ordnance Technology; Lexington Park, MD. Developed and delivered custom tailored developer training in Java 2, Oracle JDeveloper 9i, and XML. I developed a training course based on the deliverables of the client working with hands-on labs. Training was delivered in two weeks. The class was small and delivered to developers working in C++ and intranet HTML web pages. Client: Los Alamos Labs; Los Alamos, NM. Team Leader and Lead Developer for Web Based Learning Center. The system automatically used Dynamic HTML Pages. The objects were designed and generated using Oracle Designer 6i. Oracle Portal was used to standardize the look and feel of the training system. Client: Vidaloha; Volcán, Panamá. Provided Business Analysis and Process Analysis for e-commerce using Oracle Web applications iStore 11i, iPayment 11i and iProcurement. The implementation required the installation of Oracle Apps 11i, GL, INV, AP, AR. Developed the web site located at http://www.vidaloha.com to market the services available through Clínica de Salud Vidaloha. Developed several applications in Perl and Java to serve as the Common Gateway Interface (CGI) Client: Handleman Company, Detroit, Michigan. Provided Business Analysis and Process Analysis of a proprietary financial and purchasing system. Assisted Handleman Company to determine the best migration path from their current system to Oracle Applications Financials Suite and Purchasing 11i. Handleman has a manufacturing division for the manufacture and distribution of music media in the form of Tapes and CD's. Assisted with the business analysis and the gap analysis for Purchasing 11i, Manufacturing 11i, Inventory 11i and Order Management 11i. Gap analysis is where you determine the areas where the standard implemented Oracle Application does not fit the clients' requirements. Handleman Company accepted the three-year migration plan that allowed them to migrate systems during low business periods. All of my work was reported to the CIO of Handleman Company. Client: Coca Cola Panamá & Cervecerias Baru Panamá S.A. Responsible for performing the migration analysis and sizing for migrating from Informax to Oracle 8i and the Oracle Applications 11i suite of modules. Provided business analysis and gap analysis for the client implementing Oracle Applications 11i; Financials, Purchasing, Manufacturing; Order Management and Inventory. Provided client staff training to implement and customize the various modules using Forms and Reports V6i. Coca Cola accepted e-mail: [email protected]

Page 7 of 15

Raquel Anamaria Frame-Allen

[email protected]

my recommendation to migrate their character based Informax data base system to Oracle 8i running the full suite of Oracle Financial, Manufacturing, CRM and ERP Suites. The CRM modules include Marketing Analyzer, Sales Analyzer and iPurchasing. All of my work was reported to the CFO of both companies. Client: Sidres Consulting. Responsible for providing technical, functional and training support in Oracle Financials 11i. Wrote training documents used by Sidres Consulting to be used to train their clients in Oracle Financials 11i. Client: Los Quetzals Lodge & Spa. Designed and implemented the hotel reservations system on the Internet for web based reservations. The system allows the hotel to generate higher revenues and attract and keep more clients by tailoring packages for each client. The system is used to form group packages for tourism in Panama. The system was built using Dreamweaver version 4.0, JDeveloper for Java, Perl, html, and xml running on an Oracle 8i database and Web Server. Oracle Federal Consulting: Principal Consultant January 1996 to October 2000 July 2000 to October 2000 Project: Oakland 2000. Responsible for technical and functional support for Oracle Financial Systems version 10.7 to 11i upgrade for General Ledger, Cash Management, Accounts Payables and Receivables, Project Accounting, Human Resources and Payroll. Developed new reports and forms using Oracle Reports 2.5 and Oracle Forms 4.5. Responsible for development of Budget upload and download interface between third party Budget System and Oracle Project Accounting Budgets, as well as the General Ledger Budgets. May 2000 Project: EFTS AMSTERDAM SUPPORT. Responsible for internal training of Oracle Staff in Amsterdam in the use of EDMS to migrate data. Feb 2000 to Apr 2000 Project: MSC /APMC FED HR/PR Implementation. Responsible for building Time Management interface using Forms to enter time into Oracle Federal HR. Development of reports was accomplished using Reports 4.5. Jan 2000 to Feb 2000 Project: WM - NEXCOM PCMS 3 Responsible for the implementation of EDMS and Data warehouse Builder and demonstration of the system to navy clients for Oracle. Design and develop data warehouse design for Navy Retail e-mail: [email protected]

Page 8 of 15

Raquel Anamaria Frame-Allen

[email protected]

Organization. The data warehouse is being used to monitor retail sales in all Navy Retail Outlets and Organizations worldwide. Developed loading scripts and data presentation reports and screen used by the administrative staff as well as the executive staff. Jan 2000 Project: CSES HVA PHASE II Oracle Designer 2000 Release 6.0 Evaluated the logical and physical database design and process model of the Michigan Child Support System after the Initial Analysis and Design phase of the project. The legacy of the system uses a data warehouse to store and retrieve information. The evaluation of the proposed-modeled system was used to develop hardware and software recommendations and produce the cost estimates for Phase II of the project. The cost estimates were produced using the Oracle Custom Development Methodology, CDM to show time and materials required for a successful and timely delivery of the proposed system. Recommended that the project use Enterprise Data Modeling System to interface external systems to the Child Support System. Nov 1999 to Dec 1999 Project: USAID DAI CONCADE Oracle Designer 2000 Release 6.0 Develop a computer system that enabled the Bolivian Government to monitor the success of the eradication of Coca in the Champare region of Bolivia. The complete design of the system from analysis to build phase was conducted using Designer 2000 and Developer 2000. The system is designed in Oracle RDBMS with the Spatial and Time series cartridge for a Geographical Information System. The system allows the user to view data such as crop productions for a specific farm or community, monitor economic growth as coca is eradicated from the region. The system is designed to provide project accounting with costing, financials, and monitor import and export prices. Sep 1999 Project: HUGHES IRM Migration of Data warehouse to Oracle Applications versions 11. Responsible for the development of packages used by EDMS to transfer data from Oracle Data warehouse to Oracle Applications at Hughes Aircraft. Aug 1999 to Sep 1999 Project: CMS ENERGY/Tutor - OEPC Training Oracle Projects and General Ledger. Trained the staff of CMS Energy in Singapore to use Oracle Projects Costing Module and General Ledger with Budgets and Multiple Currency in Version 11.

e-mail: [email protected]

Page 9 of 15

Raquel Anamaria Frame-Allen

[email protected]

May 1999 to Aug 1999 Project: Implementation of Oracle Projects in Girasol Oracle Applications Project Costing Release 11 Implemented Oracle Applications Project Accounting, Project Costing Release 11 for Oracle Brazil at Girasol, Florianopolis, Brazil. Girasol is the major supplier of hydroelectric power for Brazil and Argentina. They construct hydroelectric, nuclear, and thermoelectric production plants. I implemented Project Costing and trained key users in the use and maintenance of Oracle Project Costing. Nov 1998 to May 1999 Project: Internal project to implement Oracle Projects using Developer 2000- Reports 2.5 - Development of Oracle Reports, Forms for Applications 10.7 in Buenos Aires, Argentina. Provided critical support to Oracle Argentina and Oracle Mexico with implementation, customization and development of localizations of Oracle Applications 11i in HR, Project Accounting and Financials. Jul 1998 to Nov 1998 Project: BF Goodrich 10.7 Final Upgrade Conversion of Oracle Applications both Financial and Manufacturing Reports from Reports 2.0 to Reports 2.5 for B.F. Goodrich in Minneapolis, MN for Oracle Applications upgrade from Version 10.5 to 10.7. May 1998 to Jul 1998 Project: LM GCSS - AF-LOGMOD Support Developer 2000Reports 2.5 - Development of Oracle Reports for U.S. Air Force Logistics System in Montgomery, AL. Jan 1998 to Apr 1998 Project: PANAMA CANAL-FINANCIAL Implementation Designer 2000/CDM - Development of Application Systems using Oracle Designer 2000 with CDM for the Panama Canal Commission. The applications interface with Oracle Financial Application and Panama Canal Commission Personnel/Payroll/Human Resources System. I am responsible for mentoring the development teams in building applications with Designer 2000 and managing the various projects using CDM. Nov 1997 to Dec 1997 Project: Saudi Arabia ARAMCO Designer 2000 - Migration of reports for from IBM MVS M204 environment to Client/Server Unix platform for ARAMCO in Saudi Arabia. Migrated current functionality using Designer 2000 for 100% generation of Reports for Oil Production. Developed critical routines for the Service Order Release process. This is the only means that Oracle has to bill the client for work completed. I Was among e-mail: [email protected]

Page 10 of 15

Raquel Anamaria Frame-Allen

[email protected]

the first consultants to successfully take a Service Order from Acceptance to Completion. This procedure paved the way for consultants working on the project to bill the client for work performed. Identified and resolved data base inconstancies and errors in reports being migrated to the new environment. Sep 1997 to Oct 1997 Project: SPITFIRE MIGRATION Forms 2.3 to Forms 4.5, Report Writer 1.0 to Reports 2.5 Conversion for Patuxent Naval Air Station. Instrumental in completing the Forms and Reports conversion effort of the Navy Inventory System with the teaming of Kumaran. I was required to turn around a project that was behind schedule and exceeding cost projections. I resolved the situation by doing a strict conversion under a teaming agreement with Kumaran. The Forms and Reports were quickly and successfully converted, installed and tested. The major interface to the system was the hand held bar code reader that was used to collect inventory data and interface to the Oracle tables. Aug 1997 Project: BATELLE/DPS Designer 2000 100% Generation of Reports 2.5 and Forms 4.5 for Department of Public Safety for the State of Ohio. My ability to generate reports and Forms with the Designer 2000 tool Suite as the Senior Consultant to Battelle allowed the client to bring their project ahead of schedule and under projected costs. I was able to transfer to the team members 'How To' knowledge the proved valuable and essential to the successful completion of the project. May 1997 to Aug 1997 Project: CINCLANTFLT Designer 2000 Generation of Reports 2.5 for Commander in Chief Atlantic Fleet Funds Grant Project. Lead for Generation of Reports 2.5, also provided training for client staff. Mar 1997 to May 1997 Project: UNISYS/DFAS INDY DATABASE Designer 2000 Corporate Data Modeling for the Defense Finance Accounting Service (DFAS). Converted the Corporate data model from ER/Win Model Mart to the Oracle Designer 2000 Version 1.3.2. The model will be used to standardize the Meta data used by DFAS. I was the key member on the team that built the Entity Relationship Diagram for the corporate data model. I accomplished this by splitting the data model into manageable subject areas. The model was loaded onto a central repository in Kansas City and accessed via SQL*Net to allow Designer 2000 analysts and functional members to work from various locations on the central repository housed on a remote sever. Trained client personnel in Designer 2000 to generate Reports e-mail: [email protected]

Page 11 of 15

Raquel Anamaria Frame-Allen

[email protected]

2.5, Forms 4.5 and Web server applications. Nov 1996 to Mar 1997 Project: LG Electronics Oracle Manufacturing Applications Implementation for LG Electronics in Kumi, Korea as the ACE Technical Team Leader I worked with the DBA, Conversion Team, Interface Team members, and Application Customization and Extension, ACE, Team members. I developed Solution Design Documents to conduct Customizations and Extensions to Oracle Applications version 10.7. I worked on the Oracle EDI Gateway interface between Oracle Applications and the EDI translator and Value Added Network, VAN, to the Supplier. Worked with Forms 4.5 to build extension applications used to track items during the manufacturing process. I was a key technical member of the staff for technical problems and getting problem resolutions and resource material for the consultant staff on the project. Sep 1996 to Oct 1996 Project: Audits and Appraisals I developed reports at the Sandia Labs in Albuquerque, NM in a highly visible project tracking internal audit procedures. Apr 1996 to Aug 1996 Project: FDC/BAIM/T&M - Oracle Reports 2.5 Design on Baseline Advanced Industrial Management (BAIM), Senior Consultant to the U.S Navy responsible for delivery of applications using Developer 2000 software development suite to include Oracle*Forms 4.5 and Oracle*Reports 2.5. Develop and maintain the BAIM model using Designer 2000. I was a critical developer for the Navy in the development of reports in Oracle*Reports 2.5. Computer Technologies Associates: Senior Systems Analyst February 1995 to January 1996 Develop reports for the Standard Army Maintenance System, SAMS, and Standard Army Ammunition System, SAAS, using Oracle Reports 2.0 and Oracle RDBMS V7.0. Using the Texas Instruments IEF CASE tool to assist in the design of the SQL statements required to run the Oracle Reports. I use Oracle Data Browser to validate the results returned by Oracle reports. Additionally, I have built the front end using Oracle Forms 4.0 to load data for testing scenarios for Oracle Reports. Oracle Reports is running on a HP 9000/750 UNIX platform and SCO UNIX workstations. As Senior Member of the software fielding team I trained the site personnel in database modeling for Oracle Browser training and Oracle Reports 2.0 operations. Additionally, I worked at the site as a UNIX Systems Administrator on the HP 9000 Model 750. e-mail: [email protected]

Page 12 of 15

Raquel Anamaria Frame-Allen

[email protected]

BDM Federal: Senior Systems Analyst June 1993 to February 1995 As the Senior Information Data Engineer I developed the Military Transportation Entity Relationship Diagrams using the ERWin/ERX CASE tool in accordance with IDEF1X methodology. I worked closely with the military transportation user community to develop the ERD and OOP diagram. The transportation model will be used migrate existing military transportation systems to a seamless integration of all military transportation systems. As a Task Leader on the Ballistic Missile Defense Organization, BMDO, Project I was responsible for the system migration from the current host based VAX 8820 to the client/server architecture of the DEC Alpha computer. I built the high level Entity Relationship Diagram, ERD, of all sub systems to enable the software developers in systems migration and development. I was the lead CASE tool advisor for the software group using System Architect. I was working with team members in their training in the development of Entity Relationship Diagrams, Data Flow Diagrams, and Object Oriented Processing diagrams. I developed the BMDO Personnel/Manpower/Budget system using class libraries and Power Builder version 3.0. As a Senior Systems Analyst for the Royal Saudi Air Force in Riyadh Saudi Arabia I provided Structured Systems Analysis utilizing the Yourdon and James Martin Structured Design Methodologies. I worked closely with the user to develop a rapid prototype of their requirements in Oracle RDBMS V6 using Oracle Card. Oracle Card takes full advantage of the GUI of the Windows environment. I used Oracle Designer CASE tool to build the ERD model of RSAF Military Sales procedures. Century Technologies, Inc.: Technical Manager April 1992 to April 1993 As the key Technical Manager on the Defense Commissary Agency, DeCA, I coordinated all work for Personal Computer Applications Development, Electronic Data Interchange, EDI, and Collector/Router development work on the AT&T 3B2 UNIX based computer. The Collector/Router is a front-end processor used to receive files from stores, validate and transmit them to the Sequent computer running Oracle RDBMS V7 for further processing. As the Senior Level Data Base Design Programmer/Analyst. I coordinated and focused the development efforts of the Data Base Design staff in dBase IV and FoxPro. I developed an Invoice Tracking System used by DeCA to track the history of an Invoice when DeCA returns the invoice to the vendor for error correction. The system automatically produces a letter that DeCA sends to the vendor attached with the invoice. Additionally, I provide CASEconsulting expertise using System Architect by Popkin Software. The Information Engineering work allows for the rapid prototype, development and deployment of systems. e-mail: [email protected]

Page 13 of 15

Raquel Anamaria Frame-Allen

[email protected]

Booz, Allen & Hamilton, Inc.: Consultant June 1991 to March 1992 Provided computer support for the US Military Southern Command located in Panama in the areas of software user training, procedural documentation, and software applications development in dBase IV. Trained users in the operation of the Multi-Media information center for theater level battle planning used in Central and South America. I Developed fault-tolerant the Local Area Network for the sharing and passing of information between the ground bases LAN's and aircraft based LAN's. The fault-tolerant E-Mail LAN/WAN system for the Command and Control Group to allow uninterrupted communications within Central and South America to the Pentagon. The E-Mail system runs within the Windows environment that allows the user to rapidly use information developed from other applications and systems. Global Associates: US Army Supply Systems Analyst June 1990 June 1991 Provided computer operations support for the US Army Supply System DS4/DAS3 on the Honeywell GCOS Model 400 computer. I developed COBOL programs to greatly enhance the Army Supply System. Computer Sciences Corporation: Senior Systems Analyst June 1989 to June 1990 Ported Laboratory Information Management System, LIMS, for the Environmental Protection Agency from the Perkin-Elmer Concurrent Computer to the DEC Micro VAX III under Oracle version 6. Provided System Design support using a CSC CASE tool where I built the ERD and DFD of the LIMS software. I provided programming support in FORTRAN IV for user exits out of SQL*Forms 2.3. I wrote system requirements specification documents that were used by the EPA for contracting purposes. I developed a software-testing program that tested and evaluated software to ensure that the software provided by the contractors meet the requirements stated by the EPA. Computer Data Systems Inc.: Task Leader/Senior Systems Analyst June 1987 to June 1989 Managed several Systems Implementation Teams installing the Navy Procurement Software Package onto the TANDEM TXP platform using Pathway. Developed, coordinated and executed the implementation agreement with each Navy Procurement Center. Developed and presented procurement (APADE) system training courses to site managers and support personnel including various other PC software packages. Evaluation Research Corporation: Senior Systems Analyst e-mail: [email protected]

Page 14 of 15

Raquel Anamaria Frame-Allen

[email protected]

September 1986 to November 1986 Performed the Data Base Design study utilizing the James Martin Entity Relationship design methodology using Oracle on a DEC VAX/VMS Cluster. Used the Texas Instruments IEF CASE tool and Knowledgeware in the design and development of the Corporate Data Base. Yourdon, Inc.: Consultant/Instructor March 1986 to September 1986 Trained client personnel in the Yourdon System Design Methodology and Entity Relationship Diagramming using the Yourdon Analyst Toolkit. Developed a link to transfer the System Design data model developed on the IBM PC using the Yourdon Analyst Toolkit and dBase III to the System Design data model on the AMDAHL using Datamanager. Computer Sciences Corporation: Senior Systems Analyst/Programmer June 1982 to March 1986 Performed Systems Analysis using the Yourdon Methodology using PSL/PSA to develop systems design and data dictionaries. The Structured Design Methodology was used for the Standard Army Accounting and Financial System,(STAFS), and the Army Transportation System (DAMMS). Implemented the Army Supply System and trained site personnel in the operations and maintenance of the Honeywell Computer. Education BS University of Nebraska, Computer Science and Business Administration

e-mail: [email protected]

Page 15 of 15