We provide IT Staff Augmentation Services!

Business Systems Testing Analyst Resume

Boston, MA

SUMMARY:

  • Over 5 years of extensive as Business Systems Testing Analyst in business functions of Capital Markets and Healthcare domains:
  • Capital Markets - Analysis and Testing experience of Front/Middle/Back office applications, client implementations, migrating the Investment Management operations from legacy systems to Enterprise Service Platform (ESP) by providing end-to-end solutions including Transaction management, Middle and Back Office Operations, Corporate Action Processing, Pricing, Net Asset Valuations (NAV), Reference data and Asset Management and Custodian Services, Information Delivery and End Client Reporting.
  • Healthcare - Analysis and Testing experience of major BI transformation projects like IDS Datawarehouse, PowerMHS to NASCO conversion, Vendor Datamarts etc., which deal heavily with functional areas such as members, enrollment, vendors, providers, claims and clinical data.
  • Experience in the Analysis and manual testing as part of Implementation of Business Intelligence solutions using Data Warehouse/Data Mart and ETL, Client/Server applications and ERP systems.
  • Plan and coordinate User Acceptance Test (UAT), manage End/Business User and Stakeholder expectations. Steer UAT kickoff and signoff meetings.
  • Extensive ETL testing experience using DataStage 9.x/8.x, Informatica 8.x/7.x/6.x (Power Center/ Power Mart)
  • Good experience of QA tools such as ALM, UFT, SQuirrel and Selenium
  • Extensive experience in working with Agile methodology and tools such as Jira, RalleyDev and RTC
  • Data warehousing experience in Healthcare administration domain using systems like PowerMHS and NASCO.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
  • Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
  • Solid Back End Testing experience by writing and executing SQL Queries.
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Has expertise in Test Strategy and Test Plan Preparation, Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
  • Expertise in Testing complex Business rules by creating mapping and various transformations
  • Experience in testing XML files and validating the data loaded to staging tables.
  • Experience in all phases of Software Testing Life Cycle and Software Development Life Cycle.
  • Thorough experience in Unit, Integration, Regression and System Testing.
  • Good analytical and problem solving skills.
  • Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.
  • Team oriented and ability to understand and adapt to new technologies and environments faster. Good at analysis and troubleshooting.
  • Experience as Test Lead and coordinating with offshore testing team
  • Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Capital Markets systems: Enterprise Service Platform, Global Reference Systems, Global Transaction Management, Record Keeping System, MYSS, Trade Order Management, Asset Management

Healthcare Administration systems: PowerMHS, NASCO

Data Warehousing: DataStage 9.x/8.x, Informatica 8.x/7.x/6.x

Reporting Tools: Business Objects 6.5, XIR3, Cognos 8 Suite, Crystal Reports

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing and Agile Tools: QTP, Selenium, ALM/Quality Center, Squirrel, Jira, RalleyDev and RTC

RDBMS: Oracle 11/10/9i/8i/7.x, MS SQL Server 6.5/7.0, UDB DB2Programming: SQL, SQL*Plus, PL/SQL, TOAD, SQL Navigator, Rapid SQL

Web Technologies: JavaScript

Project Methodologies: Agile, Software Testing and Software Development Life Cycles

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Business Systems Testing Analyst

Responsibilities

  • Performing and validating the Middle Office activities like Processing the Transactions, Settlement and Matching and Processing the Corporate Action, Manual Pricing, Cash and FX Processing.
  • Processing the Corporate Action Price adjustments and the reports and notifications.
  • Performing Trade data flow analysis through IMS Enterprise Applications like RKS, GTM, RMG & ESP
  • Participate the Preplanning meeting for each iteration.
  • Participate daily stand up calls and retro.
  • Created complex SQL queries and executed using Squirrel tool
  • Supporting internal and joint test execution process.
  • Extensively worked on ESP (Database) which includes Defining Data Elements, Outlining Filter Conditions/Logics, and Configuring Data Mapping between different Databases, Custom Feed Management and Assisting Dev Team to building up new Marts and Categories…Etc.
  • Analysis of various requirements from the clients and prepare BSD and FSD in consultation with the business analysts
  • Investigating the discrepancies between the two systems and identify the data source to correct the discrepancy
  • Migration analysis which involves the reconciliation between legacy data and enterprise data, and identifying and capturing the gaps
  • Review and understanding of business requirements document. Technical design documents (Functional specification document)
  • Performing regression testing on the application when there is new release and capturing the defects in QC
  • Understanding of test strategy and high level test case design. Test case preparation for the functional requirement based on technical design document/Business specification document
  • Test case execution and preparation of test results reports
  • Performing BUAT, JSIT,CUIT, parallel testing and support pre & post conversion
  • As part of data warehouse migration, Analyzing legacy reports and MYSS (end user reporting system) reports and identifying and reporting the sources of discrepancy
  • Investigating the discrepancies between the two systems and identify the data source to correct the discrepancy
  • Coordinate the day-to-day planning and execution of all testing for the project

