Resume

Sign in

Sql Server Project

Location:
Charlotte, North Carolina, United States
Salary:
85000
Posted:
January 09, 2017

Contact this candidate

Anoop Suresh

Phone: +* 646-***-****

Mailto: acx6yl@r.postjobfree.com

Experience Summary

Senior Software Engineer in Cognizant Technology Solutions having 8.2 years of experience in software development. I’m currently working as an onsite lead developer in Charlotte, NC, U.S.A (H1-B visa). As part of my assignments, I have been in Requirement Analysis, Effort estimation, Application Development, Maintenance and support. I have got exposure to Microsoft technologies like SSRS, SSIS and good exposure to databases like SQL Server.

Education

Title of the Degree with Branch

College/University

Year of Passing

B.Tech: Computer Science & Engineering.

Cochin University, Kerala

2007

Technical Skills

Hardware / Platforms

Windows XP/7/Vista

Technology

SSRS,SSIS

Databases

SQL Server 2005/2008/2012

Version Control Systems

MS Visual Source Safe (VSS), SVN, Borland Star Team 2008.

Project Details

Project #1

Project Title

MAOP (Maximum Allowable Operating Pressure)

Client

Electric Power Holding Company

Location

Charlotte, North Carolina, U.S.A

Role

Team Member

Technologies

SQL Server 2012,SSRS,SSIS

Operating System

Windows 7

Period

4/28/2016 – till date

PROJECT SUMMARY

Maximum Allowable Operating Pressure (MAOP) project consists of ETL development using SSIS packages for loading the data into the new system and various reports are developed using SQL Server Reporting Services (SSRS). These reports are being used by users in different departments to find the location of pipeline, line size, line map, line installation/uprated date, maximum allowable operating pressure for pipelines, maximum operating pressure of pipelines and various other information regarding the pipelines.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Interact directly with Business, Subject matter experts and Business analysts on a continuous basis gathering requirements and suggesting better solutions.

Effort estimation for requirements, preparing solution design, technical design and performing reviews.

Development of stored procedures and functions as per the requirement.

Development of SSRS reports and ETL development using SSIS

Unit test case preparation, test execution and result documentation

Production release co-ordination

Post implementation support.

Project #2

Project Title

MIS

Client

US based Insurance Company

Location

Kochi, India

Role

Team Member

Technologies

SQL Server 2012,SSRS,SSIS

Operating System

Windows 7

Period

5/31/2014 – 3/31/2016

PROJECT SUMMARY

MIS is the historical data warehouse which provides financial as well as property, borrower and other non-financial data for MetLife’s mortgage portfolio. It also provides monthly analytics such as commercial mortgage market valuations and income projections. Besides reporting, MIS also serves as an ODS, supporting operational processes such as Market Value determination and Income Projection

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Perform initial analysis, designing the specifications.

Development of SSRS reports and ETL development using SSIS.

Creation of test plans and carrying out unit testing as per the requirement.

Documenting the changes and doing code reviews for maintaining the quality of the delivery.

Coordination activities with onsite team members and client for various assignments sent to Offshore.

Project #3

Project Title

MIS Feed Optimization

Client

US based Insurance Company

Location

Kochi, India

Role

Team Member

Technologies

SQL Server 2012, SSRS,SSIS

Operating System

Windows 7

Period

10/18/2013 – 5/30/2014

PROJECT OBJECTIVE

This project aims at redesigning the process of generating Real Estate feed files from source systems (CLS, MSAS and LMW) and consuming them in MIS. Currently stored procedures are invoked from a scheduled job to port data from Corresponding source systems to MIS via FTP as flat files with DML scripts in it which is then consumed by MIS using few scheduled Jobs.

The new design will replace the existing flat file with XML files (Containing only data and not the DML script) that will be consumed by MIS application, loading data in to MIS database. SQL Server Integration Service (SSIS) packages along with Pragmatic works XML Generator Transform component will be used in Source System process to fetch the data from the database and to write them into XML file based on the XML Schema definition (XSD) designed. MIS SSIS packages validate these XMLs against XSDs and then load data into corresponding MIS tables. Reports are then developed using SSRS for MIS team.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Involved in the analysis and understanding of customer requirements.

Preparation of High level and Low level Design documents.

Development of stored procedures and functions as per the requirement

Report development using SSRS and ETL Development using SSIS.

Preparing unit test cases and perform unit testing.

UAT Release and Support

Project #4

Project Title

One PAS Reporting

Client

Hong Kong based Insurance Company

Location

Kochi, India

Role

Team Member

Technologies

