Development Project .Net Management Sql Server

SUMMARY

*.* years of experience as a BizTalk and .Net Consultant. Also, Having

experience of designing and developing EAI, B2B systems using SOA.

Specialized in implementing BizTalk Server as an ESB. Experience

integrating SQL Server, Oracle Financial, Oracle Gemms, SAP, Microsoft

Dynamics AX, Dynamic CRM, BPCS, AS400, DB2, Sharepoint, Host Apps using WCF

Lob adapters.

Key Skills

C#, VB.NET, SQL Server 2000/2005/2008R2, WFC, WWF, Crystal Report, BizTalk

10/09/R2/06/04, MOSS, Share Point, RFID, MTOM, ESB Tool Kit 2.0, Itinerary,

WCF LOB Adapter, PL/SQL, ESB Portal, MTOM, .NET 1.0/2.0/3.0/3.5/4.0, SOAP,

BRE, Web Services, Orchestration, Maps, Document and Envelope Schema, BTS

Assembly, XSLT, XML, XPath, EDI, Cloud computing, SAP, Oracle Financial,

MDM, MDS

Key Expertise

- Better requirement analysis and estimation

- Effective client communication

- Effective troubleshoot and analytical skill

Professional Experience Summary

Sierra Atlantic (Hyd)

Continuing from Jan, 2010 as Consultant and giving contribution in EAI

integration.

1. Project (Data Bus), Client (Revlon, US), March 2010-Februaru-2011,

Team Size 20 (onsite + offshore)

Roles and responsibilities - Design, development, unit test and

deployment, documentation, training and implementation.

Description - Revlon has legacy systems developed using older version

of oracle, etc. Revlon initiated a data bus project to pull data from

all legacy systems and push to Microsoft Dynamic AX CRM. Major

challenge identified and solution developed across WCF LOB adapter,

ESB Tool kit 2.0 and Itinerary development.

Tool and technologies - BTS 2009, VS 2008, SQL 2008 and ESB Tool Kit

2.0, WCF LOB adapter, DB2 and HostApps adapter. Document and Envelope

Schema, BTS Assembly, XSLT, XML, XPath, .NET Framework 3.5/4.0, BRE,

Web Services, Dynamics AX, SAP adapters.

2. Project (N2X Integration), Client (Ixia, US), January 2010-March-2010,

Team Size 16 (onsite + offshore)

Roles and responsibilities - Design, development, unit test,

documentation, training and implementation.

Description - Ixia has initiated a project to integrate archive data

from various legacy systems to SQL server database using SSIS/DTS.

Tool and technologies - SSIS/DTS, SQL Server.

Patni Computers (Hyd)

Continued from Nov, 2008 to January, 2010 as Software Specialist and given

contribution in EAI integration.

3. Project (Alaska Communication Systems), Client (ACS, US), March Nov

2008-Oct-2009, Team Size 40 (onsite + offshore)

Roles and responsibilities - Design, development, unit test,

documentation, training and implementation.

Issues and Challenges - ACS has legacy systems developed using .NET,

Java, C++, AS400, Cobol technologies. ACS kicked off a Siebel

Integration project to pull data from all legacy systems and push to

Oracle Siebel 8.0. Major challenge identified and solution developed

across AS400 integration, BizTalk application deployment across

multiple servers using cluster base approach.

Tool and technologies - BTS 2006 R2, VS 2005, SQL 2005, BTS Assembly,

XSLT, XML, XPath, .NET Framework 3.5, BRE, Web Services.

4. Project (Bench), NA, Nov 2009-Jan-2010

Cincom Computers (NCR-Gurgaon)

Continued from Aug, 2006 to Oct, 2008 as Member Technical Staff and given

contribution in EAI specific product development.

5. Product (Environ 1900), Client (Cincom Systems ), April 2008-Oct-2008,

Team Size 48 (onsite + offshore)

Roles and responsibilities - Design, development, unit test,

documentation, training and implementation.

Description - An EAI product to integrate ERP and other legacy

software with help of BTS 2006.

Tool and technologies - VS 2005, VS 2008, C#, VB.NET, SQL Server 2005,

BTS 2006, R2, Web Services, WCF, WWF, Visual Basic 6.0, COM, ASP. NET.

MOSS, ASP, using Framework 2.0, 3.0 and 3.5

6. Product (Environ 1800), Client (Cincom Systems ), September 2007-March-

2008, Team Size 48 (onsite + offshore)

Roles and responsibilities - Design, development, unit test,

documentation, training and implementation.

Description - An EAI product to integrate ERP and other legacy

software with help of BTS 2006.

Tool and technologies - VS 2005, VS 2008, C#, VB.NET, SQL Server 2005,

BTS 2006, R2, Web Services, WCF, WWF, Visual Basic 6.0, COM, ASP. NET.

ASP, using Framework 2.0, 3.0 and 3.5

7. Product (Environ 1611), Client (Cincom Systems ), February 2007-August-

2007, Team Size 40 (onsite + offshore)

Roles and responsibilities - Design, development, unit test,

documentation, training and implementation.

Description - An EAI product to integrate ERP and other legacy

software with help of BTS 2006.

Tool and technologies - VS 2005, C#, VB.NET, SQL Server 2005, BTS

2004, Visual Basic 6.0, COM, ASP, Framework 2.0.

8. Product (Environ 1610), Client (Cincom Systems ), August 2006-January-

2007, Team Size 40 (onsite + offshore)

Roles and responsibilities - Design, development, unit test,

documentation, training and implementation.

Description - An EAI product to integrate ERP and other legacy

software with help of BTS 2006.

Tool and technologies - BTS 2004, VS IDE 2003, C#, VB.NET, SQL Server

2000, Web Services, Visual Basic 6.0, COM, ASP, Framework 1.1

NextGeneSolutions (Delhi)

Continued from June, 2005 to July, 2006 as Software Engineer/Lead and given

contribution in ERP/CRM development.

9. Project (Cath Reporting System (CRP)), Client (Max Healthcare (Saket),

March 2006-July-2006, Team Size 8

Roles and responsibilities - Design, development, unit test,

documentation, training and implementation.

Description - CRS is an ERP which has 24 cardiology modules. Like for

(1) Angiography (7 modules), (2) Angioplasty (4 modules), (3)

Pacemaker (4 modules), EPS (5 modules) and ICD (4 modules). Also CRS

got integrated PACS and Max HMS.

Tool and technologies - C#, VB.NET, SQL Server 2000, integrated .NET

Crystal Reports

10. Product (Open Source Dental), NA, June 2005-February-2006, Team Size 5

Roles and responsibilities - Design, development, unit test,

documentation, training and implementation.

Description - Open Source Dental is clinic management software for

Patient Registration, patient family management, appointment /

scheduling, claims / insurance, treatment chart, clinical chart

management, and images / document management, multiple tariff

management.

Tool and technologies - C#, VB.NET, MySql 4.0, reporting services

Akhil Systems (Delhi)

Continued from January, 2004 to May, 2005 as Software Engineer and given

contribution in Healthcare ERP development.

11. Project (Hospital Management Systems), Client (Apollo Hospital,

Dhaka), March 2005-June-2005, Team Size 20

Roles and responsibilities - Design, development, unit test,

documentation, training and implementation.

Description - The client has a legacy system for its payroll

department. The details of the legacy systems need to be automated

with our project. Earlier all the manual work was time consuming and

not cost effective. With the introduction and use of BizTalk server we

had automated the process. A utility has been developed to get the

data from the legacy system (DOS based application) in XML format and

with the help of BizTalk schema editor, mapper and multiple in-build

functoid we were able to get the required format in new application.

Tool and technologies - BizTalk Server 2004, C#, SQL Server 2000,

Integrated .NET Crystal Reports

12. Project (Hospital Management Systems), Client (Apollo Hospital,

Dhaka), January 2005-Feb-2005, Team Size 20

Roles and responsibilities - Design, development, unit test,

documentation, training and implementation.

Description - Customization, implementation and training of Facility

Management, OPD/IPD, HMS modules.

Other hospitals where implementation and training given are Moolchand

Hospitals (Delhi), Rajeev Gandhi Cancer Institute (Delhi), Narendra

Mohan Hospitals (Ghaziabad), Yashoda Hospital (Ghaziabad)

Tool and technologies - VB.NET, VB 6.0, ActiveX Controls, SQL Server

2000, Integrated .NET Crystal Reports, Crystal Reports

13. Project (Hospital Management Systems), Client (Apollo Hospital,

Dhaka), August 2004-Dec-2004, Team Size 20

Roles and responsibilities - Design, development, unit test,

documentation, training and implementation.

Description - Customization, implementation and training of

Diagnostics/ Radiology, OT, Ward, Blood Bank HMS modules.

Other hospitals where implementation and training given are Moolchand

Hospital (Delhi), Balaji Hospitals (Delhi), Maharaja Agrasen Hospital

(Delhi), Narendra Mohan Hospital (Ghaziabad), Yashoda Hospital

(Ghazaibad).

Tool and technologies - VB.NET, VB 6.0, ActiveX Controls, SQL Server

2000, Integrated .NET Crystal Reports, Crystal Reports

14. Project (Hospital Management Systems), Client (Apollo Hospital,

Dhaka), January 2004-July-2004, Team Size 20

Roles and responsibilities - Design, development, unit test,

documentation, training and implementation.

Description -Inventory module customization for preparation of

indents, issues to patients, purchase order, GRN, updating daily stock

positions, stock adjustments, MIS, etc. Other hospitals where the same

feature implementated and training given are Ragiv Gandhi Cancer

Institute (Delhi), Moolchand Hospital (Delhi), Balaji Hospitals

(Delhi), Maharaja Agrasen Hospital (Delhi), Vinayak Hospital (Delhi),

Escorts Hospital (Faridabad), Narendra Mohan Hospital (Ghaziabad),

Yashoda Hospital (Ghaziabad).

Tool and technologies - VB.NET, VB 6.0, ActiveX Controls, SQL Server

2000, Integrated .NET Crystal Reports, Crystal Reports

Educational/ Professional Qualifications

Qualification University/Boa Enrollment Completion Grade % F/P/C

rd year year

X Allahabad 1988 1990 55.00% F

Board

XII Allahabad 1992 1994 60.00% F

Board

MDST IEC Software 1996 1998 F

Ltd. (Delhi)

BCA IGNOU, Delhi 1999 2003 60.00% P

Training Amity, Delhi 2004 2004 F

(Mgmt)

French BVV, Delhi 2005 2005 P

Learning

ADCA IGNOU, Delhi 2004 2005 60.17% P

MCA IGNOU, Delhi 2006 2006 60.00% P

Passport

details

Passport Issue Valid Till Place of

Number Date Issue

F2921307 15/04/2 14/04/2015 Delhi

005

Visa B1/B2 till 2020

Personal

Information

DOB 06/07/1975

Father Name Shri

Tarkeshwar

Mishra

Known Hindi,

languages English,

French

Visa B1 - Expired

in 2020

Visited US

country

Mobile 960-***-****

E-mail sushil_india20

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

State Hyderbad

Contact this candidate