Serge Kazin

Education

• MSc, Moscow State University, Saint Petersburg State University of Aerospace Instrumentation

• Certified Scrum Master (CSM)

• Business Analysis & Professional courses at Millennium Communications & Training (MCOM)

• Project Management Professional training, PMI PM training.

Career Summary

• An experienced Software QA Lead and Software Quality Assurance Analyst

• Background includes Requirements Analysis, Project coordination, Customer relation, Software Quality Assurance and Test Planning, Resource Management, Functional Test Cases execution, Test Result Analysis and Bug Track Reporting.

• Extensive work experience in ETL testing and Data Analysis using SQL on Oracle, MS SQL Server, DB2 & Teradata.

• Experience performing Quality Control activities included Verification and Validation processes as well as strong knowledge of Automated and Performance Testing Tools.

• Working for Software, Financial and Telecommunication companies, Mr. Kazin has acquired strong Software Engineering knowledge and SW Quality Assurance /Testing proficiency

Professional Experience:

Royal Caribbean International September 2018 - Present

Testing Lead

• Participate in Test Strategy Development and ensuring application of Quality Management throughout the product delivery process for Espresso transformation within Air Modernization Program

• Acting as the Espresso subject matter expert, providing knowledge transfer to other teams

• Manage day to day activities of test engineers and work with technical leads, product owners, and release managers within an agile/scrum environment.

• Proactive and disciplined refinement of Stories/Features in the backlog

• Support and guide Functional Testing, deliver the Business value every sprint

• Determine the test scenarios needed in order to effectively and efficiently test the solution based on requirements and design

• Created Espresso dashboard and provided timely status update to Program Stakeholders and Senior Management

• Identify business implications of technical solutions to the current business environment. Interprets, refines and applies methods and procedures in accordance with Software Development Life Cycle (Scrum, Agile), Information Technology industry standards and best practices as defined by the client.

• Leverage requirements modeling and testing tools to address business needs.

• Utilize data from external provider to properly class MDM data components (customer category, sub-category, etc.).

• Perform functional, integration and regression testing as well as Data certification process.

Environment: Hospitality, Sales. Jira, Confluence, MS Office, Visio, AS400, Oracle, Web Services, Sitecore Content Management, SOAP UI, Selenium

TracFone Wireless Feb 2018 – Aug 2018

Senior QA Technical Lead

• Provided analysis of strategic business information systems including business process and system processes

• Wrote and reviewed use cases, user stories; Work on re-engineering business requirements into user stories and epics (transition from waterfall to agile)

• Worked with Business users to develop test cases and define acceptance criteria.

• Produced and explored requirements in collaboration with business users and SME.

• Coordinated activities with Development team during requirement analysis and estimation phase.

• Worked with business and IT stakeholders in defining and reviewing functional and non-functional requirements in form of high-level Product Features for the application including scalability, performance, recoverability, security and confidentiality, maintainability, operability, and availability requirements. Design individual technology components of the application development, runtime, and operations.

Telecom OSS/BSS, Jira, Confluence, BRD, FRD, HLD, system architecture and sequence diagrams, MS Office, Visio, Oracle SQL Developer, ETL, SOAP UI, QTP

LIBERTY POWER May 2015 – Feb 2018

Senior QA Lead / Senior Data Analyst

• Lead the test planning of the Data migration, ETL and Orders API testing.

• Created Test plans, End to End scenarios, test scripts / test cases in Microsoft Test Manager.

• Leading and coordinating daily Wholesale and Pricing deliveries, Regression and production support activities.

• Developed SQL scripts to ensure Data Migration and Data transformation completed as per Business requirements and mapping specifications.

• Maintained stored procedures required for execution of monthly and quarterly financial reports

• Tested mobile applications on live handsets and by using simulators

• Configured TFS 2015 as per Natural Gas project requirements

• Worked with Architecture, Business, project and development teams across multiple locations.

Environment: Billing, Forecasting, E2E testing, Data migration, ETL, Windows, MS SQL Server, Visual studio, TFS 2012 client, TFS 2015 web, MTM, SSIS, ETL, Excel reporting, SOAP, WCF test client, Postman, SQL, Azure, MS Dynamics CRM

ERICSSON July 2012 – May 2015

Senior QA Consultant

• Assisted IT QA Manager in the planning of the Data migration and ETL testing.

• Assisted IT Compliance Manager in the planning of the annual SOX and PCI testing.

• Led and coordinated daily PCI test planning activities during System test and UAT, daily reporting.

• Ensured in-scope risks and controls were identified in the project risk assessment during the planning phase, appropriately captured and evaluated.

• Validated applications to meet security requirements, PCI compliance, and other requirements supporting confidentiality of data.

• Reviewed Framework for System Validation to ensure that the software being deployed meets the regulatory requirements and will continue be compliant over time.

• Ensured that IT controls were updated and changed, as necessary, to correspond with changes in internal control or financial reporting processes.

• Assisted Program Director in the planning of tools setup and implementation.

• Provided transparent reporting of program status, milestones, dependencies, issues/risks, root cause analysis.

• Worked with Architecture, Business, project and development teams across multiple locations.

Environment: Billing, Provisioning, Security, Data migration, ETL, Unix, Oracle, SQL, Jira, HP QTP, QC, MS Project, Excel reporting

Client: US CELLULAR April 2014- December 2014

Senior QA Consultant

• Leading and coordinating Bill Validation testing in production like environment.

• Analyzed Revenue Assurance requirements and test specifications to determine the most efficient design approach for testing of full Production volume of data.

• Responsible for Planning, test Execution, overall Test Delivery and post Implementation.

• Leading SQL scripts customization for Data integrity validation, team coaching.

• Identified process improvement areas and maintained high quality delivery standards during Business transformation.

• Lead Backlog team to review and resolve 6912 production tickets in less than 7 weeks. Major production defects have been identified and associated with tickets impacting more than 2 000 000 customers.

• Leading and coordinating onsite and offshore teams of Billing, CM, TRB, AR, Collection and OMS Support Analysts.

• Planned and monitored daily activities to ensure effectiveness and high-quality results.

• Served as key point of contact on the client site for Senior Management and Business escalations.

Environment: AMDOCS ABP 7.5, Amdocs Invoicing, AR, Collection, CRM, OMS, Unix, Oracle, SQL, IBM Rational, HP QTP, QC, MS Project

Client: TELCOCELL July 2012 – April 2014

Senior SW QA Lead, Test Architect, Incident Manager

• As Technical Lead responsible for testing CRM (Enabler) related projects in all stages of SDLC starting from Assessment and Requirements Analysis till Production Implementation

• Incident and Defect Management, Managing resources, Customer interaction

• Testing coordination, Leading UAT testing

• Business requirements analysis, Test planning for high complexity system testing and Test Execution

• Legacy Data Migration

Environment: AMDOCS ABP 7.5, Amdocs Invoicing, AR, Collection, CRM, OMS, SQL, Unix, AIX, Oracle, SQL, Cloud based Assembla and Service Now

ROGERS COMMUNICATIONS INC. December 2010 – July 2012

Senior Performance Lead, Project Coordinator

• As Technical Lead responsible for testing v21 (Ensemble) related projects in all stages of SDLC starting from Assessment and Requirements Analysis till Production Implementation

• Leading and coordinating on-site and off-shore testing team (TCS India) for Performance and Volume testing of GG EDW including source impact of Billing, CSM Online, AR and Dealers processing.

• Analyzed and reviewed requirements, specifications, design documents to determine the most efficient design approach for testing of full Production volume of data.

• Developed baseline based approach for testing applications (COBOL) and batch processes (JCL)where test environment is not scalable to production.

• Worked closely with Business, Development, DBA teams and vendors (AMDOCS, IBM, Deloitte, Adastra, HP, Teradata, Informatica) to identify the most efficient solution during Performance and Capacity Planning

ROGERS COMMUNICATIONS INC. Jan 2010 – December 2010

BT SFT Prime

• Leading and coordinating off-shore testing team (IBM India) for SFT at Rogers Business Transformation Project. Designing and developing test scenarios and test cases based on business and functional requirements as well as reviewing test cases prepared by team remembers.

• Analyzed and reviewed specifications, design documents and impact assessments to determine the most efficient design approach for testing

• Working closely with AMDOCS team on Business Analysis

• Monitoring and reporting daily results, performing a key analyst role in Customer Interaction Sub domain (Billing Arrangements, Financial Activities, Collection) for AMDOCS CRM and legacy system– analyzed data structures of both systems, developed conversion systems specs.

Environment: Telecommunications, E-commerce, Provisioning; AIX, MVS; ORACLE; TOAD; SQL, IMS; WINDOWS XP; COBOL; Rational Clear Quest; Mercury Quality Center; QTP

TELUS June 2006 – December 2009

Senior SW QA Analyst, QA Lead

• Analyzed and reviewed specifications to determine the most efficient design approach for testing

• Developed test strategies, plan, data, test set-up, test cases and update existing test packages according to functional requirements

• Worked on data migration and data conversion

• Developed Functional Test Scripts for Automatic Daily Operational Report.

• Activated and programmed different types of handsets / devices, validated on Network elements and performed end to end testing (PCS Postpaid, PCS Prepaid, IDEN (MIKE), pager)

