OBIEE, Informatica and ODI

Saket Krishna

*****-**************@*****.***

Mobile - +91-782*******

Career Objectives

To achieve high standards at my workplace and constantly upgrade myself with knowledge gained from experience, colleagues, education and else where and apply the knowledge for the success of the organization that’s I am part of.

Skills Summary

Having 9 years of Relevant Experience in DW/BI.

Proficient in Oracle Technologies like SQL, PL/SQL.

Worked on BI publisher (Formerly XML Publisher).

Extensively worked on OBIEE Apps.(On Siebel)

Worked on defining governance for OBIEE Security, its capabilities and implementation.

Expertise in DAC.

Installation, Fail over cluster Set up, Multiple RPD and Presentation Server Set up

Integration of OBIEE Server with Hyperion EPM Server.

Worked on Hyperion Essbase.

Development and customization of Hyperion IR, Hyperion FR.

Worked on Informatica Power Center.

Experience in preparation of technical documents as per DW/BI Implementation Methodology.

Capable of working independently and as well as a part of a team.

Good presentation, Communication and Analytical Skills.

Working knowledge of tools like Share Point, HP Quality center, WinScp, WinSql, Tivoli Job scheduler, Toad, SQL Developer, Putty.

Qualification

Master in Computer Application (M.C.A) from HNBGU University in 2006.

Bachelor in Computer Application (B.C.A) from HNBGU University in 2003.

Skill Set

AREA OF WORK

PACKAGE NAME

Servers

Hyperion Workspace 9x/11.1.1.3, OBIEE 10x, OBIEE 11x

Languages

SQL,PL/SQL,XML

Database

Oracle9i/10G/Hyperion Essbase9x/11x

GUI

OBIEE 10.1.3.4.1, OBIEE 11g, BI Publisher, Hyperion IR, Hyperion FR, Smart View

Tools

Toad, SQL Developer, Perforce, Share Point, HP Quality Center, Visio, Putty, DAC

ETL

Informatica 8x, 9x

Operating Systems

Windows 2000/XP/2003/7

Work Experience

Currently working with Computer Technology Resources, Irvine, CA from Mar’2015 to till date.

Worked with Principal Financial Global, Pune from Feb’2014 to Mar’2015

Worked with Oracle Corporation, Bangalore from Oct’ 2010 to Jan’2014

Worked with 3i-infotech, Noida from Sep’2006 to Sep’2010

Projects & Work Experience

Project #10

Client

Principal Financial Global

Project Name

MKS W2

Organization

Principal Global Services

Duration

Feb 2014 to Mar 2015

Database

DB2, Oracle, SQL Server

Environment

Unix Box, Windows

Tools Used

OBIEE 11.1.1.7, Business Objects, Informatica

Role

Tech Lead

Responsibility

Worked as HR IT BI. Sending data feed and receiving feed from external vendor for HR related details for e.g. W2, HSA, Benefits, Payroll, 401K for Principal. Set up OBIEE Team, defining security and governance/process around it. Generating HR Business Objects reports, Maintain Outbound/Inbound Data feed and Warehouse load.

Team Size

5

Project #9

Client

Chola Finance

Project Name

App 3

Organization

Oracle Corporation

Duration

Sep 2013 to till date

Database

Essbase 11.1.2.2 (Planning)

Environment

Unix Box

Tools Used

OBIEE 11.1.1.7

Role

Senior Developer (OBIEE)

Responsibility

Working on Financial reports for which data is coming from ASO (GL, Credence) and Multiple BSO (Cash Flow, Rating, Liquidity) cubes. UAT and Prod Server setup and Integration with OBIEE 11.1.1.7 with EMP 11.1.2.2 on UNIX Box

Team Size

5

Project #8

Client

Blackberry

Project Name

EDDW Migration

Organization

Oracle Corporation

Duration

Feb 2013 to Aug 2013

Database

Oracle 10g

Environment

Unix Box

Tools Used

Informatica 8.6.1

Role

Senior Developer (Working on Informatica)

Responsibility

Migrating existing Informatica mapping target tables from HP Neo View to Oracle Exadata. Creating Mappings for History data load and migrating incremental mappings to point to Oracle Exadata. Creating Migration worksheet for history data load, getting approval and preparation of UT Doc and promotion plan.

Team Size

14

Project #7

Client

Agilent

Project Name

OBI Apps Implementation and Support

Organization

Oracle Corporation

Duration

July 2012 to Jan 2013

ERP

Siebel CRM

Database

Oracle 10g

Environment

Unix Box

Tools Used

OBIEE 10.1.3.4.1/Informatica 9.0.1/DAC

Role

Senior Developer (worked on Informatica and DAC)

Responsibility

Interacting with client as an individual contributor from my company. Working on creating custom tables, developing custom mappings and maintaining the prebuilt mapping as well for type 1 and type 2 changes. Reflecting the same in DAC as our daily schedule load and monitoring the daily load on test. Support for UAT, Preparing the migration doc from Test to Prod

Team Size

6

Project #6

Client

Professional Golfer Association of America

Project Name

PGA

Organization

Oracle Corporation

Duration

Jan 2012 to Jun 2012

ERP

Oracle Fusion Apps

Database

Essbase 11.1.2.1

Environment

Unix Box

Reporting Tool

Hyperion Essbase 11.1.2.1, Hyperion Financial Reports 11.1.2.1, Smart view, Report Script

Role

Senior Developer (Worked on Essbase and Financial reports)

Responsibility

Getting requirements from client, Writing Calc script as per requirement and developing FR reports and maintaining as well. Working on smart view and writing report script on demand basis.

Team Size

35

Project #5

Client

NetApp

Project Name

Everest

Organization

Oracle Corporation

Duration

Nov 2010 to Dec 2011

ERP

Oracle Application R11.5.9 to R12

Database

Oracle 10g

Environment

Unix Box

Reporting Tool

BI publisher (Formerly XML Publisher), OBIEE 10.1.3.4.1

Role

Senior Developer (Worked on BI Publisher multilingual reports for Supply chain(Quoting, Pricing and Order to invoice))

Responsibility

Getting requirements from module leads from client side, Preparing HLD and LLD document, developing reports, preparing .xlf files for corresponding languages and test cases.

Team Size

70

Project #4

Client

Deutsche Gulf Finance

Project Name

Islamic Mortgage Finance System

Organization

3i-infotech, Noida

Duration

Jul 2009 to Sep 2010

Database

Oracle 10g

Environment

Windows

Reporting Tool

OBIEE (Dashboard, Answers, Delivers, Scheduler, RPD),

BI Publisher

Role

Senior Technical Consultant (Worked OBIEE Reports for Loan origination, collection and management Modules and multilingual BI Publisher reports.

Responsibility

Getting requirements from client, providing the technical feasibility and preparing the technical document and working on BI Layer and few reports. Giving walk through on reports and getting sign off.

Team Size

9

Project #3

Client

VeriSign Inc (US)

Project Name

DW/BI Implementation.

Organization

3i-infotech, Noida

Duration

Jul 2008 to Apr 2009

Database

Oracle 10g

Environment

Windows

Reporting Tool

OBIEE (Dashboard, Answers, Delivers, Scheduler, RPD) Hyperion Essbase 9.3.x, Informatica 8.1.1, HP Quality Center 9.2

Role

Senior Technical Consultant (Worked Essbase cube and OBIEE Reports for Sales Module and Informatica and OBIEE for Finance Reports).

Responsibility

Getting requirements from client, providing the technical feasibility and preparing the technical document and getting approval. Building cube based on parent and child data file. Writing calc script, taking back up of cube. Developing reports preparing Test cases moving report to Test

Team Size

10

Project #2

Client

Avago Technology Pvt. Ltd.

Project Name

Avago Data Warehouse Enhancement

Organization

3i-infotech, Noida

Duration

May 2007 to Jun 2008

Database

Oracle 10g

Environment

Linux Box

Reporting Tool

Essbase Analytic Services 9.2,Hyperion Interactive Reporting Studio, Financial Reporting, Workspace 9.2

Role

Technical Consultant(Worked on Shipment and backlog cube and IR report having drill from summary to details report and Publishing Reports on Workspace)

Responsibility

Interacting with Leads and developing reports and preparing Technical Design document and Test cases

Team Size

18

Project #1

Client

IATA (International Air Transport Association)

Project Name

GAIA (Gateway for Aviation Intelligence and Analysis)

Organization

3i-infotech, Noida

Duration

Nov’ 2006 to Mar’ 2007

Database

Oracle 9i

Environment

Windows XP

Reporting Tool

Hyperion Designer 8.2/8.5, Hyperion Performance Suite 8.5

Role

Technical Consultant(Worked on IR Reports and Published them on Workspace)

Responsibility

Interacting with Leads and developing reports and preparing Technical Design document and Test cases

Team Size

6

Personal Details

Name: Saket Krishna

Father’s name: Sri. Sunil Kumar Verma

Date of Birth: 15-10-1981

Languages Known: English, Hindi

Nationality: Indian

Contact this candidate