Experience Summary:

• Over 8 years' experience in OBIEE 10.1.3.4 and OBIEE 11.1.1.6 providing end-to-end business intelligence solutions by dimensional modeling design, building business models, configuring metadata, creating reports and using dashboards.
• Experience in configuring the Repository, creating Transformations and Mappings using Informatica Designer.
• Excellent Data Analysis Skills and ability to translate Business logic into mappings using complex Transformation logics for ETL processes.
• Excellent problem solving skills with strong technical background and good inter-personal skills, Quick learner and excellent team player, able to meet deadlines and work under pressure.

OBIEE/Siebel Analytics:

• Experience in Repository Administration tasks like creating Repository, User groups, Users and managing users by setting up their privileges and profiles.
• Experience in OBIEE Server Administration Tool, Siebel Answers, Siebel Dashboards, Siebel iBots and Siebel Delivers.
• Experience in developing Dimensional Hierarchies/New logical columns/Filters/Variables per business requirements.
• Experience in working on different aspect of OBIEE/Siebel Analytics RPD.
• Expertise in designing and development of Dashboards, Reports in OBIEE.
• Well versed with the Database and Data Warehouse concepts like OLTP, OLAP, Star and Snowflake Schemas, RDBMS, Multidimensional Modeling and ETL.
• Responsible for Customizing, Importing and Exporting of DAC metadata.

Data Warehousing:

• Designing and developing business solutions in Data Warehousing / Decision Support Systems using ETL tools, Informatica Power Center.
• Worked on Informatica tools Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Experience in configuring the Repository, creating Transformations and Mappings using Informatica Designer.
• Excellent Data Analysis Skills and ability to translate Business logic into mappings using complex Transformation logics for ETL processes.
• Experience in performance tuning of sources, mappings, targets and sessions.
• Efficient in trouble shooting, performance tuning, and optimization of ETL and reporting analysis.
• Wide working knowledge in the Dimensional Data Modeling with Star/Snowflake Schemas using Erwin, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and Logical data modeling.
• Expertise in PL/SQL procedures, Functions, Packages Database Triggers.

Technical Skills:

• Operating Systems: Linux, UNIX, Windows7/2003/2000 Server, XP Professional.
• Business Intelligence: Oracle Business Applications 7.9.4, OBI EE-Dashboards, Answers/
• Analytics, IBots/Agents, BI Publisher.
• Tools/ Methodologies: MS Office, MS Visio, MS Project, Agile, RUP Rational Unified
• Process .
• Databases: Oracle 11G/10G/ Informatica, SAP, Oracle OLAP, MS Access.
• Database Office: MS Office Enterprise, XML publishing, MS Excel, MS Word Tools.
• Languages: SQL PL/SQL

PROJECTS:

Confidential

OBIEE Developer:

---------------------------------------------------------------------------------------------------------------------

Responsibilities:

• Involved in Requirements gathering, Analysis, Design, Development and Implementation of the project
• Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
• Created Hierarchies, Levels and implemented Business Logic by creating level based measures in OBIEE business model mapping layer.
• Implementing the cache Management for improving the OBI Server performance.
• Developed different kinds of Reports pivots, charts, tabular, Column Selector, Narrative view using global and local filters.
• Created Session Repository Variables to achieve desired functionality.
• Created different types of Customized Reports Drilldown, Aggregation to meet Business requirements.
• Implemented Basic Security and OBI server Authentication security mechanisms for implementing Object level, Data level and Time period level.
• Create alerts based on Oracle Business Intelligence Reports and Dashboard results.
• Worked on Initialization Blocks and Variables development to achieve security and personalization.
• Worked on performance tuning of various OBIEE Reports / Dashboard.
• Based on Business reporting requirements analyzed the data and created reports in Answers.
• Applied the different Formatting, Styles conditional formatting to Reports.
• Testing the reports against data.

---------------------------------------------------------------------------------------------------------------------

Confidential

Oracle BI Consultant

Responsibilities:

• Effectively interacted with the end users and involved in meetings with team members for requirement gathering and defined requirement specifications document.
• Effectively interacted with the end users and involved in meetings with team members for requirement gathering and defined requirement specifications document.
• Develop mappings in Informatica Power Center to extract data from OLTP applications such as Oracle EBS, Oracle BRM, Siebel CRM and other legacy systems such as MSA and load data in to Oracle Data warehouse for reporting in OBIEE.
• Worked extensively with Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Created and Managed Object Level, data level security, Hierarchies and tuned running queries to optimize performance.
• Created business reports using global and local filters with BI Answers as per client requirement.
• Setup Users and granted privileges to access OBIEE Dashboards and Reports for users in the organization.
• Was responsible in migrating Informatica workflows and OBIEE RPD and dashboards.
• Monitored Incremental Full loads in DAC.
• Configured Usage Tracking, proxy user in OBIEE.
• Customizing the out of box ETL, Reports and Dashboards in OBI Apps for Siebel, Oracle EBS applications to fulfill company's reporting needs.

---------------------------------------------------------------------------------------------------------------------

Confidential

Siebel Analytics Consultant /Informatica Developer

Responsibilities:

• Worked with functional technical leads, marketing, sales, finance, and other business groups to identify, analyze, and document requirements.
• Designed and Development of Siebel Analytics Metadata Repository .rpd with multiple business layers using complex joins, presentation catalogs with access validations and external table security repository and repository migration.
• Designed and developed the many Performance Measurement Dashboards/Reports that are Dynamic Interactive with intuitive drilldowns, drill-across flash-based drillable charts bar-charts, pie-charts, radars, and bubble-charts , Capabilities split reports for summary details information, and local global filters and cache monitor using Siebel Analytical Web. Used Siebel Delivers and iBots.
• Security management for users, groups and web-groups using the various authentication systems Database table, Session Variable features, Dashboard / Report-level security .
• Benchmarked performance tuning strategies with business model-level calculations versus database level pre-computations and aggregations.
• Development complex Informatica mappings and mapplets to build key interfaces using various transformations for loading data into Data Warehouse.