CHRONOLOGICAL SUMMARY OF EXPERIENCE

OBIEE Lead Developer

Confidential

• As the OBIEE lead, Involved in end to end implementation of three projects.
• Obtain the requirements from business users and created BRDs an involved in design of warehouse tables.
• Administered OBIEE and applied patches to existing version.
• Involved in data modeling and creating ODI interfaces to load the data into tables.
• Created various subject areas and also worked on parent child hierarchy, level based hierarchies.
• Implemented both data level and object level security for the reports at RPD level and Reports level.
• Set up MUDE and Involved in Repository migration and catalog migration across the environments.
• Created reports, action links, various views in reports as per the requirements.
• Customized the OBIEE login page and Herbalife custom messages and colors to login page.
• Set up usage tracking for the reports and also implemented write back functionality
• Integrated Maps into OBIEE using Map viewer and created reports using map view.
• Worked on OBIEE reporting based on ADF pages as source.
• Implements Proxy access Act As feature to view the reports.
• Involved in performance tuning of the reports and cache management.
• Round the clock production support of all the projects developed.

Environment: OBIEE 11.1.1.7, ODI 11g, Oracle R12, Windows 7, SVN, WebLogic, SQL Developer, FileZilla

OBIEE Architect/Lead

Confidential

• Lead two projects involving OBIEE Answers Reports and BI Publishing Reporting.
• Obtain business requirements from Business analysts and users.
• Customized the OBIEE Repository Physical, BMM, and Presentation layers .
• Responsible for the DAC and Powercenter execution plan development for a new OBIEE implementation of Financial Analytics.
• Created dimension hierarchies, aggregates, level based measures, defined level keys in BMM layer.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Build repositories from scratch, perform business modeling and mapping, create security profiles, create variables, send for testing, deploy to OBIEE Presentation Services
• Create drillable/guided navigation reports based on business requirements.
• Created repository variables and initialization blocks in RPD and presentation variables in Answers.
• Managed cache in BI Publisher and OBIEE.
• Create dashboards, ibots agents , prompts, and set permissions.
• Create performance reports to be reviewed by executives for the worldwide firm, by management at local regional and set security to localized regions, as well as functional reports for the detailed financial team. Testing and debugging of reports.
• Created customer faced documents using BI Publisher.
• Involved in production migration of BI Publisher reports, OBIEE RPD and Web Catalog. Also involved in version management
• Created reports involving multiple datasets in BI Publisher and created RTF Templates.
• Created charts and cross tabs in BI Publisher templates.
• Performance Tuning of Answers Reports and BI Publisher reports.
• Scheduled BI publisher reports via java app which enables the users to send/distribute the reports by themselves to distribution list.
• Involved in upgrade process from OBIEE 10.1.3.4 to 11.1.1.5
• Enhanced all the Answers reports/ BI Publisher reports and RPD after the upgrade.
• Helped manage risk analysis and mitigation plans, status reports, and client presentations prepared business process models, milestone deliverables, and established critical success factors.
• Maintaining the Full and Incremental loads through DAC on different environments like Development and Test environment.
• Created and maintained documentation for the project describing all the tasks and work flows.
• Trained the users to create reports in Answers.
• Provided post production support for the two deployed projects in OBIEE and BI publisher.

Environment: OBIEE 11.1.1.5 / 10.1.3.4.1, BI Publisher, BI Apps 7.9.6.3, Oracle 11g, Windows XP, Solaris, Aquadata Studio, DAC 7.9.5, SVN

OBIEE Architect/Developer

Confidential

• Involved in all the phases of project from initial phase to the production release like requirement gathering, design, development, testing and release.
• Customized OOTB Out of the box Sales Analytics and Oracle Incentive Compensation HRMS repository as per the business requirements.
• Personally implemented most key projects of Empower rollout which involved building dashboards for Order Management, Order Fulfillment, Customer Service, Installation Management, Cash Management and Incentive Compensation.
• Created number of key reports for business such as Cross sales report, Revenue report, Finance and Authorization report, Lender analysis report for business to analyze.
• Worked with OBIEE Answers, Intelligence Dashboards. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports to satisfy the end users. Managed dashboard and request security/privileges in the analytics catalog manager.
• Worked with onshore and offshore team of 5 developers and led the team in the direction of development.
• Worked on Informatica OOB and Customized SDE, SIL Mappings, Workflows following best practices of Siebel. Worked with Siebel compatible table structures by configuring Informatica transformation objects.
• Deployed the Informatica workflows to the Siebel DAC and created dependency and dependent hierarchical tasks and monitored all the tasks in the execution plans that were running, scheduled, completed and failed with DAC feature called run history and resolved the failed ones. Streamlined the Execution plans with their respective tasks in Siebel DAC.
• Setup and administered Usage tracking using the direct insert process.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Configured repository and session variables to get dynamic reports and dashboards.
• Used Catalog Manager to maintain Analytics web catalog to manage Dashboards and Answers.
• Used the Security settings in Oracle BI Admin Tool to set up SSO, users, groups, access privileges and query privileges.
• Peer review of code, testing, monitoring NQSQuery and tuning reports.
• Generated Real-Time Reports based on Siebel Call Center Application data model.
• Installed Informatica Power Center Version 8.6.1 in Sandbox and upgraded V7 to V8.1.1.
• Involved in Production support for Informatica, DAC and Analytics and helping users with any questions regarding the reports or the data.

