Oracle Manager
Resume:
Mahesh Gurusamy
SOA/EAI (Integration Solution Architect)
abg2wx@r.postjobfree.com
____________________________________________________________________________
_______
Summary
. More than 8 years of professional experience as
EAI(SOA,ESB,BPEL,Java,J2EE) Consultant in Manufacturing Integrated
applications(JDS Uniphase,Nike),Educational services applications (Apollo
Group), e-Business and Data Management Applications (Dun & Bradstreet,
Affinion Group),Retail Integration Applications (Carrefour) and
Integrated Electricity and Gas Management System(National Grid Transco).
. Hands on experience in design and development of Service Oriented (SOA)
applications using Oracle SOA Suite(ESB,BPEL,WSM,BAM),Seebeyond ICAN &
Sun JCAPS Middleware Suite(eGate,eInsight,eVision,eXchange),Seebeyond SRE
5.0.5(eGate).
. Experience in design and development of message oriented middleware
applications using IBM MQ series, Active MQ, Weblogic JMS and Seebeyond
JMS IQ Manager.
. Proficient knowledge in building enterprise Applications and Distributed
Systems using technologies such as Java, J2EE (Servlets, JSP, EJB, JDBC,
JNDI, JTA, JMS), BPEL and XML.
. Strong concepts in object oriented analysis and design (OOAD). Hands-on
experience advanced J2EE patterns like Service Locator, Session Fa ade,
DAO and MVC.
. Hands-on experience in developing J2EE Applications using Struts,
JSF,iBATIS and Hibernate frameworks.
. Proficient knowledge and experience in B2B Integration using EDIFACT,X-12
message exchanges and AS2,HIPAA,HL7 specification.
. Extensive Reporting experience using Jasper Reports Engine.
. Strong Knowledge in SQL, PLSQL and Oracle performance tuning.
. Extensive experience in UNIX and Shell Scripting.
. Experience working with XML related technologies such as SAX, DOM, XML
Schema, XSL, XSLT, Xpath, XPointers and Java Technologies (JAXP, JAXB).
. Extensive team lead experience in managing and co-ordinating the team at
onshore and offshore.
. Trained more than 25 members in various integration tools like Seebeyond
ICAN,Sun JCAPS,Oracle SOA Suite.
. Bachelor of Engineering in Information Technology
. Excellent oral, written communication skills and presentation skills.
. Solid Problem Solving skills and very quick learning abilities.
Educational Qualification
. Bachelor in Computer Engineering, India
Recent Achievements
. Star Performer Award in Dun & Bradstreet for increasing the performance
(70%) of Work Flow Manager application by parallelising the data
transformation services,data routing services and connectivity services
. Feather in the Cap award from Wipro Technologies for successful
implementation of efficient integration patterns in the project.
Technical Skills
EAI & Middleware Oracle Fusion Middleware(11g, 10.1.3.x),Sun JCAPS (5.1,6.0),
Seebeyond ICAN 5.0.5, Seebeyond SRE 5.0.5,IBM MQ Series
5.3,IBM Message Broker,Amtrix,Tibco,ServiceMix,OpenESB.
Languages Java . C . C++. Bourne and C Shell Scripting
Java / J2EE Collections . Multi-threading . Exception Handling . RMI .
I/O . Reflection . Proxies . Dynamic Proxies . Generics .
Enumerations . Annotations
JDBC . EJB 2.0/2.1 . Servlets . JSP . Java Messaging
Service (JMS) . Java Naming and Directory Interface (JNDI) .
Java Mail . Java Server Faces (JSF) . Java Connector
Architecture(JCA) . Java Transaction API (JTA) . Java
Transaction Service (JTS)
Open source Java/ Hibernate . Struts2 .JDO. Log4J . Tiles . Velocity . iBATIS
J2EE Frameworks
J2EE Seebeyond Integration Server 5.0.5 . Sun Integration Server
Application/Web 5.1 . BEA Weblogic ( 10.0,8.0) . Apache Tomcat . Oracle
Servers 9i/10g AS
XML Technologies XML. DTD . XML Schema . XSLT . XPath . XPointers . DOM . SAX
Data EDIFACT,X-12,AS2,HIPAA,HL7
Specifications
Oracle SQL, PLSQL, Oracle XMLDB, Oracle Fusion Middleware (Oracle
Technologies & SOA Suite, BPEL, BAM), Oracle Messaging Gateways, Oracle
Tools AQs.
Scripting PERL . Unix Shell Scripting . awk . sed
Development UML . OOAD
Methods
Development Tools Eclipse 3.1 . NetBeans 5.5 . JDeveloper 9i . Toad .
Rational Application Developer . ClearCase . WSAD . CVS .
RAD . ANT . JUnit
Experience highlights
Employer : Apollo Group, Phoenix AZ
Duration : April 2010 - Till Date
Designation : Senior Software Developer
Financial Aid Integration
This project involves integration of diverse applications like Oracle E-
Business Suite R12 finance application, PeopleSoft financial aid
application, Student information system, Legacy applications and custom
applications..These interfaces are responsible for integrating various
external SOAP services, packaged application services like oracle apps
service, peoplesoft service, HTTP services, EJB services, database,
weblogic JMS, Oracle AQ and Active MQ. All interfaces are developed in
Oracle SOA Suite 10.1.3.4 and Oracle SOA Suite 11g(11.1.1.1) which involves
complex routing and transformations.
Robust error handling framework which seamlessly manages all error
conditions. Strong auditing and reports module which displays all
integration process flow auditing and reports data
Technologies & Tools: Oracle SOA Suite 11g(BPEL,Oracle service
bus,Mediator,WSM,Business rules),Oracle SOA Suite
10.1.3.4,Java, J2EE, EJB 3.0,JAXB,SOA,
iBATIS,Webservices, SQL, PLSQL, XML, XPATH,XSD,
TOAD, UNIX, Shell Scripting,,HTML,Weblogic 10.x
Middleware : Oracle SOA Suite 11g(BPEL,Oracle
service bus,Mediator,WSM,Business rules),Oracle SOA
Suite(10.1.3.4),Active MQ
Database : Oracle 10G Release 2 Enterprise
Edition
Responsibilities
. Gather requirements from business analyst and document functional and
technical requirements.
. Architect high level and low level design for Financial Aid
integration scenarios.
. Design and develop common object data model which can be used across
all integration scenarios.
. Develop complete integration infrastructure which involves message
handler, message normalizer, message router, message dispatcher and
error handler.
. Design and develop BPEL process using Oracle BPEL,mediator,business
rules for various integration flows.
. Develop complex routing rules and transformations in BPEL using XSLT
and mediator.
. Design and develop XSD for complex XML data exchanged with external
services.
. Implement HTTP basic authentication and authorization policies for
composite services using WSM.
. Developed applications to throttle AQ messages using Quartz
scheduler,iBATIS data mapper and java servlets.
. Used built in adapters for connecting to JMS,database,MQ,Oracle
AQ,Oracle Apps.
. Used JAXB bindings to marshalling and unmarshalling between XML and
java objects.
. Used WSIF binding to include normal java services in the BPEL
processes.
. Design and develop robust error handling framework using BPEL fault
policies to seamlessly handle all types of errors
Employer : Technotec Inc, Herndon VA
Duration : Jan 2009 - April 2010
Designation : Programmer Analyst
Client projects worked for Technotec Inc,
Duration : Sept 2009 - March 2010
Client : Affinion Loyalty Group, Richmond VA
Last Designation : EBI(Enterprise Business Integration) Consultant
Weblogic Integration to Oracle SOA Suite Migration
This is a migration project from weblogic integration 8.0 to Oracle SOA
suite 11g(BPEL,ESB,Mediator,WSM,Business rules) which provides loyalty
reward points management for various banking clients .These interfaces are
responsible for integrating various external SOAP services,HTTP
services,EJB services,database,weblogic JMS and IBM Mq. All WLI interfaces
are analysed and redeveloped in Oracle SOA Suite 11g which involves complex
routing and transformations.
Robust error handling framework which seamlessly manages all error
conditions. Strong auditing and reports module which displays all
integration process flow auditing and reports data
Technologies & Tools: Oracle SOA Suite 11g(BPEL,Oracle service
bus,Mediator,WSM,Business rules),Java, J2EE, EJB
3.0,JAXB,SOA, Webservices, SQL, PLSQL, XML,
XPATH,XSD, TOAD, UNIX, Shell Scripting,,HTML,Weblogic 10.x
Middleware : Oracle SOA Suite 11g(BPEL,Oracle
service bus,Mediator,WSM,Business rules),,IBM MQ
Series 6.1
Database : Oracle 10G Release 2 Enterprise
Edition
Responsibilities
. Analyse WLI interfaces and redesign them as Oracle SOA interfaces.
. Design and develop BPEL process using Oracle BPEL,mediator,business
rules for various integration flows.
. Develop complex routing rules and transformations in BPEL using XSLT
and mediator.
. Design and develop XSD for complex XML data exchanged with external
services.
. Implement HTTP basic authentication and authorization policies for
composite services using WSM.
. Used built in adapters for connecting to JMS,database,MQ.
. Migrate all existing EJB2.0 services to EJB 3.0 weblogic services.
. Generated XSD for all request and response EJB objects using JAXB
schemagen.
. Used JAXB bindings to marshalling and unmarshalling between XML and
java objects.
. Used WSIF binding to include normal java services in the BPEL
processes.
. Design and develop robust error handling framework using BPEL fault
policies to seamlessly handle all types of errors
Duration : April 2009 - Sept 2009
Client : Nike, Portland OR
Last Designation : EBI(Enterprise Business Integration) Consultant
Umbro.Net Integration Application
This integration application is responsible for delegating all Nike orders
from front end portal application to SAP application.JCAPS 6.1 is used as
integration tool for integrating weblogic based web services and SAP R/3
system.
JCAPS interfaces are responsible for routing orders in the forward flow and
routing order confirmations in the backward flow. This interface converts
XML order message to SAP IDOC order message and vice versa.
This application receives auditing and error messages from the workflows
about status of services in business process during runtime. Audit and
error components are responsible for logging the messages received against
the services in the oracle table. The logged records are displayed as audit
and error messages in the UI.
Technologies & Tools: Sun JCAPS 6.1, Seebeyond SRE 5.0.5,Java, J2EE, SOA,
Webservices, SQL, PLSQL, XML, XPATH,XSD, TOAD, UNIX,
Shell Scripting,,HTML,Weblogic 9.x
Middleware : Sun JCAPS 6.1, Seebeyond SRE 5.0.5,IBM
MQ Series 6.1
Database : Oracle 10G Release 2 Enterprise
Edition
Team Lead Responsibilities
. Understand business requirements from business analyst,prepare use
case documents and get it approved from client.
. Prepare high level design document for the requirements and get it
approved from architect team.
. Prepare low level design document for each type of interfaces.
. Explain the interface requirements and low level design of the
interface to all developers at offshore.
. Layout best practices,naming conventions,coding rules and
specifications to be followed while developing the interfaces in
eGate.
. Distribute the work among the developers and get all the interfaces
developed,unit tested from the developers and verify the test
results.Also would perform sanity checks on all the interfaces
personally.
. Evaluate the work and performance of all developers in the team and
shall provide report to the immediate top level manager once in a
quarter..
. Trained more than 5 members in sun Jcaps 5.1.
. Make the integration system ready for testing and notify the testing
team to carry out integration and system testing.Assist the testing
team in case of any issues.
. Visualize deployment strategy and prepare deployment design document
and get it approved from architect team.
. Automate all deployment activities and release the interfaces to
production and provide support until the system gets stabilized.
Technical Responsibilities
. Design and developed work flow process using sun JCAPS 6.1(eGate)
. Design and develop interfaces in Seebeyond SRE eGate 5.0.5.
. Developed java collaborations for transformation of XML data to SAP
IDOC format and vice versa.
. Connect to external systems MQ Series,FTP,NAS,,Oracle,Web services
and bring in data in to the system using Sun eWays.
. Developed automated orders status report via email using Velocity as
templating engine.
. Design and develop Auditing and error monitoring component to track
the status of all messages flowing in the system.
. Developed stored procedures and efficient prepared statements used by
the interfaces.
. Support and maintain the interfaces developed.
Duration : Jan 2009 - April 2009
Client : JDS Uniphase,Milpitas CA
Last Designation : EBI(Enterprise Business Integration) Consultant
SOA Pipeline Integration Application (BPEL Driven SOA Integration
Application)
SOA Integration Application is responsible for integrating Oracle
EBS,Siebel CRM On Demand,PLM and other custom built applications. Oracle
SOA Suite 10.1.3.3 is used as Integration infrastructure to facilitate
seamless data flow between diverse applications.
Implemented Oracle PIP(Process integration pack) based on AIA for
integrating data such as Accounts,contacts,party,oppurtunities,quotes
between Oracle EBS and Siebel CRM On Demand application. This application
has other integration flows using FTP adaptor,DB adaptor,File adaptor,JMS
adaptor to facilitate data flow between other custom applications.
Robust error handling framework using fault policies which seamlessly
manages all error conditions. Strong auditing and reports module which
displays all integration process flow auditing and reports data.BAM is used
extensively for auditing and reporting.
Technologies & Tools: Oracle SOA Suite 10.1.3.3, Oracle Data
Integrator,Java, J2EE, SOA, Webservices, SQL, PLSQL,
XML, XPATH,XSD, PVCS, TOAD, UNIX, Shell Scripting,,HTML
Middleware : Oracle SOA Suite
10.1.3.1(BPEL,BAM,ESB,Oracle PIP AIA)
Database : Oracle 10G Release 2 Enterprise
Edition
Responsibilities
. Design and develop BEPL process using Oracle BPEL for various
integration flows.
. Customise and implement Oracle PIP(based on AIA) for integration of
data flow between Oracle EBS and Siebel CRM On Demand System.
. Design and develop robust error handling framework using BPEL fault
policies to seamlessly handle all types of errors.
. Oracle AQ's are used to exchange error messages between the Business
processes and Error bpel process.
. Design and develop Auditing framework to display the status of diverse
BPEL process integration flows.
. Design and develop robust reports using Oracle BAM. Auditing framework
is also developed using Oracle BAM.
. All Audit and report data are sent to BAM repository using BPEL
sensors.
. Injected human workflows in Oracle BPEL process wherever human
intervention is needed in the bpel processes.
. Other adaptors(FTP,File,DB,and JMS) to integrate custom applications
built.
. Used WSIF binding to include normal java services in the BPEL
processes.
Employer : Wipro Technologies, Bangalore India
Duration : March 2004 - Jan 2009
Designation : Senior Software Engineer
Client projects worked for Wipro Technologies,
Duration : June 2007 - December 2008.
Client : Dun & Bradstreet, Center Valley, PA
Last Designation : EBI(Enterprise Business Integration) Consultant
Global Hygiene and Match (BPEL Driven Workflow Manager Application)
Work Flow Manager Application gets data as batches FTPed from IBM and calls
various Hygiene,Match,Cleansing and Standardisation services downstream and
returns the clean data to IBM.Developed and Implemented an intelligent work
flow engine encompassing sequential services call execution, parallel
services call execution, splitting jobs as chunks, Merging all chunks to
parent job, Regulating services invocation, internal and external routers,
services chunking, Batch statistics report, Match statistics report, Sanity
check report. Automated batch status email report for sending the current
status of batch to the concerned recipients.
Batch Monitoring Portal application
Web based monitoring UI tool for checking current batch execution status
and reports.
It also provides the ability to stop, restart and abort particular service
in a business process flow.
It also used to provide batch execution order based on priority to the
scheduler for triggering batches in specific order.
Auditing and Error Monitoring application
This application receives auditing and error messages from the workflows
about status of services in business process during runtime. Audit and
error components are responsible for logging the messages received against
the services in the oracle table. The logged records are displayed as audit
and error messages in the UI.
Technologies & Tools: Seebeyond ICAN 5.0.5(eGate,eInsight),Sun JCAPS
5.1(eGate,eInsight), Seebeyond SRE 5.0.5,Servicemix,
Oracle SOA Suite 10.1.3.1,Java, J2EE, SOA,
Webservices, SQL, PLSQL, XML, XPATH,XSD, PVCS,
TOAD, UNIX, Shell Scripting, Velocity,Struts
1.2,JSP,HTML,iBATIS
Middleware : Seebeyond ICAN 5.0.5, Sun JCAPS 5.1,
Seebeyond SRE 5.0.5, IBM MQ Series 5.3, Oracle SOA
Suite 10.1.3.1
Database : Oracle 10G Release 2 Enterprise
Edition
Team Lead Responsibilities
. Understand business requirements from business analyst,prepare use
case documents and get it approved from client.
. Prepare high level design document for the requirements and get it
approved from architect team.
. Prepare low level design document for each type of interfaces.
. Explain the interface requirements and low level design of the
interface to all developers at onshore and offshore.
. Layout best practices,naming conventions,coding rules and
specifications to be followed while developing the interfaces in
eGate.
. Distribute the work among the developers and get all the interfaces
developed,unit tested from the developers and verify the test
results.Also would perform sanity checks on all the interfaces
personally.
. Evaluate the work and performance of all developers in the team and
shall provide report to the immediate top level manager once in a
quarter.
. Review goals and objectives of all team members and provide ratings
for the same.
. Managed a team of 4 at onshore and 12 at offshore.
. Trained more than 20 members in seebeyond ICAN 5.0.5 and sun Jcaps
5.1.
. Make the integration system ready for testing and notify the testing
team to carry out integration and system testing.Assist the testing
team in case of any issues.
. Visualize deployment strategy and prepare deployment design document
and get it approved from architect team.
. Automate all deployment activities and release the interfaces to
production and provide support until the system gets stabilized.
Technical Responsibilities
. Design and developed work flow process using ICAN (eGate,eInsight),sun
JCAPS(eGate,eInsight)
. Developed java collaborations for transformation of data specific to
external service format.
. Connect to external systems MQ Series,FTP,NAS,DB2,Oracle,Web services
and bring in data in to the system using Sun eWays.
. Developed interfaces based on JBI framework in ServiceMix ESB.
. Developed powerful routers using Enterprise Integration patterns
framework.
. Developed BPEL process flows using eInsight for Business process
orchestration.
. Migrate existing Seebeyond based Work flow manager application to
Oracle Fusion based application.
. Design of Service oriented data flow application using Oracle
BPEL,Oracle ESB.
. Developed connectivity services using Oracle ESB adaptor services.
. Developed business process flows using Oracle BPEL.
. Design and develop BAM reports by sending report data to BAM
repository using BPEL sensors.
. Developed human workflow in Oracle BPEL processes wherever human
intervention is needed.
. Developed J2EE Webservice modules to be integrated in BPEL process
flow.
. Integrated FTP, File adapters in BPEL.
. Developed XSLT and Java collaborations for performing transformations
of XML data.
. Development of XPATH Queries to extract XML data from Source to
target.
. Developed web based monitoring of batches using Struts 1.2,JSP &
iBATIS .
. Developed Automated batch status report via email using Velocity as
templating engine.
Duration : November 2005 - May 2007.
Client : Carrefour, Paris, France
Last Designation : EAI Application Developer
Amtrix to Seebeyond Migration
This is an Integration project for world's No.2 Retailer Carrefour which
involves developing interfaces for A2A and B2B integration for extensive
applications and trading partners.A2A integration involves integrating
systems with in Carrefour and B2B integration involves integrating with
trading partner suppliers of Carrefour. In A2A integration data is
transferred and transformed between FTP server file and delimited MQ text
message. In B2B integration flat file is converted to EDIFACT business
message and sent using AS2 over http to the trading partner. The entire
Integration application was developed using Seebeyond ICAN 5.0.5 & Sun
JCAPS 5.1(eGate,eInsight,eXchange and eVision).Also has web based
monitoring tool for checking the messages status and state in the system.
Technologies & Tools: Java, J2EE (Servlets, JSP, JNDI, JCA, JTA, EJB),
SOA, Webservices,, SQL, PLSQL, XML, XPATH, Struts,
TOAD, UNIX, Shell Scripting, Clear Case,Clear Quest
Middleware : Seebeyond ICAN 5.0.5
Suite(eGate,eInsight,eXchange),Sun JCAPS 5.1
suite(Sun eGate,sun eInsight,sun eXchange,sun
eVision), Seebeyond SRE 5.0.5
Database : Oracle 9i RAC
Specifications : EDIFACT,AS2
Responsibilities
. Design and develop A2A and B2B interfaces.
. Use eGate eWays to connect to external systems like FTP,IBM
MQ,EDIFACT AS2 compliant trading partner,Batch local file
system,Oracle.
. Implemented B2B protocol and configured B2B host to enable seamless
communication between carrefour system and B2B trading partners.
. Creation and configuration of Internal and External delivery channels
in the host needed for communication.
. Configure trading partner profiles using ePartner exchange console and
Configuration of private and public certificates needed for secured
transaction.
. Developed interfaces for transforming flat file messages in to MQ
based delimited text message,flat file messages to EDIFACT message and
EDIFACT message to flat file message.
. Deign and develop health check component to check the connectivity of
all the external system status and their liveliness.
. Developed certificate management tool to manage the certificates of
thousands of suppliers and notify to a particular supplier
automatically when the certificate gets expired.
. Design and develop Auditing and error monitoring component to track
the status of all messages flowing in the system.
. Automate the deployment process by automatically creating the logical
hosts,clean bootstrapping of logical hosts.
. Clustered AS2 server to accommodate load balancing and fail over
scenarios.
. Developed Web based monitoring tool for viewing and tracking messages
in the system using JSP,HTML,Struts and iBATIS.
. Developed stored procedures and efficient prepared statements used by
the interfaces.
Duration : March 2004 - November 2005
Client : National Grid Transco, Birmingham, UK
Last Designation : Senior Applications Engineer
This is an Integrated gas management system developed for National grid
Transco who sends gas and electricity through pipeline to different areas
in the US and Europe. The system receives signals from various devices like
compression meters, alert meters, volume measurement metres etc that are
placed in the pipelines and gets updated in systems like
SAP,mainframes,custom applications approtiately.This involves integrating
diverse systems like SAP,Mainframes,custom applications,Batch FTP,MQ series
and facilitate the system to work as one unified whole. Integration
solution is developed in Seebeyond ICAN 5.0.5 suite and the monitoring
portal is developed in J2EE Technology .This data is displayed seamlessly
in the portal in different formats based on the Business need.
Technologies & Tools: Java, J2EE (Servlets, JSP, JNDI, JCA, JTA, EJB),
SQL, PLSQL, XML, Struts 1.2, TOAD, UNIX, Shell
Scripting, Clear Case,Clear Quest,Oracle jDeveloper
9.0,Oracle 9i AS
Middleware : Seebeyond ICAN 5.0.5 Suite(eGate)
Database : Oracle 9i RAC
Responsibilities
. Worked with external application teams to find out the integration
areas for the system and identify the data formats specific to each
system.
. Design and developed usecases diagram, component diagram and sequence
to provide integration solution for the system.
. Develop and configured SAP eWay,Batch FTP eWay,MQ eWay,Oracle eWay to
connect external system to pull in or push out business data.
. Developed java collaboration definition interfaces for converting the
data format from one system specific to another.
. Developed alerts,auditing and error monitoring components for
providing quality of service to the integration system.
. Developed routers for routing the business messages to the appropriate
outbound service for flushing out the message from system.
. Developed web based UI portal using struts,JSP,HTML,jdbc DAO for
displaying and tracking the messages in the system.
Contact this candidate