SUMMARY

• 9+ years of IT experience in web, windows and Microsoft BI using C#, ASP.NET, AJAX and ADO.NET with SQL server and SSIS.
• Experienced in WPF with MVVM architect using Telerik control.
• Proficiency in ETL integration Excel/Access/Text/SQL Server applications with external API’s, Databases, web pages, to import and export data.
• 3+ years of experience in team and project management.
• Experienced in building prototype and presenting to client.
• Experienced in analysis, design and development of reports in client/server environment using Visual Studio 2010.
• Expertise in creating modules and writing complex SSIS packages in different business environments.
• Good knowledge in Microsoft Dynamic CRM.
• Experience in testing tools such as HP QC and SQUIDS (internal tool).
• Expert in handling errors, debugging, troubleshooting and validation of user data.
• Sound knowledge of reverse and forward engineering, conceptual, logical and physical model.
• Handled onsite - offshore operations by conducting knowledge transfer sessions and handshake Meetings on daily basis.
• Excellent knowledge and experience on Agile/Scrum methodology.
• Experience in working with executive management, technical architects and business end-users implementing change management and new technology deployments.
• Excellent communication, interpersonal, and project management skills to work within an aggressive and demanding project schedule and environment.
• Excellent knowledge on third party tool like Quest Analytics and Telerik control.
• Experience of working in different geographical locations (USA, India)
• 6+ year experience on Team foundation Server/TFS to maintained code base for different version control.

TECHNICAL SKILLS

Programming languages: C#, ASP.NET, HTML, CSS, XML, AJAX, JavaScript

Web Technologies: .Net Framework 2.0/3.5/4.0,ADO.Net,WCF,WebService, LINQ.

DBMS: MS SQL Server 2008/2012

Version Control Tools: VSS and Team Foundation Server (TFS)

Web Server: IIS 6.0/7.0

Operating System: Windows XP/2000/7

Hardware/Software: WPF, .Net 4.0, ASP.Net, VS 2010/2012/2015 , C# 4.0, SSIS 2008

Tools: Telerik, Dollar Universe, CRM and Quest Analytics 2014.4/2015.4.

Domain: HealthCare and Life Science.

PROFESSIONAL EXPERIENCE

Confidential, KY

Project Manager/Sr.NET TECH LEAD

Responsibilities:

• Worked as SME for HSD and playing onsite Sr. Lead /co-ordinator role.
• Handling 13 team members in agile methodology and supporting onshore -offshore model.
• Playing major role in estimation, prioritization based on dependency, peer review, demo and deployment.
• Presentation layer (GUI) application has been created using WPF web forms, C#, ASP.NET 4.0, MS Visual studio 2010.
• Used ADO.NET objects to access data from SQL Server 2008 database by using stored procedures and queries in T-SQL.
• Played major role in creating user interface using WPF with MVVM architect.
• Involved in writing queries and performance optimization of the SSIS.
• Created SQL Server Job re-run utility and provided flexibility to business partner for on demand SQL SSIS Job execution from User Interface.
• Design various data flow diagrams for different modules by using Visio.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Used $Universe tool to created dependency business flow for ETL/SSIS and API/Console jobs.
• Customize Quest Analytics API as per business need for network adequacy automation.

Environment: C# .NET, MS SQL Server 2008/2012, Visual Studio 2012,SSIS, WPF, ADO.net, IIS 5.0/6.0, Quest Analytics 2014.4/2015.4 and TFS.

Confidential, KY

.NET TECH LEAD

Responsibilities:

• Worked on replacement of 20 year old system with CRM.
• Created SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services and created job for SSIS packages.
• Involved in writing queries and performance optimization of the SSIS.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Extracted data from Oracle and migrated into SQL Server 2008 using console application.
• Integrated CRM service with difference source like agent application along with real time data processing.
• Consumed enterprise address validation service and created public and private service for CRM integration.
• Deployed SSIS packages, created job and scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager of Sales department.

Environment: C# .NET, ASP.NET, MS SQL Server 2008, Visual Studio 2012,SSIS, XML, WCF, ADO.net, IIS 5.0/6.0 and TFS.

Confidential, KY

Sr.NET TECH LEAD

Responsibilities:

• Created presentation layer (dummy plan) using asp.net and C#.
• Used ADO.NET objects to access data from SQL Server 2008 database by using stored procedures and queries in T-SQL.
• Before doing any migration, always used to take database backup.
• Created SSIS job for processing of plan related data to Pinnacle system.
• Created ETL for dummy plan and actual plan comparison.

Environment: C# .NET, ASP.NET, MS SQL Server 2008, Visual Studio 2012,SSIS, ADO.net, Ajax, IIS 5.0/6.0 and TFS.

Confidential, KY

Sr.NET Developer

Responsibilities:

• Worked on story / enhancement in current application.
• Presentation layer (GUI) application has been created using web forms, C#, ASP.NET 2.0, MS Visual studio 2008
• Used ADO.NET objects to access data from SQL Server 2000 database by using stored procedures and queries in T-SQL.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Application migration from lower to higher environment.
• Production deployment support. Production incident review and fixes.

Environment: C# .NET, ASP.NET, MS SQL Server 2008, Visual Studio 2008,, ASP.net, ADO.net, Ajax, IIS 5.0/6.0,VSS.

Confidential

Sr. .NET DEVELOPER

Responsibilities:

• Created user interface using C#, ASP.NET.
• Responsible for creation, maintenance and support of .Net Application.
• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Prepared Data Flow Diagrams and Functional design document for database design.
• Created master templates.
• Gathered requirements from clients and business analysts for end user applications.
• Analyze business requirement.
• Unit testing and Integration testing for various modules.
• Followed SDLC procedure throughout the modules and reports development.
• Involved in documentation of the future enhancements.
• Performed unit testing and uploaded the enhancements into SharePoint server.
• Designed, defined and documented workflow diagrams and processes.

Environment: C# .NET, ASP.NET, MS SQL Server 2008, ASP.net, Visual Studio 2008, ADO.net, Ajax, IIS 5.0/6.0, TFS.

Confidential

.NET DEVELOPER

Responsibilities:

• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Created master templates, website, modules using toolkit.
• Unit testing and Integration testing for various modules.
• Followed SDLC procedure throughout the modules and reports development.
• Involved in documentation of the future enhancements.

Environment: C# .NET, MS SQL Server 2008, Visual Studio 2012, ADO.net, Ajax, IIS 5.0/6.0,VSS and Confidential toolkit.