SAS code enhancements after BPI System upgrade using SAS Base/EG and SAS Data Integration Studio; SIT/UAT participation for end-to-end projects; Extract/Load data to Hadoop/Hive using SQL queries; Windows/Linux batch scripts, shell scripting; Create Zena jobs for automating triggered jobs in Linux.

Senior Associate at The Depository Trust & Clearing Corporation (DTCC)

September 1, 2011 - September 1, 2024

Senior Programmer under Capacity Planning Team; automated manual internal reports for other teams from data collection on different sources, storing in central MS SQL Server Database and publish/update reports using SAS, ASP.NET pages, VBA/Excel reports, PowerBI reports and Highcharts. Duties include automation of manual reports, server and SQL/IIS administration, data analysis, automation of data imports from JSON/CSV/API/Oracle to SQL Server, and creation of reports in ASP.NET (VB) with Highcharts, aspxgrid, jquery, HTML, CSS, JavaScript; publishing PowerBI reports; creation of SQL scripts, stored procedures, functions, views and tables.

Senior Data Analyst at Seven Seven

July 1, 2010 - September 1, 2011

Automation of BI and ANDEAN report/tool using Excel, VBA Macros and MS Access; automated profit forecast calculations for different P&G products; created SK II Sample and Order Management software using Visual Basic and MS SQL database.