SUMMARY

• 16 years of experience in design & development of multi - tier database-driven web applications with rich UI across multiple domains. Thorough understanding of technologies and Development Lifecycle.
• Extensive Experience in different .NET technologies and languages like Visual Studio 2008, Visual Studio 2010, Visual Studio 2012, ASP.NET 4.0, C#.NET, VB.NET, ADO.NET, WEBSERVICES, WCF, LINQ, MVC 3.0/4.0, AJAX, VB6.0, SQL SERVER 2000/2005/2008/2012 , Crystal Reports, IIS 6.0, JavaScript, VB Script, CSS, SASS, ITCSS, HTML, SOAP, XML, Oracle 9i., Angular 7.0, Web API.
• Extensive experience in developing ASP.NET based Web forms.
• Worked on EXT.NET 2.0 for MVC & EXT.NET 1.0.
• Worked on MVC 3.0/4.0 (Model View Controller) Pattern.
• Good experience in consuming and publishing WCF, ASMX Web Services using C# hosted in IIS 6.0/IIS 7.0.
• Worked on REST web services.
• Expertise in implementation of AJAX for making the application more interactive and increasing the efficiency.
• Implemented LINQ, Lambda Expressions and LINQ to SQL& LINQ to XML for data retrieval and querying tables.
• Expertise in design, development and implementation of Client-Server and Three-tier application such as Web development.
• Implemented plugins provided by JQuery.
• Experience Creating reports with Crystal Reports.
• Expertise in database design and programming in SQL Server 2000/2005/2008/2012 , Oracle 9.x.
• Strong knowledge of back-end programming with T-SQL.
• Expertise in writing queries, Stored Procedures, Functions, Triggers, Cursors & Views in SQL server.
• Experience using Configuration Management tools like Microsoft Visual Source Safe (VSS), Team Foundation Server (TFS) for version control.
• Expertise in writing Unit Test Cases and system testing/Integration Testing.
• Involved in Change Management & Release Management.
• Good interpersonal and communication skills with fast learning capabilities.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/2000/Professional/XP/Vista/2003/2010 Server/7/8

Languages: C#.Net, VB.Net, C, C++, VB 6.0

Microsoft Technologies: ASP.NET 3.5/4.0,C#,VB.Net,ADO.NET, VB6.0, ASP 3.0, Web Services, Windows Service, WCF, LINQ, MVC 3.0, Visual Studio 2008, Visual Studio 2010, Visual Studio 2017, SSIS, Razor View Engine, Entity Framework, Web API.

Client Side Technologies: VB Script, Java Script, JQuery, CSS, SASS, ITCSS, Angular 7.0, Type Script

Databases: SQL Server 2000/2005/2008/2015 , Oracle 9i, MS-Access.

Version Control Tools: TFS, VSS6.0, SVN

Web/App Servers: IIS7.0/6.0, Apache-Tomcat

Reporting/Productivity Tool: Crystal Reports, Microsoft Visio 2003, TOAD

Content Management: Tridion

Third Party Tool: EXT.NET 2.0

PROFESSIONAL EXPERIENCE

Confidential, MN

Sr .NET Consultant

Responsibilities:

• Wrote & Updated SQL functions & stored procedures.
• Modified stored procedures for optimizing performance & achieved considerable performance gains.
• Wrote Web API to fetch, insert or update data to SQL server regarding offenders & registrants.
• Wrote queries to fetch data from backend using Entity Framework 6.0.
• Wrote UI using Angular 7.0.
• Created angular services & consumed those services in angular components using dependency injection.
• Implemented authentication & data security to authorized users using JWT.
• Implemented authorization module to grant access to different category of users.
• Implemented module called Case Note, Manage Letters, and Alert Generation & Notifications.
• Interaction with BA in order to gather information about new requirements & made correction to the requirements.
• Attended meetings with QA team to answer their questions about the new product & to discuss the defects.
• Helped & coordinated with team members to see the successful implementation of the project.

Tools: Used: ASP.NET 4.0, C#, Type Script, Angular 7.0, SASS, ITCSS, .NET Framework 4.0, T-SQL, SQL Server 2016 Web API, Entity Framework 6.0, Angular Material, Visual Studio 2017, JQuery.

Confidential, MN

Sr .NET Consultant

Responsibilities:

• Involved in the development, enhancement & support of HPA application.
• Wrote Unit test cases to test the waterfall & the validations.
• Design & Developed the new Modification programs for private & GSE investors.
• Interaction with BA in order to gather information about new requirements.
• Created tasks in TFS with details about changes in system to implement new requirements.
• Attended meeting with Business to understand the business requirements.
• Analyzed the business requirements & created tasks in TFS to implement those requirements with the details about the code changes.
• Attended meetings with QA team to answer their questions about the new product & to discuss the defects.
• Coordinated with Offshore team to synchronize the development work.
• Helped & coordinated with team members to see the successful implementation of the project.
• Wrote & Updated SQL functions & stored procedures.
• Worked on jQuery & JavaScript’s.
• Worked on defects from test/Production environments that is reported in HP QC tool.

