Scroll To View More
Adolfo Socorro, T-SQL Developer in San Juan, Puerto Rico
Adolfo Socorro

T-SQL Developer in San Juan, Puerto Rico

Member since September 10, 2017
Adolfo is a data specialist who helps small and medium-sized businesses leverage their data assets through integration and reporting strategies using Microsoft Technologies.
Adolfo is now available for hire

Portfolio

Experience

  • Database Design, 20 years
  • Microsoft SQL Server, 15 years
  • T-SQL, 15 years
  • Data Integration, 15 years
  • SQL Server Integration Services (SSIS), 12 years
  • SQL Server Reporting Services (SSRS), 12 years
  • Database Administration (DBA), 5 years
  • Microsoft Power BI, 5 years
San Juan, Puerto Rico

Availability

Part-time

Preferred Environment

Windows, Visual Studio, SSMS

The most amazing...

...project I've worked on was a healthcare metrics system.

Employment

  • Principal Consultant

    2002 - PRESENT
    eSolutions, Inc.
    • Reduced the processing time of SQL Server stored procedures for monthly calculation of healthcare KPIs (HEDIS) by 90%.
    • 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.
    • Designed and developed an end-to-end analytics solution for healthcare data, from the loading of millions of records each month in a SQL Server database to the production of dashboards and reports in Power BI.
    • Created and lead a team of developers for the development of a web-based application to capture, validate, report, and exchange data on participants of a government workforce investment system.
    • Designed several support systems for a pharmaceutical plant using web technologies and SQL Server, including systems for tracking manufacturing effort, for tracking the movement of fixed assets, and for managing of action items.
    Technologies: SQL Server Engine, SQL Server Reporting Services, SQL Server Integration Server, SQL Server Analysis Services (Tabular), Power BI

Experience

  • SQL Server Query Optimization (Development)

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

  • Production Operations Efficiency Management System (Development)

    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.

  • SQL Server Training for Programmers (Development)

    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.

  • Dashbords and Report for Medical Sales Representatives (Development)

    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.

  • Medical Group Data Analysis and Benchmarking (Development)

    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.

  • WIA Application and Data Warehouse (Development)

    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.

  • Introduction to Power BI (Hands-On) (Development)

    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 from Crystal Reports to SQL Server Reporting Services (Development)

    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.

  • Louisiana Shelter-At-Home Power BI Dashboard (Development)

    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.

  • HMISLive! Application and Data Warehouse (Development)

    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.

  • Speakers Tracking System (Development)

    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.

  • Adherence to Medications - Data Analysis and Power BI Reports (Development)

    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.

Skills

  • Languages

    T-SQL, SQL, C#.NET, C#
  • Tools

    Microsoft Power BI
  • Paradigms

    Database Design
  • Storage

    Data Integration, SQL Server Reporting Services (SSRS), Microsoft SQL Server, SQL Server Integration Services (SSIS), Database Administration (DBA)
  • Other

    Data Modeling, Data Migration

Education

  • Ph.D. in Computer Science
    1989 - 1993
    University of Oxford - United Kingdom
  • Bachelor of Science and Master of Science degrees in Computer Science
    1983 - 1989
    University of Massachusetts at Amherst - United States
Certifications
  • DAT207x: Analyzing and Visualizing Data with Power BI
    JUNE 2018 - PRESENT
    EdX
  • Querying Microsoft SQL Server 2012
    JANUARY 2016 - PRESENT
    Microsoft
  • Implementing a Data Warehouse with Microsoft SQL Server 2012
    JANUARY 2016 - PRESENT
    Microsoft
I really like this profile
Share it with others