We provide IT Staff Augmentation Services!

Sr. Etl/qa Sql Tester Resume

5.00 Rating

Rochester, NY

SUMMARY

  • 7+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
  • Solid Back End Testing experience by writing and executing SQL Queries
  • Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
  • Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices
  • Expertise in designing the test scenarios and scripting the test cases in order to test the application
  • Expert in PERL, UNIX Shell Scripting & SQL writing for several technology needs
  • Involved in Developing Data Marts for specific Business aspects like Marketing & Finance
  • Creation of test data and Automation of test cases for system and analyzing bug tracking reports
  • Expertise Shell Scripting experience on UNIX, Linux and Windows environment
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting
  • Experience in UNIX shell scripting and configuring cron - jobs for ETL Loads
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica and Data Stage
  • Good working experience in Oracle, Unix Shell Scripting
  • Extensively strong on databases including Oracle, MS SQL Server, and Teradata
  • Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
  • Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming
  • Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
  • Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C and C++ Concepts, PERL, Test Script Language (TSL),CSS, HTML, VBScript, JavaScript, Shell Scripting

Databases: Oracle 10g/9i/8i, MS SQL Server 2008, MS Access 2008, Teradata V2R6, DB2 UDB 8.2/8.1, Informix

Reporting Tools: Business Objects XIR 2/6.5.1/6.0/5.1. x/4.0 (Supervisor, Designer, Reporter), Cognos 8.0 Series, Crystal Reports, Hyperion Reports 7.x/2.x

Tools: TOAD, Win SQL, Teradata SQL Assistant, BTEQ, XML Spy 2008

Operating Systems: Windows (95, 98, 2000, NT, XP), UNIX

Office Tools: MS-Office suite (Word, Excel, Project and Outlook)

Testing Tools: Mercury (Quality Center, Win Runner, Load Runner, Quick Test Professional, Performance Center, VU Scripting, Business Availability Center) Rational Test Manager, Rational Robot, RequisitePro, RUP, UML, MS Project, MS Visio & Visual Source Safe