SQL Server 2008,SSRS,SSIS

Operating System

Windows XP

Period

12/02/2011 – 10/17/2013

PROJECT OBJECTIVE

OnePAS is the integrated policy administrative application which combines three different policy admin systems i.e. Life Asia 5.0, LSP and iLife. The scope of the OnePAS reporting solution is to generate around 300 operational reports and individual data-marts for different departments like PAD, Finance, Direct Marketing and Compliance etc.

PROJECT DESCRIPTION:

The main technologies used in this project are Microsoft SQL Server 2008 R2 database, SQL Server 2008 R2 Integration Services and 2008 R2 Reporting Services. The reports are of mainly two types – reports which are automatically generated or report portal based user interactive reports.

The SSIS packages are used to generate the reports in batch mode which are scheduled to run at specified interval based on the source application schedule status. The reports are generated in different formats like Excel, pdf, text, etc with zip or PGP compression. There are requirement to get print and fax copy automatically for the burst reports. All these technical aspects of the requirement are achieved by using SSIS script component.

The SSIS packages are used to generate the reports in batch mode which are scheduled to run at specified interval based on the source application schedule status. The reports are generated in different formats like Excel, pdf, text, etc with zip or PGP compression. There are requirement to get print and fax copy automatically for the burst reports. All these technical aspects of the requirement are achieved by using SSIS script component.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Query development based on data mapping.

Development of SSRS reports and SSIS packages.

Documentation for the SSRS reports

Unit testing and functional testing.

Co-ordination of SIT, UAT and production release activities

Post implementation support

Project #5

Project Title

Security & Derivative Act to SSRS

Client

US based Insurance Company

Location

Kochi, India

Role

Team Member

Technologies

SQL Server 2008,SSRS

Operating System

Windows XP

Period

09/01/2011 – 12/01/2011

PROJECT DESCRIPTION:

Objective of this project is to create and enhance the SSRS reports based on the client user requirements. Conversion of Actuate to SSRS reports are the other activities involved in this .Also, involved in creation of stored procedures and functions for improving the report performance in SSRS.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Analyzing the existing Actuate report and prepare design document.

Development of SSRS reports based on existing system.

Unit test case preparation and test execution documentation.

UAT release and support.

Project #6

Project Title

Harvest It - Retail System

Client

Kenyan based large Agri-business Customer

Location

Cochin, India

Role

Team Member

Technologies

SSRS, SQL SERVER 2005

Operating System

Windows XP Professional

Period

12/02/2010 To 08/12/2011

PROJECT DESCRIPTION:

HARVEST it Retail System is used to maintain the retail sales of coffee and tea products. Retail sales are the sale by the seller to customers such as distributors, super markets and Institutions. This system also handles the processing details of the coffee such as purchase, blending, roasting and packing. You can generate stock orders and sales orders based on which the retail sale of the products can be done. The details of the sanctioning and dispatching of the stock order and sales order can also be recorded. You can also specify the details of the stock returned due to some damage or other reasons. This system also captures the details of the stock adjustments and the product issued as sample or gift. This system produces all the desired reports required for monitoring and controlling the system

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Perform initial analysis and prepare design documentation

Coding according to the design specification and identifying necessary code reusability.

Preparing unit test cases and perform code reviews for peers

Perform Unit & integration tests.

Create and maintain the database objects.

Project #7

Project Title

CTP Holdings. (PNG) - HRM

Client

Papua New Guinea based large Agri-business Customer

Location

Cochin, India

Role

Team Member

Technologies

SQL Server 2005,SSIS

Operating System

Windows XP

Period

10/01/2008 To 11/26/2010

PROJECT DESCRIPTION:

The project handles the capture and maintenance of records of all the details of the persons employed within the organization right from the time they are recruited till the time they separate from the organization. The scope of this module includes Recruitment Process, Appraisal Scheduling, Deputation and Retirement Calculation of an Employee.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Interacting with Business Analysts, users to collect the business requirement

Analysis, design and development of Reports.

Preparation of unit test cases and test execution.

SIT release and support.

Co-ordination of implementation activities.

Personal Details

Date of Birth

12/31/1985

Nationality

Indian

Marital Status

Married

Father’s Name

Sureshbabu

Contact Address

706 Sharview Cir,

Apt 1335,

Charlotte,

NC-28217

Contact No:

+1-646-***-****

+1-980-***-****

Email Id

acx6yl@r.postjobfree.com

Declaration

I hereby declare that the above mentioned details are true to the best of my knowledge and belief.

Place: Charlotte, NC Anoop Sureshbabu



Contact this candidate