Timothy Hays Email & Phone Number

Remote First, Us

Oakland, California, Us

● Worked on the public launch of the Commerce Platform API. Finalized Orders system’s ability to up-convert all legacy transactions into Orders and authored the public blog post(https://developer.squareup.com/blog/everything-is-an-order/) explaining the feature. Completed the UpdateOrder endpoint and released new Discount and Tax features to all of the existing Order APIs.● Led project to split a piece of the Order system into a new primitive owned by a new Fulfillments team. The project required the new system and the Order integration with it to be fully backwards compatible with existing versions of Orders. Worked with 6 engineers on the new team to help guide the design of the new system and 1 engineer on the Orders team to implement the pieces of the integration.● Led a group of engineers to work with the owners of the Invoices system to back 30 million legacy invoices with an Order. Work included running every invoice through a conversion process and then working with the Invoices team to collate and categorize all the hundreds of thousands of conversion problems autonomously. Worked with the Invoices team to build fixes for each category of errors eventually allowing for full conversion.● Upgraded the event logging architecture within the Orders system to use the newest internal event pipeline and worked with the central platform team to lift parts of my design into the platform approach.Released multiple new discounting features into the Orders API including support for post-tax discounts, per-quantity discounts, and helped add support for automatic discount and loyalty integrations.● Worked with a teammate to cut system database sizes by 50% by shifting the source of legacy data into the legacy system and only maintaining metadata on those transactions within the Orders system. This bought the team 6-12 months to work out a long term data storage plan and shift the data to cloud providers.● Worked to mentor and onboard 6 engineers.

Atlanta, Ga, Us

Landing Pages Team: 8/18 - 10/18● Working to support MailChimp’s landing page feature and develop new enhancements.● Supported MailChimp’s public APIs and the programming framework for developing new API endpoints.● Improved logging and reporting tools for the public API to help identify performance and compliance problems.● Redesigned API framework to enhance developer experience and decrease development time for new endpoint creation.● Consulted with other product teams to review API endpoint contracts and code to maintain consistent user experience and coding standards.● Created documentation and gave department wide presentations evangelizing domain driven design at MailChimp to help improve separation of concerns and reduce code duplication.● Worked on a triage team to improve processing performance of MailChimp webhooks and prevent event floods from causing production outages.

Boston, Massachusetts, Us

● Developed a data access API and SQL query-generating platform servicing BI applications.● Improved Perl reporting tools to ensure on-time delivery of 1.6 million reports per month to over 30,000 unique users.● Increased on time delivery of reports from 93% to 98%. ● Developed and tested Java technical interview puzzles for filtering technical candidates and conducted technical interviews.● Built custom ETL toolset to allow non-technical staff to build and customize ETL processes for Epic Data Warehouse client datasets.● Improved reporting system user experience by converting HTML forms to AJAX calls via JavaScript.

Boston, Massachusetts, Us

● Improved the operations of a distributed ETL pipeline from an Oracle/Linux stack into centralized Microsoft SQL Server databases to bring monthly failure rates from around 9% to less than 0.5%.● Worked to optimize database schema for BI tool to improve real-time analysis of datasets exceeding 100 million transactions using data warehousing design and a columnar database format.● Built new database model for controlling client customization and configuration across multiple production servers using SQL Database Replication.

Boston, Massachusetts, Us

● Wrote ETL process automation for Analytics, a healthcare revenue cycle business intelligence tool targeted at large health systems.● Wrote processes to transform data from multiple practice management software vendors into data warehousing databases for BI tools to consume.● Built a set of ETL generation tools. Used to allow non-technical staff to build and customize ETL processes for clients and for adding support for new vendor systems. ● Rewrote transform and processing logic for the servicing Epic client dataset, eliminating ongoing validation problems.

Atlanta, Georgia, Us

● Manager and technical lead of the University ERP system team. Managerial duties included supervising Business Analyst.● 90% Programming - 10% Management split of time.● Worked with the Systems Team to implement and deploy a new Access Control system to the University.

Atlanta, Georgia, Us

● Designed, implemented, and maintained interfaces between University ERP system and Access Control, Dining Services, Library, Career Services, Alumni Community and Advising Systems.● Provided training, support and report writing to every functional area of the university.● Organized and supervised the upgrade of local instances of Datatel Colleague System User Interface from version 3.1 through 4.3 and provided all end user training for new versions.● Deployed new Entrinsik Informer reporting tool and designed and implemented SharePoint reporting sites for each functional area for dissemination of reports and training materials.● Worked with customers within the organization on writing specifications for large projects. Supervised and assisted in the implementation of these projects.● Worked with customers to gather requirements and implement ad-hoc reports in Entrinsik Informer.

Cleveland, Oh, Us

● Manager and technical lead to a team of four programmers, a technical trainer and interns. Managerial duties included controlling the hiring for the team and managing an annual budget of well over $500,000. ● 80% Programming - 20% Management split.● Organized and supervised the upgrade of local instances of SunGard HEs Advance System from Oracle 9i to Oracle 10g and implementation of local customizations of the product. ● Worked with customers within the organization on writing specifications for large projects. Supervised and assisted in the implementation of these projects.● Design, implement, and maintain interfaces between internal and external databases using Oracle 10g XML DB and UTIL_DBWS packages saving 4 man-hours per week.

Cleveland, Oh, Us

● Worked with customers to gather requirements and implement ad-hoc reports in PL/SQL.● Monitored ad-hoc reporting and created standardized reports in PL/SQL and PowerBuilder from regularly requested ad-hoc reports, reducing ad-hoc load by 10%.● Reviewed business rules and encapsulated them in PL/SQL functions and procedures for standard use across reports and personnel, reducing discrepancies between programmers, and overall coding time.● Tuned PL/SQL procedures and functions to reduce customer wait times, and nightly processing load. Most recently improved a report process time by 400% by modifying the report SQL to use the WITH clause (subquery factoring).

● Led design, implementation and support of the desktop version of drug information product, On-Desktop.● Implemented On-Desktop as a Java application using Swing to implement a MVC architecture and a Derby database as encrypted data storage.● Wrote client-server version of On-Desktop that used Java Threading Model and dynamic SQL over JDBC to fulfill user requests in under 1 second. ● Implemented web services using Java Spring to securely download new XML content to clients.● Implemented multi-threaded Client-Server version of ON-DESKTOP product in which clients downloaded new client software and accessed data from a central server without the need for internet access at the client machines.

● Worked with a teammate to develop data tools for the research and development of new pesticides.● Used PL/SQL, JavaScript, HTML, and DHTML to implement web based data presentation and filtering applications● Created a large web based application which used Java Servlets and JDBC to visualize extremely large datasets of highly multidimensional datasets.