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,Toad,BICS.
• Expertise in developing Oracle BI and Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer). Complete knowledge 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 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 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).
• Worked in Agile methodology.
• 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, Physical & Logical Data Modeling.
• Proficient in defining key metrics, dimensions, hierarchies, attributes and building Star and Snow flake schema.
• 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 the report as per user requirements.
• Created BI Publishers in OBIEE Repositories.
• Expertise in Siebel Analytics Installations, Migrations and Upgrades.
• Administration of OBIEE and the OBIEE Web Catalog.
• Performance tuning using Cache management techniques.
• Created datamodels, reports and dashboards in BICS.
• Created data models, RTF templets, Excel templates using BI Publishers.
• Experience in developing and supporting both production and development system.
• Ability to successfully communicate at all business levels
• Team player with Excellent communication skills
• Hands on experience on SAP BO.

TECHNICAL TOOLS:

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

WORK EXPERIENCE:

Confidential, Los Angeles, CA

Sr. OBIEE Lead Developer

Responsibilities:

• Performed in-depth analysis and documentation of business logic and requirements.
• Developed high level design documents for reporting and analysis projects.
• Extensive experience in working with Multi User Development Environments
• Deployed the RPD from MUDE to DEV, QA and production environments
• Designed and implemented Physical and Logical Star Schemas using Facts, Dimensions, Alias, Metrics and Extension tables provided with Foreign and Complex joins.
• Worked with database administrators to optimize report performance through database tuning.
• Created Meta Data repositories using OBIEE administration tool.
• Created OBIEE subject areas based on reporting requirements and built them into the physical layer of the OBIEE repository.
• Managed ODBC connections with created Meta Data and Repositories according to needed Subject Areas.
• Designed and built the physical and logical models in Physical and Business Model & Mapping Layer in the OBIEE Administration tool.
• Worked on RTF Templet and interactive template for migrating reports from 10 G to 11G
• Worked on scheduling BIPublisher reports basing on user requirement.
• Performed monitoring and analysis on OBIEE report usage.
• Established and followed processes for OBIEE access requests, new report requests, report changes, and other ongoing maintenance.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
• Modified existing reports and created new reports from various sources as per the business requirements.
• Created session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.

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

Confidential, Pittsburgh, PA

Sr. OBIEE Developer & Lead

Responsibilities:

• Install, upgrade, patched and configure all components of OBIEE on Development, Test and Production server
• Migrated RPD, catalog and configured Active Directory Security on servers
• Design and implement data in various layers including physical, business and presentation
• Assist the teams in generating dashboards and reports properly
• Use the best practices of business intelligence to administer the analytical solutions
• Perform validation of data on the reports and monitor the performance status of the same
• Prepare monthly reports and present it to the management
• Assess production faults and critical issues followed by identification of the root cause
• Provide remedial measures to the production issues or process failure
• 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
• Developed Data model and loaded data for Education and Healthcare Analytics in BICS
• Created Reports and Dashboards for Education and Healthcare Analytics in BICS
• Created user level security for intelligence dashboards based on Business Requirement
• Created session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Created users, groups, access privileges and query privileges using Security settings in OBIEE AdminTool
• Defined users, groups, access privileges and query privileges

Environment: Oracle Business Intelligence(OBIEE)11.1.1.7, BICS,Manufacturing Analytics, Oracle BI Server, BI Publisher Enterprise, TOAD, Oracle11, Oracle BI Presentation Server, BI Publisher 11g, OBIEE Administration Console, OBIEE Enterprise Manager.

Confidential, Charlotte, NC

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.
• Created mock reports and dashboards for review by the business users
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment
• Performed GAP Analysis
• 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, 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.
• Creating Dimensional Hierarchies and level based Measures
• Prepared the ETL spreadsheet after identifying the Facts and Dimensions.
• 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
• Developed BI dashboards for territory report, Sales Performance etc.
• Involved in Creating the required mappings using Informatica PowerCenter Designer and created the tasks for the mappings developed through Informatica PowerCenter
• Participated in weekly team meetings and reviews meetings.
• Co-ordinated with QA team to test and validate the reporting system and its data

Environment: Oracle Business Intelligence(OBIEE)11.1.1.7, Oracle BI Server, BI Publisher Enterprise, SQL Developer, Quality Center, Windows XP Professional

Confidential, Lafayette, 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 the business model.
• Expertise in Developing the Subject Area with Physical Layer Objects(Database, Connection Pool, Catalog, Schema, Table), Business Layer Objects (Logical Table, Dimensions, Joins, Facts, Initialization Blocks, Repository Dynamic Variables), Presentation Layer Objects (Table, Columns)
• Created various logical columns based on existing logical/physical tables as sources
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling
• 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, DAC, Toad, Windows XP, PL/SQL.

Confidential, Stamford, CT

Sr. OBIEE Developer

Responsibilities:

• Categorized the Facts, Dimensions and identified the Granularity level in accordance with the need of end user before implementing the Multi-Level Based Hierarchies.
• Customized Star and Snowflake schemas by linking the Fact and Dimension Tables.
• Created measures and Aggregated Tables to better the performance/understanding of the reports.
• Effectively 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.
• Worked extensively on Customizing OBIEE Administration tool for Repository that includes Physical Data Layer, Business model and mapping layer and Presentation Layer.
• 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
• Configured the Intelligent Dashboards for different user groups to view data across regions with the facility of drill downs and Charts.
• Implemented Security at Object level and Data level in the OBIEE Repository and Answers by creating Repository and Session Variables and Initialized Blocks.
• Created Security settings in OBIEE Administration Tool to set the groups and access privileges and query privileges. Also implemented security for the groups at the BI Answers.
• Developed end-user and migration Documentation briefing the 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 the 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 the Technical and Functional design documents for the entire new application.
• Deployed the test cases and test scripts to test the reports during the 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 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: 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 the 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 Creating the required mappings using Informatica PowerCenter Designer and created the tasks for the mappings developed through Informatica PowerCenter
• Extensively performed data validations and created mapping document from source to target.
• Created the required mappings using Informatica Power Center Designer and created the tasks for the mappings developed through Informatica Power Center Workflow Manager
• Involved in setting up Delivers to configure iBots based on the threshold value to the users.
• Worked extensively on Unit testing, Integration testing and fixed bugs during the 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