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