OBJECTIVE:

Seeking a challenging Sr. Oracle EBS Functional/Technical Analyst role.

SUMMARY:

• I have over ten years of hands - on Oracle EBS functional and technical experience as a Senior Application Consultant/ Senior System Specialist, implementing, upgrading and/or supporting Oracle EBS, both financial modules and distribution modules. I have worked on many Oracle EBS projects with various Oracle Financial modules and for many companies across different industries. I am a detail oriented problem solver and results oriented functional-technical solution provider. I am very efficient in resolving Oracle Applications related issues and problems. I am a fast learner and very productive. I enjoy working with end-users and different IT support teams. I am a team player and love to work in a team environment.
• Over 20 years of overall IT and Oracle EBS Implementation/Support experience.
• 10+ years of consulting experience as an Oracle EBS Functional-Technical Consultant.
• Multiple Full-Lifecycle Oracle EBS R12 implementation and upgrade experience. Utilized AIM/UOM methodologies during implementations.
• A critical member of project team liaises with business users and technical teams. Played key role in designing localized solutions in multi-national multi-GAAP projects.
• Go-live/post-implementation Production support experience (techno-functional role).
• Extensive functional experience with EBS modules including GL, SLA, AP, AR, AGIS, FA, CE, PA, OM & PO. Conducted modules Configurations, Testing, Trainings and Support.
• Extensive Production Support experience both functional and technical.
• 10+ years of hands-on programming experience with strong knowledge in PL/SQL, SQL*Loader, SQL*Plus, XML Publisher, Oracle Reports and Forms.
• Superb trouble-shooting and problem solving skills.
• Strong relationship with business end-users, onsite and offshore project teams.
• Strong verbal and written communication skills.
• Implemented/supported Oracle applications for companies across several industries.
• Master degree in MIS. Bachelor degree in Finance.
• U.S. Citizen. Fluent in English. Native in Chinese Mandarin.

TECHNICAL SKILLS:

Applications: General Ledger(GL), Subledger Accounting(SLA), Advanced Global Intercompany Systems(AGIS), Receivables(AR), Advanced Collection(AC), Fixed Assets(FA), Payables(AP), Cash Managements(CM), Project Accounting(PA), Purchasing(PO), iProcurement, Order Management(OM), iExpenses, System Administrator.

Languages: PL/SQL, SQL*Plus, SQL*Loader, UNIX Shell Scripting, XML, HTML

Oracle Tools: TOAD, Oracle SQL Developer, Oracle Developer, Discoverer, XML Publisher, Oracle Reports, Oracle Forms, GL Connector, XL Connector

PROFESSIONAL EXPERIENCE:

Independent Oracle EBS Consultant

Confidential, Dallas, TX

• Functioned as a Finance Lead, I am a key member of one of the deployment teams in a large Oracle EBS R12 implementation project, rolling out EBS R12 modules to company’s 32 divisions.
• Liaise with business teams and project teams, gather business requirements, design, and test and implement best possible solutions to meet business’ requirement.
• Train key business users on how to work with Oracle Financial modules effectively.
• Covering all financial modules, including AR/AC/AP/FA/PA/CM.

Independent Oracle EBS Consultant

Confidential, Andover, MA

• Functioned as a Sr. Functional-Techno Financial consultant, I was a critical member of a large multi-national Oracle R12 implementation project, rolled out EBS R12 modules to company’s international divisions:
• As a module lead of AR/AC/FA/EB-Tax/SLA/GL modules, completing each phase of implementation cycle. Together other project team members, we are successfully rolled out EBS R12’s financial and manufacture modules to Taiwan, Singapore and China divisions.
• In charge of designing, testing and implementing of China localization solutions, including local statuary reporting, Golden Tax Systems interfaces and AR Invoice Printing.
• Designed and implemented custom solutions to meet Taiwanese special AR invoicing needs. Solutions included GUI Invoice numbering, E-Invoice interface and consolidated invoicing.
• Designed and implemented custom SLA rules to meet company’s specific accounting needs.
• Worked as liaison between business teams and technical teams during data conversions of Suppliers/Customers master data, and transactional data such as assets data and open AR.
• Provided Post-Live Production support both functionally and technically.
• Working closely with other team members on other modules including OM and PO.
• Provided Production support help for US divisions while working on implementation projects.

Independent Oracle EBS Consultant

Confidential, Boston, MA

