SUMMARY:

• Over 8 years of IT experience in Quality Assurance and Software Testing of various business applications in Client/Server environments, Web based applications, Data Warehousing and Business Intelligence solutions.
• Excellent working knowledge of System Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Experienced in Functional testing, System testing, Application testing, Performance testing, Integration testing, Regression testing, Black Box testing, Stress Testing, Smoke testing, Recovery testing, Reports testing, browser compatibility testing, UAT and GUI testing.
• Expertise in writing Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases, Test scripts, RTMs, Defect status reports and Test Summary report.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like HP Quality Center and Rational Clear Quest.
• Expert in writing complexSQL queries for back - end and Reports data validations.
• Adept on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus and SQL Developer.
• Experience in maintaining the test environments; involved in requesting the deployments, requesting data loads, data base backups, restarting the servers, troubleshooting issues.
• Tested several complex Reports generated by IBM Cognos, Business Objects BOXI, Micro Strategy including Dashboards, Summary reports, Master detailed, Drill down and Score cards.
• Experience in testing the reports for both cosmetic static content and data validations as per Report specification documents.
• Experience on UNIX commands and Shell Scripting.
• Thorough knowledge on data warehouse testing strategies including - Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
• Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center, DataStage, Ab Initio and SSIS ETL tools.
• Expertise in testing reconcile (initial) and delta (daily) loads.
• Experienced in using the Oracle SQL* Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Knowledge on the phases of agile methodology and traditional Waterfall methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS:

QA Methodologies: Iterative, Agile, Waterfall and Spiral Methodology

QA Tools: HP - Quality Center, TFS (Team Foundation Server), Rational - Clear Quest

BI/Reporting Tools: Business Objects, IBM Cognos,Crystal Reports

Databases: Oracle: 11g, 10g, 9i and 8i,Microsoft: MS Access, SQL Server 2005/2008, MySQLTeradata: V2R6, V2R5

Query Tools: TOAD, Rapid SQL, SQL Developer, SQL Navigator, SQL Plus

ETL Tools: Informatica Power Center 9/8.x/7.x, AB Initio, Data Stage 7.x/8.x

Programming Languages: SQL, PL/SQL, XML, C

Operating Systems: Microsoft Windows - 7,Vista, XP, 2000, NT 4.0,UNIX - Sun Solaris, HP-UX

Others: MS Office (Share point, Outlook, Word, Excel, PowerPoint Communicator), MS Project, PuTTY, Remedy

PROFESSIONAL EXPERIENCE:

Confidential, NYC/NY

ETL Tester

Responsibilities:

• 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 source data.
• 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
• Expertise with 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 7.1.3/8.1, Ms Excel, Oracle 10g/9i, SQL, PL/SQL, Teradata utilities, TOAD 8.0, UNIX, Windows 2000

Confidential, Cleveland, OH

Sr. ETL 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 all the 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 all the 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 10g/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, SnagIT, CompareIT, MS Office, Clear Quest (CQ) and Clear Case.

Confidential, Boston, MA

DWH Tester

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Managed multiple OLAP and ETL projects for various testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• As a ETL Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
• Tested several BO Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s, Grouped List, Cascade and Web Reports.
• Tested and validated the BO reports by running similar SQL queries against the source system(s).
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center 10
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Written Test Cases for ETL to compare Source and Target database systems.
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations

Environment: Informatica 8.6.1, Business Objects XIR3, WinSQL, QTP 9.2, Netezza NPS 8050, NZ SQL, Quality Center 9.2, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 9i/10g, PL/SQL, IBM DB2.

Confidential, New Port Beach, CA

QA Analyst/DW/Reports Tester

Responsibilities:

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible to translate business requirements into quality assurance test cases
• Review of test scenarios, test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Responsible in testing Initial and daily loads of ETL jobs.
• Validated various Ab Initio graphs according to functional requirements.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Planned ahead of time to test the mapping parameters and variables by discussing with BA’s.
• Extensively usedRational Clear Questto track defects and managed them.
• Tested several reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting.
• Extensively tested several MicroStrategy Reports for data quality, fonts, headers, footers, and cosmetics.
• Tested Informatica mappings for various ETL functions.
• Extensively involved in testing theETLprocess of data sources, SAP, PeopleSoft, Teradata, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Periodical meetings with Directors, Project Managers and Clients for implementing new approaches and techniques.
• Responsible for documenting the process for future s.
• Responsible for in-depth knowledge of data, processes or applications in their specific area of responsibilities
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: Mercury Quality Center, Informatica, MicroStrategy, Rational ClearCase, Rational ClearQuest, Rational RequisitePro, TOAD, Perl, PUTTY, Web logic, Oracle 10g/9i, SQL Server 2005, Unix, PL/SQL, Win XP