Danny Gonzalez

Computer Programmer Data Analytic Business Intelligence T-SQL SQL Developer VBA .NET

About Me

I am Danny Gonzalez, a software and data analyst developer living in Toronto.

I became passionate about building applications since I built my first C++ application in 2005. Then I became a data analytic consultant and developer. Finally, my interest in web development started back in 2017 when I decided to expand my knowledge at Humber college and solve real world problems by applying new and exciting technologies.

I’ve had the privilege of working at a business intelligence company in Colombia. My main focus those days were building Excel - VBA - Power BI advanced reports & automatized tasks, writing SQL commands, creating Data Warehouses, and ASP.Net Web Applications for a variety of clients and internal projects.

Download Resume

Portfolio

RECENT AND MOST IMPORTANT PROJECTS

Image
SIMDI

Intelligence Data Import System for end user without technical knowledge. It is an Excel Tool used to create Databases & Tables, Insert & Delete data into SQL Server.

Programming Languages, Tools & Platforms: VBA - SQL Server - Excel - OOP Class Modules

Image
SAAR

Automatic Alert and Notifications System for end user without technical knowledge. It is an Excel tool used to update, attach, and send automatic reports created in Excel.

Programming Languages, Tools & Platforms: VBA - Excel - Microsoft Access - OOP Class Modules - Windows Task Scheduler

Image
CASH

Cash flow forecasting. It is an Excel tool that allows users or companies to manage their receivable accounts and payable accounts. The records are stored in SQL Server.

Programming Languages, Tools & Platforms: VBA - SQL Server - Excel - OOP Class Modules - Data Warehouse (Transact-SQL) using Openquery/Linked Server

Image
BiableWeb

ASP Web Application used to manage Power BI embeded dashboards (Software as a service model)

Programming Languages, Tools & Platforms: ASP.NET MVC - SQL Server - Power BI Embeded - Bootstrap - Html - CSS - JavaScript

Image
Tax Calendar

ASP Web Application used to control and manage their tax calendar and tax forms, phases (workflow) and email notifications

Programming Languages, Tools & Platforms: ASP.NET MVC - SQL Server - Bootstrap - Html - CSS - JavaScript

Image
Phone Line Assignation

ASP Web Application used to control, manage, and assign phone lines to travellers.

Programming Languages, Tools & Platforms: ASP.NET MVC - SQL Server - Bootstrap - Html - CSS - JavaScript

Image
Power BI

Power BI advanced reports & dashboards.

Programming Languages, Tools & Platforms: Power BI - Power Query

Image
Data Warehouses

Desktop application/tool that is used to centralise several databases or data sources in a Microsoft database SQL Server. This uses linked server as a bridge between data source and data warehouse, Openquery to implement the ETL or T-SQL commands and batch files for run the application.

Programming Languages, Tools & Platforms: SQL Server - Linked Server - Openquery (Transact-SQL) - CMD

Image
Dashboard Tool

VBA functionality tool employeed to create tachometer and thermometer charts.

Programming Languages, Tools & Platforms: Excel - VBA - XML

Image
Excel VBA Reports

Top 10 salesmen’s report made in Excel. It was developed by applying advance knowledge of Excel and VBA.

Programming Languages, Tools & Platforms: Excel - VBA

Image
Excel VBA Reports

Sales trend report made in Excel. It was made by applying advance knowledge of Excel and VBA.

Programming Languages, Tools & Platforms: Excel - VBA

RESUME

RELEVANT EXPERIENCE

  • Visión Tecnológica S.A.S, Colombia

    Dec 2008 – Feb 2022 (13 Years)

    Software Developer

    Created reports, tools and automatized task using VBA, functions, Pivot Tables, Power Query, XML, Shell Scripting, Power BI for customers and internal projects

    Wrote SQL sentences for the BI tool connected to a variety of databases such us Oracle, SQL Server, Postgres, FoxPro, Firebird.

    Developed Data Warehouses for customers using T-SQL (Openquery) and Linked Servers

    Developed web applications for a diverse array of client and internal projects using ASP.net MVC, Html, CSS, JavaScript

RELEVANT EDUCATION

Contact

Toronto ON, Canada

danny03_7@hotmail.com

(647) 207 9079

Danny Gonzalez