SUMMARY

• 8+ years of .NET development, Business Intelligence development, support experience on real time web - based applications especially in the Finance, Insurance, Mortgage and Travel domains
• Extensive experience in .NET Frameworks 1.1, 2.0, 3.0, 3.5, 4.0 and 4.5
• Extensively involved with all phases of software development life cycle (SDLC) including requirements analysis, architecture, design, development, testing, deployment and maintenance
• Followed Agile and waterfall practices for software development
• Experience in development and deployment of SSISpackages.
• Experience in Data Extraction, Transformation and Loading (ETL) using SSISof MS SQL Server.
• Experienced in designing applications on unit of work and repository pattern with entity framework and MVC following industry-accepted design patterns and best practices
• Proficient with development of Web applications using C#, VB.NET, ASP.NET, ADO.NET, MVC, HTML, bootstrap CSS, XML, LINQ, Angular JS, JQuery, JavaScript, WCF and Web API
• Experience in Test Driven Development with MS Unit Test, NUnit, Moq and AutoMoq
• Strong hands-on experience in database design, implementation and optimization of Tables and Stored Procedures, Triggers, UDF, T-SQL, SQLCLR, Exception handling in SQL Server 2014/2008/2005/2000
• Hands on experience in developing large scale IT enterprise products used by multinational clients with a sound understanding of financial concepts in Mortgage, Finance and Insurance, Travel and Hospitality(E-Commerce)
• Worked as consultant with TCS for more than 2.5 years for leading Investment client in USA. Building and maintaining healthy business relations with major clients: onsite/off-shore.

TECHNICAL SKILLS

Programming Languages: C# and VB.NET with strong object oriented programming concepts

Databases: MS-SQL Server 2012/2008/2005/2000 , PL-SQL developer

.NET Technologies: Visual Studio.NET 2003/2005/2008 , 2010,2015 ASP.NET 1.1/2.0/3.5/4.0/4.5

Web Technologies: JavaScript, JQuery, Angular JS, Json.net, HTML, XML, CSS, Bootstrap and VBScript, WCF, Web API

Application Design: Unit of work and repository pattern with entity frameworkMVC Architecture

Testing Tools: MS Unit Test, NUnit, AutoMoq

Tools: & Utilities: Auto Mapper, ELMAH, Log4NET Octopus deployments, SVN, TFS

Design: UML Diagrams, ER Diagrams, Flow Charts, Mock up designs, Object Oriented Designing

BI: SSIS, SSRS

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

IT Contractor

Environment: .NET Framework 4.5, ASP.NET, C#, SQL Server 2012, Entity Framework v6.1, MVC V5.0, Unit of Work and Repository design pattern, Angular JS, JQuery, Java script, AutoMoq, HTML, CSS, ELMAH, SSIS, WCF and Web API, Azure Blob

Responsibilities:

• Followed Agile methodology for application development
• Gathered requirements from Client meetings and Actively participated in story mappings meetings
• Created different types of UML and ER Diagrams using MS-Visio
• Design and Developed application on MVC v5 and Entity Framework v6
• Defined logical database model, table structures, constraints, Indexes and relationships in the SQL database
• Used Unit of Work and Repository Design pattern
• Used CSS and Html for UI design
• Used Angular Js and JQuery for Client Side scripting
• Used ELMAH (Error logging module and handler) for error logging
• Developed application using Test Driven development with MS Unit Tests, NUnit, Moq
• Worked on SQL server integration services and reporting services (SSIS, SSRS)
• Developed RESTfulWebAPIservices, using ASP.NETWebAPIas backend service
• Created unit test and system integration test cases
• Managed and prioritized the defects and changes during the testing and UAT phase
• Involved in Enhancement for WCF Service

Confidential, Seattle, WA

Programmer Analyst

Environment: .NET Framework 4.0, ASP.NET, MVC, C#, VB.NET, Entity Framework, SQL Server 2008, UML, XML, XSLT, SOAP, JavaScript, Log4NET, AJAX, HTML5, JQuery, Html CSS, LINQ, ADO.NET, SSIS, SSRS and SVN

Responsibilities:

• Created system requirement analysis and technical system design document
• Created different types of UML and ER Diagrams using MS-Visio
• Followed both Agile(Scrum) and Waterfall practices for software development
• Design and developed application on Entity Framework and MVC architecture
• Developed Web pages using ASP.NET 4.0, 3.5 with C# and VB.NET
• Defined logical database model, table structures, constraints, Indexes and relationships in the SQL database
• Implemented optimized Stored Procedure, Indexes, DDL and DML Triggers, UDFs, T-SQL statements and SQL-CLR Integration
• Worked on performance tuning of SQL object such as Tables, Stored Procedure and TSQL on SQL Server
• Developed rich user interfaces using Ajax, JQuery and JavaScript
• Developed class libraries to create, transform and transferring data using XML and XSLT
• Implemented server side validation through AJAX
• Involved in Creation, Development and Deployment of SSIS Package in SQL Server 2012
• Responsible for supporting Production Environment
• Worked on SQL server integration services and reporting services (SSIS, SSRS)
• Created unit test and system integration test cases
• Managed and prioritized the defects and changes during the testing and UAT phase

