Medical Billing Sql Server

Michael T. Bee

Candidate Summary

He has **+ years of full life cycle systems applications development, including analysis, design, requirements gathering, development, software quality, and maintenance in a variety of industries, including manufacturing, logistics, finance, banking, and education. He has a deep level of expertise with Oracle and Visual Basic in n-tier environments. As a get-it-done team member, he works well with others and easily collaborates with other parts of the organization to successfully bring applications to production. He employs a sense of responsibility and ownership on the projects with which he is engaged.

Skills/Experience

Databases: Oracle, SQL Server, DB2, MS-Access/VBA

Programming Languages: Visual Basic, PL/SQL, ASP, VB.Net, SAS

Tools: TOAD, Mercury QuickTestPro, Visual Studio 6.0, Visual Studio.Net, MS-SQL Server,

Excel/VBA, Enterprise Manager

Operating Systems: Windows, Unix

Applications: Crystal Reports, WebFocus, Cognos Powerhouse

Work History

Sempris 1/12 - 3/3/17

Software Developer

Data Warehousing

Full life cycle transactions, i.e.,

oauthorizations

obillings

orefunds

ochargebacks

BI Reporting (PowerPivot / SQL Reporting)

List / Address Sales

Proof-of-concept for creation of sharepoint server

oSSAS

oSSIS

oSSRS

oPowerPivot

Worked hand-in-glove with Director of Finance and Finance Analysts to:

Create data islands. Took the bank transactions that drove Sempris LLC business and to create processes to extract Oracle posted debit, chargeback, refund transactions in mySQL structures. Assisted in the creation, exploration and implementation of PowerPivot models to present this info in a variety of reports and dashboards to upper management.

Worked with Finance and network staff to do a proof of concept for implementing a SharePoint server to present/deliver PowerPivot reporting

Worked with Finance and IT staff to do a proof of concept to use R for data mining of loan / address information

Created screen scraping processes to download bank transaction data for

reconciliation of financial transaction BI reports

Frandsen Corporation 7/11 to 12/11

Report / SQL Programming

• Medical Billing

• Cognos Connection

• MS-Access/VBA

• MS-SQL

While at Frandsen:

• Redesigned their medical billing from manual ~ spreadsheet processes into an MS-Access – used VBA to load ~ export ~ process data.

then MS-SQL database. Had begun converting the Ms-Access interface to LightSwitch

• Did investigative queries - traces against the HR system to locate additional report items

not directly available from the system.

• Learned basics of Cognos connection event, query, and report studios

Minnesota Department of Education 1/06 to 7/11

Reporting / SQL Programming

• MARSSWes / TestWES

• DIRS System (a disciplinary system for juveniles)

• Clics/FNS (Food Nutrition System)

• DDP (District Data Profile)

• Teacher Testing

Technologies involved~System Support

• Crystal Enterprise 11 (5yr)

• Oracle client

• WebFocus(2 yr)

• Excel/VBA (2 yr)

While at MN Dept of ED:

Participated in database and report design discussions, was a primary SQL Report developer in the systems noted.

Extensive work with MS-SQL Server 2005, Query Analyzer

Used VBA~Excel to automate ~ prove out Financial Data Mart reports

Used DTS to load Excel data into the Teacher Testing system

<fuller/more complete history available on request>

Contact this candidate