Resume

Sign in

Project Sql Server

Location:
Kolkata, West Bengal, India
Posted:
February 09, 2019

Contact this candidate

Resume:

Mrinmoy Saha

Mobile No. +** - 882*******

Email- ac8fqp@r.postjobfree.com

Career Objective

MSBI developer with 5 years of Experience in and Business Intelligence across Travels & Hospitality, Insurance and BFS domains.

Strong experiences as a SQL Developer, Performance tuning and written Stored Procedures, Views and User Defined Functions. Strong in SQL concepts

Has worked in SQL Server 2012, 2014 & 2016 in the following areas: Installation, Configuration, Deployment / Implementation.

Well versed in SSRS reporting and has developed some complex reports which required well engineered database objects, ETL transformations and dynamic reporting utilities working in tandem ensuring information drilling ability (detailing and across) along with performance gains and subscription.

Good experience in SSIS, working with transformations such as Row, Row Set, BI, Split and Merge etc. and hands on experience with control flow, data flow, event handlers, variables, Logging and Custom Logging, Error handling, configuration and deployment.

Monitoring Job Failures in SQL Server & Enhancement of SSIS packages.

Having the experience working with TFS for managing the releases to production and JIRA.

Education

Title of the Degree with Branch

College/University

Year of Passing

Mechanical Engineering

RCERT, Nagpur University

2013

Technical Skills

Reporting Tools

SSRS 2012,2014 & 2016

Operating Systems

Windows XP/2007/8

Databases

SQL Server 2012,2014,2016

Reporting Tool

SQL Server Reporting Services, Power BI

ETL Tool

SQL Server Integration Services 2012,2014 & 2016

Version Control Tools

Team Foundation Server

Other Tools

Jira, Sql Server Migration Assistant

Work Details

Current Organization: Cognizant Technology Solutions

Date of Joining 11th Feb, 2014

Project Experience

Project #1

Client: - A global payment solutions (BFS)

Project Title

A global payment technology solutions company in USA

Domain

Banking & Financial Services

Location

Kolkata

Operating Systems

Windows

Technology

MS-SQL Server TSQL, SSRS

Database

MS-SQL Server

Team Size

30

Allocation Tenure

5th Aug 2014 – 19th Feb 2016

Role

Team Member

Duration

18 Months

PROJECT DESCRIPTION:

The Project involved production support of the entire database as well as migration activities along with monitoring batch applications.

CLIENT DESCRIPTION:

It is a global payment technology Solutions Company headquartered in Atlanta, Georgia, United States. The company's STAR interbank network offers PIN-secured debit acceptance at ATM and retail locations. It is the largest in the payments industry.

ROLES AND RESPONSIBILITIES:

Analyze the Data Model.

Developing Stored Procedures, Functions based on client requirement.

Modified and created brand new reports in SSRS.

Deploying the SSRS reports, configuring the report managers and scheduling.

Looked after the ad-hoc tickets on database, reports and SSIS packages.

Involved in client interaction for functional and technical clarifications and solutions.

Project #2

Client: - A Real Estate organization (TNH)

Project Title

A Real Estate Solutions Company In US

Domain

Travel & Hospitality

Location

Kolkata

Operating Systems

Windows

Technology

T-SQL, SSIS & SSRS

Database

Sql Server

Team Size

8

Allocation Tenure

1st March 2016 – 19th Jan 2017

Role

Team Member

Duration

10 Months

PROJECT DESCRIPTION:

The Project involves doing enhancements in codes and Reports as per the business requirement, along with doing end to end job handling (Informatica) and production support with time to time developments as well.

CLIENT DESCRIPTION:

It’s an American publicly owned company that provides real estate and relocation services. It owns and franchises several real estate brands and brokerages. It also provides relocation, title and settlement services.

ROLES AND RESPONSIBILITIES:

Analyze the Data Model.

Resolve incoming customer issues involving database and reports (SSRS reports).

Create new Reports as a part of development.

Batch monitoring and debugging related issues.

As part of enhancement, created new database objects, new SSIS packages to load data from enormous tables etc.

Delivering critical reports to the senior management of the organization by creating subscriptions and initiating the automated delivery of reports to the users on report server.

Preparing and reviewing technical design, involved in development of interface with the unit testing and sharing of system testing to have end to end testing.

Prepare the unit test case document and provide UAT support.

Guiding team members while solving critical QA and UAT defects.

Code review and configuration management for the team.

Analyzing codes for business critical issues and suggesting suitable code enhancement/modification to take care of the scenarios.

Liaising with client in Design discussion and issue resolution.

Project #3

Client: - A much renowned Education client (University)

Project Title

Renowned Education client (University) In UK

Domain

Information & Media

Location

Kolkata

Operating Systems

Windows

Technology

T-SQL, SSRS and SSIS

Database

Sql Server

Team Size

7

Allocation Tenure

1st Feb 2017 – 30th June 2017

Role

Team Member

Duration

