Krunal Gandhi

Senior database engineering and software professional with 19+ years designing, building and running mission-critical SQL Server systems for industrial and enterprise environments.

Proven ownership of the full database lifecycle: architecture and schema design, performance tuning and partitioning, ETL and data migration, reliable backup and disaster-recovery operations, and production incident response. Project manager and technical lead accustomed to owning projects end-to-end — from customer requirements through development, validation and go-live — while supervising developers and supporting global clients directly.

Microsoft Certified Technology

Specialist (MCTS); rigorous technical writer and Tier-2/3 escalation point in both customer-facing and internal contexts.

Senior Database Developer & Project Manager - Groupe Betavib Inc. - Vaudreuil-Dorion, QC

(2019-04)

• Own database architecture, performance, and reliability across every SQL Server environment supporting BETAVIB's industrial vibration-analysis platform, the backbone customers depend on to keep machinery health data flowing.
• Eliminated a major performance bottleneck for a customer by designing and implementing table partitioning on a large production table, turning slow queries into fast ones without disrupting live operations.
• Designed and built a bi-directional synchronization application from the ground up, giving field technicians real-time, two-way data sync between tablets and the central server — now relied on daily by field teams and analysts.
• Delivered the IFX application (DB Integrity and Software Update modules), cutting the manual effort customers previously spent on database maintenance and version upgrades.
• Led the full Vibworks V4-to-V5 database migration end-to-end — assessment, schema and data migration, a purpose-built migration application, and validation — delivering a smooth path to the new platform with verified data integrity.
• Protect business continuity for every hosted customer by managing host servers with backup and disaster-recovery processes.
• Deliver production-ready environments to global clients before dispatch, provisioning RAID, OS, SQL Server, and application deployment.
• Manage development projects end-to-end as Project Manager: gather customer requirements, secure management buy-in, translate requirements into scoped development plans, and supervise developers to deliver on schedule.
• Coordinate priorities across management, developers, and customers — scoping new features, sequencing work, and keeping stakeholders aligned from kickoff to release.
• Conduct onsite and remote requirement sessions with customers and their IT teams ahead of database and software implementations and migrations.
• Serve as the Tier-2/3 escalation point for complex database and software issues via MS Teams, phone, and email; deliver onboarding training and maintain internal/external knowledge-base documentation.

Senior Database Developer - FLS Transportation - Montreal, QC

(2017-10 - 2019-04)

• Designed, stabilized, and modernized SQL Server databases behind the TMW transportation management system through query tuning, execution-plan analysis, performance monitoring, and hands-on maintenance, including regular backup and restore operations.
• Built and managed database solutions using T-SQL, stored procedures, functions, views, triggers, DTS packages, SSIS, SQL Agent jobs, index maintenance, and maintenance plans.
• Designed and implemented ETL mappings, procedures, and schedules following standard lifecycle practices, ensuring data integrity and consistency across systems.
• Maintained the SSIS pipelines feeding the Data Warehouse from the TMW database, powering accurate and timely Cognos reporting.
• Eliminated manual data entry by building a PowerShell integration with the Samanage Ticketing API, automatically feeding ticket data into SQL Server via SSIS.
• Modernized reporting company-wide by converting the full SSRS report suite to Power BI and developing new Power BI reports based on evolving business requirements.
• Contributed to the TMW-to-Salesforce TMS migration, handling data mapping, transformation, and validation to protect data integrity through cutover.
• Improved order-entry efficiency for the Freight Management system through targeted database and workflow enhancements.

Senior Application & Database Developer - Business & Decision North America - Montreal, QC

(2010-01 - 2017-09)

• Led full-stack development of the Xpert ERP platform end-to-end — schema design, module development, testing, and production deployment.
• Directed the development team day-to-day: assigned tasks to developers, mentored junior team members through QA reviews, and owned patch releases to the Xpert production environment (database and application) — validating each developer's work against requirements on the test environment before deploying to production.
• Strengthened application security by building a role-based authorization framework that authenticated users and dynamically tailored menus, reports, and forms to each user’s role.
• Delivered a full-stack employee rewards portal solo, from requirements through production release, using ASP.NET and C#.
• Delivered business intelligence across the organization using SSRS, QlikView 9/10 (development and administration), Microsoft PowerPivot, and SharePoint reporting.
• Served as the go-to technical resource for consultants and clients, guiding software implementation, usage, and evaluation from both the business and technical sides.
• Partnered directly with the VP of Technology to evaluate options for enhancing existing functionality and scoping new development, based on requirements from HR, Finance, and PM stakeholders.
• Maintained servers, backups, and application infrastructure, safeguarding system stability and continuity.

Application & Database Developer - Business & Decision North America - Montreal, QC

(2006-01 - 2009-12)

• Built and maintained the SQL Server backbone of the Xpert ERP web application — stored procedures, functions, views, T-SQL, and DTS packages.
• Delivered Classic ASP front-end features and server-side logic across the full application stack.
• Translated business requirements into T-SQL queries and managed data imports/exports using DTS packages.
• Maintained servers and reliable backups of applications and databases, and provided technical support to consultants and internal teams via phone and email.
• Equipped consultants with fully configured, ready-to-work laptops and maintained the company Asset database for hardware tracking.

Database Developer - Epoch (AMBFS International Division) - Mumbai, India

(2004-03 - 2005-07)

• Designed and implemented core database objects (stored procedures, triggers, functions, views) supporting the full development lifecycle from coding through documentation.

Advanced Software Technology - Mumbai University, India (2001 - 2003)