SUMMARY

• Over 6 years IT experience with 5 years of Oracle HRMS Applications implementation Experience in Oracle 11i/R12 HRMS & Financial applications on Oracle 10G/9i database, PL/SQL, SQL*Loader, Physical database design, Data Modeling, Data flows, Gap Analysis, RICEW Components, Data Conversions, Inbound/Outbound Interfaces, Workflows, AME Approvals, Fast Formulas, ADP interfaces AIM Methodology, Custom Library Development, Application & Production Support, Performance Tuning & Optimization, Security Administration, User & Security Management
• Implemented OAB Module with Benefits Programs, Life Event Processing and Plan Enrollments Conversions using Current and Historic Life Events processes. Configured Benefits Batch Participation Process, Certification and Eligibility Requirements.
• Conducted CRP, Configuration and Setup, Functional Mapping, UAT and training workshops on Oracle HRMS Applications.
• Strong knowledge and experience with Oracle HRMS functionality such as Creating Security profile, Responsibility, registering concurrent programs, executables, form functions, defining users, administer responsibilities, adding custom reports/processes to request groups and several other related tasks. Configuring Jobs, KFF, DFF, Organization, Hierarchy, Grades, Locations, SIT, People Group, Absence, Appraisal, Fast Formulae, Web - ADI, OA-Framework, Form Personalization, and User hooks etc.
• Implemented Workflow Notifications and Supervisor Approvals for Self Service HR processes using Workflow and AME applications.
• Experience in developing interfaces for ADP payrolls in providing extracts for Benefit enrollments, Payroll Elements and Assignment Salaries.
• Experienced with Employee Self Service, Manager Self Service and Self Service Benefits enrollments processes. Well-versed in Business Flows and AIM Documentation Methodologies.
• Customized Forms and Reports 6i and 10g. Also, Created Custom Reports using XML Publisher and Oracle Discoverer. Strong experience with conversion using oracle API’s, and PL/SQL Programs.
• Experience in Creating test scripts, scenarios and conducted Integration testing and User Acceptance Testing scripts and business processes
• Strong experience with conversion using oracle API’s, and PL/SQL Programs. Developed several FAST FORMULAS for Payroll and Benefits elements. Extracted data from oracle into various flat files using utl file functionality.
• Designed and Developed Oracle HR, Payroll and Advanced Benefits Data Conversions, Costing and Payroll Interfaces, Benefits Extracts, Inbound and Outbound Interface programs from database to 3rd party providers. Facilitated conversions from legacy systems into Oracle applications-employee transaction data and master data.
• Developed several FAST FORMULAS for payroll and benefits elements and Prepared technical documentation and GAP Requirements Documents
• Good Knowledge on Date Track Mode concepts. Strong skill set in HRMS API’s and TCA Architecture. Wrote conversions, Interfaces and Bespoke Module design documents such as CV060, CV040, CV050, MD050, MD070 and TE020s.
• Expertise with Oracle Products including Oracle Reports, Oracle Forms, Oracle Discoverer, Forms Personalization, XML Publisher, BI Publisher, Sql* Loader, Unix Shell Scripting, Oracle Pl/Sql, Sql *Plus,Oracle Work Flows.
• Expert programming skills in using Oracle application design/developer tools like Toad, SQL * Loader, SQL Plus, Data Loader, Forms 6i, Reports 6i.
• Excellent work ethics, fast and enthusiastic learner.
• Strong communication, analytical and logical skills.

TECHNICAL SKILLS

Oracle Apps 11i, R12: HRMS, OAB, OTL, SSHR, Workflows, AME Approval Management Engine, Performance Management, Learning Management, iRecruitment

Oracle Technical: API’s, SQL,PL/SQL Programs, Fast formulas, Data Conversions, Forms, Reports, Interfaces, Extracts, Inbound and Outbound Programs, Workflow Customizations and AME Approvals.

Environment: UNIX, Windows 95/98, 2000, NT, Oracle 8.x, Oracle 9i, 10g

