SUMMARY

• Software Test Engineer with progressive experience in ensuring Quality Data Systems. Focused experience on Business Intelligence (Database, ETL, Datawarehouse& Reporting) Projects. Quick learner with strong communication skills and high level of motivation.
• Over 6+ Years of experience in System Analysis, Development and Quality Assurance &Testing.
• Worked in Test tools like Quality Center/Test Director, Quick Test Pro.
• Strong experience in Software Development Life Cycle and Test Methodologies like Agile, Waterfall and Iterative.
• Strong in Analyzing Business Specs and Developing Test Plans, Test Scripts and Test Cases and Execute them.
• Involved in Manual and Automated Testing of applications on Windows and UNIX Environment.
• Experience with structured QA Methodology and QA Process to ensure the Quality Assurance Control.
• Extensive experience in White Box and Black Box Testing.
• Extensively worked with all phases of testing including creation of Test plans, Test Strategy, Test case specifications, Test execution, Defect tracking, Resolution, Documenting and Reporting.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs.
• Experience in performing GUI, functional, integration, system, regression, Performance testing and user acceptance testing in Client/Server, and Web based applications.
• Experience in testing Extract, Transform and Load (ETL) processes, Reporting and OLAP applications.
• Experience in Testing Mainframe Applications involving COBOL, CICS, JCL, QMF, FILE-AID and MVS.
• Extensive knowledge in gathering and understanding BRDs (Business Requirements Document), FRDs (Functional Requirements Document), SRS (Software Requirement Specifications) and Used cases.
• Good Experience with Microsoft Office Suite - Microsoft Word, Excel, PowerPoint, Visio and MS Access.
• Involved in testing the MicroStrategy Reports, Report Service Documents and dashboards by writing complex SQL queries
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in testing ETL methodology for supporting Data Extraction, Transformations and Loading process in a corporate-wide-ETL solution using Informatica Power Center 8.x/9.1.x/9.5/9.6.1.
• Experience in testing database applications of RDBMS in ORACLE and MS SQL Server.
• Good knowledge on Use cases, Configuration Management.
• Experience in Micro strategy reports including conditional formatting testing and threshold testing.
• Worked in Medium-paced as well as Fast-paced Projects with successful completion.

TECHNICAL SKILLS

ETL, BI Tools: INFORMATICA Power Center 9.6.1/9.5/9.1/8. x, Event Engine( Confidential Internal Tool), MicroStrategy 9.x, BO

Testing tools: HP Quality Center 10.00, Test Director, Quick Test Pro (QTP)

Databases: ORACLE, MS SQL Server, DB2 and Teradata

Operating Systems: MS Windows NT/Server 2003, MS-DOS, UNIX

Languages: HTML, CSS, Java Script, C,C++,COBOL,JCL

Development Tools: SQL*PLUS, TOAD, SQL NAVIGATOR,PL/SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr.ETL/BI Tester

Responsibilities:

• Involved in understanding and analyzing requirements to identify key functions and determining the scope of the application.
• Interacted with the Subject Matter Experts, business analyst and the developer regarding the application requirements and enhancements.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Performed complex defect reports in various environments like UAT, SIT,TEST and PROD to ensure the proper delivery of the application into the production environment.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Reviewed and approved database modifications.
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Validated and helped MicroStrategy team when they are upgrading from 9.4.1 to 10.4 by verifying MicroStrategy web functionalities, some key reports and dashboards.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments.
• Reported bugs and tracked defects using Quality Center.
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project.
• Published defect reports and defect metrics on daily basis
• Tested Micro strategy reports for Report layout, Attributes/Metrics, Sub Totals & Grand Totals, Drilling options, Metric Calculations, Drill Maps, and Security filters.
• Prepared release notes with help from developers for every release.
• Extensively worked with Metrics, Filters, Transformations, Custom Groups, and Consolidations using Micro Strategy tools
• Used Informatica Power Center Workflow Manager to run Workflows and Informatica Workflow Monitor to monitor workflows and review session log.
• Used import and export facilities of the application to download/upload XMLs of failed test cases so as to re-verify.
• Coordinate and tested the deployment procedure for Micro Strategy changes to the Production
• Executed the Test cases for Micro Strategy to test the reports, Documents and Dashboards.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
• Tested different detail, summary reports and on demand reports.
• Tested the entire data reconciliation process for multiple source and target systems.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.

Environment: Informatica 9.6.1, Micro Strategy 9.4/10.4, SQL, PL/SQL, Flat Files, Manual Testing, UNIX, Shell Scripts, HP Quality Center 11.x/12, Oracle 11g/12c.

Confidential, Linthicum Heights, MD

