SUMMARY

• Around 7+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Quality Analysis/Data Mart Design, 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 working in Agile (Scrum), Waterfall, Spiral methodologies
• Expert in Waterfall Lifecycle, AGILE and Iterative project testing methodologies
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices
• Expertise in Defect Tracking, Defect management and Bug Reporting Tools like Quality Center (TestDirector), Project Trak, Rational Clear Quest,Bugzilla, Jira and version control tools like Rational Clear Case
• Knowledge on HP QTP/UTFAutomation using VB Script and Descriptive Programming
• Expertise in designing the test scenarios and scripting the test cases in order to test the application
• 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
• Expertise in Manual, Automation Testing (UsingSelenium)
• PerformedDataCentrictestingto validate the datathat is loaded in to thedatawarehouse is correct as per the defined business rules
• Expertise in developing, documenting, and executing test cases manually as well as generating automated scripts usingSelenium
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata
• Worked on Web Services Testing usingSeleniumIDE, andSeleniumRC Server, Web Driver, Testing and Junit
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
• Seleniumis used to test the application as well as reports
• 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
• 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, 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

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

Testing Tools: Mercury (Quality Center, Win Runner, Load Runner, QTP/UTF, 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

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr. 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
• Worked onQAtesting and associated methodologies and Test case management tool .Used Defect tracking softwareJIRA
• 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 business analyst and developers in setting up test data
• Worked with iterative development environment using Waterfall Model
• Interacted with QA and Development Engineers to learn about work flow, analyzed the test process, and helped develop strategies for testing products and services in a Waterfall environment.
• Developed and maintained automated regression test cases inSeleniumusing Java programming language
• Analyzed software failures, reproduced scenarios and reported bugs viaJIRA
• Testing both Manual &Automationin with HP tool - QTP
• Well versed with various types Software Development methodologies- Waterfall, Agile, RUP, Iterative and Extreme Programming
• Promoted the Test Cases in HPQC usingQTPvb script
• Developed several SQL queries for data retrieval from TERADATA and used every utility available in including MLOAD, FLOAD, FAST EXPORT, BTEQ AND TPUMP
• Extensively test the reports for data accuracy and universe related errors
• Worked on notices and validated PDF notices after executed in RQM
• Tested the functionality of applications usingSeleniumWeb Driver & automated application for Regression testing
• Created, administer, and maintainConfigurationManagementLibrary (CML)
• Maintained and updatedConfigurationManagementLibrary
• 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
• Preparation of High level design and Data CentricTechnical specifications
• Involved in user training sessions and assisting in UAT (User Acceptance Testing)
• Defects identified in testing environment where communicated to thedevelopersusing defect tracking toolHPQualityCenter
• Wrote Scripting usingQTPand Executing test cases in Quality Center
• Extensively worked with automated and performance testing tools QTP/UTF, SOAP UI, Selenium Web Driver, Load Runner, TFS, Quality Center, ALM and Team Track
• 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
• Writing test cases in TestNG and run inSeleniumWeb Driver
• Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status
• Implemented SDLC, QA methodologies and concepts in the Project
• Responsible for testing Business Reports developed by Business Objects
• Experience in creating UNIX scripts for file transfer and file manipulation
• Created and executed Test scripts for system validation and user acceptance testing (UAT)
• 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: Waterfall, Agile,QTP, ALM/Quality Center 11,Selenium, JIRA,XML, XSLT, XPath, XQuery, SQL Server 2008, DTS, SSIS, T-SQL, SQL, Oracle 11g, PL/SQL, IBM DB2, Rational Quality Manager (RQM), Business Objects XI3.1, MS Access, Flat Files, Korn Shell Scripting

Confidential, Charlotte, NC

QA/BI 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
• Reported bugs inJiraand assigned priority to bugs after discussing with team lead and product owner
• Created test data for testing specific Membership functionality
• Experience inautomationusingSeleniumWebDriver tool using Java script
• Extraction of test data from tables and loading of data into SQL tables
• Written several complex SQL queries for validating Cognos Reports
• Built and performed test cases for END to END testing usingJIRAand SQL.
• 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
• JIRAwas used for issue tracking in case of environmental issues
• Involved in all phases of the QA Life Cycle and SDLC, with timely Delivery against aggressive deadlines, with QA methodologies such as Waterfall, Agile, Etc.
• I wrote the script in java language usingseleniumweb driver for functional and regression testing of application as per requirement
• Worked with data validation, constraints, source to target row counts
• Developed automated Test Scripts using QTP
• Worked on Waterfall, and Agile methodologies
• Was involved in design part for Extracting data from different source systems into the target database using IBM Data stage Server 8.1
• Wrote and ran Unix Scripts for batch jobs
• UsedSelenium, Eclipse, Java, TestNG for Testautomationand Validated the back-end data using SQL queries for data integrity
• 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
• 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
• 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: HP ALM/ Quality Center 9.0 Informix, QTP, Selenium, JIRA, DB2, Java, Cognos, SQL, SQL Server 2008, XML, XSLT, XML Spy 2008, IBM AIX 5.3, UNIX, Shell Scripting, WinSQL, Ultra editor, Rumba UNIX Display

Confidential, NYC, NY

QA Tester

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.
• 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
• Extensively used Informatica power center for extraction, transformation and loading process
• 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
• Extracted data from various sources like Oracle, flat files and SQL Server
• Worked on issues with migration from development to testing

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

Confidential, Baltimore, MD

QA Analyst/QA Tester

Responsibilities:

• Analyzed the Business Requirements of the system. Worked with the development team to review project plans, requirements specification, design documents, and computer software
• Analyzed the Functional requirements using Scenarios & DDD(Detailed Design Document)
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse
• Used UNIX to verify the session log files for error and warning details.
• Executed the Test Scripts in TOAD and documented the results in RTM
• Imported data from tables in one schema to CSV files and exported to tables from another schema using SQL* Loader
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc
• Responsible for testing Business Reports developed by Business Objects XIR2
• The reports that were created in Business Objects were testing by running the SQL statements
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables
• Compared query result sets from different database systems using UNIX diff command
• Verified correctness of data after the transformation rules were applied on source data
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments
• Maintained the batch processes using Unix Shell Scripts
• Defect logs were created in Quality Center and coordinated with Development team in fixing the defects
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports
• Wrote complex SQL s to validate target data based on the business requirements
• Used PL/SQL programs for performance testing
• Used SQL and PL/SQL scripts to perform backend database testing

Environment: Quality Center, SQL, PL/SQL, DB2, PL/SQL, Teradata, UNIX Shell Scripting, Toad, Oracle, XML, Autosys, TSO, JCL, VSS, Windows

Confidential

QA Analyst

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs
• Analyzed the use cases given by the business analysts and developed test cases using them
• Responsible for complete manual testing of application under test (UAT)
• Written complex SQL queries for data validation and to verify the extract rules
• Performed black box/functional testing, regression testing on Application Under Test
• Performed manual testing on various modules of the Application
• Generates functional test cases that capture actual code behavior as a deployed application is exercised
• Did extensive backend testing using SQL, UNIX and PL/SQL
• Written PERL scripts for text processing, database connectivity & data parsing
• Written complex SQL queries for data validation and data verification
• Executes the test suite to identify regressions and unexpected side effects
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources)
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, UAT and Regression testing
• Monitors test coverage and achieves high coverage using branch coverage analysis
• Tests individual methods, classes, or large, complex applications
• Tracks how test results and code quality change over time
• Conducted performance and load testing using Load Runner
• Analyzed, reported and kept track of defects using Test Director

Environment: Windows NT, Shell Scripting, MS-Office Tools, SQL, PL/SQL, XML, XSLT, Web Services, SOAP, Manual Testing, Test Director, Load Runner, Oracle, Java, Servlets and Java Script