We provide IT Staff Augmentation Services!

Sr. Oracle Business Intelligence Developer Resume

0/5 (Submit Your Rating)

Columbus, OH

SUMMARY

  • 7+ Years of experience in Analysis, Application Development, Maintenance, Implementation on Oracle 12c/11g/10g, Informatica power center 9.5/9.x/8.x, OBIEE12c/11g/10g, DAC 10g/11g, BI Publisher and OBIA Reporting.
  • Extensive Experience in End to end implementations and working in all levels of the OBIA stack including OBIEE, BI Publisher, DAC, Informatica, Database, RPD, Web Catalog.
  • 2+ years of Oracle Business Intelligence Enterprise Edition (OBIEE) Repository Design.
  • Experience in Oracle Business Intelligence Enterprise Edition 12c/11g, Administration and performance tuning of OBIEE 12c/11g.
  • Installed OBIA,OBIEE andODI on one sever and applied platform patches and installed OBIEE 12 C on the second server.
  • Knowledge in Full Life Cycle development of Data Warehousing.Implemented OBIA OOTB Supply Chain and Order Management and Financial Analytics for Oracle EBS.
  • Experience in Installation and Configuration of OBIA (including Informatica, DAC and OBIEE) Out of the Box Reports.
  • Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill - down capabilities using OBIEE.Experience in OBIEE highlights (i.e. Store, Usage following, Dimensional chain of command, Aggregate route, Variables/Initialization Blocks arrangement and so on.), changing over Snow-Flake Schema to Star Schema, Dim Pecking orders, Dim Extensions, Physical & Logical Data Modeling.
  • Migrated Analytics RPD and Web Cat from OBIEE 10g to OBIEE11g by utilizing Oracle Fusion Middleware redesign partner.
  • Good exposure on Reporting & ETL tools -OBIEE, Oracle BI Apps, Informatica, Tableau 10.0,ODI, DAC.
  • Experience with repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports). Added Metadata changes to the OBI RPD.
  • Customized OBIA Out of Box Reports to meet the requirements by doing Business Analysis, Technical Analysis and RPD Modifications. Extensive experience in OBIEE Administration Tool, OBI Answers, OBI Intelligent Dashboards, OBI Publisher, Delivers and iBots with OBIEE Applications.
  • Developed Application Flow, Application Configuration and Application Filter setup using OBIEE 11g platform.Experience with the different configuration options that exist for failover, load balancing, caching, security, etc. with respect to OBIEE. Experience with customizing the functional setups of OBIA & ETL Mappings (Pre-Packaged Analytics) for modules like Financial, SCM, and HRMS
  • Extensive experience using ETL tools in Data Integration and Data-Warehousing with hands on knowledge with data modeling and developing data marts, multi-level dimensions.
  • Experience in developing Dimensional Hierarchies/Creating Aggregate Measures/Aggregate Tables/New logical columns/Filters/Variables/Time Series Functions as per business requirements.
  • Proficient in configuring Security settings at various levels both in Repository level (OBIEE Administration Tool to setup Groups, Access Privileges and Query Limits) and Presentation Catalog level.
  • Experience Integrating LDAP Server for authentication of users and working in Multi User Development Environment (MUDE). Experience developing reports & dashboards in OBIEE (BI Publisher, Dashboard, Answers, Delivers, Oracle BI for Microsoft Office).
  • Expertise in Creating Dynamic Dashboards and OBIEE Answers using Prompts, Filters, Calculations, Charts, Pivot tables, View Selector and Conditional Formatting.
  • Configured, Designed and developed BI Publisher reports by integrating them with Microsoft Office application according to client's requirement.
  • Experience in migration techniques for OBIEE, ODI, Informatica and DAC components into various test and production environments.
  • Experience using OBIEE 11g, especially in configuring Security settings using Weblogic Server (Users and Groups), Oracle Enterprise Manager (OEM for Roles and Privileges) and Presentation Catalog.
  • Strong Knowledge and Understanding of upgrading and implementing OBIEE 11g.
  • Created Test cases and Tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
  • Experience in designing and testing mappings, mapplets and workflows using Informatica Power Center.

TECHNICAL SKILLS

OBIEE Infrastructure: OBIEE/ BI Publisher 12C/11G/11.1.1.7, OBIEE 12.2.1/11.1.1.6 , OBIEE 12c/11g/10g

OBIEE Applications: OBIA 11.1.1.9,7.9.6.3,7.9.6.1(Financialanalytics, HR Analytics, Sales, Service, Marketing)

ETL Tools: Informatica Power Center 9.5/9.0, InformaticaPower center 9.5,9,8.6.1, DAC 11, 10.1.3.4.1 , ODI 12c/11g/10g

