Summary:

• Over 7 years of IT experience in Data warehousing and Business intelligence with emphasis on Requirement Analysis, Application Design, Development, implementation and maintenance of client/server Data Warehouse and Data Mart systems .
• Oracle certification in Oracle Business Intelligence Foundation Suite 11g for developers.
• Over 6 years of experience in providing end-to-end business intelligence solution. Using OBIEE11g/10g, Siebel Analytics, Data Warehousing, Data Modelling, OBIA, Informatica, DAC.
• Strong Experience in configuring metadata and building OBIEE Repository consisting of three layers Physical Layer, Business Model Presentation Layer .
• Experience in Installation and Configuration of OBIEE 11.1.1.6 . Also involved in the upgradation of OBI10g rpd and webcatalog to OBIEE 11g version.
• Hands on experience in configuring and developing the Analytics/OBIEE repository .rpd , which involves Schema Import, Implementing the Business Logic by customization, Dimensional hierarchies, Aggregate navigation, Level Based Measures, security Management Object level security , Variables, Initialization blocks, Cache Management, MUDE, Merging techniques, Writeback, Ibots utilities, subject areas etc.
• Strong Experience in designing Star Schema, Snowflake Schemas and Multi Dimensional modeling methodologies using OBIEE Analytics Administration tool.
• Configured Answers ad-hoc querying, reports , Interactive Dashboards with drill-down capabilities charts/tables/graphs , Delivers/iBots alerts and administered Web Catalog Objects pages, folders .
• Worked Extensively in Creating Users, Groups, and Initialization Blocks in Oracle Admin Tool and Security using LDAP.
• Experience with BI Publisher for development and documentation of reports.
• Proficient in Security Implementation and Adminstrative activities.
• Experience with ETL processes using Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Proficient in ETL process of creating Source/Target definitions, building Mappings/Mapplets using various Transformations, monitoring creating Sessions/Workflows.
• Monitored the DAC jobs /tasks which ran on nightly basis and involved in fixing the issues while any task failed.
• Configured DAC Email notification for completion and failure of Execution plan
• Expertise in Creating Dynamic Interactive Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting, Drill Thru, Drill Up.
• Expertise in working with Marketing Analytics in OBI Apps
• Expertise in OLTP/OLAP system study, analysis and E-R modeling. Extensive experience with E-scholar Data model i.e fact and dimensional tables.
• Strong conceptual background of RDBMS and access methods SQL.
• Complete knowledge of data ware house methodologies Ralph Kimball, Inmon .
• Immense ability to effectively provide technical documentation.
• Independently handled application development and modifications.
• Excellent problem solving skills with strong technical background and good inter-personal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICIAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. OBIEE Developer

Environment: OBIEE 11.1.1.6.2, Oracle 11i, Weblogic server, SQL Developer, Moodys Analytics Tool, Version One Tool.

