SUMMARY:

• A team oriented professional with strong analytical, technical, functional, interpersonal, leadership and communication skills. Over Twenty years of experience in Oracle Applications Modules and Technologies.
• As a Senior Oracle Manufacturing, Planning and Supply Chain Solutions Lead, Functional Analyst and Techno - Functional resource with over 15 years of Oracle Applications experience in various modules like Manufacturing, Planning, CRM and Distribution / Supply Chain (Inventory, Bill of Materials, Work in
• Process, MDS/MRP, Engineering, WMS, ASCP, Order Management, Shipping, Pricing, Purchasing, i-Procurement, Electronic Data Interchange, Accounts Receivables, Accounts Payables and CRM). Experience includes execution of 5 full lifecycle Oracle Applications implementations, numerous Application Support projects, RICE implementations, upgrades, with high Level of Customer Satisfaction. Skillful in Business process re-engineering implementation of Distribution and Manufacturing modules, analysis, testing phases of a project life cycle based on the Oracle AIM methodology for Documentation and Standards. Good Experience in manufacturing operations, Shop floor Activities and sound knowledge of Documentation flow of a manufacturing organization. Involved in analysis, design, development, testing, implementation, documentation, and support of business applications for various industries.
• Over 10 years of Functional experience in Manufacturing, Planning, Supply Chain Oracle Applications modules which includes Inventory, Bill of Materials, Work in Process, MRP, Engineering, WMS, ASCP, Costing, Order Management, Pricing, Purchasing, and Shipping.
• Extensively worked on Oracle Manufacturing, Planning and Supply Chain modules in Manufacturing Industries like Agilent Technologies, Confidential, Confidential, Confidential, Confidential, Confidential, Confidential, Confidential, Confidential Glass and etc... Since long time. Experience in Discrete / Repetitive manufacturing processes.
• Worked in Offshore-Onsite Business Models and also managed offshore and onsite resources utilizing Oracle Business Models
• Extensively worked on Oracle Manufacturing INV, BOM, WIP, Oracle MES, MRP, ENG, WMS, PJM and Costing modules Setups, Implementation and Support.
• Designed new RICE Objects related to Oracle Manufacturing, Supply Chain, Order Management and CRM Modules
• Experience functioning as a Project Manager for 3 years performing Oracle EBS Applications Full Life Cycle Implementations/Upgrades and Application Support Projects

TECHNICAL SKILLS:

ERP: Oracle Applications 12.1/11i/ 11.5.10/ 11.5.9/11.5.8 /11.5.7/11.5.6/11.0.3/10.7 (PSB, FA, AR, AP, GL, CE, INV, PA, OE, OM, Work Flow, Alerts, iProcurement, iPayment, iStore, Shipping, Pricing, PO, BOM, WIP, MRP, ENG, ASCP, CRP, Demantra, PLM, ODP, WMS, EAM, TCA, Service Contracts, Install Base, OSO, Quoting, Configurator, HRMS, OTL, Self Service, AOL, System Administration)

Languages: SQL, PL/SQL, JAVA, HTML, XML, COBOL, JCL, C and C++.

Software Tools: Oracle Developer (Forms 6i/6, Reports6i/6), Oracle Developer 2000(Oracle Forms 5.0/4.5, Oracle Reports 3.0/2.5), SQL*LOADER, UNIX Shell Scripting, SQL*Forms 3.0, SQL*Reports 1.0, PRO * C, Discoverer v 4I, TOAD, Oracle Designer v 6i/6/2000, JSP, JDBC, ADI, Data Load, Kronos, EDI, Ceridian, Daily Business Intelligence, Oracle Portals, Microsoft Visio, Data Loader.

Databases: Oracle 10g/9i/8i/8.0/7.x, SQL Server

Hardware: Sun Solaris 6500/4500, HP 9000, RS6000, IBM PC and Compatible, Pentium based machines, Sun Sparc Workstation.

Operating Systems: MS-DOS 6.x, Windows 95, Windows NT 4.0, Windows 2000/XP, UNIX, Linux, Sun Solaris and AIX 4.3.1

PROFESSIONAL EXPERIENCE:

Confidential, Colorado Springs, CO

Sr. Oracle ERP Supply Chain Solutions Lead Architect

Responsibilities:

• As a Sr. Oracle Supply Chain Solutions Lead, Supported Oracle Applications v 12.1.3 Business Systems and given answers to the Super Users Team, Business users and Development team questions around the world.
• Resolved production issues related to Oracle Supply Chain modules INV, BOM, WIP, ASCP, OM, PO, iProcurement and Oracle MES on daily basis.
• Designed Functional Specs and reviewed the specs with Super Users Teams and Business Users before submitting to the development teams.
• Evaluated / Investigated / Analyzed / Recommended different MES products including Oracle MES for Keysight Technology Centers requirements around the world.
• Delivered Camstar MES - Oracle EBS Integration inbound and outbound Oracle EBS interfaces solutions for Santa Rosa and Colorado Springs operations.
• Delivered Fusion Middleware solution to communicate Santa Rosa and Colorado Springs Operations data between Oracle EBS & Camstar MES systems.
• Enabled Jitterbit middleware solution for Camstar MES & Oracle EBS systems in production environments.
• Designed / Developed / Tested and Implemented Oracle MES Solutions for Keysight Technology Centers around the world.
• Evaluated / Investigated / Analyzed / Designed / Implemented Oracle iProcurement punchout, smart forms functionality around the world
• Responsible for the entire Oracle Supply Chain modules INV, BOM, WIP, OM, PO, ASCP, iProcurement modules configuration setups, implementations for multiple sites around the world
• Involved in analyzing the Business Processes and Functional Requirements and mapping it with the features of Oracle Applications Supply Chain modules
• Studied the existing business processes and arrived at the optimized TO-BE Process.
• Involved with Fit-Gap Analysis, Solution Design Phase. Mapped Legacy systems to Oracle Application Supply Chain modules and helped in decommissioning of legacy systems
• Created BR030s, BR100s documents of Oracle INV, BOM, WIP, OM, PO and ASCP modules.
• Created conversion mapping documents of Items, Routings, BOMs, open Discrete Jobs and validated the converted data in Oracle for multiple Organizations.
• Created Functional Specs for core interfaces between Oracle ERP and MES product.
• Explained the Functional Specifications to development team and co-coordinated all Business questions and answers with Business Process Owners.
• Experience in working with Oracle Applications modules for resolving functional and technical related issues and raising SRs with Oracle
• Enabled Camstar MES system Oracle databases requirements solution for Development, Test and Production environments in Exadata machines and provided consultancy work to Infrastructure &Technology track needs of MES program.
• Followed AIM methodology and created BR030, BR0100, MD050 etc... AIM documents

Environment: Oracle Applications 12.1.3/11.5.10 (Inventory, BOM, WIP, ASCP, OM, PO, CST, GL, AP, AR, FA, CRM, iProcurement, Oracle MES and HRMS), PL/SQL, SQL*Loader, SQL*Plus, Reports 6i, Forms 6i, DBI, XML Publisher, OA Framework, Oracle Workflow, Oracle Discoverer, Remedy and Unix.

Confidential, Denver, CO

Sr. Oracle ERP Supply Chain Functional Consultant - Oracle ERP Production Support Engineer

Responsibilities:

• As a Sr. Oracle Supply Chain Consultant, Supported Oracle Applications v 11.5.10.2 Business Systems and given answers to the Super Users Team, Business users and Development team questions in North America region.
• Resolved production issues related to Oracle Supply Chain modules INV, BOM, WMS, OM, PO, OKS, iProcurement and IB on daily basis.
• Designed Functional Specs and reviewed the specs with Super Users Teams and Business Users before submitting to the development teams.
• Responsible for Oracle Applications 11i systems and resolved support tickets on daily basis
• Responsible for the entire Oracle Supply Chain modules INV, BOM, WMS, OM, PO, OKS, IB, FS, iProcurement modules configuration setups, production support tickets for multiple sites in North America
• Involved in analyzing the Business Processes and Functional Requirements and mapping it with the features of Oracle Applications Supply Chain modules
• Studied the existing business processes and arrived at the optimized TO-BE Process.
• Involved with Fit-Gap Analysis, Solution Design Phase. Mapped Legacy systems to Oracle Application Supply Chain modules and helped in decommissioning of legacy systems
• Updated BR030s, BR100s documents of Oracle INV, BOM, WMS, OM, PO and OKS modules.
• Created conversion mapping documents of Items, Routings, BOMs, open Discrete Jobs and validated the converted data in Oracle for multiple Organizations.
• Supported Core Processes like Order Import, Auto Sourcing and Auto Receiving business processes in Oracle Supply Chain modules
• Explained the Functional Specifications to development team and co-coordinated all Business questions and answers with Business Process Owners.
• Experience in working with Oracle Applications modules for resolving functional and technical related issues and raising SRs with Oracle
• Followed AIM methodology and updated BR030, BR0100, MD050 etc... AIM documents

Environment: Oracle Applications 12.1.3/11.5.10 (Inventory, BOM, WMS, OM, OKS, IB, PO, CST, GL, AP, AR, FA, CRM, iProcurement, iSupplier and HRMS), PL/SQL, SQL*Loader, SQL*Plus, Reports 6i, Forms 6i, DBI, XML Publisher, OA Framework, Oracle Workflow, Oracle Discoverer, Remedy and Unix.

Confidential, Greenville, SC

Sr. Oracle Manufacturing Functional Consultant

Responsibilities:

• Responsible for upgrading Oracle Applications 11i system to Release 12.1.3 Implementation.
• Configured and Implemented Oracle Applications Release 12.1 MES functionality for shop floor activities
• Responsible for the entire Oracle Manufacturing INV, BOM, WIP, ENG, MRP and ASCP modules configuration setups, implementations for multiple sites in North America and Global Support in Oracle Manufacturing modules
• Involved in analyzing the Business Processes and Functional Requirements and mapping it with the features of Oracle Applications manufacturing modules
• Studied the existing business processes and arrived at the optimized TO-BE Process.
• Involved with Fit-Gap Analysis, Solution Design Phase. Mapped Legacy systems to Oracle Application manufacturing modules and helped in decommissioning of legacy systems
• Created BR030s, BR100s documents of Oracle INV, BOM, WIP, MRP, ENG and ASCP modules.
• Created conversion mapping documents of Items, Routings, BOMs, open Discrete Jobs and validated the converted data in Oracle for multiple Organizations.
• Created Functional Specs for Core Processes like Outside Processing product and Subcontract business processes in Oracle Manufacturing modules
• As a Sr. Oracle Manufacturing Functional Consultant, Supported Business Systems and given answers to the Super Users Team, Business users and Development team questions in North America region.
• Designed Functional Specs and reviewed the specs with Super Users Teams and Business Users before submitting to the development teams.
• Explained the Functional Specifications to development team and co-coordinated all Business questions and answers with Business Process Owners.
• Resolved WIP stuck transactions and pending transactions every month end close activities
• Resolved MRP plans failure issues and recommended performance improvement in MRP plans
• Followed AIM methodology and created BR030, BR0100, MD050 and etc... AIM documents

Environment: Oracle Applications 12.1.3/11.5.10 (Inventory, BOM, WIP, ENG, MRP, ASCP, RCCP, WMS, CST, OM, PO, GL, AP, AR, FA, CRM and HRMS), PL/SQL, SQL*Loader, SQL*Plus, Reports 6i, Forms 6i, DBI, XML Publisher, OA Framework, PLM, Oracle Workflow, Oracle Discoverer and Unix.

Confidential, Denver, CO

Sr. Oracle Manufacturing Functional Analyst - Oracle Production Support and Release 12.1 Upgrade

Responsibilities:

• Designed and Implemented Interface between Power Transmission Specifications legacy system(PTS) and Oracle Applications to create Items/Routings/BOMs in Oracle system
• Responsible for upgrading Oracle Applications 11i system to Release 12.1 Implementation.
• Configured and Implemented Oracle Applications Release 12.1 MES functionality for shop floor activities
• Responsible for the entire Oracle Manufacturing INV, BOM, WIP, ENG, MRP and ASCP modules configuration setups, implementations for multiple sites in North America and Global Support in Oracle Manufacturing modules
• Involved in analyzing the Business Processes and Functional Requirements and mapping it with the features of Oracle Applications manufacturing modules
• Studied the existing business processes and arrived at the optimized TO-BE Process.
• Involved with Fit-Gap Analysis, Solution Design Phase. Mapped Legacy systems to Oracle Application manufacturing modules and helped in decommissioning of legacy systems
• Created BR030s, BR100s documents of Oracle INV, BOM, WIP, MRP, ENG and ASCP modules.
• Created conversion mapping documents of Items, Routings, BOMs, open Discrete Jobs and validated the converted data in Oracle for multiple Organizations.
• Created Functional Specs for Core Processes like Outside Processing product and Subcontract business processes in Oracle Manufacturing modules
• As a Manufacturing Functional Analyst, Supported Business Systems and given answers to the Super Users Team, Business users and Development team questions in North America region.
• Designed Functional Specs and reviewed the specs with Super Users Teams and Business Users before submitting to the development teams.
• Explained the Functional Specifications to development team and co-coordinated all Business questions and answers with Business Process Owners.
• Resolved WIP stuck transactions and pending transactions every month end close activities
• Resolved MRP plans failure issues and recommended performance improvement in MRP plans
• Followed AIM methodology and created BR030, BR0100, MD050 and etc... AIM documents

Environment: Oracle Applications 12.1/11.5.9 (Inventory, BOM, WIP, ENG, MRP, ASCP, RCCP, WMS, CST, OM, PO, GL, AP, AR, FA, CRM and HRMS), PL/SQL, SQL*Loader, SQL*Plus, Reports 6i, Forms 6i, DBI, XML Publisher, OA Framework, PLM, Oracle Workflow, Oracle Discoverer and Unix.

Confidential, Dublin, OH

Sr. Oracle Manufacturing Functional Analyst

Responsibilities:

• Responsible for the entire Oracle Manufacturing INV, BOM, WIP, ENG, MRP and ASCP modules configuration setups, implementations for multiple sites around the world and Global Support in Oracle Manufacturing modules
• Involved in analyzing the Business Processes and Functional Requirements and mapping it with the features of Oracle Applications manufacturing modules
• Studied the existing business processes and arrived at the optimized TO-BE Process.
• Involved with Fit-Gap Analysis, Solution Design Phase. Given User and created documents.
• Created BR030s, BR100s documents of Oracle INV, BOM, WIP, MRP, ENG and ASCP modules.
• Designed Functional Specs MD050s and CV040s for RICE objects for Manufacturing modules
• Created conversion mapping documents of Items, Routings, BOMs, open Discrete Jobs and validated the converted data in Oracle for multiple Organizations.
• Created Functional Specs for Core Processes like Outside Processing product Sterilization and Subcontract business processes in Oracle Manufacturing modules
• Implemented Oracle Component Pick Release functionality for warehouse staging material for Discrete Jobs in Work in Process module
• Extensively worked on Inventory, Bill of Materials, Work in Process, MRP and Engineering modules for Multi-Orgs. Performed CRPs, UAT and Business users in oracle manufacturing modules
• As a Manufacturing Functional Analyst, Supported Business Systems and given answers to the Super Users Team, Business users and Development team questions around the world.
• Designed Functional Specs and reviewed the specs with Super Users Teams and Business Users before submitting to the development teams.
• Explained the Functional Specifications to development team and co-coordinated all Business questions and answers with Super Users Team and Business Users.
• Followed AIM methodology and created BR030, BR0100, MD050 and etc... AIM documents

Environment: Oracle Applications 12/11.5.10.2 (Inventory, BOM, WIP, ENG, MRP, ASCP, WMS, CST, OM, PO, GL, AP, AR, FA, CRM and HRMS), PL/SQL, SQL*Loader, SQL*Plus, Reports 6i, Forms 6i, DBI, XML Publisher, OA Framework, QAD, Oracle Workflow, Oracle Discoverer and Unix.

Confidential, Houston, TX

Oracle Manufacturing Functional Analyst

Responsibilities:

• Responsible for the entire Oracle Manufacturing INV, BOM, WIP, MRP, ENG, PJM and Costing modules Setups, Implementation and Support.
• Involved in analyzing the Business and Functional Requirements and mapping it with the features of Oracle Applications.
• Studied the existing business processes and arrived at the optimized TO-BE Process.
• Involved with Fit-Gap Analysis, Solution Design Phase. Given User and created documents.
• Designed GE Rulestream Configarator Interface Functional Specs from GE to Powell and reviewed the specs with Process Teams for approval.
• Created BR030s, BR100s documents of Oracle INV, BOM, WIP, MRP, ENG and PJM modules.
• Designed Functional Specs MD050 of GE Rulestream Configurator Interface from GE to Powell and Shop Floor Reports. Also created MD050s for new Manufacturing modules RICE objects.
• Created conversion mapping documents of Items, Routings, BOMs, open Discrete Jobs and validated the converted data in Oracle for multiple Organizations.
• Created Functional Specs for Core Processes like CAD-To-Oracle to create Items, Routings and BOMs for multiple organizations from AUTOCAD to Oracle system.
• Designed custom Paint Code process to update the Discrete Jobs with Paint information from Bills and Inventory for multiple Organizations.
• Designed Material Transactions Interface for Copper Material.
• Configured Kanban Functionality and Designed Kanban Paint Code process to carry Paint information from Kanban to Discrete Jobs.
• Designed and Tested MRP Discrete Job Auto Release Enhancement to create Jobs underneath Unit BOMs/Discrete Assemblies/Phantoms automatically when we release from MRP Workbench.
• Designed and Tested split Sales Order Line solution to ship big products which can’t fit into one container or truck.
• Extensively worked on Inventory, Bill of Materials, Work in Process, MRP and Engineering modules for Multi-Orgs. Involved in new Projects process like Initiating Demand from Projects module along with OM. Experience with ATO Models / ATO Items process.
• Key processes are CAD-to-Oracle, Rulestream Interface from GE to Powell, Paint Code, Material Transactions and ECO process. Supported standard MRP process failure issues.
• As a Manufacturing Lead, Supported Business Systems and given answers to the Process Team, Business users and Development team questions.
• Designed Functional Specs and reviewed the specs with Process Teams and Business Users before submitting to the development teams.
• Explained the Functional Specifications to development team and co-coordinated all Business questions and answers with Process Teams and Business Users.
• Followed AIM methodology and created BR030, BR0100, MD050 and etc... AIM documents

Environment: Oracle Applications 11.5.10 (Inventory, BOM, WIP, ENG, MRP, ASCP, WMS, CST, OM, PO, GL, AP, AR, FA, CRM, Projects, and HRMS), PL/SQL, SQL*Loader, SQL*Plus, Reports 6i, Forms 6i, DBI, XML Publisher, OA Framework, Ceridian, EDI, Oracle Workflow, Oracle Discoverer and Linux.

Confidential, Houston, TX

Oracle Manufacturing Functional Analyst - Global Singular Processes

Responsibilities:

• Involved in analyzing the Business and Functional Requirements and mapping it with the features of Oracle Applications.
• Studied the existing business processes and arrived at the optimized TO-BE Process.
• Involved with Fit-Gap Analysis, Solution Design Phase. Given User and created documents.
• Responsible for the creation of the MD 50 documents for new RICE objects.
• Created BR 100 setups documents of Oracle Inventory, BOM, WIP, MRP and ECO modules.
• Responsible for Oracle Manufacturing INV, BOM, WIP, MRP, ENG and PJM modules Setups, Implementation and Support. Created BR030 documents.
• Responsible for critical Extensions design which includes Notification of Revision Change, Notification of Released Items, Mass Update on Routings, Account Generator, Receipt Traveler and etc...
• Setups of BOM- Bill of Materials Parameters, Department Classes, Resources, Locations, WIP Accounting Classes.
• Worked with full life cycle like creation of Items, creation of BOM structure, assembling in WIP, copying to Multi-Org.
• Provided ABC assignments for items with serial control.
• Involved in data mapping and data conversion of Items, Routings, BOMs, Suppliers, Open Purchase Orders, Quotes, Sourcing Rules, and Approved Suppliers List for Multi-Org.
• Analysis of all scenarios/paths a purchase requisition can go through and the issues that may occur.
• Project phases include process study, Conference Room Pilots, Functional implementation, Integration testing, User Acceptance Testing.
• Implemented WIP with outside processing (OSP) for handling the Contract Manufacturing.
• Designed Custom Shipping Solution for Large Compressors.
• Extensively worked on Inventory, Bill of Materials, Work in Process, MRP and Engineering modules for Multi-Orgs.
• Lead the effort of 81 RICE Objects design, development and implementation with outsourcing company in India.
• Explained the Functional Specifications to Outsourcing development team and co-coordinated all questions and answers with Process Teams.
• Reported RICE design, development and Implementation strategy and status to PMO and Process Teams.
• Guided offshore development teams and Tested critical RICE Objects on-site.
• Successfully Implemented 81 RICE Objects for Multiple countries.

