Jasmeet Singh Email & Phone Number

Canada

Dallas, Texas, Us

• Significantly reduced customer response time for booking camp sites by creating Stored Procedures, Functions, Packages and Cursors using PL/SQL.• Secured database from SQL attacks using triggers to block data manipulation.• Spear-headed Data warehouse design and development to facilitate analytics for stakeholders.• Optimized database performance by partitioning large tables to enhance customer experience.• Integrated Retail POS on the fields with the data warehouse for downstream activations using AWS Services and Snowflake Integrations.• Produced documentation for all database and data warehouse developments and enhancements.• Utilized GitHub to version control for development work.

Vancouver, British Columbia, Ca

• Designed and developed backend medical database to aid data storage for Multiple Sclerosis (MS) research in North America. • Curated data flow and Entity Relationship with stakeholders.• Created front-end interface to allow researchers to upload and download large medical imaging datasets. • Applied data masking techniques to securely store medical data.• Performed technical troubleshooting to diagnose, isolate and correct data and database issues.• Migrated on-prem MySQL database to university private cloud server using containerization for portability, security and scalability. • Utilized Linux OS for network connectivity between on-prem and cloud.

• Developed new and maintained existing applications including ad hoc queries• Created SQL queries, stored procedures, functions and triggers• Monitored live SQL Server routinely, identify any flaw within query plans, physical designs, indexes, and naming conventions to further save IO, time, and hardware cost and increase performance across all platforms. • Provided technical support related to compliance with IT standards and requirements for system development life cycle activities• Performed analysis on source data to determine possible problems• Performed database optimization activities to improve query, integration and reporting layer performance.

Leading mobile app development and product engineering services company serving global customers. ✔ Installed & Configured SQL Server in clustered and non-clustered environment. Managed SQL Servers, Databases.✔ Wrote T-SQL statements using DML and DDL for data retrieval of using SSMS.✔ Delivered troubleshooting by using SQL Server Profiler and developing backup and restore scripts for SQL Server.✔ Created views to facilitate easy user interface implementation, and triggers to enforce Data and referential integrity.

Postgraduate Certificate In Information Technology Solutions, Database Development

Bachelor'S Degree, Computer Science