David Castellanos

Results-driven Business Analyst specializing in system optimization within the global retail and apparel Product Development lifecycle. Partners with cross-functional stakeholders (Design, Finance, Product Dev. ,Sourcing, IT) to define requirements, lead data standardization projects, and enhance operational efficiency for global brands Wrangler and Lee. • Consolidated six fragmented global costing templates into a single, streamlined version to automate the ingestion of critical attributes into the Enterprise Data Warehouse (EDW), ensuring 100% data consistency across global brands • Developed a historical costing update framework that provides stakeholders with granular visibility into year-over-year cost measurements and margin trends within the EDW data lake • Authored comprehensive Business Requirement Documents (BRDs) and process flows that secured formal sign-offs from cross-functional leads, reducing development rework by ensuring technical builds aligned with 100% of business needs

Directed enterprise-level IT solutions to enhance product management, streamline global workflows, and drive business efficiency. Served as a key strategic partner to merchandising, sourcing, planning, and product teams while leading digital transformation initiatives across PLM (Centric), DAM, and B2B platforms. • Consolidated line planning tools, reducing system redundancy and saving $270K; adapted Elastic platform to support HEYDUDE’s merchandising workflows. • Integrated restricted substance testing data into BOMs, streamlining compliance and eliminating redundant processes. • Managed Centric PLM system performance for 425+ global users, achieving 115% growth in user adoption and maintaining 90%+ monthly engagement. • Optimized data exchange between Centric PLM and CIM Trade Compliance, reducing user workload by 5% and improving data integrity. • Prepared performance dashboards and KPI reports to inform executive decisions and continuously improve systems. • Mentored a high-performing analyst team and led multiple improvement projects within budget, delivering measurable ROI.

Acted as Product Owner for Centric PLM across Crocs and HEYDUDE, guiding roadmap execution, platform optimization, and digital transformation efforts. Oversaw all aspects of PLM enablement from user training to systems integration to global process governance. • Led 6-month migration of HEYDUDE product teams onto Centric PLM, introducing new product line structures, segmentation, and assortment strategies. • Established 40+ KPIs across product, planning, sourcing, and innovation functions — enabling strategic decision-making and cost analysis. • Integrated Centric PLM with Adobe Illustrator and 3DEXPERIENCE to enable digital twin workflows and accelerate design-to-development timelines. • Converted Excel-based costing to structured PLM data, generating seasonal material and product cost reports with enhanced clarity. • Reduced sampling timelines by 1 month and cut bulk order cycles by 3–4 weeks through PO and factory workflow improvements. • Achieved a 25% increase in equipment efficiency via an automated mold allocation system for suppliers. • Supported a Centric-based global product calendar and led change management for global PLM users.

Led Centric PLM architecture, data governance, and downstream integration to SAP, Sitecore, Inspectorio, and Microsoft Azure. Acted as a global process owner for product lifecycle and costing flows. • Developed new .xml data architecture to streamline forecasting, line planning, and analytics. • Conducted in-person training for 50+ factory users across China and Vietnam, supporting capacity transfers and multi-sourcing strategies. • Migrated multiple Excel-based workflows to PLM (e.g., CE certificate tracking, innovation initiatives), increasing collaboration and reducing cycle times. • Collaborated with global stakeholders to improve factory, development, and supply chain efficiencies across product categories. • Managed international direct reports and doubled user adoption through user-centric support.

Spearheaded global PLM upgrades and custom tool development to support product teams across the US, Italy, and Asia. • Configured custom Centric PLM modules such as “Engineering Control” to optimize document and product release processes. • Led upgrade to Centric v6.2 across QA and production environments within 6 weeks. • Engineered custom slicer/report tabs and costing calculators, improving product launch accuracy and cost visibility. • Standardized NPI workflows across regions, accelerating new product commercialization timelines.

