Summary:

• Result Oriented IT professional with over 10+ years of progressive expertise in analyzing the requirements, application design, development, testing and a comprehensive background in Database development and Data Warehousing and Business Intelligence.
• Experienced in Full Systems Development Life-Cycle Implementation of Various Oracle/OBIEE Projects.
• Worked on the upgrade of reports from 10.1.3.4 to 11.1.15 and fixed all the issues.
• Managed and Resolved the issues which occurred in 11g BI Server
• Worked on MUD Environment and moved the repository to Development, Test, QA and Prod and managed these environments.
• Expertise in Siebel Analytics 7.x, OBIEE 10.1.x, OBIEE 11.1.x, Informatica, developing Metadata, Repositories, Dashboards and Reports. Scheduling and Monitoring Informatica ETL on different environments like Development and Test environment.
• Involved in working closely and effectively with a variety of Business/Technical analysts and a Variety of Business users to meet their Business Objectives.
• Experienced in Pharmaceutical, Insurance, Financial and Marketing industries.
• Good Analytic and Statistical Exposure to create Reports, Proficient in building analytical repository, presentation layer, business models, generating reports, and creating dynamic Dashboards usingOBIEE.
• Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers / IBots, creating reports / Dashboards, cache monitor, and building Siebel Analytics Repository using Siebel Analytics/OBIEE.
• Experience in implementing security in OBI using Repository Variables, Initialization Blocks, and Session Variables.
• Expertise in Creating Filters, Global Prompts in Dashboards, Presentation Variables, and Narrative Views to filter the data.
• ImplementedData Level Security, Object LevelSecurityand LDAP authentication.
• Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports) and setting up office integration for BI publisher.
• Worked in the integration of Essbase 9.3.1 with OBIEE to enable reporting on top of OLAP cubes and accomplish slicing and dicing of data.
• Worked on implementation of Data Warehouse, BI solutions and a strong understanding of Data Warehouse concepts, ETL, Star Schema, Data Modeling, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Experienced in Extracting Data from different source Systems i.e. Oracle, SQL SERVER, Flat Files, Excel etc.
• Experienced in Design, Development, Implementation, Testing and Maintenance of Oracle Databases, ETL Processes and Database Deliverables.
• Good Knowledge in Oracle PL/SQL Packages, Procedures, Functions, Triggers and other objects.
• Excellent Self Driven project management skills, Team Player, Good communications, Presentation and Telephony skills.

Technical Skills

BI Tools : OBIEE 10.1.3.3/Siebel Analytics 7.7, Oracle BI Publisher Delivers (IBots), BI Apps 7.9.5, 7.7.1.
ETL Tools : ETL Tools: Informatica Power Center 8.x/7.x/6.x/5.x.
Operating Systems : MS Dos, Win 95/98, NT 4.0, Win 2000, Win XP, UNIX.
RDBMS : Oracle10g/9i/8i/8.0/7.x, MS SQL Server 2000/2005,DB2,Essbase.
Languages : C, SQL, PL/SQL, UNIX Shell Scripting.
Methodologies : Data Modeling – Logical/ Physical / Dimensional, Star / Snowflake, Complete Software Development Life Cycle, Fact and Dimension Tables.

PROFESSIONAL EXPERIENCE

Confidential May 2012 – Till Date
Role: OBIEE Consultant San Diego

Responsibilities:

• Interacted with Business users and involved in gathering the business requirements and explained to the offshore team
• Made sure the work done by them matches requirement and tested with many test data
• Create Logical tables and data source mapping and Presentation Layer level-create presentation catalogs., test and validate the model depending on the changing Business requirements.
• Developed the Dimensions and Time Series Objects in the Business Model and Mapping Layer with Security settings using Basic RPD Authentication to setup groups, access and query privileges.
• Performed Data Warehouse analysis and identified the required Facts, Dimensions, Levels / Hierarchies of Dimensional and referential joins.
• Devised a model plan to implement the analytical repository from an Oracle Business Intelligence perspective.
• Designed and developed Analytics Metadata Repository (.rpd) using Oracle BI by importing the required objects with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies), Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Developed many Accounting and Collection Time Series objects for comparing the Billings, Collections and Adjustments between the different time frames.
• Developed fully interactive dashboards for mobile professionals while disconnected from the network i.e. Oracle BI Disconnected Analytics.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of Analytics that includes (.rpd, Dashboards, Security etc.).
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Siebel Analytics Repository.

Environment: Oracle BIEE 10.1.3.4.1, Oracle 11g, PL/SQL, DB2, Windows, UNIX

Confidential Dec 2010 – April 2012
Role: Sr. OBIEE Consultant Atlanta, GA

Responsibilities:

• Interacting with Business users and involved in gathering the business requirements.
• Experience in 11.1.1.5 from the time of tool released in the market. Have extensive knowledge about the latest release of the BI and working from the very beginning.
• Get data from SAP BW Cubes and import the cubes to rpd and develop reports.
• Oracle figured out most of the issues with the help of us in improving their product to work better with SAP BW Cubes
• Still working with Oracle in resolving the issues
• The latest release 11.1.1.5 support Hierarchies. This version gets the hierarchy like the same as cubes.
• Figured out how to pass variables from cubes to OBIEE. Version 11 support Variables too.
• Expert in figuring the issues with BW cubes and resolving them with the help of work around solution and oracle.
• Did the cross join of two subject area. One cube coming from SAP BW and other from SQL Server. Did the mapping in OBIEE and successfully completed the report.
• Modified the OBIEE RPD at 3 layers i.e., Physical Layer- connecting Data sources and import schema, Business Model and mapping- create Logical tables and data source mapping andPresentation Layer level-create presentation catalogs., test and validate the model depending on the changing Business requirements.
• Extensive Experience in Oracle Data warehouse/ OBIEE in various Projects in different versions of the tools.
• Developed reports and Dashboards in OBIEE Answers, Dashboards.
• Used the Catalog Manager and maintained the Analytics Web Catalog to manage Dashboards, Answers.
• Developed different kinds of Reports with different views like Pivots, View Selectors, and Column Selectors.
• Proficient in Reports with drill-down capabilities using page and dashboard prompts and other Web Catalog Objects such as Filters, Folders, iBots & BI Publisher reports.
• Involved in providing user based security for viewing reports.
• Upgraded the reports from 10g to 11g environment
• Resolved all the issues which occurred during the up gradation.
• Worked on MUD Environment and moved the reports to Development, Test, QA and Prod and managed the reports.
• Managed the BI Server in 11g resolved the issues which occurred with it.
• Extensively used Oracle BI Delivers to create Agents (ibots) and todeliver the reports in a scheduled manner.
• Involved in Performance tuning of reports/dashboards as well as metadata repository using optimization efforts such as re-organizing the data, cache management.
• Interacted with ETL team and contributed my role in developing reusable and non-reusable mappings, source and target definitions using informatica power center.

Environment: OBIEE 10.1.3.4.1, 11.1.1.3, 11.1.1.5, SAP BW Cubes, PL/SQL, DB2, Windows, Unix

Confidential July 2009 – Nov 2010 
Role: OBIEE Consultant Kansas City, MO

• Performed Requirement Gathering, Gap Analysis, Change Management, Data Model Design,
• Analyzed and used various data sources (Oracle Applications, POS log, etc)
• Used the OBIEE 10.1.3.4, 11g Administration tool to develop and enhance Data Model. Configured and createdOBIEE Repository, Involved in modifications of physical, business and presentation layers of metadatarepository using OBIEE Administration Tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layerof the repository
• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built BusinessModel and established relationships & Foreign Keys (Physical & Logical) between tablesidentified the aggregate levels for measures and created dimension hierarchy sources for each level ofaggregates for performance enhancement.
• Created executive level Reports and Dashboards catering to provide insight into the sales / marketing /financial data.
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet businessrequirements. Generated various Analytic Reports like Formulary Report, Union Report and Direct SalesReport using global and local filters.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specificdashboards
• Developed complex and rich Reports using pivots tables, charts, and view selector. Used global and localFilters for data abstraction.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.
• Managed day-to-day Repository, Scheduler & iBots.
• Involved in managing appropriate security privileges on subject areas (Data Level) and dashboards (ObjectLevel) according to business requirements. Managed security privileges for each subject area in Repositoryand Web Catalog according to user requirements. Created groups in the repository and added users to thegroups and granted privileges explicitly and through group inheritance.
• Reduced Cost of the Project by Implementing Complex Custom secure id verification process, based onMicrosoft Active Directory, LDAP Server and Custom Database Table that permitted access to appropriatelevel of data; Instead of Oracle Single Sign On or Third Party Authentication Piece.
• Performed Performance Tuning of Oracle BI Server by complex Cache Management StrategyInteracted with business and daily operations to generate operating and provisioning reports.
• Interactive Dashboards were configured with drilldown capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
• Designed and tested reports in the dashboards for HR analytics and financial analytics modules and created Ad-hoc report according to the client needs.
• Worked closelywith Systems Team, Application Team, Business Users, Business Analysts, Development Teams and DBAs.
• Involved with business process design, configuration, testing, quality analysis and productionsupport for Oracle BIEE.
• Used Debugger to troubleshoot the mappings.
• Migrated some of the minor reports to 11g as the Upgrade is implemented by Consulting Company.
• Fixed few minor upgrade issues such as broken filters etc.
• Performance tuning of Dashboard/Reports and made changes to database were done.
• Performed Unit, Integration and Regression testing to validate report and mapping functionality.
• Working closely with users/developers and administrators to resolve the production problems byreviewing design changes.
• Performed Project Scoping, Project Organization and Management including Business & IT Requirements,Priorities, Project Execution Plan and Resource Plan.

