Summary
Overview
Work History
Education
Timeline
Generic

Brian Bauska

Systems / Data Analyst
Ellensburg,WA

Summary

Senior Systems/Data Analyst, where 40,000+ hours of experience will contribute. Proven ability to analyze, integrate, move, and ‘model’ large volumes of enterprise data into useful data warehouses for multiple business needs. Work well independently and with teams in both private and government sectors.

Overview

31
31
years of professional experience

Work History

contractor

  • Specializing in systems design and development.
  • Extensive work with databases, word processors and spreadsheets; included Paradox, Quattro Pro, R: Base System V, Word, WordPerfect, Excel and Lotus 1-2-3.

Programmer Analyst

Creative Data Corp/Bob Dodge/Software Integrations Group/Gunderson Rail
Scappoose, Ellensburg, OR, WA
11.2007 - Current
  • Access-based software development.
  • Utilize Visual Basic/VBA, Access, Excel and many online free and low-cost software applications to help automate small businesses in logging, farming, inventory tracking, warehouse management and sales.

Database Programming Consultant

Hollister
Vancouver, WA
06.2007 - 11.2007
  • Wrote an Access-based system for a logging/paving company using Access, Excel, and VBA for Excel/PowerPoint/Access/Outlook.
  • Translated paper-system to automated computer system – billing, bidding forms and reports.
  • Additionally automated the data extraction from SQL and Access to Excel for client to graph, chart or report in multiple data formats.

Sr. Systems Analyst

Georgia-Pacific Corporation, Koch Enterprises
Portland, OR
01.2000 - 01.2007
  • Complete Software Development Lifecycle (SDLC) utilizing SAP, Oracle 8, Access, VBA, & PL/SQL.
  • Maintained locally written & 3rd party applications using VBA, PL/SQL, Oracle Discoverer Data Warehouse, and 3rd party reporting programs.
  • Assisted Camas Mill IT in design and development of Cognos 8 studios for subsequent access by local and regional management.
  • Utilizing SQL, Oracle Discoverer Data Warehouse, Access, and VBA, systems were designed, developed, installed and documented for transportation, inventory management, safety tracking/- survey, and shipping/receiving for local, regional and corporate-wide systems.
  • On-time arrival module utilizing a 3rd party application is saving the transportation department several thousands of dollars each month in late fees.
  • Pallet tracking & notifications system again utilizing a 3rd party application, along with Access & VB has saved G-P tens of thousands in yearly pallet purchases.

Systems Analyst/Programming Consultant

Fort James, James River Corporation
Portland, Camas, OR, WA
01.1998 - 01.2000
  • Program using Cognos Powerhouse fourth GL on DEC VAX and Alpha-series hardware.
  • Year 2000 analysis, upgrade, conversion and system testing.
  • Performing requirements definition, analysis and design; then subsequent dictionary modifications, Y2K repair (using ‘windowing’, logic correction, date expansion, and transformation) and program upgrades to a payroll inquiry/entry system, labor maintenance system, inventory tracking and a manufacturing system.

Systems Analyst

Puget Plastics Corporation
Tualatin, OR
01.1996 - 01.1997
  • Program using Progress’ fourth GL on Alpha Server 2000 4/233.
  • Installed, maintained and tracked third-party manufacturing system and server hardware.
  • Also added links to system for proprietary sub-systems and ODBC link for access from Netware network OS.
  • Wrote sub-systems to interface with third-party manufacturing information system.
  • Included tracking system for preventative maintenance on plastic molds, and reports to track rejected molds.
  • Saved thousands of dollars by pinpointing reject locations and operators.
  • Supported hardware & software systems management on Alpha Server; also incremental and full mage backups, terminal server linking and PC access to Netware.

Database Analyst/Programming Consultant

Hewlett Packard
Vancouver, WA
01.1994 - 01.1995
  • Consultant/contract position in inventory control management maintenance and upgrading.
  • Programmed add-on inventory delivery system using Powerhouse via Reflection terminal emulation, Windows 3.1 and HP 3000 MPE/XL OS; used HP Image Database Management System software.
  • Add-on system now used at every HP inventory site worldwide, numbering in the thousands.

Software Consultant/Personal Computer Trainer

Vancouver, WA
01.1992 - 01.1994

Programmer/Analyst

City of Bellevue
Bellevue, WA
01.1988 - 01.1992
  • For Information Services Division, duties included database management, systems development and computer user training.
  • Developed HR management system (personnel and payroll), budget development system, and permit tracking and building information system.
  • Also developed fire inspection and emergency dispatch system.
  • Played key role by adding modules to barcode and reconcile permit collections.
  • Also led support and maintenance of other budgetary systems and relational database systems.
  • Supervisor stated in 1991: ‘Brian is an excellent technician and has the people skills to be a truly outstanding programmer/analyst.
  • I have a high degree of respect for his abilities.’.

Education

BS - Computer Systems

BA - History

Central Washington University

Timeline

Programmer Analyst

Creative Data Corp/Bob Dodge/Software Integrations Group/Gunderson Rail
11.2007 - Current

Database Programming Consultant

Hollister
06.2007 - 11.2007

Sr. Systems Analyst

Georgia-Pacific Corporation, Koch Enterprises
01.2000 - 01.2007

Systems Analyst/Programming Consultant

Fort James, James River Corporation
01.1998 - 01.2000

Systems Analyst

Puget Plastics Corporation
01.1996 - 01.1997

Database Analyst/Programming Consultant

Hewlett Packard
01.1994 - 01.1995

Software Consultant/Personal Computer Trainer

01.1992 - 01.1994

Programmer/Analyst

City of Bellevue
01.1988 - 01.1992

BA - History

Central Washington University

BS - Computer Systems

contractor

Similar Profiles

CREATE PROFILE
Brian BauskaSystems / Data Analyst