|
Manuel Reyes Oracle Financials Techno-Functional Consultant |
Executive Summary
· 9+ years of experience in Oracle Tools including Oracle Developer 2000, Designer 2000, Discoverer and Oracle Applications.
· Completed full life system cycle implementations
· Excellent communication, team building and project management skills
Skills Summary
· Oracle Applications Modules: PN, GL, PC, AP, FA, PO, INV and Sysadmin
· Oracle Application Releases: 11.5.5, 11.5.8 and 11.5.9
· Tools: Oracle Workflow, Applications Desktop Integrator (ADI), Designer, Developer and Discoverer
· Languages: SQL, PL/SQL
· Methodologies & Documents: Oracle’s Applications Implementation Methodology (AIM)
· Productivity Applications: MS Office, MS Visio and MS Project
· Detailed setup and operation of the following modules in Oracle ERP: PN, PO, AP, PC, GL, Sysadmin
· Designer2000, Developer2000, Discoverer, SQL *Plus, PL/SQL
· Advanced Microsoft Office
· Languages: Spanish (native), English Fluent, French - Basic
Oracle Apps Skills and Tools
· Business Requirements Mapping for PN, GL, PC, AP, FA, PO, INV and Sysadmin modules
· Testing modules, setup for inconsistencies and missing steps-Test scripts in development environment.
· Log, view, access, monitor, follow up and close Technical Assistance Requests (TARs) online-Oracle Metalink and Oracle Applications Patch Management
· Data Migration from Legacy systems and Open Interfaces
· Load and Prepare information with Dataloader
Oracle Project Experience
Client: BIMBO
Industry: Food
Description: Bimbo is one of the most important baking companies in brand and trademark positioning, sales, and production volume around the world. In Mexico and Latin America it is an undisputed leader in its area, with presence in the United States and 18 countries in Latin America, Europe and Asia encompassing over 5,000 products and has more than 100 prestigious brands.
Project: Oracle Property Manager Module Implementation Jun 07 to Today
Role: Sr. Oracle Consultant
Description: Implementation of Oracle Property Manager Module for Grupo Bimbo Corporation in Mexico as a Functional Consultant interacting with end-users and the development team.
· Coordination of the project scope with end-users.
· Set up and test in development environment of Lookups, Descriptive Flexfields and Value Sets.
· Build DataLoaders to load information in FA and PN modules.
· Prepare functional scenarios to test FA and PN interfaces.
· Setting and configuration of development and production instances for 32 legal entities.
· Coordination of the training to end-users of the Property Manager module.
· Post-production support.
· Capture and follow-up service requests using Oracle MetaLink.
Environment: Windows NT, Modules: PN, FA
Client: TELEFONICA MOVISTAR
Industry: Telecommunications
Description: Movistar is one of the worldwide leaders in mobile telecommunications. Movistar is part of Telefonica and has presence in 13 countries. In Mexico, Movistar has more 10.2 millions of clients.
Project: Oracle Applications Support May 06 to Feb 07
Role: Functional and Technical Consultant
Description: Administration, development and enhancement of Oracle Applications. Interaction with user to solve functional issues.
· Support to Oracle Applications Suite, working with the following modules: PC, AP, PO and GL, to assure the continuous availability of the application.
· Lead the Production Support Team.
· Management of resources, assignments and schedules.
· Administration of Trouble Tickets.
· Creation and customization of reports and forms.
· Perform Sysadmin activities.
· Develop enhancements to the standard functionality using AIM Methodology.
Environment: Windows NT, Unix, Developer2000 (Forms, Reports v. 6i), Modules: GL, PO, PA, AP, FA, WorkFlow and Sysadmin.
Client: BIMBO
Industry: Food
Description: Bimbo is one of the most important baking companies in brand and trademark positioning, sales, and production volume around the world. In Mexico and Latin America it is an undisputed leader in its area, with presence in the United States and 18 countries in Latin America, Europe and Asia encompassing over 5,000 products and has more than 100 prestigious brands.
Project: Development and enhancement of Oracle Applications Jan 06 to May 06
Role: Senior Development Consultant
Description: Development of Reports, Forms, Scripts and SQL Loaders.
· Development of new reports using Reports 6i.
· Design and construct data loaders, and SQL loaders to provide data to the system.
· Support of daily operations for Oracle Financial modules.
· Requirements gathering to build Customized Reports.
· Deliverables included needs analysis, functional mapping, business process re-engineering, finding solutions, setup and prototyping & testing.
· Implementation and go-live of documents, forms, reports and SQL scripts.
· Definition of Value Sets, Descriptive Flexfields, and Custom Profile Options.
Environment: Windows NT, Developer2000 (Forms, Reports v. 6i), Modules: INV, PO and Sysadmin.
Client: TELEFONICA MOVISTAR
Industry: Telecommunications
Description: Movistar is one of the worldwide leaders in mobile telecommunications. Movistar is part of Telefonica and has presence in 13 countries. In Mexico, Movistar has more 10.2 millions of clients.
Project: Oracle Applications Support Nov 04 to Jan 06
Role: Functional and Technical Consultant
Description: Administration, Development and Enhancements of Oracle Applications. Interaction with users to solve functional issues.
· Support to Oracle Applications Suite, working with the following modules: PC, AP, PO and GL, to assure the continuous availability of the application.
· Lead the Production Support Team.
· Management of resources, assignments and schedules.
· Administration of Trouble Tickets.
· Creation and customization of reports and forms.
· Develop enhancements to the standard functionality using AIM Methodology.
· Maintenance and support of shells using DataStage for Data Warehouse.
· Monitoring of Shells with ControlM.
Environment: Windows NT, Unix, Developer2000 (Forms, Reports v. 6i), Modules: GL, PO, PC, AP, FA, WorkFlow and Sysadmin.
Client: ABN AMRO Bank
Industry: Banking
Description: ABN AMRO is an international bank with European roots. ABN AMRO has a clear focus on consumer and commercial clients in local markets, and focus globally on select multinational corporations and financial institutions, as well as private clients.
Project: Building and maintenance of Oracle developments Mar 04 to Sep 04
Role: Senior Development Consultant
Description: Development of Reports, Forms, Scripts and SQL Loaders with Oracle 6i
· Development and maintenance of financial applications used by ABN Amro Bank.
· Creation of reports.
· Support to the applications in production.
· Development of interfaces between Progress and Oracle 9i.
Environment: Windows NT, Developer2000 (Forms, Reports v. 6i), PL/SQL, *SQL Plus
Client: TECHNOLOGICAL UNIVERSITY OF MEXICO (UNITEC)
Industry: Education
Description: Private Mexican University and College with more than 8 campuses around Mexico.
Project: Financial, Logistic and Academic Area Jul 00 to May 03
Role: Junior Project Leader
Description: Coordination, evaluation, design, and development of new projects using Oracle Tools as Developer 2000, Designer 2000 and Discoverer. Testing of the implementation of Oracle Applications (GL, AP and PO).
· Development and design of a custom financial system (General Ledger and Budgeting) using Oracle D2K.
· Creation of dynamic formulas to calculate employees’ payroll using PL/SQL.
· Implementation of Oracle Discoverer to provide end-users with critical information.
· Creation, design and development of reports using Designer2000.
· Responsible for coordinating strategic projects in the Logistics Academic area.
· Development and customization of reports and processes using GUI’s.
· Coordination of the development projects related with the ERP Implementation with more that 200 users.
Environment: Windows NT, Modules: GL, PO, Developer 2000 (Forms, Reports v. 6i, 4.5), Designer 2000, Discoverer for User Administrators and End Users, PL/SQL, *SQL Plus, Modules GL, AP and PO.
Client: KERNEL
Industry: Information Technology
Description: Kernel is one of the information technology companies with the highest growth rate in the country.
Project: Development and maintenance of Oracle developments Aug 98 to May 00
Role: Analyst Programmer
Description: Development of Reports, Forms, Scripts and SQL Loaders with Oracle 6i.
· Responsible for the coordination of developments in the retirements area in HR, using D2K, in all system life cycle with user interaction.
· Responsible as developer analyst for the Human Resources area. Analysis, development and deployment of Agencies Productivity Reports using D2K.
Environment: Windows NT, Developer 2000 (Forms, Reports v. 4.5, 4.0), Designer 2000, PL/SQL, *SQL Plus.
Education
· Master in Information Services Administration, Technological University of Mexico, Mexico, 2003
· Bachelor in Computer Systems Engineering, Technological University of Mexico, Mexico, 2000
· Diploma in Project Administration, Technological University of Mexico, Mexico, 2001
Certifications and Continuing Education
· Derivates Financial Products, Bolsa Mexicana de Valores, Mexico, 2004
· General Purpose Intensive English Course, Montreal, Canada, 2003
· Discoverer for End Users/Discoverer for Administrator, Unitec, Mexico, 2002
· Objects Design and Analysis with UML, Rational, Mexico, 2002
· MS Project, Unitec, Mexico, 2001
· Designer2000, Captralir, Mexico, 2001
· SQL*Plus / PL/SQL, Kernel Co, Mexico, 2000
· Developer2000, Kernel Co, Mexico, 2000