System support for the bioinformatics department

While I held several titles and was employed by three companies over the course of this this position I continue to work for the same group with the same manager in the same role. This role includes working within a company proprietary CI/CD pipeline and generating glue that stitched larger pieces of high volume ETL work together in a High Trust healthcare environment. We worked as an Agile team using sprints. Kyruus - Healthsparq - VanderhouwenKey Accomplishments • Wrote a large (gigabyte) document comparison tool in GCP Dataflow, once in python, once in Java • Deployed purchased IBM Java code (medical episode grouper) in a Docker container using Bash sharding and concurrency to improve capacity and speed • Wrote and deployed a data distribution tool to distribute inbound data to various ETL stacks o AWS – using Lambdas, Event Bridges, Step Functions (State Machine), Docker, Batch, SNS, SQS, GCP pubsub, GCP storage transfer service, S3, GCS, DataDog (monitoring and logging functions) o GCP – ported from AWS with CloudFunctions, Scheduler, Workflows, Docker, Compute, Pubsub, GCP CLI integrated in docker for file transfers, GCS, DataDog (monitoring and logging functions) o This includes decrypting, unzipping, header removal, sharding, and starting the next ETL stack process o. Languages in the stack include Java, Python, Nodejs, BashTechnologies AWS Serverless, GCP Serverless, Python, Nodejs, Java, Bash, Docker, CircleCI, GitHub, DataDog unit testing

see Kyruus experience -> same jobTechnologies AWS Serverless, GCP Serverless, Python, Nodejs, Java, Bash, Docker, CircleCI, GitHub, DataDog unit testing

ee Kyruus experience -> same jobTechnologies AWS Serverless, GCP Serverless, Python, Nodejs, Java, Bash, Docker, CircleCI, GitHub, DataDog unit testing

Contracted to HealthSparqResponsibilities* Developing tests written in Dataflow controlled with Composer used to validate large scale data migration processes from a Hadoop store to a Google Cloud Store* Certify correct data loading processes in Google Cloud storageTechnologies* Python, Google Dataflow (apache beam), Google Composer (apache airflow)

Started out as a contractorDuties This was a position supporting an Excel based supply chain of internal paper manufacturing and internal box manufacturing. My primary role was to develop worksheets that would support the daily paper build orders via intelligence built into the table comparisons. These spreadsheets did two things. First, they reconciled datasets between various sources. Second, they made recommendations that the ordering specialists could use to make their daily paper ordersAccomplishments • Aggregated disparate data sources from two internal vendors 16 external vendors and 14 customers into a prototype forecasting tool and a separate prototype dashboard tool. The forecast tool generates ~12M$ of orders to the vendors for the internal customer daily.Technologies VBA scripting, Excel

Duties This was a role working for a very small IoT incubator within a very large corporation. I was brought on board to supply expertise around analytics implementations of high-volume data from IoT devices. The project was cancelled before we went to market. My role pre-cancellation was building the data links between the DynamoDB tables loaded by the IoT devices and the end user frontend dashboard.Accomplishments • Wrote complete web endpoint to S3 and DynamoDB storage with transformation and storage. This included zip extraction and file parsing with templates. This enabled a complete new high-volume low-cost data path. I used Node, Angular, and AWS Lambdas and Terraform to implement • Wrote front end Angular pages for the reporting piece of the web portalTechnologies JavaScript, Node, Git, Terraform, AWS S3, AWS Lambdas, AWS DynamoDB, Angular 1, SQL

Duties This job was primarily focused on transitioning a Warranty team (Hardware Quality) from Excel based analysis to Database based analysis. The implementation needed to happen while continuously supporting the actual warranty analysis required by the business. The position included working directly with the repair centers. I also managed and improved, the hardware change control processes. When I left, the implementation was handed to an admin since it no longer required engineering level development.Accomplishments • Designed and implemented an RDBMS PostgreSQL reporting database from scratch o. Used forward looking statical analysis tool to predict warranty costs for printer . Reporting done via SQL queries and stored procedures o. Collected data from spreadsheets sent via email including sheets with embedded Chinese and Japanese embedded encodings  The solution included a hand rolled perl Excel spreadsheet parser • Designed and maintained a full hardware change control system with the contract repair centers.Technologies perl, SQL, stored procedures, PostgreSQL, MySQL, Talend, AWS EC2, Excel, PowerPoint, VBA Scripting, Access

Duties This role was focused on reporting SEM scans of R&D memory wafers in processes. The goal was to have a centralized place for defect events during development prior to electrical testing of the chipslAccomplishments • Converted a manual PowerPoint reporting process to an automated web page. This doubled the reporting capacity and reduced the reporting response from one week to 2 hours. Inbound data came in a SEM specific format with file sizes upwards of 250 MB.Technologies perl, HTML, ImageMagick

Led a cross divisional team that set engineering priorities and reduced field failures by 15%Responsible for total project savings of $20M in 2005/6 (numbers reviewed and approved by finance)Led a team to create new data collection processes and targets with closed loop feedback to developmentImproved usable customer call data from 10% to 85% of calls and reduced issue response by 4 months

Prioritized field product quality issues and worked with a Japanese design/manufacturing partner to resolve the issuesCreated $3M+ of quality savings due to engineering change initiatives on productCreated and implemented a new test strategy using accelerated customer failures to qualify new productsDeveloped and implemented qualification tests for proposed product fixes from our partner

Designed and implemented a new 15,000 per month chassis build production line for a PCA factoryLine maintenance, process development, process training, and product change management support

Boat driving, food cooking, owie bandaging, outdoors-man.Responsibilities included;- interpretive presentations of the history flora and fauna of northern Arizona and central Utah.- Organizing and managing trips as a trip leader- General customer management activities real time during the trip.

Machine tool Mill operator- Reading prints to build new parts for new exercise machines- Determining feeds and speeds for new parts

Worked directly with youth at risk in an extended stay outdoor position

On site support staff for extended stay outdoor behavioral healthcare services.

Production grinder operator- Center-less grinder operator- parts made from carbide and industrial diamond bonded together in high pressure hydraulic presses

Fish factory processorFreezer hold warehouse staffFishmeal Station staff

Night Shift Intake and Spanish translation (Spanish speaking applicants to English need based forms) for a waystation in support transient farmworkers. (Supporting an NFJP) grant.

Summer High School InternWorking as a Case packer for a paper products manufacturing line