SUMMARY:

• Over twenty years of experience in developing business and financial applications in the ERP, Client/server, Object Oriented technology
• Leadership qualities in managing teams, in facilitating key management decisions, presentation skills at any level.
• Well conversant with Oracle’s AIM methodology. Green - Belt Certified
• Proven track-record of working with leading companies like Confidential and Cisco
• Extensive techno-functional experience working on Oracle Financials and Supply Chain modules as a lead person. Extensive experience in the Functional and Technical areas of iProcurement, BOM, Routing, PO, AP, iSupplier Portal, OM, Inventory and AME
• Worked in Oracle Applications R12, 11.5.10, 11.5.9, 11.5.8, 11.5.3, 11.03, 10.7
• Good experience working on interfaces, conversions, Unix Korne Shell programming and UTF8 conversions.
• Very strong in Oracle database programming, creating fuction, procedures,packages and triggers.
• Extensively worked in Upgrading of workflows/customizing in Family Pack G, Family Pack H, Family pack I and Family Pack J using Workflow Builder.
• Extensively worked on Forms 6i and Reports 6i.
• Good Analysis, Design and Programming skills
• Extensive experience developing reports in Oracle APEX
• Comprehensive experience customizing Workflows Strong exposure to System Administration and Application Object Libraries

SKILL:

Application: Oracle iProcurement, Oracle Purchasing, BOM, Routing, WIP, Sourcing, iSupplier Portal, Inventory, Order Management, Account Payables, Work Flow and AOL

Languages & Tools: Oracle Workflow 2.6, Developer 2000, Forms 6i/Reports 6i, Oracle APEX

Databases: ORACLE-7.3, ORACLE-8, ORACLE-8i, ORACLE-9i

Operating System: UNIX, Windows 2000

Hardware: IBM-PC Compatibles

PROJECT EXPERIENCE:

Confidential, Washington, DC

Oracle Applications Technical Consultant

Responsibilities:

• Upgrading the system to R12.
• Creating document on mapping 11i tables with R12 tables.
• Debugging issues
• Modify all Procedures/packages/triggers based on the new TCA architecture.
• Performance Tuning of long running query.
• Working on SR with Oracle
• Customization of Workflow
• Creation of reports in Discoverer
• Upgraded FMS system to R12 in 8 months.
• Created a generic script to create a flat file for any sql passed and in any format or separator.

Confidential, Raleigh, North Carolina

Oracle Applications Technical Consultant

Responsibilities:

• Developed a custom BOM Conversion using APIs
• Developed Customer Item Conversion Program .
• Developed Customer Item cross Conversion Program.
• Development of Routing Conversion Program
• Development of Sourcing Rule Conversion
• Creating interface for deleting inactive items .
• Creating Item load Interface.
• Setup of Forecast Sets and Forecast Designators
• Customization of Workflow
• Designing and testing customizations and enhancements
• Developing OM conversion specifications and programmatic conversion processes
• Working tars, testing patches
• Developed Informatica mappings by using Slowly Changing Dimensions.
• Extensively worked on the Performance Tuning of mappings and sessions.
• Creating Oracle PL/SQL Procedures/functions/tables/Indexes
• Creating scripts for ftp of files.
• Performance tuning of queries

Confidential, Charlotte, North Carolina

Oracle Applications Technical Consultant

Responsibilities:

• Define Purchasing cycle.
• Define suppliers & Approved supplier list.
• Customization of Workflow.
• Define Items, item attributes.
• Creating interface for deleting inactive items.
• Creating Item load Interface.

Confidential, New York

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Gathering Business requirements.
• Creating Functional and Technical documents.
• Present the solution to the Business users.
• Setup for PO/Requisition workflow in Purchasing. Of HR Interface
• Troubleshooting Production HR Issues
• Customizing T&L HR Workflow.
• Working on development
• Developing document viewer in Oracle APEX team members on Oracle APEX
• Perform SYSADMIN setup, Profile setup.
• Setting up timeouts for notification escalation in iExpense.
• Integration of AMEX with iExpense
• Involved in Project design and development of purchasing functionality
• Customizing and Upgrading PO, autocreate, requisition initiated change order and requisition workflows .
• Writing Procedures, functions, Packages and triggers.
• Development of Forms for custom setup tables.
• Customization of Invoice Approval workflow using AME.
• Working on Production issues.
• Performance tuning of High cost queries.
• Generating Trace file for debugging issues.
• Working on TAR with Oracle
• Testing
• Development of Forms for custom setup tables.

