Mitchell Small Email & Phone Number

Bedminster,Nj

Zelis Payments™, Inc. delivers easy, fast and reliable electronic payments and explanation of payments to healthcare providers upon adjudication of valid and payable medical claims and reconciliation. The Zelis system utilizes a patent pending process to deliver funds electronically and EOPs directly to healthcare providers via a newly developed web-based portal www.ppsonline.com. Zelis is the only system designed exclusively for healthcare that combines banking functions, claim payments and remittance and integration with traditional paper processes.• Offer technical assistance and direction to 4 person SQL Server development team. • Participate in weekly status meetings to senior management and stakeholders.• Develop and maintained Stored Procedures, SQL Server Integration Packages (SSIS) and SQL Server Reports (SSRS),• Developed processes and scripts to implement and configure new payers.• Developed daily payment status files and bank positive pay files conforming to vendor formats (Luminx, RedCard, Eldorado, Trizetto) and bank formats. • Developed and maintained SQL Server security model across development, test and production environments. • Developed SSIS package status reports and alerts notifying team members when processes fail.• Implemented SSIS package logging and package status reporting.• Developed reports, data driven reports and subscriptions using SSRS.• Setup daily and weekly data backups using Red Gate tool (SQL Backup). • Respond to data requests and resolve data issues.• Installed and configured Tableau Server. Set up Tableau security groups and permissions..Created Tableau Datasources, extracts and refresh schedules.

Bedminster Nj

Premier Healthcare Exchange provides advanced cost management solutions for health plans that combine claim processing automation with professional services to deliver a timely, centralized approach to healthcare cost management. This approach results in a significant reduction in payment errors, appreciable improvement in the time needed to bring claims to resolution and in savings that substantially reduce the healthcare costs of its clients. Responsible for database and data analytics support using SQL Server 2008. Designed and created databases and ETL processes for monthly claim, member and provider client data. Developed SQL Server Integration Services (SSIS) to extract text files, transform data into consistent format and load into SQL Server 2008 database. • Worked extensively with National Council for Prescription Drug Programs (NCPDP version 2.0 – HIPAA expanded) , RxEDO Payment Claims Transmission , LuminX and client file formats. • Developed stored procedures outputting monthly control total files identifying areas of interest such as claims without eligibility, active member counts and missing or bad data points. • Implemented file watch program to automatically copy incoming data files from ftp server to database server. Setup SQL Server job agents to periodically run load processes, unzip and manage data files.Installed and configured Tableau Server. Set up security groups and permissions

New York, Ny

. Developed and maintained market data feeds from vendors such as Intex, Loan Performance and Mark-it Partners. I developed processes that transformed market data into SQL Server 2008 using SSIS. Developed data extract reports on the entire CDO universe including subprime, prime, alt-a, second lien, heloc and option arm loans utilizing T-SQL and stored procedures. Provided data reconciliation reviews detailing how current calculations are performed for analytic measures such as expected losses and loss severities.

Responsible all aspects of software development including, but not limited to: 1 working closely with users to determine functional requirements 2 creating software to meet functional requirements 3 creating documentation and release notes4 preparing and packing software for release 5 installing software into production 6 providing production level support 7 set up and maintain source code version control systemTechnical Summary1 Designed and created tables, views, stored procedures, triggers, indexes in SQL Server.2 Created stored procedures, views, and C# programs to extract and update data in SQL Server.3 Visual Studio 2003 and 20054 Set up and maintained source code version control systems using Visual Source Safe.5 Provided DBA duties for development databases. Database back up, restores and optimization.6 Developed Crystal Reports and SQL Server 2005 Report Services