Nestor DeCastro

Dedicated and results-driven Data Warehousing Engineer with over 15 years of experience in designing, implementing, and maintaining data warehouse solutions. Expert at data modeling, ETL processes, database administration, and business intelligence tools. Seeking to leverage expertise to contribute to the success of a forward-thinking organization.

Business Intelligence, Data Integration Manager at Venture Tech Solutions (2019-06 – Present)

• Designed data warehousing solutions and integrated ecommerce platforms for customer lifecycle management.
• Built cubes in SSAS, developed ETL processes, and integrated telephony data with CRM.
• Collaborated with business analysts to define data requirements and create comprehensive data models.
• Conducted data profiling and implemented data quality measures, resulting in a 20% increase in data accuracy.
• Tuned and optimized database performance, reducing query response times by 25-50%.
• Integrated phone systems data with CRM and utilized Artificial Intelligence for call result determination through call transcripts and AI.

Principal Business Intelligence Engineer at Medtronic (2015-01 – 2019-06)

• Defined data warehousing solutions for LATAM operations and integrated ecommerce platforms into ERP systems.
• Established data architecture standards, data quality strategy, and ETL methodologies.
• Consolidated 14 ERP systems and Salesforce cloud data into an enterprise data warehouse.
• Managed data integration and maintenance for Canada, Mexico, Central, and South America.

MIS Manager at COMCAST CORPORATION (2006-09 – 2015-01)

• Architected enterprise-class BI reporting solution for Business Operations, Finance, and Technical Operations.
• Designed and optimized ETL processes for data extraction, transformation, and loading.
• Managed SQL servers, security, access control, and database maintenance.

Director of Data Warehousing and EDI at PERRY ELLIS INTERNATIONAL (2004-08 – 2006-09)

• Led a team responsible for architecting and maintaining a complex GIS solution with EDI in a multi-terabyte SQL Server environment.
• Managed BI lifecycle from planning to implementation.
• Oversaw onboarding of new retail companies and managed SQL Server databases.

Director of Electronic Information Systems (EDI) at PERRY ELLIS INTERNATIONAL (2000-11 – 2004-08)

• Managed technology infrastructure and ERP implementations.
• Led the implementation and maintenance of SPS Commerce EDI system, achieving near 100% accuracy rate for over 90 customers.

MIS Manager at PRETTY TALK INTERNATIONAL (1997-09 – 2000-11)

• Implemented bar code technology to increase profits and improve customer satisfaction.
• Managed ERP, EDI, systems administration, and network security.
• Created the EDI platform.

Masters' Degree in Business Administration (MBA) – University of Miami (1999-12)

Bachelor of Science Degree in Management Information Systems – University of Arizona (1989-12)