IT Experience:

Confidential is an Oracle Applications/Fusion Middleware Technical Consultant with 5 years of experience across various modules like AP, GL, HRMS and Purchasing. Confidential has delivered consulting solutions to design & develop cross system integration using BPEL, JMS, ESB/Mediators & other SOA technologies like BAM and ODI. He is trained on Oracle SOA 11g ,Oracle AIA 3.0 and Oracle ADF 11g.He is worked on integration of Oracle Demantra with Siebel 7.8 using Oracle Data Integrator and Oracle AIA foundation pack. He is conversant with phases of a project life cycle including design, development, implementation, customization, conversion, testing, production support and quality assurance in Oracle Applications 11.5.10 and R12.

Oracle Applications Expertise:

Implementation, Customization, Migration, Development and Testing of Oracle Applications R12 and 11i with focus on GL, AP, HRMS, OM.
Worked extensively on Interfaces (PL/SQL and SOA) & Conversion.
Knowledge of AIM Methodology and Oracle on Demand Standard.
Comprehensive knowledge of Oracle Application technical components like Application Object Library (AOL). (Alerts, Concurrent Programs, KFF's, DFF's, Value Sets, Menus, Functions etc).
Highly proficient with the PL/SQL programming language. Expert in writing packages, procedures and database triggers. Good knowledge of SQL and ability to write complex queries involving multiple tables. Hands-on experience developing Oracle Discoverer Reports.
Working knowledge of the following modules in oracle Applications - Oracle GL,Payable,Purchasing, Order Management,HRMS,Oracle Inventory.Have the knowledge of underlying table structure used by the above modules.
Bug fixing and Solution providing for Release 11i and R12.
Created Preparation of technical design (MD070/CV060) ,test Cases(TE020) and Migration(MD0120) documents of Interfaces and Conversion.
Hands-on experience on coding, configuration, use of tools/packages, version control - PVCS/CVS, Migration tool - Kintana, Quality Center, etc.

Middleware design and development experience on Oracle SOA Suite 10g and 11g which includes BPEL, ESB, Mediator, OSB,Oracle Rules Engine, Human workflow and Work list Application
Good understanding of BEA Weblogic Application Server and Administration.
Worked on Fault handling framework, Messaging and Alerts and Transformations.
Worked on ANT deployment,Faullt Policy,Performance Tuning of Composite/BPEL process.
Expertise in SOAP, WSDL, Web services, XSD, XML, XSLT and XPATH.
Expertise in messaging using ORACLE AQ and ORACLE JMS.
Knowledge of purging strategy.
Knowledge of Agile methodology.
Knowledge of EDN (Event Delivery Network)
Experience on Cross application integration using adapters File Adapter and DB Adapter, FTP/SFTP adapters etc.
Extensive experience in technical, UTP and migration documentation.
Good experience in understanding and designing solutions for complex integration scenarios.
Worked on Oracle Fusion Middleware Advanced Tool like Oracle BAM and Oracle ODI.
Trained on Oracle AIA 3.0 from Oracle University.
Trained on Oracle Demantra having knowledge about Demantra Level, Series, workflow configurations as well as Integration of Demantra with Oracle EBS and Siebel. Also worked on EBS-Demantra Integration.
Hands on experience of developing Interfaces using E-L-T tool (Oracle Data Integrator).
Knowledge of developing Web Application using Oracle ADF Business Component and MVC design pattern. Trained on Oracle ADF 11g.
Conducted Various Training Programs on Oracle Fusion Middleware (BPEL,ESB) and Oracle BAM.

Educational Qualification:

Post Graduate Diploma in Information Technology.
B.E. in Information Technology.

• Platforms: Windows,Unix
• Languages: C, C++, XML, PL/SQL,Core Java
• Integration and SOA: Oracle SOA Suite 11g,10.1.3.4,10.1.3.3.,BPEL, ESB, Oracle Data Integrator(ODI), Oracle BAM, Rules Engine,XSL,XSLT,WSDL, Oralce BI Publisher
• Databases: Oracle 9i/10G
• ERP: Oracle 11i/R12 E-Business Suite (GL,AP,AR,OM,HRMS,Purchasing), Oracle Demantra
• Tool: JDeveloper, Toad, Sql Developer, WINSCP, Putti

Work Experience:

Company: Confidential, Bangalore,India
Duration: Jan 11 to Till Date

Company: Confidential , Mumbai ,India
Duration: Mar 08 to Dec-10

Company: Confidential, Bangalore ,India
Duration: Sep 06 to Mar 08

Professional Experience:

Client:Confidential
Project: Oracle SOA Implémentations for Infinera.
Duration: Jan-11 to Till Date
Platform: SOA 10.1.3.4,SOA 11.1.1.3,OSB11g, Jdev 10.1.3.4,Jdev11g,

