SUMMARY

• Over 9 years of experience in analysis, design, development, implementation and administration/support of Data Warehousing, Reporting and Client/Server applications using OBIEE 11.x/10.x, Siebel Analytics 8.x/7.x Siebel Analytical Web , Informatica 8.x/7.x/6.x, Oracle 11g/10g/9i/8i.
• Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Intelligent Dashboards, BI Publisher and OBIEE Delivers with Siebel Analytics/OBIEE stand-alone/integrated Applications.
• Proficient in developing OBIEE/Siebel Analytics Repository at the Physical, Business and Presentation Layers Data Modeling , Time Series Objects, Interactive Dashboards with drill-down drill-across capabilities using global and local Filters, OBIEE/Siebel Security setup users/group, access/ query privileges , configuring OBIEE/Analytics Metadata objects Subject Area, Table, Column , Presentation Services/Web Catalog objects Dashboards, Pages, Folders, Reports , Scheduling iBots or Schedulers and OBI Cluster Controller.
• Extensive experience with real time installation and configuration of OBIEE,
• Efficiently developed many Reports and Dashboards with different Pivot Table, Graph, Column Selector, View Selector, Narrative view, Gauges, Tabular with global and local Filters Analytics views using OBIEE/Siebel Analytics Web.
• Experience in implementing security in OBI using Repository Variables, Initialization Blocks, and Session Variables.
• Experience in setting up a Multi-User Development Environment MUDE .
• Developed iBots in OBIEE to automate report delivery, seed cache and provide alerts on Interactive Dashboards.
• Strong database development and business intelligence modeling capabilities Experience in architecting complete data models combining multiple transaction systems ETL tools and relational and multi dimensional data stores for star schema, snowflakes schema designs and reporting tools. Strong Knowledge of relational database design and data modeling using ERWIN-4.0.
• Expert in data warehousing concepts like OLAP, Dimensional Modeling, Data Modeling using Normalization, Dimensional Data Modeling, FACT Dimensions tables, Physical Logical Data Modeling, Aggregate persistence wizard.
• Expertise in ETL methodology in Data Extraction, Transformation and Loading. Experience in Performance Tuning of sources, mappings, targets and sessions.
• Extensive experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets Tasks and scheduling using both Workflow Manager and Unix Shell scripts using pmcmd .
• Integrated Map Viewer and Google Maps in OBIEE Dashboards.
• Strong expertise in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
• Integrated OBIEE with Essbase 9.x, developed RPD and reports against multidimensional databases.
• Excellent problem solving skills with good interpersonal skills, Quick learner and excellent team player.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. OBIEE Lead

Responsibilities:

• Involved in project planning, change management and implementation of various procedures to comply with company standards and direct the developers towards the project milestones.
• Gathered requirements from business users, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Used OBIEE 10.1.3.4/ 11.1.1.5 Administration tool to develop and enhance meta-data.
• Involved in in the upgrade done for Informatica, Apps, OBIEE.
• Worked extensively on OBIEE 11 G for RPD and Webcatlog upgrade and also created new reports.
• Designed and developed the 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, developing multiple Dimensions Drill-Down Hierarchies Logical Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Configured Financial Analytics, SCM Analytics and Procurement and Spend Analytics to work with Oracle EBS by setting up appropriate domain values.
• Worked on to customize Financial Analytics to meet the reporting requirements of the client.
• Worked intensively to implement security for each school called as unit . Implemented unit security by using ORACLE GL Security, a part of Oracle Apps.
• Used data level and Object level security to limit the data and reports to end-users.
• Created Master directory for all dashboards which are using reports from same directory and having security implemented on it.
• Used BI Publisher for reporting direct against the source integrated Publisher reports on BI Dashboard.
• Involved in Migration of RPD Dashboard from one environment to another i.e from dev to UAT and from UAT to Prod .
• Managed Off-shore team for ETL and DAC related jobs.

Environment: OBIEE 11.1.1.5, OBIEE 10.1.3.4.1, Informatica 8.6.1, Informatica 9.0.1, TOAD, SQL Developer, DAC 7.9.6, BI Office Plug-in, Oracle Answers 10.1.3.4, Oracle Answers 11.1.1.5.

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Involved in Gathering, Analyzing Business Requirements for Reports.
• Created/Modified Metadata repository, defined/developed Physical Data Layer, Business Model Aggregates, Dimensions and time Series functions and Presentation Layer using BI Administration Tool.
• Implemented Delivers Schedule Job using Agent for delivery of reports through email, hand-held devices and mobile phones.
• Configured managed Application role Application Policies for Users Users group using Enterprise manager.
• Implemented Object Level and Data Level Security in the Enterprise Manager and Repository Variables, Session Variables and Initialization Blocks.
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Development of interactive flash-based drillable charts such as bar-charts, Gauges etc.
• Worked extensively on OBIEE Skin Branding as per client requirement.
• Create the style sheet .css which was followed in the dashboards.

Environment: OBIEE 11g, OLAP, Informatica, SQL Developer, Windows 2008 Server, TOAD, PL/SQL Procedures.

