Sql Server Project

PERSONAL DETAILS:

Name: Rajesh Agarwalla

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

Contact: 614-***-****

Address: **** ********* **, ********, ** 43230

SUMMARY:

. 7+ years of progressive technical and functional experience

specializing in analysis, design and development of Internet,

Intranet, Client Server and Object Oriented applications built on

Microsoft related Technologies. Participated in every stage of SDLC.

. Developed n-tier web applications and web/windows in .NET

environment primarily in C#, ASP.NET 3.5, Visual Studio 2008/2010.

. Worked on frameworks such as WCF, MVC, 3 tier web applications.

. Worked on different stages of Project life cycle, Architecture

Layers and Design patterns.

. Having Good understanding of SOA Architecture.

. Strong knowledge in Database Programming using RDBMS databases like

SQL Server 2008/2005/2000. Expertise in writing SSIS Packages, SSAS,

SSRS, DTS Packages, LINQ, T - SQL Queries, Stored Procedures,

Triggers and Cursors.

. Used Version Controlling tools such as Visual Source Safe 6.0 (VSS)

. Experience performing Unit and Integration Testing in the

Development, System Integration Testing (SIT), User Acceptance

Testing (UAT) including Bug Reporting and Fixing.

. Excellent logical, analytical, communication and inter- personnel

skills with exceptional ability to learn new concepts / fast learner

with complex systems and a good team player, problem solver and

ability to perform at high level to meet deadlines, adaptable to

ever changing priorities.

. Solid technical experience and domain knowledge of 3+ years in WMS

application. Developed n tier application integrated with the

shipping components of product from Connectship.

EDUCATION:

B.Tech -Bachelor of Technology in Mechanical Engineering from KITS (KIIT

University), Bhubaneswar - May 2006

TECHNICAL SKILLS:

.Net Technologies Microsoft .NET Framework 1.1/2.0/3.0/3.5, C#,

ASP.NET, ADO.NET, asmx Web Services, WCF,

MVC, Ajax

Operating Systems MS Windows 2000/2003 Server, MS Windows XP, MS

Windows NT 4.0, MS Windows 95/98, Unix,

Linux.

Developments Tools & Technologies Visual Studio.NET

2003/2005/2008, Visual Interdev 6.0,

Visual Studio 6.0, Visual Source Safe, Microsoft Visio.

Web/Application Servers IIS 5.0/6.0, MTS, COM+

Web Development ASP.NET, ASP, WEB Services, LINQ, XML, XSL, XSLT,

XPath, SOAP, WSDL, UDDI, CSS, VBScript,

JavaScript, HTML/ DHTML, Visual Studio

Tools for Office.

RDBMS MS SQL Server 2008/2005/2000/7.0, MS Access

2000/2003

Languages C#, VB.NET, VB 6.0, HTML, XML, TSQL, VBA

ETL Tools SSIS

Reporting Tools Business Objects, SSAS, SSRS

Source control tools MS Visual Source Safe, Team Foundation

Server

Other Tools Connectship Tool Kit, Progistics Management Console,

MS Visual Studio, TOAD

PROFESSIONAL EXPERIENCE:

Project: IHoP - International House of Partners

Designation: Developer

Client: LaSenza (LimitedBrands)

Project Duration: Mar 2013 - Current

Located at client facility - Columbus, OH

Description:

IHoP - International House of Partners is the datawarehouse and reporting

database of LaSenza which helps its business users with stats and trends to

make key business decision. It comprises of SSIS packages used to load the

sales data sent by partners into LaSenza's staging database by cleansing

and validating with specific technical and business rules along with

automatic alerting. Then the data is loaded into DW database through the

ETL SSIS packages followed by building the SSAS cube. It is then published

to the business users through the SSAS multidimensional cube reports. The

users have the flexibility of slicing and dicing the data across measures

and dimensions. It also comprises of web application developed in ASP.net

and C# to allow business users to insert, update or delete frequently

changing data.

Responsibilities:

. Actively involved in requirement gathering from the business users.

. Designing the architecture of the datawarehouse and cube.

. Design and develop the SSIS ETL packages to load data into

Datawarehouse.

. Design and develop SSAS multidimensional cube.

. Create hierarchies and KPIs.

. Develop .Net web applications used as Interface by business users to

maintain frequently changing data.

. Deploy the package to production environment and schedule SQL jobs.

. Performance tuning and setting up automatic alerting of ETL loads.

. Help the business users generate report from the cube.

. Provide day to day support and enhancement to the existing jobs.

. Giving presentation to business users on

Environment: SQL Server 2008 R2, SSAS, SSIS, .net, C#

Project: Risk Management Decision & Reporting

Designation: Developer

Client: WesternUnion

Project Duration: Apr 2012 - Feb 2013

Located at client facility - Denver, CO

Description:

Risk Management Decision (Blaze) is a decisioning engine that evaluated the

risk involved in approving a CNP transaction based on the historical and

central repository of data. Reporting on the other side is a centralized

OLAP reporting system that contains a lot of aggregated data focused on the

fraudulent transactions based on multiple requirements from the business

users which helps the users in analyzing the trend and to create new rules

in the decisioning engine. All these reports are in form of

multidimensional cubes and the users refer to these cubes in excel to slice

and dice the measures with different dimension.

Responsibilities:

. Requirement gathering from the business users

. Designing and implementing the changes to the Blaze system

. Design the extraction process from OLTP database to the OLAP database.

. Develop the SSIS and SSAS packages

. Create hierarchies and KPIs

. Deploy the package to production environment and schedule the SQL job

. Involve in day to day support and enhancement to the existing jobs.

Environment: WCF, SQL Server 2005/2008, SSAS, SSIS, SSRS

Project: Small Parcel Shipping System (SPSS)

Designation: Tech Lead

Client: Cardinal Health

Project Duration: Dec 2009 - March 2012

Located at client facility - Dublin, OH

Description:

SPSS is a web application used in the warehouses to ship the packages to

the clients of Cardinal Health via commercial carriers like Fedex & UPS.

The users would process an order using an application called AIMS which

would generate a packing label. They would then apply the label on to the

package, packed for the order. In order to ship it, the users would scan

the barcode on the packing label onto the SPSS application which would in

turn extract information from the AIMS database and ship the package with

the service levels of the carrier returned from AIMS database. A third

party tool called Connectship is used by SPSS to ship the package.

Connectship has the required authorization from Fedex/Ups to ship the

packages. SPSS references the dlls of Connectship and calls its multiple

functions in order to ship the package. It would then generate a shipping

label containing the tracking number and other information which is applied

onto the package to be shipped.

Responsibilities:

. Migrated the web application, SPSS, from ASP to ASP.net.

. Followed the SDLC process like requirement gathering, designing,

development, testing and deployment in different phases of this

migration.

. Developed the application in C# as per the design.

. Implemented additional security using active directory.

. Involved in the developing/updating tables, triggers, views and

stored procedures in SQL Server 2000/2008.

. Migrated the database from SQL Server 2000 to 2008 and hence

converted the DTSPackages to SSIS Packages.

. Created stored procedures that accepts data in XML format and

called them from the web application for better performance and

flexibility.

. Preparing the test cases (Unit, Integration Testing) and tested

the application followed by fixing the bugs.

. Deploying the application on to production environment followed by

testing.

. Involved in day to day support and enhancement of the application.

. Fixing the bugs and maintaining the application with constantly

changing business rules.

Environment: ASP, ASP.net 3.5, C#, SQL Server 2000/2008, XML, JavaScript,

VBScript, Connectship Tool kit, Progistics Management System

Project: AIMS Shipping Broker

Designation: Tech Lead

Client: Cardinal Health

Project Duration: Aug 2011 - Feb 2012

Located at client facility - Dublin, OH

Description:

AIMS Shipping Broker is a webservice which exposes a number of methods that

provide features of shipping/querying/voiding packages. The service is

hosted in a web server and is referenced remotely in multiple host windows

services residing in windows server. The windows service uses the classes

of AIMS Shipping Broker and call the methods exposed in order to

ship/query/void the packages. This makes the caller application independent

of its technology. There are few methods that are of one way and some that

return a response to the request. The service receives information about

the package in XML format and provides the details like tracking number,

printable ZPL code etc in XML format in its response.

Responsibilities:

. Study and analyze the business logic

. Followed the SDLC process like requirement gathering, designing,

development, testing and deployment in different phases of this

migration.

. Design the architecture and its modules.

. Coding the webservice in C#.

. Creating tables, stored procedures and accessing them through LINQ.

. Deploying it to the production web server

. Updating the Managers with project status.

. Preparing requirement specifications, design specification and

reviewing the test case documents.

. Developed Load Test scripts and tested the process (Unit, Integration

Testing) and fixed the bugs.

. Involved in day to day support and enhancement of the application.

. Fixing the bugs and maintaining the application with constantly

changing business rules.

Environment: C#, .net 3.5, SQL Server 2000/2008, SSIS, XML, LINQ,

Connectship Tool kit, Progistics Management System

