SUMMARY:

• Eleven plus years of experience in oracle application 11i (11.5.9, 11.5.10.2) and 12i (12.0.3, 12.1.1, 12.1.3&12.2.5).Highly accomplished Lead Consultant with a proven track record of managing and delivering complex IT projects and exceeding expectations in Oracle ERP - Oracle Financials, Oracle Supply chain and manufacturing. Involved in more than 5 Full life cycle implementations for Product, Nutrition, IT Infrastructure, Manufacturing, Cloud, Automobile and Pharma clients.
• Expertise in Implementation and Support for Oracle-EBS projects in the functional & technical areas of Oracle Financials (AP, AR, GL, and FA), Manufacturing (INV, WIP, BOM, Pricing, and Costing) Supply Chain Management (PO, OM) and CRM modules.
• Expertise in developing and customizing RICEW (Reports Interfaces Conversions Extensions and Workflows).
• Expertise in developing and customizing OA Frameworks (EBS Releases 11i and 12i) &ADF 11g.
• Strong work Experience and high understanding of ADF architecture, ADF development, and Bounded & Unbounded task flows, ADF Bindings, ADF Faces, Managed beans, Facets, Layouts, Web service integration in ADF.
• Experience in configuring Data source service (JDBC connections) in WebLogic server (10.3).
• Strong work experience on CUSTOM.pll, Reports 6i &10g, Forms 6i &10g, Oracle Alerts, XML Publisher, BI, Discoverer, SQL*Loader, Data Loader and Shell script.
• Expertise in using Advanced PLSQL coding concepts.
• Strong Experience in Performance Tuning: Tuning SQL, PLSQL, Reports, Forms, OAF &ADF pages.
• Production support / Implementation / experience.
• Usage of Change management and Version control tools for implementation and production support projects.
• Monitoring data volumes for developing interfaces / conversions to choose right design for PLSQL coding.
• Data fix and Code fix releases on weekly and monthly basis.
• Trouble shooting on error programs / Performance issue programs.
• Worked on Service Now, BMC, JIRA etc. ticketing software’s.
• Worked on CVS, SVN, and VAULT etc. version control and repository software’s.
• Experience with Global Rollout Implementation projects.
• Experience in developing third-party interfaces and integrating with oracle applications.
• Experience in Reviewing the code and setting up/maintaining coding standards.
• Developed and customized RICE components like Reports, Forms, Interfaces, Conversions, Extensions and workflows as per client requirements.
• Strong work experience of Order to Cash and Purchase to Pay Business Cycles.
• Ability to install and setup Oracle Tools like Developer 6i/10g, Oracle 9i/10g, JDeveloper9i/10g, Toad, SQL Optimizer and other tools.
• Ability to work individually.
• Worked on inbound and outbound Oracle EDI’s (Electronic Data Interchange).
• Knowledge of process/data flow, base tables, workflows, interface tables, and standard APIs.
• Excellent inter-personal and problem solving skills.
• Strong written and verbal communication skills.

TECHNICAL SKILLS:

ERP: Oracle Manufacturing and Financial Applications (12.0.3, 11.5.9 and 11.5.10.2)

Modules: General Ledger, Payables, Receivables, Assets, Purchasing, Inventory, Order Management, Bills of Material and Work in Process, Oracle Alerts, Application Developer, System Admin, Supply Chain Management (SCM) and Advance Supply Chain Planning (ASCP).

Oracle Tools: WEBADI, EDI, Reports 10g/6i, Forms 10g/6i, Discoverer 4i, SQL plus, PL/SQL, OAF, BPEL (Business Process Execution Language) SQL Loader and Data Loader, WebLogic 10.3

Databases: Oracle 10g/8i/9i

Database Tools: TOAD, SQL Loader, SQL Optimizer, TK-Prof

Report Tools: XML Publisher, BI, Discoverer, OPTIO

Tools: Clear case, BMC, E-room, Remedy, Quintana, JDeveloper9i and 10g, Winscp3, Putty and FTP

