PROFESSIONAL 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 BI Tester and QA Analyst
• Expert in writing complex SQL queries for data validation between source and target
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Extensively used Data Stage for extraction, transformation and loading process
• 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.
• 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 in data validation of various sources like Teradata, DB2, Informix, Oracle, SQL Server and Sybase

TECHNICAL SKILLS:

Test Management Tools: QTP, TestDirector 9.0/8.0/7.5, Quality Center 9.0/8.2:

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

Bug Reporting: Quality Center 9.2,Rational Clear Quest, Test Director, Bugzilla

Programming/Scripting Languages: SQL, PL/SQL, XSLT, JCL, HTML, XML

Operating Systems: Windows XP/NT/2000, DOS, Mac 10.4, AIX-UNIX, LINUX

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

PROFESSIONAL EXPERIENCE:

Confidential, Rochester NY

Sr. ETL/BI Tester

Responsibilities:

• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing
• Worked with ETL group for understanding Data Stage graphs for dimensions and facts.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Experienced in working with DB2,Teradata
• 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.
• Managed Financial Processing that served as primary lead for corporate financial systems, including accounting processes for accounts receivable and accounts payable systems.
• Managed financial spreadsheets and vendor accounts. Spearhead collection processes and manage accounts receivable personnel
• Different Data Stage components especially are used effectively to develop and maintain the databas
• Experienced Batch Scheduling in the Autosys tool.
• Investigate root cause analysis of batch scheduling
• Test Scripts were written in MS Excel and then imported to Quality Center/Test Director.
• Experience in creating UNIX scripts for file transfer and file manipulation
• Tested SSIS packages for transferring data from corporate and other non SQL server databases to populate various table
• Extraction, Transaction and Loading was done using different Components and different expressions using Data Stage to create test data.
• 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: Data Stage, Java, MS Oracle 10G, DB2, Teradata, SQL Server, SSIS,SSRS, SQL, PL/SQL, Teradata SQL Assistant 7.0, XML, XML Spy 2008,, UNIX, Shell Scripting, Quality Center 10.0.

Confidential, Richmond, VA

ETL QA/SQL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing
• Designing 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 used Data Stage for extraction, transformation and loading process.
• 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
• Scheduling and automating jobs to be run in a batch process.
• Executed and scheduled tasks; batch processing, metadata management and data mapping.
• 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
• 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.
• Worked with ETL group for understating Data Stage.
• Extracted Data using SSIS from DB2, XML, Oracle and flat files, Excel perform transformations and populate the data warehouse
• 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 Win SQL for Querying DB2.
• Strong in writing UNIX shells scripting. Automated and scheduled the Data stage jobs using UNIX Shell Scripting.
• 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: Data Stage, SSIS, SSRS, DB2, Java, SQL, PL/SQL, T-SQL, Teradata SQL Assistant 7.0, XML, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra edit, Quality Center 9.2

Confidential, Howell, NJ

ETL Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• 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.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Performed Data Analysis during the requirements gathering phase by reviewing the source data model and running SQL queries
• Testing has been done based on Change Requests and Defect Requests.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Involved in integration testing of Informatica mappings.
• Performed all aspects of verification, validation including Functional testing, Unit Testing, System testing, Regression testing, structural testing, Performance, load and Back-End testing manually.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant
• Used Quality Center to track and report system defects.
• Ran shell scripts in UNIX platform to Load data into Retek database.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Created reports that included a general overview, open bugs, new bugs and enhancement requests. Entered new bugs and maintained the current status of those bugs.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Worked closely with engineering team to discuss the design and testing aspects of the applications to design the test plans and to isolate the root cause of defects.
• Involved in meetings and walkthroughs.
• Responsible for weekly status.

Environment: Informatica Power Center 7.2 (Power Center Designer, workflow manager, workflow monitor, UNIX, Oracle8, Teradata V2R4, SQL Server 2005, Windows 2000, Cognos8.4.1,Quality center 9.2

Confidential

QA Tester

Responsibilities:

• Created Test Plan and Test Scripts and analyzed the user/business requirements. Functional specs, Use Case documents and created the Test Plans, Test cases for System testing.
• Executed of generated Test Cases Manually in Test Director.
• Created the Regression Test cases and automated them for the purpose of regression Testing.
• Developed and maintained automated test scripts to support regression testing and participated actively in system testing and regression testing.
• Developed and maintained the regression test bed.
• Complete responsible for manual testing of the Web Site.
•  Attended project meetings, release meetings, and QA status meetings.
• Conducting user interviews at both in-house and client locations, gathering and analyzing requirements using Requisite Pro RUP.
• Perform Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Conduct workflow, process diagram and gap analyses to derive chuck for existing systems enhancements
• Assist with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.

Environment: MS Visio, MS Excel, MS Word, MS PowerPoint, SQL, MS Project, 7.0, Windows NT, Web Logic Server 7.0, Java, J2EE, Oracle 8i , EJB 2.0.