John M. Williams Email & Phone Number

Reston, Va, Us

o Project: EDS (2022 – Present). • Position: Database Architect / Solution Architect• Description of Duties: Implementing architecture and development for Web3 SAAS platform relating to ESG and sustainability, carbon footprint calculations, and carbon credits within Azure cloud environment with Ethereum/Polygon & Cardano blockchain integrations.• Technologies Used: Azure Cloud, Databricks, Data Factory, Data Lake, Power BI, Cosmos DB, SQL Server, MySQL, Python, AWS, EC2, Linux, ETL, Pentaho, PHP, React, Javascipt, MongoDB, Ethereum/Polygon, Solidity, Cardano, Haskell, and DevOps tools (GitHub, Jenkins, Jira, Docker, Kubernetes).o Customer: PNM-OHIO (2021-2022)• Position: Database Architect / Technical Lead• Description of Duties: Lead deployment of technical solutions associated with the support of a .NET technical stack with SQL Server DB in AWS cloud. Implemented full-stack system performance and security monitoring using AppDynamics, Contrast, WebLOAD, and J-Meter. Implemented DevOps automation using Jenkins, Git, and Jira.• Technologies Used: AWS, Javascript, .NET, #C, RESTful API, JSON, SQL Server, Windows Server, Jira, Git, Jenkins, IBM MQ, AppDynamics, Splunk, WebLOAD, MS Sharepoint, MS Visual Studio, and MS Teams.o Project: EDS (2020). • Position: Database Architect / Solution Architect• Description of Duties: Implementing architecture and development for Web3 SAAS platform relating to ESG and sustainability, carbon footprint calculations, and carbon credits within Azure cloud environment with Ethereum/Polygon & Cardano blockchain integrations.• Technologies Used: Azure Cloud, Databricks, Data Factory, Data Lake, Power BI, Cosmos DB, SQL Server, MySQL, Python, AWS, Glue, Linux, ETL, Pentaho, PHP, React, Javascipt, MongoDB, Ethereum/Polygon, Solidity, Cardano, Haskell, and DevOps tools (Git, Jenkins, Jira, Bitbucket, JMeter, Docker, Kubernetes, and Maven).

o Customer: NeoSystems, Inc. (2020). • Position: Lead Database Architect• Description of Duties: Designed and implemented various data pipelines – integrating with Workday Adaptive Planning, Salesforce, Paycom, Deltek Costpoint using the Pentaho ETL platform in Azure cloud.• Technologies Used: SQL Server, JavaScript, Linux, Java, Pentaho, RESTful API, JSON, Eclipse, XML, Workday, and Visual Studio Code.o Customer: Government Accountability Office, GAO (2019). • Position: Web Development Manager/Architect• Description of Duties: Lead a team of 28 software developers, designers, and data analysts responsible for maintaining all of GAO’s 72 mission critical web applications – within a hybrid AWS cloud infrastructure.• Technologies Used: Java, Javascript, Angular, React, Git/GitLab, PHP, Cold Fusion, Oracle, XML, MySQL, AWS, SAS, Pentaho, Tableau, Eclipse, Jenkins, Selenium, Nexus, Docker, Zap, Openshift, Kubernetes, JUnit, Maven, SonarQube, Zap, TwistLock, Jira, Confluence, and MS Project.o Customer: Internal Revenue Service (IRS) - Enterprise Networks (2008-2019)• Position: Software Architect / Data Scientist / Project Manager• Description of Duties: Deployed custom software solutions for the IRS Enterprise Networks organization.• Technologies Used: Java, JavaScript, SQL Server, ASP.NET, #C, xPath, XSLT, JQuery, AJAX, XML, Windows Server, IIS, SharePoint Server, Sharepoint Designer, SSIS, Pentaho ETL, PowerShell, Informatica Power Center ETL, Python, R, R Studio, Anaconda, Jupyter Notebook, Visual Studio IDE, Eclipse IDE, Oracle DB, PostgreSQL, Apache, Databricks, Spark, Hadoop, Splunk, Cold Fusion Server, MS Visio, MS Project, MS Report Server, xMatters, Derdack, HP Network Node Manager, HP Operations Manager, HP Operations Orchestra Flow Development, HP Network Automation, AWS, Azure, PHP, Angular, React, Python, Anaconda, Jupyter Notebook, Apache, R, R Studio, Apache Spark, MySQL, Mongo, Drupal, Wordpress, Jira, Backlog, and MS Project.

