Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Hi, I’m

Prashant M Akolkar

Toronto,Canada

Summary

Experienced technical leader with over 10 years of expertise in data engineering, systems architecture, and project management. Recognized for fostering team collaboration and driving results through effective communication and strategic planning. Excels at navigating complex technical challenges and ensuring alignment with evolving business needs. Skills include leading cross-functional teams, implementing innovative solutions, and consistently delivering high-quality outcomes.

Overview

12
years of professional experience

Work History

Bank of Montreal

Senior Manager – Data Engineering
12.2021 - Current

Job overview

  • Lead a team of 5 + data engineers/tech consultant in designing, developing, and maintaining data pipelines and infrastructure across OnPrem & Cloud.
  • Created and maintained portfolio of 1 M Projects and increased overall P&BB T&O's portfolio by 20% YOY.
  • Collaborate with data scientists, analysts, and business stakeholders to ensure data solutions align with business goals and requirements and key initiatives for Risk such as re-vamping Bank's Credit risk strategy & Regulatory initiatives such as Dodd Frank 1071 & CCH - Consolidated Contact History , Including the migration of on-premises data systems to cloud-based solutions, resulting in effectively decommission merged bank data centers and created reports for 40 apps for Retention.
  • Coordinated cross-departmental projects to improve product delivery timelines, enhancing customer satisfaction.
  • Played a pivotal role for enabling Data governance team for P&BB and Implemented data governance and quality frameworks to ensure the integrity and reliability of data
  • Manage project timelines, budgets, and resource allocation to ensure successful delivery of data engineering projects.
  • Mentor and provide professional development opportunities for team members, fostering a culture of continuous learning and improvement and innovation by leading Proof of concepts for AI & Automation
  • Improved team productivity by implementing agile methodologies, reducing project completion times and enhancing collaboration.
  • Developed strategic roadmaps for technology initiatives aligned with organizational goals while maintaining focus on resource allocation efficiency.

Tata Consultancy Services Canada

Business System Analyst/Data Architect
10.2020 - 05.2021

Job overview

  • Designed Data warehousing solutions for BMO including as part of Fraud Modernization program and House holding upgrade program
  • Created multiple solutions with tight timelines and ingesting both batch as well as real time integration of data and helped Fraud analysts/Data Scientists achieve better Fraud detection with the help of vendor
  • Modeled entire project and created lineage/Mapping documents along with Use Case Scenarios and Data Flow Diagrams
  • Evaluated vendor proposals to select the most suitable solutions for business needs while maximizing cost efficiency.
  • Modeled solution framework for Company to improve their estimation creation & solution
  • Promoted a culture of continuous improvement by regularly reviewing system performance, identifying areas for enhancement, and implementing necessary changes.
  • Reduced operational costs by identifying inefficiencies in existing systems and proposing innovative solutions for optimization.
  • Trained business personnel in use of systems including data migration and consolidation efforts.
  • Analyzed existing systems and databases and recommended enhancements to solve business needs

Bank of Montreal/TCS (11163507 Canada Corp.)

Business System Analyst /Data Architect
01.2019 - 10.2020

Job overview

  • Enabled Marketing team for Change Management by developing Data warehousing solutions for BMO including acquiring new sources and assessing systems for migration from Netezza to Hadoop along with upgrading their existing MDM functionality to transition them from SQL to SAS and enabled them to get ROI of 3M.
  • Created multiple solutions with tight timelines such as regulatory compliance – TCPA, CCPA (California Consumer Protection Act), MDM upgrade and Data Acquisition projects.
  • Coordinated with all the groups to successfully incorporate Change Requests by informing stakeholders of their implications such as migrating from old system to newer system from Netezza to Hadoop
  • Assisted Stakeholders in data profiling, data quality assessment and helped them to assess requirements and provided similar information to Development team and test team
  • Analyzed the existing Ad-hoc reports from the legacy system and mapped to new data sources
  • Performed third-party software analysis as needed for inclusion in the project solution
  • Reviewed test plans and test scripts with testing teams and created Requirement Traceability Matrix
  • Reviewed test scripts and test execution results to ensure that software is delivered to end users with no critical or medium defects

Data Source, an EXL Company

Senior Business Analyst/Data Engineer
02.2018 - 10.2018

