Crystal Phillips Email & Phone Number

Torrance, California, United States

• Specializes in unraveling disparate systems, datasets, and tribal knowledge into actionable insights by discovering gaps and implementing creative solutions. -- Improves business decision making and optimizes outcomes.
• Ops Lead for ERP/MRP migration: Costpoint to Oracle.
• Drives the train while simultaneously laying down better tracks ahead: addresses immediate analytical needs while driving long-term solutions.
• Sleuths out what is mysteriously missing from the data or not readily seen, and discovers actionable insight in unlikely places by connecting dots across functions.
• Leads the end-to-end definition, solution, and implementation of an iterative deployment for an EAC approval process that bridges cross-functional teams to improve collaboration and accuracy for programmatic forecasts.
• Leads the end-to-end definition, solution, and implementation of a Purchase Requisition to Purchase Order workflow to facilitate efficient hand-offs and data integrity optimization.

Torrance, California, United States

• Led the end-to-end definition, solution, and implementation of an EAC reporting overhaul. -- Isolated input sections from calculation flows and data queries to reduce user error. -- Calculated cost, percentage.
• Consulted as a member of the MRP Task Force for the planning and execution of Costpoint MRP.
• Partnered with program management to provide financial analysis, trend monitoring, and results interpretation to ensure costs were accurate and comprehensive and to ensure forecasts were substantiated with data.
• Built and maintained a dashboard for Salesforce opportunity change history to improve pipeline forecasting and updates.
• Analyzed weekly/monthly variances, trends, and financial risks, while providing recommendations for corrective actions.
• Analyzed and monitored program risks and opportunities for revenue generation and cash flow, such as cost overruns and scheduling delays.

Torrance, California, United States

• Improved manufacturing estimates for level-loading the factory, projecting labor allocations, and outlining factory planning for future orders based on task buildups, training matrices, labor constraints, batch.
• Translated for program management, operations, and finance for EAC synchronization.
• Analyzed actuals from the general ledger and timesheet data for monthly incorporation.
• Analyzed data for ETC projections based on labor and material estimates required for remaining contract lifecycles.
• Analyzed data for baseline creation for new contracts and new delivery orders based on the proposals, operations master schedule, and labor and materials forecasting.
• Analyzed root causes for monthly variances of plan vs actuals by evaluating schedule changes, improved production efficiencies, labor increases due to design changes, and supply chain interruptions, etc.

Torrance, California, United States

• Handled production material flow and trained new employees on Costpoint modules and Excel.
• Developed an Excel inventory tracker tool to supplement limitations in Costpoint.
• Cross-Matrix support in analytics and forecasting: -- EAC support. -- Enhanced the Excel monthly production schedule tracker for improved performance.
• SME for Costpoint Manufacturing.

• Client Project Management & Analytics ---Managed staffing projects
• Consulted with clients for project requirement evaluations and contracts negotiation.
• Managed multiple programs simultaneously: planned and managed program timelines, progress schedules, deliverable submissions, and revenue generation.
• Developed a dynamic, business-critical Excel dashboard/project-tracker.
• Led a data mining project to collect and analyze 1M+ national job postings across multiple sources for lead generation during the initial Covid-19 shutdowns.
• Mined various candidate databases to identify and analyze viable skillsets for client needs.

Orange County, California Area

• Project Management & “Roll up my sleeves & jump in to do whatever needs to be done” --
• Audited multiple fundraising event financials and analyzed YoY improvement.
• Led the definition, solution, and implementation of a new CRM system, including system option research, data ETL across multiple sources, data migration, and testing.
• Managed the full life cycle recruiting program for multiple projects simultaneously.-- Led project requirement evaluations, sourcing, schedule planning, and progress tracking.-- Developed a dynamic Google Sheets.
• Led the development of a searchable actor database for enhanced overhead cost-savings.
• Led the implementation of an actor scheduling tool that reduced 75% of audition admin time.

Associate'S Degree, (3 Completed) Economics, Social & Behavioral Sciences, Arts & Humanities, 3.75 Gpa

Education record

Bachelor'S Degree, Analytics