Summary: 
Over Eight years of Industrial Experience as IT professional with over seven years of experience as Oracle BIEE Developer and experience in gathering Business Requirements , performing GAP Analysis, Design / Data Modeling, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence using agile development techniques. Monitoring ETL routines through DAC on different environments like Development and Test environment.

• Experience in working with OBIEE Applications includes,
• RPD Development (physical, Business Mapping & Modelling, presentation Layers).
• Dashboard Development and security.
• Developing Dimensional hierarchies, Expression builder, Timeseries wizard, Calculation wizard.
• Aggregate Navigation-Creating aggregate tables using materialized views.
• Multiuser development, Merging and Importing Objects from different repositories.
• Experience in migrating metadata and web catalogue between different environments.
• Expertise in Clustering, Load Balancing, Configuring delivers & iBots.
• Expertise in Cache management, performance tuning at report level & database level.
• Experience in setting up a Multi-User Development Environment (MUDE).
• Experience in Installation, development, administration & production Support of OBIEE.
• Experience ininstalling and configuring Oracle BI Applications (Informatica, DAC, and OBIEE) and integrated with Oracle EBS.
• Expertise in configuration of Oracle BI Analytics Repository (Execution Plans, Subject Areas, Containers, Design, Setup, Execute etc.,), Create/Manage Intelligent dashboards.
• Experienced in prebuilt and customized OBI Applications like Financial, Sales, Marketing, Pharma, Workforce analysis HR, Order management Analytics.
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expertise in OBIEE- SECURITY- SSO- LDAP-- OID, External Table, OBJECT level Security, ROW level Security using INIT Blocks. Experience with Federated Query tuning strategies.
• Detail understanding of OLTP and OLAP Data models to create and manage the repository with the available metadata OBIEE.
• Experience in Data Analysis and Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data Modeling using Erwin.
• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
• Developed Delivers iBots/Scheduler to automate report delivery and provide alerts on Interactive Dashboards.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
• Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills. Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms and Ability to learn and adapt to new technologies

Technical Skills Summary:

Business Intelligence Enterprise Edition (BIEE) platform 11g, 10.x, Siebel Analytics 8.x/7.x

Oracle 11g,10g, 9i

High Availability
Performance Tuning

SQL Server 2005,2008 
Microsoft Access

Windows 7/XP 
DOS 
Solaris

Informatica 8.x , 9.0
Star schema
Snow Flake
SDLC
Oracle Enterprise Manager (OEM)
Oracle SQL developer
SQL*Plus

SQL*Loader 
ER-Modelling
Object Oriented Analysis and Design

Programming Languages

SQL
PL/SQL
HTML / XML
UDML
Java / JavaScript

Software Packages

MS Office Suite 
MS Project 
MS Visio 
MS FrontPage

Education: 
Bachelor of Information Technology 

Professional Experience:

Client: Confidential, Charlotte , NC April \'11 – Present

Role: OBIEE Developer

Confidential provides a comprehensive line of banking, brokerage, insurance, investment, mortgage, and trust and payment service. OBIEE Platform Solutions was implemented for providing interactive Dashboard access to strategic business information on services, finance and various features of the Bank, top of the house from the company-wide data warehouse analytical information in mortgage at Bank Of America, a nation-wide leading financial services company. .

Responsibilities:

• Involved in Gathering, Analyzing Business Requirements for Reports.
• Created/Modified Metadata repository (.rpd), Customized BI Repository, defined/developed Physical Data Layer, Business Model and Presentation Layer using BI Administration Tool.
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Development of interactive flash-based drillable charts such as bar-charts, pie-charts, radars, bubble-charts, etc using BI Server.
• Implemented Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones.
• Involved in Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Implemented event polling cache refresh strategy to cache reports and improve performance of long running reports.
• Developed/Bench-Marked performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations.
• Expertise in Creation of Subject areas and Developing Reports .
• Involvement with ETL (Extract-Transform-Load) development team to communicate the specification for the required dimensional, aggregate and indexed data tables.
• Implemented different Passive and Active transformations like Source Qualifier, Joiner, Aggregator, Lookup, Rank Expressions, Update Strategy and Stored Procedure Transformations in Mappings.
• Environment: OBIEE 11.1.1.3.0, 10.1.3.4.1, Oracle BI Publisher 10.1.3.4.1, Oracle 10g, , SQL Developer,Oracle Application Server 10.1.3.

Client: Confidential, Louisville, KY Jul \'10 - March \'11

Role: OBIEE Developer 

Confidential is the nation\'s leading distributor of wound care, bariatric and safe patient handling equipment and solutions to healthcare facilities nationwide. It is committed in helping Customers to reduce cost, streamline operations, and improve patient outcomes. OBIEE Platform Solutions was implemented for providing interactive Dashboard access to strategic business information on services .This Project is involved in managing their sales.

Responsibilities:

• Requirement Gathering, functional and technical specifications and writing requirements and interface with end users.
• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business model and mapping and presentation layers of metadata repository.
• Created and modified repository file and modeled data in physical and BMM layer using physical and complex joins.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed Business models to represent business logic for Sales and created logical tables and defined the complex joins for a business model.
• Created dimension hierarchies for balanced and unbalanced hierarchies and assigned shared levels to respective hierarchy trees.
• Developed measure and dimension based aggregates to improve query performance and custom logical columns and calculated measures using expression builder.
• Created presentation catalogs with restricted access to various business users.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) for performing the Marketing Trends analysis using Oracle BI Presentation services.
• Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Configured iBots to deliver analytics content based on schedule, automated iBot queries to obtain weekly reports & sent notifications Alerts to Managers.
• Worked Extensively on Answers to create the reports as per the client requirements.
• Worked with various Market Forecasting subject areas and resolved various issues.
• Edited the download options to restrict public access of data from Dashboards to users worldwide.
• Developed Informatica mappings with re-usable transformations and Mapplets using various Transformations (Update Strategy, Filter, Router, Expression, Lookup, and Aggregator) for implementing MA System.

Environment: OBIEE 10.1.3.3.1, , Oracle 10g, Toad, Erwin, Oracle BI Publisher 10.1.3.4.0.

Client: Confidential , Boston, MA Oct \'09 - Jun \'10

Role: OBIEE Developer

This application was developed to provide better decision in sales analysis for their sales department. The project was on Sales department, developing reports for measuring sales activity of products. It involved in customizing Sales Application for this company. The company implemented reporting system by using OBIEE, Informatica and Oracle.

As part of the project responsibilities, developed reports for measuring sales activities of products. The project also involved customizing internal Sales Application with integrated reporting through OBIEE, Informatica and Oracle.

Responsibilities:

• Gathering requirements, Analysis, functional and technical specifications, interacting with Business Managers and End users.
• Using admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
• Worked on layer to customize the tables, hierarchies, dimensions and aggregations and calculations.
• Used aggregate persistent wizard to aggregate data at higher level for performance tuning.
• Implemented various Repository Variables and System Variables depending up on user requirements.
• Created transformations like Expression builder, joiner, and router.
• Utilized various building blocks like calculation measures, time series measures, initialization blocks, session and repository variables, fact tables, dimension tables, dimension hierarchies.
• Designed various reports i.e. Pivot, Narrative and Chart reports in Answers and Configured Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and Charts.
• Giving security permission / privileges as per the role of each user.
• Developed custom dashboards and reports using OBIEE Answers.
• Scheduling the Developed reports according to Client requirements.
• Tested and validated the repository, reports and dashboards.

Environment: Siebel Analytics 7.7, OBIEE 10.1.3.3.1, BI Applications 7.9.4/7.9.5, Informatica Power centre 8.x/ 9.0.1, Windows XP, and Oracle10g, SQL Server 2005/2008

Client: Confidential., Miami, FL Aug \'07 - Sep \'09

Role: OBIEE Developer 
The company is the supply chain manager for the Burger King system and the exclusive purchasing agent for the vast majority of products and distribution services used by RSI’s members. I was involved in the development of Market Measurement reportstosupport their market forecasting.
Responsibilities:

• Requirement Gathering, functional and technical specifications and writing requirements and interface with end users.
• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business model and mapping and presentation layers of metadata repository.
• Created and modified repository file and modeled data in physical and BMM layer using physical and complex joins.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed Business models to represent business logic for Market Measurements and created logical tables and defined the complex joins for a business model.
• Created dimension hierarchies for balanced and unbalanced hierarchies and assigned shared levels to respective hierarchy trees.
• Developed measure and dimension based aggregates to improve query performance and custom logical columns and calculated measures using expression builder.
• Created presentation catalogs with restricted access to various business users.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) for performing the Marketing Trends analysis using Oracle BI Presentation services.
• Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Configured iBots to deliver analytics content based on schedule, automated iBot queries to obtain weekly reports & sent notifications Alerts to Managers.
• Worked Extensively on Answers to create the reports as per the client requirements.
• Worked with various Market Forecasting subject areas and resolved various issues.
• Edited the download options to restrict public access of data from Dashboards to users worldwide.
• Developed Informatica mappings with re-usable transformations and Mapplets using various Transformations (Update Strategy, Filter, Router, Expression, Lookup, and Aggregator) for implementing MA System.

Environment: OBIEE 10.1.3.3.1, Informatica 8.6, Oracle 10g, Toad, ERWin.

Client: Confidential, Deerfield, IL June \'06-July \'07

Role: OBIEE Developer

Confidential deals about the lead contract data systems and heads can accurately forecast future business; risks involved & accordingly generate customized proposals to their Leads. Analytics application helps all center heads and top Management & business leads to analyze & compare forecasts vs. revenue\'s and helps them to plan & implement improved strategies for a profitable business

Responsibilities:

• Created reporting metrics and transfer key performance indicators to a process and database design.
• Create/Modify Metadata repository suiting to company’s data requirements by using OBIEE tool.
• Created connection pools, physical tables, schema folders and catalog folders in the physical layer of the repository.
• Defined Primary key-Foreign key relationships, complex joins bridge tables between dimension tables and Fact tables in the physical layer.
• Created dimension sources for each level of aggregated fact data and specified aggregate levels for each source.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Created Aggregate tables and fragmented fact tables for efficient query performance.
• Analyzed and recommended enhancement to metadata reporting in all three layers (Physical Business and Presentation).
• Extensively used filter, update, lookup, expression, router and sequence generator transformations.
• Defined the refresh extraction logic based on the last updated column in the Transactional Tables.
• Created workflows for the Initial load and refresh load.
• Created mappings to populate the aggregate, hierarchy and helper tables.
• Involved in the integration testing and unit testing the data. Identified bugs during the testing phase and fixed them.
• Tested and Validated the Repository before making it available for queries.
• Configured query cache to reduce the cost of database processing and reduce the Server processing overhead.
• Defined session variables for users to enhance data level security.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Responsible for making the end users understand the features of Answers.
• Worked Extensively on OBIEE Answers to create the reports as per the client requirements.
• Created and modified the request, modified the result layout and added filters to them according to the need of end-users.
• Configured I-Bots to deliver analytics content-based alerts as per user requirements.

Environment: Oracle Business Intelligence 10.1.x, , Oracle 9i/10g, PL/SQL, Sql server.