Post Job Free

Resume

Sign in

Service Oracle

Location:
Fredericksburg, VA
Posted:
January 30, 2015

Contact this candidate

Resume:

AMITKUMAR PATEL [pic]

Phone: +1-571-***-**** (M)

SUMMARY[pic]

. Total 10+ years of extensive IT experience in analysis, design and

development of enterprise applications using Oracle SOA technology (6+

years), Oracle Service Bus, Oracle Data Integrator, Oracle Pl/Sql,

Java.

. Oracle SOA Suite and Oracle AIA certified.

. More than 6 years of experience in large-scale SOA/EAI implementations

using Oracle Fusion Middleware and Oracle Service Bus

. Expertise on Service Oriented Architecture using Oracle SOA Suite

11g/10g(Mediator, BPEL, Business Rule, Human Workflow), Oracle Service

Bus 10g/11g, Oracle Data Integrator10g.

. Expert at working with Oracle SOA Suite SCA composites and components

like BPEL process, Mediator, Business Rules, Human Workflow, and

activities like Assign, Invoke, Pick, Receive, Switch, Flow, Java

embedding, Email, Wait, While, Validate etc. in JDeveloper.

. Expertise in using SOA technology adapters Such as File Adapter, FTP

Adapter, Database Adapter, Oracle Applications Adapter, AQ Adapter,

BAM Adapter and JMS Adapter for integration

. Extensively worked on Oracle Service Bus and used routing, publish,

service callout, routing table, different protocol - http, jms, ftp,

sftp, MQ.

. Implemented integration of Oracle SOA with Cloud technology -

salesforce.com, SAP, Oracle Apps.

. Expertise in the design, development and integration of BPEL events

with Sensors & Oracle Business Activity Monitoring (BAM) to create

dashboards with various types of graphs, Export/Import of BAM reports

from one server to another server.

. SOA Security - Configured 2 way SSL for file transfer,

username/password authentication and message encryption through OWSM

. Installation of Weblogic, SOA, OSB and ODI, Good exposure on

configuration of JNDI, Data Source, Messaging Bridge, Foreign JMS

Server( manually as well as wlst script), SMTP configuration, Proxy

Server setup.

. Working Exposure on Web Services, XML, XSD, XSLT, Xquery, Xpath.

. Worked extensively with Oracle RDBMS; Comfortable with SQL, PL/SQL,

and developing various database objects like Triggers, Stored

procedures, Functions, Sequences, Views

. Good exposure and knowledge of all stages of Software Development Life

Cycle (SDLC) using various development methodologies based on Agile,

Test driven development.

. Implemented common Error handling with fault policy and logging

framework.

. Expertise on Oracle Data Integrator. Extensively used of most of

knowledge modules in ODI. Installed ODI on clustered environment.

Configured master and work repository in ODI. Extensively used all

tools like Invoke web service, SFTP, File in ODI.

. Possess good communication skills and experience of operating in

onsite- offshore model.

. Worked as Team Leader and have experience of leading 10 SOA resources.

. Trained on Oracle SOA Suite 12c from Oracle team. Learnt new features

like MFT, Scheduler and Cloud Adaptor.

SKILLS[pic]

. Oracle Fusion : Oracle SOA Suite 11g/10g, Oracle AIA10g

Foundation Pack, OSB 10g/11g

. Data Warehouse : Oracle Data Integrator 10g, Oracle Ware-

house Builder10g

. Database : ORACLE 11g/10g/9i/8i

. Lang & Scripting : SQL, PL/SQL, XML,XSLT, XQuery, WLST .

. Release Eng. Tools : Tortise SVN, Clear Case, Borland Star

Team

. Development Tools : TOAD, JDEVELOPER 11g/10g, SOAPUI,

SqlDeveloper

. Application Servers : Oracle Application Server OCJ4, Oracle

WebLogic 10.3.6

. Operating System : Linux, Unix and Windows

EDUCATION QUALIFICATION[pic]

. B.E. (Computer) [2004] from Shri U V Patel College of Engineering

(Hemchandracharya North Gujarat University), Gujarat, India.

. XII [2000] from GSEB, Gandhinagar, Gujarat, India

. X [1998] from GSEB, Gandhinagar, Gujarat, India

PROJECTS:

[pic]

Client : US Based Electric and Electronics Company

Duration : Oct-2013 to till

Team Size : 20

Environment : Oracle SOA 11g, OSB 11g, Oracle BAM, Weblogic,

OWSM, Linux, Oracle DB, Oracle Business Rules

Project Description

Client is an Industry leading firm in the USA. It provides

a broad spectrum of services and products. Client's corporate business aims

at catering to all business lines and provide for integration services.

