PROFESSIONAL SUMMARY:

• Senior QA/ Test Analyst specialized in testing Client - Server, and Telecom, Financial, ERP and security services applications. Experience in working in software development lifecycle including requirement gap analysis, design development and execution of manual and automation scripts, risk analysis, software metrics development, change control and configuration management, managing the onsite and offshore test resources and improving the efficiency of quality assurance process.
• Over 11 years of professional experience in Information Technology with extensive experience in performing Manual and Automated Testing
• Experience in working on waterfall and Agile (SCRUM) development methodologies
• Experience in working with large volumes of data and developing complex SQL queries
• Proficient in automation testing in HP Tools: Win Runner, QTP, Load Runner and ALM Quality center.
• Working knowledge of programming languages, C, VBScript, SQL, PLSQL, Python scripting
• Experienced in testing LAWSON Financial ERP applications and custom interfaces
• Experienced in testing UNIX based application and expertise in using WINSCP,FTP tools
• Experience in Insurance industry accounting system, including Billing & Invoicing, Accounts Receivable, Accounts Payable, and General Ledge
• Experience in working with complex data and testing data migration
• Expertize in working with data testing
• Excellent leadership skills in leading QA teams, both offshore and onsite teams
• Experience in requirements, Functional Design Docs. & use cases analysis.
• Analytical thinker and a great team player with ability to develop, manage and complete multiple projects/tasks simultaneously within specified timeframe
• Strong knowledge in SDLC, QA Methodologies - CMM, Agile and rational unified process (RUP)
• Ability to accomplish projects and releases before the production dates.
• Strong problem solving skills, extremely reliable, quick learner and able to work independently as well as a team member.

TECHNICAL SKILLS:

Testing Tools: QTP 11.0, ALM Quality Center 11.0, Selenium, Clear quest, Load Runner, Jira

Databases: Oracle, Microsoft SQL Server 2008, Oracle, DB2, TOAD

Languages: C, SQL, PL/SQL, UNIX, HTML, XML, .Net, Java, VBScript, C, C++, SOAP, web services

Software: WebSphere, Tomcat, IIS, Team foundation server, Web Logic, Kanban

Development Methodologies: Waterfall and Agile (scrum), Rational Unified Process (RUP)

Client Tools: EPIC (Insurance Agency Mgmt. System), Lawson/Infor Financials, SAP BI, ERP

WORK EXPERIENCE:

Confidential

Senior. Test Analyst

• HCA is the nation's leading provider of healthcare services company comprised of locally managed facilities that includes about 165 hospitals and 115 freestanding surgery centers in 20 states. Currently working on testing Lawson HR/Payroll customized interfaces and process flow paths specifically relating HR systems. Also testing Lawson interface changes as requested by Life Point hospital as they are currently using the Lawson interface forms for their business needs.
• Reviewed and analyzed business and technical requirement documents for interfaces and process flows
• Worked primarily on Lawson HR/Payroll systems and testing the customized interfaces to match the business requirements
• Extensively worked on execution of complex process flow paths relating to HR systems
• Used the business components module in ALM Quality center to create componentized test sets in test plan module of quality center.
• Tested and verified the process flow paths in both PFI(process flow administrator) and IPA (Rich client tools)
• Developed complex SQL queries to validate data on the Lawson UI interfaces
• Good Understanding of Lawson forms and their functionality
• Created test cases using proper parameters and iterations with appropriate test steps in test plan module
• Created reusable test sets using iterations and parameters for executing process flows
• Tested various customized interfaces for Life point hospital as per their business needs
• Involved in testing the XML design studio changes on the selected Infor Lawson forms
• Used Teradata DB2 to write SQL queries to verify the data loads in QA area and compare the data against the custom Lawson forms to verify if there are any discrepancies
• Created System and functional test cases for Lawson interfaces in HP ALM Quality center and executed the test scripts from the test lab
• Prepared Lawson training materials and mentored junior testers
• Responsible for Developing Test reports and execution metrics out of HP ALM quality center to provide the status and counts to the management
• Participated in QA Agile scrum meetings to provide Testing status to the team
• Created and tested business process flows using the Lawson admin tool for GL,PO,AP and HR payroll custom Lawson forms
• Logged and managed defects in quality center and provided defect status reports to the team
• Used WINSCP (FTP) tool to place and move the reports generated through job scheduler and print manager function on custom Lawson interfaces forms to verify the detailed view of the report and analyze and compare the results
• Used LID (Lawson interface desktop) utility to track the GEAC interfaces progress in development environment
• Participated in requirements review meetings for Lawson interfaces with business and product analysts and the business users

Environment: DB2 SQL, HP ALM Quality center 11.0, XML Design Studio, Microsoft Visio, UNIX, WINSCP, FTP, Mainframe, Lawson ERP, Agile Scrum Methodology

Confidential

QA Lead

• Confidential is a leading global insurance broker, developing and delivering professional insurance, reinsurance, risk management, financial and human resource consulting and actuarial services to corporations, public entities and institutions around the world. Willis is replacing its existing legacy systems with EPIC, an Agency Management System developed by Applied Systems. QA team is responsible for functional and integration testing of the product which includes Front End, Accounting and Reporting modules.
• Gathered and reviewed program requirement documents (PRD’s) for EPIC application
• Tested the integration applications such as bank feeds and LINK that coordinates with EPIC to process the nightly batch jobs to process the payments and receipts to carriers and vendors
• Developed and executed test cases for functional and integration testing in HP ALM Quality center
• Organized and conducted SCRUM (Agile) daily meetings to discuss the overall QA status and testing effort
• Identified critical show stopper defects in accounting that could have huge impact on NAC’s business process. (National accounting center)
• Involved in company’s software development meeting as part of SDLC process
• Report End of Sprint metrics for all Agile-testing tasks for Scrum Team
• Participated in Triage meetings with business users to discuss the progress of the QC defects identified in EPIC relating to accounting module software development meeting
• Participation in Daily Scrum project meetings, Sprint Demo's, Sprint Planning sessions with vendor application support team and development teams
• Wrote SQL queries and performed data validation to perform back end testing using Microsoft SQL server management studio
• Critical QA resource in configuring the EPIC system, business scenarios and accounting.
• Main point of contact for business users, QA team, Development team and external vendor with regards to testing the EPIC application
• Analyzed Test Plans and Test Cases/User Stories based on Requirements and General Design
• Trained new resources in accounting and developed training material
• Created client and broker policies and Transactions in EPIC and tested the application workflow and functionality
• Responsible for documentation of QA Sprint processes, Test summaries, and QA environments, tools.
• Worked as Functional area defect coordinator to work with business and product strategy (accounting) stream Project managers to identify, categorize and escalate defects found within streams
• Generated daily testing status reports in Quality Center and effectively communicated them to Product Manager, Product Owner, Project Manager, Development team and Business Users.

Environment: ALM Quality center 11.0, Microsoft SQL Server 2008, .NET, Web Logic, EPIC - Agency Management System, SQL Server, Agile Scrum Methodology

Confidential

Senior. QA Analyst

• HCA is the nation's leading provider of healthcare services company comprised of locally managed facilities that includes about 165 hospitals and 115 freestanding surgery centers in 20 states .Working on GEAC replacement project which is replacing GEAC (Millennium) Accounting System with Infor Lawson Financial System. GEAC Accounting system is used exclusively by HCA Corporate Accounting which is an early ERP type mainframe system. Worked on testing the custom General Ledger, Accounts Payable, and Purchasing and HR modules that are integrated within the product suite and have interfaces in and out of other HCA systems.
• Reviewed and analyzed business and technical requirement documents for GEAC interfaces and process flows
• Tested the custom GL,PO,AP and HR payroll custom Lawson forms interfaces based on business requirements
• Worked in the Agile/Scrum development environment with frequently changing requirements and features set.
• Involved in testing the XML design studio changes on the selected infor Lawson forms
• Used Teradata DB2 to write SQL queries to verify the data loads in QA area and compare the data against the custom Lawson form to see if there are any discrepancies
• Created System and functional test cases for Lawson interfaces in HP ALM Quality center and executed the test scripts from the test lab
• Participated in daily scrum meetings where all the testers will address any blockers blocking testing and discuss the status of assigned tasks.
• Responsible for Developing Test reports and execution metrics out of HP ALM quality center to provide the status and counts to the management
• Participated in QA Agile scrum meetings to provide Testing status to the team
• Involved in Change request Meetings with business owners, product analysts and developers to coordinate
• Created and tested business process flows using the Lawson admin tool for GL,PO,AP and HR payroll custom Lawson forms
• Logged and managed defects in quality center and provided defect status reports to the team
• Used WINSCP (FTP) tool to place and move the reports generated through job scheduler and print manager function on custom Lawson interfaces forms to verify the detailed view of the report and analyze and compare the results
• Used LID (Lawson interface desktop) utility to track the GEAC interfaces progress in development environment
• Participated in requirements review meetings for Lawson interfaces with business and product analysts and the business users

Environment: DB2 SQL, HP ALM Quality center 11.0, XML Design Studio, Microsoft Visio, UNIX, WINSCP, FTP, Mainframe, Lawson ERP, Agile Scrum Methodology

Confidential

QA Analyst

