We provide IT Staff Augmentation Services!

Sr. Obiee Consultant Resume

5.00/5 (Submit Your Rating)

Columbia, MO

SUMMARY

  • 12+ years of IT experience in Developing and Implementing Oracle BI Applications, OLAP, OLTP, Data warehousing and web applications.
  • Good experience in different phases of software development life cycle including analysis, design, development, testing and maintenance.
  • Strong understanding of relational database design concepts and in depth knowledge of Data Warehousing and OLAP, OLTP solutions.
  • 10+yrs of Experience in building enterprise DWH solutions through OBIEE/OBIA BI implementations.
  • Experience in working wif business clients in gathering requirements, documenting teh requirements and understanding business process.
  • Experience in OBIEE metadata repository RPD development, Web Catalog Administration and Data Modeling.
  • Strong Experience in design and development of ETL Informatica, Datamodeling for Enterprise Data ware house and DAC scheduling.
  • Strong experience in OBIEE 10.1.3.4.x/11.1.7.X, OBIA 7.9.6.4 and DAC implementations.
  • Experience in OBIEE/Informatica/DAC/BI APPS installations.
  • Designed business model (Star Schema) and metadata repository RPD based on Project requirements.
  • Good understanding of STAR and SNOWFLAKE data models.
  • Implemented OBIEEData level and Object level security for multiple projects.
  • Experience in developing OBIEE Analysis/Answers, Dashboards, Delivers, iBots(alerts) and BI publisher.
  • Experience in developing BI publisher reports and data templates
  • Proficient knowledge in Oracle PL/SQL scripts, procedures etc.
  • Experience in developing Technical Design Specifications.
  • Sound knowledgeof ETL tools such as Informatica 9x and good understanding of ELT tool ODI(Oracle Data Integrator) 11g
  • Experience in developing/customizing teh various OBIEE/OBIA dynamic and interactive complex reports/dashboards
  • Experience in data modeling and used Data modelling tools like Erwin/SQL Modeler for multiple projects.
  • Strong Experience in relational database systems like Oracle 10/11g and SQL Server.
  • Experience in handling all phases of and Software Development Life Cycle(SDLC) of teh BI Projects
  • Experience in implementing Data Migration projects.
  • Experience in conducting POC reviews wif teh clients and projecting technical solutions.
  • Experience in web technologies (HTML, Java script).
  • Expert in adroit client communication and working wif multiple cross - functional teams.
  • Experience in leading teh project teams and worked in Onsite/Offshore Model.
  • Highly adaptable in quickly changing technical environments wif very strong organizational and analytical skills.

TECHNICAL SKILLS

OLAP BI Tools: OBIEE 11.1.7.X& OBIEE 10.1.3.4.X

ETL Tools: Informatica 8x/9x

Data Modeling Tools: Erwin, SQL Modeler

Databases: Oracle10/11g, MS SQL Server 2000

Web Technologies: ASP, JavaScript, VBScript, XML,HTML

Other Tools: TOAD, SQL Developer, MS Office.

Reporting Tools: Seagate Crystal Reports

Testing Tools: Bugzilla, HP Quality Center and Star Team

Operating System: Windows Server 2003 & 2008, Windows XP&9X, Linux, Unix and DOS

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MO

Sr. OBIEE Consultant