Environment: OBIEE V 10.1.3.4.1, DAC 7.9.5, Oracle 10GR2, Sun Solaris Platform, BI Apps 7.9.1, Oracle EBS 11.5.10, Siebel CRM 7.9.5, Toad, SQL Plus, OBI Publisher, Windows XP.

OBIEE Developer

Confidential

• Involved in Creating and Administering the Physical Layer, Business Model Mapping Layer and Presentation Layer in repository.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Configure and interactive Dashboards to alert the Marketing team about business changes.
• Managed day-to-day Rpd, BI Delivers, Scheduler iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Worked on Event Polling Tables to clear out the Cache on the OBIEE server side.
• Worked extensively on the initialization blocks and session variables for the SSO implementation to access the groups based on a pipelined table function.
• Created Virtual Dimensions Aliases on the original tables, and used them to join to other fact tables.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures
• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Involved in Design and Data Modeling using Star schema.
• Involved in upgrading the platform and applications to OBIEE though sequential and concurrent tasks which includes upgrading webcat, scheduler and migrating the rpd.
• Designed assisted Informatica ETL developer to create new Aggregates.

Environment: OBIEE 10.1.3.4.1, Oracle 10g, UNIX, SQL server, Windows NT 2000.

Sr. Siebel Analytics Consultant

Confidential

• Created Business Facts Dimensions and defined Logical relation between them in BMM layer.
• Created Drill down Hierarchies and implemented Business Logics for Facts.
• Analyzed and validated the business model in Siebel Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Imported Physical Tables and Defined Relations in Physical Layer in Siebel Analytics
• Created Reports using different Analytics Views Pivot Table, Chart, Column Selector, Table
• Created Pivot Tables and manipulated Init Blocks for report analysis
• Worked Extensively on Siebel Answers to create the reports as per the client requirements
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Exposed various business models in the presentation layer for querying.
• Maintained Existing .NET framework code for the front end customer CRM application
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created Analytics Reports including Charts and Pivot table's Compound layout using Siebel Answers.
• Created ibots and Delivers to send Alert messages to subscribed users.
• Worked on various Informatica mappings as per business requirement.
• Performed end-user training to develop ad-hoc reports using Siebel Answers
• Created mappings using PL/SQL packages to implement business rules while loading data.
• Performed performance tuning by optimizing Target, Source, Mapping and Session.
• Involved in migration of mappings / workflows from Development to Testing and to production.

Environment: Siebel Analytics 7.8.4, Oracle 9i, Informatica 7.1.2, Unix-Shell scripting, TOAD, SQL developer, SQL, PL/SQL, UNIX, Toad, Windows 2003.

Sr. Siebel Analytics Developer

Confidential

• Used Siebel Analytics Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository .rpd .
• Sourced Data from multiple databases files.
• Worked Extensively on Siebel Answers to create the reports as per the business requirements.
• Configured Intelligence Dashboards by adding embedded content such as links/images, HTML objects and folders.
• Used Catalog manager to maintain Analytics web catalog to manage Dashboards, Answers.
• Designed the logical and physical data model for Siebel data warehouse to store OLAP data.
• Analytics Admin work: New ID creation, Account modification of existing users, Password reset and Deletion of accounts.
• Developed and supported ETL process using Informatica tools.
• Analyzed complex mappings to extract and transfer source data from different databases.
• Worked in ETL process using Informatica for various transactions and loading data from Flat Files and Relational Database.
• Used different transformations to develop Mappings such as Joiner, Aggregator, Router, Normalizer Expression.
• Designed, Created and used Mapplets for Repeated functionalities.

Environment: Siebel Analytics 7.7, Oracle 9i, Informatica 7.1, Win 2000/XP, UNIX.

ETL Developer

Confidential

• Gathering the business requirements technical specifications and the design of the systems.
• Analyzed complex mappings to extract and transfer source data from different databases.
• Worked extensively on ETL Designing for Fact, Dimensions tables.
• Extracted data from Sales department to flat files and load the data to the target database.
• Designed and developed Informatica mappings for data loads.
• Used different transformations to develop Mappings such as Joiner, Aggregator, Router, Normalizer Expression.
• Tuning Informatica Mappings and Sessions for optimum performance.

Environment: Informatica 5.0, Power Mart, Windows 2000, MS SQL Server 2000.