Sql Server .Net Manager Developer Management Software

Nitu Aggarwal

Mobile: 858-***-****

Email: ****.********@*****.***

Executive Summary

Microsoft certified professional with 7+ years of experience in requirement analysis, design, implementation,

testing and deployment of highly distributed scalable applications developed with Microsoft technologies.

Proficient in all phases of software development life cycle.

5+ years of experience in working with the various Net frameworks, Ajax framework, and Windows Workflow

foundation.

6+ years of experience in working with RDBMS - SQL Server (2000,2005), MySQL, Oracle

MOSS & SharePoint implementation, architecture and development subject matter expert.

Associated with creating new applications from scratch or rewriting or enhancing existing applications in the

public and private domains.

Creative problem solving and analytical abilities with excellent communication and interpersonal skills. Quick

learner and proactive team member with capability to work independently.

Technical Skills

Operating System: 2000/ NT / XP/Vista, Windows 9x, Linux, UNIX

Languages: VB.Net, VB, C#, C, C++, VC++, VJ++, UNIX, SQL

Scripting Languages: HTML/DHTML, VBScript, JavaScript, XML, XAML, XSL, XPATH, CSS, CAML

COM/DCOM, .NET Framework(1.1/2.0/3.0/3.5), ASP.Net, ASP,

ADO.NET/ADO/DAO, Web Forms, Windows Forms, Web Services, SOAP, AJAX,

Technologies: AJAX Control Toolkit, Remoting, Windows Workflow Foundation (WWF),

Windows Communication Foundation (WCF), Windows Presentation Foundation

(WPF), LINQ to SQL, Silverlight, JSP, JDBC, MOSS 2007/ WSS 3.0/SPS 2003

DBMS/RDBMS: MS SQL Server 2008/2005/2000, MySQL, Oracle 8i/9, DB2, Sybase, Access

Visual Studio (Interdev/2003/2005/2008), SharePoint Designer 2007, SQL Navigator,

Development Tools:

Front Page, Aqua Data Studio 6.0/4.7

Reporting Tools: Crystal Reports8.0/9.0/XI, Active Reports for .Net 2.0, SQL Reporting Services

Security & Role Provider: Active Directory, Authorization Manager

UML, Microsoft Visio, Source Gear Vault, MS Visual Source Safe, CVS, TFS,

Design & Version

StarTeam, Rational Requisite Pro, Rational Clear Quest, MS FxCop, HP Service

Control:

Manager

Web Server: IIS 4.0/5.0/6.0, Personal Web Server 4.0

Certifications

Brainbench certified .NET programmer

Microsoft certified in SQL Server 7.0. Mar, 2000

Microsoft certified in NT Server 4.0. Jan, 2000

Employment Experience

Sr. Staff Engineer, LPL Financial San Diego, CA Aug’ 2008 – Till Date

Environment: Visual Studio 6.0/2003/2005/2008, ASP.Net 3.5/3.0/2.0/1.1, ASP, HTML/ DHTML, C#, VB, VC++,

COM, SQL Server 2000/2005/2008, Aqua Data Studio 6.0/4.7, SQL, DB2, XML/XSS, JavaScript, AJAX, Adobe

Acrobat 8.0 Pro., Crystal Reports XI, MS Office 2005, StarTeam 2005, TFS, MS Virtual PC 2007, HP Quality Center

9.2

Responsibilities as Level 2 Problem Management (L2PM) Developer:

Perform root cause analysis of application issues.

San Diego, CA 858-***-**** (Mobile) ****.********@*****.***

Identify the RC of problems and initiate activity aimed at establishing workarounds or permanent solutions to

these identified problems.

Apply reverse engineering for the RCA.

Using recorded problem and incident data, perform trend analysis to predict future problems and enable

prioritization of problem management activity.

Help with whatever needed like testing for SQL injection, writing scripts for data fix/ correction, urgent fixes.

Maintain good understanding of the technical direction of IS department and LPL systems, standards and best

practices.

IT Software Engineer, Nextwave Wiresless San Diego, CA Jan’ 2008 – Aug’ 2008

Environment: VS2005/2008, SQL Server 2005, Crystal Reports XI, MS Visio, MS Office 2007, MOSS 2007, WSS

3.0, SharePoint Team Services, MS SharePoint Designer 2007, InfoPath, Active Directory, Windows Workflow

Foundation

Responsibilities:

Installation, Configuration and administration of small server farms and stand alone MOSS web sites.

Developed portal and content management application using custom site definition, Site Template

Customization, Site Definition Customization, Content Management, Collaboration, custom feature

development, and custom web parts.

Used personalization, branding, content types, Excel Services.

