SUMMARY:

• Having 8 plus years of diversified Techno Functional expertise in Oracle Applications R12/11i, with extensive exposure in for Design, Configuration, Implementations, Production Support and Upgrades in Oracle HRMS .
• Proficient in all phases of Oracle Applications R12/11i implementation with major focus in Human Resource Management System (HRMS) of Oracle Applications including Oracle Human Resources (HR), Oracle Payroll, Self Service Human Resource (SSHR), Oracle Time and Labor(OTL).
• Oracle Learning Management (OLM), Oracle Advance Benefits (OAB)Oracle Performance Management(OPM), I - rec.
• Well experienced in design of Reports, Interfaces, Conversions and Extensions (RICE), Implementation and Support of various Oracle Apps modules. Involved in implementing versions/upgrades of Oracle Applications 11i, and recently involved in implementing Oracle Applications R12 for Oracle Business.
• Prepared the Designs for Gaps, Functional Specification documents, Test scripts, Data conversion documents, Report requirement, Configuration documents and SysAdmin setups documents.
• Worked on Documentation using AIM methodology for Business Requirements Setups (BR100), Functional Design Documents (MD50), Conversion Mappings (CV40) and Conversion Test Plans (CV70).
• Experience in designing and developing project plans for complete SDLC from gap analysis to post production support. Experience in preparing Test Plan, Unit Testing, System Integration Testing and Documentation. Provided support all through SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Designed Custom Reports, Forms, Workflow Customizations, Forms Personalization and all other RICE objects to meet customer requirements in Fresh Implementation and Production Support projects of Oracle Applications.
• Proficiency in understanding client’s needs and generate, modify existing data in Oracle Applications according to the requirements and specifications.
• Good Communication, Co-ordination and team skills. Well organized with excellent leadership skills and commitment to deliver on schedule.
• Experience in creating, managing and resolving TAR/SR (Technical Assistant Request or Service Request) with Oracle Support. Managed and monitored TAR’s for several P1 issues.
• Experience in Application System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Worked with Offshore Technical team on Development, Testing and Migration of Objects.
• Experienced in on-call 24/7 Application support in Production Environment and working with business users to implement or enhance the solutions into ERP system.
• Hands on experience in troubleshooting issues and resolving tickets on priority.
• Provided technical and functional support with day-to-day management of incident, problem, knowledge and change management for assigned applications and technologies.
• Experience in monitoring the system and track the issues, fix and escalate them as per the client policies.

TECHNICAL SKILLS:

ERP: Applications 11i, R12(11.5.10.2,11.5.10, 11.5.9, 11.0.5, (12.1.3) )

EBusiness suite Modules: HRMS, PAYROLL, Self Service, OAB,OTL,OLM,SSHR, I-rec, OPM, OLM SYSADMIN

RDBMS: Oracle v 10g, 9i, 8i

Operating Systems: LINUX, Sun-Solaris, Unix, Windows 9X/2K/XP

Languages: SQL, PL/SQL, C, C++, Java

Tools: Forms 6i/9i, Reports 6i/2.5, SQL*Loader, Jdeveloper, Oracle Workflow Builder, TOAD and SQL*Plus, XML Publisher, MS Visio, Data Loader, OIT 8.3.7,obiee OBIEE 11.1.1.7.13, 11.1.1.7.15

Hardware: HP 9000, Intel Pentium based PC s

Documentation: AIM Documentation (MD50, MD70, MD120,CV60,CV40)

PROFESSIONAL EXPERIENCE:

Confidential

Oracle HCM Techno Functional Consultant

Responsibilities:

