Senior Oracle Financial Functional Analyst Resume

SUMMARY

1 year experience in NetSuite implementation and support.
10+ years of experience in Oracle Applications, especially in Financials modules (GL, AP, AR, FA, ADI, Cash, Budget) and Oracle Distribution (PO, OM, INV)
10+ years of experience in Forms, Report, Oracle API, TOAD, SQL Developer, BI Publish etc.
Extensive Experience with Identify, analyze, design, development and testing stages of the system life cycle for ERP Customization work.
Master in Oracle Application Object Library (AOL), Oracle Alert, Discoverer, Oracle Application Development
Master in Oracle BI Publisher.
Experience of Manufacturing (OPM): BOM, WIP, Cost, Oracle Shop Floor Management
Knowledge of Oracle R12.
Strong analytical, problem solving and project control skills.
Strong Academic background on both business administration and computer science.
Oracle certified processional (SQL, PLSQL, FORMS).
Efficient verbal and written communication skills.
Self - starter, team-player and quick-learning, easy-going, hard-working.

PROFESSIONAL EXPERIENCE

Senior Oracle Financial Functional Analyst

Confidential

Responsibilities:

Full-lifecycle of NetSuite implementation. Master data, Open AR, Open AP, Trial balance, Fixed Asset data convention from Oracle to NetSuite.
Define Financial report and Saved Searches, create Advance PDF/HTML form in NetSuite.
NetSuite administration.
Programing Oracle EBS EDI process with AMAZON.
Responsible for financial module GL, AR, AP, FA, Cash support and extension. It includes five company global environment. Given solutions that integration with OM, PO, INV modules.
Implement US Sales tax.
Development Document base on XML file with Oracle BI publisher. (Check, Invoice, PO)
Implemented Web ADI and Report Manager. Customize user to cost center FSG report security rule.
Implement new set of books for new company Confidential Technology Singapore and China.
Convert Confidential Canada customer and Open AR to Confidential US through customer and AR interface for company merge.
Implement and customize AR Auto Lockbox. Split one bank file upload to three operating units.
Application upgrade from 11.5.9 to 11.5.10.2.
Work with Oracle Support and DBA to resolve the specific issues (Patches, updates)
Develop varies report use Store procedure, Oracle Report, Discoverer and XML template (Example: AR, AP weekly cash forecast, Sale order on credit hold, sales revenue and corresponding cost detail. etc.). Data extract use SQL Developer for business user needs.
Implemented GL consolidation book, Intercompany transaction, and Outside Processing.

Senior Oracle Application Developer

Confidential

Responsibilities:

As technical lead Analyzing, Designing, Developing, testing and training Project of Blanket PR & Shipping Notice that integration with PR, PO interfaces of Oracle Application. Using Oracle Form and report on Oracle ERP 11i with HP UNIX.
Successful Analysis, Design and Developed P2P Document Matching Form, AP Payment Reschedule Form.
Analyzing, Designing, Developing and testing Project of Goods Import bonded system (GIB), that integrating with Oracle OM, PO, INV Modules.
Successful implementing and supporting the Oracle Applications 11i (Financials, Oracle distribution) on-line full-life-cycle for SINOMOS INC. Working directly with user to provide the required expertise so as to ensure the delivery of tangible results, on time and under budget. Be in charge of a full implementation project, provide functional guidance, training and provide functional/technical support.
On-line Data import use ADI, Dataload or SQL loader.
Customized reports related to GL, P2P and O2C.
Customized additional function for standard forms use custom.pll or DB trigger.
Customized Alerts.