Asp.Net C#

Keyur Prajapati

ASP.net C# Developer /SQL Server

Ph. No: 732-***-****

**.*******@*****.***

Summary

. Over 3+ Years of Professional Experience with Microsoft .Net

Technologies and Microsoft SQL Server in Software Design, Development,

Testing and Implementation of Web Technologies /Client Server

Technology.

. Experience in all phases of SDLC coupled with enthusiasm to architect,

design and develop large-scale, complex, testable systems.

. Experience using Waterfall, Agile, Spiral, and other software

developmental methodologies

. Experience in web development using ASP, Visual Basic, COM/DCOM, DLL,

ADO, ActiveX, XML, XSL, HTML, DHTML, CSS, AJAX, TFS, JQuery, Java

Script .

. Expertise in developing web applications using Visual Studio.NET

2005/2008, ASP.NET 2.0/3.5/4.0 ADO.NET 2.0/3.5, C#, SQL

Server 2000/2005/2008.

. Expert knowledge of enterprise application development technologies

using .NET framework in the areas of performance, security,

scalability and extensibility.

. Experienced in developing Web Services using C#.Net, ASP.Net, SOAP,

XML and UDDI

. Extensively worked on SQL Queries, Stored procedures, Triggers using T-

SQL in MS SQL Server 2000/2005/2008/2008 R2.

. Experienced in working with LINQ to SQL, LINQ to XML and LINQ to

Dataset.

. Knowledge of Microsoft Office SharePoint Server 2007

(MOSS) configuration process, implementation.

. Knowledge of Windows Presentation Foundation (WPF), Windows

Communication Foundation (WCF), Silverlight and knowledge of Windows

Workflow foundation (WWF).Used Visual Source Safe (VSS) for source

control for applications.

. Building web applications with ASP.NET MVC, JavaScript, HTML, HTML5,

XHTML and CSS.

. Knowledgeable in Microsoft Product studio and TFS.

. Demonstrated in-depth knowledge of Test automation process including

requirement gathering, writing FS (Functional Specs), TDS (Test Data

Specifications) and Test automation process.

. Ability to work with source management tools like Subversion, Clear

Case, Team Foundation Server (TFS), Clear Quest, VSS, MKS and Mercury

Quality Centre / Test Director.

. Extensive experience in using all types of SQL Server Constraints, SQL

Server Database design, Database maintenance, developing Transact- SQL

queries, stored procedures, Indexes, CTE (Common Table Expressions) and

triggers using SQL Servers to facilitate efficient data manipulation and

data consistency.

. Experience across all phases of SDLC from project initiation to post-

implementation.

. Excellent knowledge in Dimensional Modeling, ER Modeling, Star Schema

/ Snowflake Schema, FACT and Dimensional tables

. Experience in ETL Processes. Worked extensively on data extraction,

cleansing/data integration, and loading from different data source

using SSIS.

. Create SSIS Packages using Various Transformation like Lookup, Derived

Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort,

Execute SQL Task, Data Flow Task, and Execute Package Task etc to

generate underlying data for the reports and to export cleaned data from

Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

. Experience in Importing/Exporting Data from various data sources like

Excel, XML and Flat file using SSIS utility. Involved in transformation

of OLTP data to the Data Warehouse using SSIS and SQL commands.

Education: Bachelor's in Computer Science & Engineering, Gujarat

Technological University, India.

Technical Skills:

C#, IIS, ASP.NET 2.0/3.0/3.5/4.0, ASP,MVC, AJAX, Visual Studio

2012/2010/2008/2005, ASP.NET Web Matrix, Front Page, ActiveX,

ADO, Agile, ADO.NET, HTML, DHTML, XML, CSS, SQL SERVER

2000/2005/2008/2008R2, Oracle 9i, MS-Access, Java script, Jquery, Classic

ASP. Crystal Reports, Microsoft Report viewer, Windows XP/Vista, Windows

NT, Windows 2000/2003/2008Server,MS SQL Server 2012/2008/2005/2000, MS SQL

Server Integration Service (SSIS), MS SQL Server Analysis Services (SSAS),

MS SQL Server Reporting Service (SSRS), T-SQL, SQL Server Management studio

(SSMS), MS SQL Server Index Tuning Wizard, SQL Profiler/Analyzer, ASP.NET,

C#, Team Foundation Server(TFS), JavaScript,MS Office (MS Visio, MS Word,

MS Excel, MS PowerPoint)

Professional Accomplishments:

Silvertech, Manchester, NH

May 2014 - Aug 2014

Dot Net Developer

SilverTech was selected by Pepco to design and develop their project.

Pepco, a subsidiary of Pepco Holdings, Inc. (PHI), delivers safe, reliable

and affordable electric service to customers throughout Maryland, Delaware,

New Jersey, and the District of Columbia. Project involved in developing

Customer Self Service NEM (Net Energy Metering) web site where customers,

contractors and GPC admin can create new NEM work request which will create

new work requests in Pepco work management system. All NEM request has two

parts, with the request being submitted to the Utility upon completion of

Part 1. After the Utility is finished its review and the Customer's

equipment has been installed and inspected, the Contractor can choose to

complete Part 2 of the request. They review data entry, attach their

inspection and submit Part 2 to the Customer. Customer review and submits

which updates work management system.

Responsibilities:

. Implemented application using MVC 5 and Razor. Created Model-View-

Controller architecture on page level

. Implemented Views in Razor code, Created Model class files for controls.

. Implemented controller classes responsible for handling user input and

responses

. Implementation of client side validations using J-Query and ASP.NET MVC

