SUMMARY

Extensive experience with PowerBuilder, including PFC. Most recent versions used are PowerBuilder 2019 R3 and SQL Server 2017 Enterprise using Transact SQL.

SKILLS

Report writing, report development; Technical Writing (programming, Testing, and User Manuals); Training.

PowerBuilder; SQL; T-SQL; CCL; Visual Basic and VBA; Java; C#; .Net; Oracle; Microsoft Office suite;

Financial applications / systems; Developer and code coverage testing; Code, Technical, System, and User Documentation; Deploying applications and updates; consuming web API services.

Medical Practice Management, Material Management Systems, Client Support, Help desk resolution.

VSS, Tortoise VSN, TFS, Git, GitHub, ClearCase. DBArtisan, PowerGen, SQL Server Management Studio.

EXPERIENCE

TekSystems (for CarMax) – IT Consultant June 21 to Oct 21

Order Entry (car purchasing) systems, in-house PowerBuilder applications (SQL-related) using PB 9, 12, and 2019.

Analyze/document current processes, propose improvements, formalize procedures, mentor newer developers.

InSight Global (for Greenbrier LLC) – IT Consultant Feb 18 to June 21

Accounting, Transportation, Storage, Leasing, Agreements, Manufacturing, Mechanical and Payables systems.

Write SQL stored procedures. Make DB changes. Write Test, Procedural, and Process documents. Known for consolidating code into reusable objects for easier, more accurate maintenance. Developer/Unit testing.

Resolve bugs and production issues. Migrated PB 2017 to 2019 R2. Changed source control from TFS to Git;

Prepare test and production builds and releases for 7 test environments on 10 servers.

MMH Transworld Industries - Sr. Software Analyst Sept 15 to Feb 18

Wrote PowerBuilder functions; designed PowerBuilder data windows and reports.

Assisted companies to improve their existing codebase; developed SOPs for testable, reusable code.

Bridged gap between application end users, sales, and developers regarding functionality.

Data conversions and database loading; report design; software education; wrote customized utility code.

Cerner - Sr. Software Engineer Jan 09 to Sep 15

Specialty Practice Management client support; PowerBuilder application maintenance and enhancement.

Developed and maintained client-server applications. Performed Root Cause analyses. Diagnosed interface issues. Performed application upgrades. Resolved 3rd tier support issues.

Performed Unit testing. Prepared technical specs. Performed client de-conversions and database splits, updating fields, process and documentation. Wrote User manuals and Support team guides.

Wrote T-SQL, CCL, Java, and Visual Basic code. Designed Custom client reports, some in C# using .Net.

Technology Partners (for Ameren UE) - IT Consultant Mar 08 to Nov 08

Upgraded over 300 distinct windows, datawindows, functions, structures, user objects (visual and nonvisual), stored procedures, and triggers on 4 servers of 50 databases each, with up to 690 tables per database.

Unit and pre-release testing, Resolved testing issues, coordinating with over 30 team members.

State of Utah - IT Analyst II Nov 88 – Mar 08

Utah Job Match: Design to release: wrote code, reports, technical manuals, documentation, and online help.

Employee data warehouse development; web-based reports for state HR personnel and public; designed security.

Designed the Annual Financial Reporting package used by the school districts to report financial activities each fiscal year. The Indirect Cost calculations were recognized federally as the most accurate of all 50 states.

Designed and implemented the Utah High School Activities report package, for all secondary schools in Utah.

Worked on the Fiscal Accounting team writing and maintaining code for Fixed Asset, Payroll, Accounts Payable and Receivable, Budget/General Ledger, Financial and DDS Warrants, and Warehousing systems.

EDUCATION

Bachelor's Degree

Weber State University

US-Ogden, UT

Double Major, Data Processing & Accounting, business emphasis; Data Processing Management Association President

High School

Weber High School

US-Pleasant View, UT

Science Sterling Scholar; Young Americans (academic team) Captain; National Merit Semi-Finalist; National Honor Society; Science Club President; Numerous Science Fair awards including State, Region and International (twice).

Contact this candidate