Developer Sql Server

Bhanu Prakash

859-***-****, Covington, Kentucky.

***.*****@*****.***

PROFESSIONAL SUMMARY

* ***** ** ** ********** encompassing the complete lifecycle of a project (design,

development, testing, deployment and support) with Strong focuses B2B integration using

webMethods.

webMethods Consultant, experience in Rational ClearQuest (defect tracking) and ClearCase

(code control) WebSphere, WebLogic and FileNet P8 Java, J2EE, EJB's - Java and compiling

Java object UNIX/ AIX.

Experience in webMethods Developer 4.6/ 6.x Integration Server 6.5, workflow designer

6.1, modeler monitor administrator and broker.

Experience with JMS, MQ, SAP, People Soft, Oracle apps, Siebel, JDBC Adapter and

exposure to configuring standard, intelligent and custom Adapters like Oracle, Siebel, Sybase

Database adapter for the legacy systems like oracle 11i apps, Siebel 7.7 Oracle8i & Sybase

open client.

Experience in development and deployment of EAI / B2B / A2A applications on webMethods

platform

Experience with integration scenarios between different databases and legacy systems like

Oracle, SQL server, IBM DB2, Oracle apps and Siebel CRM.

Experience in building, managing and analyzing webMethods Trading Networks. Experience

in data mapping with trading partners.

Worked extensively on EDI transaction sets.

Very Good management abilities and excellent understanding of SDLC, Onsite-Offshore

methodology and extensive usage of GEAR Methodology.

Involved in developing XML schemas, DTDs using XML spy 4.0.1, parsing XML using

Xerces (DOM and SAX) and parsers.

Experience in writing flow, java services and web services using webMethods developer.

Over 4 years of extensive experience internet/intranet, client server and distributed applications

using java with JDBC, Servlets, JSPs, EJBs, Java XML, C+, JavaScript and HTML.

Strong functional experience of over seven yrs with exposure to complete project life cycles,

executed under strict quality standards of SEI-CMM level 5 quality model &six sigma quality

model.

Experience with coding java services, flow services and web service connectors.

Self-motivated and enjoy working in a technically challenging environment. Possess excellent

communication and interpersonal skills.

Experience in day-to-day production support activities.

Certifications

webMethods Certified Developer (Jan 05)

TECHNICAL SKILLS:

MS(BioInformatics), School of

Education

Informatics, Indiana University Purdue

University, Indianapolis, IN

C, Java, PHP, Python, Perl, C++

Languages

WebMethods 4.6, 6.0, 6.1, 6.5,7.1

EAI/Messaging Tools

MQ Adapter 6.0 JMS Adapter, JDBC

Application Adapters

Adapter 6.0, Siebel 6.0, Oracle Apps 6.0,

People Soft 6.0 Sap 4.6

837\835\997\270\271

EAI Transactions

BEA WebLogic 8.x, IBM Websphere

Servers

5.3,6.0, Tomcat, IIS

JSP, Servlets, Java Beans, EJB, JDBC,

J2EE/Web Technologies

JNDI, JMS, RMI, Web Services

MS Windows 95/NT/2000, AIX, Unix,

Operating Systems

Linux

Qtp 6.5, 8.2, Test Director 7.6

Testing Tools

Microsoft SQL Server 7.0,/2000, Oracle

Databases

10g, 9i, 8i, 7.3, MS Access, DB2, mySql

XML, XSLT, XSD, Xpath,

Scripting Languages

XQUERY,DTD, DOM/SAX Parser,

WSDL, Javascript, VB Script, HTML

Rational ClearCase 8, IS 6.5

Version control

EXPERIENCE:

July-07 to feb-09

Fidelity Investments, Covington, KY

WebMethods Middleware Consultant

• Broker maintenance including configuration, queue and wm document management.

• Reconfigured generic Java based services with webmethods flow code.

• Created, updated, modified xml, xsdl and wsdl’s for webservices according to user

requirements

• Assessed existing packages, understood modules, made changes accordingly for new

requirements from business partners.

• Created deployer packages to move code from development to production servers

• As on-Call support, monitored the quality of work, responsible for technical support.

• Created new jdbc adapters, notifications, triggers to move data between business partners.

• Created, maintained and delivered detail design documents related to the projects

• Technical support in design architecture.

• Provide guidance and code support to team members in daily activities.

Environments: IS 6.0, 6.5 JDBC, WM Broker, WM Deployer 6.5.1, WebSphere 6.1, SunOS 5.8

April-06 to April -07

WellsFargo, Desmoines, Iowa

WebMethods Consultant

• Documented and Created packages, flow services needed for Enterprise Organizations.

• Real time technical support to capture, investigate, approval, closing, documentation and

booking of credit applications through webMethods services.

• Developed JMS services for Publish Subscribe model using Websphere broker integrating with

WebMethods

• Administered Package migration from 6.0.1 to 6.1

• Administrative support for WSDL creation, SOAP RPC and deployment for data integration

• High level error handling using custom build Adapters to extend the capabilities of

WebMethods

• Rational ClearQuest (defect tracking) and ClearCase (code control) WebSphere, WebLogic

and FileNet P8 Java, J2EE, EJB's - Java and compiling Java object UNIX/ AIX experience

• Developed MQ adapter services to publish and Subscribe to broker

• Developed Flow Services and java Services to process the EAI call documents.

• SMTP service for internal Admin Notification during fail process.

• Created JUnits to test the flow services rigorously.

• Excellent analytical and problem solving skills, Self-motivated and able to work independently

• Trading networks and created partner profiles.

• EDI package to communicate documents.(997, 270,271)

• Created custom XML canonical document for publishing to IBM MQ broker.

• Implemented different delivery methods (HTTP/FTP(s)) on secured channels (SSL, NTLM)

• Involved in multiple layered Architecture to fit webMethods perfectly into scene.

• Dealing with the issues occurred in the Layer Integrations.

Environments: IS 6.0, 6.5, JMS, MQ Adapter, EDI 997, 270, 271

Mar -05 to Mar -06

Harsco GasServ, PA

WebMethods Consultant

• Administrator for clustering environment with IS 6.1

• Created the JDBC Adapter Update notification.

• Updated 4.5 IS to 6.1 IS in cluster environments

• Created technical documentations for Business analyst to integrate Trading Networks.

• Developed Flow Services and java Services to process the documents.

• Used SMTP service for Notification using e-mail.

• XML to XML mapping

• Created custom XML canonical document for publishing to broker

• Created JDBCD connection pools for storing information of ISCoreAudit, Process Audit and

Oracle Apps adapter connection pools (pool alias definition)

• Implemented different delivery methods (HTTP)

• Extensively used JDEdwards, SAP and JDBC adapters.

• Involved in functionality transfer to the teammates.

• Involved in all the touch-points integration.

• Dealing with the issues occurred in the touch-points.

• Involved in Regression, Smoke Testing and Functional Testing

Environment: webMethods Integration Server 6.1, webMethods Developer 6.1, JDEdwards Adapter

Mar 04 to Feb 05

LQAS Report, Indianapolis

EAI Consultant

Responsibilities:

• Proposing a high and detail level architecture of the entire system that contains the web

methods integration server 6.1, Broker server 6.1, web methods develop 6.1, web methods

Oracle apps adapter 6.0, web methods Siebel Adapter 6.0 needed and developed the Canonical

document that contains the generic structure and requirement gathering.

• Understand the Mappings between Oracle Apps base tables and Seibel EIM table and map the

both to the webMethods predefined transactions and BC fields. Decide on the integration

strategy for various transactions (For ex Usage of Siebel workflow or BS) web methods system

design.

• Created JDBC connection pools for storing information of ISCoreAudit, Process Audit and

Oracle Apps adapter connection pools (pool alias definition).

• Implemented different delivery methods (HTTP) between web methods IS and Siebel CRM.

• Extensively used Siebel, Oracle Apps and JDBC adapters.

• Involved in functionality transfer tot the teammates.

• Involved in all the touch-points integration.

• Dealing with the issues occurred in the touch-points.

• Involved in Regression, Smoke Testing and Functional Testing.

Environment: webMethods integration Server 6.1, webMethods developer 6.1, web methods monitor,

Seibel 6.0 adapter, oracle apps 6.0 adapter.

May 2003 to Jan 2004

USAA Insurance, Indianapolis

WebMethods consultant

The integration involves redesigning the interfaces that were written for WorldChain XML 3.1 to

Worldchain XML3.7. The project involves development of new interfaces for the WorldChain XML

3.7 with auditing and moving them to the production environment.

Responsibilities:

• Involved in the designed of a Worldchain framework for the efficient intra -auditing purposes.

• Developed Flow services that map the BAPI structures from the SAP server to the WorldChain

XML 3.7.

• Developed the mapping documents for the transformation from BAPI to Wroldchain XML and

from Worldchain XML to BAPI.

• Extracted data from Sybase to populate the SAP tables using WmDB.

• Involved in designing the technical requirements and documenting them for the new solution.

• Developed the configuration files for the static fields mapping.

• Document the entire solution for the company records.

