Sr Qa Analyst (contract) Resume
Dallas, TX
SUMMARY:
- Ability to gather, analyze, interpret, document and understand business requirements and specifications.
- Excellent understanding of software development life cycle & network capacity planning process.
- Ability to use business intelligence tools to generate reports and dashboards.
- Solid understanding of QA process & methodologies (CMMI, RUP, Agile, RAD, Waterfall).
- Ability to test stand - alone, client-server and web-based application.
- Expert in various levels of testing (sanity, smoke, functionality, regression, performance, load, front end, back end testing, user acceptance).
- Proficient in maintenance of test matrix and traceability matrix.
- Hands-on team leader with strong focus on documentation, communication (Oral & Written), process improvements.
- A flexible and amazing team player, quick learner with proactive attitude.
- Highly efficient in complex, fast paced, dynamic, onshore-offshore environments.
- Great at establishing and maintaining customer - client relationships.
- Proper understanding of how visualization tools processes raw data into meaningful information.
- Knowledge of big data technologies (Hadoop).
- Abundant skills at using analytics and statistical tools to interpret data to support business reports and marketing initiatives.
- Possess logical, analytical and quantitative reasoning skills.
- Proficient in statistical, financial modeling and data quality analysis
- Skilled at creating data models and processes for database designs - physical and logical schema diagrams, queries.
- Possess working knowledge of networking, high speed data, docsis, cable digital video & media industry, voip standards.
- Knowledge of adobe experience manager, digital asset management, document services.
- Exposure to ISO 9001.
TECHNICAL SKILLS:
OPERATING SYSTEM: Windows Server, Windows XP, UNIX, MacOS, Vista, iOS, Windows 7, 8, 10
TESTING TOOLS: Rational Team Test, QTP, Winrunner, Load runner, Termite
BUG TRACKING TOOLS: Rational Clear Quest, HPQC, Test Director, TCM, BLT, HPALM, Jira
FRONT END TOOLS: Adobe Photoshop, MS Excel, MS Office, MS Project
LANGUAGES: SQL, TSL, Python, VB Script
WEB TECH: HTML/CSS, Web Services, UML, SOAP UI, TCP/IP, XML
DATABASE & REPORTING TOOLS: Oracle 10g, SQL Server 2012, MS Access, MS Excel, Tableau, R, SAS
PROFESSIONAL EXPERIENCE:
Confidential, Dallas TX
Sr QA Analyst
Responsibilities:
- Analyze Confidential payware tokenization user & software requirements and translate into test requirements.
- Test payment transactions on POS terminals and verify security features of transactions.
- Develop and execute test plans, test strategies, test scenarios and test cases for different payment processors.
- Provide test estimates for functional & regression test cycles at the same time maintain balance between software quality and delivery timelines.
- Analyze test results, write test summary reports and metrics detailing overall quality of the software, efficiency of the tests, and productivity of the test team.
- Document, report, and track to closure the defects found in the software and gave assessment of its quality.
Environment:: API, XML, VMX 925, VMX 915, POS terminals, e355 terminal, iPod, Excel, TCP/IP, Networking, SQL.
Confidential, Irving TX
Test Lead
Responsibilities:
- Validated channel subscription information, guide data, cover arts, widgets on set top boxes.
- Synchronized inter STB transactions in multi room DVR. Tested encrypted and premium cable channels on cableCARD-capable devices.
- Wrote SQL statements to query database in back end testing.
- Provided clear in-depth analysis and test reports to sr. management.
- Performed QA testing of guide and video applications on Motorola and Cisco platforms and worked closely with Engineering and vendor organizations on problem analysis and resolution.
- Tested VMS applications on multiple set-top boxes on Cisco and Motorola platforms.
Environment:: Excel, STB, VMS, PowerPoint, HFC, TCP/IP, Networking, MS SQL server, SQL, JIRA.
Confidential, Mt Laurel NJ
Capacity Planning, Engineer 3
Responsibilities:
- Worked with capacity planning development team to automate repeatable processes and improved data processing and reporting efficiencies.
- Collected HSD from capacity planning team developers and database infrastructure.
- Ensured data is complete, accurate and up-to-date.
- Designed, prepared and maintained metrics for capacity planning and reporting.
- Generated capacity reports and dashboards using BI tools like Tableau.
- Provided detailed analysis of observed utilization trends, consumption data, top talkers and investigate anomalies discovered.
- Analyzed capacity process and identified process improvement enhancement.
- Analyzed potential impact of speed tier upgrades and new products on network capacity.
- Wrote SQL queries to view, monitor and validate data in database.
- Developed dashboards to monitor utilization and key metrics across the network.
- Provided clear in-depth analysis and capacity reports to sr. management.
- Worked effectively with all resources engaged in capacity planning across Confidential divisions, regions and markets.
Environment: Tableau, Excel, PowerPoint, DOCSIS, Packetcable, HFC, CMTS, CRAN, TCP/IP, Networking, MS SQL server, SQL, Salesforce, JIRA.
Confidential, Downingtown PA
Sr QA Engineer
Responsibilities:
- Validated software solutions in various Confidential QA/testing environments.
- Analyzed requirements and design specifications to ensure product verification.
- Collaborated with other Engineers to identify, reproduce and document defects, bugs or problems by using project issue tracking tools.
- Utilized clearly defined standards and methods for inspecting, testing and evaluating reliability of Confidential xfinity products and features like Guide, DVR, VOD, Caller ID, ITV, PPV, Parental Control, mDVR, Widgets, SDV on multiple devices like Cisco, SA, Pace, Motorola, Arris, Samsung STBs, Routers, mobile in home networking lab.
- Assisted product engineering team in gathering and analyzing application data.
- Supported trials of new infrastructure designs/services.
Environment: HPALM, MS SQL server, Unix, DAC, DNCS, QAM, FTP, DHCP, EBIF, SQL, Manual testing, TCP/IP, HTTP, XML, STB, RF Coax, Digital Content, SCTE 130, JIRA, Ads Insertion technologies.
Confidential, Radnor PA
Sr QA Engineer
Responsibilities:
- Performed QA and testing of EBIF applications on Motorola and Cisco platforms and worked closely with Product Engineering and vendor organizations on problem analysis and resolution.
- Tested EBIF bound and unbound applications on multiple set-top boxes from Cisco and Motorola.
- Executed QTP scripts to validate iTV applications on Set-top Box and related API firmware.
- Functionally reviewed QTP scripts created by partners.
- Monitored upstream & downstream traffic of iTV application transactions and Network logs on 2WC to and from application servers.
- Analyzed impact and bandwidth analysis of new ITV applications on network.
- Wrote SQL statements to view, monitor and manipulate iTV application data in database.
- Captured and analyzed data as well as ran reports for eTV products.
- Developed reports to display data in organized format, captured specific data and exported to excel spreadsheet.
- Manipulated and converted data to csv, xml, dsv files.
- Troubleshooted and resolved iTV application lab and field issues across multiple platforms.
- Provisioned and maintained Motorola and Cisco devices on digital cable network using Motorola DAC 4000 and Cisco DNCS.
- Carried out pre-test activities such as setting up accounts in AMDOCS and CSG billing systems; perform Legacy/DSG code download, OpenCable code download and Native to Tru2Way migration for digital STBs.
- Created device add & removal entries in Amdocs billing & inventory systems.
- Added and removed Amdocs equipment from billing account.
- Created and confirmed new customer account install in Amdocs billing system.
- Added services to devices on accounts in billing systems.
Environment: STB, SCTE 130, RF Coax, HPQC, QTP, Unix, DAC, DNCS, QAM, FTP, EBIF, SQL, Digital Content, TCP/IP, HTTP, DHCP, XML, SOAPUI, JIRA, Clarity, Ads Insertion technologies.
Confidential, Radnor/ Downingtown PA
Sr QA Engineer
Responsibilities:
- Worked with Product Engineering, Network Engineers, Test engineers, QA team members to develop detail project plans and also communicated project status to Sr. Manager.
- Managed Ensequence iTV Manager authoring tool and customer facing applications, product acceptance within Confidential QA environment.
- Collaborated closely with cross-functional teams, including creative, design, technical, development, operations, QA, release management.
- Maintained project artifacts including weekly status reports, meeting notes, defect resolution, risk mitigation. Recommended solutions to any issue that change the scope of the project or negatively impact its delivery.
- Trained team members regarding use of iTV Manager authoring tool.
- Ensured creation and maintenance of key project deliverables.
- Maintained Schedules, Reviewed and rationalized cross-functional end-to-end schedules and milestones.
- Prepared SSOW, review test plans and test cases using mercury quality center; Ensured business functionality in releases adhere to detailed design documents.
- Attended meetings to review, analyze design documents and defects in applications.
- Participated in Scrum testing activities for AGILE development projects.
- Created test scenarios to certify iTV vendor applications for System, Integration, End-to-End, Regression and Logging testing, using manual and automated test suites.
Environment: HPQC, QTP, Unix, DAC, DNCS, QAM, FTP, EBIF, SQL, Skyvison, TCP/IP, HTTP, XML, SOAPUI, JIRA, Clarity, Ads Insertion technologies.
Confidential, Charlotte NC
QA Engineer
Responsibilities:
- Participated in preparing test plans and wrote test cases using Mercury quality center.
- Ensured business functionality in builds adheres to business requirements and functional specifications.
- Tested I-guide functionalities of Motorola set-top boxes.
- Attended meetings to review and analyze traffic on PMG packages and provider contents.
- Manual testing of customer care application (NAVIC) resident on multiple set-top boxes.
- Tested license expiration date of video contents.
- Monitored logs of provider activities on PMG for all configured digital headends.
- Developed and executed system level test plans, procedures and acceptance criteria for interactive TV and broadcast products.
- Configured Cable headend devices to setup test configuration.
- Provisioned set-top boxes using its Mac address on DNCS.
- Tested Scientific Atlanta or Motorola Digital Broadband Cable TV Systems, HFC networks, RF and data networks, and set-tops cable network.
- Worked with set-tops vendors and Cable MSO to perform system testing and qualification of the products, and once released support product installation and field issues.
- Project Management for the development of broadcast products. Worked with developers, test engineers and team members to develop detail project plans, communicate project status to Sr. Management and team members.
Environment: Manual Testing, Mercury Quality Center, Oracle 10g, Linux Solaris, QTP, DNCS, QAM, PMG, HTML/CSS, Amdocs.
Confidential, Sterling VA
Test Engineer
Responsibilities:
- Participated in preparing test plans and wrote test cases based on business requirements and functional specification using Test Case Management Tool
- Monitored progress against business functionality, requested objectives to ensure that projects meets the specific release criteria.
- Attended meetings to review and analyze traffic on AOL products
- Performed Smoke and Sanity testing on Talkback Client and AOL Mac product
- Performed Manual testing on the Technical module of the Talkback Client
- Performed Negative and Positive testing on UI switches in Talkback manifest file
- Performed Functionality testing on Talkback Client
- Facilitated User Acceptance testing on AOL products
- Conducted System testing and Regression testing on all components after bug fix
- Performed Load testing on diagnostic server using Silk performer
- Carried out Stress testing and Performance testing on all components using Multi-Termite
- Used SQL Plus to connect to Oracle Database
- Involved in back end testing by executing SQL statements
- Ensured data consistency on front-end by executing SQL statements on the Relational Database Management System (RDBS).
- Wrote complex SQL Queries to perform the Back End Testing of the Oracle database using SQL and UNIX shell commands.
- Performed data validation of data submitted by AOL diagnostic tool for Mac products
- Validated all possible Crash options including manual trigger options
- Verified incidents submission mechanisms using transceiver communications with diagnostic servers
- Updated Manifest file using diagnostic servers
- Verified expired data are deleted from diagnostic servers according to business requirements
- Monitored health of all components of Talkback on application level and system level
- Verified reports run on schedule with the release schedule table and ensured pages are updated
- Carried out ad-hoc review of reports to look for problems like spikes or data problems on page itself
- Baselined new builds received from development team into production on scheduled release date.
- Communicated bugs found to development and QA team, and followed up with development team to ensure bug is being fixed.
- Verified and reported bugs using Bug Logging and Tracking Tool.
- Documented all QA process to enable easy process execution by other members of the QA team.
- Worked directly with developers to ensure clear communication on requirements and analyzing defect Environment: Bug Logging and Tracking Tool, Test Case Management, Oracle 10g, Linux, Windows 2003 server, MacOS, Multi-Termite, Perl, Silk Performer, Apache.
Confidential, Akron, OH
Analyst
Responsibilities:
- Participated in preparing plans and methods to analyze data quality in the systems.
- Reviewed documentation, customer data and process models.
- Developed detailed quality parameters to compare data to other systems data
- Performed statistical, financial modeling and data quality analysis on flat files and spreadsheets
- Used SQL queries to carry out single column analysis to detect data format errors in customer address fields
- Verified address fields in database using SQL match-pattern functionality
- Carried out double column analysis to detect if customer names have different customer codes.
- Ensured customer information is not duplicated in system to avoid cost duplication of letter mailings.
- Wrote SQL queries to confirm transactions conform to business rules in business process.
- Reviewed loan applications to ensure conformance to defined business rules
- Utilized CALYX software to transmit financial loan application data to obtain investor underwriting decision.
- Assisted loan officers to select correct loan program in line with policies and regulations. Completed paperwork to initiate appraisals.
- Completed borrower credit release authorization, reviewed loan applications, prequalified borrowers for residential loan utilizing mortgage applications.
- Updated and generated customer mailing lists to be sent follow-up marketing materials.
Environment: SAS, E-Views, SQL, TOAD, Windows 2000, e-business solutions, Excel, MS-Visio, Microsoft Project 2000, MS Office, CALYX.
