SUMMARY:

• 8+ years of experience in ETL / BI, Data Warehouse Testing, Manual Testing and Automated Testing and web based client/server applications
• Solid experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Experience using query tools for Oracle, MS SQL, DB2 and Teradata server to validate reports and troubleshoot data quality issues.
• Experience with Agile Methodology.
• Well versed in detecting errors and conducting UAT by designing, developing, and executing test cases
• Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000/7.0, Teradata and DB2
• Performed Backend Database testing on Oracle and MS SQL Server databases, used SQL, PL/SQL queries, triggers & procedures.
• Performed Manual and automated testing using HP Quality center, Quick Test Professional (QTP) and Test Director.
• Worked on various Operating Systems which include Windows 95/98/2000/NT/XP and Linux (RedHat), UNIX (Sun Solaris 9.0/8.0/7.0, IBM AIX, HP UX 11i v1.5/1.6/2.0).
• Strong in developing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Extensive knowledge in regression testing and design documentation.
• Extensive experience in writing SQL and PL/SQL scripts 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.
• Responsible for execution of Batch jobs and population test data for other teams.
• Worked with defect tracking software as bugzilla, JIRA.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Skilled in analyzing business context and requirements for UAT testing purposes
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging, Data integration of operational sources using ETL processes.
• Experience in all phases of Software Development life cycle.
• Excellent communication skills, Good organizational and interpersonal skills, outgoing personality, Self - motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to adapt based on the demands of work.
• 7+ years of experience in ETL / BI, Data Warehouse Testing, Manual Testing and Automated Testing and web based client/server applications
• Solid experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Experience using query tools for Oracle, MS SQL, DB2 and Teradata server to validate reports and troubleshoot data quality issues.
• Experience with Agile Methodology
• Well versed in detecting errors and conducting UAT by designing, developing, and executing test cases
• Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000/7.0, Teradata and DB2
• Performed Backend Database testing on Oracle and MS SQL Server databases, used SQL, PL/SQL queries, triggers & procedures.
• Performed Manual and automated testing using HP Quality center, Quick Test Professional (QTP) and Test Director.
• Worked on various Operating Systems which include Windows 95/98/2000/NT/XP and Linux (RedHat), UNIX (Sun Solaris 9.0/8.0/7.0, IBM AIX, HP UX 11i v1.5/1.6/2.0).
• Strong in developing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Extensive knowledge in regression testing and design documentation.
• Extensive experience in writing SQL and PL/SQL scripts 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.
• Responsible for execution of Batch jobs and population test data for other teams.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Skilled in analyzing business context and requirements for UAT testing purposes
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging, Data integration of operational sources using ETL processes.
• Experience in all phases of Software Development life cycle.
• Excellent communication skills, Good organizational and interpersonal skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to adapt based on the demands of work.

TECHNICAL EXPERTISE:

ETL Tool: Data Stage,Informatica Power Center 9 / 8.6

Reporting Tools: IBM Cognos 8.1/Business Objects XI R2/R3

Database: Oracle10g/9i, SQL Server 2012 / 2005, IBM DB2, Sybase, Teradata 13 and MS-Access

Utilities: Toad, Citrix server, Oracle SQL Developer, SQL Advantage, Putty

Testing Tools: HP Quality Center 9.2 / 10 / ALM, TFS, JIRA, Clear Quest, Rational Clear Case,

WORK EXPERIENCE:

Confidential, St Louis, MO

QA Tester

Responsibilities:

• User Acceptance Testing mainly focused on Legacy applications i.e. 1BR1, 1BT1, 1OW2, 1CRQ, 1IM1 etc.
• Have got chance to work Transformation project from Legacy to New Wire.
• Analyzed User stories and wrote HLTS in Excel.
• Wrote Test Scripts directly in Test Plan and executed those scripts in Test Lab manually using HPALM 12.1 version.
• Worked exclusively with BA and Developer as a team to make sure the demands of correct scripting and testing are satisfied.
• Retested and reproduced the logged defects to ensure that the problem is solved.
• Worked as a team to explain UAT scope, criteria and entry/exit strategy to less trained professionals
• Perform responsibilities of conducting research on IT requirements and business requirements in UAT areas
• Participated daily stand up meeting with UAT Team Lead, Walkthrough online meeting with Product owner, BA, and Developer to make sure everybody in the same page of understanding.
• Responsible for reviewing Test scenarios and Test Scripts to ensure testing criteria is fulfilled.
• Handle the tasks of ensuring that the Pre-UAT activity is performed accurately and efficiently
• Responsible for developing UAT test process and monitoring SIT execution phases.
• Handle the tasks of identifying defects and perform root cause analysis by analyzing data quality issues.
• Written test plans and estimated time frames for functional IT, UAT phases.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Worked in Water Fall as well as AGILE Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Worked with Compatibility Testing for Browser, Printing options for Web Apps.
• Worked with Data Conversion projects for testing data quality after migration.
• Tested Business Objects reports and Web Intelligence reports.
• Identify potential problems, omissions and open issues and attend walkthroughs and attend signoff meetings.
• Provide recommendations on performance enhancements in pre-production and production environments.
• Served as a coach and mentor to the team member regarding how to develop and execute a test plan.
• Validate the business functionality using UAT  Testing.

Environment: Wisdom and Smart Station.

Tools: HPALM 12.1, MS Office (Word, Excel and PowerPoint), Version One and Out Look and BETA.

Confidential, Wilmington, DE

QA Tester

• Tested the ETL process to automate the testing process and also load the test data into the testing tables.
• Tested ad hoc and canned reports for Business objects.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Responsible for UAT project planning like creating testing scenario, test plans, and test scripts
• Handle the tasks of explaining UAT scope, criteria and entry/exit strategy to less trained professionals
• Perform responsibilities of conducting research on IT requirements and business requirements in UAT areas
• Handle the tasks of identifying UAT testers and managing resource plan by coordinating with business stakeholders
• Responsible for reviewing SIT Test Plan to ensure sufficient testing plans
• Handle the tasks of ensuring that the Pre-UAT activity is performed accurately and efficiently
• Responsible for developing UAT test process and monitoring SIT execution phases
• Handle the tasks of identifying defects and perform root cause analysis by analyzing data quality issues
• Written test plans and estimated time frames for functional IT, UAT phases
• Involved in data warehouse testing by checking ETL procedures.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Worked on Informatica DVO tool for Regression Testing.
• Worked in AGILE Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Strong ability in developing advanced and complex 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
• Worked with Compatibility Testing for Browser, Operating, Mobile & Printing options for Web Apps
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Worked with Data Conversion projects for testing data quality after migration.
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD, Teradata SQL Assistant, WinSQL and SQL Plus.
• Tested Business Objects reports and Web Intelligence reports
• Used SQL Loader for data retrieval and querying.
• Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team.
• Used SQL for Querying the DB2 database in UNIX environment.
• Responsible for execution of Batch jobs and population test data for other teams.
• Run batch jobs for loading database tables from flat files using SQL*Loader.
• Identify potential problems, omissions and open issues and attend walkthroughs and attend signoff meetings.
• Provide recommendations on performance enhancements in pre-production and production environments.
• Wrote numerous Pre-and Post-session SQL and UNIX Scripts.
• Used Autosys to do the shakeout whenever a new build is received.
• Performed database testing with SQL queries to verify data integrity using QTP.
• Served as a coach and mentor to the department staff regarding how to develop and execute a test plan.
• Validate the business functionality using UAT  Testing
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Involved in the design of web application using HTML, DHTML, Cascading style Sheets Java script and ASP.

Environment: Oracle 10g, MS SQL SERVER 2005/2008, Query Studio, AutoSys 11, MS Excel, MS Access, MySQL 5.0, Windows 2007, SQL Server 2008, HP ALM Quality Center 11.0, HP QTP 11.0, T-SQL, SQL, TOAD, Flat Files, UNIX Shell Scripting