Environment: Windows XP/7, OBIEE 10.1.3.4/11g, OBI Apps 7.9.6(HR Analytics, Financial Analytics), BI Publisher, Oracle 10g/11g, SQL Server 2005/2008, Oracle Application 11.1.1.3

Confidential May 2008 – Jun 2009
Role: Sr. OBIEE Developer Oakland, CA

Responsibilities:

• Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository (.rpd).
• Worked with business analyst and users (Financial Advisors or FAs) to gather analytical requirements and created the business model using star schemas.
• Worked with System Engineering team to design Facts, Dimensions and Hierarchies of the business model.
• Designing and developing physical and logical star schema using OBIEE admin tool.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Import/create tables and add/change physical joins/keys.
• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Modified presentation layer dimensions and attributes to match user requirements.
• Creating global filters, complex queries, prompts, reports (charts, tables, graphs) in Answers.
• Setup and administered Usage Tracking using the direct insert process.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Configured repository and session variables to get dynamic reports and dashboards.
• Used Catalog Manager to maintain Analytics web catalog to manage Dashboards and Answers.
• Used the Security settings in Oracle BI Admin Tool to set up SSO, users, groups, access privileges and query privileges.
• Peer review of code, testing, monitoring NQSQuery and tuning reports.
• Designed, developed and documented multiple interfaces using the Informatica Power Center.
• Developed Informatica mappings and mapplets to build key interfaces using transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into data warehouse.
• Analyzed data processing modules and identified areas of enhancement and improvements. 
  Maintained the ERP system in order to ensure it provides the company with proper business solutions and accurate results.
• Handled improvements of ERP systems as well as system upgrades and software updates.
• Conceptualized reporting systems interfaces to be more suitable for easy administrative controls.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying mappings.
• Performance tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.

Environment: OBIEE 10.1.3.2, BI Publisher, Siebel Analytics 7.8, Informatica 8.1, DAC 7.8.5, BI Publisher, SAP, SQL Server 2005, Oracle 10GR2, Windows XP.

Confidential Jul 2007 – Apr 2008 Role: Sr. OBIEE Developer Architect/ETL Developer Arizona

Responsibilities:

• Gathered business users reporting requirements and prepared the requirement specifications document.
• Performed Dimension modeling, Identify Fact tables & Measures, Identify Dimension Tables to store business attributes, Identify Aggregate tables & their definitions.
• Analyze, Design and Developed CP/CR Analytical Metadata repository (.rpd) as per the data requirements that consists of physical layer, multiple business model/layers with dimensions & time series objects, presentation layers with presentation catalogs, External table security using session variables.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).
• Configured & published Delivers / iBots to deliver analytics content based on schedule, automated iBots queries to obtain daily & weekly transactions by Emails.
• Developed many Mappings using various Transformations (Update Strategy, Router, Expression, and Aggregator) for extracting, transforming and loading the CP/CR data.
• Created many Oracle Materialized Views to fasten slower queries with complex joins.
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug the SQL query issued during report execution.

Environment: Siebel Analytics 7.8, Informatica 6.2, Oracle9i, TOAD, Windows server 2000, MS Office,DB2.

Confidential Nov 2005 - June 2007 
Sr. Siebel Analytics/Informatica Developer New Jersey

Confidential is one of the world’s largest Pharmaceutical /Health Care companies with offices all over the world. The project was on the extraction of data from Siebel and other Systems and building the common operational data store (ODS) for the company. It periodically assesses and prioritizes various risk areas that may affect the company’s operations and the general operations of the Compliance Program. As a result, they regularly review and do necessary refines to the several fundamental elements that define its Compliance Program. Siebel Analytics was implemented to match Call Contact and Sales Objective mappings to meet the Business Requirements.

Responsibilities:

• Worked closely with Business Analyst in understanding the analytics requirements and creating the business models for generating reports as per the requirements.
• Worked closely with the data modeler in designing the logical data model/physical data model (star schema).
• Prepared the ETL Mapping spreadsheet and Fact Dimension Matrix simultaneously prior to performing the ETL process.
• Assisted the ETL team in regards to schema and data model design
• 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 for Compliance department 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.
• Responsible for unit testing, integration testing of the reports generated using Siebel analytics.

Environment: Siebel Analytics 7.8, Informatica 6.2, Oracle 9i, Windows XP