QNXT Project to create Several SSRS Reports related to Claims, Providers, Eligibility.QNXT Data extract to HealthX. 22 different extract Files including Eligibility, accum, Claims, Auths, Provider

• Develop Several SSIS packages for Eligibility outbound to different plans, 1095B file• Develop Import SSIS of Softheon/Exchange Data• Create Reports from Data warehouse Database. Several Reports on Softheon Data. Financial Reports, Medicare Advantage Reports

• Create Custom QNXT reports for client New LOB. • Membership, Pending claims, Fund, Credit, And Delivery Reports developed via SSRS and SQL 2012

Develop Custom solutions for clients that integrate with our core product QNXT.Utilize C#, .NET, BizTalk, SSIS and SSRSQNXT 837,834,277 Add-In developmentUpgrade Client solutions during QNXT upgrade to be compatible with Database changes and DLL's

100% SQL solutions SSIS/SSRS, Design and Develop new processes to integrate wit QNXT based on Business needsWork Exclusively with QNXT in "Comprehensive Medical Dental Program" as well as "Developmental Disabilities Division"Support/fix Third party integration solutions to QNXT including 837, 834 Import and exportBizTalk configuration / support

Analyze existing SSIS packages and SSRS to modify reporting applicationBuild on-call administration website utilizing ASP.NET And VB.NET to replace current manual processCreate new reports utilizing SSRS

20% VB.Net / 60% SQL / 20% MVC• In charge of accuracy of Data provided to clients on multiple database schemas• In charge of Data changes to Live db’s requested from clients• Creator of new Stored Procedures used in Reports and Data transfers to Data centers• Create Custom reports in Crystal/VB.Net• New Project/Product – Lead Developer and Database Architecto Design New SQL Database, Constraints, Triggers, and SP’so Lead Developer on MVC Website (Backend Sql Development – Controllers-Repositories)o Approval of UI coding and Design

Migrate SQL server from 2008 to 2012 and to new hosted platformSSRS - Create new reports and modify existingSSIS - Configure several SSIS packages performing ETL from Oracle Prod to SQL Report ServerIIS and WCF

C#/SQL/ASP.NET DeveloperCustom solutions for 837,834 processing utilizing Microsoft BizTalk and XML parsingIntegrating with QNXT products, Burgess, Facets, Optum WebstratSSIS, SSRS, SQL Report Builder and Crystal Reports

Provide Electronic Medical Records Sales, Training and Support to Healthcare Providers and staff. Full IT company that can sell PC's, Servers, laptops, tablets and provide network maintenance and support.Primary projects included:SQL Admin – Managed hundreds of SQL Databases for Lytec Practice Management software on local Servers and our own remote hosted Servers. Custom queries for reports per requestManaged backups and coordinated with Network Admin on Database storage capacity planningManaged Database Security for end usersTroubleshooting of Database issues such as SQL memory leaks and bottleneckingSuperBillable – This was a program created in VB.net and VB 6.0. The program allowed a Doctor to view an Electronic Image of his Chargeticket on a tablet PC. User chose diagnosis codes and procedures done during a visit and the data would be sent to Biller interface where they could review and then post hundreds of lines at once into their Practice Management system. Built program in 2005 and have maintained and enhanced with new releases to date.Quest Diagnostics Lab order Interface – VB 6.0 program created to Pull demographic, Insurance, and Guarantor Information from Practice Managenment software and upload to Sonora Quest Care360 Website. User would enter Patient ID and all information would populate for them online eliminating need to manually enter. This saved office staff time when ordering labs for patients. Contract to sell product with Quest since 2004 to date.Arizona State Immunization Information System (ASIIS) Interface – VB 6.0 program created to Pull demographic, Billing information from Practice Managenment software and upload to ASIIS. User would enter begin and end date and program would retrieve state required information. Eliminated staff hours of pulling reports and formatting per state requirements.Project Management/ImplementationImplemented LytecMD,SuiteMed,Medinotes EMR to hundreds of private medical practices.

Programmer for custom projects – Projects mentioned above at N2 TechnologiesSQL and Pervasive Database administrationSoftware support for Lytec Practice Management and Medinotes EMROnsite and Remote Training to end users

QA AnalystHandled software testing for Medisoft and Lytec products . Handled scripting and batch files for building software using Vbscribt. Created and executed test plans. Maintained data servers, a bug tracking server, source control servers, and a document repository.