Ashir Kaleem, Developer in Toronto, ON, Canada
Ashir is available for hire
Hire Ashir

Ashir Kaleem

Verified Expert  in Engineering

Business Intelligence Developer

Location
Toronto, ON, Canada
Toptal Member Since
September 26, 2023

Ashir is an accomplished IT professional with over 12 years of experience in architecting, designing, and developing business intelligence solutions. Specializing in Power BI and SAP technologies and with a solid results-driven approach, he has successfully assisted numerous organizations in harnessing the power of data for enhanced efficiency. Ashir's extensive expertise covers diverse sectors like healthcare, retail, manufacturing, insurance, and financial and public services.

Portfolio

Government of Canada
DAX, Microsoft Access, Microsoft Power BI, Power Query M
Circular Materials (CSSA)
DAX, Microsoft Access, Microsoft Power BI, SAP Business Warehouse (BW)...
Sun Life Financial Canada
SQL Server 2016, SQL, SAP BO Dashboards, Dashboard Design

Experience

Availability

Part-time

Preferred Environment

Microsoft Power BI, DAX, SAP BusinessObjects (BO), SAP Business Warehouse (BW), Microsoft Excel, Power Query M, SQL, Microsoft Access, Tableau, SAP BW on HANA

The most amazing...

...thing I've done was architecting and developing Power BI solutions, which included configuring data security and managing workspaces.

Work Experience

Power BI & BI Developer

2020 - 2023
Government of Canada
  • Played a pivotal role in crafting a Power BI model tailored for financial reporting, specifically for P&L and headcount analyses.
  • Implemented the drill down, tooltip, and drill through options for better user experience and detailed reporting.
  • Incorporated row-level security based on departmental hierarchy.
Technologies: DAX, Microsoft Access, Microsoft Power BI, Power Query M

Power BI & BI Developer

2016 - 2020
Circular Materials (CSSA)
  • Designed and developed graphical and visualization solutions with Power BI based on business requirement documents and plans for creating interactive dashboards.
  • Generated ad-hoc reports in Power Pivot for Excel and used Power BI to share them with the decision-makers for strategic planning.
  • Implemented several DAX functions for fact calculations, enabling efficient data visualization in Power BI.
Technologies: DAX, Microsoft Access, Microsoft Power BI, SAP Business Warehouse (BW), Power Query M, SAP BW on HANA, SAP BusinessObjects (BO)

BI Developer

2015 - 2016
Sun Life Financial Canada
  • Created complex master-detail and crosstab SAP BusinessObjects Web Intelligence (WebI) reports using different data providers such as UniVerse and Freehand SQL. Implemented various functionalities like breaks, alerts, and variables.
  • Trained users, provided technical support, and resolved issues, including fixing bugs and updating patches, working directly with the SAP BusinessObjects technical support team.
  • Handled end-user training, knowledge transfer, and production support activities.
Technologies: SQL Server 2016, SQL, SAP BO Dashboards, Dashboard Design

BI Developer

2013 - 2015
Circular Materials
  • Created complex reports by linking data from multiple data providers, using stored procedures, and implementing functionalities like UNION queries, drill down, master-detail, and custom sorts.
  • Built WebI reports that utilized the online analytical processing (OLAP) functionality, providing efficient data analysis capabilities. I also worked extensively with data warehousing.
  • Created a WebI report and implemented scheduling events for its daily, weekly, and monthly generation and delivery.
Technologies: Microsoft Access, IT Project Management, Dashboard Design

Business Object Consultant

2012 - 2013
Hydro One
  • Developed a complex dashboard to facilitate grid operation by enabling monitoring of work programs, schedules, and safety measures.
  • Created and improved the dashboard standard and implemented dashboard best practices for the Hydro One networks dashboard.
  • Built a health and safety dashboard to monitor safety standards across different lines of business.
Technologies: IT Project Management, SAP BusinessObjects (BO), SAP BO Dashboards, Xcelsius

BI Developer

2012 - 2012
Tim Hortons
  • Created various master-detail, crosstab, slice and dice, and drill-down reports.
  • Used WebI to generate visually captivating charts. Created complex reports by integrating multiple queries and actively participated in optimizing them in terms of accessibility and speed.
  • Leveraged SAP data by integrating SAP BEx queries into the dashboard and utilizing the power of BEx Integrated Client (BICS) for seamless data retrieval and analysis.
Technologies: IT Project Management, Microsoft Excel, SAP BusinessObjects (BO), SAP BO Dashboards, Xcelsius

BI Developer

2011 - 2012
Labatt Brewing Company
  • Developed reports using SQL queries to pull data from the data warehouse.
  • Designed and developed universes using the SAP Universe design tool to create monthly sales reports.
  • Used WebI to create daily, weekly, and monthly sales reports and detailed monthly sales versus targets reports.
Technologies: SQL, Kalido Dynamic Information Warehouse (DIW), Business Objectives

BI Developer

2010 - 2011
Apotex
  • Modeled and developed 13 sales and marketing dashboards for top management and sales representatives, following best dashboard design practices. The dashboards targeted monthly sales, P&L, and area and region-wise sales.
  • Generated technical architecture documentation and conducted troubleshooting of SAP BusinessObjects servers, efficiently handling daily queries.
  • Modified existing SAP BusinessObjects reports and universes as per business requirements.
Technologies: IT Project Management, Microsoft Access, Dashboard Design, Xcelsius, SAP BO Dashboards

BI Developer

2010 - 2010
BMO Bank of Montreal
  • Converted legacy Cognos reports to SAP BusinessObjects and created rule-based events for WebI scheduling.
  • Developed complex reports based on various metrics and customized them into Excel, PDF, and .csv formats. Generated several templates in WebI and Deski.
  • Used Schedule Manager, Instance Manager, and Query Builder to efficiently manage and schedule tasks, handle report instances, and build queries.
Technologies: IT Project Management, Microsoft Excel, SQL, IBM Cognos, SAP BusinessObjects (BO)

BI Developer

2008 - 2010
Sanofi
  • Led the conversion from SAP-BW 3.5 to SAP-BI 7.0 within materials management and industrial operations.
  • Facilitated and assisted supply chain improvement initiatives, encompassing process mapping, metric creation, process analysis, and change management.
  • Trained business users on SAP Business Information Warehouse (BW) reports and how to create queries.
Technologies: Microsoft Excel, SAP Business Warehouse (BW)

Business Intelligence Manager

2000 - 2007
Unilever
  • Developed head office information system, which was used to show sales and targets of distributors.
  • Worked in customer development dept. worked on retail sales data for various product categories, including ice cream, beverages, beauty and health, and personal care.
  • Oversaw the launch of Walls Ice-cream and generated daily and weekly sales reports.
  • Gained experience in the channel and customer development department, where I led a national IT team and oversaw the design and development of retail sales data.
  • Worked on reporting for product categories, including ice cream, beverages, beauty and health, and personal care. I also generated comprehensive reports depicting primary and secondary sales across various channels, cities, and provinces.
Technologies: Dashboard Design, Business Objectives, Kalido Dynamic Information Warehouse (DIW), SQL Server BI

Project Management Dashboard

A project delivered at the Department of National Defense. It involved conceptualizing, designing, and developing a comprehensive Power BI dashboard to meticulously monitor major projects with budgets exceeding $10 million.

This tool was an essential asset for project managers, enabling the detailed oversight of human resources, scope changes, budget status, and various significant milestones. It provided a centralized platform for efficiently tracking key performance indicators (KPIs), empowering project managers to optimize overall project performance. The dashboard facilitated enhanced decision-making processes and proactive project management, improving project outcomes and operational efficiency.

Sticker Shock Report

A project held for the Canadian Stewardship Services Alliance. I developed and implemented a comprehensive Sticker Shock report to give stewards advanced insights into their monetary contributions and fee allocations.

This innovative reporting tool facilitated a deeper understanding and transparency regarding financial alterations and contributions, enabling stewards to proactively anticipate and comprehend their fiscal involvements.

The introduction of this report significantly enhanced the relationship between CSSA and the stewards, fostering improved communication, mutual understanding, and collaboration, thereby contributing to an amicable and productive organizational environment.

Health and Safety Dashboard

A project developed at Hydro One, an electricity transmission and distribution service provider. I leveraged my expertise as a dashboard designer to architect, design, and institute the inaugural health and safety dashboard for Hydro One.

This advanced tool allowed top management to access up-to-the-minute, province-specific data regarding their entire field workforce, streamlining the decision-making process. The introduction of this dashboard facilitated the execution of tailored health and safety training programs, resulting in a 10% decrease in on-site injuries and significantly enhancing overall safety standards. Moreover, this innovation expedited reporting timelines, transitioning from monthly delays to near real-time updates, enabling immediate insights and proactive management responses.

This role underscored my capability to design influential dashboards that offer pivotal insights and drive organizational change and improvement.

Sales and Marketing Dashboard

A project held at Apotex, a global pharmaceutical company based in Canada. Leveraging my expertise as a dashboard designer, I created specialized dashboards for the sales and marketing departments aimed at top management and sales representatives at Apotex, serving nationally.

These dashboards, meticulously designed to monitor key performance indicators, enabled on-ground sales personnel to analyze sales trends, allowing them to optimize sales strategies and enhance customer service. The insights derived from these dashboards empowered them to recognize and leverage trends, thereby driving sales augmentation and superior service delivery. Post-implementation of these dashboards, Apotex witnessed a 10% surge in sales, expanded its market share against competitors, and enhanced the efficacy of the sales force.

This project emphasized my ability to design innovative dashboards that provide pivotal insights and significantly contribute to organizational growth and competitive advantage.
2004 - 2007

Master's Degree in Computer Science

Hamdard University - Karachi, Pakistan

JUNE 2012 - PRESENT

SAP BusinessObjects Web Intelligence Developer

SAP

MARCH 2009 - PRESENT

Project Management Professional (PMP)

Project Management Institute (PMI)

Tools

Microsoft Power BI, Microsoft Excel, Microsoft Access, Tableau, Xcelsius, IBM Cognos, Power Pivot, SQL Server BI, SAP2000

Languages

Power Query M, SQL

Storage

SQL Server 2016

Other

DAX, SAP BusinessObjects (BO), SAP Business Warehouse (BW), SAP BW on HANA, IT Project Management, SAP BO Dashboards, Dashboard Design, Kalido Dynamic Information Warehouse (DIW), Business Objectives, SAP, SAP BusinessObjects Web Intelligence, Report Design

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring