SUMMARY:

• An analytical QA Specialist / Lead with over 18 years experience providing practical software solutions to complex issues.
• Software quality assurance - Inspections; risk management, requirements reviews, software metrics, quality and test plans, test designs and cases; Change control and configuration management. Test methodology and test tools.
• Over 8 years of professional work experience in various aspects of the software quality assurance by using manual and using automated testing tools for various web based n-tier architecture systems, client server and windows application (.NET, Java and Mainframe environment).
• Competent in adapting to new technologies, processes and techniques quickly and efficiently
• Collaborate with business areas, Subject Matter Experts (SMEs), solution vendor, business analysts and solution architects to facilitate QA test plan/test case development from business requirements, system use cases, functional and non-functional requirements, process workflow and product documentation.
• Quick response to project Request for Quotations (RFQs)
• Execute all the test cases. Develop and execute procedures to ensure compliance with the Processing Integrity Policy, and other aspects of the overall System Processing and Information Security Policies
• Develop non-functional test plan/test cases including but not limited to performance, stress, capacity, endurance, accessibility, data conversion and security.
• Review, validate and finalize QA acceptance criteria.
• Work with development, solution vendor and infrastructure team to establish QA environments.
• Coordinate with project manager the scheduling and execution of QA Testing.
• Develops, maintains and tracks QA test execution and critical milestones, dependencies and deliverables.
• Effectively communicate issues to QA manager, track issues to resolution and drive QA Testing to completion.
• Very well experienced in Test Strategyand infrastructure for new releases of business applications.
• Good financial business knowledge at Derivatives, Risk, Counterparty Risk Trading, FX, Capital, Mutual Fund, Interest Rate, Commission, GIC, AML and Portfolio Management.
• Structured Rates Trading and Pricing systems and flow
• With extensive knowledge of creating trace ability matrix
• Experience in building dashboard, metrics, executive presentation
• Effectively communicate issues to QA manager, track issues to resolution and drive QA Testing to completion.
• Coordinate and participate in user acceptance testing initiatives with Client Services Staff
• Conduct daily/weekly checkpoint meetings with all participants during QA execution.
• Establish and administer metrics to monitor and report on quality of products and software being developed and deployed into production.
• Well-developed organizational, project management and design skills
• Good management skills in Credit risk, Market risk, Liquidity risk, Operational risk
• Performed Quality Assurance (QA) activities for a web application going through the Software Development Life Cycle (SDLC) / Software Testing Life Cycle (STLC), for all kinds of testing methodologies.
• Strong Software Configuration Management and Quality Management skill.

TECHNICAL SKILLS:

Languages: Java, Perl, Java Script, VB script .Net, Visual Basic 6, Cobol, SQL/ PL SQLPython, CICS, PL/I, C,C++, SAS, REXX, Easytrieve, XML Database/ RDMS SQL Server, Oracle 9i/10g, SQL/ PL SQL, MS Access 97/2000/XP, Database Modeling and Design

Operating Systems: Mainframe, UNIX, Windows 2000/NT//9x/XP, DOS, MS DOS, MVS, CPMMiddleware & Web Server WebSphere Application Server 6.1, WebSphere Portal Server 6.1, BEA WebLogic, Windows NT Server 4.0, IIS web server, IBM HTTP Server

QA Skill Set: Test Automation Tool, Unit Testing, Regression Testing, Black/White Box Testing, Load Testing, Performance Testing, System Testing, Integration Testing and User Acceptance Testing

QA& bug reporting Tools: IBM Rational Function Tester, Quick Test Pro, Mercury Quality Center, Rational Performance Tester, Load Runner, Clear Case, Clear Quest, CVS

Scheduling Tools: CAD, CA7, BatchRunner, Windows batch files

Methodologies: Agile, Scum, RUP, Waterfall, SOA, UML, Web Services

PROFESSIONAL EXPERIENCE:

QA Lead / Function Test Expert

Confidential

Environment: Oracle, Zephyr, JIRA, Confluence, HP ALM, Python, Unix

Responsibilities:

