Sql Server .Net

Darshana Gor

Phone: 404-***-****

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

Career Objective

To achieve a responsible position, that gives me scope to apply my knowledge and skills, be a part of a team that dynamically work towards success and growth of the organization.

Professional Summary

About 12 Years of experience in Analysis, Design, Development, Documentation and Unit Testing of various applications with involvement in all stages of Software Development Life Cycle (SDLC)

Expertise in developing Windows and Web Applications using Visual Studio .NET

Worked in different domains like: IT, Automobile and Telecommunication domains

Experience in Client/Server Application development using Web Forms

Good Hands-on experience with Entity Framework (Version 1)

Extensive experience working with C#, VB.NET, ADO.NET, ASP.NET, Web Services, Java Scripting and SQL Server Programming

Experience in Visual Studio 2003/2005/2008/2010, MS SQL Server 2000/2005/2008

Experience in writing complex SQL Queries, creating Stored Procedures, Triggers, and using Normalization Techniques, Views, Joins and Indexes

Have participated in full life-cycle development using (OOP) Object Oriented Programming concepts

Experience in .NET Framework 1.1/2.0/3.0/3.5 and ASP.NET

Knowledge of .NET Framework 3.0/3.5 with WPF, WCF, Silverlight, LINQ (Lambda Methods and Procedures)

Proficient in working with applications based on 3-Tier Architecture and n-Tier Architecture

Experience in developing Web services in .NET using XML and SOAP

Good knowledge of OOPS programming techniques in C# and C++

Extensive experience in using State Management Techniques both Server and Client side

Expertise in using ADO.NET objects such as Connection Object, Command Object, Data Reader Object, Dataset Object and Data Adapter Object

In depth knowledge in HTML, XML, XAML, AJAX, XML Web Services & Security in ASP.NET

Expertise in migrating ASP/VB to ASP.NET/VB.NET/C#.NET

Extensive Experience in database programming using ADO.NET

Expert in creating User Controls and using Third-party controls like Data Grid.

Experience in using CSS (Cascading Style Sheets) and Skins and Themes

Involved in utilizing Microsoft Visual Source Safe(VSS), SVN and Team Foundation Server(TFS) for Version Control

Experience in working with MVC and Model-View/View Model architectures

Experience working with offshore team.

Highly organized and efficient to prioritize and manage multiple tasks

A team player with excellent interpersonal, communication, and presentation skills

Technical Skills

Framework Technologies

ASP.NET, ADO.NET,ASP

Programming Languages

C#.NET, VB.NET, HTML, DHTML, XML, C, C++, VB

Scripting Languages

JavaScript, VB Script, AJAX, Jquery

Application Severs

IIS 6.0/7.0

XMLRelated Technologies

XML, XSL, XSLT, Xpath

RDBMS

SQL Server 2000/2005/2008, SQL Server Analysis Services 2008, SQL Server Integration Services 2008, SQL Server Reporting Services 2008

Database Access Tech

ADO.NET, OLEDB and ODBC

UML and E-R Modeling Tools

Microsoft Visio, UML, Design Patterns

Development Tools

Visual Studio .NET 2005/2008/2010, VMWare

Report

Crystal Reports.Net/8.5/8.0,SSRS

Operating System

Windows 95/98/2000/2003 server/2007 Professional, Windows NT

Version Controls

VSS, TFS, SVN

Functional Skills

Management and Leadership Skills

Leading Team, Project analysis, Estimation and Execution.

Education

Degree

University/Institution

Year

Bachelor Of Engineering(Computers)

Mumbai University (India)

2001

Certifications

Degree

University/Institution

% of Marks

MCTS

Microsoft

96

MCP

Microsoft

93

Professional Experience

Aidant Technologies, Atlanta, GA Oct 2016 Feb 2017

Role : Programmer Analyst

Project: Data Interchange

This product helps small, medium and large businesses to integrate with their Trading Partners with quick and easy to use tool-kits, accelerators and platforms. These tools are interoperable On-premise, Off-premise and On-cloud. This product also has Client Interface which contains non technical business related view like Purchase order, Purchase order response, Invoice.

Responsibilities:

Participated in Business Requirements discussion and Architecting, Designing, Developing and Testing of the Application.

Worked to refractor the existing Web application code.

Developed new web pages as well as User Module.

Worked on Writing Stored Procedures in SQL Server 2014.

KForce, Atlanta, GA Jun 2015 Feb 2016

Role : Programmer Analyst

Client : Turner Broadcasting INC

Project: Momentum Workflows for MOC

The system will take care of figuring out which content needs to be ingested by querying external systems, and raise a job on Momentum to get it done by guiding the Operators and Supervisors on each step of process. This will allow for a better way of managing the complexity of these workflows by splitting them into manageable steps, many of which can be automated.

Responsibilities:

Worked Closely with Application Architect and designed the application.

Developed Windows Service to fetch the data from different sources.

Developed web forms using ASP.NET and used Third Party Controls for rich User Interface design.

Worked on Writing Stored Procedures in SQL Server 2014.

Environment: C#.Net, ASP.Net, Visual Studio 2013, ADO.NET, SQL Server 2014 and XML

Pyramid Consulting INC, Atlanta, GA Feb 2013 May 2015

Role : Program Analyst and Application Support Specialist

Client : Verizon Wireless

Project: WAA -BAA

OnDemand derivation of customer incentive to the sales representative based on Customer Usage, History and Company sales offerings. This was done to earn higher customer satisfaction, retention.

Responsibilities:

Worked Closely with Application Architect and designed the application.

Developed web forms using ASP.NET and used Third Party Controls for rich User Interface design.

Worked on Writing Stored Procedures, Functions and Triggers in SQL Server 2008 and 2010.

Used SVN to Log the work and maintain the same code along with all developers.

Extensively Used Java Script for client side Validation purposes and Jquery,CSS.

Worked to migrate classic ASP pages into ASP.Net

Environment: VB.Net, ASP.Net, Visual Studio 2010, Visual Studio 2008, Visual Studio 2005,ADO.NET, JQuery, SQL Server 2008, SVN, Java Script,, CSS and XML

Automobile Protection Corporation, Norcross, GA Oct 2010 Jan 013

Role : Application Developer

Project: ECO

This is an ongoing implementation of the company’s data-centric web application to manage all aspects of the business which includes dealership management, agency management, rate management and claim management.

Responsibilities:

Teamed with architect and DBA together, Designing, Developing and Testing of application

Worked Closely with Application Architect and designed the application as well as database using SQL Server 2008R2.

Developed Application using MVC 3.0 Framework

Used C#.NET for Code behind, Model layer for business logic, Control layer for User logic of application.

Extensively Used Jquery

Implemented data access layer and business layer to retrieve and update entities (dealership, agency, customer, web user, etc) and their contact information (address, email, phone, etc.) using Entity Framework 4.0, C# 4.0, and LINQ to Entity.

Used TFS (Team Foundation Server) to Log the work and maintain the same code along with all developers.

Extensively Worked on Agile and Scrum methodology.

Environment: C#, ASP.Net, MVC 3.0, Visual Studio 2010, ADO.NET, JQuery, SQL Server 2008, entity Framework 4.0

Cybage Software PVT. LTD. India Jan 2006 Dec 2009

Role: Sr. Software Engineer

Project: OptOut, ALM, Pitcher, DMT, Experience Framework, Solid PDF Server

OptOut Aug 2008 – Dec 2009

Client: Microsoft, Redmond

This is an outlook add-in to exclude people from the distribution list, without removing them from DLs. People who have requested to opt out from the future email messages are passed to an opt field. It adds verbiage at the end of the mail body including the list of original recipients as well as excluded email addresses. It also provides a preview feature before sending the mail.

Environment: MS Outlook Exchange, VBA, VSTO

ALM (Application Life-Cycle Management) Jan 2008 – Aug 2009

Client: Microsoft, Redmond

This application provides comprehensive assessment that helps companies understand their ALM/development processes and capabilities, as measured against industry standards or peers. This assessment is vendor agnostic and will serve as a basis for conversations with customers that will lead to a roadmap for improvement, and will help identify the most critical solutions required in the short-term.

Environment: ASP.Net, C#, .Net framework 2.0, SQL Server 2005, IIS 6

Pitcher Jul 2007 – Nov 2007

Client: Microsoft, Gurgaon

Microsoft had launched a campaign to promote the use of authenticated software. This application was designed to provide an automated system to record all the customer responses in the campaign. This tool was being used by a third party organization to handle responses of the campaign. This tool also provides different kind of reports to analyze the valued customers and priorities them which helps increasing the revenue and minimize the software piracy. Developed various SSIS packages to fetch/upload the data from Microsoft Staging server.

Also hosted several reports on Reporting server to analysis and prioritizes the data using SSRS.

Environment: ASP.Net, C#, .Net framework 2.0, SQL Server 2005 (SSIS, SSRS), IIS 6

DMT (Demand Management Tool) Jul 2006 – Aug 2007

Client: Microsoft, Redmond

