Deshant Rana

Led Data Integration for BMO’s $16.3B Acquisition of Bank of the West

• Oversaw the end-to-end integration of legacy Bank of the West systems into BMO's data ecosystem as part of one of the largest cross-border banking acquisitions in North America.
• Designed and implemented secure, scalable data pipelines to ingest, validate, and transform terabytes of customer, transactional, and product data from multiple legacy sources into BMO’s unified data lakehouse (Azure/Snowflake).
• Built robust reconciliation frameworks to ensure 99.99% data accuracy during cutover, minimizing operational risk and enabling seamless customer experience post-migration.
• Partnered with cybersecurity and compliance teams to ensure all migrated data met strict regulatory requirements (GLBA, SOX, Canadian OSFI standards) and underwent automated audits before go-live.
• Enabled faster regulatory reporting and customer onboarding by integrating critical data into BMO’s core analytics and risk platforms within 6 weeks of deal close.
• Acted as a key data liaison across Canadian and U.S. engineering teams, helping align data dictionaries, retention policies, and metadata management practices between two banking cultures.
• Resulted in successful onboarding of over 1.8 million new customer records, with zero major data incidents reported post-integration.

• Implemented Optical Fiber technology project called as Fiber to the Home (FTTH), deploying Optical Network
  Terminals (ONTs) and Optical Line Terminals (OLTs). This initiative led to a remarkable 15% surge in high-speed
  internet subscriptions, generating an annual revenue increase of $50,000.
• Deployed advanced Wireless Networking solutions, leading to a 20% rise in mobile data usage, generating
  an additional $80,000 in revenue.
• Conducted Wireshark analysis and troubleshooting network issues, reducing downtime by 10% and saving
  $20,000 in operational costs.
• Managed LAN Switching and configuring Cat6 cabling, enhancing network performance by 15% and
  generating $30,000 in improved productivity.
• Leading a team in the successful configuration of Cisco Routers and IP Phones, resulting in seamless
  communication and a 25% reduction in telephony expenses, saving $60,000 annually.
• Configured and managed Network Switches, leading to improved network performance and a revenue
  growth of 16%.
• Resolved network-related issues through effective Troubleshooting techniques, resulting in a revenue increase.
• Identified and resolved Internet Troubleshooting problems promptly.
• Proficient in managing PBX systems and optimizing communication infrastructure.
• Configured and maintained Cisco Routers, enabling seamless network connectivity, and generating revenue
  growth.

• Conducted regular follow-up calls with customers after resolving their issues.
• Tracked orders from start to finish to ensure timely delivery of goods or services.
• Identified areas of improvement in customer service processes and suggested changes accordingly.
• Implemented innovative methods for streamlining the customer service process.
• Developed positive relationships with customers through friendly interactions.
• Provided excellent customer service to resolve customer complaints in a timely manner.
• Answered customer inquiries via phone, email, and chat.
• Provided exceptional customer service to ensure customer satisfaction.
• Maintained a high level of professionalism when dealing with difficult customers.
• Resolved complex problems by working with other departments to provide solutions that meet customer needs.
• Answered customer inquiries and provided accurate information regarding products and services.
• Assisted customers with product selection, ordering, billing, returns, exchanges and technical support.
• Gathered customer feedback through surveys and used the data to improve customer service.
• Asked probing questions to determine service needs and accurately input information into electronic systems.