Data Manager

Around * years of effective experience in Complete Software development Life cycle (SDLC)BusinessRequirements Gathering, System/GAP Analysis & Design, Data Modeling (Star and Snow Flake), Development, Testing, documentation and Implementation of Enterprise Data warehouse, Data Marts and Various Business Intelligence Applications.

Professional Summary:

Hands on Experience in upgrading, designing & developing Metadata of analytical repository (RPD) in OBIEE 11g, managing the OBIEE 11g Web logic Console and Enterprise Manager.

Extensive experience in building business models of OBI analytical repository (RPD) and configuring Metadata using admin tool, Time series measures, developing complex reports using set operators and direct data base requests by including global & local Filters in answers, Delivers, developing dynamic &Interactive Dashboards with drill-down & drill-across capabilities, Security Setup, and Web Catalog Objects and scheduling IBots using OBIEE.

Expertise in debugging, Building Metrics or KPI, Implementing caching methodologies, optimizing the performance tuning of Oracle BI Repository & Dashboards / Reports and Informatica Mappings / Workflows and at Data Base level.

Extensive experience on OBIEE/Siebel Analytics features (i.e. Clustering, Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, MUD, Disconnected, Integration Variables/Initialization Blocks configuration & BI Publisher etc.)

Installation, Upgrade and Configuration of OBIEE/Siebel Analytics, Informatica Power Center and DAC (Data warehouse Administration Console) for multi OLTP regional instance environment and on Windows and UNIX environment.

Extensive experience on BI publisher which includes installing, configuring and integrating with OBIEE server and created Smart View Report Templates.

Implemented and extensively worked in Multi User Development (MUD) and performed some Administration tasks such as Security, Projects and provide required authentication as needed.

Optimized the Solution using various performance tuning methods (SQL and ETL tuning (i.e. optimal configuration of transformations and memory parameters), Database tuning using Hints, Indexes, partitioning, Materialized Views, External Table, Procedures, functions etc.)

Involved in ETL mappings design& development for more than two years using Informatica Power Center and Oracle Data Integrator Designer.

Extensive Business Intelligence experience using Oracle Business Intelligence EE 10g, 11g, Oracle Business Intelligence Publisher 10g & 11g, and Informatica Power Center 8.x.

Sound Knowledge of Relational and Dimensional Modeling (Star & Snow Flake) techniques.

Good experience in UNIX and writing shell scripts for execution of the work flows and scheduling the tasks.

Great communicator and diligent team member with strong technical background and good inter-personal skills.

Technical Summary:

Operating Systems : MS-DOS, Windows 2000/XP/7, Server 2003/2008, UNIX - AIX.

Programming Languages : SQL, PL/SQL, C, UNIX Shell Script.

Databases : MS - SQL SERVER 2008, Oracle 10g/11g, MS Access.

BI Tools : Oracle Business Intelligence10.1.3.4.x, 11g.

ETL Tools :Informatica PowerCenter8.1.x, SQL Server Integration Services

Data Modeling : ERWIN, MS Visio.

Professional Experience:

Virginia Department of Health, Richmond VAJan’14 – Till Date

Sr OBIEE Consultant

Responsibilities:

Installed and upgraded the previous version repository, Catalog and delivers in to 11g and implemented the 11g features in to the metadata.

Performing the requirement analysis, gap analysis, coordinated with financial team and Business Intelligence architecture team to map BI capabilities with requirements and plan for functionality.

Involved in building detailed project schedule, completed the POC in translating functional requirements into technical, designed and developed Technical designs and Unit test scripts.

Extensively Configured OBIEE Repository to provide Analytical Reporting solutions to business of Financial Application.

Implemented Fragmentation content, dimensional hierarchies for drill down and associated the proper level of granularity to the fact table. Created Level based Measures and share measures, Time series functions using dimensional hierarchies and Time dimension.

Designed Aggregate Tables modeled the repository for improving performance of the reports.

Worked on security for users by integrating LDAP Server for Authentication and using other Authentication types (External table authentication and Database) for authorizing admin rights.

Implemented Single Sign-on for accessing Oracle BI Answers for users and Catalog Manager for Developers to automatically log into the application.

Added column/data level security at the repository level. The data was restricted with respect to the group user. Managed security privileges for each subject area and dashboards according to requirements Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance

ConfiguredOBIiBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily Weekly, monthly and yearly reports.

