PROFESSIONAL SUMMARY:

• Having 10 yrs of Experience in Oracle Apps R12 and Oracle Apps 11i.
• Successfully completed 3 upgrades from 11i to R12
• Successfully upgraded 11i OPM modules (OPM Inventory, Development, Execution and Quality) into R12
• Experience in 5 full life cycles of implementation projects in Oracle applications, including the technical and functional support.
• Having experience in onsite/offshore model.
• Successfully implemented Oracle Project Accounting, Costing and Billing modules in R12
• Experience with Oracle 10g OBIEE
• Experience in AP Checking printing in R12
• Experience in ETL(Informatica)
• Experience in customizing ADF applications
• Experience in developing custom ADF applications
• Experience in Oracle SOA 11g Suite
• Experience in BPEL, Human Tasks, Business rules and adapter
• Expertise on developing RICEF objects on Oracle Apps 11i and R12
• Experience in development & customization of forms, reports and workflow
• Experience on upgrading oracle applications from 11.0.3 to R12
• Excellent experience in Oracle Forms 6i/10g.
• Functional exposure to Distribution and financial modules - Inventory, Purchasing, Order Management, Oracle Process Manufacturing (OPM) and Forecasting, General Ledger, Project Accounting, Account Payables, Treasury and Account Receivables
• Successfully implementation of Procure to Pay (PTP), Order to Cash (OTC) and Forecast to Pricing (FTP) Modules.
• Having experience in Retail Marketing Industry( Worked in Dunkin and Confidential )
• Having Good Exposure in Oracle AIM Methodology (Functional Design, Technical Design and Installation Document)
• Experience in developing reports from Oracle Report Builder, Discoverer Tool and XML Publisher.
• Experience in using WEB ADI Tool
• Worked with development, customization of Views, folders for Discoverer Reports 10g/9i/4i and well versed in Discoverer Administrator, Discoverer Desktop and Discoverer Viewer
• Expertise in SQL * Loader programming for Inbound process in Oracle Applications
• Expertise in PL/SQL and SQL programming.
• Expertise in Shell scripting in Unix
• Extensively used MS Word, Visio for documentations and diagrams, and Excel spread sheets for reporting.
• Technical leadership with responsibility for delivering technical services and delivery of on-time quality. Act as a technical liaison with project team members and managers to drive the Technical aspects of project delivery.
• Ability to effectively gather and refine the requirements from users and management, proficient troubleshooting skills. Ability to manage time spent on multiple projects to meet deadlines, work independently and as part of a team.
• Self motivated and dedicated fast learner with good communication and interpersonal skills.

TECHNICAL SKILLS:

Oracle Apps11i and R12: ERP Modules: Oracle Receivables, Inventory, Order Management, Purchase Order, Oracle Projects, Oracle Pricing Manger, Bill of Materials, Work in Process, 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.

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

Reporting ToolsReport 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, Irving, TX

SCM Track Lead

Responsibilities:

• Developed custom pick lease form (Order Management)
• Developed 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 custom import program for AP invoices
• Developed program to assign item to child inventory org and restricting sub inventories
• Developed Oracle Alerts for MFG system to send email notifications
• Customized AP Check Printing Report

Confidential, Irving, TX

Sr Distributions Consultant

Responsibilities:

• Followed Oracle AIM methodology and thus involved in creating process documents such as CV070, MD070, MD050, MD120 etc.
• Responsible for handing extension component (Forms,PL/SQL Packages and workflow) in Manufacturing modules
• Responsible for distributing the work and tracking the status of the components on the daily basis.
• Review the design documents and code as per the MD50 and MD70.
• Handling a technical team and helping them to make quality of work
• Involved in the complete process of each extension done and tested in live instance.
• Involved in technical Conference Room Pilot sessions.
• Supported the team to fix the Conference Room Pilot scenarios and created the corresponding AIM documents.
• Developed workflows from scratch
• Customized seeded workflows in Order Management and Purchasing Modules
• Creating technical designs (MD70) for RICEF
• 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
• Designed and Developed Project Accounting Conversion from 11.0.3 to 11.5.10.
• As part of the Conversion of Project Accounting conversion designed and developed the programs to convert, Projects, Tasks, Budgets, Agreements and funding, Events and Cost
• Designed and Developed Customers Conversion.
• Build Custom Reports and Conversions from Legacy to Projects using API's
• Write the Auto Accounting SQL based on functional doc and to derive the correct values.
• Developed Hedging variance report using Discoverer
• Developed Hedging Missing documents using Discoverer
• Developed Hedging DTR variance report using Discoverer
• Developed Hedging Rollover data report using Discoverer
• Developed hedging Sales order summary report using Discoverer
• Developed a report to show all the requisitions created from planning module

Confidential, Ontario, CA

Data Conversion Lead

Responsibilities:

• Coordinating team with the client and collecting the business requirements as per statement of work
• Making conversion Technical designs and Unit test scripts
• Responsible for making CV60 for interfaces and gaps
• Daily status meetings and preparation of operational plan
• Creating TD’s for RICEF objects
• Item conversion
• Item cross s conversion
• Item category assignment conversion
• OPM Formula conversion
• OPM Recipe conversion
• Open purchase orders conversion
• Purchase order history conversion
• Approved supplier list conversion
• Sourcing rules and assignment conversion
• Stock locator conversion
• Developed Order import program to convert legacy orders into oracle applications
• Converted AR Open invoices
• Converted AR Credit memos
• Converted 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)
• Custom Physical Inventory Initiation
• Custom Physical inventory close process
• Custom physical inventory count entry form
• Custom Re-distribution process initiation after physical inventory variance calculated
• Custom physical inventory(Old 920) report
• Custom physical inventory(Old 920) all organizations report
• Developed OPM Redistribution process for extending physical inventory process
• Developed OPM Onhand balance report for RAW materials
• Performed the setup of Oracle Projects costing and Billing.
• Performed the setups for Project Accounting, GL and AR.
• Created PSI (Project Status Inquiry) client extension in Project Accounting for ITS service line showing the task Details.
• Developed Profitability Report in PA (Project Accounting), showing the details of Costing, Revenue, Budgets, Variance and profit/loss for a project. The report also created to work for Organization hierarchy.
• 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 while batch get completed

Confidential, Irving, TX

Techno-Functional Consultant

Responsibilities:

• Coordinating team with the client and collecting the business requirements as per statement of work
• Making conversion Technical designs and Unit test scripts
• Responsible for making MD70 for interfaces and gaps
• Daily status meetings and preparation of operational plan
• Responsible for onsite and offshore coordination on object delivery
• Involved in the complete process of each extension done and tested in live instance.
• Involved in technical Conference Room Pilot sessions.
• Creating technical designs(MD70) for RICEF
• 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
• Modified the Item sync up custom program for R12 upgrade
• Developed Bulk formula personal personalization for R12
• Modified all existing OPM Custom components for R12 upgrade
• Modified Load planning document for R12 upgrade
• Modified all the custom reports using opm item master tables for R12 upgarde
• Develop interface program to create multiple projects using oracle api
• Develop interface program to update existing projects and deliting 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
• Interface Assets to 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
• Developed Bank interface to send electronic funds transaction to Bank using EDI

Confidential

Techno-Functional Consultant

Responsibilities:

• Followed Oracle AIM methodology and thus involved in creating process documents such as CV070, MD070, MD050, MD120 etc.
• Responsible for handing extension component (Forms,PL/SQL Packages and workflow) in Manufacturing modules
• Responsible for distributing the work and tracking the status of the components on the daily basis.
• Review the design documents and code as per the MD50 and MD70.
• Handling a technical team and helping them to make quality of work
• Responsible for onsite and offshore coordination on object delivery
• Involved in the complete process of each extension done and tested in live instance.
• Involved in technical Conference Room Pilot sessions.
• Supported the team to fix the Conference Room Pilot scenarios and created the corresponding AIM documents.
• Setup the OPM Modules as based on the approved business process flow.
• Developed workflows from scratch
• Customized seeded workflows in Order Management and Purchasing Modules
• Creating technical designs(MD70) for RICEF
• 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 OPM TO ODM Staging transfer program
• Developed Shipped Sales Order Management for Promo Items Extension program
• Developed Mass Batch Close form for closing multiple open batches at a time in OPM using Oracle Forms 10g
• Customized existing Incremental Backflush form in OPM
• Developed Forecast slicing and prioritization program
• Developed extension program for Publishing Order date, Ship date and Delivery dates
• Developed Extraction program for BOM Routings
• Developed a program to send Oracle (Work in Process) WIP Discreet jobs from Oracle Apps to Image Viewer.
• Blanket Agreement Price Change Program
• Extension Component-Trip Update for Backorder
• 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
• Interface Assets to 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
• Developed Utilization Report breaking it down by Organization, Department and the Project Manager in Project Accounting.
• Developed Interfaces to load the accrual data from Purchasing into PA and GL
• Performed the setup of Multi Org structure.
• Used AMG (Activity Management Gateway) in Project Accounting and developed a script to load Projects data into Oracle Projects.
• Customized Requisition Approval seeded workflow in Purchasing Module
• Customized Book order seeded workflow in Order Management

Confidential

Responsibilities:

• Assigning and tracking the status of the object and ensuring smooth delivery
• Providing technical help to the resources
• Designing documents of functional requirements and technical approach
• Trained resources on discoverer tool
• Created host programs using UNIX shell scripting.
• Oracle PL/SQL developer and involved in writing complex SQL queries.
• Incorporating the requested customizations and enhancements on Oracle Reports and Oracle forms related to Oracle Payables, Oracle Receivables and Oracle General Ledger.
• Developed SQL and PL/SQL reports.
• Hands on experience with Oracle Discoverer.
• Documenting all the development work done by the team and also review the documents prepared by peer.
• Performed the unit test cases for each request before production move.
• Solved any high severity production issues when raised by the users including SQL query tuning.
• Developed fresh Oracle reports and Oracle forms as per the business requests.
• Provided functional support on Oracle Manufacturing and Oracle Finance modules.
• Made Technical Designs(MD70) based on function document(MD50)
• Created UTP’s for the all the extension and discoverer reports
• Creating technical designs(MD70) for RICEF
• Developed Outstanding Purchase orders report
• Developed preferred supplier status report
• Developed Invoice Hold exception report
• Developed Supplier spend report against to PO
• Developed supplier spend report against to Profit Center
• Developed supplier spend report against to Item Category
• Customized Sales Order Acknowledgment report in OM
• Customized Packing Slip report
• Customized RFQ Summary report
• Developed ISO IR Details summary report
• Developed Drop shipment info report
• Developed Material Transaction details report
• Developed Interface program to upload journals from legacy to General Ledger
• Developed interface program to upload items from legacy systems to Inventory
• Developed receiving interface program in Purchasing Module

Confidential

Responsibilities:

• Responsible for development and customization of various fast formulas.
• Involved in customization and bug fixing operations of various in out bound interfaces.
• Involved in customization and development of Oracle reports.
• Designed various technical (MD70) and Installation documents (MD120).
• Writing minor UNIX shell scripts to run reports and generate the output files in the server.
• Worked on Advanced Supply Chain Planning, Oracle Demand Planning, Global Order Promising, Manufacturing Scheduling, Forecasting OPM Regulatory Management and BOM Forecasting.
• Creating technical designs(MD70) for RICEF
• Extraction of Open PO from legacy oracle systems
• Extraction of Active Suppliers, sites and contacts from legacy oracle systems
• Extraction of Approval Group Assignments from legacy oracle systems
• Extraction of Approval Rules from legacy oracle systems
• Shipping Extraction Outbound interface

Confidential

Responsibilities:

• Creating technical designs(MD70) for RICEF
• Developed Shipping Bill (Ex-Bond,Dutry Drawback, Duty Free, Dutiable)Dispatch Bolton Module
• Developed Permission Letters
• Developed Form55 Report
• Developed Airway bill and CTM Airway Bill
• Developed Commercial Invoice Report
• Developed Cargo Dispatch Sheet Report
• Revenue Document Serial Number Generation using Oracle Forms 6i/10g
• Material Dispatch Request Selection Workbench using Oracle Forms 6i/10g
• Material Dispatch Request Initiation using Oracle Forms 6i/10g
• Inbound interface it will import all the Internal Requisitions which are having Internal Sales order, Supplier Returns and Inter Org Transactions to Oracle Dispatch Module (Bolton).
• Updated the Consignment Flight details from Cargo Tip Systems (Mainframes) into Dispatch Module.
• Sending mail to supplier to informing the Revenue document serial numbers.
• Update status of the Consignments to the requestor in dispatch module.
• Customized FA Account generator workflow in Fixed Assets
• Customized purchase requisition workflow to populate custom values into DFF
• Prepared SOP for Bolton Module (Kitting)
• Defining Menu and Report Security Groups
• Defining Responsibilities and assigning them to users
• Defining Users and their Personal Profile Options
• Prepared MD70 & MD120 Documents creating OPM Item categories, Value sets etc

Confidential

Responsibilities:

• As a team member was responsible for:
• Creating technical designs(MD70) for RICEF
• Developed All Others Customer Shipments Report(DP)
• Developed MTD(month to date) Region Forecast Consumption Report(DP)
• Developed Distribution Center Average Weight Report
• Developed Error report based on BOM interfaces.
• Developed Overhead Changing Report.
• Outbound interface it will send Oracle Cost to legacy sales processing system.
• Outbound Interfaces like Backorder, Pick release Update, and Pick confirm.
• Sales Orders API, Pricing API.
• Developed interface program to upload Items into Interface tables from Legacy system.
• Developed Interface program to upload item category codes into interface tables from Legacy system.
• Registering Tables, and Forms
• Developing forms, using TEMPLATE.fmb, conforming to Oracle Applications coding standards
• PL/SQL Method of submitting Concurrent Programs
• Create Technical design documents(MD70) and migration documents(MD120)

Confidential

Responsibilities:

• Developed Invoice Class Details Report
• Developed Vendors Invoice Details
• Developed interface program to Upload items into GL interface tables from Legacy System in Oracle General Ledger and Used SQL * Loader to upload data from Flat Files to Pre-interface table and wrote a PL/ SQL Procedure for all the business validations.
• Involved in coding and design of the form in which user can send mails.
• Created tables, indexes, sequences, constraints and snapshots.
• High degree of conceptual and analytical skills
• Good written and oral communication skills