We provide IT Staff Augmentation Services!

Sr Obiee Developer Resume

Winsdor, CT

Summary:

  • Result Oriented IT professional with 7+yearsof progressive expertise in analyzing the requirements, application design, development, testing and a comprehensive background inOracle Business Intelligence (OBIEE) 11.1.1.5/Siebel Analytics 7.9.x with 3 full life cycle implementations.
  • Expertise inInstallation and Configuration of OBIEEon various platforms of AIX/Windowsanddeveloping Metadata, Repositories, Dashboards and Reports. Scheduling and Monitoring InformaticaETLthroughDAC.
  • Involved in working closely and effectively with a variety of Business/Technical analysts and a Variety of Business users to meet their Business Objectives.
  • GoodAnalytic and Statistical Exposureto create Reports, Proficient in building analytical repository, presentation layer, business models, generating reports, and creating dynamic Dashboards usingOBIEE.
  • Extensive experience in providingend-to-end business intelligence solutionby dimensional modeling design, building business models, configuring metadata,Answers, Delivers / IBots, creating reports / Dashboards, cache monitor, and building Siebel Analytics Repository usingSiebel Analytics/OBIEE.
  • Experience in implementing security in OBI usingRepository Variables, Initialization Blocks, and Session Variables.
  • Expertise in CreatingFilters, Global Prompts in Dashboards, Presentation Variables, andNarrative Viewsto filter the data.
  • Experienced in working withDACdesign and development including Customizing Execution Plan, Subject areas, Tables groups and Task definitions.
  • ImplementedData Level Security,Object LevelSecurityandLDAP authentication.
  • Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters,Siebel Security Setup(groups, access / query privileges), Metadata ObjectsandWeb Catalog Objects(Dashboard, Pages, Folders, Reports) andsetting up office integration for BI publisher.
  • Worked in theintegrationofEssbase9.3.1 withOBIEEto enable reporting on top ofOLAP cubesand 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 inExtracting Datafrom different source Systems i.e. Oracle, SQL SERVER,Flat Files, Exceletc.
  • Experienced in Design, Development, Implementation, Testing and Maintenance of Oracle Databases, ETL Processes and Database Deliverables.
  • Ability to create templates for OracleBI Publisher, and deploy those templates to an Oracle e-Business Suite instance.
  • Good Knowledge in OraclePL/SQLPackages, Procedures, Functions, Triggers and other objects.
  • ExcellentSelf Driven project management skills, Team Player, Good communications, Presentation and Telephonyskills.

Certification

Oracle certified professional on Introduction to Oracle 9i

Technical Skills

ETL Tools :Informatica Power Center 8.6.1/7.x/6.x/5.x.
BI Tools: OBIEE 11G ,OBIEE 10.1.3.4/Siebel Analytics 7.7, Oracle(IBots),BI Apps 7.9.5, 7.7.1,OBIEE
Operating Systems :MS Dos, Win 95/98, NT 4.0, Win 2000, Win XP,AIXUNIX.
RDBMS :Oracle 11g/10G/9i/8i/8.0/7.x,MS SQL SERVER 2008/2005, SQL/PLSQL
Languages:C, SQL, PL/SQL, UNIX Shell Scripting.
Web Servers :Apache, IBM Web Sphere, Web Logic, and IIS
Modeling Tools:Erwin, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential , Winsdor CT Jan 12 – Till Date
ROLE: SR OBIEE DEVELOPER/ ADMIN/HYPERION ADMIN

