SUMMARY

• Around 8 years of experience in gathering Business Requirements, Assessing Developing Business Intelligence Program Strategies, Designing and Implementing Business Intelligence Information and Analytical Solutions
• Extensive experience in the areas of Data Warehousing concepts and report development.
• Experience in developing and maintaining Oracle Business Intelligence Repository RPD all three layers Physical, Business Model Mapping, and Presentation in OBIEE 11g/10g.
• Extensive experience in developing Interactive Dashboards with drill-down capabilities, security implementation and views Creating groups, grant access privileges, data level and report level , Metadata and Web Catalog Objects pages, folders and reports and scheduling reports using BI Delivers.
• Experience in implementing Performance Tuning using Cache Management, Aggregates, Log-level management.
• Experience in maintaining OBIEE security using Light Weight Directory Access Protocol LDAP .
• Experience in developing BI Publisher Reports using customized and organization specific templates.
• Good experience in upgradingcustom repositories and migrating reports between OBIEE versions OBIEE 10g to 11g .
• Experience working with new features Key Performance Indicators KPI watch lists and KPI scorecards in OBIEE 11g.
• Experience in Creating Dimensional Hierarchies, Level Based Measures, Time Series Functions, Initialization Blocks and Variables depending upon the need for business reports using the OBIEE Admin tool.
• Experience with BI Publisher to create pixel format reports as per business requirement.
• Experience in Dimensional Modeling, identification of Facts and Dimensions, creation of schemas STAR , documentation of Report and Dashboard layouts, and end user demo/documentation for business/report users.
• Good experience working with OBIEE 11g new features like Archive Un archive in analytics, Action Links, Reusability Action Links, Master Detail Report and Condition.
• Experience in ETL and data integration in developing ETL mappings usingInformatica Power Center using Designer, Repository Manager, Workflow Manager Workflow Monitor.
• Experience in customization of OBAW. Experience in implementing oracle applications for Financial analytics/HR.
• Experience in merging RPDs
• Familiar with development of data model design .
• Experience in developing PL/SQL codes.
• Thorough knowledge of various Transformations involved in informatica mappings and familiar withperformance tuning of ETL mappings.
• Experience in migrating RPD and Web Catalog from 10g to 11 g.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Sr.OBIEE Developer

Confidential

Responsibilities:

• Experience in creating and managing multiple Logical Table Sources.
• Effectively managed ODBC connections and connection pools and imported the Physical tables, keys, views.
• Responsible for developing OBIEE repository RPD from the scratch using the best practices for the three layers.
• Worked closely with Business Users, involved in discussing and gathering the analytic requirements from different user groups
• Worked closely with ETL team to understand and implement primary key, foreign key relationship among physical, business and presentation layers.
• Extensively worked on physical, business and presentation layers
• Provided content filtering at BMM layer of RPD and used complex joins on logical table source LTS to join tables in BMM layer.
• Implemented multiple fact tables along with conformed and non-conformed dimensions.
• Created custom metrics based on the existing facts and dimensions as requested by the customers with appropriate aggregation rules.
• Mapped multiple physical tables to logical tables using LTS and set the content level accordingly
• Developed various Measures using logical column, also created Level-Based Measures.
• Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
• Utilized the dimension hierarchy in the form of setting the preferred drill path to meet the user required reports.
• Provided Object level security in the presentation layer.
• Configured Row Level Security by creating initialization blocks to allow users to view their respective data only.
• Involved in implementing LDAP security for the project.
• Developer various dashboards and created prompts to dynamically choose the reports and filter the reports.
• Worked on Oracle BI Answers to develop complex and rich Reports using pivots tables, charts, Column Selector, and view selector.
• 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 in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Created nested folders in presentation layer for more neat Subject Area.
• Involved in developing reports using BI Publisher using data model and template.
• Utilized the BI Publisher tool functionality for creating pixel perfect reports and report templates.
• Developed Logical Dimensions with Drill-Down Hierarchies, developed reports using OBIEE and published them using dashboards.
• Worked on OBIEE Delivers and Configured iBots to deliver Analytics content based on schedule.
• Built the Usage tracking reports to track the most used reports and tune accordingly.
• Migrated Repository and Catalog between environments like Dev, Test, QA, maintenance and Performance.
• Implemented data level and object level security to meet the user requirements.
• Worked on Presentation Catalog to set permissions according to the application roles.
• Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.
• Extensively used Oracle Delivers and iBots so as to provide alerts.

