CARLOS GONZALEZ

OBJECTIVE

Looking for a challenging position in the Business Intelligence and Analytics field, which allows professional development and a chance to make an important contribution to the company.

SUMMARY

Extensive experience with Microsoft SQL Server 2008/2012/2014, Management Studio (SSMS), Visual Studio, and business Intelligence tools (SSIS, SSRS, SSAS)

ETL development (extract, transform, and load) with Microsoft SQL Server Integration Services (SSIS) 2008/2012/2014, importing and exporting data between homogeneous and heterogeneous systems using various ETL methods.

ETL administration with SQL Server including multiple server environment (development-QA-production), deployment models, job scheduling using the job agent, and job troubleshooting.

Report creation using SQL Server Reporting Services and Excel using Pivot tables.

OLTP and OLAP environments with SQL server 2008, 2012, and 2014.

Implementation of business crucial logic into back-end using efficient SQL Server views, stored procedures, triggers, and functions.

Data modeling based on functional requirements, including OLTP modeling and dimensional modeling for Data Warehouse and OLAP applications.

Proficient using analytics and visualization tools such as IBM's Watsons Analytics, Tableau, and Microsoft Power BI.

Technical support to technical and non-technical users.

Development of database solutions with MS-Access 2007, 2010, and 2013 including macros, queries, reports, and programming in Visual Basic for Applications (VBA).

Proficient creating spreadsheets using Excel 2010/2013, including use of external data sources, vlookups, hlookups, PIVOT tables, complex formulas, graphs, and macros.

Additional expertise in the areas of business analysis, project management, technical documentation, training, testing, system design, conversion, installation, and implementation.

Experience with software versioning and utilities for SQL Server such as Dynamsoft's SourceAnywhere, Red Gate's SQL Source Control, and IDERA's SQL Diagnostic Manager.

Development experience using the software development life cycle (SDLC - Waterfall), also, in agile development environments including the Scrum methodology.

Medium level using Python and R for analytics applications.

PROFESSIONAL EXPERIENCE

Naturipe Farms, Estero, FL May. 2016-Present

Applications Developer

Development and support of data-driven and Business Intelligence applications using SQL Server 2008 R2/2014, stored procedures, integration services (SSIS), reporting services (SSRS).

Design, development, and troubleshooting of ETL packages and jobs using SQL Server, SQL Server Integration Services (SSIS),Visual Studio, and VB..

Creation of reports and dashboards using Power BI.

Administration and support of Business Intelligence application DIVER.

Creation of user's manuals and technical documentation of existing and new developments.

Improvements to existing processes.

PricewaterhouseCoopers, Tampa, FL Feb. 2016-May 2016

Data Modeler

Re-platform of several processes and reports in Microsoft Access and Excel to SQL Server 2012 using SSIS, SSRS, and QlikView.

Verizon, Lake Mary, FL Jul. 2014 – Feb. 2016

Business Intelligence Developer / Development DBA

Part of the team in charge of the Data Warehouse of the Reporting & Analytics department of Verizon's finance organization.

Design, development, and maintenance of ETL packages and jobs, data cubes, and reports using SQL Server 2008 R2/2012, MS-BI data tools (SSIS, SSRS, SSAS), SSMS, BIDS, Visual Studio, Tableau, Excel, and VB.

Identification and reconciliation of data and data sources within the organization and external vendors from different back-end systems in SQL Server, Oracle, Teradata (EDW), Excel, and flat files.

Support to senior analysts in the creation of reports.

The Newport Group, St. Petersburg, FL Dec. 2013 – Jun. 2014

Databse Developer

Upgrade and migration of two mission critical systems: trading and cash-recon applications in Microsoft Access.

Database migrated to a more robust RDBMS (SQL Server 2012) to improve reliability.

Includes the redesign and improvements of front-end user interfaces, recoding of VBA programs to change row-based processing (procedural approach) to a Query-Based or Set-Based approach.

Some business processes were changed and moved to the server using Stored Procedures for performance reasons. Other enhancements.

Syngenta Flowers, Alva, FL - USA Mar. 2012 – Dec. 2013

Business Analyst / Database Developer

Design, development, and support of database applications using MS-Access, MS-Excel, and Visual Basic.

Implementation and support of the ERP system FMS (agriculture and farm-management software), including integration with existing tools developed in Excel and Access.

Design and development of Data Warehouse using SQL Server 2008, and Microsoft BI Tools, including database design, ETL processes using SSIS, and reports using SSRS.

Development of real time querying application using DL-Skorpio handheld scanners, Windows SB Server 2011, VPN, Hotspots, and MCL-Collection.

SQL Server DBA: DDL, DML, views, functions, stored procedures.

Fort Myers, FL - USA Jul. 2009 – Feb. 2012

Independent Web Developer

Development of websites and portals using HTML, XHTML, CSS, JavaScript, and the CMS Joomla 1.5, 1.6, and 1.7, PHP, MySQL, cPanel, FTP, Photoshop, Dreamweaver, Filezilla, Google Maps and Google Analytics, several plug-ins, components, extensions, commercial templates, template creators, menus, video encoding, media players, YouTube and Vimeo API.

Performance Software Systems. Fort Myers, FL - USA May 2001 – Mar. 2009

Programmer

Development, maintenance, and support of car leasing systems Winlease and Leasecan using Xbase++, eXpress++, Clipper, and dBase.

Development of CRM system and other internal use software. Support to internal users and customers.

CHS Latin America, Miami, Florida - USA May 1998 – Nov. 2000

IS Administrator - Project Manager

CHS Venezuela, Caracas - Venezuela Nov. 1992 – Apr. 1998

Operations and IT Manager

CHS Madrid, Madrid - Spain

Operations and Sales Manager Jan. 1988 – Oct. 1992

Education

Bachelor of Science in Information Technology (Graduated with honors) Aug. 2012

Concentration in Database Administration

University of Phoenix, Phoenix - Arizona

A.S. in Computer Science (Técnico Superior en Computación) May 1985

Instituto Universitario “Nueva Esparta” Caracas - Venezuela

Master of Science in Data Analytics degree candidate

University of Maryland University College, Adelphi - Maryland

Courses and Certifications

Big Data University - Watson Analytics Oct 2016

Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics ID F814-2773 Sep 2016

Microsoft Certified Solutions Expert (MCSE): Business Intelligence ID F759-8249 Jul 2016

Microsoft Certified Solutions Associate (MCSA): SQL Server 2012/2014 ID F369-9611Jul 2015

Microsoft Certified Professional (MCPS) ID F342-8354 Jun 2015

Languages

Spanish and English

Contact this candidate