David Osorno

IT Division Director @ Juan Fernandez-Barquin, Esq., Miami-Dade Clerk of the Court and Comptroller

About

ScrumMaster Certified MCTIP Database Administrator 2008 Certified MCTIP Database Developer 2008 Certified Macromedia Coldfusion MX Certified Network+ Certified Professional Linux+ Certified Professional

Country

United States

City

Miami

Industry

Government Administration

Skill

DTS, Stored Procedures, T-SQL, SSIS, Microsoft SQL Server, Database Triggers, HTML, ASP, SSRS, SQL Server Management Studio, MySQL, SQL Tuning, Analysis Services, C#, SQL, PostgreSQL, Database Admin, OLTP, XML, PHP

Experience

IT Division Director

Juan Fernandez-Barquin, Esq., Miami-Dade Clerk of the Court and Comptroller

2025-7 - Present · 1 yr 3 mos

Miami, Florida, United States

Assistant Division Director, Finance Department

Miami-Dade County

2023-4 - 2025-8 · 2 yrs 5 mos

Strategic Initiatives Manager

Miami-Dade County

2019-11 - 2025-8 · 5 yrs 10 mos

Business Management Systems Analyst

Miami-Dade County

2017-5 - 2019-11 · 2 yrs 7 mos

FINANCE - System Analyst / Programmer II

Miami-Dade County

2015-3 - 2017-5 · 2 yrs 3 mos

Miami/Fort Lauderdale Area

- Design, deploy and Maintain SSIS Packages for daily data transactions between departments. - Design, code, test and debug custom queries using Microsoft T-SQL and SQL Reporting Services. - Assist in mining data from the SQL database that was used in several significant presentations for various department heads. - Assist in offering support to other personnel who were required to access and analyze the SQL database. - Assist in creating and presenting informational reports for management based on SQL data. - Perform and conduct complex custom analytics as needed by clients and executive management. - Design and develop specific databases for collection, tracking and reporting of data. - Developing Intranet Dashboard to Track; Analyze Business Key Metrics.

Manager Information System (MIS)

NEXT Precision Marketing

2004-2 - 2014-9 · 10 yrs 8 mos

- Created and led deployment of Call Detail Record (CDR) data collection using Radius Farm servers (15 Blade Servers) under Linux. Program increased company revenue by 30% by correcting flaws in billing system, and increased billing capacity from 50 million to 400 million minutes per month. - Installed and configured six production database servers with Microsoft SQL 2005 and 2008. Perform on-going maintenance of database servers. - Led team of 3 people to install and configure reporting services and transactional replication in five external nodes using Microsoft SQL 2005 and 2008. - Design, deploy and maintain intranet tools that track and analyze business key metrics using Adobe Air (Flex 4) and ColdFusion (Version 8) with Microsoft SQL 2008. - Developed monitor application that Telnets to 5 Cisco’s ASR and execute specific commands to check Health Status, Calls, CPU, Memory, CPS (Calls Per Second) and create graphs based on 2 hours, 1 day, 1 month. Using Perl, RRD, PHP and Mysql. Application can be accessed from IOS (HTML5).

Software Developer

LATINODE, INC

1999-11 - 2004-2 · 4 yrs 4 mos

- Created company's first ever wholesale VOIP billing software (Nsite) using ColdFusion markup language and SQL 2000 as backend. - Developed, deployed and maintained Call Detail Record (CDR) data collection using Radius Farm server in Linux; and Intranet for NOC tools including system for trouble tickets, testing and routing forms. - Designed web portal interface to enable configuration of radius services using Apache, PHP and MySQL under Linux.