SUMMARY:

• Over 7+ years of Experience in Data warehousing Analyst, Quality Assurance and 5+ years of ETL/BI testing experience with extensive backend testing Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Application Data warehousing experience in Banking, Financial, HealthCare, Retail and Consumer.
• Posse's good knowledge on Retail Banking workflow on Visual Banking application which is retail Banking umbrella for modules like Investments, Monetary, and consumer loans for Washington Mutual's Bank.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Expert in Oracle database testing.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Experience in developing the Manual Test Suites and Automated test suites.
• Expertise in QA process and different levels of testing like unit, Functional, Regression, and Integration testing with business scenarios.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in testing and writing SQL and PL/SQL statements.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Extensive experience in testing of Financial, Healthcare and Banking clients.
• 5 years of strong data base experience in Oracle, SQL Server, DB2 and Teradata.
• Strong experience in testing tools like TestDirector, Quality Center, Quick Test Pro & Bugzilla
• Expertise in writing SQL and PL/SQL statements.
• Good expertise in using TOAD, SQL*Plus and SQL Advantage.
• Experience in testing and writing complex SQL, T - SQL and PL/SQL statements.
• Developed a wide variety of tools such as a LaTex-based documentation generator, PCAP and token analyzers, CVS/Subversion (SVN) migration tools, and various Perl-based web applications on Linux.
• Experience in all aspects of project development life cycle.
• Experience with integration testing of the applications using various sources like flat files, sybase and oracle databases.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing
• Experience in debugging the issues.
• Proficient in working with UNIX shell scripts puTTY Environment.
• Involved in jobs scheduling, monitoring and application support in a 24/7 environment.
• Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.

TECHNICAL SKILLS:

TESTING TOOLS: Test Director 7.6/8, Quality Center, QTP, Win Runner, Rational, HP ALM / Quality Center

SCRIPTING TOOLS: VBScript, Java Script, UNIX Shell Script

OS: Windows NT/2000/Windows XP, UNIX, Sun Solaris, Red Hat Linux

DATABASE: Oracle 9i/10g/11i, MS Access 2003, SQL Server 2000/2005, MYSQL 4 and Sybase

ETL: Informatica 7.1/8.1, Data Stage 7.x, Ab Initio (GDE 1.15, CO >Op 2.15)

Reporting Tools: Cognos, Business Objects, Crystal Reports, Hyperion

WEB SERVER: Tomcat, Apache, MS IIS 5.0/6.0, WebLogic 7.0

LANGUAGES: Java, C, C++, COBOL, SQL, Perl, PL/SQL, HTML, DHTML, XML, XSLT, Java Script

LANGUAGE UTILITY: MS Office 2007, Eclipse, MS Visual Studio .Net

BUG TRACKING TOOLS: Test Director 8.0, Quality Center 8.2

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Sr QA Engineer

Responsibilities:

• Developed Test Plans, test scripts and executed the test scripts.
• Throughout the project in various iterations - conducted system testing, integration testing, functional testing and integration testing.
• Developed complex SQL queries for querying data against different databases for data verification process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Tested several complex reports generated by Business Objects including Summary Reports, Master Detailed, Drill Down and Score Cards.
• Created Jobs to Schedule multiple reports in Business Objects.
• 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 interacted with developers, business & management teams to understand the project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Created automated test bed thru PERL and Shell scripting with SNMP, improving testing time & efficiency by 25%
• Developed test scripts using QTP for Functionality and Regression Testing.
• Prepared reusable function in QTP to use across the automation scripts
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Written test cases to test the application in Quality Center 9.0.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Performed Functional Testing and Back-end Testing using the database comparable results manually.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Extensively tested several Business Objects Reports - Crystal reports and Dashboards to validate the reports, the data and cosmetics of the report.
• Written several UNIX scripts for invoking data reconciliation.

Environment: Quality Center 8.2 and Test Director 8.0, Oracle 10g/11g, Informatica Power Center 8.5.1 (Power Center Designer, Unix, Perl, Workflow Manager, Workflow Monitor), QTP,SAP Business Objects 3.1 - Crystal Reports, Cognos, SAP Business Objects Data Services, SQL Developer, MS Excel, TOAD

Confidential, Cleveland, OH

