Rimsha Shaukat
Mississauga,ON
Summary
Insightful Senior Technical Business Intelligence/Systems Analyst with 6+ years experience at leveraging advanced SQL, Power BI, Salesforce, Data Modelling, and Visualization Tools to translate complex data into actionable insights. Seeking to leverage a solid technical foundation and analytical skills to contribute to a dynamic organization focused on data-driven decision making.
Overview
6
6
years of professional experience
Work History
Senior Business Intelligence Analyst / Data Analytics
Shoppers Drug Mart (Loblaws Company Ltd.)
11.2022 - Current
- Develop and refine SQL queries to optimize data analysis and extraction, resulting in significant 60% increase in performance efficiency
- Manage dynamic and interactive dashboards in Power BI, resulting in 80% decrease in manual reporting time and enabling real-time data-driven decision-making for the leadership team
- Direct BI projects, collaborate with key stakeholders to pinpoint business needs, and execute BI solutions that surpassed industry standards, resulting in exceptional increase in operational efficiency and great boost in revenue
- Orchestrate Quarterly Business Reviews (QBRs) and Annual Business Reviews (ABRs), expertly analyzing Key Performance Indicators (KPIs) alongside comprehensive business insights, ultimately elevating stakeholder satisfaction
- Proficiently extract data from diverse platforms including Micro-Strategy, NexGen, SAP, and Salesforce, resulting in streamlined data processing and analysis workflows by 40%, improving overall efficiency
- Implement and maintain advanced security measures in pharmaceutical/healthcare sector to protect user assets, ensuring the integrity and confidentiality of patient information, resulting in 100% compliance with industry regulations and standards, safeguarding sensitive data.
Business System Analyst / Programmer
People 2.0 (Formerly: The Staffing Edge)
01.2018 - 11.2022
- Developed and executed comprehensive test plans, test cases, and test scripts, conducting rigorous regression testing to ensure software application robustness, resulting in a 95% reduction in post-release defects
- Produced SQL reports tailored to client specifications, showcasing database query expertise with an 80% accuracy rate in query generation
- Managed queue system operations, proficiently logging issues/defects and delivering timely fixes, maintaining system integrity with a 90% uptime
- Collaborated with the Scrum Master and cross-functional teams to streamline project management in JIRA, actively contributing to Sprint and Release Planning in adherence to project schedules
- Enhanced operational efficiency by documenting 20+ scripts and process flows, creating essential references and training materials, that reduced onboarding time by 40% and assisted in knowledge transfer with 100% utilization.
Education
Bachelor of Arts (B.A.) - Specialization in Business Management
University of Toronto
MississaugaSkills
- Business Analysis
- Advanced Excel
- Data Visualization
- KPI Tracking
- SQL Programming
- Power BI
- AS400
- Micro-Strategy
- SalesForce
- Documentation Writing
- Test Cases
- Strategic Planning
- Web-based reporting tools
Noteworthy projects
- Invoice Process Automation: Implemented invoice processing automation using SQL and Excel, reducing extraction time
from 45 to 10 minutes, achieving a remarkable 78% efficiency boost.
- Stored Procedure Development for Excel Reporting: Annual creation of approximately 200 intricately designed stored
procedures, enabling the seamless transformation of data into Excel reports, exemplify a commitment to delivering
high-quality, data-driven solutions.
- Power BI Dashboard: Collaborated with Power BI experts to develop interactive reports and visuals, by furnishing SQL code for query construction, enabling the integration of DAX queries into the dashboard. This pivotal project aimed to deliver a comprehensive solution to our client, enhancing end-to-end service delivery and Real-time access to insightful information.
Timeline
Senior Business Intelligence Analyst / Data Analytics
Shoppers Drug Mart (Loblaws Company Ltd.)
11.2022 - Current
Business System Analyst / Programmer
People 2.0 (Formerly: The Staffing Edge)
01.2018 - 11.2022
Bachelor of Arts (B.A.) - Specialization in Business Management
University of Toronto
Similar Profiles
Rimsha ShaukatRimsha Shaukat
Senior Business Intelligence Insight Analyst at Shoppers Drug Mart (Loblaws Company Ltd.)Senior Business Intelligence Insight Analyst at Shoppers Drug Mart (Loblaws Company Ltd.)
Leslie NashLeslie Nash
Pharmacy Assistant, Cosmetician at Shoppers Drug Mart Pharma Prix/LoblawsPharmacy Assistant, Cosmetician at Shoppers Drug Mart Pharma Prix/Loblaws
Harsh BamaniaHarsh Bamania
Pharmacy Assistant at Shoppers Drug MartPharmacy Assistant at Shoppers Drug Mart