Confidential

Sr. OBIEE Consultant

Responsibilities:

• using transformations and reusable transformation units Update Strategy, Filter, Router, Expression, Lookup, Aggregator for loading data into Data Warehouse.
• Development of many complex Informatica mappings and mapplets to build key interfaces
• Involvement with ETL Extract-Transform-Load development team to communicate the specification for the required dimensional, aggregate and indexed data tables.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report level Security.
• Implemented Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones.
• Development of interactive flash-based drillable charts such as bar-charts, pie-charts, radars, bubble-charts, etc using the integrated Corda PopChart Server.
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Created/Modified Metadata repository .rpd , Customized BI Repository, defined/developed Physical Data Layer, Business Model and Presentation Layer using BI Administration Tool.
• Responsible for creating Proof of Concept POC with Oracle data sources and Essbase cube.
• Involved in Gathering, Analyzing Business Requirements for Reports.
• Developed/Bench-Marked performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduled them to run at specified time with required frequency. Used Workflow Monitor to monitor the performance of the Jobs.
• Life-cycle support for migration efforts from development to QA to production analytics.
• Implemented different Passive and Active transformations like Source Qualifier, Joiner, Aggregator, Lookup, Rank Expressions, Update Strategy and Stored Procedure Transformations in Mappings.
• Extensively used DAC, to configure, monitor and schedule ETL routines.
• Created the Execution Plans, Subject Areas, Task groups, Tasks to schedule ETL loads in DAC.
• Created Execution plan to run only the required mapping as part of Daily, Monthly and Quarterly ETL runs.

Environment: OBIEE 10.1.3.4.1, Oracle BI Publisher 10.1.3.4.1, Informatica Power Center 8.6.1, Oracle 10g, OBIEE Disconnected Analytics 10.1.3.4.1, Essbase 9.3.1, DAC

Confidential

Sr. OBIEE Developer

Responsibilities:

• Installed and configured complete suite of OBIEE 10.1.3.4 in test and development environment on Linux boxes.
• Changed Out of the box dashboards and provided detail level drill downs to as per business requirements using Oracle Answers.
• Worked extensively on OBIEE Administration tool and Presentation Services.
• Worked on the different layers in the data model Physical, Business and Presentation .
• Involved in gathering and analyzing requirements and documenting them for further implementation.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE answers.
• Created RPD against multidimensional database Essbase cube from the scratch and did data modeling for the Essbase cube.
• Customized Out of the box Repository RPD to work with other ERP systems and Essbase. Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
• Built Time-Series calculations using AGO and TODATE functions on BMM Business mapping and modeling layer of repository.
• Created session variables for users to provide row- level data level security and used the session variable in OBIEE answers to build the query.
• Used presentation variable in OBIEE Oracle answers to save prompt values and use them for conditional formatting.
• Scheduled iBots and seeded server cache using Delivers to improve system performance. Also used iBots to clear server cache using NQCmd utility. Scheduled reports to be e-mailed using iBots.
• Provided an evaluation and Proof of Concept built a Star Schema using Oracle Warehouse Builder 10G R2 for the Oracle Business Intelligence products.
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.
• Developed process for object level migration of web catalog, for post production release of - enhanced and bug fixed reports.
• Worked on Windows platform pre development environment and UNIX platform development/ test environment to do the administrator tasks.
• Compared SAP BW with OOTB Oracle Data warehouse and advocated the use of OOTB data warehouse.
• Used TOAD for Oracle and SQL Navigator to connect to databases in Oracle.
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Environment: OBIEE 10.1.3.3.0, Oracle Answers 10.1.3.3.0, Informatica Power Center 8.1.1, DAC, Essbase v7.1.5/ 9.3.1, HyperionBrio 8.1, Oracle 9i, TOAD, SQL Navigator, Web Logic 8X, Essbase Excel Add-In, Sun Solaris, Windows 2005 server.

Confidential

Sr. Siebel Analytics / OBIEE Consultant

Responsibilities:

• Worked closely with Business Analyst and analyzed the business requirements for new reports and modifications to old reports.
• Configured Oracle Business Intelligence Application BIAPPS prebuilt repositories for Human resouces sector. Including setting up Oracle Business Analytics Warehouse OBAW formerly SRMW, using Database Administration Console DAC .
• Built RPD metadata for analytical reporting on HR Analytics related metrics.
• Created new custom reports based on the ERP Data model Order Management, Accounts Receivable, Inventory .
• Created few operational reports using BI Publisher.
• Developed reports and layouts using various data sets in BI Publishers, Published various templates RTF PDF and e-text in BI Publisher.
• Involved in Administering the Physical Layer, Business Model Mapping Layer and Presentation Layer in Analytics repository.
• Worked Extensively in Business Model and Mapping Layer to create Dimensional hierarchies, level based measures. Identify Fact tables Measures. Identify Aggregate tables their definitions.
• Used the Security settings in OBIEE Admin Tool to set up users, groups, access privileges and logging levels.
• Worked in OBIEE Answers to create Requests, designed various report views like Table, Charts, Pivot, Created Column Filters and Prompts to filter the request and worked with column formatting functions.
• Worked with IT staff to build 8 Star Schema's and 22 Dimensions using Oracle Warehouse Builder 10g Rel. 2 for the implementation of client data warehouses. Implemented the Star Schemas in both ROLAP with MOLAP capabilities, produced reports using Discoverer Plus which demonstrated the capabilities related to reporting.
• Created dashboards using analytics requests and assign Permissions to those dashboards to users depends on their user group.
• Created and granted privileges for the users using OBIEE Admin/ Presentation Catalog.
• Configured published iBots to deliver analytics content based on schedule, automated iBots queries to obtain daily weekly transactions to all the departments in the organization by Emails.
• Maintained extensive documentation for design, implementation and testing OBIEE Analytics requests, Dashboards.

Environment: OBIEE 10.1.3.2, Siebel Analytics 7.8/7.7.1, Informatica 8.1, Oracle 9i/10g, TOAD, PL/SQL, Windows 2000.

Confidential

Siebel Analytics Consultant

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Created/Modified Metadata repository .rpd and Configured Metadata Objects using Siebel Analytics Server Admin tool.
• Developed many Dashboards / Reports with different Analytics Views Drill-Down, Pivot, Chart, View Selector, and Tabular with global local Filters using Siebel Analytics Web.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Configured Intelligence dashboards by adding content such as links/images, HTML objects and folders.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers.
• Diagnosed Performance problems with Siebel Analytics and recommended solutions to improve reports run time. Performed Tests for the Data integrity and Consistency.
• Performance Tuning of Informatica Mappings data warehouse loads, including Informatica Server Manager and PL/SQL procedures.

Environment: Siebel Analytics 7.7/ 7.8.1, Informatica 6.2, Oracle 9i, IBM AIX

Confidential

Sr. Software Developer

Responsibilities:

• Installed and configured Informatica PowerCenter server and clients. Establish the ODBC and Native driver connections.
• Loaded data to the Interface tables from multiple data sources such as MS Access, SQL Server, DB2, Text files and Excel Spreadsheets using, SQL Loader, Informatica.
• Analyzed data flow requirements and developed a scaleable architecture for staging and loading data and Translated business rules and functionality requirements into ETL procedures.
• Expertise in Source definitions, Warehouse designing and modeling, Transformations, Mappings and Mapplets.
• Created and scheduled Sessions and Batch Processes based on demand, run on time, run only once using Informatica Server Manager.
• Worked with various active and passive transformations within Informatica Like expression, lookup, filter, rank, aggregate, update strategy, joiner etc
• Major involvement in issues such as database space management, Application tuning Import and Export of database at regular intervals, to optimize I/O, SQL Tuning, Performance Monitoring, and using Data Import utility to transfer data from one database to another.
• Tuning of Applications using Explain Plan and SQL Trace.
• Developed test procedures to compare the aggregates of source and target databases.
• Involved in loading data from target to Essbase.
• Prepared, analyzed, and created all dimensions in Essbase outline and developed numerous complex Essbase applications with excellent balance of dense and sparse dimensions.
• Performed member loads and data loads successfully by using RUL file for various Cubes created.
• Maintained and developed Calculation Scripts and optimized it according to Essbase outline. Developed data load rules and reports.
• Provided technical guidance concerning business implications of reporting applications and running ADHOC queries that could be used in executive level presentations.

Environment: Informatica PowerCenter 5.1.1/PowerMart 5.1.1 , Oracle 8i, SQL Server 6.5, Erwin 3.5.2, Perl, Essbase 6.0, SQL Server 7.0, Hyperion Reports, PL/SQL, Business Objects 5.0, SunOS 5.5.1, UNIX Shell Scripting, SQL Loader, SQL Plus

Confidential

Software Developer

Responsibilities:

• Involved in design, development and maintenance of Insurance policies and claims transactions Data Mart using Informatica PowerCenter.
• Extensively used ETL and Informatica to load data from MS SQL Server, SAP R/3, Teradata, Excel spreadsheet, flat files and XML files into the target Oracle 9i database.
• Implemented various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Involved in development of Informatica mappings and also in tuning of mappings for better performance.
• Developed PL/SQL procedures/packages to kickoff the SQL Loader control files/procedures to load the data into Oracle 9i.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Used PMCMD commands in non-windows environments.
• Optimized/Tuned mappings for better performance and efficiency.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created UNIX shell scripting and automation of ETL processes using Crontab.
• Involved in ETL process under development, test and production environments.
• Created various Reports using COGNOS Impromptu and PowerPlay.

Environment: Informatica PowerCenter 5.2, MS Visio 2002, Oracle 9i, MS SQL Server 7, 2000 , IBM Mainframes/DB2, SAP R/3, Teradata, MS Excel 97, PL/SQL, SQL Plus, SQL Loader, Toad 7.0, Transact-SQL, Windows 2000, Sun Solaris 5.8, UNIX ksh Shell and COGNOS Impromptu, PowerPlay 7.1