Naresh Mann
(Senior Certified BPEL/ SOA Developer)
Summary
. Over 8 years of working experience in developing enterprise applications
using Object Oriented Technologies and oracle middleware tools. Started
as an associate engineer and reached up to Sr. level by proving my
credibility in different levels of my career
. Extensive experience in Oracle Fusion Middleware (10g,11g), including
Oracle SOA suite, web services, Oracle BPEL process Manager, Oracle
Service Bus(OSB), Oracle Enterprise Service Bus(ESB), J-
Developer(10g,11g).
. Experience with handling the various faults in BPEL processes.
. Design and implementation of the Oracle SOA suite platform including
archiving and maintenance strategies
. Experience in configuration, Parameter Turning, Performance monitoring
and Trouble shooting of Oracle SOA suite
. Experience Installing and Configuring BPEL 10.1.3.3 on Oracle Application
Server and BPEL 11g on WebLogic Server
. Hands-on experience working with Technical Adaptor like JMS, Database,
File and AQ Adaptors
. Extensive knowledge in setting up OWSM policies and implementing Decision
Services, BPEL sensors
. Expertise in application development using JDBC, RMI, XML, Web Services,
WSDL
. Expertise in developing dynamic web pages in HTML with CSS for User
Interface by using JSP and servlets
. Design, analysis and modeling of n-tiered, Object-Oriented system
architectures using UML/RUP/Rational Rose
. Proficient in XML related technologies such as DTD, XSD, XSL and XSLT
. Used web/App servers like Oracle Application Server, WebLogic Server,
WebSphere and Tomcat servers based on the client requirement and project
specifications
. Expertise in using IDE like JDeveloper, Eclipse and NetBeans for
debugging and using java coding standards from the beginning of
development
. Good working Experience in using ANT scripts for building and deploying
the application in web/App servers
. Extensive knowledge in implementing SOA (Service Oriented Architecture)
architecture
. Extensive knowledge of Application Integration Architecture(AIA-3.0)
standards
. Extensive experience in working on multiple operating systems including
UNIX, Sun Solaris, Linux and Microsoft Windows
. Expertise in using configuration management tools like CVS, VSS and
ClearCase for version controlling
. Sound RDBMS concepts and extensively worked with Oracle(11g,10g), DB2,
MYSQL.
. Self motivated, able to handle multiple priorities and excellent time
management skills, able to work well in a team or independently
. Willingness and ability to easily adapt to learn any newer technology or
software
Education:
. M.S. (System Software)
. B.E (Computer Science and Engineering)
Technical Skills
Languages BPEL, Java, C, C++, SQL, PL/SQL, Cobol
Development Tools / Eclipse, Erwin, WSAD, RAD, JBoss, Oracle
Middleware tools JDeveloper, Edit Plus and TOAD / Oracle SOA
Suite (Oracle BPEL Process Manager, ESB,
OWSM).
Web/Application Oracle Application Server, IIS, Weblogic,
Servers WebSphere, Jrun, Apache Tomcat
Web Technologies HTML, XHTML, FrontPage, Dream Weaver, CSS,
JavaScript, DHTML, ASP, VB Script, PHP
J2EE J2EE, JDBC, Servlets, JSP, Java Beans, JMS,
RMI, Applet
Frameworks Apache Struts
XML & Web Services XML Schema, XML Parsers (SAX, DOM), SOAP,
WSDL, UDDI, and XSL Transformations
Databases MySQL, MS Access, ORACLE 9i/10g, DB2 and
MS-SQL Server 2000.
Version Control CVS, VSS, Clear case
Operating Systems Unix, Linux, Windows NT, 2000, XP
Work Experience:
Ingersoll Rand, Davidson, NC.
Dec'09 - April'10
SOA Developer
Project: Legacy to Oracle GL Integration
General Ledger(Gl) Trial Balance Data file is generated by MFG PRO(Legacy
System). Oracle SOA Suite fetches the Data File and GL Code Combinations
are mapped between Legacy Chart of Accounts Values and Oracle's Chart of
Accounts Values. After validation, data is inserted into Oracle GL
Interface Table and imported into Oracle GL Base tables using concurrent
program- GLLEZLSR. Finally, data is posted using concurrent program-
GLPAUTOP.
Responsibilities
. Written MD.70 Interface Technical Design as per AIA standards based on
MD.50 Functional Design Document.
. Configured FTP adapters to read Gl Trial Balance Data file.
. Customized AIA based generic XSD to transfer data from one BPEL process
to other BPEL process using OSB to support loose coupling between BPEL
processes.
. Configured database adapters to transfer Legacy System data to SOA
staging tables-legacy staging and Oracle staging.
. Configured Oracle application Adapter to transfer Legacy System data to
Oracle GL Interface Table.
. Designed various database tables-Legacy Staging, Setup, Cross Reference,
Oracle Staging, etc to store data at various stages of development cycle.
. Written customized queries in database adapters to fetch data from
database tables
. Created views which were accessed by database adaptors to fetch data from
database tables.
. Written stored procedures- to get Oracle's Chart of Accounts Values
based on Legacy Chart of Accounts Values, concurrent program wrappers to
invoke concurrent programs-GLLEZLSR and GLPAUTOP
. Captured all exceptions/errors-remote faults, binding faults, catch all,
business faults-invalid code combination, legacy amount is not balanced,
etc, using scope activity and these faults are thrown to generic AIA
based error handling service.
. Stored process status-instance ID, domain ID, process start time, process
end time, number of records-submitted, processed, error out, etc, in
database table.
Environment: Oracle SOA Suite (11g), Oracle JDeveloper(11g), WebLogic
Server(10.3.1) Oracle Service Bus(10.3.1.0), AIA(3.0), Oracle E-Business
Suite (11.5.10.2), Oracle DB(11g)
American Express,Phoenix, AZ
Aug '09 - Nov'09
SOA Developer
Project: GCT Scorecard Automation
Global Corporate Technology (GCT) Scorecard is a performance
measurement tool. It consist metrics-cost, compliance, etc, to report and
track different technology areas-resource utilization, reengineering,
operating expenses, etc, of GCT supported line of business-finance, HR,
advertising, security, etc. It is used by executive leadership-Vice
President, etc, of GCT. Data from various sources is loaded on share point
server in excel sheets. Then, we will run macro to convert excel sheets in
to CSV files and copy these files to oracle application server directory
using scorecard upload utility. BPEL process will read these files and
transfer the data to staging tables in database. Then, data from staging
tables is transferred to reporting tables. Business Intelligence (BI) tool
such as Oracle Business Intelligence Enterprise Edition (OBIEE) is used to
generate performance metrics.
Responsibilities
. Written MD.70 Interface Technical Design Document as per AIA standards
based on GCTScoreCardSmallProjectReport, Functional Design Document.
. Configured file adapters to read CSV file data.
. Designed generic xsd to transfer CSV file data from one BPEL process to
other BPEL process
. Mapped data from various CSV files to generic xsd.
. Configured database adapters to transfer CSV file data to staging table.
. Written customized queries in database adapters to compare value of
VicePresidentName and LineOfBusiness, stored in database table with the
values coming from CSV file.
. Configured eMail notification service to send eMail notification to user
indicating system fault, successful transfer of CSV file, etc to the user
. Created work list application user in Enterprise Manager
. Designed workflow to display Vice President Name and Line of Business
values of CSV file in work list application if CSV file values do not
match with values stored in reference table. Updated values-Vice
President Name and Line of Business, from working list application to
reference table in database
. Modified auto generated JSP in work list application to point
VicePresidentName and LineOfBusiness values that does not match with
values stored in reference table.
. Captured system faults-remote faults, binding faults and catch all, using
scope activity and invoked ErrorManagment, BPEL, service to send eMail
notification to the user and store fault details in database table for
future reference.
. Stored process status-instance ID, domain ID, process start time, process
end time, etc, in database table.
Environment: WebLogic Server(10.3.1), Oracle BPEL process Manager, Oracle
SOA Suite (11g), Oracle DB(11g), Oracle JDeveloper(11g), SQL Developer
Schneider National, Inc, GreenBay,WI
Jan '09 - May'09
SOA Developer
Project: EBS to Lawson/M5 Supplier Data Interface
Supplier master is maintained in Oracle E-business Suite (Ebiz).
Supplier is created/updated in Ebiz system. Concurrent program will check
for any updates/create and raises business event and it is sent to Lawson
(Legacy Accounts Payable System)/M5 (Schneider Maintenance System).
Lawson/M5 will request BPEL service with search criteria-Supplier Id, Site
Id, etc. BPEL process will do specific operations like fetching data from
database related to supplier, site, etc, mapping to generic XSD and
transfer data to Lawson/M5. Lawson/M5 will collect the modified changes and
store in staging table. In Lawson/M5, BPEL process will be triggered
periodically (Every four hours) to extract data from the staging table. In
Lawson CSV file will be generated using SFTP and in M5 XML file will be
generated and these files will be sent to the respective systems.
Responsibilities
. Written MD.70 Interface Technical Design Document based on MD.50
Functional Design Document.
. Designed, Developed, and maintained various BPEL processes.
. Written customized queries in database adapters to access data related
to suppliers, sites, etc.
. Mapped data returned by various database adaptors to generic xsd.
. Customized generic xsd to accommodate requirements of EBS To Lawson/M5
Supplier Data
Interface.
. Captured all exceptions/errors-remote faults, binding faults, catch
all, business faults, using scope
activity and these faults are thrown to Lawson/M5.
. Deployed BPEL processes in secure/ non secure SOA box.
. Created views which were accessed by database adaptors to fetch data
from database.
. Created business event in EBS system.
. Extended procedures to check for any update/create related to supplier
bank/supplier site bank and it
will invoke appropriate business event.
. Written procedures to raise business event.
Environment: Oracle Application Server (10g), Oracle E-Business Suite
(12.0.6), Oracle BPEL process Manager, Oracle ESB, Oracle SOA Suite
(10.1.3.0), Oracle DB(10g), Oracle JDeveloper, Oracle Real Application
Clusters.
W.L. Gore and Associates Inc, Elkton, MD
Dec '07 - Dec'08
SOA Developer
Project: Enterprise Integration
Client is currently implementing ERP upgrade project to upgrade from AS/400
based JDEdwards ERP System to Web based Oracle Enterprise One (E1) which
runs on Unix OS, Oracle DB and Oracle Application Server. Client had about
200 point to point interfaces to their legacy system from various other
systems like People Soft (HR), SIEBEL (CRM), Multiple Manufacturing
Execution Systems (MESA, Insite, Wonderware etc), Tra/x (Transportation
Package), Extranet B2B transactions (Suppliers and Outside Processors),
Financial Interfaces with Banks (Credit Card Transactions, ACH, ProCard,
Corporate Card, Bank Reconciliations etc) and Interfaces with 3PL (3rd
Party Warehousing and Order fulfillment partners). The goal of the
Enterprise Integration project is to rebuild all the existing interfaces
using Standards based Middleware Architecture to work with the New
Enterprise One ERP system. Oracle SOA suite was selected as the Middle
platform.
Responsibilities
. Installing and Configuring Oracle SOA suite on Sun Solaris.
. Designed, Developed, Deployed and maintained various BPEL processes.
. Involved in Design and development of BPEL processes that contain Human
workflow and paging.
. Developed BPEL processes that contain exception handling to capture the
Remote and Binding faults.
. Experience in using the Sensors in the BPEL process to create the data
for the BAM implementation.
. Designed, Developed and Registered Various ESB services.
. Secured the BPEL processes that are accessed by outside partners by
setting the policies in the oracle OWSM (Oracle Web Services Manager)
. Developed Oracle PL/SQL stored procedures and executed these procedures
using Database Adaptors.
. Configured and Accessed data from the SQL Server and AS/400 using the
Database Adaptor
. Configured file Adaptors to created XML files from the flat files.
. Configured file Adaptors to process the xml files from outside companies
and the data from xml files is used to perform the transaction in ERP by
making web service calls.
. Created E1 web services using WSG (Web Services Gateway) adaptor. WSG
provides functionality to expose E1 business functions as services.
. Created JMS Queues and JMS Topics
. Extensively used JMS adaptor to Produce and Consume the messages.
Environment: Oracle Application Server, Oracle BPEL process Manager, Oracle
ESB, Oracle OWSM, Oracle DB, AS/400, SQL Server, Oracle JDeveloper,
Enterprise One, Web Services Gateway (E1 Adaptor), Tra/x, PSFT, SIEBEL,
MES systems, Bank systems, 3PL systems.
Xerox, Rochester, NY
Jan '07 - Nov '07
SOA Developer
Project: Enterprise Integration
Client is currently implementing various interfaces between Siebel and
Oracle financial application. Siebel CRM does not offer capabilities to
represent transactions into financial and accounting format, nor does it
have out of box capability to integrate with Oracle Financial applications.
Therefore there is a need to design and develop an interface that will
transform Siebel transaction into financial transaction and interface to
Oracle Financial application.
Responsibilities
. Installing and Configuring Oracle SOA suite on Sun Solaris.
. Designed, Developed, Deployed and maintained various BPEL processes.
. Involved in Design and development of BPEL processes that contain
Human workflow and paging.
. Extensively used JMS adaptor to Produce and consume the messages.
. Extensively used Database adapter to post the summarized
transactions.
. Created JMS Queues and JMS Topics and MQ Queues.
. Extensively used advanced queuing (OJMS).
. Developed Oracle PL/SQL stored procedures and executed these
procedures using Database Adaptors.
. Installing and Configuring Oracle SOA suite on Sun Solaris.
. Used the Oracle JDeveloper IDE.
. Designed, Developed and Registered Various ESB services for Routing
services.
. Configured SMS Activity for sending alert messages to administrator.
. Experience in using the Sensors in the BPEL process to create the
data for the BAM implementation. Involved in RTP (Releasing code to
Production Environment)
Environment: Oracle Applications, SIEBEL, Oracle JDeveloper, Oracle BPEL
Process Manager, OWSM, Oracle Database, Oracle JDeveloper, SQL Server,
PL/SQL, Java, JSP, Sun Solaris, Oracle Application Server.
Pfizer, NYC, NY
Apr '06 - Jan '07
J2EE Developer
Order System
This is an application that is built for the Order processing. Sales
Representatives and Associates- Vice Presidents, Regional Directors,
District Sales Reps, Zonal Sales Reps and Territorial Sales Reps, can
place order for a calendar quarter for the product that they need. The
authorizing hierarchy endorses the order or makes changes and passes it on.
Then it comes to the Vice President for approval. Through this application
the senior management is also able to track the products and territories.
Responsibilities
. Study and review the Technical Requirements to identify the business
processes and requirements.
. Involved in the J2EE architecture with Senior Project Manager and the
Principal.
. The project design was implemented using the RUP processing.
. The application was developed using WSAD.
. Created a web service using SOAP protocol for login user authentication.
. The MVC II pattern with the Struts Framework was utilized for easier and
faster development.
. Presentation layer components were developed using JSPs, custom tags and
JavaScript.
. Wrote Action classes to handle client side requests.
. Predominantly all the actions for that page were captured in the same
Action Handler class.
. Persistence of data was done using Bean Managed Persistence.
. Wrote DAO to persist data to the underlying Oracle database.
. Used ANT for build and deployment scripts.
. Involved in designing Database Schema, writing complex queries, stored
procedures triggers, views and PL/SQL scripts on Oracle Database.
Environment: Java, J2EE, JSP, Servlets, Java script, Web sphere, WSAD, Web
sphere as application server, Oracle 9i, PL/SQL, SQL, Windows.
Picasso Software, Dallas, TX
Feb '03 - Mar '06
Programmer
Inventory Control
The application is a software solution for an inventory control system,
which integrates inventory management, billing and order management
capabilities for service providers to ensure superior business management,
performance and scalability. It powers faster and more precise sales
management, channel inventory measurement, validation of forecasts, and
financial reporting.
Responsibilities
. Responsible for ongoing interaction with users and management to define
requirements for the development of the new modules for the project.
. Built the presentation layer utilizing the Struts 1.1 framework and MVC
architecture.
. Developed the user interface using CSS, HTML and JavaScript.
. Developed persistence layer and business side entities.
. Used J2EE design patterns like Value Object Pattern and Business
Delegate.
. Configured the WebSphere 5.0 application Server and deployed all the
modules like Web modules, Business modules on WAS 5.0.
. Created a web service for distributed communication.
. Utilized WSAD as the development IDE.
. Developed cursors, triggers, stored procedures on Oracle 9i.
. Used Oracle and SQL for database connectivity.
Environment: J2EE 1.3, Java Beans, Struts 1.1, HTML, XML, XSL, CSS, WSAD
5.0, IBM WebSphere 5.0, UML, Oracle 9i.
Project: NNM & IRA Summary Page
Programmer
The goal of this project is to provide a single window service/view to
financial advisors and home office (HO) users to view the client's summary
of IRA Account Information and Net New Money Reports. They can also access
various reports like contribution report, distribution report, client
profile report, etc. The application will eliminate multiple views of
application because information is located at multiple places and it will
help in resolving issues and serve all stake holders more effectively.
Responsibilities
. Involved in Analysis, Design and Architecture of the project. Responsible
for class diagram, Sequence diagram etc.
. Created user interface using Struts, Tiles, HTML and Java Script.
. Applied patterns like Value Object, Business Delegate, Front
Controller, MVC and Data Transfer Objects.
. Created reports for Net New Money and IRA summary page used by the FAs
and Home Office (HO) users.
. Designed and developed Client and Account Adhoc report module, Commission
Ineligible module, NNM and IRA.
. Analyze user requirements, procedures and problems to automate or enhance
existing system.
. Created stored procedures using Win SQL and DB2.
. Developed various reusable Helper and Utility classes which are being
used across all the modules of the application.
. Created a web service using SOAP protocol
. Developed sequences, cursors, stored procedures on Oracle 9i.
. Used CVS for version controlling.
Environment: Java, J2EE, JDBC, JSP, Servlets, Struts, WSAD, WebSphere,
Java Script, DB2, XML, CVS, Win SQL, Business Objects and Windows XP
Project: Accounting Software
Programmer
SR Drugs is a large pharmaceutical company manufacturing bulk
pharmaceuticals. An application relating to Inventory Management System was
designed and developed to resolve complex Tax Jurisdiction and implemented
MODVAT taxation. It is a web-based application developed using Java and
MSSQL Server 7.0 Database as a backend. This Application was developed for
SR Drugs to track the customer purchases and sales. It also involved
complex accounting module, which keeps track of Account Payables and
Receivables.
Responsibilities
. Designed a system, which tracked each customer for their purchase trends
over several quarters using historical data and generated that enables
for precise planning.
. Implemented modules relating to Inventory Reorder level.
. Designed web pages using JSP.
. Was involved in coding various reports using JSP.
Environment: JSP, MSSQL Sever 7.0, Windows 95/98, Weblogic 8, Manual
Testing
Guru Jambheshwar University, India
Aug '98 - Jan '03
Faculty Of Computer Science
Lecturer
Research Projects:-
. Automated tool for generating conceptual graphs from text and Comparison
of student generated links with Automated Links. Concept mapping promotes
the idea of holistic learning. It allows the user to see how the concepts
in a system are connected. Bhava-Vachna is a tool under development that
intends to enable the user to depict her ideas in the form of maps, by
creating concept maps. The tool intends to make learning and
communication easier and quicker by the means of visual formats of data.
This project is developed in C-language on windows 98 platform.
. Generation of oscillator topologies using Genetic Algorithms. In this
project the topologies of oscillator circuits has been generated using
genetic algorithms. This is a software simulation to automate the
evolution of electronics circuits (implemented for oscillator circuits)
and their behavioral study. The project is designed in C-language.
Orcade and MAT-LAB software are used for studying behavior of circuits.
It works on any windows based operating system.
. Handwritten character recognition using artificial neural networks: - An
artificial Neural Network is designed to recognize a character set. The
network is made to learn as per the requirement by training them with
some specific bit patterns that corresponds to the character. Variation
of learning constants and momentum is studied and performed. Number of
hidden layer neuron is used for designing the artificial neural network.
Easynn-Plus software is used for the analysis of handwritten characters.
. E-governance : A study of Land Record Department. According to National e-
Governance action plan (2003-2007), government has identified over 20
mission mode projects- income tax, passport, visa, immigration,
insurance, national citizen database, central excise and banking, land
records, road transport, property registration, agriculture, treasuries,
municipalities, gram-panchayts and commercial taxes, at central and state
level to be taken up for e-Governance initiatives. Computerization of
land records is first initiatives of e-governance in India, at grass root
level. The project investigates land management system that generate
resource intelligence necessary to maintain equilibrium of land and man
relationship. To check the effectiveness of e-Governance initiatives in
Haryana- land record department having direct interface with public have
been selected. In this department- services provided, bottlenecks and
recommendation to improve these services have been studied so that
benefit of ICT can reach to masses. Proposed data flow has been depicted
by using flow charts and data flow diagrams.