Peter Krivanek Email and Phone Number

• Leading end-to-end data analytics development for the Aged Care division (Residential Aged Care, Home Care)• Collaborating with business stakeholders to identify key performance indicators (KPIs) and develop metrics related to residential age care, home care and staff productivity. • Collaborating with stakeholders across the organization to understand business needs and translate them into technical requirements for data analytics solutions. • Creating conceptual, logical, and physical models for the enterprise data warehouse to ensure data is structured and organized in a way that supports efficient and effective analytics. • Building and maintaining data pipelines to ensure the accuracy and completeness of data used in analytics, including data extraction, transformation, and loading (ETL) processes.• Designing and developing PowerBI models, creating, and managing datasets to enable self-service analytics for end-users in the organization.• Supporting and developing analytical solutions for other divisions and areas of SVHA.

• Managing end-to-end data architecture, from selecting the platform, designing the technical architecture, and developing the application to finally testing and implementing the proposed solution. (Azure Cloud Services)• Developing and implementing an overall organizational data strategy that is in line with business processes. The strategy includes data model designs, database development standards, implementation and management of data warehouses and data analytics systems. (3NF, Star Schema, Tabular Models)• Identifying, designing, and implementing internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability (Agile Azure DevOps)• Building analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics (Log Analytics, PowerBI)Technology and Architecture:• End-to-End Analytics Development – Full Microsoft Stacko Data Storage – Azure Data Lake Gen2o ETL processes - SSIS/Data Factory/Synapse Pipelineso Data Warehouse – Azure SQL, Azure Synapse SQLo SSAS/Cube – Tabular, PowerBIo Reporting – Interactive and static reporting• Azure Data Development Structure• Azure Cost Optimization• Systems Performance Optimization (Indexes, SQL queries, store procedures)• PowerBI Performance Optimization (Cube size, Refresh Times, Dax Query)Projects:• Data architecture development & maintenance – Azure Synapse SQL• Continuous Integration & deployment – Azure Devops (Agile)• Data Security & Audit Model Implementation – Azure Security & Audit • Meta Data Strategy/Framework Model Implementation – Azure Purview

Key Achievements:• Transition from Excel Reporting into PowerBI (Built tabular models and reports)• Streamlined sales/account managers’ workday by combining few systems into one platform (Operational reporting in PowerBI for sales)• Trained BI team of using different systems - Azure Cloud, PaaS, SQL, PowerBI• Built Microsoft BI architecture and its parts with use of the latest technology (Azure Cloud Services, PaaS)• Built close relationship with partners, wholesalers and an outsource IT team Successful implementation of Business Intelligence solution, which includes data warehouse, data cubes and reports development, adoption, governance and training with use of cutting-edge technology. Some of them used are as follow, Azure and its services such as SQL Database, Data Factory, Blob Storage, Sync Service, the most advanced Microsoft Power BI premium and additional linked software Business Central and Dynamics 365.Apart for being responsible for BI implementation, I have been closely working with an outsourced IT company, our sales team and business analysts to leverage use of the latest CRM.Providing expertise in data modelling, data cleansing and real time data processing.Gathering, design, development and implementation of the portable workflow system, construction of exemplar workflows, deployment of a testing system, and the authoring of documentation and training materials.Identify gaps in processing systems and methodologies, working to improve stability and performance.Continuously improve automation capabilities, reducing operational overhead and riskEvaluate existing processing systems and methodologies and provide recommendations for improving functionality and processing efficiencies

Achievements:● Developed and implemented the entire BI and replacing excel reporting for finance and sales. ● Contribute to CRM implementationDiscussing, preparing and identifying user requirements specifications followed by its developing, implementing and testing.Evaluating business processes and its optimization and implementationEnsuring professional project competency by establishing and maintaining models, processes, templates and best practices for IT project managementResponsible for creating functional specifications for different departments of the company (Customer Service, Finance, Sales Team, Supply Chain)Collaborating with developers and developing functional specifications to assure sufficient quality and integrity of the systemsPreparing business process BPMN models to ensure a correct flow of processesHolding regular project progress meetings with stakeholders.Conducting end-user training of various systemsERP - Microsoft Dynamics CRM - Microsoft DynamicsCRM - Stay In FrontBusiness Intelligence StackSSIS, SSRS, SSASCloud Azure Services (SQL, SQL Warehouse, Data Factory, Blob Storage)SQL Designing and Modeling, Tabular Designing and Modeling, Writing DAX, Building Power BI ReportingIntegration BI Reports in CRMData Management across all systems

Achievements:● Provided accountability, tracking and reporting capabilities for student testing data● Researched and full implementation of innovative technology (projectors, tablets)