Developer .Net Business Sql Server Project Manager

[pic][pic]

ARPANA MAHINDRU

*** - *** - ****

abnef4@r.postjobfree.com

SUMMARY OF QUALIFICATIONS:

> Over 8 years of experience in IT Industry with involvement in all the

stages of Software Development Life Cycle including Requirements,

Analysis and Design, implementation, integration and testing, deployment,

maintenance and Offshore Coordination.

> Over 8 years of experience in .NET application using ASP.NET, C#.NET,

ADO.NET, LINQ, MVC[Model View Controller], CMS[Content Management

System], AJAX, JSON, Silver Light, WCF, Web Handler, Web Services,

Delegates, XML, XPath, Java Scripts, JQuery and Framework 2.0/3.5 with n-

Tier Architecture

> Experience in database designing and implementing relational database

Microsoft SQL Server 2000/2005, Oracle9i/8i

> Extensively worked on RDL reports while exploring various features like

Grouping and Sub-Reports for various projects using SQL Server Reporting

Services [SSRS] and Crystal reports

> Developed complex SQL Server Integration Services (SSIS) and Data

Transformation Services (DTS) packages

> Experience in Continual Integration using Cruise Control and NANT

> Experience in Multi Threaded Application

> Extensive experience in front end designing using CSS, JavaScript and

JQuery

> Experience in working with PL/SQL programming, writing SQL Queries,

Stored Procedures, Functions, Views, Cursors, Packages and Database

Triggers.

> Knowledge of Oracle utilities such Toad, PL SQL Developer, SQL Loader.

> Extensive working knowledge of MS-SQL, Views, Stored Procedure, Triggers

> Extensively worked on RDL reports and RDLC reports while exploring

various features like Grouping and Sub-Reports for various projects using

SQL Server Reporting Services and Crystal reports

> Proficient in Unified Modelling Language (UML) and object Oriented

Analysis. This involves developing Use Case diagrams, Class diagrams,

Interaction diagrams and State diagrams

> Experience in developing of n-tier applications using Microsoft Visual

Studio (2003 and 2005) and IIS web server (IIS 5.0/6.0)

> Debugging applications and finding defects.

> Experience in Manufacturing and Retail domains.

Excellent Team Building, Project Management, Analytical, Interpersonal &

Communication Skills

Educational Qualifications

> Bachelor of Technology with specialization in Computer Science, Punjab

Technical University, Jalandhar, Punjab, India

> Microsoft Certified Professional, Cleared Developing Windows application

using C#.net (exam code 070-316)

> Oracle PL/SQL Developer Certified Associate, Cleared Program with PL/SQL

(exam code IZ0-147) and Introduction to Oracle 9i SQL (exam code IZ0-007)

certification exam.

Technical Skills:

Programming Languages : C#.NET, VB.NET, AJAX, JQuery, JavaScript,

VBScript, HTML, T- SQL, Unix Shell

Programming, Pro*C, C, C++, SQL, PL/SQL,

Informatica 7.1

.NET Technologies ASP.NET, ADO.NET, LINQ, WCF, Silver Light MVC[Model

View Controler], Web Handler, Web Service, .Net

Framework 2.0/3.5, Design Patterns, RESTFul

services

XML Technologies : XML, XSD, DOM, XPath, XQuery and XSLT

Concepts : Object Oriented Analysis and Design (OOAD), UML

Software products Microsoft Visual Studio 2005/2008, Crystal Reports,

SQL Reporting Service, TOAD, Control M, Cruise

Control,NANT

Database : SQL Server 2000/ 2005, Oracle 9i/10g

Source Control Sub Version[SVN], Visual Source Safe[VSS] and Serena

(ChangeMan DS)

Web Server IIS 5/6

Others : MS Office, CSS

Operating Systems : Windows and UNIX Family

PROFESSIONAL EXPERIENCE:

Client Name - Fedex Jun 2009 - Current

Collierville, TN

Project - Ship Manager / Ship Engine / Caf

Role - Programmer Analyst

Ship Manager gives shipping solution for both hardware and software. This

application is Windows based and also web based as you can track your

shipment online. It supports Windows XP, 2000, and Windows Server 2003.

This application is used for International and Domestic shipping services.

It delivers a seamless shipping process and provides shipment processing

within more than 200 countries worldwide as international services and for

domestic shipping services within US and Canada. Customers use the shipping

labels and printer provided by company to ship International and

Domestic. Upon registration and installation of the software, all required

and necessary downloads and uploads take place, thereby giving customers

everything they need, including new software, services, and shipping rates.

The software solution is more prevalent in a front office environment.

Integration Assistant allows customers to integrate with their backend

order management and accounting systems for easier and more efficient

exchange of information.

Responsibilities:

> Involve in developing and designing all type of forms in visual studio

2005 and 2008. Develop and implement class objects using C# as code

behind language.

> Responsible for developing generic data access layer using ADO.NET,

Generics, Interfaces and custom attributes

> Involved in UI Design, class diagrams, writing white papers, help

files, and project flow.

> Implemented the complex Logics using C#, XML Datasets, stream reader

and writer classes, extensive use of Data Grid View and using LINQ to

XML.

> Involve in using Web services, .net remoting, WCF and COM components.

> Creating and implementing new classes and methods.

> Writing edits and cleaning classes written by other developers to

enhance performance.

> Implementing business logic according to SRS.

> Responsible for developing web handlers for displaying Images

Asynchronously on web pages.

> Reading data from .dat, .csv, .txt and .xls files using stream reader

> Loading from data files into xml datasets and populating into user

friendly data grid view where user can navigate to any record and can

edit, insert, delete, cancel and save records according to privileges

assigned.

> Writing edited records into same file in same format, using stream

writer.

> Testing and solving defects catch by testing team.

> Involved in retrieving data using ADO .Net with C#, Worked with the

database using ADO, ADO.NET and used Data Readers, Data Adaptors and

Datasets.

> Creating/modifying RDLC files reports.

> Performance tuning of application using ANT's Performance profiler

4.0

> Implemented client side validations using C#.

> Also work with Sybase database and SQL Anywhere.

Developed a separate application for FedEx. Implement Data source, Data

Grid, Data sets, XML serialization, Stream reader and writer using Visual

Studio 2008 with C# as code behind language. This application is used for

developer training.

Environment:

Visual Studio 2005 and 2008 .NET Framework 2.0, 3.0 and 3.5, LINQ,Window

Forms, Team Foundation Server 2008 (TFS), C#, Star Team, Sybase 9.0 and 11,

ADO.NET, Datasets, XML, XSLT, RDLC (Report Definition Control), Web

Services, IIS 6.0, Windows API, CSS, Mercury Quality Center, Windows XP,

2000 and Windows Server 2003, ANT's Performance profiler 4.0

Client Name - AKQA Dec 2008 - May

2009

San Francisco, CA

Project - VisaGo [www.Go.Visa.com]

Role - Senior .Net Developer

AKQA is an independent, ideas-led agency that exists to help its client

lead in digital age.

Visa Go is the campaign project run by VISA, it's an ASP.NET public web

application through which user can search the best offer they can avail

using Visa Card, explore new ideas and best ways to use visa cards.

AKQA has developed the Internal Moderation and publication tool for Visa

using Microsoft .Net latest technologies, C#.net, SQL Server 2005, there

are several API's involved mainly are Flicker API for GoSaic and Razorfish

API for GoSave and EyeWonder API for GoEplore sections. Using Moderation

tool client can directly pull image from Flicker, import XML file and

Images provided by Razorfish / EyeWonder, update / approve the content and

then publish the content to AKAMAI Servers

Responsibilities:

> Understanding and documenting the Business Requirements

> Holding sessions with Business Users and providing solutions for

implementation of the business processes.

> Developed Use Case diagrams, Class diagrams, Interaction diagrams and

State diagrams using UML 2.0.

> Coded business library using Linq to XML and Collections to parse the

XML feed provided by Razorfish and Eye Wonder

> Coded generic classes to download Images Asynchronously from Flicker,

Razorfish and Eye Wonder

> Written complex logic to download only latest contents for Flicker

using Flicker API

> Coded multi threaded classes to save images to database and download

same to folder

> Developed Data Access layer using LINQ to SQL to manage bulk inserts

updates in SQL Server 2005

> Developed complete object relational model using LINQ

> Written complex preview and publishing tool to publish contents to

AKAMAI server

> Developed REST Service using WCF to handle RESTFUL requests

> Developed web handlers for re-sizing and displaying images on webpage

> Used JQuery and AJAX to handle Asynchronous requests to import data

and save images

> Developed User Interface to bulk update and insert contents

> Designing Database table structure to save the xml contents and Images

> Developed DTS and SSIS packages with complex transformation to import

/ export data from the flat file into database

> Coding and development of Master Pages, web forms and Business logic

using MVC design framework

> Developed XAML files using Silver Light to have videos and Shaded

Images on Forms

> Used Validation Controls to validate the input data using validation

Controls

> Writing complex queries, Stored Procedures and Triggers in SQL

Environment:

C#.NET,ASP.Net Framework 3.5, LINQ to [SQL, Collections and XML], JQuery,AJAX, CSS, Silver Light, AJAX, JSON, MVC, Web Handler, WCF Rest Service,

Web Services, T- SQL, SSRS,SSIS,UML 2.0, IIS 6.0, Visual Studio 2008, SQL

