Bakee Subramaniam

Data Technical Support at Canam Systems (2018-09 – 2025-06)

Created and validated PSA databases on SQL Server, enabling TCP/IP, configuring firewall rules, and ensuring secure connectivity—reducing onboarding time by 30% and strengthening data integrity.
PSA installations and SQL Server migrations across multiple versions, coordinating with IT teams to ensure smooth go-lives and reliable API sync operations.
Investigated and resolved data issues across ERP (Accounting and Web), and CRM applications by updating stored procedures, views, and T-SQL logic using SQL Server Management Studio.
Created and configured ODBC connections for external PSA users, including provisioning SQL user accounts when required. This ensured smooth and timely access for third-party users and reduced access-related issues.
Restored and validated SQL databases from backups, executed customer/job record merges, and performed mid-scale data updates with accuracy using T-SQL.
Improved system performance by 25% through SQL Profiler analysis, query tuning, and index optimization.
Maintained SQL Server environments, including user creation, resolving recovery pending/log issues, and implementing automated daily backup processes to prevent future outages.
Resolved 100+ monthly client/server and API sync issues across PSA Desktop, Web, and CRM platforms, minimizing downtime for 50+ organizations.
Delivered end-user training and authored detailed documentation, reducing support tickets by 25%.

Database Support Specialist at The Marketing Store (2013-08 – 2017-09)

Collaborated with end-user representatives via email and phone to provide step-by-step guidance on navigating and utilizing the dealer website. Delivered clear instructions on access, features, and best practices, enabling users to complete processes accurately and on time while improving overall adoption of the system.
Monitored and optimized 15+ daily data feeds (using SFTP), import/export pipelines, and email processes, ensuring uninterrupted service for 240K+ customers.
Managed and validated 30K+ daily records across 2 enterprise web applications, safeguarding data quality for 1,200+ businesses.
Automated recurring workflows using SQL and SSIS, reducing manual interventions and preventing repeat incidents by 35%.
Streamlined API-based reporting for 3,000+ daily files, cutting downtime by 50%, and improving system reliability.

Associate Developer at Comtec (2012-10 – 2013-03)

Enhanced system stability by fixing database issues and upgrading legacy ASP/VB6/JavaScript/SQL sites to.NET, improving response times by 20%.
Developed reporting web pages in ASP.NET, consolidating fragmented reporting processes into a centralized system.
Collaborated with senior developers on application upgrades, accelerating project delivery timelines by 15%.
Conducted regression testing to validate software changes, reducing post-deployment issues by 30%.
Documented development procedures, ensuring smooth knowledge transfer within the team.

Associate Database Developer at CCom Solutions (2011-06 – 2012-07)

Communicate with clients to gather system details and translate technical requirements into clear Excel-based data mapping documents. Provided guidance on the ETL(SSIS) process, ensuring clients understand data workflows and enabling timely, accurate project completion.
Migrated and consolidated multi-source data into Sage CRM using SSIS and VB/C#, improving reporting accuracy by 40%.
Standardized input formats (Excel, CSV, Web Services) to a unified CRM system, cutting reporting inconsistencies by 25%.
Built automated ETL(SSIS) pipelines, reducing manual data handling by 50+ hours/month.
Partnered with client teams to validate migrated data, ensuring smooth adoption of CRM solutions.
Created test cases and executed validations to confirm data accuracy post-migration.

About