Menu

Patrick Peterson

Simplicity is the ultimate sophistication.

~ Leonardo da Vinci *

Highly skilled senior database programmer and data architect with over 20 years of experience in database design and development, systems integration, ETL processes, analytics, security, and reporting. Proficient in various technologies, I have a comprehensive understanding of nearly every aspect of running a business. My expertise enables me to deliver efficient, secure, and scalable database solutions that drive informed decision-making and operational success.




Overview


I started with COBOL mainframe programming (yes, including Y2K!) and after a couple of years switched rolls to IT Management. This helped provide a well-rounded skill set that transitioned well into consulting. As a consultant, I spent several years developing database solutions with a focus on custom reporting. After consulting, my focus was shifted to database applications development for larger companies like Univision, Inc. & Charles Schwab, Inc. At Univision and Univision Radio, I worked closely with executives and auditors, so report development remained a core responsibility.

For backend programming I am well versed in object oriented coding and design patterns. Expert with most common web programming languages such as PHP, Perl, Javascript, JSP, C# and others. I'm also a pretty good systems administrator. I am looking for a company where my diverse skillset and background will be utilized and provides a comfortable, fun working environment.

Make it as simple as possible, but not simpler.

~ Albert Einstein *

Projects


D Harris Tours, Inc.

dharristours.com

After a successful career in technology, I made the pivotal decision to return to my roots and take over the family charter bus company as my parents prepared for retirement. This transition not only allowed me to honor their legacy but also challenged me to wear many hats, primarily as the Operations Manager and Compliance Officer. In my role, I oversee the daily operations, ensuring that scheduling, logistics, and customer service run smoothly. One of my proudest achievements has been developing and implementing proprietary software tailored to our specific needs, which has streamlined operations and significantly improved efficiency. Understanding the importance of safety, I obtained my commercial driver’s license and a School Pupil Activity Bus (SPAB) certificate to be prepared for emergency situations. I prioritize creating a culture of safety within our team by developing comprehensive training programs for our drivers, reinforcing our commitment to excellence and accountability. As I navigate the complexities of running the business, I continuously implement cost-saving measures and process improvements, driving profitability and operational performance. Building strong relationships with clients and vendors has been essential in fostering business growth and ensuring our long-term sustainability. This journey has been both rewarding and challenging, allowing me to blend my passion for technology with my commitment to family and community.

Simple Software

simpsf.com

Simple Software was truly ahead of its time, and in many ways still is. We created a SaaS application that allows companies to build their own applications using simple web tools. You can setup your own secure workspace, load your csv data and have forms generated in less than 15 minutes. You can manage user access, use simple tools to create and update tables, generate and regenerate web forms, automate business processes, create your own reports, and so much more.

I really enjoyed working on this project and even though we ran out of funding, there are still companies using it to this day! I learned a lot, especially from our lead architect Mr. Robison, and it was interesting to see the various ways the application was used, including a charter bus company & a helpdesk solution for an IT department.

This short video gives a quick overview of the project. Or watch them all at youtube.com/user/SimpSF



Sanrio Online

I was contracted to build a new B2B website that gave wholesale customers the ability to order directly from Sanrio. The requirements were not only to build a shopping cart, but to encompass all of the business rules associated with an order and have it tie directly to their ERP. This included specific ordering rules for customers & salespersons, credit checks, special product offers, including prebook products. The data not only had to interface with Lawson, it also came from spreadsheets via email. This was a complicated project just from a data perspective.

Unfortunately, the project got off to a rough start after my business parter, a.k.a the lead web developer, decided to move to Ireland, 3 months into development. After a month of trying to perform my role as data architect, and take over as web developer, I made the decision to move from PHP/Apache to MVC/.NET. From the client's perspective we were starting over, but in reality we moved from an unpaved side street, to a modern highway and were quickly meeting our deadlines.

To be honest, the decision to change environments after 4 months of development was one of the biggest I've had to make in my career. While I could slowly reverse engineer the work already done in PHP, I had minimal to no experience with .NET development at that time. Luckily, I was managing the funding and client's expectations properly, so I hired a full-stack .NET engineer and spent the next 2 months on the biggest learning curve of my life. When the time came for the developer to take a permanent position elsewhere, I had no problem taking over as lead web developer. While I'm learning new techniques everyday and always expanding my knowledge, those 8 months were some of the most stressful and rewarding of my life.



Fatherhood

When I was 18 years old, I decided on a general template for my life. My 20's would be for education and playing; my 30's would be for traveling and advancing a career; my 40's would be for family. Every decade went according to plan and a few months after I turned 40, Eve was born.


Skills