Tools: Used: ASP.NET 4.0, C#, JavaScript, MVC 4.0,Razor View, LINQ, JQUERY, .NET Framework 4.0, T-SQL, web service, SQL Server 2015, Entity Framework, Visual Studio 2012, Azure Platform.

Confidential, MN

Sr .NET Consultant

Responsibilities:

• Worked on making website 508 compliant to make website usable for people with disability.
• Remediate issues found during fortify scan.
• Optimized stored procedures for performance tuning & achieved 90% performance gain.
• Wrote shell script for generating test data & testing the stored procedure changes by comparing the output of old & new versions.
• Upgrading system to use .NET charting instead of third party charting tool for report generation.
• Involved in the development, enhancement & support of web application.
• Code Analysis of the business requirements & implementation.
• Cleaning up the code of unused variables & functions using ReSharper.
• Upgrading system to use JStree for grids & make asynchronous calls to the server.
• Merging multiple projects into one project for the sake of simplicity & design.
• Attended meetings to report the progress of project.
• Given presentation of the code to QA & managers for knowledge sharing & clearing doubts.
• Worked on making website supporting multi language user interface.

Tools: Used: ASP.NET 4.5, C#, JavaScript, SASS, ITCSS, CSS, LINQ, JQUERY, .NET Framework 4.0, T-SQL, SQL Server 2012, Visual Studio 2013, SVN, ReSharper, Fortify, Angular JS 2.0, Web API, Type Script, Angular 2.0.

Confidential, MN

Sr .NET Consultant

Responsibilities:

• Involved in the development, enhancement & support of HPA application.
• Wrote Unit test cases to test the waterfall & the validations.
• Design & Developed the new Modification programs for private & GSE investors.
• Interaction with BA in order to gather information about new requirements.
• Created tasks in TFS with details about changes in system to implement new requirements.
• Attended meeting with Business to understand the business requirements.
• Analyzed the business requirements & created tasks in TFS to implement those requirements with the details about the code changes.
• Attended meetings with QA team to answer their questions about the new product & to discuss the defects.
• Coordinated with Offshore team to synchronize the development work.
• Helped & coordinated with team members to see the successful implementation of the project.
• Wrote & Updated SQL functions & stored procedures.
• Worked on jQuery & JavaScript’s.
• Worked on defects from test/Production environments that is reported in HP QC tool.

Tools: Used: ASP.NET 4.0, C#, JavaScript, MVC 4.0,Razor View, LINQ, JQUERY, .NET Framework 4.0, T-SQL, web service, SQL Server 2012, Entity Framework, Visual Studio 2012.

Confidential, Benfield, MN

Sr .NET Consultant

Responsibilities:

• Involved in the Design & Development of ABConnect web application.
• Worked on performance tuning of SP and functions using SQL Server profiler & Execution plans.
• Created new SQL functions, stored procedures & triggers.
• Worked on redesigning of various .NET modules using object oriented methodologies.
• Interacted with business to analyze, document & implement the business requirements.
• Developed the module to change the site preferences by the users. Users can change the order of submenus in menu. They can hide/unhide menu items. They can change their landing page.
• Designed & implemented the language translation capability of site.
• Created WCF & restful web services.
• Used LINQ to manipulate and fetch the data from database.
• Worked on JavaScript & JQuery to create client side scripts.
• Involved in Unit and Functional testing using NUnit.
• Involved in testing and fixing the issues occurred in the testing process.
• Worked on business critical defects from Production environments.
• Helped & guided junior team members to finish their assigned tasks.
• Worked on TFS 2012 for version control, defect & task management.
• Created tasks in TFS 2012 with details about changes in system to implement new requirements.
• Setting up IIS 7.0 for Internal as well as External site in different environments.

Tools: Used: ASP.NET, JavaScript, LINQ, JQUERY, .NET Framework 4.5, T-SQL, Web Service, SQL Server 2008, Visual Studio 2013, VB.NET, EXT.NET 2.0.

Confidential, MN

Sr .NET Consultant

Responsibilities:

• Involved in the development, enhancement & support of HPA application.
• Wrote Unit test cases to test the waterfall & the validations.
• Developed the End To End test project that was scrapping data directly from MSP (Mainframe) and comparing it with the data in HPA application’s database (after the loan information is retrieved from MSP and at the beginning of modification). This project also compares the data that is committed to MSP (after the modification) with the data in the HPA application’s database (SQL server). This is achieved by developing a generic function that accepts the data from MSP and from HPA database and creating an array of objects holding data. Once the complete array of data is created, a generic function compares the values from these two sources.
• Deployment of new releases to test environments (Development/UAT).
• Worked on defects from test/Production environments that is reported in HP QC tool.
• Developed new scheduled task that used to scrap new FHLMS rate from external FHLMC website and update into the HPA database.
• Developed scheduled task that converted the website page that shows the modified terms into .pdf doc, so that it can be sent across to the borrower.
• Interaction with business users in order to gather information about new requirements.
• Created tasks in TFS with details about changes in system to implement new requirements.
• Involved in the migration of the application from MVC 2.0 to MVC 3.0 using Razor Views& Entity framework.
• Developed new waterfalls (Modification Plans).
• Worked on the Entity Framework & Database Projects.
• Wrote Linq to Entities & Linq to SQL queries to fetch data from database.
• Wrote compiled linq queries.
• Wrote & Updated SQL functions & stored procedures.
• Worked on jQuery & JavaScript’s.

Tools: Used: ASP.NET 4.0, C#, JavaScript, MVC 3.0,Razor View, LINQ, JQUERY, .NET Framework 4.0, T-SQL, web service, SQL Server 2008, Entity Framework, Visual Studio 2010.

Confidential

Sr .NET Consultant

Responsibilities:

• Involved in the enhancement of the “Reemployment” section of the CareerOneStop portal.
• Tridion maintenance & enhancement including schema design, page and component template development.
• Involved in the migration of system from Oracle 9G to Oracle 11G.
• Preparation of web trends reports
• Analysis & resolution of Production support Issues.
• Writing Stored Procedures & Functions in Oracle 11g using TOAD.
• Enhancing & bug fixing in classic ASP pages.
• Developed module to translate the site from English Language to Spanish & vice versa.
• Worked on XSLT as part of Tridion template development.
• Developed new web services.
• Worked on enhancing & fixing page styles using CSS 1.0 & inline styles across different browsers.
• Involved in Functions development in SQL Server.
• Worked on JQUERY & AJAX.
• Wrote LINQ statements to join XMLDOCUMENT objects as part of web service development.
• Migrating .NET 2.0 applications on IIS6 to .NET 3.5 on Windows7 & IIS7 Platform.
• Involved in stored procedure development in SQL Server.
• Stored Procedures Optimization.

Tools: Used: ASP.NET 3.5, ASP, C#, VB.NET, JavaScript, vbScript, CSS 1.0, Oracle 11g, MVC 3.0, TOAD, LINQ, JQUERY, .NET Framework 3.5, PLSQL, web service, web trends, SDLTridion, Windows 7, IIS7, SQL Server 2008, Crystal Report.

Confidential

Project Lead

Responsibilities:

• Involved in the implementation of PCI standards to protect customer data in Agile environment.
• Involved in the implementation of Auto Delivery Module in Agile environment.
• Worked in Agile environment and coordinated with Customer representative & QA team.
• Involved in the integration of QAS to the existing system.
• Involved in the analysis of many business critical issues.
• Lead the team to define process & implementing it to stabilize various test environments. This helped us to get rid of recurring issues in test environment during consecutive deployments.
• Lead the team to coordinate development & testing activities during various releases.
• Involved in the merging of two separate databases to a single database.
• Identified the unused tables across the system.
• Identified columns that are suitable for Primary key definition in tables.
• Involved in writing various Stored Procedures & Queries.
• Worked on the web service to integrate third party payment gateway for processing orders.
• Worked on the integration of third party tools like Mercado.
• Extensively used ADO .NET for data retrieval and querying.
• Worked on ASMX & WCF web services.
• Implemented changes in LINQ queries.
• Used TFS for version controlling.
• Presenting the enhancements to the clients during UAT meeting.
• Encryption of critical customer data like Password & Credit Card.
• Involved in the analysis of various business critical issues.
• Onsite/Offshore coordination
• Preparing test plan & Integration testing involving web, tibco & oracle.

Environment: Visual Studio 2008, SQL Server 2008, .NET Framework 3.5, Agile, C#.NET, XML, JavaScript, WCF, ASMX web service, REST web service, MVC 3.0, LINQ, ADO.NET, CSS, HTML

Confidential

Analyst Programmer

Responsibilities:

• Implemented various Development & Enhancements.
• Implemented enhancements to the existing pages.
• Added new tables & stored procedures in SQL Data base.
• Assisted with root cause analysis in supporting production platforms with ability to troubleshoot code and SQL Server stored procedures analyze and follow order and data flow between multiple systems.
• Followed formalized software development lifecycle (SDLC) processes
• Created & modified Triggers to implement data integrity & business logic.
• Involved in optimizing the database schema.
• Analyzing the business critical Issues & providing fix for it.
• Worked on VSS for version controlling.
• Configured IIS and set up virtual directories.
• Doing Impact Analysis for the proposed changes.
• Documenting the enhancements & project management.
• Scheduling and estimating delivery milestones
• Preparation of test plan & testing
• Onsite/Offshore coordination

Environment: Visual Studio 2005, ASP.NET, C#, VB.NET, web Services, ADO.NET, SQL Server 2005,CSS, HTML, JavaScript

Confidential

Analyst Programmer

Responsibilities:

• Responsible for architect-level design and creation of the databases and tables required for the application and for writing queries and performing upgrades and tuning on the tables and queries
• Added/ modified many stored procedures & Functions to implement business logic.
• Involved in the enhancement of the reconciliation system.
• Extensively used ADO .NET for data retrieval and querying
• Addition of new modules & reports.
• Worked on VSS for version controlling.
• Client interaction and requirement gathering
• Code integration & deployment in production environment
• Involved in Testing and deployment during various releases.
• Database & interface design

Environment: Visual Studio 2005, ASP.NET, VB.NET, ADO.NET, SQL Server 2005, Crystal Report, CSS, HTML