SUMMARY

• Over 7 years of Business Intelligence experience with more than 5 years of experience in the design and development of OBIEE and BI publisher.
• Over 3 full life cycle implementations of OBIEE 10/11g with BI Publisher.
• Experience with OBIEE components and configuring security within OBIEE
• Experience in implementing security in OBI using Repository Variables, Initialization Blocks, and Session Variables.
• Expertise in Creating Filters, Global Prompts in Dashboards, Presentation Variables, and Narrative Views to filter the data.
• Implemented Data Level Security, Object Level Security and LDAP authentication.
• Experienced in Extracting Data from different source Systems i.e. Oracle, SQL SERVER, Flat Files, Excel etc.
• Good Knowledge in Oracle PL/SQL Packages, Procedures, Functions, Triggers and other objects.
• Excellent Self-Driven project management skills, Team Player, Good communications, Presentation and Telephony skills.
• Strong knowledge on Data warehousing concepts.
• Have a thorough understanding of Oracle Business Intelligence Enterprise Edition OBIEE Architecture and the role played by different OBIEE components like analytic server, web server, rpd, security, Dashboards, Reports, I-Bots and Scheduler.
• Experienced in working with Variable Manager to define session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically
• Expertise in design and development of the three layers Physical/Business Model and Mapping/Presentation of an OBIEE Metadata Repository .rpd using Oracle BI Administration Tool.
• Experienced in creating Dimensional Hierarchies, Level Based Measures. Time series Functions, depending upon the need for Business Reports using the OBIEE Admin tool.
• Extensively performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes
• Created Users, Groups and giving the permissions in Administration Tool and verified the permissions of the users in the OBI domain
• Experienced in configuring Usage Tracking and Multi-user Development Environment MUDE
• Experienced in designing customized interactive dashboards using drill down, guided navigation, prompts, filters, and variables

EDUCATION

Bachelor of Arts in Business Administration - Management Information Systems, Eastern Washington University, May 2007

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.6.1/7.x/6.x/5.x. BI Tools: OBIEE10g/11g, Tableau, BI Publisher Operating Systems: MS Dos, Win 95/98, NT 4.0, Win 2000, Win XP, UNIX. RDBMS: Oracle 11g/10G MS SQL SERVER 2008, SQL/PLSQL Languages: C, SQL, PL/SQL, and UNIX Shell Scripting. Web Servers: Apache, IBM Web Sphere, Web Logic, and IIS Modelling Tools: Erwin, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential

OBIEE Developer

Responsibilities:

• Facilitated and captured operational and analytical reporting requirements in support of the OBIEE implementation.
• Facilitate requirement gathering sessions with the business stakeholders to demonstrate features and functionality of the OBIEE and BI Publisher platform
• Collaborated with business areas and data owners to effectively design and develop OBIEE and BI publisher reports
• Defined and developed logical and User Interface UI data components to support the development of reports
• Created, maintained, and managed the technical documentation and artifacts for the reports design including the BI repository and BI Publisher configurations
• Demonstrated and gather feedback on reports based on business requirements
• Supported the configuration of OBIEE and BI Publisher security based on defined data visibility requirements
• Developed guidelines and best practices to ensure data standardization and consistency
• Provided necessary support for the testing and deployment of the reports
• Interacted with functional technical leads, SME's and other business groups to identify, analyse, and document business requirements.
• Designed and implemented custom business intelligence solutions along with the pre-built solutions Metadata and Dashboards/Reports .
• Developed Metadata Repository .rpd with multiple business layers using complex joins, presentation catalog with access validations and external table security repository and repository migration.
• Designed and developed Dashboards/Reports that are Dynamic Interactive with intuitive drilldowns, drill-across flash-based drillable charts bar-charts, pie-charts, radars, and bubble-charts , Capabilities split reports for summary details information, and local global filters and cache monitor using OBIEE.
• Performed the Security management for users, groups and web-groups using the various authentication systems.
• Enhance performance by requesting Aggregate tables, Indexes and managing Cache after Benchmarking performance tuning strategies with business model-level calculations versus database level pre-computations and aggregations.
• Life-cycle support for migration efforts from development to QA to production analytics
• Involvement with ETL Extract-Transform-Load development team to communicate the specification for the required dimensional, aggregate and indexed data tables
• Development of many complex Informatica mappings and mapplets to build key interfaces using transformations and reusable transformation units Update Strategy, Filter, Router, Expression, Lookup, Aggregator for loading data into Data Warehouse
• Involved in upgrade from 10g to 11g

Environment: Oracle BIEE 11g, OBIA 7.9.6.3, Informatica, Oracle 11g, Linux

Confidential

OBIEE Developer

Responsibilities:

• Gathered and analysed requirements from the business users and wrote functional documents and technical specifications
• Designed Metadata repository .rpd in the Administration Tool by importing metadata from data marts
• Defined dimensions and facts in the repository according to the business entities in the Administration Tool
• Designed reports in Answers and published them in dashboards as per the user requirements
• Used appropriate filters, column filters, prompts, dashboard prompts and calculations in reports
• Created reports in different views as Pivot Table view, Table View, Ticker view and selector views
• Worked on administration tool to create users, user groups, set permissions to the user groups and assign users groups to the users
• Involved in developing ETL processes, Informatica Mappings, Sessions, Workflows and Mapplets using various Transformations Joiner, Aggregate, Lookup, Filter and Router Transformations in Mappings.
• Identified gaps and fed back data requirements to other source systems. Identified data sources, extension columns, OBIEE OLTP tables, Fields and mapped them to staging tables and ultimately to OLAP physical layer
• Tuned the OLAP database including techniques at the file systems and table spaces, placement of aggregate tables and bit-mapped join indexes, to maximize input/output and optimized performance
• Worked very closely with development activities with respect to configuration, scripting e script and building custom business services and workflows to automate business processes
• Trained end users to build Ad Hoc Reports using OBIEE Analytics

Environment:OBIEE 11.1.1.6 11.1.1.7 Admin tool, Answers, MUD, Dashboards, Delivers, Agents / iBots, Windows Server 2003, 2008, Oracle 10g, 11g.

Confidential

OBIEE/BI Publisher Developer

Responsibilities:

• Provided development, application and administrative support for the entire OBIEE environment at Medtronic Headquarters.
• Contact Person for all environment activity that impacted end users, developers, testers and management.
• Supported various projects, including monitoring, troubleshooting, tuning, installation, upgrades, migration and deployment of various environments.
• Created RPDs, defined Physical Layer, and developed Business Model Mapping and Presentation Layer using Admin Tool.
• Created and managed OBIEE dashboards and reports.
• Set up Meta data Objects Subject Area, Table, Column security and Data level security
• Modified Metadata Logical definitions in Analytics Repository using OBIEE Admin Tool.
• Created Physical and Complex Joins as well as some new Joins. Exposed custom attributes in Presentation Layer.
• Used narrative text, column selector, global and column filters to provide the functionality of viewing selective data for the end users.
• Created and maintained environment configuration documents.
• Responsible for keeping the configuration management database up-to-date with changes and relationships to test, staging and production environments
• Completed documentation when implementing changes to the production environments
• Through proper preparation, ensured environment readiness at the start of each Project Development, test, staging and production cycle
• Monitored daily OBI application performance - Batch jobs, schedulers, services, cache, etc.
• Managed and escalated issues as needed
• Used various options in an OBIEE to improve the performance of reports.
• Used OBIEE Answers to create the Financial Statement reports and Dashboards as per the detailed design requirements
• Coordinated the OBIEE RPD and Presentation Catalog objects migration across instances.
• Merged Presentation Catalogs Web Catalogs using OBIEE Catalog Manager
• Set permissions on users in Catalog Manager.
• Involved in setting up and working in multi-user developer MUD environment
• Written Shell script to change the format of a column in all the reports of a particular subject area in the web catalog.
• Written shell script for Regression test and performed Regression test.
• Extensively used time series functions AGO and TODATE
• Extensively used repository variables and session variables and initialization blocks and implemented LDAP security.
• Worked on Answers, Dashboards and Delivers and configured web catalog objects.
• Created dashboard prompts and column prompts to filter the selection criteria.

Environment:OBIEE 10.1.3.3, Oracle 10g, Informatica 8.1, DAC, OBIA 7.9.5, Windows Server 2003, TOAD, BI Publisher, Siebel CRM 7.8, Siebel Call Center 7.7.