Professional Summary

• 11 years of experience in software industry Requirement Analysis /designing/developing Client/Server, Internet/Intranet and message based Applications. Analytical, innovative and result-oriented team player. Hard working, resourceful with commitment for excellence.
• Strong experience in Data warehousing and BI solutions.
• Strong experience in SOA, B2B, BPM, BAM and ESB 2.0 design and implementation.
• Strong experience in BizTalk Server 2009, BizTalk Server 2006 R2, BizTalk Server 2006 and BizTalk Server 2004 EDI implementation with AS2 communication.
• Strong experience in ASP .NET 3.5 Web application design and implementation.
• Worked in SQL Server 2005 Reporting Services and SSIS.
• Strong experience in Visual Studio Team Foundation Server 2008 with agile methodology.
• Strong experience in SharePoint Server 2007 and worked in SharePoint custom development.
• Knowledge on FORESIGHT EDISIM and EDI technologies. Worked in EDI 867, 814, 834 and 820 files.
• Worked in WCF and WF technologies.
• Knowledge in .NET Enterprise Library 3.1
• Knowledge in Service Factory
• In-depth understanding of OOAD, UML, creating artifacts such as, class diagrams, and sequence diagrams. Experienced applying design patterns and Microsoft best practices.
• Worked with the new Microsoft BizTalk adapters like Oracle database, TibCo EMS, JDE One World, Siebel and Oracle Application Suite adapters in Microsoft Technologies, Redmond.
• Strong working experience in C .NET
• Four and half years of experience in VC MFC, Ole COM ATL
• Worked in Oracle 9i, DB2, Lotus Notes 4.0, SQL Server 2000 and SQL Server 2005
• Worked with a C .NET project that will interact with COM component.
• Worked with thread based applications.
• Worked with windows services.
• Worked with SMTP and POP3 protocols and mail servers.
• Worked in windows socket programming MFC .
• Knowledge in Java.

MCTS

Microsoft Office SharePoint Server 2007 Application Development

TOGAF

• Trainings
• The Open Group Architecture Framework
• BizTalk2004 Training organized by Microsoft Inc.
• BizTalk Adapters Training Oracle Apps, Siebel, PeopleSoft, JdEdwards organized by iWay software.
• BizTalk2004 Training organized by Satyam Computers.
• Design Patterns UML organized by Satyam Computers.
• .NET Training organized by Satyam Computers.
• QMS Training organized by Satyam Computers.
• Advanced SharePoint Server 2007 training by Riverhead Training Inc.
• Six Sigma Green Belt training by Direct Energy
• SSAS training by Direct Energy

Technical Skills

• Hardware : IBM PC's
• Operating Systems : Windows Server2003, Windows 98, NT, 2000 and
• XP, Linux7.0
• Languages : C , VC 6.0, Visual C .NET, Visual C .NET
• Databases : Oracle, DB2, Lotus Notes, SQL Server2000
• Case Tools : Visio2000, TogetherJ5.5
• Web Related : HTML, XML, ASP .NET
• Tools Utilities : Bounds Checker, True Coverage, True Time,
• PCAnyWhere, Rouge Wave DBTools, SQL
• Navigator, Crystal Reports9.0, ETCM E-Business
• Servers Test Case Management System

Professional Experience:

CONFIDENTIAL

EDI and JDE Enterprise One integration:

CONFIDENTIAL

Supply Chain decided to replace their existing GenTran system with

CONFIDENTIAL

server 2009 and the management decided to automate the whole process with JDE enterprise system. The part of the solution is to setup ESB 2.0 management portal and utilizing the unified error handling system for the integration platform. Further, the integration solution involves utilizing F57 and F47 EDI tables within JDE by using custom UBE and business functions. Below are the technological artifacts involved in this project.

1. WCF services
2. SQL Server 2008
3. LINQ-TO-SQL
4. ASP .NET 3.5
5. BizTalk Server 2009
6. ESB Portal 2.0
7. JDE Enterprise One and UBE
8. GenTran
9. Trading Partner Communication through AS2 and VAN
10. Encryption and Signing
11. SharePoint Server 2007 intranet development
12. SharePoint 2007 Business Data Catalog
13. EDI 940, 943, 944, 945, 810, 850 and 204

