Roger Messiah

Roger Messiah

Data Analyst and database manager

Work History

Work History
May 2014 - Present

Knowledge Engineer

Olympus Corporation of the Americas
  • Knowledge Engineer Create development plan for implementation of new knowledge management system
  • Identify current data systems and create plan for consolidation
  • Assist in creation of new Service Audit database
  • Acquire and disseminate the most current and accurate product knowledge to staff Maintain integrity, validation and version control of quality systems
May 2010 - Apr 2014

Data Services Manager

Northern Manhattan Improvement Corporation
  • Planning and implementation of agency wide cloud based client data management system
  • Design and maintenance of forms, tables and reports in cloud based client system
  • Creation of Stored Procedures and view for reporting and user interfaces using SQL Server 2008
  • Design of weekly, monthly and ad-hoc internal and external reports using SQL Server 2008/MS Report Builder 3.0
  • Assist in planning and implementation of integration of external data systems
  • Create data base backups on a daily basis
Jun 2006 - Apr 2010

Assistant Director of Technology

Bronx Preparatory Charter School
  • Maintain and Update School Database System(The Education Edge)
  • Create and maintain all user accounts for school database
  • Design of weekly, monthly and ad-hoc internal and external reports using SQL Server 2005/2008 and Crystal Reports
  • Supervise Network technician and assist in all technology related issues
  • Create and restore all database backups on a daily basis
Aug 2004 - Nov 2005

Database Analyst

NYU Medical Center
  • Compile and analyze data from Oracle mainframe, transfer into Access and Excel for reporting
  • Transfer Data from Oracle mainframe into SQL Server Environment for standard and ad-hoc reporting
  • Perform pre and post Quality Assurance checks for Peoplesoft Integration
  • Design ad-hoc Access queries as required for day to day database quality control
  • Responsible for the analysis of various financial systems including, Payroll and Overtime.
  • Create Update Queries for daily changes to Conversion Data schema Set Up data configuration tables in Peoplesoft Environment
Jan 2002 - Aug 2004

Database Administrative Assistant

New York Sports Clubs(TSI)
  • Compile database data and Distribute as reports in Microsoft Excel/Word for Upper Management
  • Create Database queries(Access, SQL Server 2000) to identify and research member-related issues Monitor Month End process for member billing
  • Design ad-hoc Crystal Reports to compile trends in membership


Sep 2003 - May 2005





Microsoft Access

Design build and maintain databases

SQL Server

Creation of Stored Procedures, Queries, Triggers and Functions.

Microsoft Office

Word, Powerpoint, Access and Excel. Also proficient in VBA