Colleen Chapman

Colleen Chapman Email and Phone Number

Improving Processes by Turning Spreadsheets Into Python Code One Excel File at a Time @ Elementaly
london, greater london, united kingdom
Colleen Chapman's Location
Greater Chattanooga, United States
About Colleen Chapman

Data analyst with strong problem-solving skills, exceptional attention to detail, and excellent communication skills. Experienced in making continuous improvements by creating tools, processes, and best practices to enhance work flow efficiency and data quality. Demonstrated initiative and ability to meet commitments on time, go the extra mile, take independent action, learn new skills, and complete special assignments. Proven track record delivering high customer satisfaction for both internal and external customers.

Colleen Chapman's Current Company Details
Elementaly

Elementaly

View
Improving Processes by Turning Spreadsheets Into Python Code One Excel File at a Time
london, greater london, united kingdom
Website:
elementaly.org
Employees:
2
Colleen Chapman Work Experience Details
  • Elementaly
    Senior Analyst
    Elementaly May 2021 - Present
    United Kingdom
    • Assisted clients in tracking sustainability goals though determining products’ material usage and how much of each of those materials are more sustainably created.• Data Analysis & Process Improvement--- Created Python scripts to automate analyses, decrease processing time, and standardise data cleaning and analysis steps across clients.--- Enabled transition of analyses from manual, yearly processing to more automated, frequent, consistent, and reliable reporting.----- Reduced analysis time for ten-billion-pound client by 64%.----- Reduced analysis time for nine-billion-dollar client by 62%.----- Reduced analysis time for two-point-five-billion-dollar client by 43%.----- Reduced analysis time for three-million-pound client by 62%.--- Supported new database and web application design and creation.• Reporting & Documentation--- Created and maintained data visualizations and KPIs in Excel, Power BI, and Looker Studio.--- Documented Python automation scripts in Markdown through Ghostwriter, current and future process states in Visio, and analysis methodologies in Word, PowerPoint, and Excel.--- Reworked dashboard results to fit clients’ ad-hoc reporting needs.
  • Cardiff University / Prifysgol Caerdydd
    Msc Graduate Data Science And Analytics
    Cardiff University / Prifysgol Caerdydd Sep 2019 - Sep 2020
    Wales, United Kingdom
    • Analytics exposure through practical coursework in Data Visualization, Supply Chain Modeling, Computational Data Science, Foundations of Operational Research and Analytics, Foundations of Statistics and Data Science, Applied Machine Learning, and Healthcare Modeling.• Dissertation Project: Investigating the Effects of the Help-to-Buy Wales Scheme---Collected residential purchase price information from the public domain and cross-referenced with Help-to-Buy records to perform hypothesis testing of median prices of homes purchased with and without Help-to-Buy assistance. Statistical testing indicated in most cases there were no significant differences in median housing prices in Wales and that median prices stabilized during the time period of the Help-to-Buy scheme, which may indicate it has helped mitigate rising housing costs in Wales.---Presented test results with data visualizations created in Python’s Matplotlib and Plotly libraries.
  • Boeing Commercial Airplanes
    Weight And Mass Properties Customer Introduction Engineer 3 (Including 2 Promotions)
    Boeing Commercial Airplanes Jul 2006 - Jul 2019
    • Collaborated with internal stakeholders and external customers to provide option related mass properties data and its airplane level impact.• Data Analysis and Process Improvement---Investigated historical data to identify trends used to develop and maintain Excel tools and VBA macros. These optimized and simplified the processes used to calculate, track, and format data, which enabled touch-time reduction of 20% as well as quality improvements.---Helped spearhead a web application and database development project as the stakeholder subject matter expert. Upon completion, the new interface will enable further touch-time reductions and quality improvements, and the new database will facilitate in-depth data analysis of the airplane-level effect of option weight data.---Highlighted an unexpected trend in airplane-level weight variation due to weigh location and led the reconciliation effort. Collaborated with the calibration and operational engineering groups to implement analytical adjustments, which improved data accuracy by up to .1% of the expected weight or 50% of the expected difference.• Reporting---Gathered and analyzed data and technical drawing information from multiple groups across the company to create airplane-level information for airlines.---Generated internal and external customer reports to support sales and marketing teams and demonstrate guarantee compliance.• Leadership---Implemented tracking system to focus on reducing upstream data quality defects, which improved first time quality by 10%.---Mentored new employees, exhibiting strong interpersonal skills and the ability to establish productive relationships quickly.
  • Boeing Commercial Airplanes
    Flight Test Instrumentation Engineer 1
    Boeing Commercial Airplanes Jun 2005 - Jun 2006
    • Created a clear and concise process to capture testing requirements on hydraulic system drawings, which was utilized until the successful completion of the flight test program.• Communicated design information and requirements to international partners by preparing specification documentation.• Developed and maintained computer aided design models of instrumentation equipment in CATIA V5 and ENOVIA.
  • Fermilab
    Technical Division Development And Testing Summer Intern
    Fermilab May 2004 - Aug 2004
    • Established polishing procedure for studying niobium grain boundaries and analyzed and interpreted partial pressure data to determine hydrogen outgassing.

Colleen Chapman Education Details

Frequently Asked Questions about Colleen Chapman

What company does Colleen Chapman work for?

Colleen Chapman works for Elementaly

What is Colleen Chapman's role at the current company?

Colleen Chapman's current role is Improving Processes by Turning Spreadsheets Into Python Code One Excel File at a Time.

What schools did Colleen Chapman attend?

Colleen Chapman attended Cardiff University / Prifysgol Caerdydd, Illinois Institute Of Technology, Wheaton College.

Who are Colleen Chapman's colleagues?

Colleen Chapman's colleagues are Victor Serrano Garcia, Dan Davies.

Not the Colleen Chapman you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.