Tinca Information Solutions Inc.

Home Bio Contact Contents Search

What is offered

  • Evaluation of data analysis and reporting tools, as driven from business reporting requirements.
  • Extract, transformation and load (ETL) tool justification.
  • Cost-benefit analyses of data tools.
  • Metadata repository design and implementation.
  • Utilities to update ERwin, PowerDesigner and other modelling tools.
  • Oracle specialist: experienced with Oracle SQL, PLSQL, procedures and triggers

Relevant experience

  • Designed complex Oracle Application Express (APEX) database for metadata management and control.
  • Produced ETL tool analysis and purchase justification, resulting in the purchase of Informatica PowerCenter.
  • CA ERwin and Model Manager (ModelMart) setup and configuration.
  • Author of Enhanced Metadata Utility (EMU) to simplify the jobs of architects and data analysts.
  • Sybase PowerDesigner power user.
  • Extracted metadata from JD Edwards EnterpriseOne into database repository
  • Configuration of Informatica SuperGlue repository for end user access and reporting.
  • Co-authored technology evaluation of OLAP, query and reporting tools, including Essbase, Business Objects, Cognos and Crystal Reports.
  • Generated cost-benefit analysis and migration strategy to Hyperion tools for Executives.