SUMMARY

• Over 7 years of Experience in Information Technology, have experience in Implementation, Up - gradation and Customization of various versions of Oracle Applications (versions R12, 11i).
• Proficient working in Oracle Applications modules General Ledger, Account Receivables, Account Payables, Budget Execution, OM, iProcurement, iSupplier, Purchasing, Oracle CRM; iStore, Quoting, Inventory, Advanced Pricing, Trading Community Architecture (TCA), System Administration and Application Object Library (AOL).
• Expert in Oracle Application Framework (OAF), CRM Technology Foundation (JTF), Workflow, XML Publisher.
• Very good understanding and exposure of working with the Oracle Trading Community Architecture (TCA) entities and public APIs.
• Involved in Full Life cycle Implementations of Oracle CRM, Federal Financials with major clients.
• Experience working on Oracle Application Implementation Methodology (AIM) documents like MD050, MD070, MD120 and TE.020 and also worked on BR100 document.
• Experience in customization by extension and modification of the standard application suite using Application Object Library (AOL) and setting up Oracle Alerts in Application.
• Extensively worked in Developing PL/SQL, SQL *Loader, Stored Procedures and Triggers.
• Expertise in Developing and Supporting both Production and Development Systems.
• Expertise in using migration and version control software KINTANA and Clear Case.
• Experience in working with Oracle Support- TAR management, resolving the issues.
• Strong knowledge working on SOA Suite, SOA Gateway and BPEL.
• Followed best Coding Standard Practices while developing deliverables.
• Excel at managing complex real time projects with tight schedules.
• Interaction with Functional community (Customers) and End Users to Analyze and Map the Business and Functional requirements with Oracle Applications.
• Highly motivated, energetic individual as well as a team player with excellent analytical, problem solving, communication and interpersonal skills.

TECHNICAL SKILLS

ERP: Oracle Applications (R12.2, 11.5.10).

Modules: GL, AR, AP, Budget Execution, FedAdmin, Purchasing, OM, iStore, Quoting, Inventory, iProcurement, iSupplier, iExpenses, Advanced Pricing, Sales Online and AOL.

Database: ORACLE 11g, MS SQL Server and MS Access.

Languages: SQL, PL/SQL, JAVA, JSP, HTML, JavaScript, AJAX, Unix Scripting.

Tools: JDeveloper, Workflow builder, XML Publisher, Toad, SQL Plus, SQL*Loader, Eclipse, Kintana, SVN, OBIEE 11g.

Application Servers: Oracle 9i AS, Jboss, Web Logic.

GUI: Oracle Applications Framework, JSP, Struts.

Operating System: UNIX, Windows-NT/2000, DOS.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Application Developer

Responsibilities:

• Responsible for upgrade of iProcurement, iSupplier and Custom applications from 11i to R12.2.3 and also served as main point of contact for all OAF migrations to R12.2.3.
• Troubleshot all the issues of remediating and migrating OAF objects to 12.2 version for which WebLogic server is introduced.
• Identified all the steps for migration of OAF objects including running adcgnjar utility, adding entries to custom synchronization driver file, deploying OAF pages and generating product JAR Files.
• Worked extensively in remediating and testing Non Catalog Requisitions, PCARD Requisitions, NBS External and Internal Requisitions and NBS Vendor Training Requisitions.
• Remediated Requisition Account generator and Requisition Approval Workflows customizations.
• Remediated Custom PL/SQL Packages, Views, triggers and API’s for Inventory, Order Management and Purchase Order Modules.
• Developed new customizations in Supplier forms to meet the client requirements.
• Involved in configuration and development work for iProcurement, iSupplier, EVIP and Account Payables.
• Extensively worked with iSupplier external vendors and supported them as needed in helping them create invoices and login issues. Acted as primary POC for iSupplier.
• Worked with Oracle support on multiple Service Requests including R12.2 various performance related issues.
• Remediated OAF components and BI Publisher Reports for NBS Fellow Ship Payment Process.
• This system allows the NIH Institutes and Centers (ICs) to create and maintain fellows and awards (Purchase Orders), disburse Fellowship and Health Insurance Payments, as well as associated tax documents.
• Troubleshot and tested Funds Check Process for FPS system.
• Remediated Inventory Supply Oracle reports.
• Supported client and users for post go live support.
• Documented all technical changes for development and remediations.
• Developed Shell scripts to automate migration of OAF personalizations and extensions through HP PPM.
• Won Champion of the Month Award for troubleshooting and remediating critical customizations in 12.2.3 successfully.

Environment: Oracle Applications 12.2.3, iProcurement, Purchasing, iSupplier, Payables, OAF, Jdeveloper 10.1.3, Panaya, HP Quality Center, Workflow Builder, BI Publisher, UNIX, TOAD 11.6, SVN, HP PPM, Win SCP, Putty.

Confidential

Oracle Applications Developer

Responsibilities:

• Involved in Enhancements and customizations of Oracle E-Business Suite iProcurement, Purchasing, Account Payables.
• Responsible for design, coding and development of custom applications using OAF, Workflow Builder, SQL, PL/SQL and XML Publisher.
• Developed iReclass Tool interface to classify journal entries and automate the process of creating GL journal entries in UFMS General Ledger.
• This tool validates all the data, has online iReclass request workflow approval with monitoring and notifications, ability to create and query iReclass transactions, store iReclass data and approvals history, upload backup documentation and funds check while creating entries, easy export iReclass data to Excel and iReclass Reporting.
• Developed Automated Clearing Record System (ACRS) custom interface that automates the process of creating AP invoices in UFMS Accounts Payable System from generic csv files for clearing transactions. This interface allows users to upload files from various clearing sources, correct the data, split the transactions and submit it.
• Developed complex OAF Pages that include csv file upload through OAF page to server, dynamic LOV’s, Dependent LOV’s, Copy Functionality, Excel Feature, Amount Formatting, dynamic locking and hiding of fields and buttons, advanced tables and responsibility security.
• Created PL/SQL package for validating PO’s, Vendors and CAN’s, to populate and load data into interface tables, check balances and funds available, create journal lines and archive data.
• Worked on support of Custom Applications, General Ledger, Budget Execution, Account Payables, iProcurement, Purchasing.
• Used Application Object Library (AOL) to register generated Reports and Concurrent Programs.
• Created new Lookups, Profiles, Concurrent Programs, FND Messages, functions, menus, and responsibilities.
• Supported technical team members in installing JDeveloper and SVN.
• Worked closely with client in requirement gathering, providing and testing solutions.
• Resolved IT and UAT Defects, performance issues and used bind variables wherever required to improve the performance.
• Developed Oracle BI Publisher Templates and Reports using BI Publisher Desktop Edition.
• Developed and tested OBIEE Reports for iBudget Execution Module.
• Provided alternative workaround solutions when there are technology challenges.
• Attended ADF training.
• Ability & highly keen on to learn, grasp and deliver both individually & also as a proactive team member.

Environment: Oracle Applications 11.5.10, Federal Financials, General Ledger, Account Payables, Budget Execution, iProcurement, Purchasing, OAF, Jdeveloper 9.0.3, Workflow 2.6, BI Publisher, XML, UNIX, TOAD, SVN, OBIEE 11g, Win SCP, Putty, SQL Plus.

Confidential

Senior Oracle Applications Developer

Responsibilities:

• Involved in design, coding and development of custom applications that integrates with Budget Execution process and General Ledgers.
• Responsible for Oracle Applications Framework technical development, unit testing and support.
• Created various custom pages with advanced layouts and features that include hierarchical display, Attachments, Export to Excel, Dependent LOVs, Poplists, Flex Fields, Check boxes, Radio buttons and tip messages.
• Integrated OAF with Oracle workflow and provided out of box solutions in OAF.
• Implemented security based on user roles and responsibilities to custom pages and functions.
• Developed Proof of Concept to generate XML Publisher reports from custom Oracle Application Framework pages.
• Developed PL/SQL Packages, Procedures and Functions for given business requirements.
• Provided technical support in Oracle Workflow, Database Design, Configuration Design and BI Publisher Report.
• Interaction with Functional Team at all stages of project lifecycle from business process, technical definitions to development, testing, completion and production support.
• Developed UNIX scripts to download and upload FND Messages, Profiles, Concurrent Programs, Lookups and migration scripts for java class files and pages.
• Created HP-PPM packages, provided Deployment documents and Test Results for deployment/migration of code from Development Instance to Production System.
• Involved in resolving issues related to Federal year end closing of UFMS Oracle EBS system.
• Used Sub Version for version control of Custom code objects.
• Performed intensive testing on all the process and designs in all the stages of the project.
• Documented the MD070 and MD120 documents.
• Able to work in under pressure and meet deadlines.

Environment: Oracle Applications 11.5.10, Federal Financials, Budget Execution, Federal Administrator, General Ledger, Account Receivables, iProcurement, OAF, Jdeveloper 9.0.3, Workflow 2.6, BI Publisher, XML, UNIX, TOAD, SQL Plus.

Confidential

Responsibilities:

• Involved in design, coding and development of the Oracle Applications Framework Extensions as part of 11.5.10.2 Enhancement, R12 Upgrade Projects with WMS Gaming.
• Worked on Analysis, Design and Implementation of Soft Billing which reduced Work Order lead time.
• Created the test plans and coordinated the UAT with the business users.
• Involved in the design and Development of Customer Quoting Module using Oracle Applications Framework.
• Developed BPEL applications to consume JESA system web services for fetching approved parts and software versions into Oracle EBS.
• Worked on Application Module, Entity Object and View Object substitutions for various customizations.
• Created Entity Expert classes, Property View Objects to validate and display fields based on business rules.
• Extensively worked on creating Entity Associations and View Links for loading data from custom tables which were dependent on data from seeded tables.
• Designed a complex Configurator solution for quote copy along with copy configuration.
• Created an advanced pricing solution in conjunction with configurator using pricing attributes for ‘Parts’ models.
• Worked on Upgrade and retrofit of Quote Approval Workflow, Workflow for Task Manager, Order Headers, and Order Lines Workflow.
• Developed OA Framework pages with custom security based on user security permission roles.
• Conducted a number of workshops with Revisions team to gather requirements.
• Developed program to identify and propose required correct parts for configuration to reduce downstream issues for Planning and E-Prom Room to ensure the correct size flash card is processed.
• Involved in design and analysis of iProcurement Customizations and Approval Management Engine.
• Developed UNIX scripts to download and upload FND Messages, Profiles, Concurrent Programs, Lookups and migration scripts for jsps, java class files and images.
• Used Sub Version for version control of Custom code objects.

Environment: Oracle Applications 11.5.10, R12, SOA Suite, Oracle Quoting, Order Management, Inventory, Bills Of Material, Work In Process, Advanced Pricing, AR, iProcurement, TCA, OAF, BPEL, UNIX, TOAD, Workflow 2.6, Jdeveloper 9.0.3, SOA Suite.

Confidential

Responsibilities:

• Involved in design and customizations of various Oracle iStore.
• Conducted Rapid Requirements gathering summits with the Business users to gather Requirements.
• Involved in setup and implementation ofiStore.
• Created custom API’S to get Global Availability to Promise (ATP) Information without using the Cart Information in iStore.
• Created Custom APIS to Get Pricing Information Using Advanced Pricing Api’s in iStore.
• Customized iStore Direct Item Entry Page to Check Item Availability & Pricing Using Java and PLSQL Wrapper’s.
• Created Custom Pages for Open orders, Track orders, Invoices in Oracle Portal using JAVA & JSP’s.
• Extensively Customized User Registration Process using Diff Custom Enrollments.
• User types for B2B and B2c Customers in iStore Based on Roles & Permissions.
• Customized iStore Alert and JTF Approval Workflow’s
• Prepared Documentation involving from MD050, MD070 & BR100 following AIM methodology
• Customized JSP’s for Look and Feel as per business requirement.
• Helped in Integration of iStore with Oracle Portal.
• Environment: Oracle Applications 11.5.10, Oracle CRM IStore, Order Management, TCA, AR, INV, AP and Oracle Portal.

Environment: Oracle Applications 11.5.10, iStore, Order Management, Inventory, Advanced Pricing, UNIX, TOAD, Jdeveloper 9i.

Confidential

Programmer Analyst

Responsibilities:

• Involved in analysis, design, development, and testing phases of Software Development Lifecycle (SDLC).
• Developed the application on Eclipse 3.5 and deployed on WebLogic 10.0 Application Server.
• Developed the User Interface (UI) using Java Server Pages (JSP) utilizing Custom Tag Libraries, JSTL, HTML, JQuery, CSS and AJAX.
• Developed the application based on Struts MVC Architecture, ActionForms and Java beansas Model, JSPs and Struts Tilesas View and ActionServlet configured by Struts-config.xml as a controller.
• Used Web services - WSDL and SOAP using Apache Axis.
• Responsible for installation, configuration and deployment of WebLogic Application server.
• Created Web Application Archives files to deploy the application on WebLogic Application server.
• Implemented unit testing using JUnit to test each module in the application.

Environment: J2EE, JSP 2.0, Spring 2.5, Struts 1.2, Hibernate 3.0, HTML, XML, SAX, AJAX, JavaScript, Eclipse3.5, WebLogic Server10.0, UML, SQL Server2008, Webservices, AXIS, Agile (Scrum), JUNIT, Log4j, ANT, SVN