Environment: Sun Solaris, Oracle Applications 11.5.10 (Inventory, BOM, WIP, MRP, ENG, ASCP, WMS, CST, OM, Shipping, PO, Quality, GL, AP, AR, FA, iProcurement, CRM, Projects, and HRMS), PL/SQL, SQL*Loader, SQL*Plus, Reports 6i, Forms 6i, BPEL, DBI, Oracle Portal, XML Publisher, OA Framework, Kronos, Aventx, TradePoint and Mercury ITG

Confidential, Trumbull, CT

Oracle Applications Functional Analyst

Responsibilities:

• Analyzed the business processes (especially order flows) and gathered the requirements and designed the functional specifications.
• Study/Understand the Setups, Defining functional specs for Reports and application implementation.
• Designed materials for the users and was involved in testing.
• Provided post production support.
• Designed Specs for custom Bulk Order Processing Process. Worked with users in UAT.
• Created Technical Design Documents for Reports based on the User Interaction.
• Led critical RICE Objects design, development and implementation effort.
• Worked on Customer definition and defining Price Lists, Modifiers. Also worked on order cycle and order import process.
• Utilizing all features provided in 11i for easy operation and user-friendly approach.

Environment: Oracle Applications v 11i/11.5.9(AR, OM, Service Contracts, Install Base, INV), Oracle 9i/ 9.2.0.4.0/8 i, XML, SQL, PL/SQL, SQL*Loader, Unix, FTP, Window NT/2000, Oracle Discoverer v 4i, Oracle Reports v 6i, Oracle Forms v 6i, Oracle Workflow, JSP, Lotus Notes, Kintana and Toad

Confidential, Raleigh, NC

Oracle Applications Functional Consultant

Responsibilities:

• Studying the existing Order Management (Order to Cash) process - As is Analysis.
• Mapping the transactions relevant for client and ascertaining workarounds. Application setups review to make existing business processes work
• OM modules setups for solution pilot - prototyping of To Be process flows and framing of Oracle application test scenarios.
• CRP and Integration testing for the modules and comprehensive of Oracle Applications modules for clients core team.
• Provided implementation support for Order Management modules.
• Prepared standard operating procedure for modification/changes to the setup documents.
• Setting up production instance with OM parameters - look up codes, parameters and descriptive flex fields.
• Setting up production instance with shipping parameters parameters, exceptions, picking rules, pick slip grouping rules, sequence rules and release rules.
• Troubleshooting shipping transactions as member of OM competency center.
• Study/Understand the Setups, Defining functional specs for Reports and application implementation. Created MD050s for Reports.

Environment: Oracle Applications v 11i/ 11.5.9/11.5.8 (AR, OM, INV, PO, WSH, PA, Service Contracts, Sales, TCA), Oracle 9i/ 9.2.0.4.0/8 i, XML, SQL, PL/SQL, SQL*Loader, Unix/Linux, FTP, Window NT/2000, Oracle Discoverer v 4i, Citrix, Oracle Workflow, Oracle Reports v 6i, Oracle Forms v 6i, Java, Servo, JSP and Tora

Confidential, Alameda, CA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Created Setups for Check Printing Programs of AP for different operating units.
• Worked on Check Printing Reports of AP for USA, CANADA, UK, and FRANCE Countries.
• Converted 10.7 reports to 11i with necessary changes in table and column structures.
• Customized Invoice Print Batch of Invoices, Invoice Print Selected Invoices and Invoice Print New Invoices of AR Reports for different Operating Units.
• Created Technical Design Documents for Reports based on the Functional Specs and User Interaction.
• Worked with offshore development team to resolve the issues after development.
• Worked on RICE objects implementation activities.
• Developed Report Names are WRS - Domestic Format Payments, WRS - Canadian Format Payments, WRS - UK Format Payments (Evergreen Laser), WRS - Lettre Cheque, WRSCM - A/P Outstanding Checks Report, WRSCM - Payroll Outstanding Checks Report, WRSOE - Quote Notification, WRS Shipping Proforma Invoice, WRSOE - Quote Report With Dollars, WRS - Install Key, WRS - Detailed Fixed Asset Register and WRSAR - Aged Trial Balance - 4 Buckets Reports.
• Generated XML outputs for Adobe Team (JetJForms).
• Created PL/SQL Packages, Procedures, Functions, and Concurrent Program scripts.
• Created SQL Queries and Value Sets. Worked with different Country Users in UAT Instance and given production support.
• Created reports using Oracle Discover v 4i.

Environment: Oracle Applications v 11i/11.5.9(AP, AR, OM, PO, INV, BOM, WIP, FA, Shipping, Service Contracts, Cash Management, Install Base), Oracle 9i/ 9.2.0.4.0, XML, SQL, PL/SQL, Unix, FTP, Window NT/2000, Oracle Discoverer v 4i, Oracle Reports v 6i, Oracle Forms v 6i, Java, Microsoft Outlook, Citrix, and Toad

Confidential, Louisville, KY

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Designed, Developed and Tested new ‘Operating Budget’ reports of Oracle Public Sector Budgeting Module in Oracle Reports v 6i.
• Customized ‘Stage Variance Report’ of Oracle Public Sector Budgeting Module.
• Designed, Developed and Tested new ‘Expenditures, Operating Budget and Capital’ reports of Oracle General Ledger Module in Oracle Reports v 6i.
• Customized ‘General Ledger - (180 Char), Account Analysis - (180 Char)’ reports of Oracle General Ledger Module.
• Designed, Developed and Tested new reports of Oracle Accounts Payables Module in Oracle Reports v 6i.
• Customized ‘Supplier Payment History, Supplier Paid Invoice History, Preliminary Payment Register, Final Payment Register, 1099 Forms) reports of Oracle Accounts Payables Module.
• Customized ‘Asset Retirements, Asset Additions) reports of Oracle Fixed Assets Module.
• Designed, Developed and Tested new (Depreciation Expense Schedule, Capital Assets) reports of Oracle Fixed Assets Module in Oracle Reports v 6i.
• Customized ‘Print Purchase Order, Encumbrance Detail, Printed Requisitions’ reports of Oracle Purchasing Module.
• Designed, Developed and Tested new reports of Oracle Purchasing Module in Oracle Reports v 6i.
• Designed, Developed and Tested new reports of Oracle Accounts Receivables Module in Oracle Reports v 6i.
• Extensively worked on PDF and Text reports. Converted Text reports into PDF reports and PDF reports into Text reports.
• Worked on RICE Objects design, development and implementation.
• Created Concurrent Programs, Value Sets in Oracle Applications v 11i for new and customized reports and also for PL/SQL packages.
• Designed, Developed and Tested Custom Views and setup security of reports.
• Designed, Developed, and Tested SQL Queries.
• Designed, Developed and Tested, Functions, Procedures and PL/SQL Packages.
• Created and documented custom tables.
• Given Production Support.
• Worked on both Oracle Discoverer 4i Desktop and Administration Editions.

Environment: Oracle Applications v 11i/11.5.9(PSB, GL, AP, PO, FA, AR), Oracle 9i/8i, SQL, PL/SQL, Unix, FTP, Window NT/2000, Oracle Reports v 6i, Oracle Forms v 6i, Java, Microsoft Outlook, Oracle Workflow, SQL Navigator, Oracle Discoverer v 4i/4.1.46, Toad and AIX

Confidential, Troy, MI

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Involved in Accounts Payables Module Business Area Testing.
• Involved in Documentation of AP, GL, FA, and GL BIS, PO, INV Modules Properties.
• Involved in Data Mapping of AP, GL, GL BIS, FA, PO, and INV Modules to EDW WH EUL US TO PSYM production schema and Testing.
• Involved in Data Mapping of Order Management, Advanced Pricing and Shipping Modules to EDW WH EUL US TO PSYM production schema and Testing.
• Involved in Creation of Item Classes for Order Management, Advanced Pricing and Shipping Modules and Testing. Involved in Creation of Item Classes for AP, GL, FA, PO, INV and Testing.
• Involved in Moving and Documentation of Discoverer reports to Production.
• Involved in Design, Development and Testing of Item Master Folder.
• Created joins in ‘Accounts Payable’ Business Area.
• Involved in Registration of PL/SQL packages in Oracle Applications and Testing.
• Involved in Testing, Registration of Oracle Reports in Concurrent Manager and notifying user via email after completion of report execution.
• Involved in Design, Development, and Testing New Business Area and New folders in Oracle Discover v 4i Administration Edition.
• Involved in Security and Privileges Setup in Oracle Discoverer v 4i.
• Extensively worked on both Oracle Discoverer 4i Desktop and Administration Editions.
• Involved in Design, Development, Testing and Scheduling of Workbooks using Oracle Discoverer v 4i.
• Created and Tested Custom Views.
• Involved in Design, Development and Testing of SQL Queries.
• Involved in Design, Development and Testing of PL/SQL Packages.
• Designed, Developed and Tested new reports and customized standard reports of Oracle Financials Modules using Oracle Reports v 6i and registered them in Oracle Applications v 11i.
• Customized ‘Account Status Report’ and ‘Transaction Detail Report’ of Oracle Receivables Module.
• Created Public Synonyms.

Environment: Oracle Discoverer v 4i/4.1.46, Oracle Applications v 11i/11.5.8(INV, PO, AP, GL, AR, FA, OM, Advanced Pricing, Shipping, BOM, WIP), Oracle 9i/8i, Oracle Workflow, SQL, PL/SQL, Unix, FTP, Window NT, Oracle Reports v 6i, Oracle Forms v 6i, Java, Microsoft Outlook, eRoom, PVCS, Toad

Confidential, Columbus, Ohio

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Designed Developed, Tested Oracle Procedures, Functions, and Packages.
• Designed Developed and Tested Oracle Database triggers.
• Involved in Integration, User Acceptance Testing and Production Support.
• Designed Unit Test Cases. Interacted with User’s to discuss issues and provide solutions.
• Designed, Developed and Tested SQL queries.
• Designed Unit Test Cases.
• Designed and developed test scripts.
• Designed and documented product release documents.
• Involved in uploading and downloading of files using FTP.
• Designed, Developed and Tested new reports and customized standard reports of Oracle Financials Modules using Oracle Reports v 6i.
• Designed and developed complete Invoice Import interfaces for import of Invoice information into the system. Used SQL * Loader for import into interface table and PL/SQL block for complete validation of data and inserting into base tables.
• Designed and developed Customized Invoice Reports. The reports are Vendors Audit Report, Duplicate Payments Report, and Net Open Items Report. And also involved in Flex fields setup and AOL.
• Involved in registration of new reports in Oracle Applications.
• Redesigned and developed Discoverer reports in Oracle Applications.
• Design, Development and Testing of reports using Discoverer v 4I.

Environment: Oracle 8i/8.1.7, Oracle Applications v 11i/11.5.7(AP, PO, AR, GL, INV), SQL, PL/SQL, SQL*LDR, Oracle Reports v 6i, Oracle Forms v 6i, Discoverer v 4I, AIM, Toad, Microsoft Outlook, Java, FTP, Unix, SQL*LDR, Windows 2000