Project Informatica

Souravi Bhowmik Mobile No: +1-414-***-****

OBIEE Developer Mail ID:*******.*******@*****.***

Professional Summary:

Overall 7.5 years of Professional experience.

6+ Years of experience in obiee development.

6+ Months of experience in Oralce Cloud Analytics, Preparing Data Models,Data Massaging, Creating Modules & Reports.

Working in the field of Information Technology on Oracle BIEE Analytics, Design and Development for BI Systems on Oracle database with UNIX Environment for last 6 Years .

Extensive experience on script Development & Testing of Load/Performance on OBIEE 11g by JMeter.

Developed different layers of Admin Tool (Physical, Business and Presentation Layer).

Excellent working Knowledge in development of OBIEE including Oracle BI Answers, Oracle BI Delivers, Oracle BI Interactive dashboards, Oracle BI Administration tool.

Strong background in RDBMS (Oracle) and Data warehousing concepts.

Good knowledge of SQL with the experience in constructing the tables, synonyms and views.

Good knowledge in Star, Snowflake schemas.

Real Time experience in Creating Dimensional Hierarchies, Level Based Measures. Time series Functions, Initialization Blocks and Variables.

Real Time experience in aggregate navigation, level Based measures in Business Model, logical and physical column, opaque view table.

Real Time experience in cache Management.

Real Time experience in Webcat Migration.

Experienced in developing Write Back Reports.

Experienced in setting up & using MUD environment.

Proficient in working on WebLogic Admin Console and Enterprise manager and having in depth knowledge on the Oracle Business Analytics warehouse.

Worked in Supply chain and Order Management analytics.

Worked on security privileges for subject area and dashboards according to user requirements.

Real Time exposure to connection pools creation, physical tables, defined joins and implemented authorizations in the physical layer of the repository

Hands on experience in different kinds of report development (pivots, charts, tabular)

Hands on experience in ETL load monitoring using Dac, Informatica and data sync.

Experience in gathering requirement’s and analyzing the requirement’s for developing rpd and report creation.

Experience in leading multiple projects executing onsite/offshore model and provide optimum solutions

Excellent presentation skills and ability to communicate with stakeholders, organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively with end-users and different teams of IT organizations.

Employment History :

Worked as Oracle Consultant with Regal Beloit Corporation, Grafton, US from February 2017 to January 2019.

Worked as Oracle Associate Consultant with BIAS CORP, Hyderabad, India from June 2015 to May 2016.

Worked as consultant Associate Engineer with Regal Beloit Corporation, Hyderabad, India from June 2012 to May 2015.

Technical Skills:

BI Tools : OBIEE 10g,11g,12c

ETL Tools : Informatica Power Center, DataSync

Performance Testing tool : JMeter with Apache

RDBMS : Oracle 10g,11g,12c

Database Language : SQL

Operating Systems : Windows and UNIX.

Programming Languages : C, C++

Others : Toad for Oracle 9 & 12, MS Word, MS Excel.

Educational Qualification:

B.Tech in Computer Science & Engineering from CV Raman College of Engineering, BPUT University, Bhubaneswar in the year of 2007.

Project # 1

Project Name

Enterprise Asset Management - Implementation

Client

Regal Beloit Corporation

Environment

Oracle 10g, OBIEE 11g, Informatica 9.2 on AIX Power system 64 bit 6.1

Time

Aug 2012 to Dec 2012

Project # 2

Project Name

Manufacturing Analytics - Implementation

Client

Regal Beloit Corporation

Environment

Oracle 11g, OBIEE 11g, Informatica 9.2 on AIX Power system 64 bit 6.1

Time

Mar 2013 to Nov 2013

Project # 3

Project Name

Oracle R12 upgrade

Client

Regal Beloit Corporation

Environment

Oracle 11g, OBIEE 11g, Informatica 9.2 on AIX Power system 64 bit 6.1

Time

Mar 2014 to Feb 2015

Project # 4

Project Name

Sonoco

Client

Sonoco Product Company, Hartsville, South Carolina

Environment

Microsoft SQL Server database, OBIEE 11g on Windows 2008 server

Time

July 2015 to Mar 2016

Project # 5

Project Name

Neenah

Client

Neenah Paper, Inc., WI

Environment

Microsoft SQL Server database, OBIEE 11g on Windows 2008 server

Time

Oct 2015 to May 2016

Project # 6

Project Name

Regal - Support, Development and Project Support

Client

Regal Beloit Corporation, Grafton, WI

Environment

OBIEE 12c, Informatica 9.5.1, DAC on Oracle DB 12c

Time

Feb 2017 to Jan 2019

Project # 7

Project Name

PTS(Oracle conversion project)

Client

Regal Beloit Corporation

Environment

Oracle 12C, OBIEE 11g, Informatica 9.2 on AIX Power system 64 bit 6.1, OAC

Time

July 2017 to Sept 2018

Project # 8

Project Name

Pricing Analytics

Client

Regal Beloit Corporation

Environment

Oracle 12C, OBIEE 11g, Informatica 9.2 on AIX Power system 64 bit 6.1, OAC

Time

Oct 2018 to Dec 2018

Personal Profile:

Name : Souravi Bhowmik

Gender : Female

Nationality : Indian

Languages Known : English

Phone Number : +1-414-***-****

Declaration:

I hereby declared that all the information furnished above is true to the best of my Knowledge.

Date : 27Th May, 2019

Place: Grafton Souravi Bhowmik

Contact this candidate