SUMMARY

• 7 years of experience in Oracle BI, Answers, Delivers, iBots, BI Publisher, interacting with multiple data sources like Oracle 9i, 10g,11g SQL Server and various other miscellaneous sources.
• Experience in Oracle BI Apps that include OBIEE/Siebel Analytics, ETL Tools and DAC in Banking, Financial, Pharmaceutical, Insurance and Sales & Marketing domains.
• Knowledge of Data warehouse Application Console (DAC) Architecture
• Experience working with OBIEE 10.1.3.x/11g/Siebel Analytics/OBI Applications 7.9.6.3 in development of metadata repository using OBIEE Administration tool, Intelligent Dashboards, Answers, Delivers, iBotsand Oracle BI Publisher
• Experienced in Full Systems Development Life - Cycle Implementation of Various Oracle/ETL /OBIEE Projects.
• Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
• Experience in creating Repositories (rpd) (Physical, Business Model and Mapping and Presentation Layer) create Aliases, and build Star Schemas in the repository.
• Expertise Configuring Repository, Create/Manage Dashboards, Reports/Answers and Building Physical, Business Model and Presentation Layer.
• Hands on Experience in Data Modeling using Star and Snow Flake Schemas ER Model, De-Normalization, Dimensional Data Modeling, converting Snow-Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, Physical & Logical Data Modeling
• Proficient in creating Interactive Dashboards with drill-down and drill-across capabilities, Web Catalog Objects (Dashboard, Pages, Folders & Reports), Scheduler, & Catalog Manager.
• Strong experience in creating Logical tables and columns, Dimensional Hierarchies with drill down, Level Based Measures, Time series wizards & Repository Variables.
• Good Knowledge of database experience using Oracle 11g/10g/9i/8i/7.3, MS SQL Server 2000, MS Access 2000/7.0.
• Experience in ETL methodology for supporting Data Extraction, Loading and Transformation processing using pre-staging, staging approach in Informatica Power Center and Power Mart.
• Hands on experience on TOAD and SQL Developer, tools which are used to enhance productivity and simplify the database development tasks.
• Experience in Database design using Normalization and E/R Diagrams.
• Extensive experience in database programming using SQL and PL/SQL following industry best practices.
• Proficient in PL/SQL programming - Stored Procedures, Functions and Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers
• Expertise in creating stored procedures, functions, packages, collections and bulk collections using PL/SQL.
• Expertise in loading data from legacy systems using SQL*Loader.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Experience in performance tuning utilizing tools like Cache Management and Aggregate Tables.
• Experienced in Financial, Health Systems and Marketing domains.
• Good at drafting technical specifications and as per the business requirement.
• Tested and validated data for the end users in UAT and provided production support.
• Extensive experience in development, debugging, troubleshooting, monitoring and performance tuning.
• Good Team Player and individual contributor with steep learning curve and good interpersonal skill.
• Excellent problem solving skills with strong technical background and good interpersonal skills.

TECHNICAL SKILLS

OLAP Tools: OBIEE 11g 11.1.1.x, OBIEE 10.1.3.x, Siebel 7.8.

Databases: Oracle 11g/10g/9i/8i/7.3, MySQL 5.5, 4.0, MS Access 2003/2007/2010

Tools: SQL Developer, TOAD & Microsoft Office

ETL Tools: Informatica Power Center 8.6.1, DAC 7.8.x

Operating Systems: Windows 2000/NT/XP/7, Windows Server 2005, Web Logic Server, Linux UNIX.

Programming: C, C++, Java, SQL, PL/SQL, C#.NET, ASP.Net, & HTML Dimensional Data

Modeling: Star Schema Modeling, Snow-Flake Schema Modeling

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

OBIEE Developer

Responsibilities:

• Worked on OBIEE meta-data development. Configure repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer).
• Conducted requirements analysis, Designed report structure to business owners’ requirements
• Designed and developed RPD models to support defined reporting requirements
• Optimized OBIEE report performance
• Configured OBIEE Security and Performed OBIEE Admin Activities
• Developed customized dashboards and created custom reports
• Extensively experienced gathering requirements from Business Users and translating them into FRD/Design documents
• Created the reports in Hyperion reporting tool and also converted many reports from Hyperion to OBIEE.
• Created many Templates (Excel, Word) using BI Publisher to meet the requirements of the users.
• Created much analysis, dashboards and scheduled many Agents to make sure that the users receive the reports as per their demand.
• Trouble shooting the data against the core database and delivering the good results to the users.
• Created new subject areas in RPD and also involved in Full merge, patch merge and deployments in the server.
• Experienced in agents failing issue and in migrating the reports from one environment to other.
• Extensively used Informatica Power Center to create source and target definition, mappings, Mapplet, transformations, reusable transformations.
• Implemented transformations like lookups (connected and unconnected), Update strategy, Joiner, Router, Sorter, Aggregator, Expression, Rank, Sequence Generators and others.
• Worked in performance tuning of ETL mappings and sessions.

Environment: OBIEE 11.1.1.7,Hyperion 9, Oracle 11,TOAD, Informatica 9.5.x ETL, Windows XP/2007 server.

Confidential, Ann Arbor, MI

OBIEE Developer

Responsibilities:

• Import Physical tables from Oracle database and defined relations between Physical tables at the Physical Layer.
• Design and modify metadata repository code including creating dimensional hierarchies and assigning different keys for each level as per technical specifications
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model mapping Layer and Presentation Layer.
• Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Data validation is done using SQL Developer which is productive software for database developer, DBA’s and analysts.
• Identified and created aggregate tables to improve query performance.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local filters.
• Created Session & Repository Variables to achieve desired functionality.
• Created web-groups for security purpose with access privileges.
• Assigned Data level & UI level security to the Users.
• Created OBIEE Intelligent Dashboards, & Answers.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Customized Dashboard reports using drill-down capabilities.
• Created and used Delivers and iBots extensively.
• Used Informatica Designer to Creat, Load, Update mappings using different transformations to move data to different data marts in Data Warehouse.
• Created Source, Target, Transformations, Sessions and Batches to define schedulers for the sessions.
• Understanding the business requirements and enhancing the existing Data Warehouse Architecture design for a better performance.
• Involved in developing ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 8.6

Environment: OBIEE 10g/11g, MySQL and Oracle Database, BI Publisher, SQL Developer, Informatica 9.1, and UNIX.

Confidential

OBIEE Developer

Responsibilities:

• Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down, Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Involved in Analysis and Design of the data warehouse.
• Worked extensively on Repository administration tool to configure Physical, Logical and Presentation Layers.
• Configured Physical Layer - Import tables, Create Tables, add/change physical joins/keys.
• Configured Logical Layer - Create Logical tables/dimensions, columns, Create Logical Joins/keys, Set levels to support Drill-down, Aggregation / Sum over Columns.
• Configured Presentation Layer - Create Folders/sub-folders, Standard Queries for different User Groups.
• Implemented aggregate tables for better Analytics Performance.
• Developed various output formats such as tables views, charts, pivot tables.
• Imported data from OLTP/OLAP to the Physical layer of OBIEE.
• Wrote Custom SQL Codes for the reports.
• Applied Optimization Techniques for the better performance of the reports.
• Worked extensively in Siebel Answers and Dashboards.
• Implemented various security features at various levels.
• Created and granted privileges for the users using Analytics catalog manager.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Performed unit testing and supported end users during various test cycles. Performance Tuning of Reports by implementing the aggregate navigation, Cache and Oracle materialized views.

Environment: OBIEE 10.1.3.2, Oracle 10g, Oracle BI Apps 7.9.3 (Pharma Sales Analytics), Siebel CRM, UNIX, Win-XP.

Confidential

SQL Developer

Responsibilities:

• Understand and evaluate UNIX, SQL and or Data Modeling.
• Develop underlying data models and databases.
• Develop, manage and maintain data dictionary and or metadata.
• Ensure compliance of standards and conventions in developing programs.
• Design, develop and implement complete life cycle of data warehouses.
• Translate business requirements into software applications and models.
• Resolve and troubleshoot complex issues.
• Perform and execute data extraction, transformation and loading using ETL tools.
• Maintain and manage all versions of data models for production, testing and developing databases.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Used TOAD, PL/SQL developer tools for faster application development.
• Performed SQL tuning using Explain Plan, Hints and indexes.

Environment: Oracle 10g/9i, SQL SERVER, Flat Files, SQL, PL/SQL, Windows NT.