Biswarup Roy

Mobile: +91-905******* ~ Mail: aceu6e@r.postjobfree.com

As a Techno Functional Consultant with 3.6 years of working experience in

Business Analysis with multi-tasking organizational abilities: Identifying,

Implementing, Developing Strategies & Solutions for Business Process /

System. Seeking challenging assignments with a growth oriented organization

of repute to leverage my skills & talents to the best of my capabilities.

PROFESSIONAL SYNOPSIS

* A Qualified B.Tech with enriches experience in Business Analysis with

strong technical exposure in Business Intelligence (Data warehouse)/Data

Integration tools.

* Presently associated with ISC Software Ltd as a Business Analyst.

* Strong Domain knowledge in Banking & Financial Services (Credit Card,

Prepaid Card, Credit System & Core Banking System).

* Experience in Banking Technology/ Applications (i.e. Global Data Feeds

<MasterCard / VISA> to Expense Management System, ERP, Custom Reporting,

Dashboard & Analytical Tools).

* Work as liaison between the Business Community/Stakeholders and

Information Technology Group to support the Initiation, Conceptualization

and design phase of the Project life cycle.

* Interacting with Business Stakeholders/ Global Product Owners for

requirements gathering, prioritizing & detailing. Understanding,

analysing requirements and preparing Business Requirement Documents

(BRD), Functional Specification (FSD, FRD) & Software Specification (SRS)

using Models / Use Case diagrams to represent the System - Functions

involved.

* Responsible for defining, designing Business/Functional Solutions &

Implementing Product Enhancements to Support Business Operations.

* Expertise in Business Consulting, Business Analytics & design business

models/case based on business requirements. Expertise in business process

Mapping & process management.

* Analyse the functioning of the current process (SDLC) & develop effective

solutions for improvement. Exposure in Gap/Impact/Risk analysis &

Implementing Change Management.

* Effectively manage assigned projects. Accountable for Project planning &

Implementation.

* Exposure in Testing Modules, Test Analysis & UAT. Work with UAT, SIT, QA

teams by reviewing Test case, Defect log to ensure development / CR meets

the requirements.

* Experience in Data Analysis techniques (Data

Modelling/Mining/Mapping/Standardization) & Data Management for new

Customization & Implementation in Data warehouse.

* Experience in System Re engineering & Data Quality Improvement of various

Business Intelligence & Data Integration Tools (Analytical & Custom

Reporting).

* Strong functional knowledge on Micro strategy (Dashboard). Experience in

designing Report layout and defining back end logic to display the report

based on business requirements.

* Sound knowledge of Oracle / RDBMS (Database basic concepts). Strong

Exposure on SQL.

* Excellent Statistical/Analytical/Strategic skills & approach towards

problem solving. Possess excellent team spirit helping in the easy

achievement of the personal & organizational goals.

* Successfully completed certification in Business Analyst Professional

(Key techniques & Knowledge areas) / IT Project Management endorsed by

IIBA and PMI.

CAREER HIGHLIGHTS

* June 2014 - Till Date with ISC Software Private Limited (CoreCard

Software Inc.) as a Business Analyst.

* February 2011- June 2014 with TATA Consultancy Services Ltd as a Business

Analyst.

PROFFESSIONAL EXPERIENCE

Project Title Citi Bank-Introduction of Global Account Status code &

Transaction code in Global Data Repository (GDR).

Client/Project Citi Bank Global Product Development Team : Business

Role Analyst (Data Integration)

Environment ETL, Business Intelligence Tools, Data warehousing

Description of the Project:

> Phase I- Objective of this project is to upgrade the data (Status Code &

Transaction Codes) maintained in DB tables so that the data in all

downstream applications will be in sync & normalized.

> Phase II- Create new standardized unique global codes which will be

offered to the global clients to understand the Card status & type of

transaction coming from various regional processing platforms.

Key Deliverables:

o Business requirements gathering & analysis. Developing business cases,

models & prepared BRD.

o Functional study & solution designed on the proposed DWH enhancement and

Data quality improvements & management in all downstream application

(incl Analytical & Reporting Tools).

o Data Mapping, Data Management & defining the structure of lookup tables

for new implementation in Data repository. Responsible for overall

Project planning & implementation, UAT Coordination.

o Impact analysis to evaluate the impact on downstream application (Global

Data Feed, Custom Reporting & Custom Analytical Tools) & Client Expense

System- Concur.