• Functioned as a Sr. Functional-Techno Specialist, I worked closely with Global Implementation Team and successfully completed a multi-national EBS R12 Upgrade/Implementation project:
• Worked closely with key business users, I gathered and analyzed business requirements, translated them into functional design/configuration documents. Configured AGIS/SLA/AP/AR modules, conducted CRP and UAT testing, trained users with R12 new features. Together with project team members, we successfully upgraded Oracle EBS from R11.5.10 to R12.2.4 on schedule. The project involved 40+ Operating Units and many end-users over 30 countries.
• As the AGIS module lead, successfully implemented Advanced Global Intercompany System (AGIS) to 30+ division offices around world. Provided extensive Post-Production Support to US and international users, both functionally and technically.
• Implemented PO Category restructure from one-segment to three-segment structure along with R12 Upgrade project. Wrote PL/SQL script to upload new three-segment values into Purchasing module. Re-Structured new stores for iProcurement that made requisition creation processes more efficient and user friendly.
• Provided Production support for FIN and SCM modules both functionally and technically.

Independent Oracle EBS Consultant

Confidential, Chicago, IL

• Functioned as lead functional Oracle EBS consultant, I completed an Oracle implementation project for an insurance services company, and rolled out EBS to its newly acquired division.
• Functioned as AR/AP/GL modules functional lead, I gathered business requirements, set up modules, conducted CRP and UAT sessions, trained new users and created functional documents. Together with other team members, we successfully performed Production-cutover and rolled out EBS to client’s newly acquired business division.
• Trained end-users on how to use Oracle EBS effectively to improve their work efficiency.
• Provided post-production techno-functional support and resolved many system related issues and successfully closed first period.
• Designed, developed and implemented custom programs to interface HR/Payroll data between Oracle HR and UltiPro.
• Designed, developed and implemented a custom 1099 program that merges 1099 data from two different sources and generated a single 1099 reporting file.

Independent Oracle EBS Lead Consultant

Confidential, Kansas City, KS

• Functioned as a lead techno-functional Oracle EBS consultant, I am providing techno-functional support of Oracle EBS for an Energy company, Confidential . EBS modules that I supported include GL, AP, AR, CM, FA, OM and INV. My selected personal accomplishments include:
• Functioned as a functional-lead in an implementation project that rolled out Oracle EBS to two new business divisions. Configured AP/AR/FA/CM modules under separate operating units.
• Provided post go-live Production support both functionally and technically. I was the go-to person for any Oracle EBS related issues. All issues were resolved in a timely manner.
• Lead an upgrade effort of EBS from R11.5.9 to R11.5.10.2 and ready for R12 upgrade.
• Designed, developed and implemented a custom solution for Order Management module to process orders and invoices in a special way that meets unique business requirement.
• Designed, developed and implemented several interface programs that interface item master data from a legacy system into EBS Inventory module; and transactional data into AP and AR.
• Created several new custom reports to meet new business requirements.
• Provide daily production support and resolved many issues for business users.

Principal EBS Consultant

Confidential, Dallas, TX

• Functioned as an AP/PO/iProcurement functional lead consultant, conducted business requirement gathering, gap analysis, business processes mapping and documentation. Prepared Functional Specification document for AP and PO modules.
• Configured AP/PO/SLA/iProcurement modules and conducted User Acceptance Testing.
• Created SLA Custom Source and ADR to client’s special business requirement on accounting.
• Conducted integration tests for different domestic and international divisions.
• Resolved many application related issues effectively and kept project on schedule.

Confidential, Kansas City, KS

• Provided functional and technical support for the company’s effort of rolling out EBS financial modules to a new business division.
• Configured a new Fixed Assets corporate book and converted assets from the new business division from JD Edward to Oracle Fixed Assets module.
• Designed, developed and implemented GL code combination and Balance conversion programs and converted new division’s legacy data into Oracle EBS’s GL module.

Independent Oracle EBS Consultant

Confidential, New Albany, OH

• Functioning as a Functional-Technical Oracle EBS specialist, I worked on an EBS R12 upgrade/implementation project for Tween Brands, Inc. The modules that I supported include GL, SLA, AP, FA and PO.
• Providing functional and technical support for a client company for its effort of upgrading existing EBS from R11 to R12 implementation and roll out to new business divisions.
• Resolved many R12 application related issues, such as AP Trial Balances Report issues, Intercompany Balancing Rules setup issues and SLA Create Accounting issues.
• Created functional design documents to map out GL balance conversion and JE interface processes. Designed and developed GL balance conversion program.
• Designed and developed several interface programs that interface AP invoices and assets from other systems to Oracle’s AP/FA modules.

