SUMMARY

• 8+ years of IT experience in Quality Assurance/Testing and implementation testing process for business Intelligence solutions Database, OLAP, Client/Server applications.
• 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.
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata
• 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.
• Expert in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Working with Business Intelligence tools Business objectsXIR4, Cognos
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within timeframe.
• Excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS

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

LANGUAGES KNOWN: C, PL/SQL, SQL

DATABASES: 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, DB2

REPORTING TOOLS: Crystal Reports 6.5, Business Objects XIR3/R2/R1/6.0/ 5.1, Cognos 6.5/7.0/8.0

SCRIPTING LANGUAGES: VB Script, Java Script, XSLT, PERL, UNIX Shell Scripting

TECHNOLOGIES: Active X, OLEDB, and ODBC

PROFESSIONAL EXPERIENCE

Confidential, Strongsville, OH

QA Analyst/SQL Backend Tester

Responsibilities:

• Written Test Plan, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using HP ALM
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Writing complex SQL queries for data validation for verifying the Data Mapping Rules.
• Collected requirements and tested several business reports.
• Written Test Cases to compare Source and Target database systems.
• 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).
• Used Informatica workflow manager for session management, database connection management and scheduling of jobs.
• Preventing occurrences of multiple runs by flagging processed dates
• Testing of records with logical delete using flags
• Identifying duplicate records in the staging area before data gets processed
• Tested Standard and Ad - hoc Impromptu Reports
• Tested multi-dimensional cubes using models and implemented incremental updates for Cognos power cubes
• Created Impromptu Reports and modified existing reports as per users requirement
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Tested various Drill-through reports from report to report.
• Performed front-end testing on Data Portal and Executive Credit Risk Dashboard portal

Environment: Agile, HP ALM 11, Informatica Power Center 9/8.6, XML, XSLT, XSD, WinSQL, SQL Server 2008, SQL, TOAD, Oracle 10g, PL/SQL, IBM DB2,, Cognos Series 8.0, MS Access, XML/VSAM/Flat Files, Autosys

Confidential, Tampa, Florida

Test Analyst/SQL Data Validation 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
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• 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.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested Complex data Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• 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.
• Written several complex SQL queries for validating Cognos Reports.
• Tested several stored procedures.
• 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.
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing the UI applications
• Tested Catalog in Impromptu Administrator to create Reports
• Tested Cubes by using Cognos Power Play to analysis
• Worked with Teradata SQL Assistant for data retrieval and data validation
• Worked with business team to test the reports developed in Cognos
• Tested multi dimensional Cubes for reporting using Transformer.
• Used Informatica Designer to test mappings, transformations and source and target tables
• Tested various Drill through reports from report to report.
• Reported operations sum and average, intersection, etc.
• Tested whether the reports developed in Cognos are as per company standards.
• 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 8.1/7.1, Informix, DB2, Java, Cognos 7.0 Series, SQL, SQL Server 2000/2005, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Teradata SQL Assistant, XML, XSLT, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra edit, Rumba UNIX Display, Quality Center 9.0

Confidential, Jackson, MS

Backend Tester/SQL

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Interacted with the end users to define and document data warehouse business requirements as the foundation for database design, data extraction and analysis.
• Created UAT test plan.
• Interpret the System requirements document and create Unit Test Plan and Unit Test specifications.
• Traceability Matrix to track the requirements to the test cases to ensure complete test coverage in the Mercury Test Director.
• Generated Reports and Documented and Communicated test results on daily bases
• Written SQL statements manually to validate data from Database using SQL*PLUS
• Clearly communicated defects with developers and updated comments in Mercury Quality center.
• Executed the regression test cases along with testing new enhancements by using QTP and analyzed results.
• Reviewed Error log files in UNIX box when order fails to load into SQL tables.
• Uploaded Requirements and Excel Test Cases into Mercury Quality Center. Executed Test scripts from Test Lab manually.
• Performed Back end testing by writing SQL statements using SQL Plus and TOAD.
• Tested several Informatica mappings.
• Tested several business reports developed in Cognos.
• Written complex SQL queries to validate the data.

Environment: Cognos Impromptu 7.1, Cognos Power Play 7.1, Cognos Power Play with Excel, QTP 7.2, Cognos Power Play Transformer 7.1 and Informatica, Oracle 8i, PL/SQL, Windows XP, Erwin, Test Director, TOAD, SQL*Plus

Confidential

QA/SQL Tester

Responsibilities:

• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on data Mapping document.
• Written complex SQL queries for querying data against different data bases for data verification process.
• 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 Plans and Test Cases on Mercury’s Test Director Tool.
• Defects identified in testing environment were communicated to the developers using defect tracking tool Mercury Test Director.
• Developed scripts, utilities, simulators, data sets and other programming test tools as required for executing test plans.
• Tested several Ab Initio graphs for each line of business and created test data for the same.
• 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.
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5
• Extensively used Informatica power center for extraction, transformation and loading process.
• 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: UNIX, Mercury Test Director 6.5, SQL *Loader, Cognos 7.0 Series, Oracle8i, SQL Server 2000/2005, Erwin 3.5, Windows 2000, TOAD 7