TECHNICAL SKILLS:

Technology and Tools: ORACLE REPORTS BUILDER, XML Publisher, DISCOVERER 10G, SQL* Loader, ACCESS, TOAD, Embarcadero, SQL Navigator, SQL Plus, PL/SQL, Taleo TCC, Fusion HCM Extract, Fusion PBL and HDL, Fusion OTBI, Fusion BI Publisher

PROFESSIONAL EXPERIENCE:

Confidential, Nashua, NH

Senior Consultant

Responsibilities:

• Worked as a technical lead in successful go live from EBS to Fusion HCM Cloud conversion and integration Implementation; worked involved HCM data load, Talent profile HDL load and compensation fast formulas. Additionally worked on pay batch loader (PBL) for payroll relationship s load. Additionally tasks involved usage of BI Publisher, OTBI, Comp Fast Formula, Talent Performance Load
• Participated as a technical lead in successful go live from EBS to Fusion HCM Cloud conversion and integration Implementation and People Fluent to Taleo Conversion; continued on Phase II to assist in compensation and talent implementation - worked involved Talent profile HDL load, and Benefit and compensation fast formulas. Managed and worked diligently with offshore team to get the assignments accomplished on time.

Confidential

Senior Technical Developer II

Responsibilities:

• Created several inbound and outbound processes from Solium to Oracle and from Oracle to Solium to implement Signet (Parent. Company of Confidential ) stock purchase program. Inbound interface included into Oracle Payroll, outbound interfaces included eligibility, demographic changes and payroll contribution files
• Created several inbound payroll interfaces from Work Force Management (WFM) to import payroll activities into Oracle payroll. Also worked on several outbound interfaces to WFM from Oracle HR.
• Participated in platform migration from Unix to Linux, with a leading role in all EBS HRMS related activities including several codes shell script modifications.
• Developed several payrolls related reports using XML publisher; Supported and modified several PL/SQL interfaces for vendors such as Cornerstone, Fidelity, Prudential and etc, and also supported Benefit related system extracts for UHC, Delta and VSP.
• Developed XML Deposit Advice for Canada Business Group using Canadian Archived payroll tables and data in version oracle application 11.5.10.
• Created and implemented web ADI integrator (Recently called Desktop integrator) to upload Grade Salary range data.
• Created and configured multiple plans for a program; Created and implemented several fast formulae for OAB to meet new business requirements for open enrollments.
• Worked on several Unix scripts to call SQL, and send files to other vendor location using ftp or sftp. These scripts were also designed to send email to responsible group in case of failure.
• Worked on several modifications on locally developed software called Variable Compensation Service (VCS) due to fiscal calendar changes due to Signet Jewelers taker over.
• Worked with lead developer on Zale Merit Increase software developed with JDeveloper in OA Framework format.
• Supported and resolved several issues related to Employee Self-Service, Manager Self-Service, Oracle Workflow, and Approval Management Engine (AME).
• Supported other modules such as AP and GL as needed.

Confidential, Garland, TX

Lead HRMS Oracle Analyst (Techno-Functional)

Responsibilities:

• Actively participated in EBS 12.1.3 upgrade from 11.5.10 project. As an upgrade process, converted on-line Payslip into a PDF format from HTML. Additionally, implemented payroll archival deposit advice and payroll check writer with BI publisher usages. Several custom codes were revised to comply with 12.1.3 upgrade.
• Acted as a liaison between end user group and technical community to troubleshoot, design and develop any business needs to make a full use of Oracle HRMS (HR, PAYROLL, OAB, and SSHR) module. Troubleshooting involved digging into technical codes and revising configurations. If the issues were related to local custom codes, modified and tested thoroughly. Seeded issues were reported to Oracle with Service Requests using Oracle Support Website.
• Annually assisted in all W-2 related year end payroll processes.
• Closely worked with payroll accountant to submit payroll accounting compliance reports such as 940 and 941. Oracle patches are monitored, reviewed and request to apply for the most up to date of these reports. Also assisted in running costing to reconcile accounting information and post to GL.
• Worked with payroll manager on several reports and data reconciliation using SQWL, Gross to Net, and Federal and State Tax Remittance Reports.
• Created several elements and set up and modified FAST FORMULAS as needed to execute results for the payroll related activities. In most incidents, fast formula creation included introduction of several new PL/SQL related functions being called by fast formula.
• Worked on several OAB related projects to migrate or modify benefit plans and options to another as required by TRS rules and/or requested by benefit administrator. Projects included creation of new plans, options, and eligibility profiles along with new life events for OAB to behave appropriately to meet employees’ modifications. This included several setups such as creation of new fast formula, enrollment codes, derived factors, standard and variable rates and etc. Created HIPPA letter communication types upon running a Termination Life. Created or modify OAB related fast formulae to configure the OAB related standard rates, effective dates, and periodization to limit payroll deductions for benefit plans and options.
• Provided functional support to alter or/and enter necessary entries or set ups within HRMS for business requirement. Additionally, uploaded annual salary increases using APIs and grade step progression; created grade, grade scales and steps to support GISD salary structures.
• Wrote outbound interface PL/SQL script to Confidential, Guardian Dental and ExpertPay. Provided technical supports to design and develop HRMS processes and reports using concurrent processes Oracle Discoverer and Report writer. Used personalization features to modify OA framework pages and forms as desired by the users. Worked on several interfaces including Kronos, Aesop, PEIMS and others with heavy use of PL/SQL.
• Provided continuous technical support on the interfaces with Teacher Retirement Services (TRS), Public Information Management System (PEIMS), Automated al Substitute Operator (AESOP), Guardian Dental, Confidential, Expertpay and others.
• Provided HRMS related system administration supports, such as setting up and uploading users, and assigning them to benefit enrollment responsibilities using manual or automated API processes. Additionally, used system administration and application developer responsibility to create menus, functions, KFF, and DFF to fulfill company requirements.
• Monitored and recommended mandatory patches into HRMS system (mostly payroll). Created test cases per README for these patches. As a techno-functional resource, monitored test results before approving to move to production.