Environment: OBIEE 10.x/ 11g, Oracle 10g, BI Publisher, SQL,PL/SQL,SQL Plus,,Oracle EBS 7.9.6.3 ,DAC,ETL

OBIEE/BI Apps Consultant

Confidential

Responsibilities:

• Worked on OBIEE Delivers and Configured iBots to deliver Analytics content based on schedule.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Developed Dashboard pages like AR Balance,Payments Due,Invoice Details and All AR Transactions in Receivables Dashboard.
• Developed Dashboard pages like Liquidity,GL Balance,Cash Flow and Balance Sheet in General Ledger Dashboard.
• Worked on Monthly cash flow payable turnover reports
• Customized the Rpd by adding new tables and columns to the physical layer.
• Worked extensively in Oracle BI Security, Web Object Security and Data Level Security.
• Participated in business requirement gathering meetings with analysts and lead members.
• Worked on Supporting Oracle BI Apps Finance Analytics OBIA reporting initiative which involves customizing out of box rpd and report objects as well as scheduling data loads to warehouse using DAC.
• Design,and development and testing of analysis, dashboards, kpi, scorecards are done as per the requirements in Financial analytics General Ledger, Account payables, Receivables and operations and HR analytics Absence, Compensation, Performance, Recruitment and workforce profile using OBIEE 11g.
• Actively participated in the process of Data warehousing like extracting raw data from source systems OLTP and transformed it into desired pattern and loading it to the warehouse OLAP .
• Created custom folders to modify the existing mappings.
• Customized the OOB Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts And Dimensions.
• Used ETL processes to load data from Flat files, Oracle Databases into the target OLAP databases.
• Customized ETL mappings such as added new columns and new tables. Registered them in the DAC.
• Worked on DAC for creation of Tasks, Task Groups, Subject Areas, Execution Plan to configure, monitor and schedule ETL routines
• Developed Mappings using corresponding Source,Targets and Transformations like Sequence Generator,Source Qualifier, Router,Filter, ,Joiner, Lookup, Expression, Aggregator and Update Strategy.
• Assigned and executed the workflows full and incremental load to the DAC, to schedule the execution plan through DAC.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console DAC and Informatica WorkFlow Monitor.
• Involved in developing the Incremental ETL process i.e., Mappings Mapplets using various Transformations and Workflows with Sessions Tasks.
• Involved in customizing out of the box reports to support the business requirements
• Modified the existing formulas in the expression builder to meet the user defined requirements and developed new reports accordingly.
• Developed complex reports by using different views like Table, Pivot, Chart, view selector and column selector and combined with similar requests.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.
• Configured Row Level Security by creating initialization blocks to allow users to view their respective data only.

Environment: OBIEE 11g, Informatica 9.x, DAC 10G , OBIA 7.9.6.3,Oracle EBS R12 E-Business Suite ,SQL developer,SQL,PL/SQL.

OBIEE Consultant

Confidential

Responsibilities

