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 HP Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• TEMPHas 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 SSRS, 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 in SQL server 2008.
• 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

Languages: SQL, TSQL, PL/SQL

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

Database: SQL Server 2008/2014, Oracle 9i/10g, Teradata V2R6

Datawarehousing and Modelling: Star Schema, Snow Flake Schema, Kimball Methodology, Bill Inmon Methodology

PROFESSIONAL EXPERIENCE

Confidential, IL

Business Intelligence - ETL Test Engineer

Responsibilities:

• Worked directly with the team of testing specialists on assigned projects.
• Used the Agile Project Management tool - Mingle and TFS to determine the Stories and derive the test details.
• Prepared and Maintained the Test strategy, test design, test cases, and traceability for applications under test.
• Responsible for the full life-cycle of the test phase of a project from its kick off until delivery and readiness to be deployed to Production
• Performed test task estimation, test execution, Regression testing, Functional testing, automated testing where possible.
• Worked with the teams closely to progress the testing toward realistic achievable milestones.
• Escalate information as deemed necessary and provided regular status reports on the same.
• Testing features and defect fixes to new and existing backend web services
• Created and executed manual and automated tests, document testing practices, and communicate results/recommendations to team.
• Worked with other IT and technology teams to refine technical specifications for test analysis and quality assurance.
• Effectively communicate with developers and other QA engineers and understand effectively how the business works with the associated data.
• Actively participated in team processes and use of methodologies, including customized flavors of Agile
• Followed all established Redbox QA policies and procedures
• Responsible for testing of the ETL solutions developed using SQL Server Integration Services (SSIS) 2005 / 2008 / 2012 and SQL / T-SQL.
• Responsible for testing of business intelligence reporting solutions developed using SQL / T-SQL and SQL Server Reporting Services.
• Responsible for testing Cubes developed using SQL Server Analysis Server (SSAS) and mdx scripts and XMLA files.
• Developed and maintained the manual and automated test scripts, functions / SQL code.
• Developed complex SQL queries using querying tools and SQL/T-SQL and relational database manipulation
• Understanding of data rollups/aggregation, capacity planning, data standardization, slowly changing dimensions and data security
• Designed and executed test scripts and plans for unit, integration, regression and UAT testing processes

Environment: Agile Project Management tool - Mingle, Team Foundation Server (TFS), SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SVN, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Tortoise SVN

Confidential, NC

SQL/BI Tester

Responsibilities:

• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing
• Wrote 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
• Created external tables based on the copy book to load the source data
• Wrote 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.
• Coordinated 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 leaded a team and coordinated 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.
• Experienced 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
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Java, MS SQL Server,, SSIS,SSRS,SSAS, 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, PERL

Confidential, NJ

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
• Designed the template and structure for data extraction and processing using SSIS and its different tools from different sources of Production server, Excel sheets
• Experienced in working with DB2,Teradata
• Extensively worked on designing various output and management reports Using SQL Server Reporting Services (SSRS)
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies wat 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
• Wrote 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
• Wrote 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
• Was responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experienced in creating UNIX scripts for file transfer and file manipulation
• Validated 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: SSIS,SSRS,SSAS,, 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, PERL

Confidential, Co

SQL/QA Tester

Responsibilities:

• Analyzed new Business requirements for each & every release and worked with analysts and business team for any gaps found during the test analysis
• Prepared Test plan, Test scenarios and writing & execution of Test cases
• Identified 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
• Wrote 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).
• Wrote and Executed the UNIX test cases on EDI format and verify Translation response
• Performed Reliability testing for testing the UNIX servers
• Was 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: 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