Office Data

Gertrude Wray ******@*****.***

Belvidere, NJ ****3 609-***-****

Professional Experience

BNY MELLON, Pittsburgh, PA 2020- Present

Lead QA

Requirements analysis; author and execute test plans including scenerio and test scripts;

Creating and maintainence of test data;

Skills/Environments: Mortgage & Investor data; XML, JIRA; MS Office Suite, WebEx, Agile

EXPRESS SCRIPTS, Franklin Lakes, NJ 2018 – Dec 2019

Lead QA and Sr BSA

Facilitate, author and manage requirements from Enterprise Stakeholders and internal initiatives;

Monitor and daily analysis of inbound, external daily and weekly data feeds;

Develop and execute test plans / scripts to cover transactional; pharmaceutical-specific; empirical and anecdotal evidence – including creating and maintaining test data; On-going process and root cause analysis;

Maintain continual collaboration between stakeholders and development team to ensure all requirements are understood, addressed and agreements/approvals received.

Skills/Environments: Pharmaceutical and Pharmacy benefits data; Some ETL, SQL, JIRA (User Requirement/Stories; Release and Resource scheduling), Mainframe (COBOL/ BlueZone), MS Office Suite including MS Access, Outlook, WebEx, Agile

GAF, Parsippany, NJ 2017 – June 2018

Sr Dev Applications Support Specialist (QA) / Business Systems Analyst

Business/User advocate: Maintained clear understanding of requirements but more importantly for real-world needs; ongoing validation of dev solutions; UI design with each iteration; strive for synergy; integration accuracy and requirements coverage for desktop, Web, Mobile (Native iOS, Android, Windows);

BSA/QA functions: SDLC tasks; daily interaction with dev/designers; SME for 2 products

Dev Support: automation of E2E tests (Protractor); Code Review; monitor performance factors

Release Mgt: planning, release notes, sanity testing; UAT prep; (Dev is Agile-like while PM and QA still legacy Waterfall); coverage of BRD, FRD, UAT and data requirements; Scope changes;

Dev Test Strategies (QA Engineer): defect tracking / mgt – Root Cause Analysis, solution brainstorming; Validation: continual Integration; API and webservice monitoring; usability; data management: test bed creation (unit testing/scope coverage)

Skills/Environments: .NET, APIs, Webservices, Mobile (Native iOS, Android; Windows); SQL, Outlook, MS Office, SharePoint, TFS, VS Code; VS Team Services; some Protractor (E2E automation built over Selenium in AngularJS, Node.js, typescript)

3D Engineering; FLIGHT CENTRE of Australia; GENISYS Group, NJ 2015 - Dec 2016

QA Engineer / IT Specialist / Business Analyst (Process & Systems) – overlapping contracts

Defect Management, Test Strategies and Automation creation, UAT, ETL / data mapping

System Analysis: Gap Analysis, API design, system conversion planning, implementation management

Business Workflow automation / redesign, Digital Document Repository updates, front office reengineering;

Project Coordination: new project/client onboarding/intake, A/R, A/P, proposal tracking,

Markets: Travel / Marketing; Medical/Dental policy admin & claims; Civil Engineering

Skills/Environments: SQL, MS Office, CA (Rally), XML, QTP, json, work-flow mgt, document storage, general accounting, Agile, Off-Shore/ Virtual team models

MET LIFE (IBM), Somerset, NJ 2013 - Jan 2015

IT Specialist / QA Lead / Business Analyst

Hands-On Lead of On-Site and multiple Off Shore teams of 7 – 12 members

Test Strategies, Plans, Scenarios/Cases, Traceability Matrix, and scripts (manual & automated)

Planning: Resource Mgt/Estimating, Deployment scheduling; Daily Progress / Dashboard updates

Defect & Scope mgt: Root Cause Analysis, Scope Creep monitoring, solution brainstorming

Stakeholder mgt: continual liaison with Stakeholders (AD, PM, Business, Solutions) for Project Plans, BRD, FRD, UAT and data requirements; Scope changes, defects and warranty support.

Enterprise-wide projects for Sales, Commissions, Claims, Policy Admin, Contact Mgt (iContact), Compliance, eCommerce; Digital document storage/retrieval, Work Flow, ACORD ETL, Enterprise Dashboard, job scheduler updates; 20+ data feeds and downstream (some ETL), reworks; conversion of 3 apps to mobile

Skills/Environments: Quality Center(ALM), SQL, Outlook, MS Office, .NET, SharePoint, MicroStrategy, XML, Image and Workflow, eCommerce, SiteMinder, JobTracker, various Web services, DesktTop Intelligence/BO/Oracle, etc.

ANDESA SERVICES, Allentown, PA 2012 - May 2013

Sr. Lead QA / Business Analyst

