Manager .Net Sql Server Management Project Engineer

Deepak Sharma

Phone: 337-***-**** Email: *******@****.***

Summary

. Goal-oriented, highly motivated and experienced (10+ years) software

professional with a positive attitude that promotes a high energy and

high performance environment.

. Strong experience in developing enterprise class applications using

the .NET Framework, ASP.NET (3.x/2.0/1.x), C#, VB.NET, ADO.NET, AJAX,

ASP.NET MVC, Windows Services, Web Services, WCF, LINQ, Reporting

Services, XML, jQuery, JavaScript, CSS, MS-SQL Server, Oracle.

. Knowledge of Java technologies and environment including core Java,

JSP, EJB, Hibernate, MyEclipse, JBoss, Google Web Toolkit.

. Expert in Object oriented analysis & design (OOAD), Object Oriented

Programming (OOP) and design patterns.

. Excellent design/development skills using n-tier loosely coupled

architectures, Service Oriented Architecture (SOA), Web-based

environments and Client-Server architecture.

. Full software life cycle experience - analysis, design, coding,

testing, issue resolution, documentation, deployment and maintenance.

. Team player and problem solver with experience in successfully leading

teams, managing multiple projects and meeting deadlines.

. Fast paced and eager learner with excellent communication,

interpersonal, time management and presentation skills.

Education

. M.S. in Computer Science, University of Louisiana, Lafayette (ULL)

(GPA: 3.7/4.0 scale)

. B.S. in Computer Science & Engineering, Maharashtra Institute of

Technology, Aurangabad, India

(GPA: 3.6/4.0 scale, Passed in First Division with Honors,

University Topper in II, III and IV yr)

Skills

Operating Systems : Windows XP/Server 2003/2000/9x/NT, UNIX (Solaris, Linux),

MSDOS

Languages : C#, VB.NET, Java, VB, C++, C, LISP, Scheme, Pascal, FORTRAN,

MATLAB

Databases : MS-SQL Server 200x, Oracle, PostGreSQL, ObjectStore, MySQL,

MS-Access

Development Tools : Visual Studio.NET 200x, MS-SQL Server Management Studio, SQL

Server BI Studio, MyEclipse, JBuilder

Web Related : ASP.NET, ASP.NET AJAX, Web Services, WCF, Google Web Toolkit,

Skills ASP, XML, jQuery, JavaScript, CSS

Version Control : Team Foundation Server, Microsoft VSS, CVS, Rational

ClearCase, Subversion

Change/Issue : JIRA, Rational ClearQuest, Bugzilla, QuickBase, TestTrack Pro,

Management FootPrints

Graphics Tools : Adobe Photoshop, Paint Shop Pro, Paint.Net

Software Tools : Microsoft Visio, Cebos MQ1, Log4Net, Tortoise SVN/CVS, IIS,

Cisco VPN Client, SharePoint Portal Server, Lotus Notes,

Crystal Reports, MS-Office, Microsoft FrontPage

Professional Experience

Datum Software, Inc., Atlanta, GA

Jan '08 to Present

Senior Software Engineer/Senior .NET Architect/Technical Lead

License Management System (LMS)

License Management System (LMS) is an Asset Management System that manages

software licenses and terms for products developed by Datum Software. With

an increase in Datum's suite of products and clients, there was a need for

a system to manage all the different kinds of licenses (single-user/multi-

user/rolling/volume licenses) for each product. LMS addresses this need and

gives a dashboard like view of the customer-Product-License relation.

Responsibilities

. Worked with the stakeholders to gather, analyze and formalize

requirements and define the timelines.

. Designed and implemented the rich user interface using ASP.NET 3.5,

ASP.NET MVC, C#, ASP.NET AJAX, CSS, JavaScript, custom controls, user

controls, master pages and themes.

. Developed the web services to update (activate/de-activate/renew)

license status from the client locations.

. Designed the database schema and developed the Data Access Layer using

the Entity Framework (LINQ to Entities).

. Currently working with the QA team to fix bugs and resolve any issues

associated with the system.

Environment: ASP.NET 3.5, ASP.NET MVC, C#, LINQ (LINQ to Entities), ASP.NET

AJAX, CSS, HTML, JavaScript, Log4Net, Web Services, Visual Studio.NET 2008,

Team Foundation Server, SQL Server 2005, Bugzilla, IIS, Windows 2003

Server, Windows XP

SHERPA

Network Communications, Inc., Atlanta, GA

Network Communications, Inc. (NCI) is the largest national publisher of

local printed and online magazines for the real estate market. It

distributes more than 13 million magazines each month, representing 500

markets in the U.S. and Canada. SHERPA is a web-based Advertising

Management System for NCI's "The Real Estate Book" that allows advertisers

and agents easy and intuitive creation of advertisements and listings.

Responsibilities

. Designed and developed the Order Processing System for SHERPA using

C#, ASP.NET 3.5, custom controls, user controls, Enterprise Library,

AJAX, jQuery, CSS.

. Worked with the Enterprise Architect in generating the Data Access

Layer using Microsoft's Enterprise Library, CodeSmith and the

.netTiers Template.

. Worked with the Database Architect in designing and implementing the

data conversion tool to migrate data from the legacy system.

. Created several critical web-based reports for the management team

using the SQL Server Business Intelligence Development Studio and SQL

Server Reporting Services.

. Participated on Phase II requirements and enhancements, and production

support and maintenance.

Environment: ASP.NET 3.5, C#, jQuery, ASP.NET AJAX, CSS, HTML, JavaScript,

Enterprise Library, ADO.NET Entity Framework, CodeSmith, .netTiers Template

Library, .NET Messaging, WCF, Windows Services, Visual Studio.NET 2008,

Visual Source Safe, SQL Server Business Intelligence Studio, SQL Server

2005, SQL Server Reporting Services, JIRA, IIS, Windows 2003 Server,

Windows XP

Store Manager Reporting

Macy's Systems and Technology, Atlanta, GA

Macy's Systems and Technology (MST) serves as the technology hub of Macy's,

Inc. - creating, gathering and directing millions of pieces of data that

come together to form valuable management tools. MST provides an integrated

line of high-performance retail, e-commerce and data warehouse systems that

allow Macy's, Inc. to serve its customers, manage its internal processes

and track information in more ways and less time.

Responsibilities

. Managed the changes and enhancements to Store Manager Reports that are

a part of Macy's Reporting Suite.

. Designed the Store Manager Reporting enhancements architecture and

estimated project timelines.

. Managed changes to Teradata macros, Web Services and reporting user

interface to accommodate the Store Manager Reporting enhancements

within the allocated timeframes.

Environment: ASP.NET 2.0, C#, CSS, HTML, JavaScript, Web Services, Visual

Studio.NET 2005, Rational ClearCase, SQL Server Business Intelligence

Studio, SQL Server 2005, SQL Server Reporting Services, Teradata, IIS,

Windows 2003 Server, Windows XP

ViewPointe Index Update Manager (VIUM)

FiServ, Atlanta, GA

ViewPointe Index Update Manager is an index update system designed for

FiServ to facilitate in updating the ViewPointe archive with index

updates/corrections received from all the banks and financial institutions

under the FiServ umbrella. VIUM is a two part distributed solution with the

first comprising of highly scalable, multi-threaded C#.NET windows services

to watch for and convert proprietary and XML input files to a format that

ViewPointe accepts as input. The second part is a SOA enabled web interface

to monitor all the VIUM services running on any given instance, to monitor

the current status of any file currently being processed, generate detailed

reports and an administration section to manage all the configuration

parameters.

Responsibilities

. VIUM has played a key role in enabling FiServ to quickly migrate from

its legacy archiving system and address its customer needs. This

success has ensured a long term partnership between Datum Software and

FiServ.

. Performed a detailed analysis of the legacy FiServ archiving system

and ViewPointe archiving systems in association with the Business

Analyst and Project Manager to gather requirements for VIUM.

. Designed the entire VIUM architecture with respect to current and

future FiServ goals, infrastructure plans and security policies.

. Regularly interfaced with the client and followed the Agile software

development methodology (Extreme Programming) to ensure client needs

and changes throughout the lifecycle were met.

. Designed and implemented the object oriented, scalable and multi-

threaded VIUM windows services using C#, managed thread pool and web

services to communicate with legacy systems.

. Designed and implemented the web interface for VIUM using ASP.NET 2.0,

C#, XML Web Services, JavaScript, ASP.NET AJAX, custom controls, user

controls, master pages and themes.

. Designed and implemented the VIUM Data Access Layer using strongly-

typed custom objects to interact with the underlying Oracle database.

. Interfaced with the QA team and fixed bugs/issues associated with the

modules.

. Assisted in formulating the deployment procedures, release notes and

performed port-mortem analysis.

Environment: C#, ASP.NET 2.0, ASP.NET AJAX, CSS, HTML, JavaScript, Log4Net,

Team Foundation Server, Visual Studio.NET 2005, Oracle 10g, Oracle SQL

Developer, ODP.NET, QuickBase, Bugzilla, IBM WebSphere MQ, IIS, Windows

2003 Server, Windows XP

Datum Metrics and Training (DMAT)

Process improvement activities in Datum (CMMI Level 3, ISO 9001 and ISO

20000) warranted the need for a system to organize trainings, manage

training records and provide detailed reports. DMAT is a system that

coordinates these training activities and also captures organization and

project metrics to identify process improvements.

Responsibilities

. Worked in association with the Business Analyst and Project Manager to

gather and analyze requirements for DMAT.

. Regularly interfaced with the stake-holders and followed an iterative

software development approach to ensure requirement changes throughout

the lifecycle could be accommodated (through change requests).

. Designed and implemented the web interface for all the modules of DMAT

(including training section, project metrics, reporting and

administration sections) using ASP.NET 3.5, C#, JavaScript, ASP.NET

AJAX, master pages and themes.

. Designed and implemented the DMAT Data Access Layer using strongly-

typed custom objects to interact with the underlying SQL Server

database.

. Interfaced with the QA team to fix bugs and resolve any issues

associated with the modules.

. Assisted in deployment, preparing the release notes and performed port-

mortem analysis.

Environment: C#, ASP.NET 3.5, ASP.NET AJAX, CSS, HTML, JavaScript, Log4Net,

Team Foundation Server, Visual Studio.NET 2008, Microsoft SQL Server,

Bugzilla, IIS, Windows 2003 Server, Windows XP

Ness USA Inc, Canonsburg, PA

Jun '07 to Dec '07

Senior Programmer Analyst/Senior Software Engineer

FiServ, Atlanta, GA

FiServ is the market-leading provider of highly scalable and secure

Internet banking applications supporting over 25% of the online banking

users in the USA. The Professional Services division of FiServ is

responsible for building eFinance-enabling software for large financial

institutions all across the country and the globe.

Responsibilities

. Worked in a team environment to build efinance-enabling software for

the large financial institutions.

. Participated in client meetings, JAD sessions and presented opinions,

ideas and solutions.

. Developed the user interface layer using ASP.NET, ASP.NET AJAX, user

controls, custom controls and themes.

. Implemented the business layer classes using C# and data layer classes

using C#, ADO.NET.

. Developed the XML web services that enabled users to enroll into

online banking.

Environment: ASP.NET 1.1/2.0, C#, ASP.NET AJAX, CSS, HTML, JavaScript,

Visual Studio.NET 2003, ADO.NET, SQL Server 2000, Subversion, Tortoise SVN,

IIS, Windows 2003 Server, Windows XP

C & C Technologies, Inc., Lafayette, Louisiana

Jun '05 to May '07

Senior Systems Analyst/Technical Lead

Office Management System (OMS)

Office Management System is an intranet portal system that was developed to

cover the entire range of office management suites for C & C Technologies

including customer management system, equipment-inventory management

system, signal and inventory tracking system, time management system, sales

and contract management system, reporting services, etc.

Responsibilities

. Prepared a detailed requirement specification after extensive

meetings, user interviews and questionnaires.

. Developed the object model for the application, extensively identified

patterns and used use cases.

. Implemented user authentication and authorization by implementing

custom Membership and Role Providers. Also developed a Microsoft Azman

like Authorization Manager for the portal.

. Extensively used themes, skins, web parts and ASP.NET AJAX to provide

a rich UI experience.

. Developed the UI layer, service interface layer, business classes and

database interaction methods.

. Designed/developed the database, views, stored procedures and triggers

for the application using SQL Server 2005.

. Developed a custom error logging and viewing module that supports

logging in the database and XML files.

. Proofed the system against SQL injection attacks, cross-site scripting

(XSS) attacks and extensively used best security practices.

. Developed the XML web services that enabled OMS to interface with the

pre-existing legacy applications.

. Developed a strict standards compliant product to enable a smooth

multi-browser experience.

Environment: ASP.NET 2.0, C#, VB.NET, XML Web Services, CSS, HTML,

JavaScript, Telerik UI Controls, Visual Studio.NET 2005, ADO.NET, SQL

Server 2005, Microsoft VSS 6.0, Microsoft Visio, IIS, Windows 2003 Server,

Windows XP

AuthCode Manager

AuthCode Manager is a browser based application that was developed for "C-

Nav" - A division of C & C Technologies. C-Nav is a totally new concept in

GPS positioning, providing worldwide horizontal accuracy on the order of

0.1 meter. C-Nav sells GPS receivers and the activation/deactivation codes

to operate them. AuthCode Manager was developed to enable C-Nav managers

and personnel to view the details/status of the receivers and to send

activation/deactivation codes to clients from any location.

Responsibilities

. Enabled the C-Nav division to increase their revenue over 15% the

previous quarter and cut off the losses they incurred from human

error, maintaining legacy applications/spreadsheets, overdue client

contracts and activation codes, etc.

. Performed a detailed requirement analysis conforming to intricate

business practices and manager preferences.

. Developed web services that interfaced this application with the

legacy applications that generate the activation/deactivation codes.

. Developed the web services that retrieved receiver and client details

from Microsoft Dynamics NAV.

. Extensively used themes, skins and ASP.NET AJAX to provide a rich UI

experience.

. Designed/developed the database, stored procedures and triggers for

the application using SQL Server 2005.

. Completed the entire application within a very short timeline.

Environment: ASP.NET 2.0, C#, XML Web Services, CSS, HTML, JavaScript,

Visual Studio.NET 2005, ADO.NET, SQL Server 2005, Microsoft VSS 6.0,

Microsoft Visio, IIS, Windows 2003 Server, Windows XP

Verizon Information Services, Temple Terrace, Florida

Feb '05 to May '05

Senior Software Analyst

IT Asset Management (ITAM)

IT Asset Management is an n-tier system being developed by Verizon to

enable it to more effectively track and manage its IT assets. Computer

Associates' Argis is used as the central repository into which data from

all the stand alone systems is fed. The ITAM portal is being developed to

give users the ability to define metrics, view existing reports and create

dynamic reports based on criteria they select.

Responsibilities

. Performed an analysis of the ITAM portal developed by an offshore

team, identified shortcomings and proposed changes.

. Proposed changing the system from the current tightly coupled

Component Oriented Architecture into an n-tier loosely coupled Service

Oriented Architecture to ensure scalability and integrate web services

when needed.

. Developed a role based and data based security architecture for the

ITAM portal.

. Proposed design changes for the user management module of the portal

for ease in maintainability.

. Proposed incorporating reusable code blocks, such as .NET Enterprise

Library and User Interface Process Application Block, into the ITAM

architecture to ensure code reusability, future configurability and

maintainability.

Environment: ASP.NET, C#, VB.NET, Crystal Reports 10, XML Web Services,

CSS, HTML, JavaScript, Visual Studio.NET, ADO.NET, SQL Server, Microsoft

VSS 6.0, Microsoft Visio, SharePoint Portal, IIS, Windows 2000, Windows XP

Center for Innovative Learning and Assessment Technologies, Louisiana

Jan '02

to Jan '05

Senior Software Engineer/ Technical Lead

PASS-PORT

PASS-PORT is a web-based system designed for use at university colleges of

education with 4-year teacher preparation programs to gather and evaluate

performance data on undergraduate and graduate candidates. PASS-PORT

provides candidates a tool for the creation of standards-based portfolios,

a mechanism for sending and receiving feedback on portfolios, and

portability of portfolios to other universities and to state professional

development systems. PASS-PORT offers students, faculty and university

administration the tools needed to gather, track, evaluate and report

performance data on pre-service teacher candidates, satisfying the National

Council for the Accreditation of Teacher Education (NCATE) standards,

requiring institutions to have a viable performance assessment system.

Responsibilities

. Developed and integrated a data load tool for the application using

ASP.NET, VB.NET, XML and SQL Server.

. Developed an XML web service to provide important announcements,

system notices and news.

. Developed a data transfer tool for the application to transfer

student/teacher data from one university to another using ASP.NET,

VB.NET and SQL Server.

. Developed the user browser, vita editor, vita editor builder,

administrator modules, lookup modules and news module for the package

using ASP and VB.

. Developed the scripts for a browser sniffer.

. Modeled the entire database (E-R diagram) using Microsoft Visio.

. Developed teacher/student assessment reports using Crystal Reports

8.5.

. Developed field experience and Praxis data score reports using Crystal

Reports.NET.

. Completed the entire database documentation.

Environment: ASP.NET, VB.NET, C#, ASP, Visual Basic, XML, Crystal Reports

8.5, Crystal Reports.NET, CSS, HTML, JavaScript, Visual Studio.NET,

Microsoft Visio, ADO.NET, SQL Server, Microsoft VSS 6.0, IIS, Windows 2000,

Windows XP

Portfolio Mining Tool (PMT)

Portfolio Mining Tool is essentially an n-tier knowledge gathering tool for

PASS-PORT. It is an administrative tool developed for extracting portfolio

information across the PASS-PORT instances deployed statewide in the 21

universities of Louisiana. PASS-PORT in itself does not have the ability

to mine for candidates with certain qualities. PMT has been developed to

accomplish this.

Responsibilities

. Worked on the complete design and implementation of the tool under

strict time constraints.

. Designed and implemented the object model for the application using

Microsoft Visio.

. Designed an effective object based technique to transfer information

between frames.

. Developed the front end using ASP.NET, extensively used the .NET

Framework.

. Implemented all the business logic classes and the database

interaction methods using ADO.NET.

. Dynamically generated SQL queries using user inputs ensuring input

validation.

. Implemented all the SQL stored procedures for efficient transactions

with the database.

. Implemented a global error handler for the application.

Environment: ASP.NET, C#, Visual Studio.NET, ADO.NET, Microsoft Visio, CSS,

HTML, JavaScript, SQL Server, Microsoft VSS 6.0, IIS, Windows 2000, Windows

XP

SuperAdmin

SuperAdmin is an administrative tool developed to serve as a central

administrator for all the PASS-PORT instances deployed statewide in the 21

universities of Louisiana. It essentially serves as an administrator for

the 21 individual administrators. It includes features to track the users

and their profiles, track disk quota and usage across all the instances,

reports on various statistics and the ability to transfer a candidate and

all the related files and database dependencies from one instance to

another.

Responsibilities

. Worked on the entire design and implementation of the tool.

. Modeled the class structure for the application, extensively

identified patterns and used use cases.

. Developed the front end using ASP.NET, extensively used server

controls, validation controls and events.

. Implemented user authentication and authorization using forms

authentication and personalization.

. Developed web user controls and implemented fragment caching for the

required controls.

. Designed the database and developed SQL stored procedures to transact

with 21 different databases.

. Developed the complete reporting section using Crystal Reports.NET.

. Implemented a global error handler for the application.

Environment: ASP.NET, C#, Visual Studio.NET, ADO.NET, Crystal Reports.NET,

Microsoft Visio, CSS, HTML, JavaScript, SQL Server, Microsoft VSS 6.0, IIS,

Windows 2000, Windows XP

Various IT Projects as Senior Programmer/Software Engineer

Oct '99 to Jan '02

Contact this candidate