IQBAL AMJAD

ac3f3j@r.postjobfree.com

Objective:

Seeking an integration OBIEE/OBIA Developer/Admin. role in a fast paced environment using Oracle Business Intelligence 10/11G.

Summery:

Over 7+ years of experience in IT implementing full life cycle of Business Intelligence solution with System & Data Analysis, Application Design & Dimensional and Data Modeling with Design.

Good knowledge about different tracks like Financials, Supply Chain & Order Management, Procurement and Spend Analytics.

Experience using Oracle Business Intelligence Enterprise Edition 10g and Oracle BI Apps.

Experience in end to end implementations of BI solutions for implementing Financials, Supply Chain and Order Management, Procurement and Spend Analytics.

3+ years of experience in report creation.

Experience with report creation on BI platforms Tableau .

Extensive experience in OBIEE Answers, OBIEE Interactive Dashboards, BI Publisher.

Experience in developing OBIEE Repository at three layers (Physical Layer, Business Model & Mapping Layer and Presentation layer).

Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.

Performed Cache Management at repository level.

(Experience in analysis, design and development of enterprise applications using SOA, BPEL, OSB Java, J2EE,and Database technologies).

Technical Skills

Operating systems : Windows 7/8/2000/XP/Vista, Linux

Analytics : OBIEE 11g, OBIEE 10.1.3.x, Analytics 7.8,

: Admin / Weblogic.

Scripts : TCP/IP UDP, BIND, LDAP,HTTP,WGET,SSH FTP,

RDBMS : Oracle 10g/11g, SQL Server 2000/2005, MS Access.

Languages : Java, SQL, PL\SQL

Tools/Utilities : SQL Loader, TOAD, SQL developer

Scripting : Shell Scripting, JavaScript

Web Languages : HTML, XML

Education:

Bachelor of Tec Punjab University

Work Experience

BAE Remote Dec -15 2015 to Till now

Gathered User requirements, reporting requirements and the document for requirement specifications.

Used Administration Tool for customizing and modifying the Physical, Business Model & Mapping and Presentation Layers.

Created dimension hierarchies, aggregates and keys in BMM layer.

Worked on session variables and dynamic variables along with initialization blocks.

Created users and groups in the repository and granted privileges and group inheritance.

Worked extensively on Oracle BI Answers, Delivers and Interactive Dashboards.

Involved in troubleshooting of Informatica Mappings and Workflows

Compared data from Hyperion Essbase with the OBI for data validation.

Created source and target instances and various transformations (Joiner, Aggregator, Filters, and Router).

Oshkosh Truck Corp, Oshkosh, WI March-2014 to 1st Dec 2015

Oracle BIEE Developer

Roles & Responsibilities:

Translated Business requirements into technical requirements.

Gather requirements from client or end-users to develop a layout plan

Design and develop custom made business intelligence solution according to the plan using BI applications

Customized Purchase Orders, GL, Account Receivables, Account Payables, Procurement and Spend Analytics, Order Management, Inventory reports using OBIEE 11g.

Worked with OBIA rpd, making use of the existing physical/logical objects, creating reports based on pre- built rpd.

Created Dashboard prompts and advanced filter criteria.

Created new connection pools for different data sources and designed from the scratch (physical, business model and presentation).

Customized reports from BI Apps (OOB-prebuilt) seeded reports.

Used BI Apps prebuilt Informatica mappings for development.

Fixed many OOB issues.Created major and important dashboards like Customer Profitability from the scratch including

The top priority reports like Monthly Net Sales, Customer Profitability, Funds Details, Credit Summary.

Utilized features like dashboard prompts, pivot tables, column selector, drill down, hierarchy.

Configured Web Catalog Objects (Dashboards, Pages, Folders, and Reports).

Implemented various Repository Variables and System Variables depending up on user requirements.

Extensively worked on Informatica Power Center 8.6 tools – Designer, Workflow Manager, Workflow monitor.

Designed and developed complicated/complex reports.

Followed best practices to make sure there was good performance.

Administered MUD rpd, reviewed developers’ rpd development before merging into MUD server.

Environment: OBIEE-11.1.1.5, OracleBI Apps, Oracle DB 10g, SQL Plus, Oracle SQL Developer, Informatica Power Center 8.6, DAC,weblogic,unix.

Automatic Data Processing, Inc. September 2012 – FEB 2014

(ADP), Roseland, New Jersey

OBIEE Developer

Roles & Responsibilities:

Interacting with management, business and users, gathering the business requirements, designed and developed complex dynamic business quality compliance group reports related to audit and early warning.

Created transformations like Expression builder, joiner, and router.

Implemented OBIEE solution for ‘Sales’ subject area using various components of OBIEE Suite like BI Answers, Interactive Dashboards, iBots/Delivers.

Tuned the performance of the reports by creating various types of indexes wherever appropriate.

Configured MUD for OBIEE Tool

Utilized various building blocks like calculation measures, time series measures, initialization blocks, session and repository variables, fact tables, dimension tables, dimension

hierarchies.

Created variety of interactive dashboards containing charts, graphs and pivot tables using BI Answers.

Utilized features like narrative views, dashboard prompts to create interactive dashboards.

Configured BI Scheduler and created simple, conditional and chained iBots to create alerts and deliver them using Oracle Delivers.

Environment: OBIEE-10.1.3.4, Oracle DB 10g, SQL* Plus, PL/SQL, Informatica Power Center 8.6.,weblogic,unix.

Genex Technologiesis, Newark, DE Nov 2009 – June 2012

OBIEE Developer/Admin

Roles & Responsibilities:

Gathered User requirements, reporting requirements and the document for requirement specifications.

Used Administration Tool for customizing and modifying the Physical, Business Model & Mapping and Presentation Layers.

Created dimension hierarchies, aggregates and keys in BMM layer.

Worked on session variables and dynamic variables along with initialization blocks.

Created users and groups in the repository and granted privileges and group inheritance.

Worked extensively on Oracle BI Answers, Delivers and Interactive Dashboards.

Involved in troubleshooting of Informatica Mappings and Workflows

Compared data from Hyperion Essbase with the OBI for data validation.

Created source and target instances and various transformations (Joiner, Aggregator, Filters, and Router).

Configured many dashboards with different views like Pivot table, Chart, Tabular and View Selector and guided navigation links.

Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.

Created highly formatted reports using BI Publisher based on Oracle Database.

Environment: OBIEE 10.1.3.4, Oracle 10g, Oracle BI Publisher, Informatica Power Center 8.1.,Unix

Contact this candidate