Harjot Kaur
Edmonton
Summary
Detail oriented Business Intelligence Analyst with 10 years of experience in leveraging data-driven insights to drive a business improvement and optimize overall performance. Proficient in data visualization, statistical analysis, and database management. Strong problem-solving skills, excellent communication abilities, and a passion for delivering data-driven solutions that support strategic decision-making and drive business growth.
Overview
9
9
years of professional experience
1
1
Certification
Work History
DATA ANALYST
INTEGRATED DESIGN SOLUTIONS INC.
06.2020 - 10.2023
- Transformed traditional business reports into self-service visual reports and validating the report's functionality, ensuring it is ready for production and delivering the desired user experience.
- Communicated results through presentations, reports, tools, and data visualizations for clients and internal staff.
- Managing defects during System Integration Testing and User Acceptance Testing phases.
- Consulted with key stakeholders and business partners to understand reporting needs.
- Authored business requirements document for software applications, led requirements analysis sessions, solution assessment and validation.
- Prepared regular project status reports indicating project deliverables, possible risk and issues, timelines and anticipated efforts.
- Used statistical methods to analyze data and generate useful business reports.
- Generated ad-hoc reports upon request, supporting various stakeholders'' needs for timely information access.
BUSINESS INTELLIGENCE ANALYST
CANADIAN WESTERN BANK
11.2019 - 05.2020
- Provided relevant analytical solutions in developing data analysis and reports to track and forecast retail renewal mortgage portfolio performance and trends.
- Reduced manual data entry errors by automating routine tasks using SQL scripts and ETL tools.
- Created Power BI and SSRS-based visual reports for retail renewal mortgage projects.
- Developing test strategies, test cases, test scripts, test plans, conducting System integration Testing & User Acceptance Testing.
- Met with stakeholders to establish favorable business relationships and support mutually beneficial interests.
- Presenting outcomes of data analysis to leadership and other stakeholders.
- Automation of several Ongoing Manual reports using Data Analysis and Visualization tools.
DATA ANALYST
ATB FINANCIAL BANK
11.2018 - 09.2019
- Designed Tableau and Power BI Reports based on business partner requirements for the Retail Financial Services team.
- Converted manual reports of Cash co Financial Services into self-served automated reports.
- Working with executive reporting to turn operational reports into visually appealing, easy-to-understand automated stories.
- Worked on Server and Publisher, to manage user access, schedule refreshing of documents, and mount completed applications.
- Worked as an Administrator and performed regular server maintenance and upgrades.
- Reviewed error logs and provided production support.
- The performance tuning of dashboards was carried out to limit response time and define server sizing for optimal performance of dashboards.
- Meeting with business partners and customers to understand the requirements and deliver solution accordingly
DATA ANALYST
ACCENTURE
11.2014 - 08.2018
- Developed and deployed a Tableau-based application consisting of 20+ reports and 50+ features for British Petroleum using large datasets.
- Gathered functional and non-functional client requirements to optimize the design of deliverables (reports, dashboards, alerts, visualizations).
- Worked closely with the Testing team to keep the number of defects to a minimum
- Handling Application Outsourcing Support for defect resolution using QMC, UNIX and JIRA
- Worked as a QlikView and Tableau Administrator, providing support to QlikView/Tableau users, access to various Qlik/Tableau-based applications, creating credentials for the users, leasing licenses to the users etc.
- Providing Knowledge transition sessions to non-technical stakeholders and other junior colleagues
TECHNICAL SUPPORT ANALYST
ERICSSON
07.2014 - 11.2014
- Company Overview: Working for client Sprint which is an American holding company that provides wireless services and is a major global Internet carrier.
- Maximizing network performance by monitoring performance, troubleshooting network problems.
- Undertaking data network fault investigations in local and wide area environments, using information from multiple sources.
- Fault / Incident Management.
Education
Bachelor in Engineering - Computer Science
Punjab University, India
06.2014
Skills
- Tableau, QlikView, Power BI, SSRS
- SQL
- MS OFFICE
- CRM Tools
- Google Suite
- JIRA, Service Now
- Data visualization and presentations
- Data analysis
Technical Profile
- Designing, development, testing and deployment of Visual Dashboards that provide strategic insights and support decision-making.
- Expert in Bridging communication between vendors, clients, and corporate technical and business teams.
- Highly skilled in Tableau, QlikView, Qliksense, Power BI and SSRS.
- Advanced SQL knowledge and experience working with extremely large data sets and data flows.
- Worked on UAT and UNIT Testing and Defect management activities like Raising defects and defects tracking till closure.
- Agile work style, open to iteration and flexible to change the approach.
- Excellent MS Office skills including Power BI, Power Query, Excel, Word, PowerPoint, Outlook.
Certification
- MTA - MICROSOFT TECHNOLOGY ASSOCIATE
- MCSA - MICROSOFT CERTIFIED SOLUTIONS ASSOCIATE
- AGILE SCRUM PROFESSIONAL
- TABLEAU CERTIFIED
Timeline
DATA ANALYST
INTEGRATED DESIGN SOLUTIONS INC.
06.2020 - 10.2023
BUSINESS INTELLIGENCE ANALYST
CANADIAN WESTERN BANK
11.2019 - 05.2020
DATA ANALYST
ATB FINANCIAL BANK
11.2018 - 09.2019
DATA ANALYST
ACCENTURE
11.2014 - 08.2018
TECHNICAL SUPPORT ANALYST
ERICSSON
07.2014 - 11.2014
Bachelor in Engineering - Computer Science
Punjab University, India
Similar Profiles
HARJOT KAURHARJOT KAUR
Administrative Assistant at INTEGRATED DESIGN SOLUTIONS INCAdministrative Assistant at INTEGRATED DESIGN SOLUTIONS INC
Amanda Davenport-HorningAmanda Davenport-Horning
Executive Assistant at Integrated Design SolutionsExecutive Assistant at Integrated Design Solutions
Jamil AmeyJamil Amey
Print Press Lead at Integrated Design SolutionsPrint Press Lead at Integrated Design Solutions