Patrick Kellogg Email & Phone Number

New York, Ny, Us

New York, Ny, Us

* Created ETL data pipelines to handle client files securely* Python, UNIX shell, and embedded SQL scripts for automating file manipulation* Handling trouble tickets in the Data Support queue and creating new data pipelines* Loading data files to MS SQL Server and Oracle databases and HDFS and Impala* Secure management, storage, and transmission of data files (plus PGP/SSH keys)* MS SQL Server and Oracle DBA, and disk management, backups, user permissions* SQL query tuning, troubleshooting, and job scheduling* Communicating with client personnel for data transfer setups and troubleshooting* Sent data to HDFS Apache Hadoop, AWS, and Databricks

Salt Lake City, Ut, Us

Subject matter expert (SME) for online university. Helped develop curriculum for a new class on "Advanced SQL". Wrote test questions, performed QA, and defined competencies and lesson objectives.

Miscellaneous personal projects, volunteering, and continuing education:UBS AG 1/2011 - 8/2011Converted Excel spreadsheets into MATLAB code through Park Hudson. Pushed for solid computer engineering by introducing backups, version control, and automated testing for MATLAB code.Barton Solvents Inc. 4/2017 - presentCurrently serving on the board of directors for a family-run chemical distribution company based in Des Moines, Iowa.NYCDA (New York Code + Design Academy) 9/2018 - 11/201814-week intensive programming class for software engineering and web development. Topics covered included JavaScript, Ruby, React/Redux, HTML, CSS, Ajax, and Python.General Assembly 3/2015 - 9/2015Six-month class in data science at a NY programming bootcamp. Did final project on "Classification Using Genetic Programming"Apex Technical School 6/2012 - 5/2013Year-long class to receive electrician certificate. Studied basic home wiring, fire and security systems, motor control, and power distribution. Interested in new LED technologies, Arduino and other embedded processors, and theatrical lighting.Volunteering work 1/2011 - presentWired local farms and performed pro bono electrical work for a community theater. Created websites for a community group (using SquareSpace), a Nepal GMO (using WordPress), and another Fiji LGBT civil rights group (again in WordPress).

Bethesda, Md, Us

Several projects as a defense contractor:* Designed and installed systems with high security concerns. Created cloud computing solution using VMWare and NetCool monitoring software to a Remedy database. Wrote and implemented test plans. Managed schedule, with high visibility and communication. Communicated with the client, and traveled up to 25% for implementation and training.* Led multi-segment test activities, and monitored a dozen smaller development projects for the government. Built schedules and tracked status. Organized a team of test engineers, arranging travel and billable costs. Created and documented workflow processes for new program. Created workflow to manage, track, and respond to change documents. In charge of writing test plans and procedures and managing test configurations at several data sites worldwide.* Wrote complex scheduling algorithm in Java to an Oracle / JDBC database. Updated and maintained Rational Rose models, and synchronized architecture with government planning.* Digital signal processing and algorithm work for a government contract. Worked on a highly complex large-scale system as a senior computer systems design engineer to analyze performance metrics and evaluate datasets. Data was extracted from the network using Perl, and sent to a MySQL database. Wrote new tools in C, C++, Java, MATLAB, Visual Basic, and shell scripting to analyze and present the data. Tested, maintained, and extended existing code.

Scientific computing for the University of Colorado Health Sciences Center. Analyzed medical data on hypoxia (high altitude sickness). Created medical software in VB.NET to collect biometric data, and presented streaming real-time data flow for researchers.Tools used: MATLAB, Microsoft VB.NET

Created personal company to provide computer consulting services for the Denver and Boulder area, specializing in mathematical programming featuring MATLAB, combined with rapid application development in Java, Microsoft Visual Basic, and C/C++.

Fort Collins, Co, Us

Wrote genetic algorithms to track mad cow disease for the meat processing industry. Wrote Java tools to manipulate data scanned from cattle retinas. Created machine learning solution to find closest match from a large solution space. Performed statistical calculations to compare theoretical and experimental data.Tools used: Java, Sun Netbeans, RedHat Linux, Swing, MySQL

