Robert Milliken Email & Phone Number

San Francisco, California, Us

Setup a cron job for an internal tool hosted on a tomcat server to ensure users have high availability.

San Francisco, California, Us

Lead a quarterly release from start to finish through all stages of the SDLC. Provided guidance on testing of new features. Created change requests through Service Now and gathered all necessary approvals while also delivering features necessary for security.Added custom properties for masking data. This feature will reduce the number of recompiles by picking up tags to mask from a configuration.Consistently gathering requirements to restructure and refactor codebase as well as executing corresponding database updatesTesting code changes using UAT/ERT framework (Fitnesse). Introduced a way to run tests concurrently, taking total testing time down from multiple days to under one hour.Updating testing application (java) to interface with our middleware app to be able to test code changesMaintaining development environment runtimes and database schemas to reflect current stages of SDLCPrevented over 10,000 unnecessary Splunk logging events per hour, saving on roughly 1GB of logging data per day and improving app performancePair programming with fellow engineers to fulfill requirements. Refactoring existing code for future maintainability.Updating database triggers through Liquibase SQL for production deployment to move old data to history tablesCreating Oracle SQL scripts through Liquibase to make UI changes through database configurations, saving time during install nights. As well as creating corresponding backout scripts to undo changes if neededLead the team through our most recent app update effort adding in visa mandated fieldsLead a major refactoring effort through entirety of SDLC taking cyclomatic complexity from 100 down to 10.Tools:Java development - git version control Testing using Gradle and FitnesseImplementing Agile Project Management methods using JiraOracle SQL database development Liquibase database version controlJenkins and uDeploy for CCIDSonarQube for lintingLinux

Anderson, Sc, Us

Contract with Bosch manufacturingUsing SQL Server Data Tools and Integration Services (SSIS/SSMS), I wrote custom scripts in C# to clean data before import (ETL).Refactoring static Power BI reports for database connections.Set up SQL Server bot jobs for automatic data imports.Updating winforms and .net applications to client needs.Blazor Server/Mudblazor UI development.

Warrendale, Pa, Us

• Assisted with credit card reconciliations of ~$300k per month. Tracked Covid spending for Cares Act cost reporting. Assisted with pharmacy and supply operations. Laid off due to Covid.

• With the pandemic, I saw a need for more healthcare workers and wanted to do my part.

Seattle, Washington, Us

• Position no longer needed due to unforeseen circumstances in surrounding business environment. (COVID-19)

Seattle, Washington, Us

• Audited over $1,000,000 in ship revenue entries on a voyage basis multiple times per week. Created miscellaneous journal voucher entries to ensure accuracy of voyage revenue.• Reconciled over 15 expense accounts every month for multiple ships. Assisted further in closing process by reclassing unrealized revenue into earned/unearned accounts.• Coded vba macros for common file paths and reconciliations to increase efficiency. Created new excel templates for ships to decrease manual entry mistakes.

Seattle, Washington, Us

• Processed over $600,000 a month in customer receivables from initial charge to posting to ensure completeness of financial statements.• Utilized ERP data in tandem with Excel VBA macros to create an A/R ageing report which helped to overcome shortfalls of existing software.• Actively manage over 200 customer accounts from the Portland and Logistics branches utilizing separate accounting software.• Reduced the average age of the Portland account by utilizing multiple streams of communication with delinquent customers.

• Increased donation volume by 15% over 6 months by using a customer friendly donation slip designed with Microsoft publisher.• Contributed in the annual reduction of 12,000 pounds of textile waste by creating affordable clothing options for lower income households.• Increased monthly revenue by $4,900 through the implementation of an inventory system that focused on theft loss and minimizing queue times.

Gb

• Saved 150+ hours of administrative task time annually by streamlining recurring payments using automated and one click billing systems.• Ensured accounting accuracy by keeping detailed records of aging receivables and followed up on delinquent payments.• Reduced waste stream impact by 15,000 units over 4 years by converting 25% of unwanted appliances into reuse units for low income households.

• Started a company working in tandem with the Appliance Depot doing appliance delivery and repairs.

• Reduced customer queue times by analyzing most ordered products and creating stockpiles near the front of loading process.

Bachelor Of Arts - Ba, Accounting

Master'S Degree, Computer Science

Web Development Boot Camp