Alejandro is currently unavailable
Alejandro Casin III
Verified Expert in Engineering
Excel Macros Developer
Quezon City, NCR, Philippines
Toptal member since March 11, 2019
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
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, Transact-SQL (T-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.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
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