Experience

Cayenta

• Canada
• Software Development
• 100 - 200 Employee

• Technical Writer

  • Mar 2022 - Present

  Revised over 1000 web pages of product information migrated from a legacy CMS to Confluence. Originated a comprehensive style guide to ensure all documentation is consistent and effective. Facilitated the conversion/cleanup of 500+ API specification pages by creating a custom hypertext processing script and a template library. Edited company policies and unit test documents for clarity, concision, and style. Drafted white papers, process flow diagrams, and new feature announcements for internal and external audiences.

• Application Consultant

  • Feb 2019 - Mar 2022

  Led a smart metering implementation by integrating multiple enterprise systems via SOAP, developing XML templates and SQL views, writing and executing test cases, and collaboratively editing extensive user guides. Provided demos of product add-ons to client organizations with a total base of 10,000+ users; enhanced existing add-ons to minimize manual data entry and automatically perform complex formatting changes. Served as the primary point of contact for multiple customers for metering, billing, usability, and BI issues. Utilized Jira, SpiraTest, and Microsoft cloud products (SharePoint, Teams, Office 365) to manage projects and client updates.



JPMorgan Chase & Co.

• United States
• Financial Services
• 700 & Above Employee

• Applications Developer

  • Aug 2015 - Feb 2017

  Served on IT team formalizing software development processes to balance the needs of multiple stakeholders. Lowered regulatory risk by replacing end users’ spreadsheets with self-populating solutions built in Python and object-oriented VBA; offloaded calculations to SQL Server and enterprise applications. Automated the generation and distribution of daily compliance reports consumed by 300+ internal analysts. Executed multiple phases of the software development lifecycle (debugged applications, authored patching procedures, monitored production deployments, conducted peer code reviews, provided post-release QA).



Morgan Stanley

• United States
• Financial Services
• 700 & Above Employee

• VBA Developer

  • Jan 2012 - Aug 2015

  Leveraged automation to eliminate duplicative data entry processes, reducing loan booking time by 40%. Adapted existing web scraping tools to support new business logic and handle page layout changes. Coded VBA in PowerPoint to convert SharePoint data to project tracking decks for senior management. Designed Access forms to minimize reliance on spreadsheets, apply complex data validation, extract data via web services, and dynamically tailor user interfaces in accordance with the principle of least privilege.



Credit Suisse

• Switzerland
• Banking
• 700 & Above Employee

• Data Analyst

  • Jan 2011 - Jul 2011

  Achieved 35% acceleration of data entry into web forms by using VBScript to generate keystrokes. Eliminated the need for manual reporting by automating summarization and formatting in Excel. Devised Excel add-ins to normalize raw survey response text for subsequent analysis. Achieved 35% acceleration of data entry into web forms by using VBScript to generate keystrokes. Eliminated the need for manual reporting by automating summarization and formatting in Excel. Devised Excel add-ins to normalize raw survey response text for subsequent analysis.



Morgan Stanley

• United States
• Financial Services
• 700 & Above Employee

• Excel Programmer

  • Mar 2008 - Jan 2011

  Shortened invoice processing time from 2 months to 1 day with Excel macros. Implemented an algorithm to allocate recurring expenses among multiple cost centers. Created a form-based tool to simplify the process of performing ad hoc lookups across multiple documents. Built Access database to archive thousands of payment records on a monthly basis for rapid retrieval. Shortened invoice processing time from 2 months to 1 day with Excel macros. Implemented an algorithm to allocate recurring expenses among multiple cost centers. Created a form-based tool to simplify the process of performing ad hoc lookups across multiple documents. Built Access database to archive thousands of payment records on a monthly basis for rapid retrieval.