Sr. Oracle Ebs Techno-functional Consultant Resume
3.00/5 (Submit Your Rating)
Denver, CO
OBJECTIVE:
- Senior Techno - Functional Oracle Apps EBS Developer
- To apply my extensive Information Technology expertise to a position that will be both challenging and rewarding
SUMMARY:
- Thirty four years of diversified computer systems integration experience.
- Demonstrated productivity working remotely via VPN/con-call - telecommuted via VPN/con-call for the last 12 years.
- Extensive experience in functional and technical implementation, development, documentation, and support of Oracle Apps E-Business suite (11i and R12) which includes: Bill of Materials (BOM), Inventory (INV), Order Management (OM/ONT), Shipping (WSH), Purchasing (PO), Receivables (AR), Payables (AP), Electronic Commerce/EDI Gateway (EC), General Ledger (GL) and Human Resources (HRMS) modules as well as many custom extensions and interfaces. Have created and integrated many complex custom enhancements using Oracle Forms, Oracle Reports, Custom Library, SQL*Plus scripts, SQL*Loader, PL/SQL stored functions/procedures/packages, triggers, foreign keys, indexes, concurrent sets/programs, flex-fields, profile options, value sets, workflow, alerts, folders, Unix and Windows host scripts and custom interface table sets/extensions. Extensive experience with Oracle standard interfaces and API calls - Notably OM/ONT, WSH, AR, PO, Customer, Item, and Item Costs
- Was one of two Analysts/Developers that performed a successful client upgrade from Oracle EBS 11i to version R12.2.3
- Experienced in various documentation methodologies including the standard Oracle MD-60, MD-70, MD-120 series. Participated in reviews and refinements of MD-50 documents.
- Twenty three years of relational database management system (RDBMS) analysis, design, development, support, diagnostics, and test including seventeen years of client-server (RICEW) development using Oracle Developer/Oracle Designer development tools (6i Forms/Reports, 10g Forms/Reports, BI Publisher, PL/SQL, SQL*Plus, SQL*Loader etc…), TOAD, and SVN version control.
- Was heavily involved in Oracle Apps upgrade planning, customization modifications, and associated testing (from 10.7 SC to 11.0.5 to 11i (11.5.10) and Oracle RDBMS upgrades from 7.3.4 to 8i to 9i to 10g to 11g
- 2 Years of Oracle App R12 familiarization including Multi-Org Access Control (MOAC), Sub-Ledger Accounting (SLA) and Multi-Reporting Currency (MRC) - currently working on an R12 upgrade effort.. Familiar with Oracle Apps R12 enhancements and their relevance to development/Apps upgrades.
- Six years of Electronic Data Interchange (EDI) installation, configuration, map development, test, and support using EDIOPEN and Inovis Trusted Link Enterprise (TLE). Implemented a complete, professional, high integrity TLE-based EDI system integrated with Oracle Apps from ground zero. Extensive end-to-end experience with the Oracle EDI Gateway, Inovis Mapping Workbench, Inovis Operations Center, Inovis Configuration Manager, share drives, and batch files). Extensive Inovis Mapping Workbench EDI mapping experience includes: ANSI X.12 - 810, 820, 824, 831, 846, 850, 852, 855, 856, 860, 865, 867 and EDIFACT - ORDER, ORDRSP, DESADV, INVOIC (and associated 997’s/CNTRL)
- Three years of Data Warehousing including Business Objects reports development and scheduling, and Data Integrator Extract, Transform, and Load (ETL) development
- Seven years of Field Engineering Support Services experience providing design, test, integration, troubleshooting, and customer interface services for a wide range of computer hardware and software products
EMPLOYMENT HISTORY:
Confidential, Denver, CO
Sr. Oracle EBS Techno-Functional Consultant
Responsibilities:
- Currently providing 11i and R12.1.3 development and support services to Hewlett Packard Enterprise (HPE) as part of their on-going contract with Grupo Bimbo Bakeries.
Confidential, Denver, CO
Sr. Oracle EBS Techno-Functional Consultant
Responsibilities:
- Functioned as a Senior Oracle EBS Techno-Functional Consultant for a variety of customers and requirements.
- Successfully completed multiple 11i to R12.2.3 and 11i to R12.1.3 upgrade efforts.
Confidential, Denver, CO
Sr. Oracle Developer/Technical Project lead
Responsibilities:
- Functioned as the Technical Lead transitioning the Department of Energy/Western Area Power Administration ( Confidential e-Travel System to the new Concur e-Travel System. This project used Web Services as the data communications method and interfaced to the Oracle GL, PO, PA, AP, and AR modules in order to support account and funds checks, travel fund obligations, and ultimately, AP invoices to pay off the government credit card vendor and to reimburse the employee (via the Projects/PA module). Used the Serena Dimensions Software Configuration Management (SCM) version control system. I participated in functional and technical planning for the upcoming Oracle Apps R12 upgrade.
Confidential, UT
Oracle/EDI Sr. Developer
Responsibilities:
- Provide system, process and database analysis, development and refinement using Oracle Developer/2000 front-end development tools in global Oracle 10.7 and 11.03, 11.5.9, and 11.5.10 (11i) Apps environments
- Have acquired extensive experience in Oracle Apps Manufacturing, Inventory, Order Entry, Shipping, and Finance modules from both a technical and functional perspective
- Functioned as a technical lead in Oracle Apps upgrades from 10.7 to 11.0.3 from 11.0.3 to 11.5.9 and from 11.5.9 to 11.5.10 (11i) and in a TIBCO upgrade from 1.x to 2.x
- Developed Order Management 3PL interface to/from 3rd party logistics partner (Modus)
- Transitioned Order Management 3PL interface to new 3rd party logistics partner (Globalware)
- Provide Electronic Data Interchange (EDI) platform development and support using Inovis Trusted Link Enterprise (TLE)
- Currently migrating EDI platform from Harbinger EDIOPEN to Inovis Trusted Link Enterprise (TLE)
- Negotiated substantially reduced Value Added Network (VAN) rates
- Developed numerous complex PL/SQL programs, stored packages, procedures, internal and external interfaces, custom forms and reports using Oracle Forms 4.5/6i and Oracle Reports 2.5/6i
- Developed a PL/SQL application to bill customers for non-returned products on Advance Ship RMA’s that generates upwards of $300,000/year in income and returned products. As part of this effort, coordinated with UPS to acquire UPS tag usage data via EDI and integrated an Advance Ship Mapping System into Oracle
- Developed and integrated into Oracle Apps, a custom Bank of America EDI Accounts Payable checks and wires system for the US and Europe, utilizing EDI 820/831 and EDI 824 responses with associated forms and reports and alerts for reconciliation and error advisories
- Developed and integrated a Budget Import Workbench into Oracle Apps allowing automated load from a text file produced by a 3rd party tracking tool (EssBase), pre-validation of cost centers, cross-mapping, and automated load to the GL Budget Interface for subsequent processing by the Oracle Budget Loader program. This project reduced redundant data entry tremendously
- Developed and integrated an Accounts Receivable Import Workbench into Oracle Apps allowing automated load from a text file produced by a variety of sources, pre-validation and approval of credit memos, and automated load to the AR Interface for subsequent processing by Oracle AutoInvoice. This project reduced redundant data entry tremendously
- Developed numerous complex electronic interfaces for outsourced manufacturing, shipping and receiving partners including Solectron, Venture Mfg, Banta, and Modus Media using custom tables, stored packages, procedures, and TIBCO (EDI.X12/RosettaNet)
- Developed custom extensions to the Oracle Service module to extract serialized product data from outsourced partner system and update Oracle Service accordingly
- Developed and integrated into Oracle Apps, a Custom Functionality Tracking System to provide Configuration Management capability as well as automated creation of project migration instructions for subsequent use by the DBA’s
- Developed and integrated into Oracle Apps, a Responsibility Ownership System to provide Configuration Management and security for Oracle responsibilities and the users’ possessing them
- Used TIBCO Business Works 2.x including Designer to develop numerous processes including use of Business Connect 3.5. Possess a strong knowledge of these tools from installation, development, test, and support standpoints
Confidential, Ogden, UT
Systems Analyst
Responsibilities:
- Provided process and database analysis, development and refinement using Oracle Developer/2000 front-end development tools
- Developed complex Oracle Forms 5.0/Reports 3.0 development for the Confidential ’s Integrated Missile Database (IMDB) as a subcontractor to Battelle. Was part of Battelle’s effort to achieve SEI CMM Level II certification
- Worked as a lead developer on the Confidential ’s Command Core System ( Confidential ) as a subcontractor to BDM in a client-server environment using Oracle Forms 4.0/4.5 and Oracle Reports 2.0/2.5 front-end tools
- Wrote a database attribute tracking application in Microsoft Access
- Performed numerous technical and performance studies
- Trained Junior Developer’s on the Confidential Command Core System in development techniques, and site standards
- Wrote numerous internal white papers, technical reports and database application user's guides
Confidential, Albuquerque, NM
Systems Analyst
Responsibilities:
- Provided process and database analysis, development and refinement, Network Management, Computer Support, technical writing, and training
- Developed numerous custom relational database applications for internal and Confidential customers using Paradox and MS Access. Among these were: an Confidential & Confidential Regulatory Compliance Tracking System, a Confidential Tiger Team Finding Tracking System, a Travel Commitment Tracking System, a Purchase Commitment Tracking System, a Hardware/Software Tracking System and a Cost Reporting System
- Developed skills in creating positive working relationships with demanding Confidential, Confidential and private sector customers.
- Attended the Paradox Developer's conference on two occasions, the Microsoft Access conference and the Oracle Developer's conference.
Confidential, Albuquerque, NM
Computer Specialist
Responsibilities:
- Provided process and database analysis, development and refinement, Network Management, Computer Support, technical writing, and training
- Designed, purchased, installed, tested and managed a Novell NetWare Ethernet network (LAN)
- Installed and implemented corporate e-mail capabilities
- Installed and configured server-based Windows 3.1 as well as numerous DOS and Windows applications. Worked with Palindrome Network Archivist and Cheyenne ArcServe file server backup software
- Developed numerous custom relational database applications for Confidential customers using dBASE IV including a Radiological Assistance Team (RAT) Training Tracking System
- Provided hardware and software support services
- Evaluated, acquired, installed, tested and maintained a wide array of computer, data communications and peripheral hardware
- Was the Deltek Accounting System technical point of contact for over three years. Attended the Deltek user's conference
- Supported the Macintosh and Windows operating environments and many applications including WordPerfect, Word, Quattro Pro, Lotus 1-2-3, Excel, Paradox, dBASE IV, Access, Freelance Graphics, Harvard Graphics, PageMaker, Canvas, MacDraw, ProComm Plus, cc:Mail for DOS, cc:Mail for Windows, cc:Mail for Macintosh, cc:Mail Mobile, and cc:Mail Router
- Attended the Comdex computer convention on numerous occasions
- Trained local and field employees in DOS, Windows, WordPerfect for Windows and cc:Mail for Windows
Confidential
Field Engineer
Responsibilities:
- Provided field engineering, systems integration and test, technical writing, programming, procedure development, computer support, and training services as necessary. Was part of an eight man tiger team based in St. Paul, MN providing on-call technical support services to field-site customers throughout the U.S.
- Acted as a technical liaison to the Confidential communications shelter
- Authored numerous computer and system troubleshooting manuals
Confidential
Field Engineering Assistant
Responsibilities:
- Provided field engineering, systems integration and test, technical writing, programming, procedure development, computer support, and training services as necessary
- Performed Configuration Management and expediting duties for field-sites
- Was part of a three man team which installed and tested Confidential hardware and software on the Confidential 's Automated Radar Traffic System ( Confidential ) update project at numerous airports throughout the U.S.
- Gained familiarity with a variety of test equipment including logic analyzers, breakout boxes, frequency counters, oscilloscopes and multi-meters
- Received formal training and became Confidential -certified in Electro-static Sensitive Device (ESD), soldering and wire-wrap techniques
- Trained junior Technicians and Field Engineering Assistants in proper hardware and software troubleshooting techniques for a variety of Confidential products
- Authored numerous computer and system troubleshooting manuals