Server 2005

Client Name - AKQA May 2008 - Dec

2008

San Francisco, CA

Project - VisaGo [www.Go.Visa.com]

Role - Senior .Net Developer

MethodHome.com [Redesign 3] is the e-commerce ASP.NET public Web

application that is used to shop safe and non-toxic biodegradable products

like "all purpose cleaner", "bathroom cleaner" etc. MethodHome is developed

using ASP.NET Technology [LINQ, MVC, WCF, Silver Light, Web Handler, Web

Services, .NET framework 3.5} N2 CMS, Blog Engine, Flash integration and

SQL Server 2005 as database.

Responsibilities:

> Understanding and documenting the Business Requirements

> Holding sessions with Business Users and providing solutions for

implementation of the business processes.

> Creating a control environment using Subversion to keep a

repository for all the artefacts and documents.

> Created prototypes to demonstrate functionality to client.

> Developed Use Case diagrams, Class diagrams, Interaction diagrams

and State diagrams using UML 2.0.

> Determining the design patterns needed in implementation of the

application.

> Designing and Developing CMS structure using C#.net and N2 CMS

[.NET Open Source]

> Integrating Blog Engine and CMS to provide single sign on

functionality

> Front End Development using C#.net and Framework 3.5

> Developed overlays that calls web handlers asynchronously using

Jquery to return the DHTML(dynamic html) on web form

> Coding and development of Master Pages, web forms and Business

logic using MVC design framework, CSS(Cascading style sheet) and

JavaScript's

> Developing generic business library using generic classes to

generate XML using LINQ framework

> Developing generic business library [File Manager] to upload, view

and delete Images/Files using LINQ framework

> Developed RESTFUL services using WCF

> Developed XAML files using Silver Light to have videos and Shaded

Images on Forms

> Developing web handlers [.ASHX] to get XML and view Images

> Development of web services [.ASMX] using SOAP protocol.

> Creating/modifying RDL files using SQL Reporting service 2000

> Developed DTS and SSIS packages with complex transformation to

import / export data from the flat file into database

> Created Sub reports using SSRS

> Used ADO.NET objects to migrate data from Previous application to

CSM SQL Server 2005 database

> Writing N2 [LINQ] quries to fetch data from N2 CMS database

> Migrated data from legacy site database to CMS database

> Used Validation Controls to validate the input data using

validation Controls

> Migrated data from legacy site to new SQL Server 2005 database

> Writing complex queries, Stored Procedures and Triggers in SQL

> Written unix shell scripts for new batch jobs.

Environment:

C#.NET, LINQ, JQuery, Silver Light, AJAX, JSON, MVC, Web Handler, Web

Services, JavaScript, DHTML, CSS, T- SQL, IIS 6.0, Visual Studio 2008, SQL

Server 2005,SSRS,SSIS,UML 2.0,CMS[Content Management System], Blog Engine

Client Name: CVS Pharmacy Feb 2006 -

Apr 2008

Woonsocket, RI

Project: CVS-OSS

Role - .Net/Oracle Developer

CVS (Consumer Value Stores) is America's largest retail pharmacy, operating

approximately 6,200 retail and specialty pharmacy stores in 43 states and

the District of Columbia. CVS-OSS project provides Break/Fix Incident

Resolution Services, Error Correction and Problem Management, Remediation,

Management of Changes, Performance Tuning for the in-scope Applications.

Responsibilities:

> Root cause analysis & Development of solution for all abends that

occur multiple times in production.

> Prepare Test Plan Specification and conduct unit testing for solution

that move to production.

> Holding sessions with Business Users and providing solutions for

implementation of the business processes/Requirements.

> Developed Use Case diagrams, Class diagrams, Interaction diagrams and

State diagrams using UML 2.0.

> Prototype development and review from the business users.

> Creation of Classes [Business logic] using C#.Net.

> Coding and development of web forms

> Use of XML/XSLT technologies to parse information and save it in

database

> Used ADO.NET objects such as Data Reader, Dataset and Data Adapter,

for consistent access to SQL Server 2000

> Determination of change in functionality and scope.

> Worked with Powercenter Workflow Manager, Workflow Monitor and

Designer

> Creation of Unix shell scripts to run the workflows through Unix using

pmcmd command.

> Performance Tuning for the in-scope Applications

> Writing PL/SQL Stored Procedures, Functions and Packages and Triggers

to implement business rules into the application

> Creating/modifying SQL reporting Reports using SQL Server Reporting

service [SSRS] and Database as SQL Server 2005

> Developed DTS and SSIS packages with complex transformation to import

/ export data from the flat file into database

> Offshore Coordination and review of code/script developed by the

offshore team

> Problem analysis, recovery, resolution to the Data warehouse

