This is an anonymous profile of a user registered on Mndwrk platform. Please contact us or - if you have a corporate admin account, after logging in - use the FAVOURITE and LONGLIST buttons if you are interested or would like more information.

2021 - in progress

Data Quality Engineer

Hungary

• Industry: Real estate 
• Investigate and resolve any database/ingestion issues related to ADF pipeline failures
• Implement changes in the ADF pipelines according to requests
• Implement changes in the database to support new pipeline features
• Test driven development using tSQLt and FitNess frameworks
• Static data management
• AzureDevOps (CI/CD) - TFGit

2020 - 2021

Treasury Management System CoE Analyst

Hungary

• Industry: Oil & Gas
• Understanding the Treasury business processes
• Discussing dashboard or application requirements with clients
• Working together with Data Science and Analytics team
• Creating PowerShell scripts with UI if necessary reating SQL views, stored procedures and UDFs for different purposes, mainly for Tableau Dashboards
• Creating and maintaining Tableau reports and making sure they comply with the controls in place
• Maintaining access database "tools" * moving the logic of SSRS reports, PowerQuery queries and access database "tools" to Tableau Dashboards
• Providing information for audit about Tableau reports
• SharePoint SCA responsibilities

2020

Application Support Analyst

Hungary

• Industry: Oil & Gas
• Providing 24/5 support for several business-critical applications with the US team
• Documenting troubleshooting scenarios, creating how-to content
• Using Azure DevOps Server to track work and to deploy code (TSF board (Agile, Scrum), TSF pipelines, Git)
• Creating and applying updates/patches provided by vendor
• Automating certain tasks in the production environment with PowerShell scripts and task scheduler
• Running automated tests after Treasury System updates in Tosca test suite and troubleshooting errors with the help of Tosca team
• Obtained certifications: Microsoft Azure Fundamentals

2018 - 2020

Data Analyst

Hungary

• Industry: Media production
• Managing the subscription renewal process
• Creating reports with SSRS report builder, PowerQuery, Power Pivot
• Creating advanced SQL queries, stored procedures, scalar and table valued functions, dynamic SQL for reporting purposes
• Managing certain parts of the CRM database with SQL DML and TCL commands
• Making minor modifications in applications written in C#
• Making minor modifications in VBA scripts.

2017 - 2018

Business Information Technologist

Hungary

• Industry: FMCG
• Creating ETL processes with Excel formulas and Power Query:
  • Logical operators, text, date, count functions, VLOOKUP, INDEX-MATCH (array), TRANSPOSE, CELL
  • Loading data from Excel workbooks, worksheets, SQL server, exchange server, Google analytics, websites
  • Cleaning, manipulating fuzzy excel data (removing duplicates, resolving case sensitivity, trimming, etc.)
  • Normalizing, flattening data with pivoting, unpivoting, transposing columns
  • Joining or creating sets from workbooks, worksheets, SQL tables
  • Loading data to an Excel data model or to a pivot table
• Creating measures with T-SQL and DAX (power pivot) for the controlling team
  • Loading data with SQL server import-export wizard from other SQL servers or from excel workbooks
  • Creating SQL queries (joins, subqueries, table expressions, set operators, window functions, pivoting data)
  • Loading data from Excel or from SQL server
  • Creating measures, calculated columns, KPIs. (running totals, MTDs, QTDs, YTDs, YOYs with different dimensions)
• Using SAP Business One to parse through records in files and to create queries with Query Generator and Query Wizard

2009 - 2017

Sales Manager

Hungary

• Industry: FMCG
• Retail system key user 
• Communicating with the distributor, solving invoice and supply problems
• Monitor and help managing stocks of the stores
• Pricing
• Supporting management with information to make the right decisions (Excel)
• Web development (HTML, CSS)
• Supporting the inventory-taking process