SUMMARY:

• IT professional with over 7 years of progressive expertise in gathering and analysing the requirements, building an application design, development and testing with a comprehensive background in Database and Data Warehouse developments and providing business intelligence solutions using OBIEE reporting tools.
• Perform variety of roles including Designer, Analyst, System Integration Specialist. Particularly excel at techno - functional roles that require liaison between user groups and IT.
• Experience with Data Integration and Analysis for Decision Support Systems in Banking, Pharmaceutical, Healthcare, Insurance, Sales and Telecommunication industry domains
• OverFive years of professional experience as a technicalERP Developer/ConsultantinOracle E-Business Suite Applicationswith expertise involved in end to end implementations of BI solutions for implementing Oracle Financial Analytics, Procurement and Spend Analytics, Human Resources, Supply Chain and Order Management Analytics.
• Over Seven years of strong experience in Extraction/Transformation/Loading of the data to Data Warehouse using Informatica Power Center 9.0.1, 8.6.1, 8.1,7.1.3,7.1/6.2,6.1/5.1.2 (Designer, Workflow Manager, Workflow Monitor).
• Involved in implementing prebuilt solutions in converting data from ERP systems like Oracle EBS into Enterprise Business Analytics Warehouse (BAW) with excellent knowledge of Business Intelligence concepts and involved in different phases of Software Development Life Cycle in Data Warehousing.
• Experience in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Centre and Data Warehouse Administration Console (DAC).
• Strong understanding of OBIEE 10g and 11g concepts, especially in configuring Security settings using Weblogic Server (Users and Groups), Oracle Enterprise Manager (OEM for Roles and Privileges), its architecture and components (OBI Server, Oracle BI Presentation Services, Web cat file, config files and other tools and utilities).
• Extensive experience in building OBIEE Repository (.rpd) file, configuring OBIEE Analysis (Answers), Interactive Dashboards with drill-down & drill-across capabilities, Guided Navigation, Alerts (iBots), Security Setup (access privileges), Filters, setting up Roles - Profiles - Personalization.
• Configured and customized xls and rtf templates in BI Publisher for creating various pixel-perfect BI reports by connecting to the database and BI Server.
• Hands-on experience in developing Dimensional Hierarchies/New logical columns/Filters/Variables as per business requirements.
• Ability to enhance performance by understanding when & how to leverage aggregate tables, materialized views, table partitions, indexes, and managing cache etc.
• Expertise in Dimensional data modeling, Star schema modeling, ETL, OLAP, Data Normalization, and Physical & Logical Data Modeling.
• Extensively used Informatica Designer to create and manipulate source definitions, target definitions, mappings, mapplets, and transformations.
• Extensive experience with prebuiltOracle BI Appsfor HR and Financial modules.
• Extensive experience in writing SQL queries/reports, PL/SQL Stored Procedures, Functions, Packages, triggers for Oracle 11g/10g/9i/8i and tuning of SQL queries/scripts.
• Excellent working experience in Data Warehouse applications, directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS:

Business Intelligence: Oracle Business Intelligence Enterprise Edition(OBIEE) 11.x/10.xSibel Analytics 7.x, BI Publisher, OBIA 7.x.

ETL Tools: Informatica Power Center 9.x/8.x/7.x, DAC 10.x

RDBMS: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, MSAccess

Operating Systems: Windows 2000/XP/vista/7, LINUX, UNIX (Solaris)

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++, HTML, ASP.Net, C#

Web Based: HTML, XML, Dreamweaver

Tools: SQL*Plus, SQL*Loader, Oracle SQL Developer 2.1.x, TOAD

Data Modeling Tools: Microsoft Visio

Others: MS office, Adobe Acrobat

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Sr. OBIEE developer

Responsibilities:

• Involved in client interfacing and cross functional infrastructure teams in analyzing the system architecture and translate them into architectural design documents and involved in requirements gathering.
• Played major role in upgrading OBIEE 10.1.3.4 to 11.1.1.5 and BI Apps 7.9.6 to 7.9.6.3
• Created OBIEE Repository and implemented the business logic by customization, Dimensional Hierarchies, Aggregate Navigation and Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks, cache management and implemented business logic for facts and dimensions.
• Imported new tables and columns from the Data warehouse, created Physical and Logical Joins, worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement, wrote Case SQL Statements to manipulate the data as per the needs in the rpd.
• Created connection pools, imported physical tables and defined joins in the physical layer of the Rpd.
• Created reports and schedule reports as per the requirement using BI Publisher and represented them in Web Application (dynamic/static scheduling)
• Worked on the security previliges of the repository by creating users, groups and setting up the data and object level security as well. On the web catalog, worked on creating dashboard users and groups and setting up section level permissions.
• Working on new security model introduced in OBIEE 11g. Implemented security using Weblogic server Administration console by creating and setting up users and groups. Used Enterprise Manager Middleware control to create and setup Application Roles and Application Policies. Setup the external table authentication and data visibility implementation.
• Developed/tested/migrated the RPD and web catalog in/from different Environments (Dev, QA, Production).
• Used BI answers to develop ad-hoc reports.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigation links, drilldowns, roll downs and slice & dice features.
• Designed Star-Schema using Facts, Dimensions, Physical, Logical, Alias and Extension tables and established relationships & Foreign Keys (Physical & Logical) between tables.

Environment: OBIEE 11.1.1.5/ 10.1.3.4.1, Oracle Bi Apps 7.9.6.3/ 7.9.6, Informatica 8.6.1, DAC, Oracle 11g/10g, Oracle EBS R12, Oracle SQL Developer 2.1.1, Windows 2003 Server/XP, RHEL 5.x.

Confidential, Eden Prairie, MN

Sr. OBIEE developer

Responsibilities:

• Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications
• Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher.
• Interacted with end users and developers to validate the data model, requirement validation of the reports and drilldowns with business users
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Architecture design of business model. Identified Facts, Dimensions, and Hierarchies of the business model. Created complex calculated measures based on time dimension to calculate Quarter Ago and Year Ago metrics
• Effectively managed ODBC connections and imported the Physical tables, keys and physical joins from the databases.
• Responsible for BI/ETL architecture, installation, administration and implementation.
• Developed the OBIEE Metadata Repository using OBIEE Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Used Informatica Mapping Designer to customize pre-built mappings using different transformations required to move data into data warehouse.
• Develop Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
• Created new requests and opened Answers for ad-hoc reporting to the End users
• Configured Row Level Security, Column Level Security and Object level security to allow users to view their respective data only according to the requirement.
• Designed Star schema for fact & dimensional tables and created alias for the dimension and fact tables when necessary.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables.

Environment: OBIEE 10.1.3.4.1, Oracle 11g, Oracle Bi Apps 7.9.6.1, EBS HR, Informatica Power Center 8.6.1, Microsoft SQL Server Management Studio Express 9.0, SQL*Plus, SQL*Loader, Windows NT Server/XP, UNIX.

Confidential, Newark, NJ

OBIEE developer

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Involved in Installation, configuration and administration of OBIEE server and repository.
• Customize Out of the Box ETL Mappings/ Workflows/ RPD as per the Client Requirement.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Worked extensively on OBIEE and Siebel Analytics Metadata(RPD) Development, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
• Created OBIEE Repository and implemented the business logic by customization, Dimensional Hierarchies, Aggregate Navigation and Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks, cache management and implemented business logic for facts and dimensions.
• Customized Star and Snowflake schemas by linking Fact and Dimension tables in the BMM layer.
• Worked on the security previliges of the repository by creating users, groups and setting up the data and object level security as well. On the web catalog, worked on creating dashboard users and groups and setting up section level permissions.
• Configured Analytics Metadata objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, and Reports).
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users, which include like Managers, functional heads, Department Heads.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards & answers.
• Worked on building the Dynamic/Drill-Down Cascading Style sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters.
• Utilized Siebel Delivers/iBots for delivering reports, personalized alerts and schedule iBot for subscribed users.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity.
• Worked on Informatica Power Center for ETL purpose, for Data Extraction from ERP, Data Mapping and Data Conversion (Transformation) and Data loading into the BAW warehouse.
• Used Informatica Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Prepare “Performance Recommendation” Document to improve the performance of long running ETL Sessions.
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize and monitor ETL process.

Environment: OBIEE 10.1.3.3, Oracle BI Apps 7.9.5, Informatica 8.1.1, DAC, Oracle 11g, 10g, Oracle EBS, Oracle SQL Developer 1.5.5, SQL*Plus, Windows 2003 Server, UNIX.