Juan C. Rivera
Data Engineer at Hope Media Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Spanish Native or bilingual proficiency
Topline Score
Bio
Credentials
-
Introduction to Python for Data Science
DataCampAug, 2017- Nov, 2024 -
Microsoft Certified Database Administrator
MicrosoftJun, 2004- Nov, 2024 -
Certified Scrum Developer
Scrum AllianceOct, 2016- Nov, 2024 -
Certified ScrumMaster
Scrum AllianceAug, 2015- Nov, 2024
Experience
-
Hope Media Group
-
United States
-
Entertainment Providers
-
100 - 200 Employee
-
Data Engineer
-
Apr 2023 - Present
- Main database developer for the CRM and Donations Software Enginnering team. - Main database developer for the CRM and Donations Software Enginnering team.
-
-
-
Woodforest National Bank
-
United States
-
Banking
-
700 & Above Employee
-
Data Programmer II
-
Nov 2018 - Nov 2022
- As part of the bank’s Commercial Loans Scrum team, handled several sources of data and databases to meet clients needs in a daily bases (04/2021 – 11/2022) - Main BI / Database Developer of a succesful data migration and conversion project that handles bank’s charged-off accounts (03/2019 – 03/2021) - Both roles required the creation, unit testing handling, troubleshooting and performance tuning of database objects (tables, views, indexes, stored procedures, user-defined functions), SSIS packages and jobs to deal with millions of OLTP/OLAP and other data sources, like flat files and Excel spreadsheets, in a daily basis - Beginner level of Power BI, Power Query and DAX metrics - Beginner level of Azure Data Lakes - Convert business requirements into easily read and documented technical code - On-demand reports generation Show less
-
-
-
Ascentis a UKG Company
-
United States
-
Software Development
-
1 - 100 Employee
-
Analytics & Reports Developer
-
Jul 2018 - Oct 2018
- Value added to Ascentis’s key clients by being part of a successful Scrum team that creates both static and adhoc state-of-the-art reports for its HR web-based interface- Data visualization dashboards creation through Jaspersoft Server (current project)- Assist team’s DBA on Data Warehouse implementation- Peer code reviewer
-
-
Analytics & Reports Developer
-
Feb 2018 - Jun 2018
- Value added to Ascentis’s key clients by being part of a successful Scrum team that creates both static and adhoc state-of-the-art reports for its HR web-based interface- On-demand Analytics visualization development with TIBCO Spotfire 7.0- Peer code reviewer
-
-
Senior Back-End Engineer
-
Sep 2017 - Feb 2018
- Helped assigned Scrum team for the Talent Management System (TMS), by improving database and back-end response time in some web pages by up to 63%.- Peer-to-peer code review- Unit test development and execution
-
-
-
Velocity Partners
-
United Kingdom
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Senior Database Developer
-
Jul 2012 - Aug 2017
My responsibilities and achievements included: - Added value to all CoStar Group’s clients by being part of a Scrum team that successfully added a state-of-the-art reporting tool to its Product Suite that provided geographic and demographic solid statistics, analytics and benchmarks for more accurate business decisions - Roles: Database Developer (stored procedures, complex queries, functions, views, triggers, scripting, tuning, unit testing), Data Warehouse Analyst, Business Rules Analyst, ETL Developer - Methodologies: Agile/Scrum and Lean/Kanban Client: Commercial and Residential Real Estate Analytics Show less
-
-
-
IT Systems Ltd
-
Ireland
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Senior Software Developer
-
Nov 2011 - Jul 2012
- Part of a development team that successfully developed and deployed Wire Transfers section of the bank’s main website. - Business requirements analyst and main coordinator between client and developers team. - Tools: Visual Studio 2010 (C#, HTML, Javascript, LinQ), MS SQL Server 2010 and TortoiseSVN Subversion 1.7.1 for version control Client: Banking, Investments - Part of a development team that successfully developed and deployed Wire Transfers section of the bank’s main website. - Business requirements analyst and main coordinator between client and developers team. - Tools: Visual Studio 2010 (C#, HTML, Javascript, LinQ), MS SQL Server 2010 and TortoiseSVN Subversion 1.7.1 for version control Client: Banking, Investments
-
-
-
MAPFRE
-
Spain
-
Insurance
-
700 & Above Employee
-
Web Applications Developer (Contractor)
-
Aug 2010 - Aug 2011
- Added value to key managers by developing from scratch several web-based applications - Tools: Visual Studio 2003/2005/2008 (C#, HTML, JavaScript), Oracle 9i/10g, Crystal Reports 9.2, MS SQL Server 2005 and Tortoise SVN Subversion 1.5.2 for version control Client: Insurance - Added value to key managers by developing from scratch several web-based applications - Tools: Visual Studio 2003/2005/2008 (C#, HTML, JavaScript), Oracle 9i/10g, Crystal Reports 9.2, MS SQL Server 2005 and Tortoise SVN Subversion 1.5.2 for version control Client: Insurance
-
-
-
MetroIT Resources
-
San Juan, Puerto Rico
-
Software Development Consultant
-
Jan 2008 - Aug 2010
- Added value to client by developing several web-based applications from scratch - Business requirements analysis - Tools: Visual Studio 2005/2008 (VB, C#, HTML), Crystal Reports 2008, SubSonic DLL v2.0 and MS SQL Server 2005, including initial database and application design. Client: Government (Housing) - Added value to client by developing several web-based applications from scratch - Business requirements analysis - Tools: Visual Studio 2005/2008 (VB, C#, HTML), Crystal Reports 2008, SubSonic DLL v2.0 and MS SQL Server 2005, including initial database and application design. Client: Government (Housing)
-
-
Education
-
University of Puerto Rico-Mayaguez
Bachelor's Degree, Computer Engineering -
BIOS Institute, Montevideo, Uruguay
Diploma, Investments Analyst -
BIOS Institute, Montevideo, Uruguay
Diploma, Banking Fundamentals
Community
