Ramon Gonzalez Email & Phone Number

Miami, Fl

▪ Develop data warehouse solutions across all business lines. Work/support with cross functional teams, data analysts, business analysts, and data scientists on SQL queries, indexing strategy, R programming and process automation.▪ Optimized/tune existing and developed new ETL pipelines from flat files, JSON, XML files retrieved from FTP servers, Web Request (HTTPS via C#), SharePoint, and Amazon S3 (R package aws.s3) as well as SQL and Oracle database.▪ Built self-managed sliding-window solutions using SQL partitioning to adhere to data retention policy as well as storage needs and optimize query performance.▪ Built reusable framework solutions to ingest multiple external data feeds for Decision Manager (C#/SSIS), Google Analytics (.NET/SSIS), and Salesforce - Exact Target. POC's included Facebook, Twitter, Amazon S3 extracts using R code. ▪ Built password management for automated processes by using SQL Server encryption in combination with C# code within SSIS package. ▪ Support data science Machine Learning models by building data pipelines for data analysis and implementation of batch and real-time solutions.▪ Support SSAS solutions which include development on data mart as well as SSAS cubes.▪ Built SQL solution to support Data Governance to obfuscate PII data which included dynamically altering SQL views.▪ Lead developer in support of Forecast and Fraud data projects. Extract data from several source systems, aggregate, assist in identifying variables and transforming data for forecast and fraud prediction models.▪ Provide resolution/feedback to production support team on index performance, bottlenecks and scaling issues. ▪ Provide technical documentation and training to production support team on solutions as well as optimization design.

Kendall, Fl

SQL developer working on multiple projects dealing with business intelligence solutions (SSIS,SSRS) as well as applications integration. ETL development and template design for data migration/conversion for new ERP implementation using SSIS and Pragmatic Works Task Factory. Furthermore, developer for ImageNow electronic filing and archiving application building scanning solutions which integrate with our legacy ERP system.

Support developers by completing SQL requests (account permissions, queries, and access to data). Build ETL processes using SSIS; Dynamic SSIS packages which extract from multiple sources, data cleansing, transformations and loading of data. Assist with scripts, SSIS projects, troubleshoot stored procedures and query optimization.

Maintained and manage Mobility Services telecommunications management system and personal calls management system (third party software application). Provided support to college users through mobility software (vendor specific software for wireless air cards, phonebook applications, and the like). Moreover, provided Blackberry support college wide for College VIP’s (Blackberry Enterprise Activations, Support, Troubleshooting and One-on-One tutorial sessions). Reviewed and analyzed college wide mobile devices usage which was later used for account and contract revisions by supervisor. Also, assisted in organizing mobile support for college special events, most notably the Miami International Film Festival and the Miami International BookFair.

Master'S Degree, Computer And Information Systems

Completed the MS CIS from Boston University with a Data Analytics concentration. Relevant course work includes Data Mining, Web Analytics.

Bachelor Of Business Administration (Bba), Management Information Systems, General, Cum Laude Honors Graduate

Courses taken include areas such as Business Intelligence, Database Development, and Management Support systems.

Associates In Arts Degree, Business Administration