Sql Server Developer

Objective:

To assume a respected, challenging and an encouraging position in an

organization that provides a platform to showcase my technical and

functional expertise and also provides an environment to constantly

improve my potential.

Experience Summary:

> IT Consultant/Computer Programmer Analyst, with around 7+ years of

experience in the IT Industry with specialization in Data

Warehouse/Data Mart Development Life Cycle.

> Very good experience in working with various ETL tools especially in

Ab Initio 3.0.3, Ab initio 2.5 and Reporting tools like COGNOS,

Tableau and SSRS

> Rich experience in all stages of SDLC including knowledge transition,

requirements gathering, designing & documenting architecture,

application development, testing, implementation and post-

implementation support.

> Personal strengths include excellent communication skills, commitment

to quality, acumen to deliver, value added solutions and enthusiasm to

achieve results.

Technical Skills:

Technologies Data Warehousing

ETL Ab Initio 3.0.3, Ab Initio 2.15, Informatica

8.1, DataStage 7.5

Databases Teradata 13.0, MS SQL Server 2005, MS SQL

Server 2008

Reporting, OLAP SSRS, Cognos 8.4, Tableau

Languages SQL, Unix Shell scripting

Operating Systems Windows Server 2003, Windows XP, UNIX, Windows

2007

Tools/Software Control-M, Autosys, MS Office 2010, MS Office

2007

Educational Qualifications:

> Bachelor of Engineering (B.E.) - Electronics and Telecommunications

From Vidyavardhini college of Engineering and Technology,

Maharashtra, Mumbai (65 %)

Certifications:

> Microsoft Certified Professional (MCP) (.Net 1.1)

> Oracle 9i SQL Certified

Project Experience:

Employer: Cognizant Technology Solutions

> July 2012 till date

Title: Customer Experience Metrics Program

Client: Capital One

Location: Richmond, VA USA

Description: This Project is all about doing a survey for

Capital One's various lines of business and its customer's

experience. Here we select random group of Customers from

various lines of business such as Bank, Card, Home Loans

and Capital One finance stream based on their recent

contact with Capital One and we send a Email Survey to them

in order to get response back for few of the questions

related to their experience of Capital One for their recent

contacts. Similarly survey is also conducted over a phone

on different set of customers by a third Party Vendor

Maritz. Maritz also receives the customer feedback of Email

survey which is than merged with Phone response and data is

sent back to CEMP (Customer Experience Metrics Program)

team which is than stored in database. This information is

then used by the Capital One management to improve their

overall customer experience

Role: Onsite Coordinator, Team Lead, ETL Developer

Responsibilities:

. Analyze, Design, Develop, Test and implement detailed

software applications, modules and systems to specific

client requirements

. Being the single point of contact, coordinating with

Offshore Counterparts in getting the requests

assigned/completed and also providing support/ technical

guidance to the team

. Work closely with business customers to understand the

Business/Functional Requirements and converting it to a

detailed technical design for IT

. Design and Develop ETL process using Ab Initio ETL software

. Creating Unix scripts for executing the jobs

. Extract and Reformat data from heterogeneous source using

Ab Initio as ETL tool an load it into target databases like

Teradata and SQL server

. Reviewing/Unit Testing all the work products as part of

support/enhancement requests before Implementation

. Work closely with QA team during the testing phase and fix

the issues that were reported

. Ensures that the best practices and standards are followed

in Ab Initio Development

. Tracking the development of the project and review the code

to maintain good Quality

. Work on the implementation Plan, Release Management and

track it to the closure

. Setting up of Control-M and Autosys Jobs to schedule the

process

Technology: Ab Initio 3.0.3, Teradata, SQL Server 2008, Control-

M, Autosys, Unix Shell Scripting

Employer: L&T Infotech

> May 2010 till June 2012

Title: Middle Market Construction

Client: Travelers

Location: Hartford, CT USA

Description: The project is of type - maintenance, which

includes enhancements, developments, change- requests and

production support to the existing system. The project is

for Construction department of Travelers Business Insurance-

It has several user interface applications which are being

used by Agents and Brokers to create Quotes as well by

Travelers employees for reviewing and approving those

Quotes and Binding it. It also has an ETL (Ab Initio)

process that runs daily, weekly and on monthly basis to

extract data from various system and loads the data in SQL

Server database according to business logic which is then

represented using COGNOS reports to business users.

Role: On site Co-ordinator, Team Lead, ETL Developer, COGNOS

Developer

Responsibilities:

. Being the single point of contact, coordinating with

Offshore Counterparts in getting the requests

assigned/completed and also providing support/ technical

guidance to the team

. Work closely with business customers to understand the

Business/Functional Requirements and converting it to a

detailed technical design for IT

. Reviewing/Unit Testing all the work products as part of

support/enhancement requests before Implementation

. Design, Development and Production support of Ab Initio

jobs

. Upgraded Ab Initio Jobs from 2.15 to 3.0.3

. Troubleshooting, debugging and resolving various issues

related with front end application

. Creating reports in Cognos 8.4 for business users

. Creating Autosys jobs for scheduling the Ab Inito process

Technology: Ab Initio 3.0.3, COGNOS, .Net 2.0, SQL Server 2005,

SQL Server 2005, Autosys

> May 2009 till April 2010

Title: Risk Control Business Intelligence

Client: Travelers

Location: Pune, India

Description: RCBI is a conversion project from Datastage to

Ab Initio.

It was an enterprise wide decision by travelers to move

all of their Datastage jobs to Ab Initio graphs. To carry

out this task several approaches were mention but of this

conversion tool of Ab Initio was zeroed on to carry out the

process. Later on all the graphs were identified for any

discrepancies and were resolved and made sure everything

goes fine before moving into production.

Role: Ab Initio Developer

Responsibilities:

. Testing and Development of the Ab Initio graphs.

. Responsible for all development done by the team.

. Actively involved in creation of understanding

documents.

. Preparation of Test Cases.

Technology: Datastage 7.5, Ab Initio 2.15

> Jan 2009 till April 2009

Title: Aaram Report Centre and Agency Online Portal

Client: SBI Life

Location: Mumbai, India

Description: Agency Online Report and Aaram Report Centre

applications are web based centralized repository for

hosting BI reports which enables SBI Life's business users

for tracking business trends, decision making etc. It

provides right information to right user and enables power

users for creating and deploying their own reports. It

privileges end users to manage their profiles. Information

can be presented to end users as reports, documents, rich

visualized dashboard to cater different information at one

place

Role: Report Developer

Responsibilities:

. Design the entire Report layout as per client

requirement.

. Responsible for all development done by the team.

. Actively involved in creation of store procedures and

functions.

. Preparation of Test Cases.

Technology: SQL Server Reporting Services, SharePoint

> From November 2008 - Dec 2008

Title: Paramount Clarity Reports

Client: Paramount Pictures

Location: Mumbai, India

Description: Clarity Tool is a Project Portfolio Management Tool. Over

here we have developed a report Using Actuate

Reporting Tool for the higher management in order to have

a birds view about different Projects going through

Paramount, Its financial Growth and so on.

Responsibilities:

. Creation of Project Templates, Portlets.

. Functional Design & Documentation for the Financial

Reports

. Development of Reports using Actuate Reporting Tool.

. Setting Up the projects in CA Clarity Project

Management.

. Creating the various security groups, request types and

workflows in Clarity.

Technology: CA Clarity Tool v 7.5.3 and 8.1

> From Feb 2008 - October 2008

Title: KPI Operations

Client: Dredging Environmental and Marine Engineering (DEME)

Location: Mumbai, India

Description: The COO department in DEME has a number of key

performance indicators (KPIs). Most of these KPIs are

related to the formal part of exploitation reporting. These

KPIs are obtained from the Kick-off meetings held, work

budget, weekly reports, End of work reports etc. Currently

the report is being generated every quarter and the

generation of this report takes about 2 weeks. The report

is generated manually using excel files. They would like to

be able to calculate the KPI for the data within a given

timeframe. An issue they currently face is that they are

only able to calculate averages/percentages over the entire

dataset. In order to be able to report for a given period,

more date information will need to be added i.e. end date.

The new system will need to be flexible and allow adding

new KPIs and project characteristics without too much

effort.

Role: SSIS and SSRS Developer

Responsibilities:

. Actively involved in designing and development of ETL

packages and jobs using SSIS

. Actively involved in designing and developing of SQL

stored procedures, functions etc

. Designing reports in SSRS

. Preparation of test cases

Technology: SQL Server 2005 Integration Services, SQL Server

Reporting Services, Dundas Chart for Reporting Services,

VB.NET 2003

> From October 2007 -Jan 2008

Title: Master Data Management

Client: L&T Infotech

Location: Mumbai, India

Description: Master Data Management (MDM) is basically

consolidation and cleansing of master data to provide a

single version of truth. Most of the enterprises maintain

their master data in various disparate systems this results

in data redundancy, inconsistency and business

inefficiency, master data management solves this problem by

consolidating all the master data.

Role: ETL developer

Responsibilities:

. Understanding the BI landscape / Source systems and the

business requirements.

. Creating System design document (SDD), ETL mapping

documents

. Source system data analysis, Data Profiling and

Cleansing

. Developing ETL jobs as per Data model and ETL mapping

documents

. Creation of Unit & System cases

Technology: Informatica 8.1, Oracle 9i

Contact this candidate