$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Data Analyst
Jennifer King
,
Guildford, United Kingdom
Experience
Other titles
Skills
I'm offering
Data Analyst with advanced data management, data preparation, data modeling and visualization know-how. I help businesses solve problems they have with data, be it analytics,
Digital transformation, data migration or database building.
Highly proficient in SQL, DAX and M.
Digital transformation, data migration or database building.
Highly proficient in SQL, DAX and M.
Markets
United Kingdom
Industries
Language
German
Good
English
Fluently
Chinese (Mandarin)
Fluently
Ready for
Larger project
Full time contractor
Available
My experience
2019 - 2020
job
Contracts Analyst, TCO FGP Project
Chevron Corporation.
(Contract ended 31 Oct 2020)
• Partner with contracts lead to understand their business and data requirements to create highly informative and interactive Power BI reporting solutions to support team manage the contracting process, ensuring full compliance in high value capital project payments,
and identifying wrongly submitted project expenses.
• Apply data analysis, cleansing, modeling, and quality assurance techniques to create and maintain contracts data model. Compare data between multiple systems, highlighting discrepancies for team to investigate.
• Build database for team to capture detailed projects costs and integrate this data with existing systems data.
• Partner with contracts lead to understand their business and data requirements to create highly informative and interactive Power BI reporting solutions to support team manage the contracting process, ensuring full compliance in high value capital project payments,
and identifying wrongly submitted project expenses.
• Apply data analysis, cleansing, modeling, and quality assurance techniques to create and maintain contracts data model. Compare data between multiple systems, highlighting discrepancies for team to investigate.
• Build database for team to capture detailed projects costs and integrate this data with existing systems data.
Data Analysis, Contracts, Power BI, Database, Compliance, Quality Assurance, Support, Analyst, BEE, Power, Contracts
2018 - 2019
job
Business & Systems Analyst, Enterprise Services, Global Pursuit Organization
Microsoft Corporation.
(Contract ended 30 Sep)
• Build up the new Global Pursuit Organization's BI capabilities with leadership team and IT to get insights into business performance to drive improvements.
• Manage backlog of Power BI reports and dashboards. Conduct testing before releases.
• Provide analysis on underlying drivers of business performance and communicate clear commentary.
• Answer queries from stakeholders regarding data sets used and KPI calculation methodologies, help them understand data quality / integrity issues that affect reported metrics.
• Build Power BI data models, reports and dashboards to enable additional analysis that are not currently available in the BI reports and dashboards. Bridge the gap between the needs of the business and IT.
• Build up the new Global Pursuit Organization's BI capabilities with leadership team and IT to get insights into business performance to drive improvements.
• Manage backlog of Power BI reports and dashboards. Conduct testing before releases.
• Provide analysis on underlying drivers of business performance and communicate clear commentary.
• Answer queries from stakeholders regarding data sets used and KPI calculation methodologies, help them understand data quality / integrity issues that affect reported metrics.
• Build Power BI data models, reports and dashboards to enable additional analysis that are not currently available in the BI reports and dashboards. Bridge the gap between the needs of the business and IT.
Power BI, Leadership, Data quality, It, Analyst, Testing, KPI, BEE, Power, Enterprise, UP
2018 - 2018
temp
Senior Analyst
Evergreen Garden Care.
(Contract ended 30 Sep when SAP S/4HANA system went live)
• Participate in requirements workshops with Business Process Owners to document data migration requirements from legacy SAP ECC system to target SAP S/4HANA system.
• Analyze, identify and extract required data from tables and table joins (Quickviewer SQVI) from SAP ECC system to populate load templates for migrating data to target system.
• Conduct large data set cleaning, mapping, transformation and conversion of source data to target system values using SQL Server.
• Resolve any data quality issues with data owners and collaborate with them to validate the accuracy of data pre- and post-load throughout the various migration cycles.
• Investigate data queries from colleagues and advise/assist them where necessary.
• Participate in requirements workshops with Business Process Owners to document data migration requirements from legacy SAP ECC system to target SAP S/4HANA system.
• Analyze, identify and extract required data from tables and table joins (Quickviewer SQVI) from SAP ECC system to populate load templates for migrating data to target system.
• Conduct large data set cleaning, mapping, transformation and conversion of source data to target system values using SQL Server.
• Resolve any data quality issues with data owners and collaborate with them to validate the accuracy of data pre- and post-load throughout the various migration cycles.
• Investigate data queries from colleagues and advise/assist them where necessary.
Sql, SQL Server, SAP, Data quality, Workshops, Transformation, Analyst, Server
2017 - 2018
temp
Interim Demand & S&OP Analyst
Targus EMEA.
(Contract)
• Reduce report delivery time of monthly sales forecasts for 9 sales regions across 5 product categories, 250 product models for related sales managers and customers from 4 days to 1.
• Improve accuracy of complex forecast model which combines data from multiple systems and sources (SQL Server, Salesforce.com, Logility, Excel etc.) from 80 to 100%.
• Create dashboards and scorecards to show current performance measures and how they compare to targets and previous periods. Issue monthly KPI reports on Inventory, Slow and non-moving, and Goods in Transit.
• Set up material master data in ERP and forecast systems.
• Build dimension tables for EMEA. Develop data models using Power BI's ETL tool and Data Analysis Expressions (DAX) to answer business questions quickly and accurately.
• Reduce report delivery time of monthly sales forecasts for 9 sales regions across 5 product categories, 250 product models for related sales managers and customers from 4 days to 1.
• Improve accuracy of complex forecast model which combines data from multiple systems and sources (SQL Server, Salesforce.com, Logility, Excel etc.) from 80 to 100%.
• Create dashboards and scorecards to show current performance measures and how they compare to targets and previous periods. Issue monthly KPI reports on Inventory, Slow and non-moving, and Goods in Transit.
• Set up material master data in ERP and forecast systems.
• Build dimension tables for EMEA. Develop data models using Power BI's ETL tool and Data Analysis Expressions (DAX) to answer business questions quickly and accurately.
Sales, UP, Interim, Forecast, Power, BEE, Server, KPI, Analyst, Excel, Salesforce, ETL, ERP, Power BI, SQL Server, Data Analysis, Sql
2015 - 2016
job
Supply Chain Data Analyst
Sony Europe Limited.
• Provide essential Sales and Operations planning, Supply Chain reports and data to stakeholders in Marketing, Supply Chain and Production Planning.
• Partner with end users, IT to improve report design, speed and accuracy. Answer any
queries regarding data from end users.
• Utilize Power BI to query, transform and combine data from multiple data sources from
12 European sales offices and Marketing to build long and short-term forecast reports.
• Identify opportunities to streamline and automate reporting. Reduced time to produce
critical Availability reports required for product allocation by 70%.
• Troubleshoot issues arising from spreadsheet errors. Rebuilt complex Purchase Sales Inventory reports to make them 100% error free.
• Partner with end users, IT to improve report design, speed and accuracy. Answer any
queries regarding data from end users.
• Utilize Power BI to query, transform and combine data from multiple data sources from
12 European sales offices and Marketing to build long and short-term forecast reports.
• Identify opportunities to streamline and automate reporting. Reduced time to produce
critical Availability reports required for product allocation by 70%.
• Troubleshoot issues arising from spreadsheet errors. Rebuilt complex Purchase Sales Inventory reports to make them 100% error free.
Marketing, Design, Operations, Power BI, Sales, It, Analyst, BEE, Power, Production, Forecast
2015 - 2015
temp
Customer Team Logistics Planner
Procter & Gamble UK.
(Contract)
• Provide link between customer business and supply chain through forecasting and risk reporting. Improved supply chain visibility for account management team with 2 SKUs
at risk reports weekly versus 1 previously.
• Track promotions performances by monitoring and analyzing customer buy-in, EPOS
data and shipments data.
• Build and maintain management dashboard to deliver continuous business insight with daily, weekly and monthly KPIs reporting (shipment volumes, fill rate, cuts etc.).
• Attend meetings to review and evaluate customer sales, forecasts and service risks.
• Provide link between customer business and supply chain through forecasting and risk reporting. Improved supply chain visibility for account management team with 2 SKUs
at risk reports weekly versus 1 previously.
• Track promotions performances by monitoring and analyzing customer buy-in, EPOS
data and shipments data.
• Build and maintain management dashboard to deliver continuous business insight with daily, weekly and monthly KPIs reporting (shipment volumes, fill rate, cuts etc.).
• Attend meetings to review and evaluate customer sales, forecasts and service risks.
Account management, Forecasting, Management, Sales, Service, Monitoring
My education
Esslingen University of Applied Sciences
MBA, Accounting and Finance
MBA, Accounting and Finance
Williams College
Bachelors, Economics
Bachelors, Economics
Jennifer's reviews
Jennifer has not received any reviews on Worksome.
Contact Jennifer King
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Jennifer directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark