OBIEE, Informatica

Biswarup Dey

Mail: *****.****@*****.***

Mobile: +91-948*******

Professional Summary:

Having 2.6 years of professional experience in software development, which includes

•

development of data warehouse solutions using OBIEE 11g/10g, Informatica Power Center

Tool 9.6.1.

A good experience in analyzing complex business requirements, designing, implementation

•

and management of BI reporting requirements

Worked extensively on Oracle BI Administration tool, presentation services, answers, and

•

interactive dashboards.

Involved in creation of repository and generation of business reports using OBIEE.

•

Expertise in implementing the Oracle BI Security (groups, data access/query privileges),

•

metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).

Configuring and working with Analytics, Scheduler or Delivers.

•

Worked in Data Warehousing development using ETL tools such as Informatica Power Center

•

9.6.1.

Exceptional ability to quickly master new concepts, applications and a team player with

•

exceptional technical, analytical and communication Skills.

Professional Experience:

From 18 December’2012 – Till date worked as an Associate Engineer in Atos, Bangalore.

•

From 07 August 2011 09 June 2012, worked in TCS Passport Seva Project under the payroll of

•

CMC Ltd.

Technical Skills:

Operating system : Windows 9x / 2007, Windows NT and UNIX

•

Programming language : C and C++, HTML

•

Databases : Oracle 9i, 10g, 11g

•

ETL & Reporting tools : Informatica 9.6.1 & OBIEE 11g.

•

Scheduling Tools : Autosys 4.0

•

Qualification:

Degree School/College Board Marks obtained Year

Secondary B.D.Memorial Institute CBSE 70.4% 2006

Higher Techno Model School, Garia W.B.C.H.S.E 71.4% 2008

Secondary

BCA Prajnanananda Institute of Technology WBUT 74.8% 2011

& Management

Project Details:

Project : OFS Reporter

Technology : Oracle 9i, UNIX, Informatica 9.6.1, Autosys, OBIEE 10.1.3.4, OBIEE 11g

Client : Schlumberger, France

Duration : Dec 2012 to Till Date

Role : Associate Engineer

Project Description:

Schlumberger is the leading oilfield services provider, trusted to deliver superior results and improved

E&P performance for oil and gas companies around the world. Through our well site operations and in

our research and engineering facilities, we are working to develop products, services and solutions

that optimize customer performance in a safe and environmentally sound manner. Reporter is a

Business Intelligence tool for Schlumberger Oilfield system. My role is to extract data from several

different sources, and to gather it in a single database read by a reporting Tool OBIEE. With the

reporting tool Schlumberger end users are able to build their own queries in several functional

domains.

Responsibilities:

Build repository at 3 layers Physical Layer (connecting Data sources & import

•

schema),Business Model & Data mapping (create Logical tables & data source mapping ) &

Presentation layer level (create presentation catalogs),create presentation folders & tested.

Developed the reports and created new logical measures in repository

•

Experience in building/customizing/supporting Oracle BI RPD.

•

Involved in preparing of test scripts and assisted the users in UAT testing

•

Design various reports i.e., Drill down, Pivot, Breakdown Reports and Narrative Reports in

•

Answers and with the facility to drilldown and charts.

Resolving issues faced in production environment.

•

Experience in developing ETL mappings and scripts using Informatica Power Center 9.6.1

•

using Designer (Source Analyzer, Mapping designer, Workflow Manager & Workflow Monitor),

Repository Manager.

Involved in testing the pre processor file along with the informatica files to check the

•

consistency between the files.

Using ETL process to Extract, Transform and Load the data into stage area

•

Designed and developed Aggregate, Look up and Update transformation rules (business

•

rules).

Creating, configuring, scheduling and running of Sessions

•

Personal Details:

DOB : 13 Jan 1990

Current address : House No 25, Vinayaka Layout, Doddathogur, Velankani,

Electronic City, Phase I, Bangalore 560100

Passport Details : k4922002, expire on 13/08/2022

Pan Details : BDRPD8936K

Contact this candidate