• Design, construct and execute test cases and plans for assigned testing task.
• Work with Waterfall /Agile testing frameworks and different types of testing
• Identify, document and escalate defects effectively and in timely manner
• Testing Client/Server and web based applications
• Identify risks & escalating issues in a timely manner & providing clear & concise reports to manager
• Query large data sets using SQL or big data technologies
• Define test data and environment requirements and ability to provide test data inputs
• Provide support to technology peers and the business. Join forces to identify solutions.
• Read and understand BRD, Use Cases and/or Test Scenarios in order to write test cases

QA Lead

Confidential

Environment: Hadoop, Hive, HP ALM, Surge Query, Python, Unix, Winscp, PuTTY. Tanlend

Responsibilities:

• Worked as Test Lead in Agile Test Methodology environment
• As part of Agile scrum team, attended Refinement calls to understand the requirements and prioritize the tasks and add the tasks to the sprint from Backlogs
• As part of Agile scrum team, attended Planning calls Involved in preparing baseline Test estimations for the Sprint tasks using Agile based Planning Poker methodology
• Responsible for creating complete test plans, test cases, test data and do Requirement Traceability Matrix in HP ALM ensuring accurate coverage of business requirements
• Responsible to provide the QA status in the Daily standup calls to Scrum master
• Responsible to validate the data by accessing the Cloudera impala database where the daily feeds are processed through HIVE and stored in the HDFS
• Performed data validation testing writing complex SQL queries in Cloudera Impala
• Analyzed large data sets by running Hive queries around 15 billion records
• Validated Analytics UI application and verify the data populated as per the requirements
• Responsible to review the test cases and do the Test Execution in HP ALM
• If any deviations observed when compared to requirements, responsible to raise the defects based on severity and priority in JIRA tool and assign to responsible team and track the defects until its closure
• Responsible to prepare the Sprint reports and present in the Demo call to the Product owners and stakeholders to get the Go/No Go call
• Responsible to do the Regression testing before the cutover of UAT/Production and Sanity testing after it deployed in the corresponding environments
• Automate the regression test cases using Selenium tool
• As part of Agile scrum team, attended Retrospective calls to discuss what went right and wrong in the completed sprint
• Acts as Scrum Master whenever required

Sr. QA Tester

Confidential

Environment: Management Studio, HP ALM, SQL, Mainframe, Python, Unix, JAVA

Responsibilities:

• Utilize testing methodologies and strategies to develop the test plan for systems and workflow changes. This includes defining business functionality criteria, test case development, expected results, test phase planning, and cycle definition and exit criteria.
• Review test plans, test cases and test scripts with team members to ensure sufficient test coverage.
• Generate and maintain test documentation (test plan, test scenarios/cases, Test data and defects).
• Coordinate and execute tests for testing phases (System Integration and Regression), ensuring project adherence to testing standards, methodologies and tool usage.
• Verify business requirements through system workflow and business rule testing.
• Identify, analyze, track and manage detected system errors.
• Ensure end-users involvement throughout the system testing life cycle.
• Maintain up-to-date business, system and testing knowledge across all Foresters products, processes and systems, through research of business and systems documentation, liaising with peers, IT staff, business experts and formal courses and seminars.
• Ability to review and understand documentation in order to validate the business requirements.
• Report test status and findings to QA Lead and/or project team.
• Adhere to Foresters security standards and procedures during solution implementation and support.
• Report security incidents as per the Foresters Information Security Incident Management Standard.

QA Manager

Confidential

Environment: Teradata, Hadoop, Big Data, Hive, HP ALM, SQL, Mainframe, Datastage, PuTTY

Responsibilities:

• Leveraged budgeting expertise to efficiently manage test bed build out and maintenance. Adopted virtualization as a needed process that reduced equipment costs
• Led process improvement projects to reduce test times, integrate new tools and manage key tasks
• Worked cross-functionally with other managers to streamline operations (Agile Integration Team)
• Evaluated project requirements in both Agile, Waterfall and hybrid environments
• Planned and coordinated resources needed to implement new test strategies (Agile Scrum, Sanity Suite Regression, etc.), resulting in development of best practice models

Data Warehouse / ETL /Big Data / Sr. QA Tester

