PROFESSIONAL EXPERIENCE

• Around 8 years of progressive experience in the IT industry with prime focus on analysis, modeling, design, development, implementation, testing, documentation, and maintenance of various Business Analytics in an effective way to deliver leading edge software solutions.
• Good experience in designing and developing end- to- end BI solutions according to standard OLAP methodologies using Oracle Business Intelligence Enterprise Edition OBIEE .
• Good understanding of OBIEE Architecture.
• Expertise in design and development of the three layers Physical/Business Model and Mapping/Presentation of an OBI Metadata Repository using Oracle BI Administration Tool.
• Strong experience in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data, and Repository Variables.
• Expertise in creating complex reports in Answers using various views. Extensive experience in using OBI Answers for creating different Requests, Filters, Views, Charts, Interactive Dashboards with page and dashboard Prompts.
• Experienced on Delivers/iBots alerts and administering Web Catalog Objects pages, folders .
• Worked on various OBIEE features like security, cache, usage tracking, dimensional hierarchy, aggregate navigation, variables.
• Expertise in creating projects and working in MUDE environment.
• Good knowledge of BI Publisher to create reports from BI Answers
• Experience in ETL methodology using Informatica Power Center/Mart.
• Experience in using Data warehouse Administration Console DAC to schedule and run Full and Incremental ETL loads, to schedule the Informatica jobs, and to customize Execution Plans
• Well versed with Dimensional Modeling Star and Snow flake to build the Data warehouse
• Involved in Unit Testing and Integration Testing of the application
• Good understanding on KPIS AND KPI Scoreboards
• Good commitment, result oriented, hard working and zeal to learn new technologies and undertake challenging tasks

TECHNICAL SKILLS

Reporting Tool : OBIEE 10g/11g and BI Publisher. OBIA and BI Publisher

Data warehouse Tool : Informatica Power Center 8.6.1/9.x/7.1.2 , DAC.

Databases RDBMS : Oracle 10g/11g,

Languages : SQL PL/SQL, SQL Developer, HTML, XML

Operating Systems : Windows 7/Vista/XP

PROFESSIONAL EXPERIENCE

Confidential

Role : OBIEE Developer

Responsibilities:

• Work with business users to understand the needs and define the requirements, including report definition, conversion and data cleansing rules, design changes to screens and reports, develops user system documentation and provides appropriate user documentation.
• Perform business analyst functions to develop and maintain online reporting to support the data and information needs of internal customers.
• Developing different Sales and Inventory Management Reports.
• Provide technical knowledge to the design and implementation of the enterprise wide business intelligence solutions.
• Create technical design specifications, developing analytical reports, troubleshoot and resolve technical issues, debug, tune and optimize report performance.
• Develop reports, dashboards, and supporting our client's Intelligence platforms and applications
• Working Extensively with Physical Layer, Business Layer and Presentation Layer using OBI Administration Tool.
• To create Connection pools, import physical tables and define joins in the Physical Layer.
• Involving in modeling activities which included building star schema as per the business requirements.
• Creating dimension hierarchies and assigned levels and custom aggregation rules for each level.
• Creating Time Series measures Year ago, Month ago, Year-to-date measures using AGO and ToDate functions.
• Created new logical columns in the BMM layer and created various calculation measures. Implemented Level Based Measures
• Developing Reports / Dashboards with different Analytic Views Drill-Down / Dynamic, criteria filters, Prompts, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using Oracle BI Analytics Web / Oracle BI Presentation Services.
• Configured repository and session variables to get dynamic reports and dashboards.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Created business reports using global and local filters with BI Analytic as per client requirement.
• Created and Managed Object Level, data level security, Hierarchies and tuned running queries to optimize performance.
• Setup Users and granted privileges to access OBIEE Dashboards and Reports for users in the organization.
• Created Users and Groups, and assigned permissions and privileges to Users and Groups in the repository.
• Modified the existing reports and dashboards for enhancement and fixing some of the issues related to performance, data quality etc. during production support activity.
• Worked closely with the business users to identify various KPI's.

Environment: Oracle 11g, OBIEE 11.1.1.7, SQL Developer, OBI Analytics Admin, Answers, Delivers , User Acceptance Testing, Windows 7, HTML,

Confidential

Role : OBIEE Developer

Responsibilities:

• Business requirement gathering, understanding business objectives and analysis.
• Worked Extensively with Physical Layer, Business Layer and Presentation Layer using OBI Administration Tool.
• Reported and Analyzed different key financial elements on the basis of region, by market, by roaming after extracting billing information to GL.
• Develop mappings in Informatica Power Center to extract data from OLTP applications such as Oracle EBS,Oracle BRM, Siebel CRM and load data into Oracle Datawarehouse for reporting in OBIEE.
• Configured Hierarchies, Aggregate columns, Time series wizard in the Admin Tool.
• Created Repository and Session variables in the Admin Tool.
• Creating reports and publishing them in the dashboards using answers.
• Customized and developed repository, configured metadata objects Subject area table column and web catalog Objects Dashboards, Pages, Folders, and Reports.
• Add users to the new group and apply the data level security and object level security at the rpd and Web catalog.
• Involved in the analysis of the existing system reports and modification of the reports, created new reports based on the user requirements.
• Created reports and delivered the same to the end-user through Delivers.
• Created different Views like Table, charts, pivot tables, view selectors, narratives and column selectors.

Environment: Oracle 11.2.0.2, OBIEE 10.1.3.4.2/11g, Informatica Power Center 8.6.1/9.x,

BI Publisher, Web logic, SQL Plus, Oracle SQL developer, Unit Testing.

Confidential

Role: Sr. OBIEE/ETL Developer

Responsibilities:

• Working with the Business users for identifying potential reporting needs that will help them save cost and effort. OBIEE Technical lead and Scrum master.
• Documenting customer requirements use cases translating them into functional and technical requirement specifications.
• Providing project estimates, with gap analysis and proof of concept if required for providing high level swag.
• Conduct OBIEE scrum sessions from requirement gathering phase to Customer acceptance testing.
• Worked with Delivers to create and schedule iBots.
• Preparing mock up designs for OBIEE dashboards and report requirements.
• Involved in developing Mappings and Transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy between source and target using designer.
• Configured DAC Data warehouse Access control for running of ETL jobs
• Used DAC to schedule and run the Full and Incremental ETL loads and to schedule the Informatica jobs.
• Involved in Unit Testing, performance Testing Regression Testing.
• Work with development team to resolve day to day issues and coordination.
• Responsibility for support and enhancements of the application.
• Proactively identifying new reporting requirements that are beneficial to the user community.

Environment: Oracle 10g, OBIEE 10.1.3.4.2/11.1.1.7, Informatica Power Center 8.6.1/9.x,

DAC 10.1.3.4.1, Windows XP, Unit Testing,

Confidential

Role : Report Developer

Responsibilities:

• Installation of Siebel Analytics Standalone 7.8.4 and Siebel Analytics Application 7.8.4 on the designated server.
• Configured and scheduled the DAC to load Siebel eBusiness Application data to Oracle Warehouse for Pharma and Pharma syndicate data Execution Plans.
• Created custom INFORMATICA mappings with the Transformations like Source Qualifier, Filter, Sorter, Aggregator, Expression, Joiner, Connected and Unconnected Lookups, Sequence Generator and Router.
• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Taking backups of Informatica Repository, Analytics Repository and Webcat files.
• Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables when necessary.
• Created objects in Physical, BMM and Presentation layer to be used in Siebel Answers.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Created high level and detail level dashboards for different users in the organization.
• Created various reports to fulfill the marketing needs and customized the views
• Implementation of different views of report i.e. View selector ,Pivot table, Column selector, charts, Narrative etc.
• Scheduled iBots in Siebel Delivers to show alerts on Dashboard.

Environment: Siebel Analytics Platform 7.8.4 , Siebel ePharma Analytics Application 7.8.4 , Informatica Power Center 7.1.2 Designer/ Repository Manager/ Workflow Manager , DB2 OLTP , Oracle 9i OLAP , Oracle SQL developer, .