We provide IT Staff Augmentation Services!

Obiee Developer Resume

RI

OBIEE Developer

Professional Summary:

  • Over 7+ years of experience as software developer that includesOBIEE 10.1.3.x, Oracle BI Applications 7.9.x, Siebel Analytics 7.7.
  • Experience in building and configuring repository, creating and managingOracle/SiebelIntelligent Dashboards, Oracle/Siebel Answers, Oracle/Siebel Delivers and Oracle/Siebel iBots.
  • Experience in configuring Interactive Dashboards withdrill-drown capabilitiesusing 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 forOBIEE/Siebel Analytics Projects.
  • Experience in Data Warehousing development andETL methodologyusingInformatica 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 (gatheringBusiness Users Requirements, Analysis, Design & Modeling, Development, and Testing) of Business Intelligence usingOBIEE (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 configuringInteractive Dashboardswithdrill-down capabilitiesusing global and local Filters,Siebel Security Setup (groups, access / query privileges),Metadata Objects and Web Catalog Objects(Dashboard, Pages, Folders, Reports).
  • Experienced inInformatica 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 creatingWorkflows with Worklets& various Tasks and scheduling them using both Workflow Manager and Unix Shell scripts.
  • Highly proficient inDesign, Development, Implementation, Administration and Supportof ETL processes for Data Marts and large scale Data Warehouses usingInformatica 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 betweentechnicalandbusiness processskills. Able to interact with users and business owners, while still maintaining a deep technical competency to interact with technical teams.
  • UsedDAC (Data Warehouse Administration Console)Client to manage, configure, customize, and monitor ETL process.
  • GoodAnalytic and Statistical Exposureto 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:

  • UsedOBIEE Administration Toolfor customizing and modifying thePhysical, Business Model/MappingandPresentation layers of metadata repository (.rpd).
  • Worked with System Engineering team to designFacts, Dimensions and Hierarchies.
  • Designing and developing physical and logicalstar schemausing OBIEE admin tool.
  • Import/create tables and add/changephysical joins/keys.
  • Creatingcomplex joins/keys, setting levels to supportDrill-down, Aggregation/Sum overcolumns.
  • Modified presentation layerdimensions and attributesto match user requirements.
  • Creatingglobal filters, complex queries, prompts, reports (charts, tables, graphs)inAnswers.
  • Used theexpression builderutility to createnew logical columnsin theBMMlayer and created variouscalculation measures.
  • Setup and administeredUsage Trackingusing the direct insert process.
  • Configuredinteractive dashboardsby adding embedded content such as links/images, HTML objects and folders.
  • Configuredrepositoryandsession variablesto get dynamic reports and dashboards.
  • UsedCatalog Managerto maintainAnalytics web catalogto manage Dashboards and Answers.
  • Used the Security settings inOracle BI Admin Toolto set upSSO, users, groups, access privilegesandquery privileges.
  • Peer review of code, testing, monitoringNQSQuery and tuning reports.
  • Built custom reports for the field representatives and other mobile users usingDisconnected Analytics.
  • Developed custom dimensions and facts in the business model usingSiebel Pharmaout of the box schemas.
  • Worked withDisconnected Applicationmanager tosynchronizepresentation catalog and repository.
  • DevelopedInformatica mappings and mappletsto build key interfaces using transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into data warehouse.
  • Optimal utilization ofobject-reusabilityfeatures likereusable transformations, mapplets, copying objects from other repositories, usingvariable/parametersfor simplifying mappings.
  • Performance tuning of Informatica data warehouse loads, includingInformatica Server Managerand PL/SQL procedures.

Environment:OBIEE 10.1.3.4, Informatica 8.1.1/7.1.4, OBI Apps 7.9.4, DAC, Flat Files, Oracle10g, 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 theSiebel Analytics Admin Toolto develop the 3 layers in the Repository.
  • Created connection pools, physical tables and definedPrimary keyForeign key joins, complex joinsin the physical layer of the repository.
  • Builtprototype reports from excel spreadsheetsduring the requirement-gathering phase to visualize the reports and clarify requirements.
  • Created and modifiedlogical tables, logical columns and defined Foreign-keys and complex joins.
  • Createddimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.
  • Customized/createdpresentation layercatalog folders, to show different views of the business model to different users and assignedgroup permissionsto the catalog folders.
  • Worked extensively onSiebel Answersto create the reports as per the client requirements.
  • CreatedMappings, Sessions and Workflows by using Informatica.
  • Worked extensively developedDashboards and Reportsso 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 includingguided navigational linksanddrilldowns.
  • Createdglobal filtersfor 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 likeRouter, Update Strategy, Lookup, Filter, Aggregator, and Expressionfor the exact results according to Business Requirements.
  • UsingWorkflow Managerfor 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 theCatalog managerand maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
  • Worked on improving thedashboard performance, readability, andsecurity.

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

Confidential, MAFeb06- 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 ofSiebel Analytics server/repository, Informatica server/repository, DAC client/server.
  • Configured out-of-the box and customAnalytics/Dashboard reportsusing Siebel Answers.
  • Involved in designing and development of buildingPhysical Layer, Business model and presentation layer.
  • Designed and built Siebel Analytics data model, designed and customizedStarandSnowflakeschemas by extendingFactandDimensiontables.
  • ImprovedETL performanceby removing unused batches, rearranging batches by dropping and recreating indexes.
  • Installed and configuredOracle 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 fromSiebel Analytics 7.7.2toOBIEE 10.1.3.2.
  • Developeddata maintenance strategywhich included proven data standard rules.
  • ImplementedSecurityby creatingroles, web groups, external tablesandLDAP.
  • Developed delta/incremental complex Informatics ETL process and Oracle Packages i.e.,MappingsandMappletsusing various transformations.
  • Implemented the session partitions, forPerformance Tuningof 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 aSiebel Analyticsrepository.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
  • Developed custom reports/Ad-hoc queries usingSeibel Answersand assigned them to application specificdashboards.
  • Developed different kinds ofReports(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 inDesignandData ModelingusingStar schema.
  • Designed & assisted Informatica ETL developer to create new Aggregate.
  • CreatedInformatica mappingsfor initial load and daily updates.
  • Developed several mappings to load data from multiple sources to data warehouse.
  • Developed, testedStore procedures, FunctionsandpackagesinPL/SQL for Data ETLand 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 buildInteractive Dashboardswithdrill-downcapabilities.
  • Involved in analysis and design of data model (Star Schema).
  • Configured and developedSiebel Analytics Metadata Repository(RPD) with multiple business layers using various complexes joins presentation catalogs with access validations andExternal 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.
  • CustomizedDashboards, Administered permissions and privilegesfor 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 securityand 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.

Hire Now