Muhammad Sunil Bokhari

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.

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.

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.

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.

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.

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.

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, 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.

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.

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.