Junior Engineer with years of data driven and results oriented Product Data and Material Pricing Analysis in the Aerospace Engineering supply chain industry. Accomplished analyst that brings high-level business acumen and superior qualitative and quantitative data analysis skills and champions operational improvements to drive productivity and reduce risk. Meticulous critical thinker with dedication to data quality and security. Engineering background driven mathematical and numerical analysis skills, as well as coherent, logical, effective writing, oral and graphical communication skills that has resulted in an effective and skillfully systematic solution-based problem solver.
• Coordinated and managed $5 million in global Aerospace, Aviation and Defense cross-functional material sourcing projects with buying and sourcing, commodity management, and manufacturing teams to enable successful supply chain solutions to contracted clients for material procurement and manufacturing.
• Delivered competitive material pricing strategies and solutions to support growth margins meeting defined objectives for both new business bids to and ongoing re-pricing of existing projects by collaborating with global customer units, program management, and finance/sales leads.
• Coordinated sending and negotiating quote tenders with suppliers to establish cost and set pricing. Evaluated results of complex financial information to provide recommendations for cost reduction and profit growth, and ensured supply chain Lead Time (LT), Minimum Order Quantity (MOQ) and Estimated Annual Usage (EAU) are aligned with client needs and commits.
• Successfully researched client products for market trends to align aforementioned tasks with digital marketing campaigns for performance and brand, influenced by year over year growing competitive supply chain solutions reviews in market share.
• Managed Aerospace and Defense products, product data version control, and internal data flow-down for contracted clients to ensure current accurate data is represented in Product Lifecycle Management databases, with direct involvement in: CAD drawings, PCB design data, Bills of Materials (BOM), Approved Manufacturer/Supplier Lists, and Build Instructions.
• Analyzed and deployed both technical and commercial impacts of Engineering Changes Notices (ECN) on products from clients. Successfully communicated and reported data issues and other unmet requirements to internal and external contacts for data gap bridging.
• Consolidated, tabulated, and analyzed reports on performance metrics and commitments through Microsoft Excel, CRM software, and Power BI.
• Supplementarily aided in the data management and analysis script development and testing of new Product Lifecycle Management Software to replace existing aging infrastructure as product Data Analyst in collaboration with IT and Software Engineers. Identified, tracked, regulated and tested design iterations and pre-deployment bugs using Jira.
• Developed and managed Excel Macros and VBA for process improvement of standard product data analysis tasks.
• Worked in close association with team of Material Pricing Analysts, other Product Data Analysts, and Business Analysts in developing Bids and costing strategies for new projects and consolidating pricing data for awarded projects.
• Honors Bachelor of Engineering Degree.
• Excellent presentation and communication skills, refined by experience demonstrating competencies in verbal, written and graphical (analytical) communication developed through academic research experience and case competitions to professional groups, and internship experience communicating Aerospace and Defense Engineering Product Data Analysis in corporate settings.
• Refined Supply Chain Engineering, Systems Engineering, Numerical Analysis and Reasoning skills and experience.
• Experience analyzing large amounts of data from project and product lifecycles to build performance metrics, dashboards, and predictive and mathematical modelling.
• Excellent numerical reasoning skills with strong Proficiency in problem solving and programming using tools such as MATLAB, Maple, and C programming, with good knowledge in Python and SQL.
• Exposure and experience using volumetric data analysis packages VBA, Tableau and Advanced Excel to model, forecast, optimize, and automate repetitive tasks for continuous work improvement.
• Experience with formal Bids and Awards and material procurement scale pricing strategies to meet local challenges and minimize field costs.
• Excellent collaborator and cross-functional worker with the ability to manage strategical co-operation in intradisciplinary and interdisciplinary team environments, as well as intercultural and socially diverse teams.
• Strong Proficiency with complete Microsoft Office 365 Suite.
• Intellectual Curiosity, with great attention to detail, and process-oriented with the ability to follow predetermined guidelines and standards, as well as learn more to grow more.
• Excellent time management and commitment to deadlines with experience in progressive time constrained design, analysis and reporting, and cumulative tasks.
• Bilingual communication in English and Spanish.
• Extensive experience working fluidly and communicating with stakeholders inclusive of contracted clients and accounts of awarded businesses.
• · Refined experience in aerospace and mechanical Computer Aided Design (CAD), and simulation using Catia V5, Fusion 360, Solidworks and Ansys.
·• Strong knowledge of lean manufacturing processes and management, and Six Sigma principles.
• Willing to relocate as necessary.