QA Analyst/Business Objects Tester

Responsibilities:

• 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 the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• 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 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.
• 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.
• 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.
• Tested the migration of reports from Business objects XIR2 to XIR3.
• Provided the management with weekly QA documents like Test metrics, Daily status reports, Test schedules and Test Exit Report.

Environment: Oracle 11g, Business Objects, SQL Developer, SQL Server 2008, TOAD, Informatica Power Center 8.6.1, HP Quality Center, PL/SQL, UNIX, Putty, Session log files, Flat files, XML files, Remedy, Snag IT, Compare IT, MS Office, Clear Quest (CQ) and Clear Case.

Confidential, CT

ETL/SQL Tester

Responsibilities:

• Extensively worked in Agile SCRUM environment, with Actively involved in daily scrum meeting, sprint planning meeting and retrospective meeting
• Analyzed user requirements by interactive with business users, developers and business analyst
• Responsible for documenting Test plan/ Test cases/ Test scripts as per Business rules for each release
• Coordinated with offshore QA team in test planning, test designing, test development, test execution, and test evaluation
• Involved in developing Entry & Exit criteria and defined the pass and fail standards
• Documented Requirement Traceability Matrix (RTM) to track test cases versus system specifications and ensure that specifications have been developed, tested, and implemented
• Conducted Functional testing, Integration testing, System testing, GUI testing, performance testing, Regression testing, Compatibility testing,
• Conducted sanity testing for each new build delivered
• Generated SQL queries to retrieve data from database for conducting back-end testing, data validation, and data analysis
• Designed test plan and test cases and generated test scripts to perform automation testing using HP QTP
• Extensively used VBScript to write and modify the test scripts
• Managed the Defect Tracking lifecycle using HP Quality Center - documenting defects, maintaining test metrics, generating status reports and following test schedules
• Identified defects, logged defects and re-tested the fixed ones using the Defect tab in QC
• Documented the bug report and categorized them based on severity and generated summary report
• Interacted & coordinated with development team to fix different bugs/defects
• Conducted Change Requirements Meetings and maintained Change Request Documents
• Created daily progress report for the team and performed formal defects review meeting
• Comprehensively contributed in User-Acceptance Testing (UAT) by closely assisting business users/ developers
• Facilitated defects review meeting, JAD sessions, status meetings, and created periodic progress reports for development team, QA team, PMO team, and business team .

Environment: HP Quality Center, QTP, VBScript, Oracle, Windows, JAVA, J2EE, HTML, XML, MS Visio, MS Office Suite

Confidential, Bridgeport, CT

Data warehouse Tester

Responsibilities:

• Created Test Plan and developed a test suite for Clear Vision V3.4.3 application.
• Worked with both on-site and offshore development teams for multiple projects.
• Created Manual Test scenario’s for various modules of Clear Vision V3.4.3 Application.
• Writing the test scripts for Manual/Automation testing.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Loaded data from operational data store (ODS) to data warehouse tables by writing and executing foreign key validation programs to validate where exactly star schema appears, with fact tables and dimensions/lookup tables.
• Writing Triggers enforcing Integrity constraints, Stored Procedures for Complex mappings, and cursors for data extraction.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
• Worked with ETL group for understating for data loading for both dimensions and facts.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Involved in creating the design and technical specifications for the ETL process of the project.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Prepared extensive set of validation test cases to verify the data
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Involved in user training sessions and assisting in UAT (User Acceptance 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
• Tested several Java programs for interacting with TIBCO (EAI) Message Bus and worked with interacting JMS Header and Instrument data.
• Responsible for testing TIBCO stage Queues in order to send XML messages to TIBCO Bus.
• Tested several XSD’s for setting up standards for TIBCO Bus Message Formats.
• Involved in Functional testing, End to End testing and Regression Testing
• Involved in Front to Back testing for all European and Asia pacific and North Atlantic exchanges
• Preparing and supporting the QA and UAT test environments

Environment: Sybase 12.3, J2EE 1.4, TIBCO, C, ETL Informatica 7.1, Ab Initio, Cognos, Perl Scripts, XML, XSD, XML Spy 2008, SQL, PL/SQL, Oracle 9i/10g, IBM AIX 5.1, UNIX Shell Scripting, Windows, and Test Director 8