SUMMARY

• Over 7+ years of experience in Oracle Applications (E - Business Suite) R12/11i on Analysis, Design, Development, Testing, Implementation, Version Upgrades, Interfaces, Data conversions and Customizations Developer/2000, BI-Publisher, PL/SQL..
• Extensive experience in oracle application modules which include Human Resources, Payroll, General ledger (GL), Accounts payable (AP), Purchasing (PO)
• Involved in Technical Design, System Analysis and Solution Development.
• Involved in complete Software Development Life Cycle from Requirement Gathering, Analysis, Development, Testing, Implementation and Oracle Application Extensions.
• Well versed with Oracle Workflow customizations
• Expertise in designing MD50, MD70, BR100 documents for custom extensions, reports, conversions and interfaces in Oracle EBS
• Experience in reviews of requirements, business specifications, business processes and recommends proposed solution.
• Excellent experience in using SQL Loader as part of inbound interfaces
• Expertise in Application Standards like oracle Application implementation methodology.
• Technical (developer.) activities: Interacting with users, identifying functional and technical gaps, designing custom solutions, programming, scheduling, documentations, and providing production support.
• Expertise in implementation, Migration and Support for Oracle based and Oracle Application modules.
• Ability to work hard as an individual and in a team to achieve desired results and ability to work under pressure in coordinating multiple tasks in the work environment.
• Excellent in quick adaptation and problem solving with good communication skills.

TECHNICAL SKILLS

ERP Applications: Oracle Applications R12 (12.1.3/12.0.6 ), 11i (11.5.10.2/11.5.8/11.0.3 ) GL, AP, AR, CM, FA, PO, iProcurement, iSupplier, Sourcing,, OM, INV, Advanced Pricing, Shipping and AOL.

Development Tools: Forms and Reports-6i, BI-Publisher, Workflow-2.5/2.6

Tools: TOAD, SQL Developer

Configuration Tools: SharePoint and Win-CVS, PVCS

Languages: PL/SQL

Operating Systems: Unix (SCO), LINUX, Solaris 9, Windows 98/2003/XP/8.1

Domain Knowledge: HRMS, Payroll, Standard Benefits, Purchasing

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Oracle Apps Functional Consultant

Responsibilities:

• Conducted analysis and requirements gathering.
• Performed HRMS/Payroll setups and Time and Labour setups
• Set up payroll processing cycle including employees with special circumstances
• Defined multiple methods of payment including check and direct deposit
• Set up management self-service for viewing and updating multiple employee status data.
• Set up employee self-service for reviewing job descriptions and applying online.
• Defined time entry and approval rules, elements, mapping, and retrieval processes.
• Defined timecard layouts and preferences, rotation plans, and other structures.
• Set up accrual plans
• Defined processing rules using FastFormula. Develop custom reports using BI-Publisher
• Develop MD50, BR100 documents for custom extensions, reports, conversions and interfaces
• Performed Forms Personalization
• Develop Oracle Alerts, Workflows, Fast Formulas
• Develop Interfaces & Conversion scripts for Advance Benefits Data
• Develop custom package for the Determination of Seniority & Disability Dates
• Develop Test Scripts and performed System Integration Tests and conducted UAT

Environment: - Oracle Applications 11.5.10.2 (HRMS, Payroll, SSHR, GL, AR)

Confidential, Oakbrook, IL

Oracle Techno-functional Consultant HRMS, SSHR

Responsibilities:

• Perform Gap analysis and suggest solutions
• Perform HRMS/Payroll Setups
• Developed test scripts and conducted user acceptance testing.
• Performed the tasks Oracle Application Setups like Created Current Enrollment Life Event Reasons
• Create Conversion Life Event Reasons, Attach Life Events to a program, Attach default codes to plans, Disable/Enable OAB triggers,
• Wrote PL/SQL Packages for benefits conversions using
• Create Potential Life Events, Create Person Life Events, Update Person Life Events
• Create Participant Enrolment Result, Create Eligible Covered Dependents, Create Beneficiary
• Used legislative balance for analysis and user-defined calculations.
• Set up management self-service for viewing and updating multiple employee status data.
• Set up employee self-service for reviewing job descriptions and applying online.
• Set up accrual plans, parameters, amounts, carryovers, and ceilings.
• Tuned scripts and queries for high performance.
• Developed reports using Discoverer 4, Oracle Alerts, Workflows, and FastFormulas.
• Involved in setups and custom packages for Absence Management and maintenance, and PTO accruals.
• Developed scripts for HRMS/Payroll/OTL conversions and interfaces.
• Designed and developed HR customization reports.
• Designed Business Requirements documents (RD050) for interfaces.
• This Interface will summarize all required CIVMAR data (employee, position and ship information) from Oracle and create a three data file that can be imported by SSLA.
• Developed the CV040 & CV060 documents as per AIM standards
• Develop MD70, BR100 documents

