SEARCH

Software Automation Analyst Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
SOFTWARE AUTOMATION ANALYST
Career Overview
Fifteen years experience in designing, developing, implementing and maintaining clear and concise traceability matrix, test plans, test cases, and manual/automated test scripts. Extensive knowledge in testing methodology, quality assurance procedures and best practices using HP Tools. Expert in SDLC (Software Development Life Cycle) methodologies and full lifecycle of testing including functional, integration, system, regression, UAT testing, browser compatibility testing, defect tracking, management, and reporting. Expertise in software testing procedures in manual and automated testing environments for client-server, distributed and e-Business applications used in financial and health care industries. Experience and knowledge in working with business requirements, business rules, functional specification documents and other relevant documentation for UAT/QA planning, design, and execution. Ability to develop testing methods and test data to cover the whole life cycle of a product starting from inception to regression testing during the maintenance phase. Expert in implementing Agile-testing methodology in test driven development. Work closely with business analysts, development and production teams to identify product and technical requirements and create a comprehensive test suite. Detail oriented with immense knowledge in troubleshooting. Proactively escalates issues to QA team and alerts the project team on potential impact to the systems upon assessing testing issues (gaps and risks) discovered in test execution. Self-motivation and great interpersonal skills allow for a range of work environments: interactive groups, teams, or independently. Experience with automation tools HP QTP 11, UFT, Perfecto Mobile UFT, SeeTest, ALM 11, Quality Centre 9.2, Power MHS, TPX (IBM mainframe legacy Terminal Productivity Executive), TSYS (Total System Services) and Sage ERP MAS 500 system. Experience in testing IBXpress Web applications by creating and validating eEnrollment test data using XML and METS files. Experience in using SQL, MS Sequel Server Databases, Transact SQL and MS Access queries. Experience in VBA Excel Macros, MS Access tables, Queries, Forms and reports. Experience with International Trade Processing System for Letters of Credit, Bankers Acceptances and Documentary Collections. Excellent experience in mobile device automation testing using Perfecto Mobile UFT technology and SeeTest. Ability to work independently and/or as part of a team. Experience working with geographically distributed project teams including offshore.
Qualifications
  • C/C++, Java, Visual Basic 6.0, PERL CGI programming, Perl, COBOL, Micro Assembler, Pascal, SQL, SQL*PLUS, PL/SQL, Mercury Interactives' Test Script Language and XML.
  • Databases: Oracle7/8/9i, MS Access and MS SQL Server (6.0/7.0/8.0).
  • Operating Systems: Windows XP and Mac.
  • Applications: AS400 - Eximbills, Altova XML Spy, Power MHS, TPX (IBM mainframe legacy Terminal Productivity Executive), AAA (Automated Account Administration system), FDR (First Data Resources), TSYS (Total System Services), Commercial loan accounting system AFS, Eximbills and MAS 500 ERP system.
  • Domain: Financial, Health care and Pharmaceutical industries.
  • Testing tools: WinRunner (5/6/7), HP QTP 11, UFT, Perfecto Mobile UFT, SeeTest, Quality Center (9.2/10.0) and ALM 11.
Work Experience
08/2011 to 07/2016
Software Automation AnalystJ P Morgan Chase and Company － Wilmington, DE
  • Automation of Chase Online Applications Project (Develop and maintenance): Automation of business credit card functionalities (My Accounts page, Quarterly Management Reports, Expense Reports, Account Activity, Account Details, Change Bill Due Date, and Add and Close Employee cards) and consumer credit card functionalities (Soma and Alerts) in Chase Online (COL) and Card Member Services (CMS) domains.
  • Preparation of UAT QA and Production test data using Test Account Management Tool, Administrative tool and excel VBA macros.
  • Automation of Blueprint features (Full Pay, Split It, Finish It, and Track It) for enroll, edit and cancel workflows.
  • Automation of Name and Address functionalities for various account types.
  • Automation of batch and Real time Alerts notification for Web Online and Mobile devices - Subscribe, Update and Suspend alerts for various delivery methods and verify email notifications.
  • Automation of e-Disputes process for consumer type accounts.
  • Automation of Payments and Transfers work flows - Set up of payee account, automatic payment, status checking, and cancellations.
  • Automation of Ultimate Rewards workflows.
  • Automation of customer personal details (About me, Phones, Email, Mailing address, preferred languages and preferences) and card benefits validations.
  • Execution of automated scripts for production validation on daily basis to see whether the production environment is stable and working properly.
  • Created several user defined QTP functions (Login to applications, get page screen shots, get object count and names in a page, verification of emails, transaction details etc.) Profile Combine Project: Worked on Profile Combine project that deals with removal of ECI (Enterprise Customer Identification) combine restriction for business credit card customers and to establish ECI agent.
  • After the restrictions are removed and ECIs are combined, business card accounts would appear with personal/consumer accounts.
  • Will perform UAT testing of user experience with regard to branding and account viewing after lifting restrictions on segment logic process for consumer and business card customers.
  • Set up UAT test data using Customer Administrative tool to identify individual (Consumer) and non-Individual (Business) ECI values, create user profile and verify user experience data for various business processes before and after implementation of segment logic rules in UAT environment.
  • Automation of Chase Mobile Applications Automation of Chase Online application functionalities using Android/iOS devices in Perfecto Mobile UFT environment.
  • Alerts Subscription and push notifications processes, payment and transfers are the main areas.
  • Databases: Help Card Digital Team members in providing UAT QA and Production test accounts maintained in "Test Accounts Management" Access database.
  • Create and maintain macros used in posting transactions to TSYS.
  • Maintain backing up of databases used by Card Digital Team on weekly basis.
