SUMMARY:

• Over 7 years of IT experience in the Analysis and Testing of Business Intelligence solutions, Data Warehouses, Data Marts, ETL, OLAP, Client/Server applications, Web - based applications in Insurance, Finance, Health Care, Mobile and Retail domains.
• Excellent QA experience in all phases of Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) with good working knowledge of QA methodologies, disciplines, tasks, resources and documenting.
• Experience in Integration, Functional, System, Regression, SIT, Black Box, White Box and coordinating User Acceptance Testing (UAT).
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification.
• Experience in creating Source to Target Mapping documents.
• Worked with many ETL tools like Informatica Power Center 7.1.3/8.2/8.6.1, Data Stage 7.5.1/8.0.
• Experience on working with HP QC (Quality Center), WinRunner, Rational Tools - Rational Clear Quest, Rational Clear Case, Rational Requisite Pro and Telelogic DOORS.
• Extensive experience in developing Test Plans, Test Scenarios, Test Strategies, Test Cases, Test Reports and RTMs.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experience in Business Intelligence testing in various reports using Cognos , OBIEE, Business Objects and Crystal Reports.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Have solid experience on database query tools such as TOAD, SQL Navigator, Teradata SQL Assistant, Rapid SQL, and SQL Plus.
• Experience is testing the Reports for data validation and cosmetic content.
• Experience with using Hadoop as an open-source framework to store and process big data in a distributed environment.
• Good Experience in testing Initial (Reconcile) and Daily (Delta) ETL loads.
• Experience working in UNIX environment and good Confidential file management using vi editor.
• Experience in maintaining the test environments; involved in requesting the deployments, requesting data loads, data base backups, restarting the servers, trouble shooting issues.
• Extensively worked with batch scheduling tool Autosys to run and monitor the ETL and batch jobs.
• Experience in meeting with Business Analysts and End Users to define, document and review functional and technical requirements.
• Have experience working as execution support for Autosys Scheduling Team in 24x7 shifts.
• Excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.x/7.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Ab-initio

BI & Reporting: Business Objects XIR3/R 2/6.5/6.0/5.0, Hyperion, Cognos reports, OBIEE, BO Developer Suite 6.0/5.0 (Designer, Web Intelligence, Broadcast agent, Supervisor, Module).

Testing Tools: QTP, Test Director, Quality Center

Databases: Oracle 10g/9i/8i/7.3, TFS, MS SQL Server 2008/2005/2000/7.0/6.5, IBM DB2, Netezza, Teradata V2R6, MS Access

Job Scheduling: Autosys, BMC Control M

Operating System: UNIX (Sun Solaris 9.0/8.0/7.0, HP-UX 11i v1.5/1.6/2.0, IBM AIX), WINDOWS 95/98/2000/NT/XP, Linux, MS-DOS

Web Service Tools: SOAP UI, Hadoop

Languages/Utilities: SQL, PL/SQL, SQL Developer, TOAD, Quest Central for DB2, XML

PROFESSIONAL EXPERIENCE:

Confidential,Chicago, IL

Sr QA BI Tester

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
• Responsible for planning and directing Quality Assurance and Software change control policies.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
• Coordinated in setting up Test Environments and Test Plan needs with team members.
• Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.
• Executed Test Cases using positive and negative data in Quality Center’s Test Lab and reported results and defects using Quality Center’s Defects tool.
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Executed the test scripts against Teradata source and validated the rules according to mapping documentation.
• Testing and validation of the developed Informatica mappings.
• Worked with Testing of Flat File and XML data.
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Writing complex SQL and PL/SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle. Validated all the web services by testing the WSDLs using SOAP UI.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Tested Cognos Reports according to the business requirements.
• Exclusively used Analysis Studio and Report Studio to test the Cognos Reports .
• Performed Analysis on Data using Netezza (for structured data).
• Performed System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix with requirements versus test cases.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Involved in identifying the defects and developed Defect Tracking report using HP Quality Centre, which involved bug life cycle.
• Provided daily and weekly status reports.

Environment: Quality Center 9.0, Informatica Power Center 9.1/8.6, SOAP UI, Erwin, Ms Excel, Oracle 10g, SQL, PL/SQL, Teradata utilities, Cognos, IDQ, TFS (Team foundation server), TOAD 8.0, UNIX, XML

Confidential,San Ramon,CA

