Kitchener Jones

Experience

• 

  Laventhol & Horwath

  Mar 1989 - Nov 1990

  Junior Programmer

  Technical and programming support for the executive payroll office. Maintained bi-weekly system inputs to support payroll through LAN. Various projects involved programming in COBOL to produce specialized reports, create new applications and modify existing applications as part of the automated payroll system, CYBORG. Worked as part of conversion team to create the program, which would convert CYBORG files to ADP. Responsible for the input of system updates and magnetic tape filings for tax purposes. Provided technical support for payroll supervisors of 40+ practice offices. Show less

• 

  Central Health Services

  May 1992 - Dec 1994

  Business Office Coordinator

  Technical support and system maintenance of PC based PICK accounting/payroll/billing system. Provided all facets of payroll and financial reporting including quarterly and year-end taxes. Responsible for organization and maintenance of all payroll/billing/accounting information and documentation. Also provided office technical support for software applications: Windows, WordPerfect, MS Works, DOS, Norton Utilities, and Excel.

• 

  Green Spring Health Services

  Jun 1995 - Oct 1996

  Reporting Coordinator

  Database management, analysis and reporting from utilization and membership databases. Production and of internal and external reporting including all regular weekly, monthly and quarterly reports and miscellaneous ad hoc reporting. Technical support and maintenance of various internal data systems. Responsible for creation and maintenance of new and existing programs in support of the database environment. Programming in Superbase, KBase, Paradox and Visual Basic.

• 

  Magellan Behavioral Health

  Oct 1996 - Dec 2004

  Senior Programmer/Analyst

  Responsible for all aspects of database management and report production, including HEDIS and NCQA reporting, tied to the company’s clinical data systems in Philadelphia which managed mental health/substance abuse benefits for approximately 2.7 million members within Pennsylvania, New Jersey, Delaware, Texas, and Florida. Supervision of three employees: one Reporting Coordinator and two Data Acquisition Coordinators working with an in-house sub-capitation system where all sub-capitated encounter data is maintained. Coordinate the collection of data from multiple external groups into our capitation system either through a data feed or through the use of a scanner system, which captures data submitted on paper. Authorize in excess of $1 million in monthly payments to these external groups. Interact with the Analytical Services Dept. at corporate headquarters in Columbia, MD to ensure data quality and coordinate management and utilization of all database applications relevant to the Philadelphia Regional Service Center. Develop in-house applications to support data reporting needs. Show less

• 

  Magellan Health Services

  Jul 2005 - Dec 2014

  Senior IT Finance Database Analyst

  Responsible for all aspects related to the management and auditing of third party claims data through extensive use of SQL and MS-Excel. Integrated third party claims data with internal SQL databases for reporting and analytical purposes. Created additional reports and documents associated with this data for use within the finance department and for distribution to third party clients. Developed analytical processes related to third party claims data. These processes were related to managing data extraction from internal and external relational databases in order to complete audit requests, compliance reporting, and to support organizational metrics and analytics within the data warehouse environment. Produced reports and comprehensive data analysis through the use of SQL queries combined with Excel to complete ad hoc requests and follow-ups related to external client data. Produced reports and conducted data analysis related to annual financial settlements. Produced monthly/quarterly/annual finance claims related reports. Developed and maintained analytical reporting tools to support the needs of the finance department. Show less

• 

  City of Philadelphia - Office of Homelesss Services

  Aug 2016 - now

  HMIS Data Manager