Dennis Richards Email & Phone Number

Nampa, ID, US

Panama City, Florida, US

Nampa, Idaho, US

San Francisco, CA, US

• Developed ETL to import and export data from SQL and non-SQL sources with incremental load options for large tables.
• Implemented modular/self-healing methodologies to ease ETL support.
• Optimized code and developed TSQL, SSIS, and Excel VBA apps to support analysts and department heads.
• Designed and implemented security procedures and operational features for the SQL server and SSRS server in accordance with central IT compliance standards and server owner approval.
• Served as a first responder for server issues and escalated issues to respective departments if needed.
• Remediated Clarity deprecated tables and columns in deployed solutions and created Care at Home Datamart tables to support reporting needs.

Oakland, CA, US

• Reengineered legacy programming, corrected logic, and split universe populations for on-demand reporting.
• Reduced production time from weeks to hours by rearchitecting the overall design and streamlining the generation of over 50 extracts.
• Developed ad hoc Epic-Crystal reports while serving as backup ETL/SQL Server Administrator for the Clarity database.
• Prototyped solutions to improve team workflows including automating deprecation search processes and related exceptions.
• Designed a standard SQL procedure for all data extracts in addition to developing an automated XML/C# based archival tool for ServiceNow.

Martinez, California, US

• Optimized the reload of key metrics for 500K+ patient records to reduce processing time and designed various database objects to support the risk model.
• Automated the mass enrollment and disenrollment of the patient population and collaborated with data scientist team to incorporate related dynamic criteria.
• Analyzed and migrated data from the legacy system to a new application, building a data mart to translate large non-standard JSON data sets.
• Participated in the Epic double upgrade while rebuilding Epic crystal reports into SSRS.
• Extracted various data formats including XML and JSON and designed a SQL-based XML engine.

• Kept current with BI skills by analyzing data from job board extracted using custom ETL solution.
• Caregiver for ill parent.

Los Angeles, California, US

• Interpreted BI requirements for SOX compliance, revised department policy and procedures, verified team members completed procedures, and secure appropriate approvals prior to production release in collaboration with.
• Supported the day-to-day operations including reporting requests and ETL monitoring.
• Developed reporting solutions from the backlog and provided root-cause analysis for production ETL failures.
• Verified all PRD changes met SOX compliance and conducted quarterly BI security reviews.

Aliso Viejo, CA, US

• Built and maintained Jira DW and reporting solutions for CIO to monitor hours consumed across all shared services. Revisions included monthly changes to allocated hours negotiated by CIO and department heads affecting.
• Primary SSRS report developer for Carrington Home Solutions providing operational reporting solutions and dashboards to department heads and ETL support for DW.

Corona, California, US

• Developed applications using Microsoft Access/VBA, VB.NET and ASP.NET.
• Setup and maintained private network via MS Virtual Server.
• Designed reports and dashboards using Crystal Reports, SSRS and MS Access.
• Maintained test and production Windows Server instances supporting SQL Server, IIS, SFTP and Exchange.

• Developed applications and reports in Microsoft Access/VBA.
• Performed data analysis on Amtech Imaginera ERP system using SQL Server.
• Assisted network administrator PC repair and upgrades and other delegated tasks.

Certificate, Computer Information Science

Hardware/Networking