• Participated in the unit, functional, integration as well as user acceptance testing UAT once the code development is completed.
• Worked along with the migration team to ensure there are no hiccups during the code migration between development, testing and production environments.
• Developed Ibots to send reports to the customer team on a weekly basis.
• Involved in troubleshooting and debugging of report errors and metadata inconsistencies.
• Developed various reports using different views Pivot, Graph, narrative, view selector, column selector etc .
• Performed security on a level of objects in presentation layer.
• Designed dashboard and page level prompts.
• Used implicit fact column in presentation layer in order to get the user required data in reports.
• Configured Ibots to deliver analytics content based on schedule.
• Performance of the reports was done by using various techniques both at Rpd and data base level.
• Implemented guided navigation within reports.
• Created dimensional hierarchy and developed level based measures.
• Used filters global and local and provided prompts to avoid excessive data showing up in the reports.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Working along with the ETL developers on the data loading process to ensure that the final data in the warehouse meets the reporting requirements. granularity, dimensions and facts etc
• Accordingly tested RPD and reports after upgrading RPD and web catalog. Verified the difference between 10 g and 11 g features and accordingly tested and fixed the errors and warnings in higher version.
• Worked extensively on both OBIEE 11.1.1.5 11g also called version 11 and 10.1.3.4 10g and migrated reports from 10g to 11g.
• Mapped different database sources like Oracle 10g and Teradata from multi server environment to OBIEE.
• Developed the business models and subject areas in the Repository level and reports and dashboards in the presentation services as per the business needs.
• Worked closely with the business and technical team to understand requirements for the development of the project.
• Coordinating with the ETL developers as the warehouse is updated on a weekly basis in the initial stages.
• Involved in intensive end user training both Managers and business users in Presentation Services with excellent documentation support

Environment: OBIEE 10.x/ 11g, Oracle 9i/10g,Teradata, SQL,SQL Developer

OBIEE Developer

Confidential

Responsibilities:

• Worked right from the earlier stages of reporting like the requirements gathering, designing tables in the warehouse, pulling them into the OBIEE administrator tool, creating business models in rpd files and developing reports in the presentation side.
• Involved in Query Tuning to maximize the performance of reports and Dashboards.
• Utilized catalog Manager to create web catalog documentation and admin tool to create reposiory document for understanding the data lineage of reports.
• Performed Data Validation of data in the reports.
• Managed security privileges for each subject area and dashboards according to the requirements.
• Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.
• Developed calculated measures and assigned Aggregation levels based on dimension hierarchies
• Utilized procurement and supply chain modules for reporting strategies.
• Created Dimensional Hierarchy, Logical columns, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer.
• Analyze, Design and Developed OBIEE Metadata repository RPD and validated the RPD using check global consistency before deploying.
• Successfully implemented OBIEE delivers/Created Proactive agents iBots and configured Interactive dashboards to alert the Business/Field users as per the requirements.
• Created and modified Intelligence Dashboards and Guided Navigation Links within Intelligence Dashboards and drill through reports for Summary, detail and Aging analysis
• Developer templates and reports in Oracle BI Publisher in rtf format.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards answers.
• Implemented OBIEE security for users and groups using external table authentication.
• Once the development is complete, testing and validating of data across reports, migration of catalogs across DEV, QA environments.
• Actively participated in testing of OBIEE code along with our senior consultants.

Environment: OBIEE 10.1.3...3.1,Oracle 10g, Informatica 8.6, SQL, PL/ SQL

Jr.BI Developer

Confidential

Responsibilities:

• Worked with the ETL team to design the star schema.
• Worked Informatica Power Center tools - Source Analyzer, warehousing designer, Mapping Designer and Mapplets, Transformations, Work Flow Manager Task Developer, Worklets and Work Flow Designer and Work Flow Monitor.
• Extensively used Siebel Analytics Administration Tool for creating and modifying the physical, business modeling and mapping, and presentation layers of the repository.
• Worked Informatica Power Center tools - Source Analyzer, warehousing designer, Mapping Designer and Mapplets, Transformations, Work Flow Manager Task Developer, Worklets and Work Flow Designer and Work Flow Monitor.
• Worked with the ETL team to design the star schema.
• Working with data modelers before implementing the data model and giving inputs about the required indexes, constraints, foreign key relationships etc
• Developed back end interfaces using PL/SQL packages, stored procedures, collections, object types and triggers
• Worked in Physical layer, Business layer, Presentation layers according to business Requirement.
• Created requests in Answers added filter prompts formatted views and charts.
• Created Dashboard prompts global filters and combined similar requests in Siebel Answers..

• Used Administration tool to develop and enhance meta-data, repository RPD .
• Developed Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters .

Environment:Informatica 7.1.3,Siebel Analytics/OBIEE 10g.x, SQL Server 2000.