SUMMARY:

• Srikanth has over 12 PLUS years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse, Data Marts, Business Intelligence, and Transactional applications.
• 5+ years of extensive Business Intelligence and Data warehousing experience with Kimball and Inman Methodology using Oracle BI Applications OBIEE and Informatica 7.x. which includes building and configuring repository, creating and managing oracle/Siebel Intelligent Dashboards, Answers, Delivers and iBots .
• Installed and Configured Obiee 11g and Upgraded RDP & Web Catalog Objects from Obiee 10 to 11g. Resolved Post Upgrade RPD Consistency check issue and fixed all the issue related to reports and dashboard after the upgrade in 11g.
• Expertise in complete SDLC which involves Requirement Gathering, Proof of concept, Gap analysis, Converting functional to technical Spec, Design, Development, Testing and Implementation of the OBIEE / BI Apps/ Informatica/ ETL/ Data Warehouse/Oracle Apps modules
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box(Vanilla mappings) prebuilt mappings, Designing ETL, metadata management using DAC.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large - scale data warehouses using Informatica Power Center, scheduling using DAC and reporting using OBIEE
• Involved in end to end implementations of BI solutions for implementing Oracle Financial Modules (GL, AR, AP, and Profitability etc), Oracle Projects, Revenue, HR, Service, Spend Analytics and Order Management Analytics.
• Extensive experience working with Oracle Business Analytics Warehouse Data Model/Data Structure and creating Star Schema, Snowflake data structure for OBIEE/Siebel Analytics and Oracle BI Analytics.
• Expertise in developing all 3 layers of the Analytics Repository (Physical Layer, Business Model & Presentation Layer). Extensive experience in OBIEE RPD Development, Answers Intelligent Dashboards, Delivers, iBots Implementing security using LDAP
• Expertise in Business Model development with 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.
• Having good experience with configuring Data Warehouse Administration Console (DAC) for Creating Execution plans, metadata management and monitoring the Informatica ETL Process.
• Involved in performance tuning at the DB level, ETL - Informatica level, OBIEE-RPD, Dashboard Server Level
• Involved in bi reports training for end users, business user and higher management like dashboard, answers and publisher (Interactive reports)
• Expertise in Oracle PL/SQL and database Performance Tuning Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan
• Experience in Installation, Configuration, and Administration of Oracle BI Apps 7.9.4, OBIEE 10g/11g standalone, Informatica Power Center 8.1.1/7.1.4.

TECHNICAL SKILLS:

Oracle BI Apps: Oracle Financial Analytics, Spend Analytics, Supply Chain

ERP Modules: General Ledger (GL), Oracle Receivables (AR), HR Modules, Oracle Project Accounting (PA).OFA - Oracle Financial Analyzer

ETL: Informatica/8x/9.X (Power Center & Power Mart) and Ab Initio

OBIA/ Business Analytics Applications/OBIEE: 10.1.3.3.2/3.3 7.7.1, Siebel Analytics 7.x, Admin, Web, Dashboards, Delivers, iBots, BI Publisher

Obiee11g: Upgraded RDP & Web Catalog Objects from Obiee 10 to 11g.

BI Tools: Siebel Analytics 7.7 / 7.5.3,Obiee 10.3.1.4.Hyperian

Siebel CRM: Siebel 99, 5.5 6.x,7.x Siebel Tools and Configuration, Siebel EIM, and Siebel Administration

Database: Oracle 9i/10g,11g, SQL Server, DB2 SQL*PLUS 8.x/9.x, PL/SQL 8.x/9.x, PERL

Oracle Applications: 10.7, Oracle Financials, 11i Visio, Crystal Reports, Forms 4.5,Win Runner, Load Runner, Silk Test, QTP C, C++, Java

Operating System: Windows 95/98/NT/2000/XP, Linux, Digital Unix 4.0, Sun Solaris 2.6 and Main frame environments

PROFESSIONAL EXPERIENCE:

Oracle Business Intelligent Sr Analyst

Confidential

Responsibilities:

• Analyze, Design and Developed BI APPS OBIEE Metadata repository (RPD) that consists of physical layer, multiple business model / layers with aggregates, dimensions & time series objects, presentation layers with catalogs & folders, external table security using session variables, test and validate the model using Obiee Admin tool.
• Develop data warehouses, data marts and other business intelligence solutions for corporate and division
• Business leaders. Participated in all phases of the development lifecycle: gathering requirements, analyzing
• Data quality and business rules, dimensional modeling and database architecture, developing Extract-
• Transform-Load processes and data presentation to the end-user.
• Analyzed business intelligence tools and architectures for the corporate Business Intelligence team.
• Developed data warehouse proto-types to test and determine best architecture and design approach for
• Corporate data warehousing and divisional data analysis and reporting needs. Dimensional modeling selected As the best match to corporate needs and selected MS Sql Server as business intelligence platform.
• Designed and implemented data warehouse architecture for the corporate circulation data warehouse
• That became the standard for divisional data warehouses. Subsequent data marts, extracts and reports were sourced from architecture of conformed facts and dimensions.
• 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.
• Extensively worked on Fact and dimensional tables and slowly changing dimensions.
• Experience in implementing best practices which supports Enterprise Data warehouse, Data Marts and
• Downstream Data integration points.
• Experience in writing SQL queries, Stored Procedures, User defined functions, triggers, Temporary tables,
• Table Variables and used Indexes for accomplishing various tasks.
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies.
• Development of Obiee RDP using MUDE Environment.
• Designed, configured and documented Logical and Physical Data Model and ETL process
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using BI Apps - OBIEE Administration Tool.
• Developed and debugged many Dashboard Reports using different Analytics Views (Pivot Table, Chart, and Column Selector, View Selector, Union Reports, Link Reports Drill downs, Guided Navigation), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Used the security settings in Obiee Admin Tool to set up users, groups, access privileges and query privileges.
• Converted Discoverer reports to BI Publisher Reports, MAPS, Scoreboard etc. and Account Analysis sub ledger report etc
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Developed aggregated fact tables using the content tab and fragmentation.
• Configured Repository and session variables to get dynamic reports and dashboards..
• Created New Subject Areas as per the Business Requirement to convert discoverer reports to Obiee Reports
• Created Materialized views based on the SQL’s which were used to develop discoverer reports
• Added New Dimensions to the Subject Areas to full fill the additional requirements of the Business Analysts
• Configured and extensively used Siebel Delivers, Schedulers and i Bots .
• Migrated RPD & WEB Catalog Objects from dev environment to test and Production Using Catalog Manager
• Visibility with respect to user’s responsibility and web groups in an integrated environment
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Data validation is done from source system to obiee DWH database using sql statements in toad or sql navigator
• Performance Tuning is done both at database level as well as Obiee reports level.
• Database level performance is done co coordinating with Oracle DBA’S like index creating; explain plan, creating stats on long running sql’s etc.
• Involved in bi reports training for end users, business user and higher management like dashboard, answers and publisher (Interactive reports)
• Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, QA, UAT Phases from DWH, ETL, and RPD & Reports - Dashboards.
• Coordinated and worked with different teams like dwh, dba, testing team, functional team, end users, technical architect’s, Obiee Administrator and also off shore teams Etc.

Environment: OBIEE 10/11g/ BI Apps 7.9x, Oracle E-Business Suite 11.5.10/r12/Bi Publisher/informatica 9.X/ Batch processing, PL*SQL scripts, Oracle 10G/11g, Sql’s, PL*SQL, Stored Procedures

Oracle Business Intelligent Sr Analyst

Confidential

Responsibilities:

• Analyze, Design and Developed BI APPS O BIEE Metadata repository (RPD) that consists of physical layer, multiple business model / layers with aggregates, dimensions & time series objects, presentation layers with catalogs & folders, external table security using session variables, test and validate the model using Obiee Admin tool.
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies.
• Created Technical Requirement based on BRD functional document for (Order to Cash, Quote to Cash, GL Eliminations, GL Balances, P*L Account, GL Transactions, Revenue, Receivables), and defining and setting up the modules in relevance to Business process flows at Confidential
• Development of Obiee RDP is done in MUDE Environment.
• Designed, configured and documented Logical and Physical Data Model and ETL process
• Configured and extensively used Siebel Delivers, Schedulers and i Bots .
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using BI Apps - OBIEE Administration Tool.
• Developed and debugged many Dashboard Reports using different Analytics Views (Pivot Table, Chart, and Column Selector, View Selector, Union Reports, Link Reports Drill downs, Guided Navigation),
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Used the Security settings in Obiee Admin Tool to set up users, groups, access privileges and query privileges.
• Converted Discoverer reports to BI Publisher Reports like Account Analysis sub ledger report etc
• Configured Repository and session variables to get dynamic reports and dashboards..
• Created New Connection pool in BI APPS Environment and configure variables in RDP to connect to discoverer reports database scheme.
• Created New Subject Areas as per the Business Requirement to convert Discoverer reports to Obiee Reports
• Created Materialized views based on the SQL’s which were used to develop discoverer reports
• Added New Dimensions to the Subject Areas to full fill the additional requirements of the Business Analysts
• Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Migrated RPD & WEB Catalog Objects from dev environment to test and Production Using Catalog Manager
• Created Qgroup for Object level Security for all the Financial Modules (GL, AR, AP, Disco reports conversion Reports)
• Visibility with respect to user’s responsibility and web groups in an integrated environment
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Since there was existing EDW DWH which was supporting all the other BI Tools like Congo’s etc and obiee bi apps (reports and dashboard) were developed in OBIEE DWH, Management wanted to keep only one DWH and requested to move all the obiee reports and dashboard from OBIEE DWH to EDW DWH, BI APPS RDP was developed from scratch and all the reports and dashboards were migrated to newly Created Subject Area on EDW DWH.
• Involved in bi reports training for end users, business user and higher management like dashboard, answers and publisher (Interactive reports)
• Data validation is done from source system to obiee DWH database using sql statements in toad or sql navigator
• Performance Tuning is done both at database level as well as Obiee reports level.
• Database level performance is done co coordinating with Oracle DBA’S like index creating; explain plan, creating stats on long running sql’s etc.
• Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, QA, UAT Phases from DWH, ETL, and RPD & Reports - Dashboards.
• Coordinated and worked with different teams like dwh, dba, testing team, functional team, end users, technical architect’s, Obiee Administrator and also off shore teams Etc.

Environment: OBIEE 10.1.3.4.2/3.3 7.7.1/ BI Apps 7.9x, Oracle E-Business Suite 11.5.10/r12/Bi Publisher/informatica 9.X/ Batch processing, PL*SQL scripts, Oracle 10G/11g, Sql’s, PL*SQL Stored Procedures

Business Intelligent Sr Analyst

Confidential

Responsibilities:

• Worked with Client for gathering requirements, Identified KPI, Identified Analytics Report requirements and defined ETL Process Flow
• Responsible for gathering Business Requirements, preparation of Business Requirement Specification document and performed Gap and Data Analysis.
• Created Technical Documents based on BRD’s or Functional Documents.
• Created Spread Sheet Documents from Legacy systems to DHW, from DHW to Confidential Application and from Application to Obiee Reports Environment.
• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts
• Installed the Oracle BI Applications(informatica, DAC,OBIEE) on distributed environment and configured the OOB Oracle Financial, HR Prebuilt Analytics and responsible for administration and migration of repositories between various environments
• Responsible for all activities related to the development, implementation, administration and support of ETL processes and for scheduling using DAC and reporting using OBIEE
• Working with Financial Analytics Subject Areas: Financials - AP Balance, Financials - AP Invoice Aging, Financials - AP Overview, Financials - AP Transactions, Financials - AR Balance, Financials - AR Invoice Aging, Financials - AR Overview, Financials - AR Transactions, Financials - GL Balance Sheet, Financials - GL Budget and Expenses, Financials - GL Cash Flow, Financials - GL Detail Transactions, Financials - Profitability -
• Worked with all three layers in the repository - Physical, Business, and Presentation Layer.
• Worked on security for users based on LDAP Authentication type in Production and also other Authentication types (External table authentication and Database) in other environments.
• Implemented the Cache Purging Strategy and usage tracking of Reports
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Added column/data level security at the repository level. The data was restricted with respect to the group user belongs too.
• Created reports according to user requirements and also created corresponding dashboards for the reports.
• Actively involved in deployment and post release support.
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers. Created and converted BI Publisher Reports into OBIEE as interactive dashboards for ad hoc analysis
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector, View Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Created Materialized views for tables which has multiple layer data in database.
• Configured and Developed complex Siebel Delivers, Schedulers and iBots and Automated Alert Process for Bed Movement in Prison Cells
• Data Validation from legacy system data base, DHW database, Application Database and Report Out put
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Debugged Answers, Dashboards, informatica mapping from Source systems
• Implemented security by creating roles & web groups, External tables and LDAP
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment

Confidential,CA

Business Intelligent Analyst

Responsibilities:

• cuments from (legacy systems like YSM CRM, AM, POW to Y CRM Oracle Application Modules like Finance, sales, service, Order Management Modules) for Oracle Bi Apps reporting environments.
• Created Gap Analysis document from Oracle environments to data ware systems.
• Created Technical Documents based on BRD’s or Functional Documents.
• Installed Oracle BI Applications(Informatica, DAC, OBIEE) on distributed environment and configured Oracle Financial, Sales Prebuilt Analytics
• Creating Interactive Dashboards, Answers and Administering Oracle BI Apps Applications.
• Analysis, Design, development and customization of Reports and Dashboards in OBIEE and daily client interaction. Preparation and execution of the test plans.
• Involved in developing the Incremental ETL process i.e., Mappings using various Transformations and Workflows.
• Conducted meetings and Design sessions with Business Analysts from OLTP and OLAP to customization of Oracle Business Analytics warehouse (OBAW).
• Defined and documented the technical architecture of the data warehouse, including the physical components and their functionality.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes and for scheduling using DAC and reporting using OBIEE
• Customized and developed and load data into Financial Analytics Modules, oracle projects, Revenue using DAC Configured DAC - Data warehouse Access control for running of ETL jobs
• Designed, configured and documented Logical and Physical Data Model and ETL process
• Configured and Extensively used Siebel Delivers, Schedulers and iBots.
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Used the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges and query privileges
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Configured charts, pivot table views, filters in user interface. Configured Global Filters and Prompts in Siebel Analytics Web.
• Experienced in deploying Informatica workflows to the DAC and created dependency and dependent hierarchical tasks. Streamlined the Execution Plans with their respective tasks in DAC according to the requirement. Experience in mapping business process activities for data integration solutions.
• Experience in Monitoring Incremental & Full load through DAC and maintaining the loads of Full and Incremental through DAC on different environments like Development, Test environment and Production Environments.
• Hands on experience with DAC in creation of Tasks, Task Groups, Subject Areas, Execution Plan
• Involved in the Custom Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Migration (DAC & Informatica) Repository, Web Catalog and Config files from Dev to Test and Production environment
• Deployment (DAC & Informatica) Repository, Web Catalog and Config files from Dev to Prod
• Debugged Answers, Dashboards, informatica mapping from Source systems
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns
• Implemented security by creating roles & web groups, External tables and LDAP
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Involved with the Testing team to resolve, fixing and testing problems found during the Systems Integration Test, UAT Phases.

Environment: OBIEE 10.1.3.4.2/3.3 7.7.1/ Siebel Analytics/ BI Apps 7.9x, Oracle E-Business Suite 11.5.10Informatica, Batch processing, UNIX Shell scripts Oracle 10G Unix, Informatica 7.X, Autosys - Scheduler, Sql’s, PL*SQL Stored Procedures

Confidential

Business Intelligence Consultant

Responsibilities:

• Worked with Business People for gathering requirements, Identified Analytics Report requirements and defined ETL Process Flow
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics
• Created Technical Requirement based on BRD functional document for (Order to Cash, Quote to Cash) modules, Marketing Analytics and defining and setting up the modules in relevance to Business process flows at AMAT.
• Web Presentation Confidential , Answers, & Interactive Dashboards and Security Implementation.
• Designed, configured and documented Logical and Physical Data Model and ETL process
• Configured and Extensively used Siebel Delivers, Schedulers and iBots.
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Developed many Dimensions and Time Series Objects with Security settings for analyzing
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Used the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges and query privileges.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Configured charts, pivot table views, filters in user interface. Configured Global Filters and Prompts in Siebel Analytics Web.
• Developed aggregated fact tables using the content tab and fragmentation.
• Configured Repository and session variables to get dynamic reports and dashboards
• Added new Dimensions and Columns to the Subject Areas to full fill the additional requirements from Business Analysts. visibility with respect to user’s responsibility and web groups in an integrated environment
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, UAT Phases.