Anzelm Kiss

Data Analyst at Gazprom Marketing & Trading
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
London, United Kingdom, GB

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Excel 2013: Advanced Formulas and Functions
    Lynda.com
    May, 2016
    - Oct, 2024
  • Microsoft Business Intelligence Stack Fundamentals
    Lynda.com
    May, 2016
    - Oct, 2024
  • Microsoft Business Intelligence Stack in Depth
    Lynda.com
    May, 2016
    - Oct, 2024
  • Up and Running with C++
    Lynda.com
    May, 2016
    - Oct, 2024
  • Object-oriented Programming with Java Part 2
    City University London
    Jun, 2015
    - Oct, 2024
  • C/C++ Part 2 - Object Oriented Programming using C++
    City University London
    Jan, 2015
    - Oct, 2024
  • C/C++ Part 1 - Introduction to Programming with C
    City University London
    Dec, 2014
    - Oct, 2024
  • Up and Running with Python
    Lynda.com
    Sep, 2016
    - Oct, 2024
  • Introduction to Data Analysis with Python
    Lynda.com
    Aug, 2016
    - Oct, 2024
  • Up and Running with R
    Lynda.com
    Jul, 2016
    - Oct, 2024

Experience

    • United Kingdom
    • Oil and Gas
    • 1 - 100 Employee
    • Data Analyst
      • Mar 2019 - Present

    • United Kingdom
    • Financial Services
    • 700 & Above Employee
    • Technical Client Reporting Analyst/ Developer
      • May 2018 - Mar 2019

    • United Kingdom
    • Management Consulting
    • 500 - 600 Employee
    • Assistant Manager/ Data Developer/ Data Analyst
      • Mar 2017 - May 2018

      Responsibilities:• Liaised with stakeholders to ensure timely delivery of project objectives• Gathered business requirements from key stakeholders• Maintained/ created dashboards in Tableau, QlickView and Excel for different projects• Worked on Excel and Microsoft SQL Server connection in order to retrieve and upload results into the database• Documented the code reviewsKey Achievements:• Delivered cutting edge Tableau dashboards and key findings for stakeholders from 20 Million row data sourceTechnologies:• MS SQL Server, T-SQL, VBA, MS Excel, Tableau, QlickView

    • United Kingdom
    • Financial Services
    • 700 & Above Employee
    • Technical Business Analyst
      • Nov 2015 - Apr 2016

      Responsibilities:• Liaised with stakeholders to ensure timely delivery of project objectives following the Kimball lifecycle methodology• Gathered business requirements from key stakeholders and recorded them in the JIRA system• Maintained/ created sales reports in Oracle Business Intelligence and Excel for the sales team• Supported Management of Oracle Business Intelligence reports to ensure the reports accuracy• Automated the Excel sales reports which reduced refresh time by 50%• Took part in knowledge sharing sessions and delivered presentations to the wider team• Managed UAT of different datafeeds e.g: web seminar attendees list dataKey Achievements:• Delivered cutting edge sales model to project any financial benefits of the increased conversion rates/ project variablesTechnologies:• Oracle PL/SQL, SQL, VBA, Oracle OBIEE, MS Excel

    • United Kingdom
    • Broadcast Media Production and Distribution
    • 700 & Above Employee
    • Lead Data Developer
      • Aug 2012 - Nov 2015

      Responsibilities:• Developed SQL stored procedures and views for complex reporting requirements in SQL applications.• Documented issues / bugs / change requests for senior developers in the Service Now system• Blended various data sources to create useful analytical/ insight reports• Managed UAT and reported and addressed user experience failures with senior development team.• Worked with key stakeholders across the business (including the senior management) to preserve appropriateness and consistency of project activity based on the Kimball lifecycle methodologyKey Achievements:• Delivered quarterly/ weekly pre-campaign, post-campaign, insight reports• Delivered “Customer-Centric Decision Management” campaigns (including running different decision scenarios based on propensity/ up-flit models in Marketswitch provided by Experian)• Achieved significant cost saving (£4 Million) for the social media campaign activitiesTechnologies:• Microsoft SQL Server, Sybase Winsql, Oracle PL/SQL, Experian Marketswitch, MS Access, MS Excel

    • United Kingdom
    • Book and Periodical Publishing
    • 400 - 500 Employee
    • Database Marketing Executive/ Data Analyst
      • Aug 2010 - Aug 2012

      Responsibilities:• Provided technical and analytic expertise using VBA in responding to complex specialized report requests.• Developed complex reporting utilizing Business Objects and SQL stored procedures and views• Cleansed Customer Data using SSIS package• Honed excellent technology and organizational skills to complete data and pre-campaign reporting requests for direct marketing campaigns.• Worked with key stakeholders across the business in preserving appropriateness and consistency of direct marketing activity.• Liaised with suppliers to ensure timely delivery of project targets.Key Achievements:• Developed complex reporting in Excel to measure the online effectives on the eCommerce websites as well as their financial contributions• Delivered DM campaign data to specific suppliersTechnologies:• Microsoft SQL Server, SSIS, MS Access, MS Excel, VBA, Fast Stats, Omniture, Google Analytics

    • Italy
    • Renewable Energy Semiconductor Manufacturing
    • 1 - 100 Employee
    • Project Manager Assistant
      • Oct 2009 - Dec 2009

      Tasks:• Developed a financial analysis model for jatropha (biodiesel feedstock) project in Morocco• Developed project specific Geographical Information System maps for localization of the jatropha plantation• Researched Clean Development Mechanism (CDM) requirements for the jatropha project• Developed complex CDM CO2 calculation models to identify carbon efficient, sustainable products • Contacted various biodiesel refinery manufacturers to obtain technical and financial information of the biodiesel plant

    • Marketing and Sales Assistant
      • May 2009 - Aug 2009

      Tasks:• Contributed to the financial analysis of jatropha, an environment friendly biodiesel feedstock project• Prepared presentations for board meetings demonstrating different technologies of jatropha and the related costs • Organized corporate database to improve the company management reporting system

    • External Relation Team Member
      • Oct 2008 - Apr 2009

      Tasks: • Participated in the recruitment process of new English-speaking candidates working for Hungarian organizations • Networked with private companies and non-profit organizations in order to recruit trainees

    • Project Manager Assistant
      • Mar 2007 - Jun 2007

      Tasks:• Taking part in environmental awareness excursions to promote sustainable development for the young generation • Researched the market and contacted various solar panel manufactures to gain financial and technical information of PV panels used for a wind-solar installation• Part of a team responsible for the maintenance of wind-turbines

Education

  • University of West Hungary
    MSc, Agribusiness Engineering
    2003 - 2009
  • Christelijke Hogeschool Nederland
    Bsc, Rural Innovation and Development
    2006 - 2007

Community

You need to have a working account to view this content. Click here to join now