This is for Oracle Fusion Middleware based Integration Hub for all clients'

corporate applications. Client has multiple ERP systems, and we are helping

the client on integration services across verticals, and also designing and

delivering the services.

. Participated in design discussion with EBS, SAP and Salesforce

architect

. Analysis of requirement and provide solution architect for SOA

integration considering reusability and governance.

. Propose High level design to client and present it to client

Architecture Review Board.

. Provide high level estimate to client about implementation.

. Configured 2-way SSL for file transfer.

. Integrated SAP ERP using i-way SAP Adaptor.

. Integrated Oracle Service Bus with cloud technology - salesforce.com.

. Integrated Oracle Service Bus with Microsoft SQL database.

. Helped development team to create BAM report and deployment of BAM

reports using Export/Import utility.

. Used DVM extensively to store the static domain data in the system and

Xref to store legacy data which are related to ERP.

. Used the various error handling features of SOA Suite 11g like Fault

Management Framework, catch/catch-all branches, compensating

transaction etc. to achieve robust error handling.

. Configured and used various adapters like Oracle Apps, File Adapter,

FTP Adapter, DB Adapter, JMS Adapter and AQ Adapter

. Worked extensively on the SOA infrastructure using Weblogic console

and Enterprise Manager (EM) console to fix some critical performance,

memory and transaction timeout issues in the system.

. Performance tuning of BPEL processes.

. Used Ant script for code deployment across all environments.

Client : Australian based banking client

Duration : Jul-2013 to Sep-2013

Team Size : 10

Environment : Oracle SOA11g, OSB11g, Weblogic, ADF, Linux

My Role : SOA/OSB SME and Defect Coordinator

Project Description

Client is a leading bank in Australia. We are helping

client to setup Super Annuation Fund transfer process. Current

Superannuation fund transfer process for Client is a manual process.

Client's project focuses on automating Super Anuuation fund transfer

process. Processes have 2 parts, Rollover In and Rollover out. Rollover in

when the funds are transferred from other banks to Client's BANK and out is

when funds are transferred from Client's BANK to other banks. Processes

