Resume

 

Charles H. Swartz

2356 Peninsula Drive. Shell Knob MO 65747

(808) 202-6030
charles.h.swartz@gmail.com

 

Successful Information Technology Professional with experience
in providing efficient solutions in a variety of situations

 

 

PROFESSIONAL SKILLS

 

Healthcare Information Technology, Microsoft SQL Server, SSRS, SSIS, DTS, Transact SQL, Stored Procedures, QNXT, Microsoft Visual Studio, Microsoft Team Foundation Server

 

PROFESSIONAL EXPERIENCE

 

 

Delaware Information Systems, Wilmington DE                                                                                            11/22 – 01/23

QNXT Developer

Creating/modifying T-SQL Functions and Procedures Creating SSRS reports Creating SSIS Packages

 

Symphony Corporation, Madison, WI                                                                                                 10/21 – 12/21

QNXT Developer

Creating/modifying T-SQL Functions and Procedures Creating SSRS reports Creating SSIS Packages

 

Diversified Systems, Westerville, OH                                                                                                   3/21 – 6/21

Data Analyst

Creates accurate mapping documents according to the mapping process. Works toward delivering a first draft solution to ETL for coding, by rapidly understanding which details about the mapping can be deferred. Supports DSD creation and response. Presents analysis and design recommendations to lead MITA teams, customer and/or vendors into the acceptance of the design. Supports the ETL developers based on the mappings created. Works closely with configuration team and DBAs to ensure synchronicity of configuration to interfaces and mappings. Refines mapping documents, adding more detail and filling out deferred material as questions are resolved. Uses SQL, data models, data element dictionary and schema to perform data and business analysis. Creates unit test cases for area of responsibility. Validates test plan results that satisfy the detailed design goals. Updates technical specifications and mappings. Supports Unit Testing, System Integration Testing, System Testing, and User Acceptance Testing.

 

 

Valley Health Plan, San Jose, CA                                                                                                          7/18 – 4/20

Senior Management Information Systems Analyst

SSRS & SSIS specialist Creating Transact SQL Stored Procedures and Functions Creating custom Datastores for use by junior developers Primary focus is on the QNXT Claims Processing System Integrating with other systems including Milliman MedInsight, Truven Health Analytics/ IBM Watson Health, MedImpact, Navitus Health Solutions, Medi-Cal (CalHEERS), CMS, and Valley Express Parse 834 and 837 data to aid in resolution of failures loading enrollment and claim information into QNXT. Creating reports for various HEDIS measures Assisting upgrade of QNXT from 4.2 to 5.6

 

 

HealthTECH Resources, Inc. Phoenix, AZ                                                                                          4/16 – 7/18

Senior SQL Developer, SSRS, SSIS & QNXT Specialist

Aiding Valley Health Plan in San Jose after their conversion from Diamond to QNXT

Gather business and technical requirements for SSRS reports or Interface file extracts

Create and analyze T-SQL reports, scripts, views, tables, procedure for various areas: Member, Enrollment, Finance, Provider, UM, audit (NCQA, HEDIS), and interface files extracts

Subscribe reports using SSRS or SSIS package and upload reports on SharePoint for customer self-service

Perform data analysis to ensure accuracy of SSRS reports or SSIS integration efforts

Analyze existing SSRS reports and stored procedures to improve performance and accuracy

Correct and standardize various SQL jobs/stored procedures that were incorrectly creating entries in the QNXT Process Logs

Work with vendor to develop file exacts and ensure the data set works with the vendor’s application

Correct and simplify archiving processes using stored procedures and SSIS

Assist in testing and quality assurance of various custom applications

Develop SQL ETL solutions utilizing SSRS and transferring of data via SFTP

Develop ETL solutions for integrating among various system: QNXT, Valley Express, Diamond, Data warehouse

Instruct junior developers in proper gathering of business rules and requirements Develop best practices, principles and methods of analysis, software development and validation techniques

Implement a set of reference tables or views to aid in the speed, accuracy and consistency of development efforts Provide knowledge and expertise of the QNXT claims processing system to coworkers, business users and vendors Aid in the transition of existing reports from the Diamond claims processing system to QNXT Develop troubleshooting and debugging techniques and standards

 

 

 

TEKsystems Honolulu, Hi                                                                                                                      9/15 – 11/15

SQL Developer

• Working with IntrapriseTechKnowlogies LLC to aid 7-Eleven in upgrading their Microsoft SQL Servers from 2005 to 2008

·        Analyze and modify VB .Net and VB Script programs

·        Analyze and modify VBA programs in Microsoft Access

·        Analyze and modify T-SQL Stored Procedures and SQL Agent Scheduled Jobs

·        Analyze and modify SSIS and SSRS Packages

·        Replace deprecated sp_makewebtask procedure used for creating HTML Reports with custom code

·        Languages utilized include VB .Net, VB Script, VBA for Access, PowerShell, HTML, XML, and DOS Batch Language

 

 

Solutions Consultants, Inc. Chesterfield, Mo                                                                                    6/15 – 9/15

SQL Developer, QNXT Integration Specialist

• Aid Corizon Healthcare in supporting QNXT 5.2 healthcare management system and custom processes for claims processing and system integration

·        Create custom reports using SSRS and stored procedures as well as scheduled SQL jobs that run the reports and send them to email distribution lists