Springfield, Va, Us

Enterprise Web Portal Project: Lead the development of the first web portal within DARPA that was used for tracking budget and progress of on-going DAPRA projects, automated budget approval process with a complete web-based workflow, replacing inefficient paper-based process. Web portal contained Dashboards and Graphs to help Project Managers, Analysts, and Budgeting Staff visualize current health of projects and contained drill-down capabilities for deeper views and analysis. Integrated web portal with back-end budgeting system Momentum and used ETL for data aggregation. Performed ADHOC, special project data analysis and visualization using data science techniques and reported findings to upper management.• Technology Stack(s): ASP.NET, JavaScript, C#, VBScript, VB.NET, Python, SQL Server, Windows Server, IIS, SharePoint Server, XML, DTS, SSIS, TRIM, and Momentum.

Round Rock, Texas, Us

Worked with DoD client on developing customized web applications. Technologies used with this project are ASP, COM, VB, JavaScript, SQL Server 7.0/2000, XML, DTS, Windows2000 Server, IIS 5.0, and FTP.

Client: DOD (Army Nation Guard HQ/Strength Management). Charged as project lead and onsite web team manager of 8 developers/designers to maintain and develop new applications for the Army National Guard recruiting web site. URL: http://www.1800GoGuard.com and http://www.virtualarmory.com. Technologies: ASP, Javascript, Cold Fusion MX (CFC’s, Custom Tag Dev, etc.), Java, SQL Server 7.0/2000, iMail 6.0/8.0, Index Server, Windows2000 Server, IIS 5.0, Java-based Chat Server, FTP, and integration between numerous web applications. Also lead server migration from one co-location facility to another.

Client: U.S. Department of State - Charged with database administration, web application programming/development, eLogistics design, requirements analysis, and customer support for an employee relocation web application called WebMove. Technologies: SQL Server 7.0/2000, Windows NT Server, Cold Fusion 5.0/MX Programming, ASP (Active Server Pages) Programming, MS IIS, Cold Fusion Systems Implementation and Administration, MS DTS Package Setup, SSL/PKI Implementation, and Systems Security Configurations (Windows NT, SQL Server, Cold Fusion, IIS). URL is located on the non-public intranet at the U.S. State Department.

Menlo Park, Ca, Us

Client: TMGWeb. Primary role was web programmer/engineer on projects involving custom development of e-portal, e-commerce, e-publishing, and e-membership implementations. URLs include http://www.watsonwyatt.com (MyWatsonWyatt e-portal, e-commerce, and e-publishing) and http://www.nabt.org (e-membership and e-commerce). Technologies: ASP and Cold Fusion Development, SQL Server 7.0/2000, Windows NT/2000, networking implementation and migration, DNS, Cold Fusion Server Administration, and DMZ/Firewall configuration.

London, Gb

Developer on the GoFinancials project, a 100% ASP-delivered financial management system built upon the Lawson ERP data engine and Oracle 8.1. Technologies: LDAP, Perl, JavaScript, ASP, Cold Fusion, IBM AIX (Unix), and Oracle 8i. (URL: http://eyt.com).

Lead programmer/engineer for e-commerce startup initiative (URL is offline due to halt in operations). Technologies: ASP, Windows NT Server, SQL Server 7.0, CGI, and networking.

Dulles, Va, Us

Implemented company's financial system (Deltek Costpoint), Corporate Internet/Intranet Web Sites, and Timesheet Application. Also was company's network administrator/engineer. Technologies: Windows NT 4.0, SQL Server 7.0, Oracle 7.3.3, Sun Solaris (Unix), Nortel and Cisco router configuration, ASP, IIS 4.0, MS Exchange implementation and administration, and T1 implementation.

Us

Performed DBA and systems administration duties for Windows NT network, MS Exchange, MS SQL Server, and Flexi Financials. Technologies: SQL Server 6.5, Windows NT, MS Exchange, Flexi Financials, Crystal Reports, and FRx.