Rajiv Datta
(M) +1-647-***-****
E-Mail: *****.*****@*******.***
LinkedIn: https://www.linkedin.com/in/rajivdatta
Executive Summary...
Over 14 years of experience in IT Industry and over 6+ years of experience in designing, development and implementation of OBIEE.
Expertise in full life cycle Enterprise Business Intelligence implementations and have an understanding of all aspects of an implementation projects.
Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
Experienced in migration of RPD between dev/test/prod environments.
Extensive experience in OBIEE Administration Tool, OBI Answers, OBI Intelligent Dashboards, OBI Publisher and Agents with OBIEE Applications.
Experience in developing Dimensional Hierarchies/Creating Aggregate Measures/Aggregate Tables/New logical columns/Filters/Variables/Time Series Functions as per business requirements.
Experience in developing Dimensional Hierarchies/Creating Aggregate Measures/Aggregate Tables/New logical columns/Filters/Variables/Time Series Functions as per business requirements.
Proficient in configuring Security settings at various levels both in Repository level (OBIEE Administration Tool to setup Groups, Access Privileges and Query Limits) and Presentation Catalog level.
Experience Integrating LDAP Server for authentication of users and working in Multi User Development Environment (MUDE).
Experience developing reports & dashboards in OBIEE (BI Publisher, Dashboard, Answers, Delivers, Oracle BI for Microsoft Office).
Expertise in Creating Dynamic Dashboards and OBIEE Answers using Prompts, Filters, Calculations, Charts, Pivot tables, View Selector and Conditional Formatting.
Experience using OBIEE 11g, especially in configuring Security settings using Weblogic Server (Users and Groups), Oracle Enterprise Manager (OEM for Roles and Privileges) and Presentation Catalog.
Strong Knowledge and understanding of Relational Databases, data warehousing concepts and querying tools.
Very strong in Oracle PL/SQL programs, Procedures, Packages, Functions, Triggers and other objects.
Designed and implemented successful Proof of Concept (PoC).
Experience in translating user requirements into detailed functional and technical specifications, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
Experience in creating entity relational & dimensional relational data models with Star schema and Snowflake schema.
Excellent Written and Verbal Skills; Ease to learn and apply new technologies and improve.
Technical Skill-set at a glance…
Reporting Tools
OBIEE 10g/ 11g
ETL Tools
ODI 12c
Tools
Toad, SQL Developer, SQL*Plus, DAC (Data Warehouse Application Console)
RDBMS
Oracle, Teradata.
Languages
SQL, PL/SQL, UNIX Shell Scripting, Java Script
Web Technologies
HTML
Professional Certification, Awards and Training…
Oracle Business Intelligence Foundation Suite 11g Essentials
Oracle Certified Professional (OCP) in Application Development and Oracle Certified Associate (OCA) in Oracle Database Administration.
Brain Bench certifications in Oracle PL/SQL Fundamentals, Oracle PL/SQL and RDBMS concepts.
Attended training on Oracle Forms and Reports: Move to 10g from Oracle University.
Attended training on OBIEE 11.1.1.6.5 from Oracle University.
Projects in detail…
Title: Senior OBIEE Consultant From March 2015- December 2015
Client: Reed Exhibitions
Employer: Acrotrend Ltd.
Responsibilities
Interacted with Business users for gathering Reporting Requirements.
Designed and implementing OBIEE security using Application Roles and Groups and Row Level Security.
Designed and Developed the OBIEE metadata Repository using OBIEE Admin tool.
Created Aliases for all physical tables to avoid circular joins and self joins.
Created Drill-Down Hierarchies and set the estimated levels in Hierarchies, Logical columns & manipulated Fact column in BMM Layer as per requirement using Calculation Wizard.
Created Time Series objects for comparing business performance with previous time periods using Ago and ToDate Functions.
Created various Presentation Catalogs in presentation layer with tables and sub tables.
Developed interactive Management Information reports with different Analytic Views (Tables, Pivot Tables, Charts, Column and View Selectors, Narrative, Tabular with Global and Local Filters) using presentation services.
Responsible for deployment of repository and catalog to test and production environment.
Configuring OBIEE configuration files NQSConfig.INI, instanceconfig.xml as per client’s requirements.
Designing and developed aggregate tables and DB Procedure to populate them as part of ETL.
Prepared detailed technical document for the developers and support team.
Title: Senior OBIEE and ODI Consultant From January 2015 – March 2015
Client: Prince’s Trust
Employer: Infomentum Ltd.
Responsibilities
Conducted Interviews for Business Requirements & Prepared the detail Functional Specification document.
Determined Facts & Dimensions, Date & Time relationships, Granularity, Data Consistency across Dimensions and Identified Business Users & Group Security).
Identified Data Sources and Browsed Data Content.
Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Names for Source Columns, Reports and Dashboard Layouts).
Created Physical Model, Build BMM / Creation of Star & Presentation Layer, Configured Appropriate Security for Identified Users.
Migrated OBIEE repository and Webcat to various environments.
Responsible for configuring and setting up UAT and Live OBIEE instances.
Developed ETL process using ODI 12c, for transferring data from SQL Server to Oracle data warehouse database.
Prepared functional and technical document for developers.
Prepared user guide document for user to help navigate in the system.
Title: OBIEE and ODI Consultant From October 2014 – November 2014
Client: Ladbrokes
Employer: Birlasoft Ltd.
Responsibilities
Responsible to designing and data modeling of the project.
Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
Develop interactive dashboards with multiple analysis and prompts.
Scheduled bursting of reports on hourly basis using OBIEE Agents.
Used ODI to transform and load code on to data warehouse from spreadsheets.
Title: OBIEE and ODI Consultant From January 2013 - August 2014
Client: BBC, Lloyds, SpeedPost
Employer: Reed Specialist Recruitment
Responsibilities
Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements, performed GAP Analysis, and Data Analysis.
Involved Dimensional Data modeling based on Requirements.
Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
Developed Logical Columns in Business Model Layer based on Business Requirements by using Time Series Objects and business logic’s, and creating the Presentation catalogs in Presentation Layer.
Developed various MI reports using Table and Pivot Views, View Selectors, Column Selectors, Narrative Views, Static Views, Chart and Plot Views, Title Views and Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts.
Designed and developed various Interactive Dashboards and reports with Guided Navigation, Filters and Prompts.
Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
Performed data integrity testing by comparing report data with SQL queries results.
Involved in UAT and Post Production Support.
Migrated and deployed RPD across different environments.
Worked closely with Users, Developers, Administrators and Testers to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository.
Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
Configured BI Scheduler and Oracle BI Delivers- Agents to deliver Pdf attached Email and publish updated content to subscribed users as per the schedules and requirements.
ODI Responsibility
Creating new Models for the data sources – Flat Files, Oracle.
Understanding functionality and fixing defects.
Developed mappings to load data from various sources like Flat File, Sql Server to Oracle Data Warehouse Tables.
Created Packages, Scenarios using Mappings, Variables and Procedure.
Used ODI Tools like odiFile_Move, odiFileAppend, odiFilecopy etc.
Identifying and carrying out performance tuning of ODI Mapping.
Performed Unit and Integration Testing. Created various test scenarios to test the application.
Title: OBIEE Senior Developer From May 2012 - January 2013
Client: GE
Employer: MetricStream Ltd.
Responsibilities
Interacted with business representatives and business analysts for requirements analysis and to define business and functional specifications.
Analyzed the Reporting Requirements and participated in the documentation of Business Requirements.
Developed Oracle BI Metadata repository using BI Administration tool.
Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
Developed measure for time comparison using time functions, ToDate and Ago.
Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.
Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.
Implemented security based on LDAP Authentication.
Configured Measures in the Business Model Layer and mapped to multiple logical table sources.
Created schedulers and developed iBots to deliver reports and dashboards to the subscribers as per the schedules and alerts.
Created report prototypes and presented them to users to get approval.
Attended weekly meetings with BA and Stakeholders for project status updates.
Performed unit and integration testing of reports and dashboards.
Developed Proof of Concept (PoC) for OBIEE to work with Teradata and detailed documented the steps that need to be carried out.
Title: OBIEE Consultant From November 2011 – March 2012
Client: the Scottish Government
Employer: Sopra Group, UK
Responsibilities
Developed reports in Answers with tables view, pivot view, chart view, graphs and reports.
Created dashboards in the presentation layer to meet business functionality
Created dashboards with column selector and view selector to populate the required data.
Implemented Security to the dashboards developed.
Title: OBIEE Consultant From March 2011 – October 2011
Client: NHS, UK
Employer: Capita IT Services, UK
Responsibilities
Involved in Physical, Business Model & Mapping and Presentation Layer development
Design and development of repository to meet business functionality
Used Filters and provided prompts appropriately to avoid excessive data showing up Reports.
Managed Security Privileges for each Subject Area and Dashboards according to user requirements.
Implementation of Security (i.e.: Object and Data level) for the application.
Created documentation to support development activities
Title: Oracle Consultant From November 2010 – March 2011
Employer: VocaLink, UK
Responsibilities
Understanding functionality and fixing Pl/Sql defect.
Handling client’s change request and applying then in the existing business logic
Unit testing of the application and business process using Oracle 11g Pl/Sql.
Identifying and correcting performance bottle necks in the application.
Loading data from flat files onto database using SQL Loader and processing it.
Writing Pl/Sql packages to generate various reports based on business requirements.
Title: OBIEE Consultant From August 2010 – October 2010
Client: Student Loan, UK
Employer: Capita IT Services, UK
Responsibilities
Created data warehouse tables such as Staging, Intermediate, Dimension and Fact Tables.
Loaded data from OLTP data source to OLAP using External Tables and PL/SQL objects
Developed Reports for the using dashboards as per the requirement of client.
Developed dashboard reports using tables, Charts, graphs, pivots and new tables.
Translated business requirements into technical design documents, determined scope and estimated the duration of projects.
Title: DWH Developer From August 2008 – August 2010
Client: National Savings & Investment, UK
Employer: Siemens IT Solutions and Services, UK
Responsibilities
Involved in Physical, Business Model & Mapping and Presentation Layer development
Design and development of repository to meet business functionality
Used Filters and provided prompts appropriately to avoid excessive data showing up Reports.
Created measures and level Based measures in Business Model
Responsible for developing new and modifying existing Pl/Sql code as per new migration requirement.
Database and table design and implementation for data warehouse and related ETL processes.
Provided support and developed scripts for post implementation support issues.
Carried out performance tuning of the application.
Developed code to load data from Flat Files to Data warehouse Tables using SQL Loader.
Developed complex queries for bulk processing of data during day to day batch process of data.
Developed and modified Pl/Sql code to generate reports, as per as per clients requirement.
Created adhoc queries to generate end reports for Data Warehouse testing team.
Prepared Technical Design document for development.
Prepared Test Specification and data for testing the new application.
Provided support to User Acceptance Testing (UAT).
Provided implementation support.
Title: Technical Team Leader From September 2006 – June 2008
Client: Ventyx Inc. USA
Employer: Ness Technologies (India) Ltd
Responsibilities
Interacting with clients, preparing technical documents based on the functional documents for development.
Developing and enhancing forms and reports and database objects to existing functionalities, carrying out unit testing, also providing integration test support.
Executed research work for future development of the product, like internationalization of the forms using OTM, replacing forms with JSPs.
Developed security measures to hide customer’s information’s using Oracle 10g DBMS_CRYPTO encryption method.
Developed Customized Forms for different front end functional requirements.
Involved in identifying and tuning Sql queries.
Provided production support for the application to end customers.
Involved in DBA activities like creating new tablespaces, creating user, granting and revoking privilege rights, import, export, etc.
Responsible for Design and develop new enhancements to existing functions and to Resolve software defects.
Had good working exposure to Agile Product Development Methodology.
Calculated accurate time estimates and adopted the responsibility for delivering developments to agreed time-scales and quality.
Provide regular status and progress information to higher management.
Mentor developers within the team and participate in a collaborative environment where best practice ideas are exchanged.
Title: Associate Consultant From March 2005 – September 2006
Client: Banco De Chile, Chile and Deutsche bank, China
Employer: I-flex Solutions Ltd
Responsibilities
Performed the Data Conversion from existing legacy banking product to Flexcube during product implementation at the banks using External tables.
Drafting design documents, program specifications and unit test cases according to the functional specification.
Developing and enhancing forms, master detail forms, reports and database object for the consumer lending application and conducting testing on the application as per test cases.
Successfully integrated of Daybreak’s underwriting system with Retail Lending using Pl/Sql and Complex Views.
Interacting with the on-site team for system study, requirements gathering, analysis and scoping. Also providing techno-functional support to onsite team for the application.
Customized the application as per client’s requirement.
Making performance changes to tune the application.
Debugging and conducting the manual testing of the application software.
Extending post go-live and application maintenance support to the client.
Imparting training on retail lending modules to sales team and higher management.
Education Qualification
Bachelor of Engineering, from Dr. Babasaheb Ambedkar Maratwada University with DISTINCTION.
Postgraduate Certificate Business Administration from University of Leicester, UK.