database

  • SQL / Stored Procedures / Triggers
  • SSMS / Profiler / Replication
  • SSIS / SSRS
  • Data Modeling & Masking
  • Mysql / Mirroring
  • Oracle
  • BerkeleyDB
  • memcache
  • Cassandra/NoSQL

languages

  • T-SQL
  • PL/SQL
  • C#
  • PHP
  • Javascript
  • HTML 5 / SASS CSS3
  • IBM RPG
  • COBOL/CobolScript
  • FOCUS
  • Many others...

development

  • SDLC Principles
  • Agile PM
  • .NET / Visual Studio
  • MVC / EF / Repository Pattern
  • BASH
  • POWERSHELL/Batch
  • Business Objects
  • Tableau
  • SOAP
  • Perl
  • AJAX
  • jQuery / GULP
  • XML / JSON
  • Version Control: svn, cvs, git, VSS, etc.
  • Many others...

server

  • Windows / Unix / Linux / FreeBSD / VM
  • SQL Server
  • Apache / IIS / SSL
  • Active Directory
  • DHCP / DNS / BIND
  • Virtual Machine
  • Sendmail / Exchange / Exim
  • Jabber / XMPP
  • SSH
  • IMAP/POP3
 

References


  • Space

    Eric Cacic

    (Charles Schwab), Managing Director, Digital Experience ~ Contact
  • Don McAdang

    Don McAdang

    (Charles Schwab), Managing Director, Strategy and Business Intelligence ~ Contact
  • Space

    Sherrod Blankner

    (Charles Schwab), Software Development Manager ~ Contact
  • Space

    Christopher Robison

    (Simple Software), Chief Software Architect ~ Contact
  • Space

    Geoffrey Kemp

    (Univision Radio), Director of IT ~ Contact
  • Space

    Wanda Lim

    (Sanrio, Inc.), IT Director ~ Contact

Experience


D Harris Tours, Inc.

2018
~ Present

D Harris Tours, Inc.

Operations Manager

Crockett

Transitioned from a successful career in technology to take over the family charter bus company as my parents prepared for retirement.

Serve as Operations Manager and Compliance Officer, overseeing daily operations to ensure smooth scheduling, logistics, and customer service. Developed and implemented proprietary software tailored to our specific needs, streamlining operations and significantly improving efficiency.
Obtained a commercial driver’s license and a School Pupil Activity Bus (SPAB) certificate to be prepared for emergency situations.
Prioritize safety by creating comprehensive training programs for drivers, fostering a culture of accountability and excellence. Implement cost-saving measures and process improvements, driving profitability and enhancing operational performance.
Build strong relationships with clients and vendors, essential for fostering business growth and ensuring long-term sustainability.
This journey has been both rewarding and challenging, blending my passion for technology with my commitment to family and community. Essential Functions:

  • Scheduling and Logistics: Coordinate bus schedules and routes to optimize service efficiency and meet customer demands.
  • Team Management: Supervise, train, and evaluate drivers and support staff, promoting a culture of safety and accountability.
  • Safety Compliance: Ensure adherence to safety regulations and industry standards, conducting regular training sessions and safety audits.
  • Customer Service: Address customer inquiries and concerns, fostering positive relationships and ensuring high levels of satisfaction.
  • Budget Management: Monitor operational budgets, implement cost-saving measures, and identify opportunities for financial improvement.
  • Process Improvement: Analyze operational processes to identify inefficiencies and develop strategies for enhancement.
  • Software Development: Utilize technology to improve operational efficiency, including the development and management of proprietary software systems.

Sanrio, Inc.

2018
~ 2018

Sanrio, Inc.

IT / DB Manager

El Segundo

Management of information flow, operation and programming activities, including network and systems design, procedures, and operations. Provides management direction and leadership in computer applications development and computer operations of the corporation as well as advice and counsel to management concerning new applications and technology.

Essential Functions:
  • Manages the activities involved with software maintenance and development to ensure optimal programs. Coordinates software development with other IT functions.
  • Provide recommendations to management for the purchase of new hardware and software to ensure the best product within the limits of corporate policy.
  • Assess management needs regarding information retrieval, information control, and the use of systems in company operations and processes.
  • Directs the preparation and installation of procedures and systems, including technical direction of computer operations and providing assistance in the format of management reports in order to maintain consistency and improve efficiency.
  • Database management of archived data files from legacy system i.e. Savant WMS and Lawson
  • Oversees the design, maintenance and implementation of the systems that manage an internal database.
  • Assess and implement new reporting tool to replace and convert legacy Crystal Reports and/or access archived SQL data files for ad-hoc analysis and reporting.
  • Provides user training on all applications used in order to improve productivity.
  • Manage and review scheduled jobs are ran and completed; and implementation of new jobs ensuring maximum efficiently for job turn-around and machine utilization.
  • Maintains professional contact with other companies, research bodies, and equipment manufacturers concerning computer applications and equipment.
  • Determines the degree of accuracy and security required in processing work under an automatic system.
  • Maintain, support and development of the Sanrio-Online B2B web site, particularly focus on technical aspects and data integration with Sanrio’s ERP systems and Third Party Logistic company.
  • Monitors and maintains software licensing and maintenance agreements. i.e. VOIP system and LifeSize Video Conferencing System; as well computer servers and software
  • Managing and reporting on allocation of IT budget
  • Perform other duties as assigned.

Jan, 2016
~ Oct, 2018

PD Innovations, Inc.

President / Founder / Architect / Engineer

San Francisco

Responsible for designing and managing a flexible new B2B website for Sanrio Inc. (Hello Kitty). I put together a small team of front & back end engineers to deliver a modern, responsive website completely interfaced with their ERP. The architecture helped significantly increase their wholesale business by quickly adding special offer products through custom data uploads.
Since initial deployment, I have remained the primary developer for all new requests. Some of the technologies used are:

  • .NET/C#
  • MVC 5 & Identity Framework
  • Foundation 6 Framework
  • Gulp/jQuery/JS & SASS/CSS
  • GIT repo
  • SQL Server 2016 & IIS (DMZ deployed)

Sanrio, Inc.

Jan, 2015
~ Jan, 2016

Sanrio, Inc.

DBA / Report Developer

South San Francisco

Migrate all SQL Servers to SQL 2014. This included migrating all DTS packages to SSIS, and all Business Objects to SSRS. Prepared their B2B databases for the development of a new application, including new AS400 interface methods.


Charles Schwab, Inc.

Nov, 2012
~ Jan, 2015

Charles Schwab, Inc.

Sr. Data Architect / Manager

San Francisco

Developed reporting infrastructure to support their Business Intelligence requirements.
This included:

  • Complex data extraction methods
  • Develop user friendly tools for data upload & extracts
  • Agile method - worked closely with users to complete sprints

Other projects:

  • SSIS packages to feed data to Schwab.com
  • Work closely with developers to help design new applications
  • Create Tableau visualizations & dashboards
  • Build API applications to extract external vendor data


Simple Software

Jan, 2009
~ Oct, 2012

Simple Software, Inc.

Co-Founder / Data Architect

San Francisco
www.simpsf.com

Self-funded startup specializing in Software as a Service. My role included designing data infrastructure for easily replicated online workspaces. I also worked with customers to gather requirements and develop solutions that met their needs. We created web tools so clients could develop their own workspace. Tools included:

  • DB Utility - generic database table tool
  • Automatic Form Builder - created/updated forms using table columns
  • Content manager - with built-in editor and version control
  • User Management
  • Business Process Management
  • Reporting Tool
  • much more...

There are still several companies using our hosted services. I'm especially proud of helping our family business grow 400% in less than five years. This was accomplished by working together to develop a SaaS solution that automated many business processes including:

  • Order processing
  • Scheduling
  • Automated dialer (using Twilio)
  • Billing
  • Payroll
  • Much more...

Sanrio, Inc.

Jan, 2009
~ Nov, 2011

Sanrio, Inc.

DBA / Report Developer

South San Francisco

Created application to feed data from their new warehouse management solution to their ERP and external vendors. Updated their SQL Server DTS packages, as well as modified their existing BO reports. I continue to support their reporting needs as they arise.


Charles Schwab, Inc.

Oct, 2008
~ Dec, 2008

Charles Schwab, Inc.

Oracle Database Developer

San Francisco

I was contracted to develop a sales program merging raw external vendor data with a proprietary sales system. This was developed in Oracle PL/SQL in a Linux environment. I was responsible for requirements gathering from internal and external sources; database design; code development; and testing. Extensive technical documentation and rigorous QA was required.


Univision, Inc.

April, 2004
~ Oct, 2008

Univision, Inc.

Database Applications Programmer

Dallas, TX

Worked closely and provided solutions for corporate executives by developing and maintaining custom applications and financial reporting.
ETL

  • Extraction: from multiple sources, including but not limited to, SQL and Oracle databases.
  • Transformations: Data Transformation Services, Data Integrator, custom .NET applications, PL/SQL, Oracle applications and complex SQL/stored procedures.
  • Load: consolidated view for analysis and reporting, web applications and Oracle Reports for financial users.

All custom requests that were not handled by software agreements were passed on to me for development. Maintaining data integrity and user confidence were a core objective.


