Bansidhar Mohapatra

Contact Number: 779-***-****

acgal0@r.postjobfree.com

Professional Summary

. Around 5.9 years of experience in IT in various projects with a

wide range of roles and responsibility and skill set.

. Have good experience in Client interaction and project leading, team

management.

. In-depth working experience in Database Architect, Database

administration, Data warehousing with SSIS, SSAS, SSRS and IBM

Datastage.

. Strong hand in T-Sql and PL/Sql in Oracle

. Good communication skills, interpersonal skills, self-motivated, quick

learner, team player, Flexible to Environment.

Technical Skills

Data warehousing :MSBI(SSIS, SSAS,SSRS), Infospare Datastage,

Biztalk

Mapping & Orchestration

Database :Database Administration, Data warehouse Design &

Modeling, Performance Tuning, Query Design with T-Sql &

PL/Sql

Languages :C#.net, VB.net, Asp.net

Functional Skills

Client Facing :Communicate with client for requirement

analysis, project

demonstration, release management.

Leadership :Discuss and help team member for business requirement

clearance, and technical help.

Communication :Good communication with client and team

member.

Quick Learner :Enthusiastic to learn a new language and technology for

the benefit of project and company.

Education

. Microsoft Certified Database Administrator (MCDBA)

. Microsoft Certified Technology Specialist (MCP)

. DOEACC 'O' Level (Diploma) from Department of Electronics Govt. of India

. Master in Computer Application (MCA)

Personal Details

Full Name Bansidhar Mohapatra

Last Company IBM India Pvt. Ltd

Current Designation IT Specialist

Perm/Contract Permanent

Current CTC 6 Lakhs

Expected CTC Negotiable

Notice Period Immediate join(currently not working)

Have VISA Yes

Preferred Location Anywhere

PAN Card No : AVNPM3998F

Have VISA : Yes H1 B

Passport : H1529905

Current location C/o Babu Rao,

H.No-10-5-3/2/3/F

Uco Bank Colony

Ahmed Nagar, ST No-2, Masab Tank,

Pin-500028

DOB : 8th July 1977

Contact No. : 779-***-****

Email : acgal0@r.postjobfree.com

Nationality : Indian

Projects

Nov 2012 - May 2014, IT Specialist, Company: IBM India, Client : Manulife

Insurance, Canada

Manulife Insurance is a Canada base insurance company which deals insurance

and other employee contribution details. My team was assign to creat ssis

package for each customer of Manulife, generate various type of report, and

design database for OLAP and OLTP.

Work on SSIS : Design/create SSIS package as per the requirement, write sql

script, unit test, prepare test case and release note and submit code

review.

Work On SSAS: Data modeling for OLAP. CUBE design, MDX query.

Work in Sql Server : Design /Architect whole Client Server architecture,

Create Cube, Design the whole structure of data availability. Work on all

DDL and DML script (T-SQL code) as per requirement.

Environment: SQL Server 2008R2/2012, MSBI 2008/2010, MS Visual Studio

2008/2010, Biztalk Server 2004

Team Size : 5

Nov 2009 - Oct. 2012, IT Specialist, Company: IBM India, Client : CITI

Bank, USA

Citi Bank of USA devided all their work with various small projects. So our

team assigned a big responsibility tocreate its historical database, jobs, SSIS packages, Analysis report, migrate its database. Deployement.

Coodinate with other team.

Team lead Activities: Communicate with client and Analysis its requirement,

and work on its database design. Coordinate team and prepare work plan for

team member and work on it. Provide KPP trainings to all the project

members.

Work on Sql Server : Create Sql script, Stored procedure to support above

application. Work on performance tuning of Sql script. Work on sql server

Reports application, work on its enhancement project.

Work on MSBI: Create and enhance SSIS package. Design CUBE, work on backend

like database modeling for cube. Create report.

Environment: SQL Server 2005 MS Visual /2008/2010/2012

Team Size : 10

Sept 2008 - Nov. 2009, IT Specialist, Company: IBM India, Client :

PMI(iSMS), Brazil

Philip Moris International (PMI) is a Swizerland based company doing

business in multiple country. This application names International sales

and merchandising system, (iSMS) mainly focus on business sales and its

merchandising system. My roles are as follows :

Senior Team Member Activities: Submit deliverables in Clear case tool for

production release. Responsible to provide best solution to the client for

enhancement, migration, new project development by identifying the best fit

customer requirements to the client.

Work on Sql Server : Develop & support on PMI Custom framework application

which is developed in .net language with sql server. database design and

complex query design. Develop custom sql framework (Tools) for required

operations

Work on MS BI : Work on Design dtsx package, write sql queries for its

operations like import & export data.

Work on .net : work on some support & maintenance application as per bug

and issues given as ticket number.

Environment: MS Visual Studio 2005, Sql Server 2005, Oracle.

Declaration

I Bansidhar Mohapatra hereby declare that the above written

particulars are true to the best of my knowledge and belief.

Date :

Location Signature

Contact this candidate