Richard Ortiz Email & Phone Number

ETL Data Engineer 2015 - 2020Designed, developed and implemented ETL jobs that process data from CSV files, XML, RDBMS databases or cloud data warehouses• Constructed innovative generic Talend interface to load data automatically into Snowflake, reducing the number of individual programs needed to load csv files and simplifying the user experience. • Built promotional price change parallel interface to extract and process over 2 million records in minutes.• Developed ETL Talend interfaces to support migration of Belk.com Ecommerce website from Blue Martini to Salesforce Commerce Cloud (Demandware).• Generated foundation data interfaces required to implement Oracle Retail Xstore Point of Service application after working with the business to gather data requirements.• Collaborated with production support team to swiftly modify programs in response to production job failures.• Analyzed and implemented enhancements to address performance issues in ETL programs.• Created interface to load bulk data into Snowflake (Talend 7.1). Snowflake Data Warehouse Administrator 2018 - 2020Managed user access to Snowflake and migration of internal and external data to Snowflake• Created objects (databases, schemas, tables and views) in Snowflake and granted role access for user to access data.• Migrated E-commerce data interface legacy Unix scripts populated/retrieved data to/from Snowflake cloud warehouse.

Working at Fidelity Investment in Durhan, NC. Supporting the infractructure group by developing CICS solutions that are integraded with MQ to handle communication between the mainframe and other distributed application.

IT professional developer with 24+ years of experience analyzing, designing, consulting, deploying and managing software development projects for various industry domains. Strong analytical skills focusing in the business while being able to deliver consistently fast and quality solutions. Thrives in meeting challenges and initiatives.