Sql Server Data Developer .Net Application Web

**** ********** **, ******** ** - *****

Cell: 757-***-**** Email: ******.****@*****.***

7+ years of Industry experience and 5+ Years of experience of analysis,

design, implementation & maintaining multi-tiered web applications using

Microsoft Technologies

> Extensive Programming experience (5+ Years) in design and development

of multi-tiered web applications, Windows Forms.

> Developed .NET components, Controls in C# with SQL Server as backend

database.

> Worked in all phases of the Software Development Life Cycle (SDLC) -

Database modeling, Design, Coding, Debugging, Testing, Maintenance and

Documentation

> Very Strong knowledge in OOPS concepts, stored procedures, views and

user defined functions.

> Excellent Analytical, Technical, Communication and Interpersonal

skills

> Possess strong team building skills and competencies needed to analyze

problems, respond to changing needs, and forge strong working

relationships with peers and clientele

Experience / Background

5+ years - including extensive experience

C# with Web Forms/ Windows Forms/Controls, the

.NET Component Model, writing performance

optimized code, Object oriented design and

analysis, implementing data structures for

data retrieval, SQL / OLE Data Providers.

Worked on .NET Framework 1.1, 2.0, 3.5.

SQL Server 5 years of extensive experience in design and

development of relational databases,

triggers, stored procedures, views and other

database related tasks. Sql server 2000, 2005

and 2008.

ASP.NET 5 years - primary experience in developing

web forms, user controls, custom web

controls, business and data access layers for

multi-tiered web applications.

SQL Server Integration / Analysis 1.5 years of experience in Designing,

Services building SSIS Packages, SSAS Cubes,

Dimensions, and Hierarchies.

SharePoint < 1 year in building Web parts for SharePoint

sites and Administration

ORM Tools Nhibernate, Web service Software factory,

Subsonic.

Web NET Framework 1.1, 2.0, 3.5, Ajax, Web

Services, Web Parts, XML, HTML, JavaScript,

XSL, XSLT, CSS, ADO.NET, LINQ

EDUCATION:

Masters in Computer Science, Old Dominion University, Norfolk, Virginia

Bachelor of Engineering DSCE, Bangalore, India

AMF Bowling Inc, Richmond, VA: (11/06 - Present)

Role: Sr. Application Developer/Programmer Analyst/ETL Database Developer.

. AMF.Com Web Application: - A complete re-design and remodeling of the

existing company website.

- Part of the team the development of multi-tiered web application.

- Developed data access layer for interacting and collecting data from

the database.

- Built strongly typed collection classes for data binding.

- Built Generic factory classes to return collections depending on the

type.

- Utilized .NET 3.5 framework, C#, JavaScript, wrote complex stored

procedures and SSIS packages to import existing data from Data marts.

- Use of Ajax update panels for partial page updates, auto complete text

boxes for searches, use accordions for display, dynamic menus based on

role, Nested Master Pages and JQuery.

- Nested repeaters and grid views to display data.

- Utilized membership framework with forms authentication.

- Web services for integration data look up from the existing data

warehouse, and Group Smart application for easier access and booking

of lanes.

- Role based security using authorization module.

Environment/Tools: .NET Framework 3.5, C#, SQL server 2005, SSIS, T-SQL,

Stored Procedures, JavaScript, Ajax, Generics, query.

. Theoretical Cost of Sales (TCOS) Data Mart: - designed to replace the

existing TCOS process with a new data mart leveraging already existing

inventory system to provide corporate with a comprehensive

view/analysis/reporting capabilities by drawing comparison to the actual

cost of sales.

- Requirements gathering.

- Provided star schema database design.

- Loaded data from various sources like Csv files, Excel files, JDE, SQL

Server.

- Set up the Dev/QA/Prod environments, Historical and Incremental loads.

- Developed stored procedures, views, user defined functions and SSIS

packages.

- Created cubes, dimensions, calculated measures, SQL-Agent Jobs.

- Provided extensive unit testing, testing data for accuracy using Excel

2007, maintenance and enhancements.

- Technical documentation showing the interaction of different

components.

- Mentored junior developers in application and performed code review.

Environment/Tools: SQL Server 2005, SSIS, SSAS, T-SQL, BIDS, Excel 2007.

. AMF Data Warehouse: - New data warehouse developed to replace an existing

data warehouse in Hyperion Essbase used for generating reports (using

Crystal Reports), analysis of Data, Forecasting.

- Requirements gathering

- Set up the Dev/QA/Prod Environments

- Developed complex stored procedures, views for VLDB, Triggers.

- Loaded data from various sources like Csv files, Excel files, JDE, SQL

