Ashir Kaleem
Verified Expert in Engineering
Business Intelligence Developer
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
Experience
- SAP BusinessObjects (BO) - 12 years
- Microsoft Excel - 10 years
- SAP Business Warehouse (BW) - 8 years
- DAX - 6 years
- Microsoft Power BI - 6 years
- Power Query M - 6 years
- Microsoft Access - 5 years
- SAP BW on HANA - 3 years
Availability
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
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.
Power BI & BI Developer
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.
BI Developer
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.
BI Developer
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.
Business Object Consultant
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.
BI Developer
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.
BI Developer
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.
BI Developer
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.
BI Developer
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.
BI Developer
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.
Business Intelligence Manager
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.
Experience
Project Management Dashboard
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
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
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
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.
Education
Master's Degree in Computer Science
Hamdard University - Karachi, Pakistan
Certifications
SAP BusinessObjects Web Intelligence Developer
SAP
Project Management Professional (PMP)
Project Management Institute (PMI)
Skills
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
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring