Summary:

Extensive experience of gathering requirement, Proof of concept, gap analysis, design, development, Testing and Implementation of the OBIEE/ETL/Data warehouse, BI Publisher project.

Around 8 years of overall IT experience as an OBIEE consultant with strong development and admin skills.

Expertise in Business Model development with Facts, Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.

Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions SCD .

Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.

Involved validation for technical requirements and architecture quality attributes.

Designed and developed the Metadata Repository .rpd using Server Admin tool by importing the required objects Dimensions, Facts Aggregates with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions Drill-down Hierarchies Logical Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.

Expert in Creating the Dimensional Hierarchies, Level Based Measures, Time-series Functions, Initialization Blocks and Variables depending upon the need for Business Reports using the OBIEE Admin tool.

Extensive experience in creating Reports, different charts, narrative view, column selector, view selector, pivot table and Dashboards with Prompts.

Implemented Security by creating roles web groups, checks with External tables LDAP.

Expert in database performance tuning by Parallel Execution, Partitions, Materialized views in query rewriting, creating indexes, re-building indexes and SQL Tracing.

Responsible for application development, project management, and Rapid Application Development RAD .

Performed relational database design and normalization, client-server development, object-oriented analysis and design.

Expertise in Unit Testing, Functional Testing, System Testing, Integration Testing, performance Testing and Web Application Testing.

Demonstrated ability to coordinate and work with colleagues in product development, marketing, sales, training and production as well as external customers to successfully develop structure and launch new products and services.

Work experience has given me the opportunity to acquire in depth Functional knowledge of customer's business, process flow and procedures of various domains as well as building customer relationship skills.

Experience in working with UNIX operating systems such as AIX, Linux servers, contributing innovative methodologies and alternatives to the growth of the company having excellent client relation skills and the drive to complete tasks effectively and efficiently.

In-depth knowledge of Software Development Life Cycle SDLC , having thorough understanding of various phases such as Requirement gathering, Analysis / Design, Development, Testing and Implementation / Release Management.

Interacted regularly with all teams involved in Application Maintenance and the higher management to meet the deadlines of Project milestones.

Professional Work Experience:

Confidential

Sr. OBIEE Developer

Environment: Environment: OBIEE 11.1.1.7, Oracle 11G, TOAD, Linux, Windows 7, Informatica Power Center 9.1

Responsibilities:

Involved in every OBIEE project from initial design phase through production implementation release. Duties include requirement gathering, design, development, testing and release.

Developed all layers Physical, Business and Presentation of the OBIEE repository from the startup as per business requirements.

Created customized dashboard layout in order to neatly fit and present OBI Publisher reports to the customers.

Worked with OBIEE Answers, Intelligence Dashboards and OBI Publisher reports. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports to satisfy the end users. Managed dashboard and request security/privileges in the analytics catalog manager.

Developed and customized some of the existing Dimensions Drill-Down Hierarchies Logical objects in Business Model Layer.

Expertise in setting up users and groups and performing Performance tuning for slow running reports.

Expertise in assigning object and Data Level security.

Expertise in setting up Multi user development MUD environment.

Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.

Worked on Key Performance Indicators KPI within the BI environment which can be used as

the catalyst toward driving more responsive interaction between users and data.

Worked on Configuration Application Deployment Management.

Designed and developed Performance Measurement Dashboards/Reports that are Dynamic

Interactive with drill-down, drill-across capabilities split reports for summary details

information, and local global filters using Oracle BI Presentation Services.

Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to

application specific dashboards.

Developed different kinds of Reports pivots, charts, tabular using global and local Filters.

Enhance performance of Reports/ Dashboards by implementing the Aggregate tables,

Materialized Views, Table partitions and managing Cache.

Worked on Metadata Repository objects and also Web catalog Objects which include

Dashboards, Reports, Pages and Folders

Implemented data level security Location Managers, Sales Executives etc using Session

Variables by creating content filter in dimension table in rpd.

Implemented object level security for both repository objects and web objects by creating users

And groups in repository and web catalog groups in the Presentation Services.

Expertise in BI performance tuning through cache management, indexing hints and materialized views.

Involved with DBA's to tune the DB by setting DB Parameters and tuning BI generated SQL queries.

Created custom Indexes on Tables to improve dashboard Report performance.

Involved in performance tuning for BI server and Oracle SQL queries.

Confidential

Environment: Environment: OBIEE 10.1.3.4, OBIA 7.9.3, DAC, OBIEE 11.1.1.x, Oracle 11g, BI Publisher, SQL, Windows XP, Toad, Informatica Power Centre 8.6.

Responsibilities:

