Rimsha Shaukat
Mississauga,Canada
Summary
Senior Technical Business Intelligence Insight/System Analyst with over 6 years of experience, skilled in SQL; excelling in BI tools such as Power BI, Microstrategy, and Salesforce. Proven track record of translating complex data into actionable insights using advanced data modeling and visualization tools. Aiming to apply analytical skills and a robust technical foundation in database management and KPI monitoring, to enhance data-driven decision-making in a dynamic organization.
Overview
7
7
years of professional experience
Work History
Senior Business Intelligence Insight Analyst
Shoppers Drug Mart (Loblaws Company Ltd.)
11.2022 - Current
- Develop and refine SQL queries to optimize data analysis and extraction, resulting in a significant 60% increase in performance efficiency
- Manage dynamic and interactive dashboards in Power BI, resulting in an 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 benchmarks, resulting in an exceptional increase in operational efficiency and a 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 meeting stakeholder satisfaction
- Proficiently extract data from diverse platforms including Micro-Strategy, NexGen, SAP, and Salesforce, elevating data processing speed by 40%, and improving overall efficiency
- Uphold advanced security measures in the pharmaceutical/healthcare sector to protect user assets, ensuring the integrity and confidentiality of patient information, resulting in 100% compliance and protection of sensitive data.
Business System Analyst / Programmer
People 2.0 (Formerly: The Staffing Edge)
01.2018 - 11.2022
- Executed comprehensive test plans, and test cases, and conducted 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 a high 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.
Data Entry/Bookkeeping (Summer - Part-Time)
Stackpole International
05.2017 - 09.2017
- Organized purchase orders with matching packing slips and relevant invoices, ready to be entered into AS400 software
- Received approximately 80 packing slips to ensure the ordered products/supplies have been delivered.
- Entered approximately 100 matched invoices into batches of 10-15 invoices per batch resulting in faster payment to the company's vendors
Education
Specialization in Business Management
University Of Toronto
Mississauga, OntarioSkills
- Data Visualization & Data Acquisition
- KPI Monitoring
- Database Management
- Data Analysis
- Documentation
- SQL Language
- Microsoft Excel
- Power BI
- AS400
- Microstrategy
- Salesforce
- NexGen
- Excellent Time Management
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 Insight Analyst
Shoppers Drug Mart (Loblaws Company Ltd.)
11.2022 - Current
Business System Analyst / Programmer
People 2.0 (Formerly: The Staffing Edge)
01.2018 - 11.2022
Data Entry/Bookkeeping (Summer - Part-Time)
Stackpole International
05.2017 - 09.2017
Specialization in Business Management
University Of Toronto
Similar Profiles
Rimsha ShaukatRimsha Shaukat
Senior Business Intelligence Analyst / Data Analytics at Shoppers Drug Mart (Loblaws Company Ltd.)Senior Business Intelligence Analyst / Data Analytics 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