Casey Silva Email & Phone Number

Seattle, Washington, United States

Seattle, Washington, United States

Seattle, Washington, United States

• Responsible for overall design of the data platform ecosystem including infrastructure, application integration, security, ETL design, data warehouse modeling and ODS databases.• Served as a primary engineering resource for D1 project leadership team in Phase 0 planning, assessing project risks, resource needs, vendor tool requirements, workflow processes, employee onboarding and data access discussions. • Led modernization efforts by assessing cloud storage vendors… Show more • Responsible for overall design of the data platform ecosystem including infrastructure, application integration, security, ETL design, data warehouse modeling and ODS databases.• Served as a primary engineering resource for D1 project leadership team in Phase 0 planning, assessing project risks, resource needs, vendor tool requirements, workflow processes, employee onboarding and data access discussions. • Led modernization efforts by assessing cloud storage vendors, workflow orchestration and crud application tools as well as data catalog and MDM solutions Show less

Seattle, Washington

• Designed and built out infrastructure for a complete data platform rebuild - 12 sql servers, new build server, netapp storage configuration and setup for 40+ disks, CI/CD pipelines for dozens of database project solutions. Adjusted Security model to be more in line with best practices and implemented role based permissions across all instances.• Saved SCCA $30,000 in storage costs by identifying and correcting configuration issues impacting most production databases, lowering the volume… Show more • Designed and built out infrastructure for a complete data platform rebuild - 12 sql servers, new build server, netapp storage configuration and setup for 40+ disks, CI/CD pipelines for dozens of database project solutions. Adjusted Security model to be more in line with best practices and implemented role based permissions across all instances.• Saved SCCA $30,000 in storage costs by identifying and correcting configuration issues impacting most production databases, lowering the volume usage in many cases from 95% to <5%.• Overhauled sql server permission implementation code with more functionality, flexibility and reporting features.• Worked with sdet to design a flexible metric collection/ pass fail test harness• Redesigned and rebuilt SCCA’s primary growth and performance metric• Served as the senior engineering resource for D1 project leadership team in Phase 0 planning, assessing project risks, resource needs, vendor tool requirements, workflow processes, employee onboarding and data access discussions.• Lead interviews for new resources including a new data platform team manager, consultant resources and BAs.• Mentored other team members in optimizing code, designing etl processes, sql server maintenance plans and production issue fixes.• Worked with infrastructure to fill in communication/ process gaps between the data platform team and IT to improve inter department ticket resolution, and workflows. Show less

Greater Seattle Area

• Responsible for designing ERDs/implementing database solutions for new applications• Responsible for maintaining and adding new features to existing legacy web applications- a mix of internal and external facing web applications written using Coldfusion and ASP.Net• Designed and built an automation testing framework using C#/Selenium which allows the QA team to write their tests in pseudo code• Redesigned/ restructured multiple existing reporting databases and ETL processes to… Show more • Responsible for designing ERDs/implementing database solutions for new applications• Responsible for maintaining and adding new features to existing legacy web applications- a mix of internal and external facing web applications written using Coldfusion and ASP.Net• Designed and built an automation testing framework using C#/Selenium which allows the QA team to write their tests in pseudo code• Redesigned/ restructured multiple existing reporting databases and ETL processes to allow for a consolidated ETL and data warehouse Show less

Austin, Texas Area

• Post promotion continued to travel to customer locations to train their engineers.• Wrote PowerShell and T-SQL to analyze customer application use and server statistics for in-house hosted server farms.• Created a stress test tool to analyze the performance of a new encryption tool.• Designed/ implemented database schema for new fraud application module.• Designed and executed test workflows for new application scenarios.

Austin, Texas Area

• Traveled to customer locations to train the customer's database engineers in managing Bankers Toolbox application servers.• Designed and implemented banking client core system conversions within their versions of the company's application databases.• Wrote dynamic SQL scripts to perform data migrations/updates/purges on a diverse range of client environments.• Identified and implemented fixes for issues with web (IIS), data migration jobs/scripts, server failures, implementation… Show more • Traveled to customer locations to train the customer's database engineers in managing Bankers Toolbox application servers.• Designed and implemented banking client core system conversions within their versions of the company's application databases.• Wrote dynamic SQL scripts to perform data migrations/updates/purges on a diverse range of client environments.• Identified and implemented fixes for issues with web (IIS), data migration jobs/scripts, server failures, implementation errors, application speed performance.• Implemented database maintenance plans: stats, indexes, database and log backups.• Provided technical support and mentoring to staff and clients. Show less

• Designed and built a custom intake solution to efficiently translate results files generated from inspection surveys with manually typed responses into 250 distinct data points with strict output requirements. • Created all SQL objects necessary for a CRM integration with a custom in-house app. Worked with .Net developers and architect to match the SQL functionality with app requirements.• Solely responsible for managing/troubleshooting/optimizing and adding to a portfolio of 300+… Show more • Designed and built a custom intake solution to efficiently translate results files generated from inspection surveys with manually typed responses into 250 distinct data points with strict output requirements. • Created all SQL objects necessary for a CRM integration with a custom in-house app. Worked with .Net developers and architect to match the SQL functionality with app requirements.• Solely responsible for managing/troubleshooting/optimizing and adding to a portfolio of 300+ SSRS reports and administered both SSRS Reporting Services and MS SQL Server • Redesigned and optimized legacy queries, stored procedures and SSIS packages. Show less

• Developed a prototype datamart with a complete ETL solution to build relationships between and consolidate OLTP data from multiple business segments and maintain data history• Gathered reqs from business users for reporting needs and designed/developed solutions spanning OLTP, DataWarehouse systems• Solely responsible for managing/troubleshooting/optimizing and adding to a portfolio of 300+ SSRS reports and administered both SSRS Reporting Services and SQL Server • Created… Show more • Developed a prototype datamart with a complete ETL solution to build relationships between and consolidate OLTP data from multiple business segments and maintain data history• Gathered reqs from business users for reporting needs and designed/developed solutions spanning OLTP, DataWarehouse systems• Solely responsible for managing/troubleshooting/optimizing and adding to a portfolio of 300+ SSRS reports and administered both SSRS Reporting Services and SQL Server • Created jobs, SQL Mail Agent, Alerts and scheduled DTS/SSIS Packages. Show less

- Designed and developed 12+ executive Tableau dashboards- worked with IT to design new sources for company reporting requirements- Gathered requirements for and automated 10+ previously manual operations jobs using VBA.