Douglas S. Flam

** ********* **** * ********, CT 06611 n Cell 203-***-**** n acrwzq@r.postjobfree.com

CAREER SUMMARY

Solutions-focused Quality Assurance Specialist/Lead with extensive experience in testing new web-based applications for Financial Services and e-Commerce Entertainment corporations.

Work closely with testers, developers and other team members in testing complex projects and in the overall enhancement of software product quality.

Sound understanding of SQL querying and reporting techniques from relational database management systems.

Excel in creating test plans and writing/running manual test scripts to pinpoint software defects, track bugs, close open defects and validate functionality. Serve as a value-adding member of QA teams

Technology & Testing Proficiencies

Proficiencies:

Requirements/use cases analysis, preparing Test plans, Test case authoring, defect reporting and Test status summary reporting

Technology Skills:

MS Office, FileZilla FTP, Putty, Omniture, Accertify, Firebug, Web Services, Test Harness, HTTP Protocol

Testing Methodologies:

Functionality Testing, System Testing, Regression Testing, PCI Standards Testing, Responsive Web Design Testing, Acceptance Testing, Merge Testing, Accertify Credit Card Testing, Omniture SiteCatalyst Tracking End-to-End Testing and Browser Compatibility Testing (I.E. 8 and prior, Mozilla Firefox, Google Chrome and OS/Mac Safari)

Scripting Tools:

Unix/Linux Shell Scripting, Perl Scripting

Systems:

Unix/Linux, Windows 7 and prior, J2EE, OS400(CLP), Oracle, ASP, .NET, PHP, MySQL, Oracle BRM

Languages:

SQL, HTML Progress

RDBMS:

Oracle 11g, AS400 Query, VPAS

Tools:

HP ALM Quality Center 11.0, Jira, SoapUI, XML, Chrome Mobile Emulator, Oracle SQL Developer

PROFESSIONAL EXPERIENCE

SiriusXM Radio New York, NY. August 2011 – Present

Consultant-Functional Quality Assurance Analyst

Responsible for developing and maintaining software test plan, test cases and test scripts of new and enhanced components of the current functionality on the Oracle BRM supported the Client Service and CSR SiriusXM Subscription Management Service platforms written in HTML, XML .NET and Java.

Performed functional testing on multiple projects, in numerous environments, simultaneously to confirm the development coding was being correctly merged.

Documented and reported Defects that arose, in Quality Center ALM, through JIRA ticketing application and provided test leads with timely metrics and project progress.

Wrote complex SQL queries joining multiple tables on Oracle SQL Navigator, to generate specific back-end General Ledger views confirming Accounts created Subscription Management Service applications displayed expected results in proper tables.

Traced Business Requirements to Test Strategies and Test Plans and executed Test Lab scripts in Quality Center ALM, while providing appropriate documentation to development team and business analysts that tracked and closed issues in Defect tracking. Assured the Defects were given proper level of severity and followed up until resolution.

Created test cases in MS Excel that were uploaded to Quality Center ALM

Lead QA on a Maintenance team working in an Agile methodology with daily stand-up calls to test Hot Fixes and move them to Production. Presented root cause stories and collaborated with Developers to ensure quick resolution.

Expertise in all phases of the Software QA process, including WEB and Client/Server applications testing in development and maintenance environments for Windows and Mac browser compatibility-often VM Ware.

Test Lead for Functional Testing of Responsive Web Design of a mobile application for Payments, across wide range of devices. Derived test plan from Business and Design Specifications. Included testing of Address Verification System and Omniture Analytics Tracking. Made use of both Chrome and Firefox emulators to functionally ensure that all personal devices would experience trouble-free reading and navigation while panning scrolling and re-sizing.

Gathered requirements, created and edited MS Excel workbook templates from manual test scripts. Supported the Data Automation QTP team in the creation and verification of the Regression test suite.

Executed shell scripts to generate specific back-end reports, simulate customer email notifications, loaded and tested OEM data for pricing related applications

Perl script was executed to simulate daily transactions for multiple accounts in current and future timeframe, and verified that the billing and pricing behavior was as expected.

Performed Unix/Linux Shell scripting commands including KPI reporting, vi pin log updates through Putty SQL commands to load and test data entry expectations in pricing apps.