• Confidential is a leading global insurance broker, developing and delivering professional insurance, reinsurance, risk management, financial and human resource consulting and actuarial services to corporations, public entities and institutions around the world. Willis is replacing its existing legacy systems with EPIC, an Agency Management System developed by Applied Systems. QA team is responsible for functional and integration testing of the product which includes Front End, Accounting and Reporting modules.
• Analyzed Business Requirements Specifications and program requirement documents (PRD’s)
• Performed system and regression testing for pilot phase of EPIC Application
• Created Requirements traceability matrix in the Quality Center to map the test sets against the requirements
• Tested the payable contracts setup functionality for insurance carriers and brokers
• Created client and broker policies and Transactions in EPIC and tested the application workflow and functionality
• Logged defects against the application to ensure the system is working according to the business requirements
• Developed and executed test scripts for functional and integration testing out of quality center
• Worked as Functional area defect coordinator to work with business and product strategy (accounting) stream Project managers to identify, categorize and escalate defects found within streams
• Coordinated User acceptance testing. Document, report and communicate UAT defects to senior management and external vendors.
• Generated reports from Quality Center to set the target and progress of the Project to project managers as test lead of the accounting module
• Involved in Functional and Regression testing for the Insurance Accounting Module of EPIC
• Completed status reports for testing and defect handling throughout the project
• Participated in pre beta testing phase along with accounting business team to make sure the system is stable and has the expected functionality
• Performed data validation on the data migrated from previous database systems to EPIC
• Involved in the Business Scenario Analysis and Test Case writing for the Insurance Accounting System

Environment: ALM Quality center 11.0, SQL Developer, .NET, Web Logic, EPIC - Agency Management System, SQL Server, Agile Scrum Methodology

Confidential

Sr. Test Analyst

• Horizon Commissions deals in calculating commissions for Confidential &T company representatives and dealer’s network on monthly basis. The application gets the data from point of sales system across the nation and process the data to pay individual representatives and agent’s commission as per the compensation plan and contract setups defined in the application. Coordinated activities to get the data from the upstream testing environment, Load the data into the Horizon Commission applications, validate the commission payouts as per the compensation plans and contract setups, and ensure that the data is reported accurately in the reports.
• Analyzed System requirements specifications (SRS) and High Level Design documents to understand the functionality of the application.
• Lead and mentored a team of five QA analysts and supported system testing
• Performed data loads running batch jobs using UNIX Shell scripts for the local Agents and National retailers channel in Horizon application.
• Experience assessing testing processes, creating, implementing testing strategies and SQA strategies using Agile-testing methodology
• Logged defects in quality center and provided full scale metrics and test execution status reports to the management
• Worked on test Case Design/Test Case Execution based on Requirement Specs with 100% requirement traceability.
• Participated in Sprint Planning meetings and identified the strategic features of the user stories and review the current sprint user stories relating to the project
• Executed Web Services using Eclipse Java IDE and SOAP UI.
• Wrote SQL Queries using SQL developer to verify that the data has been loaded for each local agent and national retailers in QC database environment.
• Performed File Transfers between UNIX servers using FTP (File Transfer Protocol) tool to load the data in the appropriate environments.
• Supported and maintained existing production Web Services, providing support for performance issues and launches of enhancements
• Performed detailed testing in Horizon application to verify that the Sales Commissions are paid as per the contract setups for each Agent and National retailers.
• Participated in walkthroughs and design review meetings with Development to review High level design Documents to understand the functionality.

Environment: QTP 10.0, Quality Center9.2, VB.Net, C#, HTML, VB Script, XML, SQL Server, web services, JAVA, Agile Scrum

Confidential

Test Engineer

• Confidential ( Penn DOT ) oversees transportation issues in the Commonwealth of Pennsylvania In addition; other modes of transportation are supervised or supported by Penn DOT. . centric is structured in 5 ‘threads’ or disciplines in order to deliver solutions to Penn DOT: Business Architecture, Change Management, Technical Architecture, Application Construction and Data Conversion. These five threads will combine over 20 existing Penn DOT information systems into one integrated web-enabled application that provides access to citizens, business partners, and agencies that do business with Confidential .
• Interacted with Business Analysts for gathering business information regarding Entity Administration, Inventory and Financial Functional Requirements.
• Interacted with Business Service Analysts and Data Architects for gathering Business data models and its core Data Requirements.
• Performed Data validation using Oracle TOAD.
• Developed Test Plan and Test case scenarios using Quality center.
• Logged Defects and change requests using Clear Quest.
• Developed Test reports and execution metrics out of quality center to provide the status and counts to the management.
• Participated in running the database scripts to make sure that all the records have been exploded from the data table in to the application.
• Performed ETL Testing on TOPICS and .centric Database using informatica 8.0
• Involved in testing of each phase of the application using Quick Test Pro, Load Runner and Quality Center.
• Created and Executed Manual Test Cases to test the flash objects and other objects which are not supported by automated testing tools in the application.
• Developed functional automated test scripts, and enhanced the scripts using parameterization and synchronization to support Data Driven Testing for many business processes using Quick Test Pro.
• Used Quick Test Pro for testing the compatibility of the application with different platforms.

