Sql Server Software Engineer

LUIS GARCIA-BLASQUEZ

Cell: 561-***-**** E-mail: ****.**************.*@*****.***

Address: ***** *********** ******, ****** *****, FL 33484

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

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.

Experience working with EDI forms in the Health Care industry.

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

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

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

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

SQL Commands DDL, DML, TLC and DCL

ETL: • SQL Server Integration Services (SSIS) Both, ETL and Data Warehouse

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

Microsoft: • MS Visual Studio 2019, 2017, 2015 • MS Office Suite 2021• MSMQ • Visual Source safe • Team Foundation

Excel macros and VBA programming, import/export SQL data

Other: • SAGE ERP 500, SBT Pro Series • ACCPAC Pro Series • JIRA, GIT

EXPERIENCE:

NORTH ROCK CAPITAL MANAGEMENT, LLC 10/23 – 02/24

Investment management firm built upon a global multi-PM investment platform.

Risk Developer (C# and SQL Programming)

Maintenance of the company applications using SQL 2019 using T-SQL.

Update the SSRS Report Stock Prices Analysis Report to include a data-driven subscription for analysts.

Creating .NET desktop applications using C# and T-SQL to update tables and views in SQL Databases.

NATIONS BENEFITS 07/22 – 03/23

Company that partner with health care organizations providing Supplemental healthcare benefits.

Sr. ETL/SQL Developer

Creating SQL 2019 functions and stored procedures to maintain database SQL information regarding health care from different health care organizations, using T-SQL

Maintaining & Creating SSIS (ETL) Projects using VS 2019 and SQL 2019 to modify and transfer data using FTP.

Processing claims and benefit balances using EDI formats 834 and 837.

CDK GLOBAL 03/19 – 07/22

ETL software developer for automotive, marine, agriculture and, construction companies

ETL/SQL Developer - Contract

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

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

Standardizing already created Stored Procedures, implementing exceptions handling using T-SQL.

Created SSIS Packages with scripts tasks in VB.NET using C# and VB.NET

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 SQL information using T-SQL.

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

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

Used SSIS packages (ETL) to transfer information from clients into our SQL database using T-SQL and scripts tasks in VB.NET using C# and VB.NET

Updated web applications using C# in .NET

CHROMALLOY GAS TURBINE LLC 08/17 – 06/18

Design, manufacture and repair gas turbine engines parts.

ETL/SQL Developer - 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 using T-SQL.

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

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

Advanced developments in weapon designs and accessories

SQL 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, VB.NET and SQL Server 2012, used EXCEL to show graphics.

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

Export SAGE 500 information to EXCEL spreadsheets to present graphics using VBA programming.

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 using T-SQL.

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

SQL Database Developer - 6 months’ contract

Maintained the company's trademark "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.

STUDIES:

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

Contact this candidate