SUMMARY:

• 7+ years of experience in ETL / BI, Data Warehouse Testing, Manual Testing and Automated Testing and web based client/server applications
• Solid experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Experience using query tools for Oracle, MS SQL, DB2 and Teradata server to validate reports and troubleshoot data quality issues.
• Experience with Agile Methodology
• Well versed in detecting errors and conducting UAT by designing, developing, and executing test cases
• Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000/7.0, Teradata and DB2
• Performed Backend Database testing on Oracle and MS SQL Server databases, used SQL, PL/SQL queries, triggers & procedures.
• Performed Manual and automated testing using HP Quality center, Quick Test Professional (QTP) and Test Director.
• Worked on various Operating Systems which include Windows 95/98/2000/NT/XP and Linux (RedHat), UNIX (Sun Solaris 9.0/8.0/7.0, IBM AIX, HP UX 11i v1.5/1.6/2.0).
• Strong in developing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Extensive knowledge in regression testing and design documentation.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Responsible for execution of Batch jobs and population test data for other teams.
• Worked with defect tracking software as bugzilla, JIRA.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Skilled in analyzing business context and requirements for UAT testing purposes
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging, Data integration of operational sources using ETL processes.
• Experience in all phases of Software Development life cycle.
• Excellent communication skills, Good organizational and interpersonal skills, outgoing personality, Self - motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to adapt based on the demands of work.

TECHNICAL SKILL

SETL Tools: Informatica 9.0/8.6/8.1/7.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), SSIS, DataStage 8.X

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , DB2 9.0/8.0, Teradata

Languages: SQL, PL/SQL,, Visual Basic

Tools: Toad, SQL* Loader, WinSQL, Teradata SQL Assistant 6.0

BI Tools: Business Objects XIR2/XIR3, SSRS,Cognos and Hyperion, Microstratergies

Testing Tools: QTP, Quality Center 10.0 / 9.2, Test Director, WinRunner, LoadRunner,

ETL Tools: Informatica 9.0/8.6/8.1/7.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), SSIS, DataStage 8.X

PROFESSIONAL EXPERIENCE

ETL QA Tester

Responsibilities:

• Create test plans, test cases, and participate in user acceptance testing to ensure the highest quality products are released to production
• Good experience in web related technologies including HTML, XML, SOAP, JavaScript, ASP, VB, VB.NET,ASP.NET
• Tested ad hoc and canned reports for Business objects.
• Work closely with business users and the project team to analyze business requirements in order to create project test scenarios
• Analyzed the requirements from business requirement & functional use case diagrams, and other project related documents to design and develop effective Test cases
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Experience in different SDLC methodologies like Waterfall and Agile (scrum).
• Formulate methods to perform Positive and Negative testing against requirements.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing.
• Tested ETL Dimension Table SCD Type 1 and Type 2
• Used Agile testing methodology for achieving deadlines in UAT; extensively worked on UAT of several modules single handedly.
• Executed testing across various areas such as SAP FICO, SD, MM, and FM to prove the requirements
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica
• Tested Business Objects reports and Web Intelligence reports
• Ran workflow in workflow manager of Informatica and verified session logs for data load discrepancy.
• Responsible for communication with the users and responsible for working with the users closely during UAT and getting the required sign-off’s.
• Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization
• Created and executed SQL statement to perform Backend Testing manually that ensured data consistency on the Front-end.
• Participated in weekly status me etings, walkthroughs, design review meetings and documented proceedings.
• Develop and maintain internal technical documentation relevant to the QA processes and procedures.

ENVIRONMENT: Oracle 11G, SOAPUI, SQL Server 2012,Teradata SQL Assistant, Quality Center 11 &ALM, Agile, XML, QTP, .Net, SQL Server 2012, Business Objects XIR3, Informatica 9, UNIX.

ETL QA Tester

Responsibilities:

• Tested the ETL process to automate the testing process and also load the test data into the testing tables.
• Tested ad hoc and canned reports for Business objects.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Responsible for UAT project planning like creating testing scenario, test plans, and test scripts
• Handle the tasks of explaining UAT scope, criteria and entry/exit strategy to less trained professionals
• Perform responsibilities of conducting research on IT requirements and business requirements in UAT areas
• Handle the tasks of identifying UAT testers and managing resource plan by coordinating with business stakeholders
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Responsible for reviewing SIT Test Plan to ensure sufficient testing plans
• Handle the tasks of ensuring that the Pre-UAT activity is performed accurately and efficiently
• Responsible for developing UAT test process and monitoring SIT execution phases
• Handle the tasks of identifying defects and perform root cause analysis by analyzing data quality issues
• Written test plans and estimated time frames for functional IT, UAT phases
• Involved in data warehouse testing by checking ETL procedures.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Worked on Informatica DVO tool for Regression Testing.
• Worked in AGILE Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Strong ability in developing advanced and complex 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
• Worked with Compatability Testing for Browser, Operating, Mobile & Printing options for Web Apps
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Worked with Data Conversion projects for testing data quality after migration.
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD, Teradata SQL Assistant, WinSQL and SQL Plus.
• Tested Business Objects reports and Web Intelligence reports
• Used SQL Loader for data retrieval and querying.
• Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team.
• Used SQL for Querying the DB2 database in UNIX environment.
• Responsible for execution of Batch jobs and population test data for other teams.
• Run batch jobs for loading database tables from flat files using SQL*Loader.
• Identify potential problems, omissions and open issues and attend walkthroughs and attend signoff meetings.
• Provide recommendations on performance enhancements in pre-production and production environments.
• Wrote numerous Pre and Post session SQL and UNIX Scripts.
• Used Autosys to do the shakeout whenever a new build is received.
• Performed database testing with SQL queries to verify data integrity using QTP.
• Served as a coach and mentor to the department staff regarding how to develop and execute a test plan.
• Validate the business functionality using UAT  Testing
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Involved in the design of web application using HTML, DHTML, Cascading style Sheets Java script and ASP.

