Chakshu Bajaj

Chakshu Bajaj

Reporting Analyst / Power BI
Canada

نبذة عني

Skilled in using digital analytics tools i.e., Power BI, Power Apps, Power Automation to build reports. Experienced to connect Power Apps with various data sources, such as SharePoint, Microsoft 365, SQL Server. Worked o…

الخبرة

Reporting Analyst

BMO Financial Group
Apr 2023 - حتى الآن · 3 سنوات 3 أشهر

• Worked on Power Apps and Microsoft Power Automation, to streamline workflows and automate repetitive tasks.
• Utilized SQL queries to tap into a centralized repository database and built prototype reporting for various balance sheet reports used in scheduling, cost controls, communication team and regulatory reporting obligations.
• Utilize technical skills to efficiently and effectively extract and manipulate data from client databases or other source systems to meet various reporting needs (weekly, monthly, quarterly, and ad hoc reports)
• Develop and implement new reporting for Investment and Corporate Banking and Global Markets.
• Working on troubleshoot and debug issues in power query editor with Power BI reports and dashboards.
• Worked on filters, parameters, DAX measures and calculated sets for preparing dashboards and worksheets in Power BI.
• Used visualization reports tools like KPI, slicer, graph, and allowing end users to utilize full functionality of the dashboard.
• Worked on Power Automation Procedure to run queries automatically by SharePoint to Power BI
• Worked on connectors in Power Apps, Power Automation to connect with specialized in-house applications, work with the management of the cross teams enhancing the report quality.
• Stayed up-to-date with the latest features and updates in Power Automation, continually improving automation capabilities and staying at the forefront of automation trends.
• Utilize knowledge of CM’s businesses, products, and risk measures to provide insight and analysis in support of performance and strategic objectives on Salesforce.
• Participate in and contribute to project and team meetings, interacting and collaborating with team members and other departments, as appropriate, in order to understand project requirements.
• Applying RBAC in Power Apps, to carefully design the roles and permissions.
• Manage requestor expectations, and meet agreed upon deadlines; produce work that is timely and accurate. Strive to provide great customer service and anticipate follow-up inquiries.
• Connected to data sources, importing data from Azure Data Lakehouse, Azure Synapse, Azure Data Factory.
• Work with the functional lead, and other delivery teams to design and implement data models that support the business intelligence solutions.
• Data collection, management techniques (ETL) and the development, interpretation of data to determine requirements, retrieve, analyze and deliver insights and recommendations.

Reporting Analyst / Power BI

BMO (Capital Market)
Apr 2023 - حتى الآن · 3 سنوات 3 أشهر

Worked on Power Apps and Microsoft Power Automation, to streamline workflows and automate repetitive tasks.
Utilized SQL queries to tap into a centralized repository database and built prototype reporting for various balance sheet reports used in scheduling, cost controls, communication team and regulatory reporting obligations.
Utilize technical skills to efficiently and effectively extract and manipulate data from client databases or other source systems to meet various reporting needs (weekly, monthly, quarterly, and ad hoc reports).
Develop and implement new reporting for Investment and Corporate Banking and Global Markets.
Working on troubleshoot and debug issues in power query editor with Power BI reports and dashboards.
Worked on filters, parameters, DAX measures and calculated sets for preparing dashboards and worksheets in Power BI.
Used visualization reports tools like KPI, slicer, graph, and allowing end users to utilize full functionality of the dashboard.
Worked on Power Automation Procedure to run queries automatically by SharePoint to Power BI.
Worked on connectors in Power Apps, Power Automation to connect with specialized in-house applications, work with the management of the cross teams enhancing the report quality.
Stayed up-to-date with the latest features and updates in Power Automation, continually improving automation capabilities and staying at the forefront of automation trends.
Utilize knowledge of CM’s businesses, products, and risk measures to provide insight and analysis in support of performance and strategic objectives on Salesforce.
Participate in and contribute to project and team meetings, interacting and collaborating with team members and other departments, as appropriate, in order to understand project requirements.
Applying RBAC in Power Apps, to carefully design the roles and permissions.
Manage requestor expectations, and meet agreed upon deadlines; produce work that is timely and accurate.
Strive to provide great customer service and anticipate follow-up inquiries.
Connected to data sources, importing data from Azure Data Lakehouse, Azure Synapse, Azure Data Factory.
Work with the functional lead, and other delivery teams to design and implement data models that support the business intelligence solutions.
Data collection, management techniques (ETL) and the development, interpretation of data to determine requirements, retrieve, analyze and deliver insights and recommendations.