Environment: QTP 9.5, TOAD, Rational Clear quest, Java Script, JBoss, Informatica Power Center 8.0.1, HP Quality Center 9.2

Confidential

Test Analyst

• PRISM is a web based portal that provides a central access point to multiple data sets within a highly customizable interface including standardization of the user interface thereby reducing the time required to learn the new systems and procedures. I was involved in Integrated System Testing (IST) consisting of the ‘macro’ end of the test scale which involves testing the Prism application from a Prism workflow perspective.
• Analyzed Business Requirements Specifications and System requirements specifications documents.
• Analyzed Design specification documents (DSP’s) written by development team and developed test sets based on them for testing.
• Conducted integrated system testing (IST) of the application involving combination of various modules.
• Resolved data issues in the backend of the application in order to ensure smooth running of testing.
• Involved in running data migration scripts for each test run to set up the test environment.
• Involved in Developing the Automation Framework.
• Reviewed Unit test cases with development to detect defects in early stages of the application to ensure smooth running of testing activities.
• Attended daily test status calls to provide the business owners about the testing progress.
• Developed Test plans and Test cases using HP Quality center.
• Extensively used Rational Clear Quest for handling tasks, Change requests and Defects.
• Extensively used TOAD, for backend Testing.
• Developed functional automated test scripts, and enhanced the scripts using parameterization and synchronization to support Data Driven Testing for many business processes using Quick Test Pro.
• Used various check points in automated VB test scripts to test the functionality of the application.

Environment: QTP 9.2, TOAD, Clear Quest. Quality center 9.2, cold fusion MX 7, XML, JBOSS.

Confidential

Quality Assurance Analyst

• Confidential Loyalty Platform is an end-to-end reward management program for varying lines of credit or debit Accounts and other facets of business. The components include the Data and the TLP Engine. The Data In the TLP Engine comprises of the master Account File, Cross reference structures, Credit Card Transactions, TS1/TS2 Feeds, Statement and Reward Feeds, Accounts processing Engine, SKU processing Engine, Point Feed Processing Engine and Transaction Processing Engine. The TLP Engine looks Confidential the programs, accounts and transactions and performs the calculation. TLP determines whether the accounts and associated transactions qualify and what points are awarded based on the applicable conditions.
• Analyzed System requirements specification (SRS) and Functional requirement Documents to understand the functionality of the application.
• Created and tested the master account file, Cross reference, TS1/TS2 feeds and transaction files for the input load of the TLP Engine.
• Tested the Point Feed processing Engine and Transaction Processing Engine.
• Verified programs, accounts and transactions and perform the calculations to determine the points awarded.
• Wrote and executed test cases in rational test manager
• Logged defects and communicated changes through rational clear quest
• Tested the statement file, Check and Draft Files, Monthly points File, Rewards Summary file and Reports.
• Tested the service request and response files of the web services.
• Tested the multiple connectivity options to support the incoming/outgoing file transfers, real time calls and reporting.
• Involved in testing the Redemption Back Office which includes the Account and Point Adjustment, Customer care, Redemption, Fulfillment, Accounting and Reporting.
• Created mappings with PL/SQL Procedures/Functions to build business rules to load data involved in functional, regression and configuration testing.
• Created the framework and foundation of the testing workflow using Test Manager.
• Performed the Back end testing of the application with Oracle as database.

Environment: UNIX, JBOSS, JavaScript, SQL, DB2, HTML, XML Teradata, Clear Quest, Test Manager

Confidential

Sr.QA Analyst

• Role-Based Access Control (RBAC) for Finium is a method to provide security-control access to Finium features, not only across customers, but also within customer organizations. RBAC is enforced Confidential its highest level, through the concept of logical separation of data. Each customer organization has its own customer database and users from one customer organization never have access to data from another customer organization’s database. RBAC is enforced through the concept of administrative domains.
• Analyzed the Business Requirement Documents and Use Case Documents.
• Wrote high level test plan documents
• Executed test cases from test lab in test director
• Involved in code review process with development team
• Analyzed the gaps between business requirement documents and functional design documents
• Expertise in performing security testing
• Extensively used Descriptive programming in QTP to create test components
• Developed tests scripts for testing the application using QTP
• Identifying use cases, analyzing Use Cases, document Use Cases in the form of written narratives and closely interacted with developers
• Participating in reviews of completed requirements to ensure that the requirements were built correctly
• Logged all the defects using Star team as defect tracking and change request management tool

Environment: QTP 9.0, Test Director HTML, Star team, Java, JBoss Application Server, SQL Server, Star Team