Englewood, Co, Us

Provided financial computing for a nationwide mortgage company. Refactored and maintained several existing DOS and Btrieve programs, and wrote several new ones using Visual C++, Visual Basic, and C# (all with .NET), saved to a SQL Server database.Tools used: Microsoft Visual C / C++ / C#, Microsoft Visual Basic, Btrieve, MSNQ, Microsoft .NET framework, COM+, and Microsoft Access and SQL Server.

Worked for the Earthquake Hazards Program at the United States Geological Survey. Wrote an interface in C and C++ to interface MATLAB to legacy code. Wrote Visual C++ GUI for real-time earthquake detection and damage modeling.Tools used: Perl, CGI, Apache server, Solaris, Linux, IDL, C, C++, MATLAB.

Shelter Island, Ny, Us

Book contract to write "Data Structures and Algorithms for the Accidental Programmer", a technical book on the foundations of computer science, including code examples in C++, Java, and Perl.Tools used: C++, Java, Perl, Microsoft Word, CorelDraw, Adobe Acrobat, Photoshop.

Worked for a start-up from the Santa Fe Institute, a prestigious research based in New Mexico. Developed a program for analyzing professional project management (PPM) decisions using MATLAB and constrained multi-objective genetic algorithms (CMOGAs). Wrote Java to display data and allow users to configure software over the web. Performed server installation and ASP and html webpage development.Tools used:Microsoft Visual Basic, Java, AWT, Btrieve, SQL Server, COM+, HTML, ASP.

Taught undergraduate class on "Software Tools and Methods" to the illustrate the entire programming cycle from design to distribution. Covered everything from use cases, design documents, eXtreme programming, Agile methodologies, Validation Verification & Testing, version control software, and system administration. Wrote labs involving fun games such as poker and "the prisoner's dilemma". Taught students to code in C and C++, Java, Python, Perl, UNIX shell scripting, PHP, and XML. Wrote lesson plans, administered midterm and final exams, graded papers, and helped with other homework assignments. Also worked on miscellaneous tasks for the department, including helping with other professors' research, and organizing equipment for events, including the annual "NIPS" conference on neural network computing and reinforcement learning. Organized charity functions on campus.Tools used: HP/UX, RedHat Linux, C, C++, Perl, MATLAB, Java, Python, PHP, XML, Neural Networks and Genetic Algorithms, Latent Semantic Analysis

Summer internship at USWest Wireless (now Qwest Wireless) in the Tools Development Group. Wrote several Windows tools using MATLAB and Visual Basic for telecommunications and radio frequency engineers and staff. Studied mobile radio communications and cellular telecommunication theory.Tools used: MATLAB, Microsoft Visual Basic, Microsoft Access, Sun Solaris UNIX

National Science Foundation grant to provide web access to various scientific databases of heliospatial and atmospheric data. Used HTML, Perl, and Java to create front-end web pages for data. Developed full client-server solution using CORBA to provide better data mining and user-created queries of real-time data. Other jobs included writing scientific papers, close communication with the user community, design and maintenance of web pages, business travel, and organization of yearly "CEDAR" scientific conference.Tools used: Java, Perl, HTML, CORBA, MySQL, Microsoft Access, Sun Solaris UNIX.

Copper Mountain, Colorado, Us

Led a team of developers to design and build a ticket tracking system for this Colorado ski resort. Worked both at consulting firm and client site.Tools used: Microsoft Visual Basic 3.0, Microsoft Access

Moved with several friends and co-workers to a small Denver-based minority-owned consulting firm. Helped with hiring and promotion of employees. Wrote papers on new technology as founder of research and development group. Gave lectures on Microsoft Visual Basic and Java to promote new technology, rapid application development (RAD), and code reuse.Tools used: Microsoft Office, Microsoft Visual Basic 3.0, Java

