SUMMARY:

• Around 15+ years of experience in design, architecture, development, integration and maintenance of various applications, business and process automation.
• High - performing architect/Lead developer with expertise in Design and Architecture Patterns, Integration, UML, WCF/WWF, ASP.NET/MVC/C#/VB.NET, BizTalk Server 2004/2006/2009/10/13 , HL7/SWIFT accelerator, EDI/AS2, SQL Server 2000/2005/08/ 12/14 , ETL, SSIS/SSRS/SSAS, SOA, SOAP/REST, Web Services, Web Service Factory and XML/XSLT.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server. Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS and creating SQL server reports using SSRS.
• Expert in monitoring SQL Server Performance using SQL Profiler, Query Analyzer, SQL Server Best Practice Analyzer, Index Tuning Wizard, and Windows Performance Monitor
• Expert in BizTalk performance tuning, monitoring and administration.
• Experience of telecommuting.

TECHNICAL SKILLS:

Domain Expertise: Banking & finance, Brokerage, Retail, Insurance, Healthcare, Utility and Logistic.

Database Management: SQL Server 2000/2005/08/ R2/12/14, Sybase ASE and Oracle 10g/11g.

Web Technologies: ASP.NET 3.5/4.0, ASP.NET MVC, JSON, XML/XSLT, IIS 6.0/7.0/8.0

Middleware: Web Services/WCF/WWF, Web Service Factory, SOAP, COM+, MSMQ, SOA, BizTalk 06/09/10/13, EDIFEC, HL7/EDI Accelerator, Tibco Foresight, webMethods 7.1.3 and IBM Websphere & Cast Iron.

Tools: & Technologies: VS .net 2010/12/13, TFS 2010/12, Cruise Control, Fxcop/BizCop, SQL profiler, Reflector and ILSpy.

BizTalk Tool: .BizTalk Server Best Practices Analyzer/MessageBox Viewer, Performance Analysis of Logs (PAL),Windows performance monitor (PERFMON),Processor Explorer and Monitor, Fiddler & SOAP UI, XML & EDI NotePad and BizUnit & LoadGen

PROFESSIONAL EXPERIENCE:

Architect/Lead Developer - Consultant

Confidential, Alpharetta

Responsibilities:

• Architecture assessment of BizTalk 2009/10/.NET/EDI (867, 814, 810, 820, and 824) based ISTANet billing system.
• Developed payment process using BizTalk integration with SAP.
• Resolved BizTalk prod Performance issues using BizTalk Analyzer (BBPA), Orchestration profiler, MessageBoxViewer, Performance analyzer tool (PAT) and Perfmon.
• Developed .NET custom pipeline components and custom XSLT for BizTalk application.
• Developed complex process using BizTalk Orchestrations and maps.
• Lead operation team to ensure BizTalk apps are up and running.
• Proficient with SQL server agent for scheduling BizTalk jobs, SQL profiler for database tuning
• Created complex Stored Procedures, SSIS packages, triggers, functions, tables, views and other T-SQL inline statements for applications.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Developed BizTalk exception handling using ESB and BAM toolkit.
• Migration from BizTalk server .

BizTalk & EDI - Consultant

Confidential, Tampa, FL

Responsibilities:

• Lead and manage a team of application architect and Web developers, overseeing their work, and ensuring that they build high quality applications.
• Setup and configure BizTalk 2010 on multi server environments.
• Developed BizTalk POC to process different EDI files (837/835/834).
• Developed roadmap for new development due to change in architecture.
• Drafted BizTalk and Web applications architecture document.
• Developed BizTalk monitor tool to track BizTalk PROD artifacts.
• Designed and developed ESB based BizTalk exception BAM.
• Setup development and QA team for development and testing.
• Provided technical leadership on troubleshooting and resolution of issues.

Integration Consultant

Confidential

Responsibilities:

• Interacted with senior management to understand the business needs, created design docs, prepared detailed project plans and assigned work modules to the development resources.
• Designed BizTalk based Lab integration system to connect with multiple lab vendors and handled different file formats by BTS canonical design pattern.
• Devised BizTalk base bus architecture to process different EDI files (837/835/834) and developed proof of concept (POC) for the same.
• Designed and developed pipeline .NET components (Archive, BAM etc) of the BizTalk.
• Enhanced performance of applications by implementing best practices and using .NET (FxCop, ReSharper, Reflector, ProcessMonitor, NUnit etc ), SQL (SQL server profile, DBCC, IO meter etc)and BizTalk (Biztalk Best practice Analyzer (BBPA), BBW, BizCop, BizUnit, LoadGen etc) tools.
• Streamlined development process by inducing JIRA to track progress of tasks and better project & team management.
• Designed and developed application database code objects, such as stored procedures, functions, views and T-SQL inline statements.
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2008.
• Developed BAM reports using SQL Severe reporting services (SSRS).

Architect/Lead - Consultant

Confidential

Responsibilities:

• Lead and manage a team of application and integration engineers, overseeing their work, and ensuring that they build high quality applications.
• Devised loosely coupled n-tier and SOA architecture.
• Developed BizTalk process & services, maps & XSLT and custom pipeline components.
• Created BAM for transaction reporting.
• Recommended best practices and guidelines for performance improvement.
• Devised the architecture of the applications & work flow and developed several complex components.
• Involved in database development using stored procedures, triggers, views and cursors.
• Used SSIS in importing data from XML files into SQL DB
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval
• Monitored the performance and optimized SQL queries for maximum efficiency.
• Crated transaction reports using SSRS.

Confidential, CA

Responsibilities:

• Lead and manage a team of application and integration BizTalk developers.
• Worked with BA and Team to understand function requirements (FRD) and process flow.
• Developed BizTalk processes (Orchestration), maps and custom pipeline components Consumed and expose Web service through Orchestration.
• Devised the architecture of the applications & work flow and developed several complex components.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval

Consultant

Confidential

Responsibilities:

• I designed and developed Confidential Business Solution (MBS) for Confidential . MBS was developed using ASP. NET, C#, .NET SDK, MSMQ, BizTalk Server 2004, Web Services and SQL Server 2K. MBS integrated Confidential CRM and Great Plains using BizTalk 2004. Fixed BizTalk performance issue at customer site. Coordinated with customer and assigned tasks to various team members.

Lead/Sr. Consultant/Sr. Developer/Developer

Confidential

Responsibilities:

• Worked as a Software Developer/Consultant/Lead participated in various IT projects in India. Designed and developed Desktop, client-server and Web-based applications using ASP. NET, WINFORM, C#, VB.NET, VC++, com+, Web Services and SQL Server 2K.

Confidential

Responsibilities:

• The application consist three components. MAIL component fetch mail’s attachments from mail server using POP3. Document Parser parses the word document that is fetched by Mail component using Word com component.
• Web component designed as a three-tier model comprising of Presentation Layer, Business Logic Layer and Data Layer.
• Integrated Offender Management System:

Confidential

Responsibilities:

• The application is designed as a three-tier model comprising of Presentation Layer, Business Logic Layer and Data Layer. Presentation Layer interacts to Business Logic Layer through Web Services.
• Merchandise Management System:

Confidential

Responsibilities:

• The Merchandise Management system was a web-based system that provides a platform for managing procurement of products from vendors and managing inventory.
• PC Transplant Solution:

Confidential

Responsibilities:

• PC Transplant Solution is essentially used to perform mass migrations of Windows machines. It is a web module that enhances the network management capabilities of Confidential eXpress Server.
• Placement Software system.
• B2C Portal-Online Shopping