Data Oracle

Jilani

Summary:

* ***** ** ** ********** in Analyzing / Creating Complex Applications with emphasis on Design & Development of Data Warehousing, Oracle Business Analytics Warehouse (OBAW), Reporting, ETL, Development, Testing, Documentation. Perform variety of roles including BI Analyst, Administrator and Developer particularly excel at techno-functional roles that require liaison between user groups and IT.

Experience implementing OBIEE 11g, 10g and Applications (Financial Analytics, SCM, Manufacturing Analytics, HR Analytics, Procurement and Spend Analytics).

Experience implementing OBIA 7.9.6.3, 7.9.6.4, 11.1.1.8 for EBS R12.1.x, EBS R11.5, Siebel, Teradata and PeopleSoft9.x.

ETL Development experience using Informatica Power Center/Power Mart (Repository Manager, Mapping Designer, Workflow Manager and Workflow Monitor).

Worked extensively in developing Informatica mappings and mapplets to build key interfaces using transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into data warehouse.

Expertise in providing end-to-end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers / Analysis, security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots(Agents).

Experience in migration of OBIEE 11g to 12c using BI Migration tool in Linux.

Experience in extensive dimensional modeling in BMM layer (Creating business models, logical tables, Time series modeling, logical columns, level-based hierarchies, and level-based measures).

Expertise in Performance Tuning of Data Warehouses by implementing the materialized views, bitmap indexes, partitions and aggregate tables.

Expertise in fine tuning reports by using view selector, column selector, is prompted, drill down- drill through analysis, creating master/detail reports, using database, numeric, date and time functions, etc.,where ever necessary to increase performance.

Experience in customizing OBIA Subject Areas like Finance (AP, AR, GL), Supply Chain-Sales Orders, Inventory and PO Dashboards, Reports, Fact Tables as per the client needs.

Extensive experience in Oracle 9i/8i,10g/11g,SQL Server 2000, design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL.

Strong working experience in using OBIEE Delivers which includes configuring Delivery Devices, creating and configuring iBots (Agents), and building Alerts.

Experience on assigning Data security & UI level security to the users using OBIEE repository objects & external data base.

Experience in implementing comprehensive security functionality by defining the provider specific configuration for the Active Directory Authentication and by creating Application Roles in Oracle Web Logic Server11g (OBIEE 11g).

Experience in implementing object and data level security in OBIEE using Repository Variables, Initialization Blocks and Session Variables.

Configured Answers (ad-hoc querying, reports), Interactive Dashboards with drill-down capabilities (charts/tables/graphs), Delivers/iBots (alerts) and administered Web Catalog Objects (pages, folders).

Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication (WebLogic from OBIEE 11g onwards) setup and configuration of Multiuser Development Environment (MUDE).

Proficient in data modeling and Query building using SQL, Oracle BI analysis and XML.

Experience in setting up multi-user development, assigning repositories to developers and integrating them into the master repository.

Expertise in different stages of handling data viz. requirement gathering, identifying datasources/targets, data modeling, data cleansing, data loading.

Proficient in defining key metrics, dimensions, hierarchies, attributes and building Star and Snow flake schema.

Extensive experience in Unit, Regression, Performance, Integration and User Acceptance testing methodologies.

Expertise in Financial, Sales/Marketing, Telecom and Retail domains.

TECHNICAL SKILLS

DWH (Reporting)

OBIEE 10.1.3.2.0/11g/12c, ODI 10g/11g, OBIA 11.x/7.9.x, Business Objects XIR2 (BO), Cognos, Axiom

DWH (ETL)

Informatica 8.6.1/9.6.x, ODI 10g/11g, DAC 10g/11g,OBIA 7.9.6.3, 7.9.6.4, 11.1.1.8.

Languages

SQL, PL/SQL, C, HTML, JavaScript, CSS, XML

Databases

Oracle, MS SQL Server 2000/2005, MySQL 5.0,OracleEBS R12.1.x, EBS R11.5, Siebel, Teradata and PeopleSoft 9.x.

