Pilar Joyce Email & Phone Number

United Kingdom

London, England, United Kingdom

Data Analyst at Capital, Impairments and Forecasting Team

London, England, United Kingdom

* Engaging with key stakeholders with varying levels of technical knowledge in the car trading team to scope out problems.* Computing and refining the accuracy of key profitability and cost efficiency metrics upon which business decisions are made.* Modelling data using DBT and collaborating with data engineering and data science as required. Generating relevant metrics and visualizations through SQL and Python to aid decision making using multiple data sources.* Working on DBT optimization projects related to improve data governance through documentation and pre-hooks triggered by Github actions.

Vietnam

* Leading Target Group Index (TGI) product within the team. The product involves a questionnaire delivered quarterly that is answered by 8,500 respondents across four key cities in Vietnam. Role involves marketing the data to multinational companies and media agencies.* Analyzing data packages from TGI and Media habits survey in order to derive insights on media habits and product consumptionpatterns.* Travelled to the 2018 TGI Partners conference in Porto, Portugal to discuss the changes in data collection around the world. Shared ideas on how to innovate and adapt our current product to evolving consumer needs.* In regular contact with international clients seeking data on advertising expenditure and television audience measurement inVietnam. Responsible for negotiating fees and drafting contracts for the services requested.

Chile

• Improving master data analysis capabilities for The Clorox Company internationally. This involved developing relationships with teams across 11 countries in Latin America, the United States and the Philippines.• Mastered the use of SAP Information Steward, including coding validation rules and the creation of scorecards used for Data Governance processes that cover all product operation.• Define issues that users have with information systems in their normal activities and design codes that solve them sustainably.

Chile

• Travelled to the Clorox Pleasanton Campus in California for a Data Governance workshop. Detecting new areas of SAP Information Steward applications and developing intake processes used for data quality improvements.• Inputting Master Data that is critical for effective business activities in Latin America. This involved working alongside Materials, Finance, Customer and Vendor Teams. • Extending technical information of new products and spare parts to each country. Product costing, loading prices and discounts, updating exchange rates, inputting new vendors using SAP.

Commercial Engineer With Mention Of Business Administration, Business And Administration

English Language Immersion Program, English

Academic Preparation, Business presentation skills

Data Science, Computer And Information Sciences, General

Attended Le Wagon London - Batch #597 10-week full-time intensive coding bootcamp to learn Data Science with Python: Data Analytics.