John W. Brooking Westbrook, Maine, USA

MISSION: To make a positive contribution to my little corner of the world, through the use of computing technology, while supporting my family.

Knowledge

Business Intelligence Informatica, SAP Business Objects, Microstrategy
Databases MS SQL Server, Oracle, MySQL
Web/User Interface Microsoft .Net (VB and C#), PHP, Classic ASP, Perl, Java, Cold Fusion, HTML, CSS, Javascript, XML/XSL, C, C++

Experience

1999 - present
Developer/Web Developer/Sr. Business Analyst
Sappi Fine Paper
Portland, Maine

Skills Utilized: Informatica, SAP Business Objects, Microstrategy, Oracle SQL & PL/SQL, MS SQL Server, MS Access, SAP, MS .Net, HTML, CSS, JavaScript, ASP, Cold Fusion

Began as HR/Payroll on-call support, developing new screen interfaces and reports for HR/Payroll personnel.

Moved to Application Development: Developed intranet applications in ASP/VBScript, XML/XSL, and supporting packages for internet and intranet sites, using knowledge of Java and Cold Fusion. Acquired thorough knowledge and best practices for core web programming technologies -- HTML, CSS, and JavaScript.

In 2004 all application developer positions were converted to business analyst roles, supporting sales and customer support with custom applications and reporting, including use of SAP, Informatica, and SAP Business Objects. Team moved heavily into Business Intelligence and Data Warehousing space, resulting in experience designing star-schema data warehouses, development of Extract/Transform/Load (ETL) jobs using Informatica, and build-out and maintenance of BI-based end user reporting environments Microtrategy and SAP Business Objects.


1997 - 1999
Applications Programmer
Wright Express
Portland, Maine

Skills Utilized: Oracle PL/SQL, Oracle Power Objects and Developer 2000, SQR

As primary PC applications developer, created applications for internal customer service use. Helped to convert portion of primary reporting product from Tandem mainframe to Unix/Oracle environment, with reporting and processing in SQR.


1996 - 1997
Contract Programmer
Quantum Consulting
Cleveland, Ohio

Skills Utilized: Visual Basic, MS Access

Assisted with development of large database application (100-200 tables, 20-30 screens) for legal client.


1993 - 1996
Consultant
Cap Gemini America
Cleveland, Ohio

Skills Utilized: Visual Basic, MS Access, SQL, C

On staff of major national consulting firm. Various client projects.


1991 - 1993
Programmer
Raleigh Systems
Cleveland, Ohio

Skills Utilized: C++, SQL

Assisted with development of a medical billing application, as well as a general C++ code library for OS/2.

Education

Bachelor's Degree, Computer Science Oberlin College, Oberlin, Ohio, 1990
  
Self-Education and Development I am continually acquiring new technical knowledge both within and independent of my paying job. I initially learned HTML and JavaScript as a volunteer web site author for several non-profits (for whom I continue in that capacity), spent two years working on a Perl-based content management system, and subsequently worked heavily with PHP and mySQL. Earlier, I wrote a mailing list database system incorporating householding and similar-first-name recognition, which was used by three non-profit clients.

Personal

I enjoy reading and music; I play both the piano and trombone fairly well, and have even taken a few lessons on the pipe organ. I have served several non-profits as volunteer webmaster, as well as taking on paying independent projects. I have been a year-round bicycle commuter since the summer of 2002, and have become heavily involved in bicycle education and advocacy, for which I hold several bicycle safety education certifications, serve on the board of the Bicycle Coalition of Maine, and participate in a variety of formal and informal committees and activities locally. I am married and have two pre-teen sons. As you might imagine, with all of this, I don't watch much television.