Confidential, Montpelier, VT

SQA ANALYST

  • Responsible for testing of major BI transformations projects like IDS Datawarehouse, PowerMHS to NASCO conversion, Vendor Datamarts etc., which deal heavily with functional areas such as members, enrollment, vendors, providers, claims and clinical data.
  • Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
  • Extracted data from multiple data sources (RDBMS, Mainframe, flat files etc.,) to compare against Target Values.
  • Reported bugs and tracked defects using ALM/Quality Center and JIRA.
  • Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Tested complex ETL DataStage jobs based on Business requirements and Business rules to load data from source files to target tables.
  • Involved in writing detailed level test documentation for reports and BI Universe testing.
  • Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
  • Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects.
  • Conducted review sessions on test case and regression test scripts in ALM/quality center
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
  • Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
  • Analyzed the data and applied relevant transformations and verified that the source data types are correct.
  • Performed SQL Queries, creating Tables, and Views by following Best Practices
  • Involved in creating source target mappings based on the Technical Design requirements.
  • Used different sources for Input.
  • Tested ad hoc and canned reports for Business objects.
  • Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.

Environment: DataStage, ALM/Quality Center 11.0, QTP, SQL, PL/SQL, Business Objects, Flat Files, UNIX, DB2, RapidSQL, JIRA, PowerMHS, NASCO

Confidential, Eden Prairie, MN

Selenium/DataStage/ALM/SQL/Manual Tester

  • Responsible for Business analysis and requirements gathering.
  • Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
  • Extract data from Mainframe data sets to compare against Target Values.
  • Reported bugs and tracked defects using ALM/Quality Center
  • Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Recorded and played back test cases using Selenium IDE.
  • Run tests by using Selenium RC in different browsers.
  • Examine the results of test to pinpoint defects in the web page.
  • Tested complex ETL DataStage jobs based on Business requirements and Business rules to load data from source files to target tables.
  • Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
  • Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
  • Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects.
  • Conducted review sessions on test case and regression test scripts in ALM/quality center
  • Extraction, Transformation and Load (ETL) of data from Legacy systems using DataStage.
  • Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
  • Responsible for running the load runner scenarios.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
  • Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
  • Analyzed the data and applied relevant transformations and verified that the source data types are correct.
  • Performed SQL Queries, creating Tables, and Views by following Best Practices
  • Involved in creating source target mappings based on the Technical Design requirements.
  • Used different sources for Input.
  • Tested ad hoc and canned reports for Business objects.
  • Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
  • Created different user defined functions for applying appropriate business rules
  • Worked on test data and completed unit testing to check all business rules and requirements are met.

Environment: DataStage, ALM/Quality Center 11.0, Selenium, Teradata 13.0, SQL, PL/SQL, Business Objects, Mainframe VSAM Files, Flat Files, UNIX, Oracle 11G, DB2, TOAD

Confidential

Database Tester /Analyst

  • Generated expected liability sheet containing loan no, name, amount disbursed, no of installments, gestation period.
  • Written complex SQL queries for each level of data validation.
  • Involved in creating both positive and negative test data to cover all business scenarios
  • Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
  • Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used SQL for Querying the DB2 database in UNIX environment
  • Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
  • Generated daily transaction reports with transaction no, loan no, borrower's address, particulars, credit, debits liability.

Environment: Oracle 7.x, Clear Case, Clear Quest, Windows 2000

Hire Now