Download PDF

Summary

May, 2010Providence Health CareSr. Programmer/ Reporting AnalystProvide modifcations, and enhancements to Relational DB tracking various government interactions, and meeting scenarios/ history.  July, 09 - September, 09:Sr. Programmer/ analyst for Intel. Provide technical maintenance, and source code analysis for existing RDMS tracking FAB production costs. September, 2008 - July, 2009: Pacificorp - Transmission Finance Sr. Data Analyst & ProgrammerPerform data analysis of Power and Energy data purchased and sold to various types of customers throughout the Western Grid. Tracking Meter fluctuations, and accuracy of reporting methods. Modify Access applications, Visual Basic.net applications, and several complex Excel spreadsheets. Automated various spreadsheet functions to expedite their processing efficiency, and to minimize access of required data for optimization. Modify existing COGNOS reports using COGNOS-Impromptu. Modifications include adding new report columns, and their very complex business rules, special filters, and making changes to existing business rules. Also create or modify Impromptu macros to automate nightly or monthly reporting.

Work experience

Jul 2009Present

Sr. Programmer/ Analyst

Edgelink LLC for Intel
May 2010May 2010

Sr. Programmer/ Reporting Analyst

Employment Trends for Providence Health Care

Provide changes and updates to existing MS Access application to include reporting enhancements (new reports with specific filtering criteria). Added new functionality to import Excel data and to export from application to Excel data files.

Sep 2008Jul 2009

Sr. Data Analyst/ Programmer

Pacificorp
20072008

Sr. Reporting Analyst

REGENCE
20072008

Sr. Reporting Analyst

The Regence Group
Oct 2005Jan 2007

Sr. Programmer/ Analyst

Kelly Services-Nike ETW
19941995

MS Access Developer

Hewlett-Packard

Education

Certificate

Microsoft Certifified Training

As a consultant for Technology Solutions Group, attended classes for SQL server, Visual Basic/ Visual Studio, Web Boot Camp (incliuded Javascript, HTML, DHTML, ASP, VB Script), MS Access.

Sep 1993Jan 1994

N/A

Portland Community College

Took class in C++ programming language based on new Pilot project for the CS Dept.

19831988

McKendree College
Jan 1985Aug 1986

Certificate

Brian Institute of St. Louis, MO

Studies included Cobol, RPG II, III and Principals of Accounting, IBM System 34 and related utilities.

Skills

Excel VBA programming
Provided numerous Excel type reports, and automated legacy formula macros, and performed maintenance of existing code related to various legacy reports for several clients.
Cognos-Impromptu Reporting
Provide modifications to existing reports, enhancements, and create new reports, and their proprietary functions, and paramaters.
Clipper
Developed first Aircraft Evaluation System for the U.S. Army Aviation Command to provide capability to eval teams assessing army aircraft's stability for performing in both peace time and combat conditions. This project included Pro Com Plus as well to create turn key tele com programs to enable one button execution of a complete dial up script to transmitt data from various aircraft installations to command headquarters in ST Louis, MO.
MS Access Application Development
Provided numerous Access applications to include inventory tracking, surveys, reporting, data entry, processing Excel data, Search engines, sales order system.
ADO
ADO technology utilized for data access to include executing stored procedures, and SQL as part of application internal code.
Visual Basic (6 and .Net)
Experience includes development of business applications implementing Application design and development based on Visual Basic forms, data access and reporting.
Relational Database design, and development
Several years of experience performing data modeling, and database design, implementation of structures, stored procedures, and administration (not DBA level). Databases include SQL Server, Oracle, and MS Access.