PROFESSIONAL SUMMARY:

• Over 7 years of extensive experience in Information Technology with emphasis on Quality Assurance, Data warehousing Testing, Manual testing of Web and Client/Server based commercial applications.
• Involved in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Experienced in DW projects ETL testing against DW testing with Informatica and Ab Initio tools.
• Strong working experience in the Data Centric Testing, Data Analysis, Design and Development
• Well versed with Software testing concepts, SDLC, Agile and Waterfall methodologies
• In depth technical understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, Data Warehousing/ETL testing and BI Reports Testing
• Extensive ETL testing experience using Informatica Power Center 8.1/7.1/6.2 components (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Expert in using Test Management Tools - TFS, ALM / HP Quality center 10 / 9.2
• Worked with different querying tools like SQL Assistant, TOAD, Oracle SQL Developer, iSQL * plus
• Experience in writing complex SQL and PL/SQL statements.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Experience in testing Business Report developed in Business Objects.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments.
• Expert in Test plan, Test strategy, Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Implemented various Test cases for the Functional Testing, smoke testing, re-testing, Regression Testing, Configuration Testing, Performance Testing, Back-End and User Acceptance testing (UAT)
• Ability to understand and adapt to new technologies and environments faster, good at analysis and troubleshooting and excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Test Management Tools: TFS, Visual Studio, ALM, Quality Center 10.0 / 9.0/8.2

ETL Tools: Informatica 9 / 8.6/ 8.x, SSIS

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 6.5/7.0/7.5/2005, Sybase12.0/11.0, MS Access 2005, Teradata V2R6/V2R5 / 13

Reporting Tools: SSRS, Business Objects, Cognos 8.0

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, New York

ETL Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Interacted with senior peers or subject matter experts to learn more about the data.
• Validating the Workflows and running them using Workflow Manager.
• Created Unix Shell Scripts for Data Centric applications
• Experienced in writing complex SQL queries for extracting data from multiple tables and validating with target tables.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Experienced in creating the SSIS packages, DTS packages.
• Promoted Unix/Informatica application releases from development to QA and to UAT environment.
• Experience testing tables like SCD Type 1, Type 2 & Type 3 verified history load and incremental load data.
• Developed advanced 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.
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Tested ad hoc and canned reports for Business objects.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Worked in an Agile technology with Scrum.
• Used Quality Center for defect tracking.
• Involved extensively in doing back end testing of the data quality by writing complex SQL.
• Involved in developing Test Plans, Test Strategies and Test Cases using Team Foundation Server (TFS) 2012 and Microsoft Test Manager.
• Personalized SSRS Connection for specified display options for testing regional options and rmation.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Ensured data integrity and verified all data modifications and calculations during database migration.
• Responsible for communicating Defect Status Reports to business in project meetings
• Worked with Production environment to resolve several data issues.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Performed Functional testing, System testing, Regression testing and Back end testing.
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings
• Involved in Production Support related activities including resolving end user queries, investigation and resolving data related issues
• Provide flexible & high quality support to wider Testing strategies on key regular deliverables & Adhoc reporting issues
• Managed and executed the test process, using Agile Methodology.
• Tested whether the reports developed in SSRS are as per company standards.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.

Environment: Informatica 9.1, Business Objects XIR3, SSRS, Agile, Oracle 10g, Quality center, SQL Server 2008, SQL, PL/SQL, T-SQL, Oracle, Flat files, Excel Files, SSIS, UNIX, Visual Studio/TFS

Confidential, Madison, WI

QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Created adhoc Reports and Data centric tests for to satisfy business in testing SQL server environments
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Responsible for testing Business Reports developed by Business Objects XIR2.
• Deleting the target data before processing based on logical or physical primary key.
• Analyzed and created the bug tracking reporting and summary report in the Quality Center.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Design and execute the test cases on the application as per company standards.
• Testing of records with logical delete using flags.
• Interacting with senior peers or subject matter experts to learn more about the data.
• Identifying duplicate records in the staging area before data gets processed.
• Tested Ad-hoc reports, drill down and drill through reports using SSRS.
• Worked in an Agile environment
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Reported software mismatches (from the test planning), to the development team using Quality Center
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process
• Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
• 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.
• Prepared Test Cases based on functional requirements using MS Visual Studio
• Created, tracked and closed customer issues, and development bugs using Visual Studio 2010
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Extensively worked on designing various output and management reports Using SQL Server Reporting Services (SSRS)
• 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.
• Use Business Objects OLAP Intelligence to natively access and analyze OLAP servers. OLAP Intelligence tool helps to Slice, dice, and drill directly on multidimensional sources and deliver workflows via the Web, Windows, and Microsoft Excel.
• Extensively tested several Cognos reports for data quality, fonts & headers.

Environment: Informatica 8.6.1/8.1, Business Objects XIR2, Oracle 9i, Visual Studio, TFS, SQL, Quality center, PL/SQL, SQL Server 2008, UNIX, UNIX Shell Scripting, IBM DB2, XML, SQL *Loader, Erwin 3.5, SSRS, Windows 2000, TOAD 7

Confidential, Richmond, VA

ETL Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Involved in Data centric testing using various approaches such as checksum approach to discover errors, identifying records with MD5
• Written Test Cases for ETL to compare Source and Target database systems.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet designer and Transformation.
• 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 the ETL process for both before data validation and after data validation process.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Testing TEMPhas 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.
• Experience testing tables like SCD Type 1(Staging Tables) and Type 2(Target Tables)
• 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.
• 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.

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, San Antonio, TX

QA Analyst (Manual)

Responsibilities:

• Work as a QA Analyst on different projects for the Web based application written in Java and .Net
• Performed GUI, Integration, Regression, and Negative testing on multiple projects
• Created appropriate test cases and test scenarios and logged defects in Quality Center
• Worked with the developers and Business group involved in production testing, was engaged in full cycle of testing from start to end
• Reviewing, analyzing results, risk assessment and defect tracking by Quality Center /ALM
• Communicated timely project status to appropriate levels of management
• Worked in an Agile environment
• Involved in testing the Mainframe based Mortgage application called Citilink
• Successfully completed the for the Citi link application
• Executed high risk testing in production environment on release day
• Assured customer satisfaction with proper documentation and reports

Environment: Mercury Suite (WinRunner7.0, Test Director 7.2,), HTML, MS SQL, Mainframe, DB2, PLATINUM, FILE-AID, COBOL, SPUFI, Clear Quest, SOAPUI