Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Languages
Software Tools
Timeline
Generic

Dipashri Kalokhe

Summary

Results‑driven Data Architect with 14+ years of expertise in Microsoft BI, Azure, and enterprise data integration. Proven success in designing scalable ETL frameworks, migrating legacy systems to cloud platforms, and optimizing SQL performance for global insurance and banking clients. Recognized for delivering automation and innovation that improved efficiency and client satisfaction (CSAT 4.7). experienced leader and mentor overseeing teams of up to 11 members while consistently earning awards and client commendations for excellence in delivery.

Overview

1
1
Certification
14
14
years of professional experience

Work History

Senior Specialist

LTIMindtree Technologies
12.2024 - Current
  • Optimized SQL performance with DPA/SolarWinds, resolving latency issues.
  • Implemented dynamic Azure Data Factory (ADF) pipelines to replace legacy SSIS ETL orchestration, enabling scalable and automated data integration.
  • Delivered RiskFacs US and GES UK migrations for Origami RiskFacs (US) and Snapsheet UK, ensuring accuracy and scalability.
  • Automated validation and tuning with GitHub Copilot.
  • Led Notes & Email ingestion project within Gallagher Specialty, improving efficiency.
  • Recognized with customer appreciation for Genesis Specialty release from Gallagher US and LTIM leadership.
  • Streamlined effort estimation and enabled design of additional systems, ensuring seamless integration of new data sources into the GB GIS platform for Luminous and Genesis clients.

Architect

Wipro Technologies
Mumbai
12.2021 - 12.2024
  • Automated Periodic Review Predictions Dashboard for Standard Bank of South Africa, earning Beyond Excellence Award.
  • Designed and optimized Azure VM alerts, improving Compliance IT monitoring and platform health.
  • Developed custom KQL scripts in Azure Log Analytics for advanced VM monitoring.
  • Recommended additional metrics such as disk space usage monitoring to improve coverage.
  • Ensured Azure VMs were correctly configured for monthly patching with proper tags and agent installation.
  • Implemented cost optimization strategies for Azure subscriptions, reducing overhead and improving efficiency.
  • Orchestrated ADF pipelines using Snowflake, Azure SQL DB, Blob Storage as source.
  • Contributed white papers and served on interview panels for team selection.
  • Recognized with multiple awards (Round of Applause, Customer Appreciation, Manager Recognition) from Standard Bank Group Limited.

MS-BI Module Lead/Senior Consultant

LTI
12.2017 - 11.2021
  • Architected ETL frameworks consolidating data from 80+ entities.
  • Designed ETL routines to load data incrementally through the ETL Framework into the CDL ODS for ~86 entities and 8 branches.
  • Migrated applications for CapRe Singapore, CapRe Nordic, Acturis (Stackhouse Poland, SimplyB, Bollington) and performed large‑scale backloads, ensuring data accuracy and seamless transition .
  • Designed business rule engines using CDC concepts, enhancing revenue recognition accuracy.
  • Participated in request for proposal (RFP) processes, showcasing client‑facing skills and fostering strong client relationships.
  • Handled critical month‑end revenue recognition activities, including data segregation across heterogeneous systems, loading into the EDW, and coordinating automated runbook maintenance.
  • Led a team of 9–11 members, achieving CSAT 4.4, with automation of tasks and delivery excellence highlighted as key client feedback.
  • Recognized by client CIO/CEO/CFO and LTI leadership for successful migrations and upgrades (e.g., TLS 1.2).
  • Supported major insurance clients including Arthur J Gallagher UK, Lloyds, Aspen, RBS, POFS, CDL, Cubit, Open Twins.

MS-BI Developer / Senior Developer

Accenture Services Pvt Ltd.
Mumbai
07.2012 - 12.2017
  • Developed SSIS packages, ETL routines, and SSRS reports for a top North American insurer.
  • Designed data warehouse models and dashboards in Power BI/QlikView for insurance and financial clients.
  • Trained 50+ associates on RDBMS and BI practices, enhancing team capability.
  • Delivered automation and performance tuning solutions, earning multiple Inspire Awards.
  • Built dashboards for Accenture senior leadership covering KPIs such as resource movement, attrition, and utilization.
  • Evaluated third‑party applications like Cozyroc to enhance SSIS and SQL Server productivity.
  • Resolved production issues promptly, ensuring application stability and performance for uninterrupted business operations.
  • Mentored junior team members on both functional and technical project aspects, enhancing overall team capability.

Education

B.E. - EXTC

K.J. Somaiya In.Engg And I.T.
Mumbai
01-2012

HSC - Mumbai

Vani Vidyalaya Junior College
Mumbai

SSC -

Mulund High School

Skills

  • Databases & ETL: SQL Server, T-SQL, SSIS, SQL Server Data Tools, BIML
  • Cloud & DevOps: Azure SQL, Azure Data Factory, Azure VM, Azure DevOps, GitHub, Microsoft Fabric
  • Analytics & Reporting: Power BI, SSRS
  • Automation & Tools: PowerShell, Control-M, Team Foundation Server
  • Data Management: Data integration, migration, warehousing, analytics

Certification

  • Microsoft Certified Solutions Associate – SQL Server 2012
  • 70 - 461: Querying Microsoft SQL Server 2012
  • 70 - 463: Implementing a Data Warehouse with Microsoft SQL Server 2012
  • Microsoft Certified: Azure
  • Microsoft Certified: Azure Fundamentals AZ-900
  • Microsoft Certified: Azure Data Fundamentals DP-900
  • Microsoft Certified: Azure Data Fundamentals AI-900

Accomplishments

  • Spot Award (Wipro), Beyond Excellence Award (SBSA), Inspire Awards (Accenture), LTI Pride Award.
  • Recognized by clients and leadership for excellence in delivery, automation, and innovation.
  • Winner of Knowledge Bowl for whitepapers on best practices.
  • Delivered RDBMS training to 50+ associates, achieving 4.7/5 feedback.
  • Event Head for the IEEE 2010 for Robotics Workshop and technical events organized by IEEE.

Languages

  • English
  • Hindi
  • Marathi

Software Tools


  • SQL Server Management Studio (SSMS): 14 years
  • SQL Server Data Tools – BI for Visual Studio: 14 years
  • Power BI: 3 years
  • SQL MDS 2016: 3 years
  • Azure DevOps: 3 years
  • BIML: 2 years
  • Control‑M: 2 years
  • Azure Data Factory (ADF): 2 years
  • Azure SQL Database: 2 years
  • Azure VM: 2 years
  • GitHub: 2 years
  • GitHub Copilot: 2 years
  • Attinuty Qlik: 6 months
  • Microsoft Fabric: 6 months

Timeline

Senior Specialist

LTIMindtree Technologies
12.2024 - Current

Architect

Wipro Technologies
12.2021 - 12.2024

MS-BI Module Lead/Senior Consultant

LTI
12.2017 - 11.2021

MS-BI Developer / Senior Developer

Accenture Services Pvt Ltd.
07.2012 - 12.2017

B.E. - EXTC

K.J. Somaiya In.Engg And I.T.

HSC - Mumbai

Vani Vidyalaya Junior College

SSC -

Mulund High School
Dipashri Kalokhe