QA analyst

Marianna Sandler Email:********.*******@*****.***

Linkedin.com/in/mariannasandler Cell: 215-***-****

SUMMARY

A results-driven Quality Assurance analyst with experience in integration testing mainframe, web and API based platform, test analysis, test documentation and execution effort to support development and implementation of software changes. Organized and meticulous team player, who exemplifies professionalism, and an ability to manage multiple projects and tasks at any given moment. Adept at learning and applying new skills and technologies.

Thorough experience in Agile, Scrum methodologies.

Continuous integration, E2E testing.

Code coverage and defect analysis.

Analysis of end user requirements and technical documents.

Experience across multiple types of testing.

REST API (Postman, Swagger).

Strong Data base experience in Microsoft SQL Server. Expertise in writing SQL queries in validating data. NoSQL Mongo Database.

Automated test suites (Mercury testing tools, Selenium IDE).

Compliance tracking systems (Quality Center/ALM, Jira, Azure DevOps).

Proficient in MS Office product Suite.

PROFESSIONAL EXPERIENCE

CEI Fleet Collision and Safety, Trevose, PA

IT Senior Quality Assurance Specialist, 2017 – Present

As an IT senior quality assurance specialist oversee all aspects of quality assurance including establishing metrics, applying industry best practices, and developing new tools and processes to ensure quality goals are met.

Work in a fast-paced Agile, SDLC environments.

Attend daily scrum meetings.

Strong proven expertise in creating Verification and Validation test plans, and test scripts based on high-level and detailed designs.

Work closely with stakeholders to form profound understanding of business processes. Translate business requirements into test cases.

Test the front-end application in client server environment with Microsoft SQL Server database as back end.

Develop SQL Queries to retrieve and verify data from the database.

Conduct cross-browser testing to check applications work at different browsers and versions (IE11, Chrome, FireFox).

Participate in dress rehearsal plan development for the integration.

Ensure that all test cases are updated accordingly in Azure DevOps along with User Stories.

Test the new functionalities, enhancements and production problems following the test case steps and coordinate with development team in fixing the issues. Doing Defect Management by Logging and Tracking bugs during the execution. Provide developers with written steps to reproduce software defect problems.

Run automation script for sanity test in all environments.

Perform UI Frontend and Backend Testing.

Validate REST API services.

Work with development team and business analyst to define, design, document and execute functional and regression test to ensure new applications and enhancements to existing applications meet functional requirements.

Perform the verification after the each code deployment to the Production environment.

Participated in the following projects through CEI:

oElement Integration that involved merging two different claims management systems from two industry leaders.

oSmartAction project included collection of all First Notice of Loss data over the phone with virtual agent, and communication to the Claim application. This project caused full-scale changes across CEI Operations.

VERIZON PARTNER SOLUTION, Philadelphia, PA

IT Quality Assurance Specialist

Wholesale Access Team, 2000 - 2016

Functioned as a key point of contact in Wholesale Access ordering systems as well as with the regulatory and legal obligations that our team is mandated to comply with at Verizon.

Worked on high visibility projects, requiring order entry and testing support that is critical to delivering revenue of $62M for Verizon Partner Solutions in 2016.

Delivered support across the SDLC life cycle start from requirement till code drop certification. Received awards for demonstrating core values and going far above and beyond.

Developed test plans, cases, and scripts to support QA testing (manual and automated). Code and execute scripts for regression/progression testing with an emphasis of software testing for client/server system applications which resulted in reducing time by 50%, and generate cost savings totaling $88K.

Identified issues by using multiple tools including SPUFI and web base in-house written applications. Documented software defects and performed additional testing to verify all issues were fixed before the final delivery. Facilitate daily Trouble Ticket call with Development team for the purpose of decreasing turnaround time.

Had close and productive relationships with PM and Design teams to ensure the content is meaningful and correct. Participate in design sessions and use the information obtained as basis for developing test cases following agile methodology. Analyze the impact of changes and enhancements on existing systems. Interact with Development team to perform root cause analysis and preliminary problem diagnosis, insuring systems tested meet end-users’ requirements.