Environment: Oracle 10g, MS SQL SERVER 2005/2008, Query Studio, AutoSys 11, MS Excel, MS Access, MySQL 5.0, Windows 2007, SQL Server 2008, XML, HP ALM Quality Center 11.0, HP QTP 11.0, T-SQL, SQL, TOAD, Flat Files, UNIX Shell Scripting

ETL QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Tested ad hoc and canned reports for Business objects.
• Used Quality Centre for tracking the defects.
• Tested all data reports published to Web including dashboards, summarized, master-detailed and KPI’s.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Responsible for assisting senior engineers in developing test estimation, scope and test plan for UAT
• Perform the tasks of designing and developing test procedures to meet business requirements
• Responsible for driving E2E Test scenarios efforts and in identifying test data for UAT
• Handle the tasks of helping the organization staff in planning data sets for UAT
• Responsible for drafting complex SQL queries and perform allocation testing from front end / user interface
• Tested XML feeds loaded into Data Warehousing.
• Assigned the tasks of preparing test results as well as gather test results from other testers in standardized format
• Tested existing Data web application from classic ASP and VB6.0 to VB.NET, ASP.NET, C# (.NET Framework 3.5), SQL Server 2005.
• Develop Functional/Regression automated testing solutions using QTP, traditional QTP framework, and/or Data Driven techniques.
• Written several complex SQL queries & PL/SQL stored procedures for validating Business Objects Reports
• Responsible for verifying the log files using UNIX and database for the submitted application.
• Coordinated and Interacted with Development team and actively participated in status meetings during the defect life cycle, reported the bugs and maintained their status.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Extracted data from various sources like Oracle, flat files and DB2.
• Tested SCD tables Type 1, Type 2 and Type 3.
• Wrote and ran UNIX Scripts for batch jobs.
• Create the QTP Automated Test scripts for various modules.
• Tested stored procedures & views in MS SQL 2000/2005.
• Preparing and supporting the QA and UAT test environments.
• Tested different detail, summary reports and on demand reports.
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute
• Functional Testing, Regression Testing and Acceptance Testing
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: PL/SQL, SQL, Teradata V2R5, TOAD 9.2, Oracle 9g, DB2 UDB, DB Artisan 8.5.2, HP Quality Center 10.0, AutoSys, Bugzilla, MS Access, MS Excel, MS PowerPoint, XML, XSD, XQuery, XPath, XSLT, XML Spy 2010, HP QTP 9.5, Quality Centre, Unix Shell Scripting, Windows NT/XP//2003.

ETL QA Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Worked on the design of SOAP, an XML-based messaging framework which is the foundation of Web services.
• Worked in an Agile technology with Scrum
• Written several UNIX scripts for invoking data reconciliation
• Reported bugs and tracked defects using Quality Center
• Executed SQL queries to perform backend database testing and verify/modify user data.
• Enhancing the QTP QuickTest Pro Scripts with GUI checkpoints, Database Checkpoints, Parameterization, User Defined Functions (adding functional features) and Synchronizations.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Responsible for Functional, Regression, UAT Testing
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files
• Extensively used Informatica power center for extraction, transformation and loading process.
• Performed UAT regression testing after the defects were fixed.
• Tested Cognos reports to check whether they are generated as per the company standards
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Environment: Informatica Power Center, Cognos 7 Series, QTP, SOAP, Windows NT, Test Cases, Test Scripts, Test Plans. Oracle 8i, SQL Server, Agile ,SQL, PL/SQL, XML ,Unix,SQL*Plus, Quality Center, TOAD and Shell Scripting.

ETL QA Tester

Responsibilities:

• Tested the defects in Mappings and Work flows. Used Quality Centre for tracking the defects.
• Analyzed and created the bug tracking reporting and summary report in the Quality Center
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Performed (UAT) User Acceptance testing exclusively in an Agile environment.
• Experienced using query in Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Validated format of the reports and feeds.
• Perform GUI, Functionality, Integration, Regression and UAT
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Worked on issues with migration from development to testing.
• Validated cube and query data from the reporting system back to the source system.

Environment: Informatica 8.1, SQL *Loader, QTP, PL/SQL, SQL, Stored Procedures, Test Cases, Test Scripts, Test Plan, Oracle8i/9i, SQL Server 2000/2005, Erwin 3.5/4.1, Quality Center, Windows 2000, TOAD