Responsibilities

  • Installed ,configured and administratedOBIEE11G
  • Identify the OLTP tables, design the mappings, and finally map them to the OLAP Tables.
  • Installed, configured and administratedHyperion 11.1.2.1on windows Environment.
  • Configuredactivedirectory to the shared services and import all the users from the directory by using filter
  • Designed and Tested Reports in theDashboardsfor theOracle Financial Analyticsmodules likeGL, AP, ARand created the Ad-hocreport according to the client needs
  • Worked on loading FDM data in to the application in series or parallel ways.
  • Created scripts for start and stopping the obiee services
  • Worked withmaintenanceteam by creating scripts like kill the process ,moveing the logs , and also setting up thecronjobsfor every week to recycle theOBIEEserver
  • Worked onWeblogicin obiee 11g to create users and groups
  • Worked onmigratingRPD and catalog toOBIEE 10GtoOBIEE 11G
  • Worked onupgradingOBIEE 10G to OBIEE 11G(11.1.1.5 Version)
  • Worked onOBIEE securitylike configuringLDAP authentication,creating users and groups etc
  • Migratingsecurityfrom DEV to Test env inOBIEE11g by exporting the exportindex.dat file
  • Worked on variables like repository andsessionvariable
  • Worked on cache management which deals withpurgingthe cache ,enablethecacheetc
  • Worked on configuringSSL(secure socket layer ) for providing the encryption of the data i.e communication between two process like browser and webserver etc .
  • Worked onEMConsole to deploy the rpd and provide the catalog .
  • Customized Oracle BIEE Metadata Repository using Siebel Analytics/OBIEEAdminTool by importing some of the required objects with integrity constraints into Physical Layer.
  • Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
  • Migrate therepositoryandpresentationcatalogbetween different environments like Dev, Test, QA and Maintenance.
  • CreatedTime Series measures Year Ago, Month Ago, Year-to-date measuresusing Ago and To Date functions.
  • Created Requests in Answers with various viewsTitle, Table, Compound Layout, Chart, Gauge and Pivot Table.
  • DefinedLevel Based Measuresbased on theDimensional Hierarchiescreated in the Business Model & Mapping Layer.
  • IdentifiedFactsandDimension Levels/Hierarchiesof Dimensional model.
  • Customized and developedRPD (Physical, Business Model and Presentation layer), configuredmetadata objectsandWeb Catalog Objects.
  • Developed manyreports/dashboards Analytic views(Pivot tables, Charts, Column Selector, and View Selector) usingOBIEE 11g.
  • CreatedMeasuresandLevel Based Measuresin Business Model.
  • CreatedLogical TablesandLogical Columns,Physical Columns.
  • CreatedMeasureswithLogical columnsandPhysical columns.
  • CreatedDimension HierarchiesinBusiness Model and Mapping Layer.
  • Performance tuning ofDashboards/Reportsand made changes to database by implementingmaterialized viewsandpartitions, rebuildingindexes.
  • Worked onsecurity managementforusers,groupsandweb groupsusing the various authentication systems such asLDAP,OS,DatabaseandDatabase Table AuthenticationusingSession Variablefeatures, as well asDashboard/ Report level security.
  • CreatediBotsand delivers to send Alert messages to subscribed users.
  • ImplementedSingle Sign On (SSO)on the existing OBIEE environment by integration withSite Minder,Editing the credentialstore.xml files and getting the rpd groups in sync with Database roles was part of it.
  • Monitoring performance and drive business decisions to help improve upon that performance by usingKPIscoreboard
  • Worked on Oracle BI Administration tool for customizing the Physical Layer, Business Layer, Presentation Layer that came withOBIAand modifying it according to the business requirements.
  • Worked on performance tuning to increase the performance ofHyperionproduct (heap size tuning, OS tuning etc)
  • Worked on issues likeEssbase crash, Server crashed, FR reports are not working Etc
  • Worked on shared services by creating group and adding users to the groups.

Environments :OBIEE 11.1.1.5.0,DAC 7.9.6,Hyperion EPM 11.1.1.2,HFM,FDM, Informatica Power Center 8.6, OBIA 7.9.5, TOAD, Oracle 10g, Windows 2003, , Red Hat Linux, WebLogic Server 11gR1 PS3, Financial Analytics, HR ( Human Resources) Analytics ,Pharmaceutical analytics.

Confidential, Round Rock TXJuly11- DEC 11
ROLE: SR OBIEE DEVELOPER/ADMIN

  • Participated in the Requirements Gathering of the various work streams by meeting with the business user and base lining the details.
  • Configured the tables and joins between them in the Data Warehouse.
  • Installed configured and administratedOBIEE11G
  • Identify theOLTPtables, design the mappings, and finally map them to theOLAPTables.
  • Configuredand installedBI Publisherand integrated with OBIEE server and created Smart View Report Templates.
  • CustomizedOracle BIEEMetadata Repository usingSiebel Analytics/OBIEE Admin Toolby importing some of the required objects with integrity constraints intoPhysical Layer.
  • Enterprise reporting environment for home office and retail field of 400 stores (previously in Impromptu Web Reports) with OBIEE dashboards.
  • Worked onRepository Physical Data Layer,Business Model and Mapping LayerandPresentation LayerusingOBI Administration Tool.
  • Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
  • Used theSecurity settingsinOBIEE Admin Toolto set up users, groups, accessprivileges and query privileges.
  • CreatedDimensional Hierarchy,Logical columns,Aggregate columns,Level based MeasuresandAggregate navigationin BMM layer.
  • Configuredcharts,pivot table views,Gauge Views,filterin user interface.
  • ConfiguredGlobal FiltersandDashboard and page Promptsin OBI Web.
  • Expertly used theOBIEE add-insto insert and analyse reports inWord,ExcelandPowerPoint.
  • ExecutedOBIEE administrativetasks such asOBIEEserver installation, migration and user maintenance.
  • Migrate the repository and presentation catalog between different environments like Dev, Test,QAand Maintenance.
  • Created templates as required by the client usingBI Publisher.
  • ImplementedBIPublisherand created bursting reports usingBIPublisher.
  • Expertise integrating and customizingBIOffice with OBIEE.
  • Worked on Key Performance Indicators(KPI) within the BI environment which can be used as the catalyst toward driving more responsive interaction between users and data.
  • Monitoring performance and drive business decisions to help improve upon that performance by usingKPI scoreboard
  • Worked onOracle BI Administration toolfor customizing thePhysical Layer,Business Layer,Presentation Layerthat came withOBIAand modifying it according to the business requirements.
  • Worked onMetadata Repository objectsand also Web catalog Objects which includeDashboards, Reports, Pages and Folders.
  • Designed and developedPerformance Measurement Dashboards/Reportsthat are Dynamic & Interactive withdrill-down, drill-across capabilities split reports forsummary & details information, andlocal & global filtersusing Oracle BI Presentation Services.
  • Developedcustom reports/Ad-hoc queriesusing Seibel Answers and assigned them to application specific dashboards.
  • Enhance performance of Reports/ Dashboards by implementing theAggregate tables, Materialized Views, Table partitions, re-building of indexesandmanaging Cacheetc,.
  • ConfiguredLDAPserver to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
  • Createdsessions, tasks, and workflowsetc. in Workflow Manager.
  • PerformedUnit, IntegrationandRegression testingto validate reports and mappings.

Environment:OBIEE 11.1.3.0,DAC 7.9.6, Informatica Power Center 8.6, OBIA 7.9.5, TOAD, ODI, Oracle 10g, Windows 2003, , Red Hat Linux, WebLogic Server 11gR1 PS3, Financial Analytics, HR ( Human Resources) Analytics .

Confidential. Houston , TXNov09 – July 11
Role: SR OBIEE DEVELOPER/ADMIN

Responsibilities:

  • Analyzed Business Requirements and Use Cases and converting them to a technical specification.Software Design Document(SDD) is updated with the implementation plan.
  • CreatedTime Series measures Year Ago, Month Ago, Year-to-date measuresusing Ago and To Date functions.
  • Created Requests in Answers with various viewsTitle, Table, Compound Layout, Chart, Gauge and Pivot Table.
  • DefinedLevel Based Measuresbased on theDimensional Hierarchiescreated in the Business Model & Mapping Layer.
  • Implementeddata level security(Location Managers, Sales Executives etc) usingSession Variables by creating content filter in dimension table in rpd.
  • Implementedobject level securityfor both repository objects and web objects by creating users and groups in repository and web catalog groups in the Presentation Services.
  • Created reports and dashboards with different Views likePivot table, View Selectors, Column Selectors, Chartswith drill-down capabilities for vivid information about Product Lines, Locations, Stores etc.
  • Coordinated theAnalytics RPDandWeb Catalogobjectsmigrationfrom Dev environment to QA environment and to the Production environment.
  • ConfiguredLDAPserver to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
  • Createdsubject areas,execution plansto load the data warehouse throughDAC10.1.3.4.1
  • Involved in creatingaggregate tablesto increase theperformanceof reports and access the corresponding logical table source without going to the base fact table.
  • Involved in developing performance tuning strategies by implementingaggregations, aggregate navigation, Oracle materialized views and indexes.

Environment:OBIEE 10.1.3.4.1,DAC 7.9.6, Informatica Power Center 8.6, OBIA 7.9.5, TOAD, Oracle 10g, Windows 2003, , Red Hat Linux, WebLogic Server 11gR1 PS3, , Financial Anlalytics, Human Resources ( HR Analytics) .

Confidential Atlanta GAJan 08 - Oct 09
Role: OBIEE DEVELOPER

Responsibilities:

  • Interacted with Business users and involved in gathering the business requirements.
  • Analyzed technical requirements and used metadata designing principles to design repository and followed best practices.
  • IdentifiedFactsandDimensions(with levels & hierarchy)
  • Design and Developedrepository(.rpd) that consists ofphysical layer,business model / layerswithaggregates & dimensions,presentation layerswithcatalogs & foldersandexternal table securitywithsession variablesusingOracle BI Analytics Administration tool.
  • Developed manyDashboards/ Reportsfor providing analytical information usingOracle BI AnswersandDashboards.
  • Developed and debugged manyDashboards / Reportswith different Analytics Views (Pivot Table, Chart, Tabular and View Selector),Alerts,Guided Navigation, andDynamic / Interactive Dashboardswithdrill-down capabilitiesusingglobalandlocal Filters.
  • CreatediBotsusingOracle BI Deliversto deliver reports to different devices across enterprise.
  • Integrated data intoHyperion cubesand helped in the implementation ofHyperion planningapplication.

Environment:Oracle BIEE 10.1.3.4, DAC 7.9.6,Siebel Analytics 7.8.5,BI publisher, Informatica Power Center 8.1, Oracle 10g, PL/SQL, DB2, Windows 2003 server, UNIX.

Confidential Jacksonville FLFeb 06 – Dec 07
Role:OBIEE/ ETL Developer

Responsibilities:

  • Created and administered the Physical Layer, Business Model and Mapping Layer, Presentation Layer inOBIEErepository.
  • Createdconnection pools, physical tables, defined joinsand implementedauthorizationsin the physical layer of the repository.
  • Developed customreports/Ad-hocqueries usingOBIEE Answersand assigned them to application specific dashboards.
  • Developed different kinds of reports (pivots, charts, tables) using global and local filters.Configure Interactive Dashboards withdelivers/iBotsto alert the marketing team about business changes.Managed day-to-dayRpd, OBIEE Delivers, SchedulerandiBots.
  • Managedsecurity privilegesfor each subject area and dashboards according to user requirements.
  • Security managementfor users, groups and web-groups using the various authentication systems (Database table, Dashboard / Report-level security).
  • Createdgroupsin the repository and addedusersto the groups and granted privileges
  • Developed various slowly changing dimensionsType1, Type2and slowly growingdimensional mappingsaccording to the data mart schemas.
  • Created Connected and UnconnectedStored Procedure Transformationsfor pre & post load sessions.
  • DevelopedUNIX shell scriptsto get data from external systems flat files to EDW stage area, and to schedule various workflows to load the data into target system.
  • Developed and Scheduled workflows usingworkflow managercreated and modified parameter files according to the business requirements.

Environment:OBIEE 10.1.3.1, Siebel Analytics 7.7, Informatica Power Center 6.1, Oracle 8i, SQL Server, Flat files, ERP files, Windows 2000, UNIX Shell scripting, Test Director.

Confidential BOSTON MAJuly 05 – jan 06
Role: INFORMATICA Developer

Responsibilities:

  • Interacted with Business Analyst to understand the data warehouse requirements
  • Analyzed Specifications and involved in identifying the source data that needs to be moved to DM.
  • Involved in developing dimensional data model for the Power Center data mart using star schema models.
  • Identified and created different source definitions to extract data from input sources like Flat files, SQL Server and load into relational tables like Oracle.
  • Created various database objects in Data Mart as per changing technical requirements.
  • Designed Reusable Transformations using Transformation Designer like for Date Conversion etc.

Environment:Informatica Power Center 6.x, Oracle 8i, SQL Server, SQL*Plus, SQL*Loader, Windows NT.

ConfidentialJuly 04 - June 05
Role: ETL/INFORMATICA Developer
Responsibilities:

  • Involved inrequirement gatheringfrom the business users and converted them into mapping documentation.
  • Created mapping documents with the requiredTransformation logic, Sources and Targetsfor Facts and Dimensions.
  • Analyzed dependencies and developedtransformation logicfor various enhancements and integrating various sub marts.
  • Developed various Slowly changing dimensionsType1, Type2and Slowly growingdimensional mappingsaccording to the data mart schemas.
  • Created Connected and UnconnectedStored Procedure Transformationsfor pre & post load sessions.
  • Developed Workflows for initial loading, historical data loading, Near Real Time data loading and Recovery data loading usingsessions, worklets, commands, decisions, events and timers.
  • Developedtest cases,conducted unit tests, system tests and user acceptance tests
  • Migrated meta data from development to staging and production systems,
  • DevelopedUNIX shell scriptsto get data from external systems flat files to EDW stage area, and to schedule various workflows to load the data into target system.

Environment: Informatica Power Center 7. X/6.2 .x, Oracle 8i/9i DB2, Windows 2000

Hire Now