Data Management

Brian A. Bauska

**** **** ******* ***, **********, WA 98926

**** ***** ** **, **** C, Bothell, WA 98021

Cell: 971-***-**** ***********@*****.***

OBJECTIVE

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.

HIGHLIGHTS

20+ years experience in supporting data management systems thru the designing, developing & documenting of data warehouses and databases (3rd and 4th GL’s). Skilled training others on software applications and report development.

Last nine years translating and tuning of business requirements from SQL databases and data repositories (flat, relational and object) to local data warehouses merging data marts for departmental reporting/charting.

Seven years with Georgia-Pacific, developed live and batch interfaces between SAP (Oracle 8i) and local Access/Visual Basic/VBA data warehouses using Discoverer, SQL, T-SQL, PL/SQL, HP UNIX, Digital VAX and client-server MS Office products.

Inventory/Control and Supply Chain Management & Maintenance with Hewlett Packard/Printer Division – Vancouver, WA. Designed, developed, installed & documented using HP Software Development Life Cycle.

developed and maintained relational databases as programmer/analyst for City of Bellevue, WA (1988-1992). Extensive knowledge of data processing principles. Supervisor cited my interpersonal skills, saying: ‘Every client has expressed their pleasure working with Brian.’

Programming Languages: SAP (Oracle), SQL, Cognos 8 BI Report Authoring, Powerhouse, Oracle Data Warehousing (Discoverer), Access/VBA, MS Office suite of products, multiple 3rd & 4th Generation Languages & Report Writers (3rd party & ‘off-the-shelf’).

Special Skills: DCL programming, RDBMS on HP and DEC, data normalization, and HP Image and Query relational database management software.

Experience

Contract Programmer Analyst: Dodge/Blankenship/Gunderson/VOLT/Computer Task Group/Creative Data Corp - Scappoose/PDX, OR & Ellensburg, WA (11/2007-current)

Access-based software development. Utilized Visual Basic/VBA, Access, Excel and many online free and low-cost software applications to speed up small businesses in logging, farming, and more. Full-time, permanent position as father and grandfather.

Database Programming Consultant: Contract position (Hollister), Vancouver, WA (06/07-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 (2000-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, OR and Camas, WA (1998-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 (1996-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 image backups, terminal server linking and PC access to Netware.

Database Analyst/Programming Consultant: Hewlett Packard, Vancouver, WA (1994-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 (1992-1994).

Independent 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: City of Bellevue, Bellevue, WA (1988-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 (1986).

Includes extensive training (all available courses) in mathematics and electronics.

Contact this candidate