involves 4 types of messages, IRR(Initiate Rollover Request), RTR(Rollover

Transaction Request), RTO(Rollover Transaction outcome), IRRe (Initiate

Rollover Request error) and RTOe ((Rollover Transaction outcome error).

. Done SME review of all Technical design and coding of SOA/OSB

components

. Providing review comments and following up to close all review

comments from Build team.

. Worked as defect coordinator to coordinate defect between Development

and Test team. I worked closely with both team. So whenever test team

encounters any defect in process, first I have to check and take

decision whether it is defect or CR.

. Once defect is raised, I used to communicate it with build team and

follow up to close that defect.

. Maintaining defect tracker which gives clear visibility to delivery

manager/ test team lead about defects count with all status.

Client : Taxation & Custom Client in Europe

Duration : Apr-2013 to Jul-2013

Team Size : 2

Environment : Oracle SOA 11g, OSB11g, Oracle DB 11g, OEG11g,

Unix, WebLogic Server.

My Role : SOA Solution Architecture

Project Description

It's a project about taxation and custom information

exchange between Client and third parties. We provided integration

solutions and developed architecture platform using Oracle SOA Suite11g,

OSB for exchanging information between Client and third country.

. Analysis of current project architecture

. Understanding functional requirement of existing services and defining

services based on requirements. Check for service reusability from

existing service architecture.

. Defining tool to be used to develop service

. Used service components like Mediator, BPEL and Human Task.

. Used error handling frameworks to handle error at component level.

Applied standard fault policy at composite level.

. Used database polling to poll data from table using status column and

configured singletone property to work in cluster environment

. Worked on configuration plans and ANT scripts to deploy composites in

different environments.

. Used hermes JMS to monitor third party JMS

. Used SOAP UI to simulate end system

Client : Hotel Business in Spain

Duration : Jan-2013 to March-2013

Team Size : 5

Environment : ODI11g, Oracle 11g

My Role : ODI Team Leader

Project Description

Client is leading hotel business in Europe. Client has

decided to use OBIEE as data warehousing tool to manage their finance,

operations and commercial transactions. I provided integration solution to

extract data from different source mainly EBS and load data into data

warehouse through Oracle Data Integrator. OBIEE extracts data from data

warehousing table and generates reports according to business requirements

in OBIEE.

. Functional requirement analysis with Client team

. Prepare technical design and unit test cases based on functional

design

. Team management - assign work, status reporting, helping team members

in resolving complex queries, updating work plan

. Used all type of knowledge modules (LKM, IKM, CKM), Configuration of

Master and Work repository, used SFTP, WebSerice, File related tools

in ODI.

. Parallel session execution, Custom knowledge module creation.

. Peer review of technical design and build

. Daily status call with onshore team and sending them daily status

report.

. Manage issues and risks within the project and escalate/handle them

appropriately.

Client : Finland based Retailer and South African

Based

Retailer

Duration : Apr-2012 to Dec-2012

Team Size : 10

Environment : Oracle SOA11g, OSb11g, Unix, Weblogic Server

My Role : People Development & SOA Team Lead

Project Description

One of client is leading retail business group in Finland.

Client decided to use Oracle Retail for retail business and EBS for Order

Management. For integration, Client decided to use Oracle Service Bus as

Integration tool. I have provided integration solution between Oracle E-

Business Suite and Oracle Retail application.

Another client is a South Africa based retail business

group. Client is providing retail membership card to customer for shopping

with the help of bank which is based out of South Africa. Before membership

cards provided to customer, BANK has to validate those customers detail. To

achieve this requirement, Client has decided to integrate legacy systems

with BANK and used Oracle SOA Suite - BPEL & Oracle Service Bus for this

integration. This Project is responsible for implementing the system

changes required due to BANK's purchase of Client's debtor's book. These

changes are required in order to provide BANK the required visibility of

the customer and transactional data, as well as to ensure alignment with

additional legislative and contractual compliance requirements.

. Working with various feature sets of OSB like Dynamic routing tables,

Service callouts, XQuery, XPath and XSLT to perform validation,

filtering, transformation and routing.

. Built complex service proxies using OSB that provided service

orchestration to multiple backend enterprise systems and cloud

applications (vendor web services).

. Created complex service-level and operational-level pipeline pairs

with multiple stage configurations to enable dynamic content-based and

rule-based routing.

. Built robust OSB modules by incorporating sophisticated error-handling

and fault-management strategies at multiple levels (route-node,

pipeline, service) in the OSB infrastructure.

. Expertise in using the various built-in XQuery-based OSB functions to

enrich messages.

. Develop complex schemas and XSLT transformations to read, enhance and

process incoming data and map it to E-business Suite Web Service

Schemas.

. Developed various Synchronous and Asynchronous business processes

using BPEL in Jdeveloper

. Extensively used Fault and Error handling capabilities (Catch and

Catch All), Synchronous and Asynchronous processes, Transformations,

XSD, XSLT and XPath.

. The database MDS repository was used to store all the common artifacts

between composites like DVM, XSD, Fault policy and Fault Binding

files. Abstract WSDL's were also stored here and any call to a

composite through a BPEL is made through abstract WSDL in-order to

avoid dependencies problems during server startups.

. Design and implement error handling framework using the Fault handling

framework which logs all errors in the backend and does appropriate

actions.

. Create and Configure predictive alerts and notify a distribution list

when based on SLA

. Interacting with business analysts, customers, architects and managers

during various phases of the projects.

. Resolving the defects raised in the Quality Center(Defect management

tool) by testing group

. Effort estimation based on the technical specifications including

resource forecasting

Client : Dubai Based Retailer

Team Size : 10

Duration : Sep-2011 to Mar-2012

Environment : AIA10g, ODI 10g, Unix, Oracle App Server, Oracle

Database 10g.

My Role : SOA Team Leader

Project Description

Client is recognized as one of the leading forces in the

luxury retail business in the Middle East. Client has decided to use Oracle

E-Business Suite's Order Management (OM) application for their distribution

business and Oracle Retail for the Retail part of the business. I have

provided integration solution between Oracle E-Business Suite and Oracle

Retail application using Oracle Application Integration Architecture (AIA).

. Functional design review with client team

. Prepare technical design and unit test cases based on functional

design

. Team management - assign work, status reporting, helping team members

in complex task

. Peer review of technical design and build

. This project is designed to automate Sales orders processing cycle in

Oracle E-Business Suite using Fusion Middleware stacks including AIA

Foundation Pack to leverage standard artifacts such as EBO, EBS, and

custom ABCS.

. Used SalesOrderEBS and SalesOrder EBO.

. Used Oracle Data Integrator for Bulk data transfer. ODI was used to

integrate Item details from Oracle Retail to Oracle Apps system.

. Called AIA Error handling service from ODI using OdiInvokeWebService.

. Used DVM inside Oracle Data Integrator for static value.

. Installed AIA foundation pack and used error handler in all

interfaces.

. Used oracle standard purging script to purge SOA instances.

Client : Product Development for Utility Client

Duration : Jan-2010 to Aug-2011

Team Size : 25

Environment : Oracle SOA11g, Oracle OSB11g, ODI11g, Unix

My Role : SOA Developer

Project Description

Client has a formal set of processes and assets for

assisting utilities with the development of smart grids. This architecture

is a reference model that provides for end to end collection, transport,

storage, and management of smart grid data; it also provides analytics and

analytics management, as well as integration of the forgoing into utility

processes and systems.

. Gathering requirement by studying existing systems, requirement

analysis and design of interfaces.

. Analyzed SOA integration architecture and Oracle SOA Suite 11g/Oracle

Service Bus/Oracle Data integrator to implement smart grid interfaces

. Developed functional knowledge of AMI (Advance Metering In-

frastructure) and integrated HeadEnd & MDM system for Meter connect-

disconnect, on demand meter reading, periodic meter reading.

. Learning of existing application which is developed on IBM-WebSphere

. Designing of interfaces which fulfills client new requirements as well

as existing requirements

. Configured I-way SAP Adaptor to connect with SAP system and integrated

I-doc through SAP adaptor.

. Installed Weblogic server on Unix environment and did performance

tunning of environment.

. Configured Error management framework for Product.

. Configure data source, JNDI, JMS Queue/Topic on Weblogic console.

. Monitoring SOA interfaces through EM

Client : Leading Telecom Client in UK

Duration : Oct-2007 to Dec-2009

Team Size : 4

Environment : Oracle SOA10g, EBS10g, Oracle DB10g, Unix

My Role : SOA Developer

Project Description

Client has one centralized financial system to capture all

financial transaction across the world. I was working in integration

architecture project which integrate Client's different legacy system with

financial system.

. Design and build solutions based on best practices and the complexity

of the systems involved

. Created XSDs from scratch and used in BPEL project.

. Developed various Web Services using WSDL, SOAP and Oracle JDeveloper

. Design and Developed ESB processes, configure database, file adapters

and tuned BPEL services

. Defined WSDL for BPEL process, partner links, BPEL process and

developed process logic definition

. Extensively used Oracle Apps, DB, File and FTP adaptor.

. In DB Adaptor, used data polling and sequencing.

. Testing the portal functionalities and BPEL workflows.

. Worked on Email activity with attachment.

. Created re-usable error handling services with customized fault

policy.

. JMS adapter was used for Producing and consuming the messages.

. Involved in the deployment of BPEL, and ESB services on to the

production server

. Provided fixes to a number of Application related issues of different

Severity / Priorities

. Interact with other teams to track the status of the implementation

Client : Banking Client in India

Duration : Sep-2006 to Aug-2007

Team Size : 15

Environment : Oracle DB 9i, Oracle pl/sql, I-Flex, B2k, Unix

My Role : Oracle Pl/Sql Developer

Project Description

The purpose of this project is to migrate data from

existing banking application to new banking application which has different

data structure. Bank was using B2K(Infosys banking application) to maintain

their banking transaction. Bank has replaced B2K with Flexcube (Iflex

banking product).

. The data migration activity is being done to transfer the data from

B2k system to Flexcube system. Flexcube is a tool developed by iflex,

which suits for all Banking sectors.

. Procedures, functions, Views, Packages are written to extract legacy

data in such a way that it supports flexcube tool. Modules like CIF

(Customer Information), Loans, CASA (Current Account & Saving

Account), RD (Recurring Deposit) and General Ledger are also migrated

to oracle 9i system.

. Flat files are created via procedures for all modules and all the

data's are validated in such a way that is supports the flexcube tool.

. Fine-tuning of procedure is also done to cut down the execution time.

. Used pl/sql table and record type to improve performance.

. Created Unix script to execute procedure in sequence and report error

logging.

Client : Garment/Fabric Manufacturer in India

Duration : Jun-2004 to Aug-2006

Team Size : 10

Environment : Oracle Forms6i, Oracle Reports6i, Oracle DB8i,

Pl/Sql,

Unix

My Role : Oracle Pl/SQl - Forms/Report Developer

Project Description

Garment Production system is designed specifically for

production of garments. This system helps user to create garment orders,

inventory of garment orders, fabric purchase, and production of garments &

sales of domestic garment orders. Export documentation system is designed

specifically to export garments. This system helps user to create pre

shipment invoice, letter of credit (LC), bill of loading and post shipment

invoice information.

. Develop application using Oracle Form 6i, Reports 6i.

. Created database triggers for data security.

. Created Stored Procedures and Functions to be called by Oracle Forms

6I, Reports 6I

. Created Packages to be called by Form 6i, Report6i.

. Written SQL Loader Scripts for data extraction and transformation.

. Written Export & Import Scripts for data transfer.

. Developed Repots using Oracle Reports 6i.



Contact this candidate