SUMMARY:

• 13 plus years of professional experience in IT industry; delivering solutions in Oracle Applications E - Business Suit in the areas of Application Development, Analysis, Design, Testing, Implementation and co-coordination of onsite/offshore activities.
• Good expertise and knowledge in working with 11i/R12 (Implementation, R12 Upgrade and support)
• Expertise in SQL, SQL Loader, PL/SQL, Oracle Reports, Oracle Forms, XML/BI Publisher, UNIX Shell Scripts, Workflow, OAF and AME (Approval Management Engine).
• Good understanding on SOAP based web-services using BPEL, good knowledge on WZDL, XSD and XML.
• Extensive Functional and Technical Knowledge in Oracle Financials, Purchasing, iProcurement, OTL, EAM and HRMS modules.
• Strong background in development and customization of RICE objects in ORACLE General Ledger (GL), Accounts Payable (AP), Purchasing (PO), Fixed Assets (FA), Oracle HRMS, and Oracle Enterprise Asset Management (EAM).
• Expertise in design and development of Interface/Conversion programs for Enterprise level integration of legacy systems into Oracle Applications using open interface tables and API's.
• Strong understanding on underlying data structures in Financial Modules, Purchasing, HRMS, EAM and good knowledge on Application Object Library (AOL).
• Experience in Interacting with various business users, understanding client’s requirements, business imperatives and expectations of the requirements, and ensured steps are taken to deliver it as per expectations.
• Experience in XML Gateway and Hands on in Message Designer.
• Excellent presentation and communication skills and also ability to work well with internal and external team as well.

TECHNICAL SKILLS:

Operating System: Windows 98/2000/8/10, Linux

Programming Languages: SQL, PL/SQL, JAVA, XML and UNIX

Databases & Tools: Oracle 8i/9i/10g/11g

Other Utilities: DOM, Maven, Subversion, Jenkins, Hudson

IDEs: Oracle Forms & Reports 6i/10g, JDeveloper11g, Workflow Builder, XML Publisher, Message designer.

Tools: Toad, SQL Developer, SQL*Loader, Data Loader, WinSCP, Putty, MS Visual Source Safe, HP Quality Center and Spar.

PROFESSIONAL EXPERIENCE:

Confidential - Chicago, IL

Senior Oracle Application Developer

Responsibilities:

• Performing analysis of the functional changes in R12 and remediate 11i custom objects.
• Remediate custom reports, workflow's, form personalization's (pll), db objects and shell script as per R12 changes.
• Support the development team to remediate CEMLI/R objects.
• Creating Ad hoc extracts, queries as requested.
• Report any gaps in existing applications and provide/suggest solutions.
• Prepare migration scripts to upload all the custom objects across instances.
• Coordinate with functional folks/business users to resolve queries/issues.
• Preparing technical design documents for the remediated objects.
• Co-ordinate with other team members for code review and testing.
• Interacting with oracle support on SR’s raised for standard product issues.

Confidential - Cleveland, OH

Senior Oracle Application Developer

Responsibilities:

• Responsible for Technical deliverables including Retrofit, Unit Testing and Deployment across Non Production Instance.
• Lead & support the development team to retrofit the CEMLI/R objects and provide solutions for the change requests/GAP.
• Design and develop inbound interfaces to migrate the HR employee, assignment and termination data from third party system (ADP) to Oracle HRMS.
• Design and develop custom report
• Total Transaction Report to extract all the sub-ledger transactions accounted in GL. (E-Text Format)
• XML based remittance advice report and email to the specific supplier using XML bursting. (PDF format)
• P&L FSG report based on the row-set defined in FSG setup.
• Designed and developed solution to load the 20 years of historical data (60 million records) from upgraded R12 instance to OBIA.
• Supported OBIA team to develop / modify the SQL queries used to extract the data from oracle based on requirement.
• Create alerts to monitor the concurrent programs that are running for more than desired time, program completed with error and warning status.
• Create menu using form personalization and trigger custom OAF page to submit Print purchase order report.
• Prepare migration scripts to upload the components across instances.
• Coordinate with Client/ business to resolve queries/issues.
• Preparing technical design documents for the retrofitted objects.
• Co-ordinate with other team members for code review and testing.
• Interacting with oracle support on SR’s raised for standard product issues.
• Providing technical support for the modules GL, AP, PO and HRMS.

Confidential

Senior Oracle Application Developer

Responsibilities:

• Involved in Requirements gathering, Technical Design, Development in R12 adhering to Build Standards and Unit Testing.
• Developed interface to migrate HRMS employee contacts, relationships, phone and address details from legacy system to Oracle R12.
• Designed and developed custom OTL module for contract employees (Labor Reporting) and process the time entries to create invoices.
• Designed and developed custom OTL module for regular employees (Labor Reporting) and cost the time entries against EAM work order.
• Developed interfaces for BOM, BOM Routings, BOM attachments and PM schedule in EAM module.
• Customized standard Oracle workflow in OTL and iSourcing modules.
• Customized "Oracle EAM Pick Release" program to allocate the material only from supply sub-inventory.
• Designed and developed wire transfer payment outbound interface and e-mail the payment file to the designated authority.
• Coordinated among team members for quality review, deliver solutions and gathering status of deliverables.
• Coordinated with OBIA team to test the reports and fix the bug's in the query.
• Provided technical support for the modules GL, AP, PO, EAM and custom labor reporting module.

Confidential

Senior Oracle Application Developer

Responsibilities:

• Responsible for Technical deliverables including Retrofit, Unit Testing and Deployment across Non Production Instance.
• Remediated custom objects impacted during R12 upgrade.
• Prepared technical design documents for the remediated objects.
• Coordinated with other team members for code review and testing.
• Handled new enhancements through change requests.
• Coordinated and gathered status of deliverables from Team
• Prepared status reports to update overall progress in status calls.
• Interacted with oracle support on SR’s raised for standard product issues.

Confidential

Oracle Technical Consultant

Responsibilities:

• Interacted with business users for gathering requirements of new enhancements and provide estimation and handling through change requests.
• Responsible for resolving day-to-day issues.
• Developed custom XML reports.
• Customized standard oracle reports and workflows.
• Resolve issues related to HRMS employee data inbound interface.
• Provided L2 & L3 support for multiple instances of production application.
• Coordinated with Client/ business to resolve queries/issues.
• Coordinated with multiple third party application owners for incident resolution.
• Responded to incidents in a timely manner thereby adhering to SLAs.
• Provided SIT and UAT assistance
• Mentor team members and drafted training plan.
• Involved migration and deployment activities

Confidential - Medford, MA

Oracle Technical Consultant

Responsibilities:

• Developed conversion program to migrate Supplier data from legacy systems into Oracle Purchasing.
• Developed conversion program to migrate Purchase requisitions from legacy system to Oracle Purchasing.
• Customized Account Generator Workflow’s in various modules like AP, PA, FA and POR.
• Customized PO approval workflow.
• Designed and developed custom XML reports.
• Prepared AIM technical design documents.
• Involved in customization of PO Requisition Approval workflow.
• Involved in preparing Installation scripts to move the custom objects across instances.
• Interacted with oracle support on SR’s raised for standard product issues.

Confidential - Boston, MA

Associate Consultant

Responsibilities:

• Involved in preparation of error trapping documents for OFSA which explains the unhandled exception areas in various packages and procedures used in custom objects.
• Provided technical support for AP and PO.
• Involved in testing and reviewing the components which are getting migrated from DEV to TEST instance. .

Confidential

Associate Consultant

Responsibilities:

• Developed conversion program to migrate AP Holds from Legacy system into Oracle Applications.
• Developed conversion program to migrate PO Receipts data from legacy system into Oracle Applications.
• Customized PO Approval workflow.
• Customized requisitions Account Generator Workflow
• Developed custom report to print the PO with amount ranges low and high which are open in status.
• Involved in testing and reviewing the components which are getting migrated from DEV to TEST instance.
• Providing technical support for the modules AP and PO.