Operating Systems: DOS, Win 2003/Vista/XP/NT/2000/98/95, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, MD

Sr. Consultant

Oracle Applications Enhancement: 12.1.3, UNIX Shell Scripting, Java, SQL, PLSQL, XML PUBLISHER, REPORTS, OAF, TOAD, WINSCP3, J DEVELOPER 10g, CVS, OM, PO, INV, AP, AR and GL

Responsibilities:

• Customizing existing custom OAF to display location based on selected sub inventory and derives DFF attributes for that sub inventory dynamically. Make Read only and editable based on particular status.
• Analysis the change impact for existing XML publisher reports.
• Modified XML Data templates and RTF templates to add newly created sub inventory details based on delivery / order level.
• Modified existing and also created new XM L reports in OM, AP, AR and GL modules.
• Modified existing DB objects like TABLES, VIEWS, and PL/SQL stored procedures, Functions and Packages for newly created sub inventory.
• Performed setups like Item assignment to Locator/Sub inventory, creating new responsibilities, assigning responsibilities to holds in OM.
• Performed front end tasks like Item Miscellaneous Transactions, Order entry, pick release, ship confirmation to test custom OM reports as part of unit testing.
• Performed front end tasks like creating different types invoices, validating, as part to test custom AP, AR reports as part of unit testing.
• Created new responsibilities, Release rules, sub inventory, location, shipping documents for newly created sub inventory.
• Created form personalization on order entry form.
• UAT and PRD support.
• Preparing Migration scripts for changed objects to move into Production instance.

Confidential, NJ

Sr. Consultant

Oracle Applications Enhancement & Production Support: 12.1.3, 12.2.5 UNIX Shell Scripting, Java, SQL, PLSQL,, REPORTS,OAF, SQL NAVIGATOR, WINSCP3, J DEVELOPER 10g & 11.1.1.6, SVN, MS Share point, WebLogic 10.3 CSI,INV,OM,AP,AR

Responsibilities:

• Developing interfaces as per client requirement.
• Developed OAF custom page to call PLSQL procedures and update the data in custom tables.
• Developed custom methods in application module and using them in ADF task flows.
• Developed ADF page using images, icons, managed beans, ADF rich UI components like ADF layouts, input texts, buttons, command links, Boolean check box, etc.
• Defining custom CSS and configuring them in Trinidad configuration and skins (XML).
• Dynamic change of CSS on ADF components.
• Developed ADF pages using page fragments (JSFF) and used in bounded task flows.
• Developed SOA web service (WSDL) using BPEL to call PLSQL API.
• Invoking SOA web service in ADF page.
• Developed ADF page(JSPX) and unbounded task flow using switcher functionality to display multiple functionality pages in one page using links.
• Developed ADF page using multi shuttle functionality to apply add-on features for a carline and model year.
• Deployment and Integration of ADF pages with oracle EBS.
• Created new MSCA responsibilities based on the operating unit.
• Developed PLSQL custom API to load data into custom tables.
• Coordinating with offshore team and providing technical solutions on the requirements.
• Creating new tickets for code changes and bug fixes.
• Working with QA team to provide requested/required data as per their requirement.
• Involved in requirement gathering and gap analysis meetings.
• Developing and customizing reports as per requirement.
• Code Debugging and enhancements.

Confidential, San Antonio, TX

Lead Consultant

Oracle Applications Enhancement & Production Support: 12.1.3, UNIX Shell Scripting, Java, SQL, PLSQL, FORMS, REPORTS,OAF, TOAD, WINSCP3, J DEVELOPER 10g & 11.1.1.6, WebLogic 10.3, XML PUBLISHER, DISCOVER, ETEXT, WEBADI, Service Now, MS Share point OM, PO, INV, AR, AP, GL

Responsibilities:

