Dan Medina Email & Phone Number

Sarasota, Fl, Us

Sarasota, Fl, Us

✅ Dashboard development and Compliance reporting✅ Systems Automation: Invoicing and Statement Generation✅ Systems Integration: AD, SQL, and C# webapps with System of Record✅ Programming: C#, SQL, triggers, stored procedures, SSIS, SSRS, Perl, PHP, and command prompt.✅ Manage data flow and ETL (data processing)✅ Web Server administration, maintenance, and upgrades✅ Dialer Administration: Noble Systems, Livevox, and TCN✅ Data Conversions✅ Train Staff

Sarasota, Fl, Us

✅ Direct collection strategy, issue resolution, and operational focus.✅ Increase collections efficiency: Implemented dialer management technics. ✅ Created email buttons in the system of record to send templated account information and receipts.✅ Automated account treatment notes and agent authorization.

Sarasota, Fl, Us

✅ Customization of Latitude by Genesys✅ Created real-time KPI dashboard with usage statistics, company and individual goal tracking, and performance pacing, leading to company growth✅ Created database auditing routines for deleted records, allowing for the researching and restoring of mistakes, leading to a decrease in overall errors by 20%✅ Automation of reports and file processes using SSRS and SSIS

Sarasota, Florida, Us

✅ Setup Remote App framework and installed Latitude originally based on-site, converting operations 100% cloud base, creating a permanent disaster solution, increasing company recovery probability by 100%✅ Wrote programs for client interfaces allowing the ability to load new client accounts, read client data and send back payment data, increasing client communication efficiency by 75%

✅ Implemented database table partitioning for over 2B records, optimizing call center database and ensuring up time for call center consisting of 120+ representatives, leading to the elimination of deadlocks and increasing overall division productivity by 15% ✅ Implemented Autotask Ticketing System, ensuring 100% PCI and ISO 27001 compliance for change control✅ Latitude System Management (System of Record); create and maintain stored procedures, data interfaces, and process workflow archiving, partitioning, and user management, linking logic, and trained IT personnel ✅ Managed a team of 4 direct reports

✅ Built reporting system extracting data out of CLS collection master system and allowing for seamless and instant reporting, increasing transparency, streamlining reporting processes, and increasing efficiency by over 80%✅ Created ad hoc program to automatically fill small claims lawsuit pdfs by county court, allowing for automatic lawsuit filings, increasing productivity by over 200% (In one instance, was able to fill 242 county court pdfs within 1 minute) ✅ Using TIFF indexing, created perl scripts to manipulate and convert images and PDF documents, allowing optical character recognition of files to ensure accurate queries that instantly determined document types and whether or not required documents were present to proceed with lawsuit, eliminating manual processing of images and documents and improving productivity by 200%

✅ Developed and implemented new debt purchasing and agency network management system of record using Latitude and MS-SQL for new debt management start-up, allowing for the management and tracking of new accounts and increasing productivity by 75%✅ Automated, prepared, and dispensed various reports, including ad-hoc requests utilizing ancillary data and integrated data extracts using Talend Open Studio, leading to an 80% increase in efficiency✅ Designed, built, implemented, and maintained new Data Warehouse & Reporting Intranet Site in Spanish for the Latin American division using MySQL, Oracle, Apache, and Tomcat to service Accounting, Operations, and other departments

Omaha, Ne, Us

✅ Using open source software, created new data warehouse to manage, sort, and track data for 7M accounts distributed throughout 100 companies, allowing for automated BatchTrack Reporting, 100% transparency, a significant increase in productivity, and track account performance, leading to a 300% increase in revenue and over $1M in cost savings✅ Converted data warehouse and reporting site using open source software due to new system data layouts; reviewing, rewriting, and modifying 6,000+ lines of SQL scripts in 3 days ✅ Merged upwards of 40 spreadsheets into 1 automated report, leading to an increase in efficiency of 92%✅ Developed new proprietary website to replace Microsoft Access query tool designed to produce master Sale File, decreasing time to create file from 6 hours to 3 minutes✅ Built new Microsoft Access application for Quarterly Agency Management Review, for all 100 agencies, designed to collect data on agency performance and report back, allowing for an increase in transparency to both senior leaders and outsourced agencies