SUMMARY

• Over 7 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Worked with IT Operations to ensure test environment readiness.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Strong understanding of different methodologies like SDLC and STLC
• Expertise in testing mobile applications using Emulators and Real Devices.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in Black box testing with a complete QA cycle- from testing, defect logging and validation of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Have knowledge on the web services
• Experience in Retail, Financial, Mortgage, Brokerage, and Securities industries.
• Experience with Agile, waterfall Methodologies.
• Experience in automation testing utilizing QTP and Rational Clearcase
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Experience in testing and writing SQL and PL/SQL statements.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Well versed in analyzing the XML files.
• Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Strong ability to write and maintain extensive test strategies, plans, cases and scripts
• Strong Problem Analysis & Resolution skills and ability to work in Multi-Platform Environments like Windows and UNIX.
• Experience in Installation and Implementing Mercury Interactive Test suite.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in testing XML files and validating the data loaded to staging tables.
• Good understanding of latest trends in Quality Assurance processes and methodologies.
• Good experience in Hyperion Essbase 11.x/9.x/ 7.x, Microstrategy 9.0, Cognos 8.0 and dashboard testing.
• Excellent analytical, multi-tasking, problem-solving, time-management & communication skills with particular emphasis on clearly communicating & documenting detailed Test Requirements & Tests

TECHNICAL SKILLS

ETL Tools: Informatica 8.6/8.1

Reporting Tools: MicroStrategy 9.x, Hyperion Interactive Reporting 9.3, Cognos, Hyperion Essbase 11.x/9.x/7.x, Hyperion Financial Reporting 11.1.2.2, Smart view 11.1.2.2, OBIEE

Testing Tools: QTP, Mercury Quality Center, Rational Clearcase

RDBMS: Oracle 10g/9i, MS SQL Server 2008, DB2, Teradata SQL Assistant, MS Access 7.0

Programming: UNIX, PL/SQL, Teradata SQL, SAS

Web Technologies: JavaScript, HTML 4.0, Java, XML

Environment: UNIX, Win 3.x/95/98

Devices: Windows Mobile (Device and Emulator), iPad

Other Tools: Visio, SAS 9.2

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Data Analyst/ ETL Tester

Responsibilities:

• The goal of the project is to migrate operational and analytical data stores, including Information one and EDW from DB2 database using Abinitio to Teradata.
• Involved in the requirements gathering meetings
• The data has been migrated by the development team and is available in Teradata at attribute level in all QA, UAT and production environments.
• The attributes are tested after each month data load based on the logic provided in the BRD document by connecting to Teradata using SAS
• The testing results obtained are updated in the HP ALM which is used for tracking
• Actively interacting with Clients to discuss the testing strategy and providing suggestions at each scenario level
• Source to Target documentation provided by IT is used if any discrepancy in the data is observed during testing
• In-depth analysis of the mismatches are done and defects are raised in ALM
• Involved in the Defect Status calls, to discuss the root cause of the defects and tracking them
• Provided high level compare results for attributes for all the servicing systems
• Involved in the analysis of data quality issues provided by the Data Stewards
• Created backup datasets in SAS of every month, prior to the new data load that occurs next month in order to avoid changes to previous month data that might happen due to the data load
• Involved in the unwinding of the final reports in BCBS project
• Coordinate with the business user to assure BRD/ Functional specification documents are updated as needed throughout the process
• Coordinated with SME's to capture the data elements and their relation with the business name
• SQL codes and Excels provided by the business owners are processed in order to identify the main source of reports from which they are generated

Environment: SAS 9.2, Teradata SQL Assistant V13.1, HP Quality Center 11.0

Confidential, Cumberland, RI

QA Analyst

Responsibilities:

• Involved in testing of OBIEE and Hyperion web based applications.
• Validated Hyperion reports using Smart view
• Highly Knowledgeable in all phases of testing life cycle, including Requirements review, test planning, test case design, test execution, defect tracking, defect management
• Developed Requirement Traceability Matrix to keep track of all the requirements and associated test cases
• Performed Positive, Negative and Black box testing on the application
• Manually verified the validity of the failed test cases.
• Prepared user manual and performed user acceptance testing
• Involved in Security testing for different LDAP roles.
• Involved in Parallel testing to verify the data in the new and old application
• Validated the source data using SQL Server
• Validated the reports in OBIEE at different aggregation levels and also based on time hierarchy
• Loaded the financial data from General Ledger using Financial Data Quality Management
• Involved in adjusting the financial data using the Journal Entries
• Entered data into data forms using workspace and Smart View
• Assisted business team in UAT testing
• Proficient in scheduling test cycles, testing the product, documenting the reported bugs properly and tracking the bugs using HP ALM Quality Center
• Verifying code fixes and coordinating testing efforts with developers.

Environment: Hyperion 11.1.2.2, Smart View 11.1.2.2, FDM 11.1.2.2, OBIEE 11, Quality Center 11, SQL Server 2008, Windows XP.

Confidential, Atlanta, GA

ETL\ QA Analyst

Responsibilities:

• Involved in the testing of JAVA based windows mobile application (Store Walk Mobile Project).
• Mobile Testing included Windows handheld device and Emulator testing.
• Validated SWM application on the iOS platform (iPad).
• Validated the data on the application against the source system Teradata using SQL queries.
• Determine level of testing required to validate new or revised system capabilities.
• Based on the design specification and business requirements developed the scope of the testing.
• Developed Test Plans and developed various test scenarios and test cases with input from assigned Business Analyst and data architect.
• Report accurate testing status and test summary reports.
• Continuously improve test models, Test data and Test processes based on lessons learned.
• Followed waterfall and AGILE development methodology and adhered to strict quality standards in requirement gathering.
• Coordinated component, System testing with appropriate technical groups and release management and documented testing procedures and findings.
• Worked on the web services to verify the data returned by XML.
• Extensive experience in Functional, system, Integration, Regression Testing, User Acceptance Testing.
• Reconciled test results from different tests and different group’s accesses readiness and deviation of product/project performance based upon test results and product specifications.
• Worked with data validations, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Used SAS to retrieve data from the source
• Involved in extensive DATA validation using SQL queries and back-end 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.
• Performed Black System testing, Regression and end-end testing.
• Developed test reports and participated in testing prioritization and archived test results and user signoff.
• Developed detailed Test Plans and Test Cases in Quality center and executed them
• Reported bugs and tracked defects using Mercury Quality Center 9.2/10.0.
• Maintained the Traceability Matrix between Project release, Requirements, Design Components, Test Cases and Defects.
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Involved in automation of test cases using QTP for regression testing.
• Validated various Reports, dashboards, Custom filters, Prompts, Custom groups, Consolidations and Drill paths developed in Microstrategy.
• Hyperion reports are validated initially during the migration to Microstrategy.
• Worked with the Essbase during the report validation process.
• Validated the data in the reports and dashboards using SQL queries against the database.
• Worked with the development team in testing the Automation, Implementation, backout, backup and recovery plans.
• Provided coordination of Quality Assurance offshore for the assigned initiative.
• Tested the ETL jobs and other ETL Processes
• Participate in weekly meeting with the management team and walkthroughs

Environment: Microstrategy 9.0.2, Hyperion, Essbase, SAS, Teradata SQL Assistant 13.0, Web services, Quality Center 9.2/10, QTP, Windows mobile device, Emulator, iOS, SQL Server 2008, Unix, Windows XP.

Confidential, Wilmington, Delaware

Data Warehouse Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Performed complex defect reports in various environments like UAT, SIT, and QA etc 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.
• Designed and kept track of Requirement Traceability Matrix
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Automated tests using Clearcase.
• Worked with the co-testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Used Quality Center for defect tracking.
• Performed data quality analysis using advanced SQL skills.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• 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
• Extensively used the Report Inspector tool to change, multiple reports database schemas, scheduling multiple reports, deploying and publishing.
• Testing the reports and maintenance of daily, monthly and yearly.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Implemented and maintained tools required to support data warehouse testing.
• Performed the tests in both the FIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Automated application using QTP.
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center

Environment: SQL, PL/SQL, HP Quality Center 10, Rational Clearcase, Hyperion Essbase 9.x/7.x, MS Excel, Teradata SQL Assistant, XML, Informatica Power Center, QTP

Confidential, Bristol, CT

ETL/ QA Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Reviewed Informatica mappings and test cases before delivering to Client.
• 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.
• Written several UNIX scripts for invoking data reconciliation.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Involved with ETL test data creation for all the ETL mapping rules.
• 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.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: Informatica Power Center 8.1,PL/SQL, SQL Server Analytical Server, Oracle 9.2, HP Quality Center 9.2, BI Reports, MS Access, MS Excel, Microsoft Share Point, Windows NT/XP//2003