John Simpson Email & Phone Number

Statesville, Nc, Us

Houston, Tx, Us

·Translating legacy Perl code to Python. ·Translations included custom utilities such as file copy, file move, send email, extract SQL to CSV, and associated library functions. ·Wrote various bash scripts, Python, and Flask to automate interactions with Vault by HashiCorp. ·Various interactions with AutoSys via Linux command line as needed.·Spearheaded the migration of a complex Perl codebase to Python and revamped a J2EE application using Flask and JavaScript, leading the re-architecture of the system to enhance maintainability and performance.·Designed and developed a dynamic Flask-based web application, integrating Oracle packaged functions and implementing metadata-driven page generation via JSON files stored on the server.·Led the integration of Python code with downstream systems, ensuring robust data extraction and seamless integration with external systems.·Utilized EasyUI jQuery library to design interactive and user-friendly front-end pages, allowing for drill-down functionality and search capabilities directly from the web interface.·Consolidated separate drill-down queries into a unified query using hierarchy SQL, optimizing data retrieval and display.·Used JSON for front/back data xfer, including table definitions and view configurations, to ensure seamless data handling and processing. Removed any xfer of SQL.·Modified existing logging tools to include colorized log output and enhanced multiline object/SQL query logging, improving debugging efficiency.·Established a test suite with full multiprocessor support, reducing test suite runtime for large codebases from multiple hours to less than 15 minutes.·Enabled programmatically generated menus from JSON.·Implemented a centralized URL handler for main views, separate from simple pages, such as MAIN, ABOUT, and HELP.·Set up and maintained the deployment of the application using Gunicorn / Waitress.·Environment: Perl, Python, Bash, SQL – Red Hat, Windows.

Hanover, Md, Us

All info listed under ICON Consultants. Transitioned contracting agencies but continued with same client and projects.

Pittsburgh, Pennsylvania, Us

· Wrote code to extract data from Pega blobs. · Wrote various SQL statements for data exploration, finding edge cases for use in testing purposes. · Assisted other developers with onboarding and familiarizing themselves with the applications.· Developed migration scripts for moving PostgreSQL database data and applications from host to host.· Using Python3 with Django and Pandas to develop back-end API’s for retrieving data from multiple SQL data sources, including PostgreSQL, Oracle, Pega, DB2, Denodo, and Teradata databases. · Also working with Python3, Django and JavaScript with Data tables for front end web-based application development. · Created management scripts in Bash for starting, stopping ,and getting the status of front end and backend applications for multiple deployments.· Created migration scripts for moving PostgreSQL database data and applications from host to host.· Environment: Python 3.9, JavaScript, Bash, SQL – Red Hat, Windows.

Pittsburgh, Pa, Us

· At HMHS, written a few command line utilities in Python. · One reads configuration data from an Excel spreadsheet and uses that data to set up users, routing tables, and subscriptions in an Axway Secure Transport system by means of its API. · A second utility uses recursion to copy complex route templates from one Axway ST system to another. · For this one also added a simple GUI interface. · A third utility enables automatic creation of multiple directory hierarchies utilizing a proprietary web interface.· Writing Python code to read Excel spreadsheets and use that data to configure an AxWay Secure Transport system via the AxWay API using the Python openpyql, Json, and requests libraries. · Additionally, created a Python library to ease use of colored text in log output using the 256-color palette in terminals using ANSI escape sequences. · Ensured code was compatible with Python2 and Python3 on Linux and Windows.· Environment: Python2, Python3 – Red Hat, Windows.

San Francisco, California, Us

· At Wells Fargo, we have an agent that is installed on all database servers. This includes Oracle, Informix, Sybase, SQL Server, and several more. · The agent communicates with a central server at regular intervals and checks to see if any work has been requested, such as running downloadable plugins, and then carries out that work. · The agent is in Perl and runs on HP-UX, Solaris, AIX, Linux, and Windows. · The primary plugins are for inventory collection and compliance verification. · In addition to maintaining the code base to keep up with changing standards, I have translated the agent to both Python and Java.· Debugging, enhancing, and testing CGI based Perl code for a proprietary program that tracks inventory and compliance for multiple database management systems (Oracle, Informix, Sybase, SQL Server, and more). · Upgrading PHP generated web pages from ExtJS version 4 to ExtJS version 5. · Various work with curl and PowerShell. · Using subversion and git for version control, Windows batch files. · Translated Perl code to Python, and also to Java, moderate SQL usage.· Environment: Perl, Java, Python, Bash, Korn, PHP, JavaScript, PowerShell, SQL – HP-UX, Solaris, AIX, Red Hat, Windows.

Responsible for debugging, enhancing, and testing PERL code for a Satellite based WiFi system for aircraft. Primary work was with PERL on Mandriva Linux. Using Bugzilla and Confluence for collaboration. Using AccuRev for version control. Including setup of Redhat and Fedora virtual machines. Participation in regular peer code reviews.

St Paul, Mn, Us

Responsible for development in PERL focusing on regular expressions to remove personally identifying information from medical records. Updated XML configuration files as needed. Used JIRA ticketing system. SVN for version control.

Responsible for development of web based inventory mangagement system using MVC practices. Backend programming using MySQL and PERL on a Debian Server. Frontend programming using JavaScipt, CSS, HTML, and jQuery. System imports inventory data from Excel spreadsheets, and gives operators the ability to make mass changes to the inventory before transferring to OpenCart.

Responsible for system security with firewalling tools such as iptables. Development of tools via procmail with qmail and sendmail to automate custom administration of mailman traffic. Implementation of Google captch via PERL. Frequency control of advertisement banner display via PERL. Various maintenance scripts via bash, utilizing sed, awk, and various other tools.

Responsible for research, design, development, integration, technical support, troubleshooting and maintenance of workflow engines, document management systems, and internal project management/tracking systems. Position includes system administration, network administration, network security, installation and setup of new hardware, troubleshooting and maintenance of existing hardware. Implemented an SSL Java applet/servlet file transfer module for integration of Aviator’s web-enabled document management system with Adobe Acrobat.

Burlington, Massachusetts, Us

Responsible for development of new applications and enhancements to existing applications in Lotus Notes. Applications focused on providing documented procedures assuring ISO-9000 compliance. Position included management of research and development as well as internal and second level technical support. Provided training for new software developers. Traveled to the Middle East to provide training for a newly established office.

Responsible for hardware assembly, testing, troubleshooting, and repair. Programmed micro-controllers to interface on-board components with host processor; coordinating engineering and development of firmware and hardware. Developed device drivers to interface with hardware providing functionality to the host PC. Developed test-stand and demonstration software. Provided technical support for customers and demonstrated products for potential customers at trade shows.

Randolph Afb, Tx, Us

Responsible for troubleshooting and repair of complex computer systems and networks including specialized hardware devices. Hand selected to be Small Computer Manager on Commander’s Staff to maintain personal computers throughout the squadron and to provide technical support for computer operators. Additional duties included installation, maintenance and administration of a local area network supporting 380 users.