SUMMARY

• Highly pro - active individual with a ‘Can Do’ attitude, having 8 yrs. of IT experience spanning across data warehousing, software development and Oracle Financials
• Expertise in developing Oracle BI and consisting of three layers (Physical Layer, Business Model & Presentation Layer). Complete knowledge working with Informatica Administrative Tool to build Meta data, Analytics security and caching.
• Experience in implementing and configuring pre-built OOTB Analytics (Financials, HR, Sales) of Oracle BI Applications (OBIA), Informatica and DAC.
• Experience in Complete life cycle of Business Intelligence with Star and Snow flake Schema Methodologies.
• Expertise on technical areas of Metadata Design (RPD) and Dashboard Development.
• Expertise in BI Publisher, Developing and designing the template in rich text format (RTF) and portable document text format (PDF).
• Expertise in OLTP/OLAP System Study, Analysis and developing Database Schemas like Star and Snowflake schema.
• Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO).
• Expertise in configuring Multiuser Development Environment (MUDE) and Usage Tracking.
• Expertise in debugging and optimizing the OBIEE/Siebel Analytics Dashboards / Reports.
• Experience in OBIEE features (i.e. Cache, Usage tracking, Dimensional hierarchy, Aggregate navigation, Variables/Initialization Blocks configuration etc.), converting Snow-Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, and Physical & Logical Data Modeling.
• Proficient in defining key metrics, dimensions, hierarchies, attributes.
• Expertise in OBIEE Installations, Migrations and Upgrades. Created BI Publishers in OBIEE Repositories.
• Administration of OBIEE and the OBIEE Web Catalog. Performance tuning using Cache management techniques.
• Expertise working with dimensions and fact tables in the BI Apps and experience with understanding universal adaptors in order to load into BI.
• Expertise in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring Analytics Metadata objects (Subject Area, Table, Column), Answers (ad-hoc querying, reports), Variables (Repository/Session/Presentation), Interactive Dashboards with drill-down/drill across capabilities (charts/tables/graphs), Delivers (Agents/iBots), Administering Web Catalog Objects (Dashboard, Pages, Folders, Reports), Cache monitor, Job Manager, Catalog Manager.
• Extensively Worked on OBI Publisher importing data from multiple data sources and delivered Reports, common dashboards, metadata, security, calculation, caching and intelligent request generation services.
• Very strong analytical and presentation skills, problem-solving techniques, proven leadership qualities with emphasis on individual and team effort backed by excellent communication skills.
• Implemented Usage tracking to analyze and tune the query performance.

TECHNICAL SKILLS

OLAP Tools: OBIEE 11.1.1.x/10.1.3.x, OBIA 7.9.x, Siebel Analytics 7.8.2/7.7.1/7.5.2

Databases: Oracle 11g/10g/9i, MS SQL Server 2000/2005, MS Access

ETL Tools: Informatica 9.x/8.x/7.x/6.x, DAC 11.1.1.x/ 10.1.3.4/7.9

Languages: C, C++, SQL, PL/SQL

Operating Systems: Windows 07/XP/00/NT/98/95, Linux, UNIX (Solaris)

Packages: SQL* PLUS, Query Analyzer

Utilities: Toad, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Sunrise, FL

Sr OBIEE Developer

Responsibilities:

• Interacted with Business Analyst, data Modelers in understanding the Analytics report requirements.
• Worked extensively on Customizing Physical Data Layer, Business model and mapping layer and Presentation Layer in Administration Tool.
• Configured the Intelligent Dashboards for different user groups to view data across regions with the facility of drill downs and Charts.
• Involved in creating Star schema as per the business requirements to store the business attributes and measures and configured the Logical Layer, Logical tables, dimensions and columns and created the logical joins required to support drill-down aggregation.
• Having very good understanding of the business requirements and transforming the requirements into subject areas.
• Created Business Facts & Dimensions and defined Logical relation between them in BMM layer.
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
• Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, and Table) like Drill Down, Pivot Reports using Column Filters and Prompts to filter the request in Answers.
• Developed various custom reports/Ad-hoc Reports for querying and Filters and prompts.
• Configured the Dashboard and Saved requests in Answers for drill down features.
• Worked with the Security settings in Oracle Business Administration Tool to set up users, groups, access privileges.
• Good experience in understanding & creating source and target definitions, mappings, and working with sessions.
• Configured the scheduler which runs the IBots and delivers the content.
• Extensively used Dashboard, Pages, Sections, Add Column, Dashboard Prompts including View Selector, Column Selector, Pivot Tables, Charts, Presentation Variables, Permissions on Shared Folders via Catalog Manager etc.,
• Participated in weekly team meetings and reviews meetings.
• Co-ordinated with QA team to test and validate the reporting system and its data

Environment: OBIEE 11.1.1.7, BI Publisher Enterprise, SQL Developer, Oracle11g.

Confidential, Confidential, IL

Sr. OBIEE Developer

Responsibilities:

