💻 Doug Johnson Email & Phone Number

Lincoln, Nebraska, United States

Lincoln, Nebraska Area

Greater Omaha Area

• Complete software installations for new clients and system upgrades for existing clients. This involves implementing custom site defined workflow fields, crystal reports, and writing queries to extract information that can be run on demand by the user.• Complete inbound data conversions on time and under budget• Perform complex data extracts and custom database scripting jobs at customer request.• Ported proprietary legacy data conversion utility from VB6 and SQL Server DTS to VB.NET and SSIS, allowing for easier long-term maintenance and future enhancements. • Maintain and update new data conversion utility using VB.NET• Train new System Engineers in day to day tasks including data conversion, new client implementations, report writing, and other department processes.• Troubleshoot and support client sites, both remotely and onsite. Find and fix bugs and configuration errors.• Train client super users to administer, configure, and support their OTTR installation.

Omaha, Ne

Omaha, Nebraska

• Converted and inserted new client data into database for use with company's flagship product using a series of T-SQL scripts and SSIS.• Built a data dictionary for the database deployed with company's flagship product through the use of SQL extended properties.

Omaha, Ne

• Maintained internal software used to monitor worker’s compensations insurance claims. Application supports medical review, legal review, and payment of claimants’ medical bills.• Built user interfaces, business logic, batch jobs, and framework-level code using Visual FoxPro 9.0, an object-oriented database programming language.• Designed and implemented relational database schema changes to implement new software functionality and features.a• Performed Full regression testing of internal applications.• Diagnosed and fixed miscellaneous bugs with robust solutions.• Upgraded internal applications to support upgrade of production database from SQL Server 2000 to SQL Server 2008 R2. Updated syntax of inline SQL commands and called stored procedures and performed pre-release testing.• Optimized inline SQL and stored procedures called by application code. Resulted in improved load and save times for multiple systems, including an 80% improvement in the saving of Bill records.• Wrote multiple SQL queries used to generate a wide variety of company reports.• Built system to automatically report medical transactions to the state of California from existing workflow. Met stringent deadline while working with representatives of two other departments.• Added several new features and improvements to internal Medical Bill Review module, including the ability to reconsider medical bills, more detailed tracking of approval/denial reasons, mass entry of new bills, and improved interface with an external rules engine managed by another team. • Improved triggering logic for the automated task management system used by Claims department.

Bachelor Of Science, Mathematics And Economics

Education record

Activities and Societies: National Honor Society, Track, Cross Country, Quiz Bowl, Band, Choir