SUMMARY

• Having 9+ years of professional IT experience in the areas of Design and Development of high scalable Multi - tiered Web Applications using Microsoft Technologies primarily using ASP.NET, C#, SQL Server, MVC, WCF in Energy, Insurance, Health Care and Banking/Financial domains.
• Completed Microsoft certification exam 070-515 Web Applications Development with Microsoft .NET Framework 4.
• Completed Microsoft certification exam 070-461 Querying Microsoft SQL Server 2012.
• Technical expertise in Microsoft Technologies, such as .NET Framework (2.0/3.0/3.5/4.0 ), ASP.NET, MVC 3.0/4.0, C#, Web Services, WCF, LINQ, Entity Framework, IIS, SOAP, XML, DOM, XSL, XSLT, HTML, Java Script, Visual Studio.Net 2010/2008/2005 , AJAX, ADO.Net.
• Very strong experience in Designing, Development and Maintenance of Database applications using SQL Server 2012/2008R 2/2008/2005.
• Involved in all phases of Software Development Life Cycle.
• Good experience in using third party controls like Telerik, DevExpress.
• Have good experience in Reports Development using SQL Reporting Services (SSRS).
• Good experience on Relational Database Management Systems (RDBMS) Concepts with strong experience in Database Design and Programming using SQL Server.
• Expertise in scripting DDL, DML, T-SQL (Complex VIEWS, Stored Procedures (SP), Functions, Triggers and Indexes).
• Strong experience in Web based pages and site design using HTML, XHTML, CSS, Themes, Master Pages, Site Map, XML, XSLT, JavaScript and Ajax.
• Expertise in Developing web forms, web controls, user controls and validation controls in ASP.NET.
• Implemented ADO.NET data access techniques i.e. SQL Connection Objects, SQL Command Objects, Data Set Objects, Data Reader Objects and Data Adapter Objects using Data Grid, Data List and Repeater Controls.
• Hands-on experience with WCF(Windows Communication Foundation)
• Good experience and understanding of Database Design, Relational Integrity Constraints, OLTP and OLAP.
• Proficient in developing all types (Tabular, Matrix, List, Drill-Down, Drill-Through, Sub-Reports, and Chart Reports) of Complex Reports using SQL Server Reporting Services (SSRS).
• Experience in Implementing Dynamic Grouping, Sorting & Page Breaking using SSRS Parameters.
• Experience in Extraction, Transformation and Loading (ETL) in SQL Server database using SQL Server Integration Services (SSIS).
• Good Experience in Creating and Scheduling Jobs for SQL Server Database and SSIS packages using SQL Agent.
• Good Experience in Tuning SQL Queries by implementing Indexes.
• Expert in troubleshooting/resolving SQL Reporting services and SQL related issues.
• Experience with versioning tools like Team Foundation Server, SVN, Serena Dimensions and Visual Source Safe.
• Experience in Software Development Life Cycle (SDLC) including requirements gathering, writing technical specifications and Production support/Maintenance Activities.
• Good Experience in Agile Methodology and Water Fall Methodology.
• Self-starter and quick learner with strong analytical and problem solving /troubleshooting skills.

TECHNICAL SKILLS

Microsoft.NET: NET Framework 4.0/3.5/3.0/2.0 , ASP.NET, MVC 3/4/5, Entity Framework, ADO.NET, Web Services, WCF, XSLT, XSD, UDDI, WSDL, IIS 7/6, SharePoint 2010

Databases: MS SQL Server 2012/2008/2005 , MS Access, Oracle 10g

BI Data Warehouse Tools: SSRS, SSIS

Languages: T-SQL, C#.Net, PLSQL

Scripting: Javascript, JQuery

App. /Web Servers: IIS 5.0/6.0

Reporting/ETL: SSRS, SSIS, Power Pivot, Report Builder and Crystal Reports

Platforms/OS: Windows 98/2000/2003/ XP/NT/Vista, Windows 7, Windows 2003 Enterprise Server

Protocols: HTTP, TCP, FTP, SMTP, SOAP

Version Control Tools: VSS, Team Foundation Server, JIRA, SVN and Serena Dimensions

Others: SQL Server Data Tools, BIDS, SQL Server Management StudioVisual Studio.Net 2005/2008/2010 , MS Access, MS Excel, MS Word, VB Micros, FTP and Share Point, TELERIK, DevExpress, TeamCity

PROFESSIONAL EXPERIENCE

Confidential, OH

Sr.Net Developer/Lead

Responsibilities:

• Implemented and extensively used the Object Oriented programming concepts in C# and ASP. Net
• Used ASP.NET User Controls to create wizard steps for a step by step process of insurance quote generation.
• Developed the independent WCF (Windows Communication Foundation) services and defined Service Contracts, operation Contracts, Fault Contracts and Data Contracts for specific functionality to gather information of the tools.
• Used Telerik and ASP.NET controls extensively in developing the new web pages.
• Used XML intensively to bind the data to the web controls, data manipulation and to store data and sent as parameter to the stored procedures.
• Implemented Serialization and De-serialization of objects.
• Involved in handling ASP.NET client side state management (view state, cookies and query strings) and server side state management (application state and session state).
• Developed partial post back validations to manipulate data on web pages using AJAX.
• Created and maintained SSRS Reports for the top management reporting purposes.
• Interacted with BA and Business in gathering/clarifications on Specification Documents.
• Implemented Dynamic Grouping, Sorting & page breaking through parameters for all new SSRS Reports.
• Excellent T-SQL Developer skills including Stored Procedures, User Defined Functions, Triggers, and Distributed Transactions.
• Imported data from Excel sheet and loaded onto SQL Server using import export wizard.
• Designed and Developed complex SSRS Reports (sub reports, dynamic grouping/sorting).
• Used Ajax model popups, calendar and other controls extensively throughout the application.
• Implemented some functionalities using custom code for SSRS reports.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Scripted complex Stored Procedures, Views and Functions for developing reports.
• Implemented best practices both in SQL Scripting and RDL Designing.
• Involved in immediate attention production issues.
• Involved in developing Process Document for the smooth running of the project.

Environment: C#, MS Visual Studio 2012, .NET Framework 4.5, JQuery, Telerik, Java script, Ajax, MS SQL Server, SSRS, ASP.NET 3.0, HTML5, ADO.NET, XML, SOAP, Web & RESTful, IIS 7.0, Web services, WCF, WSDL, TDD, TFS 2012.

Confidential, MD

Sr Software Engineer

Responsibilities:

• Involved in the requirements gathering and client meetings.
• Involved in full Software development life cycle (agile methodology).
• Responsible for documenting the technical specifications in multiple iterations of the project.
• Designed, modeled and architected multi-threaded, enterprise n-tier software agent using Windows Communication Foundation (WCF) service hosted in a Windows service to support Distributed computing.
• Worked with the team to develop the Web Services that is used to fetch data or to submit the document and processing it.
• Developed WCF Services for creating and consuming business components in ASP.NET
• Designing WCF with Service oriented architecture to support Distributed computing where services consumed by end-user.
• Implemented JQuery in the frontend.
• Utilized database components (Data Adapter and Data set) to access database using ADO.NET.
• Used LINQ to SQL in the data layer for rapid development of few standalone projects
• Implemented various features like Partial classes, Anonymous types, Read-Only Properties, polymorphism and inheritance ofC# inbuilding data entity model.
• AJAX and JSON along with JavaScript libraries to established for presentation layer.
• Coded and created Stored Procedures for performing repetitive tasks in updating related tables using-SQL Server 2008
• Worked extensively on Client Side Validation using Java Script.
• Extensive use of XML features of T- SQL for maintaining xml data based on XPath queries. Reading XML documents and storing data in the relational database using various methods.
• Used JQuery and JSON to develop a modular approach that allows the creation of powerful and dynamic WebPages and web applications.
• Applied Cascading Style sheets (CSS) to the pages.
• Developed XML Web Services usingTechnology and utilized WSDL, SOAP for transferring data in XML format.
• Developed Custom User Controls to reduce the Complexity in User Interface Coding and provide better look and feel.
• Understand the work flow of the (SOA) application and make the changes in application pages to in corporate the editing.
• Responsible for interaction with the client in collecting the requirements.
• Involved in Unit, Integration and load testing. Well-coordinated with testing department.

Environment: Visual Studio 2008/2010, ASP.NET 3.5/4.0, C#.NET, VB.NET, ADO.NET, WEB SERVICE APIs,MSMQ, AngularJS, LINQ to SQL, SOAP,WSDL,SQL Server 2008, WCF Restful Services, XML, IIS 6/7.5, CSS, SSRS, JQuery, Bootstrap, WPF, XAML, TFS, VSS, DevExpress

Confidential, MN

Sr Software Engineer

Responsibilities:

• Introduced and implemented Agile methodologies such as Scrum and Test Driven Development (TDD).
• Involved in requirements elicitation from clients for product design and enhancements.
• Designed and implemented application using .NET Framework 4.0
• Actively involved in developing web applications using ASP.NET, C#, MVC and VisualStudio.NET.
• Created new Views, Controllers and Models and maintaining the existing application.
• Used AJAX and the third party Telerik controls for adding rich features to the application.
• Used ADO.NET for Data accessing. Upgrading the modules into Microsoft.NET (C# .NET, VB.NET and ASP.NET) and created a web services.
• Created Procedures, Functions, Indexes and Views using SQL Server.
• Scripted complex Stored Procedures, Views and Functions for developing reports.
• Maintaining database consistency with DBCC at regular intervals
• Implemented Error handling through Try-Catch, Common Table Expression (CTE), Ranking Functions.
• Used ASP.NET MVC Page Controller pattern to add functionality to individual pages such that to accept input from the page request, invoke the requested actions on the mode.
• Created WCF Service to lookup and retrieve the data from database.
• Involved in developing WCF service using SOAP/HTTP to communicate.
• Developed Java Scripts for dynamic user interface and browser compatibility tests.
• Worked on SSRS 2008 to generate over 40 reports for various user and developer groups.
• Written stored procedures and SQL statements to access data from SQL Server 2008 Database.
• Involved in preparing System Test Cases, User Acceptance Test cases and Bug Fixing.

Environment: C#.NET, VB.NET, Visual Studio 2010, SOA, SQL Server 2008R2/2005, Telerik, ASP.NET, MVC 4, JQuery, ADO.NET, HTML, IIS 6.0, SSRS, SSIS, Web services, WCF, WSDL, SOAP, JavaScript, CSS3, XML, XSLT, XSD, UML Windows 2008 Server, TFS 2012.

Confidential, Harrisburg, PA

Sr Software Engineer

Responsibilities:

• Working on Detail System Design (DSD/HLD) with agile environment.
• Coding the Data Access Layer, and Business Logic Layer using C#.NET
• Develop Master Pages and Themes using C#.NET to create a consistent layout for the pages
• Developed service contract, operation contract & data contract classes to support communication between Agents to Insure.NET using Service Oriented Architecture (SOA) through WCF web services through C#.NET.
• Used Ajax, JQuery, JavaScript, CSS and various web controls to present data to users in a much comfortable environment.
• Model View Controller (MVC) pattern is used to design this layer.
• Developed Custom Controls and Navigation controls using C#.NET and configured the caching policies
• Analysis, Design and Development of Core Financial Screens using ASP.Net, C#.Net
• Working on Work Items in Team Foundation Server (TFS)

Environment: s: .Net 3.5(ASP.Net, C#), MVC, WCF, Oracle 10g, Toad, PL/SQL, Crystal Reports, Visual Studio-2008, AJAX, CSS, HTML, JavaScript, XML, TFS, IIS 6.0, Windows Server 2003/ Windows XP

Confidential

Software Engineer

Responsibilities:

• Collected all the requirement specifications of input data
• Analyzing and understanding the Crystal report functionality
• Analyzing the approach in which SSRS report should be developed
• Implementing the same functionalities in SSRS reports which is there in crystal reports
• Developed web applications using ASP.NET, C#, ADO.NET and VisualStudio.NET.
• Used ADO.NET for Data accessing. Upgrading the modules into Microsoft.NET.
• Achieving things through work around which are not directly supported in SSRS
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and SQL JOINs.
• Designed and created VIEWS for security purposes, implemented rules, defaults, and user defined data types.
• Extracted data from Excel sheets and flat files and moved onto Database using SSIS.
• Created Packages to Migrate data from different Data Sources to Data warehouse.
• Created SSIS Packages by using advanced tools (i.e. Lookup, Derived Columns, Condition Split, Aggregations and etc...).
• Created SQL Server Reports using SSRS 2005 for the Business.
• Status Reporting
• Involved in preparation of User Interface Specification document.
• Developed GUI front end Web Forms in C#.
• Used Presentation Layer as CSS which allows customization of layout, color based on the user selection using XSLT, XML and CSS.
• Deployed developed reports on to the clients portal for the end users.
• Supported 24/7 for the production system for post deployment Reports on the server.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Fixed all the issues provided by the end users.

Environment: Windows XP, SSRS, SSIS, ASP.NET, C#, ADO.Net, Web Service, Visual Studio.NET 2005, SQL Server 2005, HTML, XML, CSS.