Matthew Ames Email & Phone Number

Philadelphia, Pennsylvania, US

• ETL Pipeline Project:
• Designed and implemented an automated ETL pipeline for quotations, orders, and sales data in a virtualized Scale Computing environment.
• Created data validation Excel sheets for data collection to ensure quality control. Excel met the company requirements as a cost-effective and familiar tool for all employees.
• Python extracts the Excel data, transforms it into the proper database format, and loads the data into the PostgreSQL database. Data quality checks are run during each step in the pipeline.
• Integrated the PostgreSQL database with Tableau to automate company dashboards.Database Project:
• Created and administered the company’s first SQL database using PostgreSQL. The open-source software met the company requirements as a cost-effective, low maintenance, and easily administered solution that values.

• Gathered, assessed, and cleaned data to conduct exploratory data analysis, uncover insights, and provide business process recommendations. Due to Jobin Machine's newfound interest in utilizing data, exploration of.
• Developed an engine program and sales analysis Tableau dashboard to breakdown production trends, which identified an over-dependence on specific customers and programs to be addressed and ensure stability moving forward.
• Analyzed a five-year customer order forecast schedule and categorized orders by engine type and program to more efficiently schedule in-house production and adapt to potential changes in demands.
• Created an interactive Tableau dashboard summarizing historical quotation data to improve the efficiency of Jobin Machine's new job bidding process.
• Performed data quality assessments and recommended new collection processes to enhance data quality. Reliable data sources were identified and used as the basis for exploration and analysis.
• Implemented and managed a company Enterprise Content Management System. Reviewed business requirements to define metadata structures, create dynamic data views, and integrate external data sources.

Shanghai, CN

• Communicated fluently in a Mandarin language work environment and with Mandarin speaking clients.
• Designed workflows and new business processes to support company growth, integrate Shanghai and Shenzhen branch offices, and meet the needs of a bicultural environment.
• Constructed a digital library of approved educational materials, course curriculums, and teacher resources. The library was organized into educational categories and levels to provide quality control across all course.
• Structured, designed, and implemented a Baidu cloud-hosted electronic document management system. Business documents were completely searchable, organized by business group, and secured with role-based permissions.
• Designed and implemented online academic student portals via the domestic collaboration software Teambition. The portals provided an engaging platform for student interaction, tracked academic progress and personal.

Shanghai, CN

上海, 上海, CN

• Conducted domestic market research for Intersport's key product lines, a European-based retail group encompassing multiple brands, to ensure successful expansion into the Mainland Chinese market.
• Managed sourcing activities and quotation acquisition for Palygorskite, an Earth mineral most commonly found within clay deposits in the Southeastern United States. The mineral was needed in the manufacturing process.
• Collaborated with our product development team and partnered with Microsoft to design and create a Surface Pro compatible protective casing with additional capabilities to increase the quality of experience of Surface.

Bachelor Of Science In Business Administration, Major In Global Management And A Minor In Chinese Language

Chinese Language

International Business

International Business