SUMMARY

• 8 years of experience in Software Development and Expertise in OBIEE 11.1.1.7.1/11.1.1.3/10.1.3.4/10.1.3.3 and Siebel Analytics 7.5/7.7/ 7.8.4.
• Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Intelligent Dashboards, BI Publisher, Delivers and iBots.
• Expertise in developing Oracle BI and Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer). Complete noledge working with Siebel Analytics Administrative Tool to build Meta data, Analytics security and caching.
• Experience in Complete life cycle of Business Intelligence with Star and Snow flake Schema Methodologies.
• Around 4 years of expertise on technical areas of Metadata Design (RPD) and Dashboard Development.
• Expertise in BI Publisher, Developing and designing teh 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 schema 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 debugging and optimizing teh OBIEE/Siebel Analytics Dashboards / Reports.
• Experience in OBIEE features (me.e. Cache, Usage tracking, Dimensional hierarchy, Aggregate navigation, Variables/Initialization Blocks configuration etc.), converting Snow - Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, Physical & Logical Data Modeling.
• Proficient in defining key metrics, dimensions, hierarchies, attributes and building Star and Snow flake schema.
• Experience in developing OBIEE Repository at three layers (Physical, Business model and Presentation Layers), Interactive Dashboards and drill down capabilities using global and Filters and Security Setups.
• Migrated Analytics RPD and Web Cat from OBIEE 10g to OBIEE11g by using Oracle Fusion Middleware upgrade assistant.
• Proficient with BI Publisher reports and using various templates to publish teh report as per user requirements.
• Created BI Publishers in OBIEE Repositories.
• Expertise in Siebel Analytics Installations, Migrations and Upgrades.
• Administration of OBIEE and teh OBIEE Web Catalog.
• Performance tuning using Cache management techniques.
• Expertise working with dimensions and fact tables in teh BI Apps and experience with understanding universal adaptors in order to load into BI.
• 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.

TECHNICAL SKILLS

OLAP Tools: Siebel Analytics 7.8.2/7.7.1/7.5.2, OBIEE 11.1.1.7/11.1.1.3/10.1.3.4

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

Data Modeling: MS Visio, Erwin

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

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

Packages: SQL PLUS, Query Analyzer

Utilities: Toad, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. OBIEE Developer

Responsibilities:

• Interacted with Business Analyst, data Modelers in understanding teh Analytics report requirements
• Worked extensively on Customizing Physical Data Layer, Business model and mapping layer and Presentation Layer in Administration Tool.
• Configured teh Intelligent Dashboards for different user groups to view data across regions with teh facility of drill downs and Charts.
• Involved in creating Star schema as per teh business requirements to store teh business attributes and measures and configured teh Logical Layer, Logical tables, dimensions and columns and created teh logical joins required to support drill-down aggregation
• Having Very good Understanding of teh business requirements and Transforming teh requirements into subject areas
• Created Business Facts & Dimensions and defined Logical relation between them in BMM layer.
• Created Dimensional Hierarchies for teh Drill Down functionality and implemented Business Logics for Facts
• Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, Table) like Drill Down, Pivot Reports using Column Filters and Prompts to filter teh request in Answers
• Developed Various custom reports/Ad-hoc Reports for querying and Filters and prompts.
• Configured teh Dashboard and Saved requests in Answers for drill down features
• Worked with teh Security settings in Oracle Business Administration Tool to set up users, groups, access privileges.
• Creating Dimensional Hierarchies and level based Measures
• Prepared teh ETL spreadsheet after identifying teh Facts and Dimensions.
• Good experience in understanding & creating source and target definitions, mappings, and working with sessions
• Configured teh scheduler which runs teh Ibots and delivers teh content
• Developed BI dashboards for territory report, Sales Performance etc.
• Disconnected Analytics are set up to enable users to access reports during off network time.
• 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.,
• Involved in Creating teh required mappings using Informatica PowerCenter Designer and created teh tasks for teh mappings developed through Informatica PowerCenter
• Participated in weekly team meetings and reviews meetings.
• Co-ordinated with QA team to test and validate teh reporting system and its data

Environment: Oracle Business Intelligence(OBIEE)11.1.1.7, Oracle BI Server, BI Publisher Enterprise, SQL Developer, Oracle11.

Confidential, LA

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 teh business model.
• Identified teh granularity level of teh business model based on teh end user requirements.
• Extensively used OBIEE Administration Tool for Customizing and modifying teh physical, business, and presentation layer of teh repository.
• Worked extensively on OBIEE Answers and Dashboards to create teh reports as per teh client requirements.
• Worked extensively on various Cache Management techniques to increase teh performance of teh both Real-Time and Non Real-Time reports.
• Implemented Time Comparison and calculation measures in teh business model using Time series wizard.
• Created groups in teh repository and added users to teh 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 teh metadata to ensure standard measures and best practices are followed.
• Maintained TEMPeffectiveness in creating teh dashboards by appropriately including guided navigational links and drilldowns. Setup teh 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 teh 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, DAC, Toad, Windows XP, PL/SQL.

Confidential

Sr. OBIEE Developer

Responsibilities:

• Gathered Business Requirements from end Users and efficiently converted teh requirements to technical specifications for developing teh Reports/Dashboards as defined.
• Developed various objects in Repository using BI Admin tool by importing teh required objects with integrity constraints into Physical Layer using Connection Pool.
• Categorized teh Facts, Dimensions and identified teh Granularity level in accordance with teh need of end user before implementing teh Multi-Level Based Hierarchies.
• Customized Star and Snowflake schemas by linking teh Fact and Dimension Tables.
• Created measures and Aggregated Tables to better teh performance/understanding of teh reports.
• TEMPEffectively implemented Time Series Functions, calculation Wizard and Expression Builder to generate trend analysis reports.
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to Reports.
• Implemented Security at Object level and Data level in teh OBIEE Repository and Answers by creating Repository and Session Variables and Initialized Blocks.
• Created Security settings in OBIEE Administration Tool to set teh groups and access privileges and query privileges. Also implemented security for teh groups at teh BI Answers.
• Developed end-user and migration Documentation briefing teh features and capabilities of various reports with screenshots and supporting description on how to schedule and execute.
• Developed reports and dashboards with various analytical views with Global and Local Filters.
• Customized Prompts page level and Dashboard level, in accordance with teh requirements.
• Developed Guided Navigation drill downs, Pivot Tables, Narrative Views, Charts to improve accessibility of dashboards.
• Configured presentation layer used by different user groups and also established various standard queries in order to create precise presentation layer.
• Designed and Integrated BI Publisher reports to oracle BI Dashboards for Analysis to PDF/RTF templates.
• Configured iBots to deliver content based Analytics on schedule, Automated iBots to obtain daily and weekly reports.
• Created teh Technical and Functional design documents for teh entire new application.
• Deployed teh test cases and test scripts to test teh reports during teh Testing phase.

Environment: OBIEE 10.1.3.4, Oracle 11g/10g, Windows NT, SQL *PLUS, Toad, BI Publisher.

Confidential, Fort Lauderdale, FL

OBIEE Developer

Responsibilities:

• Identified Facts, Dimensions, and Hierarchies of teh business model.
• Involved in Analysis, Requirement gathering, function/technical specification, development and testing.
• Identified teh granularity level of teh business model based on teh end user requirements.
• Extensively used OBIEE Administration Tool for customizing and modifying teh physical, business, and Presentation layer of teh repository.
• Worked extensively on OBIEE Answers and Dashboards to create teh reports as per teh client requirements.
• Worked extensively on various Cache Management techniques to increase teh performance of teh both Real-Time and Non Real-Time reports.
• Created groups in teh repository and added users to teh 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 teh 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 teh 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: Windows XP, OBIEE 10.1.3.3, Oracle Financial Analytics 7.9.5, Oracle 11g, SQL, TOAD, PL/SQL.

Confidential

Siebel Analytics Developer

Responsibilities:

• Involved in Creating and Administering teh Physical Layer, Business Model and Mapping Layer and Presentation Layer in a Siebel Analytics Repository.
• Configured analytics repository with logical dimensional modeling using Star Schema (Facts and Dimensions).
• Configured and created repository using Siebel Analytic Admin Tool.
• Developed different kinds of reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.
• Created connection pools to retrieve data from Siebel OLAP layer, real time Siebel OLTP data and data from Oracle Database.
• Managed day to day rpd, scheduler, and iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Involved in setting up Delivers to configure iBots based on teh threshold value to teh users.
• Developed UNIX and PL/SQL scripts for pre & post session processes to automate daily loads.
• Created ibots and Delivers to send Alert messages to subscribed users.
• Worked on various Informatica mappings as per business requirement.
• Worked extensively on Unit testing, Integration testing and fixed bugs during teh UAT phase.

Environment: Siebel Analytics 7.8.5, Informatica 6.x (Power Center Designer, Workflow Manager, Workflow Monitor), Oracle 10g/9i, SQL, PL/SQL, SQL Server 2000/2005, Windows 2000/2003, ER Studio