Biotech engineer with 13+ years of experience using data and coding to speed up analysis, solve complex problems and improve decision making. Proficient in data mining, wrangling, modeling, insights, visualization and dashboard design. I regularly apply Six Sigma, Kepner-Tregoe & mathematical modeling for problem solving while using Excel, Minitab, Visual Basic, R, Python and Power BI reports and dashboards for data analysis, data mining (SQL query, Data Feeds, XML, Mercury, Access, Azure, etc.) and product performance monitoring.
-
Erp Data AnalystSteelcaseCiudad Apodaca, N.L., Mx -
Sr. Development / Process Engineer R&DKemet Electronics Corporation Oct 2021 - PresentMatamoros, Tamaulipas, MexicoNew Product Development- Created a product improvement roadmap covering product design opportunities and upgraded equipment capabilities.- Applied supervised learning to model and predict new product design recipes.- Developed prototype samples with a 40% decrease in direct current leakage.- Applied Ordinary Differential Equations to model and simulate chemical processes.- Improved process control by reducing 50% of temperature variation.- Developed Tantalum powder prototypes with 5 times the baseline surface area of SOP products.Side projects- Created a R-SQL database that speeded-up 400% data preparation times PE/QA analysis protocols.- Coded a Shiny application in Quarto/RStudio that allowed the interactive visualization of product quality indicators through the production line.- Implemented a dashboard for the Manufacturing team that automatically tracks and reports On-Time Delivery, Daily Production Rate, Yield, and Throughput Time. - Deployed a batch traceability dashboard in Power BI to comply with audit requirements and improve the Root-Cause Analysis process.- Created a dashboard template to engage the transition from Excel to Power BI for corporate HR.- Automated raw material waiver approval process with Power Automate.- Created organizational Yammer communities to spread awareness of Excel, Power BI, R, Python, and VBA productivity tools. -
Quality LeadKemet Electronics Corporation Apr 2017 - Oct 2021Matamoros Area, MexicoPlant transfer USA to MEX- Lead qualification of 13 products (capacitor grade tantalum powder) through AUTOMOTIVE and STANDARD protocols in 4 locations (Mexico 2 sites, China, Thailand)- Equipment and product evaluation/qualification- Raw material & supplier evaluation/qualification- ASQ certified quality auditorCustomer quality- Customer complaints, 8Ds, 3L5Y, SPC, process flowcharts, MSA- Specification creation and revision- Item setups- Product change documentation / New product documentation - ID sources of variation affecting critical parameters- Internal customer FPA and Yield trackingInternal testing area (20 employees)- Equipment: ICP, densimeter, LECO CS, LECO ONH, FT4 rheometer, laser PSD, etc.- Reduction of time to report results- Reduction of retests- MSA- Troubleshooting- Mistake proofingInternal quality, documentation and indicators- KPI in Excel and Power BI- Finished Product Acceptance: 16% improvement- Lot to lot variation reduction- ISO audit support- Work Instructions -
Senior Product EngineerEaton May 2016 - Apr 2017Reynosa Y Alrededores, MéxicoProduct type: electromechanical switches for heavy vehicle industryAchievements• Reduced NPI setup time by 61%• Implemented PN with sales value of $398K Activities• Custom / New product design• Process documentation• Cost reduction projects $82K• New material evaluation• CAD drawing creation and interpretation• Marketing and Customer Service liaison• 5S implementation -
Product EngineerKemet Electronics Corporation Apr 2012 - May 2016Anode Manufacturing Plant, Matamoros TamaulipasProduct type: anode for tantalum capacitorsProduct Engineer / Process Engineer• Reduced 15% throughput time• Improved First Pass Acceptance by 12% • Increased supplier FPA by 30%• Six Sigma Green Belt • Root cause Analysis: G8D's, 5 why's, Kepner and Tregoe method• PPAP, APQP, MSA, SPC, FMEA• Financial variance analyst (material, scrap, variable overhead...)• Proficient data mining and analysis skills• Evaluation, qualification and documentation of new materials and new product designs • Final customer complaint analysis• Developed mathematical predictive models for capacitance, pull strength, ESR, Oxygen diffusion• Vertical integration database for root cause analysis• Link between material Supply and Engineering departments• Supervisor of a multifunctional team combining Engineering, Technician and Operative members• Supplier development• Supplier quality documentation• Specification revision and implementation• Layered audits -
New Product Introduction EngineerKemet Electronics Corporation May 2011 - Apr 2012Matamoros Y Alrededores, MéxicoDevelopment and implementation of the New Product Introduction Project that safely launched new anode designs for Automotive, Military and Standard customers- Definition of SPEC limits- Initial setup for process parameters- Negotiation with customers to define and adapt process variables to get the desired capacitor performance -
Quality Control EngineerNutrecom S.A. De C.V. May 2010 - May 2011Nutrecom S.A. De C.V. Matamoros TamaulipasQuality Control Engineer. Product certification, quality standards definition, 8D’s & experimental design.• Development of master production program achieving a decrease of 28.7 tons in inventory, and eliminating out of stock situations from 9 to 0 in a period of six months• Modified warehouse layout that improved 10% product shipping speed• Managed the rehabilitation of a Quality Control Laboratory product inspection according to American regulatory organisms.
-
Research AssistantTecnológico De Monterreyapli Aug 2007 - Dec 2008Monterrey Nuevo León, México• Mastered a variety of molecular techniques such as RT-PCR, blue-white screening, electrophoresis, generation of recombinant bacteria strains, agarose and acrylamide gels, RNA and DNA extraction and purification.
Juan C. Education Details
-
Data Science And Business Analytics -
Exchange Program
Frequently Asked Questions about Juan C.
What company does Juan C. work for?
Juan C. works for Steelcase
What is Juan C.'s role at the current company?
Juan C.'s current role is ERP Data Analyst.
What schools did Juan C. attend?
Juan C. attended The University Of Texas At Austin, The University Of Texas At Austin, Instituto Tecnológico Y De Estudios Superiores De Monterrey.
Who are Juan C.'s colleagues?
Juan C.'s colleagues are Daniel Sada, Kaylee Moroski, Carlos Cambranis Chávez, Andreas Ulrich, David Contreras, Miles Morrissey, Maher Babar.
Not the Juan C. you were looking for?
-
-
Juan Carlos Peláez C.
Mexico City Metropolitan Area -
-
Juan Camilo Mejía C
Mexico
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial