SUMMARY

• 7+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Proven skills in all phases within the software development lifecycle and very strong in the implementation and maintenance of Quality Engineering Processes.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
• Experienced in testing both ETL and BI applications.
• Providing back-end support for customized Forms like customer and supplier maintenance, bill, receipt, letter of credit, invoice, debit and credit notes.
• Responsible for creating manual test scripts to include Functional Test, Regression Test, UAT, Data Migration Test and Study Configuration Test.
• Extensive experience in testing Business Intelligence (BI) reports using various reporting tools like Micro strategy (MSTR), Cognos Report Net and Business Objects
• Extensive experience working with Data warehouse ETL tools like Data Stage, Informatica, SSIS and AutoSys tools.
• Experience in bug reporting and bug tracking using management tools such as Test Director and communicated recorded problems to the responsible QA or development personnel.
• Adept in using testing tools like Test Director, HP ALM/Quality Center.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Strong Skills in using Integration, Functionality, Regression, Performance, Stress and Configuration Testing.
• Extensive experience with Functional, GUI, Database, Stress, Volume, Regression, Load and Performance Testing.
• Strong SQL query Analyzer skills using an enterprise wide RDBMS (DB2 UDB, Oracle, MS SQL Server & MS Access) and familiar with concepts of SQL queries ranging from DML, DDL and TCL
• Was involved in setting up the test environment, created test data as per the requirement.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, Teradata, Ms Access, Flat files into a staging area
• Good working experience on testing ETL, Reference Data and BI
• Proficient experience in different Databases like Oracle, SQL Server 2008, DB2, Sybase and Teradata
• Experience in testing and writing SQL and PL/SQL statements.
• Automated and scheduled the Data Stage jobs using UNIX Shell Scripting.
• Experience in all phases of Software Development life cycle.

TECHNICAL SKILLS:

Test Management Tools: QuickTestPro9.5/9.2/8.0, Jira and Rational Clear QuestETL Tools: Informatica 8.6/9, SSIS, Data Stage 7.5/8, Ab initio.

BI /Reporting Tools: Micro Strategy, BO XIR2, Cognos 8.0

Operating Systems: Windows XP/NT/2000, AIX UNIX, LINUX

Databases: Teradata V2R6, Oracle 10g/9i/8i/7.3, MS SQL Server 6.5/7.0/7.5/2005, Sybase12.0/11.0, MS Access

Web Development/Tools: XML, VBScript, Java Script.

PROFESSIONAL EXPERIENCE

Confidential, KS

Sr. ETL QA Analyst

Responsibilities:

• Established the business analysis methodology using Iterative model of SDLC.
• Created and executed detail functions DW (ETL) test scripts based on the DW Mapping Design Documents.
• Responsible for Data Mapping testing by writing SQL Queries.
• Involved in Delta load testing and compare source and target data.
• Involved in GAP Analysis as per requirements and communicate with our BA on finding GAP Issues.
• Arranged meetings with business customers in better understanding the reports by using business naming conventions.
• Work closely with team members to follow up on defects validation to get closed within the timelines and the same to be informed to the customer.
• Attending daily status meetings (Scrum Standup Meetings) and weekly scrum sprint sessions and planning testing work ahead for self and QA team members.
• Performed various types of testing, such as Integration, functional, SIT and Regression testing.
• Data testing in Golden Source and Mainframe application (Source) data to migrate properly in Target MDM System thru staging areas.
• Involved in testing all required Stage loads and Target MDM Database testing.

Environment: Informatica 9.1.0, Tidal, JIRA, TortoiseSVN, SQL Server 2012 and Oracle,PostgreSQL Tool pgAdmin v 1.20.0, HDFS (Hadoop), MS-Access, Mainframe, HP ALM 12.0

Confidential, Charlotte NC

ETL QA Tester

Roles & Responsibilities:

• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing
• Writing source, target SQL’s based on the mapping documents and validating the data
• Coordinating the testing activities to complete System Integration and UAT Test preparation on schedule.
• Validated OBIEE Dashboard, by passing values in the prompts by fetching the values from backend.
• Validate different Profitability cross sell dashboards - Profit and Loss, Officers, Organization,Relationships of Accounting unit and Customers.
• Validated Financial Metrics - NII, NOF,PTPP,ROE,ROA etc..
• Validated the Recon Reports for the re- conciliation of Outstanding Balances.
• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Successfully leading a team and coordinating the testing activities to complete System, Integration and UAT Test preparation on schedule.
• Data verification and validation using complex SQL queries
• Executed test cases/scripts and accurately & concisely reporting both progress and defect status.
• Used SQL for Querying the SQL server database for data validation and data conditioning
• Created ETL test data for all ETL mapping rules and for Front End - OBIEE.
• Worked with Data Extraction, Transformation and Loading (ETL)

Environment: Informatica 8.6, Oracle 11g, OBIEE 11v, HP ALM, MS-Excel, Informatica 9.1.0.

Confidential, Providence, RI

ETL QA Tester

Responsibilities:

• Extensively written several Test Scripts to compare source and target database.
• Performed reverse engineering to trace the root cause analysis.
• Analyzed the requirements and wrote simple to complex queries to test the requirements.
• Tested and reviewed the mapping document as per the Low level Design.
• Attended several walk thorough meetings with business users and test lead.
• Performed Dry Run on the test scripts before System Integration Testing.
• Involved in verification, validation, functional, GUI, system integration, sanity, and regression testing
• Participated in creating various test scenarios to perform GUI testing
• Validated data from source to stage and stage to target database.
• Tested several UNIX Shell Scripts and Perl scripts for connecting to database and for file manipulation of data.
• Conducted Data Migration and Data Cleansing
• Extensively worked with Metrics, Filters, Transformations, Custom Groups, and Consolidations using Micro Strategy tools
• Generated daily transaction reports with transaction no, loan no, borrowers address, particulars, credit, debits liability.
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Performed data integrity, correctness and profiling at various stages from source to target database
• Prepared test data for various positive and negative testing scenarios.
• Tested reports daily, weekly, monthly based reports.
• Involved in RDBMS Programming DB2 SQL, MS Access and associated SQL Programming and Microsoft SQL Server (T-SQL).
• Worked extensively on MS Access and Excel for data validation purposes.
• Experienced in writing UNIX shell scripts for testing the counts and for processing the test data feeds and folder contents.
• Wrote data conversion and data migration scripts for ETL process
• Executed the Test cases for Micro Strategy
• Extensively worked on HP ALM to execute a bunch of test scripts.
• Logged the defects found in HP ALM while execution of test scripts
• Validated the data present from flat files to database
• Tested Daily, Weekly, Biweekly and Monthly data loads.
• Tested the layout of the table from the database to the data model.
• Identifies, assesses and solve complex problems for area of responsibility, where analysis of situations or data requires an in-depth evaluation of variable factors.
• Involved in testing Micro strategy reports including conditional formatting testing and threshold testing
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules
• Closely follows the strategic direction set by senior management when establishing near team goals.
• Worked on multiple projects and acted as a lead to coordinate with onsite and offshore members.

Environment: Micro Strategy, DB2 UDB SQL, MS-SQL,SSIS, MS-Access SQL, Aqua Data Studio 13.x, Data Stage 8.5x, 8.x, 7.5x, AIX 5.x. HP ALM 11.x, IP Switch (FTP tool).Ultra Edit tool.

Confidential

ETL QA Tester

Responsibilities:

• Extensively written several Test Scripts to compare source and target database.
• Analyzed the requirements and wrote simple to complex queries to test the requirements.
• Tested and reviewed the mapping document as per the Low level Design.
• Attended several walk thorough meetings with business users and test lead.
• Tested data migration to ensure that integrity of data was not compromised.
• Performed Dry Run on the test scripts before System Integration Testing.
• Involved in verification, validation, functional, GUI, system integration, sanity, and regression testing
• Participated in creating various test scenarios to perform GUI testing
• Validated data from source to stage and stage to target database.
• Assisted in kicking off Informatica ETL jobs using UNIX and analyzed the data in dimension and fact tables
• Created Test Plans for various versions of Citi Line of Credit Reports applications from different BRQ Business Requirements created by the Project Management, and Business Line Teams.
• Tested Micro strategy reports for Report layout, Attributes/Metrics, positions, Totals & Grand Totals, Drilling options, Metric Calculations, Drill Maps, and Security filters
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Tested Track changes of SCD type 2 dimension
• Tested several UNIX Shell Scripts and PERL scripts for connecting to database and for file manipulation of data.
• Performed record count from source to target database
• In the process of data migration, migrated data from an Oracle data source to Teradata.
• Prepared test/Seed data for various positive and negative testing scenarios.
• Tested the messages published by INFORMATICA and data loaded into various databases
• Performed tests to check whether there is any loss of data during data loads
• Tested reports daily, weekly, monthly based reports
• Involved in RDBMS Programming Microsoft SQL Server (T-SQL), Oracle (PL/SQL), MS Access and associated SQL Programming.
• Experienced in writing UNIX shell scripts for testing the counts and for processing the test data feeds and folder contents.
• Tested several data migration application for security, data protection and data corruption during transfer.
• Coordinate and tested the deployment procedure for MicroStrategy changes to the Production
• Tested several Informatica ETL jobs and ran on UNIX for loading purpose and checking the log files
• Extensively worked on Quality center to execute a bunch of test scripts.
• Logged the defects found in quality center while execution of test scripts
• Tracked the bad records present in the table.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Validated the data present from flat files to database
• Highly experienced in various features of Micro Strategy like managing multiple projects, project migration and defining standards, procedures for development, production environment
• Wrote complex sql queries using Teradata sql assistant and toad for various testing purpose
• Tested Daily, Weekly, Biweekly and Monthly data loads.
• Tested the layout of the table from the database to the data model.