Solution design and development of integration artifacts.

Environment:

Visual Studio .NET 2008, ERWin Data Modeler r7.3, SQL Server 2008, BizTalk Server 2009, ESB 2.0, Visual Studio Team Foundation Server 2008.

CONFIDENTIAL

Business Intelligence BizTalk Server 2009 implementation:

• As Direct Energy has different business units and it uses huge amount of data for any business decisions, the executive team has decided to initiate the data warehousing activities to get better visibility to the management. As a result, it is decided to create a data warehouse and data marts for DE business. Further, it is been decided to develop multi dimensional cubes and dash boards for management reports and any business related reports. We have just started this initiative this month and we are working with external BI Architects.
• In addition to these BI initiatives, we are planning to improve our SOA architecture and governance with the latest release of BizTalk Server 2009 ESB 2.0 tool kit by providing loosely coupled services and unified reporting environment. Further, we are moving with the new BizTalk EDI adapter to handle high volumes of files coming through external utilities.

Role:

Overseeing developers, design and development of data warehouse, data marts, ETL, Multidimensional Cubes, reports and performance point server dashboards. Creating architecture vision, design and development of SOA applications using ESB 2.0, BAM, WCF and the new EDI enhanced support by BizTalk Server 2009.

Environment:

Visual Studio .NET 2008, Windows XP, ERWin Data Modeler r7.3, SQL Server 2008, BizTalk Server 2009, ESB 2.0, Visual Studio Team Foundation Server 2008, Performance Point server 2007.

Technical Lead / Client

CONFIDENTIAL

• Gas Tools Integration and BizTalk data center migration:
• Direct energy enrollment information is being saved into Infinity database and the business team is moving this information into the Billing system named Nirvana manually. As the manual process of moving the data is tedious and error prone all the time, the executive team decided to automate the whole process.
• The Nirvana system is a third party one and it is unclear to anyone in DE business. However, we are able to successfully automate the complete workflow successfully by overcoming all the unknown challenges that we faced.
• Further, it was decided to destroy the old BizTalk Dev, QA and PROD environments in Pittsburgh office and re-created all these three environments in the Toronto office due to the management decision. All new BizTalk server environments were created and moved into Toronto successfully.

Role:

Overseeing developers, Requirement analysis, design and development.

Responsibilities:

• a Requirement analysis and design.
• b Preparing design documents/proto types.
• c Worked with the SSIS package for the automation.
• d Worked with the SSRS reports to give visibility to the users.
• d Worked on the Infinity web UI which is developed by using ASP .NET 3.5.
• e Design and development of ASP .NET 3.5 web application named InfinityUI .
• This is a replacement of the old Infinity UI.

Environment : Visual Studio .NET 2008, C .NET, ASP .NET 3.5, Windows XP, SQL Server 2005, BizTalk Server 2006 R2, Visual Studio Team Foundation Server 2008

4. BizTalk/.NET/SharePoint Technical Lead and Architect / Client: Direct Energy, Pittsburgh/ Jan 2007 to Feb 2009

Strategic Energy receives energy related information from different Utility companies. The data will be received in different file formats through emails or web sites. This project involves converting these external data into the 867 flat file types which provides input for ERM/HEDGE tools which are billing and pricing components for the company and routing these files into different internal systems. This process involves BizTalk Server, ASP .NET 2.0 Web Sites and Web Services.

Role:

Played Architect and Tech Lead roles.

Responsibilities:

a Requirement analysis and design.

b Preparing design documents/proto types using new current and new

technologies.

c Multi Server BizTalk Implementation.

d Dual Server TFS installation and customization of the process.

d Company wide BizTalk training and mentoring the team members.

e Created core message based design for Strategic Energy

f Define standards for SQL Server development.

g Define standards for SSIS development

h Define standards for BizTalk Server development.

i Work with Enterprise Architecture team

j Worked with BizTalk Rules Engine

k Worked with flat file schemas and EDI schemas.

l Worked extensively with Excel FarPoint component.

m Used SSO.

n Worked on SharePoint site design and implementation. It includes custom

webpart development. We are currently focusing on enterprise content

management, workflows and team collaboration with SharePoint Server 2007.

o Worked with SQL, SMTP and SOAP adapters.

