Post Job Free
Sign in

Oracle Manager

Location:
93151
Posted:
April 30, 2010

Contact this candidate

Resume:

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.



Contact this candidate