Languages and Web Technologies: SQL, PL/SQL, Java, C, C++ XML, HTML/XHTML, TOAD, SLA

ERP and Applications Servers: Oracle Applications 12c,11i, R12, PeopleSoft9, 8.9, Oracle Web Logic Server 11g/10.3.5

RDBMS: DB2 UDB (9.x,8.x and 7.x), Oracle 12c,11g/10g, MS-Access, SQL-Server 2008,Hyperion System 9 Essbase

BI Tools: OBIEE, Tableau, Informatica

Tools: /IDE: Web Logic Studio, Eclipse, JDeveloper, Dream Weaver, Net Beans

Operating Systems: Microsoft Windows 8.x, Windows 7, Solaris 5.8, UNIX, Oracle Enterprise Linux 5.7, Mac OS X

Methodologies: Software Development Life Cycle (SDLC) -Waterfall Model, Agile Methodology, Rational Unified Process (RUP)

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Oracle Business Intelligence Developer

Responsibilities:

  • Managed the development, release activities and Worked on production Support.
  • Modify existing ETL jobs in Oracle Data Integrator (ODI).
  • Created numerous Interfaces to load data from Flat files, CSV files and Oracle tables into staging tables and then into respective FACT/DIMENSION/Look-up Tables in Data Warehouse.
  • Customized ODI inbuilt KM (Knowledge Modules) to build Interfaces for complex data requirements.Used ODI in-built scheduler to schedule Scenarios/Load Plan's in production.
  • Setup of OBIEE environments and maintenance.
  • Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
  • Using PLSQL working on Inbound and outbound interfaces.Worked with the users to explain about the new features of OBIEE 12c/11g.Worked on ODI (Oracle Data Integrator).
  • Worked on the performance tuning of the dashboards and reports and managed security.
  • Configured Physical & BMM layer - import tables, Identifying facts, dimensions, created physical tables, join the tables, creating the logical tables and logical columns using OBIEE 12C/11G Administration tool.Created Drill down Hierarchies and implemented Business Logics & Facts.
  • Create OBIEE Publisher RTF template and Data models and Bursting.
  • Created customized format and calculation in the OBIEE Publisher reports.
  • Map and reference agency Oracle data structures to corresponding Common Education Data Standards (CEDS) data models and support.
  • Provide technical expertise on data integration technologies such as messaging, SOA, Data Virtualization, JSON, XML. Support web services built using PHP.
  • Have knowledge on other super BI tools like Tableau.
  • Ensure proper technical documentation (data mapping, technical architecture drawings, supporting narrative etc.) is developed and maintained.
  • Experience in migration techniques for OBIEE components into various test and production environments.Created Aggregation tables in OBIEE and Created Job Scheduling for Aggregation Tables.Prepared documentation on Technical specifications, Scenarios, Business processes, Workflows, Process flows, Unit Test cases.
  • Created and Executed test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: Windows server 2008, OBIEE 12c/ 11.1.1.7.1 , BI Publisher, Oracle 12c/11.1.0.7, Tableau, WebLogic 11g/10.2, TOAD, Siebel CRM,SOA, XML,JSON, SOAP, REST and WSDL.

Confidential, Des Moines, IA

Sr. Oracle Business Intelligence Developer/OBIA Consultant

Responsibilities:

  • Creating Answers reports, Deploying and maintaining the RPD while employing the best practices.
  • Creating and maintaining dashboards using different design styles like, linking dashboards, linking dashboards pages, using appropriate prompts on different pages.
  • Created Design and Development Documents for creation of new subject areas/customization.
  • Creation and Customization of the OBIEE Repository (Physical, Business and Presentation layers).
  • Managed and monitored Cache, Security and Performance Tuning of the OBIEE Application.
  • Customized out of Box OBIA reports to meet the requirements by doing Business Analysis, Technical Analysis and RPD Modifications.
  • Designed, developed and tested reports for Oracle Financial Analytics modules of AP, AR and GL as per the requirements.Having experience using OBIA with Siebel.
  • Experienced in using OBIA with Oracle Service Cloud & in the creation of solution architecture descriptions. In-depth knowledge of OBIEE/OBIA security configuration.
  • Created OBIEE Repositories and implemented the business logic by Customization, Dimensional Hierarchies, Aggregate Navigation, And Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks and cache management.
  • Responsible for implementing and managing security at both Repository Level and Presentation Catalog Levels.
  • Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
  • Performed Consistency check and Global Consistency check of the Business Model before exposing Business Models in the Presentation Layer considering errors and warnings.
  • Worked with OBIEE/OBIA Answers, Intelligence Dashboards. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports.
  • Managed dashboard and request security/privileges in the analytics catalog manager.
  • Worked on different subject areas of AP, AR and GL to create Reports and Dashboards according to the business requirements.
  • Successfully implemented OBIEE delivers/Created Proactive agents (iBots) and configured Interactive dashboards to alert the Business/Field users as per the requirements.