p Define standards for ASP .NET development.

q Define standards for SSRS development.

r Created BAM reports

s Assigning tasks to the team members

t Working with Business Analysts and Business Users

u Recruiting team members when necessary

v ASP .NET Web Applications design and development.

w ProsPectUpload and HedgeDirect WCF Service design.

x Design application for any new development.

y Preparing templates for deployment document, release document, high level

and low level design documents.

z Working on TFS 2005 2008 to analyze the benefits of implementing Agile for

MSF.

Environment : Visual Studio .NET 2005, C .NET, ASP .NET 2.0, BizTalk Server 2006 R2, Windows XP, SQL Server 2005, ASP .NET 3.0, Visual Studio Team Foundation Server 2005

5. Sr. BizTalk Developer / Client

CONFIDENTIAL

OutSourcer Interface:

Litton, one of the major clients of ServiceLink wanted to outsource their loans from their system to ServiceLink through internet. This Outsourcer interface is running in both ServiceLink and Litton and executes loan processing. This is a B2B application.

Role:

Requirement Analysis, Design and Development.

Responsibilities:

a Involved in design.

c Created Orchestrations.

d Used SSO.

e Used dynamic ports

f Used un-typed messages.

e Worked with BizTalk Maps.

f Worked with SQL, SMTP and SOAP adapters.

g Worked with message envelopes.

h Working with dynamic maps.

i Used exception handlers in Orchestrations.

j Created MSI installation packages.

Environment : Visual Studio .NET 2005, C .NET, BizTalk Server 2006, Windows XP, SQL Server 2005

6. Sr. BizTalk developer / Client:

CONFIDENTIAL

TitleDecisionManager:

CONFIDENTIAL

needed to make a call to a decision engine which is a third party web service. This would enable them to calculate the loan amount for applicants. Since this third party web service is not reliable, they wanted to implement a reliable system for their internal web applications. This application therefore provided a reliable system and exposes its functionality as a web service.

Role:

Requirement Analysis, Design and development.

Responsibilities:

a Preparing design documents.

b Configured BizTalk Server 2004 and BizTalk Server 2006.

c Creating Orchestrations.

d Using SSO.

f Working with SQL, MSMQ and SOAP adapters.

g Created new host and host instances.

h Invoking Web Services from Orchestration.

i Making Orchestration as Web Services.

m Using correlation sets.

n Dynamic ports.

o Used exception handlers in Orchestrations.

p Created MSI installation package.

Environment : Visual Studio .NET 2005, C .NET, BizTalk Server 2006, Windows XP, SQL Server 2005, SQL Server 2000

7. Sr. BizTalk Consultant/ Client

CONFIDENTIAL

BizTalk Adapters:

acquired BizTalk adapters for diverse applications from iWay Softwre. These adapters are used to communicate with People Soft, Siebel, JdEdwards, Oracle and etc. The scope of this project is to test all the iWay adapters with BizTalk Server2004, BizTalk Server2006 Beta2 and Visual Studio 2005.

Role:

Team Member.

Responsibilities:

a Installed and Configured BizTalk Server 2004 and BizTalk Server 2006

Beta

b Creating Orchestrations to insert, query, update and delete data for the

adapters Oracle Application Suite, Oracle Database and Siebel.

c Created affiliate applications and used SSO for the following adapters,

Siebel, Oracle e-business suite and Oracle database.

d Used atomic transactions for Oracle adapters.

e Used the folloing Business Components in Sales Module for Siebel

adapter,

HouseHolds, ServiceRequest, Asset, Agreement, Events, Opportunity,

Partner, Product, Quote, Revenue, Account, Action, Contact, Employee,

Resource Request, Comm Package, Comm Request, Cycle Counting,

Account Private Note, Account Note, Addresses, Messaging UI,

Customer Survey, Activity Plan

f Worked with Oracle adapters in Send side as well as receive side.

g Invoking Web Services from Orchestration.

h Making an Orchestration as a web service.

i Tibco Enterprise Message service adapter,

JDE One World adapter, Siebel Adapter, Oracle e-business suite adapter,

And Oracle database adapter. All these adapters are being shipped with

BizTalk Server 2006

• Environment : Visual Studio .NET 2005, People Soft, Siebel, JdEdwards,
• Tibco Enterprise Message Service, Tibco Rendezvous,
• BizTalk Server2004, BizTalk Server 2006 Beta2, Windows
• Server 2003, Windows XP, Oracle 9i, SQL Server 2005,
• SQL Server 2000

8. Team Lead/ Client

CONFIDENTIAL

Customer sells marine engines to the ship owners. The initial target market was small pleasure boats. Along with the engines, a display product Navigator was also sold to the users, which was used to view information about the engine parameters like speed. As this market was not lucrative in terms of business volumes, Customer targeted the bigger ships. This necessitated that the display product incorporate more features. Also, the bigger ships typically had PCs in their ship network. This mandated that the display software used in display products like Navigator be made available on the PC in addition to the traditional Navigator product.

Role:

Team Leader.

Responsibilities:

i Design and applying design patterns for the module that I handled.

ii Preparing prototype.

iii Assigning tasks to the members involved in the module.

iv Worked with COM Component through .NET RCW

v Coding

vi Testing

vii In charge for all the activities in version control software Visual Source Safe for this project.

viii Used BizTalk maps.

Environment : BizTalk2004, Visual C .NET, Embedded XP XPe SP2,

Windows XP, Windows2000, EDB

9. Team Lead/ Client

CONFIDENTIAL

The Maintenance Strategy Reference MSR is used as a planning / strategy template for maintenance and repair events. It is designed to provide a way for the dealer and the customer to jointly define and document how equipment will be maintained at a particular jobsite. The MSR encompasses maintenance and repair activities and management processes up to and including component level maintenance. The component level plans, when taken in the aggregate, become the overall site or project maintenance plan. The outcome of the planning process is recorded in a reference document for use by all parties involved in the management of a specific fleet, at a specific site.

Role:

Team Leader

Responsibilities:

i Design and applying design patterns for the application.

ii Preparing prototype.

iii Worked extensively with data grid and ADO .NET.

iv Assigning tasks to the members involved in the module.

v Coding

vi Testing

vii In charge for all the activities in version control software Visual Source Safe for this project.

viii Used BizTalk Orchestrations and maps.

Environment : BizTalk2004, Visual C .NET, Windows XP, Windows2000,

MSDE2000

10. Sr. Software Engineer/ Client

CONFIDENTIAL

• PSPS Migration from Visual Studio 6.0 to Visual Studio 7.0:
• PSPS Factory Client is a standalone Win32 application used to flash and configure Electronic Control Modules ECMs , and is developed by Product Software Programming System PSPS group of Cat Electronics IS. The current version of PSPS Factory client is version 4.3 and it consist of various modules written in C, C , VB under Visual Studio 6.0 and is using Win32 SDK, MFC and COM-DCOM. These modules have to be migrated to Visual Studio 7.0 .Net platform, so that client can use the migrated modules for new PSPS version 4.4.

Role:

Team Member

Responsibilities:

• Find out the obsolete MFC API's and COM API's and replace them with the new one. And build all the 23 modules and send it to the QA team.

Environment : Visual Studio 6.0, Visual Studio 7.0,

Windows XP, Windows2000, VC

Sr. Software Engineer

CONFIDENTIAL

• The Corporate Security Asset Maintenance Tracking System SAMS is a management tool designed to document the inspection requirements for a variety of fire and safety equipment. Equipment may include fire extinguishers, smoke alarms, sprinkler risers, fire doors, etc. The following inspection intervals are supported:
• Hourly, Daily, Weekly, Monthly, Quarterly, Semi-Annual, Annual, Recharge, 6-Year, Hydro, User Defined 1, User Defined 2, User Defined 3.
• SAMS is designed to meet the record keeping requirements as specified in NFPA and OSHA for all Fire Detection and Suppression Systems.

Requirement:

Caterpillar needs to delete the records from the Activity table. They need to add an additional option in SAMS application's main menu to do the above requirement. This option should be enabled only for the Admin users. Further SAMS should be updated with the .hlp file and the language resource file SAMSENGLISH.DLL. The help file should be created/updated with the Windows Help File System. And the installer should be created with the updated .exe, .hlp and the samsenglish.dll.

Role:

Team Member

Responsibilities:

• Design and Development
• Testing - unit testing integration testing

Environment : Visual Studio 6.0, SQL Server 2000, Query Analyzer,

Windows XP, Windows2000

Sr. Software Engineer

CONFIDENTIAL

Component Based Trouble Shooting:

The objective of the STW - Component Based Troubleshooting - 2004A project is to integrate the CBT application with STW and provide run-time integration with SIS Convergence and ET modules through CBT OLE Server. This module integrates the CBT static HTML files with STW Active Document Container application.

Role:

Team Leader

Responsibilities:

• Design and Development
• Testing - unit testing integration testing

Environment : VC , Visual Studio 6.0,

Windows XP, Windows2000

13. Software Engineer/ Client

CONFIDENTIAL

EMCast :

CONFIDENTIAL is used to send thousands of customized emails within a short period. This is a multithreaded application. Each thread accounts for a mail server. We can send targeted mails also. In addition, we can send attachments along with the emails using this application. We can use this tool to send AOL messages to the AOL account holders if the AOL flag is set.

Role:

Team Member

Responsibilities:

• As a team member, was responsible for
• Development
• Testing - unit testing integration testing

Environment : VC , Visual Studio 6.0,

Windows XP, Windows2000

Software Engineer

CONFIDENTIAL

EMRemove

The inbound mails to

CONFIDENTIAL setup might include request to removal from their mailing list. To facilitate American Express's outbound campaign EchoMail needs to gather these Un-Subscribe request from its database and sent to Amex. EMRemove is an automated tool which does the process of getting the requests and put into Amex FTP server and this tool is running as a Windows NT Service.

Role:

Team Member

Responsibilities:

• Development
• Testing - unit testing

Environment : VC , Visual Studio 6.0, Bounds Checker, SQL

• Navigator, Windows NT sp6 , Windows2000,
• Oracle

Software Engineer/ Client:

CONFIDENTIAL

EMFtpToDB

A desktop tool, which is used to retrieve non-EMSF format files from the FTP server and converts all those files into EMSF format files. It pumps all the data to the Oracle standard schema.

Role:

Team Member

Responsibilities:

• As a team member, was responsible for
• Development
• Testing - unit testing

Environment : VC , Visual Studio 6.0, Bounds Checker,

SQL Navigator, Windows XP, Windows2000,

Oracle

Software Engineer

CONFIDENTIAL

EMXtract DB2 Incorporation:

Incorporate the code for DB2 and adding the facility to support the Windows2000 OS. This

application runs as a task bar icon.

Role:

Team Member

Responsibilities:

• Development
• Testing - unit testing integration testing

Environment : VC , Visual Studio 6.0, Lotus Notes SDK,

• Bounds Checker, SQL Navigator,
• Windows NT sp6 , Windows2000,
• DB2, Oracle, Lotus Notes

Software Engineer/ Client:

CONFIDENTIAL is a tool, which simulates the Notes pump LEI. It is used to pump records from Lotus Notes Database into Oracle Database. It can also be set to do the pumping in equal intervals.

Role:

Team Member

Responsibilities:

• Development
• Testing - unit testing

Environment : VC , Visual Studio 6.0, Lotus Notes SDK,

• SQL Navigator, Windows NT sp6 , Windows2000,
• Oracle, Lotus Notes

Software Engineer/ Client:

CONFIDENTIAL

• A tool which is used to trigger a Lotus Notes Agent as per the configuration in the INI file
• and the UI.

Role:

Team Member

Responsibilities:

• Development
• Testing - unit testing

Environment : VC , Visual Studio 6.0, Bounds Checker,

Lotus Notes SDK, WindowsNT sp6 , Windows2000

Software Engineer/ Client:

CONFIDENTIAL

A module which is a used to validating a mail list file and create a valid mail list file according to the EMSF format.

Role:

Team Member

Responsibilities:

• Development
• Testing - unit testing

Environment : VC , Visual Studio 6.0, Bounds Checker,

SQL Navigator, WindowsNT sp6 , Windows2000,

Oracle

Software Engineer/ Client:

CONFIDENTIAL

A monitoring tool which is used to monitor all other applications running in the production environment. If any application in any of the server malfunctioning, immediately this application sends a Alert mails to the corresponding persons configured in the INI file and immediately it changes the List View image status in the UI.

