Sales Nursing

LARRY SCHLUSSEL

** ********* **** *****@***.***

Edison, N.J., 08817 732-***-****

INFORMATION TECHNOLOGY PROFESSIONAL

SKILLS – SQL, SQL Server Management Studio, SSRS, SSIS, Python, Java, Action script, Visual Basic, Visual FoxPro, TFS, VSS, PHP, XML, HTML, Flex, Flash developer, TSQL, C#, Crystal Reports, Excel, Word, Power point, Visio, Pascal, Cobol, Fortran.

PROFESSIONAL EXPERIENCE

9/2003 - Present

Logical Automated Systems – Consultant

Toys R Us – Board Member 2018 - 2019

oCurrently a board member of the newly created Toys R Us IT company called Toys Wayne. As a board member I meet with the CTO and CFO of Toys Wayne to determine the progress of winding down of the company and report to the rest of the board.

oReviewed budget and compensation packages for remaining employees.

oAnalyzed existing software, hardware and existing procedures to determine company status.

Care One 2018 - 2019

oMet with various department heads, VP’s and the company owner to analyze the company wide IT systems and make recommendations for improvement.

oLed a team in creating multiple SSRS reports and SSIS packages for rent tracking of multiple nursing home facilities

oOversaw the correction of SSRS reports that were producing incorrect data.

oConverted SharePoint system created by in house staff to a web based system that retained data in a SQL server database.

Partners Pharmacy 2018 - 2019

oImplemented companywide standards for reporting.

oCreated an automated alert system which constantly reads a daily log to determine if a pulse message is being received from multiple providers and produced warning emails.

oCreated an automated alert system which read records in a SQL database to determine the validity of the data received and produced warning emails.

Jzanus Ltd – 2010 – 2018

oTeam leader on multiple projects.

oCreated automated ETL import processes to bulk insert records from multiple hospitals that sent their data in a wide variety of formats.

oUsing CDC methods within SSIS, converted data into correct formats for the printing of UB bills.

oWorked with clients to create SSRS reporting system which updated accounts with modifications made by users.

oImplemented Devops best practices by enforcing all changes to go through VSS.

oCreated a clinical denials reporting system with customizable interface to allow a wide variety of reports depending on user selection.

oSupervised and trained new employees in the workings of the system and the common best programming practices used company wide.

oCreated triggers to update records with user and time stamp information.

Ashley Furniture Store 2005 - 2014

oMet with Owner and VP’s to determine scope of system requirement for KPI reporting and sales tracking system.

oCreated an SSRS sales analysis reporting module with over 30 reports to analyze and track company/store/salesman performance by year, quarter, month, week and day.

oCreated an SSRS advertising reporting module with over 20 reports to compare budgeted advertising expenses versus actual expenses, year over year comparisons and ROI.

oUpgraded and did performance tuning on the call center reporting system to analyze call pickup, response and talk time per operator.

Bronx Lebanon Hospital 2007 - 2019

oReviewed all open account receivables in order to clean up accounts not handled correctly by the PATCOM system.

oManaged project of scanning paper EOB from multiple insurers, wrote program to reformat scanned files, and posted remittances and denials electronically.

oWorked with multiple insurers to receive an electronic EOB. Wrote program to post remittances and denials from varied imports.

oCoordinated duel systems, PATCOM and FEGS, to work together for patient registration and billing information. Fixed payment discrepancies.

oCreated multiple reports based on Cyber Queries for a variety of users ranging from Managed Care projections to bad debt analysis.

oAnalyzed accounts to determine charity care allowance levels.

oReviewed patient information and removed HIPPA invalid information.

oAnalysis of accounts to determine bad debt status.

National Care Systems 2004 - 2019

oDesigned and programmed a HIPAA billing module for a large nursing home software company using Foxpro and TSQL combination.

Medical Source 1995 - 2000

oUpgraded existing system with new features and functions.

oConverted old UB92 billing format to HIPPA compliant format.

Jaguar Limo

oCreated a reporting module using SSRS and redesigned multiple user interfaces.

oUpdated billing modules

Aristacare

oCreated GL comparison reports.

oAnalyzed and reviewed multiple systems for use in different nursing homes.

JZanus

oConverted HIPPA billing files into reports using ETL procedures and SSIS.

Prior Experience

Comhill Systems - Project Manger 1990 - 2004

oAnalyzed original billing practices and created flow charts depicting workflow.

oLead a team of programmers in designing and implementing patient billing system.

oLead a team of programmers in designing an ad hoc reporting system that was build to user specifications.

Interactive Marketing - Lead programmer 1988 - 1990

oDeveloped a touch screen kiosk system installed in supermarkets dispensing recipes and coupons.

oCreated interactive mail marketing discs.

Mobius Management Systems – Programmer 1986 - 1988

oDesigned and developed multiple mortgage calculation system capable of calculating and comparing different types of mortgages

oDeveloped Library system for the blind and handicapped, tracking patron requests, items send and received.

EDUCATION

June 1986 Yeshiva University College

New York Bachelor of Science

Contact this candidate