Nicholas Hunter Email & Phone Number

Houston, TX

VBA macros and Alteryx workflows to automate the pricing of financial derivatives, data transfer, and board reporting.

Houston, TX

• Development of reference data and trade capture syncs between OATI and Athena (SOAP, Python)
• Meter data and congestion bid load to OATI (SOAP, Python)
• Support and enhancement of Asset Shadow Settlement spreadsheets for AES and Georgia (Excel/VBA)
• Ad hoc SCADA & NMarket reports (Python, SQL)
• Web scrapers for fundies data (Python, Java)

Houston, TX

• Designed and implemented a daily settlement reporting application drawing together data from a variety of sources, performing user-configurable calculations, and printing to pdf.
• Designed and implemented a three way deal reconciliation application, provided rolling data reconciliation and exception reporting (Excel/VBA).
• Provided support and enhancement of a suite of reporting and reconciliation tools developed using Microsoft Office 2003: streamlined the tools' use; provided remediation for data and logic errors; and supported version.

Houston, TX

• Reengineered production MSVC++ application running against a Btrieve database, first to run simultaneously against Btrieve and SQL Server databases in order to performance test a SQL Server solution, then cutting over.
• Designed and implemented a suite of ant tasks, using ftp, telnet, and http, automating the transformation of data files and workflow, replacing two FTEs.
• Reduced the number of incidents occurring during the "Service By Others" nightly batch from one or two a week to one or two a year.
• Provided support and enhancement of a suite of reporting and reconciliation tools developed using Microsoft Office 2003; streamlined the tools' use; fixed data and application errors; and supported version upgrades.