Data Medical

RICHARD V. KONIECZKA Programmer Analyst/Data Miner Full Time, Part Time, Contract

** ******* **** ****** *********: To Use My 17 years in the Accounting & Health Care Industry Bensalem, PA. 19020 using ETL process to collect, Store and Report on the data.

215-***-****

Database Management/Programming: VB6 - VB.Net (FW 2.0 – 4.5) using (Microsoft Office 97/2013

Work with Medical & RX data. Import all types of data from vendors, convert and produce required reports.

Use ODBC to access Oracle, MySQL database, and M/S SQL Server to validate data for report generation.

Extract, Transform and Load (ETL) data from BCBS, Express Scripts, Horizon, VSP and “Local Fund” offices.

Designed over 300 active working Data conversion (ETL) type applications.

Compare Claims Billing against Claims Paid for accuracy.

Create Reports: By Employer using member file, Missing Members & New Members, Claims By Plan Summary

Medical claims by Store & Employer, Utilization, Member Match/no Match RX, by Employer using member files

Missing Members & New Members, Claims By Plan Summary, Medical claims by Store & Employer

Set up invoice tracking system to relate to A/R, A/P functions and outstanding invoices.

Generate reports by customers, area, inventory items, and any other special criteria.

Manage inventory and purchases with MS Access (2.0 - 5.0) (relational database).

Generate year end reports and taxes totals.

Design full accounting package with reports for CPA firm.

Write database manipulation applications in Visual Basic & Windows (DB3, DB4, ACCESS, ETC.).

Design relational database using present business constraints to computerize existing business.

Education:

Philadelphia. College of Textiles & Sciences, Philadelphia, PA.

B.S. - Management Information Systems, Accounting Minor. GPA 3.16.

Electronics Training Center, Pensauken, NJ.

A.A. - Electronics Technology

Professional Experience:

Frank M. Vaccaro & Associates Inc, N.J. 10/2000 to 3/31/2017

Programmer/Analyst. Design programs to import/Extract and store client data for Report generation

Create CMS MSP File, Query File, and Tin reference File, process return file as per CMS GHP users guide.

Create ACA 1094/5 B & C for Employees and IRS

Write programs to convert data from one type of format to another type of format:

Medical claims by Store & Employer.

Create MOB reports in date range on Medical and RX, Dental & Vision Claims by employer, fund and eligibility

Educational Testing Service, Princeton, N.J. 9/98 to 10/2000.

Programmer. Design and code VB/Access various projects These project track complaints from a telephone call

through a validation process to a makeup exam or file status. Design automated mail merge process for

perspective examinees by selecting criteria from the master database. Create billing application using DDE to

print Excel style SS & export data to mainframe database. Design automatic update to existing users program,

updating user with latest version of program & database changes. Update programs for Y2K. Use “Capture

Screen” technology to import mainframe data to access database. Assist in converting above To SQL Server

6.5 Databases. Create “Auto Backup” and “Auto Batch” programs to update files on a daily basis. Create

“Electronic Feed” application to export honoraria payments to mainframe and update access database with

process results. Create Automated E-Mail Using M/S Outlook from within other applications. Create Spell

Check Using M/S Word’s dictionary file as a drop in to other applications. Write documentation for above.

Speech Solutions, Phila, PA. 3/97 - 9/98

Programmer. Design and code sample applications with VB 5.0 (32 bit) using voice technology. Alpha and

beta test same. Assist with documentation development. Complete “Full Life Cycle” development on above

projects

Young Ideas, Bensalem, PA. (1) 8/95 - 6/96 (2) (contract) 12/96 - 3/97

Programmer. (1) Design & code (VB) Medical Billing application. Full life cycle from inception to finished

product. (2) Design report generator with VB 4.0 (32 bit) accessing multiple Informix databases with ODBC

drivers. Use M/S Access to combine mixed data, while generating reports using Crystal Reports. Use M/S SQL

Server to test-validate data for accuracy.

Naval Air Warefare Center (FSEC), Warrminster, PA. 7/96 - 11/96

Engineering Tech. Write spec.’s & disassembly instructions. Certify computers for shipment. ( PC’s & Mac)

J.T. Distributing Co. Glenside, PA. Wholesale Food Distributor 4/92 - 8/95

Programmer/ Controller: Set up computerized accounting system. Responsible for A/R, A/P, Invoicing.

Design & code (VB & Access) invoicing program. Report generation with Crystal Reports.

Train employees on computer based systems

Burlington County Vo-Tech, Mount Holly, NJ. Secondary School 1987/1988

Instructor/Electronics Teacher: Taught High School students basic electronics to computer repair,

robotics and laser technology. Instructed students during laboratory classes for hands-on capabilities.

Salary Requirements: Negotiable

Contact this candidate