Actively maintain the documentation for five different teams under the Google Distributed Cloud air-gapped product area. I create, plan, and triage the documentation work required for all five teams.Implemented a tool that automated the process of finding broken URL links in the documentation. Before this initiative, this was a manual process and many broken links were fixed in the first automated scan.Created the first manual test plan for our documentation which is executed… Show more Actively maintain the documentation for five different teams under the Google Distributed Cloud air-gapped product area. I create, plan, and triage the documentation work required for all five teams.Implemented a tool that automated the process of finding broken URL links in the documentation. Before this initiative, this was a manual process and many broken links were fixed in the first automated scan.Created the first manual test plan for our documentation which is executed each release. Executing these tests resulted in 40+ issues being fixed that would have made it into the final release of the documentation. Attained the Google Cloud Associate Cloud Engineer certification in my first year to deliver more detailed documentation and improve collaboration with Engineering and Product stakeholders. Show less

Wrote a series of How-To guides for Dutch startup TalkJS that demonstrated potential uses for their JavaScript SDK.Created or improved upon existing API documentation for many different clients across industries such as Energy, Health Insurance, and Banking. Completed a series of SQL Tutorial posts for LearnSQL.com, that were designed to educate users of all skill levels on how to use SQL.Wrote SEO-focused blog posts that rank on page 1 of Google for their targeted… Show more Wrote a series of How-To guides for Dutch startup TalkJS that demonstrated potential uses for their JavaScript SDK.Created or improved upon existing API documentation for many different clients across industries such as Energy, Health Insurance, and Banking. Completed a series of SQL Tutorial posts for LearnSQL.com, that were designed to educate users of all skill levels on how to use SQL.Wrote SEO-focused blog posts that rank on page 1 of Google for their targeted search terms. All of this work and my other completed freelance projects can be found here: andrewjamesbone.com/entire-portfolio. Show less

Integrated with the UI & API teams to manually test new features and enhancements that were developed, tested, and deployed in adherence to Scrum methodology. I used Postman, Swagger, Xray, Jira, and interacted with DBs directly using SQL to complete this testing. Used Python, Behave, and Cucumber to create automated test suites. I contributed to existing sanity and regression tests, that ran daily in Jenkins, and developed new automated API and UI tests.Prepared extensive… Show more Integrated with the UI & API teams to manually test new features and enhancements that were developed, tested, and deployed in adherence to Scrum methodology. I used Postman, Swagger, Xray, Jira, and interacted with DBs directly using SQL to complete this testing. Used Python, Behave, and Cucumber to create automated test suites. I contributed to existing sanity and regression tests, that ran daily in Jenkins, and developed new automated API and UI tests.Prepared extensive documentation about current systems and covered end-to-end flows within the application. Prepared training documents to be used by new members of the team. Contributed to the documentation of how we create Test Plans, Test Cases, and Test Executions in Jira, and the associated plugin, XrayAssisted in the interview process for new candidates, conducted the daily stand-ups for the QA team on a biweekly basis. Contributed to Sprint retrospectives, ticket refinements and estimations, and sprint planning sessions. Consistently praised for the relations maintained with developers, design & product teams, where we worked together with a collaborative focus on software quality, and the experience our users would have. Show less

Updated an existing tool which extracted Point-of-Sale data from book stores using Shopify. I updated the program to also extract data from the Lightspeed and Square POS systems using the REST APIs they provided. I created an ASP .NET page where our clients were authorized through OAuth 2.0. After successful authentication, we extract and parse the data automatically each week then export it to CSV format. This application is built using Visual Studio and C#.Created… Show more Updated an existing tool which extracted Point-of-Sale data from book stores using Shopify. I updated the program to also extract data from the Lightspeed and Square POS systems using the REST APIs they provided. I created an ASP .NET page where our clients were authorized through OAuth 2.0. After successful authentication, we extract and parse the data automatically each week then export it to CSV format. This application is built using Visual Studio and C#.Created a tool that allowed our internal staff to replace the cover images of existing book titles. This involved creating a file browser on the web page which allowed users to interact with the files on the server. These files were referenced in the SQL database so all references had to be updated or deleted based on user actions. Created three new ASP.net web pages from scratch which allowed users to createand export custom reports.Created three separate SOAP web service methods which allowed users to retrieve SQL data in the form of a text file or displayed as XML. Show less

My role was split between creating new features and enhancements for an in house application, and performing maintenance duties for this application such as QA testing new features, bug fixes and addressing any user questions, concerns or data requests. This application is built using Visual Studio and C#.Generating reports was an almost daily task. This involved writing SQL queries which varied in complexity.I wrote a program which automated the sending of… Show more My role was split between creating new features and enhancements for an in house application, and performing maintenance duties for this application such as QA testing new features, bug fixes and addressing any user questions, concerns or data requests. This application is built using Visual Studio and C#.Generating reports was an almost daily task. This involved writing SQL queries which varied in complexity.I wrote a program which automated the sending of emails for 90,000 records which slashed 5 minutes of processing time for each of the 90,000 records. Show less

My main role was creating automation software for the tax departmentMy other responsibilities included the management of databases, debugging and correcting existing software, and assisting in the deployment of laptops.Some of the projects I worked on were as follows:SLA CalculatorMy first task was writing a VBA program which took the last date each employee did work for a client, and used this to calculate the Service Level Agreement each employee had to meet. My code… Show more My main role was creating automation software for the tax departmentMy other responsibilities included the management of databases, debugging and correcting existing software, and assisting in the deployment of laptops.Some of the projects I worked on were as follows:SLA CalculatorMy first task was writing a VBA program which took the last date each employee did work for a client, and used this to calculate the Service Level Agreement each employee had to meet. My code generated an excel worksheet containing the employee’s Assignee ID, last name, first name, the last date each employee logged data into the system and finally the SLA date. There were two buttons on the spreadsheet, a button which allowed the user to run the macro simply and another which enabled the user to clear all the cells in the spreadsheet quickly. When the button was clicked, the imported document would be opened in another tab which made copying between the documents easy. Report BuilderThe second project I worked on was a Report Builder application. The purpose of this application was to allow the user to generate different styles of reports depending on their inputs. The first stage was the import stage. The application had to read data from Excel .csv files and write this data to a database. Microsoft Access was used for the databases involved. SQL commands were used to retrieve data from the Access databases. Show less

This work involved the counting and organisation of stock in a variety of retail stores around the country.