Joseph T. Pepersack
Principal Systems Architect
Summary
- A creative hands-on leader with over 20 years experience, exceptional technical skills, and a business-focused outlook
- Background in both software development and systems operations, spanning diverse industries, gives an unique perspective on
how to create and deploy highly scalable, reliable, and secure systems that deliver a positive return on investment
- Extensive career commitment to staff development and team building through mentoring, teaching, and knowledge transfer
- Open to permanent leadership positions as well as long and short term consulting opportunities
Key Accomplishments
Leadership
- Led effort to migrate a hosted application to a cloud-based architecture, to achieve projected 90% cost savings while increasing scalability and reliability
- Taught web development courses in a formal classroom setting
- Lead database designer for AIMPages.com, AOL Member Directory 2.0, and the tagging & commenting infrastructure used by multiple AOL properties
- Lead database designer for Benelogic, a web-based benefits enrollment system
- Led a team that created a web-based interface to an existing Data Warehouse
- Led a team that created a workflow system which improved productivity by 250%
Software Engineering
- Developed prototype ERP application using Amazon Web Services, Perl, and Hadoop
- Developed tools to generate XML sitemaps for millions of user-created web pages
- Developed ETL, administrative, and reporting tools in Perl, C, and Unix Shell
- Extended and maintained AOL's "master control" system for systems operations
- Wrote and tuned stored procedures for Sybase, MS-SQL, MySQL and Postgres
- Designed generic security and authentication module for web-based applications
- Developed client-server applications using C and DB-Lib/CT-Lib
Systems Operations
- Administered 50+ replicated Sybase, MS-SQL, Postgres, and MySQL servers supporting the AOL.com portal site as well as other AOL branded properties
- Architected database clusters based on analysis of projected and actual loads
- Administered 25+ multi-terabyte databases supporting ENTREZ and PubMed, the world's largest public repositories of genomic data and medical journal abstracts
- Sole administrator for a computer-based training site serving 200,000+ employees
Proficiencies
General
- Cloud Computing (AWS/E2C)
- Scalability Engineering
- Capacity Planning
- Data & Application Modeling
- Database Administration
Languages
- Perl (Mason, DBI, mod_perl)
- SQL (all major dialects)
- Unix Shell (bash, csh, awk)
- [X]HTML, CSS, JavaScript
- XML and XSLT
- C
- PHP
- Java (dated)
Databases
- Hadoop / MapReduce
- Sybase ASE and ASA
- Sybase Replication Server
- Microsoft SQL Server
- MySQL
- Postgres
- Oracle (dated)
Clients and Employers
- Guest|Metrics Principal Systems Architect
- Boston University - CDIA Instructor
- America Online Sr. Systems Engineer, Sr. DBA
- National Library of Medicine - NCBI Sr. Sybase DBA
- Benelogic Sr. Database Architect
- Verizon Communications Sr. Software Engineer
- Small Business Administration Sr. Database Architect
- Maryland Insurance Administration Lead DBA
- Los Alamos National Laboratory Sr. Programmer / Analyst
- United States Air Force Programmer / Analyst, Software Tester
Education
University of New Mexico
Computer Engineering
8/1993 - 5/1995
C.C. of the Air Force
Computer Science
10/1989 - 2/1993
Other Skills
Photographer
Portfolio available on request