SUMMARY:

• 9 years of professional experience in Oracle E - Business Suit(EBS) consulting in the area of Manufacturing, Telecom, Construction and Finance domain
• Extensive experience in 11i to R12 upgrade, R12 Implementation, Data Migration, Enhancement, Integration and Support project
• Strong experience in design and development of Inbound and Outbound interface for transactional data of PO,OM,INV and AR module
• Strong experience in design and development of conversion program to import high volume master data and transaction data into Oracle EBS R12 through SQL*loader
• Strong experience in development of custom forms using oracle forms 10g
• Strong experience in personalization of oracle forms 10g
• Strong experience in development and customization oracle reports
• Strong experience development of xml publisher reports
• Extensive experience in registering and configuring various AOL concepts like concurrent programs, request groups, request sets, Key Flex fields, Descriptive Flex fields etc.
• Rich experience exposure PO, OM, AP, INV, HR and GL module as technical consultant
• Excellent working knowledge in components related to Order to Cash and Procure to Pay cycle
• Experience in planning and managing project in Agile, DevOps and Waterfall model

TECHNICAL SKILLS:

ERP: Oracle Apps 11i and R12 e-Business Suit

Modules: PO, OM, INV, AP, HR and GL

Work Area: Interface, Conversion, Oracle Reports, XML Publisher Report, Oracle Forms

Languages: SQL,PLSQL and Unix

Database: Oracle 9i, 10g and 11g

Tools: TOAD12.5, SQL Developer, Filezilla, WinSCP, Putty, HPQC, SVN

PROFESSIONAL EXPERIENCE:

Confidential

Technical Consultant

Oracle Release: Oracle Application Release 11.5.10

Responsibilities:

• Support Inventory, PO and Order Managment module
• Analyse and Resolve the incident tickets reported from users
• Identify long term fix of existing issues/bugs in the interface, report and forms
• Participate with business to identify enhancement need in the existing process and gather requirement for enhancement
• Design interface to replicate sales order from 11i to R12 system
• Monitor critical scheduled jobs in inventory and Order Management
• Participate in monthly and quarterly release
• Mange and Coordinate offshore team

Technical Consultant

Oracle Release: Oracle Application Release 12.1.3

Responsibilities:

• Requirement gathering for item serialization
• Development of technical design document for Interface and BI Reports
• Development of outbound interface to export data to AXWAY system
• Develop item serialization mechanising for shipping items to South Korea
• Development of xml publisher report
• Setup serialization mechanism at item, lot, transaction and responsibility level for testing items shipping to South Korea
• Perform Misc Receipt transaction, release lot quantity, change serialization profile values and change FND Diagnostics profile values for testing
• Create Sales order and IR/ISO for testing
• Coordinate QA and business user at onsite
• Manage and Coordinate with offshore team

Technical Consultant

Oracle Release: Oracle Application Release 12.1.3

Responsibilities:

• Analysis of functional document and development of technical design document
• Development of inbound interface to load purchase order from legacy system to EPOM (custom module)
• Development of XML Publisher reports and Oracle Reports
• Development of custom forms for setting up project milestone
• Creating value sets, executable, concurrent programs, request sets and profiles
• Performing code movement to various instance using TAR files
• Peer review of technical document, code and unit test case
• Supporting GO-LIVE activity and warranty support of project

Technical Consultant

Oracle Release: Oracle Application Release 11.5.10

Responsibilities:

• Preparing Mapping document (CV040) and Conversion Program Design document (CV060) for install base and service contract.
• Development of inbound interface to create/load item instance and warranty contracts from legacy system to oracle application.
• Validating item instance and warranty contract created in oracle application by conversion program
• Develop PLSQL reports to publish conversion reports
• Peer review of technical document, code and unit test case
• Supporting GO-LIVE activity of project

Technical Consultant

Oracle Release: Oracle Application Release 12.1.3

Responsibilities:

• Validating Objects need customization in AP, PO, AR, OM, HRMS and PA modules of 11i
• Documenting changes required in custom object as R12 compatibility
• Customization/Recreation of interfaces and conversion program with new tables and API of R12
• Customization of oracle standard reports and oracle forms in R12
• Performance turning of oracle reports, xml publisher reports and interfaces
• Code migration activity to various instance using TAR files
• Peer review of technical document, code and unit test case
• Played role of Offshore Team lead

Technical Consultant

Oracle Release: Oracle Application Release 12.1.3

Responsibilities:

• Finding Objects need customization in AP, PO, GL and AR modules of 11i
• Documenting changes required in custom object as R12 compatibility
• Customization/Recreation of interfaces and conversion program with new tables and API of R12
• Customization of oracle standard reports and oracle forms in R12
• Development of custom oracle reports and interfaces
• Performance turning of oracle reports, xml publisher reports and interfaces
• Creating LDT files for modified objects
• Performing code movement to various instance using TAR files
• Supporting GO-LIVE activity of project
• Performing Warranty support after go live of project
• Worked on enhancement and production support ticket resolution

Technical Consultant

Oracle Release: Oracle Applications Release 12.1.1.0

Responsibilities:

• Analysis of functional document and development of technical document.
• Development of Inbound/Outbound interfaces for GL and AP.
• Development of XML Publisher reports.
• Code migration to various instances
• Peer review of technical document, code and unit test case.
• Preparation of Installation document.
• Post Go Live Support

Technical Consultant

Oracle Release: Oracle Applications Release 12.1.1.0

Responsibilities:

• Analyse CV40 and create CV60 document for conversion programs.
• Development of conversion program for account payables - supplier and supplier bank
• Development of conversion for hrms - hr locations, hr organization, hr positions and employee
• Development of conversion for oracle purchasing- requisition and purchase order
• Development of conversion for Inventory- item and on hand quantity
• Development of XML Publisher reports.
• Code migration to various instances

Technical Consultant

Oracle Release: Oracle Applications Release 12.1.1.0

Responsibilities:

• Development XML Publisher Report, rdf, executable and concurrent programs
• Creation of LDT files using FNDLOAD command
• Preparation Unit Test Cases
• Preparation of component delivery Documents

Confidential

Technical Consultant

Oracle Release: Oracle Applications Release 12.1.1.0

Responsibilities:

• Development and customization of Reports using Oracle Report Builder 6.0 and XML Publisher
• Forms customization and Personalization using Oracle Form Builder 6.0.
• Creation of Concurrent program, executable, value set, profile option and request set
• Monitoring and assigning application support incident
• Preparation Unit Test Cases