SUMMARY

• More than 12+ yrs. of experience as Oracle EBS Techno - Functional Consultant/Lead in multiple Implementations, R12 Upgrades and Support/enhancement projects in Oracle E-Business Suite 11i (11.5.10) & R12 (12.1.3, 12.2.5, 12.2.6)
• Experience in various modules in areas of Financial (AR, AP, FA, GL), Manufacturing & Supply Chain Management (WIP, BOM, QA, OM, INV, PO), PLM, HRMS, DR, Alert and AOL.
• Efficient programming skills in PL/SQL, Stored Procedures, Functions, Database Triggers, Packages with Oracle Database 9i/10g/11g/12c on Implementation/Upgrade/Support projects within Oracle 11i/R12 E-Business Suite.
• Excellent experience in full Software Development Lifecycle (SDLC)
• Experienced in design and developing integration between 3rd party systems like Concur and Workday with Oracle EBS
• Experienced in RICEW (Reports, Interfaces, Conversions, Extensions, Workflow) and performance tuning of SQL, PL/SQL and Views.
• Experience in creating and customizing existing and new reports using reporting tools like Oracle Reports 10g/6i and BI Publisher (XML Publisher).
• Experience in Data Conversions and design/development of Interfaces using Oracle open interfaces and Oracle Public API’s for various Financial and Manufacturing modules.
• Experienced in customizing Oracle Applications using CUSTOM.pll, Form Personalization, OAF personalization & Extension and MWA customizations.
• Experienced in creating, customizing and administrating Discoverer reports/workbooks using Oracle Discoverer 10g/4i reports and Oracle Discoverer Administrator 10g/4i.
• Experienced expert on Label printing solutions using Loftware and Bartender like tools in Oracle EBS ecosystem.
• Mediocre experience in developing new custom pages using OAF in 11i and R12 versions of Oracle EBS.
• Extensive experience on AOL/System Administration tasks like Concurrent Programs, Registration & setup of Forms/OAF pages, Flex fields, Value Sets, Lookups, Menu and Responsibility.
• Experienced in working with the utilities like TOAD, SQL* Loader, Version Control Systems like Microsoft Visual Source Safe 6.0 (VSS), Serena PVCS VM 8.0, MKS Integrity Client and Tortoise SVN.
• Good interpersonal skills and ability to interact with people at all levels, and excellent communication skills.
• Experienced in gathering and understanding user requirements and translate into technical/Functional specifications.
• Experience in performing code reviews and ensure that all over programming quality as per standards.
• Experience in troubleshooting and resolving issues with technical, functional and DBA teams.
• Experienced working with Offshore-Onsite model with US clients.
• In-Depth knowledge of the Apps data model, which helps in all aspects of development cycle such as building Custom Reports, data validation, data import, data fixes.
• Ability to learn quickly new technologies and solve problems in a team environment and multitasking.
• Capable of working independently and as well as a part of a team and working under pressure and deadlines.
• Excellent skills resolving issues in supply chain and finance modules of techno-functional nature
• Experienced in opening/following-up service requests (TAR or SR) with Oracle Support.
• Experienced in leading a team, mentoring team members towards common goal, delivery and testing.
• Good working knowledge in REST API, WSDL, JSON, Web Services, SOA

PROFESSIONAL EXPERIENCE

Confidential, Camden, NJ

Oracle Apps Developer

Responsibilities:

• Participate in all aspects of Software Development Life Cycle (SDLC) and requirements gathering and analysis.
• Analyze business requirements, and estimate design/development work
• Develop technical documentation for each phase of the SDLC
• Perform design, development and unit test of application features using Unix, XML, Java, Oracle Forms, OAF, Reports, and BI Publisher, SQL and PL/SQL
• Follow code control standards using source control tools like PVCS/SVN
• Application build and deployment to WebLogic server in development, UAT and Production environments
• Perform Quality Assurance (QA) testing Assist users in User Acceptance Testing (UAT)
• Document Technical Design (MD70), installation instructions (MD120) and assist in production deployment and post-production support

Environment: Oracle EBS R12 (12.2.6), Oracle Database 12c, INV, PO, OM, QP, BOM, WIP, PL/SQL, Custom.pll, TOAD, Tortoise SVN

Confidential

Oracle Apps Developer

Responsibilities:

• Develop custom APIs packages using PL/SQL to create Sales Orders, inquire inventory on hand and item Pricing according to business requirements within Oracle EBS R12.2.6
• Unit testing and coordinate with SOA team to verify end to end functionality
• Code migration through CP using MKS Integrity Client repository tool
• Performance tuning for SQL and PL/SQL custom code to eliminate time bottlenecks in system
• Utilize Toad, SQL, PL/SQL, Order management, Inventory, Purchasing, Pricing to enhance Oracle R12.2.6 with 12c database
• Design and develop technical solutions to a pre-defined requirement and develop components (e.g. extensions, views, customizations, modifications and workflows) independently or as a part of a team

Environment: Oracle EBS R12 (12.2.6), Oracle Database 12c, Custom.pll, INV, PO, OM, PL/SQL, TOAD

Confidential

Techno-Functional Oracle EBS Consultant

Responsibilities:

• Develop and/or customize Oracle reports and forms to meet functional business requirements.
• Design, develop, and test custom extensions (e.g. packages, functions, procedures, and triggers)
• Work with end users and functional analysts to capture and document business requirements, perform unit and system testing.
• Assist in migrating code changes to production environment and perform code reviews.
• Provide techno-functional expertise necessary to support daily operations in Oracle Applications Supply Chain & Financials area.
• Month End support on various financial (AP, AR, GL) and supply chain (OM, INV, BOM, WIP, QA) modules
• Architected and developed end to end solution for Label printing automation using Loftware and Oracle EBS in WIP
• Architected and Developed end to end integration of Concur (3rd party) system with Oracle Payable (AP) to create AP Invoices.
• Worked on personalizing the Oracle Application through Form Personalization and Custom.pll
• Architected and Developed end to end integration of Workday (3rd party) with Oracle HRMS
• Utilize Oracle tools, such as SQL, PLSQL, Toad, Forms, BI Publisher and ALERTS to enhance Oracle applications.

Environment: Oracle EBS R12 (11.5.10, 12.1.2 & 12.1.3), Oracle Database 11g/12c, Report10g, Forms 10g, Custom.pll, WIP, BOM, INV, QA, AR, AP, GL and PLM, PL/SQL, TOAD