Developed Role-Based Dashboards for Region Managers, pages, reports with various views i.e. table, pivot, Gauge, charts, narrator, column selector etc. and various report prompts.

Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.

Created Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and graphs.

Design and developed process for Initial loads and Ongoing loads (Incremental Aggregation with Extract Date concept).

Involved in Migration and Merging of Analytics Repository and Catalog from Dev to QA and coordinated into production.

Environment: ODI 11.1.1.6.x, OBIEE 11.1.1.7.x, Windows Server 2008, Oracle 11g, Oracle EBS 12r, Oracle Hyperion Essbase 11g, PL/SQL.

Johnson & Johnson, Philadelphia PASep’12 – Nov’13

Sr OBIEE Developer

Responsibilities:

Created and developed the ODI Interface metadata mappings to extract the data from Exhibition Event Master and EBS Apps to consolidate the data into Enterprise data warehouse.

Involved in system performance tuning to improve the performance from OBIEE report/dashboard wise and RPD.

Designed Aggregate Tables modeled the repository for improving performance of reports.

Identified Gaps by analyzing the Datamart instance and provision of alternative solutions as well as recommendation of changes to databases

Designed and developed the OBIEE/ Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer.

Designed ETL mappings for bringing in data from various data sources

Identified the fact and dimension tables, designed the Kimball Matrix, created the data mapping field matrix

Developed multiple Dimensions with multiple Drill-Down Hierarchies in Business Model Layer and customization of Presentation catalogs in Presentation Layer

Configured more than 90 Measures in the Business Model Layer that are not critical to performance and mapped them to multiple logical source tables

Developed Time Series objects for computing Year Ago, YTD, MTD, WTD measures. Also created Fragmentation content for few fact tables

Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.

Created Roles/Groups in Oracle EBS to provide the access to multiple departments without relying on the responsibilities.

Integrated LDAP server in order to authenticate the users along with Native authentication and EBS authentication. Maintained the groups in LDAP and applied the security on user level.

Built Interactive Dashboards with drill-down capabilities, use of global prompts and Presentation variables

Extensively worked on complex Interfaces which involved slowly changing dimensions.

Worked in the ETL Code Migration Process from DEV to QA and to PRODUCTION.

Created Complex procedures and used them in the interfaces to load the data to simplify the interface design. Automated the schema name using ODI interface function in procedures.

Customized requests and modified the OBIEE Dashboard using cascading style sheets

Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements

Performed Unit, Integration, and Regression testing to validate report and mapping

Handled huge Initial load trouble shooting scenarios. Daily ETL load monitoring and fixing production load failures.

Respectively participated in weekly Project status meetings and communicated effectively with Project Managers

Environment: Informatica 8.6.1, DAC 10.1.3.4.1, OBIEE 11.1.1.5.x, Windows Server 2003, Oracle 11g, OBIA Financial Analytics 7.9.6.1, Oracle Hyperion Essbase 11g, PL/SQL.

Marsh & McLennan, New York NY Sep’11 – Sep ‘12

OBIEE Consultant

Responsibilities:

Involved in translating functional requirements into technical requirements also in building detailed project schedule, completed the POC in translating functional requirements into technical, designed and developed Technical designs and Unit test scripts.

Extensively Configured OBIEE Repository to provide Analytical Reporting solutions to business of Financial Application.

Interacted with Procurement and Operation / Maintenance business representatives for gathering the OBIEE Reports / Dashboards requirements and to define business and functional specifications

Analyzed and used various data sources – Oracle, Excel, and Web Services

Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling

Customized and developed RPD (Physical, BMM and Presentation Layer), configured metadata objects and Web Catalog Objects

Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.

Used the incremental update feature to capture the enhancement in hierarchies or newly added dimension to reflect in the Repository file.

Developed the reports based on Dimension hierarchies and presentation columns to provide the filter at any level of column detail.

Configured OBIEEiBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.

Implemented security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security.

Reports were created to analyze the financial service center statistics for different campaigns, Customized pre-built dashboards.

Involved in developing the Incremental ETL process i.e., Mappings &Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd.

Created Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and charts.

Developed many PL/SQL procedure & functions and used the same in mappings, pre and post sessions.

Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.,

Performed Unit, Integration, and Regression testing to validate report and mapping functionality.

Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Siebel Analytics Repository.

Environment:

OBIEE 10.1.3.4.1, UNIX – AIX 5.3 (64Bit), Informatica 8.6.1, Oracle 10g/ 11g