Helped to deliver a superior customer experience through Verizon’s products and services. Mitigate security and regulatory risks and fulfill industry-mandated changes.

Performed production verification for both major and maintenance releases to reduce fallout work in centers and avoid any risk of financial penalties to Verizon.

Served as a liaison between developers and different business units to promote information flow, minimize access costs and drive operational efficiency. Communicate with business stakeholders regarding installation issues and software defects.

Developed training materials for on shore and offshore teams.

Created and maintained test data and Winrunner scripts in separate environments including QA, CTE(production like) and production

Supported and maintained standard tracking and reporting procedures for Wholesale Integration Test Team related to EDI and WEB testing.

Provided assistance in all data procurement activities for all regression and progression test scenarios in South region for all Wholesale Releases throughout the year as required and requested.

Generated automated scripts using Winrunner automated testing tool for Express Track Level 2. Result of the completion of this task was benefit a Wholesale Integration team to allow of the tasks 80% less time that is normally spend on working those manually in the QA, CTE and Production Releases as well as accuracy of the final result which is 855 EDI output transactions.

Supported and maintained team infrastructure. Maintained Winrunner scripts for Express Track Level 2. Provided training for Express Track Level 2. Helped to setup Express Track application for first time users.

Provided technical support during QA testing for EXPRESS TRACK project. Defined test scenarios, created test plans, generated test scripts using automated test tool WINRUNNER v6r0. Maintained data for both progression and regression testing. Verified data in RDBMS (DB2) using SPUFI and FILE-AID for DB2.

DMR Consulting Group, Inc

State of New Jersey, Trenton, NJ, 1999-2000

Consultant

Had a lead role in gathering and summarizing user requirements for Ten years and Graduated Driver License project. Worked on modification, renovation, and testing of the on-line Business Licensing System (CICS/DB2). Analyzed the correspondence of user requirements and legacy of the existing Agency Interface System.

Managed the OIT MVS Y2K validation and verification project using mainframe-based VIALOFT application and PC-based PERITUS package. Participated in maintenance of the Y2K INVENTORY System using ORACLE 7.1

Created Ad-Hoc users’ revenue reports required retrieval of information from RDBMS (DB2) using SPUFI and COBOL batch processing.

NJ State Police, Trenton, NJ, 1998-1999

Consultant

Worked on design, renovation, and modification and testing of the NJ State Police existing batch reporting system to ensure Year 2000 readiness using contemporary version of COBOL/MVS, structured programming technology and new user requirements. Prepared detailed specifications and programming documentation for renovation of the on-line Criminal History System to be Year 2000 compliant.

MARKETING COMMUNICATION SYSTEMS, INC, Ivyland, PA

Senior Programmer/Analyst 1997-1998

Participated in enhancement and maintenance of DATABASE CustID, which manages distribution of advertisement of services for AIG Insurance group trough mail.

Provided technical support to production batch process. Created SAS reports for our clients per their requests. Prepared all shipment documentation for outgoing tapes and all created reports delivered to our customers.

Managed discussions with client and working the strategy for resolution of all arising problems and upcoming requirements from customer side.

Had a key role in analysis and design of database for the new customer (Metropolitan Life Insurance Company). Software used included COBOL, COBOL II, VSAM, MVS JCL, QiuckJob, SAS.

COLONIAL PENN LIFE INSURANCE COMPANY, Philadelphia, PA

Programmer/Analyst 1996-1997

Participated in data conversion of Providential Insurance Company to Processor 1 Insurance Package currently being used by Colonial Penn Life Insurance Company.

Participated in data conversion of Lifecomm System to Metromail, in enhancement and maintenance of Documerge System and Agent System. Upgraded and maintained the APECS System that managed abandoned property until you report it to the state. Provided technical support to production batch process on rotation basis.

EDUCATION / TRAINING

Bachelor of Science and Engineering.

Odessa State Academy of Technical Regulation and Quality, Odessa, Ukraine

Visual Basic/Database Management Course, Certificate of completion

Contact this candidate