• Experience in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
• Extensively worked on Oracle Advanced Benefits(OAB) Implementation such as extracting medical benefits, Dental Benefits, Vision Benefits, FSA information for different vendors using Outbound Interface Methodology and send files to respective Vendors.
• Complete setup of Core HR which includes Key Flex fields, Descriptive Flex fields, setting up business group, HR Organizations, Locations, Job, Position, Elements, Element Links, Fast Formulas, Value sets, Lookups etc
• Configuration of Benefits, Eligibility and Life Events into OAB system Unit testing of configuration
• Responsible for integrating absence management and developed an interface to create employees timecard with different types of absences
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository (RPD) using Oracle BI Administration Tool.
• Skilled at configuring OBIEE Metadata Objects including repository, interactive dashboards, reports and interactive BI Publisher.
• Experienced in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Creating Dashboards using Analytics requests and assign Permissions to those dashboards to users depending on their user group.
• Experience in configuring and set up of OBIEE Security configuring object level and database level security.
• Experienced in designing customized interactive dashboards in OBIEE using drill down, prompts, filters, and variables.
• Experience in creating executive reports with BI Publisher integrated with OBIEE.
• Created and granted privileges for the users using Analytics Catalog Manager.
• Skilled at configuring OBIEE Metadata Objects including repository, interactive
• Helped users resolve issues during New Hires and Assignment changes.
• Modified OA Framework Pages to display Total Score to Managers.
• Worked on Employee, Address, Phone, Assignment data conversions using HRMS API's.
• Worked on OA Framework personalization to hide Rating levels from Employees.
• Worked on CO Extension for restriction of adding Objectives in Employee Self Service Performance Management.
• Worked on creating Descriptive Flex fields, EIT's and Special Information Types.
• Prepared the code packs to migrate deliverables from one instance to another instance.
• Fixed the errors for multiple reports in several instances.
• Created New Objectives Template to hide inactive Objectives for Employees; New Competencies template to restrict selective competencies.
• Worked on AME (Approval Management Engine) to set up Approval for SSHR Transactions
• Fixed the errors for multiple reports in several instances.
• Developed an OTL report to identify missing time cards and approve them using a custom program.
• Set up New Elements, Element Links, Formula Results.
• Worked on AIM Documentation like MD50, MD70, MD120.
• Created several fast formulas for HRMS Modules.
• Worked on HRMS Reports and Customizations. The users using Analytics Catalog Manager.

Environment: Oracle Application R12.1.3, Oracle (HR, OTL, PAYROLL, OAB,OPM,PLM I-rec, AOL, SYS ADMIN), Oracle Configurator, Oracle Database 9i/10g,OBIEE 11.1.1.7.15, PL/SQL, Toad.

Confidential, New Jersey

Oracle HRMS Techno Functional Consultant

Responsibilities:

• Defining New Users, Creating Responsibilities and assign responsibilities to the Users.
• Defining Request Groups, functions, menus, Assigning Request Group to Users.
• Defining Key Flex fields and value sets.
• Development of new reports (XML/BI and RDF)
• Performed Unit testing.
• Worked extensively, in and out on conversions. Involved in conversion process right from design, pre-conversion/data-cleansing, extract, validate and interface the data from legacy systems into staging tables and then to interface tables.
• Worked on Oracle Alerts, PL/SQL Alerts.
• Worked on the Data migration activities of Core HR/Payroll through conversion scripts (like employee creation, assignment, job, contacts, phones, address, bank details, element entry, pay proposals etc.)
• Worked on the Bank file Transfer interface and also few internal interfaces like Payroll Costing Interfaces, FND user interfaces where the Program is set create the FND User and also attach the Employee Self Service responsibility to the user.
• Worked on custom interfaces critical to business.
• Worked on few Third Party Benefit Interfaces both Outbound and Inbound Interfaces
• Designed various Technical and Functional documents like MD050, MD070 and MD120
• Prepared deployment documents for moving custom developed reports and forms from development instance to production after code testing.
• Involved in all phases of project life cycle such as project planning, requirements gathering, analysis, design, development, implementation, testing and documentation.
• Developed custom discoverer reports those were critical to business as a part of postproduction support and also provided relevant documentation such as MD50, MD70 and MD120.
• Prepared Technical Design Documents based on Standard AIM Templates.
• Worked on CEMLI for PL/SQL Packages, Concurrent programmers, Reports and SQL objects etc.
• Prepared TE50 and TAC documents for the upgraded objects.
• Involved in testing the migrated components.

Environment: Oracle Application R12.1.3, Oracle (HR, OTL, PAYROLL, SSHR, AOL, SYS ADMIN), Oracle Configurator, Oracle Database 9i/10g, PL/SQL, Toad Sales Force.

Confidential, Daytona Beach, FL

Oracle Applications HRMS Techno Functional Consultant

Responsibilities:

• Primary responsibility involves system study, Requirements Gathering, preparing functional specs, Conversion Design, Test script documents, User Manuals and Business Process documents.
• Documented the setup specification using AIM - BR0100 as setup document for deliverable.
• Prepared functional and technical design specification for the Historical conversion Event to transfer the benefit elections from legacy system to OAB using Oracle API's.
• Documented MD050/MD070/CV040/CV070 for application extension / modification / interfaces & conversion.
• Setup Oracle Advance Benefits by establishing Elements for various Benefit Plans, Programs, Program Enrollments, Life events, Eligibility Profiles to restrict eligibility. Simplified the Customizations in OAB and modified the Configurations at different levels to follow Oracle rules and hierarchy of Eligibility and Electability rules.
• Setup Self Service OTL, OTL Timekeeper groups, Alternate names, Rotation plans, earning policies, Holiday calendar, Work plan etc
• Designed Conversion Strategy and Conversion Data Mapping Documents for HR/OAB and OTL modules and wrote conversion programs using API's.
• Benefits Self Service Personalization with communication message text changes and added text on SSHR pages to provide information about the plan which they are about elect and enroll.
• Wrote fast formulas to calculate coverage amounts, enable/disable the options programmatically and validation of options selection like he/she must select same emp/emp+1/family option across all plans (Medical/dental/vision/prescription) provided.
• Employee and Manager Self Service Personalization and user creation.
• Developed fast formulas to calculate coverage amounts, enable/disable the options programmatically and validation of options selection like he/she must select same emp/emp+1/family option across all plans (Medical/dental/vision/prescription) provided.
• Preparing system for Open Enrollments and Conducting mock open enrollments in advance to avoid issues during open enrollments.
• Interacting with Third party benefits providers (IBC, Delta Dental, Vision Benefits of America and CVS Caremark) and prepared functional specifications for the Carrier Extracts.
• Adding new plans/options and ending existing plans, rate changes.
• Assisting end user training performed by key users.
• Created Approval Rules, Conditions, and Approval Groups (AME.B) as per the City's Organization Structure.
• Wrote dynamic attributes for AME.B and modified Workflow Notification to display employee number & employee name using Sql and PL/Sql.
• Created security profiles to avoid departments to access other departments Information.
• Regular status reviews through conducting meetings with client & variance analysis if any through issue & risk log.
• As OTL Functional, responsible for gathering requirements, system configuration, Documenting BR100 and User Training manuals. Configured OTLR and OTL
• Configured different approval routes for exempt and non-exempt employees.
• Worked closely with the users and trained the trainers on using the OTL functionality
• Performed the Workflow Administrator role.

Environment: Windows, Oracle 10g, Oracle Applications 12.1.2, XML Publisher, SOAP, EiS, JDeveloper, XML Gateway, TOAD, E-Business, Forms 6i, Reports 6i, Discoverer 10g

Confidential, Lake Forest, CA

Oracle Applications HRMS Techno functional Consultant

Responsibilities:

• Primary responsibility involves system study, Requirements Gathering, Conversion Design, preparing functional specs, Test script documents, User Manuals and Business Process documents.
• Data conversion, customization and development of inbound and outbound interfaces.
• Loading legacy system data (csv, xml, flat files) into HRMS using SQL*Loader, pl/sql and API's available in HRMS modules
• Registering Forms, Reports, Packages, Web Pages and Unix scripts in AOL
• Customization of SSHR web pages using JDeveloper (OA Framework).
• Customized New Hire V4.0 Workflow process for Contingent worker maintenance.
• Developed custom web pages in OA Framework for Contingent workers self-service for rehire process.
• Developed custom web pages in OA Framework for the Cummins Merit review process.
• Extraction of employee, Payroll and benefits data from HR, PAY and BEN tables using custom views.
• Development and enhancements of the reports for core HR, Payroll, OAB modules using Reports6i and XML Publisher.
• Developed Reports for COBRA.
• Writing utilities using Unix Shell Scripting for FTP, SFTP, Encryption and Decryption
• Wrote PL/SQL Packages, Procedures and Functions Scripts:
• To validate data before loading into Oracle HR Tables.
• To End Date Non-active user Responsibilities.
• Employee Benefits extraction for third party venders like CIGNA, DELTA DENTAL, using utl file utility.
• Extract for Open Enrollment Confirmation.
• For COBRA report requirements like Calculating monthly premiums, rate etc.
• Increase in Employee's pay proposals based on Organization requirements.
• To Extract Oracle HR and Payroll data, which is, required ADP for processing the Payments.
• For backfeed of processed payroll data from the third party payroll provider (ADP) to the Current HRMS application
• For Workflow Function activities
• Transfer and load recruitment and vacancy data into third party vendors
• (webhire.recuriter.com) and HRMS base tables.
• Wrote SQL Scripts:
• To make correction in the data issues like updating, correction and deletion of records.
• To Grant Access to APPS on Custom Objects.
• Loading Data into EIT Tables
• Developed Periodic/Event based alerts as per the Business Requirement.
• Handling Change requests from Clients.
• Analyzing the data issues in Development, Proxy and Production servers.
• Updating the Technical documents as per the functional design documents.
• Creating Unit Test Planning and Test Cases Documents.
• Code debugging, Review, defect sheet updating and checking into Clearcase.
• Prepared functional design specification for the Historical conversion Event to transfer the benefit elections from legacy system to OAB.
• Prepared functional design specification for the Benefit Structure/Eligibility/Rates/Premiums/Others as per the User needs.
• Involved in Design of Life Events, Eligibility, Rates and System Extracts (e.g. Carrier Extracts, AP, Payroll etc.)
• Prepared functional specifications for the Carrier Extracts and designed/configured/tested the Extracts in OAB using System Extracts.
• Developed Functional specifications for various business rule which were implemented in OAB as fast formulas for the requirements which weren't satisfied by in built OAB functionality setups.
• Developed Functional specifications for Various Reports needed by the user.
• Used AIM Methodology for OAB Project Plan documents/deliverables.
• Conducting knowledge-sharing programs on every week among the team members.
• Ongoing production support for HRMS/Payroll/OAB.

Environment: Oracle Applications 11.5.10, Workflow Builder (2.6), J2EE, BC4J, OAF JDeveloper, XML Publisher, TOAD, E-Business, Forms 6i, Reports 6i, Discoverer, VSS, Clearcase and Citrix.

Confidential

Oracle Apps HRMS Technofunctional Consultant

Responsibilities:

• Primary responsibility involves system study, Requirements Gathering, preparing functional specs, Conversion Design, Test script documents, User Manuals and Business Process documents.
• Setup functions, Menus, Responsibilities, and Request groups and performed other System admin responsibilities.
• Setup Oracle Advance Benefits by establishing Elements for various Benefit Plans, Programs, Program Enrollments, Life events, Eligibility Profiles to restrict eligibility. Simplified the Customizations in OAB and modified the Configurations at different levels to follow Oracle rules and hierarchy of Eligibility and Electability rules.
• Prepared testing documents using AIM and Business user training
• Supported the business users in their testing and ensured all the issues are resolved in a timely manner.
• Wrote conversation documents for moving legacy benefit enrollment data to Oracle OAB.
• Conducted CRP's (CRP1 & CRP2) for the client to demonstrate the business process flows.
• Developed SQL scripts to transfer data from the Legacy system into the staging tables.
• Write extensive PL/SQL procedures, functions, packages, cursors.
• Worked on SQL query optimization.

Environment: Oracle Applications 11.5.7, SQL, PL/SQL, Oracle 9i, Developer 6i - (Forms and Reports), TOAD and UNIX.

Confidential

Oracle Applications HRMS Technical Consultant

Responsibilities:

• Developing packages, procedures, functions, and triggers for the application.
• Using UNIX environment for performing the testing.
• Performing the tests on the newly coded procedures and documenting the same.
• Writing technical documents using the functional specifications.
• Writing PL/SQL code using the technical and functional specifications.
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Automated sqlldr using shell scripting.
• Automated data fetch using UNIX shell script.
• Optimized the queries to improve the performance of the application.
• Created Pl/Sql Interface to validate legacy data and loaded into Oracle Staging Tables
• Involved into creating KFF, DFF and required valuesets and inserted required data into the corresponding KFF, DFF Structures as per the functional design documents.
• Using HRMS Tables created database procedures, database triggers, cursors, packaged procedures and program units to enforce the client specifications.
• Created and linked elements to maintain data for Employees for Merit reviews.
• Extraction of employee data from HR tables using custom views.
• Worked in Configuration Management Team.(Source code Maintenance).
• Reviewed, tested and trained customers on the developed system.

Environment: Oracle Applications 11.5.5, TOAD 7.0, VSS, SQL*Loader, Forms 6i, Reports 6i and Citrix.