SUMMARY:

• Around 8.6 years of professional IT experience, Involving in Analysis, Design and Development of Oracle applications using Oracle Reports, PL/SQL on MS Windows Servers, NT and UNIX platform.
• Short term On - site Experience as single point of contact for Finance components in Doha-Qatar.
• Around 8.6 years in Oracle Application 11i ERP in development, implementing, upgrading, supporting and customizing of Oracle Inventory, Oracle Bill of Materials, Supply Chain Planning, Oracle Work in Process, Oracle Purchasing, Oracle Release Management, Order Management, Oracle Payables, Receivables, General Ledger, HRMS, Fixed Assets and iProcurment.
• Expertise in development, customization, upgradation, migration and implementation of Oracle applications 11i.
• Expertise working with Oracle 8i/9i, PL/SQL, Reports 6i, Professional Data Loader, SQL * Loader.
• Experience in developing Database Triggers, Stored Procedures, Functions and Packages, Oracle reports.
• Experience in RICE (Reports, Interfaces, Conversions, Enhancements).
• Experience in developing XML Reports, XSL Style Sheet Reports, Workflow and Oracle Application Framework.
• Experience in handling system administrator responsibilities like creating users, responsibility, request group, value sets, request set, creating executables and concurrent programs etc.
• Good knowledge in Functional setup of Oracle Inventory, Puchasing, Order management, Oracle Bill of Materials, Oracle Work in Process, iProcurement setup's in 11.5.10 apps version as well as R12.
• Good knowledge in developing the Advanced Queuing concepts.
• Good Knowledge in Java, J2ee, BPEL, SOA and ADF Technologies.
• Experienced in Designing Technical Specification Design Document.
• Strong communication exhibited by skill in working closely with customers to identify and resolve problem; ability to convey technical concept to non-technical audiences.

SKILL:

ERP: Oracle Manufacturing and distribution 11.5.10 and R12 (INV,WIP,BOM,MRP,OM,PO,GL,CRM and RLM)

Operating Systems: Win NT 4.0/2K, UNIX.

Language: C, C++, Java, J2EE, Advanced Queuing, XML Style Sheets.

Development Tools: Oracle Reports 6/6i & Forms, PL/SQL, SQL*PLUS,SQL*LOADER, ADF, BPEL, SOA, Toad, XML Publisher, JDeveloper 9i, Workflow and OAF.

RDBMS: Oracle 7.x/8i and Oracle 9i

Configuration Management Tool: Microsoft Visual Source Safe, PVCS and E-room

PROFESSIONAL EXPERIENCE:

Confidential

Modules: PO, OM, INV, AR, AP, GL, PIM.

Senior Analyst-Onsite

Responsibilities:

• Enhancement and development of new customizations like OAF forms, Oracle Forms and workflow.
• Worked on Enhancements or Change Requests i.e. understanding the CR, resolving the issue and updating the technical documents for all types of components.
• Customized and personalized Oracle Application Framework in Finance and Inventory modules.
• Automated the approval workflow process in Trade Management module.
• Provided technical feasibility study and assessment.
• Created custom form to load the data for Finished goods requests for outside users.
• Integrated the PIM, Item descriptions to capture the values in GL product value set and send multiple notifications to the customers.
• Did the form personalization to achieve business requirements.
• Implemented different types of reports like XML, d2k reports and pl/sql reports.
• Done customization to print preprinted checks.
• Developed the interface programs like suppliers, open invoices, GL transactions, GL balances for GL Interface, which takes data from the Custom Tables to interface tables and as per Clients Requirements data will be created based on their respective base tables
• Worked in Production Support for Supply Chain modules like purchasing, Inventory, Financials
• Worked with Oracle Product Support for getting various bug fixes/datafixes/solutions for our customer.
• Gather requirement from the business and provided technical solutions, work along with off-shore team.

Confidential

Modules: SCM

Senior Analyst

Responsibilities:

• Worked with Oracle Product Support for getting various bug fixes/datafixes/solutions for our customer.
• Did functional setups like Inv Organization, Org Parameters, Locations, Sub-inventories, Purchasing etc.
• Worked on Enhancements or Change Requests i.e. understanding the CR, resolving the issue and updating the technical documents.
• Worked with Production support for Supply Chain modules like purchasing, Inventory, iProcurment.
• Worked on Multilingual application Environment (Brazilian Portuguese PTB and English US ).

Confidential

Modules: OM, PO, AP, AR, GL, FA and CRM

Team Lead

Responsibilities:

• Development of business key components in Forms and Reports
• Developed of Interfaces, SQL Reports and Forms as per client business requirement.
• On-site spoc for financial components.
• Prepared Technical and Testing Documents for developed components.
• Objects Developed:
• Developed Oracle 10G Forms.
• Forms personalization
• Customizations on Standard Reports and developed new repots.

Confidential

Modules: INV,PO,AP,AR,GL

Consultant

Responsibilities:

• Development of Interfaces, SQL Reports and Forms as per client business requirement..
• Preparing Technical and Testing Documents for developed components.
• Oracle 10G Forms and Reports
• Integration between Oracle to Siebel System and Billing system
• Customizations in Workflow
• Developed Conversions and Interfaces

Confidential

Modules: OM, BOM, INV, WSH

Consultant

Responsibilities:

• Development of Interfaces, SQL Reports as per client business requirement..
• Preparing Technical and Testing Documents for developed components.

Confidential, Detroit

Modules: PO,WSH,OM,INV,AR

Consultant

Responsibilities:

• Development of Interfaces, SQL Reports as per client business requirement.
• Issues handling for the Production Support.
• Development and Customization of reports and forms.
• Carrying out Different development works as a technical consultant like developing and customizing the Reports, RICE Components and PL/SQL packages for different business requirements
• Worked as a peer review role.
• Followed Documentation as per AIM Documentation standards as well as ARM standards.
• Involved in User Acceptance Testing phase for Offshore Development Components as per standards.

Confidential, SanJose

Modules: GL,PO,FA,INV,WIP

Associate Consultant

Responsibilities:

• Requirement Gathering
• Preparing Both Technical and Functional Documents
• Carrying out Different development works as a technical consultant like developing and customizing the Reports, XML Publisher Reports, RICE Components and PL/SQL packages for different business requirements

Confidential, Boston

Modules: Oracle Order Management and Oracle Inventory

Associate Consultant

Responsibilities:

• Involved in client meetings for gathering the business requirement.
• Developed database triggers with respective to the business.
• Alert notifications by Advanced queuing concept.

Confidential, Boston

Modules: OM,WIP,BOM,INV and MRP

Associate Consultant

Responsibilities:

• Involved in client meetings for gathering the business requirement..
• Development of conversions as per client business requirement.
• Development of Interfaces as per client business requirement.
• Customization of DRP Interface Code as per the new Organizations
• Development and Customization of reports.
• Creation of technical design documents as per functional documents.
• Functional setups and testing on various modules for new Organizations. prepared the pl/sql blocks in respected areas