LUIS GARCIA-BLASQUEZ

Cell: 561-***-**** E-mail: adf0bg@r.postjobfree.com

LinkedIn: linkedin.com/in/luis-garcia-blasquez-96834134

SYSTEMS ANALYSIS/DESIGN/PROGRAMMING - DB PROGRAMMER

Systems Designer/Analyst, Computer Programmer and Database Professional, with extensive experience designing, developing and implementing information systems. Experienced developing solutions, conducting system overviews and operational tests, analyzing and identifying defects and software conflicts. Proficiency in SQL databases migration, programming and design.

SUMMARY OF QUALIFICATIONS

Experienced with database design concepts, data organization and storage.

Experience with ETL solutions, worked with DTS, SSIS and SSRS

Received training in OLAP and Data Mining

Strong problem-solving skills, as well as organizational ability.

Excellent communication and interpersonal skills; Fluent English – Spanish.

Demonstrated ability to quickly learn and grasp new concepts, create innovative solutions.

Capable of working independently or as part of a team effort.

SKILLS: Operating Systems: Windows Server 2003 • 2008 R2, Windows XP, Windows 7, DOS

Languages: • VB.NET • VB6 • MS ACCESS • VBA • XML • HTML • T-SQL

DBMS: • SQL Server 2005/2016 • Stored Procedures • Views • Functions • Triggers

• SQL Server Agent Jobs • SQL Management Studio • ADO.Net • ODBC

ETL: • SQL Server Integration System (SSIS)

Reporting: • Crystal Reports XI • SQL Reporting Services (SSRS)

Microsoft: • Microsoft Office Suite • MSMQ • Visual Source safe • Team Foundation

Other: • SAGE ERP 500, SBT Pro Series • ACCPAC Pro Series • JIRA (Zoom)

EXPERIENCE:

CDK GLOBAL 03/19-Present

Sales and CRM software developer for automotive, marine, agriculture and, construction companies

ETL Developer- Contract

Maintaining & Creating SSIS (ETL) Projects using VS 2017 and SQL 2016 to import especially from XML files and reporting through EXCEL.

Creating SQL 2016 views and stored procedures consumed by SSIS packages.

Standardizing already created Stored Procedures, implementing exceptions handling.

CONVEY HEALTH SOLUTIONS 07/18-01/19

Government Sponsored Health Plans Services for Health Insurance Companies

SQL Developer- 6 Months contract

Created SQL 2016 views, functions, triggers and stored procedures to maintain database SQL information.

Maintained customers' applications using MS Visual Studio 2015 and C# programming language.

Created SQL 2016 views, functions, triggers and stored procedures for new projects.

Used SSIS applications (ETL) to transfer information from clients into our SQL database.

CHROMALLOY GAS TURBINE LLC 08/17 – 06/18

Design, manufacture and repair gas turbine engines parts.

Data Warehouse Developer- 10 Months contract

Created SSIS packages (ETL) using VS 2015 transferring and modifying information from different sources (Sql, Oracle, DB2, Access, Flat files and FoxPro) into a data warehouse in SQL Server 2016.

Enhanced SSIS packages design grouping functionality in different packages called by the Execute package task.

Created SSRS reports from data warehouse for management.

Used EXCEL macros and VBA to present detail information about tables and structures using functions and pivot tables.

L. GARCIA-BLASQUEZ - PAGE 2

EXPERIENCE: (CONTINUED)

KNIGHTS ENTERPRISES MANAGEMENT, LLC 10/15–07/17

Advanced developments in weapon designs and accessories

Database Developer

Customized the company's SAGE 500 ERP system using the built-in customization technology.

Created SQL 2012 views and stored procedures to complement the SAGE 500 ERP system's customization.

Developed .NET desktop applications using VS 2010 and SQL Server 2012, linked to EXCEL to present graphics.

Designed the Sales Traveler .Net desktop application to control all aspects of Sales Orders processing from gathering finished items, government authorizations, invoicing, packing and shipping.

NIGHTINGALE NURSES 10/12 – 07/15

Traveler Nurses Staffing Company – Boca Raton, FL

Applications Developer- Database Programmer

Maintained the Company main application using Microsoft Access 2010 using VBA forms and Macros.

Created/modified SQL 2008 Stored Procedures, Views, Functions and Triggers, called by the Access application.

Created SSRS reports distributed through for a wide range of users via SSRS Data Driven Subscriptions.

Build SQL Agent Jobs to schedule distribution of SSRS reports.

EDGEMED HEALTHCARE SOLUTIONS, INC. 03/12 – 09/12

Practice Management Software & Medical Billing Services – Boca Raton, FL

Database Developer- 6 months’ contract

Maintained the company's trade mark "Innovation" System using FoxPro 5.0

Fixed corrupted FoxPro databases, create new indexes and rebuilt entire databases.

Migrated the Company's Innovation system from Visual FoxPro databases to SQL Server using SSIS applications.

Created SQL Stored Procedures, Functions and Views to support FoxPro functionality.

TECHNOLOGICAL UNIVERSITY OF AMERICA 11/09 – 03/12

University – Coconut Creek, FL

Systems Analyst/Programmer

Supervised the design of the University website and all server side applications & SQL Information.

Developed the library control system using VB.NET using VS2010 and SQL 2008. Graphics were presented in linked EXCEL sessions and extensive use of macros.

Supported marketing campaigns to increase student census with data handling and reports.

Created a data warehouse through SSIS applications to import student population/careers information from different regions in the US. Used SSRS to create reports.

GLOBAL TV CONCEPTS, LTD. 11/08– 11/09

Design, Manufacturing and Distribution of Consumer Products – Deerfield Beach, FL

Systems Analyst Consultant – 12 months’ contract

Performed system analysis to provide complete diagrams of the information flow of the company.

Research vendors to find an effective EAI for the company to integrate accounting, CRM and EDI applications.

Perform cost-benefit and ROI analyses for proposed systems, to aid management in decision making.

Supervised the migration of the company Peach Tree accounting system to Microsoft GP and Dynamics CRM.

FLEET LEASE DISPOSAL, INC. 08/99 – 11/08

Used Vehicles Remarketing – Delray Beach, FL

Senior Systems Analyst/Programmer

Maintained the company's main application using FoxPro 5.0, and SQL Server 2000.

Migrated of the Company's FoxPro code to VB.NET application and the FoxPro databases to SQL Server 2005.

Linked the main .NET application to SBT Accounting system via MSMQ using Web and Windows services.

Created ETL applications using DTS and SSIS (ETL) with VS2005 and SQL Server 2005/2008.

Created SSRS reports with VS2005 and SQL Server 2008.

STUDIES:

PERUVIAN AIR FORCE

Ranks: Second Lieutenant / Lieutenant

Peruvian Air Force Academy: Bachelor of Science, Major: Statistics and Computer Science.

Developed information systems solutions for the Air Force’s Supply Chain and Aircraft Maintenance using COBOL programming language and FORTE and INFOS database management systems.

Contact this candidate