Lakshay is available for hire

Lakshay Bajaj

Verified Expert in Engineering

Power BI and Power Platform Developer

Location

Mississauga, ON, Canada

Toptal Member Since

September 11, 2023

Lakshay is a skilled software developer with 7+ years of experience using business intelligence reporting tools to tackle business challenges and processes. He excels in implementing reporting solutions and is experienced in Microsoft Power BI, Power Platform, Power Automate, Microsoft SQL, data lakes, SharePoint, CRM tools, and business requirement documents (BRD). Lakshay is a resourceful professional who values teamwork, striving to enhance processes and efficiently resolving project issues.

Data Visualization DAX Data Analysis Data Engineering Microsoft Excel Microsoft Power BI Power Pivot Microsoft SQL Server Snowflake Tableau SAP SQL Server BI SAS SQL SQL Server 2016 SQL Server DBA Power Query

Portfolio

Rogers Communications

Microsoft Power BI, Power Pivot, Power Query, DAX, SharePoint, SQL Server BI...

RBC Capital Markets

Microsoft Power BI, Power Pivot, DAX, Microsoft 365, T-SQL (Transact-SQL), ETL...

Bank of America

Microsoft Power BI, Power Pivot, DAX, Azure API Management...

Experience

Microsoft Power BI - 8 years DAX - 8 years SharePoint - 7 years Microsoft SQL Server - 7 years Microsoft Power Apps - 6 years Microsoft Power Automate - 5 years Scrum Master - 3 years JavaFX Script - 2 years

Availability

Full-time

Preferred Environment

Microsoft Power BI, Microsoft Power Apps, Microsoft 365, Power Query, Microsoft Power Automate, DAX, Microsoft SQL Server, Power Query M, Salesforce, SharePoint

The most amazing...

...thing I've done is create and deliver Power BI reports using SharePoint, Salesforce, SQL, Dynamics 365, and Power Automate.

Work Experience

Power BI & Power Platform Developer

2022 - PRESENT

Rogers Communications

Developed visual reports, dashboards, KPI scorecards, as well as DAX, T-SQL, SQL, and Power queries, measures, columns, and aggregate functions in the Power BI desktop.
Implemented the Power Automate procedure using the Power App and Power BI with SharePoint to run queries automatically. I also implemented security measures in Power Apps, ensuring data confidentiality and compliance with organizational policies.
Used SQL-generated data from Microsoft SQL Server with SSRS, SSAS Tabular, and SSIS. I also applied filters and parameters and calculated sets to prepare insightful dashboards in Power BI.

Technologies: Microsoft Power BI, Power Pivot, Power Query, DAX, SharePoint, SQL Server BI, Microsoft Power Automate, Microsoft Power Apps, Dynamics CRM 365, Salesforce, Data Visualization, eCommerce, Snowflake, Dashboards, Management, Team Leadership, Tableau, Workflow, Corporate, Checklists, BI Reporting, Data Engineering, SAP, Microsoft Excel

Power BI & Power Platform Developer

2019 - 2022

RBC Capital Markets

Conducted gap analysis on business data from multiple sources for ETL purposes. Built support reports using a combination of Power BI and SQL. Used Power BI reports and dashboards for troubleshooting and debugging issues.
Used ITSM ticketing tools such as Jira, ServiceNow, and Remedy to complete tickets before the service-level agreement (SLA) period. Worked in Agile environments, leveraging tools like Jira and Confluence.
Analyzed trading and settlement data, like equity, commodities, and fixed income, using Microsoft Excel and SQL. Produced Power BI interactive reporting dashboards by combining multiple views.

Technologies: Microsoft Power BI, Power Pivot, DAX, Microsoft 365, T-SQL (Transact-SQL), ETL, SQL Server BI, Azure API Management, Data Visualization, eCommerce, Snowflake, Dashboards, Management, Team Leadership, Tableau, Financial Services, Workflow, Corporate, Checklists, Fund Accounting & Administration, Data Analysis, BI Reporting, Data Engineering, SAP, Microsoft Excel

Power BI Developer

2016 - 2018

Bank of America

Conducted in-depth analyses of client and capital market product data using SQL to identify trends, patterns, and insights and then produced reports in Power BI.
Developed and implemented data-driven strategies and recommendations to optimize business performance for clients. Optimized and fine-tuned existing datasets across internal systems to create uniform and standardized reports.
Used SQL-generated data from Microsoft SQL Server with SSRS, SSAS Tabular, and SSIS. I also utilized DAX, OLAP, Power queries, Power BI, Power Pivot, and Power Query to analyze product and service data and drive business processes.

Technologies: Microsoft Power BI, Power Pivot, DAX, Azure API Management, Microsoft SQL Server, Microsoft 365, Data Visualization, Snowflake, Dashboards, Management, Team Leadership, Tableau, Financial Services, Workflow, Corporate, Checklists, Fund Accounting & Administration, Data Analysis, BI Reporting, Data Engineering, Microsoft Excel, Microsoft Report Builder

Experience

Business Banking Customer Profitability (BBCP)

This customer profitability project aims to create a fresh profitability analysis platform for business banking and extend its use from the credit segment to encompass all client credit segments.

I employed Power BI and Microsoft Power Automate to optimize workflows and eliminate repetitive tasks. I also worked on role-based access control (RBAC) in Power Apps to carefully design the roles and permissions.

Sales Analytics Report

This sales report enables the analysis of the total sales profit and revenue in different quarters compared to the previous year. It also gives information about other sale trends on priority orders in terms of item types, country, and region.

Education

2019 - 2021

Master's Degree in Engineering

Concordia University - Montreal, Canada

2012 - 2016

Bachelor's Degree in Engineering

Punjabi University, Patiala - Patiala, India

Certifications

DECEMBER 2022 - PRESENT

Certified Scrum Master (CSM)

Scrum Master

JULY 2021 - PRESENT

Microsoft Certified: Azure Fundamentals

Microsoft

SEPTEMBER 2019 - PRESENT

Microsoft Power Automation

Udemy

MARCH 2019 - PRESENT

Oracle PL/SQL Developer Certified Associate

Udemy

AUGUST 2018 - PRESENT

Microsoft Certified: Power Platform Fundamentals

Microsoft

JUNE 2018 - PRESENT

Microsoft Power BI

Udemy

Skills

Libraries/APIs

CanvasJS, Azure API Management

Tools

Microsoft Power BI, Power Pivot, Power Query, Tableau, Microsoft Excel, Microsoft Report Builder, Microsoft Power Apps, SQL Server BI, Azure Logic Apps, Azure Key Vault

Languages

Power Query M, Snowflake, SQL, JavaFX Script, T-SQL (Transact-SQL)

Storage

SQL Server 2016, Microsoft SQL Server, SAS SQL, SQL Server DBA

Platforms

Salesforce, SharePoint, Microsoft Power Automate, Azure Functions, Azure SQL Data Warehouse, Azure, Dedicated SQL Pool (formerly SQL DW)

Paradigms

Management, ETL

Other

Power Management Systems, Microsoft 365, DAX, Data Visualization, eCommerce, Dashboards, Financial Services, Corporate, Checklists, Fund Accounting & Administration, Data Analysis, BI Reporting, Data Engineering, Dynamics CRM 365, Team Leadership, Workflow, SAP, Scrum Master, IT Project Management, Team Mentoring, Stakeholder Management, Workshop Facilitation, API Gateways, Business Process Flow (BPF), Business Process Automation, Business Process Modeling, Business Reporting, Microsoft Azure Cloud Server, SharePoint UI, ADP, Coaching

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.

Share your needs

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

Choose your talent

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

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