Senior QA Analyst

Name: Liju Varghese

Contact No.: 832-***-****(M)

Email Address: *********@*****.***

Current Location: Houston,TX

Visa: US Citizen

Relocate: No

Availability: Immediately

PROFESSIONAL SUMMARY

•9 yrs of experience as a Lead QA Analyst having worked in reputed organizations like Campus Management,Lender Processing Service, PDS Americas, GE Energy, Cardinal Health, HP, Sapient, Sprint, Digital Blue

•Requirements gathering, Business Case Development, Business Framework Analysis, Business Process Re-engineering using UML.

•Project Planning, Project Scheduling, Project Tracking, Risk and Scope Change Management, And Project Reporting

•Proficient in functional, negative, regression, system integration (SIT), acceptance (UAT), load/performance, SAP BW, SAP MM,Excellent knowledge and working experience in with test planning, test execution and test results analyses

•Query Analysis and Report Generation using Business Explorer, Query Designer, SAP BW, SAP MM,SAP CCS Web Application Designer, SAP Business Objects and Yotta .

•Worked on RDBMS like Oracle 9i, SQL Server, Microsoft Access, SQL,PL-SQL

•Tested applications on Java, Javascript, VB Script, C, C++,ASP.Net,C#

•Tools/Technologies evaluations, prototyping and recommendations.

•Excellent interpersonal, written and communication skills.

TRAINING/CERTIFICATION:

•BW310 Business Information (BW) Data Warehousing

•BW305 Business Information Warehouse (BW) – Reporting & Analysis

•BW330 SAP BW Modeling, BW350 SAP BW Extraction.

•Formal training in Agile Architecture and Design Patterns.

.

EDUCATION:

•M.S. (Computer Science) – 2005

•B.S. (Computer Science)-2002

•B.S. (Chemistry)-2004

•ISTQB Certification Foundation Level

Campus Management Corp Oct 2014- Oct 2017

Senior QA Analyst-QA Lead

Responsibilities:

•Generated test scenarios, test cases and test data. Executed tests, created problem reports

•Gather Requirement from Department of Education for different Student Loans and Life Cycle and Student Loan Payments

•Worked on Selenium Test Scripts to Automate test cases

•Worked on TFS and Test Manager for execution of Test Scripts

•Tested integration and validation of data from various sources to targets using SQL queries and ETL process.

•Worked on SOAP UI tools,Coded UI and WCF for Web Services testing

•Writing SQL/PL-SQL queries and manipulating large amounts of data

•Work with Business Analyst and Development team to do Gap Analysis for testing and gathering requirements

•Automation testing in Selenium using Java for Web based application

•Assure that credit limits are monitored and recommend appropriate action if limits are exceeded through .Net Applications

•Conducted installation and cross-platform testing of Internet Configuration Wizard application

•Demonstrated experience reviewing requirements and design to determine appropriate tests including interfaces to legacy systems, Wrote test Plans and Test Scripts for different application for SAS/SIS Package

•Compile, organize, and review data for use by analysts and management

•Writing SQL/PL-SQL queries and manipulating large amounts of data

•Data mapping, detailed data analysis and metadata analysis, creating and maintaining detailed mapping documents

•Prepare Test Plans and Project Plan for executing test cases

•Bug Logging in TFS and Quality Centre

PDS Americas, Houston, TX, USA March 2014 – Sep 2014

Client: Shell Well Vantage Project

Senior QA Analyst

Responsibilities:

•Developed of testing strategies for Shell application.

•Generated test scenarios, test cases, Test Plans and test data. Executed tests, created problem reports

•Worked on SIRTAF Architecture and Remote services architecture.

•Worked on Shell Well Plan, WellBore and Rig Assignments Projects

•Knowledge of Compass, WellPlan, CasingSeat, Drillworks, and StressCheck a plus.

•Worked on PI Explorer Systems,OPC Tags and OPC Matrikon Services

•Tested on SAP BW/BI Business Objects and for Incident and Release Management Reporting

•Develop end-to-end test plans for systems, integrated and user acceptance testing based on project standards and testing strategy

•Implemented Algorithm Hardware & Software performance Testing for drilling

•Independently set up Systems and daily build for Releases and execution of Test Cases

•Set up Scrum Process and Meeting for daily process updates

•Analyzed business requirements, functional specifications and mock ups of financial to provide functional decomposition

•Worked in Web Service like RDS and SIRTAF Services

•Collect and collate appropriate data for use in databases and conduct related research

•Generate reports using IT / database systems and assist in their analysis

•Assist in development and upgrading of database systems and analytical techniques

•Implemented Test Cases and Test Plans using Quality Centre

Environment: Test Manager, TFS, Windows, SQLServer 2008,.NET,SAP BW

PROJECT DETAILS:

Lender Processing Service, TX, USA Dec 2011 – Feb 2014

Clients: Citibank,Bank of America,JP Morgan Chase

Senior QA Analyst- QA Lead

Responsibilities:

•Development of Rules testing strategies for different Banks including Freddie Mac and Fannae Mac

•Generated test scenarios, test cases and test data. Executed tests, created problem reports

•Worked on TFS and Test Management for execution of Test Scripts

•Tested integration and validation of data from various sources to targets using SQL queries and ETL process.

•Worked on SOAP UI tools and WCF for Web Services testing

•Writing SQL/PL-SQL queries and manipulating large amounts of data

•Work with Business Analyst and Development team to do Gap Analysis for testing and gathering requirements

•Assure that credit limits are monitored and recommend appropriate action if limits are exceeded through .Net Applications

•Conducted installation and cross-platform testing of Internet Configuration Wizard application

•Demonstrated experience reviewing requirements and design to determine appropriate tests including interfaces to legacy systems, Wrote test Plans and Test Scripts for different application for SAS/SIS Package

•Compile, organize, and review data for use by analysts and management

•Writing SQL/PL-SQL queries and manipulating large amounts of data

•Data mapping, detailed data analysis and metadata analysis, creating and maintaining detailed mapping documents

•Prepare Test Plans and Project Plan for executing test cases

•Bug Logging in TFS and Quality Centre

•Worked on MISMO XML for testing rules

•Automation Scripting done using .NET Framework on VB Script

Environment: SAP BW,Quality Center, Test Director, Windows, SQLServer,.NET,TFS

Cardinal Health Houston, TX, USA Jan 2011 – Nov 2011

QA Analyst

Responsibilities:

•Developed of testing strategies for Internet application.

•Generated test scenarios, test cases and test data. Executed tests, created problem reports

•Worked on Windows Server Management

•Different notebooks, Printers, Servers and software applications tested on Vista Version.

•Tested integration and validation of data from various sources to targets using SQL queries and ETL process. .

•Assure that credit limits are monitored and recommend appropriate action if limits are exceeded through .Net Applications

•Automated Scripts in Win Runner and used Quality Centre as the defect tracking tool

•Testing done in SAP BW and SAP CCS

•Conducted installation and cross-platform testing of Internet Configuration Wizard application

•Demonstrated experience reviewing requirements and design to determine appropriate tests including interfaces to legacy systems, Wrote test Plans and Test Scripts for different application for SAS/SIS Package

•Compile, organize, and review data for use by analysts and management

•Writing SQL/PL-SQL queries and manipulating large amounts of data

•Data mapping, detailed data analysis and metadata analysis, creating and maintaining detailed mapping documents

•Worked on SOAP UI tools and WCF for Web Services testing

•Prepare special reports and exhibits with directions on Crystal reports

•Reporting done in SAP BW,MM,SAP R/3 and Bex Analyser

•May perform a variety of administrative duties for the unit.

•Bug Logging in TFS and Quality Centre

•Wrote Test plans and procedures for HP Monitor compatibility display testing

•Implemented website providing real time status on results to HP and US and overseas vendors

Environment: SAP BW,Quality Center, Test Director, Windows, SQLServer,.NET,TFS

GE Energy, Houston, TX, USA March 2010 – Nov 2010

QA Analyst

Responsibilities:

•Developed of testing strategies for Internet application.

•Generated test scenarios, test cases,Test Plans and test data. Executed tests, created problem reports

•Worked on Progression and Regression Scripts.

•Implemented Algorithm Hardware & Software performance Testing for drilling.

•Worked on Oracle Transport Product Architecture and implement technical solutions for Oracle’s Transport Product

•Worked on SAP Rate and SAP BW Testing module

•Worked on Finance Billing Applications like GL,AP,AR and Cash Management modules.

•Worked on Data Migration for SQL Server 2005/2008 and Informatica

•Performed ETL integration testing using Informatica PowerCenter 8, data Integrity/validation, and backend testing and queried multiple relational databases (Oracle 9i, 10g and SQL Server 2005) using TOAD, SQL Enterprise Manager.

•Worked on Energy Trading for different Vendors and Materials

•Develop end-to-end test plans for systems, integrated and user acceptance testing based on project standards and testing strategy

•Reimaging Vision workstations

•Created test cases necessary to validate all ETL and data-handling processes

•Analyzed business requirements, functional specifications and mock ups of financial to provide functional decomposition

•Automated Scripts in Win Runner and used Quality Centre as the defect tracking tool

•Collect and collate appropriate data for use in databases and conduct related research

•Generate reports using IT / database systems and assist in their analysis

•Assist in development and upgrading of database systems and analytical techniques

•Implemented Test Cases and Test Plans using Quality Centre

Environment: Oracle Applications,J2EE,Quality Center, Test Director, Windows, SQLServer,.NET

HP, Houston,TX, USA Jan 2009 – August 2009

QA Analyst

Responsibilities:

•Manual testing with HP network cards and devices on proliant servers and drivers

•Working with development teams investigating and correcting software bugs and deficiencies based on the testing results.

•Performing various types of testing, such as functional, regression, user acceptance, negative and installation testing

•Worked on SAP Rate and SAP BW Testing module

•Worked on Data Migration for SQL Server 2005/2008,SAP BW and Informatica

•Involved in modeling their product hierarchies and sales organization, analyzing trends in the sales history, modeling the affect of promotions and integrating i2's Demand Planner with their operational systems.

•Developed and updated Test plans, Test Matrixes, Test Scenarios, and Test Cases for all company products

•Conducted variance management by analyzing and verifying test results, providing status and progress reports, using TestDirector 7.0i

•Conducted system functionality testing: developed and executed test cases, produced problem reports, suggestions, system test logs, and test incidents reports

•Expertise with Reporting tools like SAP Business Objects and Yotta

•Writing SQL queries and manipulating large amounts of data

•Data mapping, detailed data analysis and metadata analysis, creating and maintaining detailed mapping documents

•Data Analytics and Reporting

•Implementing entire software development life cycle (SDLC) including analysis, design, development and testing of software applications

•Responsible for quality and timeliness of operations

•Responsible for Onboarding of data from Users and analyzing from different servers and database.

•Excellent interaction with cross-functional teams

•Implemented Test Cases and Test Plans using Quality Centre

Environment: SAP Business Objects, Yotta,Quality Center, Test Director, Windows, Unix, SQLServer

Modis, Houston, TX, USA May 2008 – September 2008

Client:Disney world

QA Analyst

Responsibilities:

•Developed of testing strategies for Internet application.

•Generated test scenarios, test cases and test data. Executed tests, created problem reports

•Worked on Oracle Transport Product Architecture and implement technical solutions for Oracle’s Transport Product Worked on Windows Server Management

•Tested Bluetooth, Cellular/mobile broadband using WALN 802.11

•Different notebooks, Printers, Servers and software applications tested on Vista Version

•Manual testing with HP network cards and devices on proliant servers and drivers.

•Review of ETL design documentation mappings/workflows and testing of ETL mappings and data loading using Informatica PowerCenter 8

•Assure that credit limits are monitored and recommend appropriate action if limits are exceeded through .Net Applications

•Review, verify and code company credit card invoices in a timely manner

•Process credit applications for all locations

•Process credit card payments through automated systems

•Reimaging Vision workstations

•Created test cases necessary to validate all ETL and data-handling processes

•Analyzed business requirements, functional specifications and mock ups of financial to provide functional decomposition

•Automated Scripts in Win Runner and used Quality Centre as the defect tracking tool

•Testing done in SAP BW and SAP TAO

•Conducted installation and cross-platform testing of Internet Configuration Wizard application

•Demonstrated experience reviewing requirements and design to determine appropriate tests including interfaces to legacy systems, Wrote test Plans and Test Scripts for different application in Peoplesoft

•Compile, organize, and review data for use by analysts and management

•Writing SQL/PL-SQL queries and manipulating large amounts of data

•Data mapping, detailed data analysis and metadata analysis, creating and maintaining detailed mapping documents

•Designed and organized a functional test lab for testing any type of software or hardware on a wide range of operating systems and computers for Digital blue Testing for different cameras and camcorders of Disney Products

•Utilize and maintain spreadsheet, mainframe, and other technical applications used in the actuarial ratemaking process

Environment: Quality Center, Test Director, Win Runner, Windows, Unix, SQLServer, J2EE,Excel,MS Access

Sapient,New Delhi,India January 2007 – July 2007

Clients:Sprint

QA Analyst

Responsibilities:

•Documentation/Use Case Documentation/Function Documentation

•Developed Test Plan/Scenarios and create Test Cases from the Requirement

•Write business requirements, programming specifications, and training material

•Writing SQL/PL-SQL queries and manipulating large amounts of data

•Worked on Oracle Transport Product Architecture and implement technical solutions for Oracle’s Transport Product

•Worked on WLAN, Bluetooth, Cellular/mobile broadband

•Worked on Supplier Relationship Management is i2’s suite of product that focuses on design, sourcing, and procurement capabilities

•Manual testing with HP network cards and devices on proliant servers and drivers

•Worked on Finance Billing Applications like GL,AP,AR and Cash Management modules.

•Worked on Data Migration for SQL Server 2005/2008 and Informatica

Environment: Quality Center, Test Director, Win Runner, Windows, Unix, SQLServer, J2EE,Excel,Access

Sapient,New Delhi,India September 2006 – December 2007

Clients:Western Union Money Transfer

QA Analyst

Responsibilities:

•Created test cases necessary to validate all ETL and data-handling processes

•Korn shell scripting for job execution

•Used scheduling tool (Tidal) in informatica to execute jobs

•Different notebooks, Printers, Servers and software applications tested on Vista Version

•Reimaging Vision workstations

•Data mapping, detailed data analysis and metadata analysis, creating and maintaining detailed mapping documents

•Data Analytics and Reporting

•Scripting done In Perl and Unix

•Work with programmers to make sure requirements are understood

•Prepare special reports and exhibits with directions on Crystal reports

•Reporting done in SAP BW and Bex Analyser

•Strong understanding of database structures, theories, principles and practices

•Designing, installing, configuring and supporting database servers

•Hands on troubleshooting and database tuning experience

•Execute Test cases to cover both positive and negative functionality as well as back

Environment: Quality Center, Test Director, Win Runner, Windows, Unix, SQLServer, J2EE,Excel,Access

References will be available on request.

Contact this candidate