SUMMARY

• Over 8 years of Technical expertise with Oracle HRMS/HCM E - Business Suite (11i and R12).
• Extensive experience in HCM full life cycle implementations/upgrades with Oracle HCM suite, including HR, Payroll, OAB, OTL
• Expertise in Oracle Application EBS Customization, Enhancements, Reports, Interfaces (RICE) and upgrading projects that includes Application Software Development, Mapping, Data Cleansing, Testing, Documentation, Production Deployment and Production Maintenance/Support.
• Conversant with Oracle’s AIM (Application Implementation Methodology) while executing projects.
• Thorough knowledge in e-Business Suite, Oracle Apps Architecture, Directory Structure, Schema structure in Oracle Apps, Multi-Org, Menus and Functions, Key Flex field, Descriptive Flex field, Profiles, Value Sets, Concurrent Processing, Inbound Interface, Outbound Interface and FND CONCURRENT package.
• Experience in data conversion, interfaces and migration using ORACLE API’s.
• Experience in Oracle Application Frameworks (OAF) customization and personalization.
• Extensive experience in creating reports using Oracle Developer 6i, XML (BI) Publisher.
• Hands on experience with PL/SQL, Stored Procedures, Packages, Triggers, Functions, SQL Loader, External Tables, Utl File, Objects Types, Collections, Bulk Collect, Cursors, Ref cursors, Table functions and Dynamic SQL on Oracle (9i - 11g).
• Experience with Logging and Monitoring Service Requests through Oracle Metalink.
• Have excellent communication skills with a proven ability to interact with end users, developers and project management.
• Experienced in leading technical teams (Onsite, Offshore) in Oracle Development and in Implementation projects.
• Experienced in requirements gathering, gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users and production support.

TECHNICAL SKILLS

Oracle Applications: R12, 11i (E-Business Suite)Oracle Payroll (PAY), Human Resources (HR), Core HR, Oracle Time and Labor(OTL), Oracle Advanced Benefits(OAB), Applications Object Library (AOL)RDBMS:Oracle Database 9i - 11g

Development Tools: XML Publisher (BI Publisher) 5.6.3/5.6.2 , Oracle Forms & Reports 10g/6i, SQL * Plus, TOAD, PLSQL Developer and SQL Loader, Oracle Applications Framework(OAF)

Programming Languages: SQL, PL/SQL, XML and UNIX Shell Scripting

Operating Systems: UNIX, WINDOWS

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

HR/payroll/OAB Technical Consultant

Responsibilities:

• Gathered requirements for OAB plan changes
• Gathered EDI 834 Benefits outbound Interface requirements for various benefits of CIGNA
• Prepared MD-050 and MD-070 for both functional and technical components.
• Developed inbound interface to load SIT data from ADP payroll system.
• Developed CIGNA OAB Open Enrollment Interfaces and verified the interfaces with CIGNA.
• Developed CIGNA OAB Full file EDI 834 Interface to send Retro/Current/Future enrollments for Employee and dependents.
• Developed the SFTP process to deliver the OAB interfaces securely to CIGNA.
• Fixed the issues with existing Dental, Cobra and FSA Interfaces.
• Developed OTL Timecard details report (BI Publisher) to show the timecard details of the employee for given time period.
• Developed Timecard Element Details reconciliation report to show time transferred from OTL to Payroll for the employee.
• Prepared test scripts and technical design documents for all development components.
• Supporting HCM (HR and OAB) day-to-day technical issues.

Environment: Oracle Applications R12.1.3, SQL Plus, PL/SQL Developer 9i and 10g, XML/BI Publisher, SQL Loader.

Confidential, Houston, TX

HCM/Payroll/OTL Techno-Functional Consultant

Responsibilities:

• Meeting with business users and Gathering the requirements for Argentina payroll (Union and Non-Union) and OTL implementation.
• Meeting with business users and Gathering the requirements for International and Retiree Benefits implementation and plan changes for US and Canada Business groups.
• Prepared the high-level process flow diagram for payroll and OAB implementation.
• Prepared the detailed scope of work document for payroll and OAB implementation.
• Created BR 100 for all HR, OAB, and Payroll setups in HCM system.
• Created Nabors AN-100(MD70) for all functional requirements for Argentina payroll implementation and New OAB setups.
• Meeting with ADP team to get interface requirements (OTL and HR data to ADP system).
• Developed outbound interface program to transfer time from OTL to ADP payroll system for Argentina Employees time.
• Configured all HCM Setups (Location, GRE, Payroll, Elements, Lookups, etc...) required for Argentina Payroll implementation.
• Developed CITI bank outbound interface for UAE.
• Modified the existing Merrill Lynch inbound and outbound 401K interfaces based on new requirements.
• Developed Payroll Details XML Report for international business group.
• Creating New OAB Plans for International Benefits.
• Developed OAB conversion programs (Programs, Plans, Employee and Dependent Enrollments ...) for International Benefits.
• Implementing Retiree Benefits for OAB.
• Opening up self-service pages for all Life Events.
• Developed Benefits FSA interface for vendor Confidential .
• Developed outbound “employee and dependents information” extract to Kaiser/Spectera carrier.
• Modified existing PTO fast formulas based on client requirements.
• Supporting various HCM (HR, OTL, Payroll and OAB) functional and technical issues for US/CANDA/MEXICO and international business groups.
• Provide status report to PMO team on daily basis for project tracking.

