TECHNICAL SKILLS:

Skills: Oracle Cloud Implementation and Support; Oracle ERP Application 10.x, 11i, 12.1Support, and Implementation; Database Administration;

Tools: Oracle BI tools, Oracle XML Publisher, PL/SQL, SQL Connect, Oracle Report (Ver. 2.0 - 9i)Oracle Discoverer(3 - 11g), PVCS, JIRA(Project & Work Issue)

Language: SQL, PL/SQL, HTML, Oracle ProC/C++, VISUAL C/C++.

EXPERIENCE:

Technical/Functional Support for Oracle HCM/Cloud system

Confidential

Responsibilities:

• Interfaces with ADP Payroll system with ADP G2 Spec for 12 Global payrolls with HCM Extracts.
• Created/Maintained all customized HR, Compensation, Payrolls, OAB, AP and GL reports with BI tool. like Absence Accrual, Employees Details, Work Structure, States Workman Comp, Assignment Change, Area of Responsibility, Payment Methods, Worked hours, SOE, etc..
• Interfaces with internal Application Systems like Dataware House. OKTA, Oracle EBS (Financial).
• Upload acquisition data with HDL. HSDL and PBL tools.
• Created/Customized Fast Formula for Absence Accrual.
• Customized Workflow Display Page with BI tool.

Oracle HCM Techinal/Functional Support

Confidential

Responsibilities:

• Supported any issues related with Global HCM system in 40,000 HR employees and 23,000 Payrolls/Benefits (OAB) system.
• Admin/Create/Maintain all customized HR/Payroll/OTL/OAB/AP/GL reports with Discoverer, Report Writer, and PL/SQL developer tools.
• Implemented Oracle Manager Self-Service Reports with Oracle XML Publisher tool.
• Converted 4000 Global HR/Payroll/Benefits data to Oracle HCM system withn Oracle API packages.
• Migrated Legacy employees appraisals data to Oracle Talent Management system.
• Third Party Hours Loading to OTL and BEE tables.
• Help Concurrent Manager Layouts for Oracle Replication Server system to improve performance.
• Supported Data Consolidation for Payroll Accounting and Auditor in Payments and Costing.

Technical/Functional Support

Confidential

Responsibilities:

• Technically Supported Oracle Training system in Bulk Enrollment with API, reports and Contents import.
• Supported Global HR in Organization, Positions, Jobs and Flex values setup and data migration with API.
• Supported Oracle OAB Module, Life Event setup, Fast Formula, Health Eligibility Interface, Benefits Confirmation Letter, and any kinds of reports for benefits deduction checking and ceusus.
• Supported 3rd Party Payroll In/Out Interfaces; sent out person info like salary, elements entry values for their payroll processing, and received their feedback to upload into Oracle Backfeed tables.
• Application System Administrator that includes setup of Security, Responsibility, Menu, Flex values, Fast Formula, Oracle Alert and Concurrent Programs etc..

Developer for Oracle Financial system

Confidential

Responsibilities:

• Supported Oracle Financial AP and GL modules, and created PL/SQL interfaces to upload/download data from other Purchasing and Project Accounting systems (PRISM).
• Migrated from Oracle 11.5.8 to Oracle 11.5.9 (Oracle DB 9.2 and App server 9.04/10g).
• Customized DAD PL/SQL modules for AP invoice query.
• Used Discover tool to create business area, folder, and wordbook to query Historical Financial data
• Supported and setup 170 workflow system which tracking the invoice workitems.

Developer for Oracle HR/Payroll, Financial system

Confidential

Responsibilities:

• Extracted HR/Payroll historical Earnings & Deductions & Tax data from Oracle HR/Payroll 11i system to load into ADP Enterprise system with Application API and PL/SQL tool.
• Created reports and discover program to consolidate AP & GL balance.
• Used Oracle 9i Report Writer and Discover to generate field Reserve reports and PL/SQL tool to create packages for data migration.
• Installed Oracle 9i Database and Application Server (10g) on Window 2000 platform. With Form, Report and Discover Services running in the backend.
• Developed a web application to tracking system activity with PL/SQL Web toolkid packages (include HTP, HTF, HTML JavaScript, OWA UTIL, and OWA TEXT etc) and PL/SQL Server Page...
• Daily Technical support for AP, GL, and AR modules in reports, PL/SQL interfaces, Discover, ProC, and Unix Shell scripts.
• Create a Data Warehouse with historical Sale and Financial info, and brouse with Discover tools.
• Created customized 6i&9i forms and reports for corporate application system, like Time-Sheet Entry, Product Exchange, and Global Market Sales information system.
• Migrated the Time attendance with 9i forms and reports to 10g Application Server environment
• Interfaced ADP HR/Payroll with GL Posting and Time Attendance system.
• Data Migration from Oracle HR/Payroll system to ADP Enterprise system.
• Daily production support for HR/Payroll system in reports, PL/SQL interfaces, ProC, and Unix Shell scripts. And, functional support for elements, balance items, fast formula, security, and GL costing setup.
• Enhanced and Generated Tapes of Employee Benefit data from Oracle HR/Payroll system and sent to Financial Entities like American Century, Aetna, Cigna, Unum, John Hancock, Frick, and Metlife. Automatizes/Integrated these processes with UNIX scripts and registered to Concurrent Manager.
• Fine-tuned all customized SQL statements related with HR/Payroll tables, some with 20 million rcords.
• Customized Check writer and Deposit advice files for sending to Mellon Bank.
• With SQL server as backend, and Visual Basic/Crystal report in front end. Also created ASP pages to allow internet user to do remote registration.

Technical Developer for HR/Payroll System

Confidential

Responsibilities:

• As a member in Oracle implementation team to finish HR/Payroll R10.7 project.
• Responsible for HR/Payroll reports/interfaces and support functional people to verify application setup.
• Those works were related with Earnings, Deductions, 401K, Benefits, and Tax.

Technical Developer for HR/Payroll System

Confidential

Responsibilities:

• In a team to migrate Oracle Application from R10.5 to R10.7.
• The major role is to customize Check Writer and Deposit Advice and generate files based on standard format for checks printing.
• Tuned all customized reports and PL/SQL to assure best performance for operation.

Technical Developer for HR/Payroll System

Confidential

Responsibilities:

• Completed a successful Implementation of Oracle HR/Payroll application R10.7 just over 3 months.
• To develop critical reports and interfaces for company HR/Payroll operation with PL/SQL and Developer 2000 tools.
• Those programs are related with Employee’s Earnings, Deductions, 401K and Benefits.
• Some are used for State or Federal Tax filing purpose.

Technical Developer for HR/Payroll System

Confidential

Responsibilities:

• Fine tune applications to optimize the system performance.
• Cut the running time from hours down to minutes, and minutes to seconds.
• Some of the tables included more than 20 million records.
• Those applications were developed with Oracle Developer 2000 and used for HR/Payroll, Sales/Shipping, and Inventory control