Business Intelligence and Analytics, Team Management

SOHAM ROY

**, ***** ***** *** ******, Dum Dum, Kolkata 700 028;

Contact: +91-983*******; Email: **********@*****.***

[pic]

IT Business/Data Analyst, Dev & Maintenance (MIS) Lead

Seeking a challenging and rewarding opportunity with an organization of

repute, which recognizes and utilizes my true potential while nurturing my

analytical, functional & technical skills [pic]

PROFILE

. Competent & result oriented professional with an overall experience of 5

years & 11 months in IT

. Onshore Agile Development Lead, streamlining operations & controlling &

coordinating the various client related functions; other functional

strengths include resource management, developing project scope, client

relationships & conducting status meetings

. Experienced in Requirement Gathering/Modelling, Team Management,

Reporting, PL/SQL, Qlikview development & Maintenance and Business

Acceptance Testing

. Equipped with Data warehousing and Data Mining techniques for MIS.

. Practitioner of Analytical techniques Like : Regression Analysis, Time

Series, Factor Analysis, Cluster & Conjoint Analysis, Hypothesis Testing,

Operations Management (Linear Programming with Sensitivity Analysis,

Precision Tree)

Technical Skills

Operating Systems Windows 98/XP/7, Unix

Programming C, C++, Core Java, c#

Languages

Database Oracle

BI Tools Qlikview, BO 6.5.1 (Desktop & Webi Intelligence), OWB,

Statistical Tools WinGADD

SPSS, R, XL-Miner, PH-Stat

Applications MS Office (Word, PowerPoint, Excel)

Other Tools SQL Developer, Toad, BMC Remedy, Clear Case, Clear Quest

[pic]

PROFESSIONAL EXPERIENCE

CAPGEMINI (Jan 2012- till date)

32 Months

Designation: Consultant

Job profile -

> Analysis, preparing status and reporting to higher management

> Requirement Gathering/Elicitation, Data Modelling, Developing and

Maintaining BI reports for IKEA Sales team

> Client communication, preparing incident/problem management trend

analysis & reporting

> Performance tuning, analysis to migrate existing project to Qlikview

> Dashboard & Reports design using Qlikview

> Working on FMA, Unit Testing, Problem Reports and Change Requests

Projects Handled

Project IKEA - Communication & Selling

Client IKEA

Domain Retail - Sales

Duration Jan 2012- till date

Role Onshore Business Development Lead

Environment Oracle

Qlikview, Wingadd, SQL Developer, BMC Remedy, Clear Case, Clear

Tools Quest

TATA CONSULTANCY SERVICES (Oct 2008- Jan 2012)

3 Years 3 Months

Designation: Systems Engineer

Job profile -

> Leading a team of 3 members

> Preparing status and reporting to higher management

> Scheduling and conducting conference calls with clients discussing

project status and planning future prospect of the project

> PL/SQL, UNIX, Batch application developing, testing, scheduling and

handling, Data cleansing and analysis activities, understanding the

existing code, documentation of technical specifications

> Worked as Admin (Supervisor) & Broadcast agent in BO 6.5.1 and BI

reporting

Projects Handled

Project 1 EDW (Enterprise Dataware House) - 56 TB Oracle 10g data warehouse

Client BT (British Telecom)

Domain Retail

Duration March 2009- Jan 2012

Role Team Member, Team Lead

Environment UNIX, Oracle

SQL Developer, Toad, BO 6.5.1, RTD, Clarify

Tools

Project 2 TCS internal (Android mobile apps to conduct online test on Android

enabled mobile phone)

Client TCS internal

Duration Dec 2008- Feb 2009

Role Team Member

Environment Oracle, Web Development

Tools Android, PL/SQL, SQL

[pic]

EDUCATIONAL CREDENTIALS

PG certificate: EPMBD - Business Analysis, Nov 2012 to Jan 2014

Indian Institute of Management, Calcutta

B.C.A., 2008

Techno India, West Bengal University of Technology, C.G.P.A. 8.4

XII, 2005

Bhartiya Vidya Bhavan, C.B.S.E., 71.2%

X, 2003

Indira Gandhi Memorial High School, C.B.S.E., 76.6%

Trainings Attended

OCA from N.I.I.T

Oracle 11G PL /SQL - from Capgemini internal

ITIL V3 Overview - from CAPGEMINI internal

Business Analysis Requirements Elicitation - from Capgemini internal

[pic]

Extra Curricular Activities

. Key member of College departmental football team

. Learnt under national board of fine arts for 3 years, henceforth 4 years

in private

Date of Birth: 21st June 1986

Hobbies: Photography, Travelling

Contact this candidate