Joseph Cillo Email & Phone Number

Springfield, Illinois Area

• Provide consulting services to a major hospital healthcare system related to the Information Builders’ Omni-Patient product, mapping clinical data into the Omni Patient canonical model from the AllScripts clinical data.
• Utilize Information Builders’ Iway MDS toolset to profile data, evaluating fitness for use of the clinical data in the Omni-Patient system, providing consultation and analysis on mastering the data, and making.
• Provide consultation on data governance and stewardship processes to optimize implementation of the Omni-patient system
• Provide consultation on testing processes and test planning in order to evaluate integration processes for the Omni-Patient product.

Greater New York City Area

• Information Architect at Novartis
• Evaluated the current state of the data quality framework for the MDM and Commercial Data Warehouse, evaluating process flows and identifying areas for improvement
• Made recommendations for the future state vision of information management, including: information governance and stewardship; Metrics collection and IQ Dashboard; Metadata Management; Improved data quality tools and.
• SAS DMP (DataFlux) Data QualityEvaluated current customer relationship management (CRM) data quality processes for Contacts and Accounts. Recommended, designed and implemented improvements using SAS DMP (DataFlux).

Princeton, NJ

Led the DataFlux DMP upgrade project on location at Bristol-Meyers Squbb. Converted existing application interfaces to use the new DataFlux application. Developed and implemented a new solutions architecture for the BMS Data Quality Service utilizing the new DMP application. Led the effort to develop and implement a data monitoring solution for the SAP.

· Trillium Data Quality Implemented the Trillium TS Quality application for the Merck COMET SAP project. Standardized requirements between the customer and vendor core and international market teams. Implemented batch and online processes in a validated environment including address cleansing for 28 countries. Responsible for delivery and vendor management.

Whitehouse Station, NJ Enterprise Sharing Architecture (ESA) 2004-2006 The ESA is a customer-focused enterprise data management group supporting data stewardship processes and a metadata repository that integrates and rationalizes data from a variety of sources. Supported publication and subscription processes for over 135 subscribers. The ESA database is.

Lebanon NJ HR, Payroll, and Benefits Support 2001-2004 Responsible for maintaining 12 Visual Basic front-end Client-Server applications. Developed program modifications in VB 5, VB 6, and Crystal Reports, including major revisions necessitated by a change in W2 format in 2002. Prepared update scripts using Wise Install. Managed data loads to the back-end.

On assignment at Merck, responsible for production support, program changes, and maintenance of Tesseract system (COBOLL II mainframe application)

Diploma, Computer Science

Got the highest grade ever on the comprehensive exam.

Ba, Music And Economics

Activities and Societies: Graduated cum laude

M.Ed., Mathematics Education

4.0 GPA