Key Responsibilities:
Build, support and maintain enterprise integrations while working very closely with other developers, users, and senior management to enhance, construct, and deliver state-of-the art SOA based integrations. Other responsibilities include developing technical specifications and writing core technical code to create solutions for our business needs.
Develops and maintain existing Oracle SOA Suite based integrations.
Worked on SOA10g to 11g migration.
Define XML schemas and web services.
Develops technical specifications and core technical code to integrate systems and applications.
Assesses system integration needs, researches and architects solutions, and implements those solutions with performance, accuracy, and integrity in mind.
Creates and consumes web services to integrate with ERP and other Business systems.
Writes documentation of deployment procedures, monitoring and support processes, security policies, configuration maintenance, migration procedures, and best practices for each component of the integration architecture.
Develop and document common patterns and solutions in middleware architecture.prototyping, debugging, working with Oracle support, and researching Oracle Technology Network (OTN) and related knowledge bases and forums.
Support and improve existing middleware infrastructure, including Oracle WebLogic, OC4J, and SOA BPEL, including performance, provisioning of new systems, and configuration management.
Document architecture and configuration of all middleware and web services infrastructure.

Client: Confidential, US, Canada
Project: Oracle EBS R12 SCM Implémentation.
Duration: From Sep-10 to Dec-10
Platform: Oracle EBS R12.1,

Key Responsibilities:
As a Technical consultant worked on following Conversion.
Item Conversion
Item Catalog Conversion
Item Category Conversion
PIM Attributes Conversion
Register Concurrent program including SQL loader. Also created CTL file for loader.
Configured Lookups and Value sets
Developed PL/Sql Packages, Procedures, functions etc.
Developed Unit test Plan (TE-20), Technical Design Document (CV060 & MD070) and Migration Document (MD0120).
Created RFC and SR for various Functional and Technical Issues.
Involved in CRP, Pre UAT, UAT Testing cycle and Support.
Involved in maintaining traceability matrix.

Client: Confidential, US, Client is world\'s leading biotechnology Company.
Project: Oracle EBS R12 Finance Implémentation.
Duration: From Aug-09 to Currently Working
Platform: Oracle EBS R12,Toad,Oracle SOA 10.1.3.4, BAM 10.1.3.4,Jdeveloper 10.1.3.4

Key Responsibilities:
As a Technical consultant worked on following Conversion.
GL Conversion
AP Supplier and Sites Conversion
HR Employee and Address Conversion
Developed Chart of Account Change/Add Interface, Employee Interface using BPEL and ESB. Used Oracle BAM for Error Logging and Error Reporting. Configured JMS,Databse and File Adapter.
Created BAM DO, BAM Report and Configured BAM Alert for email Notification.
Developed Custom Web ADI Integrator for Chart of Accounts.
Write Common PL/Sql Procedure to Invoke Web Service.
Write Common PL/Sql Procedure for email notifications.
Interacted with Onsite functional Consultant to resolve issues.
Involved in Error Handling design Approach using BAM, BPEL & ESB.
Register Concurrent program including SQL loader. Also created CTL file for loader.
Configured Lookups and Value sets
Developed PL/Sql Packages, Procedures, functions etc.
Developed Unit test Plan (TE-20), Technical Design Document (CV060 & MD070) and Migration Document (MD0120).
Developed Training Document for BAM and BPEL and Conducted Training on Same.
Interacted with Oracle On Demand Team for TAR, RFC (Open, Monitor, Update, Close).
Created RFC and SR for various Functional and Technical Issues.
Involved in CRP, Pre UAT, UAT Testing cycle and Support.
Involved in maintaining traceability matrix.

Client: Confidential, Masco, Client is the second largest cabinet manufacture in USA
Project: Oracle EBS R12 Implémentation & Intégration
Duration: 6 Months
Platform: Oracle EBS R12, Oracle SOA Suite 10.1.3.3, BPEL, ESB, Oracle BAM 10.1.3.3, Oracle JDeveloper 10.1.3.3, Linux, Oracle Demantra 7.1

Key Responsibilities:
As a Technical Consultant involved in the areas of developing interfaces in Oracle Fusion BPEL.
Data transfer from Legacy systems like JDE, Frontier to Oracle EBS through BPEL interfaces for daily business processes.
Work on EBS-Demantra Integration using BPEL Interface.
Configure AQ Adapter, Data base Adapter, File Adapter etc.
Created BAM Data Objects, BAM Alerts and BAM Report.
Developed ESB Process to call BPEL Process.
Used BAM, BAM notifications and BAM reports for most of the BPEL interfaces.
Major role for designing the Error handling and Business process for interfaces.
Introduced the multi consumer queue concepts for scheduling of BPEL processes through concurrent programs.
Configured Demantra Level and Series.
Developed PL/Sql Packages, Procedures, functions etc.
Created Unit test Plan (TE-20),Technical Design Document(MD070)
Register Concurrent program and Call BPEL interfaces from Concurrent Program.

Client: Confidential, Client is a Leading Solar Energy Provider in North America.
Project: Oracle Applications R12 finance implementation for Europe and Canada
Duration: 5 months
Platform: Oracle EBS R12, Oracle Discoverer, Oracle Workflow.

