Synopsis:

• 8 years of IT experience which includes analysis, design, development, implementation, deployment and maintenance of Business Intelligence, Data Warehouses and Data Mining applications.
• Experience on Siebel Analytics 7.7.1,7.8.5/OBIEE 10.1.x, 11.1.1.5, 11.1.1.6, BI App version - 7.9.6.3 in designing Dashboards Oracle/Siebel , Answers Oracle/Siebel , and Analytics/Oracle Administration Tool i.e. Analytics rpd.
• Proficient in Installing and configuring Siebel Analytics/OBIEE, Oracle BI Apps DAC and Informatica.
• Expertise in providing end-to-end business intelligence solution by configuring metadata building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Inter-active Business Intelligence Dashboards using Siebel Analytics/ Oracle Business Intelligence OBIEE .
• Experience in Upgrading Rpd, Web Catalogs from OBIEE 10g to OBIEE 11g using upgrade assistant utility Oracle Fusion Middleware Upgrade Wizard .
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse.
• Experience in converting and using Oracle pre-build rpd's Financial, Supply Chain and Order Management, Marketing Analytics, etc. according to business requirements.
• Expertise in fine tuning reports by using view selector, column selector, drill down- drill through analysis, creating master/detail reports, using database, numeric, date and time functions, etc., where ever necessary to increase performance.
• Developed and maintained complex reports like crosstab, drill through, drill down, master detail relationship, conditional formatting, Graphs/Charts, calculated columns, prompt pages etc.
• Experience in Dimensional Data Modeling using Star Schema, Snow-Flake Schema, Fact and Dimensional Tables.
• Experience in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows, various Tasks and scheduling them using Informatica Power Centre Designer and Workflow Manager .
• Expert in Performance tuning of Oracle BI / Siebel Analytics Repository, Analytics Dashboards/Reports, Informatica Mappings/Mapplets and Oracle programs.
• Strong working experience in using OBI/Siebel Delivers which includes configuring Delivery Devices, creating and configuring iBots, and building Alerts.
• Expertise in Merging repositories and Implementing MUD Multi User Development Environment.
• Experience on assigning Data security UI level security to the users using OBIEE repository objects external database.
• Worked extensively in developing Informatica mappings and mapplets to build key interfaces using transformations Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator for loading the data into data warehouse.

Technical Competencies:

• BI Tools/Analytics: OBIEE 11.1.1.6,11.1.1.5/10.1.3.x, BI App version - 7.9.6.3, SiebelAnalytics 8.x, 7.x Administration, Interactive Dashboards, Disconnected Analytics, Briefing Books, BI Delivers, Web Catalog Administrator, Analytics Server Administration .
• Database: Oracle R12.1.3, 11g /10g/9i/8i/7.x, SQL Server 2005/2000, MS
• Access.
• ETL Tools: Informatica Power Center server v9.0.1 Hot Fix 2,8.6/8.1/7.x/6.x
• Power Mart 6.2/5.1, Oracle Data Integrator ODI .
• Data Modeling Tools: Erwin, Star Schema, Snowflake Schema, Tables, Physical
• and Logical.
• Languages: SQL, PL/SQL, C, Java 1.3/1.4/1.5/1.6, HTML, XML.
• Oracle Tools/Utilities: SQL Loader, Oracle Designer, SQL Developer, TOAD,
• SQL Developer, Oracle Developer 2000.
• Scripting Languages: JavaScript, VBScript and UNIX shell script.
• Operating System: Windows Vista, Win 95/98/2000/XP/7, Win NT 4.0, Linux,
• UNIX.
• Scheduling Tools: DAC 10.1.3.4.1 Data warehouse Administration Console .

Professional Experience:

Confidential

Sr. BI Developer

Responsibilities:

• Involved in performance tuning by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.
• Implemented object level security by creating Application Roles in Oracle Enterprise Manager 11g and by setting the permissions on dashboard pages using the application roles.
• Configured Intelligence dashboards by including embedded content such as links/images HTML objects.
• Leveraged existing and new reports/Dashboards with new features of OBIEE 11.1.1.7 'Replace Analysis in ', 'Return to ', 'Freeze Column', 'Hide Sliders', 'Zoom to data range' etc. .
• Developed many Reports/Dashboards with different Analytics Views Drill-Down Drill-Across, Pivot Table, Gauge, Waterfall Graph, Stacked Graph, 100 Stacked Graph, View Selector, and Column Selector using Oracle BI Web.
• Upgraded rpd and Web Catalogs Answers, Dashboards from OBIEE 11.1.1.5 to OBIEE 11.1.1.7.
• Created Parent-child hierarchies, Aggregations and Time Series functions using admin tool in the Business Model and Mapping Layer.
• Used Fragmentation to pull the fact data distributed across different tables in a single data source.
• Worked with data architects to translate business requirements into technical specifications and logical physical data models.
• Gathered requirements of the various work streams by meeting with the business user and base lining the details.
• Provided end-user training to power users to develop dashboards, reporting metrics and reports and provided documentation to BI Group.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.1.5/11.1.1.7, Oracle 11g, Windows XP, Toad.

Confidential

Sr. BI Developer

Responsibilities:

• Involved in gathering and analyzing the Business Requirements in collaboration with the Oracle Finance SMEs, Business Analysts, and users.
• Worked with data architects to translate business requirements into technical specifications and logical physical data models.
• Upgraded rpd, Web Catalog Answers, Dashboards and BI Publisher from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.6 using upgrade assistant utility Oracle Fusion Middleware Upgrade Wizard .
• Created, Supported and discussed with Oracle Support on the open SR's, Patch and bug fixes.
• Imported Dimensions and Facts into OBIEE Repository and built Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.
• Configured the RPD by creating level-based and time series measures, dimensions and their hierarchies, aggregates and variables that provided business analysts the ability to easily slice and dice data in Answers.
• Developed Reports/Dashboards with different Analytics Views Drill-Down Drill-Across, Pivot Table, Gauge, Graph, Chart, View Selector, and Column Selector, with global local Filters using Oracle BI Web.
• Created Daily Balance Reconcilement, Deferred Revenue, Client Revenue, Revenue Comparisons and accrual reports.
• Used Informatica Power Center 8.6.1 to load the Oracle 11.5.9 data into OBAW using Source dependent adapters SDE ORA and Source Independent adapters SILOS and custom Folders.
• Involved in developing Initial and Incremental ETL process i.e., Mappings Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Worked on OBIEE Security settings in Administration Tool / Web logic Console to set up users, groups, access privileges and query privileges and also managed security for groups in Answers.
• Implemented object level security by creating Application Roles in Oracle Enterprise Manager 11g and by setting the permissions on dashboard pages using the application roles.
• Tuned OBIEE Reports and Worked with materialized views and aggregates for Performance Gains.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from development environment to QA environment and then to the Production environment.
• Assist stakeholders in developing a user acceptance test strategy, coordinate the execution of user acceptance testing and facilitate problem resolution for issues identified.
• Provided end-user training and documentation and second-line support to power users to develop dashboards, reporting metrics and reports.
• Utilized HP QC and JIRA for Requirement gathering and tracking issues.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.1.6./10.1.3.4.1, Linux, UNIX, Oracle 11g/10g, Windows 7, Apex 4.0.2, SQL, PL/SQL and TOAD.

Confidential

Sr. BI Developer

Responsibilities:

• Worked with business users to understand business requirements and translate to appropriate technical solutions.
• Used the Administration Tool to configure the physical, logical and presentation layers of the RPD.
• Created pervasive and interactive dashboards with scorecards, year over year analysis, distribution void and business trending reports using bins, guided navigation links, conditional formatting and variety of views. This allowed the sales team to spend more time selling than creating reports and managers reconciling reports.
• Analyzed and validated the business model in Oracle BI Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Performed Presentation Services Administration tasks like managing privileges, managing groups and users, and managing interactive dashboards and sessions.
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively.
• Responsible for migrating the web catalog and RPD from DEV, UAT and Training, Production environments.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Deployed analyticsRes Folder by using Web logic Console and implemented Query Blocking and Custom Links.
• Developed many Ad-hoc and standard 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 using delivers to seed server cache and send requests to dashboards as Alerts.
• Involved in user trainings on the generated reports for this project.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4.1, Linux, UNIX, Oracle 11g/10g, Windows 7, Apex 4.0.2, SQL, PL/SQL and TOAD.

Confidential

Oracle BI Developer

Responsibilities:

• Actively involved as a part of a team for gathering and analyzing the needs of End user requirement and accounting specification.
• Created and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository .rpd using Oracle BI Administration Tool.
• Created Hierarchies, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Developed many Reports/Dashboards with different Analytics Views Drill-Down Drill-Across, Pivot Table, Gauge, Graph, Chart, View Selector, and Column Selector, with global local Filters using Oracle BI Web.
• Used Filters global and local and provided customized Prompts to avoid excessive data showing up in the reports.
• Configured Intelligence dashboards by including embedded content such as links/images HTML objects.
• Upgraded Rpd, Web Catalogs from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.6 using upgrade assistant utility Oracle Fusion Middleware Upgrade Wizard .
• Deployed analyticsRes Folder by using Web logic Console and implemented Query Blocking and Custom Links.
• Utilized HP Quality Center tool for tracking issues which are raised by users post OBIEE 11g upgrade process and fixed them priority wise.
• Created Application Roles in Oracle Enterprise Manager 11g and set the permissions on dashboard pages using the application roles.
• Created pivot table requests allowing managers to analyze the business in different perspectives.
• Deployed OBIEE 11g RPD and Web Catalog by using Web logic Enterprise Manager.
• Involved in performance tuning by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.1.6/10.1.3.4.1, Linux, UNIX, Oracle 11g/10g, SQL, PL/SQL and TOAD.

Confidential

Sr. BI Consultant

Responsibilities:

• Gathered user requirements to build reports.
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance.
• Developed Analytics Metadata Repository .rpd using OBIEE by importing the required objects with integrity constraints into Physical Layer using connection pool, developed multiple Dimensions Drill-Down Hierarchies , Logical objects in Business Model Layer, and created the Presentation catalogs in Presentation Layer.
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Adhoc report according to the client needs.
• Developed many Reports with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using OBIEE.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Merged the changes to the original repository using the merge repository and import from repository features.
• Extensively used presentation variables to develop reports with complex logics.
• Designed and developed transformations, mappings and sessions in Informatica to load target database.
• Developed Custom SDE and SIL mappings to populate the data using different types of transformations.
• Developed Custom SDE and SIL mappings for Helper tables using the lookup transformation.
• Developed custom mappings to identify duplicate records for source data coming from flat files.
• Customized the Financial informatica mappings.
• Developed custom ETL mapping to control check on the GL code combinations and failing the execution plan for the data does not match.
• Configured DAC Data warehouse Access control for running of ETL jobs
• Configured DAC on SOLARIS machine.
• Used DAC to schedule and run the Full and Incremental ETL loads and to schedule the Informatica jobs.
• Created catalog groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Implemented comprehensive security functionality by creating users web groups.
• Enhanced performance by requesting Aggregate tables, Indexes and managing Cache after Benchmarking performance tuning strategies with business model-level calculations versus database level pre-computations and aggregations.
• Worked on performance tuning for the data load through DAC.
• Maintenance and support the OBIEE/Informatica/DAC for the production environment.
• Developed the mapping document to build the data ware house to match the user requirement.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.1.5.0, BI App version - 7.9.6.3, BI Publisher 11g,Informatica Power Center server v9.0.1 Hot Fix 2, DAC 10.1.3.4.1 Data warehouse Administration Console , Windows 7, Linux, UNIX, Shell Scripting, Oracle R12.1.3,11g/10g, SQL, PL/SQL, and TOAD.

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Worked on Oracle BI EE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• Worked closely with Business Analysts in understanding the Analytics requirements and created Business Models for generating Reports as per the requirements.
• Worked extensively on OBIEE Answers and Dashboards to build the reports as per the client requirements.
• Experience in Oracle Data Integration Suite Oracle Data Integrator ODI to Extract Load and Transform E-L-T for high performance and faster responsiveness.
• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
• Performed the detailed design of Reports / Dashboards and performed Gap Analysis between existing reports and new requirements.
• Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up reports.
• Used view selector, column selector, is prompted, drill down- drill through analysis, creating master/detail reports, using database, numeric, date and time functions, etc., where ever necessary to increase performance.
• Created Session Repository Variables to achieve desired functionality.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Built test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4, BI Publisher, Windows XP, UNIX, Shell Scripting, Oracle 11g/10g, SQL, PL/SQL, and TOAD.

Confidential

Sr. Report Developer

Responsibilities:

• Gathered requirements of the various work streams by meeting with the business user and base lining the details.
• Worked with data architects to translate business requirements into technical specifications and logical physical data models.
• Created Repositories by building Physical Layer, Business Model and Mapping Layer, and Presentation Layer using OBIEE Admin Tool.
• Created Dimensional Hierarchies, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Used Filters global and local and provided customized Prompts to avoid excessive data showing up in the reports.
• Created pivot table requests allowing managers to analyze the business in different perspectives.
• Implemented security by creating users groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler iBots.
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents iBots to subscribed users.
• Involved in performance tuning by enabling the cache to improve the query performance.
• Involved in preparing/executing Test scripts, establishing Test Data, and recording defects.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from development environment to QA environment and then to the Production environment.
• Performed a POC on OBIEE 11g including installation on a sandbox
• Deployed folders which holds metadata using web logic console and generated Metadata Dictionary to the deployed folder.
• Created user and groups using web logic Administration Console.
• Created Roles and policies using web logic Enterprise Manager.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4/11.1.1.3, Oracle Delivers, BI Publisher, Windows XP, UNIX/LINUX, Shell Scripting, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential

Sr. OBIEE Consultant

Responsibilities:

• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Created Dimensional Hierarchies, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Modified presentation layer dimensions and attributes to match user requirements.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Configured Intelligence dashboards by including embedded content such as links/images HTML objects.
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents iBots to subscribed users.
• Used the Security settings in Oracle BI Admin Tool to set up SSO, users, groups, access privileges and query privileges.
• Configured Informatica connections source DB connection and target DB connection in DAC.
• Used DAC to schedule and run the full incremental ETL loads and to schedule the informatica jobs in Oracle Business Analytic Warehouse.
• Developed Informatica mappings and mapplets to build key interfaces using transformations Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator for loading the data from Oracle EBS source into data warehouse.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Built custom analyze scripts for DAC to reduce the time for table analysis.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from development environment to QA environment and then to the Production environment.
• Provided end-user training and documentation and second-line support to power users to develop dashboards, reporting metrics and reports.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4, Informatica Power Center 8.1, Data Warehouse Administration Console DAC , Oracle Delivers, BI Publisher, Windows XP, UNIX/LINUX, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.