Juan C. Rivera

About Juan C. Rivera

Experienced Database Developer and Analyst in different industries like banking, human capital management, investment, hospitality, government, health, real estates, manufacturing, bar-coding, law, among others; mostly as a Database Developer, Data Warehouse Analyst and DBA. Passionate about building and troubleshooting complex queries, stored procedures, as well as BI and metadata scripts.Proven experience of more than twenty (20) years in Microsoft SQL Server (SSMS) and T-SQL for stored procedures, scripting and algorithms. More than ten (10) years of experience dealing with ETL and SSIS, Analytics, Statistics, advanced Excel skills (Power Pivot), and Reporting (both SSRS and Crystal Reports).Eleven (11) years of experience in Agile Methodologies, like Scrum and (some) Kan-Ban. Currently certified by Scrum Alliance as a ScrumMaster (CSM, 8/2015) and Scrum Developer (CSD, 10/2016).

Experience

1. Data Engineer

   Hope Media Group

   Apr 2023 — Present · Humble, TX, US

   Main MySQL DB developer for the CRM and Donations Software Enginnering team (until 03/24)- CDP main data handler and Redshift Posgresql developer for the Data Science team (present)- Power BI developer (present).

Education

• BIOS Institute, Montevideo, Uruguay

  Diploma, Banking Fundamentals

• BIOS Institute, Montevideo, Uruguay

  Diploma, Investments Analyst

• University of Puerto Rico-Mayaguez

  Bachelor's Degree, Computer Engineering

Skills

• Software Development
• Scrum
• Visual C#
• User Defined Functions
• Visual Basic
• Cursors
• Sql
• Asp.net
• Databases
• Web Applications
• Stored Procedures
• Visual Studio
• Business Intelligence Development
• Javascript
• Html
• Data Warehousing
• Mysql
• Microsoft Sql Server
• Table Design
• C#
• .net
• Agile Methodologies