Sofia Stjernqvist Email & Phone Number

Stockholm, Stockholm, Sverige

Tester (test automation) in data warehouse/data vault, also branching into test management tasks

Greater Stockholm Metropolitan Area

Senior IT Analyst at Quality Assurance unit.

Stockholm, Sverige

TOM Information factory - Small Improvements agile teamWorking as Test Analyst / Tester in agile team developing small improvements within Nordea's Central Data Warehouse. Working mainly with Teradata and SQL queries to verify data transformation and handling within the Data Warehouse, JIRA for agile team management and HP ALM for test execution and documentation.

Stockholm, Sverige

Information Factory - Test Centre of Excellence The Information Factory within Nordea was created to organize Information change handling within Nordea's Central Data Warehouse. Working as a Test Analyst / Tester within the Test Centre of Excellence, working mainly with Teradata and SQL queries to verify data transformation and handling within the Warehouse.

Stockholm

Test Coordinator in FATCA project at Nordea Worked with coordinating tests conducted in Sweden, Norway, Denmark, Finland, Baltics and several of Nordea's International Units. Besides this, the project was run on international level with many team members in India. Tests consisted of verifying correctness of data that was extracted from different source systems, sent to a Central Data Warehouse and then loaded and transformed through the warehouse's different layers.

Stockholm, Sverige

Stockholm, Sverige

Stockholm, Sverige

Worked in different test roles in several projects at Euroclear, Swedens Central Securities Depository. The projects where run on international level, including project members in Finland and India. Short description of some roles/projects: Tester/Test Analyst in Mainframe environment, designing and executing tests of Mainframe transactions. Tester / Test Analyst in project creating a Web based Single Sign On-solution. Tester / Test Analyst / Test Designer in FATCA project at Euroclear. Tests in old and new Mainframe transactions created to handle FATCA regulatory requirements within Euroclears system. Also tested creation of FTP files within TSO environment, for extracting and sending FATCA information from Mainframe system. Test Leader / Test Analyst / Tester in Annual Reporting project (ÅSK). Worked as Test Leader in Annual Reporting project at Euroclear handling the 2013 updates in the annually occuring reporting of Annual Statements and Income Statements to Swedish Tax Authority. This included changes in existing Mainframe Transactions, changes in the structure of Annual Statement and Income Statement files, and handling of new information to be reported to Swedish Tax Authorities. Also worked as Test Designer / Test Analyst / Test Designer / Tester in this project creating all needed test data within the Mainframe system, preparing system for running Annual Statement and Income Statement reporting, and then running/submitting the JCL-jobs in TSO in order to create results in Mainframe system, and then following these jobs up in Tivoli Output Manager. Also verifying that Annual Statement and Income Statement Fixed Length-files where created correctly in TSO.During this project I worked with Mainframe transactions, TSO, submitting and following up on jobs in TSO, Running QMF in TSO to prepare test data.