SUMMARY:

• 8+ years of Software Quality Assurance (QA) experience testing Data Warehouse and Database Testing.
• Solid Back End Testing experience by writing and executing SQL and PL/SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Standardization, Data Verification and identifying data mismatch.
• 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.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designin Erwin in Client/Server and distributed applications development.
• Worked on Waterfall, RUP and Agile methodologies.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within timeframe.
• Depth knowledge of writing SQL queries using various Joins, System and User Defined Functions
• Expert in writing SQL queries and Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron - jobs for ETL Loads
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Extensive experience in working with databases including Oracle 10g/9i/8i, MS SQL Server 2008/2005 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.
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows XP,NT/95/2000, OS/2, Sun Solaris 2.6/2.7,Linux 6.X/7.X/8.X

LANGUAGES KNOWN: C, PL/SQL 8.x/2.x, SQL*Plus, SAS 9.1/8.1

RDBMS: Oracle 7.X/8/9i/10g, Teradata V2R6, MS SQL Server 6.5/7.0/2000, MS Access 7.0/ 97/2000, SQL Server 11.x/12.0

RATIONAL TOOLS: Requisite pro, clear case, clear quest

SCRIPTING LANGUAGES: VB Script, Java Script, XSLT

DATABASES: IBM DB2 8.x, Oracle 9i/10g, Teradata V2R6, Sybase 12.3, SQL Server 2000/2005, Netezza NPS 8050

TECHNOLOGIES: Active X, OLEDB, and ODBC

WEB SERVERS: Java WebServer2.0, Netscape Enterprise Server, Web Logic 6.0.

DATAMODELLING TOOLS: Erwin 3.5.1/4.x, Designer 2000

DATAWAREHOUSING: Informatica 8.6/7.1, Ab initio.

PROFESSIONAL EXPERIENCE:

Confidential, Chester brook, PA

DW/QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Involved in understanding Logical and Physical Data model using Erwin Tool.
• Written Test Plan, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center 10.0
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Worked with Decision Table Test Design Technique for various test actions
• Designing and creation of complex mappings using SCD Type I, Type II and Type III involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Collected requirements and tested several business reports.
• This work will include loading of historical data onto the Teradata platform, as well as reference data and metadata.
• Performed Functional Testing and Backend Testing using the database comparable results Manually
• Worked on Execution Tracker, Test Design Tracker & Defect Metrics.
• Wrote complex SQL including working with Joins, Date Functions, String Functions,
• Did complex data validation using SQL queries.
• Performed the Backend Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
• Vigorously worked on Manual Testing by writing the Test Cases and executing the Test Scripts for various scenarios.
• Experience creating Requirement Traceability Matrix for Status report
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005
• Extensively used Complex SQL queries and UNIX commands to first verify the data at file level and then at database level.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Independently designed and developed project document templates based on SDLC methodology
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• 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
• Tested multi-dimensional cubes using models and implemented incremental updates for power cubes
• Extensively used joins and sub Query’s and functions for validating data.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: HP Quality Center 10.0, Unix, Teradata V2R6, Teradata SQL Assistant 7.0, T-SQL, SSAS,SSRS, SQL Server 2005, Oracle 10gi, PL/SQL, IBM DB2, WinSQL, Java Scripts, SOAP, MS Access, XML/ Flat Files

Confidential, Atlanta,GA

DW QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Clear Quest
• Involved in developing detailed test plan, test cases and test scripts using Clear Quest for Functional and Regression Testing.
• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing, Sanity, Regression and end-end testing
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Used Teradata SQL to View and sort the results by column and save them to a file;
• Used Teradata SQL to save queries to a file so you can run them automatically from the same file in the future.
• Developed and involved in both Manual Testing and Automation Test scripts based on Use cases developed.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Build up SQL queries to get data from both source and destination and to compare them in the test bed.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Performed the Backend Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Detailed repeatable end to end test cases for application, interviewed developers to gain detailed information on complex calculations and backend exception processing in order to validate the back end utilizing SQL Plus
• An extensively used Complex SQL statement for retrieving data using TOAD and it is used in TSL scripts
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables and verified with joints like inner join, left join, right join.
• Tested several stored procedures.
• Extensively involved in Identifying defects and logged/tracked them using bug tracking tool Rational Clear Quest.
• Created Reusable actions for scenarios using QTP
• Used Rational Clear Case and Clear Quest as Configuration Management and Change control tools.
• Worked with Equivalence Partitioning and divided the input data into various partition of data based on test case condition.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing the UI applications
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: DB2, Java, SQL, SQL Server 2000/2005, Rational Requisite Pro, Rational Clear Quest, Teradata V2R4, Teradata SQL Assistant 7.0, XML, XSLT, IBM AIX 5.3, UNIX, Shell Scripting, QTP, Quality Center 8.2

Confidential, Jersey city, NJ

QA Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Interacted with senior peers or subject matter experts to learn more about the data.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Batch testing development and execution and done analysis of batch works.
• Handled batch and the online projects.
• Assisted customers in troubleshooting issues with their applications in Autosys.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Designed the data flow diagrams using VISIO.
• Drafted Test Plan for flow of data from front end to back end legacy applications
• In a team environment, planned testing strategy for end to end flow through the system to link the front end functionality to the back end
• Wrote test procedures for back end validation via functional specifications
• Prepared SQL scripts for test data preparation for Back End functionality testing
• 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.
• Used Quick Test Pro to write the automated test scripts by using various actions and reusable actions.
• Used reusable actions with utilizing the flexible functionalities in Quick Test professional
• Worked with SOAP UI for testing Web Services
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
• Written Test Plans and Test Cases on Mercury’s Quality center.
• Defects identified in testing environment were communicated to the developers using defect tracking tool Mercury Quality center.
• Extensively used Informatica power center for extraction, transformation and loading process
• Tested a number of complex ETL graphs, transformation logic for both full load and daily data loads.
• Creating test cases for ETL graphs and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/SIT/QA/UAT/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.
• Reported bugs and tracked defects using Quality center.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.

Environment: UNIX Shell Scripting, SOAP, SOAPUI, Web Services, Informatica Power Center 7.2,Mercury Quality center, SQL *Loader, Cognos 7.0 Series, Oracle8i, SQL Server 2000/2005, Erwin 3.5, Windows 2000, TOAD 7

Confidential, Richmond, VA

SQL Tester

Responsibilities:

• Participated in Business Requirements gathering with business and user groups.
• Written several complex PL/SQL statements for various business scenarios.
• Analyze data using SQL, Excel, UNIX and data testing tools.
• Loaded data from operational data store (ODS) to data warehouse tables by writing and executing foreign key validation programs to validate where exactly star schema appears, with fact tables and dimensions/lookup tables.
• Writing Triggers enforcing Integrity constraints, Stored Procedures for Complex mappings, and cursors for data extraction.
• Worked extensively with mappings using expressions, aggregators, filters, lookup and procedures to develop and feed Data Mart.
• Did data parsing, text processing and connecting to the database using PERL.
• Developed UNIX Shell scripts to automate repetitive database processes
• Identify the primary key (logical / physical ) and put update or insert logic
• Deleting the target data before processing based on logical or physical primary key
• Design and execute the test cases on the application as per company standards

Environment: Oracle 7.0, SQL*Plus, SQL, Quality center, SQL Server 2000, T-SQL, SQL, PL/SQL, Visual Basic 6.0, Windows 95, XML, XSLT, XSD, UNIX, Korn shell scripting, PERL, MVS, JCL, ISPF, VSAM Files, OS/390