03/2011 to 07/2011
QA AnalystWedgewood Pharmacy － Swedesboro, NJ.
  • eCommerce Sales force Project: Sales force is a .net based web application used to register new online accounts for pharmacy prescribes and health care providers as well as for the existing customers.
  • Data flows from public web application to MS SQL based WDS/IDS databases to Sage ERP MAS 500 system.
  • Manual updates made in MAS 500 flows from ERP system to IDS/WDS databases to the corporate web site.
  • Design test procedures, create detailed test cases and scripts, works with business analysts to determine requirements are captured correctly and work with development teams to analyze and resolve defects.
  • Responsibilities: Design test procedures to validate registration process for new online accounts for pharmacy prescribes and health care providers.
  • Create and validate Shipping cart and checkout processes.
  • Create and validate sales orders for regular and tax-exempt customers belonging to taxable and non-taxable States.
  • Validate payment types (invoices and credit card processing) and shipping methods in web and MAS 500 system.
  • Validate sales promotions, order history, customer contact, billing and shipping information in Web and MAS 500 systems.
  • Verify data in ERP system in Accounts Receivable, Accounts Payable, Sales Orders, and Inventory Information and Customer Maintenance modules.
  • Adjust item parameters (like increase quantity ordered, add new flavor, size, strength, dosage form, marketing description etc) in ERP system and verify data in SQL databases and in internal web site.
  • Browsers' compatibility testing for all workflows.