Environment: Oracle Applications R12.1.3, SQL Plus, PL/SQL Developer 9i and 10g, XML/BI Publisher, SQL Loader.

Confidential, Houston, TX

HR/Payroll/OAB Technical Consultant

Responsibilities:

• Involved in Data Conversions from the legacy systems using the Oracle API’s. Conversions involved Payroll Balance Load and Benefit Enrollments.
• Responsible for resolving issues of their Day-to-Day HR/Payroll and OAB modules and provided support for the smooth running of the payrolls. Monitor the payroll activity.
• Leading HCM Conversions Effort. Conversions include complete history for Employees and Contingent Workers for Multiple Business groups.
• Created functional and technical mapping documents for all HR and Payroll (locations, organizations, person, assignment, address, elements... etc.) conversions.
• Configured new PTO Accrual Plans for Vacation and Sick Plans and developed the new accrual fast formulas based on business requirements.
• Developed COBRA Status and Payment reports as per client requirements.
• Developed Fidelity inbound interface to automate 401K plan rate changes.
• Created an Outbound interface to send an ASCII output file to Huntington trust regarding pre-tax Employee and Employer contribution amounts (401K, 401K ER, 401K Catch up, Loan 401K deduction etc.) per assignment run dimension and SQL*Plus report to create text file
• Created MD.070, MD.120 and TE.020 for all the interfaces developed.
• Customized all reduce regular sick and vacation element fast formulas to avoid negative pay.
• Successfully resolved various TARs opened with Oracle support.
• Responsible for reconciling various payrolls reports and compare/analyze the balances to fix the issues related to.

Environment: Oracle Applications R12.1.3, SQL Plus, PL/SQL Developer 9i and 10g, XML/BI Publisher, SQL Loader.

Confidential

HR/Payroll Technical Consultant

Responsibilities:

• Involved in Data Conversions from the legacy systems using the Oracle API’s. Conversions involved Payroll elements and core HR data.
• Created technical mapping documents for all HR and Payroll (locations, organizations, person, assignment, address, elements... etc.) conversions.
• Created MD-50 document for all HR and Payroll reports.
• Developed payroll and HR reports using XML Publisher (Earnings and Deductions, Acting Allowance, Standby allowance, Increase and Promotions, Rent Report etc).
• Used XDO XSL attributes to develop reports using XML Publisher.
• Used PL/SQL to develop queries for the data to be generated in the report.
• Registration of AOL Objects.
• Customizing the output format of the Reports.
• Prepared and delivered unit test script document for all possible validation scenarios.
• Resolution of tickets during support activity.

Environment: Oracle Applications R12.1.3, SQL Plus, PL/SQL Developer 9i and 10g, XML/BI Publisher, SQL Loader.

Confidential

HR/OTL/AP/AR Technical Consultant

Responsibilities:

• Upgrading from 11i to R12 and developed custom OAF web based front end pages.
• Created a technical document for mapping the fields in OAF web-based pages.
• Developed web based front end pages for OTL module using OAF (Oracle Application Frameworks).
• OAF pages - Missing Timecards, My timecard Reports, Total, Subordinate Report, Portfolio management Reports etc.
• Defining the function for the developed OAF web-based pages.
• Registering the function to a menu and including the menu in the responsibility to open the OAF pages.
• Upgrading the custom application object - concurrent programs.
• Upgrading the Custom Database object - Views.
• Upgrading the reports and Messages.
• Preparing ldt Files for Porting Concurrent Programs, Executable, Value set, Request Groups using FNDLOAD.
• Regression Testing.
• Moved all code and documents into code repository (MKS) and created PPM to move all code changes successfully into other testing and Production instances.
• Resolution of tickets during support activities.

Environment: Oracle Applications 11i (11.5.8), R12, SQL Plus, PL/SQL Developer 9i and 10g, Oracle Applications Framework, SQL Loader.

Confidential

SCM Technical Consultant

Responsibilities:

• Involved in Conversions from the legacy systems with order management Suite.
• Created CV-50 conversion document.
• Loaded the vendor’s information from legacy system to oracle Purchasing.
• Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.
• Developed Requisition conversion.
• Customized forms using custom.pll to change the functionally of the standard forms.
• Customized Sales Order form to add customer fax, email and phone number contacts.
• Worked on Form Personalization in Order Management.
• Registered the Concurrent Programs, Forms, Reports and Requests Sets in AOL and System Administration.
• Review source code of other objects
• Registration of AOL Objects.
• Preparing ldt Files for Porting Concurrent Programs, Executable, Value set, Request Groups using FNDLOAD.
• Regression Testing.
• Moved all code and documents into code repository (MKS) and created PPM to move all code changes successfully into other testing and Production instances.
• Resolution of tickets during support activities.

Environment: Oracle Applications 11.5.10, Toad, SQL Plus, PL/SQL Developer 9i and 10g, SQL Loader, Oracle Forms Builder 6i.