Role:

Team Member

Responsibilities:

• Development
• Testing - unit testing

Environment : VC , Visual Studio 6.0, Bounds Checker, WindowsNT sp6 ,

Windows2000

Software Engineer/ Client:

CONFIDENTIAL

A mail forwarding tool which handles the bounce back mails and add two new mail headers in the header field of the mail and forwarding this to the specified address through SMTP server.

Role:

Team Member

Responsibilities:

• Development
• Testing - unit testing

Environment : VC , Visual Studio 6.0, Bounds Checker,

• SQL Navigator, WindowsNT sp6 , Windows2000,
• Oracle

Software Engineer/ Client:

CONFIDENTIAL

A desktop tool which can be used by top level management to get the graphical representation of varying Customer Attitudes real time. The three-tier architecture uses DCOM architecture to talk to the Database server and OCX Control to provide user interfaces. The graph is drawn based on the Dimension and Sub category selected.

Role:

Team Member

Responsibilities:

• Development
• Testing - unit testing Integration Testing.

Environment : VC , Visual Studio 6.0, Bounds Checker,

SQL Navigator, WindowsNT sp6 , Windows2000, Oracle

oftware Engineer/ Client:

CONFIDENTIAL

A tool which is used to retrieve mail information from Oracle database and process all the mails including attachments and push into Lotus notes database. This application will run as a taskbar icon.

Role:

Team Member

Responsibilities:

• Development
• Testing - unit testing Integration Testing.

Environment : VC , Visual Studio 6.0, Bounds Checker, Lotus Notes SDK,

SQL Navigator, WindowsNT sp6 , Oracle

Software Engineer/ Client:

CONFIDENTIAL

A tool which is used to retrieve all the mails from a mail box configured in the UI using POP3 protocol and inserts the data into the oracle table.

Role:

Team Member

Responsibilities:

• Development
• Testing - unit testing Integration Testing.

Environment : VC , Visual Studio 6.0, Bounds Checker, Lotus Notes SDK,

SQL Navigator, WindowsNT sp6 , Oracle

Software Engineer/ Client:

CONFIDENTIAL

A tool which gets the input data from Lotus Notes Database and encrypted the data using PGP SDK and write all the encrypted information in a text file in some specific formats.

Role:

Team Member

Responsibilities:

• Development.
• Testing - unit testing.

Environment : VC , Visual Studio 6.0, Bounds Checker, Lotus Notes SDK,

PGP SDK, WindowsNT sp6 .

Software Engineer/ Client

CONFIDENTIAL

A tool which is used to encrypt the field values in the Lotus Notes database.

Role:

Team Member

Responsibilities:

• Development.
• Testing - unit testing.

Environment : VC , Visual Studio 6.0, Bounds Checker, Lotus Notes SDK,

PGP SDK, WindowsNT sp6 .

Software Engineer/ Client:

CONFIDENTIAL

A tool, which gets the encrypted data from a Lotus Notes Database and decrypts the data using PGP SDK.

Role:

Team Member

Responsibilities:

• Development.
• Testing - unit testing.

Environment : VC , Visual Studio 6.0, Bounds Checker, Lotus Notes SDK,

PGP SDK, WindowsNT sp6 .

Software Engineer

CONFIDENTIAL

Every weekend Saturday campaign activity data are extracted from oracle tables and campaign activity data log files created by some other project module. In addition, based on several conditions, it creates some text files and uploads all the files to FTP server. For every process, it sends the process log the some mail id's using SMTP protocol. This tool accesses the database using OCI.

Role:

Team Member

Responsibilities:

• Development.
• Testing - unit testing.

Environment : VC , Visual Studio 6.0, Bounds Checker, WindowsNT sp6 , Oracle

Software Engineer

CONFIDENTIAL

Every Saturday the client will send a flat file, which contains email Ids, to the FTP server. CG UPLOAD tool will extract this flat file from the FTP server and store the entire mail IDs with relevant information's to the temporary Oracle table. Based on certain constraints it stores all the information to the Oracle database.

Role:

Team Member

Responsibilities:

• Development.
• Testing - unit testing.

Environment : VC , Visual Studio 6.0, Bounds Checker, WindowsNT sp6 , Oracle