Key Responsibilities:
As a Technical consultant worked on following Conversion.
AP Supplier and Sites Conversion
AP Invoices Conversion.
Worked on following Workflow
Project Status Change Workflow.
Project Accounting workflow customization.
.Worked on Project Accounting Discoverer Reports
.Developed CV060, TE020, and MD120.
Register Concurrent program including SQL Loader program. Developed CTL file for SQL Loader.
Interacted with Onsite functional consultant for resolving issues and Coordinated with Oracle on Demand Team for migration activities.
Created Value set and Lookups
Write PL/SQL Packages, Procedures, Functions.
Developed Common Error reporting Package.

Client: Confidential, Client is New Zealand\'s largest building material supply company.
Project: Oracle Applications implementation.and Integration
Duration: 6 months
Platform: Oracle EBS R12, Oracle SOA Suite 10.1.3.3, BPEL, ESB,Oracle JDeveloper 10.1.3.3

Key Responsibilities:
As a Technical consultant worked on following SOA Interfaces.
Internal Sales Order Interface
Marketing and Promotions Interface
Purchase Order Interface
Developed both Inbound and Outbound Interfaces using BPEL & ESB.
Developed Batch and Real Time Interfaces.
Register Concurrent Program in order to call BPEL Interfaces.
Web Service Invocation using PL/SQL.
Configuration of Various Adapters including AQ and Database and File.
Involved in Development of Error Handling Strategy.
Developed CV060, TE020, and MD120.
Interacted with Oracle On Demand Team for TAR, RFC (Open, Monitor, Update, Close).

Client: Confidential.
Project: Order Booking
Duration: 2 months
Platform: Oracle SOA Suite 10.1.3.3, BPEL, Jdeveloper 10.1.3.3

Key Responsibilities:
Synchronous and asynchronous services invocation
Parallel flows of execution.
Conditional branching logic (for runtime decision making based on real time service responses)
Process fault handling
Exceptions management
File adapter functionality (for writing and reading files).
Database adapter functionality (selecting and inserting data)
Notification (E-Mail based)

Client: Confidential, Australia
Project: Oracle Apps 11.5.10 PA & Payroll Implementation
Duration: 4 months
Platform: EBS 11.5.10

Key Responsibilities:
As a technical consultant in Oracle PA/HR module and was involved in the design, and development of data conversion programs.
Used various API\'s and created various PL/SQL procedures for data conversion. This was a full-fledged Oracle PA/Payroll conversion.
Loaded employee, Assignments and Budgets details from legacy systems into temporary Oracle tables using SQL * Loader. Wrote PL/SQL procedures such as \'hr_create_employee\' etc. to validate the data in the temporary tables. Used Exceptions in various procedures to capture errors during validation of data in the temporary table and insert them into a temporary error table. Analyzed values in the error table and then completed the process of validation and updating of the legacy data into the application\'s base tables.
Understanding of the CV40 functional document and preparation of CV60, TE20, and Technical approach document, creating Concurrent Program and executables, unit testing.
Interacted with Oracle On Demand for Migration Activities.

Client: Confidential, Poland
Project: Oracle Apps I1.5.10 FA Implementation
Duration: 2 months
Platform: EBS 11.5.10

Key Responsibilities:
As a technical consultant in Oracle Fixed Assets.
Worked on Full Retirements of Assets Interface.
Understanding of the MD050 functional document and preparation of MD070 , TE20.
Register Concurrent Program and executables.
Configured Value Set and Lookup.

Client: Confidential, Germany
Project: Oracle Apps I1.5.10 FA Implementation
Duration: 4 months
Platform: EBS 11.5.10

Key Responsibilities:
Worked as a technical consultant in Oracle CRM module and was involved in the design, and development of data conversion programs. Used various API\'s and created various PL/SQL procedures for data conversion. This was a full-fledged Oracle CRM conversion.
Loaded Catalog, Work Order and task details from legacy systems into temporary Oracle tables using SQL * Loader. Wrote PL/SQL procedures to validate the data in the temporary tables. Used Exceptions in various procedures to capture errors during validation of data in the temporary table and insert them into a temporary error table. Analyzed values in the error table and then completed the process of validation and updating of the legacy data into the application\'s base tables.
Development of a service process interface. The interface has inbound as well as outbound components. Also involved in the data collection and proper understanding of the interface.
Understanding of the CV40 and MD50 functional document and preparation of CV60, MD70 TE20, and Technical approach document, creating Concurrent Program and executables, unit testing

Client: Confidential, India
Project: PLSQL Code Parser Tool
Duration: 2 months
Platform: Java

Key Responsibilities: Worked as a Java developer.
About Tool:
This tool checks the coding Standard of code unit before deliver it to client.
Coding standards might be change according to client requirements.
If there are no specific Requirements of client, this tool checks the company Own coding standard.
All the code units should be compiled before using this tool.

Professional Training:

Oracle Applications 11i - architecture/details
Application Object Library
SQL and PL/SQL programming
Oracle Forms 6i and Oracle Reports 6i
Open Interfaces and Conversions
XML Publisher
R12 Training

GATE Score in INFORMATION TECHNOLOGY: All India Rank 619
Got merit scholarship in 12th...
Won prize in Microsoft security shoot out contest conducted by Microsoft.