Mahdeep Singh

Mahdeep Singh Toronto, Ontario | - |-| LinkedIn Detail-oriented and results-driven Business Analyst with a strong foundation in IT and business project management, system development lifecycle, and data analysis. Knowledgeable in requirement gathering, process improvement, and stakeholder communication through work experience, coursework, and hands-on projects. Skilled in leveraging project management and data visualization tools to analyse business needs and optimize workflows. Successfully developed and executed self-initiated projects in the banking and marketing sectors, demonstrating the ability to apply business analysis frameworks in real-world scenarios. Adept at collaborating with cross-functional teams and delivering insights that drive informed decision-making. CORE COMPETENCIES Project Lifecycle Management Agile and Waterfall Methodologies Business and IT Analysis Software Development Life Cycle (SDLC) User Acceptance Testing (UAT) Quality Assurance Digital Transformation System Integration/Implementation Budget Planning & Financial Oversight Cross-functional Team leadership Stakeholder Engagement & Management Process Re-engineering & Optimization PROFESSIONAL EXPERIENCE TELUS Digital AI Data SolutionsRemote, CA Data AnalystOctober 2024 – January 2025 Conducted data profiling and cleaning on 500,000+ geographical records, improving dataset accuracy by 30% using SQL and Python (Pandas, NumPy). Assisted in training AI models by supplying high-quality, structured geographical data, improving model precision by 15%. Performed quality assurance checks and resolved 98% of discrepancies in geographical data pipelines, reducing processing errors by 35%. Enhanced operational workflows through ITIL-aligned process improvements, reducing data processing time. Designed and executed deployment strategies for SAP-integrated systems, minimizing system downtime and improving operational efficiency. Researched and implemented advancements in geographical data analytics tools. Documented data collection, validation, and analysis workflows, enhancing operational transparency and reducing onboarding time for new analysts by 15%. Utilized advanced formulas, VLOOKUP, and PivotTables in Microsoft Excel to optimize data validation processes, reducing manual effort by 30%. Troubleshooted and debugged SQL queries to identify and resolve data-related issues, ensuring data accuracy and reliability. Ensured clear and consistent communication with stakeholders through regular updates and status reports, utilizing tools such as Confluence and Slack to document progress, track changes, and address any issues promptly. Guru Tegh Bahadur Institute of TechnologyNew Delhi, IN Jr. Business Analyst (Internship)October 2021 – August 2022 Analyzed stakeholders' requirements and processes by creating user stories and business requirements, and conducting workflow analysis, leading to more efficient project planning and execution. Facilitated the collection and analysis of data on the education industry’s LMS and CRM trends, market demand, and competitor performance, generating comprehensive reports to support organizational decision-making. Implemented Agile methodology to assist with project workflows, facilitating regular sprint planning, daily stand-ups, and retrospective meetings, ensuring iterative development and continuous improvement. Developed Business Requirement Documents (BRD) and Functional Requirement Documents (FRD) and maintained version release documentation for necessary changes in Confluence. Conducted user experience testing (UAT) including functional, regression, integration, and performance testing to ensure that the product meets the documented requirements. Identified and implemented process improvements to enhance project efficiency and effectiveness, achieving a 20% increase in productivity. Conducted ad hoc analyses to address specific questions or challenges faced by the educational administrative unit, presenting findings and recommendations to relevant stakeholders, leading to informed decision-making and strategic planning. Ensured all stakeholders were kept informed of migration progress, risks, and issues through regular updates and Planview reports, resulting in a 98% satisfaction rate among stakeholders. PROJECTS Bank Loan Analysis Dashboard | Click to View Personal Project | Tech Stack: SQL, Excel, Tableau Analysed 38.6K loan applications, tracking a 6.9% MoM increase to identify lending trends. Developed interactive dashboards to monitor funded loans, reflecting a 13.0% MoM rise in disbursed amounts. Performed financial data analysis, revealing a 15.8% MoM growth in total received loan repayments. Segmented loan performance, showing 86.2% good loans vs. 13.8% bad loans for risk assessment. Evaluated credit risk by analysing 13.7% charged-off loans to improve decision-making. Measured key financial KPIs, including a 12.0% average interest rate and 13.3% debt-to-income (DTI) ratio to optimise loan strategies. Sales Analysis Dashboard | Click to View Personal Project | Tech Stack: MS Excel, SQL, Power BI Developed an interactive sales and profit dashboard, improving visibility into key business metrics across products, orders, digital advertising, and customers. Analyzed order and quantity trends, revealing a 15% increase in total sales and a 12% rise in profit margins over time. Segmented sales performance, showing consumer sales accounted for 52% of total revenue, aiding strategic planning. Identified top customers, with key accounts driving over 20% of total sales, enhancing customer retention strategies. Strategic Investment in Green Hydrogen and Battery Storage Technologies | Click to View Academic Capstone Project | Tech Stack: MS Word, Excel, PowerPoint, Canva, Git Conducted thorough research into Renewable Energy, especially energy via green hydrogen, to support the business case for pursuing fuel solutions based on the same. Developed a Project Charter outlining the scope, objectives, timelines, and deliverables for Power Corporation of Canada’s green hydrogen and battery storage investment. Created a BRD, documenting functional & non-functional requirements, ensuring alignment with strategic goals. Conducted a 20-year feasibility study, forecasting ROI, expenses, CCA impact, and post-EBITDA net income. Authored a 500-page report covering competitive analysis, project management, feasibility, risk mitigation, and implementation strategies. Amazon Fulfillment Center Process – Swimlane Diagram Project | Click to View Academic Project | Tech Stack: MS Visio Created a Swimlane diagram mapping the key fulfillment processes via Visio to define role-based workflows. Analysed bottlenecks in order processing, inventory management, and shipping, proposing automation improvements. Evaluated robotic systems and AI logistics for efficiency gains in warehouse operations. Quality Function Deployment (QFD) for Auto Insurance Policy | Click to View Academic Project | Tech Stack: MS Excel Created a QFD project to identify and prioritise customer requirements for an auto insurance policy. Developed a House of Quality matrix to align customer needs with functional and technical requirements, resulting in product enhancements based on customer preferences as well as market trends. EDUCATION Conestoga CollegeKitchener, ON PG Diploma in Information Technology Business Analysis2023 – 2024 Guru Gobind Singh Indraprastha UniversityNew Delhi, IN Bachelor of Technology in Computer Science2018 – 2022 TECHNICAL EXPERIENCE Office Productivity Tools: Microsoft Office Suite, Google Workspace Project Management and Collaboration Tools: Slack, Jira, Confluence, MS Project, Planview, Trello Database Management Systems: MySQL, MongoDB Data Analysis and Visualization Tools: MySQL, MS SQL Server, MS Excel, Power BI, Tableau Programming Languages: JavaScript, Java, C++, Python OTHER Certifications: Business Analysis Techniques for Business Transformation (PMI) Languages: English (Fluent), Hindi (Native), Punjabi (Fluent), Spanish (Intermediate)