John Wsol

11778 Tulip Ct; Fountain Valley, CA 92708

949-295-6002

JWsol@TechMD.com
Objective:   To integrate my gifts, analytical talents and creative skills into a team of individuals dedicated to technological advancement, the pursuit of engineering excellence.

Summary:      25+ years of experience with analysis/design, development, and implementation of applications systems – manufacturing, accounting, business process, engineering and scientific.

§  Amazingly analytical and perceptive: able to grasp and model real-world systems and write specifications for optimal designs: including data-representations, structures and algorithms.

§  Established standards for managing large complex systems, as well as multitasking the development, implementation and support phases for multiple projects at once.

§  A definite self-starter, with the initiative to research theories, evaluate software tools, scope-out business needs and recommend multiple design options, anticipate design bottlenecks and present the trade-offs.

§  Applications Systems Experience:

·         Accounting: A/R (billing, dunning), A/P (cash flow), Inventory Control, Payroll, G/L

·         Engineering / Manufacturing Tracking: Product Data Management, Production Scheduling, metric tracking (ISO/9000), Data Acquisition, Statistical Process Control (SPC), robotics programming.

·         Healthcare: medical/dental insurance billing, familiar with ICD9 / CPT coding.

§  Database and Software Engineering:

·         Expert in information theory and database design: conceptual architecture, logical constructs, and physical structure for both transactional and analytical (OLAP) applications. Also OOP.

·         Optimal database design and algorithm development - with over 10+ years experience in SQL-based databases, the past 7 years primarily client-server apps using Microsoft SQL Server.

Skills:  Extensive Transact SQL, XML plus many dialects of BASIC, VB, VBA, Access (DAO & ADO), (C), SOAP, ASP, .NET, APL, FoxPro, Windows, SPEL (robotics), POV-ray (3D graphics & animations).

 

Accomplishments

·         California Science Fair: 1st Place – for computer build from old pinball machine parts.

·         Chemistry Student-of-the-Year: Western High School

·         National Science Foundation: grant for Programming Language Design Project

·         U.S. Navy: Navy Science Cruiser’s Award

·         Worlds fastest sort algorithm: 60,000 keys indexed in 2.51 seconds on 16MHz CPU

·        Microsoft Certified Professional: Database Administration & Application Development

·        Hobby: http://MysteriesOfTheUniverse.info: Epistemology, cosmology and quantum physics.

Experience:

9/06 to 2/07

Application Developer/Consultant

San Clemente, CA

Designed & Developed:

For Parker Hydraulics Group: an Estimating tool for Sr. Engineers to manage the complexities of most aspects of Test Engineering projects for new aircraft control system designs.

                                                                                                                        

2/04 to 7/06

Part-time Database Consultant : TechMD.com

Whittier, CA

Developed:

Interactive and printed reports for several of TechMD’s clients. (Some so complex they required queries nested 5-6 levels deep.)  Forms included extensive VBA logic.

 

4/04 to 11/05

Sr. Db Eng: American Information Strategies

San Clemente, CA

Created: Developed:

Created many reports for complex selection and grouping criteria, including data mining.

Designed and developed a neural-net hosted by SQL Server (~12,000 lines of T-SQL) that assimilated millions of inconsistently coded contacts (including extensive use of user defined functions and Trigger logic) into a consistent knowledge-base.  Its graphical User Interface featured clicking on bar-charts and creating customer orders just from mouse clicks!  Blazingly faster than its predecessor.  (Including integration with FAX server.)

 

8/02 to 12/03

Sr. Database Engineer: iEnterprise Technologies

Costa Mesa, CA

Responsible for:

Established:

Redesigned: Developed:

SQL Server: Installation, configuration, database replication (transaction log shipping)

Database Design Standards: normalization, relational diagrams, referential integrity

Database Schemas: Optimized structure/indexes, tuned performance

Intelligent Comm. Software/Database Interface: Import/Export automotive inventories, transactions. (VB, OLE-controls, Secure TCP/IP, Transact SQL, ASP, XML, VB.NET)

 

4/02 to 12/02

Instructor: Software Education of America

Brea, CA

Taught:

Microsoft SQL Server: Administration & Application Design/Development

 

3/99 to 1/02

Software Development Engineer: Tulon

 Irvine, CA

Deciphered:

Applications
Developed:

 

 

 

 

 

 

Designed:

Integrated:

Networked:

MRP Database Dictionary (Meta-Data) auto-translated it to standard SQL.

Access Applets: (via ODBC) to an MRP system (MAPICS-AS/400): A/R, A/P, sales analysis, Inventory, manufacturing orders

TulTrack: tracked tools received, in-process, shipments; printed and read bar codes.

Consignment Inventory System: Access GUI sync’ed with SQL 2000 & AS/400

Mission Management System: ongoing projects QSR monitoring (Access with OLE)

Engineering Specifications: Correlated similar designs showing real-time inventories.

Statistical Process Control: multi human-language support for shop floor UI, semi-automatic data acquisition systems, and automated visual inspection systems.

Robotics: VB GUI with DAO and Seiko SPEL (parallel tasking robotics).

Customer Relationship Management Database: (SQL/2000, ASP)

PCs (Windows 98, NT4, Windows 2000), Servers (DHCP, WINS, DNS, Exchange). LAN Switches, WAN routers, SonicWall firewalls & VPN.

 

4/01 to 7/01
Consultant

Fountain Valley, CA

Developed:

 

 

Created:

GoFBO an aircraft repair shop system: Airplanes: makes, models, maintenance history, work orders, line-item progress status; Employees: roles, scheduling, time tracking; Categorized: problems, corrective actions, parts; Inventoried: multiple warehouses (Ms Access, SQL/2000)

Ferro Corporation - Access application: automated importation of Lotus spreadsheets into Access, making translation into a consistent database schema possible  (VBA)

                                                                                                                                                                                                                                                                                

9/94 to 3/99

Sr. Software Developer: Tycom

Irvine, CA

Applications
Developed:

 

 

Integrated:

OFI System (Opportunity For Improvement): problem resolution tracking, English to SQL report writer. Amazing! Implied Multi-phase queries and JOINs.  (HyperCard, FoxPro)

Manufacturing Data Acquisition & Robotic control: multi-threaded VBA controlled automated vision and robots.  Gave engineers many beautifully analytical charts.

Billing system: Access GUI (via VPN) to HP9000 printed invoices in Japanese

Web Access to Shipments: Customers inquiry of shipments without interrupting staff

LAN, WAN, Servers: DHCP, WINS, Exchange, Proxy

 

2/92 to 4/94

Sr. Programmer: Integrated Medical Systems

Fountain Valley, CA

Developed: 

Amazing DOS Batch & C programs: processed medical insurance claims, supporting many protocols, data interchange formats including EDI.

                                                                                                                                                                                                                                                                                                

Education:

 

John Wsol

949-295-6002

Western High School: Diploma, 1+ year college: Calculus, Physics, Chemistry

IBM: AS/400 Concepts, Facilities, Applications Programming

Software Education of America: MCSD school

Self-taught: 27+ Programming Languages, 10+ Database Management Systems, computer science, cognitive science, epistemology, ontology, cosmology, (learning Hebrew)