Amna Bajwa Email & Phone Number

Ottawa, On, Ca

Ottawa, Ontario, Canada

• Initiated and managed the strategic migration from Tableau to Power BI, integrating SharePoint Online and Lists to optimize data workflows and deliver a 30% increase in analytics efficiency, enhancing decision-making and user engagement• Crafted sophisticated Power BI dashboards utilizing SharePoint lists for data management, leveraging advanced warehousing insights to accelerate strategic decisions by 20%• Streamlined and automated essential business processes with Power Automate, reducing operational redundancies by 15% and boosting overall productivity, reflecting a keen aptitude for enhancing business operations efficiency• Engineered and deployed innovative Power Apps integrated with SharePoint Online, significantly improving data management and operational workflows within tight budgetary and time constraints• Directed project management efforts to align SharePoint and Power BI solutions with corporate goals, ensuring effective stakeholder communication, which facilitated the delivery of solutions that drove key business objectives and collaboration• Developed and implemented complex data models in Power BI, utilizing SQL and DAX to establish star schema architectures, optimizing data relationships for improved query performance and insightful analytics

Ottawa, Ontario, Canada

• Integrated Power BI and Power Automate to automate data processing, enhancing decision-making speed and accuracy by 35%𝘾𝙡𝙞𝙚𝙣𝙩 : 𝗘𝗻𝗲𝗿𝗰𝗮𝗿𝗲• Developed a predictive maintenance dashboard in Power BI, leveraging IoT sensor data and analytics to preempt equipment failures, resulting in a 45% reduction in unscheduled repairs and significantly enhancing operational reliability• Engineered a Power BI-based revenue optimization framework by analyzing inefficiencies through advanced DAX formulas, identifying inefficiencies that led to operational adjustments and a 22% increase in service profitability• Implemented an automated data processing pipeline with Azure Data Factory and Power BI, enhancing data refresh rates by 30%, which enabled timely and informed decision-making with up-to-date insights• Designed a customer segmentation analysis tool within Power BI, utilizing DAX to dissect service usage patterns, thereby empowering the marketing team with precise data for crafting targeted outreach campaigns• Utilized Power Automate in conjunction with Power BI for automating report generation and distribution, streamlining data management processes and improving operational efficiency• Directed Power BI workshops to elevate the team's analytical capabilities, fostering a data-centric culture that markedly improved organizational decision-making processes

Ottawa, Ontario, Canada

• Led the implementation of a Power BI financial reporting solution at Canada Life, integrating disparate financial systems to offer executives real-time performance insights, resulting in a 20% increase in reporting efficiency• Developed and executed an ETL strategy with SQL Server Integration Services (SSIS) to centralize insurance claim data, improving claims analysis accuracy and accessibility, and achieving a 15% reduction in claim processing times• Implemented a Power BI-driven risk assessment model, leveraging historical data and predictive analytics to pinpoint financial risk areas, supporting the formulation of mitigation strategies that decreased risk exposure by 18%• Spearheaded the development of an interactive Power BI dashboard for monitoring policyholder trends and behaviors, empowering the marketing team to customize products and services more effectively, which led to a 10% uplift in policy renewals

Ottawa, Ontario, Canada

• Orchestrated the migration of legacy BI systems to Power BI for a portfolio of IT Logix clients, leading to enhanced data visualization capabilities and a 25% increase in client-reported satisfaction with analytics tools• Developed custom DAX measures and queries to meet complex client reporting needs, facilitating detailed performance analysis and strategic planning, which resulted in a 30% improvement in client decision-making processes• Pioneered the use of Azure Data Factory for automating data pipelines across multiple projects, significantly reducing manual data handling and ensuring a 20% faster turnaround on BI deliverables• Designed and delivered comprehensive Power BI training programs for IT Logix clients, empowering them with the skills to maintain and extend their BI solutions, fostering long-term client engagement and a 15% increase in consultancy service renewals• Implemented advanced Power BI security models, including Row-Level Security (RLS), for clients in regulated industries, improving data governance and enhancing client trust

Pakistan

• Pioneered the integration of AI and machine learning with Power BI dashboards for SaaS product analytics at Folio3, boosting forecast accuracy by 35% and enhancing client services• Crafted dynamic Power BI dashboards for real-time user engagement analytics, reducing response times by 40% and increasing user interaction by 20%, setting a new benchmark for SaaS product performance monitoring• Led the strategic migration of data warehousing to Azure cloud services, significantly improving data retrieval speeds by 50%, thereby streamlining development workflows and supporting agile practices• Established a Power BI-based KPI monitoring framework, optimizing project management and accelerating project completion by 25%, significantly boosting operational efficiency• Conducted Power BI training sessions for cross-functional teams, elevating data analysis skills across the organization and fostering a culture of data-driven decision-making and continuous innovation