Scroll To View More
Muhammad Sunil Bokhari, Oracle BI Developer in Melbourne, Victoria, Australia
Muhammad Sunil Bokhari

Oracle BI Developer in Melbourne, Victoria, Australia

Member since August 26, 2015
Muhammad is an IT professional with over 10 years of experience designing and implementing data warehouse solutions using Oracle BI, Cognos, SSRS, Oracle BI for Utilities, Oracle Data Integrator, Informatica, Oracle Warehouse Builder, and Oracle BI Apps. He's a great communicator and is comfortable working solo or in a team.
Muhammad is now available for hire

Portfolio

  • UXC Red Rock Consulting
    SSRS, OBIEE, ODI, Informatica, DAC, SQL
  • Infotech
    Oracle BI (OBIEE), Oracle Data Integrator (ODI), IBM Cognos, OBIU, Oracle SOA...
  • Eni Pakistan
    SAP Plant Maintenance, ArcGIS, Cognos, OBIEE, Ultimus BPM...

Experience

  • SQL, 6 years
  • Oracle Data Integrator 11g, 5 years
  • Informatica, 4 years
  • Oracle BI, 4 years
  • ArcGIS, 2 years
  • Cognos 10, 1 year
  • Oracle Service Bus, 1 year
  • SSRS, 1 year
Melbourne, Victoria, Australia

Availability

Part-time

Preferred Environment

Unix, Linux, Windows

The most amazing...

...thing I've designed is a complex data warehouse with data being received from different geographical subsidiaries.

Employment

  • Senior Business Intelligence Consultant

    2012 - PRESENT
    UXC Red Rock Consulting
    • Contribute as a member of BI and EPM Team in Victoria.
    • Responsible for designing and implementing Oracle BI solutions for clients.
    • Provide services for different clients including State Government Victoria, TWE, NAB, and City West Water.
    Technologies: SSRS, OBIEE, ODI, Informatica, DAC, SQL
  • Solution Architect - IBM/Oracle

    2011 - 2012
    Infotech
    • Led a team of consultants focused towards delivering solutions related to business intelligence and middleware technologies.
    • Implemented a Cognos BI Solution and Oracle BI for Utilities (OBIU) for a gas Uutility company.
    • Provided 216 hours of Oracle University OBI courses, with satisfaction rate in feedback up to 99.05%.
    Technologies: Oracle BI (OBIEE), Oracle Data Integrator (ODI), IBM Cognos, OBIU, Oracle SOA, Oracle Service Bus
  • Technical Applications and SOA Expert

    2005 - 2010
    Eni Pakistan
    • Responsible for evaluating, developing, implementing, and supporting applications within the organization.
    • Successfully migrated maintenance operations for the Bhit Gas Plant from Maximo CMMS system v 4.2 to SAP Plant Maintenance module ECC 6, responsible for all SAP implementation activities at the plant site, managing approximately 25-30 personnel.
    • Evaluated and implemented BI Tools, including Cognos and Oracle BI. Delivered POCs and presented to the management. Involved in functional document design, project planning, and execution.
    • Analyzed, designed, and implemented business processes related to contracts and procurement as well as finance on Ultimus BPM and Microsoft SharePoint Portal 2007.
    • Set up GIS infrastructure in Eni Pakistan, providing the capability to the exploration department to conduct spatial analysis and advanced cartography. Set up Eni Pakistan's intranet-based online GIS portal (Java-based website).
    Technologies: SAP Plant Maintenance, ArcGIS, Cognos, OBIEE, Ultimus BPM, SharePoint Portal 2007

Experience

  • Software Suite at Dept. of Justice for the State Government of Victoria (Development)

    Performed end-to-end analyses as well as designing, implementing, and testing Informatica ETLs, DAC, and OBIEE. Designed, implemented, and supported an integrated Project Management Excellence (PME) BI system used within the DOJ for project management. Designed and implemented analytics for the Prisoner Tracking System (CV PTRS), involved Extract Transform Load (ETL) routines using Informatica, OBIEE Repository customization, Data Warehouse Administration Console (DAC), and reports/dashboards. Architected the design for Adapter Model, Corporate Information Model (CIM), Data Warehouse Model, and RPD Business Models for PTRS. Developed reports on Microsoft SQL Reporting Services for Rostering for Prisons project.

  • Global BI/DW Project for Treasury Wine Estates (Development)

    Global BI/DW project, with the purpose of providing uniformed global reporting/analytics for the management of TWE. The project includes building a data warehouse with data flowing in for ANZ, Asia, EMEA, and North America regions of TWE. We used Agile BI methodology. The role involves end-to-end analyses as well as designing, implementing, and testing Informatica ETLs, DAC, and OBIEE, along with modifying an existing BI Apps-based solution.

  • ODI Solutions - NAB (Development)

    Configured an ODI console environment. Designed POC ETL process using custom knowledge modules. Documented "ODI Migration Strategy & Approach," outlining a roadmap for BISC's transition from existing DTS & PL/SQL based ETL Engine to ODI based ETL. Conducted a brown bag session for BISC on ODI.

  • The Arrow Program, City West Water (Development)

    Gathered requirements and documented the solution design for Oracle BI for Utilities (OBIU) and Oracle BI Apps. The scope of OBIU included CC&B BI. BI Apps modules included EBS Oracle GL, Projects, Procurement, Fixed Assets, and Contracts. Customized Oracle BI Apps for Procurement, creating new OBIEE reports and dashboards and Informatica ETL. Integrated OBIEE with Oracle Enterprise Content Management, using managed attachment functionality.

Skills

  • Languages

    SQL, C++, C, Java, JavaScript
  • Tools

    SSRS, Oracle Warehouse Builder (OWB), Oracle Service Bus, Oracle SOA Suite, Oracle Business Process Management (BPM)
  • Platforms

    Oracle Data Integrator 11g, Oracle BI EE 11g, Oracle Database
  • Other

    Informatica, Oracle BI, Cognos 10, Ultimus BPM, Oracle WebLogic Application Server
  • Libraries/APIs

    ArcGIS
  • Storage

    MySQL

Education

  • MBA degree in Finance
    2006 - 2009
    Institute of Business Administration - Karachi, Pakistan
  • Bachelor of Science degree in Computer Science
    2001 - 2005
    National University of Computer and Emerging Sciences - FAST - Karachi, Pakistan
I really like this profile
Share it with others