We provide IT Staff Augmentation Services!

Business Intelligence & Dwh Manager Resume

SUMMARY:

  • I have over 10 Years in Oracle Business Intelligence OBIEE, Oracle Business Intelligence Applications BI APPS, Oracle Data Integrator ODI, Oracle WebLogic Server, Oracle Service Oriented Architecture SOA and Java Programming Language.
  • I am highly motivated team player with excellent communication skills, presentation skills & a continuous will to quickly learn and apply new technologies.
  • Development of Oracle BI Publisher Report with different data sources.
  • Development of Oracle BI Analyses and Building Oracle BI Dashboards.
  • Development of Oracle BI KPIs (Key Performance Indicators) and KPI Watch list.
  • Building Maps for Oracle Business Intelligence Analyses and Dashboards.
  • Building Oracle Business Intelligence Briefing Books.
  • Development projects with Visual Analyser.
  • Integration between analyses/reports with third party files using Data Mashup.
  • In depth development OBIEE analysis advanced filters and prompts.
  • In depth working with pivot tables in the results.
  • In depth working with views and graphs in analyses and dashboards.
  • Visualizing Data using Gauges, Tellies, charts, etc.).
  • Professional Administration of BI users and groups on Oracle WebLogic
  • Professional Administration of BI elements on Oracle Enterprise Manager
  • Integrate OBIEE with MS Office.
  • Data modelling, Star /Snowflake Schema Modelling, FACT and Dimensions tables, physical and logical modelling with different approaches (Ralph Kimball and Bill Inmon).
  • Modelling Multi - dimensional databases like Essbase.
  • Configurations of Repositories/Sessions variables.
  • Configurations of Data/Object Level security.
  • Installation and Configurations of OBIEE 11g/12c on all Platforms (Linux, Solaris, AIX and MS Windows, etc.). With Single instance and High availability architecture.
  • Troubleshooting all issues related to OBIEE with different aspects.
  • Performance Tuning for OBIEE to increase response time and fast execution of reports.
  • Configuration of SSL over OBIEE.
  • Configuration of OHS (Oracle Http Server) over OBIEE.
  • Upgrade OBIEE 11g to 12c.
  • Integration between OBIEE and security Providers (Microsoft Active Directory).
  • Installation and Configurations of OBIEE 11g/12c on all Platforms (Linux, Solaris and MS Windows, etc.). With Single instance and High availability architecture.
  • Configuration of financial mapping between Oracle EBS and OBIA like (Chart of Accounts, GL group Numbers, Balance sheet, etc.).
  • Configuration of SCM mapping between Oracle EBS and OBIA like (Master Organization, Products Catalogs, Inventory, etc.).
  • Implementation of ODI Extract, Load and Transform (ELT) processes, programs and scripts.
  • Design of data warehouse tables, including source to target mappings, configuration of ODI knowledge modules.
  • Development of the ODI ELT process in order to help in creation and maintenance of the source to client data mappings, ELT specifications and complex transformation rules and technical documentation.
  • Working on Data Cleaning, updating, validations, extracts by running complex SQL queries.
  • Development of Python and Jython scripts which can assist in ETL Process for huge amount of Data.
  • Implementation of ETL techniques, fully loading, CDC, Etc.).
  • Extensively working on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
  • Development of with PL/SQL and PL/SQL program units (Creating stored procedure, function, package and Triggers as well as maintaining & debugging PL/SQL program code).
  • Extracting data from sourcing system like EBS, Siebel, Oracle Flexcube, and T24.
  • Installation and Configurations of ODI 11g/12c on all Platforms (Linux, Solaris, AIX and MS Windows, etc.). With Single instance and High availability architecture.
  • Troubleshooting all issues related to ODI with different aspects.
  • Performance Tuning for ODI to fast execution of Interfaces/Mapping, Packages and Load Plans.
  • Configuration of SSL over ODI.
  • Configuration of OHS (Oracle Http Server) over ODI.
  • Upgrade ODI 11g to 12c.
  • Integration between ODI and security Providers (Microsoft Active Directory).
  • Working with Oracle BPEL, Mediators, JCA adapters which allows the creation of end-to-end processes Orchestration.
  • Working with Oracle Service bus which allows integrating between different backend systems.
  • Installation and Configurations of SOA/OSB 11g/12c on all Platforms (Linux, Solaris, AIX and MS Windows, etc.). With Single instance and High availability architecture.
  • Troubleshooting all issues related to SOA/OSB with different aspects.
  • Performance Tuning for SOA/OSB to fast execution of Interfaces/Mapping, Packages and Load Plans.
  • Configuration of SSL over SOA/OSB.
  • Configuration of OHS (Oracle Http Server) over SOA/OSB.
  • Upgrade SOA/OSB 11g to 12c.
  • Installation, Configuration and patching WebLogic Single instance/ High Availability environments.
  • Tuning all kinds of deployment under Weblogic Servers.
  • Troubleshooting and analyse thread/heap dumps to identify issues root causes.
  • Migrating WebLogic instance between various environments under all platforms.
  • Integrating different built-in system components with both J2EE and .NET technologies.
  • Development and modifying of standard and customized screens using RAD Tool.
  • Development of web services over FCUBS gateway which can be integrates with external systems.
  • Development of Reports Screens integrated with BIP server.
  • Development of Generic Interfaces (GI) to import/export files.
  • Configuration of FCUBS Running batches during EOD.
  • Development of Third party applications which integrates with FCUBS to print transactions advices.
  • Patching FCUBS.
  • Experience in analysing data using HiveQL 2.1.1 and custom MapReduce programs in Java.
  • Experience in working with NoSQL databases like Impala 2.7.0, Hive 2.1.1 and Oracle NoSQL.
  • Experience with configuration of Big Data Connectors and integrate with OBIEE.
  • Experience with loading data from HDFS using ODI.
  • Experience with Kafka architecture, Connect, Producer and Consumer APIs.
  • Experience with Kafka Messaging mechanism between HDFS and databases Province Experience in Development of Banking Business applications using Microsoft .Net Framework, ADO.NET, Entity Framework, LINQ, WebAPI and Microsoft Enterprise Library.
  • Experience in Development of Banking Business application using JSP/Servlet, Struts and ADF.
  • Experience in Development of the integration of Oracle applications using Web Services Or Java Connectors.
  • Experience in PL/SQL and T-SQL Development of over Oracle, SQL Server Databases (Stored Procedures, Triggers, Functions, Packages, Etc.).

Employment History

Confidential

Business Intelligence & DWH Manager

Responsibilities:

  • Business requirement gathering and analysis.
  • Upgrade/Migrate All FMW Products from 11g to 12c across all platforms.
  • Development of DWH modelling, reports and Dashboards using OBIEE.
  • Development of ODI ETLs with various strategies and mechanism like incremental load, CDC and SCD.
  • Troubleshooting advanced and critical issues over Weblogic Server across all FMW Products.
  • Development of BPEL workflows using various JCA adapters to meet business requirements.
  • Development of various Business Services using Oracle Service Bus OSB.
  • Integrate FMW Products with Security Providers like Microsoft Active Directory.
  • Deployment of SSL certificates over all FMW Products.
  • Development of Web applications using ADF/APEX.
  • Installation & Configuration of Oracle Felxcube 11.x & 12.x
  • Development of FCUBS Canned Reports
  • Development of DWH/Data Marts using OBIEE/BIP for FCUBS different business areas like (CASA, CIF, Loans, Trade Finance, Treasury).
  • Development of FCUBS Banking Load Plans using ODI.
  • Development of FCUBS screens using RAD (Development Workbech).

Confidential

Senior Technical Consultant

Responsibilities:

  • Upgrading OBIEE project from 10g to 11.1.1.7 (Repositories and Catalogs files).
  • Upgrading Informatica from 8.6 to 9.5.1 (backup and restoring ETLs).
  • Configuring DAC with Informatica servers and schedules.
  • Installing BIAPPS 7.9.6 on AIX OS and testing all reports and dashboards.
  • Installing and configuring UAT and Production Environment under AIX operating system.
  • Developing ETL using Informatica to pull data from different OLTP sources to DWH.
  • Work with various layers including presentation, business and physical layers.
  • Involve in data modelling through the use of star schema and dimensional modeling.
  • Administrating Oracle Database, WLS and OEM.
  • Install, configure Oracle SOA/OSB 11g across different platforms.
  • Working on development of BPEL workflow to integrate with different systems.
  • Present analytics, reports and dashboards in template.
  • Working with Oracle Golden Gate (Dual mode and single mode) to integrate databases.

Confidential

Software Engineer

Responsibilities:

  • Install and configure database solutions through the OBIEE tools
  • Configure the domain specifications and create repositories
  • Create domain groups and add users in the group
  • Develop and design dashboards, reports, ad hoc queries and analysis
  • Work in collaboration with business users and internal teams
  • Work on data with physical, presentation and business layers
  • Design and develop business reports using BIP.
  • Prepare other types of reports through the use of local and global filters
  • Ensure security arrangement for database and dashboards according to the need of end users or project
  • Identify issues and problems and troubleshoot them.
  • Working as WLS and OEM Administrator for deployment any services which will integrate with OBIEE.
  • Monitoring OBIEE services and performance.
  • Working on tuning database to make sure that OBIEE gives best performance.
  • Design and develop banking applications using Java and C#.net.
  • Install &configure Oracle Database, WLS, OEM and OBIEE on Linux Redhat.
  • Designing creating and maintaining Repository (physical, Business Model, Mapping and Presentation Layers).
  • Adding multiple Logical Table Sources and Calculations to a Fact Tables
  • Create, configure, maintain and customize analysis, dashboards, action links, Graphs and KPIs.
  • Administering the Oracle Business Intelligence Presentation Catalogs.
  • Applying different security types (object level and data level).
  • Integrating security with LDAP external authentication.
  • Configure OBIA 11g Functional Tasks for Financial, SCM and HR Modules.
  • Configure OBIA Parameters (Initial Extract Date, Master Org, etc.).
  • Configure Oracle financial Analytics Mapping, COA, GL Group Accounts, Financial Statements Codes, etc.)
  • Handle all the documentation for user operational guide.
  • Working on the integration between Siebel CRM and Dynamics CRM after acquiring
  • Integrate Master data between Siebel and Dynamics CRM using ESB.
  • Developing Business Services using ESB to grab data from Siebel to LDN portal.
  • Integrate with Mobinil SMPP Protocol to send SMS from Dynamics CRM.
  • Install and configure WLS, OEM and OBIEE.
  • Designing creating and maintaining Repository (physical, Business Model, Mapping and Presentation Layers)
  • Adding multiple Logical Table Sources and Calculations to a Fact Tables.
  • Creating dimension Hierarchies and Level-Based Measures (including share and rank measures).
  • Data modelling such as time-series, and many-to-many relationships.
  • Creating/setting permissions for users/groups, authentication and setting limits/filters on data access.
  • Use of cache manager, inspecting cache reports, purging cache entries, seeding the cache and modifying cache parameters.
  • Create, configure, maintain and customize dashboards
  • Develop ETL to move data from sources to staging areas then to targets using ODI 12c

Hire Now