SUMMARY

• 15+ years of experience in implementation and post - production support of Oracle Applications (EBS) R12 (12.0.3 and 12.1.3), Oracle ADF & WebCenter Technologies.
• Good exposure on MVC pattern/Agile Environment/tuning ADF BC Components/PL-SQL performance/Jdeveloper 11g,12c/Oracle ADF Faces/Oracle WebLogic Server/Web Services.
• Experience in high performance object/relational persistence and query service like ADF BC and developing rich web application using ADF Faces.
• Knowledge on Oracle HCM applications like Compensation,Core-HR,Benefits,Payroll and Performance management.
• Extensive experience in Oracle Application Modules which include Fusion(General Ledger(GL), Accounts Payable (AP), Accounts Receivable (AR), Purchasing(PO), iReceivables, iProcurement, iStore, Fixed Assets(FA)), Inventory (INV),Bills of Material(BOM) & Order Management (OM) modules.
• Hands on Cash (O2C) and Procure to Pay (P2P).
• Hands on experience in Oracle Fusion Middleware OTBI,OBIEE and BI publisher.
• System Analysis, process mapping, Requirement gathering, analysis, Specification generation, Solution building, functional / technical design and System integration.
• Worked as a techno functional team/module lead, analyst, developer in development, implementation and support environments.
• Excellent perspective on converting the functional specifications into technical design and development.
• Expertise in Conversions, Interfaces, Extensions(Forms),XML(BI) Publisher, TCA, Reports, PL/SQL, Forms Personalization, Discoverer, Work flow and Oracle AIM implementation methodology.
• Have a good implementation and upgrade experience from Oracle 11i to R12.
• Developed custom Reports in INV and BOM modules using Reports 10g.
• Created test scripts,business process flows, and conducted multiple testing cycles.
• Conducted analysis focusing on the development of creative solutions delivering substantial results to clients; evaluated business needs, user requirements, functional specifications; analyzed and understood the client's pain areas, strategic direction and project goals in order to deliver exemplary customer service to clients.
• Perform implementation activities including, but not limited to requirements analysis, business process redesign, training and end-user support.
• Involved in QA Testing process and coordinated with end users for Acceptance Testing.
• Functional responsibilities: Interfacing with users, requirements gathering, functional gap analysis, design, configuration, module setup, test script generation, writing training guides, training end users and production support.
• Technical activities: identifying functional and technical gaps, estimating work, architect system interactions, designing custom solutions, scheduling, producing documentation, user manual to users and providing production support. Have a good implementation and upgrade experience from Oracle 11i to R12.
• Worked extensively on Customer Conversion using interface tables to import customer data from Legacy AS/400 system. And involved in data mapping.
• Provided support to Oracle SOA Suite settings and operational requirements.
• Design and Code PIM Extensions of the Oracle PIM,Oracle Configurator and Oracle Quoting Schema.

TECHNICAL SKILLS

• Middleware Oracle SOA Suite 10.1.3.x
• Oracle Fusion Middleware 11g
• J2EE technologies
• JDBC
• Servlets
• JSP
• JMS
• JNDI
• ERP Oracle Fusion Applications
• Java technologies
• AT swing
• Applets
• Frameworks Oracle ADF struts
• Apache
• Tomcat
• Web logic technology HTML
• XML
• XSL
• XPATH
• Oracle ADF
• ADF Mobile
• Weblogic
• Webcenter
• BEPL
• AJAX
• JDeveloper 11g/12c
• Visual Studio 2005/2008
• Hudson
• SOAP UI.
• Account Receivables (AR)
• Accounts Payables (AP)
• General Ledger (GL)
• PIM.
• Order Management (OM)
• Purchasing (PO)
• Inventory (INV) iSupplier (POS)
• ASCP.
• Install Base (CSI)
• Field Service (CSF)
• Service Contracts (OKS/OKC)
• CRM Foundation (JTF)
• Teleservice (CS)
• Depot Repair (CSD) iSupport (IBU)
• Trading Community Architecture (TCA/HZ)
• Oracle 11g
• PL/SQL
• JDeveloper
• BPEL
• Discoverer
• OAF
• Oracle Reports 6i/9i
• XML/BI Publisher
• Oracle Forms 6i/10g
• Workflow 2.6
• SQL Loader
• Toad
• TSO/ISPF
• SPUFI
• DCLGEN
• XPEDITOR
• QMF
• File Aid
• ChangeMan
• QueryMan
• SCLM
• In-Sync
• Trace-Master
• Intertest
• Control-M
• DBOL
• IDMS
• SAS
• SQL Estimator
• Stored procedure Builder
• Freeze Frame
• DASD Calculator
• DB2 Explain
• Smart Production
• Panvalet.

PROFESSIONAL EXPERIENCE

Confidential, New York

Oracle ADF-Analyst

Responsibilities:

• Involved in designing the custom database schema for the application to store the Customer data and involved in design, development and customization of ADF framework pages.
• Created Pop-up windows for adding and updating rows in the ADF table for various pages and created the validations for various fields using ADF validators to validate required field range, length and performed validations at attribute and entity level, written methods in ApplicationmoduleImpl class. Also created the UI using ADF faces components, train components, complex components such as ADF tree table and various Layout components.
• Customized the ADF exception handling to display user friendly error/warning message. Implemented scope concepts the shortest request scope to the largest application scope.
• Created ADF pages with Master detail tables, master table detail form and tree tables, also created new screens by using ADF task flows, JSFF and JSF associated between entity objects to represent the business relationships.
• Worked on ADF layout components such as Panel Stretch Layout,Panel collection,Panel Accordion and dynamic Iterator using Iterator component.
• Analyzed user requirements and modularized them into deliverable features, identify the tasks o complete it in given time and refined future requirements and developed user interface components using JSF and Oracle ADF.
• Worked on Customizations and launching in ADF, OAF, ADFdi integration, handling function and data security for item workbench, change management and rules configuration. Prepared Use case-development, Test Scripts,BR100 documents, Rollback plan besides raised SR and resolved.
• Provided the post- production support for Oracle Fusion Applications/Oracle SOA suite and debugged using Oracle ADF,Oracle 11g,Hudson,OBIEE.

Confidential, Chicago,IL

Oracle ADF- Analyst

Responsibilities:

• Performed ADF configurations using Oracle composer tool,Webcenter Spaces framework and integrated ADE Merge/Refresh schedules, application deployment to web logic server.
• Designed and developed the batch process for transfer data to HR process using Enterprises Service Scheduler (ESS),ADF,Java and PL/SQL.
• Prepare and review the functional design documents and setting up of financial category for Oracle Fusion Payables, Receivables accounts in GL for Reconciliation, besides performed the DataReview for easy migration and Smooth Reconciliation.
• Gathered business requirements, participated in setups & implementation and test scenarios for Oracle EBS CRM modules and very strong experience in Service Contracts, Installed Base.
• Resolved critical customer issues on Payables and Receivables Reconciliation Report and OTBI Reports using Oracle Fusion Middleware OBIEE.
• Involved in design and development of Bounded and Unbounded Task Flows,UI pages using ADF Rich Faces Components and demo the UI development approach.
• Worked on Customizations and launching in ADF,OAF,ADFdi integration,handling function and data security for item workbench,change management and rules configuration.
• Prepared Use case-development,Test Scripts,BR100 documents,Rollback plan besides raised SR and resolved.
• Provided the post- production support for Oracle Fusion Applications/Oracle SOA suite and debugged using Oracle ADF,Oracle 11g,Hudson,OBIEE.
• Leading a team of 6 developers. (Offshore - Onsite model).

Environment: Oracle Weblogic Server 11g,Linux,PL/SQL,ADF,SOA,Webcenter and Jdeveloper.

Confidential, Sioux Falls, SD

Oracle ADF-Developer

Responsibilities:

• Gathered business requirements and defined business processes, participated in setups, and test scenarios for Oracle Fusion Applications/ADF using BC components an Mapping it to Web Services/Web Center.
• Developed the ADF Business Components using Entity Objects,View Objects,Entity associations, View links, application modules. Besides good working knowledge on ADF controller such as Bounded task flows,Regions and Train Flows.
• Worked on ADF layout components such as Panel Stretch Layout,Panel collection,Panel Accordion and dynamic Iterator using Iterator component.
• Converted existing module from Oracle Database to Vertica Database for fast retrieval of data and customized ADF exception handling to display user friendly error/warning messages on ADF pages .Actively participated in Bug Analysis and fixing at system integration testing on ADF security and ADF skinning.

Environment: Oracle 11g, Jdeveloper, SOAP,UI, HTML,Java, ADF Rich Faces, Webcenter Portal, ADF Business components, ADF scripts.

Confidential, Portland, ME

Oracle Apps Consultant

Responsibilities:

• Worked on Check Printing (AP) report using XML Publisher on Oracle Apps 11.5.10.2
• Good Knowledge on Forms Personalization, Customizations using Custom.pll and customized the reports for AP,AR,AP aging payment reports,Inventory,purchase order, Order management and developed Interfaces Program/invoices using Payable Open Interface(AP).
• Used XML Publisher/BI Publisher, Discoverer to develop Custom Reports using TCS API's custom packages to update customer details, besides conversion of AR Receipts, Customer Interface Programs, CRM Resources using API’s and PO using Open interface.
• Extensively worked on Order To Cash customizations (OM, AR),CRM modules (JTF: Field Service, Service Contracts, Install Base, Territory Management, Tasks, Resources and Notes, CRM Foundation).
• Worked on various customizations for Field Service, Install Base, and Service Contracts, API’s for Conversions of Install Base using Customization, In-bound and Out-bound interfaces using Open Interfaces and customized programs for various application modules, besides developed PL/SQL packages, procedures and functions to migrate legacy data into Oracle Apps.
• Strong knowledge of Application Object Library (AOL) and knowledge of System Administrator. Development and customization of Oracle Applications Forms, Reports, Interfaces, Concurrent Programs and loaded data to the TeraData tables for Statistical Reports.
• Worked extensively on batch optimization project is to review the inventory of batch jobs in an application and recommend ways to reduce the total costs of the application.

