SUMMARY

• 6+ years of experience in Business Intelligence, Data Warehousing and Database Applications including Analysis, Design, Development, Testing and Support using ODI, OBIEE and BI APPS.
• Proficient in Data Warehousing, Dimensional modeling using star schema/ snow flake schema modeling, Fact and Dimension identification.
• Had knowledge of ODI graphic tools, Knowledge Modules and ODI objects - Project, Model, interfaces, Yellow interfaces, Procedures, Filters and Change Data Capture(CDC).
• Expertise in building Metadata Repositories (RPD) using Physical layer, Business Model and Mapping layer, Presentation layer with the Oracle BI Administration tool.
• Proficient in RPD designing, developing and generating dashboard Reports, Business views, Unit Testing, Quality Assurance, Project Planning and Documentation.
• Experienced in developing and implementing Dimensional Hierarchies, Level Based Measures, Aggregation Rules, Time Series Functions and Rank Functions.
• Skilled in configuring OBIEE Metadata objects including repository variables, initialization blocks, connection pools using ODBC, OCI and Universal Adapters.
• Experienced in designing customized and complex interactive dashboards in OBIEE using drill down/ drill up, guided navigation, prompts, filters and variables.
• Experienced in configuring and set up of OBIEE Security using LDAP and External Database Tables besides configuring object level and database level security.
• Expertise in database Performance Tuning by implementing Parallel Execution, Partitions, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes.
• Good knowledge in using OBIEE answers to create queries, format views, charts to enhance the user experience.
• Skilled at creating and scheduling Agents (iBots) using Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
• Experienced in upgrading and migrating of OBIEE reports between dev/test/prod environments.
• Extensively involved in developing Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Good knowledge in Oracle tools like SQL*Plus, SQL Loader, SQL Developer using TOAD in secure databases.
• Highly motivated team-player with excellent communication/problem-solving skills. Quick learning ability.

TECHNICAL SKILLS

OBIEE Tools: OBIEE 11.X/10.X, OBIA 7.9.6.3

ETL Tools: ODI 11G

Languages: SQL, PL/SQL

RDBMS: Oracle 8i/9i/10g/11g, SQL Server

Operating Systems: Windows XP, Windows 7

Database Tools: TOAD, SQL Developer, SQL*Plus

PROFESSIONAL EXPERIENCE

Confidential, Brea, CA

OBIEE Developer

Responsibilities:

• Involved in all the phases of the project from Planning, Discovery, Requirements Gathering, Design, Construction, Testing, Pilot and Deployment.
• Created new models and work flows for different data sources Oracle DB, MS SQL Server and flat files using ODI.
• Used ODI Topology Manager graphical tool to manage the data describing the information systems physical and logical architecture.
• Used the ODI Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Optimized the Knowledge modules for increasing the efficiency of jobs as a part of performance tuning.
• Performance tuned the interfaces, queries through use of indexes, ranks, Oracle hints, exchange partitions etc.
• Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team.
• Developed the repository in OBIEE by designing the physical layer , Business Model and Mapping (BMM) layer and presentation layer according to the business requirements.
• Created Drill Down Hierarchies and implemented Level Based Measures, Cache Management, and Performance Tuning using Aggregate tables in OBIEE Business Model Layer
• Developed many Analytical and Operational reports using different Analytics Views ( Pivot Table , Chart, Column Selector, and Narrative View ), Dynamic / Interactive Dashboards with drill-down and drill through capabilities, charts, tabular using global and local Filters.
• Implemented Security by creating user groups, roles and external tables.
• Created ibots using OBIEE Delivers and scheduled daily and weekly reports
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository.

Environment: OBIEE 11g, OBIA 7.9.6.3, ODI 11.1.1, Oracle11g, SQL Developer, Windows XP.

Confidential, Tennessee

ODI/OBIEE Developer

Responsibilities:

• Actively involved in all the phases of project - development, testing, deployment and support.
• Created ODI design documents from the existing mappings and used these design documents in development of interfaces/packages.
• Configured and setup ODI master repository, work repository, Project, Models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, condition.
• Implemented CDC through ODI Journalization Knowledge Modules (JKMs) to capture change on the source data.
• Created the users, profiles using the ODI security manager.
• Performance tuned the ODI interfaces.
• Performed unit and integration testing. Created various test scenarios to test the application.
• Created repository by mapping of data sources using OBIEE Admin Tool.
• Worked on development of OBIEE RPD to Physical, Business Model and Mapping and Presentation Layer, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Created Pivot Tables, Pie charts, Column/Bar Charts, View Selectors, Narrative Views, and Column Selectors in OBIEE environment.
• Created Session and Repository Variables and Initialization Blocks for desired functionality.
• Created Groups/Users and set up Security using LDAP Authentication.

Environment: OBIEE 11.1.1.6.5 , ODI 11.1.1, Oracle 11g, SQL*PLUS, SQL Developer, Windows XP.

Confidential, San Antonio, TX

OBIEE Developer

Responsibilities:

• Involved in data analysis, designing, and development of data warehouse environment.
• Interacted with Business Users and Business Analysts for gathering new business requirements and also understood the current requirements and Data Analysis.
• Worked with multiple sources such as Relational database, Flat files for Extraction, Transforming and Loading data into target tables.
• Created Business Requirement documents based on the requirements.
• Created Repositories, Agent, Contexts, Data Server and both of Physical & Logical Schemas in Topology Manager.
• Developed and maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema.
• Used ODI Knowledge Modules to create interfaces to cleanse, Load and transform the Data from Sources to Target.
• Imported tables from database, developed projects, released scenarios using ODI Designer.
• Monitored sessions for executions using ODI Operator. Managed user privileges using ODI Security Manager.
• Tuned sources, targets, mappings and sessions to improve the performance of data load into Oracle database.
• Developed the repository in OBIEE by designing the physical layer , Business Model and Mapping (BMM) layer and presentation layer according to the business requirements.
• Created Drill Down Hierarchies and implemented Level Based Measures, Cache Management, and Performance Tuning using Aggregate tables in OBIEE Business Model Layer.
• Developed reports using various Analytics Views ( Pivot Table , Chart, Column Selector, and Narrative View ), Dynamic / Interactive Dashboards with drill-down and drill through capabilities, charts, and tabular using global and local filters.
• Implemented Security by creating user groups, roles and external tables.
• Used OBIEE Delivers and Created ibots and scheduled daily and weekly reports .
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems and made corresponding changes to the OBIEE Repository

Environment: ODI 10.1.3.5, Oracle 10g/9i, SQL Developer, WINSQL, Windows XP.

Confidential, NJ

SQL & PL/SQL Developer

Responsibilities:

• Analyzed Business requirements for the enhancements required in the contract Administration application.
• Documented the detailed requirements and prepared DLD for the new enhancements.
• Performed several DDL, DML and TCL operations.
• Created database objects like stored procedures, function, packages, Cursor, Ref Cursor and Triggers using TOAD.
• Created Database packages with related functions and procedures.
• Provided support to QA team.
• Creation and Execution of the Functional Test Cases.
• Defect Logging and Tracking using Lotus Notes.

Environment: Oracle 9i, PL*SQL, Toad, Lotus Notes.

Confidential

SQL & PL/SQL Developer

Responsibilities:

• Participated in Requirements review.
• Involved in developing ER model.
• Created tables and views using SQL queries.
• Developed PL/SQL procedures, functions, Triggers using TOAD.
• Loaded Data using SQL loader and developed the control files for the same.
• Developed custom reports using SQL*Plus.
• Wrote and executed test plans, maintained versions of change components to ensure accuracy and update.
• Tested the software using many methodologies like Functional Testing, Load testing, and Regression Testing. Tuned few queries to resolve Performance issues.
• Used SQL Loader to dump the data provided in the form of flat files from the legacy system into normalized staging tables.

Environment: Oracle 8i, TOAD, SQL Loader, SQL*Plus.