ETL Tools: Informatica 8.1/7.1.2/6.1. X (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Web Intelligence, Essbase Excel Add-in, DataStage 7.1/8.x, Ab Initio

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Sr. ETL/QA SQL Tester

Responsibilities:

  • Involved in understanding Logical and Physical Data model using Erwin Tool
  • Prepared the guides for UAT
  • Prepared Execution procedure document format to prepare the Test cases based on mapping document.
  • Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
  • Ensured that the mappings are correct and Conducted data validation testing
  • Worked with PERL control structures & Regular Expressions for substitutions based on matches
  • Worked with business analyst and developers in setting up test data
  • Developed several SQL queries for data retrieval from TERADATA and used every utility available in including MLOAD, FLOAD, FAST EXPORT, BTEQ AND TPUMP
  • Writing complex SQL queries for data validation for verifying theETLMapping Rules
  • Extensively test the reports for data accuracy and universe related errors
  • Worked on notices and validated PDF notices after executed in RQM
  • Used T-SQL for Querying the SQL Server database for data validation and data conditioning
  • Tested several dashboards and deployed them across the organization to monitor the performance
  • Used SQL tools to run SQL queries and validate the data loaded in to the target tables
  • Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
  • Involved in user training sessions and assisting in UAT (User Acceptance Testing)
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Written extensive UNIX Shell scripting for error logging, cleanup, data archiving & job scheduling
  • Preparing manual test cases and test data for Scenarios
  • Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status
  • Implemented SDLC, QA methodologies and concepts in the Project
  • 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 testing Business Reports developed by Business Objects XIR2
  • Experience in creating UNIX scripts for file transfer and file manipulation
  • Created and executed Test scripts for system validation and user acceptance testing (UAT)
  • Did database backup and recovery mechanism using PERL
  • CreatedETLexecution scripts for automating jobs
  • Tested multi browser application manually and executed in RQM
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
  • Tested Operation Data Store process of ODS/DWL product
  • Used workflow manager for session management, database connection management and scheduling of jobs

Environment: Informatica 9.1, XML, XSLT, XPath, XQuery, SQL Server 2008, ALM/Quality Center 11, DTS, SSIS, T-SQL, SQL, Teradata 13.0, Oracle 11g, PL/SQL, IBM DB2,Rational Quality Manager (RQM),PERL,Business Objects XI3.1, MS Access, Flat Files, Korn Shell Scripting

Confidential, Louisiana

ETL Tester

Responsibilities:

  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
  • Created test data for testing specific Membership functionality
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments as required
  • Extracted certain column of data from a number to files using PERL
  • Used PERL for automating all the types of modules at a time
  • Worked with PERL control structures & Regular Expressions for substitutions based on matches
  • Worked with PERL for file manipulations, text processing, data parsing and Converted SQL queries results into PERL variable
  • Extraction of test data from tables and loading of data into SQL tables
  • Extracted certain column of data from a number to files using PERL
  • Used PERL for automating all the types of modules at a time
  • Written several complex SQL queries for validating Cognos Reports
  • Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
  • Experience in creating UNIX scripts for file transfer and file manipulation
  • Validating the data passed to downstream systems
  • Worked with data validation, constraints, source to target row counts
  • Developed automated Test Scripts using QTP
  • Wrote and ran Unix Scripts for batch jobs.
  • Performed regression testing against the various builds of the application and executed manually in RQM to perform through testing.
  • Used data conversion to Protect the data and prevent data loss
  • Strong in writing sql queries and makes table queries to profile and analyze the data in MS Access
  • Created macros to automate the process of refreshing the data in MS Access
  • Provided technical support and coaching to team members about functionality of MS Access
  • Worked with Data Extraction, Transformation and Loading(ETL)
  • Involved in testing data mapping and conversion in a server based data warehouse
  • Involved in testing the UI applications
  • Involved in Security testing for different LDAP roles
  • Worked with business team to test the reports developed in Cognos
  • Used Microsoft excel and Word 2003 to document the test status reports and the Test Data
  • Used Quality Center to track and report system defects
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Informatica 9.0, Informix, DB2, Java, Cognos, SQL, SQL Server 2008, PERL, Teradata 12, XML, XSLT, XML Spy 2008, IBM AIX 5.3, UNIX, Shell Scripting,QTP,WinSQL, Ultra editor, Rumba UNIX Display, Quality Center 9.0

Confidential, NY

QA Analyst/Data WarehousingTester

Responsibilities:

  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements
  • Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based onETLmapping document
  • Written complex SQL queries for querying data against different data bases for data verification process
  • Performed UAT testing
  • Designed the data flow diagrams using VISIO
  • Prepared the Test Plan and Testing Strategies for Data Warehousing Application
  • Preparation of technical specifications and Source to Target mappings
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
  • Analyzed SQL code to ensure Business Objects queries the correct data from the database
  • Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director
  • Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans
  • Tested a number of complexETLmappings, mapplets and reusable transformations for daily data loads
  • Extensively used Informatica power center for extraction, transformation and loading process
  • Creating test cases forETLmappings and design documents for production support
  • Setting up, monitoring and using Job Control System in Development/QA/Prod
  • Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
  • Scheduling and automating jobs to be run in a batch process
  • Effectively communicate testing activities and findings in oral and written formats
  • Reported bugs and tracked defects using Test Director 6.5
  • Worked withETLgroup for understating mappings for dimensions and facts
  • Extracted data from various sources like Oracle, flat files and SQL Server
  • Worked on issues with migration from development to testing
  • Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic

Environment: PERL, UNIX Shell Scripting, Oracle, Informatica Power Center 8.6.1, QTP, SQL *Loader, Cognos 7.0 Series, Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, PL/SQL

Confidential, Lawrence, KS

HP QC Admin

Responsibilities:

  • Experience in Functional Testing, Stress Testing, Regression Testing and Integration Testing and expertise in developing Test Plans, Test Cases/Scenarios, Test Procedures and analyzing Test Results.
  • Setup and upgraded the Quality Center Repository from 9.0 to 10 and performed the necessary schema updates on the backend database
  • As an Administrator of HP QC/ALM, set-up and maintain projects and users.
  • Lead and administer all HP Quality Center Administration functions including Quality Center, Quick Test Professional and Load Runner applications and tools.Inspecting /reviewing and updating Functional specification, test conditions and Run Sheets
  • Prepared the Test Data, Test Cases and Test Responsibility Matrices for the Application under test
  • Involved in the entire QA Life Cycle which includes documentation of Test Plans, Test Cases, Requirement Traceability Matrices
  • Analyzed the specifications in the User Requirements Document, Functional Requirement and Technical Requirement Documents for the purpose of preparation of Test plans
  • Communication protocol FIX (Financial Information exchange) was used for real time exchange of information related to the market.
  • Extensively worked on testing of FIX protocol messages used for the communication of trade related data
  • Performed Backend Testing to ensure the authentic retrieval of the data from the database
  • Conducted Regression Testing on various builds of the application and reported the defects to the developers using Quality Center for the bug fixing and tracking.
  • User account and Quality Center Project Entity administration Quality Center End user assistance
  • Working with Quality Center users to implement new processes
  • Setup and configuration of Quality Center projects
  • Accountable for resolution of issues within Quality Center
  • Developing, implementing, and executing a Quality Center backup and recovery strategy
  • Expertise in Quality Center, which deals with the managing the testing, tools like QTP.
  • Key Expertise in Quality Center Management tool.
  • Research QC user requests (i.e.: workflow, customization and functionality on Admin)
  • Work with project admins to troubleshoot users’ issues.
  • Assist in user id clean up, Create User Ids, Reset Passwords, Create New Projects
  • Delete inactive users (as per lists provided)
  • Create KPI’s using QC Dashboard
  • Configuring Quality Center User Groups, Project Entities, Project Lists
  • Providing technical assistance to users of Quality Center
  • Monitoring and administering COTS product multi-user licenses
  • Integrating Quality Center with external sources such as Excel, Requisite Pro, Word etc.
  • Maintaining the day to day Quality Center and Performance Center environments, including monitoring all application logs for errors, monitoring the Microsoft SQL database, responding to reported issues, configuring application servers.
  • Set up new Quality Center Projects, add new users, change existing users groups and/or projects, delete users, reset passwords, add user defined fields, add user defined list items, add user defined groups & add users to those groups, adding users to the tool, project removal, and performing all upgrades, patches and enhancements. Strong understanding of the interoperability between the various Operating systems, Security requirements.
  • Resolve any integration questions or issues, and determine if issues are related to Quality Center / Test Director, another tool, or a system / network issue

Confidential

QA Test Admin

Responsibilities:

  • Good Understanding of Functionality and Requirements of the Application.
  • Analyzed the specifications in the User Requirements Document, Functional Requirement and Technical Requirement Documents for the purpose of preparation of Test plans
  • Involve in developing and supporting the testing program aimed at supporting multiple supporting efforts simultaneously..
  • Used coreJavaand advancedJava API in implementing business layer with respect to functional requirements
  • Providing the solutions for Development Issues.
  • Code Implementation to complete the tasks.
  • Developed the presentation layer using JSP, JavaScript, HTML, CSS, jQuery.
  • Involved in developingJavaAPIs, which communicates with theJavaBeans.
  • Designed and developed Customer registration and login screens using HTML, JSP, Servlets and JavaScript.
  • Involved in Servlets, Java Bean programming on the server side for the communication between clients and server.
  • Tested and deployed the application on Apache Tomcat.
  • Completely involved in Production support from client requirements to developmental aspects with coding, system optimization and testing.
  • The maintenance and additions of new projects, fields, workflows to HP QC data elements, as needed and as an Administrator of HP QC, set-up and maintain projects and users.
  • Oversee and drive HP Quality Center Upgrades; Plan and control upgrades as appropriate.
  • Setup and Configure HP Quality Center to support UCPath users for each testing cycle including Functional Unit Testing, System Integration Testing
  • Extensively used SQL queries to verify the back end process and prepared test data. Involved in Manual Testing of the various reports developed.
  • Involved in analyzing functional requirements documents for the project.
  • Execution of Manual Test Cases.
  • Identifying the reusability in the application with respect to QTP.
  • Analyzed Test Results / Reports.

We'd love your feedback!