ETL/BI Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Wrote Test Plans, which detailed the testing scope, testing requirements, success criteria, milestones and necessary resources.
• Worked with ETL tool to design mappings to move data from source to target database-using Informatica to understand the functionality.
• Involved in full life cycle Testing of ETL Data warehouse and reporting environment.
• Worked on Informatica Power Center repository server and analyzed the workflows.
• Validated the MicroStrategy reports by using the SQL Queries.
• Written Complex SQL Queries to Check the data loads in Different Stages.
• Tested MicroStrategy reports for different scenarios like slice and dice, drill down and drill up.
• Executed automated tests in appropriate test regions in support of unit, integration, functional, and regression testing using Quality Center.
• Involved in testing Micro strategy reports including conditional formatting testing and threshold testing.
• Experienced in Defect Tracking and fixing using tools like Quality Center.
• Tested pro-active reports and delivered them to end users using MicroStrategy Narrow Cast server
• Tested reports that had Object prompt and posted on MicroStrategy Web.
• Validating the report elements impact when there are any changes to data structures (DDL) in database.
• Validating the report attributes and Metrics data if the business requirements in BRD are met.
• Worked with developers in De-bugging the issues for workflows failures by analyzing the data and logs.
• Performed Back End testing by writing SQL queries to che ck data integrity, row-counts and measures.
• Used Quality Center to track application issues, requests and bug reports.
• Participated in weekly status meetings to discuss the status of the project, review meetings to discuss the bottlenecks and its resolutions.

Environment: HP Quality Center 11, Informatica Power Center 9.1,MicroStrategy 9.4.1,QTP,Manual Testing, MS Windows NT, Oracle 11g, SQL server 2008, MS Office, UNIX.

Confidential, Dallas, TX

QA Analyst

Responsibilities:

• Analyzed user requirement document and developed test plan, which includes Traceability matrix, test objectives, test strategies, test environment and test cases
• Attended requirements and design meetings, review and analysis of requirements and design documentation.
• Developed and implemented test methodologies, test plans, strategies, test specifications test cases, test scripts and test matrices as per the requirements.
• Performed Validation testing on the application navigation for various scenarios and reported the errors
• Worked with Datawarehouse developers who extensively used Informatica, ETL tool to design mappings to move data from source to target database-using Stages to understand the functionality.
• Performed Functional testing, System testing and Regression testing of the application.
• Created Test cases and Test plans for Functional testing, Black box testing and White box testing.
• Automated test scripts using QTP and also executed manual test scripts.
• Performed database testing, Suggested performance tuning techniques for ETL.
• Used Quality Center for defect tracking and versioning documents.
• Performed back end testing using SQL.
• Involved in the design of Test Plan and developing Test Cases based on business requirements using QTP.
• Participated in status and defect tracking meetings and responsible for maintaining bug log
• Written Complex SQL Queries to Check the data loads in Different Stages
• Participated testing in ETL mappings/Jobs, based on the customer requests for Siebel Analytics.
• Performed Positive & Negative Testing.
• Used LLD/HLD in testing the reports to identifying the actual database columns used in the report to write validation queries based on the warehouse table information.
• Experience in testing ETL mappings using ETL Mapping document.
• Checked the data integrity from Legacy systems to Oracle.
• Attended regular walk thorough, project meetings and weekly team meeting.
• Performed Data testing, Transformation testing, Business rules and Data quality.
• Performed Package Validation and file validation.

Environment: HP Quality Center 10, Informatica Power Center 8.5.X/9.1, MicroStrategy 9.1,QTP,Manual Testing, MS Windows NT, Oracle 10g, SQL server 2008, MS Office, UNIX

Confidential

QA Tester

Responsibilities:

• As Software Quality Assurance Engineer, involved in SQA Analysis, Design, and Testing of the application.
• Developed test plans, test cases (test scenarios), test steps and test scripts.
• Involved in manual testing and Automated testing using Quick Test Professional.
• Designed and developed test scenarios and test steps for putting the application on manual testing.
• Involved in Black Box testing (Functionality, GUI Testing).
• Involved in performing different types of testing Performance & Load, Regression, Data Driven and Validation testing.
• Enhanced test scripts with regular expression to enable Quick Test Pro to identify objects and text strings with varying values.
• Documented manual test cases corresponding to business and functional requirements.
• Documented and communicated test results using Test Director.
• Involved in database testing by writing and executing SQL queries to ensure that data entered has been uploaded correctly into the database.
• Performed manual testing by executing the test scripts.
• Performed performance testing of the web application using Load Runner to check the stress of the server.
• Generated the detailed reports of the Bugs, Pass-Fail report and comparison chart.
• Worked with development team to ensure ‘testing issues’ are resolved on the basis of using defect reports.

Environment: Manual testing, Quality Center, Informatica Power Center 8.5.x, QTP, XML, TOAD, Event Engine( Confidential internal ETL tool),Oracle 9i/10g, SQL, PL/SQL, Windows, Teradata.

Confidential 

QA Tester

Responsibilities:

• Involved in testing various Mainframe and Web applications manually.
• Involved in writing Test Plans, Test Cases and Test Scripts.
• Tested the web applications functionality, GUI and hyperlinks.
• Worked with batch jobs (JCL) and validated the reports.
• Worked with SPUFI and QMF to test the DB2 database and File-aid to work with files.
• Participated in System, Regression and Acceptance Testing.
• Worked with all levels of management and resolved the issues found.
• Generated the XML test files.
• Tested the CICS screens.
• Use SQL & PL/SQL to test backend functionality.
• Used Test Director for defect tracking and participated in Bug reporting and reviews.

Environment: Java, Java Script, HTML, XML, MVS, VS COBOL II, CICS, DB2, JCL, SPUFI, File-Aid and VSAM.