SUMMARY:

• Data Modeling, EBS Application development, Oracle Report and Form, BI Publisher, XML Publisher, Workflow, SOA Suite, RICE, OAF, Discoverer, BI Reporting, SQL Tuning, PL/SQL, XML Programming, Oracle AIM documentation, Oracle UPK, SDLC, Water Fall and Agile methodologies
• Sue is a proven IT professional with 15+ years of experience in the delivery of database and application solutions based around Oracle products. Her core expertise is in leading the technical aspects of Oracle Application implementations, upgrades, developments, and related projects.
• Sue held a BSIT and MBA degrees, and has led the development efforts on multiple EBS projects across different business areas (SCM, CRM, Financials, MFG, and Reporting)

RELEVANT EXPERIENCE:

Confidential

Oracle SOA Suite and Application Developer

Responsibilities:

• Provided technical services with expertise in modifying and designing APIs and interfaces to accommodating Confidential ’s HR system upgrade from PeopleSoft to Oracle Cloud HCM, designed and developed SOA messaging services for multiple internal and external Federal agencies communicating on HR data exchange
• Worked closely with internal and external project teams at all levels to understand business requirements, provided data - message mappings, identified system integration related components and nodes, and created interfaces, APIs, and ESB messaging by using PL/SQL, Java, and Oracle SOA Suite.

Coded in: SQL, PL/SQL, XML, and JAVA.

Development tools: SQL Developer, SQL Data Modeler, Toad, SQL Navigator, Oracle Report and Forms, JDeveloper, BI Publisher

Confidential

Oracle User Productivity Kits 11 developer and SME

Responsibilities:

• Provided technical services with expertise in Oracle UPK development and advisory.
• Identified business requirements and objects, modify, design, and create user productivity training material.
• Verified and published contents to the web-based portal for NIH training courses.

Coded in: HTML

Development tools: Oracle UPK, Adobe Dreamweaver

Confidential

Oracle EBS application and database lead developer

Responsibilities:

• Provided technical services with expertise in database and application architect, system design, coding, performance tuning, and project release leadership; Provided guidance to the functional team in defining project scopes, collecting requirements, and hosting pre-production user training; Trained and leaded BTAs and junior developers during each phrase of project deliveries; Provided Oracle R12 upgrade analysis, advisory, and estimates on database objects and application components.
• Worked closely with client at all levels to understand business requirements, identify problems, and define project scopes.
• Recommended effective solutions with technical specifications, pursued project approvals, and made successful end-to-end release deliveries.
• Collected project requirements, developed, enhanced, and supported Oracle EBS application and database for the MEC (Manufacture Execution Console) extension.
• Led and guided a group of Business Technology Analysts and junior programmers to provide exceptional technical service with expertise in system design, data modeling, coding, performance tuning, and software release leadership.
• Implemented customizations and extensions in Oracle EBS using Oracle Application Framework.
• Developed and Supported SOA Bi-Directional messaging implementation.
• Delivered customizations in manufacturing module by using Oracle Open Interface APIs. This includes: Shop Floor Manager, Inventory, Workflow, and BOM. Developed OAF pages with Oracle application page style to ensure a customized look and feel to a real web-based Oracle Application. The example of successful delivered project MEC system has provided a seamless transition between Oracle application interface and a customized manufacturing execution system interface.
• Provided post go-live production support for each project delivery.
• Delivered sets of mapping documents for describing functionalities of MEC Application with related OAF Pages, Oracle APIs and Open Interface modules in functional and technical aspects.
• Proposed and executed a series of documentations, knowledge transfers, and trainings in MEC Application architecture containing deep-dive functionality and technical specifications. This series has opened up additional business opportunities for the project team with the existing client.

Coded in: SQL, PL/SQL, XML, HTML, and JAVA in JDeveloper for OAF.

Development tools: SQL Developer, SQL Data Modeler, Toad, SQL Navigator, Oracle Report and Forms, JDeveloper, BI Publisher

Framework: Oracle Application Framework (OAF)

Confidential

Senior Programmer Analyst

Responsibilities:

• Analyzed current business process, defined future business processes, and recommended improvements to all levels of business users.
• Worked closely with the business units to define requirements, proposed and developed systems to implement solutions.
• Built and maintained Subaru Vehicle Supply Allocation System and Subaru Vehicle Ordering System.
• Enhanced and supported Subaru dealer Wholesale and Retail modules in EBS.
• Built and maintained Subaru ETL customizations for processing files from suppliers, transportation companies, dealers, and Subaru Manufactures facilities.
• Utilized Oracle Data Integrator 11g for high volumes data mapping, movement, and transformation.
• Supported Oracle Financial and Incentive Compensation modules; designed and developed accounting invoices and statements with built-in currency conversions; assisted Accounting month-end and year-end closings and helped the AP/AR/GL reconcile processing.
• Assisted Accounting Department in month-end and year-end closing, provided on-demand/ad-hoc reporting services to Accounting, Marketing, Distribution, Sales department, and executives.
• Provided application and technical support to Subaru Auto Leasing Management and related promotional programs.
• As the role of Oracle Discoverer Administrator, maintained accurate user access security and system maintenance, designed and developed materialized views for master discoverer reports, and assisted and trained business users periodically on using Oracle EBS and Discoverer.
• Converted majority of Oracle Discoverer reports into OBIEE in helping ERP and Sales users to analyze and forecast supply-demand trends.
• Created documentation for each phase of SDLC using Oracle's AIM methodology including business requirements (BR030), functional specification (MD050), technical specifications (MD070), and testing documents (TE010, 020).
• Worked closely with other ERP team members to gain and transfer knowledge, developed and administrated knowledgebase pages and sites in SharePoint.
• Performed multi-faceted roles working as a business analyst, developer, tester, and production support analyst as well as working on multiple priorities simultaneously.
• Gained hands-on working knowledge in Oracle EBS 9i, 10g, 11i, and R12 application upgrade, customization and development, and functional support, including modules in:
• CRM (IB Enterprise, Service Contracts, RMA, Sales)
• Financials (AP, AR, GL, PO, IC)
• SCM (INV, BOM, CZ, OM, QP, QA, WIP, IB, Workflow)
• Project (PA)
• Performed SQL and application tuning to improve performance in PL/SQL programs and Oracle reports.
• Coded in SQL, PL/SQL, XML, and VB.
• Experienced in Waterfall and Agile software development methodologies.

Confidential

Outsource / PDM Support Specialist

Responsibilities:

• Developed and supported Outsourcing Database Application.
• Provided support to the Director of Outsourcing by supplying Chinese - English translations, cost analysis, marketing forecasts, and product process improvement.
• As the DBA for Oracle8i database, managed the operation of Oracle Database Sever for PEM s Product Data Management (PDM) system, CMS/ProductCenter (a version controlled product documents management system) Coded in SQL, VB, C++.