We provide IT Staff Augmentation Services!

Sr. Backend Test Engineer Resume

Baltimore, MD

PROFESSIONAL SUMMARY:

  • Experienced Quality Analyst with strong background in design, development, and support of databases and information products as well as data analysis / reporting / Testing.
  • 8+ years of IT experience in the Analysis, Design, development, testing and Implementation of Quality Analyst solutions using Databases, Backend, SQL, Web and Client/Server applications.
  • Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back - end testing.
  • Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load of data from Legacy systems using Informatica.
  • Well versed using UNIX commands for shell scripting.
  • Testing on various methodologies for data warehouse projects and Star and Snowflake Schema
  • Planned, developed and conducted unit, function, integration, data quality and UAT tests
  • Expertise in Testing complex Business rules by creating mapping and various transformations using Informatica.
  • Hands on experience in testing soap UI and xml web service interfaces and running basic UNIX shell scripts
  • Extensive backend testing executed SQL queries on Teradata, Oracle, DB2, and Hadoop, SQL server tables in order to view successful transactions of data and for validating data.
  • Experienced in working with HP ALM/Quality Center and Rational Requisite Pro and Clear Quest for Test Management and defect tracking.

TECHNICAL EXPERTISE:

Programming: SQL, PL/SQL, Perl, VB.Script

ETL Tool: Informatica, Data stage 8.1, Ab Initio, SSIS

Reporting Tools: Business Objects XI R2/R3, IBM Cognos, SSRS, OBIEE, and Microstrategy

Database: Oracle 11i/10g/9i, SQL Server, IBM DB2, Sybase, Teradata and MS-Access

Utilities: Toad, Oracle SQL Developer, SQL Advantage, Putty, Claim Guide wire

Testing Tools: HP Quality Center/Test Director, Clear Quest, Rational Clear Case, ALM

WORK EXPERIENCE:

Confidential, Baltimore, MD

Sr. Backend Test Engineer

Responsibilities:

  • Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
  • Wrote Test cases and SQL queries to validate the data pulled in from the Data Marts and populated.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Good experience in writing SQL in order to data validation in migration as part of backend testing
  • Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used in house.
  • Validated the source data coming from various databases using complex SQL queries.
  • Performed various data analysis Confidential the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts.
  • Execute SQL queries to perform Backend testing to ensure data validation. Aggregated the data Confidential source and compared with the Target to validate Transformations.
  • Logged defects using HP ALM/Quality Center, linked defects with requirements and generated Defect Reports in QC.
  • Analyzing Facts, Dimension models for data warehousing FDW in Star join schema.
  • Attended daily status call with Offshore to review assigned tasks and solve any impediments.
  • Extensively used SQL queries/Unix commands for data verification and backend testing.
  • Used Oracle SQL developer tools for Querying source Database.
  • Used Quality Center/ALM for execution, tracking and reporting for Internal High Level access and also to create reports and update bug status
  • Documented and reported various bugs during the Testing process. Written SQL Queries to define identify and validate the code written for the data movement into the database tables, fine-tuned the queries for better performance.
  • Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: HP ALM/Quality Center, MVS, SQL, PL/SQL, SQL Server, Teradata, SOAP UI, XML, QTP/UFT, Web services, Oracle, Data Quality Analyst, PL/SQL, TOAD 8.0, SQL, UNIX.

Confidential, Columbia, MD

Backend Test Engineer

Responsibilities:

  • Involved in Business analysis and requirements gathering. Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
  • Extensive backend testing for the front end of the application using SQL Queries in Teradata data base.
  • Reported periodic project status and updates to the QA Lead and QA Manager
  • Performed Integration Testing of different modules. Logging in UNIX server for checking logs in UNIX in Production & Development environment.
  • Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
  • Performed various data analysis Confidential the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts.
  • Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
  • Load new or modified data into back-end SQL server database. Used Quality Center to run the test scripts and to log and track defects.
  • Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
  • Extensively involved in Web service testing using SOAP UI. Performed backend testing by validating data between source and target by developing SQL scripts, and verifying stored procedures.
  • Tested User Interface inconsistency and application functionality.
  • Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
  • Expertise in bug-reporting and bug-tracking using the test management tool like Clear Quest, ALM and Quality Center.
  • Preparation of test data for various levels of testing. Verified the Data completeness, Data Migrations, Data transformations and Data Quality
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Created Customized report using Soap UI tool for all the services. Created various stored procedures for dropping and recreating indexes on target tables.
  • Worked on issues with migration from development to testing. Validated cube and query data from the reporting system back to the source system.

Environment: SQL, PL/SQL, SOAP UI, XML, Teradata, ALM/Quality Center, DB2, SQL Server Import Export Wizard, Oracle10g, C#, SQL Server, Erwin, Windows XP, TOAD for Oracle.

Confidential, Hunt Valley, MD

Quality Analyst

Responsibilities:

  • Worked with Business analyst and QA manager in gathering technical and functional specification documents for reviews to understand the functionality.
  • Prepared test plan and determined testing approach and time slots for task completion.
  • Coordinate with other test team, define the functionalities to be tested and assigned the tasks to other team members.
  • Wrote Test Cases and design test steps according to the requirements specifications in Excel.
  • Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements.
  • Exported test cases into Mercury Quality Center. Inserted Check Points to check for the broken links, Text and standard properties of an object using Quick Test Pro.
  • Performed Synchronization and Tested Applications using Quick Test Pro with different sets of data.
  • Created page checkpoints to test the properties and contents of the web page using Quick Test Pro.
  • Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
  • Get sign off after completion all the test scenarios have been tested successfully. Worked with Business Analyst in UAT testing and involved in testing in Production region.
  • Extensively involved in Database testing by writing SQL queries.

Environment: Oracle 9i, Toad, DB2, SQL, MS Visio, SQL Server 2003/2005, HP Quality Center, UNIX.

Confidential, Pikesville, MD

QA Engineer

Responsibilities:

  • Develop test plans based on BRDs and Technical Specifications. Written complex SQL queries for querying data against different data bases for data verification process. Preparation of technical specifications and Source to Target mappings.
  • Verified the Data completeness, Data Migrations, Data transformations and Data Quality
  • Written Test Plans and Test Cases on Mercury Test Director Tool. Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
  • Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
  • Tested the different sources such as Flat files, Mainframes Legacy Flat Files, DB2 and Oracle to load into the Oracle data warehouse.
  • Extracted data from various sources like Oracle, flat files and SQL Server.

Environment: UNIX, SQL, PL/SQL, Perl Scripting, Mercury Test Director 6.5, SQL *Loader, Oracle 9i, SQL Server 2003, Java.

Hire Now