Sr. Oracle Applications Analyst

Confidential, Richardson, TX

• Functioning as a functional-techno Oracle EBS specialist provided post implementation production support both functionally and technically for Oracle Financial modules including GL, AP, PO, iProcurement, PA, FA and AR. I also supported third-party AP invoice processing application MarkView. I resolved many Oracle related issues for our business users and developed many RICE programs to meet business’ specific needs.
• Provide day-to-day production support: troubleshooting and break-fixes. Manage incident and problem tickets and resolve them according to the priorities.
• Worked closely with business managers to understand business needs and gather requirements for improvement. Created several custom reports that helped business users improved business process. For example, one of my AP custom reports is helping AP manager easily identify duplicated payments therefore reduced number of duplicated payments dramatically and saved company millions of dollars.
• Designed, developed and implemented a PL/SQL program to help PO users to mass receive items against open POs and saved business users one week of time and enabled them to book accruals before year end.

Sr. Oracle Consultant

Confidential, Dallas, Texas

• As a techno-functional consultant of an OTL implementation project, designed, developed and implemented an interface programs that interface Oracle HR data with third-party web based Time-Clock application. The interfaces enabled HR staffs reconcile employee’s working status and working hours much more effectively.
• Worked side by side with our auditing partner on providing recommendations and system improvement solutions to our client, Dallas Independent School District (DISD).
• Reviewed and investigated issues within the Oracle financial systems (GL, AP, AR, FA modules) that have been identified by the auditors. Provide recommendations and/or solutions for resolving the issues and fixing the problems.

Sr. Oracle Specialist

Confidential, Plano, Texas

• Providing production support for US and international remote users (China and Iceland).
• Participated in Oracle-SAP conversion project, designed and developed several interfaces, such as AP/PO accrual interfaces and GL account interface, to integrate SAP applications with Oracle applications. Worked closely with business users and other EAM teams on gathering and documenting requirements, designing and developing solutions, developing test plan and conducting integration test. Provided go-live implementation and post production support.
• Involved in many project activities playing a role of SME. Provided answers/reports to many ad-hoc inquiries and requests. Provided helps with testing plan, setting up testing jobs and debugging failed jobs. I was often the go-to person for my users and was depended on to find the proper Oracle solutions by other cross-function teams.
• Configured additional GL Sets of Books for newly acquired oversea companies to allow foreign currency transactions directly enter into Oracle Applications. This capital project was initiated with very short notice and I was able to complete it on time and under budget.

Financial Applications Manager

Confidential, Plano, Texas

• I functioned as a System manager managing Oracle Financials R11i. Helped implementing all core financial modules and personally worked on many tasks including module configurations, data conversions and custom programs development. Oracle modules I supported including GL, AP, FA, PA, AR and Cash Managements.
• Functioned as an internal team lead in the Oracle applications’ initial implementation project. Worked closely with external Consultants during configuration and go-live. Led supporting effort during initial stabilization and post implementation phases.
• Managed a small support/development team supporting daily business needs and develop RICE components. Played dual role of manager and developer/analyst.
• Created customization standards documentations and made sure all developments are consistent with the pre-set standards. All Setups and customizations are well documented.
• Designed and created MD50 functional documents for data conversion processes to convert legacy AR/AP invoices into Oracle AR/AP modules.
• Managed an upgrade project upgrading Oracle applications from v11.5.6 to v11.5.9.

Sr. Application Consultant

Confidential, Dallas, Texas

Worked on several projects for clients that across several industry sectors:

Oracle Financials Implementation

Confidential, Cambridge, MA

Functioned as an AP/PO Specialist, involved in full life cycle of implementation and successfully implemented Oracle Applications for the company.

Oracle Manufactures Implementation

Confidential, Dallas, TX

Functioned as a Sr. Application Consultant fully responsible for converting orders, inventory items and GL data from legacy systems to Oracle OM, INV and GL modules.

Oracle Applications Implementation

Confidential, San Antonio, TX

Functioned as a Sr. functional consultant in charge of implementing Oracle Purchasing and Payables modules.

Staff Accountant / Business Analyst / System Analyst

Confidential, Dallas, Texas