Senior Qa Analyst Resume
SUMMARY:
- Sr. Information Technology Quality Engineer with over 15 years of lead/hands - on experience in Software QA testing, QA lead, business/technical analysis, data analysis and project coordination.
- Experience includes research, analysis, testing of Data Warehouses/Marts, testing of SOA based highly distributed JAVA and .NET based web services interfacing with a mix of Windows, UNIX, Mainframe, DB2, ORACLE, MQ and IBM Workflow models. Familiar with all the phases of SDLC (Software Development Life Cycle) and has played a pivotal role from conception to completion of a software application Expertise in requirement gathering, software evaluation, assessment, determining test strategy, developing test plans, determining processes and procedures, writing scripts, testing, benchmarking, (stress and volume) and bug tracking.
- Worked independently and as a proven team leader in various environments such as Web, Client-Server, Mainframe, UNIX and Windows platforms Expertise includes functional testing, integrated testing, system testing, compatibility testing, database validation testing as well as benchmarking application modules, database interfaces and systems to ensure quality assurance.
- Proficient in querying Oracle and DB2 databases using SQL tools such as TOAD, SQL Developer, SQL Server and WinSQL on various projects involving, financial transactions download, GL reconciliation, credit card functionality, stock exchange decimalization effort, financial brokerage and IRA applications, loan applications, web-printing applications and other types of applications
TECHNICAL SKILLS:
WinRunner 6.0: 7.5, TestDirector 6.0-8.0, Quality Center 9.0, Segue QA Partner/Silk Test, Rational Test Studio 2002, QTP, ClearCase, ClearQuest, MS Visual SourceSafe, Microsoft Visual Test
Methodology: CMM, ISO 9000, MS Visual Source Safe, Rational Unified Process, IBM Testing Methodology.
Languages: TSL, C, C++, Java, Visual Basic 5.0 and 6.0, PowerBuilder, SQL, COBOL, 4 Test, HTML
Databases: DB2, MS SQL Server, MS Access, Oracle 7.03/8i client.
Application Servers: BEA WebLogic 6.0, Siebel 7(web based), Apache Tomcat, Oracle Applications 11i Modules: Accounts Payable, Accounts, Receivable, Purchase, Project Accounting
Applications: MS Project, Microsoft Excel, Web Services Web Services Application Integration, PVCS
PROFESSIONAL EXPERIENCE:
Confidential
Senior QA Analyst
Responsibilities:
- Responsible for creating complex Back-end SQL scripts for Guthy-Renker in-house database (FH - Fulfillment Hub) for all new orders created via Order Motion OMX web interface.
- Running various batch jobs which propagate UI orders into various back-end systems following all orders from order creation to shipment and to eventually fulfillment of those orders.
- Getting ownership of new JIRA stories, reading requirements on them and following up with the business and development team with any questions in order to thoroughly test them out before they get deployed to the production environment.
- Run and analyze SSRS reports dat fetch data from corporate data warehouse theirby work closely with the business users if the reports satisfy their needs. Identify data quality issues and recommend data fix at the WH as well as data source level.
- Attend daily scrum meetings in a very fast-paced agile based development environment with Business, Database, development, testing teams led by the scrum master. Keep them abreast of the progress on the task assigned, any road-blocks and estimated completion date on the story.
- Testing include running SSIS packages built on top of a SQL Server back-end where data (based on specific selection criterion) is pulled from a nightly backup database and such orders/customers are subsequently dumped into a Report Database for either generating customer notices or performing certain business functions dat are invoked via API calls to the OMX front end.
- Learning new user stories on an expedite basis and deliver quality to the team. Train new team members on the systems and overall flow of data from upstream to various down-stream systems use for BI purposes.
- Bug logging and reporting using the TFS (Team Foundation Server) defect management tool.
- Depending on the situation and due to time constraints, mock data on the Backup server in order to test out a story. Sharing all testing details and pass/fail with appropriate stakeholders.
- Test all notices including but not limited to packing slips, letters and post cards with GMC Inspire which is the 3rd party CCM (Customer Communication Management) tool used at Guthy-Renker.
- Test out all aspect of notice data by using different WFD (workflow definition files) in conjunction with XMLs and XSDs, rendering them into a PDF file for previewing and printing purposes. Provide sign-offs for production deployment so dat mass mailing on such notices can occur.
Confidential
Senior QA Analyst
Responsibilities:
- Lead and hands-on testing on Experian D2C products including Experian.com, FreeCreditReport.com, FreeCreditScore.com, ProtectMyID, CreditScore.com, CreditReport.com and various others.
- Testing encompasses various business functions including new member enrollment,, Upsell, Cross-sell, Down-sell, cancellation and much more.
- Validate all data flows via User Interface, SQL Server Backend and by viewing/running Control-M batch jobs. Techniques include visual inspection on the UI, running SQLs on the backend and via the Customer Service Tool created specifically for Experian customer support staff.
- Core test team member responsible for testing key and critical customer alert testing on browser and as well as mobile platforms. Alerts include Credit Alerts, Public Records, Positive/Negative improvement to customer score, Score Alerts and Credit Usage Alerts.
- Perform Baseline and Browser testing in production before and after deployment respectively using various browser versions including but not limited to IE, Chrome, Safari and Firefox using a wide variety of site versions on each product.
- Use VMs as well as actual machines with specific OS/browser combination for process. Use various mobile devices including IPAD, IPhone, Samsung and the Chrome User Agent switcher to cover the mobile realm of applications.
- Log the result of partial and full regression testing with server IP, site versions, date time and other relevant information.
- Communicate the testing progress and status regularly with PM, Test Manager, Developers, Test team and other stakeholders.
- Use in-house defect tracking application for execution, defect logging and reporting purposes. Perform testing in Test, Stage and production environments.
- Help out other teams with finding new issues and testing existing production tickets in QA, stage and production environments
Confidential
Technical Analyst/QA Lead
Responsibilities:
- Technical Analyst and test lead on EIS middle tier Cloud based Web Services developed on .NET - XML based highly distributed SOA based application created primarily to service Wells Fargo Brokerage and IRA accounts dat are consumed by various consuming applications within the broader organization.
- Consuming applications include bank side channel SVP - Store Vision Platform, Brokerage side channel SRWF - Service Request and Work Flow, CCIVR - Contact Center Interactive Voice Response and many others.
- Validate consuming applications/customers calling for web-services from a cloud as well as a non-cloud environment into the bank’s cloud based architecture where the API calls encompass multiple domains.
- Participate in testing and analysis on one of the biggest mergers in US history involving consolidation of Wachovia (East Coast) with Wells Fargo (West Coast) to form a single Wells Fargo entity.
- Lead multiple testing teams involving web-services including but not limited to manual, automation, GUI front-end and IVR testing teams. Work closely with each of the team’s on-shore lead, provide guidance and support to on/off shore testers including resolving hiccups, environment issues, halping in high level scenario creation, defect logging, retesting from an end-to-end perspective.
- Successfully supervise and test decommissioning of an existing system among many existing systems and ensure dat the replacing system continue provide old functionality with additional enhanced capabilities.
- Effective communicator and quick learner of people and systems in a new and fast-paced complex environment. Demonstrate subject matter expertise and interact with various groups involving business, development, testing, DBAs, PMs and other SOR support groups.
- Install and configure SoapUI with WSDL/contract loading, installation and end-point validation. Use SoapUI, Test Harness, TOAD for DB2 and Oracle, Mainframe RUMBA tools etc to perform thorough in-depth testing of service components leveraged by in-house consuming applications.
- Provide assistance to other users in installation and configuration of the above tools for research, development, and testing purposes.
- Participate in design reviews with all stakeholders and ensure unit and integration testing is completed to ensure timely commencement of the UAT phase.
- Serve as key member of the team at the enterprise level, analyzing existing application interfaces, schemas and data needs.
- On a per-need basis, work closely with the Technical Analyst and if desired provide feedback on draft version of TSD before it is published to a wider audience.
- Perform data mining activities for own testing and provide testing guidance/data to other consuming application partners to enable them complete important milestones to meet tight deadlines.
- Thorough testing with testing scope include happy-path scenarios, XML element validation, business logic validation, negative testing, data-base validation via SQL and non-SQL techniques, exception logging with various log levels including but not limited to Errors, Warning, Timeout etc.
- Testing includes but not limited to message initiation, parsing, formatting, routing by ensuring all points are properly traversed/touched and data flows to the appropriate SORs from an end to end perspective.
- Robust analysis/testing of 1BAT - Brokerage Analysis web based reporting tool during SIT and UAT. Also perform demo to the user community and other stakeholders following UAT sign-off.
- Active participation and thorough review of complex business/process flows within the Technical specifications and apply dat in test case development/execution to ensure maximum quality for each product delivery.
- In UAT phase, test in parallel with the business partners and be available to provide support and root-cause analysis for issues discovered during testing their by enabling them achieve maximum quality for timely software delivery. Support completed software throughout the Software Development Life Cycle and in production.
Confidential
QA Lead
Responsibilities:
- Develop and execute complex SQLs for data validation on various bank initiatives including but not limited to Countrywide and Merrill Lynch merger efforts.
- Lead all testing efforts on MIMS - Mortgage Investment Management System which is a JAVA based Internet application with ORACLE 10G at the back end. The application allows BOFA traders to work on various loan pools and to make buy/sell decision on such pools.
- Create user guide for MIMS application to be used for purposes.
- Plan and lead all testing efforts pertaining to the Merrill Lynch merger integration.
- On the CIDW ( Corporate Investment Data Warehouse) trading data project assist QA team in SQL development where data comes into the DIM and FACT tables from Intrader, PAM and Bloomberg data sources in the test environment. Log issues and follow them to closure.
- Detailed testing on CUSIPs/Tickers involving Bonds, Stocks, CDs and other positions. Core business scenarios involving versioning and Bloomberg override, Country override and Ticker override are tested.
- Attend all relevant project meetings and keep project managers abreast of progress and status at any given point of the testing effort.
- Leverage JADE as well as HP Quality Center for story creation, requirement housing, defect logging and reporting purpose.
- Provide end-to-end on Quality Center to various business groups within the bank using Live Meeting. Perform administration and support users on Quality Center during SDLC.
- Assist business groups with production support issues involving Oracle SQL by comparing data between UAT and production environments.
- Perform field level validations on all fields in testing scope based on the mapping and transformation logic provided in the mapping requirement documents.
- Regularly send weekly testing status reports during SIT and UAT. Provide business/QA sign-offs after each testing cycle as part of the entry/exit criterion.
- Create Test Plan for all projects and obtain sign-offs from various stakeholders.
Confidential
Test Coordinator
Responsibilities:
- Provide cost estimates on newly open projects covering coordination time, SIT and UAT activities.
- Participate in the meetings involving SOW, Business and Technical requirement walk thru to understand the overall goal and testing scope of an effort.
- Lead Test Plan and Test Script reviews and coordinate test execution with key areas needed for the test effort.
- Work as a liaison between the testing and development teams and make sure dat all questions are answered for both groups. Additionally interface with the business partners for further clarifications on requirements.
- Lead test coordination for AG Edwards merger representing Host Authorization, Debit and Credit Card applications, attend daily project-status meetings and keep all stakeholders informed about issues and participate in discussion regarding resolution.
- Chair weekly Testing Sub Committee meetings with status on current test execution, gather information; update action items/issue lists and expected future activities for the project.
- Ensure all key players are appropriately informed of any testing issues and follow up with appropriate team(s) on timely resolution of defects.
- Ensure all test scripts are developed and executed including but not limited to Unit testing, System Integration testing, User Acceptance testing, regression testing, determine Unit, SIT & UAT entry & exit criteria and escalate issues to the IT Project Manager as needed.
- Provide testing reports test evaluation reports to the IT Project Manager, coordinate issue resolution and Incident tracking.
- Review test scripts created in the Quality Center, provide feedback on the test scripts and track their execution progress.
- Keep PM informed of any high severity defects and if any obstacles prevent testers from moving forward due to environmental issues.
- Ensure dat the SDLC process is followed throughout testing cycle and sign-offs are obtained from all necessary stakeholders from an audit and compliance perspective.
Confidential
Test Coordinator
Responsibilities:
- Support the efforts for the Design, Build and Deployment around the Product Content Management Repository (PCMR), Catalog Management Integration (CMI), and eCommerce efforts under the direction of SDG Project Manager by performing the following tasks.
- Test on highly distributed environment including various components Java, WebSphere, MQ, IBM Workflow and mainframe to name a few.
- Lead all testing effort on Oracle’s out of the box content management solution EDAM - Enterprise Digital Asset Management application. The EDAM repository holds data and web optimized digital asset for use by Lowes.com and its parallel replica Lowes store based 20/20 tool
- Develop and implement a Test Plan for software changes in the DEV, QA and Production environments.
- Develop Test Scripts in Quality Center to support the requirements defined in the project documentation, to include the Business Document (BRD), Business Solution Document (BSD), High Level Design (HLD) and the Solution Specific Document (SSD).
- Maintain the project Share Point sites with the documents specific to testing.
- Ensure project documentation is in compliance with Sarbanes-Oxley requirements.
- Provide support for all testing activities, to include UAT in a web-based, windows and UNIX environment.
- Work with Lowes’ Core Team and Vendor (Oracle) to create the work plan for all testing activities. Responsible for creating and executing test cases within Quality Center covering Functional aspects, DB Validation per data map, navigation, positive and negative scenarios.
- Ensure all project hours worked are reported on the appropriate project tasks in Project Office.
- Provide detailed information regarding issues logged in Quality Center and any environment issue during the bug review with Lowe’s IT group, Oracle and with Lowes business partners.
Confidential
Sr. QA Analyst
Responsibilities:
- Develop, execute and test various new and existing XCBS web services/operations using XML messaging in cloud based test regions dat are used by various front-end clients as part of the middle tier layer to be executed against SOR as well as stand-in Database.
- XCBS - Cross Channel Business Services are the reusable web services used by different consuming channels such as web-based Wachovia.com, Telephony based Wachovia IVR, in-house used MCS - Multi Channel Solution application. The services are developed using J2EE architecture and access the Mainframe system through Common Message Interfacing (CIM) calls and non-CIM calls.
- Assist developers in the Unit testing phase as a subject matter expert and perform various types of testing including Product Verification testing, smoke/build verification testing in the SIT and UAT testing environments and regression testing using the SoapScope tool and execute/log defects in the Teamsite as well as Quality Center for defect management.
- Test the middle tier services end to end with security, error-handling, positive and negative scenarios so dat the .Net and Java clients can retrieve their data going thru MQ into Integration Hub and tan into the SOR or stand-in databases.
- Responsible for setting up client s on the SoapScope tool as well as others to install their own.
- Use in-house tools such as Cimulator and Webulator as well as Mainframe green screens to perform DB validation against the systems of record.
- Provide support to various clients dat may arise in various regions such as GHI, DEF, 345 and ABC. Find the root cause and solution or involve other teams such TEMPhas MH Hub, CIM owners etc for a timely resolution of client's issues in a highly distributive environment.
- Log CIM issues dat may arise during testing or due to clients having issues in their SIT and UAT testing.
- Use QTP Automation tool to write automation scripts against the XCBS stand-in tables.
- Perform data mining activities using WinSQL tool for our own testing needs as well as client's testing needs in various testing regions as well as in the XCBS stand-in data mart which feeds data into other down-stream applications to be used by various Wachovia Retail channels.
- Co-ordinate testing activities which involve various clients using the same operation but verifying different data attributes from their end as well as resolving any time conflicts in scheduling such activities.
- Work closely with the developers to provide them additional details, clarify requirements and halp them reproducing issues pertaining to specific defects on a need basis.
- Create and execute test scenarios for new projects/clients such as EStatements, PAGWealth, West Corp, MCS and many more so as to ensure dat the best code be delivered to the front-end clients for further validation.
Confidential
Sr. QA Analyst
Responsibilities:
- Responsible for test case and test script development of various modules of ARGO BankPro based client server GUI application with mainframe backend used across 15 states by more than 3,000 branches catering to a huge customer base.
- Executed test scripts and log defects in TestDirector.
- Heavy GUI, Functional and Database validation testing for Wachovia Retail channel involving opening and updating Demand Deposits, Time Deposits, Revolving Credit accounts, Funds Transfers and Stop Payments in various test environments including DIT, SIT and UAT.
- Test and support key and critical applications including but not limited to Account Relationships such as Service Charge, Overdraft and Transfers.
- Test small business loan applications, from completing a loan application with collateral, through the loan decision, to preparation for closing.
- Cover all aspects of test case development and execution such as GUI, navigational, functional, negative and positive testing using a window-by-window approach for the Retail Banking PEGASIS application, which communicates data to and from mainframe system via a CIM (Common Interface Messaging).
- Assist testing and development in recreating hard-to-reproduce defects for the Small Business Loans, SOLD Planner, Customer Association and Customer Financial Profile. Provide the dev team with trace/log file created during execution of test cases.
- Identify test data needed for test script execution, create new customer financial profiles and capture snapshots of new/existing profiles to be used later on to satisfy various business scenarios. Execute database validation scripts and perform test case execution from requirement documents as well use an ad-hoc approach.
Confidential
Test Lead
Responsibilities:
- Responsible for creating/administering TestDirector database for Retail Confidential web based loan application. Fulfill user requests for the project on a per need basis.
- Test all the key and critical components of Confidential application, which automates loan processing and disbursement of loan funds using IBM Workflow model in a Web-Sphere environment by using various roles such as Loan Review Analyst, Action Resolution Analyst and Financial Controls Specialist. Provide feedback to the business and development teams with suggestions in order to improve the overall quality of application under test.
- Train and assist field personnel during UAT (User Acceptance Testing) phase of development cycle in how the web based application functions in comparison with the older client server based application. Provide continuous in-person support to the users regarding how the defects should be logged such as defect severity, business priority etc. and assign tasks/roles (user privileges) to them in order to meet strict deadlines.
- Provide feedback to the business group and the development team regarding any incomplete or ambiguous requirements and work as a liaison between the two groups to continuously improve the quality process.
- Perform system testing on weekly builds in order to make the software officially available for all testing groups. Test document image viewing/printing of loan documents available after the loan is initiated and before it’s booked via collateral perfection.
- Create WinRunner script dat successfully creates and disburse a loan from an end-to-end perspective irrelevant of the loan type using a generalized approach. Train the business team in understanding the test script flow and execution of the programmed test script written in TSL.
Confidential
Test Lead
Responsibilities:
- As a QA representative, attend requirement gathering meetings held between the design, development, business, SMEs and infrastructure groups and gather information to be used in test planning, test strategy and test script creation & execution.
- Create Test Director Database for the project and define users/groups with proper display rules & privileges to ensure dat the highest level of standards are followed during and after the defect management process.
- Validate dat the merged data is printed correctly on a blank form, appears in right places on general forms as well as GL forms for both debit and credit type entries. Develop Testing Strategy document for the project by including all aspects of testing approaches used for the project by various groups and discuss in details defect management process, test case/test script execution using Test Director.
- Provide administrative support for TestDirector during SDLC phase. Tasks includes but are not limited to adding new users, remove existing users, create new display rules and run defect reports daily to be viewed by business, development and upper management.
- Certify more than 150 forms, which contain merged data (user entered data along with system data) merged into a pdf file via a merge engine as part of entrance criteria for the application deployment.