Kunaksh Verma

Highly experienced Detail detail-oriented Data Analyst with over 1+ years of expertise in analyzing business intelligence and reports within the banking and finance domain. Proficient in collecting, organizing, interpreting, and disseminating data with utmost accuracy and auditability. Skilled in utilizing reporting tools such as Power BI, Tableau, MS Excel, and PowerPoint, as well as programming languages like Python and R. Possesses in-depth knowledge of databases such as Microsoft SQL Server and MS Access.

Demonstrates a strong understanding of the software development lifecycle (SDLC) and agile methodology. Exceptional stakeholder management and interpersonal skills, with a proven track record of effectively collaborating within multidisciplinary teams. Known for the ability to influence others and faster connections in a multicultural environment. 

Data Analyst | Stripe | Toronto, ON April 2025 – Present

• Built and optimized end-to-end ETL pipelines in SQL and Python, reducing data processing time by 35% and enabling faster business insights.

• Developed and maintained Power BI dashboards that tracked KPIs across finance and operations, improving leadership decision-making speed by 25%.

• Led the development of automated dashboards using Power BI, increasing reporting efficiency for cross-functional stakeholders by 40%.

• Collaborated with cross-functional teams to establish data governance standards, implementing data lineage and metadata tracking that improved data discoverability by 40%.

• Utilized SQL to extract, clean, and join datasets from multiple sources, improving reporting accuracy to 99% and reducing manual reconciliation efforts.

• Built advanced Excel models with Power Query and pivot tables to forecast sales trends, improving demand planning accuracy by 20%.

Data Analyst | Electronic Arts |Toronto, ON July 2024 – Dec 2024

• Integrated Power BI with SQL databases, enhancing reporting accuracy by 60% and providing real-time data visualization to stakeholders.

• Used Python-based statistical analysis (e.g., regression, hypothesis testing) to evaluate marketing strategies, enabling a 20% improvement in campaign ROI.

• Performed data cleaning, modeling, and statistical analysis using pivot tables, VLOOKUP, and advanced Excel formulas.

• Automated variance analysis in Power BI using DAX, reducing manual calculations by 30%.

• Reduced forecast error by using Python and continuously optimizing parameters based on performance metrics.

• Facilitated agile practices by using Jira/Asana boards to plan sprints and assign tasks, enhancing team collaboration and project delivery.

• Leveraged Python to integrate data from SQL databases and Google Cloud Platform, streamlining campaign analytics workflows and improving data accuracy.

• Collaborated with cross-functional teams to gather business requirements and delivered custom Power BI reports that enhanced department decision-making. 

Analyst, CIBC | Toronto, ON Sept 2023 – Aug 2024

• Prepared and tested user reports in Excel and SQL, improving data accuracy and accessibility by 15%.

• Presented monthly forecast reviews using Python to senior leadership, providing insights to guide strategic planning and mitigate risks.

• Designed dashboards in Power BI for real-time monitoring of revenue and Invoice statements, improving stakeholder decision-making processes.

• Conducted process mapping to identify automation opportunities, leading to a 20% reduction in manual tasks using macros and VBA.

• Conducted strategic analysis using Python libraries like Pandas and NumPy to identify customer segments for targeted marketing campaigns, increasing engagement rates by 15%.

• Created Python-based ad-hoc analytical reports tailored for presentations to senior management, improving communication of business results and opportunities.

• Implemented KPI tracking on Jira/Asana boards to measure project performance and drive continuous improvement across teams.

• Standardized data management procedures through process mapping, improving efficiency and saving 5 hours weekly for the analytics team.

Customer Associate (performed duties as Data Analyst) | Scotiabank | Windsor, ON Sep 2022 - Aug 2023

• Created efficient Excel templates using VLOOKUP and macros to quickly log and track over 200 daily transactions, reducing time spent on manual data entry by 50%.

• Automated monthly financial analysis reports for balance sheets, using macros and Power BI, improving preparation time by 30%.

• Used the internal system to extract data using SQL queries and performed EDA to identify key insights and trends.

• Implemented Python-based analysis to monitor KPIs, identifying key growth opportunities and improving revenue margins by 12%.

• Transformed raw data in Excel into actionable insights, contributing to data-informed decision-making that led to a 10% increase in marketing campaign effectiveness.

• Developed a deep understanding of the bank's AML/ATF procedures and guidelines for reporting LCTRs and EFTRs, resulting in accurate and timely reporting of suspicious transactions.

• Managed end-to-end KYC processes, including customer onboarding, document verification, and risk assessments, ensuring compliance with regulatory standards.

• Applied Python-driven data storytelling techniques to clearly communicate portfolio trends and business insights, earning stakeholder buy-in on growth initiatives.

Data Analyst Co-op | Edison Finance | Toronto, ON Jan 2022 – April 2022

Project: Reproach Customer Model

• Built data and reporting dashboard from scratch with Tableau and SQL to gain real-time insights into the banking products

• Built predictive models using Python libraries like Scikit-learn and Stats models, improving forecast accuracy by 20%.

• Developed regression models and classifiers, improving customer satisfaction and client conversion rates by 18%.

• Independently conducted UAT, identifying and reporting critical issues early, which contributed to a 20% reduction in post-deployment bug fixes.

• Performed customer data analysis to determine various patterns and features to understand the factors associated with client conversion using Python libraries like Pandas and NumPy.

Data Analyst Co-op | National Informatics Center (NIC) | India Feb 2020 – June 2020

Project: Data Migration

• Optimized SQL queries by implementing an indexing mechanism, resulting in a 22% improvement in application performance and faster data retrieval.

• Supported the migration of databases across cloud platforms like AWS, Azure, or Google Cloud, optimizing system performance.

• Developed ETL pipelines using tools like SQL, Python to extract, transform, and load data into the data warehouse, reducing processing time by 30%.

• Monitored data migration progress using Excel and Power BI dashboards and reports, providing regular updates to project

managers and leadership.• Automated migration of 1,000 daily users between business domains using Excel (VLOOKUP, Macros), SQL, and Cron scheduling, ensuring minimal disruption and a seamless user experience.

• Utilized tools such as Python, SQL, and Power BI to analyze, clean, and transform datasets during migration processes.

Data Analyst Co-op| National Rifle Association of India Jan 2018 – Aug 2019

Project: Performance Analyst

• Automated reporting using VBA macros, reducing manual reporting time by 80%.

• Conducted A/B testing and multivariate analysis, leveraging Google Analytics data to optimize landing pages and improve user experience.

• Extracted and transformed data from multiple sources (Excel, SQL, APIs) using Power Query, creating unified and analysis-ready datasets.

• Built Power BI dashboards to track KPIs, enhancing accuracy by 2.5x.

• Delivered presentation skills training and mentoring for team members on SQL and Excel tools.

• Provided weekly and monthly reports on key performance indicators (KPIs) to senior management to track progress toward organizational goals in Jira.

Guru Nanak Dev University                                                                                                           

  Bachelor of Engineering – Information Technology  

  St. Clair College                                                                                                                             

  Post Graduate Diploma Degree in Data Analytics for Business