DMT (Demand Management Toolset) was developed as a tool (work flow based web tool), to support the business processes, that will support the decision making process from capture, through assessment and prioritization of enhancement requests across the Microsoft eXperience and MXPS organization group. This tool provides a single source of information that then forms the basis for assessing the relative benefits, costs, and risks required to effectively and efficiently prioritize and allocate available resources to maximize the return on investments.

Environment: ASP.Net, C#, .Net framework 2.0, SQL Server 2005, IIS 6

Experience Framework Apr 2006 – Jul 2006

Client: Microsoft, Redmond

This product was developed to provide a centralized data repository and toolset which allows MEDPG group of Microsoft to make product decisions depending on customer’s feedback. The input sources to the system could be customer site visits, usability studies, end-user and partner surveys etc. All the input data gets aggregated into Experience trees to provide a means of viewing and tracking end-to-end experiences.

Environment: ASP.Net, C#, .Net framework 2.0, SQL Server 2005, IIS

Solid PDF Server Jan 2006 – Mar 2006

Client: Voyager Soft LLC

This product was developed for providing a platform for converting PDF file(s) to various formats like, MS Word, RTF etc. This also supports extraction of tables from PDF file to MS excel format and extraction of images from PDF files to image files. It also provides email facility where output files can be sent to the pre-configured email ids.

Environment: ASP.Net, C#, .Net framework 2.0, SQL Server 2005, IIS, Install Shield Devstudio 9.0, SQL Server 2005 Query Analyzer, SQL Profiler

Responsibilities:

Involved in designing, developing and testing for the above projects mentioned.

Worked as Team Lead for OptOut & Pitcher project.

Extensively worked with asp.net webforms.

Developed User Controls for several search screens which were used throughtout the project.

Implemented Client-Side and Server-Side validations in several pages.

Developed a datagridview which can implement data binding source.

Used typed data sets as data sources for UI layouts.

Extensively used GridViews with sorting and paging

Written complex stored procedures to retrieve data.

Also used dynamic sql to grab information for dynamic search criteria.

Also used View State to save value of variables through page.

Written design documents for every task and User Story checked-in.

Did Code Reviews for colleagues.

Worked with several Web Server Controls like DataGrid, ListView, CheckBoxList, DropDownList, panel, placeholder, Image Button, LinkButton etc.

Designed wireframes for the project using Microsoft Visio.

Attended meetings with Business Managers to gather requirements, show updates on the wireframes and get suggestions accordingly.

Attending Scrum meetings and Sprints.

Updating daily Work-Log, reporting previous day work done and today’s tasks to be done at daily scrum.

Logged number of hours worked and remaining on every task assigned to me in VSS.

Created tables and maintained relationships as per architect’s design.

Created tables and Stored procedure for the application modules in SQL SERVER 2008

Involved in debugging, analyzing critical application issues by looking at the logs and other connectivity.

Provided Production Support

Handled many production issues and Resolved various critical issues during maintenance

Lauren Information Technologies Pvt. Ltd. India May 2004 –Jan 2006

Role: Programmer

Project: ROS, Pfizer Optima V2

ROS Dec 2005 – Jan 2006

Client: DHL, South Africa.

The application was intended to automate the daily transactions made with customers in terms of Cash, Cash-Cards and Gold. There were various kinds of reports supported by the application which were used by senior management to analyze the business position.

Environnent: ASP.Net, VB.Net, ADO.Net, Java Script, HTML, SQL Server 2000, IIS.

Pfizer Optima V2 Apr 2005 - Nov 2005

Client: Pfizer, New Zealand

This project was developed to manage all the transactions done by Sales Representatives of the company with the customers (Hospitals, Medical Stores etc.). The application was also keeping track of all the orders taken by individual Representative as well as their personal records. There was facility in the application to manage online Calendar for the appointments of the Representatives.

Environnent: ASP.Net, VB.Net, ADO.Net, Java Script, HTML, SQL Server 2000, IIS.

Roche Diagnostics Mar 2004 – Apr 2005

Client: Roche, Mumbai

This project was developed to automate the complete Inventory management process of the company. The different modules in which, I was involved were Sales, Purchase, and Warehouse.

Environnent: VB 6.0, Java Script, SQL server 2000.

Responsibilities:

Used N-tier architecture for presentation layer, the Business and Data Access Developing the

Application using VB.NET

Involved in Programming Business Objects, UI Design and Unit Testing

Developing Stored Procedures using SQL Server 2000

Involved in User Interface Development

Updating or retrieving data from database using ADO.NET

Written stored using SQL in SQL SERVER 2000.

Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.

Corcomp Infosystems. Ltd. India Apr 2003 - May 2004

Role: Trainee Programmer

St.Angelo’s Computer Ltd. India Dec 2001 - Dec 2003

Role: Center Manager

Contact this candidate