David Mangatal
ETL Developer at Decisionedgroup Inc.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Native or bilingual proficiency
Topline Score
Bio
Credentials
-
Learning Python
LinkedInFeb, 2021- Nov, 2024 -
Python Quick Start
LinkedInFeb, 2021- Nov, 2024
Experience
-
DecisionEd
-
United States
-
Software Development
-
1 - 100 Employee
-
ETL Developer
-
Jul 2009 - Present
ETL Development to support BI Data Warehouse solution at School Districts throughout the USA. ETL Development to support BI Data Warehouse solution at School Districts throughout the USA.
-
-
-
The School District of Palm Beach County
-
United States
-
Education Administration Programs
-
700 & Above Employee
-
Independent BI Consultant
-
Mar 2005 - Jun 2009
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… Show more 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. Show less 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… Show more 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. Show less
-
-
-
The Baer Group
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Senior Cognos Consultant
-
Sep 2002 - Feb 2005
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, FL Total Systems, Inc. (TSYS), Columbus, GA 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, FL Total Systems, Inc. (TSYS), Columbus, GA
-
-
-
Cognos
-
Software Development
-
100 - 200 Employee
-
Senior Consultant
-
Feb 1999 - Aug 2002
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 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
-
-
-
PwC
-
Professional Services
-
700 & Above Employee
-
IT Consultant
-
Jul 1997 - Jan 1999
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)… Show more 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. Show less 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)… Show more 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. Show less
-
-
Education
-
1995 - 1997
Howard University
MBA, Finance -
1985 - 1988
University of the West Indies, St. Augustine Campus
Bachelor of Science (BSc), Electrical and Computer Engineering
Community
