Summary of Qualifications

• ** Years Solutions Development, Tech & Bus.

• 12+ Years Database Development

• Shell, command-line, and Tools savvy

• Mech Engineer with Strong Data Analysis skills

• 5+ Years Database Administration

• PHP, JS, AJAX, jQuery developer

• Author of ERAs, DFD, Logical & Phys. Designs

• Perforce & GitHub experienced

DATABASE DEVELOPER with significant OLTP and data warehouse design and reports experience using SQL, UNIX Shells, SSIS, and Perl. Rich background in ad-hoc queries and at writing savvy reusable DML procedures. Built a data warehouse using only shell scripts and a textual SQL editor.

DEVELOPER with significant full software development life cycle experience, and the passion and skill to develop high quality code that is reliable, robust, efficient, well structured and well documented. Experienced troubleshooter and tester, and author of a Boeing division's Software QA and Configuration Management documentation. When appropriate, will incorporate validation routines within the product.

FULL STACK DEVELOPER with dozens of successfully completed projects; starting with interfacing with the customer, creating As-Is and New models, Architecture and Design diagrams, Development, Testing (all levels), Delivery and Maintenance. Medium to small sized projects, business and technical customers.

DATA ANALYST with experience in Infrastructure QA, Promotions, and Releases. I have Reporting experience using self-authored SQL queries and reports, also Tableau experience. I have Source System Analysis experience on enterprise systems, and performed accounts management at the enterprise level.

DATA ARCHITECT for Transaction and Data Warehouse DBMSs. Experience creating logical and physical designs, modeling, normalization, documentation, and test planning. Well-experienced with many facets of data quality, and engineered an on-demand ETL process to a DW solution before aware of the specialty.

ENGINEER with strength in numerical analysis techniques. Well-versed with data quality dimensions including accuracy, consistency, completeness, timeliness, concurrency, and conformance. Years of Systems Analysis, Design, Data Analysis, and Testing. Bold problem solver and questioner, has pushed the limits of technology to achieve world firsts.

DOCUMENTATION advocate, with experience documenting functional requirements, schemas, data dictionaries, procedures, and rationale. A firm believer in high quality usable documentation, have ample experience working without it.

Technical skills

Languages: Four variations of SQL, UNIX shells, PHP, Python, JavaScript, and some Java, and Perl

Advanced knowledge of: SQL, Microsoft Excel and Word

Databases: MySQL, SQL Server, Oracle 10g, PostgreSQL, ANSI SQL

Operating Systems: Windows (various), Linux, HP-UX, and OS X

Working knowledge of: Tableau, Microsoft Access, SPSS, SSIS

Experience with: Toad, Informatica, HP Quality Center, SSAS, SSRS

Education

MSE, Master's in Software Engineering, Seattle University, Seattle, Washington

BSME, Bachelor's in Mechanical Engineering, University of California at Davis

Training after my MSE

Hadoop / Big Data certification training, 36 hours via Edureka (doing cert. project now)

Oracle 11gR2 DBA training

Microsoft Certified Business Intelligence, SQL Server 2008

PL/SQL; Stored Procedures, Triggers, and Cursors

Oracle: ERA Modeling, Oracle SQL*Plus, DBA OCA certification and DBA OCP training

Microsoft Access v7, Levels I, II, III, IV

Visual Basic Fundamentals, DB, and Programming

Certifications and Affiliations

Business Intelligence SQL Server 2008: Certification Training May 2010, 160 hours

Oracle® Certified Associate (OCA) DBA for 10g, 2006

DAMA Data Management Association, Puget Sound

WWOUG Western Washington Oracle User's Group

AWC Association of Women in Computing, Puget Sound

MySQL Meetup Puget Sound

SEAPUG Seattle PostgreSQL Users Group

Professional Experience

Panasonic Oct 2015 to Nov 2016

Senior Project Analyst

Primary developer and end-user system analyst to develop a forms and software based solution to encapsulate the work of managing the billing plans, active/suspended status, location, and history of approximately 5,000 cellular modems on aircraft around the world.

Implementation included 45+ normalized tables for data, metrics, auditing, and logging

Application required dozens of procedures and functions, Events, and triggers

Optimized SQL queries with judicious use of (functional) indicies, efficient statements, and normalization

SQL and PHP code was instrumented to augment functionality and provide adjustable levels of auditing

Used JavaScript, jQuery, AJAX, and PHP to implement the DB based solution to a huge spreadsheet

Separate from this project, I generated reports with Tableau for a few weeks in support of other programs

T-Mobile Aug 2015 to Oct 2015

Source Systems Analyst

Working on the Marketing track to identify source systems, databases, schemas, tables, and attributes in legacy systems so to map them to a new Integrated DW.

