ETL Development to support BI Data Warehouse solution at School Districts throughout the USA.

Provided project management and consulting services using Cognos software. Developed Reporting and Analysis solution for approximately 2,000 Principals, Vice Principals and Administrators. using suite of Cognos Studios. Led implementation of reporting solution for 17,000 teachers. Designed and implemented menu interface, security infrastructure (Active Directory,Framework manager,Reports), and reports for teacher Reporting Solution. Maintained and enhanced Educational Data Warehouse using DecisionStream ETL tool. Included creation of several summary tables for Dashboards, Cubes, and Reports.

Partnered with Cognos Corp as Consultant and Project manager for Cognos application development and DataWarehousing projects at School District Palm Beach County, West Palm Beach, FLTotal Systems, Inc. (TSYS), Columbus, GA

Provided BI Project Management, Consulting, and Professional Education Services to clients throughout the USA and Puerto Rico. Tasks Included:- Installation and configuration of Cognos Series 7 Software. Developing and Integrating Cognos BI solutions into existing customer products (OEM/ASP) – involving Cognos Scripting, VB scripting, PowerPrompt development (Javascript and HTML), and XML development. Conducting Cognos Certification Classes - PowerPlay, Impromptu

Assignment: Marriott International – Provide Year 2000 compliant Data Warehousing Solution for Marriott Reservations Worldwide. Designed and developed Impromptu Catalogs, Cognos Transformer Models and Cubes. Developed and presented prototype for Marriott Reservations Data Warehouse using Cognos tools, Impromptu and Powerplay. Designed HTML web pages as user interface to the prototype. Assignment: Completed 3 month Training Program - MCS Information Technology Individual Study (MITIS) program.Training covered the Price Waterhouse System development Life Cycle Methodology and System Management Methodology (SMM); GUI development tool PowerBuilder (PC and Oracle platforms), Oracle database, and C programming (UNIX and Oracle platforms); ISPF editing, COBOL programming, Job Control Language (JCL), DB2 database, QMF database query program; Introduction to JAVA programming (Sun server and Browser platform); and SQL Plus.