Experienced Systems Engineer & IT Manager with SQL/ETL Expertise
Resume:
CARLOS GUILARTE
Contact
Information
Address
***** ** ***** ***, *****, FL 33032
Cell
***********@*****.***
https://www.linkedin.com/in/carlos-guilarte-02156487
PROFESSIONAL SUMMARY
Highly versatile Systems Engineer and IT Manager with over 30 years of experience, bridging deep software development expertise with enterprise IT infrastructure management. Proven ability to lead the entire Software Development Life Cycle (SDLC) using Object-Oriented Programming (OOP) and advanced languages including C#, Borland Delphi, and C++. Expert in designing, optimizing, and managing complex Microsoft SQL Server databases (2000-2019), developing Stored Procedures, Triggers, and Functions using T-SQL, and managing critical data integration via ETL tools like SSIS. Successfully manage enterprise IT infrastructure (Azure, Windows Server, LAN) while also possessing practical experience in financial control leveraging QuickBooks and Fishbowl systems. Currently expanding capabilities in Business Intelligence by preparing for Microsoft PL-300 (Power BI Data Analyst Associate) certification to optimize financial and operational decision-making. Currently transforming traditional accounting into strategic forecasting tools by preparing for PL-300 and DP-203 certifications. My approach combines the power of SQL Server with advanced visualization in Power BI.
SKILLS & EXPERTISE
Category
Expertise
Data Analytics & BI
Microsoft Power BI (Candidate PL-300), SSRS, Crystal Reports, Financial Data Analysis, and Business Metrics.
Database Management
MS SQL Server (2000-2022), Advanced T-SQL (Procedures, Triggers, Functions), Relational Database Design, Performance Optimization.
Cloud & Infrastructure
Azure Administration (AZ-104 Focus), Windows Server (2000-2019), Microsoft 365, Hybrid Network Management.
Data Integration (ETL)
SSIS, Data Migration, ETL Data Conversion, SQL Jobs, and Automation.
Software Development & Programming
C# / .NET Framework (ASP, ADO, VB), Borland Delphi Pascal, Visual FoxPro (6.0, 9.0), Object Oriented Programming (OOP), Systems Analysis, Software Development, Troubleshooting and Debugging
Infrastructure & IT Systems
Windows Server (2000-2025), Azure, Office 365, Microsoft Exchange, LAN Design and Management, VoIP Systems, CCTV Systems, Computer Hardware, Performance Tuning
Business Applications & Accounting
QuickBooks Enterprise Desktop, QuickBooks Online, Fishbowl Inventory Software, POS Systems, Accounting and Finance
Specialized Skills
3D GIS and 3D Modeling, GIS systems and Applications, Digital Elevation Modeling, 3D visualization, Digital Image Processing
WORK HISTORY
Senior Financial Accountant at Chemco Corp
September 2022 – Present
Managing all core accounting operations including Invoicing, A/R, A/P, Cost Accounting, and Revenue Recognition.
Preparing and publishing timely monthly, quarterly, and yearly financial statements, including Balance Sheets and Profit and Loss reports.
Streamlining the daily and monthly bank reconciliation process.
Ensuring quality control over financial transactions and financial reporting.
Maintaining and strengthening internal controls by documenting business processes and accounting policies.
Managing and ensuring compliance with local, state, and federal government reporting requirements and tax filings.
Information Systems Manager (Concurrent Role) at Chemco Corp
August 2017 – Present
Managing the core network services (Domain Server, AD, DNS, and DHCP) on Windows Server 2019 utilizing Microsoft Azure for cloud integration and management.
Configuring and maintaining the Exchange e-mail server using Office 365 and Microsoft Azure.
Administering and controlling the enterprise IT infrastructure, including Switches, Firewalls, Wi-Fi Access Points, and Wireless bridges.
Overseeing critical business applications, configuring and maintaining the Accounting system (QuickBooks Enterprise/Online) and the Inventory system (Fishbowl Inventory).
Spearheading the development and modification of new programs, reports, and databases using tools like MS SQL Server 2019, Power BI, Crystal Reports, and MySQL.
Installing and configuring specialized systems including VoIP phones and CCTV security systems.
Implementing advanced data models and visualizations in Power BI (in line with PL-300 certification standards) to automate financial statement reporting and inventory control.
IT Solutions Developer at TechXmart LLC
July 2015 – April 2017
Installed and configured POS systems for retail stores and restaurants.
Analyzed, reviewed, and altered programs to increase operational efficiency and adapt to new requirements using Visual FoxPro, MS SQL, and Crystal Reports.
Installed and configured VoIP phones and CCTV systems.
Developed networks and communications systems.
Freelance Software Developer (Concurrent Role)
September 2013 – August 2017
Evaluated users’ requests and modified existing or created new programs, reports, and databases using Visual FoxPro 9.0, FoxInCloud, MS SQL Server 2016, and Crystal Reports.
Troubleshooted technical issues and identified modifications needed in existing applications to meet changing user requirements.
Installed and configured POS systems for retail stores and restaurants.
Principal Software Development Engineer at Habaguanex S.A.
October 1999 - September 2013
Led the full SDLC for multiple Windows enterprise applications covering Inventory Control, Purchases, Retail Sales, Accounting, and Financial Analysis using C#, Visual FoxPro, and MS SQL Server.
Designed, developed, and successfully implemented a mission-critical POS application for a company network that spanned over 300 locations and utilized approximately 1,500 POS terminals.
Designed, developed, and administered complex Microsoft SQL Server databases.
Authored and optimized complex stored procedures, functions, and triggers using Transact-SQL (T-SQL).
Developed and deployed comprehensive reporting and queries packages using SSRS (SQL Server Reporting Services).
Gathered and analyzed business requirements from clients to create system specifications.
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 in Image Processing, DEM, and using Geographical Information Systems (GIS).
Software Engineer at The Nickel Company
September 1988 - August 1990
Designed, developed, and managed software projects for clients using Clipper.
Developed code fixes and enhancements for inclusion in future code releases and patches.
EDUCATION
Technical University of Havana (ISPJAE), Havana, Cuba
Bachelor's Degree in Systems Engineering Graduated: 1988
Center of Studies and Research of Systems (CEIS), Havana, Cuba
Master's Degree in Applied Mathematics for Image Processing Graduated: 1997
Continuous Education and Self-Study
Online self-learning using Pluralsight and Kaplan training tools (2014 - 2017): Extensive coursework in C#.Net and MS SQL Server Tools (SSIS, SSRS, SSAS, SSMS).
New Horizons Computer Learning Center, Miami, FL (2014)
Advanced IT Training and Coursework
Completed Coursework Included: Hardware and OS Troubleshooting (CompTIA A+ content), Network Infrastructure and Administration (CompTIA Network+ content), Desktop OS Configuration (Windows 7 content), Server Infrastructure Administration (Windows Server 2012 MCSA content), Enterprise Server Services (Windows Server 2012 MCSE content), and Cisco Network Associate Training (CCNA content).
Center of Overcoming and IT Training (CENSAI), Havana, Cuba (2004)
Focused Training: .NET Framework
Covered curriculum for Microsoft Application Developer knowledge areas.
CERTIFICATIONS AND PROFESSIONAL DEVELOPMENT
Microsoft Certified: Power BI Data Analyst Associate (PL-300) – In progress (Estimated exam date: May/2026).
Azure Data Fundamentals – Self-study through Microsoft Learn focused on cloud data integration.
Contact this candidate