SUMMARY:

• 9 years of experience with Oracle ERP, SQL, PL/SQL, Oracle Applications Framework, Java,ADF, XML Publisher Reports, Open Interfaces, and APIs.
• Experience in Java, HTML, JavaScript, PHP, JSP, ASP and Excel Macros VB scripting.
• Experience in Oracle ERP R12 and 11i on Supply Chain\Financial Modules Customizations\Implementations and MDM Master Data conversions (Customers, suppliers, inventory, Banks and GL Flex Values)
• Worked on AR,GL,AP,FA,IBY,INV,PLM,QP,CM,PO, AOL, FND and SYS Admin modules of Oracle R12
• Adept at all stages of project lifecycle, from business requirements and technical definitions to development, Reviews, Testing, user acceptance testing (UAT) and production support.
• Vast experience on performance tuning.
• Worked on Fresh R12 Implementation projects, 11i to R12 Upgrade Projects and Production Support.
• Good at communication, organizational, and interpersonal skills.

TECHNICAL SKILLS:

Programming Skills: SQL, PL/SQL, Unix Shell Scripting, Java, JSP, ASP, JS, PHP, ADF and Oracle Applications Framework.

Tools Acquaintance: SQL*Loader, SQL*Plus, Toad, J - Developer, Eclipse IDE, Winscp\Putty.

Database knowledge: Oracle 9i/10g/11g.

Operating Units: Microsoft Windows 98/2003/2007/ XP

PROFESSIONAL EXPERIENCE:

Confidential, Jericho, Melville NY

Senior Oracle Applications Engineer and Technical Architect\Lead

• Develop various Oracle Applications using PL/SQL, SQL*Plus, OAF\Java, ADF, XML Reports, and Application Object Library.
• Use Oracle E-Business Suite applications for Inventory, PLM, PIM, MDM, accounts payable/accounts receivable (AP/AR), general ledger, fixed assets, and cash management, supporting data extraction, filtering, and validation.
• As Technical Architect and Lead, work with onsite Process leads and coordinate with offshore team through all SDLC phases to design, mentor, and code review for new enhancements for regional rollouts.
• Create extensions using Oracle recommended frameworks. Report against Applications data model.
• Write technical design documents for conversions, extensions, interfaces, and reports.
• Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conduct quality reviews of code developed by other development staff.

Confidential, Columbus, IN

Technology Lead

• Manage a team of Software engineers to deliver complete financial conversions solution for R12 upgrade which includes conversion entities identification, Discussion with client for requirements gathering on the entities identified, designing the Solutions for the entities and enabling the team to understand and implement the solutions designed till delivery and execution.
• Working with Business leads to gather requirements and translating them into Business requirement documents and analyze the fits and gaps.
• Working on Solutions for the requirements acquired based on vast experience on R12 Technical Architecture.
• Working on the MD50 and MD70 documents to detail document the Functional and Technical Specifications.
• Conversion of Purchase Orders \Releases\Requisitions, Receipts Payable Invoices, Fixed Assets, Cash Management Banks\Branches, Suppliers\Customers, Receivable Receipts, Invoices and General Ledger Journals

Confidential, Melville, NY

Onsite Techno functional Consultant\Lead

• Worked on preparing Functional Specifications with details of requirements, functionality, business validations, desired performance metrics and success criteria definition.
• Working on the Technical Specifications with details of technical designs suiting the performance criteria and the requirements\business functionalities.
• Analyzing and identifying the apt oracle seeded interfaces\API for the designed solution based on the module and entity
• Discussing with the client review teams to get a sign off on the specifications prepared.
• Develop PLSQL packages, OAF pages and UNIX shell scripts based on the Technical design to implement the solution.
• Testing the code to suite the business requirements agreed on.
• Key contribution for the program is the design and development of MDM Item master solution to import Supplier Price Files which loads the Items Price File received from various suppliers and create the Items, UDAs, Price Lists and Blanket Purchase Agreement with Sourcing rules using standard oracle Item Import interfaces, Price Lists Import, Import Price Catalogs interfaces.
• Worked on an advanced performance impacting module which requires normalizing the entire Item details related tables (Onhand, Sales Orders, Purchase Orders, Cross references\Lead times\Stock Qty\Receipts\EGO UDA\BOM\Customer Relations) using complex PLSQL blocks with heavily indexed bulk inserts\temporary tables and merge joins to a single master table to plug in for the FAST integration for Advanced user search engines for the part details.
• Interacting with the other existing dependant teams and convey them the key designs specifics of our solution and sort out any potential gaps upfront.
• Interacting with external review teams for external code reviews and get a concurrence on the deliverables quality.
• Testing the code for performance criteria and work on the performance improvement of the code using advanced TKPROF and SQL tuning methods.
• Maintaining and tracking the code versions\migrations using MKS tools and utilities.
• Planning and executing various test executions on the delivered code with the client and get sign-off on the complete delivery.