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

Education

Education
Sep 2003 - May 2005

Baccalaureate

CUNY

Skills

Skills

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