Sign in

Developer Sql Server

Miami, Florida, United States
January 09, 2018

Contact this candidate

Alfredo García Díaz

**** ** *** **, *****, Fl****5 C: 786-***-****


* ***** ** ********* *** Server

* ***** *** ***********

* ***** ****

* ***** *SIS

2 Years SSAS

1 Year in Database Administration


MCSA: SQL Server 2012/2014 - Certified 2017

70-461 Querying Microsoft SQL Server 2012/2014

70-462 Administering Microsoft SQL Server 2012/2014

70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Certification Number: G204-8363

Certification Number: G069-0031


Enterprise technologies: SQL 2005, 2008, 2008 R2, SQL 2012, 2014

Create database objects

Work with data

Modify data

Troubleshoot and optimize

Visual Studio,

Integration Service

SQL Server Management Studio

Master Data Quality

Master Data Service

Tech Experience: T-SQL,,SSIS, SSRS, SSAS.

Programming Languages: Transact-SQL.

Excellent problema and solving abilities

Data Extraction

Data Transformation

Data Warehouse Design

Deploy SSIS Solutions

Master Data Services

Microsoft Office: Excel, Access

System backups

System upgrades

Data backup and retrieval

Excellent communication skill

Install and configure

Maintain instances and databases

Optimize and troubleshoot

Manage data

Implement security

Implement high availability


Report Developer 01/2017 to Current

Restore Digital Solution - Miami, FL

Reporting Services for Business Solutions and IT Processes.

Support the reporting needs of the business by defining, developing, configuring and supporting reporting and analytics applications for internal and external usage

Evaluate user requirements and identify the best source and delivery of the information requested by business users

Database Developer, 09/2015 to 08/2016

DLL Group - Oaxaca- Mexico

Conduct Performance Tuning

Managed all changes to the data models

Deployed changes to database

Worked with project and application teams

Ensured they comply with data quality standards, architectural guidelines and designs

Creation of Tables Relationships, Stored Procedures CRUD: Create, Read, Update and Delete. Including Log Tables.

Administrative Management Features of Users and Improved Query Performance

Business Intelligence Processes.

Analyze Business Requirements and translate into SSIS packages

Report Designer & Developer, 06/ 2013 to 08/2015

Wholesaler of Tourism ITH Camaguey-Cuba

Created reports for Sales Dept.

Conduct trial runs to produce desired information

Test database, correct errors and make necessary modifications

Designed Data Models

Gathered business requirements § Created Relational/Transactional Databases

Created Data Marts

Developed, tested and version controlled physical database changes

Designed Multi-Dimensional Cubes

Created Reports from Cubes

Queried Cubes using SSAS

Create and publish reports to Excel

Desktop Support & Back-up SQL Admin, 09/ 2011 to 06/2013

Provincial Health Directorate Camaguey- Cuba

Diagnose, troubleshoot, and resolve hardware, software, or other network and system problems, and replace defective components when necessary.

Research new technologies by attending seminars, reading trade articles, or taking classes, and implement or recommend the implementation of new technologies. Configure, monitor, and maintain virus protection software.

Plan, coordinate, and implement network security measures to protect data, software, and hardware.

Design, configure, and test computer hardware, networking software and operating system software.

Worked closely with SQL Server 2000 Administrator (2003 to 2005)

Maintained the health, performance and integrity of the database systems

Responsible for database alerts, maintenance plans and scripts

Responsible for back-ups

SQL Developer Experience

Database Developer: I worked for a year in a development in Software in Mexico as Database Developer, my main functions were the modeling of the entire database, including creation of tables and their relations, restrictions, default values, all CRUDs, triggers, Functions, views present in the Database Layer (where the entire business rules environment applies).

Report Developer: In my current job, I do the sales reports rentals and accounts receivable once or twice a week. I generated my reports in Reporting Services and I visualized it in Excel, in Cuba I worked two years with Report Developer doing the reports for the Sales department published my reports with the Report Manager for the whole department, I always store and work my dataset with stored procedures with Parameters, with cascading parameters.

BI Developer: When working in Cuba, he is part of a team of all MINTUR companies to develop a BI Project to support decision-making for all directors of the province. My responsibility was the design and implementation of the dimensions and their implementation in a Cube, Analysis Services / OLAP Server.

Before coming to the United States I was working on a BI project for a food company, implement the Data warehouse using SSRS.


Application Architect Program in Information Technology Program

The Academy - Miami, FL

February 2017 – Present

Foreign Informatics Engineer

University of Camaguey

2006 to 2011

Contact this candidate