PROFESSIONAL SUMMARY:

• Enthusiastic and highly skilled individual with 8+years of experience in the field of data warehousing, specialized in Oracle BIEE, Siebel Analytics, BI publisher, and Informatica ETL reporting tool
• Hands on experience in configuring and developing the analytics/OBIEE repository, which involves Schemas Import, Implementing the business logic by customization, Dimensional Hierarchies, level Based Measures, Security Management such as Data level /Object level Security, Variables, Initialization blocks
• Expertise in development of the three layers (Physical layer, Business Model and Mapping Layer & Presentation layer) of an OBI Metadata repository using BI administration tool
• Expertise in Creating, Modifying and administering Dashboards Using OBIEE
• Experience in setting up a Multi - User Development Environment (MUDE) and OBI Answers to run queries to test and validate the repository
• Experience in setting up Security and architecture with OBIEE 11g by using weblogic admin console and enterprise manager
• Experience in Configuring Interactive Dashboards with drill-down capabilities using global and local filters, Metadata objects and web catalog objects such as Dashboards, pages, folders and reports
• Expertise in Cache Management, Performance tuning at report level and database level
• Experience in setting up aggregate Navigation-Creating aggregate tables using materialized views
• Experience in working with new OBIEE Functionality and features (Score cards, Action links, Selection steps, Hierarchical columns etc.)
• Experience in Data Analysis and dimensional data modeling, Star Schema Modeling, Snow flake Modeling, identification of Fact and dimension tables
• Experienced in development & customization of BI publisher (XML publisher) reports
• Customized Business Intelligence (BI) applications and modified prebuilt solutions according to the requirements
• Involved in customizing Data warehouse Administration Console (DAC) and Informatica mappings/Tasks
• Development strategies for extraction, Transformation and loading (ETL) of data from various sources into data marts and Data ware houses using Informatica Power center
• Committed team player with multitasking capabilities, Excellent interpersonal and human relation skills. Strong communication skills both verbal and written, with an ability to express complex business concepts in technical terms and ability to learn and adapt to new technologies

TECHNICAL SKILLS:

BI Tools: OBIEE11.1.X, 10.1.3.4/3/2, Siebel Analytics 7.8/7.7/7

ETL: ODI, Informatica 9.X/ 8.6/8.1.1/7.9. x/6.1.1

Scheduling Tools: Data ware Administration Console (DAC)

Tools: TOAD,SQL developer, SQL plus, Discoverer

Database: Oracle 11g/10g

Operating System: Windows, UNIX, Linux

Data Modeling: Star Schema, Snow-Flake Schema Modeling

WORK EXPERIENCE:

Confidential

OBIEE Admin/Developer

Responsibilities:

• Installed OBIEE on oracle linux server and did complete server configuration
• Created Application Roles using Oracle Enterprise Manager& assigned different permissions on dashboards and reports.
• Used Customized JavaScripts/HTML to disable certain standard OBIEE features at dashboard page level and also at report level.
• Customized skin and style sheets of OBIEE to meet the business needs.
• Worked on Cache Management to improve performance.
• Interacted with business users to gather requirements and created mock up reports to finalize the requirements
• RPD Development is based on subject areas like Public queries and Enforcement
• Created Reports & designed various report views like Table, Charts, Pivot, Created Column Filters and Prompts to filter the request and worked with column formatting function
• Based on requirement created Initialization blocks, repository variables and session variables to generate dynamic data
• Extensively used Action Links to navigate from Parent to Child Report and passing filters/prompt values.
• Customized skin and style sheets of OBIEE to meet the business needs.
• Designed and created Report/Dashboard layouts with the necessary Data level and Object level Security as per business requirement in OBIEE 11g
• Used Customized Java Scripts/HTML to disable certain standard OBIEE features at dashboard page level and also at report level
• Set up the ODI connection with Oracle.
• Troubleshooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
• Created business mapping document based on business requirement document.
• Set up the Topology including physical architecture, logical architecture and context.
• Created new models for the data sources - flat files, MS SQL server, Oracle.
• Did reverse engineering for the data sources and targets.
• Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.

Environment: (OBIEE) 11.1.1.7.1 / 11.1.1.7.1 40527, Oracle 11g, SQL/PLSQL, BI Publisher, Oracle Linux 6,ODI 12C.

Confidential, Marlborough, MA

OBIEE Admin/Developer

Responsibilities:

• Configured Amazon web services (AWS) environments with necessary oracle recommended packages and Installed OBIEE on Red hat Linux 6.5
• Performed patch upgrade related activities from OBIEE 11.1.1.5 to OBIEE 11.1.1.7 in all three environments
• Upgraded OBIEE 11.1.1.6.2 to OBIEE 11.1.1.7.1
• Involved in OBIEE Production support for different Application teams
• Created Shell scripts to start and stop the OBIEE instances in linux environments
• Created scripts to clear cache by subject areas, queries and tables etc.
• Hands on experience in RPD and Web catalog merging
• Migrated RPD and Web Catalog from Lower environment to higher environment
• Configured Security groups and users using LDAP & External Tables in Enterprise Manager and Weblogic Console
• Implemented Write back functionality and deployed analytics res in Weblogic
• Installed SSL certificate and enabled https in OBIEE
• Implemented Data level and Object level security for different application teams based requirements
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance
• Created Application Roles using Oracle Enterprise Manager & assigned different permissions on dashboards and reports.
• Created smart view connection that enables you to create new reports and run existing reports /analysis, directly from Excel
• Customized skin and style sheets of OBIEE to meet the business needs
• Created Proactive Agents /iBots using Delivers & delivered using Scheduler services.
• Worked with OBIEE cache manager and followed the best practices to improve the performance
• Involved in creating scripts to monitor BI server logs
• Build reports in tableau using OBIEE RPD by connecting through adapter provided by the Tableau
• Built financial and invoice RTF template for BI Publisher reporting
• Installed Jasper server on Amazon web services(AWS)
• Created existing OBIEE reports in Jasper server and converted existing RDF Template to Jasper reports
• Documented process OBIEE on AWS, security configuration, migration process and users training material
• Interacted with business users to gather requirements and created mock up reports to finalize the requirements
• RPD Development is based on subject areas like Hedge Funds, Finance, Human Resources and Procurement
• Developed Business Model Mapping Layer to create Dimensional hierarchies, measures and assigned Aggregation levels based on dimension hierarchies (Times, Locations and Promotions etc)
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions extensively.
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement
• Created BI publisher reports as per business requirement
• Based on requirement created Initialization blocks, repository variables and session variables to generate dynamic data
• Extensively used Presentation Hierarchy/Hierarchical Column to drill deeper into the data, to view more detailed information.
• Extensively used Action Links to navigate from Parent to Child Report passing filters/prompt values.
• Created proactive agents, Ibots and interactive Dashboards to alert the marketing team about business changes.
• Used/Suggested Views, Indexes, and Aggregated Tables to improve performance of reports/dashboards
• Documented Technical Design document and User Training/help documents.
• Guiding / Training customer’s IT Team during course of the project so that it feels confident about supporting this product post deployment

Environment: (OBIEE) 11.1.1.7.1, Oracle 11g, My SQL, Informatica 9.0.1, SQL Developer, Windows 2008, SQL/PLSQL,ODI,BI Publisher, Amazon Web services, Linux, Red hat Linux 6,Amazon web services

Confidential, Burlington, MA

Sr. OBIEE Administrator/ Developer

Responsibilities:

• Installed OBIEE, Oracle Weblogic components on Dev, QA& Prod and did Server configurations on all three environments.
• Migrated Repository & Web Catalog from Development to QA & Production server using Oracle Enterprise Manager/Catalog Manager.
• Performed patch upgrade related activities from OBIEE 11.1.1.5 to OBIEE 11.1.1.7 in all three environments.
• Performed upgrade Metadata Repository and Web catalog from OBIEE 11.1.1.5 to OBIEE 11.1.1.7
• Export/ import process to migrate users and groups from Dev to Prod server.
• Configures SSL configuration and Security Certificate installation.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Configured Security groups and users using LDAP & External Tables in EM/Console.
• Worked closely with the business users and developers to make sure that business requirements are correctly translated into design and ultimately into the application.
• Created Mock up reports as business requirement to validate the reporting requirements
• 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.
• Designed and created Report/Dashboard layouts with the necessary Data level and Object level Security as per business requirement in OBIEE 11g.
• Performed POC on Oracle Discoverer to OBIEE.
• Created Application Roles using Oracle Enterprise Manager & assigned different permissions on dashboards and reports.
• Created proactive Agents, Ibots and interactive Dashboards to alert the marketing team about business changes.
• Used/Suggested Views, Indexes, and Aggregated Tables to improve performance of reports/dashboards.
• Involved in Mude setup
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Performance tuning for slow running reports & recommended best practices for improving usability in OBIEE
• Enabled SSL listen port to establish the connection between web via OBIEE 11g front end and weblogic app server using HTTPS Protocol
• Created Smart View connection that enables you to create new reports and run existing reports /analysis, directly from Excel.
• Documented OBIEE setup, configuration, and design in detail with knowledge transfer to technical team.
• Trained End Users about the OBIEE UI functionality.

Environment: (OBIEE) 11.1.1.7.1, Oracle 11g, My SQL, Informatica 9.0.1, SQL Developer, Windows 2008, SQL/PLSQL, BI Publisher