• Interacted with Subject Matter Experts (SME), Business Analysts and users in gathering and analyzing and designing the Business report requirements.
• Designed and Developed the RPD by importing metadata into Physical layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Designed and developed OBIEE/Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developed Calculated Measures, dimension hierarchies & Logical Facts/Measures in Business Model Layer, and creating the presentation catalogs in Presentation Layer.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Designed, Created and Tested Reports in the Dashboards and also provided Adhoc reporting capability as per the client needs.
• Created groups in the administration console and added users to the groups
• Designed, Developed and Tested Data Security and Dashboard Security in OBIEE.
• Implemented Security by authenticating against an LDAP server.
• Migrated the tested code from Dev to QA and QA to production.
• Configured Interactive Dashboard with drilldown capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
• Developed custom reports/Adhoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, Oracle materialized views and making changes to reports
• Managed security privileges for each subject area and dashboards according to user requirements.
• Implemented and extensively worked in Multi User Development MUDE and performed some Administration tasks such as Creating users, groups, Projects and provide required authentication as needed.
• Developed and scheduled IBots using BI delivers to deliver Analytics content based on schedule, automated IBot queries to obtain daily and weekly reports.
• Upgraded the 10g rpd to meet the 11g standard and rolled out OOTB reports for in current DWH.
• Installed and configured OBIEE 11g as a kick-start for current upgrade process of our current 10g version of OBIEE in Sandbox.
• Involved in Merging the RPD and Web Catalog folder with OBIEE Admin tool and Catalog Manager.
• Extensively worked on the Informatica Power Center tools - Designer, Workflow Manager, Workflow monitor.
• Created custom complex Mappings which use to bring the data from Oracle EBS Loans base tables to staging tables and then to Facts and Dimensions.
• Implemented slowly changing Dimensions (SCD, Both Type 1 & 2).
• Extensively worked on transformations like Lookup (Connected and Unconnected), Aggregator, Expression, Router, Filter, Update Strategy and Sequence Generator.
• Created and Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Workflow Manager.
• Used Repository Manager for moving the mappings and sessions from one environment to another, such as from a development environment to test or production environments.
• Created custom Mappings, Mapplets to load the new tables and the new information into the warehouse.
• Used Informatica to load data from Flat Files to Oracle using various transformations.
• Performed Unit, Integration and Regression testing to validate and mapping functionality.
• Worked closely with Users and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.
• Involved in rpd merge, webcat merge, migrate from Dev to QA to Prod.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Educated and Trained End Users and Pilot Users about OBIEE Tools.

Environment: Oracle BI Apps 7963/795(Finance and HR), DAC 10.1.3.4.1 , OBIEE 11.1.1.6.0 / 10.1.3.4.1 , Informatica 9.x/8.x, Windows 2003 Server

Confidential, TX

Sr. OBIEE Developer

Responsibilities:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Installed and configured Oracle BIEE 11.1.1.3/11.1.1.7.1
• Installed and configured BI Publisher and Integrated with OBIEE server.
• Identified Facts, Dimensions, and Hierarchies of the business model.
• Identified the granularity level of the business model based on the end user requirements.
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Implemented Time Comparison and calculation measures in the business model using Time series wizard.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Enforced criteria based navigation to achieve better SLA on Ad hoc queries based on customer origination and industries.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Created corporate standard variables in the metadata to ensure standard measures and best practices are followed.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns. Setup the visibility of dashboards to employees with respect to their responsibilities.
• Implemented Prompts to provide dynamic filter condition to End users.
• Created Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and charts.
• Providing object level security for different web groups based on responsibilities.
• Developed security matrix for dashboards/Answers users based on Individual responsibilities and LDAP Authentication type.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.

Environment: OBIEE 11.1.1.3, BI Publisher, Oracle 10g, Toad, PL/SQL.

Confidential, Fort Lauderdale, FL

OBIEE Developer

Responsibilities:

• Identified Facts, Dimensions, and Hierarchies of the business model.
• Involved in Analysis, Requirement gathering, function/technical specification, development and testing.
• Identified the granularity level of the business model based on the end user requirements.
• Extensively used OBIEE Administration Tool for customizing and modifying the physical, business, and Presentation layer of the repository.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Created corporate standard variables in the metadata to ensure standard measures and best practices are followed.
• Customized Dashboard reports using drill-down capabilities.
• Implemented Prompts to provide dynamic filter condition to End users.
• Created Intelligent Dashboards for different groups of users to view across regions, Customer demography with the facility to drill downs and charts.
• Providing object level security for different web groups based on responsibilities.
• Developed security matrix for dashboards/Answers users based on Individual responsibilities.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.

Environment: OBIEE 10.1.3.3, Oracle 11g, SQL, TOAD, PL/SQL.

Confidential

Siebel Analytics Developer

Responsibilities:

• Involved in translating high-level business requirements into logical business dimensional model.
• Designed and developed the OBIEE/Siebel Analytics Metadata Repository (.rpd) using OBIEE 10.1.3.x Admin Tool by importing the required data base objects both Facts and Dimensions with integrity constraints into physical layer using connection pool.
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Mapping in data sources using Oracle BIEE Admin tool to create repository.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• 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
• Created OBIEE Intelligent Dashboards, & Answers.
• Assigned Data level & UI level security to the Users.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Created and used Siebel Delivers and iBots extensively.
• Involved in developing ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 7.1.x/8.x.
• Involved in fine-tuning of Informatica Mappings.
• Involved in creating mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target table.

Environment: Seibel Analytics 7.8.2, Power Center 7.1.x/8.x, MS Office, Toad