Confidential

Environment: Netezza, Hadoop, Hive, HP ALM, Aginity, SQL, Datastage, PuTTY

Responsibilities:

• Written Test Cases for ETL to compare Source and Target database systems.
• Executed the developed Test Cases and Test Plans. Responsible for creating Test Strategy for the Data Warehouse.
• Reported the Bugs/Defects using Quality Center 11 defect management tool. Responsible for communicating Defect Status Reports to business in project meetings.
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Involved in Unit testing and integration testing. Performed Functional testing, System testing, Regression testing and Back end testing.
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications. Involved in documentation in order to maintain and run scripts for future enhancements.

Sr. Quality Assurance Analyst / ETL / Big Data Tester

Confidential

Environment: Hadoop, HP ALM, Hive, SQL, Toad, PuTTY, Jira, Confluence, Datastage, VPN

Responsibilities:

• Work closely with Architect, Business Analysts and ETL Developers to validate ETL scripts
• Test Complex ETL Mappings based on BSTM to load data from TSZ to Snapshot to Semantic
• Validate the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the business rules with in the transformation
• Develop and execute test cases, run HQL files using both hive under Putty (Unix-like platform) and Hive editor under Hue (Hadoop UI)
• Perform data validation of duplicate data is not loaded, NULL value fields and record count match
• Perform SIT testing during ETL running and cover end-to-end scenarios for data completeness, data accuracy, functional scenarios & integration workflows
• Prepare testing data for error handling and default tracking scenarios
• Join daily conference meetings to provide status updates to business stakeholders
• Test critical bug fixes and coordinated with developers in release of bug fixes
• Perform regression testing after BSTM update or defects was fixed
• Conducted packages testing and schema testing.
• Verified data completeness and transformation rules.
• Tested referential relations and integrities of data.
• Wrote technical reports of located data errors with recommended solutions.
• Processed data for testing and analytics after mitigation of data errors.

Sr. Quality Assurance Analyst

Confidential

Environment: Windows 7, Oracle 11g, HP ALM, Quick Test Pro v11.0

Responsibilities:

• Understanding existing OnSIS Application functionality and specifications
• Develop the scripts for the assure Application and Data Quality of the OnSIS functionality
• Implement the automation of new and existing testing scripts using Quick Test Pro v11.0 and VB scripting
• Perform functional, regression and performance testing based on the test scripts developed·
• Plan, create and implement test data beds for testing·
• Involved Integration and Regression testing based on the system requirements
• Perform knowledge transfer to the Ministry staff

Sr. Quality Assurance Analyst / ETL / Data Warehouse Tester

Confidential

Environment: Windows 7, Unix, Sybase, IBM Rational Clear Quest, Clear Case, PuTTY

Responsibilities:

• Meet with representatives from the project team to gather information regarding business and technical requirements
• Use Clear Case to manage the version control and application life management. (ALM)
• Execute the test case for function / Non-function, regression and ASSET Portfolio Management testing
• Conduct an analysis of systems and business processes
• Advanced skill in Data centric testing, Data Mapping, verification and validation (V&V) and Backend Data / Database testing by using complex SQL query.
• Review detailed project documentation such as project charter and project plans (e.g. scope, schedules, risk, quality, etc.);
• Execute the testing for workflow management.
• Develop QA strategies and test plans describing how to test the business processes and expected functional experience
• Review business and technical requirements documentation to create test cases that support the functional and technical requirements
• Executing Tests cases and reporting results formally in test results documentation
• Log defects and issues in Team Foundation Server
• Complete an activities report on a weekly basis
• Maintain application test progress spreadsheet on a weekly basis
• Assist with DEV/UAT/SIT testing as required
• Keep the Project Lead/Supervisor-QA and/or Project Manager informed of ongoing activities and any unusual circumstances;
• Ensure all required project documentation is prepared according to Confidential standards and appropriate approvals are obtained in a timely manner;
• Ensure the project follows the Confidential ITS Project Management Methodology;
• Perform related duties as assigned.
• Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
• Worked in multiple responsibilities such as reviewing of ETL architecture, ETL design, and analysis and ETL technical specifications.
• Tested ETL applications in relational databases and flat files and involved in the report generation of BI systems
• Excellent Functional knowledge on various domains like Insurance, Payroll management, Finance/Banking, ETL/Database management,

