Sql Server .Net Service Data Business Project

Location:

7950

Posted:

March 23, 2010

Contact this candidate

Resume:

SUMMARY

. **+ years of hands-on experience in System Analysis, design, development

and deployment of applications using Microsoft technologies, including

.NET Frame work 2.0/3.5, VS2005/VS2008, VB.NET, C#, ASP.NET, IIS 6.0,

AJAX, Web Service, WCF, XML/XSL, SQL-Server 2005/2008.

. In-depth experience in System Analysis & Design, Coding, Testing and

support of multi-tier / Enterprise applications.

. 9 years of experience in developing web applications using .NET framework

2.0/3.5 with C#, VB.Net, ASP.Net, Web User Interface Design, HTML, Java

Script, AJAX, ASP and VS2008/VS2005 IDE.

. Extensive experience with RDBMS (MS-SQL Server 2008/2005 & Oracle 9.x).

. Experience in database design using Normalization rule and creating

database schemas.

. Extensive experience in writing stored procedures, triggers, functions on

SQL Server 2005/2008.

. Extensive experience in implementation of full SDLC using methodology

like Agile, RAD, Waterfall & Spiral Model.

. Worked on various domains: Finance, Telecom, Government, and Retail.

. Superior record of delivering large-scale, mission critical projects on

time and budget.

. Strong analytical, trouble shooting, performance tuning and decision

making skills.

. Ability to quickly grasp business processes and conceptualize development

modules for implementation.

. Mentored & supervised development teams.

TECHNICAL SKILLS

Web Technology: .NET Framework 2.0/3.5, C#, ASP.NET, VB.NET, ADO.NET, Web

Services, WCF, AJAX Toolkit 2.0 /3.5, OOPS, OOD, HTML,

JavaScript, CSS, Themes and VBScript.

Application Servers: IIS 5/6

Operating Systems: Windows 2000/NT/2003/XP

RDBMS: SQL Server 2008 / 2005, T-SQL (DDL, DML), Database design,

Functions, Stored Procedure, Triggers, SSRS, Data

migration, Oracle 8i/9i, PL-SQL.

Reporting Tools: Microsoft Reporting Services (SSRS)

Version Control: Visual Source Safe, CSV, VSVN, Subversion

Testing: Prepare UTP, ITP & UAT test cases.

Tools/Others: MS Visio 2003, SDLC, Use Case, Sequence Diagram, Payment

Gateway Integration, Infragistics web controls, Software AG

EntireX 7.3, Component One WebGrid 1.1/2.0, Active

Directory.

EDUCATION: BS in Computer Science and Mathematics

CERTIFICATION: Microsoft Certified Solution Developer (MCSD)

PROFESSIONAL EXPERIENCE

BIT, Dept. of Sanitation, City of New York, NY

Lead Programmer/Analyst Apr 09 - present

Projects:

> DSNY Common Platform

> Complaint System

> Operator Detach System.

Responsibilities:

. Analyzing business requirement

. Designing the enterprise framework and web application architecture for

DSNY Common Platform.

. Developing class library, Proxy, Service & Data Access layers using OOPS

and .NET Framework 3.5

. Developing web service for Security & Email.

. Implementing Authentication & Authorization using forms authentication in

web applications.

. Designing Web User Interface using C#, ASP.NET, JavaScript, AJAX, HTML

and CSS.

. Developing Dashboard using data grid with paging, sorting & search

functionality.

. Converting of legacy systems into web based enterprise application.

. Designing SQL Server 2008 database for the system's backend data

processing

. Developing Stored Procedure, User Defined Function & triggers

. Implementing workflow for the application.

. Developing User Controls.

. Developing reports using SSRS and integrated with ASP.NET page to view

reports.

. Participating in Data migration from Mainframe, Data ease and other

legacy systems.

. Generating PDF outputs for various forms and send as email.

. Developing maintenance portal for User Profile & applications

maintenance.

. Unit testing and Integration testing of application and data migration.

. Generating scripts and documentation for deployment.

Environment: OOPS, .NET framework 3.5, ASP.NET, C#, Web Service,

JavaScript, AJAX, SQL Server 2008, SVN.

Department of Citywide Administrative Service, City of New York, NY

