Adolfo Socorro

Reducedby 90% the processing time of SQL Server stored procedures for monthly calculation of healthcare KPIs (HEDIS).

This application allows for the detailed tracking of manufacturing events and labor, and calculates performance measures related to operational efficiency and direct labor utilization. Events and labor are recorded through a stylish drag-and-drop interface.

Best practices training for developing high-performing queries in SQL Server. Topics ranged from hardware and database server configuration to database design and the correct use of T-SQL.

Developed data models, dashboards, and reports for sales representatives in SQL Server and Power BI, integrating data from several sources and automating lengthy processes that were previously done manually.

This project implements a series of healthcare intelligence measures for comparing and rating medical groups that provide services to the participants of the Government of Puerto Rico's health plan. The technical solution employs SSIS for loading a monthly batch of millions of claims records into a data warehouse, provides various SSAS tabular models, and uses Microsoft's Power BI tools to publish and visualize this data in browsers and mobile devices.

Web-based, case-management system for clients of the federal Workforce Information Act and the Wagner-Peyser Act. It complies with federal data-gathering requirements for the WIA, Wagner-Peyser, and TAA programs, and includes a sophisticated performance analysis subsystem. It serves users in all 78 municipalities of Puerto Rico. In addition, a SQL Server data warehouse allows end-users and IT professionals to query data with self-service business intelligence reporting tools.

A hands-on training for new users of Power BI. We covered data loading techniques using M, the configuration of visuals, the development and publication of reports, and the creation of dashboards.

Conversion of a set of more than 20 reports in Crystal Reports to SQL Server Reporting Services, for a Caribbean utility company. The reports operate against a Microsoft Dynamics database.

Design and development of a Power BI report and dashboard to give real-time, end-to-end status of house rebuilding assistance to flood victims. Included requirements gathering, database analysis, and development of calculated status states using SQL Server queries.

A homeless management information system (HMIS) that complies with the latest Technical and Data Standards of the Federal Department of Housing and Urban Development. It is designed to record and store longitudinal client-level information on the characteristics and service needs of homeless persons throughout a community. It includes all the required HUD reports and modules for case management, system administration, security, and custom reporting. In addition, a SQL Server data warehouse allows end-users and IT professionals to query data with self-service business intelligence reporting tools.

Award-winning web-based system for planning and tracking educational and promotional activities. It automates several processes and has allowed for better compliance with government and corporate policies. The system includes functionality to automatically notify users when business-critical events occur. It was selected among the top three worldwide projects of 2005 for the company.

Using an algorithm to estimate the intake and availability of medication based on medical claims, an adherence percentage was estimated for people with certain types of chronic conditions. Data visualizations in Power BI were developed to present the results of the study.