Sr. Quality Assurance Analyst

Confidential

Environment: Windows 7, Mainframe, HP QC, XML, .NET, Web services and IMS Mainframe/IMS Connect, IBM Book of record, CAD, CA7, DB2, BatchRunner, Windows batch files

Responsibilities:

• Develop, publish and execute Quality Control oversight plans.
• Work closely together with offshore team and monitor the defect from offshore team
• Good remote communication skill and guild offshore tem to understand the business requirements and function.
• Write the matrix and the status for offshore team and report to the manager
• Provide solutions and suggestions to the offshore team
• Execute the test case for function / Non-function, regression testing.
• Strong business, technical and interpersonal skills developed over the years of learning and professional experience. (AML, KYC, Trade, Capital Market and Portfolio Management etc)
• Good Coordination experience with other teams.
• Execute DEV/BAT/PAT and workflow management testing as required. (Both on Functional front-end testing and IBM Book of record Back-end testing)
• Advanced skill in Data centric testing, verification and validation (V&V) and Backend Data / Database testing by using complex SQL query.
• Good skill at Text Data File interface Testing (e.g. XML, HTML, Flat Files) by creating SQL query and other file testing tools and methodology
• Execute Security testing, including Application Vulnerability Testing
• Good knowledge at the Risk of Credit and GAAP (Generally Accepted Accounting Principles)
• Good experience and knowledge of modeling Use Cases, Flowcharts, Gantt chart and other related diagrams using MS Visio.
• Participate in identifying WCO requirements for projects by participating in the review of contractual documentation
• Maintain a high degree of awareness on WCO issues
• Prepare generic and project specific WCO plans and procedures.
• Interface with various departments, including other branch offices, contractors and customer representatives.
• Review, improve, document and implement WCO procedures and policies on a continuous basis.
• Establish and maintain software baselines and ensure that all artifacts are properly placed
• Create and maintain projects within WCO tools
• Diligent and can work in any environment with minimal help.
• Examine all testing related deliverables for Code Release and determine if the artifacts are complete and correct according to Client and Cluster standards and guidelines
• Interface with vendors to report bugs, and request enhancements

Sr. Quality Assurance Analyst

Confidential

Environment: Windows 7, Mainframe, DB2, JCL, Jira. SQL 2008, CAD, CA7, BatchRunner, Windows batch files

Responsibilities:

• Execute tasks to ensure that customer deliverable comply to specifications
• Execute the test case for function / Non-function, regression testing.
• Execute data conversion testing by using SAS.
• Execute the testing for Credit Card Application
• Good understand the Risk of Credit, Credit Card Score and Credit Report.
• Maintain customer files in an orderly and accurate manner - track changes with names, addresses, terms and credit cards.
• Document and report problems and issues found during testing
• Prepare test cases and scripts, develops plans for systems changes
• Ensures systems changes meet specifications and do not impact systems functionality
• Develops documentation for problem logs, user guides and
• Devises to current procedures and performs workflow analysis
• And recommends quality improvements
• Internal Customer / User Support
• Captures, Diagnoses and resolves user issues and systems problems
• Manages problem recognition, research, isolation issues
• Documents resolution steps, logical procedures and resolves customer / user requirements and problems

Sr. Quality Assurance Analyst

Confidential

Environment: Win XP, 2008 SQL Server, SAS, Bug Tracker, Load Runner, .NET, Cognos

Responsibilities:

• Participate in System, Functional and User Acceptance Testing for multiple applications on varying platforms
• Execute the test case for function / Non-function, regression testing.
• Effectively analyse and decompose business, functional and non-functional requirements to extract test requirements
• Prepare test strategy and test plans for workflow management
• Participate in testing for multiple applications on varying platforms
• Provide accurate test estimates to the IQS Project Manager and Quality Management Lead
• Write and execute effective test scenarios, cases and scripts to thoroughly test the applications
• Oversee the development and execution of effective test scenarios, cases and scripts to thoroughly test the applications
• Log and track defects to closure
• Maintain test documentation according to defined processes
• Identify and communicate any schedule and quality issues and risks to the IQS Stage II Project Manager and Quality Management Lead
• Liase with the development and business teams to clarify requirements
• Help create and interpret use cases
• Produce documentation according to OPS standards

