We provide IT Staff Augmentation Services!

Sr Oracle Developer Resume

Cleveland, OH

Summary

  • Having 12 Years’ experience in the area of HCM domain as Technical, Functional and Operational experience in Oracle Applications on versions 11i & 12i, specializing in HRMS, Oracle Advanced Benefits, Compensation Work Bench, Payroll, Self-service HR, Oracle Learning Management, Performance Management, Oracle Succession Planning, Absence Management and OTL modules.
  • Strong management, organizational and communication skills displayed during communication with clients, project stakeholders, key users, technical team and project status/review meetings.
  • Experience in System Analysis, Requirement Study, and Project plan Definition, Specification Generation, Test Plan Preparation, Unit Testing, System Integration Testing, CRP and User Training.
  • Extensive experience in setup/enchantments in running OPEN Enrollments, Performance Management, Compensation workbench process and troubleshooting production issues.
  • Well conversant with Application Implementation Methodology (AIM). Worked on end to end implementations involving Business Process Analysis, Solution Design, Gap Analysis, Security Design, User Training and Documentation.
  • Experience in release/version upgrade (11i to 12 and 12.1.2 to 12.1.3), latest mandatory patches, documentation, testing, user acceptance and production migration.
  • Extensively worked on API’s, Alerts, and WRICE, Workflow, XML Publisher Reports, SQL Loader Utility scripts, JAVA and PL/SQL in writing stored procedures, functions, Reports, Fast Formulas, Web-ADI and packages to validate the inbound and outbound data between the Oracle Applications and third party systems and UNIX shell scripting.
  • Extensive experience in EXCEL & VBA Scripting, used for Oracle data validation.
  • Experience of end-to-end HRMS implementations and post-production support and SOX compliance.

Skills

ERP

Applications (12.1.3, 12.1.2, 11.5.10.2,11.5.10)

E-Business suite Modules

HR, OAB, OTL,PAYROLL, OLM, OPM, CWB, OSP, SSHR, SYSADMIN

RDBMS

Oracle v 11g, 10g, 9i, 8i

Operating Systems

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

Languages

SQL, PL/SQL, C, C++, Java

Tools & Utilities

Forms 6i/9i, Reports 6i/2.5, EiS, SQL*Loader, Jdeveloper, Oracle Workflow Builder, TOAD and SQL*Plus, XML Publisher, MS Visio and MS Excel.

Hardware

HP 9000, Intel Pentium based PC’s

Documentation

AIM Documentation (BR100, BR030, MD50, MD70,DO070, DO060, MD120,CV60,CV40,TE40)

Professional Experience

Confidential

Sr Techno Functional Consultant Oracle

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.
  • Setup annual open enrollment for benefits election, conducting mock open enrollments, user testing and production migration.
  • Personalized OAB Self-Service pages with custom tips which gives explanation of plans offered to employees.
  • Setup Manager and Employee Self Service for core HR.
  • Setup Global Compensation workbench for Merit, Lump sum and Bonus for US, CA, MX, UK, China and Germany business groups.
  • Documented the setup specification using AIM - BR0100 as setup document for deliverable.
  • Setup Talent Profile/Succession Planning Webpages where Managers and Employee can access their Self Service functions like Adding/Modifying Qualification, Benefits, and Employee assignments, Salary, Performance and Objectives.
  • Defined Organizations, Locations, Jobs, Payrolls, and Salary Basis etc to setup Global HR. Implemented HR for US, MX, CA, Germany, UK, Swiss and China countries.
  • Defined Global deployment setups to transfer employees from one country to another country for part time or full time.
  • Setup Approval rules using AME rules for MSS, CWB and OPM Self-service transactions.
  • Enabled matrix manager approvals systems for Performance management.
  • Setup up rating scales, Objective templates, Questionnaire and Appraisal templates for performance management system.
  • Setup objective process, approvals and performance tracking.
  • Setup alerts that run weekly before the objectives/Appraisals deadlines and sent to respective managers.
  • Personalized Self-service Appraisal web pages as per client requirements.
  • Setup Performance management for yearly appraisals.
  • Developed custom BI reports for managers to print objectives, performance tracking and appraisals reports thru self-service.
  • Developed custom concurrent programs to include employees into appraisals who are missed/error due to manager termination or during seeded appraisal concurrent process.
  • Define the competencies(qualifications, knowledge, and experience) your enterprise requires from its
  • current staff and future applicants.
  • Designed catalog to accommodate the needs of organizations and individuals.
  • Worked on Catalogue security and managing enrollments in oracle Learning Management.
  • Integrated Learning management with third party vendor Skill port.
  • Personalized Learning management pages as per the client requirements.
  • Designed documents for Conversion and benefit enrolment for Nichols Company acquisition, attended business user meetings, handled team at offshore to meet the deadlines and conducted CRP testing with end users.
  • Designed setup and migration documents for workforce who enrolled benefit plans to new offered plans.
  • Provided a solution to allow users to enter Cost Allocation Key flex fields thru self-service to synchronize with finance modules for GL, and taken care of effected regular ongoing interface and reports, documented the change for future enhancements.
  • Workflow administration and trouble shooting of approvals.
  • Defined various security profiles based on business requirements.
  • Writing Business requirements for offshore teams and validating the work deliverables.
  • Customized Webpages using Oracle JDeveloper.
  • Wrote fast formulae for performance, compensation and benefits
  • TAR Creation and follow-ups using Metalink.