Environment: - Oracle Applications 11.5.10.2 (HRMS, Payroll, SSHR, GL, AR)

Confidential, Parsippany, NJ

Oracle Applications 11.5.10.2, Techno - Functional

Responsibilities:

• Maintenance/Development of Custom Interface using PL/SQL, reports
• Develop scripts for conversions & interfaces
• Develop reports using Reports 61 and BI-Publisher
• Set up management self-service for viewing and updating multiple employee status data.
• Set up employee self-service for reviewing job descriptions and applying online.
• Set up payroll processing cycle including employees with special circumstances.
• Modification of Workflows
• Written HR/Payroll SQL queries for Payroll functional team as required / requested.
• Developed complex PL/SQL procedures and functions to efficiently perform custom business logic to summarize payroll data.
• Developed inbound and outbound interfaces to Kronos and ADP.
• Generated spreadsheets and reports using oracle PL/SQL, Toad and SQL to support ADP functionality.
• Maintained version control using the PVCS utility.
• Developed test scripts, performed system integration tests, and conducted user acceptance testing.

Environment: - Oracle Application 11.5.10.2 HRMS/ Payroll Customization

Confidential -Raleigh, NC

Oracle Functional/Technical Consultant

Responsibilities:

• Analyse issues and Change requests
• Design, Deliver and support the required customization and extensions
• Tune Slow running Reports & PL/SQL Packages
• Develop Custom Reports, PL/SQL Packages for interfaces & Formulas
• Develop MD20, MD50 and MD070 for the proposed solutions
• Implementing the customizations
• Defined Program, plan year periods, Life Event Reasons
• Defined Rates. Coverage, Premiums
• Defined Plan Types, Plan Information, Element Type,
• Defined Standard Rate Calculations
• Performed HRMS Employee Data conversions from the Legacy System using the API
• Performed HRMS Employee Termination Data conversions from the Legacy System using the API
• Performed setups to support the conversions in Advanced Benefits.
• Developed PL/SQL scripts for Advanced Benefits conversions
• Conduct CRP and User Training

Environment: - Oracle Application 11.5.9, Oracle 9.0.2 HRMS/Payroll/Advanced Benefits/OTL Customization and Support - (HRMS, Payroll, Standard Benefits) HP-Unix, PVCS, BI-Publisher .

Confidential

Oracle Developer

Responsibilities:

• Develop the Technical Specifications and Requirements
• Develop Several PL/SQL Packages, Stored Procedures to support the PPV computations.
• Developed new custom reports using Oracle Reports 6i/ Discoverer 4i. A few reports
• Developed are AAM Summarized & Categorized Purchase Price variance Report,
• AAM Purchase Part Price History Blanket Agreements Report.
• Developed a zoom to support the capture of the Purchase Price Variance by Category
• And price changes. Maintenance/Development of Custom forms, reports
• Modified Custom Workflow
• Was involved in the Conference Room Pilot (CRP) and User Acceptance Test ( UAT).
• Used Workflow for setting up approvals.
• Developed and delivered Oracle end user training.
• Created training for conference room pilots.

Environment: - Oracle Application 11.5.10.2 Purchase Price Variance Categorization

• Client: - Mahindra satyam, Hyderabad, India ( )

Role: Oracle Functional consultant

Responsibilities:

• Performance Tuning
• Design, Develop custom reports, forms and PL/SQL Packages to support customization, conversions and interfaces.
• Post implementation support and production support
• Develop conversions and interfaces for Employee data conversions from Legacy systems.
• Involved in the setup of GL in Creating chart of accounts, Defining accounting calendars
• Defining Set of books and attached responsibilities to GL.
• Generated various reports as per the requirement of the project.
• Developed custom forms like Available To Promise, Rescheduled Orders,
• Mass Add/Update Customer Restrictions, EDI Customer Item Availability, EDI Output Definitions
• Developed custom APIs to create extracts for checks and invoice payments in various formats as specified by the vendors
• Set up multilingual and multi-currency capabilities to maintain information on in patriate, expatriate and national assignments.
• Set up user defined groups to budget and administer salary planning.
• Set up compensation system to include multiple pay component.
• Set up functionality for job requisitioning.
• Developed workflows for approvals
• Developed the CV040 and CV060 documents for the conversions

Environment: - Forms-6i, Reports-6i, XML Publisher, PL/SQL, LINUX