Alejandro is available for hire

Alejandro Casin III

Verified Expert in Engineering

Excel Macros Developer

Quezon City, NCR, Philippines

Toptal member since June 18, 2020

Expertise

Excel Macros Excel Development Database SQL SQL Server MySQL Data Visualization Data Migration Data Engineering Data Warehouse Visual Basic Sybase

Bio

With several years of hands-on experience under his belt, Alejandro has the knowledge and skills to design, develop, debug, and support your back-end development. He's the type of developer who enjoys solving extremely challenging database development problems the most.

Portfolio

An Online Freelance Agency

C#, PHP 7, SQL, SQL Server Integration Services (SSIS)...

Self-Employed

C#, VB.NET, SQL, Database Design, Tax Accounting, PHP 7, JavaScript 6, HTML5...

Seven Seven Softwares

Amazon Redshift, AWS Glue, AWS Lambda, AWS Step Functions, Microsoft Outlook...

Experience

Microsoft Excel - 20 years
SQL - 15 years
Microsoft SQL Server - 15 years
Excel VBA - 10 years
Excel Macros - 10 years
MySQL - 5 years
Data Visualization - 5 years
.NET - 3 years

Availability

Full-time

Preferred Environment

Windows

The most amazing...

...project I've delivered was an application for an accounting firm that automated the tedious tax compliance processing for their clients.

Work Experience

Top Rated Freelancer

2018 - PRESENT

An Online Freelance Agency

Pulled data from various API servers and saved it to on-premise data warehouses using SQL Server Integration Services (SSIS).
Synchronized data between on-premise systems and online platforms like Airtable and Mailchimp.
Created reports using SQL Server Reporting Services (SSRS) and configured them to be emailed to recipients based on a schedule.

Technologies: C#, PHP 7, SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MySQL, Databases, Microsoft Outlook, Data Engineering, Reporting, Airtable

Developer

2018 - PRESENT

Self-Employed

Developed web application to improve and streamline the operation of accounting firms.
Updated tax processing desktop application to make it compliant with changes in tax code.
Tracked and fixed bugs promptly, answering queries and extending customer support.

Technologies: C#, VB.NET, SQL, Database Design, Tax Accounting, PHP 7, JavaScript 6, HTML5, CSS, Database Development, Microsoft Excel, Excel Macros, Excel VBA, Visual Basic for Applications (VBA), Microsoft Outlook

ETL Developer

2022 - 2023

Seven Seven Softwares

Re-engineered and streamlined the ingestion process using stored procedures instead of the Amazon services approach, Glue, Lambda, and Step Functions.
Automated the creation of almost a thousand stored procedures to ingest data from text files, increasing productivity for all ETL developers and improving code quality.
Created PowerShell scripts to parse error messages in a user-friendly format, reducing debugging time.

Technologies: Amazon Redshift, AWS Glue, AWS Lambda, AWS Step Functions, Microsoft Outlook, Data Engineering

Senior Database Developer

2012 - 2017

Macquarie Offshore Services Pty Ltd (Manila, Philippines)

Created and modified database objects (tables, views, stored procedures, and triggers) using SQL based on business needs.
Prepared, planned, tested, and coordinated the deployment of database code changes to production and vendor patches.
Optimized SQL queries and stored procedures to acceptable levels.
Developed and enhanced data visualizations based on business requirements, using IBM Cognos—data models, business reports, and dashboards.
Automated the loading and processing of timesheets data in a CSV format into a database using Unix and database scripts, which eliminated tedious manual processing.

Technologies: IBM Cognos, Cognos 10, Oracle, Sybase, Microsoft Outlook, Data Engineering, Reporting

Developer

2012 - 2012

Loanworks Technologies

Mentored team members in SQL database programming, which improved the team's efficiency in resolving client issues by 20%.
Modeled and implemented the data warehouse of one of the company’s clients, including creating an ETL package.
Enhanced both the front and back end of the company’s main product to handle two additional types of loans.

Technologies: Microsoft SQL Server, Microsoft Outlook, Reporting

President

2009 - 2011

Cubesoft Software Solutions

Developed the business.
Constructed a client-server application to streamline their tax preparation.
Manage the project that developed and deployed the website of the Cooperative Insurance of the Philippines.

Technologies: Microsoft SQL Server, .NET, Microsoft Excel, Excel Macros, Excel VBA, Visual Basic for Applications (VBA), Microsoft Outlook

Consultant

2005 - 2008

Fast Track SBOI Sdn Bhd

Configured SAP Business One according to the clients' business processes.
Mentored and trained junior staff on developing customized reports.
Developed customized programs to accommodate client requests lacking in the core product.

Technologies: Crystal Reports, Microsoft SQL Server, Excel VBA, Microsoft Excel, Excel Macros, Visual Basic for Applications (VBA), Microsoft Outlook, Reporting

Cadet Engineer

1989 - 1991

D.M. Consunji. Inc.

Planned and supervised exterior concrete walls construction.
Supervised pile driving operations. Between 150 and 200 piles were driven.
Quantity surveying and estimates for bidding purposes.

Technologies: Civil Engineering

Experience

HAS Accounting

Here, I developed a .NET client-server application that streamlined the tax returns processing and preparation of other related tax compliance documents of the HAS accounting firm.

Music Royalty System

For this project, I developed a desktop application to calculate the royalties due to composers, producers, and artists based on record sales. The rates of each payee may vary per song in the album and there may be multiple payees per song.

Order and Billing System

For Steam System Philippines, I developed a client-server application for an order-and-billing system.

Education

1983 - 1988

Bachelor's Degree in Civil Engineering

Mapua Institute of Techonology - Manila, Phillippines

Skills

Tools

Microsoft Excel, Microsoft Outlook, Microsoft Power BI, SQL Server BI, IBM Cognos, Crystal Reports, Microsoft Access, AWS Glue, AWS Step Functions

Languages

SQL, Excel VBA, T-SQL (Transact-SQL), PHP 7, Visual Basic for Applications (VBA), C#, VB.NET, JavaScript 6, HTML5, CSS

Paradigms

Database Development, Database Design, ETL

Storage

Databases, Relational Databases, MySQL, SQL Server 2017, Microsoft SQL Server, Sybase, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Frameworks

.NET

Platforms

Oracle, AWS Lambda

Other

Excel Macros, Reporting, Data Visualization, Data Warehousing, Data Warehouse Design, Data Migration, Data Engineering, Cognos 10, Civil Engineering, Tax Accounting, Amazon Redshift, Airtable

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring