SUMMARY:

Over 7+ Years of IT experience in Data Analysis/QA Testing/ Batch Testing/ETL/DWH/BI - Reports& Testing of Software systems in Data Warehouse/ Business Intelligence/Client/Server Oracle and Web-based environments under Windows and UNIX platforms.

• Extensively worked in entire QA Life Cycle, which includes designing, developing and execution of the entire QA Process.
• Strong knowledge of Software Development Life Cycle (SDLC), and QA Methodologies like Agile, Scrum, Waterfall, and Iterative process.
• Expertise inWeb Intelligence Reports, Desk Intelligence Reports, Dashboard using Business Objects Enterprise XI R2 / XI R3.
• Involved in preparing the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.
• Experience on Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, UAT, Batch Testing, Interface testing, and Performance Testing.
• Proven Leadership experience with strong Analytical, Presentation and Communication skills
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports, Checklists, Job Aids, Test Readiness Review Documents, Test Summary Reports.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Extensive experience in writing complex SQL Queries and PL/SQL scripts.
• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects BOXI, Micro Strategy, Cognos including dashboards, summary reports, master detailed, drill-down and score cards.
• Expertise in test management using HP Quality Center, Microsoft TFS and maintained Versioned objects using Rational Clear Case.
• Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking bugs using HP Quality Center, Rational Clear Quest, Bugzilla.
• Experienced in interacting with Clients, Business Analysts, UAT Users, and Developers.
• Understanding of Data Models, Data Schema, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.
• Have experience in testing reconcile (initial) and delta (daily) ETL loads.
• Have good experience in Data Migration testing and Web Interface testing.
• Have good experience using Informatica Workflow Manager for running/managing workflows and Informatica Workflow Monitor for monitoring the workflows and checking the session logs.
• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors. 
• Extensively worked on Batch Scheduling tools Autosys, Control-M to run and monitor ETL jobs.
• Knowledge on the phases of Agilemethodology and Scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS:

QA/Testing Tools: HP Quality Center 10.x,9.x,TestDirector,Quick Test Pro (QTP), TFS, Rally

Bug Tracking Tools: Bugzilla, Rational Clear Quest

Version Control Tools: Rational Clear Case, CVS

Requirements Tools: Rational RequisitePro, DOORS

RDBMS (Databases):  Oracle 11i/10g/9i/8i, MS SQL Server 2003/2005/2008 , MS Access, DB2, Teradata

RDBMS Query Tools: SQL*PLUS, Query Analyzer, TOAD, Oracle SQL Developer, SQL Navigator

BI/Reporting Tools: IBM Cognos, Hyperion, Micro Strategy, Business Objects BOXI, OBIEE

ETL Tools: Informatica Power Center 9.x/8.x/7.x, DataStage, Ab Initio

Programming Languages: PL/SQL, C

Scripting Languages: SQL Scripts, UNIX Shell Scripts, VB Script

Incident Management Tools: Remedy

Operating Systems: Microsoft Windows Family, UNIX - Sun Solaris, HP-UX MS Office MS Word, MS Excel, MS PowerPoint, MS Outlook

Scheduling Tools: Autosys, Control-M

Other Tools: PuTTY, TextPad, CompareIT, SnagIT, WinSCP, Data Flux, GS Data Generator

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr QA Analyst/ETL Tester/Test Lead / Data Analyst

Responsibilities:

• Developed Test Plan, Test Cases, Test Scripts and Test Scenarios to ensure that end to end testing was conducted appropriately for all the releases.
• Examined system requirements, Business Requirements and generated Traceability Matrices from requirements to test cases.
• Used TOAD, Teradata to develop and execute test scripts in SQL, to validate the test cases.
• Involved in the process of analyzing the expected and actual results .
• Managed onsite and offshore team, define the schedule and timelines as per client schedule.
• Involved in reviewing test scenarios, test results for data warehouse/ETL testing.
• Responsible for testing Initial/Reconcile and Incremental/daily loads of ETL jobs.
• Involved in testing confidential customer data used for AML/Fraud case generation.
• Worked on Extracting Data from Flat files and load the data into Oracle/Teradata.
• Performed Integration, End-to-End and System testing.
• Responsible for source system analysis, data transformation, data loading and data validation from source systems to Transactional Data system and Warehouse System.
• Performed testing in SIT, UAT and Prod Environments to validate that the developed application meets the business requirements.
• Tested UNIX jobs according to the specifications and the functionality.
• Executed various SQL Queries to perform the backend testing.
• Had aregular meeting with Developers to report various defects and used QC to log these defects .
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Createdand used macros to improve the quality of testing.
• Written Test Cases for ETL to compare Source and Target database systems.
• Mocked test data to test all the scenarios and test cases planned.
• Written several complex SQL queries for data verification and data quality checks.
• Arranging and conduct reviews, CCB meeting, maintaining approvals.
• Validated and executed Unix commands to check the header count and File layout checks to ensure that file is received.
• Involved in creating Induction Manual, KT documents with BA and SMEs.
• Analyzing the existing testing process and submit the report to improve the process and estimate the efforts.
• Creating and maintaining audit documents related to all the documents in the repository.