Confidential, Seattle, WA

Software Developer

Environment: .NET Framework 3.5, ASP.NET 3.5, C#, VB.NET, SQL Server 2005, WCF, UML, XML, XSLT, AJAX, JavaScript, JQuery, HTML, CSS, Microsoft Enterprise Library, LINQ, IIS 6.0 and SVN

Responsibilities:

• Created system requirement analysis, technical system design and service change request documents
• Developed application on N-Tier architecture
• Created normalized database model, Stored Procedure, Triggers, UDFs and T-SQL statements
• Followed different design patterns such as Factory, Abstract Factory, Singleton, Façade
• Created different types of UML and ER Diagrams using MS-Visio
• Followed Waterfall software development life cycle model
• Developed Web pages using ASP.NET 3.5 with C# and VB.NET
• Written SSIS Package to load data in RAICIR database from multiple sources which also includes complex business logic and to output data to multiple output sources
• Created unit test and system integration test cases
• Used SVN for the source code and version control
• Set up the complete staging environment and configured the site on IIS 6.0 and Windows Server 2007 for the testing phase

Confidential, Seattle, WA

Software Developer

Environment: .NET Framework 3.5, ASP.NET 3.5, C#, SQL Server 2005, WCF, HTML, CSS, UML, XML, XSLT, Silverlight, JavaScript, LINQ, IIS 6.0 and SVN version control

Responsibilities:

• Involved in creation of requirement analysis and technical system design documents.
• Developed application using Abstract Factory design pattern and SOA
• Designed and developed a class libraries using C#, ADO.NET 3.5
• Developed web pages using ASP.NET 3.5 and C#
• Created the Tables/Relationships/Indexes/Stored Procedures/User-defined Functions/Triggers using SQL Server
• Worked on performance tuning of SQL object such as Tables, Stored Procedure and TSQL on SQL Server 2005
• Created and consumed remote services using Windows Communication Foundation (WCF)
• Used Ajax, JQuery, Silverlight, XAML and WPF to develop rich user interface
• Written SSIS Package to load data in APM database from multiple sources which also includes complex business logics and supported production environment
• Set up the staging environment and configure the site on IIS 6.0 and Windows Server 2003 in testing phase
• Managed and prioritized the defects and changes during the testing and UAT phase
• Reviewed deliverables and ensure they meet the high quality standards before delivering them to the client
• Attended weekly meetings and updated the project manager weekly on task progress
• Used SVN for the source code version control

Confidential, IA

Software Developer

Environment: .NET Framework 2.0, ASP.NET 2.0, C#, SQL Server 2005, Data Tier Modeling, JavaScript, JQuery, and Visual Source Safe, XML, ADO.NET, UML diagrams in MS Visio and IIS6

Responsibilities:

• Gathered requirements from the business users and analyzed and translated to the technical system design document
• Designed and developed a class library using C#, ADO.NET for the data access layer
• Design and developed application on N-tier architecture
• Developed Web pages using ASP.NET with C# and VB.NET
• Used Team Foundation Server for the source code and version control
• Defined logical database model, table structures, constraints, Indexes, and relationships in the SQL database
• Worked on performance tuning of SQL object such as Tables, Stored Procedure and TSQL on SQL Server
• Participated in all phases of SDLC for this project
• Involved in Creation, Production Support and Enhancement of application

Confidential

Software Developer

Environment: .NET Framework, C#, Multithreading, WPF, SQL Server 2005 and Visual SourceSafe, XML, ADO.NET, UML diagrams in MS Visio

Responsibilities:

• Extensively involved in creation of requirement specification and technical design documents
• Designed and developed N-tier Architecture using C#, ADO.NET
• Developed Windows application using C# and SQL Server 2005
• Wrote efficient Stored Procedures, User Defined Functions, Views and T-SQL statements to access
• Created unit test, system integration test and user acceptance test cases
• Participated in all phases of SDLC for this project
• Created Utility class in C#.
• Designed and developed mock screens and finalized the requirements
• Developed the high level and low level architecture and design documents

Confidential

Software Developer

Environment: ASP.NET 1.1, 2.0, VB.NET, C#, AJAX, Data Tier Modeling Tool, SQL Server 2000, UML, XML, WML, Remoting, TFS, ADO.NET, WinForms and IIS6

Responsibilities:

• Developed the web application using N-tier Architecture
• Designed and developed web pages C#, ASP.Net, ADO.Net and Sql Server
• Created window schedule job for to automate other process
• Involved in database designing and normalization activities
• Wrote efficient Stored Procedures, User Defined Functions, Views and T-SQL statements to access
• Created unit test, system integration test and user acceptance test cases
• Participated in all phases of SDLC for this project
• Performance tuning of application by fine tuning SQL queries and creating indexes as well as caching techniques
• Involved in support and Enhancement for other Applications