Professional Summary:

• Over 6 years of experience as OBIEE developer with progressive expertise in design, configuration, development, testing and implementation of Data warehousing and Business Intelligence Applications
• Highly experienced in Oracle Business Intelligence Enterprise Edition OBIEE /Siebel Analytics, Oracle Discoverer Desktop Edition, Plus Edition, Viewer Edition and Admin Edition of Versions 4i, 9i and 10g , BI Publisher Formerly Known As XML Publisher
• Excellent experience in designing OBIEE Dashboards, BI Answers, and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data warehouse.
• Expert in working with MUD Multi User Development environment and Setting up OBIEE Security groups, access , Metadata Objects and Web Catalog Objects Dashboards, Delivers, Reports, Folders .
• Highly experienced in setting up Session Variables and Repository Variables using various Initialization Blocks.
• Highly experienced in working with OBI Answers, OBI Dashboards, BI Publisher and OBI Delivers.
• Expert in working with OBI administration tool developing metadata repository consisting of three layers Physical Layer, Business Model Presentation Layer .
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities and using Dashboard and Page Level Prompts and Filters
• Expert in Complex requirements such as creating Drill Downs, Navigations, Creation of Launch Pads using Narratives and customizing look and feel of OBIEE as per the requirements.
• Extensively worked on Integration of OBIEE with Informatica Data Management in order to show end to end Lineage of Data Elements from Presentation layer and BI Answers of OBIEE to Legacy sources.
• Highly experienced in Data Modeling using Dimensional Data Modeling, Star and Snowflake Schema modeling, Fact and Dimension tables, and Physical and Logical data modeling.
• Experience in Pre-Build, Packaged Oracle Analytics including Financial Analytics, Human Resources Analytics, Spend Analytics
• Knowledge in extracting data from Siebel, Oracle EBS, OLTP, flat files and integration and loading data to OLAP systems
• Hands-on experience in Installing, Configuring and Administration of OBIEE Administration Tool
• Highly experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition.
• Highly Experienced in Training Resources in OBIEE, Discoverer and creating BI Delivery Kits, OBIEE Learning Material and user guides for OBIEE Workshops.
• Excellent Troubleshooting and problem-solving skills.
• Excellent client coordination, experience working closely with them in order to understand their requirements, issues and suggesting relevant solutions.
• Possess effective communication, problem solving, analytical and leadership skills and willingness to learn and master new technologies quickly.
• Excellent Analytical, Communication, and Team Working skills.
• Highly experienced in Effort Estimations, Detailed Analysis of Business requirements and mapping those to technical Requirements.
• Strong work ethics, good time management skills, establish and maintain productive working relationship with management, Clients and team members.
• Clear written, Analytical and oral perception of ideas and concepts. Ability to articulate alternative solutions or workarounds. Ability to listen to superiors and absorb new technological advance.

Technical Skills:

Oracle BI EE 10.1.3.1/3.2/3.3/3.4,Oracle BI Applications 7.9.5/7.9.6/7.9.6.1 DAC, Dimensional Data Modeling Logical / Physical, Informatica 8.6.0/8.6.1/7.1 Oracle 8i/9i/10g/11g, MS SQL Server2000/2005/2008, DB2.Teradata, SQL, PL/SQL, TOAD, C/C , C , Java, Visual Basic, XML, HTML, ASP, JavaScript, Windows 98/00/NT/XP, Redhat Linux, Windows 2000/2003, UNIX, Visio, MS Office, Adobe Acrobat

Professional Experience:

Confidential

Role: OBIEE Developer

The Asset Management team utilizes numerous reports based on Performance, Trades, Security Hub etc., for which OBI is being implemented thus retiring the Actuate e designer tool usage and the Asset Management Portal.

Responsibilities:

• Work in an agile environment and follow the scrum policies
• Analyse and understand the exisiting reports
• Configured connection pool for the database connection in the Physical Layer.
• Designed and Developed Metadata Repository .rpd that consist of physical layer, business model / layers with aggregates, dimensions and Dimension hierarchies, presentation layer with catalogs folders using Oracle BI Administration tool.
• Integrated BI Publisher with OBIEE. Created Templates, Reports, Prompts in BI Publisher
• Schedule reports and bursting as per the requirement in BI Publisher and delivered to user email on daily and weekly basis, represented them on OBIEE dashboards and archived them on share point.
• Worked on analyzing source systems and their connectivity
• Analyzed different options for heterogeneous database connectivity and defined policies for dealing with different source databases with ETL team.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.
• Performed Data Validation including both unit and regression testing of data in the reports and dashboards including the functionality based on requirements and the rpd.
• Performed environment migrations between the Development, Quality Assurance, and Production environments.
• Established and followed processes for OBIEE access requests, new report requests, report changes, and other ongoing maintenance.

Environment: OBIEE 11.1.1.7.1, EAGLE PACE 10.1, Informatica 7.1.1, Oracle 11g, SQL plus, PL/SQL, TOAD, Windows 7

Confidential

Role: Senior OBIEE Developer

Confidential and other digital communication products that enable fast, secure, and efficient communications to any location bringing today's new communication applications to people out of reach of terrestrial networks, in both the commercial and government sectors, with a variety of networking products and services.

Responsibilities:

• Analyzed the business needs to meet the requirements
• Developed different Dashboards/Reports with different views like Calculation, Detailed, Pivot, Charts, Filters using the Presentation services
• Created new reports and trouble shot OBIEE issues at the Report, rpd level and made modifications to existing reports, to meet new needs
• Imported excel file as a data source to the OBIEE tool pulling in static fields
• Implemented Maps on various reports as a drill down object using Oracle Map viewer
• Configured and worked on the MUD environment successfully
• Made required changes and additions to the rpd to meet additional requirements and also to improve the performance of the dashboards
• Built Time-Series calculations using AGO and TODATE functions on BMM Business mapping and modeling layer of repository and TIMESTAMP Functions in the Answers
• Troubleshot the process or production issues and resolved the problems
• Actively participated in the business meets to suggest solutions based on the tool
• Trained the client and users to build reports on tool by conducting sessions individually and also in groups
• Reported the project status to the manager on a daily and weekly basis

Environment: OBIEE 11.1.1.6.6, Oracle Map Viewer, MUD, BI Applications 7.9.6, Informatica 8.6.1, DAC 10.1.3.4, Oracle 11g, SQL plus, PL/SQL, TOAD, DB2, Quality Center, Windows Server 2008 R2

Confidential

Role: Senior OBIEE Developer

Confidential is a financial group which provides finance in various sectors like auto, housing etc. besides many other of its business operations. The project dealt with the finance sector.

Responsibilities:

• Gathered requirements from client or end-users to develop a layout plan
• Designed and developed custom made business intelligence solution according to the plan using BI applications
• Worked with the ETL team to communicate and negotiate data needs
• Prepared, enhanced and configured meta data and data models using OBIEE
• Built interactive dashboards with drill down effect through Oracle BI Answer
• Developed and designed complex data structures, ad hoc queries, reports and analytics
• Developed the repository models and create variables in the repository
• Improvised query performance using SQL Query and filters, thus aiding in smooth operation of the query execution
• Create various reports to meet client requirements pivotal, chart, tabular, drill down, etc. through global and local filters
• Created new reports in BI Publisher and trouble shot OBIEE issues at the Report, rpd and made modifications to existing reports, to meet new needs
• Managed appropriate security privileges on subject areas Data Level and dashboards Object Level according to business requirements.
• Troubleshot the process or production issues and resolved the problems
• Responsible for unit testing, integration testing of the reports generated
• Trained the end users one-one and classroom on reporting using BI Answers
• Reported to the manager with weekly and monthly project status report

Environment: OBIEE 10.1.3.x, Informatica 8.x, DAC, Oracle 11g, SQL plus, PL/SQL, TOAD, DB2, Quality Center, Windows XP.

Confidential

Role: Senior OBIEE Developer

Confidential is a worldwide leader in delivering end-to-end SOA, BPM, Portal and Security solutions and a leading provider of analytic software-based solutions for the security and business intelligence markets.

Responsibilities:

• Responsible for developing OBIEE repository RPD from the scratch. Worked closely with ETL team to understand and implement primary key, foreign key and composition key relationship among physical facts and dimension tables
• Provided content filtering at BMM layer of RPD and used complex joins on logical data source LTS to join tables in BMM layer
• Created and managed different functionalities of Siebel/OBIEE such as Oracle Answers combined reports, action link, Navigation link etc Catalog, Dashboard, Delivers iBots , briefing book etc
• Developed security matrix for enterprise users based on their role and provided role based security using variables
• Developed different Dashboards/Reports with different view Calculation, Detailed, Pivot, Charts, Filters using the Presentation services.
• Automated cache purging process using iBots and configured cache management at various layer i.e. BI server, presentation server, browser etc.. Configured Event Polling for clearing the stale cache
• Created new reports in BI Publisher and trouble shot OBIEE issues at the Report, rpd and made modifications to existing reports, to meet new needs
• Created Primary keys using Sequence Generator and loaded dimension from flat file using source analyzer and Expression builder in Informatica
• Performed Data Validation including both unit and regression testing of data in the reports and dashboards including the functionality based on requirements.
• OBIEE Admin work: New Id creation, Account modification of existing users, Password reset and Deletion of accounts
• Developed various test scripts for business users for UAT and assisted them to use and understand the functionality of the tool
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots
• Developed process for object level migration of web catalog, for post-production release of - enhanced and bug fixed reports
• Worked with the team and a DBA to communicate and negotiate data needs

Environment: OBIEE 10.1.3.x, BI Applications 7.9.6, Informatica 8.x, DAC, Oracle 11g, SQL plus, PL/SQL, TOAD, DB2, Quality Center, Windows XP

Confidential

Role: OBIEE Developer

Confidential offers a robust and flexible suite of services designed to meet each client's needs. With a deep commitment to accuracy and profound attention to detail, they provide comprehensive administration services for employee stock option, restricted stock and stock purchase plans.

Responsibilities:

• Performed Project Scoping, Project Organization and Management including Business IT Requirements, Priorities.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships Foreign Keys Physical Logical between tables
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Experience in BI Applications in development of rpd, data models and integrating with EBS, SFDC for development
• Created Facts like Opportunity, Project for UPP Project Portfolio Subject Area.
• Created Customized Dashboards like Pipeline, UPP Project Portfolio catering to provide insight into the sales / marketing / financial data.
• Built Time-Series calculations using AGO and TODATE functions on BMM Business mapping and modeling layer of repository and TIMESTAMP Functions in the Answers.
• Created different types of Customized Reports Drilldown, Aggregation, Levels to meet business requirements. Generated various Analytics Reports like Formulary Report, Union Report and Direct Sales Report using global and local filters.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards
• Worked on BI Applications on Supply Chain module, Financial Analytics in organizing data and implementing security
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes and managed day-to-day Repository, Scheduler iBots.
• Managing appropriate security privileges on subject areas Data Level and dashboards Object Level according to business requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Integrating and automating Informatica workflow loads using DAC.
• Created tasks and execution plans in DAC and scheduling the ETL run.
• Developed customized mappings, sessions and workflows for some of the Subject Areas, using the Informatica Power Center Designer, Power Center Workflow Manager.
• Created new reports in BI Publisher and made substantial modifications to existing reports.
• Involved in unit testing, integration testing, functional testing to analyze and fix the issues encountered.
• Performed end-user training to develop ad-hoc reports using OBIEE Answers.

Environment: OBIEE 10.1.3.4, BI Applications 7.9.6, Informatica 8.6.1, DAC 10.1.3.4, Oracle 11g, SQL plus, PL/SQL, TOAD, DB2, Quality Center, Windows XP,

Confidential

Role: OBIEE Developer

Confidential is a health information provider, offering services to consumers, employers, health professionals providing health plans to millions of people.

Responsibilities:

• Extensively used Designer to create Mappings, Mapplets using corresponding Sources, Targets and Transformations
• Extracted data from heterogeneous sources, like Relational Databases, Flat files and XML
• Used several transformations such as Look up, Update Strategy, Filter, Router, Expression, and Aggregator in mapping and Mapplets development
• Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Siebel Analytics Repository using Siebel Analytics Administration Tool
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies
• Worked extensively on Siebel Answers, Siebel Delivers, and Siebel Intelligent Dashboards using Siebel Analytics stand-alone/integrated implementation
• Responsible for developing different kinds of reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards
• Configured presentation layer used by different user groups and also established the various standard queries, in order to support the presentation layer
• Created Security settings in Siebel analytics Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in Siebel Answers
• Managed security privileges for each subject area and dashboards according to user requirements
• Used Filters and provided customized prompts filtering options appropriately to avoid excessive data showing up reports
• Worked on the Time Series Wizard and implemented time comparison measures
• Responsible for unit testing, integration testing of the reports generated using Siebel analytics
• Involved in user trainings on the generated reports for this project
• Participated in Post implementation reviews with the Project teams

Environment: Siebel Analytics 7.8.4, Oracle 9i, Informatica PowerCenter7.1.3/8.1, SQL Plus, Windows XP