Work
PepsiCo
|Business Intelligence Developer
Not specified, Not specified, Not specified
→
Summary
Led the development and delivery of critical business intelligence solutions, providing executive leadership with actionable insights into sales and operational performance.
Highlights
Directed end-to-end delivery of executive-level business dashboards and reports, providing critical insights into E-commerce sales data for strategic decision-making.
Automated monthly brand performance reporting across all PepsiCo business units, generating over $1M+ in yearly savings through enhanced data visibility and efficiency.
Developed an out-of-stock dashboard and collaborated on a delisted SKU tracker, optimizing sales distribution strategy during Covid-19 and mitigating revenue loss.
Translated complex business requirements into comprehensive feature roadmaps, enabling business partners to effectively track and achieve quarterly objectives.
Engineered and optimized advanced SQL queries in Snowflake and MS SQL Server, ensuring robust data validation and enhancing query performance for comprehensive exploratory analysis.
Quicken Loans
|Analyst - Strategy & Analytics
Not specified, Not specified, Not specified
→
Summary
Performed in-depth data analysis and developed reporting solutions to support strategic initiatives and enhance product features within the financial services sector.
Highlights
Conducted comprehensive analysis on loss mitigation data, recommending strategies that significantly reduced risk for investors from default clients.
Identified and resolved critical data quality gaps within large, complex datasets, substantially improving the accuracy and reliability of reporting.
Performed detailed impact analysis to optimize product features for the work management tool, driving continuous improvement and user satisfaction.
Developed and maintained monthly reports using SQL and Power BI, providing essential visibility and actionable insights for senior leadership.
Created impactful data visualizations using Tableau, Power BI, and Excel, effectively communicating complex data trends to stakeholders.
Quicken Loans
|Data Analyst Intern - Strategy and Analytics
Not specified, Not specified, Not specified
→
Summary
Contributed to strategic analytics initiatives by identifying operational opportunities and implementing data-driven solutions to enhance call center efficiency.
Highlights
Gathered and analyzed requirements from diverse business areas to identify and implement key opportunities within Call Center operations, leading to improved overall efficiency.
Leveraged SQL and R for advanced regression analysis to pinpoint variables impacting contact rates, informing targeted operational improvements.
Collaborated with IT to implement changes based on A/B test results, enhancing the outbound call process and achieving a 25% lift in contact rate.
Provided daily performance reports to business leaders, ensuring real-time visibility into critical call-center performance metrics and facilitating agile decision-making.
About
Mahnoor Tariq is a highly accomplished Business Intelligence Developer with over 4 years of experience driving data-driven insights and strategic solutions for leading organizations like PepsiCo and Quicken Loans. Specializing in end-to-end dashboard development, advanced data analysis, and reporting automation, Mahnoor has a proven track record of delivering measurable business impact, including over $1M in annual savings and significant improvements in operational efficiency and risk mitigation. Adept at leveraging SQL, Power BI, Tableau, and Snowflake to transform complex data into actionable intelligence, she is poised to excel in a challenging role focused on optimizing business performance through sophisticated analytics.
Skills
Technical & Professional Skills
SQL, Power BI, Tableau, Microsoft Excel, Snowflake, MS SQL Server, R, HTML, Data Analysis, Data Visualization, Regression Analysis, A/B Testing, Query Optimization, Data Validation, Reporting Automation, Business Intelligence, Strategy & Analytics, Business Requirements Gathering, Project Management, Team Leadership, Presentation Skills, Public Speaking, Public Relations, Research, Management, Event Planning, Clinical Research, Protein Purification, SDS-PAGE, Genetics, Epidemiology, Biochemistry, Molecular Biology.
Education
Boston University
→
Master's degree
Business Analytics
COMSATS Institute of Information and Technology
→
Bachelor of Science (B.Sc.)
Biology/Biological Sciences, General