Environment: Informatica 9.6.1, Teradata 15.10, Teradata Studio 15,SQL Server ManagementStudio 2014, QC ALM12,TOAD for Analysts 3.0, TOAD 11.6JIRA, MS Project,Putty, Agile, Business Objects XI,Autosys,Tosca, UNIX, MS Viso, Sharepoint

Confidential, Baltimore, MD

SrQA Analyst/ETL Tester/Reports Tester / Data Analyst

Responsibilities:

• Designed &createdMaster Test Plan based on the BRD and SRS. Also referred Technical Design document, Source to Target Detailed mapping document & Transformation rules document, ER Diagrams to derive test cases for functional testing. 
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata.
• Co-ordinate testing efforts between onsite and offshore teams.
• Involved in testing the Business Objects performance & connectivity across different domains.
• Tested complex objects to the universe to enhance the report functionality.
• Tested ad hoc and canned reports for Business objects.
• Tested Business Objects reports and Web Intelligence reports.
• Validated database structure with ERD.
• Prepared Test cases and Scripts in Quality center and executed them in test lab module.
• Performed pre-process validation for existence of specified database objects like tables, views, synonyms and grants for the same to corresponding schema in database. 
• Validated the target table column definition with source column definition (including type and length).
• Involved in verifying the readiness of the system before starting process.
• Involved in creating CR for any type of migration/changes using Remedy.
• Participated in migrating Informatica, UNIX code from DEV to QA and QA to UAT environments. 
• Used Clearquest, TFS and Jira tools for defect/bug management. 
• Involved in executing/scheduling ETL jobs through Autosys.
• Validated Informatica mappings that load files into staging tables.
• Involved in extensive end to end DATA validation and back-end testing using SQL queries. 
• Good work experience with Partition Exchange concept in Oracle.
• Created BRD x SRS and SRS x Test Cases Traceability matrix for all the projects.
• Responsible for QA status update and was Point of contact in the team of 5 members including 4 offshore QA Analysts from India.
• Validated PL/SQL, Informatica batch processes which are scheduled using Autosys.
• Validated various SSIS and SSRS packages according to functional specifications.
• Heavily involved in performance testing and worked with analyzing tables, gathering statistics, tuning of SQL queries used to fetch source data. 
• Used TOAD GUI tool for querying oracle database.
• Presented QA team work update/Status to Project/Program Manager in status meeting and also worked with business team to get approval on test plan/test cases. 
• Validated that design meets requirement and functions according to technical and functional specifications. 
• Involved with Design and Development team to implement the requirements. 
• Developed Test Scripts and executed them manually to verify the expected results and published the same to wider audience upon successful completion along with QA signoff. 
• Participated in KT meetings with Business Analysts and SMEs. 
• Frequently used Perforce to store documents and update them with the latest versions and additions. 
• Participated in walkthrough and defect report meetings periodically. 

Environment: Informatica Power Center 8.6,SQL, PL/SQL, Business Objects Enterprise XI R2/ R3, Remedy, DB2,Oracle 11g,TOAD, Rational ClearQuest, Rational ClearCase, Doors, Oracle SQL Developer, XML,MS TFS (Team Foundation Server),Putty, VB Script, Quality Center 10, Agile, Business Objects XI,Autosys, SQL Server 2008, SSIS, SSRS, SSAS, XP, UNIX

Confidential, Charlotte, NC

Sr. QA Engineer / Data Analyst/ Web Interface Tester/ETL Tester

Responsibilities:

• Involved in meetings with Business Analysts and End Users to review functional/technical requirements and responsible to translate business requirements into quality assurance test cases.
• Used TOAD to develop and execute test scripts in SQL, to validate the test cases.
• Involved in reviewing test scenarios, test cases and test results for data warehouse/ETL testing.
• Prepared 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.
• Managed user accounts and security using Business Objects Supervisor.
• Tested the universes and reports in Business Objects 6.0
• Created reports using Business Objects functionalities like Slice & Dice, Drill Mode, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Responsible for testing Initial/Reconcile and Incremental/daily loads of ETL jobs.
• Interacted with design/development/DBA team to decide on the various dimensions and facts to test the application.
• Involved in testing the Autosys Batch programs, UI screens.
• Establish and organize Offshore Development Teams.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Planned ahead of time to test the mapping parameters and variables by discussing with BA’s.
• Extensively used Rational ClearQuest to track defects and managed them.
• Extensively tested several Cognos reports for data quality, fonts, headers, footers, and cosmetics.
• Conducted user acceptance testing (UAT) to validate that the developed application meets the business requirements.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Used Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Extensively involved in testing the ETL process from different data sources (SAP, PeopleSoft, Teradata, SQL Server, Oracle, flat files) into the target Oracle database as per the data models.
• Tested reports in Cognos using Analysis studio, Report studio.
• Validated datastage jobs. Used datastagedirector to execute and verify datastage jobs.
• Used Autosys for scheduling the ETL mappings, PL/SQL subprograms.
• Written Test Cases for ETL to compare Source and Target database systems.
• Mocked test data to test all the scenarios and test cases planned.
• Used UNIX commands for file management; placing inbound files for ETL and retrieving outbound files and log files from UNIX environment.
• Written several complex SQL queries for data verification and data quality checks.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Responsible for documenting the process, issues and lessons learned for future references.
• Reviewed the test activities through daily Agile Software development stand-up meetings.

Environment: Informatica Power Center 8.6,, Teradata V2R6, Teradata SQL Assistant,SQL, Business Objects Enterprise XI R2/ R3, ClearCase, ClearQuest, RequisitePro, HP Quality Center, SharePoint, Web Logic, Oracle 10g,Fiddler, SQL Server 2008, DB2, PL/SQL, UNIX, PuTTy, Flat files, Session Logs, Rally, Remedy, Windows XP.

Confidential, Pittsburg, PA

Sr. QA Consultant / ETL Tester / Reports Tester

Responsibilities:

• Involved in writing the test plans, test cases and RTM involved in the process of analyzing the expected and actual results .
• Worked on Extracting Data from Mainframe and load the data into Oracle.
• Performed Integration, End-to-End and System testing.
• Responsible for source system analysis, data transformation, data loading and data validation from source systems to Transactional Data system and Warehouse System.
• Extensively used   ETL   to load data from Flat files to Oracle.
• Executed various SQL Queries to perform the backend testing.
• Tested Informatica mappings for various ETL functions and transformations.
• Had regular meeting with Developers to report various problems .
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing and end to end testing .
• Implemented SDLC, QA methodologies and concepts in the Project .
• Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts .
• Tested UNIX batch jobs according to the specifications and the functionality.
• Developed test scripts based upon business requirements and processes. Processed transactions from system entry to exit.
• Used Informatica Workflow Manager to schedule and run Informatica mappings and Workflow Monitor to monitor ETL execution and logs.
• Involved in developing Unix Shell wrappers to run various SQL Scripts.
• Extensively created UNIX shell scripts for scheduling and running the required jobs.
• Tested the   ETL   Data Stage jobs and other   ETL   Processes (Data Warehouse Testing) .
• Tested the   ETL   process for both before data validation and after data validation process.Tested the messages published by   ETL   tool and data loaded into various databases .
• Performed the tests in both the SIT, QA and contingency/backup environments .
• Involved in extensive DATA validation using SQL queries and back-end testing .
• Heavily involved in testing Business Objects reports, extensively used SQL for testing reports.
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.

Environment: Oracle 9i, Toad, DB2, SQL, Informatica, PL/SQL, Business Objects, MS Visio, DB2, Rapid SQL, Mainframes, TOAD, .Net, XML, COTS, RUP, Windows, Autosys, TIBCO, Remedy, QTP, SQL Server 2003/2005 SSIS, SSRS,UNIX, PuTTy