SUMMARY

• About 21 years of IT experience in Cloud HCM (Payroll/Absences Management/Time and Labor, and Core HR) and the EBS Applications implementations/system upgrade/system enhancement, etc.
• Experienced in delivery full package solutions for Cloud Payroll, Absence Management, and Time and Labor.
• Collecting and documenting the business scenarios and requirements through workshop sessions and questionnaires.
• Analyzing the system based on business requirement and presenting pros and cons to the clients.
• Configuring the system using Oracle delivered features as well as fast formulas.
• Demonstrating the prototypes to the clients to finalize the solution.
• Testing and troubleshooting the system for the user approval test.
• Refining the solution through interacting with the clients.
• Strong documentation skill for the knowledge transition, e. g. using Oracle Unified Method for Cloud Implementation Methodology.
• Expert of fast formula in Payroll, Absence Management, and T&L modules.
• Skillful in utilities Oracle cloud delivered, e. g. Reports and Analytics, Approval Management, HCM Data Loader/HCM Spreadsheet Loader.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Lead Consultant

Responsibilities:

• School District of Philadelphia as T&L/Absence Management Lead
• Function design of implementation from complicated legacy system to HCM Cloud in Absence Management and payroll.
• Deliver the inbound/outbound interface between the Oracle cloud and 3th party system of absence Aesop and workforce time reporting system Kronos.
• Conduct questionnaire sessions to collect the policies, rules, and requirements and based on the discovery compile the documents of RTM, RAID, and RICE, etc.
• Deliver functional/technical design M65 documentations for complicated reports and interfaces.
• Deliver the complicated solution for the absence accrual adjustment processes.
• Design and configure complicated eligibility rules regarding absence plan/type, and extended to the Benefits module.
• Design and configure absence plans, accrual banks, absence elements, absence types, absence reasons, and action items. Implement complicated substitutions requirements in the legacy system.
• Design and configure the Payroll module for the absence payroll elements and customize the Oracle Payroll formulas to meet the requirements
• Conduct prototype presentation for all items and scenarios in RTM and deliver test/validate scripts.
• Resolve absence plans’ priority in the absence type issue in the payroll module, which is an Oracle defect and could not be fixed in SR.

Confidential, Houston, TX

Technology Delivery Lead Associate Manager

Responsibilities:

• Exelon Cloud Payroll Implementation as Main Payroll Function Designer
• Key role as Business Functional Analyst, implementing Oracle Cloud HCM Suite.
• Design and implement Payroll 401K, with 3 different categories of 401K plans and delivery the solution, which Oracle does not have.
• Delivery function solutions in Standard/Supplemental Earnings, 401K, Union Dues, Competitive Overtime Pay as FLSA, ADP Integrity, Oracle unsupported local tax, for implementation of the corporation (30,000 employees) and PHI (5,000 employees) to a Cloud Payroll from PeopleSoft and SAP, respectively.
• Direct and guide offshore team for functional/technical solutions
• Work directly with client business analysts and users for the new request and enhancements.
• Provide support to functional questions from the testers during test execution.
• Troubleshoot and fix Payroll fast formulas and other configuration issues.
• Support client through post go - live
• Hearst Implementation Project as Function Designer of conversion (HR and Talent Profile)
• Strategically define how data will be stored, consumed, converted, integrated and managed by different data entities and systems.
• Analyze, design and/or implement data design and best practices through technology solutions.
• Align with data governance, predictive modeling, and/or data visualization.
• Design the approach to guide client technology team to perform data extraction based on the latest HCM Cloud Technology.
• Modify and enhance the templates of Business Objects by Oracle to make work sessions with client much more efficient.
• Mock test the conversion strategies and guide "Offshore Team" to verify the testing the loading files.
• Helped with Core HR configurations and software analysis

Confidential, Houston, TX

Sr. Payroll Functional Consultant

Responsibilities:

• Implement US Payroll, Absence Management, and Time and Labor to Cloud HCM from EBS.
• As key functional role, conduct RTM and RAID analysis in the plan phase for Payroll and Time and Labor.
• Design in following function areas of Payroll, such as Standard/Supplemental Earnings, FLSA overtime/premium, 401K, local tax, Courtesy tax, Involuntary Deductions (e. g. Garnishment Deduction, Child/Spouse Support), ESPP, Accrual plans, FMLA, and Costing Allocation.
• Design absence plans, absence types, absence reasons, and action items in absence management.
• Design in following function areas of Time and Labor, such as Time Entry Layout, Time Rules, and Setup Profiles.
• Perform proof of concept and prototypes for the function areas above.
• Verify and test the logics of function design.
• Resolve payroll processing issues caused by incorrect configuration, element entry data, and/or fast formulas in the phase of SIT and PRC.
• Design and build ad hoc BI analytics and reports.
• Design and build payroll interface for non-US legislative data groups.
• Design and build interface for benefits outbound to vendors, e. g. Careplus, SHPS, UNUM, etc.
• Support Year End process.

Confidential, Los Angeles, CA

Sr. Oracle Functional/Technical Consultant

Responsibilities:

• As functional leader, architected, analyzed, implemented, and migrated legacy data in Mainframe system into Oracle e-Business for the organization merge. This includes designing migration strategies, mapping data to seeded or custom tables, convert columns with list of values (BR100), designing and developing (MD050/MD070) utility PL/SQL programs for data conversion, comparing data, and handling exceptions and bad records (records or/and column values violating logic in Oracle e-Business.
• Lead Year End Process includes end of year balance adjustments, W2’s, Setup new pay elements and benefits plans, and new benefit rates, Open enrollments, United Way pledges, and PTO carryover process for the new-year.
• Designed and implemented payroll interface to ADP.
• Designed and implemented Oracle GRC Suite to extend the custom security system of e-Business suite.
• Designed and developed Labor Distribution Setup Oracle Costing functions to transfer Payroll data with associated labor distribution account codes with credit and debit accounts to General Ledger.
• Perform Payroll/General Ledger reconciliation for month end closing. Created adjustment journals to balance accounts.
• Implemented OTL and enhanced it by being integrated with PTO accrual plans (allowing employees to check PTO accruals while entering timecard.
• Worked on SSHR configurations and setups.

Confidential, Los Angeles, CA

Sr. Functional/Technical Consultant

Responsibilities:

• As a lead role to implement core HR, Advanced Benefit, Time and Labor.
• Compiled and generated BR100 by collection of all business requirements as guideline to configure and setup work structure, HR/Payroll components, e. g. grade, job, position, people group, costing allocation, value sets, lookups, etc.
• Implemented Advanced Benefit, setup program, plans, plan types, eligibility rules, etc.
• Implemented OTL - configuring timecard layouts, setting up recurring periods, approval period, approval style, time entry rules, and preferences. Designed and developed custom functions for Fast Formulas to enforce time entry rules, e. g. prior period entry/edit disallowed, exempt employees exception hours no more than 80 hours per pay period, non-exempt employees’ overtime hours limitation, special timecard rules for shift workers.
• Designed and implemented fast formulas for OAB 401K plan as well as OTL time entry rules.

Confidential, Houston, TX

Sr. Oracle Functional/Technical Consultant

Responsibilities:

• Implemented Oracle Advanced Benefit modules, e. g. setup programs, plans, plan types, life events, eligibility rules, etc.
• Designed, implemented function extension (MD050, MD070) for HR/Payroll custom outbound benefit data interface with Blue Cross/Blue Shield, Manulife (Canada), and Kaiser.
• Designed, implemented function extension (MD050, MD070) for HR/Payroll outbound and inbound interface with Merrill Lynch as its 401K saving plan administration.
• Designed, implemented, and developed Payroll outbound positive pay interface with Wells Fargo and HSBC.
• Designed/implemented outbound file automated administration system by using Unix host script and PL/SQL package.

Confidential, St. Louis, MO

Sr. Oracle Functional/Technical Consultant

Responsibilities:

• As a leading functional role of full implementation of Core HR, Payroll, Time and Labor.
• Configured, setup work structures, e. g. business group, GRE, and legal entity, as well as job, position, competence, grade, person analysis, soft code, people group, and cost allocation key flexfields.
• Collected, analyzed, and compiled business requirements and legacy system features and functionality to generate BR100 for data mapping, e. g. value sets, lookups, and data conversions.
• Implemented Time and Labor for hourly/salary employees. Configured and/or modified timecard layouts for payrolls. Created time entry rules, approval period/style, and custom fast formulas to meet requirements.
• Implemented payroll components, e. g. earnings, deductions.
• Created test plan, and user training scripts.

Confidential, Houston, TX

Sr. Oracle Functional/Technical Consultant

Responsibilities:

• Analyzed, designed and customized Oracle Project/Payables/Receivables/Purchasing intercompany importing interface. Setup and implement AP/AR/PO/PA records into GL as intercompany journal entries.
• Analyzed, redesigned, and customized reports for GL, AR, AP, FA, and PO, e.g. AR Aging Report, etc.
• Prepared documentation of the integration procedures for the Oracle application A/R, Order Management, 11i and Vertex 2.1.7 using Oracle 9i database
• Installed, developed and maintained company’s Vertex database using Oracle 8i with Vertex PL/SQL version.
• Analyzed, designed and developed/tested BI XML publisher reports.
• Analyzed, configured and setup custom Purchasing Order Approval workflow to fit the user requirements.
• Analyzed, evaluated, implemented upgrade to 11.5.10.2 from 11.5.9.

Confidential, Virginia

Sr. Functional/Technical Consultant for HR, Payroll, Benefit and Finance

Responsibilities:

• General Ledger Set of Book Consolidation Project for Smithfield and Gwalney.
• Oracle Financial and Payroll reconciliation project, (Monthly and Year End reporting).
• Configured and setup Self-Services for Executive Payroll.
• Oracle Labor Distribution analysis and project write up for 11.5.9.
• Oracle Advance Benefit analysis and project write up for 11.5.9.
• Implementing new plants into Oracle HRMS/Financial system after merger.
• Debugged and resolved issues for Gross up earnings which have problems on SOE’s earning calculation when employee has refunds.
• Debugged and resolved issues due to incorrect inventory element setup in payroll costing by redoing the elements setup
• Debugged and re-developed 401K fast formula.
• G/L & Payroll costing reconciliation project - identified the deficiency in G/L interface processes and made recommendations to improve the monthly end closing.
• Developed in-house interface routine to transfer Payroll data with associated labor distribution account codes with credit and debit accounts to General Ledger.
• Performed Payroll/General Ledger reconciliation for month end closing. Created G/L journals to balance accounts.
• Designed and developed Kronos Time card system interface transferring data to Payroll module at pay period basis for Batch Element Entry (BEE).

Confidential, Houston, Texas

Sr. Technical/Functioal Consultant

Responsibilities:

• Review and enhanced Financial (GL, AP, AR, CM, PO, Oracle Project) set ups for create new GRE and Set of Book for California Operations.
• Configured and setup AR customers, AP vendors, GL account charts related data and all the needed key flexfields fields in the Financial system.
• Configured and setup PA (Project Accounting) Project, Task, Resource, Billing, Costing, HR organization, job, position, people group, special information type, tax rules, salary management, and all the needed key flexfields fields in people and assignments for California Operations.
• Create new benefit programs and plans in OAB configuration. Also new PTO accrual plans, pay elements set ups with California State requirements.
• Enhanced Self Service module to in corporate California employees.

Confidential, Dallas, Texas

Oracle Technical/Functional Consultant

Responsibilities:

• Implemented newly-installed e-Business 11i HR, Payroll and 80% Oracle Advanced Benefit for over 30,000.00 teachers, PE coaches and school employees.
• Implemented Self Service HR, Oracle Project and Oracle Labor Distribution.
• Designed G/L interface between Labor Distribution, Project and Oracle Financials
• Developed in-house interface routine to transfer Payroll data with associated labor distribution account codes with credit and debit accounts to General Ledger.
• Setup procedures for users to perform Payroll/General Ledger reconciliation for month end closing. Created adjustment journals to balance accounts.
• Investigated and resolved setup issues, and debugged setups for Payroll State Taxes and Tax Corrections (refunds and recoup).
• Designed and Developed Workers Compensation HR Sub-System.
• Designed and Developed Vacation and Sick Time Recap Report
• Setup PTO Accrual (new Vacation and Sick Time Accrual Plans), write Rules in Fast formula to reflect the changes.
• Setup new HR and Payroll Responsibilities to better secure the HR and Payroll information.
• Setup and programming to convert existing data for Oracle Standard benefits with over 30000 employees benefit enrollments.
• Trained Payroll Group in the proper use of Oracle HR and Payroll.
• Create Oracle Discoverer Views for HR, Payroll, Benefit data and training end users how to create ad hoc HRMS data using Discoverer reporting tools.
• Create Advanced Benefit functions - setup 403B benefit program and plans for employee enrollments (over 1200 US financial institutions).
• Create Stipend earning programs for DISD sports coaches compensations (over 60 different types of pay incentives).

Confidential, Houston, TX

Oracle Technical & Functional Consultant

Responsibilities:

• Oracle 11i (release 4) HRMS, manufacture and financial new implementation project.
• Creating and setup new Arima responsibility for the different group of users; setup user profile, organization hierarchies, multi-business groups, and GRE.
• Registering and setup interface and reports under Apps concurrent manager.
• Designing and setup all key flexfields (job, position, grade, special info, people group, cost allocation), descriptive flexfields, and value sets for Oracle HRMS.
• Setup shifts, work plan, rotation plans, earning groups, variance, and eligibility rules for OTL.
• Coding data conversion interfaces to convert employee, contact, address, assignment, and salary information from legacy system into Oracle HRMS system using Oracle APIs.
• Implemented financial and manufacture flexfields (accounting, category sales order, item category, stock location, sales taxes location, asset category, territory, bin category).
• Designed and coded WIP interface, which provides all information for in-house shop floor system, and includes seven interface tables, picking list (work order) report, serial number and customer shipping information?
• Programmed price interface and forecast interface base on Oracle API.
• Implemented and configuring the Accrual Plan and absence management. Developed and maintained Fast Formula to meet the requirements.
• Designed and developed 11 Oracle reports (picking slip, invoice, second invoice, picking list and different kinds of auditing reports) using Report 6i.
• Designed and developed form customized forms for CTO and BTO completion and shipping processes using Oracle Forms 6i. Created a very complicated view to connect all different kinds of shipping.
• Implemented and configured Advanced Benefit, HRMS Self-Service and Time and Labor Management.
• Customized Self Service and Time and Labor approval processes using Oracle Workflow builder.
• Customized and enhanced CRM Telesales forms and back-end process to fit the specific business requirements.
• Customized, designed, and created workflow using workflow builder to automate the CRM and OM processes.
• Developed and customized Oracle Apps Discoverer reports on HR/OTL, AR, and CRM.

Confidential, Deer Park, TX

Oracle Technical/Functional Consultant

Responsibilities:

• Function setup of HR/OTL, elements, holiday calendar, shift, work plans, rotation plans, earning group, etc.
• Designing and coding custom library for the special business functionalities in People form, Assignment form, Salary form and Application Assignment form.
• Designing and coding outbound interface for Metlife, Advanced PCS, United Healthcare, Vision, etc. using Oracle API & PL/SQL.
• Developing ERP custom reports in multiple modules, such as HR, Payroll, Benefit, AR, GL, and AP, (e. g. employee transfer, benefit premium due, 401k extraction, payroll journal entries, payroll runs not paid, payroll costing journal by account, employee/element, employee, etc. for HR/Payroll;
• Developing PL/SQL inbound interface for Time and Labor.
• Developing PL/SQL packages, procedures, and functions to meet business rules in HR and Payroll areas, to narrow down identified the user errors.
• Implementing Standard Benefit Administration for HRMS.
• Setup Oracle Discoverer to display HRMS information and report.
• Implementing and configuring Time and Labor Management.
• Customizing Time and Labor approval processes using Oracle Workflow builder.
• Oracle Application 11i Release 4 (11.5.4) Oracle HRMS upgrade and implementation.
• Setup deduction elements (medical, dental, vision, 401k, long term disability, life insurance).
• Designing and coding Owen benefit inbound interface (including medical, dental, vision, 401K, long term insurance, life insurance for employee, child and spouse, etc) for benefit open registration.
• Designing and implementing data warehouse database sync with Oracle Applications and programming PL/SQL ETL.
• Designing and coding custom library for absence management.
• Setting up balance adjustments (federal, state, country, and city).
• Revising time card interface for in-house designed time card system using Oracle BEE load.
• Creating three views for time card system base on HRMS tables.
• Setting up payroll group procedures for running oracle payroll and Quick Pay.
• Setting up assignment sets, run payroll process, pre-payments, NACHA and check writer.
• Designing and developing employee count, employee transferred; benefit registration, 401K, and payroll reconciliation reports using Oracle 6i.
• Defining system security, e.g. new responsibilities, request groups. Set up organization structures, and user profile.
• Designing and customizing Oracle Discoverer reports.