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
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
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
Similar Profiles
Zachary BettsZachary Betts
VP Program Management at X-Therma IncVP Program Management at X-Therma Inc
Casey CostaCasey Costa
Pipefitter Foreman at Therma LLCPipefitter Foreman at Therma LLC
John PrattJohn Pratt
Regional Sales Manager at Quest (Therma-Stor)Regional Sales Manager at Quest (Therma-Stor)
Linda Tucker-CountsLinda Tucker-Counts
Plant Administrator/Maintenance at Altium Packaging LLCPlant Administrator/Maintenance at Altium Packaging LLC
Mars OjedaMars Ojeda
Customer Service Representative at Clear Cities PharmacyCustomer Service Representative at Clear Cities Pharmacy