Confidential, Boston MA

QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Tested ad hoc and canned reports for Business objects.
• Used Quality Centre for tracking the defects.
• Tested all data reports published to Web including dashboards, summarized, master-detailed and KPI’s.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Responsible for assisting senior engineers in developing test estimation, scope and test plan for UAT
• Perform the tasks of designing and developing test procedures to meet business requirements
• Responsible for driving E2E Test scenarios efforts and in identifying test data for UAT
• Handle the tasks of helping the organization staff in planning data sets for UAT
• Responsible for drafting complex SQL queries and perform allocation testing from front end / user interface
• Assigned the tasks of preparing test results as well as gather test results from other testers in standardized format
• Tested existing Data web application from classic ASP and VB6.0 to VB.NET, ASP.NET, C# (.NET Framework 3.5), SQL Server 2005.
• Develop Functional/Regression automated testing solutions using QTP, traditional QTP framework, and/or Data Driven techniques.
• Written several complex SQL queries & PL/SQL stored procedures for validating Business Objects Reports
• Responsible for verifying the log files using UNIX and database for the submitted application.
• Coordinated and Interacted with Development team and actively participated in status meetings during the defect life cycle, reported the bugs and maintained their status.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Extracted data from various sources like Oracle, flat files and DB2.
• Tested SCD tables Type 1, Type 2 and Type 3.
• Wrote and ran UNIX Scripts for batch jobs.
• Create the QTP Automated Test scripts for various modules.
• Tested stored procedures & views in MS SQL 2000/2005.
• Preparing and supporting the QA and UAT test environments.
• Tested different detail, summary reports and on demand reports.
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute
• Functional Testing, Regression Testing and Acceptance Testing
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: PL/SQL, SQL, Teradata V2R5, TOAD 9.2, Oracle 9g, DB2 UDB, DB Artisan 8.5.2, HP Quality Center 10.0, AutoSys, Bugzilla, MS Access, MS Excel, MS PowerPoint, XML, XSD, XQuery, XPath, XSLT, XML Spy 2010, HP QTP 9.5, Quality Centre, Unix Shell Scripting, Windows NT/XP//2003.

Confidential, Richmond VA

QA Tester

• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Worked in an Agile technology with Scrum
• Written several UNIX scripts for invoking data reconciliation
• Reported bugs and tracked defects using Quality Center
• Executed SQL queries to perform backend database testing and verify/modify user data.
• Enhancing the QTP QuickTest Pro Scripts with GUI checkpoints, Database Checkpoints, Parameterization, User Defined Functions (adding functional features) and Synchronizations.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Responsible for Functional, Regression, UAT Testing.
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files
• Extensively used Informatica power center for extraction, transformation and loading process.
• Performed UAT regression testing after the defects were fixed.
• Tested Cognos reports to check whether they are generated as per the company standards
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Environment: Informatica Power Center, Cognos 7 Series, QTP, SOAP, Windows NT, Test Cases, Test Scripts, Test Plans. Oracle 8i, SQL Server, Agile, SQL, PL/SQL, Unix,SQL*Plus, Quality Center, TOAD and Shell Scripting.

Confidential, Jersey City

QA Tester

• Tested the defects in Mappings and Work flows. Used Quality Centre for tracking the defects.
• Analyzed and created the bug tracking reporting and summary report in the Quality Center
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Performed (UAT) User Acceptance testing exclusively in an Agile environment.
• Experienced using query in Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Validated format of the reports and feeds.
• Perform GUI, Functionality, Integration, Regression and UAT
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Worked on issues with migration from development to testing.
• Validated cube and query data from the reporting system back to the source system.

Environment: Informatica 8.1, SQL *Loader, QTP, PL/SQL, SQL, Stored Procedures, Test Cases, Test Scripts, Test Plan, Oracle8i/9i, SQL Server 2000/2005, Erwin 3.5/4.1, Quality Center, Windows 2000, TOAD.