Univision Radio, Inc.

Oct, 2002
~ April, 2004

Univision Radio, Inc.

Database Applications Programmer / DBA

Dallas, TX

Custom application development, database administration, network administration, application and desktop support, & new site builds were my primary responsibilities. I also managed our data warehouse and OLAP cubes containing AP/AR and GL information derived from Great Plains and Marketron systems.
My other responsibilities included creating and managing in-house applications. Most applications were created with an ASP front end, Active Directory security, and reinforced with a data security layer.


Oct, 2001
~ Oct, 2002

E-talk

Report Developer / Database Administrator

Irving, TX

E-talk is a provider of call center software solutions. I was contracted by E-talk to develop custom Crystal reports for their customers including full lifecycle project management from quote to deployment. Database administration, Crystal Reports, VB and all IT implementations were my primary responsibilities. Reporting involved, but was not limited to, data warehousing, systems integration, and web development.


April, 2001
~ Sept, 2001

DSG Technologies, Inc.

Consultant

Dallas, TX

My primary responsibility was as a solution provider for many industries through consulting services. Some of the solutions I provided include Web development, application development, database design, and reporting solutions in various environments. Reporting solutions were our main focus and DSG was Seagate's Partner of the Year for two consecutive years. I have implemented many enterprise reporting solutions including Seagate Info, and Crystal Enterprise and have integrated them with multiple databases including DB2, Oracle and SQL Server.


Nov, 2000
~ Mar, 2001

Steidlmayer Software

Software Developer

Chicago, IL

Functioned as multi-leveled software specialist. Located inside CBOT, my duties included development of trading software. Written in VB, it handled data requests for clients inquiring on stocks and futures. I also implemented a fully automated Help Desk solution; upgraded server/network & hardware/software; network administration including managing proxy and all web services.


Sanrio, Inc.

July, 1999
~ Oct, 2000

Sanrio, Inc.

IT Operations Supervisor

South San Francisco

My responsibilities included Network Administratior, support & enhancing LAN/WAN hardware, supervision of the PC technicians, AS/400 computer operators, and consultants. I was also purchasing manager for all hardware and software as well as the project lead for all development and enhancement needs.
Network
Novell 4.11 server, Windows NT servers, two AS/400's, and over 100 Windows 95 and 98 PC's and laptops. I was involved in many projects that helped them to perform more efficiently. Some of the projects include moving from a DSL to a metered T1, upgrading their network backbone from hubs to switches, and working with the AS/400 systems programmer to integrate with multiple systems. I upgraded their design department from old 9600's to G4 workstations and upgraded all of the printers.
Services
I implemented a SQL server with crystal reports. Supported the mail server, Internet Proxy. and all Network services and protocols.
EDI
Acquired EDI certification, implemented and managed new EDI solution. Integrate the EDI orders directly into our Lawson order entry system. I set up our VAN, handled interconnects with our Trading Partners, and created all message mappings for each document required. The documents were created in X12 4010 standards. We acquired Extol as our translator.


Aug, 1997
~ June, 1999

Walker Interactive Systems

Programmer / Analyst

San Francisco

Enhancement of the financial modules including Project Management Accounting and Budget forecasting, Accounts Payable, Purchase Order Entry, Processing and Distribution, and Inventory Management. In house development and providing technical support were the core responsibilities. The work involved analyzing, coding and testing new and existing features for better efficiency and optimization, as well as supporting the various releases. The programs were written in COBOL, Visual Basic and other Walker proprietary languages in an RDShare file control environment for DB2 / CICS / VSAM environments with MVS / VM as the operating systems.
Reporting Solutions
Involved in multiple projects to enhance the ability of data extraction for reporting purposes. Focus Reports that accessed DB2 tables using SQL. Developed Visual Basic forms that linked to COBOL using screen scrapes. Installation of the Direct Web product, which allowed the Walker CICS transactions to be accessed directly from the Web. This involved coding in COBOL, VBScript, and HTML commands.
Data Migration
Developed standard routines for the migration of customer data from one release of Walker financial to another. Analyzing Walker systems for performance and data corrections & testing the migration routines after generating test data were the core responsibilities.
Quality Assurance
Lead a team of professionals for system testing of the new releases and provided technical guidance and expertise as needed. Monitor the testing progress and job scheduling were my secondary responsibilities. This involved mainframe and client testing of financial applications and efficiency measurements.
Y2K
Reengineered the Procurement system for YEAR 2000 compliance. This involved identifying the affected entities, mainframe field expansion, recode and testing client/server applications.


Education

Computer Learning Center, SF, CA 1997
Computer Programming