Interviewing architects and data administrators to map sometimes vague sought-for attribute names and descriptions to existing systems.

Startup viaBlitz Jun 2014 to Feb 2015

DB Architect, DBA, QA Engineer using MySQL

Working closely under a NDA with genius entrepreneur and remote teams, performing all data management duties

Designed (improved) schemas supporting the functionality and relationships of the developing product

Automated the table and foreign key creation activities, a flexible backup regimen, maintenance routines and replication; using MySQL via XAMPP, shell scripts, and PHP

Performing QA oversight of contractor work, and working with test bed for future enhancements

Providing technical system specification, including DFDs, Data Dictionary, CRUD, and more

Training Apr 2013 to Jun 2014

I took some time off to resolve some family issues that are now resolved.

At the same time I returned to the 'classroom' with the goal of updating and maintaining my knowledge of Database Engineering and Software Engineering.

I've always excelled at development and loved it, I thought it wise to pursued DBA training in order to make myself a more wise Developer

I competed 50 hours instructor-led, self-paid-for Oracle 11g DBA training and followed that up with hundreds of additional hours of exercises on my own

I implemented a couple AWS EC2 instances with MySQL and was preparing to set up replication and follow that up with using PostgreSQL at home to use its Foreign Data Wrappers to connect to the slave

I have kept up to date by reading a plethora of articles and papers on wise Data Management practices, 'Big Data', and of the functional features and approaches with MySql, Oracle, and PostgreSQL

Amazon.com Dec 2012 to Mar 2013

HIRED FOR: MySQL DBA/Developer # DID: Ruby on Rails Developer, System Analyst

The job description as posted and during the interviews was for a MySQL DBA/Dev. However it was not, though it did remain a vendor tracking system for the construction of data centers.

Designed and implemented schema changes, performed installs, builds, and migrations

Used JIRA, GitHub, and Perforce for issue tracking and configuration management

Worked with one other analyst/developer in an Agile manner, also performed Ruby on Rails development, reporting out to management in Virginia.

T-Mobile via Amdocs JUN 2012 to DEC 2012

Business Intelligence Infrastructure Support Specialist

Provided advanced troubleshooting for new data warehousing applications

Performed code deployments/promotions for Business Intelligence Applications

Participated in design reviews, project meetings, and stack sessions

Provided support using BI Applications: Informatica, EDW, SmartMart, Business Objects, Report Info, SAP-BW and more

AT&T via Accenture (Was to be a 4-mo contract but for delayed paperwork) Nov 2011 to Dec 2011

SQL Server Database Developer, System Analyst

Defined schemas for raw imports and final data store assuring data integrity

Worked with analysts and administrators to produce a roll-up of Company-wide Storage Utilization reports

Extracted information from several multi-vendor data sources by authoring a pool of Functions, Procedures, and batch SQL following Company requirements

10kInfo, (An Internet Startup) AUG 2010 to MAY 2011

PostgreSQL Database Administrator, Architect and Developer

Designed, developed, tested, and implemented several enhancements to the core business schema

Authored stored procedures, performed benchmarking, management of roles, privileges and quotas

Extensive SQL and shell programming to clean and join datasets from diverse sources

Worked well with local and overseas teammates to route-out and solve urgent issues

University of Washington AUG 2006 to FEB 2009

Database Administration and Development

Established and tested backup regimens for PostgreSQL and MySql clusters

Designed and implemented databases, established roles, security, and alerts

Extensive Relational Database report generation from PostgreSQL and MySql databases using SQL, shell scripts, and Perl

Created dashboards to provide timely information to management

Utilized cronjobs to initiate data mart updates, some using clever aggregation techniques

Research Analyst (at UW)

Significant analyses of both scalar and nominal survey data using SPSS to generate custom tables which were then transformed into reports using MS Excel and Word

Personal Accomplishments and World Firsts

While at Boeing I was the first to incorporate a stepper (vs. analog) motor to a national standard-alike manometer. Making full use of this enhancement I was the world's first engineer to configure this standard to generate (versus only measure) known pressures to 0.005% of reading above 15 inches of mercury. I created a touch screen application enabling manual control, or selection of other customizable self-authored applications. The screen incorporated a dashboard to provide up to the moment indication of the current program and hardware status and progress, the current pressure, and the test device's reading via an I/F bus.

At 19 I built a motorized battery powered scuba tow, (ala Cousteau). I'm a certified SCUBA diver

At age 15 I coordinated every aspect of a world record setting 600 mile marathon swim that required the 24-hour involvement of 100 swimmers, lifeguards and parental chaperones

I am a successful mole hunter.

Contact this candidate