Project: AIMS & SPSS ETL Datawarehouse

Designation: Tech Lead

Client: Cardinal Health

Project Duration: Dec 2009 - Mar 2012

Located at client facility - Dublin, OH

Description:

The data from the SQL server of AIMS (Warehouse application) and SPSS

(Shipping application) is exported to the Oracle Datawarehouse on a daily

basis. The process is designed to store the data in the datawarehouse so

that the data from the live database of the applications can be purged.

It's purely based on Extract - Translate - Load (ETL) process. There are

numerous SSIS packages that get executed in a sequence. Both of the

processes were migrated from SQL Server 2000 to 2008. So, the DTS Packages

were converted to SSIS Packages.

Responsibilities:

. Study and analyze the business logic

. Analyze the new requirements and enhance the process

. Updating the Managers with project status.

. Involved in preparing requirement specifications, design

specification and reviewing the test case documents.

. Writing SSIS packages and also converting DTS Packages to SSIS

Packages.

. Developed Load Test scripts and tested the process (Unit,

Integration Testing) and fixed the bugs.

. Test the reports through Business Objects XI

Environment: .NET Framework 2.0/3.5, Visual Studio .NET 2008, SQL Server

2000/2008, SSIS Packages, Business Objects XI

Project: Print and Apply

Designation: Tech Lead

Client: Cardinal Health

Project Duration: April 2010 - June 2010

Located at client facility - Dublin, OH

Description:

Print & Apply is a windows/web service (an automated version of SPSS

application) where the packages comedown a conveyor and a scanner mounted

on it scans the barcode on the package and sends the information to the

server that is hosting the service over sockets. As soon as the service

receives the order number, it extracts the information from AIMS SQL

database and ships the package with appropriate service levels of Fedex/UPS

and stores the shipping information into its SQL database. Then the ZPL

code of the shipping label is extracted from Connectship and is send to

sent to the Zebra printer located near the scanner which prints the label

and applies on the package.

This service works exactly like SPSS, but without human intervention and

was developed from scratch using SPSS as a reference. It uses Connectship

as it's the base for shipping a package. Connectship's dlls were referenced

and its functions were used in the service.

Responsibilities:

. Design the architecture and its modules.

. Coding and testing the service

. Deploying it to the web server

. Updating the Managers with project status.

. Preparing requirement specifications, design specification and

reviewing the test case documents.

. Developed Load Test scripts and tested the process (Unit,

Integration Testing) and fixed the bugs.

Environment: .NET Framework 2.0/3.5, Visual Studio .NET 2008, C#, LINQ, SQL

Server 2008, XML, Sockets, Connectship Tool kit, Progistics Management

System

Project: Dealer Tracing & Rebates System (DTRS)

Designation: Project/Software Engineer

Client: Cardinal Health

Project Duration: Jun 2006 - Dec 2009

Located at offshore - Kolkata, INDIA

Description:

DTRS is a suite of applications used for calculating and processing the

charge back & bill back amount for the distributors of Cardinal Health

against their sales. It comprises of 7 windows (2 in VBA & 5 on .net) & 2

web application. There are 11 batch jobs and 12 ETL jobs programmed for

this process as well. The web applications are used to maintain the dealer

rebate contracts for the distributors where as the windows application are

used to calculate, review, approve and process the rebates. The ETL jobs

are used to send and receive data to the Datawarehouse, which is an Oracle

server. So, there are numerous DTS Packages/SSIS Packages that are used to

extract data from tables in Oracle server to tables in SQL Server. The

pricing and sales information is extracted from the datawarehouse and the

calculated charge back, bill back amount along with the contract

information is loaded into datawarehouse on daily/weekly/monthly basis.

Responsibilities:

. Understanding and documenting the business requirements as

enhancements.

. Designing the database.

. Designing Web/Windows pages.

. Designing the middle tier architecture

. Developing the changes as per the design and requirement.

. Understanding, designing and implementing the interfaces to

external applications

. Active Directory Integration for the application security.

. Involved in the developing/updating tables, views and stored

procedures in SQL Server 2000/2008.

. Testing the application (Unit, Integration Testing) and fixing the

bugs.

. Deploying the changes to production environment

. Providing 24*7 support

Environment: VBA, .NET Framework 2.0, ASP.net, C#, CSS, SQL Server

2000/2008, IIS 6.0, Windows 2003 server, Win XP Clients

COMMENDATIONS:

. Received Oh My! Certificate from Client for Project Omega for

Incredible Tenacity

. Under my leadership my team was awarded Best Value Addition to Client.

Contact this candidate