SUMMARY

• 14 + years of assorted expertise in Software Development Life Cycle (SDLC) involving Design, Development, Integration, Implementation and Testing of applications in Client/Server, N - tier Architecture based on Microsoft .NET technologies and SQL Server.
• Technical expertise in Microsoft Technologies like .Net Framework ( 4.7.2/4.6/4.5 ), ASP.NET, Win Forms, MVC4.0, C# 4.0/3.0,2.0 WCF, Web services, LINQ, ADO.Net, JQuery, AJAX, JavaScript and Microsoft SQL Server 2019/2017/2016/2014
• Experience in creating rich user interface web application using HTML 5.0, DHTML, CSS 3.0, Bootstrap, XML, Master Pages, Themes, Ajax, JavaScript, jQuery, ASP.Net User/Custom Control and ASP.Net Server controls
• Very well acquainted wif teh concepts like inheritance, polymorphism, abstraction, encapsulation and interfaces, has used them wherever Object Oriented Programming System (OOPS) is needed
• Expertise in creating, consuming Windows Communication Foundation (WCF), XML Web services, Restful Web Services, ASP.Net Web API, Windows Workflow, Soap, JASON objects, Windows Services, and Enterprise Library 6.0
• Created Entity classes, relationships between entity classes using LINQ to Objects, LINQ to XML, and LINQ to SQL and to manage relational data as objects wif Entity Framework 4.0
• Extensive experience in Database Design, Developing T-SQL queries using joins, Stored Procedures, Functions, Indexes, Triggers, View, Common table expression (CTE) and Performance Tuning using SQL Server 2019/2017/2016/2014
• Involving in creating/modifying teh complex SSIS packages for Data Migration and Transformation Using SQL Server Data Tools 2017/2015 and expertise in Scripting Queries wif Microsoft SQL Server.
• Expertise in working wif SQL Server Reporting Services (SSRS) and generate ad hoc SSRS reports
• Experienced in using XML technologies like XSD, XSLT, XQUERY and XPATH Navigator.
• Good experience in building & deploying teh Web application, WCF Services, XML Web services, Sql Objects and SSIS packages in lower/higher environments.
• Experienced in creating and modifying teh Unit testing project using Microsoft Test project & N-Unit framework
• Experience in creating Technical high\low design document, Functional requirement specification (FRS), Business requirements document (BRD) Use cases, Unit Test cases (UTC) and User manuals for various projects.
• Good Basic noledge on Microsoft Azure, Angular JS, React JS and AJAX framework in creating efficient and interactive Web applications
• Experience in using Source code control systems like Bitbucket, Team Foundation Server (TFS), Apache Subversion (SVN), Visual Source safe (VSS), & Clear Case
• Involving in all stages of software development life cycle (SDLC) including requirements gathering, analysis, designing, coding, testing and implementing teh application following Scrum (Agile) methodology and Waterfall methodology
• Good experience in teh US Healthcare Domain (Member Enrollment, Provider management, Claim Encounters and Payer), Media & entertainment, Multi peripherals devices, Enterprise Resource Planning (ERP)
• Self-Motivated and a Team player wif excellent communication and written skills wif exemplary analytical and problem-solving skills.

TECHNICAL SKILLS

Microsoft Technologies: .NET Framework 4.7.2/4.6/4.5 , ASP.NET, MVC 5.0/4.0, ADO.Net, WCF, Web Services & SSIS, SSRS, Enterprise Library 6.0, HTML5.0, CSS 3.0, Bootstrap

Languages: C#.Net, LINQ

Script Languages: JQuery, JavaScript, AJAX, Jason

Database: MS-SQL Server 2019/2017/2016/2014 , Oracle 12.10, DB2

ORM Technologies: Entity Framework 4.0, XML Related TechnologiesXML, XSD, XSLT, XQUERY and XPATH

Unit Testing Framework: MS Test Projects & NUnit

Source Control: Bitbucket, TFS2015/2010, VSS, Clear case, SVN

Tool: Visual Studio 2019/2017, Source Tree, Jira, Confluence, Git, Visual studio Code, Toad Developer, SQL Developer, SoapUI, Postman, Microsoft Visio, Star UML, ReSharper, SonarQube, Beyond Compare, OPTUM Geonetworks

PROFESSIONAL EXPERIENCE

Confidential - Norfolk, VA

Technology: .Net Framework 4.7.2, MVC 5.0, JQuery, C#4.0, WCF 4.0, SQL Server 2019, SSIS 2016, SSRS 2016

Responsibilities:

• Analyzing different data sources to map to a new integrated data warehousing system.
• Developed data transformation Stored Procedures, Functions, View for a data source to an EIDS system
• Validating teh data in EIDS against Facets/EDINet, VLM, ODW for its correctness in terms of Claims, Members, and Provider data elements.
• Designing teh integrated system wif different data layers - Landing, Conformed, Staging and Encounters.
• Involved in Production monitoring for all teh markets in Encounter Data Sourcing
• Involving in creating/Modifying teh complex SSIS packages for Data Migration and Transformation Using SQL Server Data Tools
• Developed SSIS Package for Automate teh source & target data validation
• Involved in Dev & QA Data component deployment.

Confidential - Norfolk, VA

Technology: .Net Framework 4.5.2, Asp.net, C#4.0, WCF 4.0, SQL Server 2017/2016, SSIS, Bitbucket, Source Tree

Responsibilities:

• Involved in Requirement gathering, Requirement analysis, understand teh business requirements
• Involved in high level / low-level design, coding, and unit testing
• Involved in database design, and writing procedures, functions, triggers, and view
• Involved in code review, peer review wif team & fix teh code review issues
• Involved in creating new SSIS Package and modified teh SSIS package based on business need
• Integrating various sub-modules & performed Unit testing and functional testing
• Worked closely wif teh QA team to close all teh defects/ observations in system testing
• Analyzing and fixing teh production issues if any as part of System Testing and involved in project deployment.
• Managing end to end project deliverables which includes creating and maintaining development and deployment plans

Confidential - Norfolk, VA

Technology: SQL Server 2014, SSIS, Optum Geo Networks, Facets, SVN

Responsibilities:

• Modified existing geo reports & generate geo reports based on business demand
• Generating teh geo reports for more than six different markets
• Compare and validate teh healthcare networks on a monthly, quarterly, and yearly basis
• Analyzed teh existing geo reporting issues & fixed teh issues
• Closely working wif customers and business analysts to understand teh business requirements
• Involved in Requirement gathering, Requirement analysis, Review teh SQL Objects
• Involved in SQL Script Performance tuning and bug fixing

Confidential

Technology: .Net Framework4.5.2, C#4.0, WCF 4.0, SQL Server 2012, SSIS

Responsibilities:

• Responsibility for developing teh Console application using .NET framework 4.5.2, C#4.0, WCF 4.0, LINQ SQL Server 2012, and SSIS
• Involved in Requirement gathering, Requirement analysis, understand teh business requirements
• Involved in high level / low-level design, coding, and unit testing
• Involved in database design, and writing procedures, functions, triggers, and view
• Involved in code review, peer review wif team & fix teh code analysis issues
• Created WCF Services using HTTP, TCP verbs
• Implemented in Logging, Exception Handling & Caching using Enterprise Library 6.0
• Integrating various sub-modules & performed integration testing
• Worked wif various tools like SonarQube6.1, Resharper, FX Cop
• Build and migrate code to development and SIT environment using Visual Studio 2013 & IIS
• Used Team Foundation Server (TFS 2015) to maintain and versioning teh code
• Worked closely wif teh QA team to close all teh defects/ observations in system testing
• Improved teh performance of applications using parallel processing in LINQ

Confidential

Technology: ASP.NET4.0, C#4.0, WCF 4.0, DB2, Ajax, JQuery, JavaScript, HTML, CSS

Responsibilities:

• Responsibility for developing teh Web application using ASP.NET4.0, C#4.0, WCF 4.0, LINQ to SQL Server 2012
• Involved in Solution architecture, User interface design, and DB model for teh application.
• Involved in preparing teh technical response, low-level design documents
• Implemented Site Minder Authentication for Application User login
• Created WCF Services using HTTP, TCP verbs
• Creating Unit test cases for teh Business requirement & involved in bug fixing
• Optimize teh database queries for performance improvement
• Involved in Build and deployment of teh application for teh production releases
• Used Clear Case to maintain and versioning teh code
• Worked wif various tools like Verecode, Resharper

Confidential

Technology: ASP.NET4.0, C#4.0, WCF 4.0, SQL Server 2008, Ajax, JQuery, JavaScript, HTML

Responsibilities:

• Responsibility for developing teh Web application using ASP.NET4.0, C#. NET, WCF, LINQ, and SQL Server 2008 and SSIS
• Involved in high level / low-level design, coding, code/peer review, and unit testing
• Created Custom Drill down report & Charts Using Custom JQuery Controls (JQGrid)
• Implemented Site Minder Authentication for Application user login.
• Created WCF Services using HTTP, TCP verbs.
• Created teh unit test cases document and completed unit testing.
• Used Team Foundation Server TFS 2010 to maintain and version teh code.

Confidential

Technology: ASP.NET4.0, C#4.0, WCF 4.0, DB2, Ajax, JQuery, JavaScript, HTML, CSS

Responsibilities:

• Responsibility for developing teh Web application using ASP.NET4.0, C#4.0, WCF 4.0, LINQ & SQL Server 2012
• Involved in Solution architecture, User interface design, and DB model for teh application.
• Involved in preparing teh technical response, low-level design documents
• Implemented Site Minder Authentication for Application User login
• Created WCF Services using HTTP, TCP verbs
• Creating Unit test cases for teh Business requirement & involved in bug fixing
• Optimize teh database queries for performance improvement
• Involved in Build and deployment of teh application for teh production releases
• Used Clear Case to maintain and versioning teh code
• Worked wif various tools like Verecode, Resharper

Confidential

Technology: ASP.NET MVC, C#4.0, WCF 4.0, Entity Framework, SQL Server 2008, Windows Server AppFabric 6.1, Resharper, Star UML

Responsibilities:

• Teh sole responsibility of developing teh Web application using ASP.NET MVC 3.0, C#4.0, WCF 4.0, LINQ, and SQL Server 2012 for various modules
• Involved low-level design, database design, coding for various modules
• Consumed External WCF services for receiving & sending data
• Created Data access layer using Entity Framework
• Wrote functions, stored procedures, views, and triggers using SQL Server 2008
• Built unit test projects using NUnit and Microsoft Test projects.
• Worked wif various tools like Windows AppFabric 6.1, Enterprise Library, Resharper

Confidential

Technology: ASP.NET4.0, C#4.0, WCF 4.0, nHibernate3.2, SQL Server 2008, AJAX, JQuery

Responsibilities:

• Responsibility for developing teh Web application using ASP.NET 4.0, C#4.0, WCF 4.0
• Involved in Requirement gathering, understand requirements & coding
• Involved coding for core components like Logging, Exception Handling, Data access layer & Caching
• Implemented POC for nHibernate3.2 Data access layer
• Creating unit test cases for teh Business requirement & involved bug fixing

Confidential

Technology: ASP.NET4.0, C#4.0, WCF 4.0, Entity Framework, SQL Server 2008

Responsibilities:

• Responsibility for developing teh Web application using ASP.NET MVC, C#4.0, WCF 4.0, Entity Framework, and SQL Server 2008
• Involved in Database design, coding & unit testing for various modules
• Involved in Code review and Integration testing
• Created teh unit test cases document and completed unit testing
• Used Code Analysis tools like FX Cop
• Worked as Configuration Controller in teh projects.

Confidential

Technology: ASP.NET2.0, C#2.0, Web services, Windows Service, SQL Server 2005

Responsibilities:

• Responsibility for developing teh Web application using ASP.NET2.0, C#2.0, Web / Windows Services & SQL Server 2005
• Designed and developed teh front-end screen and business logic layer using C#. Net.
• Involved in database design and writing teh procedure, function, triggers and views.
• Optimize teh database queries for performance improvement
• Implemented in Custom & User control using ASP.NET2.0
• Unit testing and defect fixing in developed modules

Confidential

Technology: ASP.NET2.0, C#2.0, SQL Server 2000, JavaScript

Responsibilities:

• Developed Web forms using ASP.Net 2.0 & C#2.0, Web services, JavaScript
• Prepared Database Design and written Stored Procedures, Triggers, User Defined Functions using SQL Server 2000
• Developed Sales & Admin Modules individually
• Handled client-side technologies like JavaScript framework for validations.
• Worked wif ADO .NET objects such as Data Adapter, Dataset, and DataReader to interact wif SQL Server databases.
• Involved in unit testing, bug fixing of teh application.
• Used Visual Source Safe (VSS) to maintain and versioning teh code

Confidential

Technology: ASP.NET2.0, C#2.0, SQL Server 2000, JavaScript

Responsibilities:

• Designed and developed teh front-end screen and business logic layer using C#. Net
• Involved in database design and writing teh procedure, function, triggers and views
• Worked in various technology like Asp.net 2.0 C#2.0, Web services, JavaScript, SQL Server 2000
• Developed Foundational component, Custom & User control
• Used Visual Source Safe (VSS) to maintain and versioning teh code
• Unit testing and defect fixing in developed modules