PROFESSIONAL SUMMARY:

• 12 Years of Oracle Applications experience - specializes in the development of Oracle software solutions utilizing expertise in requirements definition, business analysis, design, systems integration, and implementation
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, work arounds, interfaces, user
• Developed functional(MD50,CV40) and technical(MD70,CV60) specifications as well as test plans(UTP) and test scenarios using AIM methodology
• Good Experience in implementing Order-to-Cash and Procure-to-Pay Business Process flows
• Good Experience in Oracle CRM Foundation (Install Base, Service Contracts, Filed Services and Depot Repair)
• Strong experience in customizing applications using OAF, JTF, Java, JSP, ADF and JSF
• Over 12 years of experience in Implementation and RICEFW Customization/Development of Oracle Applications 11.5.7/11.5.9/11.5.10 and Release 12 modules such as AP, AR, GL, PO and expenses
• Successfully upgraded 11i OPM modules (Inventory, Development, Execution, Costing and Quality) into R12
• Good experience customizing and personalizing approvals using Oracle Approval Management (AME)
• Good knowledge of the TCA (Trading Community Architecture) model architecture in 11i & R12
• Has very good experience in customizing existing OAF Screens, forms and reports as per business needs using OAF Substitutions, custom PLL's, Forms Personalization's respectively
• Experience in the preparation of Functional Design, Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces, Reports, Forms and Customizations
• Experience in database programming using Oracle 8i/9i/10g/11g databases
• Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes
• Experience in various development tools like SQL Developer, SQL*Loader, Oracle Developer 10g/9i, Forms 10g/6i, Reports 10g/6i
• Experince in working ETL and Oracle OBIEE project integrations with Oracle R12
• Proficient in Oracle Application Express 4.0, 42, Java Script, HTML, XML, CSS, SQL and Oracle 11g/12C
• Experience in developing UNIX Shell scripts for loading data into staging tables
• Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace
• Experience in developing reports from Oracle Report Builder, Discoverer Tool and BI Publisher(XML)
• Experience in development, customization of Views, folders for Discoverer Reports 10g/9i/4i and well versed in Discoverer Administrator, Discoverer Desktop and Discoverer Viewer
• Experience working within an agile development process (Scrum, XP, Kanban, etc.)
• Experience with Source version control tools like VSS, PVCS, SVN and Kintana
• Excellent communication skills, adapt in client interaction and understanding business applications
• Pro-actively identify areas of opportunity and work to finding solutions that meet the business needs of the customer
• Absolutely capable of working in a fast paced, dynamic, team-oriented environment with 24x7 support

TECHNICAL SKILLS:

Oracle Apps11i & R12: ERP Modules Oracle Receivables, Inventory, Order Management, Purchase Order, Oracle Projects, Oracle Pricing Manger, Bill of Materials, Work in Process, iProcurement, iExpenses, HCM/HRMS, Forecasting and OPM Modules (Inventory, Product, Execution and Quality)

Foundation Modules: Oracle Alerts, System Admin, Application Developer.

Oracle Tools: Oracle Developer, Workflow2.5/2.6,SQL*Loader, Form Builder 6i/10g, Oracle Enterprise Manager, JDeveloper 10g.

Databases: Oracle 7/8/8i/9i/10g/11g, MS Access

Reporting Tools: Report Builder, Discoverer and XML Publisher

Languages: C, C++, PL/SQL and Java

Operating Systems: UNIX (SUN Solaris, SUN OS, HP9000), Windows NT/2000/XP

Exposure To: XML, Java Script

Application Tools: Microsoft Visio/Projects/Power pointer/Access

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, TX

Platforms: Oracle Applications R12

Oracle Integration Lead

Responsibilities:

• Developed a custom Star Retail Application using OAF. Using Star Retail Application GMF borrow the loans from investor by keeping Retail loans as collaterals
• Developed Retail Pool Cut custom page using Jdeveloper (OAF)
• Extended OAF Supplier page, automate Supplier number even setup made supplier number manual generation. This extension is required since some suppliers come from daily interface and they used legacy supplier number but when oracle user creates supplier then the number should auto populate.
• Personalize OAF Supplier page, Supplier site alternate code should be visible in supplier site region
• Oracle Application Framework (OA Framework) to create and approve transactions related to Non-Appropriate Funds for the activities at various bases. This involved architect, design and developments of around 20 complex new UI custom forms, creating secured data views augmenting existing Oracle Application. Created new form functions and assigned OAF screens developed, sub-menus, menus and based on the user roles. Created new custom top menus and assigned to new custom responsibilities. Used MVC design patterns and created Entity object (EO), Entity Associations, View Objects (VO), View Links, Regions, Pages, Page Controllers and Application modules (AM) to maintain Transactions context when the transaction flow spans multiple page.
• Extended iProcurement requisition OAF page Expenditure type LOV VO to add project id as additional field

