.Net Sql Server

Professional Profile:

*+ years of extensive experience as .Net Developer in Microsoft.Net technologies.

Expertise in developing object-oriented Multi-Tier web and windows applications using Microsoft .Net Framework 1.1/2.0/3.5/4.0, ASP.Net 1.1/2.0/3.5/4.0, C#.Net, VB.Net, ADO.Net, WCF, XML, XSL, MVC, Web Services, Web Forms, Win Forms, JavaScript, jQuery, AJAX, SSIS, Oracle 8, SQL Server 2000/2005/2008, SOA, IIS on Windows platforms.

Extensively worked in all phases of Software Development Life Cycle Process(SDLC) involving Analysis, Design, Development, Deployment, Testing and Implementation of Client/Server applications using Microsoft .NET.

Extensively developed presentation layer using Web Forms, Windows Forms.

Hands-on experience in developing the web applications using ASP.NET, C# and database accessing using ADO.NET.

Experience in migrating existing applications to newer .Net Framework versions to enhance extensibility and maintainability.

Expertise in creating stored procedures, Triggers, Functions, SSIS in SQL Server 2000/2005/2008.

Experience in Training and mentoring software professionals on developing highly scalable and maintainable applications using .Net and SQL Server.

Experience in Implementing OOP concepts and design patterns.

Experience in using ETL (Extract, Transform and Load) tools like SQL Server Integration Services (SSIS) for data migration from various data sources like Excel, SQL Server, Flat files.

Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

Experience in developing reports using Crystal Reports and Active Reports.

Working knowledge in configuration and version management using Visual Source Safe (VSS), Clear -Quest, Clear-Case, Subversion (SVN) and Team Foundation Server (TFS 2010).

Good experience in implementing client-side JavaScript, JQuery, proficient in HTML, CSS.

Good understanding of technology with focus on delivering business solutions. Comprehensive problem solving abilities, excellent verbal and written communication skills, Interpersonal Skills and Leadership Qualities.

Technical Skills:

Technologies:

.NET Framework 3.0/3.5/4.0, C#.Net, ASP.NET, ADO.Net, AJAX, Web Services, WCF, WPF, LINQ, JQuery, SSIS

Languages:

C, C++, C#, SQL

Database:

MS-SQL Server 2005/2008/2012, Oracle 9i/10g

Frameworks:

.NET 3.0/3.5/4.0

Web Technology:

HTML, HTML 5, XML, JavaScript, AJAX, CSS, Web services

Server Platforms:

IIS 7.0/6.0/5.0, Windows Server SPI

IDE:

Microsoft Visual Studio .NET 2005/2008/2010/2012, Selenium

Reporting tools:

SSRS, Active Reports, and Crystal reports

Version Control:

MS-Visual Source Safe, MS-Team Foundation Server, Tortoise SVN, Clear Case and Clear Quest

Professional Certifications:

MICROSOFT CERTIFIED PROFESSIONAL in .NET Framework 2.0-Web-based Client Development

MICROSOFT CERTIFIED PROFESSIONAL in .NET Framework 2.0-Application Development Foundation

BRAINBENCH CERTIFIED in ASP.NET

Educational Qualification:

MCA (Masters in Computer Application) from J.N.T.U, HYD - India

Professional Experience:

Veteran Affairs, Hines, IL

Oct 2014- till date

Senior .Net Developer

Project: Asset Point- IT Asset Management Software

Asset Point is a unique software platform that provides a holistic approach to IT Asset Management for the planning & administration of IT Change & Transformation events. IT professionals gain visibility and control of the information needed to implement IT strategies that support business objectives, inform effective decision-making and mitigate the risk of corporate changes. Asset Point is a fully configurable powerful tool to manage moves and migrations, to model & manage space, power, cooling and connectivity requirements, as well as for Business Continuity Planning.

Responsibilities:

Responsible for analyzing and documenting the requirements from the end clients

Designed process flow diagrams using Microsoft Visio

Designed and developed web forms for the application using C#.net, ASP.net, HTML, AJAX, CSS, XML, JavaScript, jQuery, Infragistics and Telerik controls

Implemented MVC(Model-View-Controller) design pattern for enhancing user experience

Wrote complex SQL queries, stored procedures, views and triggers to insert, modify, delete and search data using SQL Server 2008

Enhanced the existing application by implementing Drag and Drop Framework by creating customizable Widgets per user using JavaScript, AJAX

Implemented ADO.Net Entity Framework by creating conceptual model, storage model and mapping of the models

Used Lambda expressions to write LINQ queries while implementing LINQ to SQL

Implemented Row level security in the application so that the user access is restricted as per the settings

Migrated the existing web services to WCF

Responsible for writing Data contracts and Service Contracts for the services

Troubleshooting and problem solving existing issues in Production environment on client side

Used TFS (Team Foundation Server) to facilitate working in team environment

Environment:

.Net Framework 3.5/4.0, ASP.Net 3.5/3.0, C#.Net 3.5/4.0, VB.Net, SQL server 2008 R2, Infragistics 2010, Telerik controls, JavaScript, jQuery, TFS, AJAX, IIS, HTML, MS Visio.

