Robert Valladares
Orlando,Florida
Summary
Experienced with designing and optimizing data pipelines to ensure seamless data flow. Utilizes advanced SQL skills to create and maintain robust data architectures. Track record of implementing scalable solutions that enhance data integrity and support informed decision-making.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Data Engineer, IT
University of Central Florida
Orlando, FL, USA
11.2022 - Current
- Develop Advance SQL ETL Processes
- Senior Power Bi Back and Front-End Developer for College of Graduate Studies IT
- Senior Microsoft SSRS Developer
Associate Data Engineer, Advance Analytics
Universal Orlando Resort
Orlando, FL, USA
11.2021 - 07.2022
- Automate data gathering utilizing Python, SQL and Batch scripting from external sources
- Simplify scripts from multiple languages such as Visual Basic, R, Python, Java, JavaScript to a single language, Python for the purpose of gathering and uploading data to Data Warehouse
- Refactoring SQL Stored Procedures to aid in maintenance, performance and scalability
- Working with multiple data sources and tools such as MicroStrategy, Snowflake, SQL Server, text files
Bus Intel & Analytics Specialist I, IT
University of Central Florida
Orlando, FL, USA
01.2017 - 11.2021
- Automated reports with SSRS Data-Driven Subscriptions and use of Stored Procedures resulting in 99% execution time reduction from previous approach
- Refactored Visual Basic and SQL codebase which led to a 77% reduction in the package size
- Reduced calls to remote server by 99%
- Developed Microsoft Power Bi reports and automated processes to deliver on demand
- My work consists of writing, maintaining, optimizing T-SQL stored procedures for the purpose of providing important data to users
- I work with our user base to collect requirements, design, deliver and automate their ideas into a functional self-serve report either in SSRS or Power Bi
- I work with data from Oracle Databases using PL/SQL and data from SQL Server with T-SQL to create scalable data models
Software Engineer
Harris Corporation
Melbourne, FL, USA
09.2016 - 12.2016
- Served as Software Integration Engineer for Harris’ National Air Space (NAS) Enterprise Messaging System (NEMS)
Data Mining & Reporting Specialist
Universal Studios
Orlando, FL, USA
08.2009 - 12.2013
- Implemented process automation to collect, analyze and present KPI reports to theme park management
- Automated contract date enforcement and purchase reservation completion, resulting in reduced financial penalties to the company and guests by identifying hotel reservation cancelations before payment deadline and delivering automated notices to business analysts
- Developed, deployed and supported customized SharePoint sites with SharePoint Designer
- Created and maintained custom reports with Avaya’s CMS Supervisor and IEX Workforce management
- Created a scalable and automated reporting process that served a staff of over two hundred members with software readily available such as SharePoint Services, MS Access, MS Excel, and SQL Server
Education
Bachelor of Science - Computer Science
University of Central Florida
Orlando, FL01.2016
Associate in Arts -
Valencia College
Orlando, FL01.2012
Skills
- ETL processes
- Database design
- Data visualization
- Reporting tools
- Performance tuning
- Business intelligence
- SQL programming
Certification
- LinkedIn Learning, Advanced SQL for Data Science: Time Series, Advanced SQL: Logical Query Processing, Advance SQL for Data Scientists, SQL: Data Reporting and Analysis, SQL Tips, Tricks, & Techniques, Advanced SQL for Query Tuning and Performance Optimization, Over Thirty (30) courses related to programming or data processing
- New Horizons Orlando, Analyzing Data with Power BI, Developing SQL Data Models, Data Mining SQL Server with T-SQL, Implementing and Maintaining MS SQL Server 2008 Reporting Services SSRS, Microsoft SharePoint Services 3.0, Microsoft SharePoint Designer 2013
Languages
Spanish
Native or Bilingual
English
Native or Bilingual
Timeline
Data Engineer, IT
University of Central Florida
11.2022 - Current
Associate Data Engineer, Advance Analytics
Universal Orlando Resort
11.2021 - 07.2022
Bus Intel & Analytics Specialist I, IT
University of Central Florida
01.2017 - 11.2021
Software Engineer
Harris Corporation
09.2016 - 12.2016
Data Mining & Reporting Specialist
Universal Studios
08.2009 - 12.2013
Bachelor of Science - Computer Science
University of Central Florida
Associate in Arts -
Valencia College