Project Title Global Data Feeds (CDF (MasterCard)/ VCF (VISA)/ CCF

(Citi) /GBF (Citi)

Client/Project Citi Bank Global Product Development Team : Business

Role Analyst (Data Integration)

Environment Ab Initio/Java (ETL), ERP- SAP/IBM, Expense Management

System- Concur

Description of the Project:

> - Commercial Card GTS offers Global Standard Outbound File Feeds to end

clients for Card demographic information & transaction details

(reconciliation) through define file formats/types.

- Objective is to upgrade the Custom/Standard Data Feeds (data received

from regional processing platforms through Association) so that the data

can be used globally. Also Global File Feeds will be in sync with the

paper statement/online statement and make payments to Citibank by global

clients.

Key Deliverables:

o Requirements analysis from global/regional product team & detailed system

study on E2E data flow.

o Prepared the data mapping & data management which includes the data

loading flow chart to DWH.

o Prepared the BRD & provide the business solution on the proposed

enhancement.

o Data analysis & enhancing custom global data feeds as per the

business/clients requirements.

Project Title Citi Bank Custom Analytical System (CCAS)

Re-Engineering

Client/Project Citi Bank Global Product Development Team : Business

Role Analyst (Data Integration)

Environment Commercial Analytics-Custom Analytical System (CCAS),

Business Intelligence

Description of the Project:

> Purpose of this project is to develop a method for managing the global

needs of the commercial cards regions to be able to analyse data that is

available globally, by region, and by country. Today's environment lacks

the capability to deliver information without significant effort.

Key Deliverables:

o Prepared the global data mapping chart which provides the mapping of the

each data element received from global platforms & Determination of key

aggregate data elements. Determining the DB table & Data modelling based

on the global chart. Prepared the Data Mapping between Regional Data

Processing Platforms -> GDR-> Analytical System (CCAS) -> to make the

data globally available

Project Title Citi Bank (LATAM & CHINA)- Dual Currency implementation

in CCRS

Client/Project Citi Bank Global Product Development Team : Business

Role Analyst (Data Integration)

Environment Micro Strategy/Data warehouse -Citi Custom Reporting

System (CCRS)

Description of the Project:

> As part of the LATAM/ASIA dual currency project, CCRS needs to be

analysed to make sure that the clients can run global/standard reports

which will provide correct information, in the correct layout with

respect to Dual Currency implementation.

Key Deliverables:

o Elicitation & analysing the Business & Functional requirements from

Global/Regional Product manager and documented the same in BRD.

o Prepare & analyse the report specification (Micro Strategy) based on the

dual currency requirements/effects. Prepared the project summary & FSD

for development efforts.

o Overall project planning & implementation. Solution analysis and the

impact on end customer. Accountable for preparing effort, estimation,

proposal and strategy.

o Define the reports backend logic to capture the data from data warehouse

(defining report- Attribute/ Filter/Prompts/Metrics).

Project Title Implementation of Spend Reports through Dashboard

Client/Project Citi Bank Global Product Development Team : Business

Role Analyst -Data Integration

Environment Micro Strategy/Data warehouse -Programme Dashboard

Description of the Project:

> This project is to design & implement Financial (Spend) Report through

Programme Dashboard which will be used by Citi Bank customer for their

Spend Analysis/Budgeting.

Key Deliverables:

o Elicit the Business/Functional requirements from Global stakeholders.

Requirement analysis & Prepared BRD & detailed Functional Specification

document for new implementation.

o Analyse the key data element, data points & financial modelling of data

for new implementation.

o Define Dashboard report layout & design back end solutions for data flow

as per the requirements.

Financial Modeling

V Monthly Spend/Global Forecast Report : By Banking Product/Global

Region/Financial Portfolios

- Developing business solution to get the global spend/sales data from

daily transactions posted in system & defining DB table to store the

financial spend details in data warehouse for Financial Reporting.

- Financial data modelling for new customization & develop the financial

model, report layout/specification & back end logic which can be view from

Reporting tool (Micro strategy).

- Preparation of the monthly Scorecard report, Spend report, dashboard

which can be used by Global & Regional Product heads to view the detail

spend of each global region/country for a particular month.

V Top 50 Customer Analysis:

- Derived business solution to identify the monthly TOP Customer's details

from DWH with respect to overall spending at Citi Bank. Data point analysis

& financial data modelling to designing the report layout/specification.

- Provide the monthly report which displays the comparison of customer

performance between present year v/s last year (Benchmarking).

Academic Credential

. Successfully completed Bachelor of Technology (B.Tech) in Biotechnology

from Maharishi Dayanad University (2004-2008).

Certification

V IIBA (International Institute of Business Analysis) & PMI (Project

Management Institute):

- Successfully completed certification in key techniques & knowledge

areas of business analysis.

- Successfully completed PMI endorsed certification in Project Management-

Execution IT Project

- Knowledge of BABOK (Business Analysis Body of Knowledge).

V Oracle Workforce Development Programme: Oracle certification on Database

Administration System (9i), Oracle SQL/PlSQL.

Technical Skills

. Oracle: Knowledge in Oracle Database Management System. Sound knowledge

in Oracle database concepts, backup & recovery.

. Micro Strategy (Dashboard): Strong functional exposure on Micro strategy.

Sound knowledge on Report layout design, defining report

attributes/metrics/ filter & prompts. Developing functional solution to

display report data in expected layout.

. Business Intelligence: Experience in various data warehouse operation,

Business Intelligence & Data Integration Tools (Data Management).

Knowledge in Database table design.

. Data Analytics/Data Analysis: Restricting and sorting data, manipulating

data, data standardization, data migration. Strong working knowledge on

Data mapping/Data Mining processes. Sound knowledge on data modelling

techniques.

. SQL & PlSQL: Strong exposure on SQL Statement Processing & batch

statement in PlSQL.

. RDBMS: Exposure to Relational Database Architecture, Data integrity,

Relational model.

. Testing (UAT): Knowledge of different testing modules & techniques.

Strong Exposure in UAT & Testing Analysis. Preparation & reviewing the

test cases/test scenarios/defect logs.

. MS Office: Working knowledge of MS Office- Excel, Presentation (Trend

line /Graph/Charts), and Microsoft Visio.

Personal Details

Name: - Biswarup Roy

Date of Birth: - 15th March, 1986

Nationality: - Indian

Marital Status: - Married

Passport Details: - J8197323

PAN Details: - AYAPR1689L

Present Address: - 2/144A Bijoygarh, Kolkata-700032, West

Bengal.[pic][pic]

Contact this candidate