Environment: Oracle Applications R12.1.3 Modules (GL, AP, AR, CE and FA), Reports 6i, SQL* Loader, MS Windows 2003, Oracle RDBMS 9i/10g, Oracle Developer.

Confidential, Dearborn, MI

Oracle Apps Techno - Functional Consultant

Responsibilities:

• Administered business requirement definition and gap analysis, and defined business processes, setups, and test scenarios for Oracle Financial modules.
• Handled the application of Oracle Financials that automated accounts payable, accounts receivables, fixed assets and cash management;
• Created FSGs comprising row sets, column sets and content sets for reporting purposes.
• Participated in the design of Chart of Accounts and did the Set up of Recurring Journals, Stat Journals & Mass Allocation Journals.
• Trained end users in AR, AP, GL, FA and CE and also created detailed user manual.
• Created corporate book, asset categories, system controls, flexfields - asset key, location and category in fixed assets.
• Provided users with access to multiple ledgers in GL through the use of GL Data Access Sets and to Multi OU through security profile in a secured environment; liaised with other personnel to deliver first-class customer service to clients; and adhered with governing policies and procedures enforced by the organization.
• Maintained proactive interaction with clients to understand business practices in rendering assistance in system configuration; analyzed various business functions to derive benefits that would be obtained in terms of cost rationalization and management control as a result of the implementation.
• Oversaw mapping business processes to Oracle Financial modules and conducted functional analysis, requirements, definition, and Oracle Financial module configuration and testing; designed and operated financial reports through the use of Final Statement Generator (FSG) tool; and trained users on various processes, such as AP, AR, GL, and CM (Release 12) while creating a detailed user manual.
• Documented the business requirements, current and future Processes, besides created the Responsibilities for all the ledgers and attached the Responsibilities to the Ledger.
• Worked on SLA (Sub-Ledger Accounting) rules to replace traditional transaction codes for generating multiple accounting representations for one business transaction.
• Involved in Defining Month End Close Processes and Post Production Support for Oracle Financial Modules, besides assisted users in month end closing process, reconciliation, generating month end reports.
• Conducted analysis focusing on the development of creative solutions delivering substantial results to clients; evaluated business needs, user requirements, and functional specifications; analyzed and understood client strategic direction, issues, and project goals in order to deliver exemplary customer service to clients.

Environment: Oracle Applications R11.5.10 Modules (GL, AP, AR, CE and FA), Reports 6i, SQL* Loader, MS Windows 2003, Oracle RDBMS 9i/10g, Oracle Developer.

Confidential, North America

Oracle Apps Developer

Responsibilities:

• Worked on conversion of AR Receipts, Customer, CRM Resources, and Sales-rep using API’s.
• Developed Conversions and Interfaces in 11.0.3.
• Used XML Publisher/BI Publisher to develop Custom Report with XML Output.
• Developed Interface Program to upload invoices in AR Auto invoices.
• Created and used AIM documents like MD50, MD70, and CV40.
• Forms Personalization, Customizations using Form Personalization and Custom.pll.
• Developed Interface Program to upload invoices in AR Auto invoices.
• Customized AR Payment aging report to create parties (consultants) and define relationships between consultants, hosts and guests, to migrate customers, contacts to TCA tables
• Creation of Responsibilities and Users. Defining Functions, Menus and assigning in to Responsibilities.

Confidential

Java - Tech Lead

Responsibilities:

• Translation and Arching web enabled, portal supports and database driven application.
• User selects the course, types in the additional information about the course and submits the requests.
• Application provides the facility to the user to generate the reports based on the error analysis.
• Developed server side components using JSP/Servlets and GUI using Javascript, CSS and HTML/DHTML.
• Developed ANT build script to automate the process of building, deployment and removing files from temporary location.
• Configured development and testing environments.
• Developed PL/SQL procedures and functions, created database views and triggers.
• Developed test cases and performed user acceptance testing using manual testing method.
• Fixed the bugs after integration test.

Environment: Java 1.2, WebLogic 7.1,MVC,JSP, Servlets, JDBC 2.0,Java Mail, PL/SQL, Javascript, CSS, DHTML, HTML, CVS, TOAD, Dream Viewer, WindowsNT.