• Responsible for working on tickets assigned and delivering solution.
• Developing interfaces as per client requirement.
• Designed and developed complex requirements like integrating xml publisher reports into OAF pages.
• Code Debugging and enhancements.
• Developing and customizing reports / BI publisher reports.
• Developed Device and Account Level Products OAF Page.
• Developed Cloud account usage by customer OAF page.
• Converted custom forms into ADF pages functionality and integrated to oracle applications EBS.
• Developed custom ADF pages with list of values (choice list, auto suggest, input text lov), search, master detail with insert and update functionality.
• Developed ADF page with export to excel sheet functionality.
• Developed ADF page to import data from excel sheet into custom table.
• Developed custom ADF page template according to client standards.
• Developed ADF page to upload contract PDF’s into the custom table column of BLOB.
• Developed and customized WEBADI (EXCEL) to upload data into oracle tables.
• Developed user responsibility listing report in e-Text output format to copy file into another server using XML bursting file.
• Modified Print selected invoice report as per client requirement.
• Customized AR Aging Report by account report.
• Fixed Assets Additions and Adjustments report.
• Fixing performance issues.
• Developing shell scripts and used for migration.
• Preparing Technical design and migration documents as per AIM standard.

Confidential, New York, NY

Sr. Oracle Apps Developer/EDI Consultant

Oracle Applications: Up gradation (11.5.9 - 12.1.3 ). 11.5.9, 12.1.3, Java, SQL, PLSQL, FORMS, REPORTS, TOAD, WINSCP3, XML PUBLISHER, EDI, WEBADI, OM, PO, INV, AR, AP, GL

Responsibilities:

• Responsible for upgrading concurrent programs/forms/EDI from 11i (11.5.10.2) to 12i (12.1.3).
• Developing WEBADI (MS EXCEL) forms.
• Upgrading RDF TEXT reports to BI Publisher Reports.
• AIM documentation like MD70, MD120.etc.
• Shell script for migration of code from one instance to another instance. Developed AR Invoices and credit memo WEBADI form for creating bulk invoices and credit memos.
• Developed AP invoices WEBADI form for creating bulk AP invoices.
• Modified and configured 850 POI EDI program according to R12 instance.
• Modified and configured 810 Invoice out bound EDI according to R12.
• Modified PLSQL and Oracle reports concurrent programs (oracle base tables) accordingly to R12.
• Modified Custom Forms according to R12 instance.
• Developed new shipping documents as per client requirement using BI publisher.
• Developed AR Invoice and Tax reports as per client requirement using BI publisher.
• Customized seeded Chart of Accounts Listing to BI Publisher reports to show output in EXCEL.
• Upgraded more than 50 custom reports as part of upgrade from 11i to 12.1.3

Confidential, Santa Monica, CA

Sr. Oracle Apps Developer

Oracle Applications Implementation: 12.1.3, UNIX Shell Scripting, Java, SQL, PLSQL, FORMS, REPORTS, OAF, TOAD, WINSCP3, J DEVELOPER 11g, WebLogic 10.3, XML PUBLISHER, WEBADI, AP, AR, GL, PA

Responsibilities:

• Responsible for developing forms, reports, conversions, Interfaces, OAF pages and customizing workflow.
• Developed ADF page with Autosuggest LOV functionality.
• Developed ADF pages using BC4J components like (Entity Objects, View Objects, Application Module, View Link)
• Developed custom application UI using ADF pages (JSP, JSFF), task flow.
• Deployment of ADF application to Standalone WebLogic server and integrating it to oracle EBS.
• Implemented WEBADI for AP and AR bulk invoice import functionality.
• Responsible for unit testing, bug fixing and preparing Technical design and migration shell scripts and documents.
• Unit testing and code migration.
• Preparing documentation as per AIM standards.
• Communicating with client /onsite functional personal on business requirements.
• AP Aging report - Customized standard report to meet client requirement.
• GL Report- Customized General Ledger report to show EXCEL output.
• Developed new custom page based on staging table for correcting error records.
• Customized account generator work flow to assign cost center for only specific organizations.
• Customized OEOL workflow.
• Developed new custom forms to validate / edit / insert for WEBADI records.

Confidential, Maryland

Sr. Oracle Apps Developer