Confidential, Irving, TX

Platforms: Oracle Applications R12

Sr Lead Developer

Responsibilities:

• Developed Order Summary program to show a report finished item and row items consummation
• Developed an interface for employee outbound to Kronos system in Oracle HR
• Developed an interface for payroll outbound to ADP in Oracle HR
• Developed an interface for ADP expenses inbound to Oracle GL
• Developed a bank statement interface program in Cash Management
• Developed approval rules based on invoice amount for the following transaction type Payables Invoice
• Approval using Oracle Approval Management (AME) and configured action types and actions and set up the profile option to work for Payables only and also the required setup through Payables Options form

Confidential, Irving, TX

Platforms: Oracle Applications R12

Modules: Inventory, Purchasing, Order Management, CRM, OPM and HR modules

Sr Lead Developer

Responsibilities:

• Developed custom pick lease and custom pick confirm form (Order Management)
• Developed extension program to split order line (Order Management)
• Developed extension program to add backorder line to ready to release line (Order Management)
• Developed lot split program to split lot for lot individual items
• Developed program to assign item to child inventory org and restricting sub inventories
• Developed a custom program to calculate OPM lot costing based on metal content percentage
• Developed a custom program to add freight charges from PO to Landed cost management module
• Customized OPM Simulator form to show customer specification min, max and target values of metal contents.
• Customized Select available inventory form to show Quality results for each lot
• Customized Process manufacturing make to Order program to reserve more qty and increase batch qty
• Developed extension program to capture shipping cart no# and freight charges from IBM WebSphere MQ system (External supplier) to Purchase order line DFF

Confidential, Boca Raton, FL

Modules: Project Accounting, Field Services and Depot Repair (CRM)

Onsite Technical Lead

Responsibilities:

• Developed SMAI Interface to Legacy
• Developed one time reversal report
• Developed Progress billing data transfer report
• Developed Material Frontend load report
• Developed SSO Change report
• Developed extension program to create field service de-brief header and lines using CSF DEBRIEF PUB
• Developed Interface program to create repair orders that comes from legacy system (scheduled program) using CSD REPAIRS PUB

Confidential, NY

Platforms: Oracle Applications R12

R12 Integration Lead

Responsibilities:

• Developed an interface program to sync supplier, sites and contacts information from Microsoft Dynamics to Oracle R12
• Developed an interface program to sync supplier bank, braches and accounts information from Microsoft Dynamics to Oracle R12
• Developed an interface program to sync supplier invoice information from Microsoft Dynamics to Oracle R12
• Developed an outbound interface to sync supplier invoice payment information (Check and ACH) from Oracle R12 to Microsoft Dynamics
• Developed forms to perform mass update of WIP Attributes (Supply type, Locator and Sub Inventory) in BOM for Kanban Items that are maintained at organization level in Common BOM
• Developed an Interface program to load item master data from MQ messages.
• Customized OAF iSupplier Portal Home Page by adding summary stack layout region ( Display Hold, process and Reject invoices count)
• Customized OAF iSupplier Portal Account page by adding hold filed in query region

Confidential, Irving, TX

Platforms: Oracle Applications 11i and R12

Modules: Inventory, Purchasing,CRM, OM, WIP, BOM, GL, AP, PA

Sr Distributions Consultant

Responsibilities:

• Developed Hedging Application using Oracle Forms 6i
• Developed Hedging rollover application using Oracle Forms 6i
• Developed AP extension program to capturing Freight cost for Drop ship orders
• Developed Project conversion in PA module
• Developed Open PO conversion in PO
• Developed program to capturing the planning on the requisitions( DFF)
• Customized Sales order line workflow to populate currency exchange rate
• Customized purchase order workflow to populate currency exchange rate
• Customized Supplier OAF page to populate custom supplier number using JDeveloper
• Developed conversion programs for Items and Service Contracts using Oracle PL/SQL and Standard APIs
• Developed a concurrent program to create depot repair orders using CSD REPAIRS PUB API (CRM)
• Developed custom reports to show Field services requests and priorities using Oracle BI (CRM Field service)
• Inter-track dependency evaluation and discussion holding with Common Objects (Master data management) and Service Sales (Field Service) tracks of Siebel CRM.
• Developed Hedging variance report using Discoverer
• Developed Hedging Rollover data report using Discoverer
• Developed hedging Sales order summary report using Discoverer
• Modified Custom BOM Details report to add Approved Supplier Information
• Developed BOM-WORKORDER Variance report for exceptions messages
• Formulated SQL queries, functions and processes as per customization requirement for APEX
• Supported APEX applications and conducted performance tuning for PLSQL
• Contributed with database designs and assisted in increasing response time for APEX reports

Confidential, Ontario, CA

Platforms: Oracle Applications R12 Rollout

Data Conversion Lead

Responsibilities:

• Item conversion, Item cross s and Item category assignment conversion
• OPM Formula and Recipe conversion
• Open purchase orders conversion
• Purchase order history conversion
• Approved supplier list conversion
• Sourcing rules and assignment and Stock locator conversion
• Developed Order import program to convert legacy orders into oracle applications
• Converted AR Open invoices, AR Credit memos and AR Debit Memos
• Converted customers from legacy to oracle R12 (TCA)
• Converted customer ship to and bill to address from legacy to oracle R12 (TCA)
• Converted Oracle Service Contracts from 11i to Oracle R12(CRM)
• Developed OPM Redistribution process for extending physical inventory process
• Developed OPM Onhand balance report for RAW materials
• Developed an Interface to load manually entered GL Journal Accrual Entries into Projects.
• Designed and developed a program to convert Bill Rate Schedules of Project Accounting.
• Created an interface program to convert purchase orders.
• Developed OPM lot costing calculation program when batch get completed

Confidential, Irving, TX

Platforms: Oracle Applications 11.5.10.3 and R12 Upgrade

Techno-Functional Consultant

Responsibilities:

• Developed Dropship sourcing rules and assignment conversion in Purchasing module.
• Developed Approved supplier Conversion
• Developed of Analysis report(COA) is used to send the customer along with items
• Developed Forecast creation program to create forecast designators and buckets assignments.
• Developed Open PO Conversion program to upload Supplier info from legacy system to AP
• Developed Stock Export Workbench for Customer Export Orders using Oracle Forms 10g
• Developed Freight Quotation form for tracking freight charges using Oracle Forms 10g
• Develop interface program to create multiple projects using oracle api
• Develop interface program to update existing projects and deleting projects
• Develop conversion program to create project billing events
• Develop program to validate project and project tasks
• Developed Draft Invoice Generation Report in project accounting
• Developed extension program to close trips automatically by using oracle interface trip stop API.
• Modified BOM form to enable DFF to store BOM Diagram details and interface is provided to display the diagram

Confidential

Platforms: Oracle Applications Release 12

Techno-Functional Consultant

Responsibilities:

• Developed FA Common Routines extension program
• Developed PA Asset creation program for expenditure items
• Developed Oracle Process Manufacturing (OPM) Oracle Discreet Manufacturing (ODM) Inventory Transfer Program
• Developed WEB ADI Program for Price List creation and update
• Developed extension program to submit custom pick list program while doing order pick release
• Develop interface program to create multiple projects using oracle api
• Develop interface program to update existing projects and deleting projects
• Develop conversion program to create project billing events
• Develop program to validate project and project tasks
• Developed Draft Invoice Generation Report in project accounting
• Developed an Interface to load Legacy Asset information into Oracle Assets
• Developed extension program to close trips automatically by using oracle interface trip stop API.
• Developed a program to pull the batches and process them in OPM from planning module
• Used AMG (Activity Management Gateway) in Project Accounting and developed a script to load Projects data into Oracle Projects
• Customized Additions by Source Report in FA
• Customized Annual Additions Report in FA
• Customized Purchase Order Print Report in PO
• Developed Invoice Class Details Report
• Developed Vendors Invoice Details
• Developed Concurrent program summary report
• Developed BOM Conversion Exception Report
• Developed Item Category Assignment conversion program in Inventory
• Developed BOM Routing Conversion program to upload Routings into BOM Module
• Developed Vendor Conversion program to upload Supplier info from legacy system to AP
• Developed Complex Discoverer reports for order intelligence
• Discoverer Administration Activities (like EUL privileges, Creating Folders).
• Developed Discoverer Worksheet and register in Oracle Applications
• Customized Requisition Approval seeded workflow in Purchasing Module
• Customized Book order seeded workflow in Order Management