SUMMARY:

• Has 25 years of total and 20 of strong experience on Oracle Applications R12/11i/ 11.5.10.2/11.5.9/11.0/10.7/10.5 including Oracle Financials (GL, AP, AR, FA and PA) Manufacturing, SCM (OSFM, MRP, ENGINEERING, BOM, QUALITY, Advanced Planning, Scheduling, Advanced Supply Chain Planning, Demantra, Order Management, Shipping, WMS,TCA, PO, I - Procurement, I-Supplier, I-Store, WIP,COSTING, INV, CRM, Advanced Pricing, Time Management, Labor Management. He has more than three years experience in Data ware housing including ETL tools
• Good Functional Knowledge with Order to Cash (OTC)and Procure To Pay Cycles (P2P)
• Involved in more than 10 Oracle Application Implementation including E-business Suite
• Involved in 11i and R12 upgrades
• Experienced with E-business suite with exposure to BPEL along with EDI for PO transactions.
• Involved in about 8 RICE Implementation Experience
• Designed and developed various Interfaces In INV,BOM,WIP,PO and Receiving
• Involved in Oracle to SAP Interfaces design
• Involved in DBA functions including Database design, Modeling, Performance-tuning, backup, recovery operations. Concentrated experience in data conversions, custom application development, gap analysis and system design under Unix/windows environment and client/server applications.
• Used Toad, Explain Plan,OEM, SQL Trace, AWR and Load Runner for Performance Tuning
• Has strong Techno/Functional consulting experience from scratch to post implementation of oracle application Projects. Used methodology for these projects.
• Has extensive implementation experience in manufacturing, logistics and Finance management systems.
• Managed many Projects and People
• Proficient with the Oracle Designer/Developer 2000, Discoverer and has application development experience in Oracle 10G/ 9i/8.x/7.x, Forms 6i/4.5, Reports 2.5 and Graphs 2.5 and OAF
• Used third party tools like View Direct TCM for reports distribution and viewing and maintaining. He also used OPTIO software for formatting outputs from oracle applications.
• Completed training in Oracle Supply Chain Applications from Confidential s with specific focus on engineered orders, which encompasses Order Entry, Product Configurator, Inventory, Bill of Materials applications, TCA, Pricing, Quoting and Order Managements, Service Contracts
• Ability to code using C, C++, Visual Basic, SQL, PL/SQL, JAVA, JAVASCRIPTS, and HTML .
• Used SAS statistical packages for Analysis.

TECHNICAL SKILLS:

DBMS: Oracle 7.2.2.4/ 7.3.2.1 / 8.04 / 8 i,,9i,10g, 11g Sybase 11.9.2, Informix, MS Access

OS: Windows 3.x/95/98/2000, Windows NT,MS- DOS, AIX 4.1 (RS-6000), HP-UNIX, SUN, Secant, SQLSERVER

Languages: SQL/PLSQL,SQL*PLUS, C, C++, Pro*C, Java .C sharp Dot.Net

Multidimensional databases: Oracle Express 6.2

Development Tools: Express Analyzer, Express Objects, Express Administrator, OEM, Developer-2000, Discoverer, Object View, JBuilder 4.0,OAF

Data Modeling Tools: Designer 2000, Erwin

Script: Shell Scripts (K and C Shell), Python

Web Technologies: Java 1.2 - JSP, EJB 1.1, Servlets, JavaScript, HTML, OAS3.0, BEA WebLogic 5.1

Exposure to: People Soft Human resources, Purchasing ERP (7), SAP,BANN, Manman, Wds, SAS

Reporting Tools: Business Objects, Cognos, View Direct TCM

DW Tools: Data Stage, INFORMATICA, EDMS. OWB

PROFESSIONAL EXPERIENCE:

Confidential, COLUMBUS, OHIO

ORACLE GLOBAL TRACK LEAD

Responsibilities:

• INVOLVED IN PRODUCTION SUPPORT FOR IPROC,OTL and AP Module
• INVOLVED IN GO LIVE FOR ORACLE R12 FINANCIALS AND IPROC
• INVOLVED IN SYSTEM VALIDATION FOR SUPPLY CHAIN R12 IMPLEMENTATION
• INVOLVED IN TECHNO FUNCTIONAL ACTIVITIES

Confidential, Cleveland, OHIO

ORACLE CONSULTANT

Responsibilities:

• DESIGNED AND DEVELOPED INTERFACES FOR AP MODULE
• INVOLVED IN PRODUCTION SUPPORT
• RICE DEVELOPMENT FOR R12 IMPLEMENTATION
• CREATED ORACLE REPORTS
• WORKED IN SOA BPEL SERVICES
• INVOVED IN UNIT TESTING AND RESOLVING DEFECTS
• INVOLVED IN DATA BASE TUNING BY USING LOAD RUNNER AND EXPLAIN PLAN
• USED OEM TOOL FOR PERFORMANCE TRACKING
• INVOLVED IN AGILE PLM INTEGRATION

Confidential, PARKERSBURG, WV

SENIOR ORACLE FINANCIAL CONSULTANT

Responsibilities:

• DESIGNED AND DEVELOPED INTERFACES FOR GENERAL LEDGER MODULES
• CONFIQURATION AND SETUP FOR FIXED ASSETS MODULE
• CONFIQURATION AND SETUP FOR MFG SLA FOR COSTING AND INVENTORY
• SIT TESTING FOR GL,FA.INV and COSTING MODULES
• CREATED TEST SCRIPT AND SCENARIOS FOR COSTING AND GL
• MAINTAINED BR100 FOR FA AND GL
• Hands-on experience with different modules of Agile Advantage 2006 such as Agile Administrator, Agile CM, Agile Change Cast, Agile Express Professional, Agile Import, Agile Dataload, Agile Fileload and Agile SDK, system installation, system configuration, Oracle, Tomcat, and the working experience with Oracle Agile 9.2.2.2 Java Client Admin, Web Client Admin, PC Module, PQM Module, PG&C Module, PPM Module .

Confidential, TEMPLE, TX

SENIOR ORACLE CONSULTANT

Responsibilities:

• DESIGNED AND DEVELOPED INTERFACES FOR PURCHASING MODULES
• CREATED PACKAGES FOR ASL,ITEM PRICE CATALOG,OPEN PO’S AND SOURCING
• CONVERTED DATA FROM LEGACY SYSTEMS,PEOPLE SOFT TO ORACLES
• CREATED REPORTS
• INVOLVED IN UNIT TEST AND INTEGRATION TESTING
• INVOLVED IN CONFIGURATION AND SETUPS
• USED AWR AND SQL TRACE FOR PERFORMANCE TUNING

Confidential, ORRVILLE, OH

SENIOR ORACLE FUNCTIONAL CONSULTANT

Responsibilities:

• DESIGNED VIEWS AND PACKAGES FOR R12 COMPLIANCE
• Business Requirements Mapping for INV, OM, RLM, SCH, QP, AR, WMS, BOM, WIP and Planning and shipping for R12 COMPLIANCE
• WORKED IN AP,GL,FA AND AR AND ORDER MANAGEMENT MODULIES
• INVOLVED IN PERFORMANCE TUNING CONFIGURATION
• CREATED AND MODFIED DISCOVERER REPORTS
• CONFIGURATION OF ASCP INTERFACES FOR DAILY LOAD WITH DEMANTRA
• CONFIGURATION OF DEMANTRA WITH HYPERION INTEGRATION
• INVOLVED IN PRODUCTION SCHEDULE SET UPS
• CONFIQURATION OF ORACLE MES
• CONFIGURATION OF ORDER MANAGEMENT,INVENTORY,WIP AND SHIPPING
• Involved in Process mapping and requirement analysis for Shop floor management
• USED PLM METHODOLOGY

Confidential, MIAMI, FL

SENIOR ORACLE FUNCTIONAL CONSULTANT

Responsibilities:

• DESIGN AND DEVELOPED PRODUCT HUB
• CREATED MD 50 and 70 DOCUMENTS
• DESIGNED AND DEVELOPED ITEM CONVERSION
• Involved in extensive Testing in SIT,UNIT and Regression testing
• CREATED Reports for ITEM and BOM Extractions
• CREATED GDSN extract Reports
• USED TCA ARCHITECTURE FOR REPORTS
• Alignment of the Engineering, Manufacturing and Inventory Management departments to adopt the new solution
• CONFIQURATION OF ORACLE MES
• INVOLVED AGILE PLM INTEGRATION

Confidential, Tampa, FL

Oracle Manufacturing Functional Consultant

Responsibilities:

• Involved in requirement gathering, Gap Analysis and estimation
• Designed Functional documents for reporting requirements
• Created Test scripts and Test Plans for unit and user testing
• Involved in extensive Testing CQT and Regression testing
• Modules involved are Manufacturing and oracle Financials
• Involved in User sign off for enhancements
• Created XML Reports
• Used Change Management process and ticketing systems
• Used Version controls Like Subversion and PVCS
• Requirement gathering for PRODUCT HUB
• DESIGNED TCA UNDERLINE TABLES FOR REPORTS GENERATION
• CONFIQURATION OF ORACLE MES

Confidential, Solon, Ohio

Oracle Techno Functional Consultant

Responsibilities:

• Designed,Set up and Implemented PO Interfaces to Load BPA
• Set up Approved Supplier list
• Developed Script for Data Loader to load PO,ASL and SOURCING RULES
• Worked in BOM, Routing,COSTING AND INVENTORY modules
• Designed ASCP Interfaces for Daily Load with Demantra
• Created test scripts for Baseline testing
• Created BR100 and MD70 documents
• Created custom Label field in WMS
• Created SQL trigger for Inbound labels.
• Leading Manufacturing (WMS, BOM, and INV) and planning team for Setup and data migration track. Major activities include setting up Inventory Organization, Subinventory, Item locators, Network Routing, Resource, Resource Cost, Cost Elements, Department Resources, Department Class, Departments, Standard Operations, Operation Resources, resource Shifts, WMS Operation Details and Bonus Lot transactions, Material Status, Material Status Control, Put Away Rules, Picking Rules, Task Type Assignment Rules, Cost Group Rules, and Labeling Rules. Strategy Search Order, Strategies, Strategy Assignment, Replenishment using Min-Max report, Cycle Counting and Physical Inventory, Cartonization, Zones and Cost Groups, Cost Group Rules, LPN Transactions, Dock Door Appointment and Cross Docking, Task Types and Task Prioritization.
• Resolved and implemented many Change Request (CR) and Technical Assistant request (TAR) during Go-Live and later. Trained User for day to day WMS activities, supported WMS critical reporting issues after go live.

Environment: Oracle Apps 12.1.3, PL/SQL, SQLPLUS, ORACLE 9i, 10g,11g, 12i/11i /5.10.2 on IBM AIX

Modules Implemented: INV, BOM, PO,ASCP, WMS and COSTING

Confidential, Greenville, South Carolina

Oracle Functional Consultant

Responsibilities:

• Implementing Inventory,Costing and BOM modules
• Developed BR 100 documents
• Configured setups for Inventory, Costing, BOM and Routing modules
• Created test scripts for Baseline testing
• Participated in central Qualification Testing for Release 12
• Designed and developed Interfaces from third Party system to ASCP
• Planned, designed Inventory conversion strategy and created CV40 documents
• Designed customizations and interfaces and created Functional documents
• Involved in Fixing CQT testing Issues
• Involved in 12i upgrades
• CONFIQURATION AND SETUP OF ORACLE MES
• Involved in Process mapping and requirement analysis for Shop floor management

Environment: Oracle Apps 12.1.3, PL/SQL, SQLPLUS, ORACLE 9i, 10g,11g, 12i/11i /5.10.2 on IBM AIX

Modules Implemented: INV, BOM, WIP, PO,ASCP and costing

Confidential, Maumee, Ohio

Oracle Functional consultant

Responsibilities:

• Created Technical and Functional Design documents
• Created Test scripts
• Involved in Daily Production Support
• Involved in customization of Automation of existing manufacturing Process
• Requirement Analysis and Estimation
• Used Clear Orbits for shipping Transactions
• Used MSCA for receiving transactions
• Designed and developed WMS Interfaces with MSCA and clear orbits
• Developed Inventory Interfaces Like MTL SYSTEM ITEMS,MTL TRANSACTIONS INTERFACE and MTL SERIAL NUMBERS
• Developed WIP MOVE TXN INTERFACE
• Involved in INTER ORG transfer automation
• Involved in PO,RCV,AR and AP Interfaces
• Involved in design of EDI and PeopleSoft Interface from and to oracle
• Exposed to OWB setups
• Involved in Project Accounting, Project Costing, Project Billing: Integration of Project Modules with Inventory, Purchasing, Accounts Payables, Account Receivables etc.
• Worked in Project accounting Interfaces
• Worked in Advanced Pricing created Price List
• Developed and Used Crystal reports and oracle reports
• Worked on customization WIP Completions Forms(wip module)
• Set up Physical Inventory and used Data Loader for Physical Adjustments(INV Module)
• Created BOM Explosion Reports for different Org (BOM Module)
• Set up BOM Routings
• Involved in Po setup, Buyer setup In Po modules
• Trained user and Analyst for various tasks
• Acquired Knowledge from Dana Corp and transferred Knowledge to Offshore for Production Support
• Used SAS for Analysis

Environment: Oracle Apps 11.5.10.2, PL/SQL, SQLPLUS, ORACLE 9i, 10g 12i/11i /5.10.2 on Sun Solaris

Modules Implemented: INV, BOM, WIP, PO, ASCP

Confidential, Solon, OH

Senior OracleAplications Techno Functional Developer/Architect

Responsibilities:

• Created Technical and Functional Design documents.
• Created Test scripts for Unit testing
• Designed and developed interface between MAS 200(Legacy Account System) to Oracle Financials on R12
• Created Oracle PL/SQL Packages consists of Oracle procedures and functions.
• Modified existing Oracle Packages to suit the client requirements
• Used technology like Dynamic SQL and Bulk Load in PL/SQL
• Involved in Production Support
• Modified Oracle reports and oracle forms(9i version,10g version)
• Used OAF and JDEVELOPER for FORMS Development
• Created and modified UNIX scripts and schedule in cron jobs
• Involved in .NET, Java, HTML and JAVASCRIPT code Modifications
• Involved in performance tuning for Oracle packages and reports
• USED DATA BASE TUNING TOOLS LOAD RUNNER, OEM AND TOAD
• Modified Workflow in AP, PO Account Generators and Approval processes
• Involved in MRP schedule setups
• Involved in shipping and WMS interfaces
• Used OWB for dataware house
• OM customization requirement finalization and implementation

Environment: Oracle 11.5.10.2, PL/SQL, SQLPLUS, ORACLE 9i, 10g, 11g,12i/11I /5.10.2 on Sun Solaris

Modules: OM, PO, MRP

Confidential, Cincinnati, OH

Senior Oracle Apps Developer

Responsibilities:

• Involved in Interface Design from Oracle inbound and outbound to third Party
• Conduct requirement analysis and create Solution Design
• Create Technical and Functional Design Documents
• BR035 for Purchasing, Payables, iSupplier, iProcurement, iStore, Sourcing, MSCA
• Solution Designing- BR010 document for Purchasing, iSupplier, iProcurement, Sourcing, MSCA
• MD050 for Oracle MSCA & Purchasing, iSupplier, iProcurement, iStore, Sourcing
• Configuration of Purchasing, iSupplier, iProcurement, iStore, Sourcing, MSCA
• Co ordinate with offshore team on daily basis for project execution and Planning
• Focused on Order Management, Inventory, Purchasing and planning modules
• Designed outbound Interface from Oracle to Impact a legacy purchasing System
• Designed BRM and TECHNICAL documents for iSupplier, iStore and iProcurement
• Designed outbound Interface from Oracle to CAS a legacy manufacturing System
• Designed Inbound Interface from Servigistics to Oracle ASCP for forecasting
• Designed outbound Interface from oracle to BANN
• Designed Automation for ASCP recommendation for sales order lines updates in ASCP
• Designed reports in ASCP
• Designed reconciliation report from WMS warehouse system to Oracle
• Designed WMS inbound and outbound interfaces with third party systmes
• Designed and development of ORDER LOAD from EC server to OM, from CWC to OM and from Strother to CM
• Setup Buyers for iProcurement
• Setup Sites for i-Store
• Worked with BPEL for PO in EDI
• Worked in Production support for 850 and 81 0 transactions in BPEL
• Created ASN and ASBN for i-Supplier for Logistics documents
• Created Over due Receipts for purchase order Shipments
• Worked in Contract Manufacturing Setup
• Worked in Item Interface, tem substitution and Product Data Hub
• Involved in OWB configuarations
• Worked in Project Accounting
• Involved in Inventory Conversion
• Involved in Order Conversion, Item Conversion
• Modified Workflow in AP, PO Account Generators and Approval processes

Environment: Oracle Apps 11.5.10.2, PL/SQL, SQLPLUS, ORACLE 9i, 10g

Modules: OM, INV

Confidential, Canton, OH

Senior Oracle Techno Functional/Architect(OPM)

Responsibilities:

• Developing manufacturing interfaces from Third Party to Oracle
• BR035, BR010, BR100, MD050, MD070 - MSCA
• CRP, SIT, UAT, Go-live, User Training, & Production Support
• Project Planning, Estimation, Scoping
• Requirement Study, Fit-Gap Analysis, Solution Designing, Testing
• Involved in Inventory Conversion and AR CONVERSION, Item conversion, Order Conversion
• Production support for Oracle Manufacturing and Financials
• Production Support of Oracle Financials (AP, GL, CM, FA, iExpenses), Oracle Purchasing, iProcurement, iSupplier
• Set up Buyers and Punchouts for iProcurement
• Worked with BPEL for EDI transactions for PO
• Worked in 850 and 81 0 customer transactions for BPEL and trouble shooting
• Setup customer for Order Management
• Set up ASN for i-supplier
• Created Bank Account Details for suppliers in i-supplier
• Daily maintenance of WIP, INV, PO modules
• Inv transactions in Transactions Interface
• Design and extract of Interface from Oracle to SAP for order Management
• Routing set up for Multiple Operations
• Resource set up for costing
• Maintained locator, lot, serialized material transactions
• Developed oracle forms and reports
• Customized the form for multiple operations
• Worked as a RICE (Reports, Interface, Conversion, Extension)Consultant
• Create and modified Unix scripts
• Developed and modified PL/SQL procedures and packages
• Worked in data ware house, item, customer conversion, product data hub
• Worked in project accounting production support and development

Environment: Oracle Apps 11.5.10.2, PL/SQL, SQLPLUS, ORACLE 9i, 10g on IBM AIX

Modules: OM, WIP, BOM, PO

Confidential

Senior Technical Consultant

Responsibilities:

• For Data Warehouse Project Interfacing with Oracle HRMS
• Using Informatica for ETL tool for loading the data
• Created Technical specifications for loading the data
• Created stage1, stage2 and Insert and Update mappings
• For loading through Informatica

Confidential, Cleveland, Ohio

Senior Technical Consultant

Responsibilities:

• Developed Interfaces from Oracle to I2 for Inventory, WIP, BOM, MRP, Advanced Planning and Scheduling modules
• Developed reports in WIP, PO and AP modules.
• Used OPTIO for Purchase order formatting.

Environment: PL/SQL, SQLPLUS, ORACLE 9i 11I /5.9 on SUN SOLARIS Platform, OPTIO

Modules: WIP, BOM, PO, MRP, ASCP

Confidential, Windsor, CT

Senior Order Management Technical Consultant

Responsibilities:

• Developed Interfaces for Inventory module form third party to Oracle
• Also developed technical design documents for the Interfaces
• Modules Included Advance Supply Chain Planning, Scheduling, Order Management

Environment: PL/SQL, SQLPLUS, ORACLE 9i 11I /5.9 on SUN SOLARIS Platform

Confidential, Columbus, OH

Oracle Apps Consultant

Responsibilities:

• Involved in Configuration Management and Audits for different instances for migration to production for 11i oracle application modules
• Used Data Loader to load data
• Created Extract Scripts
• Worked in CRM and SUPPLY CHAIN modules
• Worked in conversion for Service and Contracts for CRM

Environment: PL/SQL, SQLPLUS, ORACLE 9i, 11i /5.9 on SUN SOLARIS Platform

Confidential, Phoenix, AZ

Senior Oracle Apps Consultant

Responsibilities:

• Worked as liaison between Offshore and on shore developers and designers and clients to execute the Projects
• Did business requirements and created technical documents and got the code from offshore
• Managed the People for the delivery and mentored them for the results
• Did Business Analysis for iProcurements, iSupplier and PO modules
• Developed Interfaces and Conversion design Analysis for Purchase, Inventory, Order managements, Project Accounting, CRM and Financials
• Developed Customization design for Oracle GL, FA, AP, and AR modules for 11.5.8/5.9 in financial modules
• Helped the clients for setting up PO, AP, FA, PA and GL Modules
• Involved in Segments set up for code combinations in GL modules
• Helped the clients in setting up Buyers for PO modules
• Involved in CRM Implementation
• Exposed to Trading Community Architecture
• Helped the client in setting up Party, Accounts, locations and sites for CRM
• Worked in Contracts and Service modules
• Created Functional and mapping documents for all these modules
• Used the Standard Oracle Import Programs wherever possible
• Used EDI for Inbound and outbound for PO modules

Environment: Developer - 2000, Discoverer, PL/SQL, SQLPLUS, ORACLE 8I/9i 11I 5.8/5.9 on SUN SOLARIS Platform