SUMMARY

• Senior Oracle Applications Professional with over 14 years of functional and technical experience in teh Oracle eBusiness Suite applications and performing requirement gathering, analysis, functional design, technical design, instance configurations, customizations, Data Migrations,personalization, extensions, systems integration, production support, upgrade, leading functional tracks and Development teams, and managing projects.
• Extensively worked on: Oracle Applications 11.x/ 12.x (Order Management(OM), Shipping(WSH), Purchasing(PO), Inventory(INV), Transportation Management(OTM), iExpense, Trade Mgmt, Bills Of Materials(BOM),WIP,EAM,ASCP,iSupplier,iProcurement,Collabarative Planning,Warehouse Management,Advanced Pricing(QP), Accounts Payables(AP), Accounts Receivables(AR),HR,Payroll Processing,General Ledger(GL),CRM, Service Contracts(OKS),Deport Repair(CSD),Installed Base(IB),OPM Costing, AOL, Release Management(RLM),WMS.
• Experience with Brazil Localizations Implementation and Multi Org Implementation
• Excellent Soft Skills, Inter Personal Skills, People Management,Project Management,Planning and Timely Project Execution and delivery.
• LANG/ TECH: SQL, PL/SQL, Unix Shell Script
• DATABASES: Oracle 8.x/ 9.x /10g/11g
• TOOLS: Developer Suite 6i,9i,10g (Forms, Reports ), Discoverer (4.x, 10g)Workflow Builder, XML Publisher,TOAD,Data Loader, Microsoft Office(Excel,Word,Visio,Projects,Power Point).

PROFESSIONALEXPERIENCE

Confidential

Responsibilities:

• Worked with Confidential Local Brazil Business process leads and Global Process Owners in teh implementation offunctional areas OM,Pricing,Shipping,WMS,EMS,Inv,AR,Synchro, Softway
• Gathering teh Business Requirements and working with process owners to design teh efficient solutions and configure and implement them in Oracle EBS.
• Extensivly worked on designing and Configuring Order Management w.r.t Order Import from Confidential Home Grown Web Ordering Tool Application for building teh ATM configurations and Services,Designing teh new Order Types for brazil, processing constraints,Defaulting Rules, and Workflows,Order Holds,Price Modifiers,RMA Setutp, Pick Release Grouping Rules,IR/ISO process,Soft Allocation,Hard Allocation,IR/ISO For direct Materials,Custom RICE Objects etc.
• Involved with Supplier,Item,Customers conversion from Legacy systems.
• Designed custom process for determining teh Item Origin of Retail products purchased from domestic and international suppliers.
• Other Key functional areas worked are 3PL WMS Solutioning, Exports and Imports Process From Brazil, Time and Material Billing, Service Parts Movement using NF - Express Solution, Item Conversion,
• Designed and written functional spec for custom solutions for Invoicing teh CID instead of teh components as per teh brazil statutory requirement.
• Designed teh custom solution for Bundling teh Hardware and Services PIDs and Invoicing teh customer as bundles instead of separate items on Invoice as per Brazil Statutory requirments.
• Designed teh Integrations between EBS WOT (Web Ordering Tool) and Oracle EBS for Interfacing Hardware Configured Items and Service Configurations, Creating Warranties and Service Contracts based on teh quotes submitted to ERP from WOT.
• Lead teh cross-track solutioning for Exports and Imports from Brazil through GSL(Global Solutions Limited Legal Entity), an Internal Confidential company registered in Europe for Tax Purposes. Solution involved auto creation of sales order from PO and Softway Integration for Export Compliance and Synchro for Nota Fiscal(Invoice) generation and EMS for Freight Charges and Global Export Compliance.
• Designed Custom solution for Service Parts Movement from Central Warehouse to Different Confidential Maintenance Branches and Issuing Parts and Nota Fiscals to Technicians and End Customers.Solution Involved auto creation of Internal Requisitions and Internal Sales Orders and Outbound NF, Inbound NF and Consumption NF.
• Designed solution for Time & Material Billing, For generating Service Nota Fiscals for charging teh Technician labor,expenses, Service Fees etc and Product Nota Fiscals for Parts Replaced during repairs and Maintenance.
• Designed a custom Price List Upload from Spreatsheet process for users to directly mass upload price lists and Configured Various Price Lists and Modifiers
• Worked with other track on designing teh very complex 3PL and OSP solutions for generating Remittance NF and also Item Origin Solution.
• Worked on teh AR setups and Latin Tax Engine Setups with SMEs.
• Written teh Business Process BP080 document for End to End Process Flows in O2C area,Writing CIT,SAT,UAT test scenarios, Test Scripts and Test Cases and Execution of test scripts and Written BR100 Setup documents for deployment to multiple instances etc

Confidential

R12 Implementation

Environment:Oracle Applications 12i (Order Management,Inventory,Costing,Shipping,WMS,Pricing,OTM,Purchasing,iSupplier,iProcurement,Collaborative Planning, ASCP,BOM,WIP, High Jump,IB,Service Contracts,iWarranty,EAM etc)

Responsibilities:

• Worked with Business process leads in teh implementation offunctional areas OM,Pricing,Shipping,Inv,OTM,High Jump(WMS),BOM,WIP,EAM, PO,iSupplier,iProcurement,ASCP and Collaborative Planning
• Gathering teh Business Requirements and working with process owners to design teh efficient solutions and configure and implement them in Oracle EBS.
• Extensivly worked on designing and Configuring Order Management w.r.t Order Import, processing constraints,Defaulting Rules, Order Types and Workflows,Drop-Ship Process,Order Holds,Price Modifiers,RMA Setutp, Pick Release Grouping Rules,IR/ISO process,Soft Allocation,Hard Allocation,IR/ISO For direct Materials,ASCP Collection Plans,Custom Reports etc.
• Other Key functional areas worked are Setting up Outside Processing,Consignments,BPAs, Sourcing Rules,production scheduling, Min-Max Planning, JIT, Advanced Supply chain Planning,Designing OTM agents, Inter-Org Process,Closing Inventory Periods,Cycle Counting,Configuring EAM for different Plants,Setting up EAM Preventive Maintanance Schedules etc,E2E Testing Of EAM work Orders.
• Designed custom solutions around production scheduling and Integrations with High Jump for WIP Completion and Receiving teh products into EBS.
• Extensively Worked on improvizing teh OTM Agents and teh EBS-OTM integration issues to cater to teh business needs and developed a mechanism for business to handle teh Day2Day support issues.
• Designed teh Integrations between EBS shipping,OTM and EBS, High Jump, a WMS system and Improvized teh ineffeciencies in teh integration process.
• Lead teh Shipping Reconciliation activity to clean-up teh pending transactions due to SOA Integration issues and made sure all teh shipments are invoiced.
• Was Part of Rollouts to Canada,Mexico and Involved with Data Conversion,Designing Custom Import Documentation and Local Taxation processes and Border Crossing Documentation.
• Extensively worked on resolving teh post production issues and trained teh business users to resolve teh issues themselves.
• Apart from teh above, provided functional guidance to Business Process Leads and technical team to Close teh Inventory Periods, clear any uncosted inv transactions, Pending Shipping Transactions and any other pending Inventory transactions and help teh users to resolve teh Inventory descripencies between High Jump and EBS, Serials Vs Onhand Descrepencies in EBS.

Confidential

Systems Integration

Environment: Oracle Applications 12i (INV,WMS, OM, PO), Oracle 10g.

Responsibilities:

• Solution Architect for fast-turn implementations of new customers dat are being added to teh SPLUS system with varying business requirements,Designing teh business process changes for Shipping Lithium Ion batteries, Maintaining teh Inventory by Disposition, Reservation by disposition etc.
• Analysed teh in-effeciencies of teh cycle count process and Identified teh root causes and designing and developing teh new multi threaded solution to create teh cycle count entries for multiple subinventories at once.
• Designed and Developed a strategy to consolidate teh inventory organizations and minimize teh redundant org Items and thus increasing teh Database space utilization.
• Designed teh Custom Warehouse management Application to cater teh UPS needs by intergrating Oracle Inventory Application, and posting all outbound and inbound transactions to Oracle Inventory.
• Designed teh process to import teh ASN transactions from teh suppliers and honoring teh updates to teh same ASNs with varying complex logic for different suppliers.
• Designed a custom process to bypass teh Order Management and to create teh Inventory Move Orders based on teh customer’s orders captured in another proprietary tool(RTM) and to do teh reservation and to generate custom pick slips.
• Designed Custom Item master import programs to create teh master items and Organization Items and Updates to teh existing Items using PL/SQL and Standard Item Import process.Also Creating teh Blanket POs for teh new items, so dat items can be received against teh blanket POs.
• Designed teh process to do teh inventory replenishement by disposition from source subinventories to destination subinventories based on teh min-max levels set at teh destination subinventory.
• Providing production support to help operation users in troubleshooting and resolving teh techncial and Functional issues.
• Project Manager for teh whole EDI Implementation project
• Responsible for project planning, requirement gathering and analysis, functional and technical design, systems integration testing, UAT, deployment, and user training
• Designing teh map specifications for five EDI transactions such as 850(Inbound Purchase Order), 860(Inbound Purchase Order Change), 855(Outbound PO Acknowledgement), 810(Outbound Customer Invoice), and 824(Inbound Invoice Reconciliation Errors).
• Coordinating with teh translation partner GXS for maps development and unit testing
• Designing teh Oracle interfaces for inbound transactions to import teh purchase orders and create Billing Agreements and Projects, extraction logic for sending outbound invoices
• Conducting teh user acceptance with AT&T Implementation and nSoro users
• Preparing cutover plan,performing production deployment of teh database objects and Functional Implementation setups and user training.
• Resolving teh production issues related to 810 invoice transactions and 850 inbound purchase orders.
• Designing and Developing various discoverer reports such as Budget Comparision Report, Non-Turf Invoice Report, CIEB Report etc.
• Leading teh offshore Production Support team in resolving teh key production issues and re-engineering some inefficient processes.

Oracle Applications

Confidential

Responsibilities:

• Functional Lead for implementing Oracle OM,Advanced Pricing, Shipping,Purchasing,ASCP, Receiving modules and OPM Costing.Was responsible for conducting WTP,CRP,SIT and UAT sessions with users.
• Gathered requirements from business users for OM, Pricing,Shipping, custom Inbound Label process,Excess Inventory Transfer, OPM costing and custom OPM cut/ wrap process and designed custom process and Configured teh system as per teh business needs.
• Designed teh Integration between Siebel CRM system with Oracle Order Management system to create teh orders in oracle seamlessly and to send teh ackwoledgements back to siebel and to provide teh pricing information to siebel system.
• Designed a custom solution to teh cost changes process and teh impact of teh cost change on vendor pricing, customer pricing, and price holds based on teh customer TEMPeffective date
• Designed a price book report to replicate teh Advanced Pricing process based on formulas and Pricing attributes to report teh customer prices
• Designed and developed a custom price change notification process to send e-mail alerts about teh price changes to teh customers.
• Designed a custom process to generate teh Invoices data to send to multiple customers in multiple EDI Formats integrated through SOA and BPEL.
• Designed a custom solution to create teh trips based on teh routes and scheduled ship date, also developed a workbench to monitor teh trips, reassigned teh trips to future trips, and rescheduled teh trip to a next available scheduled ship date
• Designed a process to integrate teh Oracle Transportation module with eBS to import teh freight settlements to impact teh actual cost and write-off teh differences between planning allocation and voucher allocations in OTM.
• Designed and Implemented teh Solution to Maintan teh Excess Inventory at each warehouse and provided teh capability for teh buyers to see teh excess inventory at other warehoues and order for teh transfer of teh excess inventory.

Confidential

Oracle Applications

Responsibilities:

• Led teh Sales implementation track and EDI, dat covered teh Order Management, Release Management,ASCP, Advanced Pricing, and Shipping modules
• Gathered requirements from business users, drafted teh BR035s for teh OTC Track, designed teh solutions for teh custom business processes, and prepared solution design documents (BR010s), functional design documents (MD050s), and setup documents (BR100s)
• Configured and Implemented teh OM, Pricing,EAM,PO and Shipping modules. As part of dis, Defined Price Lists,Modifiers,Formulas, Order Types, Shipping Networks, Carriers, Pick Release Rules, Pick Slip grouping Rules, Shipping parameters,Defaulting Rules, etc.
• Designed a custom solution to import teh Sales orders from teh Customer System Directly.
• Designed teh custom solution around outside processing,which will provide capability to view teh Finished Good inventory,Raw Material, Consumption of teh raw material at teh Vendor Location.
• Designed teh Custom Pick Slips, Pack Slips and Bill-Of-Lading documents and Co-Ordinated with technical team for teh testing and delivery of teh reports.
• As Functional lead was responsible for tracking teh issues, deliverables status, and providing roles/ responsibility matrix.
• Designed teh Templates to Convert teh Open Sales orders and Price Lists with teh new 12i setups.

Confidential

Oracle Application

Responsibilities:

• Techno-Functional Lead for Oracle Trade Management, Demantra Integration, and OTC implementation
• Led teh Offshore Development team OTC customizations and extensions, Oracle Trade Management, and Demantra integration
• Gathered requirements from business users for teh OTC custom business processes, and prepared functional design documents(BR010) and setup documents (BR100s)
• Implemented teh EDI 945 inbound to allocate and ship confirm teh deliveries automatically
• Implemented teh Auto Lockbox process for teh client with Bank of America.
• Implemented teh bank statement load process with Citizens Bank.
• Designed teh solutions and approach for teh integration between Demantra and Oracle Trade Management, ASC Instances.
• Techno-Functional Analyst and Lead Coordinator for teh Offshore Development team
• Prepared teh functional design documents for teh OTC custom objects and required setup documents (BR100s)
• Developed teh custom form to handle teh pre-deduction memos, and developed interfaces to import indirect sales and claims from SYSCO
• Implemented teh iExpenses module to reimburse teh employees expenses
• Customized teh payment format for electronic payments to employees from USA Bank to reimburse teh employee paid expenses
• Developed programs to export teh remittances data to American Express for teh employee credit card transactions
• Was Part of teh India OU Rollout and Localized teh Application for Specific Indian Tax Calculations By state and Custom Import/Export Documentation, Custom Pick Slips/Pack Slips,BOL.
• Providing teh production support to business users in troubleshooting, identifying teh root casues and debugging them.

Confidential, San Diego

Oracle Applications

Responsibilities:

• Techno-Functional Analyst for improving teh OTC process inefficiencies
• Designed teh custom Workflow process for order import through shipment because teh client did not maintain teh inventory and all teh products were delivered by third parties
• Improved teh performance of teh order import and booking process as teh process was time consuming during teh peak business periods
• Designing teh solution to improve teh receipts creation process and developing teh custom programs in placeof teh standard lockbox receipt creation process
• Designed and developed teh custom OM and AR reports such as Invoice Print Reports, AR Aging Reports, Check Register for AR refunds,Order Details By Status,Ship Confirm by order Source.
• Developed teh SQL queries for generating event Alerts and periodic Alerts.
• Set up teh functional information such as banks, bank accounts, receipt class, receipt source, lockbox, and transmission formats based on teh business requirement
• Set up teh order sources, order types, and holds
• Customized teh Standard Aging reports to display teh aging by business units and detailed aging, and developed new write-offs by business unit report
• Developed new reports in AR and OM track such as Credit/ Debit Memo Printing, Underpaid Prepayments Correspondence, Order Details By Status, and Check Register
• Developed custom forms such as PO hold, logistic business rules, inventory transactions, trading partner maintenance, order approval, and error PO review
• Developed custom program for consignment sell through fulfillment
• Developed PL/SQL programs for notifying concerned people in advance about teh expiry of service contracts and warranties
• Developed teh PL/SQL programs for notifying concerned people about teh successful completion of QA check and about teh invoices dat are going to be raised against customers
• Customized Order Line Workflow to bypass teh standard oracle process and incorporate teh client’s custom Shipping process
• Designed EUL, business areas, and user workbooks for ad hoc reporting using Oracle Discoverer 4i For Service Contracts,Depot Repair,Installed Base Modules.
• Developed technical design documents (MD070s) for teh programs as per teh Oracle Application Implementation Methodology (AIM) and thorough testing
• Worked on Localizing teh Warranty Terms,Service Agreements as per Kuwait Country Statutory Policies.Developed Custom Reports For Some Legal Documentation for Service Contracts and Warranties
• Developed a custom Locatlization process to adjust teh fixed currency rate fluctuations in Arab Countries and Custom Solution for Service Tax Calculations.
• Developed custom programs to import journals and daily rates in GL
• Developed reports such as Payment Register and AP Invoice Aging by company
• Improved teh performance of time taking GL interfaces and reports
• Developed alerts for notifying password expiration, PO create alert, and new SKU alert

Confidential, San Jose

Oracle Applications

Responsibilities:

• Wrote conversion programs to convert teh data in 10.7 to 11i
• Wrote programs to convert customers, orders, invoices, and receipts
• Migrated teh AR Custom reports as per teh new TCA architecture
• Migrated teh reports in Order Entry (OE 10.7) to Order Management (OM 11i) as per teh new data architecture in 11i
• Migrated teh custom forms from Developer/2000 to Developer 6i
• Developed technical design documents (MD070s) for teh objects to be migrated as per teh Oracle Application Implementation Methodology (AIM)
• Supported teh production instance, and tuned teh reports and programs
• Imported customers using AR customer interface
• Imported receipts using receipts API
• Imported AP invoices using teh AP invoice interface
• Developed teh extraction programs to extract data from inventory to legacy systems
• Developed Asset Addition, Asset Retirement, Asset Transfer, and Asset Inventory reports in FA

Confidential

Oracle Applications Customization

Responsibilities:

• Customized standard reports and developed new custom reports in INV, PO, and AP such as PO Forecast Report, and Check Printing
• Performed code review of teh forms and reports developed by teh peers as a first level review
• Prepared Technical Design documents, Unit Test reports, and User documents for all objects
• Responsible for ensuring teh quality standards of Satyam in all teh deliverables
• Designed implementation strategy of teh algorithm and development of teh code for implementing teh algorithm
• Performed testing - unit testing and integration testing
• Responsible for overseeing teh quality procedures related to teh project
• Worked on eStore an eCommerce product, developed to provide electronic shopping functionality on web sites
• Prepared process flow diagrams and designing of teh database
• Designed screens and templates for different functional specifications
• Developed different Applets and Servlets on teh customer side of teh store development and personalization end
• Prepared quality matrix and test reports at different stages in teh product development
• Documented coding standards and GUI design
• Member of teh testing team, actively involved in module level and integration testing