Frank Dobbs Email & Phone Number

San Diego, California, United States

San Diego, California, United States

Off-grid residential power storage solutions using repurposed EV traction batteries and solar inverters

Jacksonville, Florida, United States

• Instrumental in building a new process to automate 100% compliance with federal/state bank regulations• Scripting new SQL queries; creation and documentation of program logic using MS Excel, Visio, PowerPoint• Adapting to frequently changing work priorities; tracking projects for CEO; work with overseas Developers• Mapping out work flows; building out Data Dictionaries; writing training procedures; training new employees

San Diego, California, United States

• Single-handedly repaired and updated >100 SSRS reports and SQL for the entire Residential Loan division• Eliminated multi-year backlog of service requests; designed new workflow reports for upper management• Trained and guided a direct report; managed a project to migrate the department from SSRS to Tableau• Maintained and distributed monthly financial KPI and Salesforce compensation reports to management

San Diego, California, United States

• Quickly assumed duties of a genomic instrument data warehouse (ETL process) for a Developer on sick leave• Conducted a system-wide audit/gap analysis of active XML data streams using Excel VBA macros• Configured the extraction of new test data streams via t-SQL queries, views, and stored procedures

Carlsbad, Ca

• Generated creative new SQL scripts and SSRS reports to repair and update daily/weekly/monthly reports• Served as DBA for an entire division’s FDA auditable complaint database; updated and repaired SSRS reports• Automated repetitive Excel tasks using VBA macros; presented a proposal for migrating reports to Tableau• Improved risk management by using statistical analysis to provide actionable complaint trend detection • Developed new dashboards for management using multiple data streams (SSRS, Tableau, Minitab, Cognos)• Migrations of >50 reports from legacy databases (SSRS; MS Access) to SAP HANA Business Objects system

Temecula, Ca

• Mastered med device regulations (e.g. 21CFR 820; ISO9001; HIPAA) for Post Market Vigilance/Surveillance• Proposed and managed a project to create a new zero-cost MS Access database that resulted in: o Automation of the workflow of 100+ lot records per day for review by a team of eight Analysts o On demand metrics reporting for upper management (e.g. department status, throughput trending) o Savings of thousands of dollars each month by eliminating backlog and the need for Analyst overtime