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 Siebel Analytics 7.8.5/OBIEE 10.1.3.x/ 11.1.1.5/11.1.1.6. in designing dashboards (Oracle/Siebel), answers (Oracle/Siebel), and analytics/oracle administration tool.
• Extensive experience in the Siebel Analytics RPD metadata. customized siebel analytics repository, defined physical data layer, developed business model and presentation Layer using siebel analytics administration tool
• Excellent in developing business intelligent solutions using data warehouse and OLAP techniques.
• Strong data modeling experience using dimensional data modeling star schema/snow flake schema, fact and dimension tables, physical and logical data modeling.
• Experience in Informatica (data warehousing ETL experience using Informatica PowerCenter 8.6/8.1/7.1, source analyzer, mapping designer, mapplet designer, transformation designer, warehouse designer, repository manager and server manager).
• Experience in using all the transformation components like source qualifier, expression, aggregator, filter, router, sorter, update strategy, lookup, joiner and sequence generator and experienced in tuning mappings
• Experience in data warehousing, data analysis, reporting, ETL, data modeling, development, maintenance, testing and documentation.
• Extensive experience in Oracle 11g/10g/9i - design and developing stored procedures/packages, database triggers, cursors using SQL, PL/SQL.
• Expert in database design, relational integrity constraints, normalization, denormalization of database.
• Strong knowledge of SQL*Loader for extraction of data from legacy databases to Siebel interface tables.
• Experience in performance tuning of database.
• Excellent communication, leadership, organizational, analytical and problem solving skills.

TECHNICAL SKILLS

• Oracle 9i 10g 11g
• SQL Server 2000 2005/2008
• MS Access.
• C
• C++
• SQL
• PL-SQL
• Informatica (Power center 8.6/8.1/7.1)
• Oracle OLAP
• Siebel Analytics 7.8.5
• OBIEE 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

PROFESSIONAL EXPERIENCE

Confidential, MA

Sr Oracle Business Intelligence Consultant

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, Groton, CT

Sr.Oracle Business Intelligence Consultant

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, Providence, RI

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, Boston, MA

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, Easton, PA

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, Dallas, TX

Sr. 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, Wilsonville, OR

Sr. Oracle Business Intelligence Consultant

Hardware/Software:Oracle 10g, MS SQL, OBIEE 10.1.3.3.2 , BI Publisher, UNIX Shell Scripting, MS Visio, MS Excel

Responsibilities:

• Responsible for full cycle implementation of OBIEE.
• Lead an OBIEE configuration team or development team, ensuring design, development and testing work is completed to standard and on time.
• Captured and documented Management Information/Business Intelligence requirements from clients, via interviews or workshops, ensuring suitable balance of business needs and delivery feasibility.
• Designed, configured and documented Logical and Physical Data Model and ETL process and mapping configuration.
• Developed Metadata repository (.rpd) that consists of Physical, BMM and Presentation layer using Oracle BI administration tool.
• Implemented external table security with session variables, tested and validated the business model and repository level calculations using Oracle BI Administration tool.
• Implemented object-level security to restrict the access of data.
• Used Ago and Todate functions extensively.
• Performed cache management using event poling table, cache persistence time, seeding the cache.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Extensively used SQL queries, Indexing, Triggers.
• Developed 3 Dashboards / 27 Reports using different Views (Pivot Table, Chart and Column Selector), with drill-down and drill across capabilities, guided navigation and dashboard and page prompts.
• Used BI Publisher to create reports from an Answers Request, and from BI Server data.
• Performance Tuning using optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes
• Involved in Reconciliation Process Oracle BI Reports output with Cognos Reports.
• Prepared and executed Component, System and User Acceptance testing, including bug resolution.
• Involved in OBIEE installation and configuration in LINUX environment.
• Created reports, dashboards, customizing login screen, portal banner.

Confidential, San Fransico, CA

OBIEE 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.
• Worked closely with the data modeler in creating logical data model (Star Schema).
• 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 Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Installed and configured Oracle BI Publisher and integrated it with Oracle BI Presentation services.
• Developed and modified reports in BI Publisher.
• Extensively used SQL queries, Procedures, Triggers.
• Developed user guides for the end users. User guide contained some screenshots of high level reports and also provides instructions in accessing them.
• Also participated in developing ETL design using Informatica, used Transformations like Aggregator, Joiner, Update, Filter, Lookup, Sorter.

Confidential, Fort Lauderdale, FL

Siebel Analytics Consultant

Hardware/Software:Siebel Analytics 7.8.5, Informatica 7.1.2, Oracle 10g/9i, SQL, PL/SQL, SQL Server 2000/2005, Windows 2000/2003.

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements.
• Involved in creating the Star Schema, Logical and Physical Modeling.
• Built the Analytics repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer).
• Created Complex Joins, Alias Tables and Views.
• Tuned Siebel Analytics Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed Calculated Measures and assigned these Aggregation levels based on Dimension Hierarchies.
• Worked extensively on Answers, Delivers, and Interactive Dashboards.
• Developed Various Dashboards and Reports and Created the Business Model for Ad-hoc queries using Siebel Analytics Answers and assigning them to application specific dashboards.
• Designed the Row Level Security for the Managers to View the Reports pertaining to their Region.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Managed and provided Permissions for Reports and Dashboards in Siebel Analytics Presentation Services Web Catalog.
• Created Transformations like Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created Complex Mappings using Lookup, Sorter, Aggregator, and Router transformations for populating Target Table in Efficient manner.
• Created Mapplet and used them in different Mappings.
• Extensively Used Sql queries, Triggers, Indexes, Oracle Functions.

Confidential

Database Developer

Hardware/Software:Oracle9i, SQL, PL/SQL, XML, SQL*Loader

Responsibilities:

• Wrote several stored procedures/triggers in Oracle (PL/SQL) for the enterprise portal application and data merge.
• Involved in daily, weekly and monthly load of data from mainframe data set to Oracle database.
• Worked on very large database environment in terabytes and tuned queries for performance. Created and maintained parallel queries for very large datasets.
• Creating temporary tables and indexes for loading and updating data.
• Worked on queuing for sending XML data to the calling java APIs.
• Data loading using SQL *Loader.
• Imported/exported several databases through various environments
• Developed and maintained lot of batch scripts in KSH scripts for the production, like scheduled data loading, Create, databases, Tuning and backup and Recovery.