Served as the lead administrator for Centric PLM, supporting 215+ global users across design, merchandising, operations, and product development teams. Acted as the primary help desk and training resource for regional teams in the U.S., Italy, and China, handling issue resolution, process documentation, and adoption support. • Designed and implemented scalable PLM processes including Engineering Change Orders (ECOs) and add/change/drop workflows. • Acted as the technical lead for the Electronic Bill of Materials (eBOM) initiative, managing data architecture for materials, packaging, tooling, and component libraries. • Led cross-departmental workshops to align on “as-is” vs “to-be” processes, identify core data attributes (costed supplier quotes, AVL, naming standards), and build reusable templates. • Provided UAT and training support for process rollouts, ensuring effective adoption across multiple departments. • Partnered with IT and business users to diagnose system issues, suggest optimizations, and increase PLM reliability.

Acted as performance support lead for the Product Creation team, managing PLM support, process documentation, and team training across global offices. Contributed to PLM project execution and continuous improvement as part of the Centric 8 implementation team. • Maintained and entered large datasets in Centric PLM, ensuring clean, consistent product data across global teams. • Created process guides and user-friendly documentation to increase understanding of system capabilities. • Supported testing of PLM enhancements and participated in cross-functional prioritization meetings for development requests. • Assisted in planning and executing global training sessions, helping to onboard new users and standardize workflows.

Managed EDI order processing and fulfillment workflows using Oracle and Sterling order management systems. Ensured order accuracy and fulfillment for key accounts by working cross-functionally with customer service, supply planning, and distribution. • Oversaw the full EDI transaction lifecycle from order entry through shipment, managing exception alerts and early releases. • Prioritized fulfillment for high-volume key accounts by analyzing order books and coordinating with supply chain partners. • Conducted booking audits and ensured alignment to sourcing rules for 30+ major retail accounts. • Collaborated with planning teams to troubleshoot backorders, release holds, and fulfill orders against real-time inventory which for one project unlocked $3.65M+ in salable inventory in one month

Represented the Colorado Rapids as a brand ambassador at community and team events, supporting marketing, fan engagement, and game-day operations. Acted as a key public-facing representative of the organization, helping promote the club through grassroots marketing across Colorado. • Led the setup and breakdown of event assets including branded trucks, tents, inflatables, prize tables, and signage at 100+ events. • Executed promotional campaigns and data capture initiatives at games, youth tournaments, and local festivals to drive fan growth. • Coordinated halftime contests, player meet-and-greets, and pre-/post-game activations, enhancing the live fan experience. • Supported operational logistics for viewing parties, street fairs, and grassroots soccer events across the Denver metro area. • Served as a liaison between the club and the public, building rapport with fans and representing the Rapids’ values in the community.

Overall, my objective was to increase gross profit of the branch each month by growing relationships with established customer as an account supervisor, developed new leads with outside sales team, and channel representatives of top industrial manufacturers. Assess and maintain multiple product lines of inventory by using the turnover ratio and comparing order quantities with order levels. • Accounting: handle check and credit card discrepancies, tax exemption forms, W-9s, past due invoices, approve freight bills. • Customer service: create quotes, process purchase orders, drop ships, warehouse transfers • Inventory: Controlled inventory levels of over 100 products by working closely and efficiently with vendors.

• Partner with local soccer associations to set up promotional booth in order to accumulate and generate sale leads • Create partnership playbook consisting of FC Dallas rules, specifications, and media guidelines for all sponsored partners • Constructed a media display to highlight advertising locations within FC Dallas Stadium and Soccer Complex • Assemble gameday planners for President and Senior VPs consisting of critical VIP cliental and in game promotions • Develop media specifications and marketing guidelines for sponsors to clearly understand contract deadlines and elements • Conduct preliminary research on potential sponsors

• Coordinate volunteer events and activities and supervise volunteers to ensure proper execution of events • Sell tickets for a specific game using promotional and sales strategies • Collect, record, and analyze customer information into key demographics for ticket operations

• Provide outstanding customer service • Generate ideas for customers based upon their needs • Operate register responsible for sales, reconciling cash, and transactions • Re-stock and check inventory • Execute opening and closing of store • Shipping and receiving of inventory from vendors and to on-line customers

• Planned and promoted a KSU Baseball Game • Create and implement promotional plan • Arranged a sponsor to promote the game • Cherokee County Special Olympics Dodge Ball Tournament • Record and set up registration on gameday • Promote signing up for the event