$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Insight/modelling/MIS specialist with advanced Excel, SAS/SPSS/SQL/POWERPOINT specialised in marketing
Cristina Meloni
,
London, United Kingdom
Experience
Other titles
Skills
I'm offering
Finance and Banking Post-graduate (2012) with different years of experience as an insight analyst/statistician and financial translator, both as a contractor and direct employee, in Italy and UK.
Worked for consulting companies, educational institutions, healthcare institutions, marketing agencies and financial services companies.
Modelling, statistics, insights and presenting skills.
Main tools used: SAS EG, SPSS Statistics, Excel, PowerPoint, Tableau Public, PowerPoint, Outlook, Word, in-house BI tool, Adobe Acrobat.
Currently self-studying (via Codecademy) Python and refreshing econometrics.
Examples of Excel data analysis and PowerPoint/Interactive PDF presentations design: http://*****.***
http://*****.***
Tableau: http://*****.***
Worked for consulting companies, educational institutions, healthcare institutions, marketing agencies and financial services companies.
Modelling, statistics, insights and presenting skills.
Main tools used: SAS EG, SPSS Statistics, Excel, PowerPoint, Tableau Public, PowerPoint, Outlook, Word, in-house BI tool, Adobe Acrobat.
Currently self-studying (via Codecademy) Python and refreshing econometrics.
Examples of Excel data analysis and PowerPoint/Interactive PDF presentations design: http://*****.***
http://*****.***
Tableau: http://*****.***
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Good
Spanish
Good
French
Good
Italian
Fluently
Ready for
Larger project
Ongoing relation / part-time
Available
My experience
2019 - ?
job
Retail Credit Risk Analyst
Lloyds Banking Group.
(UK)
Unsecured Capital and Impairment. Prudential Modelling team. Credit risk models and statistics to support the decision-making process. Basel III and IFRS9. Scorecards, Expected losses, Unexpected losses, PD, LGD and EAD
modelling. Statistical modelling (logistic regression, decision trees, etc.). Excel, SAS EG and SQL. PowerPoint decks
preparation. Presenting to internal stakeholders (Risk Committee, senior colleagues, etc). Prudential regulatory
reporting (PRA notifications, etc.).
Unsecured Capital and Impairment. Prudential Modelling team. Credit risk models and statistics to support the decision-making process. Basel III and IFRS9. Scorecards, Expected losses, Unexpected losses, PD, LGD and EAD
modelling. Statistical modelling (logistic regression, decision trees, etc.). Excel, SAS EG and SQL. PowerPoint decks
preparation. Presenting to internal stakeholders (Risk Committee, senior colleagues, etc). Prudential regulatory
reporting (PRA notifications, etc.).
Sql, Excel, Powerpoint, Retail, SAS, Statistics, Support, Analyst, Presenting, Regulatory
2018 - 2018
job
Financial Analyst at Treasury Services
JP Morgan.
(UK)
Contract role at JPMorgan Chase & Co. via Resource Solutions.
This role is to ensure that an application is made fully available in Italian language (localisation). QA Tester for
linguistic quality and functionality testing detecting and logging defects in ALM UAT/Production (ADA/BAU).
It involves also the creation of interactive AML weekly dashboards/trackers using Excel (advanced formulas, pivots, macros included) and VBA (basic) and the preparation of Power Point decks.
Contract role at JPMorgan Chase & Co. via Resource Solutions.
This role is to ensure that an application is made fully available in Italian language (localisation). QA Tester for
linguistic quality and functionality testing detecting and logging defects in ALM UAT/Production (ADA/BAU).
It involves also the creation of interactive AML weekly dashboards/trackers using Excel (advanced formulas, pivots, macros included) and VBA (basic) and the preparation of Power Point decks.
Excel, VBA, Financial analyst, QA, It, Analyst, Testing, Power, Production, Treasury, Basic
2016 - 2018
job
Insight Analyst
Reach Contact Field Marketing Agency.
(UK)
Marketing and Promotional campaign and Category analysis at store level for an FMCG client operating in the grocery industry.
Using the sales figures from the retailer's portals (RetailLink for ASDA, TescoLink for Tesco, etc.) and the data that
we collect on store via our Field Team we provide the client with:
• useful insights on marketing and promotional campaigns,
• brand performance analysis like the identification of the variants within the brand that mostly drive the overall decline of the brand,
• promo brand and competitor cannibalization analysis,
• sales trackers, periodic reports
• on shelf availability issues analysis of specific products by retailer by store,
• test-control analysis to evaluate the uplift generated by specific activities on store done by the field team.
• ROI by retailer by category using a test-control methodology
• sales uplift and ROI generated by each intervention by retailer by store.
• based on those analysis we elaborate action plans to better support their marketing and communication
execution at store level.
The main tools that I used are Excel and PowerPoint.
Marketing and Promotional campaign and Category analysis at store level for an FMCG client operating in the grocery industry.
Using the sales figures from the retailer's portals (RetailLink for ASDA, TescoLink for Tesco, etc.) and the data that
we collect on store via our Field Team we provide the client with:
• useful insights on marketing and promotional campaigns,
• brand performance analysis like the identification of the variants within the brand that mostly drive the overall decline of the brand,
• promo brand and competitor cannibalization analysis,
• sales trackers, periodic reports
• on shelf availability issues analysis of specific products by retailer by store,
• test-control analysis to evaluate the uplift generated by specific activities on store done by the field team.
• ROI by retailer by category using a test-control methodology
• sales uplift and ROI generated by each intervention by retailer by store.
• based on those analysis we elaborate action plans to better support their marketing and communication
execution at store level.
The main tools that I used are Excel and PowerPoint.
Marketing, Excel, Powerpoint, Test, Sales, ROI, Support, Analyst, FMCG, Campaign
2016 - 2016
job
Transactions Associate - OTC
Robert McBride Ltd.
UK
Order release management, running of the blocked orders reports, cash posting using SAP, credit control duties,
debit notes and credit notes management, credit limit control and review following the Company Credit Policy.
Italy, Spain and Belgium Ledgers.
Order release management, running of the blocked orders reports, cash posting using SAP, credit control duties,
debit notes and credit notes management, credit limit control and review following the Company Credit Policy.
Italy, Spain and Belgium Ledgers.
SAP, Management
2012 - 2016
freelance
Freelance Statistician & Financial Translator, Italy
unknown.
I worked on different statistical project for different clients in different sectors. I used data from various sources
and I validated, manipulated and analysed those data using both Excel and SPSS Statistics. I provided the client the final results putting insights on a PowerPoint deck. Below there are some examples.
The statistical techniques that I used are: descriptive statistics, contingency tables, correlations analysis, t-tests, chi-
square tests, ANOVA, linear and logistic regressions, cluster analysis, factor analysis, time series analysis, charts,
pivot tables, VLOOKUP's and other advanced excel functions, etc. Tools: SPSS Statistics, Excel and Power Point.
I am also translating financial, investment and economics documentations, especially about ETFs, from English/Spanish/French into Italian using SDL Trados Studio 2015, WordFast, SDL Passolo, Word, Excel, PowerPoint
and Adobe Acrobat. Major clients: justETF and Amazon.
My specialties: Financial markets (KIIDs, market reports, commentaries, RFP, etc.), Business (business plans, financial statements), Economics (conference reports, financial education docs), Marketing (events news, brochures, presentations), Website contents (marketing and information contents of company websites, e- learning contents), Tech
(user's manuals of accounting software), General (letters, emails, certificates).
and I validated, manipulated and analysed those data using both Excel and SPSS Statistics. I provided the client the final results putting insights on a PowerPoint deck. Below there are some examples.
The statistical techniques that I used are: descriptive statistics, contingency tables, correlations analysis, t-tests, chi-
square tests, ANOVA, linear and logistic regressions, cluster analysis, factor analysis, time series analysis, charts,
pivot tables, VLOOKUP's and other advanced excel functions, etc. Tools: SPSS Statistics, Excel and Power Point.
I am also translating financial, investment and economics documentations, especially about ETFs, from English/Spanish/French into Italian using SDL Trados Studio 2015, WordFast, SDL Passolo, Word, Excel, PowerPoint
and Adobe Acrobat. Major clients: justETF and Amazon.
My specialties: Financial markets (KIIDs, market reports, commentaries, RFP, etc.), Business (business plans, financial statements), Economics (conference reports, financial education docs), Marketing (events news, brochures, presentations), Website contents (marketing and information contents of company websites, e- learning contents), Tech
(user's manuals of accounting software), General (letters, emails, certificates).
Marketing, Excel, Websites, Powerpoint, SoMe, Word, Spss, Website, Statistics, Adobe, Adobe Acrobat, Software, RFP, Amazon, Power, Cluster Analysis
2015 - 2015
freelance
Due Diligence Contractor
Clayton Euro Risk.
UK
Financial Translations (English-Italian) and other Consulting Duties for Due Diligence Reviews, Risk Management,
Consulting and Data Analysis Projects on NPLs for International Banks, Financial Services Companies, Insurance
Companies and so on.
Financial Translations (English-Italian) and other Consulting Duties for Due Diligence Reviews, Risk Management,
Consulting and Data Analysis Projects on NPLs for International Banks, Financial Services Companies, Insurance
Companies and so on.
Data Analysis, Consulting, Risk Management, Management, Due Diligence, Insurance, International
2013 - 2014
temp
Customer Service Clerk and Statistician
Mineral Test Sas (Research Centre), Civitanova.
(temporary employment) at Mineral Test Sas (Research Centre), Civitanova
Marche, Italy
Psychological and Mineral Statistical Assessment on Patients with Severe Diseases.
I was responsible for the questionnaire design and the psychological parameters comparisons before and after a
treatment and the hair mineral values on patients with severe diseases before and after a treatment. Techniques used:
descriptive statistics, cluster analysis, t-tests, ANOVA, correlation analysis and linear or logistic regressions using Excel and SPSS Statistics. Report writing.
Marche, Italy
Psychological and Mineral Statistical Assessment on Patients with Severe Diseases.
I was responsible for the questionnaire design and the psychological parameters comparisons before and after a
treatment and the hair mineral values on patients with severe diseases before and after a treatment. Techniques used:
descriptive statistics, cluster analysis, t-tests, ANOVA, correlation analysis and linear or logistic regressions using Excel and SPSS Statistics. Report writing.
Design, Excel, Writing, Research, Customer service, Test, SAS, Spss, Service, Statistics, Assessment, Cluster Analysis
My education
2000
-
2005
Istituto Tecnico Commerciale A Gentili
HighSchoolOrEquivalent, Accounting
HighSchoolOrEquivalent, Accounting
Birkbeck University of London
N/a, Probability and Statistics
N/a, Probability and Statistics
Faculty of Economics of Università Politecnica
Masters, Banking and Insurance
Masters, Banking and Insurance
Faculty of Economics of Università degli studi di Macerata
Bachelors, Finance and Insurance
Bachelors, Finance and Insurance
Cristina's reviews
Cristina has not received any reviews on Worksome.
Contact Cristina Meloni
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Cristina 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