• Used RCM (Resource control Manager) Applications, which manages subscriber related resources such as MIN, MDN, MSISDN, IMSI and Static PCS IP addresses) to setup the Test Data

• Validated portals and web services for SDF (Service Delivery Framework) project to ensure existing web services work for the new network type HSPA and is backward compatible with CDMA and iDEN.

• Testing Knowability (ENSEMBLE) Price Plan, CSM, Switch Control and MAF, T2T. Created real and simulated usage of different types: CDRs, ipDRs. Created data for testing needs, validated usage rating of all levels of complexity, followed all steps of provisioning. Successfully completed Wireless Number Portability Project.

• Tested CRM back office operations to make sure it supports both current and next-generation voice, data and video services.

• Implemented Post-release Quality control methods as part of workflow within the Rational Unified Process.

• As a QA Lead worked closely on Change Requests (CR) with business, PM, development team, Engineering and other QA teams.

Testing procedure included:

• Functionality Testing

• System Testing, Systems Integration Testing

• Positive and Negative Testing

• Regression Testing

• User Acceptance Testing (UAT)

• End-to-End Testing

Environment: Telecommunications, E-commerce, Provisioning; Sun Solaris 5.9; ORACLE; TOAD; SQL; WINDOWS XP; WS_FTP; TELNET; MS OFFICE 2003/2007; Rational Clear Quest; Mercury Quality Center

BANK OF MONTREAL Dec 2002 – June 2006

SW QA Lead and ETL Tester

Project: The Basel Retail Project Phase One was successfully and cost-effectively tested for the Data Integrity and Transformation (ETL) in accordance with requirements set by the federal regulator, Ontario Superintendent of Financial Institutions (OSFI).

• Developed Quality Assurance & Test documentation, including Test Level Assessment and Strategy for the System and User Acceptance testing. For several projects including Basel BMO and Basel Harris

• Performed Integration, System and Regression testing of Basel BMO Retail Data Mart.

• Developed test design for Staging and Basel Retail & Commercial Data Marts

• Responsible for Test environment creation and maintenance for off-line and production processing for both QA and UAT environments.

• Provided review of QA & Test documentation and leading of small group of testers on several projects, managed implementation of QA activities including code review, inspections, business requirements and data model walkthrough.

• Implemented and executed script’s templates to improve existing ETL test procedure.

• Managed priorities, assigned resources, provided estimations and monitoring QA activities for all BASEL projects.

• As a Department Information Security Practitioner developed and implemented activities to protect privacy Data using in different Data Marts

• Maintained test environment and user-vendor communications.

Environment: Financial; IBM; Data Warehouse; WINDOWS 2000; WINDOWS XP; AIX; Shell; MVS, IMS, MS Office; AbInitio; DB2 UDB; Erwin; SQL; AQT; Oracle

COWBOY CORP Jan 2001 – Dec 2002

SW Quality Assurance Lead

Project: he Customer Relationship Management System (CRM) was successfully and cost-effectively tested for the Data Integrity, Usability, Load and Stress requirements

• Participated in Customer relationship management and Automotive lead management system development through whole Software Life Cycle (Requirements, Design, Source Code creating, Implementation and Testing, Product Release and Maintenance).

• Designed and implemented testing strategies, formulated and maintained Testing plan and schedule.

• Worked to develop an overall Quality Assurance methodology for the company (Cloud based CRM for Auto Dealerships)

• Compiled and prioritized requirements to achieve optimal coverage within a limited time frame

• Worked closely with Product Manager and Business Analysts to arrange walkthrough of testing requirements.

• Test cowboycorp.net software releases, ensure overall quality of the website.

• Conducted Usability testing for GUI, participated in the process of evaluation the product for usability by developing Human Computer Interface (HCI) in a manner that reduces erroneous input.

• Set up QA environment, created and executed Regression, Performance and Transition test.

• Managed Defect Tracking System and coordinated software releases with the development team.

• Created functional and system test cases for Credit Application business scenario as well as Credit Bureau interface.

• Evaluated existing Automated testing tools as Astra Quick test, WinRunner, RSW E-Test, Rational Robot, Open STA and determined where automated tools could expedite and reduce errors in the testing process.

• Performed Security testing, attended and evaluated walkthroughs of various documents in the process.

Environment: E-commerce, B2B: Linux, Sun Solaris; ORACLE, SQL-server; Tomcat, IBM WebSphere, BEA WebLogic; SQL; Windows 2000 Server; .NET, Visual Source Safe; X-Win32; Visual Intercept; Astra Quick Test; e-Test.

Contact this candidate