C
Carlos Eduardo Ochoa Patena
About
Detail
Chihuahua, Mexico
Contact Carlos regarding:
work
Full-time jobs
Starting at
USD1k/month
groups
Networking
Résumé
Jobs
verified_user
0% verified
Data AnalystBrightOct 2024 - Jan 2025 (4 months)• Analyzed the material flow process to identify the root cause of material loss within the company.
• Extracted database information using SQL, providing key insights on purchase orders and customers.
• Automated a custom Google Sheets format connected via SQL queries, streamlining purchase order creation and enhancing administrative efficiency.
• Designed interactive dashboards with SQL-extracted data to facilitate insightful decision-making across departments, including the use of Tableau for enhanced visualization.
• Implemented and managed a comprehensive purchase order tracking system using Retool, increasing visibility and control over orders.
• Designed and implemented a standardized process- Operations SupervisorTextron AviationFeb 2021 - Dec 2023 (2 years 11 months)• Collected SAP process data to identify performance patterns, outliers, and predictive trends.
• Analyzed large datasets in Excel, utilizing advanced tools like Pivot Tables, Power Query, and statistical functions, achieving 30% production time savings.
• Automated data extraction and transformation processes using Excel macros, reducing KPI report generation time.
• Conducted exploratory data analysis (EDA) and applied statistical techniques to develop a continuous improvement project, reducing riveting process defects and creating a new defect-tracking KPI.
• Designed interactive dashboards and reports in Power BI, Tableau, and Excel, facilitating data-driven decision-making for operational and management - TWarehouse Logistics Analyst - InternTextron Aviation-Oct 2020 - Feb 2021 (5 months)• Analyzed warehouse logistics processes to identify improvement opportunities in material deliveries.
• Collected material delivery time data using SAP and Excel to identify patterns, outliers, and trends.
• Conducted statistical analysis in MiniTab to develop new material process KPIs.
• Designed a new material delivery process, reducing time and presented the results to materials management leaders. Additionally, utilized Tableau to create a comprehensive report that visually represented the improvements achieved, enhancing the clarity and impact of the presentation to management.
Education
verified_user
0% verified
- PPower BIOct 2024 - Current (2 years 1 month)
- IMulticultural ExchangeILSCJan 2024 - Aug 2024 (8 months)
- IIntermediate PythonMar 2023 - Apr 2023 (2 months)
- Data AnalystTripleTenJan 2023 - Jan 2024 (1 year 1 month)
- DData Analyst in SQLFeb 2020 - Jun 2023 (3 years 5 months)
- QQuality Process Analyst – ASQ CertificationFeb 2019 - Dec 2019 (11 months)
- Industrial EngineeringInstituto Tecnológico de ChihuahuaJan 2016 - Jan 2020 (4 years 1 month)
Projects (professional or personal)
verified_user
0% verified
- VVideo Game Sales AnalysisMay 2023 - Jan 2024 (9 months)Analyzed historical video game sales data to identify market trends and purchasing patterns. • Analyzed over 10,000 sales records, identifying key trends and performing statistical tests revealing 95% confidence level differences between platforms and genres regarding user ratings. • Utilized Tableau to present results effectively, enhancing the clarity of insights derived from the data analysis. • Leveraged Python and its libraries, including Pandas, Scipy, Seaborn, and Matplotlib, to conduct in-depth statistical analyses and data standardization, ensuring robust and reliable findings that informed strategic decisions in the gaming market.
- MMarketing Expense AnalysisFeb 2023 - Feb 2024 (1 year 1 month)Analyzed user behavior on a website using activity metrics, session durations, and return frequency. • Examined historical visit, order, and cost records to gain insights into user behavior, such as daily, weekly, and monthly active users, session durations, and return frequency, assessing customer profitability over time. • Utilized Tableau to visualize data trends and enhance reporting capabilities, complementing the analysis performed with Python, Pandas, and Matplotlib, and providing a comprehensive view of user engagement and financial performance.