SUMMARY

• Around 9.5 yrs of experience in Oracle applications as Techno Functional Consultant of which 6.5 years Associated with Confidential Consultancy Services (TCS) as Oracle Apps Techno Functional Consultant and 3 years with Accenture Services PVT Ltd
• Experience in Implementation, development and Support of Oracle HRMS (Core HR, Self Service, Oracle Advanced Benefits, Oracle learning Management, Oracle OTL, Oracle Absence Management and Oracle ADP Payroll) and Financials (AP, AR, GL,OM) Modules
• Expertise in design, development of RICE (Reports, Interfaces, Conversions and Extension) programs to integrate Oracle Applications modules to import data from various sources into Oracle Applications.
• Comprehensive technical experience in Oracle Applications tools - Oracle Reports, Workflows, Oracle XML Publisher, Oracle PL/SQL, SQL and UNIX.
• Experience in development and Customization of OAF Pages.
• Proficient in tuning SQL statements using EXPLAIN PLAN AND TKPROF
• Experience in the preparation of Functional Design, Technical Design documents.
• Strong background in knowledge management and system maintenance technical Documentation including documentation using AIM Methodology
• Experience in working with Oracle Utilities like SQL*Loader, UTL FILE Package and UNIX Shell Script.
• Working closely with end-users/clients through complex problems and providing a fix.

TECHNICAL SKILLS

• Oracle 9i/10g
• Oracle Apps
• HRMS
• Account payable
• Account Receivables
• General Ledger
• Order Management
• Oracle SQL
• Oracle PL/SQL
• UNIX
• Core Java
• C/C++
• Oracle Workflow Builder
• Oracle Reports
• Oracle XML publisher
• Jdeveloper
• TOAD
• FTP
• Putty
• Oracle SQL Plus
• Oracle SQL Loader
• Pl/SQL Developer

PROFESSIONAL EXPERIENCE

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Interaction with client to gather the requirements such as MD50
• Development of Account Receivables and Account Payables and Fixed Assets Components from Scratch such as conversions, Interfaces, Extensions and XML Reports.(Customer Site Conversion, Invoice Conversion, Suppliers Conversion, and Inbound and Outbound Interfaces)
• Integration of Sabrix System with Account Receivables for tax Calculation
• Development of HRMS Job, Organization, Position and Employee Conversions and Interfaces.
• Development of AR to AP intercompany Process using AGIS.
• Development of AR Cash receipt Creations and Application of Cash receipts against Invoices and Credit Memos
• Involved in implementation of Custom Check Printing as per the Client Requirements.
• Implementation of New and Complex Functionality during Assembly and Integration Testing across All Financial Modules and HRMS.
• Functional Configuration of Accounts Receivables and HRMS across Instances
• Onshore - offshore Co ordination for Implementation of Components
• Preparation of Detailed Design of the objects/custom extensions, technical spec (Such as MD 70) based on requirements received, test plan.
• Assembly Testing, Integration Testing, UAT and liaison with various groups during testing Support during Quality Assurance Testing of the code using MQC
• Fixing the bugs raised by the QA team based on their priority level in all Phases of Implementation
• Training, Knowledge Transfer of applications and Induction of new team members to the Account and Project.
• Knowledge Transition to QA team.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN

Confidential

Module Lead/Senior Developer

Responsibilities:

• Worked closely with business users for gathering and understanding the business requirements.
• Involved in Developing the Payroll Outbound Interfaces from end to end for APAC, US and Canada Regions
• Involved in Developing the Payroll Outbound Interfaces from end to end for EU Payroll Countries (Netherlands, UK, Ireland, Spain, France, Germany etc.)
• Involved in developing the Inbound Interfaces on Compensation and Benefits track
• Design and Implementation of OAF pages for Compensation Track
• Development of PTO Carryover Program using Customization.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN
• Design and Implementation of interfaces for Core HR track
• Integration Testing and liaison with various groups during testing. Support during Quality Assurance Testing of the code using MQC
• Fixing the bugs raised by the QA team based on their priority level.
• Training, Knowledge Transfer of applications and Induction of new team members to the Account and Project.
• Preparation of Detailed Design of the objects/custom extensions, technical spec (Such as MD 70) based on requirements received, test plan.
• Review and fine tune the oracle Pl/SQL code using Trace and TKPROF files
• Knowledge Transition to QA team.
• Developed an Oracle Web ADI tool, to create/update/delete the configuration data like Job/Grade/Bonus Plan.
• Involved in Migration of objects using KINTANA Migration
• Involved in registering concurrent programs, executables, creation of Responsibilities, request groups, menus, value sets, request Sets, Flexfields in System Administration.
• Preparing test plans and unit testing of the components.

Confidential

Developer, Production Support Executive

Responsibilities:

• Involved in all the phases of dis project.
• Personalisation on self-service screens and documentation.
• Analyzed the user requirements
• Involved in solving the Defect Change Requests
• Developed control files to load data from flat file to Oracle Staging tables using SQL* Loader for customization of AP, AR, interfaces.
• Involved in customization and solving the issues in Leave of Absence issues, Time Recording, Oracle Learning Management issues
• Worked on synchronizing Workflow Database with Oracle Portal OID
• Worked on version up gradation process of TMS
• Involved in solving the issues in me Expense reports, Auto lock box issues and Aging Reports
• Worked on Web ADI HRMS issues.
• Worked on Oracle Portal LDAP to load the multiple users’ issues.
• Developed the code for concurrent program for assigning new oles to multiple users
• Worked on Financials Up gradation and Customization of interfaces in AP, AR Modules
• Analysis of the requirements.
• Prepared functional design documents.
• Prepared technical design documents.
• Defined value sets, concurrent programs, request sets, PL/SQL procedures, functions, triggers and packages.
• Worked on Conversions, Inbound Interfaces of Sales Orders, Purchase Orders, Work Orders, and Vendors.
• Performed the unit testing for the code and migrated the files through kintana tool.
• Batch Data loads and data fixes using Open Interfaces and APIs.
• Development, maintenance, enhancement and customization of Oracle Reports, Oracle Forms and Workflows.
• Maintenance, enhancement and customization of inbound and outbound data interface programs.

Confidential

Developer

Responsibilities:

• Interaction with client to gather the requirements.
• Unit testing and integration testing.
• Involved in solving the Defect Change Requests
• Providing end user support, technical support and monitoring the jobs for BASC Financial Applications.
• Involved in End user support to the CriticalCFL GL/Oracle GL team during Month End Closeout
• Worked on Aging Reports and Auto lock box issues of AR module.
• Worked on Customized AP, AR Interfaces.
• Involved in solving the Defect Change Requests.
• Worked on solving the Critical Production Support Issues on AP, AR, and GL Modules
• Support and maintenance of Oracle Applications 11i instances including production.