Lakshay Bajaj
Verified Expert in Engineering
Power BI and Power Platform Developer
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.
Portfolio
Experience
- Microsoft Power BI - 8 years
- DAX - 8 years
- Microsoft Power Apps - 8 years
- Microsoft Power Automate - 7 years
- SharePoint - 7 years
- Microsoft SQL Server - 7 years
- Scrum Master - 3 years
- JavaFX Script - 2 years
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
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.
Power BI & Power Platform Developer
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.
Power BI Developer
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.
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.
Sales Analytics Report
Education
Master's Degree in Engineering
Concordia University - Montreal, Canada
Bachelor's Degree in Engineering
Punjabi University, Patiala - Patiala, India
Certifications
Certified Scrum Master (CSM)
Scrum Master
Microsoft Certified: Azure Fundamentals
Microsoft
Microsoft Power Automation
Udemy
Oracle PL/SQL Developer Certified Associate
Udemy
Microsoft Certified: Power Platform Fundamentals
Microsoft
Microsoft Power BI
Udemy
Skills
Libraries/APIs
REST APIs, Power BI REST APIs, CanvasJS, PySpark, Azure API Management
Tools
Microsoft Power BI, Power Pivot, Power Query, Tableau, Microsoft Excel, Microsoft Report Builder, BigQuery, Looker, Microsoft Dynamics, Microsoft Access, Microsoft Teams, Power BI Embedded, Microsoft Power Apps, SQL Server BI, Grafana, Azure Logic Apps, Azure Key Vault
Languages
SQL, Power Query M, Snowflake, Python, JavaFX Script, Transact-SQL (T-SQL)
Frameworks
Unity
Paradigms
ETL, Business Intelligence (BI), Management
Platforms
Salesforce, SharePoint, Amazon Web Services (AWS), Oracle, Microsoft Power Platform, Microsoft, Android, iOS, Microsoft Fabric, Azure Synapse, Microsoft Power Automate, Azure Functions, Azure SQL Data Warehouse, Azure, Dedicated SQL Pool (formerly SQL DW)
Storage
SQL Server 2016, Microsoft SQL Server, Data Pipelines, Databases, InfluxDB, Database Administration (DBA), Azure SQL, JSON, MongoDB, PostgreSQL, MySQL, NoSQL, SAS SQL, SQL Server DBA
Industry Expertise
Insurance
Other
Stakeholder Management, Power Management Systems, Microsoft 365, DAX, Data Visualization, eCommerce, Dashboards, Financial Services, Corporate, Checklists, Fund Accounting & Administration, Data Analysis, BI Reporting, Data Engineering, Time Series Analysis, Time Series Data, APIs, CRM APIs, BI Reports, Sales Reports, Data Build Tool (dbt), Azure Data Lake, Payroll & Benefits, Logistics, Funnel Analysis, Looker Studio, Google BigQuery, Health IT, Architecture, Data Warehousing, Business Requirements, Business Analysis, Data Analytics, Low Code, No-code Development, Azure Databricks, Data Modeling, Analytical Thinking, Apps, Excel 365, Data Science, Dashboard Design, Fabric Data Factory, OneLake, Azure Data Factory (ADF), Finance, Communication, Database Optimization, MySQL DBA, Amazon RDS, Data Governance, Debugging, Workflow Automation, Microsoft Dataverse, Dynamics CRM 365, Team Leadership, Workflow, SAP, SFDC Configuration, Scrum Master, IT Project Management, Team Mentoring, Workshop Facilitation, API Gateways, Business Process Flow (BPF), Business Process Automation, Business Process Modeling, Business Reporting, Microsoft Azure Cloud Server, SharePoint UI, ADP, Coaching, Office Scripts
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