SUMMARY

• 13+ years of IT experience with 5+ years in Oracle E - Business Suite 12.1.3 experience in Distributions and Financials in Applications Framework (OAF) Customization, Personalization, Interface Design, Reports Development and Data Conversions.
• Extensive experience in Oracle Applications Framework (OAF) which forms the base for all Self-Service Web Applications (SSWA) in Oracle Applications e-Business suite.
• Done Customization from scratch and Extension using OAF and JDeveloper in R12.
• Worked on OAF UIX Pages, ADF Business Components (BC4J), Partial Page Rendering (PPR), SPEL, and Business logic coded in JAVA.
• Technically strong in SQL, PL/SQL, Procedures, Packages, Functions, Triggers, Form Personalization, Oracle Workflow, Reports 10g, XML Publisher, BI Reports, Sql*loader, Interfaces.
• Worked in Oracle Purchasing (PO), Trading Community Architecture (TCA) i-Supplier, General Ledger (GL), Oracle Inventory (INV), Accounts Payables (AP), in support and development projects.
• Experience in Procure to Pay life cycles.
• Knowledge on PIM module.
• Prepared Technical Specification (MD70) documents based on the (MD50) documents provided by the functional team.
• Used SQL*Loader and UTL FILE for uploading flat file data into Staging Tables.
• Used FNDLOAD utility to migrate concurrent programs, request sets, value sets etc.
• Worked on Outbound and Inbound Interfaces uing API'S and Staging table concepts.
• Responsible for migration of packages and procedures, shell scripts and SQL*Loader files.
• Thorough in usage of various Oracle API’s and Interfaces to convert data from an existing system to Oracle Apps.
• Expertise in Oracle Forms personalization, Customization, Interfaces, conversions & Performance Tuning.
• Expertise in Oracle RICE technologies.
• Very strong in full suite of Oracle Tools including Forms 10.1/9.0/6i, Reports 10.1/9.0/6i, OA Framework, PL/SQL, SQL Loader, FNDLOAD.
• Expert in System Administrator and Application Developer responsibilities.
• Excellent communication and presentation skills.
• Skilled in Designing Business Process and Notification mailers using Workflow Builder 2.6.
• Ability to identify root causes of problems and consider both long and short-term impact of proposed solutions and develop workable solutions along with excellent communication and interpersonal skills.

TECHNICAL SKILLS

ERP: Oracle Applications 12i versions 12.1.2, 12.1.3/11i E-Business Suite (EBS) versions 11.5.9, 11.5.10

RDBMS: Oracle 8i / 9i / 10g / 11g

Apps Modules: Oracle Purchasing (PO), Accounts Payables (AP), iProcurement, iSupplier, iExpense, Procure-to-Pay (P2P) cycle, Workflow, General Ledger (GL), Knowledge on SLA, Approval Management Engine (AME), Billing / Costing, Fixed Assets (FA), Oracle Applications Framework (OAF), ADF Business Components, XML/BI Publisher, Inventory (INV), Application Object Libraries (AOL), PIM, Oracle Alerts, Oracle User / System Administration

Methods: Applications Implementation Methodology (AIM), Rapid Application Development Methodology, Software Development Life Cycle (SDLC), Sarbanes-Oxley compliance (SOX), Gap Analysis

Tools: TOAD, SQL*Plus, Workflow Builder 2.6.4, Forms 10g Builder, Reports 10g Builder, XML/BI Publisher, Jdeveloper 10.1.3.3.0, Perforce PVCS (code version controller), Unix-Box, Unix shell scripting VI Editor, AR System’s Remedy Support Tool

PROFESSIONAL EXPERIENCE

Oracle Customer Online (OCO) Customization

Confidential, Northfield IL

Responsibilities:

• Gathered requirements for Oracle Customer Online customization OCO module.
• Customization done to avoid duplicate Person Credentials on OCO profile page for main Party Person. Created extension of controller for Stack layout for this requirement using personalization. Duplicate entries tracked using PPR.
• Customization done for Business purpose effective dating where Effective start and end date was customized fields added using personalization. Using Controller Extension PPR events were tracked of Remove and Add Purposes. Changes of Business purposes were tracked and showed in History which again was a customization. Created customized stack layout to show history.
• Making available relationship organization’s address while creating account sites for this LOV VO extension was done.
• List Organization sites on main party person this requirement was achieved by VO extension.
• Not to remove site of main party person or organization if site removed from account. This was achieved by Application Module AM extension and Controller extension.
• Done customization of OCO pages in Oracle Application Framework (OAF) using JDeveloper in Oracle Application.
• Developed search record, Lov, delete, update, create new record and submit record of OAF Pages.
• Created extensions / customizations of ADF business components i.e. View Objects (VO) and Application Module (AM) in OAF page.
• Done extensions of Controllers to achieve business events.
• Used JDeveloper for additional functionality and GUI enhancement in Oracle Application Framework (OAF) to implement adding business processes.
• Created Partial Page Rendering (PPR) events.
• Written Business logic in JAVA in ADF Business Components (BC4J) i.e. Application Module (AM)
• Development done using Model View Controller (MVC) Architecture
• Developed custom OAF pages using Jdeveloper right from scratch. Used SPEL and PPR.
• Developed XML Publisher reports.
• Developed validation rules based on business requirements.
• Created custom tables and maps them with Oracle tables to capture additional customize data.

Environment: Oracle Applications R12.1.3, Oracle Customer Online (OCO), TCA, PL/SQL, SQL*Plus, Oracle Applications Framework (OAF) Ver. 12.1.3, Jdeveloper 10.1.3.3, SQL*Developer, UNIX, Windows 7, Java

Oracle 12i Interface Development

Confidential, Washington - DC

Responsibilities:

• Created As-Is process flows and gathered requirements for FedTraveler system to integrate it with Oracle PO, AP and GL Applications.
• Developed Web pages in Oracle Application Framework (OAF) using JDeveloper to integrate custom application and Oracle Application.
• Developed search record, Lov, delete, update, create new record and submit record OAF Pages.
• Created ADF business components i.e. Entity Object (EO), View Objects (VO) and Application Module (AM) in OAF page.
• Design and developed iExpense Report Details XML OAF Page to show GL all segments and description.
• Create iExpense Report User Interface OAF page similar to seeded on but hide and show certain details depending on the Expense type.
• Used JDeveloper for additional functionality and GUI enhancement in Oracle Application Framework (OAF) to implement adding business processes.
• Created Partial Page Rendering (PPR) events.
• Written Business logic in JAVA in ADF Business Components (BC4J) i.e. Application Module (AM)
• Development done using Model View Controller (MVC) Architecture
• Check of Funds Availability (COFA) design and coding for Comprizon interface to Oracle PO, GL Applications.
• Developed custom OAF pages using Jdeveloper right from scratch. Used SPEL and PPR.
• Developed XML Publisher reports.
• Developed validation rules based on business requirements.
• Designed and developed Federal Funds Check process which is integrated to Oracle General Ledger and PO modules.
• Designed and developed Traveler Authorization interface process using standard Oracle Purchasing interface.
• Designed and developed Travel Voucher process using Oracle AP interface.
• Created staging tables and maps them with Oracle interface tables.
• Developed reconciliation reports using Oracle reports 10g on modules AP, PO, GL to facilitate the users in validating the interfaced data.
• Developed SQL*Loader files to load data from legacy system into the Account Receivables (AR) staging tables for importing Customer data.
• Created a process for order import using standard API for validating data and update the Base tables.
• Created SQL*Loader control programs and PL/SQL validation procedures to execute along with Customer Interface (AR), and Order Import Interface (OM) programs to support the interface requirements.
• Developed BI Publisher reports using BI templates.
• Developed RICE components.
• Designed and customized On-hand Quantity reports, Purchase Order Report using Oracle Reports Builder 10g, XML/BI Publisher.
• Developed the Notification mail using workflow.
• Prepared the TDD (Technical Design Document) based on the FDD (Functional Design Document).
• Develop various PL/SQL packages for use by the entire development team to meet generic requirements like Mailing, Excel File generation etc.
• Developed concurrent programs and scheduled jobs as per the requirement.
• Developed concurrent programs & set incompatibilities as per the requirement.
• Personalized the Transactions, Sales Order forms.

Environment: Oracle Applications R12, AR, AP, PO, GL, INV, TCA, PL/SQL, SQL*Plus, Oracle applications framework (OAF) Ver. 12.1.2, Jdeveloper 10.1.3.3, workflow, SQL*Developer, Reports 10g, XML /BI Publisher, UNIX, Windows NT, Java, TOAD.

Oracle Workflow Implementation

Confidential, Erie, PA

Responsibilities:

• Successfully completed the challenge to work under enormous pressures against a steep deadline
• Played multiple roles in the project including that of a business analyst, a technology and database consultant, a workflow and apps developer, a team lead, owner of the workflow change and release management
• Hands on participation in each and every phase of the project starting with requirement gathering, feasibility study, database designing, application designing, design reviews, actual development, application testing, documentation, end user training and finally ongoing application support
• Used the skill in identifying and analyzing business requirements and providing wide range support which included process mapping, gap analysis, setups, data conversion and validation, report customization, user acceptance, end user training and implementation in a multi org environment
• Developed OAF Pages for Supplier Details, Supplier Bank Accounts Details, Supplier Financial Details, Business Activities, list of Mandatory documents attachments in OAF using JDeveloper 10.1.3.3
• Developed Supplier registration Web pages in Oracle Application Framework (OAF) using JDeveloper
• Developed search record, Lov, delete, update, create new record and submit record OAF Pages.
• Created ADF business components i.e. Entity Object (EO), View Objects (VO) and Application Module (AM) in OAF page.
• Used JDeveloper for additional functionality and GUI enhancement in Oracle Application Framework (OAF) to implement adding business processes.
• Created Partial Page Rendering PPR events.
• Written Business logic in JAVA in ADF Business Components i.e. Application Module (AM)
• Developed 9 PLSQL packages having thousands of lines of SQL code to implement the custom Oracle workflows
• Worked on designing the custom application interface to send data to Oracle interface using standard APIs
• Modified the POXPOPDF - Print Purchase Order Report with custom PDF template to display GE info on the PO using XML Publisher responsibility. Also, modified the PO approval workflow which generated this report
• Wrote custom PLSQL procedure to validate and then interface the data from supplier on boarding application to Oracle Payables and Oracle Purchasing using the standard Oracle interface tables AP SUPPLIERS INT and AP SUPPLIER SITES INT and standard interface programs Supplier Open Interface and Supplier Sites Open Interface Import concurrent programs
• Overcame the challenge of sending workflow notifications to multiple roles by introducing the concept of role creation in workflow by using Oracle Standard APIs WF DIRECTORY.CreateAdhocRole, WF DIRECTORY.AddUsersToAdHocRole and WF DIRECTORY.RemoveUsersFromAdHocRole
• Designed and developed the custom functionality for creating Oracle workflow roles and adding people to it which is used across global GE Oracle Applications instance
• Created a concurrent program to create or disable an Oracle workflow role on adhoc basis by inputting parameters like role name and description
• Created a concurrent program to add or remove people from the Oracle workflow roles on adhoc basis by inputting parameters like user name and role name
• Created the backend PLSQL procedures to put the parameter validations in above concurrent programs
• Developed a BI Publisher report to show the supplier and site details along with the relationship between contacts and GE contacts
• Used WFLOAD UNIX command to load the workflows into the database and preserve customizations
• Customized PO approval workflow to send a custom supplier collaboration report as an attachment with the PO approval notification to be sent out to the suppliers
• Prepared SQL seed data script to fulfill the GE hierarchy requirements of multi-level approval rules based on business unit and commodity combinations
• Created database objects using SQL, PLSQL like tables, views, sequences, indexes, triggers, cursors etc
• Performed the DML SQL query data cleansing on the existing GE supplier data by removing duplicate and old records and invalidating end-dated suppliers
• Designed and created approval notifications displaying the key supplier data fields to be shown to the internal GE approvers and separate notifications to be shown to external suppliers containing supplier on boarding application URL in it
• Resolved the issue of data security by adding the logic in design to send a unique URL to the external suppliers so that the email notification and the application link is accessible only to the intended supplier
• Performed the business unit mapping of the on boarding application with the operating units in Oracle
• Created and managed the AIM based documentations like MD 50 for functional specifications and the MD 70 for the technical mapping of the MD 50
• Used the migration and version management tools like Kintana and VSS to migrate the PLSQL code from development instance to staging instance and then finally to Production instance in a planned fashion and by sticking to associated timelines
• Part of the effort involving ITIL processes and integrated service delivery
• Owner of the workflow implementation involving configuration management, change management, incident management, release management and problem management at GE
• Performed Application Object Library (AOL) setups for FND Lookups, creating profiles, creating or excluding menus, creating responsibilities, value sets etc
• Developed the Oracle interface error handling process for sourcing users to show interface error details on screen, giving option to retry the failed lines from the interface or do a manual entry instead
• Developed a supplier master file BI publisher report and associated RTF template to show data corresponding to one supplier’s header, site, commodity, questionnaire and banks. Used DBMS XMLGEN PL/SQL package to extract data in XML format directly from PLSQL
• Performed the BI publisher setups using the XML Publisher Administrator responsibility
• Customized PO Create Document workflow to accommodate the business requirement to notify requisition preparer if the information entered is not enough to auto-create a PO from the requisition. Made changes in PO AUTOCREATE DOC procedure and created preparer notification in the workflow using Oracle Workflow Builder 2.6.3.5
• Did Oracle Application Framework (OAF) personalization to hide few fields from the custom form
• Developed the supplier collaboration supplier on-boarding application based on Agile scrum methodology with rapid changes in business requirements and processes