Defect Tracking Tools

Quality Center, JIRA

Middleware

WebLogic, EAI

Big Data

Hadoop, MapReduce, HDFS, Hive, Hbase.

Query Tools

TOAD, SQL Developer, SQL Tools

Version Control

Tortoise SVN, GitHub

Operating Systems

Windows 2000/XP/Windows 7, Linux/Unix

Professional Experience:

State of CA, Rancho Cordova, CA Nov 2016 to till date

Role: Senior OBIEE Developer

Responsibilities:

Install, upgrade and configure all components of OBIEE from 11.1.1.7.1 to OBIEE 12c.

Design and implement data in various layers including physical, business and presentation

This project involved extraction of data from multiple sources and transform the data as per the business logic and is loaded into the data warehouse which is finally used for reporting using OBIEE.

Involved in meeting with business analysts and business users to understand the business requirements and functionality.

Created and Administered the Physical layer, Business Model and Mapping layer and Presentation layer in Repository (.rpd) using Oracle BI Administration Tool.

Create connection pools, imported physical tables and defined joins (between dimension and fact tables) in the physical layer of the repository.

Defined facts, dimensions, Level based measures/Hierarchies, Time Series and Aggregation using data modeling in RPD.

Created Logical Tables, Logical Columns, Dimension hierarchies and measure columns as per the Business need.

Extensively worked on OBIEE 12g Upgrade Experience.

Scheduling and Monitoring the ODI loads.

Created logical joins between fact and dimension tables in business model layer.

Design data modeling and aggregate navigation in business model in RPD.

Identified the aggregate levels for each source and created dimension sources for each level of aggregates.

Created subject areas to contain all of the required data elements and measures which can be accessed by the business users.

Coordinating development meetings with offshore team.

Developed various analysis (reports) with different analytic views including table, pivot table, charts and column selector to allow users to analyze the business from different perspectives.

Make sure technical specifications of each report are being met in accordance with business requirement.

Prepared POC on visual analyzer and presented various kinds of graphs created for business.

Build calculations using formulas and functions based on business requirement in various reports.

Create variables, filters and prompts requires for reports and dashboards.

Performed Performance Tuning of Dashboards/Reports and made recommendations for changes to database.

Involved in merging of RPDs& migrating applications from development to SIT/UAT/ production environment.

Write complex SQL queries to validate data quality of reports and dashboards.

Managed security privileges for each subject area and dashboards according to user requirements.

Created group level security for intelligence dashboards and assigned users to groups based on Business Requirements.

Created group level security for intelligence dashboards and assigned users to groups based on Business Requirements.

Performed Unit testing to validate Reports and Dashboards.

Conduct internal meetings with team to discuss about the status of development and issues (if any) raised by QA team.

Support SIT/UAT team and fix any issues raised by QA team.

Environment: OBIEE 12.2.1.0.0, Oracle 11i, Golden gate, Informatica 9.6.x, DAC 11g, Oracle EBS, Linux/Unix

Express Scripts, St. Louis, MO Jan 2014 – Oct 2016

BI Developer

Responsibilities:

Gathered requirements of the various work streams by meeting with the business users and base lining the details.

Worked with data architects to translate business requirements into technical specifications and logical & physical data models.

Imported Essbase Cubes from Essbase multidimensional source and Dimensions & Facts from Oracle Warehouse into OBIEE Repository and built Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.

Federated (Vertical & Horizontal)Essbase multidimensional sources with relational data sources in OBIEE Business model and Mapping layer.

Used Fragmentation to pull the fact data distributed across different tables in a single data source.

Upgraded rpd and Web Catalogs (Answers, Dashboards), BI Publisher from OBIEE 11.1.1.5 to OBIEE 11.1.1.7.

Developed new reports and customized existing reports using BI Publisher 11.1.1.7.

Worked extensively on OBIEE answers to create reports containing charts, pivot tables, gauges.

Informatica Power Center 9.0.1is used to load the Oracle 11.5.10 data into OBAW using Source dependent adapters (SDE ORA) and Source Independent adapters (SILOS) and custom Folders.

