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 cloud data warehouse and Lakehouse platforms, and providing technical support for deploying AI platforms. Adept at identifying and evaluating opportunities to improve system and process efficiencies, troubleshooting and resolving Business Intelligence system and process integration issues, and managing organizational Data Governance processes.Key Skills:Modernizing Data & Analytics infrastructure and capabilitiesDesigning enterprise-level cloud data warehouse and Lakehouse platformsProviding technical support for the deployment of AI platformsFostering data-driven organizationsTroubleshooting and resolving Business Intelligence system and process integration issuesManaging organizational Data Governance processesDeveloping and maintaining data modelsIdentifying and evaluating opportunities to improve system and process efficienciesRevenue growth from information products and services

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 expertise and experience.• 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.• Provide and enable the technical capability to support the deployment of AI Platform.• ldentify, evaluate, recommend and action improvements to enable system and process efficiencies.• Subject matter expertise provided to support with the development of reports to meet business needs

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.• Create Dashboard showing data insights of PnL accounts.• Deploy reports and dashboard to server workspace for Specific teams.Finance Data warehouse Sodexo:Requirement is to Integrate data from several clients and build a scalable data warehouse which will be used to create insights and reports.• Review existing architecture and suggest design change.• Adding new and modifying entities in Master data Services.• Add and modify source files in Blob storage.• Create stored procedure to create Dimensions and Fact in data warehouse.• Create scalable and agile data model using Analysis service tabular model and publish to server.• Develop the report using PowerBI with drill thru functionality.• Create Dashboard showing data insights and trends of all 12 source data.• Deploy reports and dashboard to server workspace for Specific teams.• Give permissions to users to specific work group

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 provide data insight of historical data for all 140 catholic schools in various departments.• 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.• Applying customized color palette to reports to match company's internal colors.• Implementing security by defining roles using DAX.• Schedule data refresh and emailing to specific user group for everyday standard reports.• Created reports with drill thru capabilities for greater data analysis.

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 various departments across the globe.• 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.• Developed SSIS package to POST Promotion Data using REST JSON to API.• Testing and Deploying in Dev and UAT Environments.• Involved in leading team with meeting updates and Scrum calls.• Creating user stories in JIRA and updating progress of Team • Creating Release documents, Analysis and approach documents.

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 in DTS and developing SSIS package from the scratch. Testing phase involved in Creating Snapshots for Quick restoration of Database. Optimizing code. Unit testing, writing test cases, Database Tuning. • Role – Developer• Developing Complex SSIS Packages using ETL concepts• Testing and Documentation of SSIS Packages• Creating Snapshots, Databases, Schemas.• Handling all kinds of Transformations.• Migration of DTS Packages to SSIS Packages• Hands on SQL Server 2008• Writing coding in VB Script and VB.net• Writing and designing Complex Queries, Stored procedures, Triggers, Indexes and views.• Configuring SSIS packages.• Technology– SQL Server 2000, MS SQL Server 2005, VB-Script, SSIS,DTS• Total project effort is 6 man months

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 Application.Application is multi-client supportable with multiple hierarchies. Requirement was to build robust ETL so that application can support multiple clients dynamically.Here data input was EDI (Electronic Data Interface) files, Excel which are complex to handle.ETL application was handling process of data integrity, business logic. o Title – Sr.Software Engineer• 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.• Deployment and test in remote serverso Creating and Managing Indexes and Constraints.• Replication of Tables.o Technology (Specific to my role) – MS SQL Server 2008, MS SQL Server Integration Services, MS Visio, VB-Script and VSS

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 use, it has been decided to used a replica of the ODS. So this Project is designed to validate and verify the Consistency of ODS. Job will be created for each Object and Exception data will be Produced and stored In database. There were around 400 jobs created to perform Data quality check.o Title – ETL Developer• 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.• Also Involves in Scheduling Jobs.o Technology (Specific to my role) – MS SQL Server 2005, MS SQL Server Integration Services, MS Visio, VB-Script and TFS

Master Of Computer Applications (Mca), Computer Software Engineering

Have Studied Master of Computer Applications.

Sslc, High School/Secondary Diplomas And Certificates

schooling