Job overview

  • Implemented Data Lake & Data Quality solutions for multiple clients such as Remax and KBRA to move from SQL Server to Snowflake to effectively enable Business in their cloud journey in 500k. Migrated one Billion records for Analytics firm and was key member in migration and planning from offshore.
  • Provided ETL Solutions with various tools such as SSIS & Talend based on Azure and Snowflake DB.
  • Identified and prioritized requirements for Insurance as well as Real Estate client to accommodate futuristic solutions to increase their revenue with optimized tools and solutions
  • Helped Real Estate Client eliminate re-selling the same property by proposing real time integration and batch mode daily integration for migration projects from SQL Server to Snowflake
  • Mentored team members about latest technologies and created standard templates for future usage
  • Implemented Data Quality Solutions such as Profiling, Address Cleansing, Name Standardization & De-Duplication which helped client in sending appropriate mail to their customers and avoiding re-routing or sending incorrect information

Wipro Technologies

Senior ETL/SQL Analyst
02.2013 - 01.2018

Job overview

  • Implemented & Maintained ETL & Data Quality solutions for multiple clients mainly US as well as European clients such as Campbell Soup, Mazda, Nokia and Marsh-McLennan
  • Provided ETL Solutions with various tools such as Informatica & EDQ
  • Worked for couple of migration projects which included migrating5-10 systems and usage of different sources such as XML, Mainframe, Oracle DB and Siebel CRM/UCM
  • Deployed minor enhancements which included Unit Testing, Tuning the SQL and made sure optimized query is sent downstream to avoid any impact
  • Maintained Clients’ system according to ITIL & SLA standards and made sure SLA isn’t breached and if breached then provided proper root cause analysis
  • Suggested optimal solution for the SQL Query using Pre/Post runs – which helped to improve the run time of a query from4 hours to15 minutes
  • Tuned the Informatica mappings and removed redundancy which helped client reduce entire batch time by2 hours
  • Provided RCA’s for Break fixes which included extensive debugging skills from reporting tools such as Microstrategy to Informatica and even SAP ABAP

Education

Visvesvaraya Technological University
Karnataka

Bachelor of Engineering from Computer Science
01.2012

University Overview

Assessed by WES as equivalent to a Canadian Bachelor’s Degree

Skills

  • Project Management (Agile, Scrum & Waterfall)
  • Talent development
  • Organizational improvement
  • Strategic planning
  • Operations management
  • Merger & Acquisition
  • Cross-functional collaboration
  • Data-driven decision making
  • Cross-functional team leadership
  • Data Engineering & Data Architecture
  • Data Modeling/Cloud Data Architect
  • ETL/ELT Processes
  • Gap Analysis/Data mapping
  • Data Analysis/Break Fixes
  • Data Governance/Metadata Management
  • Data Profiling/ Data Lineage
  • Technology/Tools -
  • Data Lake/Lake Formation/S3/AWS Sage Maker
  • AWS Redshift spectrum/ETL/Data Quality
  • AWS Glue/SSIS
  • Informatica91,96I,101/Oracle EDQ121,3 (MDM)/Trillium161/Talend70
  • Redshift/Athena
  • Oracle SQL/Netezza/SQL Server/Hadoop
  • Snowflake
  • PowerBI
  • Python
  • AI - LLM Models
  • Agentic AI

Accomplishments

  • Received Ambition2025 - Best Employee Award for FY23.
  • Received Two spotlight quarterly award in the span6 quarters.
  • Received Shining Star award for Q22018 in EXL for helping project to turn from yellow to green state.
  • Received twice promotion within3 years of span and completed
  • Technical Lead certification in Wipro during the tenure of5 years.

Timeline

Senior Manager – Data Engineering

Bank of Montreal
12.2021 - Current

Business System Analyst/Data Architect

Tata Consultancy Services Canada
10.2020 - 05.2021

Business System Analyst /Data Architect

Bank of Montreal/TCS (11163507 Canada Corp.)
01.2019 - 10.2020

Senior Business Analyst/Data Engineer

Data Source, an EXL Company
02.2018 - 10.2018

Senior ETL/SQL Analyst

Wipro Technologies
02.2013 - 01.2018

Visvesvaraya Technological University

Bachelor of Engineering from Computer Science

Similar Profiles

CREATE PROFILE
Prashant M Akolkar