PROFILE SUMMARY

• 10+ years of IT Experience in design, development and implementation of integration solutions making use of Oracle Fusion Middleware technologies.experience in Oracle Fusion Middleware including Oracle SOA suite 11g, Oracle BPM 11g, Oracle BAM 11g, Oracle ADF 11g, WebLogic Administration, and J2EE.
• Worked extensively in developing and deploying OSB & BPEL processes using technology adapters (File Adapter, FTP Adapter, Oracle Apps Adapter and DB Adapter). Knowledge on JMS, AQ, MQ Adapters and Human Work Flow.
• Experience of entire SDLC with proficiency in designing & developing applications based on SOA. Have worked on Java as well as middleware like Oracle BPM and SOA.
• Extensive experience in Oracle SOA Suite components such as SOA BPEL, Mediator, Business Rule, Human Tasks, OSB, Oracle BPM/BAM, EM, OWSM, Oracle SOA Management Pack.
• Strong experience in architecting the SOA endeavors by getting involved from the inception in choosing appropriate components based on project need, participating in hardware resource acquisition from clustering and load - balancing perspective, DB profiling.
• Expertise in SOA/OSB, WebLogic and Database performance tuning and administration tasks.
• Effective in project planning, team-meetings, coordinating from onsite and offshore, work collaboratively with other teams in organization, team management and improve team motivation skills.
• Expertise in web services, XML, XSD, XSLT, XPath, XQuery, WSDL, SOAP and WS-Security.
• Oracle Business Activity Monitoring (BAM) to create dashboards with various types of graphs.
• Excellent analytical, troubleshooting and debugging skills.
• Strong communication, motivational and presentation skills, and good team worker.
• Experience in creating Capacity Planning and creating KRA’s for the team to ensure timely delivery.

TECHNICAL SKILLS:

Oracle Fusion Middleware: SOA Suite 11G, OSB 11G, OWSM, Oracle BPM 11G, Oracle BAM, Oracle ADF

Operating systems: Red hat Linux4, Windows 7/8, XP/98/2003

Languages: Core Java-J2EE, Oracle PLSQL, MS Excel functions

Web Technologies: HTML, JavaScript, SOAP/REST based Web Service, JSON

Adapters: DB Adapter, Oracle Apps Adapter, JMS Adapter, MQ Adapter, AQ Adapter and File Adapter.

Applications/Tools: VMware, Eclipse, Net beans, Jenkins, Oracle SQL Developer, Oracle J Developer, SQL*Plus, SOAPUI, Http Analyzer

Application/Web Servers: Web logic 11g/12c, Web Sphere, JBoss, Apache Tomcat

XML/Web Services: XML, XSD, XSLT, SOAP, UML, WSDL, DHTML, HTML, UDDI, XSL

Database: Oracle 10G/11G, MYSQL 5.0, SQlServer 2005/2008

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Sr. Oracle ERP Technical Consultant

Responsibilities

• Oracle scope was to commission invoice, billing and collections from the Hoteliers. Accounting and automated revenue was done with the ability to support payment via direct debit and credit card. All this was achieved in OM, AR, Adv Collections,
• Payments and GL.
• Oracle was also integrated with lodging systems to subscribe and publish hotel data (oracle customer data) and to publish invoice data to the supplier portal for presentation to the hoteliers.
• Oracle received all the booking details from a third party to process further.
• Migrate the existing solution for Expedia’s corporate procure to pay and fixed assets from Peoplesoft to Oracle.
• It involved banking integrations for EFT transmissions, integration with Peoplesoft HR for employee and bank account data and month end GL upload to Peoplesoft financials. To achieve this functionality, different Interfaces were developed.
• Few of the Interfaces:
• Design and creation of Inbound Hotelier information from Supplier systems and Outbound Hotelier information to Supplier systems.
• Design and creation of Inbound Order creation from third party application.
• Design and creation of outbound AR account balance to supplier portal.
• Reports development was done for the following:
• Design and development of Invoice report to generate hoteliers invoice report which includes details of all reservations along with commission amounts due to Expedia for a specific date range. The invoice layout allowed the hotelier to view all reservations that occurred within the billing cycle on a single statement for multiple regions and languages.
• Design and development of the Credit Memo report to generate the credit memo to present to Supplier legal entity. It will allow the hotelier to view a single credit memo that was applied to individual oracle invoice for multiple regions and languages.
• Design and development of the Dunning Letter for Advanced Collections to generate and mail the dunning letters to the delinquent hoteliers for all active and suspended accounts for regions in multiple languages.
• The Dunning letters were developed to communicate with hoteliers to ensure collections of accounts receivable. Hoteliers were also emailed with a collective list of invoice numbers, amounts due and the due dates of unpaid invoices that need to be remitted.
• Developed common error handling program for the Interfaces.
• Designed testing scenarios and prepared Unit Test Plan and Scripts.
• Lead the team of 5 people for Reports track.

