Professional Summary:

• Over 8 years of IT experience which includes analysis, design, development, implementation, deployment and maintenance of Business Intelligence, Data Warehouses and Data Mining applications.
• 6 years of 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.
• Having 2 years of experience in ETL methodology using Informatica Power Center/Mart.
• 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 .
• Experience in working with new web console and Enterprise Manager of OBIEE 11g.
• 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.
• Experience in implementing new features in OBIEE 11g such as Sliding Bars, Moving Columns dynamically on the dashboard.
• 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 data base.
• 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.0,11.1.1.5/10.1.3.x, BI App version - 7.9.6.3, Siebel
• Analytics 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
• Navigator, JDeveloper, 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. OBIEE Developer

Confidential is a leading global engineered materials company, focused primarily on the production of nonwovens for the hygiene, wipes medical, and industrial markets. PGI's extensive experience makes it a total-systems supplier for many of its clients, which include multi-national and regional consumer and industrial product manufacturers. With one of the largest global platforms in the industry, PGI operates manufacturing and converting facilities throughout nine countries.

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.
• 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.
• 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.
• 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

OBIEE / Oracle BI Developer

The main goal of Confidential is to provide a consolidated view of global data across HR processes through a web-based reporting portal that will support the secure, integrated delivery of standard reports, dashboards, analytics and ad-hoc reports to approved individual recipients and user groups.

Responsibilities:

• Involved in performance tuning by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.
• Created pivot table requests allowing managers to analyze the business in different perspectives.
• Created Application Roles in Oracle Enterprise Manager 11g and set the permissions on dashboard pages using the application roles.
• Utilized HP Quality Center tool for tracking issues which are raised by users post OBIEE 11g upgrade process and fixed them priority wise.
• 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 .
• Configured Intelligence dashboards by including embedded content such as links/images HTML objects.
• Used Filters global and local and provided customized Prompts to avoid excessive data showing up in the reports.
• 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.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Created Hierarchies, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Imported Dimensions and Facts into OBIEE Repository and built Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.
• Worked with data architects to translate business requirements into technical specifications and logical physical data models.
• Involved in Requirement gathering from business users and translated them into technical specifications.
• 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 11.1.1.6/10.1.3.4.1, Linux, UNIX, Oracle 11g/10g, SQL, PL/SQL and TOAD.

Confidential

Sr. Oracle 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.

Prince George County Public Schools-Upper Marlboro, MD Apr 11 Aug 11

Sr. OBIEE Consultant

Confidential's County Public Schools is the 2nd largest school system in the state of Confidential and the 18th largest in the nation. With a projected enrollment of more than 134,000 students, the system is among the largest and most diverse in the nation. The purpose of this project is to build reports which help the school to analyze cohort graduation and dropout rates.

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics requirements and created Business Models for generating Reports as per the requirements.

• 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 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.
• Build 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 folder 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

Confidential is the only fully integrated biopharmaceutical services company offering clinical, commercial, consulting and capital solutions worldwide. Its network of 23,000 engaged professionals in 60 countries around the globe works with an unwavering commitment to patients, safety and ethics ensuring a higher level of healthcare for people. For its biopharmaceutical customers, they help them navigate risk and seize opportunities in an environment where change is constant. The objective of this project was to provide information technology solutions through its range of solution.

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 and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository .rpd using Oracle BI Administration Tool.
• 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.

Confidential

OBIEE Developer

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.
• To create Connection pools, import physical tables and define joins in the Physical Layer.
• Developed and customized some of the existing Dimensions Drill-Down Hierarchies Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in BI Answers.
• Developed Dashboards for each of metrics by embedding reports and providing intuitive drill-downs and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Used OBIEE Delivers to automate iBot queries, obtain weekly reports and to send alerts to related managers and secured team members.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Involved in developing the Incremental ETL process Mappings Mapplets using various Transformation and Workflows with Sessions/Tasks, executed workflows through shell scripts using pmcmd.
• Created saved several BI Publisher reports by selecting an Answers request as Data Source.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules Reports, Dashboards, Security and Star schema.
• Build 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.2, Informatica Power Center 7.8.4, Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/LINUX Oracle10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential

Siebel Analytics/Oracle BI Consultant

Confidential Inc. is a diversified financial services company providing a wide range of commercial, consumer, mortgage banking, trust and financial planning services to a broad client base. Citizens serve communities in Michigan, Ohio, Wisconsin, and Indiana with 218 offices and 255 ATMs. Citizens bank is the largest bank holding company headquartered in Michigan with roots dating back to 1871 and is the 46th largest bank holding company headquartered in the United States.

Responsibilities:

• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Developed many Reports/Dashboards with different Analytics Views Drill-Down Drill-Across, Pivot Table, Chart, View Selector, and Column Selector, with global local Filters using Oracle BI/Siebel Analytics Web.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and user Security.
• Developed Accounting and Collection Time Series Object Oracle BI Time-Series Functions for comparing the Billings, Collections and Adjustments.
• Created Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
• Tuned Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed many complex Informatica mappings and mapplets to build key interfaces using reusable transformations Source Qualifier, Lookup, etc. for loading data into Data Warehouse.
• Peer review of code, testing, monitoring NQSQuery and tuning reports.
• Involved in building and migrating the metadata across DEV/ST environments.
• Used Informatica Power Center to develop ETL mappings, transformations, and to load data.
• Enforced Row Level Security for Managers to View the Reports pertaining to their Region.
• Used Informatica transformations like Normalizer, Expression, Filter, Aggregator, Update Strategy, Lookup, Joiner, etc. extensively to create complex mappings and mapplets.
• Performed Tuning of Dashboards/Reports by aggregate navigation, and cache management.
• Involved in preparing/executing Test scripts, establishing Test Data, and recording defects.

Environment: Siebel Analytics 7.8.2/ Oracle Business Intelligence 7.8.4, Informatica Power Center 7.7.1, Data Warehouse Administration Console DAC , XML Publisher, Delivers, Windows XP, UNIX/Linux, Shell Scripting, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential

Siebel Analytics Consultant

Responsibilities:

• Designed and Developed the Analytics repository Physical Layer, Business Model and Mapping Layer and Presentation Layer .
• Developed many Reports / Dashboards with different Analytics Views Pivot Table, Chart, Tabular, etc. for performing the Marketing Trend analysis using Siebel Analytics Web.
• Developed Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions based on the Requirements.
• Designed Added Customized Mappings to schedule the loads to run on weekly basis.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business.
• Developed complex mappings by extensively using the Informatica transformations and flagging the records using the update strategy for populating the desired SCD tables.
• Used Workflow manager and Workflow monitor for Workflow, sessions and database connection management and workflow monitoring.
• Created Delivers and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler Delivers.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, and Cache Management.
• Created saved several XML Publisher reports by selecting an Answers request as Data Source.
• Managed Security privileges for each subject area dashboards according to user requirements.
• Performed Pre/Post implementation testing of Dashboard, Answers and validating Repository.

Environment: Siebel Analytics 7.1.3, XML Publisher, Delivers, Windows XP, UNIX/LINUX, Oracle10g, SQL, PL/SQL.