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.