Confidential, Austin, Texas

Technical Lead, Test Manager and Cutover lead

Responsibilities:

• Responsible for interacting with Business SME’s for requirements and analyzing the existing processes. Coordinated with IT and business SME’s to get the RICEW development tracker.
• Preparation of technical upgrade and test strategy documents. Review the Functional Design Document (MD050s) and prepare detailed Technical Design Documents (MD070s).
• Perform peer review of the technical design documents, code and unit test documents. Involved in retrofit and development of the interfaces from external systems to GL, AP, PO, and PA.
• Coordinated with the infrastructure and DBA team on the instance strategy, instance planning and refresh for development and various test execution cycles.
• Design of Journal Interface from external systems - Constab, Microsiga, ProBusines Payroll. Interfaces from Ariba for inbound Purchase Orders, Receipts and Invoices.
• Design of Interfaces from Change Point to Oracle PA - Projects, Tasks Hierarchy etc.
• Worked on conversions related to - Projects, Tasks, Agreements, Budgets etc.
• Involved in preparation of the project cutover plan by having meetings with key stakeholders from EBS and external applications. Responsible for execution of cutover and reporting status to leadership and client group.
• Resolve issues identified during System Integration Testing, User Acceptance testing and Post Production Support by working with the business and IT SME’s.

Environment: Oracle EBS R12.1.3, 12.2.4, BI Publisher, OAF, SQL, PL/SQL, XML, Workflow etc.

Confidential, Atlanta, Georgia

Oracle Apps Technical Consultant

Responsibilities:

• Development of Eis Reporting and Time Entry Solution. This solution consisted of building custom applications using OA Framework for the User Interface, Oracle Workflow for approvals, PLSQL APIs for backend, XML Publisher for reporting.
• Involved in development of reports - Journal Details, GL Daily Activity report, Payables to General Ledger reconciliation report etc.
• Developed database packages, procedures, functions, views, synonyms etc. Worked on unit testing and system testing activities etc. Reviewing the Technical documents and the code.

Environment: Oracle Applications 11i, SQL PLSQL, Oracle forms, reports, XML Publisher, OA Framework etc.

Confidential, Texas

Lead Oracle Apps Technical Consultant

Responsibilities:

• Worked on development and maintenance of conversions - AR Transactions conversion; Customers Conversion. Worked on building a common data loader program to load legacy data for all the conversions.
• Built custom oracle forms ex: Quote and Order query forms to meet with business needs. Worked on reports like - Claims Aging, Claims Letter, Quote Document, Sales Order Acknowledgement etc. with XML Bursting included printing output documents.
• Worked on extensions, forms personalization, customization using CUSTOM.pll modifications. Worked on Oracle Payables - generation of Payment Files (for Check and EDI printing) using XML Publisher RTF and e-text templates.
• Worked on Customer Facing Document i.e. XML Based Receivables outbound invoice using Bill Presentment Architecture feature (BPA) in Oracle. Well versed with the setups in BPA. Worked on customizing the seeded LCT’s ex: forms personalization to suite project object’s migration needs.
• Worked on generating custom EDI outbound process for PO - 850 and PO Change - 860. Worked on PLSQL API’s and packages, procedures and functions for Tally Based integration i.e. custom application functionality built using oracle OAF.
• Coordinated with team members in resolving defects and participated in peer reviews for objects. Involved in unit test and system integration testing phases support.

