SUMMARY:

• Having 8.9 years of extensive experience on Oracle E - Business Suite different versions on Implementation, Upgrades & Support of multiple business processes.
• Having rich technical experience on Oracle E-business technical stacks - SQL, PLSQL, Forms, Reports, XML Publisher reports, Interfaces / API’s, conversions, workflows, Oracle Database objects, Alerts, AOL’s and shell scripts. Holding good hands on experience on Java, J2ee, BPEL, SOA and ADF Technologies.
• As Techno-Functional consultant involved in business requirement gathering & analysis, design and development of E-Business suite extensions with optimized/best solutions to meet business definitions/requirements accurately.
• Strong technical hand hold knowledge on E-business suite 11i and R12 different modules/process Oracle Inventory, Oracle Bill of Materials, Supply Chain Planning, Oracle Sourcing, Oracle iSuppliers, Oracle Work in Process, Oracle Purchasing, Oracle Release Management, Order Management, Oracle Payables, Receivables, General Ledger, HRMS, Fixed Assets and iProcurment.
• Holding around 3 years of experience of on-site coordinator / SPOC for Sony & Teyseer delivery projects in parallel of individual deliveries.
• Immense experience on upgrade projects (from 11.5.7 to 11.5.10 and 11i to R12) from end to end.
• Good knowledge on Functional setup of Oracle iSuppliers, Oracle Inventory, Purchasing, Order management, Oracle Bill of Materials, Oracle Work in Process, iProcurement setups in 11.5.10 and R12.2.x versions.
• Strong working knowledge on customer reports/statements design & development by using XML templates and Advanced Queuing concepts.
• Good Knowledge on AIM Methodology & having understanding on OUM methodology
• High potentiality to learn / adopt new environments quickly; holding strong communication exhibited by skill in working closely with customers to identify and resolve problem; ability to convey technical concept to non-technical audiences.

TECHNICAL SKILLS:

Development Tools: Oracle Developer Suite (6i & 10g), PL/SQL, SQL* Plus,SQL* Loader, BPEL/SOA, Toad, XML Publisher, JDeveloper 9i (ADF and OAF) and Workflow.

Oracle E: business Suite 11.5.10 and R12.2.x Manufacturing and distribution (INV, WIP, BOM, MRP, OM, PO, GL, iProc, iSupliers, Oracle Planning, CRM and RLM)

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

RDBMS: Oracle 7.x/8i, Oracle 9i and Oracle 11g

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

Version Control Tools: Microsoft Visual Source Safe, PVCS, Tortoise SVN, Microsoft Kintana Tool, and E-room

PROFESSIONAL EXPERIENCE:

Confidential

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/data fixes/solutions for our customer.
• Gather requirement from the business and provided technical solutions, work along with off-shore team.

Confidential

Senior Analyst

Responsibilities:

• Worked with Oracle Product Support for getting various bug fixes/data fixes/solutions for our customer.
• Did functional setups like Inv Organization, Org Parameters, Locations, Sub-inventories, Purchasing and 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

Team Lead, On-Site

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.
• Developed Oracle 10G Forms.
• Forms personalization
• Customizations on Standard Reports and developed new repots.

Confidential

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

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

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

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

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