SUMMARY:

• Senior Systems/Data Analyst, where 20+ years of experience & 7 years 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 public sectors.
• 20+ years of experience in supporting data management systems thru the designing, developing & documenting of data warehouses and databases (3rd and 4th GL’s).
• SQL - ETL - Relational databases (using Discoverer, TOAD, Excel and Access) to SAP/Oracle - Two years exclusively. Converted data for Georgia-Pacific for warehouses in North America; .
• Nine years translating and tuning of business requirements from SQL databases and data repositories (flat, relational and object) to local normalized SQL 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, Transact-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.
• Cognos BI - MDX - two years query building for dashboards and report data drilling.
• Designed, developed, installed & documented multiple server-based systems using HP Software Development Life Cycle.
• Developed and maintained relational databases as programmer/analyst for Confidential, WA ( ).
• Extensive and experience in data processing principles. Supervisor cited my interpersonal skills, saying: ‘Every client has expressed their pleasure working with Brian.’
• Programming Languages: SAP (Oracle), SQL, Cognos/IBM 8i BI Report Authoring, Powerhouse, Oracle Data Warehousing (Discoverer), Access/VBA, TOAD, and MS Office suite of products. Multiple 3rd & 4th Generation Languages & Report Writers.
• Special Skills: DCL programming, RDBMS on HP and DEC, data normalization, and HP Image and Query relational database management software, Visual Basic, Pascal, Fortran, Cobol, DEC Assembly Language.

EXPERIENCE:

Contract Programmer Analyst

Confidential

Responsibilities:

• 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, and sales.
• 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.

Confidential

Sr. Systems Analyst

Responsibilities:

• 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 studio dashboards for subsequent access by local, regional & corporate management.
• Utilizing SQL, Oracle Discoverer Data Warehouse, Access, and VBA, systems were designed, developed, installed and documented for transportation, inventory management, safety tracking/-surveying, 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.
• 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.

Confidential

Systems Analyst - Database Administrator

Responsibilities:

• Program using Progress’ fourth GL on Alpha Server .
• 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.

Confidential

Database Analyst/Programming Consultant

Responsibilities:

• 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.
• 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.

Confidential, Bellevue, WA

Programmer/Analyst

Responsibilities:

• For Information Services Division, duties included database management, systems development and computer user .
• 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.’

Confidential

Programmer/Analyst

Responsibilities:

• Co-wrote HR management system (personnel and payroll). Installed HRIS for Ministry of Labor, Victoria, BC, Ministry of Advanced, Victoria, BC and Confidential, WA.