Oracle Applications Enhancements: 12.1.3, SQL, PLSQL, REPORTS, TOAD, WINSCP3, XML PUBLISHER, AP, AR, GL, PA

Responsibilities:

• Responsible for developing various RICE component testing and migrating to Production.
• Responsible for developing various project accounting reports in EXCEL/PDF output.
• Responsible for fixing issues and customizing according to new enhancements/requirements.

Confidential, Cincinnati, OH

Sr. Oracle Apps Developer

Oracle Applications Implementation: 12.1.3, SQL, PLSQL, REPORTS, TOAD, XML PUBLISHER, INTERFACES. OM, PO, INV, AP, AR, GL, PA

Responsibilities:

• Developing OAF Page to meet the client requirement.
• Developing EDI programs.
• Requirement gathering.
• Developing custom forms.
• Developing database objects like PL SQL packages, Triggers, Functions.
• Developing custom programs using standard API’s to meet the client requirement.
• Post production support.

Confidential, Duluth, GA

Sr. Oracle Apps Developer / OA Framework Developer

Oracle Applications Implementation: 11.5.10.2, UNIX Shell Scripting, Java, SQL, PLSQL, FORMS, REPORTS, OAF, TOAD, WINSCP3, J DEVELOPER, XML PUBLISHER, MS Share point. OM, INV, PO, CST, BOM, WIP

Responsibilities:

• Developed data conversions and interfaces.
• Developed XML Publisher Reports.
• Involved in requirement gathering.
• Involved GAP Analysis.
• Post production support.

Confidential, Torrance, CA

Sr. Oracle Apps Developer

Oracle Applications Implementation & Production Support: 11.5.10.2, UNIX Shell Scripting, OPTIO, SQL, PLSQL, FORMS, REPORTS, TOAD, WINSCP3, Service Now, BMC. OM, INV, AP, AR, GL

Responsibilities:

• Developed OPTIO reports.
• Worked on Data fixes and code fixes.
• Involved in unit testing of programs related to oracle PLSQL concurrent programs.
• Creating and updating tickets in BMC software.
• Preparing MD120 and MD70 documents.
• Worked on customizing AOL objects like Concurrent programs, Lookup, Value sets, Profiles, etc.
• Customized PL/SQL packages which generate XML data related to OM modules.
• Post implementation support.

Confidential New Jersey, TechEnzyme Inc, NJ

Oracle apps Techno-Functional consultant

Oracle Applications Implementation: 11.5.10.2, UNIX Shell Scripting, SQL, PLSQL, FORMS, REPORTS, TOAD, WINSCP3, MS Share point. OM, PO, INV, Costing, BOM, WIP, GL

Responsibilities:

• Prepared functional, technical design documentation.
• UTP Installation documentation and Shell Scripts.
• Created the test cases.
• Involved in testing and reviewing the objects.
• Developed XML reports.
• Developed data conversions.
• Coordination with offshore team.

Confidential, Pittsburgh, PA

Oracle Applications Analyst

Oracle Applications Implementation: 12.0.3, UNIX Shell Scripting, SQL, PLSQL, FORMS, REPORTS, TOAD, WINSCP3, MS Share point OM, INV, PO, FA, AP, AR, GL

Responsibilities:

• Prepared functional, technical design documentation.
• UTP Installation documentation and Shell Scripts.
• Created the test cases.
• Involved in testing and reviewing the objects.
• Developed XML reports.
• Developed data conversions.
• Coordination with offshore team.

Confidential, Wichita, KS

Oracle Apps Technical Consultant

Oracle Applications Production Support: 11.5.10.2, SQL, PLSQL, FORMS, REPORTS, TOAD, WINSCP3. OM, INV, PO, AP, AR, GL, WIP, BOM

Responsibilities:

• Oracle Applications Technical support for various components like Reports (RDF, Sql plus, discoverer), Interfaces, Alerts.
• Involved in developing the new components (reports, PL/Sql Procedures, packages).
• Involved in developing the data fix scripts.
• Involved in Setup changes in related modules.
• Involved in Inventory Month end closing process.
• Involved in interacting with users when required.