Deshant Rana

• Current Application State Analysis: Evaluated the production state to assess new implementation impacts on business processes.
• Data ETL: Extracted, transformed, and loaded data using Azure Data Factory, T-SQL, Spark SQL, and U-SQL. Improved ETL efficiency by 30%.
• Data Ingestion: Streamlined data ingestion to Azure Data Lake, Azure Storage, Azure SQL, and Azure Data Warehouse, processed using Azure Databricks. Reduced data ingestion time by 25%.
• Proof of Concepts: Implemented PoCs for SOAP & REST APIs, resulting in a 20% improvement in data retrieval efficiency.
• Power BI Solutions: Designed and developed Power BI dashboards, enhancing data visualization and business insights by 40%.
• REST APIs: Developed REST APIs for analytics data retrieval, improving data access speed by 15%.
• ADF Pipelines: Created ADF pipelines using Linked Services/Datasets for comprehensive data ETL from various sources. Enhanced data processing accuracy by 10%.
• Stakeholder Collaboration: Worked with stakeholders to meet data needs, resulting in a 35% increase in stakeholder satisfaction.
• Spark Applications: Developed and tuned Spark applications using PySpark and Spark-SQL, achieving a 25% increase in data processing speed. Monitored and troubleshot Spark clusters, optimizing cluster size and performance.
• Automation with SQL Scripts: Automated processes with SQL scripts, reducing manual effort by 30%.
• Reporting and Analysis: Generated custom reports, summarized business, financial, and economic data, improving decision-making speed by 20%.
• Industry Trends Communication: Engaged with customers, competitors, and suppliers to stay updated on trends, improving strategic alignment by 15%.
• Build and Release Management: Managed build and release processes using Visual Studio Team Services (VSTS) for multiple projects.
• KPI Definition: Defined KPIs based on collected data, improving performance tracking and reporting by 25%.

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.

• Customer Account Management: Handled over 150 customer accounts, ensuring seamless onboarding and integration onto the RocketRez platform.
• Provided continuous support to ensure customer success.
• Onboarding & Training: Conducted over 50 training sessions and webinars, leading to a 95% customer satisfaction rate post-onboarding.
• Data Analysis: Utilized data analytics tools to monitor customer engagement and usage patterns. Identified key metrics to enhance customer experience, resulting in a 15% increase in customer retention.
• Customer Communication: Responded to an average of 200 customer inquiries per month, addressing pre-purchase, post-purchase, and technical issues efficiently.
• Process Improvement: Implemented new support workflows that reduced response times by 20% and increased resolution rates by 25%.
• Cross-functional Collaboration: Worked closely with the product and engineering teams to relay customer feedback and drive product improvements, enhancing overall user experience.
• Performance Metrics: Achieved a 10% increase in upsell opportunities through targeted customer engagement strategies and proactive support.

• Spearheaded telecom initiatives for the Saudi Parliament and Royal Area, generating more than $10M inrevenue (breakdown: 30% from improved connectivity, 40% from enhanced network performance, 30%
  from cost optimization).
• Implemented telecom solutions, driving 17% productivity gains and $108,000 cost savings annually.
  Streamlined communication systems, reducing downtime by 12% and ensuring uninterrupted connectivity.
• Collaborated to resolve complex telecom issues, minimizing disruptions and optimizing network performance.
• Led integration of advanced technologies, resulting in improved data security and communication capabilities.
• Developed strategic plans, reducing expenses by 30% and enhancing service quality.
• Mentored and supervised 30+ telecom professionals, delivering high-quality projects on time and within budget.
• Conducted regular audits, ensuring industry compliance and implementing performance upgrades.
• Managed vendor relationships, negotiating contracts for annual cost savings.
• Acted as a key liaison, providing expert advice and ensuring seamless communication channels

• 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.