Guru Prasad Email & Phone Number

Perth, WA, AU

Perth, Western Australia, Australia

Spearheading the implementation of cutting-edge data platforms using Microsoft Fabric and PowerBI to empower 190 clients with insightful analytics and actionable insights. Dedicated to optimizing data-driven decision-making processes and enhancing operational efficiency on a scalable level.

Perth, Western Australia, Australia

Professional Summary:Accomplished Data and Analytics Manager with extensive experience in modernizing Data & Analytics infrastructure and capabilities, enabling revenue growth from information products and services, and fostering data-driven organizations. Skilled in creating community-centric modern Data & Analytics strategies, designing enterprise-level.

Perth, Australia

• Development of the strategy and governance framework for Wes Trac's corporate data platforms.
• Architecting and delivery of WesTrac's business intelligence and Al software and corporate data platforms and technical specifications in line with the Bl strategy and framework.
• Troubleshoot, triage and resolve any and all Business Intelligence system and process integration issues to ensure no disruption to platform and data availability and accuracy through application of deep Bl technical.
• Strong cross functional engagement and collaboration with key stakeholders to identify data needs through interpretation of business requirements, selecting appropriate solution options and designing the solution.
• Identification of current sources to be integrated into the data platform and development of integration plans.
• Development and maintenance of data models to ensure scalability and integrity.

Perth, Australia

• Department of Finance:This requirement is to develop PnL reports for CFO to have insights on accounting data. This report will be shared across accounting team.
• Analyse requirement and source tables to meet PnL visuals.
• Create stored procedures to create Dimensions and Fact in data Lake.
• Connect PowerBI to Sql server tables and Integrate data into model.
• Create scalable and agile data model.
• Develop the report using PowerBI with drill thru and bookmark functionality.

Perth, Australia

• Client: Catholic Education of Western Australia (CEWA) CEWA is the head office for all Catholic schools in Western Australia.Project is to replace existing legacy reports with Interactive PowerBIDashboard and to.
• Creating data model in PowerBI Desktop and Publish to PowerBI services for shared usage of model.
• Design dashboard to give insight of finance, school ICSIA scoring, staff and other domains.
• Created Symantec layer to Integrate and transform data into star schema dimensions and fact in Azure DB.
• Create calculated measures using DAX and automate, transform data using 'M' language.
• Simplified development by creating template and functions which standardized across all developers and reports.

Singapore

• Credit Agricole is Leading Investment bank where data warehouse was built on MSBI Stack.Current project provides wide range of KPI’s and Dashboards which will help COO’s to determine Growth and current status of.
• Creating SharePoint site and hosting
• Integration of SSRS reports to SharePoint site
• Creating SSIS Package to create csv files to support reporting
• Developing daily Reports which will display SSBT values
• Designing SSAS cube to support many to many relationship with customer and terminals.

Working on Oracle Business Intelligence as Tech Lead

Bengaluru Area, India

• SSIS architecture was re-developed the approach and design is completely changes. Even though migration wizard was provided by Microsoft only for few components. So this project involved in analyzing the business rules.
• Role – Developer
• Developing Complex SSIS Packages using ETL concepts
• Testing and Documentation of SSIS Packages
• Creating Snapshots, Databases, Schemas.
• Handling all kinds of Transformations.

• Krunchbox is the application which provides BI analysis and statistics for clients. Application design was data retrieval from cubes using SSAS, ETL using SSIS and Presentation or reporting using.Net.
• Role – Analyzed customer requirements and Develop SSIS package designing the ETL Architecture basing on data model.
• Writing Complex Stored procedures, UDF’s.
• Developing end-to-end ETL process.
• Preparing Visio Diagram for ETL Design.
• Preparing LLD’s and Unit Test cases according to the Client’s Specification.

• Involved in development of Reconciliation project The preliminary purpose of this project is to validate and verify the ODS data. Since Production data cannot be used for development and due to the nature of resource.
• Role – Analyzed customer requirements and Develop SSIS package Designing the ETL Architecture basing on data model.
• Writing Complex Stored procedures, UDF’s.
• Preparing Visio Diagram for ETL Design.
• Preparing LLD’s and Unit Test cases according to the Client’s Specification.
• Deployment process and making of Release Notes.

Master Of Computer Applications (Mca), Computer Software Engineering

Have Studied Master of Computer Applications.

Sslc, High School/Secondary Diplomas And Certificates

schooling