Mrinal Bhardwaj Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

Toronto, Ontario, Canada

• Performed business analyst responsibilities such as interviewing stakeholders and SME’s,brainstorming, document analysis, and creating use cases.• Prepared documents such as Intermediate Requirement Document (IRD), System Requirement Document (SRD), and Business Requirements Document (BRD)• Designed the architecture of the data transitions/mapping from databases to the in-house tool dashboard/data warehouse.• Worked as a lead BA in a mobile application development project… Show more • Performed business analyst responsibilities such as interviewing stakeholders and SME’s,brainstorming, document analysis, and creating use cases.• Prepared documents such as Intermediate Requirement Document (IRD), System Requirement Document (SRD), and Business Requirements Document (BRD)• Designed the architecture of the data transitions/mapping from databases to the in-house tool dashboard/data warehouse.• Worked as a lead BA in a mobile application development project, which increased the user base by 20%, bringing in mobile user traffic along with PC users.• Transformed 40+ as-is and to-be manual reporting processes on MS Excel and SAS to develop automated reports on Power BI that decreased manual work effort by 90%.• Developed a 1-stop-shop Executive Reporting solution with 20+ Executive Summary Power BI dashboards reporting on 75+ pillar KPIs across multiple global company operations. Equipped leadership with the right information and delivering data-based insights within a single environment.• Facilitated a 29.3% QoQ and 15.7% YoY increase in call center overall productivity and increased customer satisfaction by managing CRM software and introducing new triggers.• Supported Project Manager and Product Owner in maintaining, monitoring, and reporting project status of actions, issues, and risks log on a weekly basis which reduced the development and testing phase time by 10%.• Acted as a liaison between the business, technical team, and QA during the sprint to maintain project scope and eventual acceptance of the application.• Created and managed Traceability document between, BRD, User story, UID, and Use Case which helped avoid scope creep.• Created User Interface Document (UID) and Use Cases to help developers understand system behaviors from an end-user point of view. Show less

India

• Facilitated requirement elicitation and data gathering through Agile methods.• Conducted Data cleaning, filtering, and analysis of KPIs using statistical techniques.• Performed storytelling through Tableau Dashboards and Power BI, which increased profitability and +2.5% YoY change in retention.• Performed exploratory data analysis and root cause analysis using Python, SQL, and Excel.• Consulted with stakeholders to identify requirements, conduct data discovery, and make… Show more • Facilitated requirement elicitation and data gathering through Agile methods.• Conducted Data cleaning, filtering, and analysis of KPIs using statistical techniques.• Performed storytelling through Tableau Dashboards and Power BI, which increased profitability and +2.5% YoY change in retention.• Performed exploratory data analysis and root cause analysis using Python, SQL, and Excel.• Consulted with stakeholders to identify requirements, conduct data discovery, and make impactful recommendations based on facts that led to a 1.6% increase in revenue.• Developed a reporting structure that delivered 20+ reports and dashboards using Power BI and written effective DAX formulas and expressions.• Performed ETL, filtering, aggregation, data cleaning, and pre-processing on raw data from a data warehouse using Python and MS SQL to generate clean datasets and reports. Show less

India

• Conducted automation using Python and C++ to implement process testing procedures to automate conference calls for the company saving time for users and increasing the customer base by 10%.• Collaborated with the automation team to manage application resistivity, and suggested testing methods.• Created dashboards using Tableau to measure product portfolio performance based on territory analysis, customer segmentation, and growth analysis.• Predicted sales based on current data of… Show more • Conducted automation using Python and C++ to implement process testing procedures to automate conference calls for the company saving time for users and increasing the customer base by 10%.• Collaborated with the automation team to manage application resistivity, and suggested testing methods.• Created dashboards using Tableau to measure product portfolio performance based on territory analysis, customer segmentation, and growth analysis.• Predicted sales based on current data of the organization which increased revenue by 20%. Show less

Project Management It, Information Technology

Postgraduate Degree, Big Data Analytics

Bachelor Of Technology - Btech, It