Responsibilities include creating and maintaining custom financial reports in Sage Intacct for a myriad of clients, and improving internal administration process through the development of custom tools on platforms such as Salesforce, Jira, Maxio and Rocketlane. The reports are created through the use of the Sage Intacct ajax and REST APIs, along with Intacct's native YUI environment provided with their page scripts feature. Jquery and other libraries are used to create the custom page scripts to enhance the user experience. I improved administratiion processes at Alliance by creating a custom suite of objects and tools in Salesforce to track and manage all bugs and work items incoming from clients. Prior to this, there was no formal process for tracking bugs and work items that the development team were responsible for. This tool provided administration useful metrics to report upon and demonstrate progress made by the developers. I also created workflows and automations in Jira to connect with the tools I created in Salesforce to provide a seamless experience for the development team. Connecting Salesforce cases to Jira tickets was integral to ensuring a smooth workflow for developers and administration. Additionally, I connected Jira tickets to Azure DevOps; our git repository of choice; to ensure that developers could easily build a knowledge base of bugs resolved and code implemented to resolve those bugs.

My favorite project at Alliance was creating a cron job on our new internal VM which would sync financial data from Maxio to our internal database so the president of the company could effectively report on the financial health of the company. This was a huge win for the company as it allowed us to have a single source of truth for our financial data which we could then use to generate custom reports and charts for monitoring incoming revenue.

Responsibilities included developing a private API for internal use at Syncarpha. I was the sole developer of the API as of the time of my departure. The API had a vast suite of tools and CRON jobs that were the backbone of many important accounting and asset management processes. The API interfaced with a number of third party APIs including: Sage Intacct, Box.com, SmartSheet, ReTool, and proprietary APIs within the solar industry.

A massive accomplishment of the tool was creating a robust library to interface with Intacct’s SOAP XML API in a repeatable and iterable way. This was done by designing a system via functional programming. The tool included but not limited to: the ability to parse an arbitrary JSON object which matches the schema of an object in Intacct into the appropriate XML insert or update query and effortlessly update that object. In the case of objects that had required fields that were found to be missing the program could optionally make a get request (using my api’s tools) to fetch the required data from the object before executing the insert. The tool was capable of doing fast and efficient batch inserts of thousands of records at once and was capable of iteratively fetching an arbitrary amount of data to circumvent the restriction of only allowing 2000 results per individual request. The tool also featured robust error reporting and cataloging tools. Any time an error occurred, if it was a data-entry/user error the API would be able to detect that and notify the user of the error and suggest potential fixes without IT intervention, and if it was a logical error or a bug, the API would know and notify IT instead with a stack trace of the error, a timestamp and details of actions that were taken that lead up to the error. This was achieved by creating an action queue that cataloged every action the API took in order to allow simple tracing of user activity and errors at any time.

I developed custom software in Rust to automate parts of the employee onboarding process. An example application is an executable that would automatically register a network drive pointing to the company NAS and take an inventory of the computer’s specifications and important applications installed and store them in our database. I established a database of employee information to enhance security and access to tools made by IT. This employee database was an integral part of the creation of Syncarpha’s proprietary task-management system.

Responsibilities include running unit tests on the P-Series class of servers that run Red-Hat Linux. Repairing both physical and technical problems with servers and coordinating repairs and bug fixes with engineers. Unit tests were written in perl and used IBM’s proprietary platform Deleuth to help diagnose and catalog problems with individual machines.

Developed a full stack application in Next.js, GraphQL and PostgreSQL. The application was a SaaS in which social media influencers could be paired up with advertising agencies. The platform facilitated the exchange of money between agencies and influencers via the stripe api with a suite of tools for both parties to help fulfill these deals. Features included: Integration with Stripe and Stripe Express to allow users to send and receive payments between other users; A real time chat application made with websockets; and a custom search engine which allows influencers and advertisers to discover clients.