Server, and Essbase.

- Created custom Windows forms application for manipulating

(create/delete/edit/move) nodes in Hierarchies.

- Developed SSIS packages, created cubes, dimensions, SQL-Agent Jobs,

calculated measures, Data archiving, Log Shipping

- Performed extensive testing, maintenance and enhancements, and

periodic data extracts to business.

- Standardized Processes for deployment of packages using environment

variables and SQL server.

- Developed incremental solution for daily loads.

- Mentored junior developers in application and performed code review.

Environment/Tools: Excel 2007, SQL Server 2005, SSIS, SSAS, T-SQL, BIDS,

Windows Forms, C#

. Risk-Management Web Application: - A dynamic ASP.NET web application

designed to report unusual occurrences at centers such as theft, arson,

etc. The content of the WebPages can be changed dynamically using the

admin interface. Depending on the question and the answer type chosen,

the web pages load different server controls.

- Participated in the entire lifecycle of the project i.e., requirements

gathering, prototype development, detailed design coding, unit testing

using Mb Unit.

- Developed UI forms for various modules.

- Designed the multi layered architecture to be used for the web

application

- Designed the relation Database for the application, complex stored

procedures, user defined functions, cursors, views, Common table

expression (CTE).

- Created master Question repeater user control to display questions

with answer option dynamically based on date from database.

- Designed the Admin interface to modify/add/delete exiting questions

with answer types.

- Created Manager Classes in data access Layer to interact with Data

type layer.

- Created Web forms using Web Controls, User Controls, HTML Controls,

Master Pages, Wizard controls

- Used Nhibernate (ORM) to interact with the Database.

- Used My Generation Tool to create objects corresponding to the Tables

in the relational database.

- Used Modal pop up with grid views, auto complete text boxes, Update

panels and other Ajax controls / extenders.

- Reporting on submissions, Email generation using email templates.

- Used Java Script, JQuery, all types of validation controls for all UI

validations and auto calculations.

- Used CSS to apply style sheet.

Environment/Tools: NET 2.0, C#, Visual Studio 2005, SQL Server 2005,

Nhibernate, XML, ITextSharp PDF Generator, Ajax, MBUnit.

. Inventory Web Application: - ASP.NET application which automated manual

processes at every center reporting their monthly inventories to

Corporate which then manually entered/verified data and posted to the GL.

This multi tiered application was built using Web Services Software

Factory, ITextSharp for pdf generation and SSIS packages for posting to

the GL.

- Participated in the entire lifecycle of the project i.e., requirements

gathering, prototype development, detailed design coding, unit testing

using Mb Unit.

- Designed the multi layered architecture to be used for the web

application using Web service Software Factory.

- Designed the relation Database for the application, user defined

functions, stored procedures, views.

- Built SSIS packages for daily Invoice data load, Gl posting.

- Built Web forms using Web Controls, User Controls, Custom Controls,

HTML Controls, and Nested Master Pages.

- Used ITextSharp PDF generator to generate PDF documents using XML

files.

- Parsing of XML files to display items in web pages and PDF documents

depending on the center.

- ADO.Net to interact with database.

- Used Modal pop up, auto complete text boxes, Update panels and other

Ajax controls / extenders.

- Nested repeaters / Grid views to display data.

- Used Java Script / all types of validation controls for all UI

validations and auto calculations.

- Used CSS to apply style sheet.

- Created a detailed Technical documentation showing the interaction of

different layers and components.

Environment/Tools: : NET 2.0, C#, Visual Studio 2005, SQL Server 2005,

Web service Software Factory, Subsonic, XML, ITextSharp PDF Generator,

Ajax, Java Script.

. AD-JD Sync Utility: - A .net C# application with web services that reads

data from a SQL Server database representing JD Edwards and update Active

Directory user properties with that data, along with maintenance of self-

service user data maintained by users through the SharePoint user

interface and to help include specialized logic to allow AMF XMGR

accounts data to be maintained by this process as well.

- Participated in the entire lifecycle of the project i.e., requirements

gathering, prototype development, detailed design coding, unit testing

using Mb Unit.

- Designed the multi layered architecture to be used for the

application.

- Built Web services to pull data from SQL server and Web service to

insert in to Active Directory.

- Designed the relation database for the application, stored procedures,

and views.

- Parsed XML files to map table column names with AD attributes.

- Built SSIS packages for daily data load from JDE.

- Created C# class libraries and strongly typed classes, datasets.

- Utilized SharePoint User profile web service to access user profile

data.

- ADO.Net to interact with database.

- Scheduled SQL jobs to run the application nightly.

- Created a detailed Technical documentation showing the interaction of

