Resume

Sign in

Software Engineer Oracle OBIEE

Location:
Abu Dhabi, Abu Dhabi Emirate, United Arab Emirates
Posted:
April 17, 2020

Contact this candidate

Resume:

Professional Summary

Offering ** years of experience in Software Product and OBIEE Development.

OBIEE 11g Certified.

Development and analysis of data warehouse applications using OBIEE 10g,11g and 12C

Experience in all phases of the System life Cycle including project definition, analysis, design, coding, testing, implementation and post production support.

Experience in design and developed Oracle BI repository consisting of three layers [Physical, Business Model & Presentation Layer].

Experience in creating number of Complex measures and Logical columns in BMM Layer as per business requirements by using Different TimeSeries functions like Ago, Todate and other Business logics.

Developed Complex Reports by using the Different Views like Table, Pivot, Chart, Link, Narrative View, Column Selector, View Selector and Combined with Similar Requests.

Created static & dynamic repository variables and Initialization Blocks for different purpose.

Implemented Object Level and Data level Security by creating roles & web groups using External tables and web logic console.

Configured alerts for delivering reports and for Cache Seeding.

Good Experience in managing the OBIEE Web logic Console and Enterprise Manager.

Experience in database Performance Tuning by implementing Parallel Execution, Partitions, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes.

Experience in working with different operating systems like HP UNIX, Solaris and Windows NT/2000/XP.

Involved in complete SDLC life cycle by adhering to Client specific quality processes and align them with client quality Standards.

Working knowledge on different data sources ranging from flat files, Oracle, SQL Server.

Sound knowledge of Data Warehousing Concepts.

Fully conversant with Life Cycle Methodologies from conceptualization to implementation and maintenance.

Programming knowledge of Oracle SQL.

Experience in customization reports by using Report6i.

Self-starter and team player with excellent communication, interpersonal and analytical skills.

Got three times Outstanding Performance Award.

Work Summary

Working as Senior Analyst & OBIEE Lead with Crisil Ltd, Dubai from Aug 2015 to till Date.

Working as Technical Lead with Capgemini India Pvt Ltd, Mumbai from July 2014 to Aug 2015.

Worked as Senior Software Engineer with Zensar Technology, Pune India from Dec 2013 to July 2014.

Worked as Consultant with Capgemini India Pvt Ltd, Mumbai India from June 2011 to Nov 2013.

Worked as Consultant with Magna InfoTech Pvt. Ltd, Mumbai India from Mar 2011 - Jun 2011.

Worked as Software Engineer with Netwin Systems & Software (I) Pvt. Ltd, Nashik India from may 05 – Sep 07.

Education

BSc computer science from Pune university, Maharashtra, India.

MCA from Pune university, Maharashtra, India.

Technical Skills

BI : OBIEE 10g, 11g,12C

RDBMS : Oracle 9i,Oracle 10g,11g.

Operating Systems : Windows 2000, XP, NT,UNIX

Languages : SQL*Plus, PL/SQL.

MS Suite : Word, Excel, PowerPoint, Access.

Web Based Technologies : HTML.

Professional Experience

Project :- 1

Tital

FAB

Client

First Abudhabi Bank

Role

Senior Analyst / OBIEE Lead

Duration

Aug - 2015 to Till Date

Description :-

The objective in the project is to implement Oracle based business intelligence, enterprise performance management for WBG, CAD & LINK Segments using Oracle Business Intelligence Enterprise Edition.

Responsibilities:

Involved in gathering & validating requirements, performed Gap Analysis and Data Analysis.

Prepared Technical Requirement documentation based on reporting requirements.

Design and developed Oracle BI repository.

Design and development of Web Catalog Objects (Dashboards, Pages, Filters, Reports) with different Analytics Views (Pivot Table, Chart, Tabular, View Selector and column selector) as per the business / client requirement.

Performed System integration & User acceptance testing for reports & dashboards with data validation.

Involved in fixing bugs / defects while performing SIT & UAT.

Environment: Oracle BI EE 11g,12c, Windows 2008,Unix,Oracle 11g

Project :- 2

Tital

B&V

Client

Black & Veatch USA

Role

Technical Lead

Duration

Sep - 2014 to Aug 2015

Description :-

The objective in the project is to implement Oracle based business intelligence, enterprise performance management and balanced scorecard solution using Oracle Business Intelligence Enterprise Edition.

Black & Veatch aims to implement OBIEE to help better decision making and enhance on BIC & Excel Based reporting application.

Responsibilities:

Involved in gathering & validating requirements with onsite coordinator, performed Gap Analysis and Data Analysis.

completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs

Prepared Technical Requirement documentation based on reporting requirements.

Design and developed Oracle BI repository.

Design and developed Bi Publisher reports.

Design and development of Web Catalog Objects (Dashboards, Pages, Filters, Reports) with different Analytics Views (Pivot Table, Chart, Tabular, View Selector and column selector) as per the business / client requirement.

Performed System integration & User acceptance testing for reports & dashboards with data validation.

