o Created modal with live information/logs about workflows run

o Worked with the Accounting team to re-implement webpages that use more up to date libraries and technologies in SQL, C# and Javascript

o Helped work on a wrapper class for C# tasks

o Created a mock scheduler for workflows, and a C# emailer that sends the workflows that did not run on schedule

o Created a error report system for workflows

o Worked on the backend(SQL/C#)/frontend(Javascript.HTML, CSS) on different webpages to better present data to end users.

o Worked on implementing different utility functions to expand in-house libraries

o Helped create way to run workflows through SQL store procedures

o Worked on the Data Load Team which created efficient workflows that quickly gathered data from new data streams to support traders and researchers with day to day operations

o Created the data architecture that properly created, and updated database tables and stored procedures for financial data on MS SQL Server

o Used Python libraries such as Requests and Selenium to create web scrapers, parsers, and downloaders to grab data for the ETL process

o Developed and enhanced an Extract-Transform-Load framework with Python 2 and Python 3 and MS SQL that is used in dozens of critical/high impact automation tasks that directly supported business users; in some cases, automated multi day processes to take less than an hour

o Developed websites for users to visualize data using Javascript, HTML, CSS

o Created regression tests to ensure consistency across production environments in SQL and Python

o Identified test requirements from specifications, map test case requirements, and design test coverage plan.

o Developed, documented and maintained functional test cases and other test artifacts like the test data, data validation, harness scripts and automated scripts.

o Execute manual or automated test cases and report test results.

o Identified any potential quality issues per defined process and escalate potential quality issues immediately to management.

o Ensured that validated deliverables meet functional and design specifications and requirements.

o Documented defects in defect tracking system and re-test corrected defects.