Developed and implemented custom workflow forms using InfoPath and custom workflows.

Extensively used C#, XSLT, CAML, SQL, JavaScript, CSS, Master Pages.

Design, develop, troubleshoot and debug software and scripts for internal IT applications.

Develop software tools including utilities, databases, and network-related software applications.

Analyzes and determines system software test standards and procedures.

Monitor end-user usage of services offered proactively and provide systematic metrics to management.

Participate in intra-departmental meetings representing IT Software Engineering.

Provide third tier support for internally IT developed software.

Consultant, State of Illinois, Springfield, IL Sep’ 2007 – Dec' 2007

Project: Liheap - Low Income Heating Energy Assistance Program. The Liheap is a federally-funded program

(intranet website) to help eligible low income households meet their home heating and cooling needs.

Environment: ASP.Net 2.0, Ajax Extensions, Windows Workflow Foundation, Biz Talk Server 2006, Ajax Control

toolkit, Web Services, Infragistics, VB 2005, C#, ADO.Net, VS 2005 Team Edition, XML, SQL Server (2000, 2005),

Active Reports for .Net 2.0, Crystal Reports XI, JavaScript, CSS, HTML, Vault

Responsibilities:

Owner of Address Book piece which is the database of contact information of all agencies/intake sites.

Involved actively in all phases of project development

Fully analyzed, designed and coded significant components of the user interface screens.

Developed SQL stored procedures, views, and triggers to perform CRUD operations.

Used Update panels and Ajax controls to minimize post backs and enhance user experience.

Configured the website to use ASP.Net 2.0's Active directory membership provider to authenticate users.

Used ASP.Net2.0's Role Manager (Authorization Manager) provider to authorize user access.

Used new ASP.Net 2.0 data bound controls (Grid view, Form view, SQL Data source and Object data source)

and Infragistics web controls for data access and manipulation.

Used ASP.Net 2.0 Validation controls and client side JavaScript to perform front-end validation at the browser

level.

Implemented on demand print functionality to view and print reports from within the Liheap web interface.

Sr. Consultant (.Net Technologies), Deloitte for State of Pennsylvania, Harrisburg, PA Aug’ 2006 – Aug' 2007

Project: CWDS - The CWDS Project is a partnership among all the Workforce Agencies of Pennsylvania's

Departments of L&I and DPW to create a shared data system for tracking and reporting services provided by the

agencies to effectively coordinate services to Pennsylvania's job seekers, employers and training providers.

Environment: Visual Studio 2003, SQL Server 2005, Crystal Reports XI, Business Object Client, MS Visual Source

San Diego, CA 858-***-**** (Mobile) ****.********@*****.***

Safe, MS Visio, Rational Requisite Pro, Rational Clear Quest, MS FxCop

Responsibilities:

Served as a mentor, assisting other developers.

Participated in technical Code Review of Framework and code written in C#, VB.net, JavaScript and SQL.

Owner of a component responsible to handle all correspondence by the application.

Worked on Data Access Layer, Business Logic Layer, and Presentation Layer.

Written tables, look-up tables, stored procedures, views, triggers.

Validated client and server side code using CSS, Master Page, JavaScript and Validation controls

Used Data Grid control and various custom controls to display data from the database

Extensively generated various reports using Crystal Reports.

Performed troubleshooting, debugging and Integration testing

Strictly followed corporate and industry practices to meet the software quality Standards.

Consultant, Citi Financials, Warren, NJ Aug’ 2005 – Jul’ 2006

Project: projectCES - Citi Financials is a leading financial services firm which specializes in wealth management,

investment banking and asset management. Citi Financials has a wide range of domestic and international customers

and has both individual and corporate clients. ProjectCES is aimed at developing an automated, web based, secured

client server loan and credit approval system which interacts with the other line of businesses to retrieve information in

order to make a decision. ProjectCES is focused on enhancing the corporate clients’ experience.

Environment: ASP.NET, C#, ADO.Net, JavaScript, CSS, COM, SQL Server, IIS 5.0, Windows XP

Responsibilities:

Actively involved in requirements gathering and Use Case development

Worked on Data Access Layer, Business Logic Layer, and Presentation Layer using ASP.NET, C#.NET,

ADO.NET and SQL Server 2000

Developed stored procedures, triggers, views to manipulating the database

Validated client and server side code using CSS, JavaScript and Validation controls

Used Data Grid control and List control to display data from the database

Maintained security of the application using .net security mechanisms and state of the web application using

session management

Developed Web services using C# to interact with other Business layer

Performed troubleshooting, debugging, Unit and Integration testing

Worked as administrator for Share Point Servers in creating and setting user access levels.

