Carlos Rocha Email and Phone Number

- Maintain and redesign Opera PMS pipelines- Lead data governance initiative, increasing monitoring, and deployment capabilities - Support revenue management and finance teams in resolving reporting anomalies, providing analytics solutions - Develop and implement scaleable and metadata-driven ETL pipelines

- Design and implement financial data pipelines using Azure Blob Storage, Python, Matillion ETL , and Snowflake- Develop ERP data transformation jobs using Matillion ETL.- Calibrate orchestration schedule efficiency using JupyterLab- Use Git to deploy code changes via Azure DevOps pipelines.- Collaborate with broader stakeholders in an Agile framework.

My role at One Six varied from project to project, and generally spanned various aspects of data analytics engineering and data warehousing. Ongoing client communication, cloud cost projections, data architecture design, automated load orchestration, and general project management communication underpinned every project. Specific examples of the role functions I fulfilled included:- Designing and implementing a data warehouse migration strategy for a fundraising platform developer, as well as developed Tableau Cloud data sources and dashboards. As my largest project with One Six, I was heavily involved in the new data warehouse architectural design decisions. We applied Kimball methodology and normalization to integrate overlapping data sources. At times this project also required “translating” complex PostgreSQL and MySQL logic to SnowSQL, ultimately for Tableau dashboard development. - Building out new Snowflake architecture using Matillion ETL jobs, and migrating legacy Excel report logic to SnowSQL views, helping optimize incremental load orchestration to reduce costs, and deploying a data mart self service for use by an investment banking firm client via ODBC connection and PowerBI - Migrating Excel report logic to PowerBI dashboards for use in live warehouse kiosk panels by a 3PL firm. This project required a new data model in PowerBI and building DAX measures to replace existing Excel formulas. -Enhancing healthcare data architecture using DbSchema, resulting in improving data model organization

As a data analyst, my responsibilities included resolving entanglements across datasets to support operations, ongoing quality audits, ad-hoc reporting requests, user acceptability testing- Manually aligned data across licensing databases and Salesforce CRM- Performed periodic Salesforce entity data quality audits, provided on-call CPQ support and user admissibility testing - Ad-hoc SQL report development in SSMS to provide joins not possible in Salesforce report builder

As a hardware logistics analyst, my duties included constant contact with our system integrator partners & Sales, troubleshooting EDI issues, coordinating with international distributors, ensuring shipments meet international compliance standards, user acceptance testing, publishing order pipeline reports, inventory reconciliation, fulfilling RMA requests, managing a proof of concept program, vendor PO requisition & generation, hardware warranty purchasing & reporting, and onboarding new team members.

As an intermodal coordinator, my focus was on facilitating communication between multiple parties spanning the supply chain. My daily responsibilities include sourcing drayage rates, dispatching containers, notifying clients of container availability, analyzing customs issues (AMS/ACE codes), and processing incoming vessel manifests.

My responsibilities as an operations team member included ERP batch order entry,, EDI troubleshooting, label sorting, and submitting accounts receivable claims.

My responsibilities at HD Supply included ERP order entry, cross-shipping, drop-shipping, and order tracking.

Seasonal textbook sales at Colloquium retail store.

As a technical support representative for Grande Communications, my duties included assisting customers with telecom hardware and software issues, issuing service tickets, and reporting outage trends.

In my role as a lab assistant, I aided the lab coordinator in maintaining software documentation, testing a new version of the university's online course management system, issuing debug tickets, researching open-source software solutions for department use, and aiding faculty in implementing Adobe Creative Suite for educational purposes.