Tools: SQL*Plus, SQL*Loader, TOAD, SQL Navigator, SQL Developer, XMLPublisher, Discoverer 9i/10g, Jdeveloper, Developer Suite (Forms 4.5/6i/9i/10g, Reports 4.5/6i/9i/10g, Workflow 2.6, Oracle ADF, Procedure Builder

Methods: Oracle AIM for Documentation and Test Scripts preparation

PROFESSIONAL EXPERIENCE

Confidential - Hunt Valley, MD

Oracle HRMS Techno-Functional Consultant

Responsibilities:

• Worked on the implementation of Oracle HRMS 12i applications HR, iRecruitment, OAB, Payroll, OLM and OTL.
• Gathered the business requirements, conducted design, gap assessment, and process redesign sessions.
• Was involved in setting up OTL self service process by defining Approval rules, Hours types, Time entry rules, Approval styles and Setting up the Preferences.
• Worked on approving and transferring timecards from OTL Self Service to BEE.
• Developing technical specification and performing actual conversions from legacy system to Oracle applications.
• Involved in setting up Payroll earning elements, deduction elements, payroll processing and payment methods (Check writer and Deposit Advice).
• Developed MD.050, MD.070, MD.120 and BR.100 Documents.
• Designed and developed various inbound interfaces (person import, Email import, Absence import Encryption SSN and IRC autohire import) and outbound interfaces (TROWE extract 401k, EMEA payroll extract and Ultra link Census Extract).
• Was responsible in defining Advanced Benefits, Eligibility Factors, Eligibility Profiles, Programs, Plan types, Plans and Options, Enrollment Requirements, Flex credits, Benefit Pools, and Standard Rate Calculation.
• Was involved in setting up iRecruitment module - Recruiting Sites, Applicant Assignment Statuses, External Assignment Statuses, Creating Vacancies, Vacancy Approvals, Vacancy Security, Job Seekers, Site Visitors, Registered Users, Job Search, Job Baskets, Candidate Processing, offer and Hire.
• Was involved in Setting up US Regulatory plans like Imputed Income and COBRA.
• Was involved in working HR core entities like Person, Assignment, Organization, Address, Phone and Contact.
• Created and maintained client’s custom PL/SQL reports for the HR/Payroll/Tax business areas based on specific business needs.
• Created the inbound and Outbound Interfaces for Oracle HR and Payroll.
• Involved in setting up Key Flex fields, Descriptive Flex fields, Special information types, extra information types.
• Involved in System administrator related tasks- Creating Users, Responsibilities, Menus and Function Security.
• Was involved in setting Salary Administration setup and absence management.
• Worked on Catalogue security and managing enrollments in oracle Learning Management.
• Integrated Oracle HR with ADP for payroll processing and designed and developed the interface between the systems.
• Integration with third party ADP to run the payroll
• Used HRMS APIs (HR Location API, HR Location Extra Info API etc) to populate HRMS tables.
• Developed a generic program to Load values into Extra Information Tables.
• Involved in the development of WEBADI (WEB Application desktop interface) support for different HRMS entities. WEBADI provides a functionality, which enables the user to migrate his data from legacy systems. It provides spreadsheet support for all the entities. User can upload, download data from /into a spreadsheet.
• Created a interface to load pension YTD values into SIT entry value for each year for each employee and ex-employee record.
• Modified the seeded HR OFFER workflow process as per the their needs
• Created Interfaces for the Mass Benefit Changes using the Oracle APIs, which is going to change the employee from one benefit, plan to another benefit plan in a Mass Level.
• Created Alerts to send when an employee is hired, terminated, etc. Alerts are sent to individual emails, distribution lists.
• Customization of forms using form personalization for phones form, find search form, people finder form, dependents form, Manage contracts form and people folder form.
• Designed and developed reports in HR, Payroll, Advanced Benefits and Time and Labor using Oracle Reports Builder 6i, Oracle Discoverer and Oracle BI (XML) Publisher.
• Developed PL/SQL packages to resolve multifaceted business validations transformation at the staging database using Oracle HRMS APIs and Public APIs to upload legacy data.
• Developed HR Payroll and OAB reports like New Hire Compliance, Payroll Audit, Personnel Changes report, Local Tax Audit, Benefits Enrollment Confirmation, 401k/RRSP using oracle reports 10g.
• Developed Payroll Interface ADP check and label printing Interface for Canadian Business Group.
• Developed technical specification for inbound and outbound interfaces between Oracle and ADP Payroll and between Oracle and KRONOS.
• Developed code for loading contacts and contact relationships into oracle HR from flat files using sql*Loader and API’s.
• Created Tax filing and FundDirect Interfaces using PL/SQL and utl file functions for third party payroll providers.
• Modifying/Creating the technical design (MD.070)/functional design (MD.050) documents based on the business team’s requirement changes/inputs.
• Performed translations/validations on the data in the legacy tables to prepare for loading into oracle applications using oracle provided API’s
• Worked on extracting life events and benefits of employee information from Oracle Applications base tables to Intermediate tables for Outbound interfaces
• Involved in data mapping of legacy data to Oracle Applications. Wrote Open Interfaces for the Data Conversion and data validation using PL/SQL. Created temp tables in Oracle to load the data and wrote control file for the transfer of the data through Sql*Loader.
• Documented all processes and created step-by-step training guides, trained end users and resolved outstanding production phase issues.

Environment: Oracle Application R12, Human Resources, Payroll, OTL, Self Service, Discoverer, Developer 2000 (Forms 6i and Reports 6i), UNIX, and Sql*Loader

Confidential, New York, NY

Oracle HRMS Techno-Functional Consultant

Responsibilities:

• Involved in setting up and implementation of E-Business Suite Applications HRMS 11i - HR, Payroll, CWB, SSHR, OAB and OTL.
• Was involved in setting up Paid Time off (PTO) Accruals in absence Management.
• Was involved in customization of Checks and Deposit Advices as per the business requirement.
• Was involved in setting up bonus Compensation Plan (CWB) by defining distribution budget, eligible salary and worksheet details.
• Wrote functional specifications (MD050, CV040) and technical specifications (MD070. CV060) using Oracle's Application Implementation Methodology (AIM).
• Was involved in setting up OTLR by defining Holiday Calendar, Shifts, Work plans, Rotation plans, Element Time Information, Shift Differential Policy, Hours Deduction Policy, Premium Eligibility Policy, Earnings Policy, Assignment Time Information, Automatic Timecard Generation, Transfer to BEE.
• Was responsible in defining recurring periods, Alternate names, Flex field Mapping, element sets, Approval periods, Approval rules, Preferences, Eligibility criteria, Timecard Layouts, Time Entry rules and transferring timecards from OTL self service to BEE.
• Developed inbound and outbound Payroll interfaces which include employee Garnishments and payee details to Accounts Payables, employee time entry details from legacy system using BEE & MIX processes.
• Configured Self Service HR Personalized Employee and Manager web pages, Setup additional flex fields to capture client specific information using self service web pages.
• Responsible for running the Participation Process, Creating Life Events, Life event Summary Report, Enrollment Process in OAB (Oracle Advance Benefits)
• Customization of Self Service HR Personalized Employee and Manager web pages, Setup additional flex fields to capture client specific information using self service web pages(Advanced Search page, contacts information page and Personal information page).
• Personalized views panel of search pages, table regions and search result views page using OAF personalization in SSHR module.
• Involved in developing forms and reports for Salary Administration System project.
• Extensively involved in fusion middleware modules - Oracle BPEL.
• Developed various BI Publisher payroll reports like New Hires, Check Sequence, Job/Location specific details, OT Hours & Earnings, Compensation, Earnings and Deductions for specific pay periods.
• Worked on update assignment API for updating the default expense account information based on the Gl code combinations. Default expense account was needed for expensing the amout to cost centers accurately. I wrote a conversion program using update assigmnet API to load the data from GL CODE COMBINATIONS table.
• Worked on enhancements and defect correction of Accounts Receivable standard reports like billing and report history using Oracle Reports 6i and 10g. Business user needed additional fields and calcuations in the existing reports. Developed custom Dunning letters for various collector profiles under Metro business group. Business users needed to send dunning letters to different vendors from various departments in Metro. I worked on creating each customer profile with its own dunning letter format using oracle reports 10g.
• Configured position hierarchy for the Metro Organizational Structure. Metro has a shared HR system and needed position hierarchy for costing and reporting purposes. I worked with the payroll manager to prepare an Org chart for each individual department and loaded the hierarchy into oracle.
• Wrote SQL programs to run weekly extracts for payroll providers, benefits third party providers like AFLAC.
• Developed ADP and Kronos Interfaces with Oracle HR, Payroll and OTL information.

Environment: Oracle Application 11.5.10.2 (Family Pack-K Rup2) GL, AP, AR, PO, Human Resources, Payroll, OTL, CWB, OAB, Self Service HR, Discoverer, Developer 2000 (Forms 6i and Reports 6i), UNIX, and Sql*Loader

Confidential, Upper Saddle River, NJ

Oracle HRMS Techno-Functional Consultant

Responsibilities:

• Worked on implementation setup processes of Oracle E-business HRMS 11i applications -HR, iRecruitment, SSHR, OLM, Payroll, OTL and OAB.
• Configured and Developed SSHR custom components in self appraisal, manager appraisal, performance ratings, and approvals processes.
• Worked on setting up of Work Structures - Location, Organization, Job and Grade in HR.
• Involved in setup and implementation of Absence management with Accrual Plans to define the Vacation package for the employees and Involved in definition of Absence types, Accrual Plans.
• Extensively involved in setup of System Extract, Flex credit programs and Benefit pools.
• Defined Eligibility profiles, Enrollment Requirements, Plans, Programs and standard rates.
• Worked on Conversions for Employees, Addresses, Phones, Assignments, and Salary using Oracle seeded Application Programming Interfaces.
• Wrote complex PL/SQL database packages and configured concurrent programs for data conversion conversions of non training history, delegate booking information, announcements, category, certification category, courses, finance header and line, learning enrollment detail, learning path, resource bookings and plan details for OLM module.
• Configured and implemented iRecruitment setup steps-system profiles, recruiting sites, Creation of Vacancies, Vacancy approvals, Job Seekers, Site visitors, job Search and candidate processing.
• Worked on Oracle ADP Connection Implementation project to send employee data from Oracle HR to ADP.
• Designed and developed employee date tracked report, new hire report, employee assignment report, organization wise summary report to show regular earnings, over time earnings, sick leave earnings, regular hours worked using Oracle BI (XML) Publisher, PL/SQL, UNIX Shell scripts and Oracle Concurrent Manager.
• Developed programs to support applicant data conversion, online vacancy creation, applicant rejection letter enhancement and identity management for SSHR module.
• Designed and developed employee date tracked report, new hire report, employee assignment report, organization wise summary report to show regular earnings, over time earnings, sick leave earnings, regular hours worked using Oracle API, PL/SQL, UNIX Shell scripts, SQL Loader and Oracle Concurrent Manager for SSHR module.
• Developed Userhooks to in corporate the complex business requirements with in the SSHR module using PL/SQL and Oracle API.
• Migrated setup data, lookups and value sets and DFF's from setup instance to CRP instance using migrator available in Oracle isetup responsibility.
• Wrote conversion programs using API”s for Locations, Organizations, Jobs, Positions, Grades, Employees, Addresses, Phones, Contacts, Contracts, Assignments, Extra Information Types, Salary, Personal Payment Methods, SITs, EITs.
• Developed Interfaces for Payroll Elements and Balances Data Conversions using Batch Element Entry and Balance Load API’s
• Developed OAB Benefits Programs, Life Events and Plan Enrollments Conversions using Current and Historic Life Events processes.
• Implemented Benefits Batch Participation Process, Certification, Eligibility Requirements and Self Service Benefits enrollments processes.
• Involved in Business Intelligence tools like XML reports creation and registration of XML reports like Check Writer (XML) and Deposit Advice (XML).
• Was involved in raising defects, test plan design and test labs in HP quality center.

Environment: Oracle Application R12, Financials, HR, Payroll, OAB, SSHR, Discoverer, Developer 2000 (Forms 6i and Reports 6i), UNIX, and Sql*Loader

Confidential, Jamesburg, NJ

Oracle HRMS Techno-Functional Consultant

Responsibilities:

• Acted as techno-functioal mentor for Oracle E-Business Suite HRMS 11i (HR, OTL, OAB, Payroll, CWB) implementation and assisted Team Leaders, Architects, Systems Engineers and Project Manager for development high quality extensions, reports, interfaces, conversion programs and OAF in Oracle HRMS, Opportunity Management, Estimate to Quote, Forecast to Plan, Procure to Pay, Schedule to Build, Inventory Management, Dispatch to Ship, Invoice to Cash, Period Close and OTL business process.
• Was involved in working HR core entities like Person, Assignment, Organization, Address, Phone and Contact.
• Converted functional specifications (MD050, CV040) into technical specifications (MD070. CV060) using Oracle's Application Implementation Methodology (AIM).
• Using OAB API’S developed custom interfaces for OAB Benefits Programs, Life Event Processing and Plan Enrollments Conversions using Current and Historic Life Events processes.
• Involved in defining Elements, Element sets, Assignment sets, Consolidation set, Element links.
• Worked on Transferring Timecards to BEE.
• Implemented Benefits Batch Participation Process, Certification and Eligibility Requirements.
• Developed custom reports and registered these reports in Oracle Applications using Concurrent Manager, defining Executables, Concurrent Programs, and defining Value Sets. Some of the reports listed are - List of Applicants Reports, Employee Annual Salary Reports, Employee Hire and Termination Reports.
• Created Unix Program to autopopulate Retired Benefits data from third Party Vendors into Oracle Pay User Tables.
• Prepared MD050 Functional design and MD070 Technical Design documents for the Functional Gaps in the product.
• Computed paid hours and wages per each work location through PL/SQL package.
• Prepared data mapping document of legacy payroll system to Oracle Payroll system for conversion of Payroll Elements and Balances.
• Developed Oracle Alerts to notify the managers when the database event occurs and to notify employees to make their elections after New Hire and Rehire and provided certificates for all the plans suspended because of certification requirement.
• Developed back feed Payroll Interface that compares the third party data file with Oracle Payroll information and sorts out the differences to keep both systems in sync
• Responsible for developing HMO Remittance Extract Interface. This Interface runs every month and extracts the participation information of all the employees enrolled in HMO plans. This interface also handles RETRO changes.
• Developed CIGNA outbound interface (Benefits) and Watson Wyatt Employee Health Elections interface to generate the participants and dependents information to a flat file to feed to legacy systems.

Environment: Oracle Application 11.5.10 (Family Pack-K) Human Resources, OTL, Payroll and OAB, Oracle RDBMS, Discoverer, Developer 2000 (Forms 6i and Reports 6i), UNIX, and Sql*Loader.

Confidential, Dublin, OH

Oracle Developer

Responsibilities:

• Wrote PL/SQL procedures to obtain the data from the Oracle Application Tables and validated them with the business requirements of the clients. This data was being used for business continuity purposes, and involved the data extraction from Oracle Legacy, creation of flat file in Excel, conversion of the data and use of Sql*Loader to load data onto the Oracle Application
• Developed Packages to validate raw data from Flat Files and insert into tables.
• Used Public APIs & Order HRMS APIs to upload/update the Legacy system data
• Performed Unit Testing on Forms and Reports and PL/SQL Stored Procedures, Functions, Triggers and Packages.