Subordinates: 2Data Warehouse maintenance including minor improvements to the different data models (course management, human resources, treasury, scholarships, academic tutoring, help desk, among others)Design and development of reports required by the different academic and administrative departments of the UANL in relation to the existing data modelsTechnologies: MS SQL Server, MS SQL Server Integration Services, Progress DB, Oracle DB, TOAD, SAP Business Objects Web Intelligence, SAP Business Objects Universe Designer, Star Schema Data Model and Kimball methodology.

Client: Bank of AmericaSubordinates: 2Analysis, design and development of reports required by the Corporate Security department using SAP Business Objects Web IntelligenceAnalysis, design and development of improvements to the Data Warehouse including adecuations to the universes in SAP Business Objects Universe DesignerTechnologies: Oracle DB, SAP Business Objects Web Intelligence, SAP Business Objects Universe Designer, MS Sharepoint.

Client: Bank of AmericaSupport to a transformation project where the DW from the banking client was being transformed to a new IBM model called Banking Data Warehouse. We worked together with a near shore team. The tasks executed were “source to target mapping” and “test cases review.”Technologies: MS Sharepoint, Local Network Website, MS Excel.

Analysis and design of the indicators, cubes and reports required by the logistics departmentDesign of the logistics data modelTechnologies: DB2, MS SQL Server, MS SQL Server Integration Services, Kimball Methodology.

Subordinates: 4Analysis, design and development of the indicators, cubes and reports required by the different departments of the UANLDesign and development of the UANL data warehouseDevelopment of statistics and indicators for 15 academic units (faculties), for the departments of course management, human resources, finances and planningMaintenance and support to the Data Warehouse and the Business Intelligence applicationTechnologies: MS SQL Server, MS SQL Server Integration Services, Progress DB, Oracle DB, MS Visual FoxPro, TOAD, IBM Cognos Query Studio, IBM Cognos PowerPlay, SAP Business Objects Web Intelligence, SAP Business Objects Universe Designer, Star Schema Data Model and Kimball methodology.