Reporting Analyst / Power BI

Rogers Communications
Feb 2021 - Mar 2023 · 2 سنوات 1 شهر

Developed visual report, dashboards and KPI using Power BI desktop using DAX and transformation in Power query editor.
Collaborated with teams for automation procedure and implemented end-to-end solutions using Power Automation.
Created various visualizations reports tools like KPI, metrics, data slicer, line & area graph, text cards, geo maps, gauge charts and allowing end users to utilize full functionality of the dashboard.
Worked on filters, parameters and calculated sets for preparing dashboards and worksheets in Power BI.
Developed visual report, dashboards and KPI scorecards using Power BI desktop.
Connected to data sources, importing data and transforming data for Business Intelligence.
Created new measures and columns for getting required results in data view and report view.

Power BI Marketing Analyst

Schneider Electric India Pvt Ltd
May 2018 - Dec 2020 · 2 سنوات 7 أشهر

Collaborated with business and technology partners to elicit information / data requirements and articulate requirements.
Provided support to the development and testing teams to resolve data issues.
Provided data governance and data availability support to technology teams and business users and ensure requirements regarding privacy and security of data, data governance and access controls are appropriately captured.
Ensured data is maintained in compliance with enterprise data standards, policies and guidelines.
Build and supports reports using a combination of BI tools and SQL.
Contribute to data deliverables including contribution to the overall project business requirements and data requirements documents.

Tech Support Advisor

Hager Electro Pvt Ltd
Nov 2016 - Apr 2018 · 1 سنة 5 أشهر

Work with clients to solve various types technology problems, including Wi-Fi/network connectivity; hardware and software issues.
Use resources, technology, and problem-solving skills to troubleshoot mobile POS network issues which include tablet and printer connectivity with cabled and wireless LAN and WAN devices.
Take ownership of customer issues through to resolution or escalation while providing accurate and prompt feedback both to the customer and teammates.
Follow company policy and procedures for the proper escalation of unresolved issues to appropriate internal teams.
Maintain a high percentage of issue resolution within first customer interaction.

Help Desk Analyst

Schneider Electric India Pvt Ltd
May 2013 - Oct 2016 · 3 سنوات 5 أشهر

Work directly with business users with variety of level of expertise and requirements to identify and translate the business case into technical requirements for development of full analytics solutions.
Evaluate query designs, data structure, and data quality to provide recommendation for improvement as needed.
Removed troubleshoot system failures or bugs and provided solutions to restore functionality.
Experienced of AWS Administration, providing security and following the SOP (Standard of Procedures).

المهارات

كوجنوس مايكروسوفت أكسس نظام التحليل الإحصائي (SAS) لغة الاستعلامات الهيكلية (SQL) توثيق كريستال الجداول المحورية خدمات تقارير SQL Server مهارات تحليل البيانات كتابة التقارير المالية باور بي آي تابلو التقارير التنظيمية Power Apps Power Automate BI Analyst Data Analyst KPI Data Modelling SharePoint Microsoft 365 SQL Server RBAC RDBMS NoSQL Python Microsoft SQL Server SSRS SSAS Tabular SSIS OLAP Azure Active Directory OAuth RLS DAX Power Query Power Pivot Power BI Desktop Data Integration Data Warehousing Enterprise Data Management Data Analysis ETL JIRA Zendesk Remedy Oracle Salesforce Snowflake AWS MS Word MS PowerPoint MS Excel WebEx Google Forms JotForm T-SQL Azure Functions Azure Logic Apps Azure Key Vault Azure API Management
الإبلاغ عن هذا الملف الشخصي؟