Professional Summary:

• Over 7 years of IT experience in analysis, design, development, implementation and testing of various client/server and data warehousing technologies.
• Over 6 years of experience on OBIEE 10.1.3.x/11.1.1.5/11.1.1.6/11.1.1.7 in designing dashboards, answers and administration tool.
• Expertise in design and development of the three layers Physical/Business Model and Mapping/ Presentation of an OBIEE Metadata Repository .rpd using Oracle BI Administration Tool.
• Experienced in designing customized interactive dashboards in OBIEE using drill down, prompts, filters, and variables.
• Expert in using OBIEE Answers to create queries, format views, charts, add user interactivity and dynamic content to enhance the user experience.
• Experienced in working with Variable Manager to define session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically.
• Knowledge in Informatica data warehousing ETL experience using Informatica PowerCenter 9.0.1/8.6/8.1 source analyzer, mapping designer, mapplet designer, transformation designer, warehouse designer, repository manager and server manager .
• Knowledge in using the transformation components like source qualifier, expression, aggregator, filter, router, sorter, update strategy, lookup, joiner and sequence generator.
• Experience in Oracle 11g/10g/9i - design and developing stored procedures/packages using SQL, PL/SQL.
• Experience in database design, relational integrity constraints, normalization, denormalization of database.
• Experience in performance tuning of database.
• Excellent communication, leadership, organizational, analytical and problem solving skills.

Skillset:

Oracle 9i, 10g, 11g, MS Access, C,C , SQL, PL-SQL, Informatica Power center 9.01/8.6/8.1 , Oracle OLAP, OBIEE 11.1.1.7.x/11.1.1.6/11.1.1.5/10.1.3.x, SQL Loader, TOAD, SQL developer, Unix Shell Scripting, JavaScript, HTML, XML, Windows 98/2000/XP/Vista, Unix, Linux

Projects Summary:

Confidential

Sr.Oracle Business Intelligence Consultant

Hardware/Software:

Oracle 11g, OBIEE 11.1.1.5/11.1.1.7, CDA Clinical Development Analytics , BI Publisher, Informatica 9.0.1, SQL, Toad, UNIX.

Responsibilities:

• Developed Metadata repository .rpd that consists of Physical, BMM and Presentation layer using Oracle BI administration tool.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Created Alias tables and Dimensional Hierarchies.
• Worked extensively on Answers, Delivers, and Interactive Dashboards.
• Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and inline Filters.
• Developed reports using Map Viewer.
• Configured IBOT's/Agents for delivering alerts.
• Performed Customization of dashboards
• Created Users and Groups in the Embedded Web logic LDAP Server by using Oracle Web logic Server Administration Console.
• Implemented WriteBack feature to enter the comments in to the database.
• Implemented Custom Links to allow users to access the external content they required.
• Used Action Links to allow the user to navigate from one dashboard to other dashboard and pass the parameters between the dashboards.
• Configured Usage Tracking to monitor the frequency of usage and performance of the reports.
• Developed templates and reports in Oracle BI Publisher in rtf format.
• Performed unit testing of the reports

Confidential

Sr.Oracle Business Intelligence Consultant

Hardware/Software:

Oracle 11g, OBIEE 11.1.1.6/11.1.1.7, SQL, PL/SQL, Toad.

Responsibilities:

• Developed Metadata repository .rpd that consists of Physical, BMM and Presentation layer using Oracle BI administration tool.
• Extensively used Repository Variables, Session Variables and Initialization blocks.
• Implemented OBIEE reports in IPAD using Oracle App so that managers can use these reports remotely.
• Worked extensively on Answers and Interactive Dashboards.
• Extensively used time series functions AGO, TODATE and Period Rolling.
• Developed 4 Dashboards / 15 Reports using different Views Table, Pivot Table, Trellis Graph, Bar Graphs, Line Graphs, View Selector and Column Selector
• Created Users and Groups in the Embedded Web logic LDAP Server by using Oracle Web logic Server Administration Console.
• Implemented Master-Detail Event to trigger events on a view based on user's selection in the master report.
• Performed unit testing of the reports

Confidential

Sr.Oracle Business Intelligence Consultant

Hardware/Software:

Oracle 11g, OBIEE 11.1.1.5 CDA Clinical Development Analytics , BI Publisher, Informatica 9.0.1, SQL, Toad, UNIX.

Responsibilities:

• Developed Metadata repository .rpd that consists of Physical, BMM and Presentation layer using Oracle BI administration tool.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Worked extensively on Answers, Delivers, and Interactive Dashboards.
• Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and inline Filters.
• Configured IBOT's/Agents for delivering alerts.
• Performed Customization of dashboards
• Created Users and Groups in the Embedded Web logic LDAP Server by using Oracle Web logic Server Administration Console.
• Implemented WriteBack feature to enter the comments in to the database.
• Developed templates and reports in Oracle BI Publisher in rtf format.
• Performed unit testing of the reports
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers

Confidential

Sr.Oracle Business Intelligence Consultant

Hardware/Software:

Oracle 11g, OBIEE 10.1.3.4, BI Publisher, DataStage 7.8.6, ANSI SQL, Toad, Javascript.

Responsibilities:

• Responsible for full life cycle implementation of OBIEE
• Participated in user meetings to understand the requirements
• Developed Metadata repository .rpd that consists of Physical, BMM and Presentation layer using Oracle BI administration tool.
• Created Alias Tables, Views in the RPD.
• Implemented security based on LDAP Authentication.
• Implemented data level security based on External Table Authorization.
• Implemented security by creating roles and web groups, and defined Object Level and Data Level Security.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Worked extensively on Answers, Delivers, and Interactive Dashboards.
• Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.
• Performed Customization of dashboards
• Developed 8 Dashboards / 25 Reports using different Views Table, Pivot Table, Chart and Column Selector , with GOURL navigation and dashboard and page prompts.
• Created users, groups, configured the permissions in the administration tool and verified the Permissions of the users in web catalog
• Integrated BI Publisher with OBIEE to build reports in word, excel format.
• Developed templates and reports in Oracle BI Publisher in rtf format.
• Performed unit testing of the reports
• Involved in UAT.

Confidential

Oracle Business Intelligence Consultant

Hardware/Software:

Oracle 10g, OBIEE 10.1.3.4, Informatica 8.6.1, SQL, Toad, Cygwin, UNIX Shell Scripting.

Responsibilities:

• Participated in user meetings to understand the requirements.
• Written Shell script to change the format of a column in all the reports of a particular subject area in the web catalog.
• Written shell script for Regression test.
• Performed Regression test.
• Extensively used time series functions AGO and TODATE
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Implemented LDAP security.
• Worked extensively on Answers, Delivers, and Interactive Dashboards.
• Configured web catalog objects.
• Created dashboard prompts and column prompts to filter the selection criteria.
• Developed 2 Dashboards / 8 reports using different views pivot table, charts, graphs, table, view selector, column selector .
• Configured permissions to restrict the access of users to the dashboards.
• Performed unit testing of reports.
• Involved in migration of RPD and Catalog between environments through FTP.

Confidential

Oracle Business Intelligence Consultant

Hardware/Software:

Oracle 10g, SAP, OBIEE 10.1.3.3, BI Publisher, ANSI SQL, PL/SQL, Toad, UNIX.

Responsibilities:

• Participated in user meetings to understand the requirements.
• Created tables and views in the database.
• Data loading using Toad.
• Developed Metadata repository .rpd that consists of Physical, BMM and Presentation layer using Oracle BI administration tool.
• Developed Calculated Measures and assigned these Aggregation levels based on Dimension Hierarchies.
• Extensively used time series functions AGO and TODATE
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Implemented LDAP security.
• Worked extensively on Answers, Dashboards and Delivers.
• Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.
• Configured web catalog objects.
• Created dashboard prompts and column prompts to filter the selection criteria.
• Developed 3 Dashboards / 13 reports using different views pivot table, charts, graphs, table, view selector, column selector .
• Configured permissions to restrict the access of users to the dashboards.
• Performed unit testing of reports.

Confidential

Oracle Business Intelligence Consultant

Hardware/Software:

Oracle 11g, SAP BW, OBIEE 10.1.3.4, Oracle BI Apps Supply chain Analytics , BI Publisher, ODI 10.1.3.5, SQL Developer, ANSI SQL, UNIX.

Responsibilities:

• Responsible for full life cycle implementation of OBIEE
• Participated in user meetings to understand the requirements
• Developed Metadata repository .rpd that consists of Physical, BMM and Presentation layer using Oracle BI administration tool.
• Created Alias Tables, Views and Dimensional Hierarchies.
• Developed Calculated Measures and assigned these Aggregation levels based on Dimension Hierarchies.
• Implemented external table security with session variables, tested and validated the business model and repository level calculations using Oracle BI Administration tool.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Worked extensively on Answers, Delivers, and Interactive Dashboards for Procurement and Spend Analytics.
• Developed standard and custom SAP BW reports in OBIEE
• Performed Customization of dashboards
• Developed 11 Dashboards / 53 Reports using different Views Table, Pivot Table, Chart and Column Selector , with guided navigation and dashboard and page prompts.
• Created users, groups, configured the permissions in the administration tool and verified the Permissions of the users in web catalog
• Developed and modified reports in BI Publisher
• Performed unit testing of the reports
• Involved in UAT.
• Involved in migration of RPD and Catalog between environments through FTP.

Confidential

Oracle Business Intelligence Consultant

Hardware/Software:

Oracle 10g, Informatica 8.1.1, OBIEE 10.1.3.2, BI Publisher, Toad, SQL, SQL Loader, PL/SQL Procedures, Windows 2000, UNIX, Shell Scripts.

Responsibilities:

• Participated in User Meetings to understand the requirements.
• Built the OBIEE repository/metadata Physical Layer, Business Model and Mapping Layer and Presentation Layer and created the subject area where reporting and analysis are centered around.
• Developed calculated measures and dimension hierarchies in the Business Model and Mapping Layer
• Configured web catalog objects Dashboards, Pages, Folders, Reports
• Implemented data level and object level security.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities based on organization's and product's hierarchies
• Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Generated Dashboards to provide insight into Sales Analytics, Activity Analytics.
• Created users, groups, configured the permissions in the administration tool and verified the Permissions of the users in web catalog.
• Assisted in creation of pivot table requests allowing manager's to analyze the business/data from different perspectives.
• Performed unit testing of Dashboard, Answers and validating Repository.
• Developed and modified reports in BI Publisher.
• Developed user guides for the end users. User guide contained some screenshots of high level reports and also provides instructions in accessing them.