Onshore Qa Lead Resume
Houston, TX
SUMMARY
- Software Quality Professional with over 10years experience in various web - based, client-server and distributed multi-tier applications deployed on multiple platforms. Manual and Automated test methodologies (ATLM) with significant experience integrating Quality Center with other tools for project management, developing and applying QA processes and procedures, test planning and design.
- Designing, developing and implementing manual and automated test for Functional, Integration, and compatibility, Cross-Platform, System and Regression testing on Enterprise Wide Solutions.
- Involvement in project request, product documentation, review and work through and Analysis Phases.
- Very strong function script writing for TFS, Quick TestPro and LoadRunner and HP Quality Center
- White and Black Box Testing.
- Designing, developing and implementing manual and automated test for Functional, Installation, Integration, compatibility, Load, Stress, Performance, Cross-Platform, System Integration (SIT), Database Testing, End to End Testing, User Acceptance Testing (UAT) and Regression testing.
- Excellent knowledge in software development life cycles (SDLC) Methodology Waterfall, V Model, Iterative, Agile and Rapid Prototyping, software testing methods and object oriented programming.
- Excellent understanding of Data Warehouse Architecture, Informatica, Star Schema, Data Marts decomposing High-level design documents into ETL specification document
- Extensively used ETL methodology for supporting Data Extraction, transformations, loading to process solution in a corporate-wide-ETL Solution using Oracle Warehouse Builder 9i suite series. Good knowledge of and ORACLE, SQL RDBMS concepts.
- Specialized skills include Software Test Planning and Design, Requirements Management (RM), Software Configuration Management (SCM), Process Improvement, Software Quality Assurance Risk Management
- Creating and defining software testing architecture, which includes the key technical decisions that constrains the overall design and implementation for a project
- Facilitating formal reviews and inspections, and ensuring that they occurred when required and are conducted to a satisfactory standard.
- Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, Business process modeling, Unified Modeling Language (UML),Cost Benefit Analysis, Risk Analysis.
- Establishing standards for test documentation and test progress reporting.
- Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
- Performing HP Quality Center Server Configuration enhancements, and general maintenance, and documenting the maintenance process.
- Experience in Requirement Analysis, JAD sessions, Business and Systems reviews and working sessions to understand the requirements and system design.
- Knowledge of TQM, CMM and Six Sigma 1, 2 & 3 process implementation.
TECHNICAL SKILLS
O/S: Windows 7.X, 8.X, Sun Solaris, Windows XP/Vista, UNIX, Sun Solaris 10g, AIX, Linux, MAC
Mobile: IOS 9+, Android 5+, Windows
Languages/Scripts: VB Scripting, Java, UNIX, Perl, Shell Scripting, Ants, Python, C#, C, C++, HTML, Ruby, HTML, CSS, XML, SQL
Software/Framework: MS-Office, MS-Project, MS- Visio, TOAD, DB Artisan, XML SPY, MS Projects,, Net, ADO.Net, ASP.Net
Database: SQL Server, Oracle, Sybase, MS Access, DB2
Test tools: HP Quality Center 11.5, BugZilla, Clear Quest, LoadRunner, QTP, JIRA, Nunit, Microsoft Visual Studio TFS & Test Manager, Selenium, Version One, Rally, Pivotal Tracker
Servers: Apache Application Server, BEA Web Logic, Server, WebSphere Application server
Middleware: EAI (MQ Series), APCOM, Tibco, IBM Tivoli Privacy
CRM/ERP: SAP, PeopleSoft
OLAP Tools: Business Objects, Business Warehouse (BW), SpotFire, Hyperion, Crystal.
ETL Tools: Informatica Power center 5.x, 6.x, 7.1.1, 8.5 Power mart 5.x, and 6.x
Change Management Tools: IBM Turnover, Clear Case, PVCS Tracker, SVN, Remedy, Intraspect RM
PROFESSIONAL EXPERIENCE
Confidential, Houston, TX
Onshore QA Lead
Responsibilities:
- Lead Onshore and Offshore test teams in Bangalore, India and Houston to support energy business and systems for retail energy which include Shopping Experience, an initiative that involves geo-targeted offers based on customers’ TDSP. No New Paper Conversion an initiative that provided customer the ability use both emails and Userid whilst retiring the calls of emails from the database to CRM on web, mobile web as well as mobile applications. The initiative was also a Mobile enterprise cloud-based front-end platform.
- Coordinated test execution efforts across multiple projects and multiple platforms, IOS, Android, Windows, UNIX and across applications that interface with SAP CCS and CRM.
- Involved in testing across Cross Platforms, Cross browsers and platform independent projects.
- Performed installation, GUI, usability, functionality on Android and IOS devices whilst test on, iPhone, iPad, Samsung, Notes devices of all major IOS and Android version
- Worked with the team to create and execute tests on IOS simulator using Xcode
- Created and executed tests on Android simulator using Android Virtual Devices.
- Developed a clear Test Plan of which test cases were developed for cross-browser (IE, Firefox, Chrome, Safari) and cross-platform (Windows 7, MAC OS X) testing in virtual machine (VMWare) environment
- Worked directly with stakeholders to translate business requirements into sophisticated system and reporting solutions.
- Work with the Project Manager in planning and execution of project activities, including: Project planning, Risk and issue management, Identifying and resolving dependencies, Stakeholder engagement and Support handoff.
- Analyze gathered requirements data, verify requirements and create business requirement specifications.
- Analyzed the business requirements and created several Test Plans to use as a basis for testing the system.
- Utilized JIRA as well as QC for Bug and issue tracking as well for project management and issue tracking.
- Worked with the developers, functional analysts and business users by holding several sessions to analyze what new changes were needed to replace the existing functionality.
- Ensured the testing team performed testing in a timely manner and all changes and defects were documented accordingly.
- Hands on Unit Testing, Functional Testing, Interface Testing, Compatibility testing, Stress and User Acceptance Testing (UAT), Integration Testing, System Testing, GUI Testing and Regression Testing
- Utilized SOAP UI for API testing.
- Interacted with the business users and division supervisors to gather the requirements
Confidential, Houston, TX
Sr. QA Analyst
Responsibilities:
- Involved in the BATTLEred project as a PSL Lead - the Confidential Delivery Framework (HDF) which comprised of HDF Online - an initiative in which a proposal is developed to facilitate the Confidential Sales process and Remote applications for executing and processing Sales Orders in a remote location and sending to SAP for billing.
- Methods designed with Agile, Scrum methodology for monthly iteration.
- Performed System and System Integration testing and participated in User Acceptance Testing.
- Performed Quality Control of the project on its production phase i.e. spot-checks input/output data validation, correctness of calculations, format and layout.
- Performed SAP validation for pricing elements such as Pricing condition types, Date and Document date and configuration data for configurables.
- Initiated Automation strategy using MTM’s Coded UI to create a repeatable and portable test Suite that contains a solid framework for exercising the HDF Online application
- Identified areas of potential impact as well as associated risks in order to maximize the quality of the final product and initiative.
- Identified weaknesses with the current Test Plan strategy Templates and made recommendations on how those templates could be improved.
Confidential, Houston, TX
Lead IT Development Analyst
Responsibilities:
- Involved in the eSense Mobile App project. An initiative to provide customers an app that allows for account management and bill pay and to replace the existing app with a new more robust app on the IOS and Android platforms.
- Served as a focal point for business and management for testing, implementation, and roll-out support to users.
- Participated and analyzed requirements during the requirements analysis phase of the project whilst keeping track of the new requirements from the project and build.
- Reviewed BRD, functional specs, design and implement test strategies/plans for the projects.
- Provided Daily, Weekly, Monthly status reports to stakeholders
- Ensured metrics data is captured for the project and computation of testing metrics
- Hands on testing of the Mobile app on various Smartphone devices and versions - i.e. IPhone and Android.
- Control and manage daily test activities for assigned area or applications.
- Design and ensure overall integrity of the testing strategy.
- Provide timely and relevant communication on test findings to key stakeholders.
- Identify and prepare the appropriate data for testing, and prepare the data for the test cases in partnership with business and technology leads.
Confidential, Sugar Land, TX
Sr. Analyst
Responsibilities:
- Responsible for the transitioning from HP quality Center to Microsoft Team Foundation Server (TFS) and Visual Studio Team System (VSTS) 2010.
- Responsible for HP Quality Center administration including configuration and support
- Key Contributor in providing test and build procedures for electric utility and electricity distribution power systems.
- Responsible for Setting up, configuring and administering Team Foundation server including integration with other tools such as MS Project, SharePoint and MS Excel.
- Administration of version control, Work Items and Security.
- Design, document, implement and maintain configuration management processes including version control, branching and merging and agile process.
- Participate in the improvement, documentation, communication and enforcement of quality assurance processes for software applications.
- Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements
- Identified, researched, defined and documented user problems and automated/manual business processes.
- Identify, recommend and document quality assurance and test practices.
- Research tools, methods and technology trends to support testing objectives.
- Provide training to developers, testers and project managers on Team Foundation Server and Test Manager.
- Actively solicit, analyze, prioritize and negotiate customer requirements from scope definition through detailed system requirements
- Actively involved in gathering and preparation of technical and business documentation for the application in design, which could serve as future reference to the programmers and system developers.
- Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements
- Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
- Collaborated with project manager in tracking and managing project development process following RUP based SDLC methodologies
- Prepared High Level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
Confidential, Houston, TX
Sr QA Analyst
Responsibilities:
- Worked with the project team to define and create overall testing strategy for project Red Bull framework and its entities which is part of the Big Red initiative to support multi brands - including Confidential ’s low cost brand. A customizable website (Pennywise) was developed for users’ to access electronic bills, provide web support to conduct popular transactions such as Bill Pay and leverage existing SAP CCS calls to cost-effectively deliver functionality.
- Developed Test plan varying from high level to low level for the project.
- Managed Requirements Traceability to Test scripts using the test management tool - HP Quality Center. Provided Quality Center Administration support covering customization of fields, user creation & authorization, creation of project databases.
- Defined test process including test activities and deliverables for Project Red bull: Online Account Management, Online Enrollment, E-bill and the Internal Support Tools release. Validated end to end business process flow and related functionality; exercised the various SAP CCS/CRM calls and parallel tested all applications side-by-side to verify expected look/feel on the project identified standard browsers/platforms.
- Tested web sites for functionality, GUI, usability, navigation, browser and OS compatibility
- Coordinated executionof Test Cases for performing Functional, compatibility, Data Reconciliation, Performance, Security & Regression testing.
- Coordinated the creation of test data for system, business process, integration, volume and performance testing.
- Facilitated / Managed Internal and External Defects prioritization - Defect prioritization meetings.
- Business requirement gathering, Creation of Project Test Strategy & Test Plan for the PCI remediation project which was an initiative to create a path outside of Reliant.com to capture Credit Card information and process Credit Card payments via the Web (Reliant.com and Pennywise) and CCS in order to allow the Web to function outside of standard PCI requirements for future projects and to bring CCS handling of Credit Card payments into PCI compliance.
- Co-ordinated with business for requirement understanding, analysis, review, query resolution
- Identification of Tiered Regression pack for prioritized execution.
- Coordinated Daily/Weekly QA Status calls to covers QA issues, dependencies and Risks.
- Preparation of Daily Test Status Reports and Weekly QA Dashboard.
Confidential, Houston, TX
Sr Software Testing Specialist
Responsibilities:
- Responsible for business and functional requirements gathering, system Integration Testing, test plan creation, test case documentation, test environment set, test data identification, test execution in quality center, defect Management in Jira integrated with HP Quality Center, user acceptance coordination for Confidential field operations solution called Bagnet. This is proprietary web-based software on an Oracle database used in the field on a daily basis to view scheduled orders, create driver routes, and mark bags as collected in the system.
- Responsible for End to End system and Integration testing, Use case development, test case execution, functional testing, Regression testing both Manual and Automated testing with QTP, Performance testing of OCS application which is an on-board computing system used by Confidential for dispatching, routing, scheduling, and reporting. OCS is comprised of an interface between the dispatcher and the driver. Two different types of clients form the OCSD system: OCSD client: the dispatcher uses The OCSD client. This client is written c#.NET using WPF. The OCSD client interfaces with the application server by calling different web services.
- Business requirement gathering, Test environment management, Defect Management, test case development test plan creation, database validation, Use case development
- Functional and regression testing on Route Assistant solution, which is a client that is used by the driver, mounted on the truck. This is written in C#.net. It communicates with the application server by calling web service that resides on the application server. OBU uses an aircard to communicate with the application server.
- On occasion, responsible for identifying and documenting business rules and creating detailed Use Cases
- Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the project plans accordingly and conducted project related presentations.
- Consult with Business Managers on new outbound initiatives and gather business requirements
Confidential, Houston, TX
Lead Software Testing Specialist
Responsibilities:
- Responsible for the core activities of the test effort which includes identifying and defining the required tests, monitoring detailed testing progress and results in each test cycle, evaluating the overall quality experienced as a result of testing activities for BI iReports
- Coordinated functional, system, Integration, performance, referential data integrity and regression testing, Prepared Test cases based on Technical Specification document.
- Collecting the Test data from the Business Team
- Involved In Analyzing the ER-Diagrams.
- Identified the Test Environment for Database Testing.
- Understand the database development for this project.
- Analyzed the database design.
- Preparation of database Test cases according to assigned module
- Reviewing the database Test cases.
- Perform the Database Testing when writing the Complex Queries from SQL.
- Executed the Stored procedure when passing the valid/Invalid Parameters.
- Involved in Data migration and Data distribution testing.
- Execute the database Test cases according to release.
- Analyze the results and log the defects in bug tracking tool
- Retested resolved bugs on each build release
- Communicate with Developers and DBA
- Perform the Database Testing when writing the Complex Queries from SQL.
Confidential, Ann Harbor, MI
Sr. Software Testing Specialist
Responsibilities:
- Performing functional, system, Integration, performance and regression testing on EndurEnergy trading, risk management and transaction-processing system allows users to see more, do more, and make more. Endur links front, middle, and back offices with functionality that was designed to cover the entire energy transaction life cycle
- Responsible for the core activities of the test effort which includes identifying and defining the required tests, monitoring detailed testing progress and results in each test cycle, evaluating the overall quality experienced as a result of testing activities. And identifying the appropriate techniques, tools and guidelines to implement the required tests.
- Modifying ENDUR AVS scripts to create Intraday Tasks and workflows
- Identified and established the testing environment (Physical and logical environments, test data, test tools) that needs to be in place.
- Provided industry and functional advice regarding design, configuration, implementation, testing, deployment and support of trading and risk systems for the commodity markets
- Provide guidance and mentoring to one or more Business Analysts across one or more functional areas of commodity systems
- Created test cases to validate advanced business computational logic focused around prompt forward trade (i.e. P&L impact), for trades booked in ENDUR V9.This includes impact from Conversion from SYBASE (ENDUR 5.3) to ORACLE(ENDUR 9)
- Performed Comparison between ENDUR V9 and ENDUR 5.3 to validate impact to current functions.
- Validated the one Time Historical Data Migration historical load for EOM, EOQEOY Gas deal valuations, which include Currency Conversion, UOM conversion, Interest Rates, Volatility, Exposure Results, MtM Results, Impact Results for Gas.
- Created test cases to validate data base views for snapshot of end of Month data for (Deal Characteristic views, Exposure Results views, Mark to Market Results views, Forward Prices views, Interest Rate views, Volatility views, Impact Calculation views and Trading Limits views.). Exposure Results - Testing on Cash Month (current month) and Forward Month for Financial / Physical gas and power data, Forward Prices - for Cash Month, Forward Month for Financial and Physical Gas and Power data., Impact Calculation - for Prompt Month Forward., For the following impact types (Price, Interest, FX, COMM-STOR, ENGY SWAP) and Effective Prices
- Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
- Traceability Matrix was created between Requirements and Test Cases using Test Director.
- Involved in testing Business Objects reports and tested various classes, filters and conditions in the Universes.
- Tested Business Object reports for different scenarios like drill down, slice and dice etc for correct data Interact with the release engineering team to find the build status.
- Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using test Director
- Creating and executing SQL queries on an ORACLE database to validate and test data using TOAD.
- Decomposed ETL specifications from High-level documents.
Confidential, Houston, TX
Sr Systems Analyst / QA Team Lead
Responsibilities:
- Involved in several projects including Online banking (OLB) and Online Account Opening (OAO), COAF, E-Alert, Smartswitch, OLB Maintenance release as well as in house projects such as the Web enabled DSAR and Cleartrack projects.
- Involved in the Bank Enhanced Integrated Alerts Rollout. The goal of this solution was to provide enhanced alerting features for consumer and small business banking customers. The alerts were configured for delivery to several device types including e-mail, phone, fax, and wireless devices (Any PDA device, such as Palm, Compaq, Blackberry and Visor). Alerts were also configurable by account type and frequency.
- Responsible for core activities of the testing effort, which includes Identifying and defining the required tests, monitoring detailed testing progress and results in each test, monitoring detailed testing progress and results in each test cycle for Confidential .Helped develop and implement specific goals and practices to increase the organization's level of process maturity per the Capability Maturity Model Integration (CMMI) frame
- Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using HP Quality Center.
- Creating and executing SQL queries on an ORACLE database to validate and test data using TOAD.
- Responsible for conducting User Requirements sessions and documenting minutes, requirements, Issues and other project documents.
- Review Clients Operating model and process flows to understand current process and document future process, interfaces, Forms.
- Performed End User Training
- Created and maintained strategic partnership between Business needs and Technology delivery in an agile development environment.
- Develop test scripts, test conditions, input test data, and expected results for one or more test plans, including component, assembly, product, performance, user acceptance and technical architecture tests Online Banking
- Regression Testing for System (OLB), Confidential Auto Finance (COAF), Retail Bank Registered Online Account (RBROA),
- Managing incident handling (complex severity 1&2 incidents) and resolution of escalated complex multi-discipline technical application incidents end-to-end specially relating to the infrastructure, availability and performance as per the agreed business defined SLA
Confidential, Houston, TX
Sr Systems Analyst / QA Team Lead
Responsibilities:
- Test Lead Responsible for testing the implementation of critical material management, financials, shipping, export and transportation application.
- Ensured the accuracy of large Oracle database integrity by using the Data Driven methodology.
- Implemented the use of Rational Unified Process (RUP) methodology to manage test deliverables, System Test Planning, monitoring, coordinating and test execution.
- Communicated with appropriate development resources for functionality, design clarification, defect report and their status.
- Reviewed and revise the system test strategy using requirement management tool to improve the efficiency of testing with a view to reducing time and effort but maintaining quality of deliverables.
- Documentation and specification of testing deliverables. Used Mercury Interactive Test Director 8.0 for test management, execution of multiple scripts, analyzed results and Tracked defects.
- Responsible for core activities of the testing effort which includes Identifying and defining the required tests, monitoring detailed testing progress and results in each test, monitoring detailed testing progress and results in each test cycle.
- Performed Data Validation of Data Mapping and all transformation constraints and derivations, intermediate files and tables, and all output specifications in Informatica
- Performed system testing, System Integration (SIT), Functional and Regression testing on application.
- Involved in full QA life cycle: Unit Testing, Integration Testing, Regression, Smoke Testing, Build Acceptance, and User Acceptance Testing (UAT)
- Performed Backend Testing, Database Integrity testing Using SQL Queries. transformation and load programs (ETL Data Mapping) for a Data Warehouse, data models and ensure Developed and execute ETL test plans that ensure the quality of data transformations, Data extraction, referential integrity.
- Performed Data Validation of and all transformation constraints and derivations, intermediate files and tables, and all output specifications in Informatica
- Responsible for defining all aspects of requirements for the respective modules, including but not limited to; functionality, reporting, interfaces, customizations and configuration.
- Prepared test plans, test strategies, test assets and storage.
- Wrote software requirement based on system/business/data requirement.
- Creation and execution of test plans and test suits; ad hoc testing; bug documentation and regression.
- Facilitated brainstorming sessions with developers to find ways to solve quality issues and prevent problems.
- Prioritize and executed functional/Integration/System/Regression and performance test cases.
- Responsible for technical spec reviews, working with business representatives, developing test cases, test execution of all the above-mentioned applications - front-end, middleware, backend, reviewing error logs, writing incident reports, and tracking these to conclusion.
- Utilized Test Director for test planning and management and WinRunner for developing functional test scripts.
- Updated existing test cases in Test Director.
- Created a Naming Convention and Implemented a Change Management Process for the entire SQ team to follow.
- Performed maintenance on the Legacy AS400 Systems for batch loading accuracy and data back up.
- Executed test in an N-Tier and Object Oriented design environment.
- Tracked defects using Test Director.
- Converted Business Requirement, use cases and user requirement to test cases
- Generated customized cross project analysis reports configurations and layouts using Test Director. Utilized Test Director Automatic Traceability Notification to trace changes to the testing process entities.
- Generated cross project report using business objects.
- Conducted interview sessions with SME to clarify requirements
- Developed automated test scripts using Quick Test Pro and converted existing WinRunner Scripts to QTP based on test plan.
- Tested the Incremental Upgrades of software to minimize business risks.
- Certified existing core application functionalities is undisturbed especially in the absence of any documentation.
- Defined a regression test suite to certify that modified application meets existing application functionality.
- Defined test cases and executed testing to validate the changes incorporated in the software.
- Developed a multi-tiered test Strategy for a complex application rewrite to ensure effective testing of the software
- Identifying module requirements for Unit testing, system requirement for Integration testing and functional requirement and documenting how testing will be achieved
- Responsible for defining the test requirements, Analysis, Scenario design, Test Case Development, Test Execution, Test Closure and Test Process Analysis.
Confidential, Decatur, GA
Sr Systems Analyst / QA Team Lead
Responsibilities:
- Created the automated testing infrastructure ( a collection of reusable classes, methods, generic reusable base scripts and high level scripts, Initialization scripts, constants, functions stored in complied modules and test cases) using WinRunner with Visual basis Add-in and ActiveX control Add-in Established test lab procedures and organized lab to run in a batch mode for maximum usefulness as a shared resource
- Brought about uniformality in the usage of terms and terminologies for higher level of understanding and communication.
- Working Knowledge of Product Lifecycle Management (PLM)
- Defined the testing process for clear identification of testing stages with well-defined entry and exit criteria (e.g., requirements gathering, test strategizing, test case development, test case execution and result analysis.
- Tested the Critical business objectives documented in the software requirements specification.
- Established a Requirement Traceability matrix between requirement and test cases in Test Director.
- Evaluated Test completion Criteria, time, cost, Quality and Business Critical Objectives
- Created Defect logs and verified closed defects reports.
- Responsible for developing and testing components, in accordance with the projects adopted standards, for integration into larger subsystems.
- Created Excel data tables to drive the data driven aspect of the automation
- Perform Integration/Regression Testing to validate that MQ messaging connections are built between different components of the Enterprise architectures application and to validate that the new set of rules for how users access each application and creates new demands for system functionality, scalability and interoperability are in line with Software Requirement Specification.
- Generated customized cross project analysis reports configurations and layouts using Test Director. Utilized Test Director Automatic Traceability Notification to trace changes to the testing process entities.
- Generated cross project report using business objects.
- Conducted interview sessions with SME to clarify requirements
- Developed automated test scripts using Quick Test Pro and converted existing WinRunner Scripts to QTP based on test plan.
- Tested the Incremental Upgrades of software to minimize business risks.
- Certified existing core application functionalities are undisturbed especially in the absence of any documentation.
- Defined a regression test suite to certify that modified application meets existing application functionality.
- Defined test cases and executed testing to validate the changes incorporated in the software.
- Developed a multi-tiered test Strategy for a complex application rewrite to ensure effective testing of the software