Sr. Quality Assurance Analyst

Confidential

Environment: Win XP, WebSphere Portal 6.1, WebSphere Application Server 6.1, Clear Quest, Rational Function Tester, Oracle 10g, J2EE, Java, Perl, and VMWare

Responsibilities:

• Used IBM Rational Functional Tester tool 8.1 for function and regression testing
• Used IBM Rational Performance Tester 8.1 for load and stress testing
• Used IBM Quality Manager 3.0 for managing all test scripts and test case documents
• Deployed Websphere Applications to the SIT/UAT and Production.
• Concentrated and involved more in System Integration testing.
• Involved in testing the data integration, system integration and business workflow between each function.
• Executed Backend Data / Database testing in Oracle using SQL.
• Reported defects in timely manner and logged the same into defect tracking tool (Clear Quest).
• Verified the Fixed CRs and tracked the same to closure.
• Coordinated with the developers and other individuals involved in the project to resolve the identified issues.
• Ensure that all the test cases are written and updated in Clear Quest.
• Reviewed tests specifications, cases and performed manual testing.
• Designed and developed test cases for putting the application on Manual testing.
• Developed QA management process including:
• Testing strategies;
• QA methodologies;
• Planning, developing and executing test plans and test cases;
• Defect management and tracking;
• Performed SOA testing and web service-based applications;
• Performed building, scripting, configuring, and executing test sequences using automated testing tools;
• Experienced with automated test tools at the build/code level;
• Good understanding of business requirements tracking tools (Clear Quest) and the Software Development Life Cycle (SDLC) / Software Testing Life Cycle (STLC)
• Good experience with Testing in Frenchversion
• Worked in an application development and system integration environment within a deadline-driven atmosphere;
• Good documentation skills and superb organizational and logic skills;
• Excellent analytical, problem solving and decision-making skills; spoken and written communication skills; interpersonal and negotiation skills;
• A collaborative team player with a track record for meeting deadlines.

Sr. Quality Assurance Analyst /Team Lead

Confidential

Environment: Win XP, SAS, Java, HP QC, Web Sphere, C sharp, Crystal Reports 10, Oracle 9i, SQL Server, XML Mercury Quality Center, QTP, Viewfinder, Load Runner

Responsibilities:

• Analyzed business requirements and developed the Detail Test Plan and the Test Strategy and infrastructure for new releases
• Prepared test data and coordinated the test data from different source.
• Created test data strategy and set up test environment.
• Execute the test case for function / Non-function, regression testing.
• Developed test plans, test design specifications, and test cases for business applications. (FX, Trading, Capital, Mutual Fund, Interest Rate, Commission)
• Created test cases based on business and functional requirements and wrote test cases.
• Developed test strategies in analyzing performance risks and identifying root cause for production issues;
• Participated in Test Case walkthroughs and in inspection meetings.
• Prepared test cases for Unit, System, Integration and Regression testing based on the system requirements.
• Performed applications testing for all aspects of verification, including functional, structural, regression, performance, stress, load and system testing. Designed, developed and implement complex test automation both at the functional and system level.
• Executed test cases and verified the actual results with the expected results in Mercury Quality Center.
• Wrote modification request (MR) for the defects in the application and liaised as the point-of-contact during the defect tracking process
• Identified areas and methods to improve testing efficiency, expand coverage and increase product reliability.
• Performed multiple sets of data testing, verification and validation (V&V) and Backend Data / Database testing by using complex SQL query.
• Written test automation scripts, Unix Shell script and SQL query to extracted test data to meet the requirements.
• Maintained requirements, test cases, test data, test results and defects using tools (SQL query, Mercury Quality Center, QTP, Viewfinder, Crystal Report, Clear Quest).
• Optimized QTP scripts for Regression testing of the application with various data sources and data types.
• As a team leader, estimated the complex of test job, assigned the schedule to the team, checked the status and monitored the test result.
• Performed SOA and web service-based applications testing.
• Understood the FIX Protocol and used it in trading activity.