Involved in fixing bugs / defects while performing SIT & UAT.

Environment: Oracle BI EE (11.1.1.7), Windows 2008,Unix,Oracle 11g

Project :- 3

Tital

BCI

Client

Beckman Coulter USA

Role

Senior Software Engineer

Duration

Dec - 2013 to July - 2014

Description :-

Beckman Coulter is a bio-pharmaceutical company manufacturing drugs at a global level. The company had to implement Financials, Supply Chain, Procurement and Spend, HR modules of BI apps to help better organize and quick decision making.

The goal of the project was to upgrade the existing functionality OBIA 7.9.5 with the new OBIA 7.9.6.4 capabilities and also developing new functionality in addition to the existing one.

Responsibilities:

Installed OBIEE 11.1.1.3 on Windows Server 2008 Environment.

Upgraded RPD by using ua.bat file. Performed Any Required Post-Upgrade Manual Steps for Oracle BI EE.

Resolved Post Upgrade RPD Consistency check issue and fixed all the issue related to reports and dashboard after the upgrade in 11g.

Identified impacted & non impacted reports

Deployed OBIEE 11g RPD and Catalog by using Enterprise Manager.

Compared OBIEE 10g reports and Dashboards with OBIEE 11g Reports and Dashboards. Performed Unit testing to validate report and fixed the issues opened by QA and BA team.

Created Users and Groups in the Embedded Web logic LDAP Server by using Oracle Web logic Server Administration Console.

Created Application Roles and Policies using Fusion Middleware Control and mapped Application roles to the Groups.

Implemented Security by using External table Authentication.

Environment: Oracle BI Apps 7.9.5/7.9.6, Informatica 9.5.0, DAC, OBAW, Oracle11g, Windows 2008,Unix

Project :- 4

Tital

HPCL

Client

Hindustan Petroleum Corporation Limited India.

Role

Oracle BI Consultant

Duration

Mar - 2011 to Aug - 2012

Description :-

The objective in the project is to implement Oracle technology based data warehousing, business intelligence, enterprise performance management and balanced scorecard solution using following tools:

1. Oracle Business Intelligence Suite Enterprise Edition Plus (OBI EE +)

2. PeopleSoft Enterprise Performance Management Suite 9.0 (EPM Suite)

HPCL aims to implement Oracle technology based data warehousing, business intelligence, and Enterprise Performance Management and Balanced Scorecard solution to help better decision making and enhance on MIS reporting. This is to help HPCL to better manage the business and customer satisfaction.

Responsibilities:

Involved in requirements gathering of the various work streams by meeting with the business user, performed Gap Analysis and Data Analysis.

Design and developed Oracle BI repository for Distribution, GL & Localization Module.

Developed Calculated measures, level based measures and dimension hierarchies in the Business Model and Mapping Layer.

Design and development of Web Catalog Objects (Dashboards, Pages, Filters, Reports) with different Analytics Views (Pivot Table, Chart, Tabular, View Selector and column selector) as per the business / client requirement.

Creating hierarchy, formula, measures etc in BMM layer.

Performed Repository Testing and validation before exposing Business Models in the Presentation layer.

Performed System integration & User acceptance testing for reports & dashoards with data validation.

Involved in fixing bugs / defects while performing SIT & UAT.

Involved in deployment of Web Catalog Objects & RPD from DEV to SIT,UAT & PROD environment.

Implement Data level & object level security by created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.

Involved in Support team for Go-live Modules.

Environment: Oracle BI EE (10.1.3.3.3), Windows 2007,Unix,Oracle 11g

Project :- 5

Tital

NetBank Application

Role

Software Support Executive

Organization

Netwin Systems & Software (I) PVT LTD

Duration

Jan - 2007 to Sep - 2007

Description :-

Netwin Systems & Software (I) Pvt. Ltd. is a privately held software company that focuses on delivering customized solutions to its clients by converting business ideas into well defined solutions. It has been involved in Web Application Development, Custom Desktop Application Development, Quality Assurance and Testing, Software Maintenance, Embedded,System Software and OracleConsulting.There client base includes Co-op Banks and Co-op Credit Societies in India. The company focused on developing important segment, namely banking and finance. Netwin rapidly acquired many satisfied clients, amongst them large banks and small co-op credit societies. Netwin have a satisfied customer base of more than 1200 banks and financial companies.

Responsibilities:

Involved in Understanding the business requirements and find analysis gap.

Client Requirement Study and Analysis.

Involved in to solve client business problems related to superbank application.

Developing and customization Reports by using Report Builder as per client requirement.

Working with Development and Test Team to ensure requirements are achieve.

Involved in testing new developed modules in office as well as at client side and implement.

Conducted end user training session for exercising full use of application.

Environment:Windows 2003, Oracle 9i, Report Builder 6i

Personal Details

Name : Mr. Kishor Throat

Languages : English, Hindi, Marathi.

Nationality : Indian

Marital Status : Married



Contact this candidate