Muhammad Sunil Bokhari, Data Warehouse Design Developer in Melbourne, Victoria, Australia
Muhammad Sunil Bokhari

Data Warehouse Design Developer in Melbourne, Victoria, Australia

Member since August 26, 2015
Muhammad is an IT professional with over ten 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

Experience

Location

Melbourne, Victoria, Australia

Availability

Full-time

Preferred Environment

Windows, Linux, Unix

The most amazing...

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

Employment

  • Practice Lead

    2020 - PRESENT
    ASG Group
    • Delivered 13 data warehousing and BI projects successfully, nine of them for the Victorian government.
    • Held regular showcases with senior management in DHHS to walkthrough reporting and visualization deliverables and incorporated feedback received from the business.
    • Set up CI/CD for data warehousing in DHHS using release pipelines technology of Azure DevOps.
    • Successfully delivered a stimulus dashboard for Homes Victoria (previously part of DHHS), enabling them to accurately monitor spending as part of the Victorian government response to COVID-19.
    Technologies: Microsoft Power BI, Tableau, SQL Server Integration Services (SSIS), Azure
  • Technical Solutions Architect

    2019 - 2020
    ASG Group
    • Defined data architecture for the ASG managed services division along with solution identification and tool selection for the data lake.
    • Successfully migrated on-premises procurement analytics to Oracle Cloud for DET in a hybrid cloud setup, with data sourced from on-premises SAP Ariba.
    • Actively worked with ASG account directors to engage with clients, work on bids, and define a solution architecture for proposals.
    Technologies: Oracle BI, Oracle Cloud, Oracle Data Integrator (ODI), Oracle Analytics Cloud (OAC), Microsoft Power BI, Azure
  • Technical Lead | Senior BI Developer

    2016 - 2019
    Department of Justice and Community Safety, State Government Victoria
    • Performed end-to-end business analyses. Designed and implemented BI solutions.
    • Provided support to the business for an analytics solution delivered in production.
    • Took part on the agile BI team managing the central data warehouse and BI solutions for DJCS.
    Technologies: Oracle BI Apps, Oracle Database, SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Oracle Data Integrator (ODI), Oracle BI
  • Senior Business Intelligence Consultant

    2012 - 2016
    DXC Red Rock
    • Contributed as a member of the BI and EPM team in Victoria.
    • Owned the design and implementation of Oracle BI solutions for clients.
    • Provided services for different clients including the State Government Victoria, TWE, NAB, and City West Water.
    Technologies: Oracle Database, Oracle Data Integrator (ODI), Oracle Business Intelligence Enterprise Edition 11g (OBIEE), SQL, Informatica, SSRS
  • 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 Business Intelligence Enterprise Edition 11g (OBIEE), Oracle BI, Oracle Service Bus, Oracle SOA Suite, IBM Cognos, Oracle Data Integrator (ODI)
  • 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: SharePoint, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Ultimus BPM, Cognos 10, ArcGIS, SAP Plant Maintenance

Experience

  • Compliance and Monitoring Reporting Project | Department of Health and Human Services, Victoria (Development)

    o As the functional and technical lead, I engaged with end-users to understand business requirements, define feature changes and user stories, and then lead the design and implementation of data models.
    o The purpose of the project was to deliver visualization capabilities for six identified pain points.
    o As part of this project, I successfully delivered a Stimulus reporting dashboard that enabled the department to accurately monitor spending as part of the Victorian government response to COVID-19.
    o I also set up cloud-based analytics on the Azure platform, with a data warehouse in AzureSQL and Tableau visualization.

  • QuickWins Reporting Project | Department of Health and Human Services, Victoria (Development)

    o As the technical lead, I led the design and implementation of data models.
    o The business had identified critical business requirements that were required to be delivered immediately.
    o I successfully delivered all requirements within an identified timeframe.
    o Set up cloud-based analytics on the Azure platform, with a data warehouse in AzureSQL and Tableau visualization.

  • Oracle Analytics Cloud Planning and Implementation Project | Dept. Education and Training, Victoria (Development)

    o As a data architect, I designed the data architecture for procurement analytics, including data repositories and data functions.
    o As the technical lead, I successfully migrated on-premises procurement analytics to Oracle Analytics Cloud.
    o The scope of the project included identifying a target hybrid cloud solution and defining tasks in the migration.
    o The migration included upgrading the existing code, enabling data traffic between on-premises and Oracle Cloud, reloading the data warehouse, and the reimplementation of reports in the Oracle DV tool.
    o The project was delivered successfully and within defined timelines.

  • Enterprise Architecture and Strategy for Managed Services | ASG Group (Development)

    o I was responsible for establishing the technical architecture for ASG managed services division.
    o The project involved identifying and categorizing data critical to the organization.
    o I identified data required for SLAs, KPIs, and service agreements, including client reporting requirements.
    o I also planned and identified a solution for data lake implementation to capture data from disparate sources including SM9, Nagios, CISCO, and Oracle ERP.

  • Oracle ERP Financial, Time and Labor Reporting | ASG Group (Development)

    o As the BI and analytics lead, I was responsible for delivering internal ASG reporting on Oracle ERP Cloud.
    o I led requirements gathering sessions with various stakeholders and business process owners.
    o I managed the overall delivery of analytics and reporting stream as well as support.
    o I was also involved in the hands-on development of data models, ETLs, and analytics/visualizations.

  • Marval PowerBI Reporting | ASG Group (Development)

    The project involved migrated the existing Remedy-based PowerBI reporting to Marval-based reporting. This required changing visualizations on the existing source, as well as remapping data from the new table schemas.

  • Multiple Projects at the Department of Justice and Community Safety, Victoria (Development)

    o I architected the design of the adapter model, the corporate information model (CIM), the data warehouse model, and business models for PTRS, PME, and other BI projects.
    o I designed the data model and reports using the Microsoft BI stack for the Rostering for Prisons project used heavily 24x7 across Victoria State’s prisons.
    o I implemented an analytics solution for finance and procurement for DJR.
    o I also implemented BI apps HR analytics with source data from Chris21 (HR system).
    o I designed a custom prisoner movement reporting and analytics solution combining data from various sources including Corrections Victoria and Victoria Police.
    o I implemented the regional services network (RSN) BI performance reporting.
    o I designed and implemented a custom legal services panel BI solution for the civil law policy division in DJR.
    o I also designed and implemented the prisoner transport reporting system (PTRS) analytics, using Informatica and Oracle BI.

  • 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

    T-SQL, SQL
  • Tools

    Tableau, Informatica ETL, IBM Cognos, Microsoft Power BI, Oracle Business Intelligence Enterprise Edition 11g (OBIEE)
  • Paradigms

    Azure DevOps, ETL Implementation & Design
  • Platforms

    Oracle Data Integrator (ODI), Oracle BI EE 11g, Azure, Oracle Database
  • Storage

    SQL Server Integration Services (SSIS), Azure SQL, SQL Server Reporting Services (SSRS), Oracle Cloud, SQL Server 2012, Database Modeling
  • Other

    Oracle Analytics Cloud (OAC), Data Warehouse Design, Data Modeling, Solution Design, Oracle BI, Oracle BI Apps, Data Integration Platform Cloud (DIPC), Data Warehousing, Solution Architecture, Oracle Transactional BI (OTBI)
  • Libraries/APIs

    ArcGIS

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

Certifications

  • Microsoft Certified: Azure Fundamentals
    AUGUST 2020 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others