Responsibilities:

  • Act as SME for OBIEE BI implementations for BI requirements.
  • Involve in OBIEE11g report Analysis, System Design, Development, Unit Testing, Production Support and Enhancements.
  • Interact wif Business Analyst, business users and identify teh BI project requirements.
  • Identify gaps and perform analysis on client requirements and suggest technical solution.
  • Conduct Proof of concept reviews for new OBIEE report developments and presents to teh client.
  • Prepared technical design documents for RPD, dashboard/report development based on teh requirements.
  • Design and develop STAR data model as per teh project requirements.
  • Prepare technical design documents for OBIEE RPD, dashboard/report development based on teh project requirements.
  • Develop Javascript to impose mandatory filters on OBIEE adhoc reports.
  • Configure/Customize OBIEE metadata repository (RPD) based on requirements, which includes Configuration of Physical, BMM and Presentation layers.
  • Worked on MUD development for various projects in OBIEE 11g.
  • Develop/Customize OBIEE RPD Dimensional hierarchies, Aggregate Navigation and Time series calculations for various reporting requirements.
  • Customize/Configure OBIEE RPD Repository, system and non-system session variable and initialization blocks for various reporting requirements.
  • Develop iBots (alerts) and schedule OBIEE reports according to teh business requirements.
  • Develop analytical and operational OBIEE reports/ dashboards and work on report layout views table/pivot table/chart/narrative/view selector etc.
  • Prepare OBIEE deployment instructions document to deploy OBIEE RPD and Web Catalog objects for development, testing and production environments.
  • Implement OBIEE performance improvement techniques.
  • Develop/Enhance OBIEE interactive dashboards wif teh features such as Prompts, Drill downs, Guided Navigation etc.
  • Develop Oracle PL/SQL queries to validate OBIEE report data across teh dashboards.
  • Customize/Develop ETL Informatica mappings through Informatica Designer as per teh user requirements.
  • Wok on Informatica Workflow manager to create tasks for teh mappings.
  • IdentifyFinance Subject Area related ETL tables, Informatica workflows/mappings and DAC tasks and customize Informatica mappings.
  • Develop new subject areas and execution plans in DAC as per teh requirements
  • Monitor teh daily Incremental Load in Production environment and fix any issues during teh Load.

Environment: OBIEE 11.1.1.7, BI Apps 7.9.6x, DAC 11g, Informatica PC 9x, Oracle EBS R12, Unix, Oracle 11g, SQL Developer, HTML, JavaScript.

Confidential, GA

Sr.OBIEEConsultant

Responsibilities:

  • Installed Out of box OBIA APPS and configured teh out of box RPD and Catalog.
  • Configure/Customize OBIAmetadata repository (RPD) based on requirements, which includes Configuration of Physical, BMM and Presentation layers.
  • Interact wif Business Analyst, clients and identify teh BI project requirements.
  • Identify gaps and perform analysis over customer requirements and suggest technical solution.
  • Act as SME for entire OBIEE BI implementations for Confidential ERS BI requirements.
  • Conduct Proof of concept reviews for new OBIEE report developments and presents to teh client.
  • Prepare technical design documents for RPD, dashboard/report development based on teh requirements.
  • Develop/Customize OBIEE RPD Dimensional hierarchies, Aggregate Navigation and Time series calculations for various reporting requirements.
  • Customize/Configure OBIEE RPD Repository, system and non-system session variable and initialization blocks for various reporting requirements.
  • Worked on Financial Analytics Subject Areas Account Receivables, Accounts Payables and GL Subject Areas and corresponding dashboards as per user requirements
  • Customized Account Receivables, Accounts Payables and Oracle GL Subject Areas and corresponding dashboards as per client requirements.
  • Implement OBIEE object level security for dashboards through client specific Application Roles/WEBGROUPS.
  • Create Oracle SQLmaterialized views and aggregates tables to improve report-rendering performance.
  • Works on both OBIEE webcatalog and Presentation administration.
  • Works on Oracle PL/SQL scripts, Procedures and created materialized views based on teh requirements.
  • Works on OBIEE report development which involves various OBIEE report views like table, chart, column selector, view selector, pivot view/Narrative view etc.
  • Created custom CSS classes, styles, java scripts and HTML scripts to enhance teh dashboard interface, functionality and deliver reports according to teh business requirements.
  • Develop/Enhance interactive dashboards wif teh features such as Prompts, Drill downs, Guided Navigation etc.
  • ConfigureiBots (alerts) and schedule teh reports as per teh client requirements.
  • Develop BI publisher reports and data templates.
  • Enhance/Customize teh OBIA Financedashboards/reports based on user specific requirements.
  • Developed KPI and KPI watch list as per teh business requirements.
  • Customize/Develop ETL informatica mappings through Informatica Designer as per teh user requirements.
  • Develop Informatica ETL mappings by using teh transformations such as Source qualifier, Lookup, Expressions, Update Strategy, Router, Filter, Sequence Generator, Aggregator, Joiner etc.
  • Wok on Informatica Workflow manager to create tasks for teh mappings.
  • Installed DAC and configured DAC container wif teh respective out of box OBIA ETL Informatica mappings.
  • Configured teh Out of box ETL Repository in Informatica and created Integration service.
  • IdentifyFinance Subject Area related ETL tables, Informatica workflows/mappings and DAC tasks and customize Informatica mappings
  • Create/CustomizeInformatica Workflows wif Worklets & Tasks and schedulethroughDAC.
  • Develop new subject areas and execution plans in DAC as per teh requirements
  • Deploy Informatica workflows to teh DAC, create dependency and dependent hierarchical tasks and streamline teh Execution Plans wif their respective tasks in DAC.
  • Monitor teh daily Incremental Load in Production environment and fix any issues during teh Load.
  • Schedule data load using DAC by configuring teh developed mappings wif their sources, staging tables and targets along wif their workflows.
  • Actively participate in client discussions and project discussions wifin ERS project.
  • Conducts code reviews and mentors team for deliverables and helps teh team for technical challenges.
  • Involves in continuous development, enhancements and resolves technical challenges.
  • Prepare effort schedule for deliverables, assign and track teh work status from team members.

