John Paul Castro

Senior Data Warehouse Architect Bi Architect @Incora

Incora is the world’s leading distributor and provider of comprehensive supply chain management services to the global aerospace industry, based on annual sales. The company’s services range from traditional distribution to the management of supplier relationships, quality assurance, kitting, just-in-time delivery and point-of-use inventory management. The company believes it offers one of the world’s broadest portfolios of aerospace products, including chemical, electrical and C-class hardware. • Chief Data Warehouse Architect that will integrate 3 ERP systems (JDE, tcmIS, GEAC) under one Cloud-based Data Warehouse. • Participates in the Strategic analysis and Development of all projects using different IT technologies for the company worldwide. • Design new and maintain existing Data Marts using SSIS and Qlikview/Qliksense. • Ongoing development of databases that reside in DB2, Oracle and MS SQL 2016 and 2019. • Constant tuning of indexes, creating of new Functions, Stored Procedures and Views. • Creates and maintains complex T-SQL, DB2 and Oracle queries, stored procedures. • Continuous Web development using Visual Studio.NET 2017/2019, C#, CSS, HTML, Javascript.