AddThis Social Bookmark Button
peter chang ( Available )
Austin, TX - 78729 usa
Expertise :oracle apps reports, oracle apps 11i/r12, oracle developer
Status :Citizen
Job Type :
All -
Position :

Resume
 
Summary


Peter Chang

15 15 years experience of which 8 8 years of strong experience in design, development, customization and implementation of Oracle Applications 11i/11.5.9/10.7 HRMS, Payroll, Oracle MFG R12 and Oracle Financials R12/11i/11.5.9/10.7 PO, AP, GL using Oracle Tools- Developer suite Forms 10g/9i/6i/4.5, Reports 10g/9i/6i/3.0/2.5, Discoverer 9i/4/3 Administrator 9iAS/4i/3i Desktop, Discoverer Plus, SQL, PL/SQL, SQL*Forms, SQL*Plus, SQL*Loader, SQL*Report writer 1.1, SQL*Forms with Oracle 9iAS/8i .x under UNIX, Windows XP/2000/NT/98/95 environment.

Skills/ Tools :
ERP : Oracle Applications 11i/11.5.9/10.7 HRMS, Payroll, Oracle Financials PO, AP, GL
Oracle Tools : Oracle Developer Suite10g Forms 10g/9i/6i, Reports 10g/9i/6i/3.0/2.5, Oracle Discoverer 9i/4/3 Discoverer Administrator 9iAS/4i/3i Discoverer Desktop, Discoverer Plus, Discoverer Viewer, SQL*Report writer 1.1, SQL*Forms, SQL*Plus, SQL*Loader, PL/SQL, SQL*Menu, SQL*Net




Employment

October, 2007 -  December, 2008
Software Engineer


Development/customization and user support of Oracle Applications R12 AR/AP/PO/BOM/OE or OM/WIP/INV Products and Pricing for a global company in a multi-org/multi-language environment. Modified store packages, procedures and functions.
Write PL/sql package do Data load into Oracle tables.
Convert Oracle Report2.5 to Oracle Report6i/10g
Write new XML report using Oracle Report10g and BI Publisher.

Environment : Oracle10g, Oracle Developer suite10g, Oracle discoverer10g, Oracle Form10g, Oracle Report10g, SQL*Loader, JDeveloper, Business Intelligence Enterprise Edition, Oracle eBusiness Suite, Salesforce, SOA, OAF, Oracle workflow, SVN, TOAD, WinxpPro, SUN/SOLARIS, IBM-AIX.


March, 2005 -  December, 2007
Software Engineer


Implement Automated Insolvency System AIS. Replicate functionality that exists in the Internal Revenue Service s Automated Insolvency System to Oracle10g.
Convert C program to Oracle Report9i, store packages, procedures and functions.
Using Oracle From9i to Create MENU and FORMS.
Write PL/sql package do Data load into Oracle tables.

Environment : Oracle10g/9i Oracle 9ias, Oracle 9ids, Informix, Oracle Developer suite10g, Oracle Form9i, Oracle Report9i, JSP, SQL*Loader, JDeveloper, Clearcase, TOAD, WinxpPro, SUN/SOLARIS.


January, 2005 -  February, 2005
Senior Consultant


Implemented Affirmative Action data extract to load into access AAP reporting system.

Environment : Oracle HR/HRSS Applications E-Business Suite 11.5.9, Oracle Forms 6i, Oracle Report6i, SQL*Loader, TOAD, Workflow, Oracle 8.1.7 SUN/SOLARIS.


June, 2004 -  September, 2004
Senior Consultant


Wrote interface API packages to load Civilian competence or competence elements data, into Oracle HR Career Management module.
Implemented Oracle Report 9i/6i to replace current reporting system like AF FOMRM 860A AF FORM860B AFFORM860 and individual development plan reports.
Used SQL*Loader to load excel data into Oracle interface table.

Environment : Oracle HR/HRSS Applications E-Business Suite 11.5.9, Oracle Forms 6i, Oracle Report9i/6i, SQL*Loader, XML, TOAD, SQL Navigator, Workflow, Oracle Portal, Oracle Discoverer4i Administrator9iAS/4i, Discoverer Desktop, Discoverer Plus, Discoverer Viewer, Oracle 9.2.0.4.0, SUN/SOLARIS.


April, 2004 -  May, 2004
Senior Consultant


Modified Custom library to enhance Oracle Applications 11.5.9 HR, OTA

Environment : Oracle HR Applications 11.5.9, Oracle Report 6i, Oracle Forms 6i, Oracle Discoverer Administrator 9iAS/4i/3i Workflow, TOAD, SQL Navigator, Discoverer Desktop, Discoverer Plus, Discoverer Viewer, Oracle 8i, SUN/SOLARIS

AFPC,
Randolph Air force Base, San Antonio TX


March, 2003 -  March, 2004
Software Engineer


Used Oracle Applications 10.7 with OTA option for Military Personnel Data System which USAF uses for personnel life cycle management of all members of Air Force.
Performed maintaining, administering Recruitment and accession system.
Performed application tuning, performance SQL tuning TKProf, Explain Plan.
Created, modified SQL/ PL/SQL code, supported users, development team in implementing business rules.
Did Oracle Report performance tuning and created new reports.
Modified HRMS Oracle forms 4.5, Oracle report 2.5 by using Oracle Applications Coding Standards.
Did debugging, testing Military Personnel Data System in Oracle Apps.