Environment: OBIEE 11.1.1.7, BI Apps 7.9.6x, DAC 11g, Informatica PC 9x, Oracle EBS R12, Unix, Oracle 11g, SQL Developer, HTML, JavaScript.

Confidential, Austin, TX

OBIEEConsultant

Responsibilities:

  • Participated in requirements gathering wif teh clients and Business Analyst.
  • Designed Star Schema Data model for Confidential specific Custom report requirements.
  • Acted as SME for entire BI analytics implementation for OBIA Procurement analytical report development.
  • Conducted POC reviews wif teh clients.
  • Involves in discussion wif business clients for business requirements and analysis.
  • Customized OBIA out of box RPD for Confidential specific requirements and configured Physical, BMM and Presentation layers.
  • Implemented OBIEE security through External tables and LDAP.
  • Implemented data authorization for internal and external PQM users through dynamic filters capability.
  • Implemented Dimensional hierarchies, Aggregate Navigation and Time series calculations for various reporting requirements.
  • Created custom CSS classes,styles, java scripts and HTML scripts to enhance teh dashboard interface, functionality and delivered reports according to teh business requirements.
  • Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
  • Worked on OBIA Procurement and Spend Analytics subject Areas Purchase Orders, Purchase Receipts, Purchase Requisitions, Purchase Requisition status.
  • Customized teh OBIEE user interface on top of existing out of box Procurement dashboards,
  • Classified multiple subject area in presentation layer depending on teh business user requirements.
  • Customized OBIA RPD Repository, system and non-system session variable and initialization blocks for various reporting requirements.
  • Developed interactive dashboards wif teh features such as Prompts, Guided Navigation, drill down etc.
  • Prepared technical design specification documents.
  • Developed various analytical and operational OBIEE reports/ dashboards through OBIEE presentation service and worked on report layout views table/pivot table/chart/narrative/view selector etc.
  • OBIEE Webcatalog administration.
  • Coordinated teh OBIEE RPD and Web Catalog objects migration from Dev environment to QA environment and to teh Production environment.
  • Worked on iBots (alerts) and scheduled teh reports as per teh client requirements.
  • Developed Oracle PL/SQL queries, procedures to validate report data across teh dashboards.
  • Mentored team for report development and technical challenges.
  • Conducted Pilot programswif teh clients during UAT phase.
  • Planned work schedule estimations for individual team members
  • Involved in end-to-end testing of all teh reporting deliverables during development.
  • Worked on Data mapping files for data migration for legacy systems.
  • Installed DAC and configured DAC container wif teh respective out of box OBIA ETL Informatica mappings
  • Customized/Developed Informatica mapping through Informatica Designer.
  • Configured teh Out of box ETL Repository in Informatica and created Integration service.
  • Created different types of Transformations like Source Qualifier, Expression, and Filter, Rank, Sequence generator, Lookup, joiner, Aggregator, Sorter and Update Strategy transformations in Informatica designer.
  • Worked on creating DAC tables, task definitions, Subject areas and indexes for tables and worked on change capture mechanism during incremental load for tables which were not part of OOB.
  • Deployed Informatica workflows to teh DAC, created dependency and dependent hierarchical tasks and streamlined teh Execution Plans wif their respective tasks in DAC.

