Project Sql Server

CONTACT DETAILS

[pic]

NAME: Smaranika Sahu

Mobile No. +918*********/801-***-****

Emailid- ************@*****.***

Current

Address : F-27/5, Karunamoyee Hosuing Estate

Kolkata,WestBengal

OBJECTIVE

[pic]

Anticipating ample opportunities to portray my skills and utilize them

for the growth of the organization and to excel both technically and

functionally to contribute my share of knowledge.

EXPERIENCE SUMMARY

[pic]

Since March 2011 I have been working with Cognizant Technology solutions

Pvt ltd in Levi's Account. As part of the assignment, I have worked on

SQL Server 2008 and along with SSIS. After 13th July 2012 I have been a

part of Global Crest account till 4th Jan 2013 where I worked on

Reporting like SSRS and SQL server. After 5th Jan I was a part of AIMCO

till 31st may 2013 where I gave support on SQL jobs and also worked in

enhancement of projects on SSIS and SSRS 2005.After 1st July 2013 I have

been a part of Xerox testing team working as test analyst till date.

I have around 47 months of working experience in the Information

Technology. I have successfully completed my training in advance JAVA.

SKILLS DETAILS

[pic]

Hardware / Windows 98/XP/2000/Windows 7.

Platforms

Technology Cognizant internal training

on Core Java

Programming JAVA

Languages

Databases SQL Server 2008

Scripting JavaScript, HTML,VBA

Languages

Tools Used Visual Studio 2008,2005,QC

CERTIFICATION DETAILS

[pic]

# CCP in Core Java Cognizant Internal

# CCP in Retail L0 certification

# Brainbench certification in JSP

# Brainbench certification in Struts

# Brainbench certification in EJB

#CCP in Software testing L0

PROJECT EXPERIENCE

[pic]

Organization: Cognizant Technology Solutions

Project #1

Title Retail Assortment Planning

Client Levi's

Operating System Windows

Tools SQL Server 2008 and SSIS

Team Size 4

Role Team Member

Period May 2011- Feb 2012

Project Objective: As a part of this project I got an opportunity to work

on SQL server 2008 and SSIS.The objective of the project was to send data

from a pre-staging database to a staging database with proper manipulation

of logic according to the environment of staging database. I acquired

knowledge on store procedures, joins, views in SQL server. From SSIS point

of view I have developed small packages in my project. Project was

completed in Nov 2011 but some Requirement changes were done and some

enhancements were continued till feb 2012.

I have done some technical documentation in my project.

Organization: Cognizant Technology Solutions

Project #2

Title Maple Lake Reporting

Client Levi's

Operating System Windows

Tools SSIS

Team Size 2

Role Team Member

Period Feb 2012- May 2012

Project Objective: As a part of this assignment I worked singly in

developing certain SSIS packages for the client. This was only using SSIS.

The challenge was that client will be giving some data in flat files and

from those flat files according to some criteria, I had to generate

multiple flat files with dynamic naming convention and distinct combination

was generated. There were seven different flat files for which seven SSIS

packages were developed.Technical documentation is also done for the

project

Organization: Cognizant Technology Solutions

Project #3

Title JE Upgrade (Constraint Interface)

Client Levi's

Operating System Windows

Tools SSIS and SQL server 2008

Team Size 3

Role Team Member

Period May 2012-July 2012

Project Objective: As a part of this project I had to develop SSIS package

for an interface called Constraint where data from different vendors or

third party would be consolidated and finally the output would be a JE Flat

file. This was done by using Store procedure as well as SSIS package which

would finally generate JE flat file for the client.

Logical as well as Functional document for the interface was also prepared.

Organization: Cognizant Technology Solutions

Project #4

Title Global Crest

Client Realogy

Operating System Windows

Tools SSRS and SQL Server 2008,

Team Size 4

Role Team Member

Period July 2012- Jan 2013

Project Objective: For this assignment I had to develop reports using SSRS

with SQL Server as the back end. Source data came from CRM front end tool.

These reports were deployed in Report Server as well as in CRM

front end. This project gave me an overall idea about the CRM front end as

well as Reporting services .Test cases were also prepared for end to end

testing.

Organization: Cognizant Technology Solutions

Project #5

Title Horizon

Client Aimco

Operating System Windows

Tools SSIS and SQL Server 2005

Team Size 4

Role Team Member

Period Jan 2013 30th June 2013

Project Objective: This is a production support project. I had to monitor

some scheduled jobs that run in SQL Server Agent. Even I had to fix if the

job fails in between. The jobs were written in T-SQL and some SSIS

packages, DTS packages were also there. This gave me knowledge of SQL agent

server and job scheduling also explored some DTS packages. I have done some

documentation like analysis document preparation and Application Handbook.

Organization: Cognizant Technology Solutions

Project #6

Title XBS-BFS-Mortgage

Client Bank Of America

Operating System Windows

Tools Quality Centre, Citrix

Team Size 4

Role Team Member

Period July 2013 till present

Project Objective: ACS, a Xerox Company, is providing infrastructure to

Bank of America to send documents to the ACS Xerox systems for assigning

them to right document types and index them with correct Loan Number /Pre

App Number, time frame and Signature. Bank of America personnel are sending

the documents to Xerox server via fax, scan and upload channels.

As part of ACS Xerox team, checking the integration of bank system with

ACS Xerox systems and checking the functionality of all 7 applications of

ACS (for document management of Bank of America)so that each type of

document coming from different channels are indexed as per bank's

requirement is done by Cognizant QA team. Supporting bank's internal test

cases by batch (group of documents) processing is also being facilitated by

Cognizant Technology Solutions in daily basis.

There many releases where I had to test the Image capture Application and

there were 3 types of document called FAX, file upload and scan type and

according to the type the document get routed to different Image capture

applications. These application basically avoid the manual paper work in

bank normally as the user in image capture go and completely classify and

complete the document and finally sent to the bank for review. There are

many releases and Change requests for these application which we are

testing. Many changes in the applications are going on and I tested it in

phase by phase. In this I have written test cases also made regression test

suites and uploaded these batches in QC on daily basis.

Project #7

Title XBS-BFS-Mortgage

Client SunTrust

Operating System Windows

Tools Quality Centre, Citrix

Team Size 3

Role Team Member

Period March 2014 till June 2014

Project Objective: This Project was based explicitly on web testing and the

process was quite manual where there were documents present in 14 queues

named differently and the user has to manually test the routing of the

document. The user needs to assign, review and verify the documents and

their routing is according to the business rule or not. I had to write the

functional test cases and the regression test cases for the two releases of

different web viewer one was atlas soft and the other was normal viewer.

Additional functionalities were also checked. These test cases were

uploaded in Quality Centre.

EDUCATIONAL DETAILS

[pic]

Course Institution CGPA/Percent Year of

age Passing

B. Tech(Electronics & College Of Engineering 7.47

Telecommunication Bhubaneswar Orissa

Engineering. 2010.

)

Senior Secondary(+2) Kendriya Vidyalaya 67.4

Sambalpur 2006

Secondary (10th) Kendriya Vidyalaya 82.6

Sambalpur 2004

PERSONAL DETAILS

[pic]

FATHER'S NAME :Mr. Ranka Mani sahu

DATE OF BIRTH : 07TH JUNE 1988

MARITAL STATUS : UNMARRIED

PERMANENT ADDRESS: GURUPARA,SAMBALPUR

ODISHA PIN-768001

Mob: - 084********/801-***-****

Declaration:

[pic]

I hereby declare that the above information is the best of my knowledge and

are correct.

Contact this candidate