30th June 2016

PROJECT DESCRIPTION:

The project mainly involved in migration and up gradation of existing complicated applications which had Dot net framework as its UI, SSIS packages for flow of data, SSRS reports which generates daily basis reports which are used by business people for their analysis.

CLIENT DESCRIPTION:

The University is a collegiate public research university in England, often regarded as one of the most prestigious universities in the world.

ROLES AND RESPONSIBILITIES:

Analyze the Data Model.

Resolving all client tickets involving database and reports (SSRS reports).

Needed to migrate the entire set of Reports from 2005 version to 2012 and deploying them at the report server.

Needed to migrate the existing SSIS packages from their earlier 2005 versions to 2012.

Created the complex packages for loading data and also handled the erroneous data in the SSIS Packages.

Deploying the SSRS reports, configuring the report managers and scheduling.

Assist QA team with defect triage, addressing, fixing and deploying code fixes to SIT, UAT.

Manage code releases and deployments to pre-production and production environments.

Project #4

Client: - An amusement park in Abu Dhabi

Project Title

Amusement park

Domain

Information & Media

Location

Kolkata

Operating Systems

Windows

Technology

Azure

Database

Sql Server 2016

Team Size

10

Allocation Tenure

1st July 2017 – 30th Sep 2017

Role

Team Member

Duration

3 Months

PROJECT DESCRIPTION:

This project is meant to be developed from scratch in Azure environment. Business will be just dumping the data files in a desired location from where it needs to be taken to the DWH environment which is in cloud.

CLIENT DESCRIPTION:

It’s a famous amusement park in Middle East which is well known for Go carting.

ROLES AND RESPONSIBILITIES:

Used to understand the nature of data that is getting dumped and need to validate whether it’s in sync with business knowledge.

Needed to create the corresponding objects as per the business logic in all the different layers.

Since here there was no concept of using ETL, had to write multiple Stored Procedures for populating the data in the destination tables.

Also needed to develop the architecture for assisting to incremental load scenario.

Analyze the Data Model.

Do full-fledged Unit round testing for validating the business functionalities.

Project #5

Organization: - Swiss Insurance client

Project Title

General insurance client

Domain

Insurance

Location

Kolkata

Operating Systems

Windows

Technology

T-SQL, SSRS

Database

Sql Server

Team Size

12

Allocation Tenure

1st Oct 2017 – 2nd April 2018

Role

Team Member

Duration

7 Months

PROJECT DESCRIPTION:

It was a scratch SSRS development project. 124 reports needed to be created along with the database development as well.

CLIENT DESCRIPTION:

A renowned Switzerland insurance firm, active all around the globe in different countries. Currently I was working for the Australian venture.

ROLES AND RESPONSIBILITIES:

Complete BRD analysis.

Template delivery of reports.

For analyzing the limitations of the tool in order to achieve client expectations.

Developing sub reports, drill through reports, drill down, graphs, charts etc and deploying them in corresponding environments.

SIT support.

Closing UAT defects and making Code Review document.

Optimize Queries to insert, update and fetch the relevant details from the database.

Promoting to Production and also doing the production deployment.

Serving warranty support post GO Live.

Project #6

Organization: - US Mortgage Bank

Project Title

US Mortgage Bank

Domain

Banking & Financial Service

Location

Kolkata

Operating Systems

Windows

Technology

T-SQL, SSRS, SSIS

Database

Sql Server 2016

Team Size

5

Allocation Tenure

2nd April 2018 - Ongoing

Role

Team Lead

Duration

On going

PROJECT DESCRIPTION:

It is a development project along with giving support to ongoing database structures such as Jobs, Packages etc. Production support was also integral a part of the role.

CLIENT DESCRIPTION:

A leading Mortgage bank in US who deals with home loans and their servicing.

ROLES AND RESPONSIBILITIES:

The main challenge was there was onsite presence from CTS, hence had to directly work with client. Everyday call, task gathering, getting clarifications etc. was an everyday task.

I had to analyze the BRD.

Get requirements directly clarified with client because of the time zone difference.

Developed multiple stored procedures, tables, views and numerous other database objects.

Created numerous SSRS reports, used subscriptions, Tablix, Matrix, Charts, Graphs, Drill through, Sub reports etc.

Also had my hands on creating new SSIS packages and deploying them.

As there was no separate QA team hence had to take the complete ownership of the code and needed to create all test cases myself.

Used TFS for check in my codes and maintain the versions.

From developing the code to testing, getting it validated by client, creating the deployment request and finally moving it production along with post deployment validation was my entire responsibility.

Got many applauses from client for my efficiency.

Personal Details

Father’s Name : Mrinal Saha

Mother’s Name : Ratna Saha

Date of Birth : 30th March 1990

Permanent Address : 16/1/H/48 B.B.Ghosh Sarani, Kolkata

Nationality : Indian

Gender : Male

Language known : English, Hindi, Bengali, Marathi



Contact this candidate