Confidential, Dallas, TX

Oracle Application Analyst

Responsibilities:

• Completed several major upgrade projects including upgrade to 11i from 10.7 NCA (2003) and from 11.5.7 to 11. ).
• Annually assisted in all W-2 related year end payroll processes.
• Worked on several set ups and configurations using System Administrator and Application Developer modules to create menu, functions, validation sets, Descriptive ad Key Flexfields, concurrent programs and sets. Additionally, worked on HR security profiles in conjunction with these modules in setting up menu, functions and oracle custom responsibilities to ensure SOX compliance to full fill segregation of duties requirements.
• Assisted in applying several mandatory payroll patches on annual basis.
• Completed several Atmos acquisitions projects including acquisitions of Mississippi Valley gas and TXU gas.
• Provided extensive functional and technical support to Oracle HR and Payroll application users on a daily basis. This support included running payroll processes, creating elements in need, as well as setting up employees with all elements and viewing the payroll and assignment process run results.
• Supported in setting up, designing, and producing reports on Discoverer as well as using SQL PLUS and Report writer using concurrent processes.
• Additionally, worked on modification of seeded forms and several FAST FORMULA to fulfill company’s specific needs.
• With heavy use of HTP packages with PL/SQL and java scripts, Designed and built web-enabled in-house Employee Self Service (ESS) for annual benefit enrollments, E-time for times entries, and gave access to custom pay slip information which enabled company to stop handing hard copy deposit slips.
• Designed and developed Saving Bond employee balance, employee enrollment statement as well as enrollment confirmation statement, employee earning and deduction element statement, and inventory turns calculation (at organization and sub-inventory level) reports using Discoverer 5.0, Developer/2000, Oracle PL/SQL
• Designed and developed several HR/Payroll interfaces such as New Hire interface, payroll savings bond extract, Metlife dental, Superiorvision vision, Metlife voluntary benefits, and BCBS medical, and T Rowe Price on outbound/inbound Employee Stock Option Plan (ESOP), Ceridian FSA, and others as needed.
• Worked extensively with users to help them solve encountered problems due to lack of new patches, incomplete data entry and technical programming errors.
• Modified several Unix Shell Scripts for several existing problems to be solved.
• Worked on Payroll bank reconciliation project to reconcile the data with Oracle Cash Managements system.
• Designed, developed, and implemented New Employee Hire, Rehire, and Termination and Employee Salary Changes E-mail notification using Oracle Alerts in Oracle Human Resources Applications.

Confidential, Irving, Texas

Application Developer

Responsibilities:

• Developed user required HR/Payroll related reports and interfaces using Developer/2000, Oracle PL/SQL, Flexfields, custom value sets and fast formula, and install and implement reports and interfaces on HR/Payroll application using Concurrent Manager.
• Specific projects included: Cigna interface, automated employment offer letter, Pay Mix time entry processes, Company/cost center validation, development of cost center attributes on organization screen, GL related summary reports and interfaces, and modification of several existing reports and interfaces to improve execution time significantly.
• Troubleshoot and maintained the Oracle HR/Payroll application in order to allow the application’s procedures, Triggers, Fast Formula and related reports to work more efficiently.