Tester / Programmer

Confidential

Environment: Unix Shell script, HP QC, COBOL, SQL, SAS, PL/I, JCL, VSAM and REXX

Responsibilities:

• Developed quality assurance standards and processes
• Contributed to the defect resolution process with the development teams and worked with developers and business analysts to solve the problems.
• Coordinated test efforts including writing test reports, status updating, issues escalating.
• Categorized defects into different severity levels, logging defects in Clear Quest
• Developed software quality plans, test design specifications, and test cases for business applications by using Unix Shell script, SQL and COBOL.
• Developed and Migrated the system from Mainframe to Unix platform
• Maintained system according to the business requirements
• Ran test cases to find defects in Internet-based business applications with Rational Function Tester automation tool
• Participated in risk management to help determine best use of development and testing resources
• Worked with customers to develop user acceptance tests for Internet-based business applications
• Inspected QA Test Case design and execution methodologies
• Carried out test cases using Rational tools and prepared test result reports

Systems Designer / Quality Assurance

Confidential

Environment: COBOL, SQL, Lotus Notes, SAS, TSO/MVS, ISPF, DB2, JCL, Endeavor, CICS, CAD, CA7

Responsibilities:

• Define test strategy and guidelines for the teams to sure quality controls, assurance procedures and results met project objectives
• Designed test plans and test cases to ensure through and complete test process by SQL query, FileAid and XpEditer.
• Conducted manual and automated blanket tests that identified and eliminated static and dynamic logic errors and discrepancies
• Executed multi-level tests for over 200 cases bases, including unit testing, integration testing, system testing, performance testing, regression testing and user acceptance testing
• Analyzed test results which improved system performance and Reconciliation
• Provided technical consultation and onsite assistance to teams to ensure consistent development strategy and testing standard
• Developed an integrated agency system that incorporated over 100 databases, which meet primary object to provide detailed financial reports to multi-departmental consultants and managers
• Maintained system and provided on-call support that improved user accessibility
• Enabled end users to create a Lotus Notes Mail view and manage email or files.
• Extracted data from Lotus Notes emails and stored into file system.

Programmer

Confidential

Environment: COBOL, VB Script, Oracle 8.1.6 RDBMS, Java Script, HTML, Windows 2000, IBM-390

Responsibilities:

• Designed Import and Export Advanced System that was an application and database program that assisted organization in making solid business decisions
• Involved the development and maintenance during the entire life circle of the project
• Developed an understanding of foreign trade requirements and needs through extensive research and liaison with trade specialist to ensure that the final product met project objectives
• Defined data flow, divided the whole system into subsystem and modules, defined functions of different modules, include reporting subsystem, account balance analysis, day-end and year-end subsystems, and interest counting to ensure logical sequencing that eliminated errors and improved future additions or changes
• Designed data dictionary and data structure to improve user ability to utilize the program and conduct analysis programs
• Wrote code and performed testing including unit and system test ensuring quality of software
• Met client new requirements through conducting system modifications and adding latest functions based on continual improvement and functions

Programmer

Confidential

Environment: COBOL, PL/I, RPG, DB2, C/C++, VB Script, EASY, JCL, Windows 98, IBM-390

Responsibilities:

• Designed code for the Referral Commission Calculation and Administration System that calculated the referral commission, rebates and bonus on the purchases of stock utilizing a unique technology that significantly reduced the time to give customer responses
• Program allowed approved customers to view their commission details and genealogy structure online

Trainee

Confidential, Los Angeles, CA

Environment: UNIX, Oracle and Windows NT/9x

Responsibilities:

• Successfully completed one-month Oracle, obtained Oracle and Unix

Developer and Trainee

Confidential

Environment: COBOL, Preview, C, and UNIX

Responsibilities:

• Involved in specific to in a RS6000 machine in order to maintain and troubleshoot issues
• Developed the Management of Inventory System as a practice project