EXPERIENCE SUMMARY:

• Oracle 20 years
• Unix 18 years
• PL/SQL /SQL*Plus 15 years
• SQL*Navigator & Toad 10 years
• Oracle Forms 10 years
• Oracle Report 2.5/6i/10g 10 years
• Oracle Discover/XML/BI Publisher 5 years
• Oracle HRMS EBS(12i) 18 years
• Oracle Payroll EBS(12i) 18 years
• Oracle OTL EBS 7 years
• Oracle Advance Benefit (11i/12i) 8 years
• Oracle SSHR (5.2) 8 years
• Jenkin,Jira, Bitbucket,PVCS, Vertex, Kintana, MS - Access, HTML,XML,J2EE
• AIM MD50/MD70/CV10
• I have good experience in IT for over 15 years covering the contemporary aspects relating to Oracle and specifically Oracle Applications ERP.
• I am involved in engagements covering the complete life cycle projects including Design, Development, Testing, Implementation and Training for various Business Data Processing and Oracle Applications.

PROFESSIONAL EXPERIENCE:

Experian, TX

Oracle Global HR/Payroll Lead

Tools: UNIX, Oracle Applications 12.1.3, Reports10g

Responsibilities:

• Part of Team implemented Taleo Cloud
• Created numbers of new FastFormuls for newly created element
• Implemented Oracle HRMS in Brazil
• Implemented Oracle OTL in Costa Rica
• Implemented Devops(Jenkin, Jira and Bitbucket) for migration process
• Created Development and UAT data scramble process for sensitive data.
• Created interface to ADP for few GRE

Confidential, TX

SR Oracle HRMS Developer Consultant

Tools: UNIX, Oracle Applications 12.1.3, Reports10g

Responsibilities:

• Created Conversion Data for Employee and Dependents
• Created Conversion Data for Location,Job,Organization,Department,& Position
• Created Conversion Data for Earning & Deduction
• Created Conversion Data for Employee Tax
• Created Daily Interfaces for change data for Employee,Dependent,Tax,Location,Job,position,organization and department

Confidential, St. Louis, MO

SR Oracle HRMS Consultant

Tools: UNIX, Oracle Applications (11i/12i), Reports11g

Responsibilities:

• Taleo to Oracle Routine Employee Data Upload Process Project
• Created Routine to Upload all the employee Data like Employee,Assignment,Phone,Address,Salary,Payment Method,Tax, Education and element Entry to Oracle HR. This process runs on every hour.
• Customized Oracle W2 templates
• Automate Employee Record Update From Taleo to Oracle
• Testing all the HR/Payroll/OAB Process and custom program
• Changing all the custom table name and the corresponding custom programs
• Redefining all the custom concurrent program due to change of custom application name and directory
• Added new functionality in OAB Created Address change LE
• Added new functionality in HR &Payroll - Added new payroll, OrganizationLocation, new elements and written few FastFormula.
• As Part of Implementation Team for Canadian Payroll involved in Functional Setup
• For Employees, Assignments, Salary, GRE and Federal and Province Taxes.
• Loaded all the required

Confidential, Raleigh, NC

SR Oracle HRMS Consultant

Tools: UNIX, Oracle Applications (11i), Reports10g

Responsibilities:

• Created Outbound and Inbound Benefit interface for Benefit vendor
• Created All new benefits element
• Create Outbound Interface for employee data between Oracle HRMS and Workforce
• Created Inbound Interface For Confidential Entry for all the the Hourly employees

Confidential, Houston TX

SR Oracle HRMS Consultant

Tools: UNIX, Oracle Applications (R11i/2i), Forms10g, and Reports10g,BI Publisher

Responsibilities:

• Testing all the HR/Payroll/OAB Process and custom program
• Changing all the custom table name and the corresponding custom programs
• Redefining all the custom concurrent program due to change of custom application name and directory
• Technical and Functional support to user group
• Rewriting few interfaces like 401K and medical
• Work with DBA to apply Oracle Patches
• Responsible for maintaining 25 interfaces,100 reports and any functional issue

Confidential, Jersy City, NJ

Sr. Oracle Application Consultant

Tools: HP UNIX, Oracle Applications (R11i/R12i), Forms6i/10gi, Reports6i/10gSQL*Loader, PL/SQL, Discoverer 4.1

Oracle Apps: Oracle HRMS, Oracle Payroll, Oracle Standard Benefit (OSB), WorkforceOracle Time & Labor (OTL), Oracle Advance Benefit (OAB)

Responsibilities:

• Responsible for providing technical and functional support to user group.
• Trouble shooting day - to-day Problem.
• Applying Patches.
• Designing and documentation interfaces
• Supporting Production Issue and resolving in timely manner
• Taking Initiative in upcoming project.
• Worked on following major projects.
• Converted all the custom Reports and Forms from 6i to 10g.
• Tested all the oracle functionality and RICE. Fixed custom reports
• Problem due to 10g upgrade.
• As a part of team created conversion program to convert data to OAB.
• Timecard setup including Exception layout and Project and payroll layoutTime Entry Rule design, Time Entry Preferences Design, Setup of OTL assignment and moving the time from OTL to BEE.
• Design and Developed Interface Program to load Time data from
• Workforce system into OTL (Oracle Time & Labor) using PL/SQL and
• Oracle Standard API s. Created ten reports like
• Timecard Entry Submit Verification Report
• Timecard Detail Report
• Daily, Weekly and Monthly Worked Hour Summary & Detail Report
• Absence Report
• Interface between OTL and PA
• Interface to create timecard for a group of employees from third party
• Time entry system by using standard API s.

Confidential, Missouri

Oracle Application Specialist

Tools: HP UNIX, Oracle Applications (R11i), Forms6i, Reports6iSQL*Loader, PL/SQL, Discoverer 4.1

Oracle Apps: HR, Payroll, OAB, Workflow, SSHR

Responsibilities:

• As - Is Requirement Analysis
• To-Be requirement Analysis
• Product Fitment and Gap Analysis
• Data Migration and Interface Requirement Analysis and Design
• Setting up of User Acceptance Testing
• Roll Out of solutions to different Division of Emerson on HR, PayrollSSHR system and OAB
• Offshore Support (India & Philippines)
• Worked on Two OAB Open Enrollment Process

Confidential, Missouri

Sr. Application Developer

Tools: HP UNIX, Forms6i, Reports6i, SQL*Loader, PL/SQL, Kintana

Oracle Apps: Oracle HRMS (11i), Oracle Payroll (11i), Oracle Standard Benefit (11i)

Responsibilities:

• Responsible for providing technical and functional support to user group.
• Trouble shooting day - to-day Problem. Applying Patches.
• Designing and documentation interfaces, Supporting Production Issue and resolving in timely manner, taking Initiative in upcoming project and Worked on following major projects.
• Involved in Callconnect project, used to changes personal data, dependent data, address, phone, payment method data (Bank Info) and benefits data.
• Callconnect send data as flat file.
• Wrote a process to automatically upload data into Oracle HRMS through Oracle API after the approval of authorized user.
• Involved in migrating all of employees and dependents personal data, employee
• Address, employee phone, employee salary, Direct Deposit
• Bank Info and tax info into Oracle HRMS.