OBIEE Developer

Professional Summary:

• Over 7+ years of experience as software developer that includes OBIEE 10.1.3.x, Oracle BI Applications 7.9.x, Siebel Analytics 7.7.
• Experience in building and configuring repository, creating and managing Oracle/SiebelIntelligent Dashboards, Oracle/Siebel Answers, Oracle/Siebel Delivers and Oracle/Siebel iBots.
• Experience in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, Siebel Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Extensive experience of creating star schema for OBIEE/Siebel Analytics Projects.
• Experience in Data Warehousing development and ETL methodology using Informatica 8.1.1/7.1.
• Expertise in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & various tasks and scheduling them using both Workflow Manager.
• Experience with complete Lifecycle (gathering Business Users Requirements, Analysis, Design & Modeling, Development, and Testing) of Business Intelligence using OBIEE (Siebel Analytics).
• Experience in specifically focused IT, reporting strategy and design, with a strong focus on Business Intelligence and analytics.
• Translating high-level business requirements into logical business dimensional model; Defining various logical subject areas and organization ofPresentation Layer metadata; Understanding and defining key metrics, dimensions, hierarchies and attributes.
• 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 OBIEE (Siebel Analytics)Repository using OBIEE (Siebel Analytics).
• 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).
• Experienced in Informatica Data Integration Tools - Repository Manager, Designer, Workflow/Server Manager, and Workflow Monitor.
• Expertise in Developing Mappings, Mapplets and different Transformations between Source and Target using Informatica Designer.
• Experience in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & various Tasks and scheduling them using both Workflow Manager and Unix Shell scripts.
• Highly proficient in Design, Development, Implementation, Administration and Support of ETL processes for Data Marts and large scale Data Warehouses using Informatica Power Center 8.x, 7.x and implementing OBIEE platform (Formerly Siebel Analytics).
• Experience in extracting data from Siebel, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems.
• Excellent balance between technical and business process skills. Able to interact with users and business owners, while still maintaining a deep technical competency to interact with technical teams.
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize, and monitor ETL process.
• Good Analytic and Statistical Exposure to create Reports, Proficient in building analytical repository, business models, generating reports, and creating dynamic Dashboards using Oracle BI Analytics.

Technical Skills:

• Operating Systems: MS-DOS,Windows XP/2000/NT, UNIX, Linux
• Packages: MS-Office, Adobe
• Programming Languages: C,C++, SQL, SQL*Plus, PL/SQL, UNIX shell scripts, Java
• Databases: Oracle 8i/9i/10g, MS Access, SQL Server
• Reporting Tools: Oracle's Siebel Analytics 7.5.x/7.7.x/7.8.x, OBIEE 10.1.3.x, Oracle BI Apps 7.9.x
• ETL Tools: Informatica Power Center 8.1.1, 7.1, 6.2, 5.1,DAC 7.8.5v
• DB Tools: TOAD 7.x, SQL Plus 10.x/ 9.x/ 8.x, ODBC
• Dimensional Data Modeling: Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimensions Tables, Logical and Physical Data Modeling.

Education:

• B.tech from Confidential, India.

Work Experience:

Confidential, RI Oct 08 - Till date
Role: Sr. OBIEE Developer /ETL Developer
Scope of the project includes the development of data which contains an operational data store from different source databases, an enterprise warehouse that stores historical transaction level data. Development of ETL processes to load historical and current data and development of subject specific data marts that store summary data to feed the reports. Familiarization with existing reporting, understanding the business requirements and replicating existing reports from a new ledger environment.

Responsibilities:

• Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository (.rpd).
• Worked with System Engineering team to design Facts, Dimensions and Hierarchies.
• Designing and developing physical and logical star schema using OBIEE admin tool.
• 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.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• 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.
• Built custom reports for the field representatives and other mobile users using Disconnected Analytics.
• Developed custom dimensions and facts in the business model using Siebel Pharmaout of the box schemas.
• Worked with Disconnected Application manager to synchronize presentation catalog and repository.
• 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.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, usingvariable/parameters for simplifying mappings.
• Performance tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.

Environment: OBIEE 10.1.3.4, Informatica 8.1.1/7.1.4, OBI Apps 7.9.4, DAC, Flat Files, Oracle 10g, UNIX, Windows XP, SQL server 2000, MS Office 2003, TOAD

Confidential, FL June 07 - SEP 08 
Role: Sr. OBIEE Developer /Informatica Developer
The purpose of this project is to maintain and manage all possible distribution scenarios including commission payments of Sales Reps. for internal, external and third party clients. The reporting requirements are handled using Siebel Analytics.

Responsibilities:

• Used the Siebel Analytics Admin Tool to develop the 3 layers in the Repository.
• Created connection pools, physical tables and defined Primary keyForeign key joins, complex joins in the physical layer of the repository.
• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on Siebel Answers to create the reports as per the client requirements.
• Created Mappings, Sessions and Workflows by using Informatica.
• Worked extensively developed Dashboards and Reports so as to meet the Functional Requirements.
• Defined additional views (compound, table, chart views) of the data returned by the request to visualize data in many different ways.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Created global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Created Proactive agents (iBots) and configured Interactive dashboards to alert the employees as per the requirements.
• Used various Transformations like Router, Update Strategy, Lookup, Filter, Aggregator, and Expression for the exact results according to Business Requirements.
• Using Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Formatted columns used in generating the requests and used various filtering options as and when needed.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• Worked on improving the dashboard performance, readability, and security.

Environment: OBIEE 10.1.3.2, Siebel Business analytics 7.8, Informatica 7.1, Oracle 10g, UNIX, Windows XP, PL/SQL developer.

Confidential, MA Feb06- Apr07
Role: Siebel Analytics developer
The purpose of project was to analyze the data warehouse and to change the data loading part from PL/SQL to Informatica along with this,organization and integration of the data from multiple channels into data warehouse the core was reports and for analysis of customer receivables, order entry and sales analysis with revenues cost and budget through Siebel Business Intelligence Reporting system.
Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Involved in installation, configuration and administration of Siebel Analytics server/repository, Informatica server/repository, DAC client/server.
• Configured out-of-the box and custom Analytics/Dashboard reports using Siebel Answers.
• Involved in designing and development of building Physical Layer, Business model and presentation layer.
• Designed and built Siebel Analytics data model, designed and customized Star and Snowflake schemas by extending Fact and Dimension tables.
• Improved ETL performance by removing unused batches, rearranging batches by dropping and recreating indexes.
• Installed and configured Oracle Business Intelligence Suite (OBIEE 10.1.3.2) in development environment to explore the new features like enhanced Data Mart automation, Microsoft Office integration, BI Publisher, Improved Data Visualization and End User Personalization.
• Developed strategy for migration from Siebel Analytics 7.7.2 to OBIEE 10.1.3.2.
• Developed data maintenance strategy which included proven data standard rules.
• Implemented Security by creating roles, web groups, external tables and LDAP.
• Developed delta/incremental complex Informatics ETL process and Oracle Packages i.e., Mappings and Mapplets using various transformations.
• Implemented the session partitions, for Performance Tuning of Informatica sessions by running parallel sessions and re-arranging the session's dependencies.
• Environment: OBIEE 10.1.3.2, Siebel Analytics 7.8/7.7.2, Informatica 7.1, Oracle 9i/10G, TOAD, PL/SQL, ePharma, Windows 2000.

Confidential, India Jan 2004 - Nov 2005
Role: Siebel Analytics developer 
Description: This Project was developed for inventory control. The system contained master details like item, quantity on hand, expiry date, last issue date etc. The daily transactions like receipts/purchases issue, purchase returns and issue returns were entered. Item master is updated, so the stock status can be viewed at any time. Reports were generated.
Responsibilities:

• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer in a Siebel Analytics repository.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Configure and interactive Dashboards to alert the Marketing team about business changes.
• Managed day-to-day Rpd, Siebel Delivers, Scheduler & iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Involved in Design and Data Modeling using Star schema.
• Designed & assisted Informatica ETL developer to create new Aggregate.
• Created Informatica mappings for initial load and daily updates.
• Developed several mappings to load data from multiple sources to data warehouse.
• Developed, tested Store procedures, Functions and packages in PL/SQL for Data ETL and also performed Data conversions.

Environment: Siebel Analytics 7.7.4, Informatica 7.0, PL/SQL, Oracle 8i/7i, MS Access, Windows 2000, UNIX Shell Scripting.

Confidential, India May 2002 - Dec 2003 
Role: Siebel Analytics developer 
Description: Siebel Call Center data was moved to SQL Server Data Warehouse using Informatica. This data was for reports generation and business analysis. Siebel Analytics was used for data analysis & Report Generation. This was to reduce response time and load on Online Servers of Siebel.
Responsibilities:

• Customized and developed RPD, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Configured measures in the Logical Layer and mapped to multiple logical source tables.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
• Involved in analysis and design of data model (Star Schema).
• Configured and developed Siebel Analytics Metadata Repository (RPD) with multiple business layers using various complexes joins presentation catalogs with access validations and External Table Security.
• Implemented Analytics Data level Security by creating Groups and setting up content filters in the repository.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users.
• Performed query optimizations / tuning in physical layer as well on database.
• Developed many Dashboards using drill-down capable as well split reports for summary and details information.
• Administered security and created alerts.
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.

Environment: Siebel Analytics 7.0, SQL Server 2000, Oracle 8i/7i, Windows 2000.