Alfredo García Díaz

**** ** *** **, *****, Fl****5 C: 786-***-**** ac8a80@r.postjobfree.com

PROFESSIONAL SUMMARY

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

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

* ***** ****

* ***** *SIS

2 Years SSAS

2 Year in Database Administration

4 Years IT Support

2 Years Networking

4 Years Troubleshooting

CERTIFICATIONS

Microsoft Certified Solutions Associate in SQL Server

70-461 Querying Microsoft SQL Server

70-462 Administering Microsoft SQL Server

70-463 Implementing a Data Warehouse with Microsoft SQL Server

Certification Number: G204-8363

Microsoft Certified Solutions Expert in Data Management and Analytics

70-466 Implementing Data Models and Reports with Microsoft SQL Server

Certification Number: G819-7904

Microsoft Certified Professional

Certification Number: G069-0031

EDUCATION

Computer Science Engineer

University of Camaguey- Cuba

2006 to 2011

Application Architect Program in Information Technology Program

The Academy - Miami, FL

February 2017 – December 2018

Computer Systems & Info Technology/CISCO, CCNA & CCNP Certificates

Miami Lakes Educational Center

January 8 -Currently

SKILLS

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

Create database objects

SQL Server Management Studio

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

Business Intelligence

Cloud

DAX Queries

Data Analytics

Data Management

Data Modeling

Database Design

MDX Queries

SSRS

Tabular Data Model

Microsoft Office

Printer Solutions

Active Directory

Cabling, Routers, Hubs

Network Configuration

IT Troubleshooting

LAN Connectivity

Hardware Configurations & Software Install

WORK HISTORY

Database Developer, 09/2015 to Present (Remote)

Softmas -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

Field Technician 02/2018 to Current

AT&T- Miami, FL

Install central Fiber Optic Splitter Terminal Box (FAT).

Install PoE to each customer premises.

Running Invisible Light in each customer premises

Crimp the fibers Connectors (SC) in the Optical Network Terminal (ONT) equipment room.

Install and maintains complimentary hardware for wire plan being installed and runs appropriate cross-connects to complete the system installation.

Splicing fiber and Ribbons into the Fiber Optic Splitter Terminal Box (FAT)

Label each microduct/fiber in the equipment room and central wiring panel.

IT Support & Report Developer 01/2017 to 01/2018

Restore Digital Solution - Miami, FL

Reporting Services for Business Solutions and IT Processes.

IT Install and Network Configuration

Troubleshooting

Solve printer issues

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 last 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.

Contact this candidate