JPMorgan Chase, Chicago, IL

May 2013 – Sep 2014

Sr. Software Developer

Project: MAGIC

JPMorgan Chase is one of the world’s leading financial service providers for corporations, Institutions and affluent individuals. HQ-New York. JPMorgan Chase is the no 1 global custodians with over $16 trillion in assets under custody. MAGIC was developed using VB 6.0 and Sybase 9 providing services to investment clients. This application was mainly used to create account and parties and maintain their profiles and investment details.

Responsibilities:

Architecture and infrastructure requirement gathering of the system.

Analysis and Design of specific tasks.

Develop the system using Silverlight 3.0, .Net 3.5, WCF

Develop SSIS to transfer data and to be used by the new jobs.

Reviewing and Remodeling Data Model and Data Dictionary.

Developing the specific requirements to technical design document.

Develop Reports using SSRS

Create POC for critical functionalities.

Development/Construction.

Implementing best practices.

Created database objects like tables, functions, triggers and stored procedures.

Created SSIS package for data migration between staging and OLTP schemas

Environment:

. Asp.Net 3.5, C#, SQL Server 2005, Silverlight 3.0, Visual studio 2008, WCF, Web services, SQL Server Integration Services (SSIS), SSRS, Windows Server 2008R2.

U.P.M.C, Pittsburg, PA

Jan 2012 – Mar 2013

Programmer Analyst

Project: Applicant Image Capture

This is a windows based client-server application designed to capture applicant’s photo, signature and keycard information. Applicant’s picture is captured through webcam using WIA (Windows Image Acquisition) libraries. Third party libraries were integrated in the application for capturing e-signature of the applicant. This application also facilitated scanning the bar-code on the key card of the applicant using the bar-code reader.

Responsibilities:

Totally responsible for full life cycle development of the software (SDLC)

Responsible for conducting in-depth analysis of the requirements and preparing Software Requirement Specification documents

Attended end-client requirement gathering meetings and analyzed feasibility of the requirements

Created process-flow diagrams and cross-functional diagrams for various applications

Designed mock-up screens for the proposed application using MS Visio

Designed and Developed web forms and User Controls using C#.Net, ASP.Net, SQL Server 2005, HTML, CSS, jQuery, XML, VSS, AJAX, WIA (Windows Image Acquisition)

Developed business layer and data layer classes using C#.Net, ADO.Net

Used AJAX Animation control to enhance the user experience

Wrote complex SQL queries, stored procedures, views and triggers to insert, modify, delete and search data using SQL Server 2005

Created and monitored SSIS (SQL Server Integration Services) packages to fetch data from external SQL server databases and transform to required schema before inserting it into the destination databases

Converted existing DTS Packages to SSIS SQL Server Packages

Created various web services using SOAP, WSDL, HTTP, C#.Net and ADO.Net and exposed the web services to outside systems to perform common tasks

Developed and maintained windows service using C#.Net, ADO.Net and SQL Server 2005

Designed and Developed WinForm for capturing applicant’s image from camera using WIA library, capturing E-signature using the third party signature pad and scanning and storing barcode using barcode reader using C#.Net, ADO.Net

Created state-of-the art reports using Cognos

Created Detailed Design Documents for various modules of the application

Responsible for manual testing and Unit testing of the applications to ensure all parts of the code behaves as expected application

Environment:

.Net Framework 2.0, ASP.Net 2.0, C#.Net 2.0, VB.Net, WinForms, SQL server 2005, Cognos Reports, VSS, AJAX, jQuery, IIS, HTML, MS Visio.

TNS Global, Hyd, India

Aug 2010 – Oct 2011

Application Developer

Project: Reports Central

Reports Central is a web based application hub which contains various campaign Reports like BellSouth, Davenport University, Capital One, Princeton. This application enables the upper level management users to view various campaign reports in different formats like summary-view, detail-view, chart-view, etc. It is a repository of reports which is made available to the user based on his role.

Responsibilities:

Conducted meetings with the various personnel on different levels of management to identify the potential data to be incorporated in the application

Normalized the data to enable faster fetching and searching of data

Designed and Developed user interface using ASP.Net, CSS, Infragistics, JavaScript

Developed business layer and data layer classes using C#.Net, ADO.Net

Created stored procedures and functions to generate reports using SQL Server 2000

Developed Web user Controls for application using C#.Net, ASP.Net, ADO.Net

Used Tree Control for displaying the hierarchy of reports

Designed various reports using Infragistics WebChart controls

Used Java Script for client side validation

Designed forms to upload reports to the desired location

Maintained existing Stored Procedures and responsible for data related issues

Responsible for unit testing of the application

Documented the technical specifications and user manuals for the application

Environment:

.Net Framework 1.1, ASP.Net 1.1, C#.Net 1.1, ADO.Net, SQL server 2000, Visual Source Safe (VSS) 6.0

Contact this candidate