Confidential, Albany, NY

Sr. OBIEE Admin/Developer

Responsibilities:

• Interacted with business users to gather requirements and created mock up reports to finalize the requirements
• Interacted with end users and Architect to validate the data model.
• Migrated Repository & Web Catalog from Development to Test& Production server using Oracle Enterprise Manager/Catalog Manager.
• 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.
• RPD Development is based on subject areas like Finance, Human Resources and Procurement.
• Created Logical Dimensions with Level-Based Hierarchies and Parent-Child Hierarchies, level-based Measures, aggregates.
• Created, modified and formatted reports/dashboards, using different views i.e. pivot table, charts, and filters in analysis. Built new reports as per business needs.
• Used View selector to show two different views in same report.
• Configuring Repository, Session variables to generate dynamic reports.
• Configured and integrated Map Viewer.
• Used Index Col function for data level security.
• Used/Suggested Views, Indexes, and Aggregated Tables to improve performance of reports/dashboards.
• Migrated Repository& Web Catalog from Development to Test& Production server using Oracle Enterprise Manager/Catalog Manager.
• Extensively used Presentation Hierarchy/Hierarchical Column to drill deeper into the data, to view more detailed information.
• Extensively used Action Links to navigate from Parent to Child Report passing filters/prompt values.
• Designed and created Report/Dashboard layouts with the necessary Data level and Object level Security as per business requirement in OBIEE 11g.
• Created Application Roles using Oracle Enterprise Manager& assigned different permissions on dashboards and reports.
• Documented Technical Design document and User Training/help documents.
• Guiding / Training customer’s IT Team during course of the project so that it feels confident about supporting this product post deployment

Environment: (OBIEE) 11.1.1.6 BP2, Oracle 11g, Informatica 9.0.1, SQL Developer, Windows 2008 R2,SQL/PLSQL,BI Publisher

Confidential, Jersey City, NJ

OBIEE Admin/Developer

Responsibilities:

• Worked closely with the business users and developers to make sure that business requirements are correctly translated into design and ultimately into the application.
• Created Mock up reports as business requirement to validate the reporting requirements.
• Interacted with end users and Architect to validate the data model.
• Performed patch upgrade related activities from OBIEE 11.1.1.4 to OBIEE 11.1.1.6.
• Development of RPD using Physical, BMM and Presentation layers of BI Administration Tool.
• Configuring Repository, Session variables to generate dynamic reports.
• Created Proactive Agents /iBots using Delivers & delivered using Scheduler services.
• Migrated Repository & Web Catalog from Development to Test& Production server using Oracle Enterprise Manager/Catalog Manager.
• Created, modified and formatted reports/dashboards, using different views i.e. pivot table, charts, and filters in analysis. Built new reports as per business needs.
• Extensively used Presentation Hierarchy/Hierarchical Column to drill deeper into the data, to view more detailed information.
• Designed and created Report/Dashboard layouts with the necessary Data level and Object level Security as per business requirement in OBIEE 11g.
• Created Application Roles using Oracle Enterprise Manager& assigned different permissions on dashboards and reports.
• Used Customized JavaScripts/HTML to disable certain standard OBIEE features at dashboard page level and also at report level.
• Worked on Branding of the existing OOTB product for enhanced user adoption.
• Customized skin and style sheets of OBIEE to meet the business needs.
• Worked on Cache Management to improve performance.
• Used/Suggested Views, Indexes, and Aggregated Tables to improve performance of reports/dashboards.
• Guiding customers on Server Sizing.
• Documented Technical Design document and User Training/help documents.
• Guiding / Training customer’s IT Team during course of the project so that it feels confident about supporting this product post deployment

Environment: (OBIEE) 11.1.1.4/5/6, Oracle11g,Informatica9.0.1,SQLDeveloper,Windows2008,SQL/PLSQL,ODI,BI Publisher

Confidential, Salt lake city, UT

OBIEE Developer

Responsibilities:

• Interacted with business users to gather requirements and created mock up reports to finalize the requirements.
• Performed upgrade activities from OBIEE 10g to OBIEE 11.1.1.3, also documented issues & resolution occurred during upgrade process.
• Designed and Built Oracle BIEE Repository at Physical layer, Business Model / data mapping and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Configuring Repository, Session variables to generate dynamic reports.
• Customized the OOTB reports/dashboards using different views i.e. pivot table, charts, and filters in analysis. Built new reports as per business needs.
• Setup MUDE environment to facilitate multiple user’s repository development in parallel by setting up users and projects.
• Assisted User in Designing Report Layouts and Report Structure for better utilization and Understanding of data.
• Extensively used Action Links to navigate from Parent to Child Report passing filters/prompt values.
• Designed and created Report/Dashboard layouts with the necessary Data level and Object level Security as per business requirement in OBIEE 11g.
• Configured Agents/Ibots to schedule reports to email in all three environments.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Worked on Branding of the existing OOTB product for enhanced user adoption.
• Customized skin and style sheets of OBIEE to meet the business needs.
• Worked on Cache Management to improve performance.
• Used various transformations like Source qualifier, Aggregators, Dynamic Lookup, Router, Sequence generator for mappings based upon the requirement
• Used/Suggested Views, Indexes, and Aggregated Tables to improve performance of reports/dashboards.
• Trained Users on new features of OBIEE 11g and creation of Adhoc Reports.
• Documented Technical Design, Upgrade of OBIEE 10g to 11g and User training/help documents.

Environment: OBIEE 10.1.3.4/11.1.1.2, Oracle 11g, Informatica 9.0.1, SQL Developer, Windows 2008 server, SQL/PLSQL

Confidential, Bingham Farms, MI

OBIEE Developer

Responsibilities:

• Analyzed, designed and developed OBIEE Metadata repository (.rpd) that consists of physical layer, multiple business models with aggregations, dimensional hierarchies, and level based measures, calculations and multiple presentations catalogs for the presentation layer
• Created repository variables to achieve dynamic reports and dashboards and also implemented initialization blocks to pass values to the variables
• Configured the multi user development environment that allows multiple users work on different modules in the repository
• Used Answers to model and build the designation Ad-hoc reports
• Involved in the modifications of the physical, business and presentation layers of the metadata repository using OBIEE admin tool
• Created proactive agents, Ibots and interactive Dashboards to alert the marketing team about business changes
• Managed Security privileges for each Subject area and Dashboards according to user requirements
• Worked with OBIEE cache manager and followed the best practices to improve the performance
• Developed performance tuning strategies, for optimized performance, by implementing Aggregate Navigation, cache Management and Indexes
• Involved in Migrating OBIEE from 10g to 11g
• Created Time series measures year ago, month ago, year-to-date measures using AGO and To Date Functions
• Managed security privileges for each subject area and dashboards according to user requirements
• Implemented comprehensive security model, by creating user roles and web groups
• Designed and build OBIEE data level security based on external data base model to deliver an intelligence authentication mechanism with row-level security
• Monitored database utilization and system response time

Environment: Oracle business intelligence enterprise edition (OBIEE) 11.1.1.0/10.1.3.4, Oracle 11g/10g, Oracle BI Publisher, SQL Developer, TOAD

Confidential, Colorado Springs, CO

OBIEE Developer

Responsibilities:

• Created business reports according to the user requirement, connection pools, physical tables, defined joins and implemented authorizations in physical layer of the repository
• Designed Star Schema for fact & dimensional tables and created alias for the dimensional tables when necessary
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports
• Setup MUDE environment to facilitate multiple Users repository development in parallel by setting up users and projects
• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include like Managers, functional heads, Department Heads
• Managed Security privileges for each Subject area and Dashboards according to user requirements
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Oracle BI Presentation Services
• Collected pre-built application components like forms, reports, database tables and objects by using AOL
• Used Analytics Web Catalog to set up groups, access privileges and query privileges
• Used various transformations like Source qualifier, Aggregators, Dynamic Lookup, Router, Sequence generator for mappings based upon the requirement
• Designed and developed Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for extraction, transformation & loading
• Worked for performance tuning by finding out the bottlenecks in various mappings

Environment: OBIEE 10.1.3.4, Oracle 10g, TOAD, SQL developer, Windows server 2003, Informatica

Confidential

Siebel Analytics/ ETL consultant

Responsibilities:

• Worked closely with business Analyst in understanding the analytics requirements and created the business model for generating reports as per the user requirements
• Created/Modified Metadata repository suiting to data requirements using Siebel Analytics Server Admin tool
• Analyze, Design and develop Siebel Analytics Metadata repository (RPD) that consists of Physical Layer, Business Model and Mapping Layer and presentation Layer
• Developed Answers, Filters, Customized Reports and Dashboards using Siebel Analytics Web
• Responsibilities include business requirement analysis, and functional requirement
• Using the Siebel Analytics Administration tool (.RPD) to develop and enhance meta-data to Build Business model and establish relationships
• Simplifies and reorganizes the Meta data into a single business model
• Organize presentation layer in a format that is easy for end user to use as basis for reporting using Siebel Analytics Administration tool (.RPD) intelligence dashboards for subscribed users
• Created new mappings and updating old mappings according to changes in business logic
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance

Environment: Siebel Analytics 7.x, Oracle 9i/8i, Informatica 6.1.1, SQL Server, SQL/PL