·        Create and modify various EDI interfaces and SQL jobs with Corizon clients using SSIS and stored procedures

·        Trouble-shoot and correct various stored procedures that were returning erroneous results and/or performing poorly

·        Assist in testing and quality assurance of various custom applications

·        Correct and standardize various SQL jobs/stored procedures that were creating entries in the QNXT Process Logs incorrectly

·        Clean up various reference data such as HCPCS codes incorrectly entered into the Diagnosis Code tables

·        Correct and simplify archiving processes using stored procedures and SSIS

·        Create or modify utilities written in Visual Basic .Net

·        Perform code review for submitted Reports and/or Stored procedures providing recommendations for improving performance

·        Automate various processes to relieve support personnel of daily, weekly or monthly tasks

·        Corizon processes claims for the Department of Corrections as well as Jails so these are Medicare & Medicaid claims

 

 

HMSA, Honolulu, Hi                                                                                                                               1/09 - 12/13

SQL Developer

• Supporting QNXT 4.7 healthcare management system and custom processes for claims processing

·        Coordinate, correct and standardize the HCPCS, CPT, ICD9, HIPPS and DRG codes across all Lines of Business using SSIS and stored procedures

·        Update Fee Schedules and RBRVS using SSIS & stored procedures

·        EDI interface with Medco Health Solutions using SSIS, stored procedures, and Tumbleweed SecureTransport

·        EDI interface with First Databank and Medi-Span as well as stored procedures for combining data from the two drug information databases using SSIS, stored procedures, and Tumbleweed SecureTransport

·        Create and maintain MS T-SQL scripts, stored procedures, and functions

·        Custom reports with SSRS

·        Scheduled tasks using Cisco Tidal Enterprise Scheduler

·        Work includes Private Line of Business, Medicare & Medicaid

 

Ajilon Consulting, Town & Country, Mo                                                                                             7/06 - 9/08

Computer Consultant

• Aid Mercy Health Plans in migrating from Diamond to QNXT

·        Update HCPCS, CPT, ICD9, HIPPS and DRG codes using DTS and stored procedures

·        Update Fee Schedules and RBRVS using DTS & stored procedures

·        Software written in VBA for Access and Excel to aid in the maintenance of benefits, plans, and contracts and report discrepancies between Diamond and QNXT

·        MS T-SQL scripts, stored procedures, and functions for maintaining benefits, plans, and contracts

·        Reports using SSRS

·        Scripts for adding, changing or deleting records from Diamond using TinyTerm CScript Language

·        Work includes Private Line of Business, Medicare & Medicaid

 

Top Shelf Systems, Ash Grove, MO                                                                                                      1/03 - 4/06

Director of Development

• Develop and maintain CyberBOS Point of Sale software written in Visual Basic using MS Access or MySQL Server as the database

·        Automatic updating CyberBOS and database schema via the Internet

·        Enable the use of MySQL Server as the database source while still supporting MS Access for smaller installations

·        Ability to connect to databases via the Internet for companies having multiple sites

·        Utilities for importing and exporting data to and from SelJax

·        Allow companies to archive databases to file servers or CD ROM

·        Beta releases and major upgrades of CyberBOS

·        Empower users to create custom reports via intuitive selection criteria

·        Interfaces with signature pads, storing and printing signature images on statements, invoices and cash slips

·        Oversee development and maintenance of:

·        Interfaces with Quick Books accounting software

·        PDA interfaces for inventory and purchasing

·        Interfaces with SuperCharge and NovaLink for clearing credit and debit cards over the Internet

·        Conversions from multiple competitors and training in the use of Monarch for conversions

·        Implement the use of Visual Source Safe, standards for error trapping and logging, and code review standards and practices

 

Creditor Resources Inc, Indianapolis, In                                                                                             5/98 - 12/02

Field Support Engineer

• Installations and Technical Support for Credit Unions

·        Programming in MS T-SQL, VBA, and WinBatch

·        MS Windows/NT Server, SQL Server, and CRI Products

·        MS-DOS or Windows workstations with CRI Products, MS Office, and other end-user applications

·        Forms and reports using Crystal Reports and CRI software

·        Terminal emulation with Core Bridge, Rumba, and IBM eNetwork

·        Installing and configuring network hardware

·        Support end-users on site or via phone and remote control software

 

Financialware, Indianapolis, In                                                                                                             1/97 - 5/98
Installations and Support

• Installations and Support of item processing and image processing systems for financial institutions

·        Programming in MS Visual Basic, MS T-SQL, and COBOL

·        Creating and maintaining forms and reports using Crystal Reports

·        MS Windows/NT Server, SQL Server, Kofax Optical Server, and Financialware Products

·        Windows workstations with Financialware Products and other end-user applications

·        Programming and supporting NCR 7770 and 7780 Proof Machines

 

Reilly Industries,  Indianapolis, In                                                                                                        1/92 - 1/97
Computer Programmer

·        MS Visual Basic, VBA, Borland C, and MicroFocus COBOL

·        Creating and maintaining forms and reports using Crystal Reports

 

EDUCATION

 

Professional Careers Institute, Indianapolis, In                                                                             1/ 83 - 12/83

Computer Science: COBOL, BASIC, and RPGII on IBM System 34.

 

Carmel High School, Carmel, In                                                                                                           11/76 - 6/81