I had the pleasure of working directly with Val a couple of years ago with both SQL Server 2016 and Snowflake. She was extremely reliable and would keep pushing until each individual project was comp...
Trust Score
Exceptionally trusted; proven professional excellence.
RemoteTemporary, part-time consultant hired to identify and fix system performance issues and to create Power BI reports and dashboards. Root cause analysis (RCA) shows missing indexes, unused indexes, poorly designed indexes, inefficient code in stored procedures and views, unnecessary use of tempDB, and an under performing database architecture. Identified duplicate and missing data from a data m...
RemoteChampioned adoption of Snowflake and aided configuration of Snowflake, conducting training sessions for new users and the IAM team on user and role management. Developed efficient, scalable system for retail promotions, reducing processing time from two hours to two minutes, designed to transition from SQL Server to Snowflake. Spearheaded migration of SQL Server stored procedures and views to...
RemoteDesigned large-scale data mart (2+TB) using SQL Server ETL techniques and job scheduling. Developed daily ETL processes in Snowflake using DAG tasks and procedures. Enhanced data operations logging within ETL process, incorporating error reporting and deadlock resolution. Produced educational materials including training videos on data mart operations, promoting knowledge transfer and tool pr...