Ajax, Ontario, Canada
Experienced Developer/Consultant with a demonstrated history of working in the computer software industry. Skilled in Databases, Data Warehousing, Dashboard, Business Intelligence, and Data Warehouse Architecture. Strong professional with a Master of Science focused in Automation and Robotics from Warsaw University of Technology. ● Extensive hands on development experience with Desktop, Architect, Intelligence Server, Report Services, Enterprise Reporting, Transaction Services, Mobile and Web. ● Experience in schema design and creating schema objects using Star and Snowflake (Hierarchies, Attributes, Facts and Transformations). ● Excellent experience in MicroStrategy report development, report testing and report tuning. ● Extensive experience with all types of MicroStrategy Filters, Prompts, Templates, Metrics, Consolidation and Custom Groups. ● Experience with using Command Manager, Object Manager, System Manager and Enterprise Manager. ● Experience with configuring VLDB properties to fine tune reports. ● Experience with SDK customizations for MicroStrategy Web. ● Completion of MicroStrategy Bootcamp and MicroStrategy MCE and MCES Certified. ● Worked on multiple enterprise reporting, web and mobile projects with exposure to different industries including hospitality, telecom and insurance. ● Exceptional ability to quickly master new concepts and capable of working in groups as well as independently. ● Strong analytical, troubleshooting, performance tuning and problem solving skills coupled with excellent written and verbal communication.
Focused on designing high level Dashboards Building POWER BI Dataflows, Semantic Models for high visibility reports / dashboards Paginated Reports DAX Tuning, Power Query tuning, Power Bi Administration Creating complex DAX measures, DAX calculated groups and summarized tables to display data from different sources (and at different levels of aggregation) with single grid, that would be also used for other visualizations or other reports and dashboards. Cleaning up and aggregating the data within the dataflows and semantic models. Separating dimensions if not available in the existing data warehouse (data warehouse is in design stage and not all tables are available there) Bringing data from multiple sources (SQL Server, Azure Databricks, Postgres) and merging it within Power BI
Focused on supporting and designing high level sales reports / Dashboards / Dossiers for Astrazeneca Canada. Migration project of the MicroStrategy reports, and Dashboards to Power BI. Over the timespan of 14 months migration and modifications were required for all Dashboards, Reports and Documents from MicroStrategy to Power BI. Building from scratch Power Bi data flows, semantic models for high visibility Power BI reports and Paginated reports, to meet the requirements from business users Building calculated groups, complex multilevel measures and calculated fields to meet business requirements.