Motorola Solutions, Schaumburg ILMay ’10 – Aug’11

SrOBIEE Developer

Human Resource Analytics Performance and Talent Management: An out of the Box HR Analytics application has been implemented which is50% customized with perfect star schema by considering the future upgrade possibilities.

Responsibilities:

Participated in walkthroughs of the data models, identification of Dimensional Attributes, Facts and Star Schemas to fulfill the requirements.

Involved in Customization and Development of the OBIEE Metadata Repository (.rpd) using OBIEE Admin Tool in Multi User Development (MUD) Environment.

Developed managerial hierarchy in the RPD with vertical table structure to identify the direct report employees of a particular manager at certain level. Implemented conditional formatting to identify the employee level of reporting.

Developed the reports based on Dimension hierarchies and presentation columns to provide the filter at any level of column detail.

Implemented security on fact table to restrict the organization data limited to their own hierarchy.

Restricted confidential data to certain groups including top talent associates profile information access to higher level management only.

Created set of dashboards/reports for talent planning, performance management, competencies, and Executive profiles using OBIEE.

Developed report with conditional filters, Prompts, Drill Down reports, Drill Reports, different Analytics Views (Pivot Table, Charts).

Created user level security for intelligence dashboards based on Business Requirement and utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.

Security has been considered primarily for the confidential columns data by generating the SQL and gathering the group’s information to restrict the data to certain groups only.

Implemented Workforce planning project to allow users to forecast the Organization metrics data, and displaying the current and forecasted data in a single dashboard by having run time calculations to display forecasted data.

Provided new design for Associate movement summary as Daily data or monthly data changes. Configured the RPD to switch the sources to provide the flexibility of choosing daily or monthly snap shot data

Limited the row level data to the certain groups based on inclusive or exclusive access to the organization, Location, Manager and Confidential information. Limited the intersection of row and column by categorizing the confidential columns based on row level data and exclusive or inclusive access to it.

Provided additional layer of security on physical data base objects to the particular promo group to perform the data base authentication.

Environment:

Oracle Business Intelligence (OBI) EE 10.1.3.4.2, Informatica 8.1.x, Oracle 10g, Windows Server 2003, UNIX - AIX.

Verizon, Atlanta GA Jan’08 – May ‘10

OBIEE Developer

Responsibilities:

Participated in multiple end to end implementations which consists of gathering requirements from multiple user groups, analyzing Business Requirements Documents (BRD’s), preparing high level and low level design documents, Development, Support.

Prepared HLD’s (High Level Design), LLD’s (Low Level design) and participated in Data Model Reviews.

Participated in GAP analysis, Impact Assessment, and prepared necessary documents for multiple projects.

Expert in presenting the designs to business and in getting signoff’s with some report mockups (without actual developing the reports).

Expert in designing and developing Rpd (repository) using OBIEE Admin tool. Developing all the three layers (Physical, Business Model and Mapping, Presentation) with oracle’s best practices.

Developing Reports/Dashboards using OBIEE front end (OBIEE Presentation Services). Created Reports using different views like table, pivot, narrative, filter, compound etc based on the requirement.

Developed Interactive Dashboards using dashboard prompts, attractive landing pages, with multiple links, Guided navigations, Answer queries, BI Publisher reports. Formatting Reports/Dashboards with attractive colors, wordings, font as per client’s requirement.

Supporting Infrastructure team in merging multiple projects from multiple development teams into one development rpd and deploying it into server. Preparing SIT, UAT, Production deployment checklists, testing the environments after each and every deployment.

Tracking Production Issues, SIT Defects, UAT Defects in Quality Center and Fixing, deploying the changes in all the environments them with very less time.

Participated in Release Management work which consists of raising TFS, Maximo tickets for code deployments in to different environments (SIT, UAT, and Production).

Documenting all the changes and maintaining them in SharePoint sites which help future enhancements.

Developed Usage tracking reports for monitoring user activity and implemented Usage tracking business model in RPD. Fetched user and Group information for SA subject area.

Configured advanced Navigation reports, guided navigation link, Complex Union reports etc.

Environment:

Oracle Business Intelligence (OBI) EE 10.x, BI Publisher 10.x, Informatica 8.x, Oracle 10g, Windows Server 2003.

Education:

Bachelor of Technology in Electrical & Electronics Engineering from JNTUINDIA.

Contact this candidate