Confidential, NC

Oracle Applications Technical Consultant

Responsibilities:

• Gathering Business requirements.
• Working as IT Analyst for HRMS.
• Data mapping of required fields in HRMS.
• Working on upgrade from 11. for iProcurement, Purchasing and HR.
• Analysis on the new functionality in R12.
• Creation of Table Space.
• Customization of iExpense workflow.
• Calculation of backup space requirement for financial tables in Archive schema.
• Creating FSD
• Developing HR Interface
• Customizing Workflows.
• Modification of Form and Report as per business requirement.
• Customization of Invoice Approval workflow.
• Working on Production issues.
• Testing
• Group the requisition based on requestor, supplier and description
• Escalation process
• Stop autocreate for the requisition, which are not touchless, and these requisition should not be visible in autocreate pool.
• Sends Email to the concerned person with relevant error message making the Requisition incomplete
• One time script to create Contracts.
• Script to create autobuyer employees and users

Confidential, CO

Oracle Applications Technical Consultant

Responsibilities:

• Upgrading PO and requisition and OM workflow .
• Gathering requirements for iSupplier customization
• Giving Demo of iSupplier to users.
• Testing of customization.
• Documentation and knowledge transfer to Confidential technical team.

Confidential, FL

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Conduct meeting with Cincom team members and understanding the requirement.
• Enhancement of GL Interface
• Setup and Implementation of OFA.
• Involved in the development of Reports, Interfaces, Conversions, customization of Workflow
• Developed a custom BOM conversion using oracle APIs to load BOM from custom application
• Created triggers on order lines to perform custom validations.
• Designed and developed custom workflow Item types to send notifications from Concurrent Programs/PL-SQL procedures.
• Prepare mapping between oracle and cincom field.
• Preparing extract file layout required for each conversion
• Identifying Translation/Derivation required for mapping.
• Preparing Technical design document in CV60 format for Conversion
• Preparing Technical design document in MD70 format for Interface
• Coordinating with offshore in development of code
• Development at Onsite
• Preparing UTC document.
• Testing of conversion.
• Preparing MD120 document
• Conducting knowledge transfer sessions with GEUnison team members .

Confidential, PA

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Setups for Application
• Testing existing functionality
• Verifying setups after upgrade.
• Requirement Gathering
• Preparing test scripts and Setup document.
• Functional Specifications and Gap analysis.
• Functional design document
• Gathering Technical requirement for workflow customization.
• Resolving critical workflow issues in production quickly.
• Setup of AME rules for Invoice approval workflow.

Confidential, California

Oracle Applications Techno/Functional Consultant

Responsibilities:

• Techno/Functional consultant for iSP implementation.
• Facilitating Supplier Adoption Process
• Testing existing functionality
• Setups of Application.
• Ensure smooth functioning of iProcurement module.
• Organizing weekly status and review meetings with various users to review the modules and to discuss the wish lists.
• Tracking all the enhancement requests from the users and planning the development.
• Coordinating with offshore team for the deliveries of the production fixes and enhancements.
• Involved in analyzing the business requirement, preparation of GAP analysis documents, functional and technical specification documents.
• Conducting Conference Room Pilots and Super Users Coordinating the QA and UAT

Confidential, New York

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Testing existing functionality
• Ensure smooth functioning of iProcurement module.
• Organizing weekly status and review meetings with various users to review the modules and to discuss the wish lists.
• Tracking all the enhancement requests from the users and planning the development.
• Coordinating with offshore team for the deliveries of the production fixes and enhancements.
• Involved in analyzing the business requirement, preparation of GAP analysis documents, functional and technical specification documents.
• Leading the workflow upgrade team in upgrading workflow.
• Gathering Technical requirement for workflow customization.
• Resolving critical workflow issues in production quickly.
• Setup of AME rules for Invoice approval workflow.

Confidential, Cincinnati

Group Leader

Responsibilities:

• Requirement Analysis
• Coded
• Tested of the Maintenance Change Requests (MCR's)
• Co-ordination with the client during conference calls
• Knowledge Transfer to new team members