Lead Programmer/Analyst Jan 07 - Apr 09

Projects:

> Online Application System

> HRA Resume Automation

Responsibilities:

. Interacting with business users to gather and analyze functional

requirements

. Developing Use Cases, Proof Of Concept & Prototype.

. Building flowcharts, Sequence diagrams, data flow diagrams (DFDs) in the

requirements gathering and design stage of the Software Development Life

Cycle (SDLC) for project implementation using Visio.

. Designing n-tier distributed architecture using Object Oriented Design

. Developing the portal using RAD/Agile methodology. The portal was

implemented in 4 phases with several smaller iterations.

. Developing one-way hashing to encrypt user password using SHA256 with

salt. The encrypted password and the salt were stored in database to meet

the security policy.

. Developing web service to communicate between presentation layer and the

business layer to support the web farm environment were Web servers were

on DMZ and App servers behind firewall on local LAN.

. Integrating payment service provider 'Skipjack' to the portal for

payments using credit and debit cards.

. Developing an automated daily reconciliation process to reconcile all the

missing credit card transaction.

. Using Software AG's EntireX Broker, developed data access layer to

access/modify data from Mainframe database (CA Datacom DB).

. Developed web user interface using VB.NET, C#, ASP.NET and JavaScript

using VS2005

. Implementing AJAX toolkit extender controls to enhance user interface.

. Designing database using SQL Server.

. Developing Functions, Stored Procedure and triggers in SQL Server 2005

. Developing Unit Test Plan and Integrated Test Plan and assisted QA team

in load testing of the portal.

. Assisted App scan team to scan the portal for security vulnerability and

implemented the recommendations.

. Developing Health monitoring service to check availability of service on

all servers and send information via email if any of the service is down.

. Developing Alert & escalation mechanism for the portal to send out alert

via email for critical errors.

. Pro actively anticipated and addressed project obstacles during design &

development phase

. User support, Code review and ongoing code maintenance.

Environment: OOPS, .NET framework 3.5, ASP.NET, VB.NET, C#, EntireX, Web

Service JavaScript, AJAX, SQL Server 2005, CA Datacom DB and distributed

architecture in web farm environment using load balancing switch between

web servers and app servers and state management using windows services.

Prudential Financial, Newark, NJ

Lead Programmer/Analyst Oct 06 - Dec 06

Project:

> Broker Dealer - Compliance Performance Measurement (BDCPM)

Responsibilities

. Developing Prototype.

. Designing 3-tier architecture using OOD.

. Developing class library, Business & Data Access layers using OOPS and

.NET

. Used Microsoft Enterprise Data Access Application Block to access data

from SQL Server.

. Developing web interface using C#/ASP.NET in VS2003 IDE.

. Designing and developing with object oriented approach.

. JavaScript programming & XMLHTTP Request for AJAX.

. Designing SQL Server database using normalization rules.

. Writing Functions, Stored Procedure for data access using T-SQL in SQL

Server 2000

. Writing triggers for data audit trails using T-SQL in SQL Server 2000

. Testing different Modules and their functionality before and after bug

fixes for regression testing.

. Version control using Visual Source Safe (VSS)

. Preparing Release scripts documentation.

Environment: OOPS, .NET framework 1.1, ASP.NET, VB.NET, SQL Server 2000,

JavaScript & AJAX

Coach Inc, NYC

Lad Programmer/Analyst Apr 06 - Sept 06

Projects:

> Retail Finance Forecasting Tool (RFFT)

> Ultimate Time & Attendance (UTA)

Responsibilities

. Developing Prototype.

. Preparing System Design Documents.

. Developing class library, Business & Data Access layers using OOPS and

.NET

. Developing web interface using C#/ASP.NET in VS2005 IDE.

. Designing SQL Server database using normalization rule.

. Using Microsoft Enterprise Data Access Application Block to access data

from SQL Server.

. Writing Stored Procedure for data access using T-SQL in SQL Server 2005

. Writing triggers for data audit trails using T-SQL in SQL Server 2005

. Using Component One Web Grid 2.0 for display of data in tabular format.

. Developing and Integrated Active Directory Security module for

authentication and authorization of user.

. Developing GUI interface for Search/Add/Update/Delete user from Active