ETL QA DWH Tester

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tested customized and OBIEE reports with Metrics and Filters for Business analysis using Desktop intelligence with features of Drilling options drill up, drill down and drill anywhere .
• Tested the XMLs feeds received from another source, which is a third party for data consistency.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Tracked defects to closure by coordinating with the dev team.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and coordinated integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.
• Worked with the DSO team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
• Prepared test data to cover all the test scenarios.
• Experience in using Hadoop for big data and storing the data.
• Prepared UNIX scripts to run the informatica ETL jobs from command line.
• Maintained the entire test cases in HP Quality Center and logged all the defects into the defects module.
• Provided the management with weekly QA documents like Test metrics, Daily status reports, Test schedules and Test Exit Report.

Environment: Oracle 10g, SQL Developer, SQL Server 2008, TOAD, Informatica Power Center 8.6.1, HP Quality Center, PL/SQL, Java, Hadoop, UNIX, Putty, Session log files, Flat files, OBIEE, XML files, Remedy, SnagIT, CompareIT, MS Office, Clear Quest (CQ) and Clear Case.

Confidential,Baltimore, MD

ETL QA DWH Tester

• Analyzed the business requirements, system requirements, and data mapping requirement specifications, interacting with client, developers and QA team.
• Written Test Plans, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Written complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Tested Metadata of tables including the data types, constraints and default values on the columns.
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, trouble shooting issues.
• Used Toad to run SQL queries and validate the data loaded in to the target tables.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Involved in Functional Testing, Regression Testing, Sanity Testing, Ad-hoc Testing and User Acceptance Testing.
• Responsible to test the functionality of Ab Initio graphs.
• Responsible for testing Initial and daily loads of ETL jobs.
• Involved in validating various SSIS and SSRS packages according to functional requirements.
• Involved in preparation and maintenance of the Requirement Traceability Matrix (RTM) to measure the progress, test matrix and test script review.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• Tested the ETL AB Initio mappings and other ETL Processes (Data Warehouse Testing)
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Written several complex SQL queries for validating Business Objects Reports.
• 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 the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2005 and Oracle to load into the Oracle data warehouse
• Extensively used Rational Clear Quest to track defects and managed them.
• Tested whether the reports developed in Business Objects are as per company standards.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.

Environment: Ab Initio 2.13, Oracle 10g, SQL Server 2008, SSIS, SSRS, HP Quality Center, SQL, TOAD, PL/SQL, DB2, Business Objects XI, Microsoft Visio 2003, XML, XSLT, .Net, Web Logic, Clear Case, Netezza, Teradata, Clear Quest, TFS, DOORS, Autosys, Windows XP, PuTTY, UNIX

Confidential,Charlotte,NC

DW Tester Product Sales Data Mart

• Extensively involved in Business Analysis and Requirements Gathering
• Analyzed business requirements and interfaced with vendors for development and enhancement of a system to support multiple business areas including Asset Management, portfolio management and risk management.
• Involved in gathering, analyzing, distilling and clearly conveying complex information to business and project team members through JAD sessions
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements.
• Conducted discussions and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions
• Responsible for validating the files availability, format and data on UNIX server
• Produced documents for business requirements (requirements matrix), design requirements, gap analysis, solution recommendations, test cases, test plans and reference guides
• Coordinated system walk through, training, User Acceptance Testing (UAT) and facilitate issue resolution
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Developed Reports and Graphs to present the results to the management.
• Used Toad for testing execution of ETL.
• Performed Data Driven Testing of the Application for different users/data sets
• Developed Test cases for the data warehouse in Oracle System
• Conducted Functional testing to ensure that the application meets the requirements and to ensure usability readiness
• Experience in creating UNIX scripts for file transfer and file manipulation.

Environment:: SQL, PL/SQL, UNIX, Toad, Test Director V7.6, Informatica Power Center 7.1, Windows NT, Sun Solaris, SOAP UI, MS SQL server, Cognos 7.0 Series, Oracle 9i, Crystal Reports.

Confidential,Atlanta, GA

Back end/ Web Tester

• Worked with the end users and gathered information for designing the specifications.
• Performed the data analysis and data mapping and designed and documented the conversion documents.
• Supported go-live and post-go-live, which included code/process tracing for debugging and performance tuning.
• Participated in developing the file management and ftp process for transmitting the files, also scheduled the daily batch process.
• Worked on issues with migration from development to testing.
• Performed Regression testing/system integration/integration testing/ System Integration testing/ Smoke testing.
• Used Test Director for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Manually ran the test scripts in Test Director and documented the results.

Environment: Oracle 8i, TOAD, SQL, PL/SQL, Cognos, SQL Server 2000, SQL Navigator, Test Director, Windows, UNIX AIX