SUMMARY

• Information technology professional with 7+ years experience in Requirement’s Gathering, Analysis, Documentation, Testing, Implementation and Maintenance. Specialized in Quality Assurance and testing, worked as ETL Tester, BI Tester and QA Analyst
• Expert in writing complex SQL queries for data validation between source and target
• Expert in both ETL and BI testing
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling
• Experienced in creating the SSIS packages, DTS packages.
• Experience in writing Teradata SQL Queries for various needs including BTEQ, TPUMP, FLOAD, MLOAD & FEXPORT
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica, Ab Initio
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Experience in testing BI reports developed in Business Objects & Cognos Series
• Experience in testing XML files and validating the data loaded to staging tables
• Experience in testing and writing SQL and PL/SQL statements
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing.
• Familiar with implementation of SSIS (SQL Server Integration Services), Database Mirroring and Service Broker concepts which are some of the new features in SQL server 2005.
• Quality Assurance: Expertise in preparing Test Strategy, Test Plan, Test Summary Reports, Test Cases and Test Scripts for Automated and manual testing based on the User Requirement Document and System Requirement documents
• Experience in writing Test Plan and Test Strategies for Data Warehousing Applications
• Good experience in System, Integration, Performance, Sanity, Security, Load, Database, UAT, Usability and Regression Testing
• Excellent knowledge in using automation tools like QTP, Win Runner and Load Runner
• Professional Experience in Financial, Brokerage, Banking, HealthCare applications and strong understanding of Banking/Financials/Mortgage lending applications
• Good knowledge in Mutual Funds, Variable life, Variable Annuity, Mutual Funds Compliance, Agent Compensation
• Experience of various data warehousing, web-based, client-server and distributed multi-tier applications
• Experience in data validation of various sources like Teradata, DB2, Informix, Oracle, SQL Server and Sybase

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows XP,NT/95/2000, OS/2,Linux 6.X/7.X/8.X, UNIX

Data Warehousing: Informatica, SSIS, SSRS, SSAS, Informatica, Ab Initio, Business Objects

SCRIPTING LANGUAGES: PL/SQL, SQL

DATABASES: Oracle 9i/10g, Teradata V2R6, SQL Server 2000/2005, 2008

DATAWAREHOUSING & MODELLING: Star Schema, Snow Flake Schema, Kimball Methodology, Bill Inmon Methodology

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

ETL SQL/BI Tester

Responsibilities:

• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Experienced in working with DB2,Teradata.
• 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.
• Creating external tables based on the copy book to load the source data
• Writing source, target SQL’s based on the mapping documents and validating the data
• Used UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Coordinating the testing activities to complete System Integration and UAT Test preparation on schedule.
• 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.
• Experienced in defining, creating and implementing testing process and methodology for onsite/off-shore team.
• Data verification and validation using complex SQL queries
• Executed test cases/scripts and accurately & concisely reporting both progress and defect status.
• Utilized various testing methodologies and developed strategies, test cases, and executed testing for reporting and data validation of various Vendor feeds
• Used SQL for Querying the SQL server database for data validation and data conditioning
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Responsible for identifying and defining the Key Performance Indicators in SSAS 2005 .
• Created ETL test data for all ETL mapping rules.
• Experience in creating UNIX scripts for file transfer and file manipulation
• Worked with Data Extraction, Transformation and Loading (ETL)
• Tested SSIS packages for transferring data from corporate and other non SQL server databases to populate various tables
• Involved in testing data mapping and conversion in a server based data warehouse
• Used Quality Center to track and report system defects and writing test cases/scripts
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Informatica 8.6, MS SQL Server, SQL, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, TPUMP, BTEQ), PL/SQL, Teradata SQL Assistant 7.0, XML, XML Spy 2008,, UNIX, Shell Scripting, Quality Center

Confidential, Providence RI