Environment : Oracle HR Applications 10.7 Oracle Discoverer Administrator 9iAS/4i/3i Discoverer Desktop, Discoverer Plus, Discoverer Viewer, Kintana, PVCS, Workflow, Oracle 8i, HP-UNIX 11


November, 2001 -  February, 2003
Software Engineer


Worked as member of SQL Tuning Tiger Team, reviewing SQL views, cursors in database, tuning code when applicable to improve performance of SQL code in MilPDS.
Examined how much of generated SQL is used which can hamper overall system performance.
Examined any large packages to see if they is broken into smaller ones.
Used functions that are in large package can put large resource demand on system, even if individual functions are small.
Conducted Knowledge Transfer KT sessions for DPDM developers to teach our developers how to tune their own code.
Modified HRMS Oracle Forms 4.5, Report 2.5 by using Oracle Applications Coding Standards.
Did debugging, testing Military Personnel Data System in Oracle Apps 10.7

Environment : Oracle HR Applications 10.7 Oracle 8i, HP9000, Windows 2000


January, 2001 -  October, 2001
Senior Consultant


Wrote interface programs to load CMS Employee s Stock Purchase Plan flat file data into Oracle HRMS through API.

Provided user training MD/50/60/70 Technical Solution Design Document.
Modified Oracle Forms 6i, Oracle Report 6i by using Oracle Applications 11i HRMS Coding Standards.

Environment : Oracle Applications HRMS/ Payroll 11i, Oracle Forms 6i, Reports 6i, Oracle 8i, Windows NT4.0, HP9000


October, 2000 -  December, 2000
Senior Consultant


Identified issues and concerns, involving APPS Replication.
Examined apps table changes before and after patch load.
Wrote database triggers and loading data through API.
Developed HRPR report using Oracle Report 6i.

Customized Purchase Order Detail Distribution POXPODDR and PO Status Report.

Implemented PO Analysis Status Report for Oracle Report 6i Development ; Coding and Testing ; implementing it in financial application.

Environment : Oracle Financial 11i HRMS, Payroll, Oracle Report 6i, Windows NT servers


April, 2000 -  September, 2000
Senior Consultant


Converted COBOL reports to Oracle Report 3.0.

Did Performance SQL tuning, user Training on Oracle Report 3.0.

Environment : Oracle Report 3.0, Lotus Notes, Oracle 8i, DB2, Windows NT 4.0, IBM RISC/6000


March, 1999 -  March, 2000
Oracle Financials Developer


Developed customizations for Oracle Financials system Purchasing Order, Accounts Payable, General Ledger, Fixed Assets, HR and Payroll.
Developed new features for company s existing temporary, permanent leasing and Buyer Registration systems.
Managed all application reports and Oracle Discoverer 3.0.
Used Enterprise Manager to perform variety of DBA duties.
Used Metalink, submission of TARs and loading patches.
Performed Oracle Financials user security, create magnetic W2 tape, TWC tape and custom reports for finance department.
Performed data conversion, prepared data mapping, data load through API to Oracle HRMS system.
Followed conversion API Dependency Diagram to execute API scripts.
Customized Oracle Application reports.
Modified programs - Check Writer Report PAYRPCHK, RDF and pychqwrt, pkb, Deposit Advice PAYRPPST, RDF and payroll Register PYRPREG.
Wrote document for those customizing oracle application reports.

Environment : Oracle Financials HRMS NCA10.7 Oracle Developer 2000, Oracle Discoverer 3.0, Oracle Forms 4.5, Reports2.5, SQL*Forms3.0, SQL*Plus, PL/SQL, SQL*Loader, SQL*Reportwriter1.1, LEGATO/ Net Worker, Crystal Reports, TOAD, SQL Server 7, Access, Windows NT 4.0, Sun Solaris


April, 1995 -  February, 1999
Technical Consultant


Developed LEGAL/ PATENT database system.
Provided DBA support for PATENT Database and Texas Instruments.
Developed HMO/PCA system which included Claims, Client_unit, Provider and Provider_networks.

Environment : Oracle Developer 2000, Oracle Reports2.5, SQL*Forms3.0, SQL*Plus, PL/SQL, SQL*Loader, SQL*Reportwriter1.1, LEGATO/ Net Worker, Access, Oracle 7.2, Novell NetWare, Windows NT 4.0, Sun Solaris


May, 1992 -  March, 1995
Oracle Financials Developer





Education

Graduated Study Computer Science . Southwest Texas State University , San_Marcos , Texas .
BS Chemistry or Mathematics . Huston - Tillotson University , Austin , Texas .



Miscellaneous

Developed customizations for Oracle Financials 9.7 system Purchasing Order, Accounts Payable and General Ledger.
Performed Technical support for Accounting Department, generated credit report flat files for EDP and TRW using PL/SQL, SQL*Plus, SQL*Loader to load flat files into tapes.
Reviewed Oracle General Ledger manual, with emphasis on how balances are stored.
Used PRO*C and PL/SQL to write various financial reports
Developed data conversion files for Master Pack, General Ledger, Accounts Receivable and Revenue Accounting.
Developed user interface by using SQL*Forms3.0, modified existing forms to enhance performance by using performance turning techniques in SQL*Plus and PL/SQL.
Developed reports by using SQL*Report writer, wrote User Manual
Created universe with elements used for financial reporting using Business Objects.
Environment : Oracle Financial 9.7, PL/SQL, SQL*Forms 3.0, SQL*Loader, SQL*Report writer 1.1, DGaviiON, REXX, XEDIT, Business Objects, Oracle 7/6.0 Novell NetWare
Information
Peter Chang