SUMMARY

• 7+ years of total IT experience and very good knowledge QA of Software Applications and Testing. Extensive experience in testing of data warehouse / data marts.
• Extensive 5 years of QA experience in Data Warehousing technology in building and managing various data warehouse / data marts using Informatica products such as Informatica Power Center/Power Mart, Power Connect, Power Analyzer and Power Exchange Tools.
• Experience in using SOAP Sonar for providing simple, intuitive and comprehensive testing for SOAP - , XML- and REST-based services
• Experience working in using Databases like Oracle, Teradata, SQL Server, DB2, MS Access and DB2. Expertise in Database Programming (Stored Procedures, Triggers, Packages, PL/SQL) using Oracle.
• Used QTP for Checkpoints, Regular Expression and Accessed Data Tables for multiple applications.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Automated detailed test cases by using Quick Test Pro.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Extensive experience in Business Intelligence reporting tools using Cognos Series, Power Play, Transformer, Impromptu Web Reports (IWR).
• Extensively used SQL, PLSQL to create complex queries, SQL Override, Stored Procedures, and Trigger

TECHNICAL SKILLS

Database: Oracle, SQL Server 2005/2008, Teradata

Data Warehouse Tools: Informatica, Ab Initio, Data Stage

BI Tools: Cognos 8.0 Series & Business Objects

Languages: PL/SQL, T-SQL, SQL, XSLT, Visual Basic, PERL, Shell Scripting

Other Tools: Smart, WinSCP, Putty, emacs, Pico, XML Spy 20

Testing Tools: HP Quality Centre 10.0, Test Director

PROFESSIONAL EXPERIENCE

Confidential - St. Louis, MO

ETL Tester

Responsibilities:

• Analysed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Experienced in working in Agile Scrum and Waterfall SDLC methodology environments
• Developing and executing functional and automation test strategy for the successful completion of all phases of the project
• Created the Regression Test cases and automated them for the purpose of regression testing using QTP.
• Tested complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Enhance existing test cases, develop test procedures, and improve test automation capabilities
• Used all functionality of crystal reports using labels, templates letters and dashboard, functions features
• Tested Cognos reports to check whether they are generated as per the company standards
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process
• Involved in Scheduling and automating jobs to be run in a batch process
• Ensured data integrity and verified all data modifications and calculations during database migration using Informatica.

Environment: Informatica, Crystal Reports 9.0, Cognos 7.0, HP Quality centre 9.0, Visual Basic 6.0, SQL Server 2000, SQL, T-SQL, UNIX, Teradata, AGILE

Confidential - Charlotte, NC

ETL Tester

Responsibilities:

• Analysed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.
• Created complex SQL queries for querying data against different data bases for data verification process.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Executed test cases for web-based MicroStrategy reporting application.
• Tested new Data migration tool used in the mapping of data to new system.
• Data migration of raw data to excel documents for clients
• Participated in defining and executing test strategies using agile methodology.
• Tested several complex reports generated by MicroStrategy including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created Test cases for Data Acquisition and Data Delivery and tested the data accuracy for all the transformations.
• Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members.
• Written extensive UNIX Shell scripting for error logging, clean-up, data archiving& job scheduling
• Conducted backend testing by querying databases to synchronize testing databases and checked for data integrity and proper routing based on workflow rules at each step.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Generated the detailed Bug reports and Defects were tracked, reviewed and analysed.
• Involved in meetings to discuss the findings in the executed tests and decide the next steps.
• Validated that application meets requirements and functioning as per the technical and functional specifications.
• Tested the functionality and performance of web services using SOAP UI.
• Used Quality Centre to state requirements, test plan, test cases, and update test run status for each iteration and to report the defects.
• Worked on issues with migration from development to testing
• Involved in recording change requests on the Change Requests.
• Created Requirement Traceability Matrix by mapping the requirements with test cases to ensure that all requirements are covered in testing
• Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
• Involved in testing the MicroStrategy reports by writing complex SQL queries.

Environment: Informatica, Oracle, SQL, PL/SQL, SOAP, SOAP UI, UNIX, Teradata, ALM/HP Quality center TOAD, MICROSTRATEGY Agile, XML, XSD, XSLT

Confidential - Bethpage, NY

ETL Tester

Responsibilities:

• Analysed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Centre.
• Created test data for testing specific Membership functionality.
• Executed SQL queries to perform backend database testing and verify/modify user data.
• Coordinated and managed testing activities as per the agile methodology followed by project team members.
• Tested the different sources such as Flat files, Legacy Flat Files, SQL server 2008 and Oracle to load into the Teradata data warehouse
• Tested whether the reports developed in Cognos are as per company standards.
• Extraction of test data from tables and loading of data into SQL tables.
• Performed data validation testing after the ETL process using Informatica.
• Worked with data validation, constraints, source to target row counts.
• Worked with business team to test the reports developed in Cognos.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server-based data warehouse.
• Used Microsoft Excel and Word to document the test status reports and the Test Data.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica, Teradata, Agile, Quality Centre, Cognos, SQL, XML, XSLT, XML.

Confidential - Boston, MA

ETL Tester

Responsibilities:

• Involved in understanding Logical and Physical Data model using Erwin Tool
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Ensured that the mappings are correct and Conducted data validation testing
• Worked with business analyst and developers in setting up test data
• Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.
• Extensively tested several MicroStrategy reports for data quality, fonts, headers & cosmetic
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules
• Extensively test the reports for data accuracy and universe related errors
• Used Toad for query Oracle, SQL Assistant for Teradata and SQL Management studio for SQL Server
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Tested several dashboards and deployed them across the organization to monitor the performance
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Monitored the workflow transformations in Informatica work flow monitor
• Preparing manual test cases and test data for Scenarios
• Experience in creating UNIX scripts for file transfer and file manipulation
• Huge experience on testing MicroStrategy Reports. Validated the underlying SQL query, Report layout and the naming conventions against the requirement, Formatting Properties like alignment, scroll bar, decimal places etc., Export/ Print functionality.
• Created ETL execution scripts for automating jobs
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used workflow manager for session management, database connection management and scheduling of jobs

Environment: Informatica Power Center 7.1, Oracle, XML Files, Data Files, MS Excel, Flat Files, SQL, PLSQL, SQL Server, Unix Shell Scripting