ETL /SQL/BI Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 10.0
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing
• Experienced in working with DB2,Teradata.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Used various checkpoints in the Informatica designer to check the data being transformed
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2008
• 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 the test environment for Staging area, loading the Staging area with data from multiple sources
• Written several Sql and PL/SQL stored procedures. Tested the output of Statements from sql vs. ETL output.
• Used T-SQL for Querying the SQL server database for data validation and data conditioning
• Tested on the Data Validation rules of various input data files through the generic conditioning graph ensuring the integrity of data used for processing based on the rules
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Extracted Data using SSIS from DB2, XML, Oracle and flat files, Excel perform transformations and populate the data warehouse
• Written several complex SQL queries for validating Cognos Reports
• 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
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation
• Validating the data passed to downstream systems
• Tested different reports including detail, summary reports and on demand reports developed by SSRS Report Studio
• Tested data warehouse ETL process using SSIS (Integration Service)
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Worked with Data Extraction, Transformation and Loading (ETL)
• Involved in testing data mapping and conversion in a server based data warehouse
• Worked with business team to test the reports developed in Cognos
• Tested whether the reports developed in Cognos are as per company standards
• Used Quality Center to track and report system defects and writing test cases/scripts
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Informatica 8.6, DB2, Java, Cognos, SQL, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, TPUMP, BTEQ), PL/SQL, T-SQL, Teradata SQL Assistant 7.0, XML, XSD, XSLT, XML Spy 2008, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra edit, Rumba UNIX Display, Quality Center 10.0

Confidential, Atlanta GA

ETL SQL/QA Tester

Responsibilities:

• Analyzing new Business requirements for each & every release and worked with analysts and business team for any gaps found during the test analysis
• Preparing Test plan, Test scenarios and writing & execution of Test cases
• Identifying Impacts on the different telecom products and defining level of efforts for testing the software
• Identified Test Conditions in according to the BRD’s and Change Requests
• Written EDI(Electronic Data Interchange) test cases in UNIX in X-12 format based on the product mapping example and developer worksheet.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Written and Executed the UNIX test cases on EDI format and verify Translation response
• Performed Reliability testing for testing the UNIX servers
• Responsible for execution of Batch jobs and population test data for other teams
• Executed Complex SQL queries within UNIX shell scripts in the UNIX environment
• Responsible for FTP jobs to transfer data between UNIX test servers.
• Responsible for UAT’s
• Responsible for Production Monitoring during peak hours
• Regression Testing for Each and Every Release Using Win Runner
• Used Test Director & Rational DDTS as Test Management tool.
• Responsible for doing System Testing, Functional Testing, Integration Testing, Load Testing and Smoke Testing.

Environment: Informatica Power Center 7.1/6.2, Informatica Power Connect, Oracle 8i/9i, MS SQL Server7/2000, Teradata, MS Excel 97, Flat files, PL/SQL, SQL, Toad 7.0, SQL*Loader, Windows 2000, Unix (ksh) Shell and, Shell Scripting, XML Files.

Confidential, Atlanta, GA

Qa TESTER

Responsibilities:

• Worked on gathering requirements for loan level and pool level amortization process.
• Prepared detailed business requirement documents.
• Reviewed the Business Requirement Documents and the Technical Specification.
• Worked with a team of Systems Analysts and Programmer/Analysts to determine success or failure of tests.
• Used Test Director for bug tracking and reporting, followed up with development team to verify bug fixes and update bug status.
• Worked with heterogeneous sources from various channels like Oracle, DB2, SQL Server and flat files.
• Maintain SQL scripts for creation of database objects.
• Studied in detail the SRS,BRS, and the Uses Cases and Created Test Plan, Test Case Depending on Those requirements from SRS,BRS and Used Cases
• Analyzed the system requirements and developed detailed test plans and test cases and provided the documentation.
• Interacted with developers in fixing unknown exceptions Written Complex Sql Queries to perform backend testing
• Developed a Testing strategy before testing.
• Written all the Test case in Excel sheet and imported into Test Director.
• Automated some of the test case for regression purpose with mercury tool QTP.
• Designed Manual Testing strategy and performed Manual Testing of some of the modules/components of the application as per the requirements.
• Tested functionality, alignments, navigation, content, broken links using various instances.
• Tested application in Development, Functional, Staging and Production
• Used tools effectively for Defect Logging and Defect Tracking.
• Executed STS (System to System) test cases with third party tool Test Harness.
• For each build generated the Test Execution Reports and Graphs.
• Involved in the Integration Testing, System Testing, UAT Testing, Regression Testing
• Understood and studied all the uses cases and executed those in the Test Director.
• Worked on Test Director (Quality center) for the tool Enhancements.
• Conducted functional, System and Regression testing of the application using Quick Test Pro.
• Interacted with the team members and called for review meeting with Developers and Base's for understanding the requirements which are not clear.
• Tracked defects on the Requirements if they are not clear in Test Director

Environment: Oracle 8.0, DB2, Informatica Power Mart 6.x, SQL, PL/SQL, SQL*Loader, UNIX Shell Scripts, Windows NT.