Technical Consultant, Adventist Healthcare, Rockville MD

Project: Newborn Hearing Screening Test (NHS) Aug’ 2004 – Jan’ 2005

Adventist HealthCare is a network of healthcare providers that includes hospitals, home health agencies, nursing

centers, and other healthcare services.

Description: Intranet system tracks the information of the babies hearing screening test results, risk factors, and missed

reasons.

Environment: ASP.NET, C#, ADO.Net, JavaScript, SQL Server 2000, IIS 5.0, Windows 2000.

Responsibilities:

Developed and validated web pages using ASP.NET and C#.NET. Used CSS to enhance the look and feel of

web pages.

Developed Web Services in order to interact with business components.

Used ADO.NET extensively for data retrieval, querying, storage and manipulation.

Written stored procedures for data manipulation and querying from SQL Server.

Created generic data access classes in Data Layer for SQL Server using C#.NET.

Created Web User Controls, Custom Controls using ASP.NET.

Reports were generated using Crystal Reports and implemented using ASP.NET, C#.

Project: MediLink Oct’ 2003 – Jul’ 2004

Aimed at upgrading the legacy system to VB.NET. MediLink provides patients tools that allow them to become active

participants in their own healthcare by on-demand self scheduling appointments, forms completion from home, etc. It

also helps physicians by having online complete patient health history and information, online physician/ referral, etc.

San Diego, CA 858-***-**** (Mobile) ****.********@*****.***

Environment: Visual studio.Net, ASP.NET, VB.NET, SQL Server, ADO.NET, T -SQL, XML, Visual Source Safe

6.0, Crystal Reports, Jscript, Windows XP

Responsibilities:

Developed Business Logic layer by implementing the OOPS concepts in generic manner.

Designed and developed Web Application using ASP.NET and VB.NET as code behind language.

Written different ASP.NET application for retrieving the user information and displaying the results

Developed data access layer using VB.NET and ADO.NET to define and implement secure middle -tier

components using disconnected architecture

Involved in the logical and physical design of Relational database design using SQL Server 2000

Extensively worked on the stored procedures and functions by considering the performance concurrency

Implemented input validation using the ASP.NET Input Validation Controls

Data displaying, editing, sorting and adding new records using Data Grid

SW Developer, Appin Knowledge Solutions, Delhi India Jan’ 2002 – Sep’ 2002

Project: Tax Deduction Software

Developed Taxation SW for PricewaterhouseCoopers Pvt. Ltd.(PwC). PwC is India’s largest Tax and Advisory

Firm.

Calculates TDS, Surcharge, total tax amount, checks for errors, generates 1040EZ, 1040A, and 1040 forms, can backup

and restore data.

Environment: Visual Basic 6, Seagate Crystal Reports 7.0 and SQL Server 7.0

Responsibilities: Responsible for the implementation and testing of the full SDLC of the application and Post

Implementation support.

SW Developer, Padmini Ltd., Delhi India Mar’ 2001 – Dec’ 2001

Responsible for the automation of the various applications in Padmini Appliances which is a leading group of

companies engaged in manufacturing and supplying Home Appliances.

Project: Complaints Handling - used for recording and handling of all complaints for all the products in all the

companies. Tracks complaints handled, pending and attempts made. There are different search options, various reports.

Project: Invoice Package - required studying the existing invoicing system and upgrading the software as required by

the company accountant and the new sales procedure. The software system managed invoicing to distributors, issuing

Credit/Debit notes, maintaining their accounts, transferring data to warehouses, monthly and yearly closing procedures.

Environment: Visual Basic 6, Seagate Crystal Reports 7.0 and MS Access

Responsibilities: Responsible for the implementation and testing of the full SDLC of the application and Post

Implementation support.

Counselor/ Faculty, NIIT Ltd., Delhi India Sep’ 2000 – Mar’ 2001

Worked (part time) as student/ educational counselor.

Conducted classes for MS Office, DOS, HTML, C++.

Technical Education

Sun Certified Java Programming, SSI Limited, New Delhi, India.

Web Page Programming, NIIT Ltd., New Delhi, India.

Program Quality Management, NIIT Ltd., New Delhi, India.

3 yrs Advanced Diploma in Network Centered Computing, NIIT Ltd., New Delhi, India.

Education

Masters in Commerce/ Accounting, Himachal Pradesh University, India

Bachelor in Commerce/ Accounting, Delhi University, India

Advance Diploma in French Language, Delhi University, India

San Diego, CA 858-***-**** (Mobile) ****.********@*****.***

References

Available upon request.

San Diego, CA 858-***-**** (Mobile) ****.********@*****.***

Contact this candidate