Mr. Veltstra

Senior Software Engineer

Mamiye Brothers, Inc•  May 2015 - Present

Software Engineering, Software Development, continued application support and bug-fixing, Data Visualization, Data Integration between ERP and third-party trading partners and e-commerce platforms. Business Analysis, Business Intelligence Analysis, DevOps, Server Provisioning, Ad-hoc Reporting, Tool and Service Provider Selection. Software development in Java 8, 9, and 10, to create an enterprise message pump that performs data integration between an in-house ERP (MS SQL Server) and remote REST APIs by multiple communication partners (Amazon Marketplace / MWS, Walmart Marketplace, NuOrder, BigCommerce, Shopify, Mirakl, Ebay, Jet, Joor). Other skills used: OAuth, OAuth2, gradle for CI/CD, AWS CodeCommit, maven and gradle for dependency management, SQL, XML, XSLT, JSON, Powershell, Batch, EDI, X12, ETL, and JavaFX for GUI. Both B2C and B2B communication for product sales and logistics. Software development in Python on AWS Lambda to create a serverless computing enterprise message pump using AWS S3, AWS DynamoDB, AWS IAM, AWS Secrets Manager, AWS Storage Gateway. Both B2C and B2B communication for product acquisition, sales, and logistics. Software development to create a document management system: cross-browser GUI Front-End with HTML/CSS/JS (Javascript), middleware with Python on AWS Lambda, integrating with back-end in AWS DynamoDB and AWS S3, secured by AWS Cognito, made scalable and highly available using AWS CloudFront, protected by AWS WAF. Software development to migrate a Python Flask REST API to AWS API Gateway. It receives documents from remote communication partners, using AWS Storage Gateway. I also built the implementation in Flask. Data storage model optimization and data retrieval optimization in MS SQL Server using SQL, TSQL, SQLCMD to make updating of inventory to remote sales partners near real-time. Using ETL middleware Biz Server by OpenText, and their ETL mapping and transformation tool Mapper. Software development in Powershell to migrate a media upload system from DOS Batch, and to create a multithreaded file compression system, and to create tools for DevOps: to manage applications on remote servers. Software development in QlikView, a tool for data analysis and data visualization, to increase business intelligence by building financial and logistics management insight dashboards. Software development in QlikView, a tool for data analysis and data visualization, to create a generator for MS Excel spreadsheets, that helps decide acquisitions. Pre-programmed MS Excel formulas to allow for real-time data manipulation in the spreadsheet. Using VBA to import images. Software development using Python and Flask to create a person and equipment information system for HR and IT, using HTML/CSS/JS (Javascipt) and Jinja templates for the GUI front-end, Flask as the web server, python as the middleware that communicates via AWS API Gateway to AWS Lambda where functions in Javascript and python retrieve, store, and validate documents in AWS DynamoDB. DevOps: server support for AWS EC2 server park. Data transformations using XSLT and middleware tools like OpenText Biz Mapper for day-to-day sales communication and data integration between in-house ERP (MS SQL Server) and formats prescribed by remote communication partners: XML, EDI, EDIFACT, X12, JSON, CSV. Requires data analysis using SQL. Website development using HTML/CSS/JS (Javascript) to help coworkers work from home: allow access tools & documents & shared drives, using AWS S3, AWS Lambda, API Gateway for auto-scaled & auto-provisioned serverless hardware platforms, Jscript, HTA. I designed UX (User Experience), GUI (Graphical User Interface), and wrote documentation.

Senior Software Engineer

Redgrave Research•  September 2021 - Present

Prodject LAMMPster: Reducing the amount of time needed to create posters, flyers, and social media posts about missing persons. Using a combination of python and SVG templates to produce output in PDF, PNG, and publish directly to a predefined list of social media accounts. The data is stored in a Google Sheets spreadsheet.

Founder

Treasure Trove Studio•  August 2020 - Present

Currently creating a children’s video game based on my own children’s ideas and designs. Programming using the haskell functional programming language, available as FOSS (free and open software) for unix, linux, macos, and ms windows, here: https://sr.ht/~aev/maskies I write the story lines, compose the music, produce digital assets and imagery, conduct testing sessions, produce let’s play videos. Release as a high-scale web-based game is in the planning. Graphical interfaces (GUI) are created using SVG, HTML, JS, CSS, and HTML Canvas.

Senior Software Engineer

Redgrave Research•  November 2020 - July 2021

Project Ged2Dendro: Reduced the amount of time needed by genealogy researchers and artists to remove sensitive private data from genealogical ancestral information, filter ancestry trees, and produce diagrams suited for public presentations and forensic (police) research. Programmed using the haskell functional programming language and XSLT, available as FOSS (free and open software) for unix, linux, macos, and ms windows, here: https://sr.ht/~aev/ged2dendro/

Senior Software Engineer

Detacom / Lectric / Colors•  May 1999 - May 2012

Helping customers achieve their goals by developing and selling custom software. The company hired me straight out of college, got bought up several years later, and then the new company changed it name. My responsibilities: - Functional Designs (Axure), - Technical Designs (Microsoft Office, Word), - User Manuals (Microsoft Office, Publisher, Powerpoint), - Best Practices, - Coding Guidelines, - Information Security Implementation and Legal Compliance, - Data Breach Prevention and Pentesting, - Privacy Protection for customers of our customers, - Visual Design (Adobe Photoshop, Inkscape), - User Experience Design (UX, Visio, Axure), - User Interface Design (UI, GUI, Visio, Adobe Photoshop, Inkscape), - Usability Consultancy and Legal Compliance, - Diagramming and prototyping (Visio), - Content strategy, - SEO (search engine optimization, Google), - Conducting interviews and workshops (Powerpoint), - Coaching and educating of customers and coworkers, - Quality Assurance (automated and manual testing), - Multimedia production (audio, video, tutorials, walk-throughs), - Software programming (VB, VBA, VB.Net, VBScript, Javascript, MS-Dos Batch, - C#, local, client/server, distributed, Access, Excel), - Database modeling (Microsoft SQL Server, Oracle, MongoDb, MySQL), - Database and software performance tuning, database load balancing, data sharding, - Hardware provisioning (Microsoft Windows Server), - Software installations on Microsoft Windows , - On-site customer support, - Remote customer support, - Web site programming (HTML, CSS, Javascript/JS, XML, XSLT, PHP, Sitecore CMS, Smartsite CMS), - Data integration (client/server), - Data transformation (ETL, SQL, T-SQL, PL/SQL), - Technical team management, - Project management (agile and waterfall).

Leeuwenborgh Opleidingen, Maastricht

Software Engineering, B.Tech•  August 1998 - July 1999

High-speed vocational government-approved education geared to placing people into a job fast. A boot-camp, if you will, cramming 4 years of study into 1. Highly technical, focusing on practical engineering knowledge and skill.

University of Maastricht

Data Science, BS•  August 1993 - July 1998

HackerRank does not allow me to enter the actual program in which I was enrolled. Yes, I did do data science there, too. But that was but a small part, to be able to conduct statistically significant reseach and surveys. I also learned psychology, history, anthropology, comparitive culture studies, English for academics and business communication, politics, political and cultural systems, and more.