Environment: WebMethods B2B server 4.6, webMethods Developer 4.6, WmDB, SAP Adapter,

Oracle, Sybase and Java.

Sep 2002 to Apr 2003

Master Integration, Softima, Inc, IL

WebMethods Consultant

Responsibilities:

• Installation of WebMethods integration server, Developer, Trading networks, modeler.

• Created JDBC connection pools (pool alias definition alias definitions) for storing information

of ISCoreAudit, Process Audit, TN and Xref.

• Crated Aliases for accessing the Services in remote integration servers.

• Created access control lists, groups and new users with different privileges using integration

server administration. Screen.

• Managed B2B packages and services to include copying packages between environments,

updating and installation, Archive and activating/deactivating packages.

• Defined and setup various trading partner profiles, document types and creating processing

rules using trading network console.

• Implemented different delivery methods (FTP, SMTP etc) between enterprise and trading

partner.

• Designed reports using DSP pages.

• Extensively used JDBC to connect to databases like SQL server.

• Developed Human readable formats for 997, semantic and code source errors.

• Testing of WmHipaa package with different types Edi documents like 270, 837, 835 etc

• Created flat file schema and dictionary for EDI document.

• Tested Hipaa package with different Trading partners, with different delivery methods

• Tested total transaction flow process using Trading Networks.

Environment: webMethods integration server 6.0, webMethods trading networks 6.0, webMethods

Developer 6.0, webMethods Modeler, WebMethods Monitor.

Oct 2001 to July 2002

Worldwide Retail Exchange, wwre AZ

Web Methods Consultant

Responsibilities:

• Responsibilities for proposing a high and detail level architecture of the entire system that

contains the webMethods integration server and trading networks.

• Recommended and developed the canonical document that contains the generic structure.

• Responsible for transforming EDI 850 to canonical document and then to a flat file format that

is acceptable by the Legacy system.

• Responsible for generation acknowledgement (997) for the received EDI 850

• Created and configured Trading partners to exchange the 850 document using http.

• Aided in integration testing and deployment.

Jan 2001 to Jul 2001

Issue Tracking GTL-Product-India

Java Progrmmer

Item synchronization: A product catalogue is the backbone IT infrastructure on which a Retailer runs

his business. More critical aspect of the product catalogue is the capability to keep the information

about items in the catalogue always up to the date. This problem is most commonly referred in the

industry as Item Synchronization. Items are good that are sold by the manufacturers to the retailer to

be sold by the retailer to the consumers, Some times manufacturers discontinue making certain items

and some times they repackage an item for better profitability. In such cases, if the retailer’s catalogue

is not updated properly then the retailer might place an order for the wrong item, which could result in

wasted shipping costs and lost sales. The technology solution is a hybrid model where we allow the

retailer’s product cataloguing system to obtain the updated via both the push and pull mechanisms

based by the manufacturer or suing the WEB.

Responsibilities:

• Creation of a product catalogue based on MSSQL server

• Creation of JSP/J2EE web interface for item synchronization/ Item management using

WebLogic.

• It also involves the creation of a Webservices for a manufacturer that can act as the server

(producer) and the creation of a web service for the retailer that can act as a client (consumer)

of the web service created by the manufacture.

• Designed front end using JSP.

Environment: J2EE, XML, SQL server and Web Logic 6

This project enables easy tracking of various issues in the organization. This application allows the

user to give the required data for his particular activity that he wants to generate thereby the

application dynamically generated the tables for this activity and also helps him in keeping track of the

different activities related to that particular issue. It also handles the various states of that particular

issue that undergoes thereby defining the different attributes, attribute values for that state if that

particular issue.

Responsibilities:

• Involved in Database Development.

• Design and Development of User Forms using Home Site, JavaScript, HTML and JSP

• Involved in developing Middle Tier logic using Server Side scripting to access te database

Environment: JSP, Java Script, HTML, MS SQL Server

Feb1999 to Dec 2000

MTTool

Java Programmer

MTTool is useful for Doctors and medical Transcriptionists. A doctor can use MTTool for recording

the voice file and save it in a specified remove server from where a medical transcriptions can

download the file transcribe it and saves in the same server. Afterwards, the doctor can download the

transcribed file from his inbox. MTTool also generates reports according to the Doctor or

Transcriptions queries.

Responsibilities:

• Actively involved in coding phase using Java

• Developing components using Servlets

• Developed the screens using HTML, DHTML

• Developed scripts for front end validations using Java script

• Developed the CSS for separating the layout from the functionality

Environment: Java 2.0 Weblogic 4.x and Servlets.

Contact this candidate