Supporting client in Pharmaceutical industry with Power BI Development.

• Orchestrated the transformation from a startup-like environment to a company supported by data and project management best practices.

• Developed and implemented Power BI dashboard to efficiently monitor and assess the status and financial PnL performance of projects.

• Created a Project & Portfolio Manager (PPM) tool using MS PowerApps & Dataverse, seamlessly integrated with Power BI for portfolio performance tracking.

• Automated key operational processes using Power BI and MS Power Automate, enhancing efficiency and accuracy.

• Setup HR & Recruitment reports to track company head count, hiring, location diversification and other metrics.

• Facilitated 360 Review Q&A creation, as well as reports to analyze and visualize the data. Helped setup row-level security for managing access permissions.

• Developed report to analyze company’s yearly financial performance based off QuickBooks data.

• Oversaw all ETL and infrastructure processes related to Power BI, Power Automate & PowerApps

• Standardized and established security groups access across company’s resources

• Established an analytics framework using Power BI to track and analyze KPIs across the studio and product portfolio.

• Consolidated information from multiple project, resource, and attendance planning systems (JIRA, TargetProcess, TestRail and other) into series of Power BI reports to track portfolio performance.

• Led project to receive tax deduction for R&D activities, being responsible for data gathering, transformation, cleanup and reports preparation.

• Developed Python data-scraping script to extract data from JIRA API.

• Developed Python data-scraping script to extract data from TestRail API.

• Developed report(s) to track performance of external QA partners.

• Led cross-functional teams, aligning project goals with business objectives, and ensuring successful project deliveries.

• Setup reports to track HR-related matters for Prague studio.

• Optimized P&C lab utilization by shortening tests based on game crash data.

• Developed KPIs and prediction metrics to track SLA and project performance.

• Developed reports to track financial health, PnL and other metrics for the project.

• Support ETL processes for exctracting data from internal systems.

• Pioneered the development of BI models using Power BI and Python, contributing to the success of multiple high-stakes projects.

• Led workshops across company about BI systems (namely Power BI) for enhanced project management and performance analysis.

• Developed and taught an in-depth SQL course, elevating database management and analytical skills across company’s employees.

• Developed supporting reports for Employees performance analysis.