Environment: OBIEE, OBIA (Financial Analytics, Procurement and Spend Analytics and HR Analytics), Informatica Power Center, DAC, Oracle 11g/10, SQL Server 2008, Oracle EBS R12, TOAD, Siebel, MS SQL Server 2008, Windows XP, Red Hat Linux, Oracle BI Publisher, SQL.

Confidential, Somerset, NJ

OBIEE Developer/Administrator

Responsibilities:

  • Business requirement gathering, understanding business objectives and analysis.
  • A full cycle development of Siebel Analytics (Supply Chain Analytics) was implemented. Involved in indentifying, designing, configuring &testing the application.
  • Involved in the Supply Chain & FDM project where it involves replication of SAP BW reports to OBIEE.
  • Get the database connectivity and design the Physical Layer, Business model and Mapping layer and the presentation layer in the repository (.rpd).
  • Add users to the new group and apply the data level security and object level security at the rpd and Web catalog.
  • Involved in the analysis of the existing system reports and modification of the reports, created new reports based on the user requirements.
  • Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
  • Define iBots / Delivers for various requests if needed.Created reports in BI Publisher using PDF, RTF templates.
  • Performed OBIEE Administration -including creation of users and cache management.
  • Created hierarchies based on the territory level to territorial level sales and contact reports.
  • Developed many PL/SQl procedure & functions and used the same in mappings.Created reports and delivered the same to the end-user through Delivers.
  • Created Dimensional Hierarchy fro Date, Facility and Location Dimensions, Level based Measures and Aggregate navigation in BMW layer.
  • Merge Repositories two way and three way into master repository from each developer.
  • Merging Catalogs folders to master catalog using Catalog Manager.Developed many Dimensions and Time Series Objects with Security settings for analyzing.
  • Configured Repository and session variables to get dynamic reports and dashboards.
  • Added new Dimensions and Columns to the Subject Areas to full fill the additional Requirements of the Business Analysts.
  • Mapped the configurations to accommodate for the Territorial hierarchy that were accommodated via chart drilldowns.Implemented security by creating roles & web groups, External tables.

Environment: OBIEE 10g/ 10.1.3.3/10.1.3.4 Oracle 10g/11g, SQL, Windows 2003 Server, Siebel,Windows Services, Weblogic 11g, UNIX, TOAD, PL/SQL.

Confidential, SFO, CA

OBIEE/ETL Developer

Responsibilities:

  • Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
  • Configured Physical & BMM layer - import tables, Identifying facts, dimensions, created physical tables, join the tables, creating the logical tables and logical columns using OBIEE 10G Administration tool.
  • Built Business model and established relationships & Foreign Keys Physical & Logical between tables. Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services.
  • Created Drill down Hierarchies and implemented Business Logics and Facts.
  • Created Aggregation tables in OBIEE and Created Job Scheduling for Aggregation Tables.
  • Worked on Dimensional Hierarchies (Ragged & Skipped) and Level Based, Level Based Measures and Time series Functions based on business requirements.
  • Experience in performance tuning in OBIEE and gathering performance metrics for various measures in reports. Implemented Ago, To Date and Period Rolling Measures in OBI 11G.
  • Developed and Implemented Market Basket Analysis and RFM Analysis for Retail Clients.
  • Strong domain knowledge in Retail Industry - Involved in Marketing, Sales and Customer Analytics.
  • Experience in migration techniques for OBIEE components into various test and production environments.Worked on the Procurement and Spend analytics reports.
  • Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard (GL) Customized Payments Due, Payment Performance, Customer Report dashboard pages in Account Receivables (AR).

Environment: Windows server 2008, OBIEE 10.1.3.2, Oracle 10g, SQL, Web logic 9x, Informatica, Oracle EBS 9.1, Unix OS.

Confidential

ETL Developer

Responsibilities:

  • Experience with ETL/ETI(Informatica) (Extraction Transform and Loading, Extraction Transform and Import) data from production database to data warehouse database.
  • Worked on transformations such as source qualifier, joiner, lookup, rank, expression, aggregator and sequence generator etc.
  • Reused mapping, mapplets and transformations.
  • Scheduled sessions and batches on the Informatica Server using Informatica Server.
  • Tuned transformations and mappings in Informatica.
  • Implemented slowly changing dimensions.Created Unix Shell Scripts and PL/SQL procedures.

Environment: Informatica PowerCenter 7.1, Shell Scripts, Database Systems, SQL and PL/SQL, Windows NT, Oracle8i and UNIX.

We'd love your feedback!