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.
