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, Distribution Planning, Demantra, Order Management,Trade 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
• Involved in Product Hub Implementation
• Involved heavily in Inventory and Costing Setup
• Exposure to Oracle Sales, Service,Financials,SCM and PBCS Cloud Services
• Good Functional Knowledge with Order to Cash (OTC)and Procure To Pay Cycles (P2P)
• Experienced with Product Configurator
• 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 oracle corporations 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,12c 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

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, MALVERN,PA

Techno Functional Lead

Responsibilities:

• Involved in Leading Offshore team for Techno Functional issues on daily basis
• Reporting the end client the day to date project progress
• Analysis for oracle Upgrade and Cloud Implementation
• Involved IN HCM Cloud Upgrade
• Involved in OTL configuration
• Involved in Project Estimation for Business as Usual at High Level
• Involved in Project Optimization and Performance for existing customization
• Involved in OFSC Interface Customization
• Involved in MDM design with Financial Accounting Hub and Customer Data Hub
• Involved in Revenue Recognition customization

Confidential, CLEVELAND, OHIO

ORACLE EBS PROCURE TO PAY/ Confidential FUNCTIONAL CONSULTANT

Responsibilities:

• Involved In Production Support For iProc, isupplier, Purchasing And AP Module
• Configured ABC Cycle count for all the inventory Org and Customized reports to meet the annual Auditing deadline
• Used Average Costing
• Configuration of Costing for Inventory Transactions
• Configuration of Product Hub
• Involved in MDM design with Financial Accounting Hub and Customer Data Hub
• Configuration of Product Configurator
• Created BR100 and User Manuals
• Participated in ALM(Application Lifecycle Management) Automated Testing for Purchasing and WAM Interface
• Involved in WAM customization Testing
• Involved in setting up Advanced pricing and Order Management
• Configured Back to Back Order processing
• Modification of AP Invoice Hold Custom Package and testing and Implementation.
• Modified DFF for customer Information
• Involved in Form Personalization
• Involved in Oracle Financials Cloud Implementation
• Involved IN HCM Cloud Upgrade
• Involved in Production support for Oracle PBCS (Planning and Budgeting Cloud Services)
• Supported month end processing, Period Close process, reconciliation, and reporting

Environment: Oracle Apps 12.2.5, PL/SQL, SQLPLUS, ORACLE 12c

Confidential, COLUMBUS, OHIO

ORACLE GLOBAL TRACK LEAD

Responsibilities:

• Involved In Production Support For IPROC,OTL And AP Module
• Used Average Costing
• Configuration of Costing for Inventory Transactions
• Involved in Trade Management Setup
• Involved in Order Management Configuration
• Supported month end processing, Period Close process, reconciliation, and reporting
• Involved In Go Live For Oracle R12 Financials And IPROC
• Involved In System Validation For Supply Chain R12 Implementation (Inventory,Planning)
• Involved In Techno Functional Activities in ASCP Integration
• Design Inventory Optimization process and solution
• Defining Items as Distribution Planned
• Defining Bills of Material for Kitting
• Defining Demand Priority Rules
• Defining Trip Limits for Ship Methods by Lane
• Defining Sourcing Rules
• Setting Up Supply Allocation Rules
• Setting Up High Volume Distribution Planning
• Configuration of Product Hub
• Involved in MDM design with Financial Accounting Hub and Customer Data Hub
• Configuration of Product Configurator
• Involved in Oracle Sales and Service Cloud computing Tasks
• Involved in SCM Cloud Implementation.
• Worked in Oracle Warehouse Management System WMS, MSCA.
• Used Loft ware configuration for Label Printing
• Setup Intellium for serialized transactions
• Training/Defect resolution/Production Support for picking project.
• Modification of Reports and Forms
• Modified Custom Reports to suite new requirements

Confidential, Cleveland, OHIO

ORACLE CONSULTANT

Responsibilities:

• Designed And Developed Interfaces For AP Module
• Involved In Production Support
• Rice Development For R12 Implementation.
• Implementing sales order replenishment picking.
• Worked On WAVE PLANNING
• Created Oracle Reports
• Modified Oracle Forms
• Worked In Soa Bpel Services
• Involved 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
• Configuration And Setup For Fixed Assets Module
• Configuration And Setup For Confidential 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 Data load, Agile File load 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
• Configuration of Product Configurator
• Converted Data From Legacy Systems, People Soft To Oracles
• Created Reports
• IT Analyst for Oracle Warehouse Management System WMS, Inventory, MSCA assessment
• Used Loft ware configuration for Label Printing
• Setup Intellium for serialized transactions
• Recommendations for Manufacturing Picks for task assignment
• 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 Modules
• Involved In Performance Tuning Configuration
• Created And Modified Discoverer Reports
• Created and Modified Oracle Reports and Forms
• Configuration Of ASCP Interfaces For Daily Load With Demantra
• Configuration Of Demantra With Hyperion Integration
• Involved In Production Schedule Set Ups
• Configuration Of Oracle MES
• Configuration of Product Hub
• Configuration of Product Configurator
• Configuration Of Order Management, Inventory, WIP And Shipping
• Used Loft ware configuration for Label Printing
• Setup Intellium for serialized transactions
• 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
• Configuration Of Oracle MES
• Involved Agile PLM Integration
• Oracle Manufacturing Functional Consultant for R12 Enhancements
• 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
• CONFIGURATION 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, Sub inventory, 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