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.
• 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.

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.
• 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.

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.

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.