applications abends in production

> Collaborating with project manager and onsite offshore team for

ensuring the strict SLAs are met

> Resolving the issues reported by the user based on the severity.

> Documenting the process to be followed for resolution of the problems

and making a repository of all the production bugs for reference.

> Coordinating with vendors for new releases.

> Undergone HIPAA training.

Environment:

ASP. NET, ADO. NET, SQL Server 2000/ 2005, Visual Studio 2005,

SSRS,SSIS,Pro*C, C,C++, SQL, PL/SQL, Oracle9i, TOAD, Informatica 7.1,UNIX,

Shell Scripting, Control M,UML 2.0

Client Name: Goodyear - India Oct

2003 - Jan 2006

INDIA

Project: Project Value Assessment Process

Role - .Net Developer

Project Value Assessment Process (PVAP) is a part of the Stage Gate Process

used in the development of Tire Projects. It is a data Collection tool for

various tire projects.

Responsibilities:

> Designing the database (table structure) and layouts for screens &

reports

> Preparing use-case diagram, class diagram, collaboration instances and

activity diagram

> Creation of classes [Business Logic] using VB.net

> Use of Visual studio 2000 in order to develop and deploy one of the

modules of the application.

> Carrying out impact analysis and Estimations of the Enhancements

> Created internal CMS to manage contents of Tires.

> Prepare the detailed plan for the development of the Business

requirements and Enhancements

> Responsible for Construction of the programs affected by the Business

requirements and Enhancements.

> Prepare Test Plan Specification and conduct unit testing for the whole

Release.

> Front end designing of Windows Form and User Controls

> Coding of screen using VB.net

> Developed and maintained all SQLs, stored procedures, functions and

packages, which were integral to the client's application and to data

integrity.

> Responsible for performance monitoring, performance tuning, security,

and finding and fixing data integrity issues within the database

> Written PL/SQL Stored Procedures, Functions and Packages and Triggers

to implement business rules into the application

> Documentation and execution of Unit Testing Cases.

Environment:

VB.NET, ASP. NET, ADO. NET, Oracle9i, PL/SQL, Visual Studio 2000

Client Name: Pawan Hans Helicopter Ltd Aug 2002-Sep

2003

INDIA

Project: Integrated Information System for PHHL (iISP)

Role - .Net Developer

iISP is a project under the Ministry of Civil Aviation, Government of India

for Pawan Hans Helicopters Ltd. It is a web-based MIS (Management

Information System) application integrating different business modules of

the client. iISP is developed in Microsoft ASP.NET technology with SQL

Server 2000 as the database and using Crystal Reports as a reporting tool.

Responsibilities:

> Requirement capturing and client interaction

> Documentation of SRS and client sign-off.

> Technical and functional consulting with the client during testing and

implementation

> Prototype development, review and client sign-off.

> Designing the database (table structure) and layouts for screens &

reports

> Preparation of design document of module

> Coding and development of web forms

> Creation of classes [Business Logic] using C#. NET with proper

comments of in and outs of class and what it does.

> Use of Visual studio 2000 in order to develop and deploy one of the

modules of the application.

> Creating/modifying crystal reports using crystal report 10.0 and

visual studio 2000

> Developing/Modifying Data Access layer using ADO.NET

> Writing complex SQL queries, stored procedures, triggers, and

functions

> Using Web services to show GIS interface and ARCGIS for displaying

spatial maps.

> Coordinating with the Internet service provider for resolution of

deployment issues relating to application hosting and server

maintenance.

Environment:

C#, ASP. NET, ADO. NET, SQL Server 2000, Crystal Reports, Visual Studio

2000, Visual Source Safe

Client Name: DataTech Computer Ltd Jun 2001-Jul

2002

INDIA

Project: General Management Information System in PUNJABI Language for

Colleges

Role - .Net Developer

Purpose of this project was to develop a generalized MIS system for

Colleges with "PUNJABI SLANG" as core language instead of English to

facilitate users with less English Language skills. This project was

specially developed on the request of Punjab Deptt of Govt College in which

All the I/O, database entries and contents on reports were properly handled

in Punjabi Language. Used Visual Studio.Net 2000 as development IDE and UML

for modelling design of project.

Responsibilities:

> Analyzed the basic requirements for such system & worked on Unicode

character research

> Developed Administrative, Library & Examination system components of

project in C#.Net

> Developed API for Punjabi Language in C# and tested it against various

pre designed test case.

> Designed and wrote different Stored procedures in SQL server.

> Involved in client and server side Validations

> Made different reports in Punjabi language using crystal report

Environment:

C#, ASP. NET, ADO. NET, SQL Server 2000, Crystal Reports, Visual Studio

2000, Visual Source Safe

Contact this candidate