• Worked closely with the business users and developers to make sure that business requirements are correctly translated into database schemas and ultimately into the application.
• Interacted with end users and developers to validate the data model.
• Requirement validation of the reports and drilldowns with business users.
• Performed upgrade related activities from Siebel Analytics to OBIEE.
• Designed and Built Oracle BIEE Repository at 3 layers i.e., Physical Layer connecting Data sources import schema , Business Model / data mapping create Logical tables data source mapping and Presentation Layer level create presentation catalogs , create presentation folders, test and validate the model.
• Responsible for creating users and maintaining visibility privileges using Analytics administration on the repository side.
• Expert in cache management, Repository migration, data level and object level security in OBIEE
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created Sales Scorecard, Weekly Sales Summary and Daily Sales Summary reports.
• Created reports on Sales Objectives Target vs. Actual , Sales effectiveness Direct Sales, Indirect sales .
• Worked with Cache Manager to improve performance.
• Created View , Aggregate Table and Indexes to improve performance
• Integrated BI Publisher with OBIEE.
• Created workflows for full load and incremental loads to be used by DAC
• Created Templates, Reports, Prompts in BI Publisher.
• Created Sales Dashboards for different positions Hierarchy in different Business Units.
• Extensively worked on data validation of the data in the reports and dashboards.
• Performed unit and integration for all components in OBIEE.
• Provided training to the End user's on OBIEE Answers, Dashboard and Admin Tool using OBIEE best Practices.
• Documented project details and Test cases for future reference.

Worked at conceptual/logical/physical data model level using Erwin according to requirements.

• Involved in exhaustive documentation for technical phase of the project and training materials.

Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use.

Confidential

OBIEE Consultant

Environment: OBIEE 11.1.1.5, TOAD for Oracle, Oracle 11G, MS Excel, MS Access, Win 7, RHEL 5.

Responsibilities:

Created connection pools, imported new tables and columns from the Data warehouse defined Physical joins in Physical layer and in Business Model Layer created Logical Joins

Added New Columns based on business requirements, followed design best practices for the RPD and Dashboard designs

Worked on Sales dashboards as part of Netapp Yearend transition.

Created Dynamic Hierarchies using Index Col Function as per the business requirements to protect the data

Involved mostly in Production Support.

Worked with DBAs to create aggregates to improve performance.

• Created various Ad-hoc reports for day-to-day business requirements making use of global and shared filters with different views in accordance with the requirements.
• Extensively worked on tableau created adhoc worksheets as per client requirement.
• Interacted with business users for gathering requirements for newly added Business Hierarchies Projects Dashboards.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database.
• Generated tableau dashboards with combination charts for clear understanding
• Generated Tableau dashboards for yearend transition to validate data
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports

Confidential

OBIEE Consultant

Environment: OBIEE 10g, Oracle 9i, PL/SQL, UNIX, SQL Plus, Windows Server 2k, OWB, IBM AIX

Responsibilities:

Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.

Gathered the business requirements and specifications from end users, marketing executives and managers.

Analyzed, Designed and Developed OBIEE .rpd with aggregates, dimensions, Time Series Objects, Catalogs, Folders, enforced external table security.

Developed calculated measures assigned aggregation levels based on dimension hierarchies.

Informatica was used to translate the Business requirements into mappings, and to load data into Data warehouse.

Built and debugged various Dashboards with drill-down capabilities based on hierarchies using local and global filters.

Designed Reports with different Views Pivot Table, Chart, Tabular and View Selector .

Developed mappings using transformations like Connected and Unconnected lookups, Aggregator, Update strategy, Router, and Sequence generator.

Used the expression builder utility to create new logical columns and calculation measures.

Customized prompts appropriately to avoid excessive data showing up in Reports and Graphs.

Created new Time series measures using AGO and TO Date functions for forecasting.

Involved in the Analysis of Sales business knowledge, Customer Service and ordering subject areas.

Worked on creating web groups, session variables, setting up of Permissions and Privileges for different user groups.

Design, create and tune physical database objects tables, views to support logical and dimensional model.

Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.

Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts, Oracle Enterprise Manager and Precise/SQL

Established and wrote the Performance Tuning guidelines to enhance the quality of the products for all current and future code development which includes hints for SQL and JDBC performance tuning, application tuning methodologies.

Data modeling of 3 business event/process in the data warehouse, data mart and staging layers.

Oracle E-Business Suite Module Involved: AR Account Receivable and CS Support, Incident , OWB target user configurations, OMB Release scripting, Management and test on the OLAP Street, query and mapping optimizations, parallelism configuration query execution and DML repository modeling, dashboard development and release, usage tracking installation.

AIX 5x and 6x installation, up gradation, migration and troubleshooting.

Confidential

Software Engineer

Environment: Oracle 8i/7i, PL/SQL, Visual Basic, ASP, HTML, JavaScript, VB Script

Responsibilities:

Created and customized database with appropriate table spaces to increase the performance.

Created stored procedures and triggers to view, update and enter the check-in and checkout procedures.

SQL Loader was used to convert the data from the Excel to oracle tables.

Prepare detailed statistical reports in MS Access and MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.

PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.

Sub-queries and joins were extensively used in stored procedures.

Created database triggers to automate the transactions that take place online.

Used dynamic SQL to find out the availability of tickets.

Optimize the SQL statements using hints and created SQL scripts to tune performances and make backups.