Environment: Oracle Applications R12, AR, AP, PO, OM, GL, INV, iSupplier, OAF, TCA, PL/SQL, SQL*Plus, Reports 10g, XML/BI Publisher, Workflow, SQL*Developer, VSS, UNIX, Windows NT, Java, JDeveloper, TOAD.

ERP System in Aviation Sector

Confidential

Responsibilities:

• Worked on Financials, Billing, Sales order, and Purchasing and Machine Routing operation system.
• Customization and Enhancement in Sales order system.
• Customization and Enhancement in Machine routing system.
• Developed Parts tracking system for small parts routing system.
• Auto email notification system when sales order are created or modified.
• Tracking of leased parts and sending email notifications.
• Created various reports for Financials, Billing, Sales orders and Machine Routing system.
• Developed OAF Pages for HR Policy documents attachments in OAF using JDeveloper 10.1.3.3
• Developed OAF pages for Quick Applicant.
• Converted Invoices from Legacy System into Oracle Receivables using Auto Invoice Import program.
• Created SQL*Loader control programs and PL/SQL validation procedures to execute along with Customer Interface (AR), and Order Import Interface programs to support the interface requirements.
• Created and configured staging tables to receive and process files sent by EDI for Order-To-Cash implementation: (Invoices, Sales Order).
• Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
• Created a process for order import using standard API for validating data and update the base tables.
• Run Journal Import in General Ledger (GL) to load the data into Oracle application tables.
• Prepared the TDD (Technical Design Document) based on the FDD (Functional Design Document).
• Developed BI Publisher reports.
• Developed XML templates according to customer’s requirements and required format based on Oracle.
• Developed RICE components.
• Involved in creating parameters in data template file according to the requirement.
• Developed several custom workflows.
• Primary point of contact with the client for technical issues.
• Analyzing the change requests whether the scenario is feasible and helping the team in incorporating the Change Requests.
• Responsible for fixing of various Day-to-Day as well as Development/ Enhancement Issues.
• Responsible for developing and reviewing the issue resolution documents.

Environment: Oracle Database 10g, Oracle Applications 11.5.10, AR, AP, GL, OM, INV and PO, SQL, PL/SQL, SQL*Plus, SQL*Loader, Forms 10g, Reports 10g, XML/BI Publisher, XML Publisher, TOAD, UNIX, Windows XP.

Confidential

Lab Equipments and Analytical

Responsibilities:

• As a Project Leader performed the system requirement gathering, Requirement Analysis, Technical Review, Designing, Programming, Presentation, Testing and documentations.
• Implemented 3 tier Architecture Presentation Layer, Business Logic Layers, and Data Access Layers using object oriented programming C#/ASP.NET for both front & back end development.
• Designed and developed dynamic XML based web pages for Confidential .
• This unique project was designed to login into application for three different databases: Oracle, SQL Server 2005 and Access.
• Wrote extensive business logic using C# Coding, SQL Server 2005 Database and T-SQL.
• Extensively used ASP.NET for developing web pages for WSL Project.
• This project was to develop report engine tool for Chromatography machines.
• Gave IT support to gas and liquid chromatography machines to perform the testing of gas and liquids in forensic department labs and pass the data to computer.
• Developed various kinds of reports for the business users to give detailed analytical and graphical representation based on the above generated data.
• Created reports using Visual studio with Crystal Reports.

Environment: Windows Server 2003, Microsoft SQL Server 2005, Visual Studio 2005, .NET Framework 2.0, ASP.NET, C#, ADO.NET, XML, JavaScript, CSS, Oracle9i, Access, Crystal Reports.

Confidential

Responsibilities:

• As a Project Leader performed the system requirement gathering, Requirement Analysis, Technical Review, Designing, Programming, Presentation, Testing and documentations.
• Implemented 3 tier Architecture Presentation Layer, Business Logic Layers, and Data Access Layers using object oriented programming C#/ASP.NET for both front & back end development.
• Designed and developed dynamic XML based web pages for Confidential .
• This unique project was designed to login into application for three different databases: Oracle, SQL Server 2005 and Access.
• Wrote extensive business logic using C# Coding, SQL Server 2005 Database and T-SQL.
• Extensively used ASP.NET for developing web pages for WSL Project.
• This project was to develop report engine tool for Chromatography machines.
• Gave IT support to gas and liquid chromatography machines to perform the testing of gas and liquids in forensic department labs and pass the data to computer.
• Developed various kinds of reports for the business users to give detailed analytical and graphical representation based on the above generated data.
• Created reports using Visual studio with Crystal Reports.

Environment: Windows Server 2003, Microsoft SQL Server 2005, Visual Studio 2005, .NET Framework 2.0, ASP.NET, C#, ADO.NET, XML, JavaScript, CSS, Oracle9i, Access, Crystal Reports.

Confidential

Mate GUI Cheq

Responsibilities:

• Involved in Coding using Magic 5.7, Magic 8.3, Magic 9.4,
• Involved in implementation and Support of Cheqmate TBC and Core Banking Solution
• Involved in Oracle 9i SQL and PL/SQL development wrote procedures for various reports.
• I was involved in development of various modules like Term Deposits, Term Loans, General ledgers, Savings, Cash Credits, Overdrafts, Remittances, Clearing Standing instructions, Lockers, BG, LC, Inter branch Reconciliation and Day End process for these modules.
• Deploying product on client side and giving technical support.
• I am also involved in giving Technical as well as functional training to members who work with me.
• Testing of the project.
• Implementation on the client side Giving Support after implementation
• I was also involved in Data migration of various third parties banking software like Onward, Nelito, TCS, Petasoft, Kale Consultancy, Virmati Software’s. to Cheqmate
• Wrote programs for data migration using Magic 5.7 Magic 8.3.
• Developed conversion utilities for all third parties banking software.
• Involved in actual data Migration & Conversion activity for migrating all third party software data to CheqMate data,
• Cross verifying the data to ensure all the data has been converted.
• Wrote programs for reporting purpose to verify and validating of data and tallying the General Ledgers data.
• Testing of the Cheqmate on migrated data
• Implementation on the client side
• Giving Support after implementation.
• Clients include Central bank of India, Dena Bank, Allahabad Bank, Uco Bank, OBC Bank, UBI and Other Major Nationalize and Cooperative banks.

Environment: Operating Systems Windows Novel Netware 4.20, HP UNIX, SCO UNIX 5.60, Windows, Front End Magic Version 8.3, Magic Version 5.7 Back End Btrieve, CISAM, Oracle 7.3, Oracle 9i, J2EE, JAVA