different layers and components.

Environment/Tools: NET 2.0, C#, Visual Studio 2005, SQL Server 2005, Web

Services, Adsiedit, XML

. Group Smart Web Application: - A comprehensive web application for lane

booking, event bookings, lane mapping, report generation, quote

generation and food & beverage, lane and combo unit price manipulation.

This multi-tier web application developed on ASP.net 2.0 frame work, SQL

2005 and C#.

- Built new web forms for the admin feature to manage users, accounts,

profiles using the existing multi layered architecture.

- Performance tuning of stored procedures by analyzing the execution

plan.

- Optimization of pages for faster page loads.

- ADO.Net to interact with database

- Implemented error emailing module with stack trace to better trouble

shoot the problems real time.

- Performed bug fixes and enhancements, which involved design, coding,

testing, design review, code review.

Environment/Tools: NET 2.0, C#, Visual Studio 2005, SQL Server 2005, Web

Services, XML

Relocation Essentials LLC (March 2005 - Nov 2006)

Role: Mid -level Developer.

. Community Profile Report (CPR) Web Application:- A powerful online

relocation tool called CPR (Community Profile Report),which allows

Realtors in generating PDF reports for their customers based on the

location of the customer wishes to relocate to. The PDF report generated

includes Demographic, Climate, Cost of Living, Crime and Safety, Housing

and taxes and Education information based on the area of selection.

- Part of the team that designed the multi layered architecture to be

used for the web application.

- Built the Admin Module to manage users and their profiles, images,

themes, skins.

- Designed the relation database for the Admin application, user defined

functions, procedures.

- Utilized the membership framework, forms authentication and role based

authorization.

- Integration of the web forms VeriSign Pay Flow to accept online

payments.

- Created web forms using Web Controls, User Controls, and Custom Web

Controls.

- ADO.Net to interact with database.

- Worked with third party frameworks like Dundas charts and Dynamic PDF

to generate PDF documents with different metrics.

- Developed Image scripts to manipulate the HSL of images.

- Used Java Script / all types of validation controls for all UI

validations and CSS to apply style sheet.

Environment/Tools: C#, ASP.NET 2.0, ADO.NET, HTML, Java Script, SQL Server

2000, XML, Dundas Charts, Dynamic PDF

Calculators Web Application:- Developed a web based Calculator used for

calculating Mortgage payment, Pre-Payment plan, Rent vs. buy comparison,

Pre-qualification for mortgage. Display of data based on monthly and Yearly

schedules. This tool Displays graphs based on yearly and monthly schedules

using Dundas Charts.

- Part of the team that designed the multi layered architecture to be

used for the web application.

- Built base pages for using common functionality.

- Built user controls for headers and footers to enhance reusability.

- Utilized third party frame works like Dundas charts to display pie

charts and bar graphs.

- Used Java Script / all types of validation controls for all UI

validations.

- Used CSS to apply style sheet.

Impaq Corporation (Nov 2004 - Feb 2005)

Role: Application Developer / Intern

. Remodeling of LTD Management System website: Complete re-modeling of the

LTD management website which was earlier in PHP using Asp.Net and Sql

Server 2000. This involved the creation of base pages, user controls, UI

layer, business logic layer data access layer; use JavaScript for client

side programming

- Developed N-Tired application.

- Built base pages for accessing common functionality.

- Built user controls for headers and footers to enhance reusability.

- Embedded Flash for Movies and Images.

- Used Java Script / validation controls for all UI validations.

- Used CSS to apply style sheet.

Environment/Tools: C#, ASP.NET 1.1, ADO.NET, HTML, Java Script, SQL Server

2000

OLD Dominion University (Aug 2003 - November 2004)

Role: Research Assistant.

Application Casting (Java, Applets, Sockets)

Extensive Research and Development of Application casting a multi threaded

application, designed to transmit / capture a part or a user defined part

of the screen over the network using RTP protocol (RFC 1889), UDP Client

Server Model, developed algorithm capturing and transmitting change in the

pixels in a tile over Darwin Streaming Server using

Peer to Peer Application (Windows Forms, C#, XML)

Implemented client/server model interface using Windows forms in C#, has

similar features of Gnutella networks. Features like file sharing, download

and searching songs with friends are implemented. Joining a multicast group

is also implemented. Each searched file has Dublin core metadata displayed.

The interface supports play song; file delete, display

registered/unregistered users, rate the songs downloaded from each client.

Online Advising web Application (Asp.Net, XML, JavaScript's, SQL Server

2000)

Enhancement / Support for HCCG Application (Asp.Net, SQL Server 2000)

Contact this candidate