10/2009 to 02/2011
QA AnalystWachovia Bank － Philadelphia, PA
  • Asia Trade line Migration to Eximbills Project: Asia Trade line is Wells Fargo Bank's back end Trade Services processing system.
  • Eximbills is Wachovia Bank's back end processing system that audits and automates the complete cycle of trade finance transactions.
  • As a part of merger, all existing Asia Trade Line customer's commercial LC business is being migrated to Hong Kong Branch Eximbills for processing.
  • Responsibilities: Creation of test customer profile (demographic and financial parameters) including addendum tables for Test and IST environments.
  • Process Export LC and Import LC Negotiations, Collections for Payments and Settlements, Transfer LC Negotiations and Standby LC Negotiations for various customers.
  • At the end of the day these transactions will be batch processed and sent to IBIS (a system that supports multi-currency accounts, foreign exchange, money market lending and General Ledger functionality) and Midas Plus (a system that supports direct deposit account or demand deposit account).
  • Verify data by analyzing recon/reconciliation reports generated by Eximbills specific queries (Libraries and files) maintained in Eximbills utilities.
  • Coordinated with Eximbills technology team located at Hong Kong for test data results and escalation of issues.
  • Swift BIC Conversion Project: As Wachovia bank and Wells Fargo systems continue to integrate; there is a need to consolidate BIC (Bank Identifier Code) codes to reflect the Wells Fargo naming convention.
  • This project is implemented for several application/infrastructure Systems, and Eximbills is one among them.
  • All Eximbills systems applications, data and programs, across all Eximbills instances, will change the existing BIC code into go-forward Wells Fargo BICs.
  • Responsibilities: Verification of BIC changes for SWIFT Forms in all applicable product modules in all Eximbills instances (Offshore as well as inshore).
  • Verification of BIC changes for Auto Doc Templates.
  • Verification of BIC changes for CUBK (Customer Bank) profile and International Fund Transfer Payment instructions.
  • Eximbills Bridges and Interfaces Project: Eximbills is Wachovia's Trade Processing System for Letters of Credit, Bankers Acceptances and Documentary Collections.
  • This system exists at US, Hong Kong, Taiwan, Shanghai, Tokyo, Seoul and London and each instance may contain one or more modules.
  • As a result of the merger between Wells Fargo and Wachovia it has been decided that the Commercial Loan system, currently in production for Wells Fargo, called AFS, will be the go-forward system.
  • The Eximbills is required to incorporate data and post Customer Exposure to AFS for Trade Products.
  • Responsibilities: Verification of external interface activities whether they are interactive or batch initiated, memo posting or hard Postings, and intraday or end of day or end of month.
  • Interfaces include AFS/Eximbills intraday sweeps and EOD (End of Day, PMAX, Customer View and Bankers Score Card EOM (End Of Month).
  • Verification of data and specific field values in the AFS_Interface, AFS Request and Response files for US, London and Hong Kong Eximbill instances.
  • Design and set up customer profile and test data in Eximbills system for US and London instances for Unit/IST/QA/UAT test environments.
  • Creation of various types of Trade Processing transactions (Import, export, standalone, negotiations and payments) in Eximbills and verify data in AFS (Loan).
  • Early Charter Consolidation Project.
  • Merger activities range from re-organizing documents to reflect the acquiring institutions name (Wells Fargo Bank, NA), modifying outward correspondence documentation that will need to bear the new name, making the requisite internal process and systems changes to appear to all third parties as Wells Fargo Bank, NA.
  • Verify change of entity name for LC issuance, LC advising, confirmation, LC negotiation, bankers acceptance, open account and documentary collections processing (direct/incoming).
  • Verify whether the modified customer output forms maintained within the legacy WB processing platform "EximBills" to reflect the name change.
  • Verify whether the Modified EximBills internal and external reports to reflect name change.
  • Modify customer-interfacing forms managed by other support units such as Hong Kong Cyber import forms.
  • Modify CUBK records that reflect Wachovia Bank to reflect name change.
09/2005 to 09/2009
QA AnalystIndependence Blue Cross － Philadelphia, PA
  • Test e-Business IBXpress Web applications - Benefit focus, Group Portal, EDI Portal and Customer Setup.
  • Developers convert Group Portal data in to Canonical XML files in the form of "Customer load file" and "Member load file".
  • Verify whether customer load data (Customer, Group, Account, Tier Coverage, Coverage Package, Family Status and Group Profile) and member load data (Member Profile, Contact Information, Benefits Coverage, Group Provider, Family status, additional insurance information, Cobra indicator) is correctly mapped to canonical XML.
  • Verify whether all data from customer load file and member load file is loaded in to benefit focus using Perl code.
  • Verify events at FTP and validate change-customer and change roster files generated from databases and MHS.
  • Create and validate member enrollment transactions for Benefit focus applications via front end and through canonical XML file - enrollment transactions include add a new plan, add dependent(s), change demographic information, change participating physician, change groups, change benefit plan(s), term contract or cancel benefits, term dependent(s) or cancel benefits, reinstate contract, reinstate dependent(s), add COBRA, add or modify other insurance, Medicare.
  • Create Canonical XML files using Altova XML Spy for member portfolios and for member enrollment transactions and validate them against SOA (System Oriented Architecture) based Web Common Services.
  • Verify log files for Enrollment Transaction Request, Enrollment Transaction Response, 'Group Related Object' properties, Contract level elements and their values, 'Transaction' and 'Activity' codes and BRE errors.
  • Validate Canonical XML data generated for enrollment transactions.
  • Validate HR- XML Enrollment transactions.
  • It involves creation of enrollment test data in XML document, loading it through a tool 'InterfaceB2BRequestQueue' and validates transactions against HR-XML schema.
  • Validate HR-XML Acknowledgement messages against XML Enrollment data.
  • Verify Business Rules Engine (BRE) validation results in Acknowledgement.
  • Verify whether Transaction Services populate test data in Member Application Database (MAD), Managed Health System (MHS) and IBM mainframe legacy Terminal Productivity Executive (TPX).
  • Create METS (Member Enrollment Transaction System) test data files for medical, drug and vision coverage for various contract types.
  • Validate customer profile and coverage keys in EDI Portal, MAD database, MHS and Mainframe against METS data.
  • Validate data mapping of EDI inbound XML and METS file contents against data created in EDI Portal GUI.
  • Validate functionality of 'PaperFree' interface by comparing EDI inbound and outbound XML file contents.
  • Validate functionality of 'ContractAnalyzer' interface by comparing EDI inbound METS coverage data against coverage keys in Customer Setup EDI Portal, MAD database and MHS.
  • Validate functionality of API s that writes data to MHS to establish member tier code and coverage keys.
  • Verify contents of Error Reports generated in Customer Setup application.
  • Benefit focus submits eEnrollment data to IBC's Portfolio Services on daily basis.
  • Some of the members fall out and some show BRE errors.
  • Create a report using SQL queries on daily basis to show CID-based member status and BRE errors.
  • This report is available to Business as well as QA leads on daily basis.
11/1998 to 08/2005
QA Analyst/Sr. Software Automation AnalystJ P Morgan Chase and Company － Wilmington, DE
  • Design, develop, implement and maintain automation test strategies, plans and scripts using detailed functional and technical specification business requirement document provided by business analysts for heritage Bank One application "First Support".
  • Managed conversion project from FDR (First Data Resources) to TSYS (Total System Services) by developing and maintaining automated test scripts for FDR based regular 'First Support New Generation' and TSYS based i3 'First Support'.
  • Participated in developing test strategies for Year 2000 compliant processes for "First Assist", "First Watch", "First Support", "First Image", and "Customer Support New Generation".
  • Participated in automation feasibility studies for several other CMS applications.
  • Contributed in setting up company wide standards for WinRunner automation.
  • Reviewed and developed test plans, test subjects and test cases for several CMS applications.
  • Automated scripts developed by me are being used to test several functionalities of other CMS applications by UAT, ITE and Business Card groups.
  • Participated in writing of initial high-level specification documents to create and maintain automated scripts for other CMS applications.
  • Performed functional testing, system testing, verification testing, regression testing and user acceptance testing.
  • Developed and maintained Test Script Language (TSL) based GUI maps, handling dynamic GUI maps, user defined functions, compiled modules, external APIs, mapping custom objects, and handling exceptional handlers.
  • Tested applications at various phases of System Development Life Cycle.
  • Created TSL scripts to test application GUIs, data and control elements, and database structures by checking database objects and their values using SQL queries.
  • Employed automation scripts to verify front-end GUI data against terminal emulator based FDR and TSYS green screen values.
  • Developed automation procedures to export text from any file type in to test step design view of Test Director to facilitate bulk transfer of data in to test steps.
  • Created and implemented test strategies and processes for FDR Disaster Recovery tests using manual and automated scripts.
  • Involved in identification of requirements for risk- based testing.
  • Networked with appropriate business and technology leads to determine the acceptable range of tests and creation of test data to perform System Fail over testing.
  • Assisted Application Developers in identifying test data, designing, and authoring test scenarios that encompass both valid and invalid data and performing quick functional testing using automation scripts.
  • Document test results and analysis including defect identification, resolution and workarounds wherever it was possible.
  • Participated in Post Implementation Reviews.
Education and Training
2000
Associate Degree: Computer SciencesDelaware County Community College － PAComputer Sciences
1998
Associate Degree: Computer Sciences "Information SystemsDelaware County Community College － PAComputer Sciences "Information Systems
1980
M.S: Bio Statistics /Computer SciencesOsmania University － HyderabadIndiaBio Statistics /Computer Sciences
Skills
*Design, develop and maintain manual and Automation testing scripts in financial and healthcare domains.
* Usage of HP ALM (Application Lifecycle Management)
* Usage of HP QTP/UFT, selenium webdriver using java
 * Usage of TSYS (for Financial main frame) and MHS (for healthcare mainframe)
* Usage of databases (SQL, MS Access)
* Usage of VBA for creation of macros
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • J P Morgan Chase and Company
  • Wedgewood Pharmacy
  • Wachovia Bank
  • Independence Blue Cross

School Attended

  • Delaware County Community College
  • Osmania University

Job Titles Held:

  • Software Automation Analyst
  • QA Analyst
  • QA Analyst/Sr. Software Automation Analyst

Degrees

  • Associate Degree : Computer Sciences
    Associate Degree : Computer Sciences "Information Systems
    M.S : Bio Statistics /Computer Sciences

Similar Resumes

View All
Software-Automation-Test-Analyst-resume-sample

Software Automation Test Analyst

J P Morgan Chase and Company

Aston, Pennsylvania