Validation implemented at Controller level.

. Implemented client side functionality using J-Query.

. Content show/hide using JavaScript

. Used web-services to pull XML data.

. Implemented partial page view for used on multiple pages

. Enum and look up table for Dropdown list controls

Environment: .NET FRAMEWORK 4.5, OOPS, C#.NET, Visual Studio 2013, TFS,

Agile Methodology, HTML, HTML 5.0, LINQ,MVC 5, Razor, WCF, IIS 7.0, CSS,

CSS 3.0, Java Script, J-Query, AJAX, WINDOWS 8.

State of Michigan, Lansing, MI Jul 2013 - May 2014

Dot Net Developer

The Department of Technology, Management and Budget promotes a unified

approach to information technology management and provides centralized

administration of services including auditing, budgeting, employee

resources, financial services, fleet management, mail, printing, property

management, purchasing, records management, and retirement services for

departments and agencies in the executive branch of state government

Responsibilities:

. Worked with Team Foundation Server for version control and project

tracking.

. Scrum meeting for gathering business requirement, Involved in all stage

of application development life cycle, follow OOPs concept for developing

an application.

. Write complex function for application in C# language, using various

object oriented features like classes, interfaces, inheritance,

polymorphism etc and asp.net.

. SQL Queries, SQL Joins (Inner Join, Outer Join)

. Extensive involve in analyzing business requirement and discussion with

business users.

. Involved in enhancement of existing system based on the business

requirements, database design and system analysis. Developed ASP.NET

Pages using C# and Server Controls. Extensive use of JavaScript for

client side validation. Involved in documenting bug reports and build

fixes.

. Developed GUI using .Net framework 3.5/4.0.and responsible for creating

components using C#.Net.

. Extensively worked with the java scripts and client side validations.

. Experience on Creating the Documentation for the Project.

. Responsible for supporting Web forms application and provide appropriate

solutions and fix the issue.

. Used AJAX to load controls dynamically for Disease specific and interview

specific based on parent control

. Creating pages and Maintain GUI for application.

. Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset,

Data table for consistent access to SQL data sources.

. Data Grid and Grid view for showing complex data from database

Environment: .NET FRAMEWORK 4.0, ADO.NET, C#.NET, Windows Server 2003,

Visual Studio 2010, SQL SERVER 2008R2,TFS, Agile Methodology, HTML, HTML

5.0, LINQ, WCF, IIS 7.0, CSS, CSS 3.0, Java Script, J-Query, AJAX, WINDOWS

7.

Dish Network Denver, CO

Sep 2012 - Jun 2013

ASP.NET

Developer

Dish is a web based document management system developed using .Net

Technologies. This system allows users to scan/upload the documents, full

document search, bar code recognition and optical character recognition

(OCR). Users can schedule the documents to trigger different types of

actions. Dish has a feature for accounting/HR departments to create

different types of workflows. It has ability to send emails/faxes and using

Dish web service it can integrate with any application. This system

provides an integration of search engine with Web server to provide uniform

interface for portal pages and the search engine.

Roles and Responsibilities

. Created several ASP.NET pages using ASP.NET, C#, ADO.NET, HTML, CSS,

LINQ, SQL Server 2008

. Designed User Controls for document upload, Comments Input, Multi

Select Dropdown, Risk Question Control etc which were used heavily

across the application

. Created Business Layer/Data Access Layer using C#, ADO.NET, LINQ, SQL

Server 2008

. Created WCF services to expose HLBVA data using C#, LINQ-SQL

. Created Stored Procedures/Functions/Triggers in SQL Server using T-

SQL.

. Designed and implemented the UI with extensive use of JavaScript,

JQuery Ajax.

. Designed reports using SSRS and called them in Web Application

. Worked on Performance related Issues in SQL Server database

. Consumed web services(WCF) created by Rule server application

. Developed WCF services to save/get the data for portfolio screen using

C#, LINQ

. Used CSS classes/skins for client side control UI formatting and

provide same look and feel throughout the application.

. Created SSIS packages to extract data from different Databases

. Used Microsoft Team Foundation Server for source repository and

version control.

. Started working on migrating ASP.NET application to ASP.NET MVC

application

. Created web application in ASP.net Web-forms, C#, LINQ-SQL

Environment: Web-forms, ASP.NET 4.0, C#, ADO.NET, HTML, CSS, Visual

Studio.NET 2010, T- SQL, XML, TFS, SQL Server 2008, AJAX

Control Toolkit, LINQ.

InDataa Pvt. Ltd., India June 2011 - July 2012

ASP.Net Developer

The development methodology uses My SQL Server as the back-end tool for

data warehousing and query processing while Active Server Pages (ASP.NET)

technologies is chosen as the front-end tool for developing the User

Interface elements in the system.

Roles and Responsibilities

. Extensively worked on SQL, ASP.NET and C#.

. Involved in Analysis, code development, code review, testing, bug-fixing,

preparation of program specifications and unit test plans, production

support.

. Analyzed and Prepared the Software Required Specification of the

programs.

. Designed and documented Functional and Technical documents using MS

Visio.

. Worked as a developer in creating different data object like Functions,

Stored Procedures, triggers, cursors, tables, and views and other SQL

joins and statements for applications.

. Involved in deployment, trouble shooting, problem solving and complete

application support.

. Responsible for interacting with the client, understanding their

requirements and implementing the necessary changes in the program

Environment: ASP.Net, C#, ADO.Net, SQL Server 2008 R2, Visual Studio .Net,

Visual SourceSafe, IIS, Windows.

References: Will be provided upon request

Contact this candidate