Data Front Office

Hanna Zaitseva

Software QA Tester

Email: adlmkv@r.postjobfree.com

Mobile: 910-***-**-**

SUMMARY:

5+ years of IT experience in the Analysis, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.

Worked with software development management tools such as ALM and JIRA.

Experienced using query tools for Oracle and MS SQL Server to validate reports and troubleshoot data quality issues.

Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica Power Centre

Investigated the bugs occurred in Informatica Power Centre mappings.

Used Informatica to run the workflows, to see the status, analyze logs.

Experienced in Informatica Designer, Workflow Manager, Workflow Monitor.

Worked with different types of transformations to validate the data.

Expert in writing Test Plan, Test Cases and Traceability Matrix.

Hands-on knowledge of testing tool-REST API

Experienced in testing Business Intelligence reports generated by various BI Tools like SSRS and Micro Strategy

Good understanding of SQL Packages, Stored Procedures/Functions, triggers.

Solid Back End Testing experience by writing and executing SQL Queries.

Experienced in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.

Experienced in testing XML files and validating the data loaded to staging tables.

Good experience in Data Warehouse and analytical reporting testing.

Good experience in Data Modeling using Star Schema and Snow Flake Schema.

Experienced in all phases of Software Development life cycle.

Application Data warehousing experience in Financial Domain.

Performed Functional, Integration, Regression and System Testing.

Good analytical and problem solving skills.

Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

Team oriented and ability to understand and adapt to new technologies and environments faster.

Good at analysis and troubleshooting.

Proficient in assessing progress and providing status reporting to stakeholders.

Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Reporting Tools: MicroStrategy, SSRS

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables

Testing Tools: Test Director, ALM/Quality Center, JIRA, PAC2000

RDBMS: Oracle, MS SQL Server

ETL: SSIS, Informatica

Programming: UNIX Shell Scripting, SQL

Job Schedulers: Autosys, Windows task Scheduler

Web Technologies: JavaScript, HTML, and DHTML, Java.

PROFESSIONAL EXPERIENCE:

MUFG, Raleigh, NC 10/2018 - Present

ETL Tester

Project: FDM – Financial DataMart project enhancements and architecture redesign testing.

Responsibilities:

Obtained requirement clarifications from SME’s and BA’s and draw out a testing plan for the sprint scope items.

Created detailed Test Strategy and Test plan documents for the project, designed Test Scenarios for the requirements.

Reviewed Test scenarios with the SME’s and business users and composed associated test cases accordingly.

Performed ETL testing, backend testing and UI integration testing.

Performed end-to end ETL testing by validating source data validation, DB schema (MetaData) validation, Count Check, Data Quality and Accuracy testing, Data Transformation and Integration testing.

Prepared test artifacts based on the requirements, design and data mapping documents.

Had experience in validating the business transformations by writing complex SQL queries.

Executed Autosys jobs, verified dependency and time conditions, and verified the jobs statuses.

Performed Back end testing by writing various SQL statements using JOINs, UNION, EXCEPT, INTERSECT, Aggregation functions, CASE statements, and wildcards using MS SQL.

Tested data quality for FDM, customer data integration and Match-Merge process.

Performed User Acceptance Testing (UAT) from test case design to execution and defect tracking, reviewing, analyzing, and closing.

Used UNIX to configure, manage and monitor various environment specific services and applications.

Analyzed and tracked the changes to requirements throughout the project.

Tested the data acquisition, data transformation and data cleansing approach for the FDM implementation.

Validated various ETL functional changes and transformations from both DDL and DML perspective.

Developed requirement traceability matrix to map the requirements to test cases, Defining test methodology to carry out the development schedule.

Reviewed and finalized the test cases and Test scripts that are designed.

Monitored and tracked the progress of Test execution process.

Worked with team to ensure test environments are setup and test data are available for test execution.

Implemented logical and physical data modeling with STAR schema in Data Marts.

Interacted with onsite and offshore team in resolving testing related problems.

Regular interaction with the offshore team manager/leader and Quality Assurance team.

Prepared and sending out the weekly status report to the client and HCL managers.

BNY Mellon, New York, NY 12/2015 – 08/2018

QA Analyst

Project: ETL and Reporting process validation for Securities trading data flow from Front Office and Back Office sources to the target database system.

Responsibilities:

Involved in developing detailed test plan, test cases and test scripts using HP ALM for Functional and Regression Testing.

Involved in testing all the reports that were generated through MicroStrategy.

Preparation of technical specifications and Source to Target mappings.

Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.

Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.

Extracted data from various sources like Oracle, MS SQL Server, and flat files.

Optimizing/Tuning several complex SQL queries for better performance and efficiency.

Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.

Worked with non-transactional data entities for multiple feeds of reference data using Master Data Management.

Tested several UNIX Shell Scripts and for connecting to database and for file manipulation of data.

Identified Test Cases to be automated and assigned them to the Automation Team to write corresponding Automation scripts.

Validated various Reports, Custom filters, Prompts, Custom groups, Consolidations and Drill paths developed in MicroStrategy.

Validated source identification, data collection, data manipulation, data normalization, data consolidation logic.

Worked on issues with migration from development to testing.

Experienced in data analysis using SQL, PL/SQL and many other queries based applications.

Created different user defined functions for applying appropriate business rules

Worked on test data and completed testing to check all business rules and requirements are met.

Prepared data using INSERT, UPDATE statements to perform negative and positive testing scenarios to check the output by comparing it with expected result.

Wrote test cases and prepared test documentations accordingly.

Liquidnet Inc, New York, NY 06/2014 – 11/2015

QA Analyst

Project: Daily trade pricing batch processing testing.

Responsibilities:

Performed GUI, Smoke, Accessibility, System, Regression, UAT and Performance testing.

Involved in writing test plan and verified test entry and exit check lists to deliver a good quality product, wrote test cases.

Participated in documenting test deliverables like test plan, test scenario, test cases and test results in HP ALM for Sprints.

Used Jira for bug/defect tracking.

Performed independent verification and validation testing for various applications in each build.

Performed data validation of the flat files that were generated in UNIX environment using UNIX commands as necessary.

Used UNIX commands to investigate the log files and search for patterns.

Worked in SQL to access data from RDBMS, which is loaded on nightly batch runs for positions, balances and other referential data.

Involved in Regression and Integration testing of various components of the application.

Performed Back-End testing by writing and executing queries in testing databases to validate test results and to debug the issues.

Involved in summarizing QA sign-off items.

Responsible for coordinating/managing the testing activities and the timelines for each release.

Involved in Scrums and Daily Sprints in the Agile methodology.

Involved in various meetings with Business Analysts, Developers and Project Managers.

EDUCATION:

2004-2009 O.M. Beketov National University of Urban Economy in Kharkiv (O.M. Beketov NUUE)

Master’s degree in Project Management

Contact this candidate