Executed SOA Web Services Test Harness and SoapUI requests to automate, create and manipulate test accounts.

Worked closely with Developers and Business Analysts to transform SiriusXM business requirements into traceable Quality Center test cases for manual testing.

Tested Password creation and Credit Card data masking to confirm they conformed to Payment Card Industry Data Security Standard.

Priceline Norwalk, CT. September 2010 – April 2011

Quality Assurance Analyst

Tested Web Applications or applications written in web languages C#,ASP,.NET, XML, PHP and HTML in all Windows and Mac browsers.

Backend and regression tested applications with data entries using SQL on Oracle SQL Developer and MySQL.

Worked closely with developers and clients to analyze and gather requirements into Quality Center for manual testing.

Functional translation of requirements into test cases and scripts.

Documented and reported defects that arose and provided management and clients with timely metrics and project progress.

Robert Half Technology/William Raveis Shelton, CT. November 2009-April 2010

IT Consultant/Business Analyst -William Raveis Mortgage Company

Responsible for researching, scripting, data mapping and implementing QlikView dashboard reporting tool used in gathering data from unconnected profit silos applications to determine the best course in cross-selling financial services products enterprise-wide.

Completed project to gather user requirements and research vendors to determine the cost effectiveness of purchasing a Mortgage process imaging tool.

Completed projects to gather user requirements and research the cost of enhancing Contact Management system and the Internet/Intranet web-site design for Loan Officers.

Prudential Financial (acquired Skandia Corporation 2003) Shelton, CT. 1995-June 2009

Quality Assurance Specialist (2005-June 2009)

Performance, regression, negative, smoke, back-end and user acceptance tested Annuities Web Services application with JSP based pages, to verify conformance resulting in adherence to business requirements and guidelines.

Performed SQL queries in AS/400, VPAS and Oracle databases, to create and validate test cases.

Provided daily metrics on testing status. Included total completed, passed or in Defect status.

Performed black box and front-end testing tasks, using Waterfall methodology, on new functions (web frames, products, benefits, roles and authority changes), modified and existing features (eDocs batch component tested online w/ PDF document viewing), introduced to WebSphere application servers for regularly scheduled release cycles.

Designed Requirements, Test Plans and executed Test Lab scripts in Mercury Quality Center, while providing appropriate documentation to development team and business analysts that tracked and closed issues in Defect tracking. Assured the Defects were given proper level of severity and followed up until resolution.

Participated in creating traceability from business requirements to functional specifications to test strategy and collaborated with analysts and developers during functional specification walkthroughs to clarify design issues early in the testing phase.

Conversion Team Specialist (2003-2005)

Worked in partnership with analysts and developers to convert and integrate inception-to-date activity for over 400,000 contracts from the Skandia AS400 to the proprietary Prudential administration system.

Prepared Data Mapping, Test Strategies and Test plans to assure data accuracy for translation into new system

Performed backend testing by writing SQL statements to assist the team in making sure all data converted as expected.

Business Analyst (2001-2003)

Created and maintained SQL queries, to produce timely scheduled activity reports through MS Access, to support the requests of the sales, customer service and legal departments.

Addressed over 60 weekly ad-hoc reports, from requests generated in the reporting help desk queue, to maintain the 3-5 day service level agreement turn around requirement by individually completing 95% of all requests, to provide exemplary and often-recognized benefit to the company sales teams.

Gathered requirements from business partners to direct developers and consultants in the creation of over 30 new user friendly automated screen options to successfully enable the generation of self-directed reports.

Technical Support Specialist (1995-2001)

Provided technical support for accounting and compensation department by writing queries that would assist in daily reconciliations and year-end financial reporting.

Created and maintained complex spreadsheets necessary for determining the monthly sales activity of over 70 wholesaler territory assignments and thereby facilitating the process of compensation computations.

Acted as User Acceptance Tester to make certain that commission percentage, product and firm compensation table changes updated in the proprietary system assuring integrity in the reporting documents.

EDUCATION

MBA–Management Information Systems, University of Bridgeport, Bridgeport, CT.

BA, Psychology, Kenyon College, Gambier, OH.

Contact this candidate