Ernie Castruita Email & Phone Number

North Richland Hills, Tx, Us

Fort Lauderdale, Fl, Us

Major Responsibilities;Lead strategy development and transition for a SQL server data on-prem environment to an enterprise data warehouse on a lake house architecture leveraging AWS RA3. Deliver good data to Amazon dropping competitors and choosing Kaplan.Assist in design and launch of managed services provider agreement with Amazon, Inc. to provide non-educational support service to fulfillment center associations across multiple countries.Key Deliverables;• Generated a hybrid team model with resources in America and India.• Rebuilt and stabilized data engineering team, established CI/CD processes, and recruited top talent by devising succession strategy.• Built the business case for a data governance function, Enterprise-wide organizational structure, and policies/standards.

Tukwila, Wa, Us

Major Responsibilities;Led the organizational redesign of the data engineering organization and cross-functional alignment with data operations, data governance, and business analysis. Directed and monitored the implementation, training, and adoption of BI tools, including Alteryx (Server, Connect, Desktop) and Tableau.Key Deliverables;• Drove savings of 30%, including managed services 24/7 Tiers 1/2 operations support contract by negotiating vendor contracts.• Directed a technical team of DBEs, BAs, and developers on decommissioning of an on-prem enterprise data warehouse, including conversion of 2k+ reports across 22 business units and over 200 report owners in an Azure environment.

Seattle, Wa, Us

Major Responsibilities;Led strategic product roadmap and feature prioritization for analytical products. Directed a team of BIEs, DEs, and SDEs in development of analytics tools in support of rapid international expansion teams through provision of 138 key business metrics across 23 Amazon-wide disciplines, including marketing, advertising, customer service, supply chain, and OPS/GMS. Influenced strategic priorities through insight-provision and systemic analysis by serving thought-leader on metric identification, definition, and visualization.Key Deliverables;• Impacted 500k+ employees by developing mathematical models for key cost and process metrics across worldwide Amazon operations network influencing processes while leading worldwide project teams.• Identified $150M in cost-saving opportunities through statistical process control (six-sigma) while developing standard methods and algorithms for entitlements calculations for strategic process improvement prioritization.• Created reporting and analytics repositories, designed, published, and automated strategic/tactical reporting and predictive models leveraging AWS stack (Redshift, Lambda, Glue, S3), Python, Alteryx Server.• Obtained big-data (12B+ daily records) from relational and NO-SQL databases.• Ensured zero unplanned-turnover-rate by leading performing team through performance improvement and promotions.

Us

Major Responsibilities;Monitored all returns related processes, inclusive of regular reporting, compliance, and insight provision. Created and executed semi-automated processes and controls for accountability reporting on critical outsourcing projects. Identified, prioritized, developed, and implemented system improvements across entire supply chain by acting as divisional champion. Broke down silos and created an environment of knowledge-sharing/collaboration through relationship-building, a customer-centric approach to problem solving, and development of a flexible and capable analytics team.Key Deliverables;• Ensured data integrity of reporting in any/all systems and continuity and succession planning of returns team.• Oversaw development and application of non-parametric modeling through self-learning algorithms to initial distributions function leading to a 20% accuracy increase for store-level demand predictions.• Met timelines/deliverables on RTC and Le-Regie processes to support needs of warner brothers and internal business partners for successful title releases.• Advanced reporting roadmap and future design objectives by formulating and executing best practices in KPI reporting/service level scorecards.

Brea, California, Us

Us

Atlanta, Georgia, Us

Vevey, Ch

Us

Managed the Liquitex brand of art products' in-store and in-school demonstration program.

Washington, Dc, Us

Mba, Entrepreneurship & Finance

Bachelors Of Science, Information Technology

Advanced Certificate, Marketing Research