Used Oracle PL/SQL as ETL to pull the data from Oracle EBS stage tables and wrote complex logics (functions, cursors...etc.) before loading the data into OBIA warehouse.

Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.

Implemented object level security by creating Application Roles in Oracle Enterprise Manager 11g and by setting the permissions on dashboard pages using the application roles.

Involved in training users in developing, Customization and scheduling reports in BI Publisher 11.1.1.7.

Provided end-user training to power users to develop dashboards, reporting metrics and reports and provided documentation to BI Group.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.5/11.1.1.7, BI Publisher 11.1.1.7, Informatica Power Center 9.0.1,Essbase 11.1.2.2.310, Oracle 11g, Windows XP, Toad.

iMedRIS, Redlands, CA May 2012 – Dec 2013

OBIEE Consultant

Responsibilities:

Imported Dimensions and Facts into Repository and built Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.

Worked with ETL team to push the calculations to database wherever possible and improved the query performance of reports in existing Dashboards.

Created Logical Columns, Level Based Measures and Variables using admin tool in the Business Model and Mapping Layer as per reports requirement.

Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.

Developed many Reports/Dashboards with different Analytics Views (Pivot Table, Graph, Chart, View Selector, and Column Selector, with global & local Filters using Oracle BI Web.

Created Presentation catalogs/Subject Areas for Sales and Month End Account measures.

Setup Multi User Development Environment (MUDE) in OBIEE.

Merged repositories and migrated to multiple servers.

Created production builds and getting approvals from senior management.

Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.

Implemented comprehensive security functionality by defining the provider specific configuration for the Active Directory Authentication.

Coordinated the OBIEE .rpd and Web Catalog objects migration from Development environment to QA environment and then to the Production environment.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.5, Oracle 11g, Linux, SQL Developer.

UBS Financial Services Inc., Weehawken, NJ Oct2010–Apr 2012

OBIEE Developer

Responsibilities:

Created Repository by building Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.

Created Dimensions, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.

Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.

Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.

Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.

Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.

Used the Security settings in Oracle BI Admin Tool to set up SSO, users, groups, access privileges and query privileges.

Created Repository Groups and Web Groups and assigned users to configure security in the Siebel Analytics Server.

Implemented data and Object level security.

Worked on LDAP authentication and Row Level Security.

Worked on migrating the code to DEV,QA &PROD environments.

Troubles hooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.

Performed reverse engineering for the data sources and targets.

Defined Session variables in the repository to populate the current date filters.

Worked on Dashboard and Page level prompts and Report filters.

Performed debugging for verifying the prebuilt ETL mappings for Oracle BI Applications.

Created pivot table requests allowing managers to analyze the business in different perspectives.

Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.

Involved in performance tuning by enabling the cache to improve the query performance.

Involved in preparing/executing Test scripts, establishing Test Data, and recording defects.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Oracle Delivers, BI Publisher, UNIX/LINUX, Shell Scripting, Oracle 11g/10g,SQL and TOAD 6.3/7.0.

United Engineering, Karachi Feb 2009- Sep 2010

Role: OBIEE Developer

Responsibilities:

The Information Management and Delivery (IMD) project provides customer billings, collections and

service requests and analytics solution to users to enhance decision-making process with respective revenue and service management.

Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.

Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.

In depth knowledge of data models such as Star schema and Snowflake schemas.

Very good understanding of OBIEE development best practices and Analytics Architecture.

Worked closely with the business experts to understand the source data.

Created various kinds of reports such as Title, Table, Pivot table, Chart/Graph reports etc.

Created and designed dashboards based on the business requirement.

Added dashboard prompts, report filters based on the business requirement.

Deployed both RPD and catalog to SIT and UAT environment for testing purpose.

Responds promptly and sort the issues raised by both SIT and UAT teams.

Created users and groups and assign access privileges to users and groups.

Worked on performance tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse.

Environment: OBIEE 10.1.3.2, ODI 10g, BI Publisher, Oracle 11i, Linux/Unix.

Contact this candidate