Environment: OBIEE 10.1.3.4.1 , BI Apps 7.9.6.x, DAC 10.1.3.4.1 , Informatica PC 8.6, Oracle EBS Apps, Unix, Oracle 11g, TOAD,MSVISO

Confidential, Dallas, Tx

OBIEEConsultant

Responsibilities:

  • Configured/Customized OBIA RPD for Physical, BMM and Presentation layers.
  • Imported custom database tables to RPD Physical layer and created Alias table, physical joins and created logical tables in BMM layer.
  • Configured/Customized OBIEE RPD hierarchies, level based measures, time series measures etc.
  • Worked on Financial Analytics Subject Areas Account Receivables, Accounts Payables and GL Subject Areas and corresponding dashboards as per user requirements.
  • Implemented OBIEE dashboard object level security through an External table.
  • Configured/Customized out of box OBIA Repository, system and non-system session variable and initialization blocks for various reporting requirements.
  • Customized OBIEE reports through Table/Pivot table/Chart/Narrative/Narrative Views etc.
  • Customized interactive dashboards wif teh features such as Prompts, Guided Navigation, drill down etc.
  • Developed Oracle PL/SQL queries, procedures to validate report data across teh dashboards.
  • Developed CSS HTML custom style sheets as per teh client requirements and customized teh out of box OBIA dashboard web interface.
  • Created custom columns and measures in RPD BMM layer for Finance Subject Areas Account Receivables, Accounts Payables and GL Subject Areas.
  • Implemented Star Schema for new set of client custom requirements and used ERWIN modeler for logical and physical data model design.
  • Customized/Developed Informatica mapping through Informatica Designer.
  • Developed Informatica mappings though teh transformations such as Source Qualifier, Expression, Filter, Rank, Sequence generator, Lookup, joiner, Aggregator, Sorter and Update Strategy transformations in Informatica designer
  • Worked on creating DAC tables, task definitions, Subject areas and indexes for tables and worked on change capture mechanism during incremental load for tables which were not part of OOB.
  • Deployed Informatica workflows to teh DAC, created dependency and dependent hierarchical tasks and streamlined teh Execution Plans wif their respective tasks in DAC.
  • Monitored teh daily Incremental Loads.

Environment: OBIEE 10.1.3.4.1 , BI Apps 7.9.6.x, DAC 10.1.3.4.1 , Informatica PC 8.6, Oracle EBS Apps, Unix, Oracle 11g, Erwin Data Modeler

Confidential, Pittsburgh, PA

OBIEE Developer

Responsibilities:

  • Worked wif management professionals, analysts as well as other business teams on requirement gathering.
  • Worked on repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Folders, Reports).
  • Identified Facts and Dimensions according to teh design specification.
  • Developed analytical repository using Siebel Analytics Admin Tool (importing database object into physical layers, defining logical objects that includes Dimensions & facts in BMM layer and presentation catalog in Presentation Layer).
  • Modified Dynamic Session Variables used for Data Visibility, Configured Security Confidential teh repository level, Catalog level & teh Siebel Application level.Created measures in Administration tool for teh requirements using expression builder and calculation wizard and also created hierarchies and level-based measures for drilldown detail wifin Analytics Reports.
  • Used BI Publisher for report delivery in many popular pre-packaged application suites, like teh Oracle e-Business Suite.
  • Created Rich Text Format (RTF) templates to generate BI Publisher Reports and embedded them on Oracle Intelligence Dashboard..

Environment: OBIEE 10.1.3.3,Informatica Power Center 7.1,Business Objects XIR2,Crystal Reports XI, DAC,Oracle BI Apps 7.9.4,BI Publisher, DAC

Confidential, Camp Hill, PA

Siebel Analytics Consultant

Responsibilities:

  • Involved in gathering functional requirements from system users and converted them to business requirement documents.
  • Used Metadata Design Principals to design Repository based on business requirements and followed Best Practices.
  • Customized and developed teh SABMM layer by creating new logical columns, aggregate columns, hierarchies etc.
  • Specified aggregate levels for each source and created dimension sources for each level of aggregates.
  • Developed many Reports / Dashboards wif different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, Page and Dashboard Prompts).

Environment: Siebel Analytics 7.x, Informatica 6.x/5.x,Oracle 8i, UNIX, Windows 98

We'd love your feedback!