Environment: Oracle EBS 12.1.3, Oracle Forms, Oracle Reports, XML Publisher, Oracle 10g, PL/SQL, SQL Developer, Oracle Workflow, Putty etc.

Confidential, Edinburg, Texas

Oracle Apps Technical Consultant

Responsibilities:

• Worked on Miscellaneous transaction import to load miscellaneous transactions into Oracle Projects using Open Interface.
• Creation of budgets in Oracle Projects using budget creation API.
• Customization of forms and workflow.
• Involved in preparing unit test cases.
• Worked on debugging code and fixing defects.
• Preparation of MD070 technical design documents for projects worked on.

Environment: Oracle Applications 11i, Oracle Forms 6i, Reports 6i, Oracle 9i, SQL, PL/SQL, TOAD, Workflow etc.

Confidential, Milwaukee, Wisconsin

Oracle Apps Technical Consultant

Responsibilities:

• Worked as on-site Technical Developer. Worked on forms personalization and custom.pll modifications to meet the client’s requirements. Customized workflow processes - PO requisition approval; PO Approval etc.
• Worked on a generic SQL*Loader program that is used to populate custom staging table given the data file, control file, remote ftp server details etc. Worked on Payables Open Interface to import invoices - developed SQL*loader and PL/SQL programs to load the open interface tables.
• Worked on modification and customization of reports. Design and build different database objects such as tables, views, indexes and synonyms. Worked with System Administration responsibilities for registering custom programs, creating Value Sets and Flex Fields etc.
• Created Concurrent Programs of types PL/SQL Stored Procedures, Host, Oracle Reports, SQL *Loader. Modified the Receivables Invoice Preview using Bill Presentment Architecture (BPA). Prepared AIM documents MD070, MD120 and worked with Oracle Support by logging SR’s etc.
• Worked on OA customizations (personalization and extensions) in i-Procurement and custom page development. Some extensions involve - defaulting requestor name in i-Procurement preferences; Restricting the List of Values on the Deliver-To-Location; Restricting the Select List pop list on the Shopping lists page etc.

Environment: Oracle Applications 11.5.10, Oracle Forms 6i, Reports 6i, Oracle 9i, PL/SQL, TOAD, Workflow, OAF, Jdeveloper 10g, WsFtp, Putty, UNIX and Windows, Star-team.

Confidential, Atlanta, Georgia

Senior Oracle Apps Technical Consultant

Responsibilities:

• Documented technical specifications and testing scenarios for Custom Reports and Forms. Loading transactions into projects interface with the relevant POET information. Developed custom forms and customization of existing seeded forms.
• Developed oracle alerts for identifying the manual journal entries in GL with invalid journal entries and send email to the business users for correction. Worked on forms personalization to meet the business requirements.
• Prepared unit test cases as part of testing activities. Prepared AIM documents - technical design MD070 and installation/deployment document MD120. Worked on Customizations using Oracle Apps standard API & Packages.
• Worked on migrating concurrent programs using FNDLOAD. Report Development (using Report Builder and XML Publisher). Worked on Code Migration and Migration Documents. Post production of custom developed objects.

Environment: Oracle Applications 11.5.10, Oracle Forms 6i, Reports 6i, Oracle 9i, PL/SQL, TOAD, Workflow, WsFtp, Windows, Sub-version..

Confidential

Applications Engineer

Responsibilities:

• Worked on the oracle e-business suite product development as an application developer and responsible for following tasks:
• Tax Codes migration - Involved in the tax codes migration from R11i to R12 and XBUILD sanity checks to verify the migration process and fix/resolve defects.
• Involved in debugging the API’s (database packages, procedures, functions) for Tax Calculation and taxation related services.
• Development/modification of XML publisher RTF templates, Oracle reports for the Tax Reporting Ledger (TRL) using XML Publisher.
• Worked on enhancement of OAF pages and bug fixes as part of XBuilds and Financials QA testing.
• Involved in building the seed data configuration (coding the LCT files) for the tax entities using FNDLOAD utility. Worked on defaulting and validation API invoked from sub-ledgers.

Environment: Oracle Applications R12, SQL PLSQL, Oracle Forms reports 10g, XML Publisher, OA Framework etc.