Designed a cloud based medical claims processing system. This system processes Professional, Institutional, and Dental claims while providing near real time information about the scrubbed claims. The rules engine can add or remove required information that billing software may not be able to provide. The smart EDI parsers can get most badly formed EDI and create a good claim out of it. This makes for nearly no rejects at the file level, only claim level.We have a full featured claim editor that allows editing of any field in the claim. This should help make billing easier where the biller doesn't have to go back to the billing software and resubmit claims.We can work with other software companies to develop API's that integrate into their own software.The processing system stays current with .Net 7 and an Angular 15 frontend.

Worked on creating .net core applications to work in a micro-service environment. The applications would connect to Epic's App orchard and send data to and from their main system. Also worked on Microsoft SQL databases and setting those up in a Linux environment.

Maintained legacy billing systems and fixed when problems came up. Also helped design a new billing system and worked on designing a document management system.

When I started, my job was to maintain the dimensional data warehouse. I quickly discovered that the data was modeled incorrectly. After talking to the business about the data and what they hoped to gain from the warehouse, I re-designed it from the ground up. I created new fact, dimension, and bridge tables. I also created new ETL packages in SSIS that load the warehouse nightly and once complete only have a few minutes of downtime.Outside of the warehouse I design queries for the company for the reports and dashboards they need. These are all connect to the portal in C# in common data access controls using a web api framework.I work some in the web, doing MVC, with javascript and Knockout.

Designed the new system databaseDesigned and wrote the a new .net input system, that parses Ansi 837 EDI and print image files of claims.Designed and currently writing and implementing the larger part of the systems.I was working with a high availability sql server running 2014 Enterprise. I setup backup jobs and designed the backup plans. I also did performance tuning on the databases. This ranged from better indexing, rebuilding indexes, RAM allocations, and even working with the temp database to help speed up all around. The data access layer of most of the system were in EF6. I learned how to work with EF to get the most speed out of it for batch processing.Used here: SQL Server 2014 Enterprise, SQL Server 2008r2 Standard, VS 2015 C#, EF 6, and VB6.

Help write the new billing systemsWrite application to create PDFs from scratch for invoices and other documentsWrite reports for various business usesWork with eConnect by creating applications to move customers and invoices to Great Plains

Write Web Services using ASP.Net 1.1 and 2.0 in C# and VB.NetDebug and fix legacy code written in VB6Parse XML documents using Xpath in .Net and VB6Project Overview HRXMLProject was already started before I got there. I had to go through the code and fix various bugs and see the project to completion.ClearStar IntegrationWrote a C# Windows application that communicates with the customer's webservice to receive their orders. The application this converts the customers XML format to HRXML using the .net serializer components.

Write Web applications using ASP.Net 1.1 and 2.0 in C#Act as technical lead to teamDesign and write reusable custom controls for web applicationsProject Overview Revenue Recover & Revenue ProtectUsing business rules given to my team by consultants. I helped design and write these web based application using C#. The applications were used at hospitals to recover lost revenue from insurance companies and patients.The major design decision I had my team focus on was code reusability. For this reason I wrote a custom table control, which could be used by multiple applications we were working on. This control would read it's configuration from an xml file. This would help because various clients wanted different fields on the work list. Then using reverse binding would let us display any other control on the grid.

Write Web applications in Cold FusionUse Webmethods to work with EDI transactionsWrite forms and reports using FormsPathProject Overview Web Order EntryOn a team helped design the companies first order entry system for the web. Using ColdFusion and JavaScript. The application had to be responsive enough to encourage users to use it over the old text based version. The challenge of this system was to use enough JavaScript to "appear" fast while trying to conserve memory on Windows Terminal Servers.Customer Integration Using WebMethods, CF, PHP, or Perl wrote systems that would either read EDI documents into the company database or write EDI documents to be sent back to customers or banks.Document Printing Solution (FormsPath project)Wrote CF or PHP applications that created the data file required by FormsPath to print the required form, for example print an invoice to give to customers. Warehouse Management SystemDesigned and created a packaging workflow system for the company's warehouses. The web application was written in ColdFusion and tied into the printing side of the Web Order Entry Project. Once the invoice was finalized the order was sent to several printers in the Warehouse that were close to the parts being ordered. The multiple pick lists were then accounted for and combined into a packing slip.

Created and designed databases in mySQL for use with PHP web pagesDesigned web application in PHPMaintained the new College of Business websiteProject Overview Faculty DirectoryUsing PHP objects and a MySql database created a reusable directory component for the college website. College WebsiteMaintained the college website by handling changes professors needed to make to class websites and various changes to the college website.

Wrote applications for Pocket PCs using eVB 3.0 and Microsoft SQL Server 2000 CEWorked with a team to design and create databases for MS SQL Server 2000Designed and wrote interfaces to databases in Visual Basic 6.0Worked under rapidly changing scopes and tight deadlinesDesigned object-oriented programs for Visual Basic.NETProject Overview Consultant Documentation ProjectWrote an embedded application that was to be used by the field consultants to create maintenance documentation for clients. Toward the end of my internship I was working on the design for the .NET version.

Designed and created databases for mySQL using INNODBDesigned and programmed interfaces in Visual Basic to use with databasesCreated database reports using Crystal Reports 8.5Project Overview Graduate Student DatabaseThis was a VB6 application that was used by various departments in the College of Business. The back end used a MySql. The reporting side use Crystal Reports 8.5 and took advantage of the VB6 viewing control.

Designed and built LANs and WANsDesigned and installed a six building WAN and 300 drops Managed the six building Wan on site and remotely