Environment: Micro Strategy, Teradata SQL assistant 13.0,Toad for Oracle10g, INFORMATICA, Erwin Data Modeler, SQL loader, Quality Center,SSIS, Cobol Files, SAM Files, UNIX, Business Rules Repository GUI(BRR), Business Process Application GUI(BPA), Data Quality Monitor GUI (DQM)

Confidential VA

ETL QA Tester

Responsibilities:

• Responsible for writing Test Cases, Test Plans, Test scripts and other test documents based on business requirement.
• Responsible for data validation testing using SQL and executing testing on data Warehousing projects.
• Responsible for developing detailed UAT test plans, conditions, scenarios, cases and related data and participate in UAT planning and execution activities for business and operations participants.
• Developed Test Plans and developed Test Cases/Test Strategy with input from the assigned business analysts and data architect.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS packages
• Executed Informatica ETL jobs using UNIX to load the data into target tables
• Reviewed Business Requirements, System Specs and Training Material for accuracy. Planned, developed and executed test plans, including detailed test scripts.
• Developed and Tested UNIX shell scripts to move source files to archive directory.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Involved in extensive data validation using SQL queries and back-end testing
• Used HP Quality Center for test scripts creation, execution, test coverage and defect tracking
• Developed Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts and data architect.
• Used TOAD, DB Artisan tools to connect to Oracle database to validate the data that was populated by ETL applications.
• Coordinate and helped in testing the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Promoted Unix/INFORMATICA application releases from development to QA and to UAT environments
• Worked on Clear Quest to log defects and track resolution till the closing of defect after retesting.
• Tested both conditional formatting and threshold level testing for several reports developed in Business Objects XIR3.
• Determine level of testing required to validate new or revised system capabilities.
• Report accurate testing status and create test summary reports.
• Continuously improve test models, test data, and test processes based on lessons learned.
• Used Informatica ETL tool for Extraction, Transformation and Loading the data into target database.
• Tested ETL Packages, Scripts from development to QA environment.
• Plan tests with Quality Center (Design Steps and Run Tests) and also prepared detailed documentation with Screen Shots
• Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Tested whether the reports developed in Business Objects are as per company standards.
• Developed test reports and participated in testing prioritization and archived test results and user signoff.
• Involved in extensive data validation using SQL queries and back-end testing
• Used SQL Server Management Studio for Querying SQL Server 2008 databases.
• Written complex SQL queries to validate the data against the target based on ETL mapping specifications.
• Used Tidal scheduler for composing and executing the jobs to simulate the production environment in QA.

Environment: ETL (INFORMATICA), SSIS,UNIX, IBM Rational Clear QuestV7.0, IBM Functional tester, Windows XP, SQL Server 2008, Oracle 10g, HP Quality Center 10, TOAD, WinSQL, Teradata SQL Assistant, XML Spy 2010, XM L Files, MVS, JCL, COBOL II, Copy Books, VSAM Files, CSV Files, Business Objects XIR3

Confidential

Software Test Engineer

Responsibilities:

• Understanding of complex financial business requirements
• Writing test plans and test scripts
• Maintained Progress Report of team members for update on individual work during test execution cycle.
• Written complex SQL queries.
• Tested several Ab Initio graphs for data movement between source and target
• Performed testing in mainframe environment
• High Level Test Case Design and writing detailed test cases
• Involved in extensive DATA validation using SQL queries and back-end testing
• Reported periodic project status and updates to the QA Lead and QA Manager
• Heavily involved in interacting with UNIX Shell scripts.
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
• Exporting test cases to Test Director
• Preparation of Data Requirements
• Data Mapping (one-to-one mappings)
• Accessing mainframes and validating the data
• Identify & record defects with required information for issue to be reproduced by other teams.
• Worked with high-volume, real-time DB2 database applications and systems
• Conducted Bug Review meetings for update on defects from development team & retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application.
• Experienced in co-ordinating resources within Onsite-Offshore model
• Conducted Training Sessions and Knowledge Transfer Sessions on new applications
• Managing testing documents in Test Director.

Environment: Ab Initio (GDE 1,12, Co>Op 2.12), Shell Scripting, Windows, SQL, PL/SQL, Mainframes, MVS, COBOL II, VSAM Files, JCL, .Net, DB2, ASP.Net, Test Director