Summary
Overview
Work History
Skills
Timeline
Generic

Brian Crandall

Brea,CA

Summary

Diligent [Desired Position] with background in technical partnerships, bringing valuable experience in strategic collaboration and troubleshooting. Successfully facilitated numerous high-stakes projects, showcasing proficiency in technology integration and stakeholder management. Demonstrated analytical thinking and problem-solving skills to drive team success and ensure project milestones are met.

Overview

28
28
years of professional experience

Work History

Legence DW Data Lake

Therma Corporation
San Jose, CA
07.2024 - Current
  • Wrote ETL to migrate data from application layer through data lake to model lake house
  • Updated documentation to provide cross functional teams with detailed information allowing migration of existing reports to new destination REWRITE THIS environment
  • Wrote scripts to audit, validate, reconcile application source and lake house

Senior Technical Partner

Comp Three
Scotts Valley, CA
03.1998 - Current
  • Led successful migration efforts from legacy systems to modern platforms without compromising existing functionality or data integrity.
  • Implemented Agile methodologies in workflows which improved team adaptability, communication, and efficiency during the project lifecycle.
  • Enhanced software performance by identifying and resolving technical issues in collaboration with cross-functional teams.
  • Mentored junior team members, improving their technical skills and overall contribution to the project''s success.
  • Presented complex technical concepts to non-technical audiences, increasing understanding and buy-in for proposed solutions.
  • Developed customized solutions for clients, resulting in improved user satisfaction and increased revenue.
  • Optimized code quality through rigorous testing and debugging practices, ensuring a seamless end-user experience.
  • Streamlined workflow processes for increased efficiency and productivity through the implementation of automation tools.
  • Managed multiple projects simultaneously, meeting strict deadlines while maintaining high-quality deliverables.
  • Spearheaded cross-departmental collaboration, fostering better communication and understanding of project goals, ultimately leading to successful project completion.
  • Delivered exceptional customer support by addressing concerns promptly and implementing effective resolutions that enhanced client relationships.

Windchill PDM Link Post Migration Support

Raytheon
01.2019 - 07.2024
  • Identified and reported data anomalies
  • Collaborated with users to create custom extracts and reports
  • Generated business critical engineering performance metrics
  • Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks

Windchill PDM Migration

Raytheon
04.2016 - 01.2019
  • Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
  • Increased migration project efficiency by streamlining data collection and analysis processes.
  • Collaborated with cross-functional teams to identify potential risks, addressing issues proactively to minimize impact on project timelines.
  • Reduced data discrepancies for accurate reporting through diligent data validation and cleansing tasks.

SAP Post Migration Support

Raytheon
01.2006 - 04.2016
  • Collaborated with finance clients to identify and resolve reporting deficiencies between SAP basic functionality and US Government standards
  • Led the effort to design, develop and deploy custom data warehouse reporting structure to bridge gaps in financial reporting requirements
  • Built customized reports despite minimal user requirements, based on extensive finance experience

SAP Migration

Raytheon
09.2002 - 01.2006
  • Developed internal tools for automating repetitive tasks in the migration process, boosting team productivity levels significantly.
  • Supported system integration efforts by aligning data structures between legacy systems and target platforms.
  • Enhanced stakeholder communication by providing regular status updates and progress reports throughout migration.
  • Collaborated with cross-functional teams to identify potential risks, addressing issues proactively to minimize impact on project timelines.
  • Facilitated successful migrations by conducting in-depth pre-migration analyses.

Application Support and Data Warehouse

Therma
03.2000 - 09.2002
  • Created data models and mapped content storage pathways to facilitate easy access and support troubleshooting access issues.
  • Utilized comprehensive understanding of data types and best practices for organization and display.
  • Streamlined data retrieval for business users by designing and developing user-friendly reporting tools.
  • Ensured data accuracy and integrity by conducting thorough audits of source systems, validating transformation logic, and monitoring ongoing data quality.
  • Built data cubes, data marts and queries, maintaining every aspect of storage and translation.

ARS

Raytheon
03.1997 - 09.2002
  • Coordinated user acceptance testing efforts, facilitating timely issue resolution and smooth system rollouts.
  • Ensured compliance with regulatory requirements through diligent documentation and adherence to established policies.
  • Streamlined financial system processes by implementing new technology solutions
  • Collaborated with stakeholders to identify process improvements, leading to increased operational effectiveness.
  • Delivered high-quality results by consistently adhering to strict quality control standards throughout all phases of each project lifecycle.

Skills

Software Development

Training and mentoring

Problem-Solving

Relationship and Team Building

Adaptable and Flexible

Timeline

Legence DW Data Lake

Therma Corporation
07.2024 - Current

Windchill PDM Link Post Migration Support

Raytheon
01.2019 - 07.2024

Windchill PDM Migration

Raytheon
04.2016 - 01.2019

SAP Post Migration Support

Raytheon
01.2006 - 04.2016

SAP Migration

Raytheon
09.2002 - 01.2006

Application Support and Data Warehouse

Therma
03.2000 - 09.2002

Senior Technical Partner

Comp Three
03.1998 - Current

ARS

Raytheon
03.1997 - 09.2002
Brian Crandall