• Gathered user requirements and reporting requirements Functional and Non functional requirements by interviewing business users and BSAs and understanding the current reporting system.
• Acquired good functional knowledge of BASEL, Pillar III Reporting, FFIEC Reports and Risk weighted assets RWA .
• Performed Impact Analysis between existing model, database tables, RPD, webcatalog and Business Process Requirements and recommended enhancements to Metadata Reporting in all 3 layers Physical, Business and Presentation .
• Created documentation around Technical Design, Data Mapping, Data Modeling and Unit testing.
• Worked on developing OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Created business facts, dimensions and defined logical relation between them at the Business model and mapping layer.
• Created hierarchies Ragged/Skipped , levels, and implemented business logic by creating level based measures in OBIEE business model mapping layer.
• Identified and created aggregate tables to improve query performance.
• Created time series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Worked on Repository merge, Patch merge, comparison, project creation techniques in MUDE Multi User Development Environment OBI 11g.
• Created Presentation Variables to achieve desired functionality.
• Created many reports/Ad-hoc queries and dashboards with different analytics views drill-down/dynamic, pivot table, chart, column selector, with global and local filters using Oracle BI Presentation Services.
• Customized reports look and feel using column formatting, conditional formatting. Defined additional views compound, table, chart views of the data returned by the request to visualize data in many different ways.
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Managed the security by creation of users and groups in Enterprise manager and assigning Application role with the required permission to the groups.
• Implemented Object level security for different login users in the Application .
• Configured Ad-hoc and Canned reports in BI Answers according to the end users requirements.
• Involved in POC for development of BI Publisher Reports.
• Worked on Cache purging strategy using Cache purging techniques.
• Developed procedures for ETL process and scheduled it in CTRL M as jobs.
• Worked on procedures, views, materialized views, partitioning, indexing at DB levels.
• Created unit test case scenarios and tested the Reports/ Dashboards by comparing the SQL Output on the Data Warehouse to the values in the Reports/Dashboards
• Worked closely with users, ETL team and DBAs to resolve ongoing problems by reviewing changes made to the systems and made corresponding changes to Repository.
• Prepared the migration deliverables DB objects, RPD, webcatalog files and worked in the deployments of the code to Dev, QA and PROD environments.

Confidential

Sr. OBIEE Developer

Environment : OBIA 7.9.x, Informatica Power Center 8.x, Data warehouse Administration Console DAC , Oracle10g , SQL developer, Siebel CRM

• Worked on Impact Analysis with respect to the existing model, mappings, workflows, RPD, web catalog and environment infrastructure.
• Updated the Technical Design Document Functional Design Document as per the Enhancement Requirements.
• Developed the RPD with star schema model using the Conformed dimension, Facts, LTS Logical table source . Also, defined the aggregation rules on the measures.
• Worked on scheduling of ibots which involved delivering weekly reports to the End user's inbox.
• Customized reports look and feel using column formatting, conditional formatting. Defined additional views compound, table, chart views of the data returned by the request to visualize data in many different ways.
• Worked on OBIEE Skin and style customization like addition of Client Logo, Clients default portal URLs and color coding of the reports.
• Developed basic BI Publisher reports and embedded them on the OBIEE Dashboards.
• Worked on SDE mappings between source - stage and SIL mappings between stage target.
• Standardized data to store various Business Units information in tables.
• Involved in developing the Incremental ETL process by Informatica Mappings Mapplets using various Transformations.
• Worked with Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer, Mapplet, Designer, Mapping Designer, Repository manager.
• Developed a Dimensional model that identifies the fact table Grain, Associated dimensions, Attributes, and Hierarchical drill paths.
• Developed Informatica mappings using transformations like Lookup, Stored Procedure, Filter, Expression, and Aggregator.
• Monitored the DAC jobs /tasks which ran on nightly basis and involved in fixing the issues while any task failed.
• Configured DAC Email notification for completion and failure of Execution plan.
• Worked extensively on complex SQL queries.

Confidential

BI Developer

Environment : OBIEE 10.1.3.x , TOAD 7.0, Siebel CRM

• Extensively worked on OBIEE components including the repository and web catalog.
• Imported DB tables to the Repository and configured the Connection Pool in the physical layer.
• Created Physical joins, logical joins and complex joins in physical and BMM Layer between the dimensions and facts tables.
• Implemented additional Dimensional Hierarchies and build metadata around new custom dimension facts table. Confirmed the new fact tables to the existing dimension tables.
• Worked on setting up log level for different login users.
• Created OBIEE intelligent answers, dashboards and customized dashboard reports using drill-down capabilities .Extensively worked with complex reports.
• Customized reports look and feel using column formatting, conditional formatting.
• Enhanced the subject areas as and when suggested by the business analysis.
• Facilitated in data loads from Siebel transactional application to OBIEE Analytics application .
• Implemented Write Back functionality in the OBIEE reports as per the Business requirement .
• Customizing Dashboards with prompts and reports.