QA and some Business Analysis of System, UAT, UAR and forecasting for proprietary Web-based admin program offered to Fortune 50 Life Insurance companies.

Develop and execute test scripts; create test data; defect trackingfor manual testing and New Automated Suites: creation and maintenance of new selenium-like framework (keywords, data)

Initiated repository for user documentation, QA artifacts; Data models and data dictionary; etc.

Skills/Environments: Proprietary company-written product(s) (Java / Pascal), Linux, Oracle, WebConsole, FTP Pro (IPSwitch), Apache Subversion, Internet Tracking Mgr (ITM), MS Office Suite, light Shell Scripting, Crystal Reports, SQL, Outlook, Project Insight, QTP/Selenium-like Automation framework.

MERRILL LYNCH / BANK of AMERICA, Pennington, NJ 2010 - Dec 2011

QA Lead / Business Systems Analyst

Delivered high-profile, data sensitive projects on time and under budget in a fast-paced, Agile-like environment – including some Requirements gathering, and test bed management

QA: Create, maintain and execute complete test strategies/ scripts for the UI, back-end, functional, Dark Pod, Black Box, E2E, Regression, UAT and go-live Sanity testing. Intermittent ETL / intergration; Defect Mgt / Scope change

SME for new ESPP product – vendor liaison, ETL (on-boarding); ensured data integrity for regulated systems

Skills/Environments: some Web-Based products (.NET), Mainframe/UNIX, TOAD, SQL, SharePoint, Clear Quest (Defects), Quality Center-with QTP (starting to build), Waterfall/Agile, MS Office Suite, Clarity

LEXISNEXIS (Redwood Analytics Division), Mt. Laurel, NJ 2008 - Mar 2010

Lead Systems Analyst (BSA and QA)

BA/QA-Customer service; needs analysis of custom BI software installations, upgrades and OEM products

Lead Tech BA/QA on new Web-based software product initiatives (i.e.: Benchmarking and Diversity)

Skills/Environments: SQL, Analysis Services, SQL Studio, MSAS, .Net Framework, Cognos, Crystal Reports, Panorama, Cizer Reports, Multi-Dimensional Cubes, SharePoint, Test Track Pro, MS Office Suite, Outlook, WebEx, Law Firm metrics/measures and profitabilities, Diversity and Benchmarking concepts, BluePrint, Agile and Waterfall Testing,

CAESARS ENTERTAINMENT, Atlantic City, Memphis & Las Vegas 1997 - Dec 2007

Sr. Business Systems Analyst/QA (eCommerce, Gaming, Marketing, POS, Promotions, Hotel and Data Warehouse)

BSA, Lead QA and/or PM for complete SDLC of enterprise and world-wide projects requiring abidence of Regulatory Approval and Compliance from all applicable local, state and federal gaming governing bodies (i.e.: Casino Control Commission, State of NJ DGE (Gaming Enforcement) ;

Lead QA – Hands on QA of all E2E, back-end; UI, data and regression; test data/environment set-up and maintenance; Defect Management, Root Cause analysis; UAT; On-going Warranty/ SLAs compliance; coach / mentor local, remote and off-shore IT, Business and SuperUsers

Mission-critical Metrics Project– Created prototype of state-of-the-art Data Model, developed solution archictecture and processes; initiated ETL procedures

SME for several Intranet, Internet and Casino products/programs, World Class IT Award

Programmer / Analyst (First 3 years)

Maintenance of casino (CMS), accounting and hotel systems (LMS) in RPG, VB, and CoLog.

Lead integration projects on multiple platforms (AS400, .NET, DOS/Windows, Mainframe, XML)

Skills/Environments: AS400 (iSeries): CL/RPG/DB2; .NET: VB/SQL; ASP, HTML, XML, web services; ETL, JavaScript, Teradata, Mercury Products (Test Director), Niku (Clarity), MS Office Suite, Outlook, NetMeeting, WebSphere, Flash, Kiosks, Mobile and remote/Mobile Apps

PRUDENTIAL PROPERTY & CASUALTY INSURANCE, Holmdel, NJ 1993 - Dec 1996

Programmer / Systems Analyst and Re-Engineering Design Team

Complete SDLC of enterprise systems - including requirements, regulatory, PM;

Reprogrammed OEM firmware for special re-engineered apps on DOS based platform;

Only non-executive member of the Re-engineering team;

Lead Analyst - TASC study - millions of manually collected transactional data elements; created automated data entry tool, developed analytical reporting suites with Lotus Notes Suite

Skills/Environments: COBOL, JCL, IBM Mainframe, DOS, CoLog, Lotus Notes, Lotus Script Language, Business Process Analysis, Re-Engineering Concepts

EDUCATION

Computer Science Major with Business Administration Minor

Somerset County College, Somerville, NJ

Dean's List, Computer Lab Associate (helped other programmers debug and revise their programs)

Contact this candidate