Part of a large programming team to write a comprehensive accounting system. Wrote front-end in Visual Basic, with a middle layer in C++, going to an Oracle repository. Helped install and deploy software, and analyzed the site architecture. At the time, this was the largest Visual Basic project ever completed by an American company.Tools used: Microsoft Visual C++, Microsoft Visual Basic 3.0, Oracle.

Helped write code and set up a telephone network to answer 911 calls.Tools used: Microsoft Visual Basic 3.0, ODBC, telephony.

Raleigh, North Carolina, Us

Worked for now-defunct PC distribution company, writing a Microsoft Visual Basic on-line ordering system for retail outlets.Tools used: Microsoft Visual Basic 3.0, Microsoft Office, EDI, OLE/DDE, telephony.

Denver, Co, Us

Worked with accounting staff for "per unit" cost analysis. Performed network analysis and documentation.Tools used: Visio, Microsoft Visual Basic, Microsoft Excel, Microsoft Word

Worked for Boston-based consulting firm, first as a sub-contractor and later as a full employee. Wrote several proposals and worked with hiring staff to interview prospective employees. Wrote introductory training manual to promote new Visual Basic language. Evaluated and helped install new phone system.Tools used: Microsoft Excel, Microsoft Word, Microsoft Access, Microsoft Visual Basic 3.0, ROLM phone system

Wrote C code for medical CD-ROM database. Wrote drivers to access database using Btrieve. Started new interface using Oracle and Microsoft Visual C++. Debugged and commented existing code, and wrote documentation.Tools used: Microsoft C, Microsoft Visual C++, Btrieve database, oscilloscopes, CD-ROM "red book" standard

Wrote miscellaneous applications using Microsoft Visual Basic and Visual Basic for Applications (VBA). Created interface from HP 9000 platform to various PC formats, including Microsoft Word, PostScript, and scripting language for embroidery machines. Wrote other time-tracking and management tools in Visual Basic. Helped install mainframe-to-PC LAN interface.Tools used: Microsoft Visual Basic, Microsoft Visual Basic for Applications (VBA), PostScript, scripting for embroidery machines, Microsoft Office

Wrote Microsoft Visual Basic demo as part of proposal to a new client. Demo was so successful, it led to a long-term contract to develop front-end GUI and Microsoft Access database back-ends for online telephone check ordering system. Interfaced with phone pool, caller ID, and credit card authorization systems. I managed several other people, including DBAs and VB programmers. At the time, I lived in Boulder, Colorado, but commuted 1 1/2 hours each way to client site in Colorado Springs.Tools used: Microsoft Visual Basic, Microsoft Access, telephony

Worked as database analyst (DBA) for Colorado power utility for large-scale DB2 and COBOL system. Worked closely with Arthur Andersen consultants on database configuration and optimization on IBM AS/400 systems. Performed daily maintenance and documented database structure.Tools used: DB2, PL/SQL, COBOL, JCL, AS/400

Consulting sub-contract with Keane and Associates for Denver-area medical administration firm. Wrote C code for billing and tracking system. Debugged and commented existing code and created documentation with custom "Matrix" software I wrote in C.Tools used: HP 9000 UNIX platform, GNU C compiler, WordPerfect, Informix/SQL

Senior project in biomedicine in association with the Mayo Clinic. Worked with graduate students in the biomaterials department to build an electronic instrument to measure tooth stress and strain. Used mathematical programs to plot and analyze the results.

Electrical engineering internship for credit-card manufacturing company. Tested parts and built prototype machines for testing. Read parts catalogs and specifications. Designed hand-held test instrument using embedded controls. Moved test instrument into small-run production. Created budget and timetable. Tested and oversaw production line.Tools used: HP spectrum analyzers, oscilloscopes, wiring and soldering, embedded controls, ORCAD, SPICE, Microsoft Assembler, 68000 Assembler, Microsoft C, Excel.

Master'S Degree, Computer Science

Bachelor'S Degree, Electrical And Electronics Engineering

Certificate, Electrician

Software Engineering, Web Development