Environment: Windows, Oracle 11g, Oracle Applications 12.1.2, 12.1.3, XML Publisher, SOAP, EiS, JDeveloper, XML Gateway, TOAD, E-Business.

Confidential

Sr Techno Functional Consultant –Oracle HRMS

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

Sr Functional Consultant –Oracle HRMS

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.
  • Setup ICD Plans for 401(k) contribution so that, employee can contribute money directly thru self-service.
  • 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.
  • Successfully completed OPEN Enrollment first time with 87% of employee participation.

Confidential

Sr Techno Functional Consultant –Oracle HRMS

Responsibilities:

  • Primary responsibilities include identifying the requirement of reports needed for business users and finding issues in existing reports.
  • Developed Discoverer Reports for OTL, Payroll and OAB.
  • Supported the business users in their testing and ensured all the issues are resolved in a timely manner.

Confidential

Sr Technical Consultant- Oracle HRMS

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: Sun OS (8.0), Oracle 9i AS, 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

Sr Oracle Developer

Responsibilities:

  • Wrote SQL scripts to populate EIT Tables.
  • Wrote Shell Scripts to load the legacy data into staging tables using SQL*Loader.
  • Forms customization using custom.dll
  • Created Custom reports as per the requirements
  • Adhoc Reporting as per client's requirement.
  • Analysis and Bug Fixing of Incident Reports by Client.
  • Prepare Daily Monitoring report for nightly batch jobs.
  • Worked as a Defect Prevention Representative.

Environment: AIX – UNIX (4.0), Oracle 8i/9i, Oracle Applications 11.5.7, TOAD 7.0, VSS, SQL*Loader, Clear case, Forms 6i, Reports 6i and Citrix

Confidential

Sr Oracle Developer

Responsibilities:

  • 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: AIX – UNIX (4.0), Oracle 8i/9i, Oracle Applications 11.5.7, TOAD 7.0, VSS, SQL*Loader, Clear case, Forms 6i, Reports 6i and Citrix

Confidential

Sr Oracle Developer

Responsibilities:

  • Requirement Analysis.
  • Maintaining the Muster by open List Reports.
  • Back-End programming in oracle (creating functions and procedures, Packages, Triggers and views).
  • I also have an exposure to DBA activities like Back Up and Recovery.
  • PL/SQL programming and tuning
  • Changes, Bug fixing and problem analysis.
  • Designing User interface Units in Forms and Reports.
  • Attending Team and Client meetings to discuss functional issues
  • Designing, developing & maintaining the in house MLM Database.
  • Implementing Business Logics in PL/SQL and Matrix Binary, royalty and other Commission calculations
  • Creating of custom views for reports & statistical data.
  • Product income plan design

Environment: Windows 95, Oracle 7.3, Pl/Sql, Forms 4.5, and Reports 2.5

Hire Now