John P. Email & Phone Number

Alpharetta, Georgia, United States

• Facilitated the adoption of a standardized development environment, ensuring consistency and mitigating errors arising from disparate setups.• Develop and maintain pages for an in-house project administration site.• Utilize Python Flask, Django, and Jinja templates to create a robust and user-friendly web application.• Generate reports using Pandas and SQLAlchemy, providing valuable insights to stakeholders.• Incorporate Plotly to visualize data in an interactive and visually appealing manner.• Implemented MySQL as the database backend for efficient data storage and retrieval.• Leverage JavaScript, including jQuery, to enhance the front-end functionality and user experience.• Created Windows console application to automate generation of PowerPoint presentations using C#, thus significantly reducing overhead for Design team.• Converted Mercurial repo to Git in a manner that retained revision history, including mapping Mercurial sub-repos to Git sub-modules. Configured on-prem Git forge air-gapped from public internet on Arch Linux.• Implemented web-based XMPP client to monitor and manage in-house high-performance compute render farm.

Atlanta Metropolitan Area

Create and document Google Cloud Functions in Python, frontend and backend solutions in PHP and JavaScript (HTML5 and CSS3), and design and manage data structures, functions, and stored procedures in MySQL. Performed integration testing in legacy PHP and JavaScript codebase.Mentored more junior developers and otherwise oversaw transition to new management team.Regularly deployed codebase to Google Cloud Platform managed instance groups.Integrated Google Maps API for address verification in order to reduce lost or returned shipments. Created executable installer to help newly hired developers set up Node and Grunt.JS.Created dynamic XML file for Google Merchant Center product reviews.

Decatur, Georgia

Created Chrome extension to provide customized markup to web-based shop management application (Shop-Ware)

Duluth, Georgia

Use SQL Server and SSIS to develop multi-step procedure to determine delegation of authority for DocuSign recipients based on organizational hierarchy.

Greater Atlanta Area

• Maintained rating system in AS400 using DB2 for iSeries, Visual Basic for Applications, and Microsoft T-SQL / SQL Server.• Developed SSIS packages to share data between SQL Server RDBMS and AS400.• Identified several methods to maximize warehousing efficiency--saving gigabytes of redundant data and shaving time off dependent stored procedures.• Developed applications in VB to convert nested data files into flat files for intake into ERP.• Liaised with ops, claims, business processing support, and other departments outside of IT to determine business needs and develop appropriate solutions.• Created ad hoc reports, queries, procedures, etc. as needed based on requirements outlined in daily stand-ups, and from Kanban-based ticketing systems (ZenDesk, Kace, Atlassian, Jira).• Participated in Agile and Waterfall SDLC.

Maintained electronic parts catalog using OEM data from more than 30 tier one automotive brands including Volvo Cars, BMW Motorrad, Subaru, Toyota, VW, and Audi.Developed SQL scripts, functions, and procedures using Microsoft T-SQL in SQL Server Management Studio.Developed applications in VB to automate ETL tasks and data mapping.Created SSIS executable packages and developed scripts to streamline and automate daily, weekly, and monthly tasks.

Atlanta

First point of contact for clients who needed calm and knowledgeable reassurance that their car would once again be operating safely and reliably.

Decatur, Ga

I was able to gain further exposure to the particular service needs of Swedish, Japanese, and German autos in an up-and-coming yet state-of-the-art environment.

Sausalito, Ca

I was able to migrate the customer database from an outmoded and pre-standardized shop management program to one of the most powerful in the industry. From there I was able to implement a shopwide computer network for technicians, and I created a successful direct-mail remarketing campaign.My favorite part about the position at A&A was that when I would ask the owner for his opinion on how I should proceed, he would say "I trust your judgement. Do what you think is best."