Developer Data
Resume:
Alfredo García Díaz
**** ** *** **, *****, Fl****5 C: 786-***-**** *******.*********@*****.***
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