Sql Server Engineer

Carlos Guilarte

**** * ***** ** **** Blvd Apt *, Coral Gables, FL 33134

Cell: 786-***-**** - e-mail: ***********@*****.***

https://www.linkedin.com/in/carlos-guilarte-02156487

Professional Summary

Systems Engineer with over 25 years of experience in all phases of the software development life cycle (SDLC) and a strong Object-Oriented Programming (OOP) background. Advanced knowledge of several programming languages including but not limited to Borland Delphi, C++, Visual FoxPro and C#. Hands-on experience working as a SQL Programmer. Exceptional ability to read, understand and write complex SQL queries and to utilize other SQL Artifacts. Sound knowledge of MS SQL DBA functionality: Building tables, views and sequences. Design, development and management of Microsoft SQL Server databases. Ability to develop and optimize Stored Procedures, Triggers and Functions using T-SQL. Hands-on experience in working with ETL tools for Data Conversion and Integration like SQL Server Integration Services (SSIS) to manage data from diverse sources including but not limited to MS Access, MS Excel, Visual FoxPro Tables, CSV and MS SQL Server. Extensive experience using databases reporting tools including Visual FoxPro Reports Designer, Crystal Reports and SSRS.

Skills & Expertise

Troubleshooting and debugging

Systems Analysis

Software Development

Relational Databases Design

Data Analysis and Integration

MS SQL Server 2000, 2005, 2008, 2012, 2016

T-SQL (Procedures, Triggers & Functions)

MySQL

Fishbowl Inventory Software

Intuit QuickBooks Enterprise

SSIS

SSRS

ETL Data Conversion

ETL Tools (Analysis, Design, Development)

SQL Jobs

Object Oriented Programming

.NET Framework (C#, ASP, ADO, VB)

Visual FoxPro 6.0, 9.0

Borland Delphi Pascal

Windows Server 2000, 2005, 2008, 2012, 2016

LAN Design and Management

Computer Hardware

POS Systems

CCTV Systems

VoIP Systems

Performance Tuning

Office 365

Microsoft Exchange

Azure

Reporting & Analysis

Crystal Reports

3D GIS and 3D Modeling

GIS systems and Applications

Digital Elevation Modeling

3D visualization

Digital Image Processing

Accounting and Finance

Spanish (Native proficiency)

English (Professional working proficiency)

Work History

Information Systems Manager at Chemco Corp

August 2017 – Present

• Managing the Domain Server, AD, DNS and DHCP services in Windows Server 2016 using Microsoft Azure.

• Managing and Configuring Exchange e-mail server using Office 365 and Microsoft Azure.

• Configuring and Maintaining Accounting system using QuickBooks Enterprise Solutions - Manufacturing and Wholesale 2018.

• Maintaining Inventory system using Fishbowl Inventory 2018 - Manufacturing and Warehouse Version.

• Evaluating requests and modifying existing or creating new programs, reports and databases using Visual FoxPro 9.0, FoxInCloud, Jaspersoft iReport, MySQL, MS SQL Server 2016, Excel 2016 and Access 2016.

• Solving implementation problems, planning, developing and testing new hardware and software.

• Developing networks and communications systems.

• Installing and configuring VoIP phones.

• Configuring CCTV systems (Security cameras, DVR, monitors, applications).

• Managing, administering and controlling the enterprise IT infrastructure including Switches, Firewalls, Wi-Fi Access Points and Wireless bridges.

Freelance Software Developer

September 2013 – August 2017

Evaluated users’ requests and modifying existing or creating new programs, reports and databases using Visual FoxPro 9.0, FoxInCloud, MS SQL Server 2016 and Crystal Reports.

Solved programming problems, planning, developing and testing new hardware and software.

Installed and configured POS systems for retail stores and restaurants.

Analyzed detailed business requirements.

Troubleshooted technical issues and identified modifications needed in existing applications to meet changing user requirements.

IT Solutions Developer at TechXmart LLC

July 2015 – April 2017

Developed networks and communications systems.

Installed and configured POS systems for retail stores and restaurants.

Installed and configured VoIP phones.

Installed and configured CCTV systems (Security cameras, DVR, monitors, applications).

Analyzed detailed business requirements.

Analyzed, reviewed and altered programs to increase operational efficiency and to adapt to new requirements using Visual FoxPro, MS SQL and Crystal Reports.

Principal Software Development Engineer at Habaguanex S.A.

October 1999 - September 2013

Developed from conception to completion several Windows applications for Inventory Control, Purchases, Retail Sales, Accounting, and Financial Analysis using C#, Visual FoxPro and MS SQL Server.

Designed, developed and implemented a POS application for a company with more than 300 locations (shops, restaurants, hotels and stores) using about 1500 POS.

Designed, developed and administered Microsoft SQL Server databases.

Wrote complex stored procedures, functions, and triggers using Transact-SQL.

Designed and deployed reports and queries packages using Crystal Reports and SSRS.

Provided support in all phases of SDLC and ensure to deliver high-quality products.

Gathered and analyzed business requirements from clients to create system specifications.

Provided trainings and mentor other Engineers when required.

Senior Software Development Engineer at Constructions Company

September 1990 - October 1999

Designed and programmed more than 300 modular applications.

Designed new application modules for Image Recognition and Image Processing.

Designed and programmed new applications for Digital Elevation Modeling (DEM) generation and Stereoscopic Visualization of Terrain (3D view).

Led and trained a team of 30 engineers (geologists, geographers and geophysicists) in Image Processing, DEM and using of Geographical Information Systems (GIS).

Wrote and implemented scripts to enhance user experience and integrated scripts using Computer Modular System and Borland Delphi architecture.

Understood and evaluated complex data models.

Software Engineer at Nickel Company

September 1988 - August 1990

Designed, developed and managed software projects for clients using Clipper.

Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.

Developed code fixes and enhancements for inclusion in future code releases and patches.

Installed and managed connectivity products such as printers and routers.

Analyzed problems relating to software installations and configurations.

Education

Online self-learning using Pluralsight and Kaplan training tools

C#.Net, MS SQL Server Tools (SSIS, SSRS, SSAS, SSMS). 2014 - 2016

New Horizons Computer Learning Center, Miami, FL

Some IT Certifications, Information Technology, 2014 – 2014

Activities and Societies:

* CompTIA A+ (220-801, 220-802)

* CompTIA Network+ (N10-005)

* Windows 7 (70-680)

* Windows Sever 2012 MCSA (70-410, 70-411, 70-412)

* Windows Sever 2012 MCSE (70-413, 70-414)

* CCNA (200-120)

Center of Overcoming and IT Training (CENSAI), Havana, Cuba

.Net Framework, Information Technology, 2004 – 2004

Grade: Microsoft Certification Application Developer

University City Jose A Echeverria (CUJAE), Havana, Cuba

Master's Degree, Applied Mathematics for Image Processing, 1995 – 1997

Top Technical Institute Jose A Echeverria (ISPJAE), Havana, Cuba

Bachelor's Degree, Systems Engineering, 1983 – 1988

Contact this candidate