David Cruz Email & Phone Number

Salt Lake City, Utah, United States

South Jordan, Utah, United States

Software Engineering Leadership: Led and managed a software engineering team responsible for developing and integrating third-party APIs, machine learning models, and data solutions for underwriting and risk management. Successfully completed integrations for two e-commerce websites, onboarding of a new fraud detection data provider, and transitioned from legacy Lease Management System to a new SaaS platform. Machine Learning Model Development: Oversaw the design, development, testing, and deployment of two new machine learning models for fraud detection and credit risk evaluation using Python, SQL and NoSQL Databases, AutoML, and C# to reduce fraud rates, reduce default, and increase profitability.Portfolio Optimization: Implemented processes for optimizing the profitability and performance of the company portfolio using a data-driven approach that includes linear regression, logistic regression, integer programming, and what-if analysis.Project Planning and Prioritization: Planned and prioritized API integrations and underwriting projects and initiatives using data-driven strategies to meet business objectives and deadlines.Quality Assurance: Implemented and maintained unit testing and quality assurance processes for underwriting software, ensuring high standards of data integrity and reliability, and increasing test coverage.Compliance Assessments: Conducted compliance assessments and audits of underwriting policies and procedures, and adjusting the underwriting system to ensure alignment with regulatory and industry standards.Stakeholder Collaboration: Collaborated with senior management, business intelligence and software engineering teams, data providers, and e-commerce partners to plan projects, evaluate new products, and present underwriting results and insights, leveraging data visualization tools for effective communication.

Salt Lake City, Utah

Technical Support and Guidance: Provided technical support and guidance to a team of data migration engineers as part of an on-call rotation, resolving issues promptly and ensuring a smooth and reliable migration of data from legacy systems to Filevine’s platform.Performance Tuning and Optimization: Conducted performance tuning and optimization of data migration processes to minimize downtime and ensure seamless user experience.Data Migration Protocols: Regularly reviewed and updated data migration protocols for various competitor systems by collaborating with data migration engineers.Data Integrity: Improved data migration validation and error handling procedures to maintain data integrity during migrations.Testing Tools Development: Developed testing tools to validate the performance of data migrations infrastructure and proactively identify potential issues.System Issue Identification: Identified system issues and collaborated with platform engineering teams to enhance data migration capabilities.

Salt Lake City, Utah

Data Engineering: Designed, developed, and tested ETL procedures to migrate client data from several different competitors' databases and client filesystems into customizable Filevine data structures. Created new tools and processes to support the migration of critical and previously inaccessible data, providing more complete data migrations for clients. Developed Dynamic SQL procedures that automated common data transformations, simplifying future scripting and reducing project timelines.Client & Team Collaboration: Collaborated with external clients, internal project managers, data migrations analysts, and other data migrations engineers to gather requirements, provide technical advice, determine project timelines, and present data analyses to facilitate data migrations decisions.Project Management: Maintained organized project documentation of data mappings, user acceptance test results, migrations checklist, and implementation go-live schedules to clearly communicate project progress and ensure seamless migration from legacy system into Filevine.Mentorship: Mentored other data migration engineers and analysts in best practices to improve data mapping, data validation, error handling, data access and transformation performance, and query patterns for clean code.

Draper, Utah

Data Engineering: Led a project to consolidate data feeds and simplify the data model within a cloud-based BI data warehouse, improving team efficiency and data reliability. Developed and maintained ETL processes of external and internal data sources for data warehousing needs using SQL and Domo.Business Intelligence: Utilized Domo to develop interactive dashboards and reports, driving strategic decision-making. Designed and delivered visualizations and dashboards of metrics and KPIs for the entire organization.Reporting and Analysis: Provided key metric reports and analyses to data scientists, operational managers, and executives. Conducted data analysis, contributing to the achievement of annual sales and revenue, and risk management goals.CRM Data Integration: Integrated with Sales and Marketing CRM to improve B2B and B2C relationships and sales using SSIS. Managed and delivered the project from beginning to end from included requirement analysis, data mapping, data cleaning, and data transfer automation.Team Collaboration: Collaborated with data scientists, data analysts, and executive management data stakeholders to align data initiatives with organizational goals.

Draper, Utah

Database Management: Under the direction of the Database Administrator, assisted in the management of database servers, ensuring performance and security. Resolved production performance issues during on-call rotation.SQL Development: Developed complex SQL queries, stored procedures, functions, and assisted engineers with the designing and building of databases and schemas to support business processes.Data Modeling & Quality: Designed and implemented data models and KPIs/metrics to ensure data quality, consistency, and integrity. Helped create and document database best practices and standards, reviewed and trained other engineers' changes to maintain best practices.Project Deployment: Delivered database-centric solution components of larger project deployments in various environments following sprint schedule.Performance Tuning: Conducted performance tuning and troubleshooting of Microsoft SQL Server applications, optimizing at the server, database, and query levels.Monitoring: Utilized tools such as Redgate SQL Monitor, Spotlight, and SolarWinds Data Performance Analyzer for monitoring and troubleshooting database performance.ETL Processes: Developed and maintained ETL processes using SSIS and SQL Server Agent for scheduling of jobs for data warehousing needs.Reporting: Provided reports and analyses of key metrics to operational managers and executives.Team Collaboration: Supported Database Administrators, Software Engineers, and Data Scientists in various projects.

Draper, Utah

Database Management: Under the direction of the Database Administrator, assisted in the management of database servers, ensuring performance and security. Resolved production performance issues during on-call rotation.SQL Development: Developed complex SQL queries, stored procedures, functions, and assisted engineers with the designing and building of databases and schemas to support business processes.Data Modeling & Quality: Designed and implemented data models, documented database standards and KPIs/metrics to ensure data quality, consistency, and integrity.Project Deployment: Delivered database-centric solution components of larger project deployments.Performance Tuning: Conducted performance tuning and troubleshooting of Microsoft SQL Server applications, optimizing at the server, database, and query levels.Monitoring: Utilized tools such as Redgate SQL Monitor, Spotlight, and SolarWinds Data Performance Analyzer for monitoring and troubleshooting database performance.ETL Processes: Developed and maintained ETL processes for data warehousing needs.Reporting: Provided reports and analyses of key metrics to operational managers and executives.Team Collaboration: Supported Database Administrators, Software Engineers, and Data Scientists in various projects.

Draper, Utah

Web Development: Developed web applications using C#, ASP.NET MVC, HTML, CSS, JavaScript, and Microsoft SQL Server.Agile Development: Participated in Agile/Scrum methodologies, breaking down projects into tasks, story pointing, task prioritization, and sprint deployments.Project Tracking: Utilized Kanban for ticket tracking and Git for branch management.Requirement Analysis: Conducted requirement analysis through communication with stakeholders, project managers, and the development team.Code Review: Engaged in code reviews to maintain high coding standards.

Salt Lake City, Ut

Improved study skills and lecture topic retention of math students from diverse backgrounds.Increased student homework completion, test scores, and grades.Promoted inter-student interaction and led study groups.Tutored subjects from algebra to statistics and calculus.