Anna Kun Email & Phone Number

Portland, Oregon, Us

• Facilitate continuous improvement efforts in the teams process and systems for development operations.• Organize testing activities across developers, QA engineers, and stakeholders.• Prioritize testing efforts based on business need and available capacity• Automate and maintain business processes using a diverse set of tools.• Assist other members of the analytics team with peer review and ad hoc query work.• Collaborate in developing the Enterprise Data Lake and Enterprise Data Warehouse and other Data Management projects and defining the Data Architecture.• Provide direction to assigned employee team, set clear expectations and review performance on a monthly basis.• Provide full employee support; maintain timekeeping records, conduct performance appraisals, interview, hire and train new employees, coach, provide performance improvement plans as needed.

Greenville, Sc, Us

Portland, Oregon, Us

• Created Test Plan, Test Cases for POWER platform , an integration of HR and clinical data into new DW , utilizing new developed components including : UI, ETLs, EDW, Analytical Services , POWER BI reports • Defect management and prioritization.• Collaborated with Business Analysts and Development team, facilitating the successful definition and review of functional and business requirements.• Collaborated with developers on testing and the optimization of technical solution • Support, security maintenance, monitoring and administration of multiple environments.• Analyzed source data • Validated ETL and overall data integrity • Contributed to separation of environments ( SOE) process definition• Contributed to deployment process procedures • Acted as a Scram Master for team training and ceremonies associated with Agile process of development

Lake Oswego, Or, Us

• Testing of Reporting Systems at all the stages of software development life cycle for KinderCare Education BI group • Testing of data warehousing transformation utilizing SQL Server, SSIS, SSRS • Verified new developed reports, including statistic calculation, UI changes, formatting utilizing Power BI, PBIRS• Developing test automation script for data validation utilizing SQL Server, NUNIT, NBI• Created test cases, user stories, provided estimates, created defects utilizing Jira• Participated in all stages of Agile Methodologies, including daily scram, estimates, sprint planning, retrospectives and user stories and tasks management. Provided guidance on agile methodologies to the team.

Chicago, Il, Us

• Testing of Reporting Systems at all the stages of software development life cycle for global management consulting company offering services to the Healthcare, Higher Education, Life Sciences, and Commercial industries, utilizing SQL Server and Spotfire • Verified existing and new developed reports, including data staging, statistic calculation, UI changes and graphics expressions • Verified logic and perform deployment for all objects required for reporting • Created test cases, user stories, provided estimates, created defects utilizing Azure DevOps• Participated in all stages of Agile Methodologies, including daily scram, estimates, sprint planning, retrospectives and user stories and tasks management . Provided guidance on agile methodologies to the team.

Armonk, New York, Ny, Us

Sr. SQA Engineer/Team Lead (August 2009 to Present)Created and executed Test Plans, Test Cases, Test Scripts for the Loan Workout Solution, for the mortgage servicing industry.Defect management and prioritization.Test Lead for multiple projects, including the hiring of resources, estimation of work efforts, and task allocation.Managed local and offshore SQA resources utilizing Agile approach for software development and testing.Mentoring and training of project resources including SQA, Developers and Business Stakeholders.Planning and maintenance of automation efforts, identifying priorities and the optimization of testing efforts.Validation of APIs, web services and file transformations.Collaborated with Business Analysts, UAT and the Business Stakeholders, facilitating the successful definition and review of functional and business requirements.Collaborated with developers on unit testing and the optimization of technical solution specifications.Support, security maintenance, monitoring and administration of multiple QA environments.Facilitated DBA reviews, validation and analysis. Validated ETL utilizing multiple DB tools. Release management including manual and automated deployments of framework and SQL server objects as well as DBA reviews.

Us

•Involved in testing of Reporting System at all the stages of software development life cycle •Verify changes in database architecture between multiple servers and databases such as Microsoft SQL Server and Teradata. Provide Performance, Regression and Load Testing•Verify the logic and performance of ETL processes between multiple servers, with Informatica •Verify logic and perform deployment for all objects required for reporting to Informatica•Created test cases in a form of SQL query to verify logic for standard and Custom Reporting system. Utilize MS SQL Server 2005 , Teradata and HP Quality Center

Tested on-line casting call management application, which enables communication between talent, casting directors, and photographers Provided functionality, regression, and release acceptance testing Tested browser and operating system compatibility (IE, FireFox, Windows XP/NT) Tested performance, usability, navigation, links, images, forms, etc Developed test cases and test suites for the designated areas of testing Executed structured and ad hoc tests against new releases Utilized Mantis web based bug tracking system to report software anomalies and defects Reported numerous problems of various severity level Verified bugs fixed in new releases, Followed up with reported problems until satisfactory Provide regression testing of software updates before uploading them to Production Server

Tested proprietary software applications developed for needs of international cleaning systems franchise company. The applications tested include:Web based promotional facilityClient-server Franchise Business Management application (Windows XP/NT, MS SQL Server)

Us

•Designed, implemented and tested Address Verification Application and Address Verification Web Service using .NET technology, MS Visual Basic 6.0, and third party COM objects. Utilized GROUP1 Client to standardize the address verification and SQL Server 2000.•Designed and implemented the foul language COM object to reduce great number of the incorrect records that were coming from the company’s web site.•Was responsible for development and support of the major TVGuide Magazine SQL Server Databases. Have written various stored procedures to format each incoming customer record to the standard form and to synchronize several databases accordingly to the updated information.•Performed DBA and Data Warehouse Analysis duties

Philadelphia, Pa, Us

•Developed ActiveX DLLs for AMEX project, automating repeatedly performed tasks, related to downloading large flat files to MS SQL Server 7.0. •Designed, implemented and tested an ANCHoR 2000 (Automated National-specific Homeless services Recording) information system with a minimum of supervision. The system included Outreach, Assessment, Residential, Service Planning modules. Implemented database model design and software distribution wrote 95% of code. Used MS Visual Basic 5.0, MS SQL Server 7.0, Windows NT.•Created numerous reports using Crystal Reports 6.0/7.0. Develop ActiveX DLLs, automate repeatedly performed tasks, related to report printing, parsing selection formulas with a large number of user-defined input parameters, and other application features. Environment: MS Visual Basic 5.0, Seagate Crystal Reports 6.0/7.0, MS SQL Server 6.5/7.0.

International Economics

Managment Information Systems