SUMMARY:

• Having around 7+ years of experience in Analysis, Testing, Design, Development and Quality Assurance testing of Host, Client/Server, Data Warehousing and WEB based Applications. Experience in Banking, Logistics, Brokerage, Insurance and Financial domains.
• Having extensive experience in performing automated and manual testing using Rational and Mercury tools.
• Involved in complete System Analysis, Design, Development, Testing (SDLC), Maintenance, Enhancement and Quality Assurance of software applications.
• Experience in different software development life cycle methodologies like Rational Unified Process, waterfall model, Agile scrum, RAD, Spiral etc
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting.
• Experienced in Onsite-Offshore Co-ordination, Test Management, Test Automation, Onsite Offshore Model Process Consulting, Requirements Management, Defect Management, Release Management and Team Management. Has performed planning and testing of Client/Server and Web applications
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Experienced in creating the SSIS packages, DTS packages.
• Experience in testing Business Report developed in Business Objects XIR2
• Involved in Business Requirement Analysis, and writing Test Plans, Test Cases, trace matrix, Test Scripts for middleware, Data warehousing, web-Based, Client/Server and Stand-Alone applications.
• Good knowledge on Data warehousing / ETL Concepts, Database testing, Manual Testing
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with Oracle PL/SQL programming. Writing positive and negative Scenarios and Test Cases for System & Security testing.
• Experience working with UNIX, Shell scripting, SQL scripting(Complex Queries), Test cases, Test scripts, managed version control software and defect tracking systems
• Involved in performing functional, system, and user acceptance testing manually.
• Involved in testing end to end ETL Process DWH applications and used SQL Queries for data validation in ETL process.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Performed Integration testing, System testing, Black Box functionality testing, Regression testing, UI testing Back end testing and User Acceptance Testing .
• Strong experience in Tracking Bugs and Generating Reports using Mercury Quality Center and Documenting test documents using MS Office tools.

TECHNICAL SKILLS:

Testing tools: Clear Quest, Quick Test Pro (QTP), Mercury Quality Center

Testing Languages: SQA Basic, VB Script. C, C++

Bug Reporting: Rational Clear Quest and Test Director, Quality Center

Application Servers: Web Services, Web Logic, Apache Tomcat and Web sphere

Programming Languages: SQL, C, C++, Java 2.0,.NET, HTML, DHTML, XML

Databases: DB2, Sybase, SQL Server, Oracle & Teradata

Operating Systems: MS-DOS, Windows, Windows2000, XP, NT, UNIX, Linux

ETL/BI/Others Tools: Informatica 8.6.1/8.5/7.1/6.1, Ab Initio, Data Stage, SSIS, SSRS, SSAS, Business Object XI R3, Crystal Reports, Quest Toad, OBIEE, Cognos, XML Spy 2010

MS-Suite: MS Office, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, St. Peters burgh, FL

Sr. ETL Data warehouse BI Test Analyst

Responsibilities:

• Lead numerous projects throughout the SDLC, involving onsite and offshore resources.
• Extensively analytics and test pilot versions of incentive and loyalty products (Coupons/Rewards).
• Technical subject matter expert to provide sound advice, support and governance on Data Warehouse testing.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Extensive testing experience in designing and developing Unix Shell Scripts for automation of ETL Process, Error handling and Auditing.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Involved in collecting Business Intelligence reporting data from managers, staff across divisions and across geographies
• As a Lead, was involved in weekly status, following up the development as well as the business /Testing teams, re-scoping project planning
• Tested different reports including detail, summary reports and on demand reports developed by SSRS Report Studio.
• 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.
• Configured Quick Test Pro with Quality Centre and Maintained the project information in Quality Centre.
• Written complex SQL queries to validate the data as per mapping rules.
• Used Quality Center for bug reporting.
• Tested SSIS packages for transferring data from corporate and other non SQL server databases to populate various tables.
• Provide 24x7 supports to external teams during project go-live period. Co-ordinate smoke testing process and integration issues.
• Perform statistical analysis on data for trend analysis and test Vs control analysis for decision making.
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts.
• Expert in data cleansing for accurate reporting of campaign data. Thoroughly analyze data and integrate different data sources to process matching functions.
• Conducted weekly onsite-offshore status meetings .
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Generated test script based Business Requirement Document (BRD).
• Identified Test cases at Unit level, System level, Enterprise level.
• Performed manual testing using toad on Enterprise Database.
• Ad hoc analysis to provide data for laying out coupons campaigns based on various qualification criteria.
• Extensively used rational clear case for version control and clear quest for bug tracking during the SDLC.
• Prepared and executed test cases ensuring that specified technical requirements were achieved
• Involved in various data pulls for OLAP cubes for reporting. Co-ordinate with reporting team and business to identify Facts and Dimensions. Involved in high level Report Layout design to mark Attributes, Metrics and Prompts.

Environment: Informatica 9.1/8.6.1, SSIS/DTS, MS SQL SERVER 2012, SSRS, SSIS,SSAS, Business Objects XIR3, Oracle 11g, Teradata 12, Linux, Toad, IBM DB2, IBM AIX 5.5, Rational Clear Quest, Toad, HP ALM, HP Quality Center 11.0, HP QTP 11.0, Rational Clear Case, XML, XSD, XML Spy 2010

Confidential, New York, NY

Sr. Data Warehouse BI SQL Tester

Responsibilities:

• Interacted with clients to determine User requirements and goals.
• Participated in analysis of Business and functional requirements
• As a Test Lead Created Test plan, Test scenarios and test cases
• Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
• Developed Test Plan and overall Test Strategy for the Application.
• Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Performed Positive and Negative Testing for this application.
• Extensively used SQL queries to check storage and accuracy of data in database table
• Performed basic testing of security features using manual testing
• Responsible for creating Test Strategy for the Data Warehouse
• Submitted Status and Test Evaluation Reports to Test Lead on daily basis and Constantly updated test deliverables
• Responsible for identifying and defining the Key Performance Indicators in SSAS.
• Involved in creating the design and technical specifications for the ETL process of the project.
• Worked on trimming the SQL and optimizing the SQL by using various VLDB settings in the MSTR to avoid the cross join and removing multiple passes.
• Tested different reports including detail, summary reports and on demand reports developed by SSRS Report Studio.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation
• Worked as a lead to resolve issues during critical phase of projects and guide junior testers and even played the role of a mentor whenever required.
• Testing of Business Objects and Reports which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects, tested the Universe Structure to ensure that tables are properly uploaded.
• Strong ability in developing 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
• Used Erwin to reverse engineer the existing database design in SQL Server.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Developed Regular Expressions using PERL for parsing needs.
• Tested Business Objects reports and Web Intelligence reports
• Performed Positive and Negative Testing for application.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005/2008
• Extensive user of Clear Quest for defect tracking, process automation, reporting and lifecycle traceability for better visibility and control of the SDLC
• Strong Windows operating-system background, with understanding of the key drivers and influences on performance
• Developed SQL Stored Procedures and Queries for Back end testing.
• Involved in automation of test cases using QTP.
• Reported bugs and tracked defects using Rational Clear Quest.
• Tested web forms from test to production using Export and Import.
• Tested various business rule and data load rule files.
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other
• Involved in the production support team for planning cycle after production implementation
• Strong ability in developing 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
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Written several UNIX scripts for invoking data reconciliation.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the Oracle database in UNIX environment
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Extensively used Informatica power center for extraction, transformation and loading process
• Created and maintained test scripts in Rational Clear Quest and co-ordinate with the ETL group and other developers.
• Interacting with the Offshore Team members about the project status through Conference calls and need to prepare a Teams of Memorandum for the same.
• Involved in offshore and onsite Coordination activities
• Synchronized the dimensions of development planning with production planning
• Troubleshooting the planning web forms with user testing
• Involved in integration/system testing and backup/restore testing for all components
• Involved in the production support team for planning cycle after production implementation.

Environment: Informatica Power Center 8.6, (Power Center/ Power Mart,) Rational Clear Quest, VB Script, Erwin 9.3, SQL Server 2010, SQL Plus, Business Objects XIR3, SSRS, SSIS, SSAS, SQL, PL/SQL, MS Excel Add-in, XML, XSLT, XSD, Test Cases, Test Plan, Traceability Matrix, UNIX Shell Scripting, HP Quality Center 10, HP QTP 10

Confidential, SFO, CA

QA/Data warehouse Test Analyst - Credit Risk Datawarhouse

Responsibilities:

• Reviewed Business Requirement Documents and the Functional Specifications
• Implemented testing methodologies, framework, procedures and standards for the project. Documented test cases corresponding to business rules and other operating condition.
• Wrote test cases and test scripts for the functional testing and Regression Testing.
• Performed Database testing manually.
• Establish and organize Offshore Development Teams
• Worked with leadership team to analyze current SDLC process and recommended process improvements
• Tested Business Objects reports and Web Intelligence reports
• Implemented and supported the Business Intelligence environment and User Interface.
• Responsible for testing Business Reports developed by Business Objects XIR2
• 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.
• Involved in Identifying of the unused test cases in the Test Plan in Quality Center and prepared a consolidated doc to delete the test cases.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Tested stored procedures & views in MS SQL Server 2000/2005
• Designing the template and structure for data extraction and processing using SSIS and its different tools from different sources of Production server, Excel sheets
• Developed unit/assembly test cases and automated them using PL/SQL procedures and UNIX shell scripts to run along with daily/weekly/monthly batches to reduce or eliminate manual testing effort
• Developed ETL test cases for various lines of businesses based on ETL mapping document.
• Created and Executed Korn Shells in UNIX for ETL loading process.
• Tested several business reports generated using Excel pivoting and Dashboards.
• Investigating issues occurred while System testing and Regression testing.
• Involved in reading the log files to identify issues/errors in scripts for ETL process.
• Involved in validation of data according to the mapping documentGood experience in understanding Source and target
• Tested the ETL mapping. Worked with various transformation such as Joiner transformation, Lookup transformation, Expressions transformations
• Performed security testing to see how well the system is protected against unauthorized access
• Responsible for Database integrity testing by executing SQL statements
• Regression testing was implemented at various phases of the development and test cycles
• Reported and tracked testing progress in the customized bug tracking system Test Director
• Maintained and executed test cases and test scripts using Quality Center.
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Involved in testing complex queries using toad.
• Involved in Manual Testing, Integration Testing, System Testing, UAT Testing, Regression Testing, Functional Testing
• 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.
• Interacted with developers to report software bugs and re-tested the fixed versions
• Analyzed the defects and categorized them based on severity using Test Director

Environment: Informatica 8.6/7.1, Business Objects, Windows NT, Visual Basic, Oracle 9ix,MS SQL Server, SSRS, SSIS, Crystal Reports 7, MS Office, WinRunner 6.0, TestDirector 6.0, Mercury Quality Center

Confidential, Plano, TX

Data warehouse QA Testing - EDW

Responsibilities:

• Designed, developed Test Cases, and Test Scripts for UI, Functionality, Integration, and System testing
• Developed QTP Scripts to automate the reusability and regression functionality. Developed reusable functions and reusable actions in QTP
• Responsible for identifying and defining the Key Performance Indicators in SSAS 2005.
• Used Erwin to reverse engineer the existing database design in SQL Server 2000
• Created and executed automated test Scripts using QTP for Functional, Integration, and Regression testing
• Used SQL Queries for data validation in ETL process.
• 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 testing end to end ETL Process data ware housing applications for various releases
• Gathered the test cases which are common for every release and which can be executed for multiple sets of data for the purpose of regression testing by using QTP.
• Worked with Object repositories, functions, data tables and descriptive programming in QTP.
• Created Data Driven Tests to validate the same scenario with different sets of test data.
• Worked closely with the User Acceptance Test Coordinator, Project Manager and Business System Analysts to understand business processes and develop concrete User Acceptance Test (UAT) cases
• Extensively used test management tools like Quality Center, and QTP to carry out test case documentation, execution, and defect logging
• Responsible for creating traceability matrix to ensure all requirements are covered by test cases
• Responsible for testing a web-based portal that accepts new loan applications which is built on a .Net framework and make sure functionality, design conforms to User requirements
• Developed and exported test cases to Quality Center and mapped all test cases to the business requirements/rules
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log
• Developed and executed SQL queries for back-end testing in Oracle.
• Documented test results and SQL outputs and provided daily execution status to Team Lead
• Review target to source mapping documents and other design, requirement documents and identify design defects
• Executed test cases for web-based Micro strategy reporting application.
• Assisted the team lead with daily QA tasks. Attended project meetings, release meetings, and QA status meetings

Environment: Java, JSP, XML, IBM Web Sphere, QTP 9.0, 9.2, VB Script, Mercury Quality Center 9.0, Oracle, Informatica 7.1, MicroStrategy, Windows XP

Confidential, Phoenix, Arizona

ETL QA Test Engineer - Credit Card Data Services

Responsibilities:

• Study of Change Requests and preparing Test cases.
• Analyze Functional Requirement and Business Requirement Documents to get a better understanding of the system on both functional and business perspectives.
• Involve in writing and implementing the Test plan, Test cases, Test Procedures, Test sets using Use cases and requirement specification document.
• Developed design strategy of the Extract, Transform and Load for various ODW tables.
• Developed mappings with the Design Documents and also performed testing for various sample data.
• Data Quality Analysis to determine cleansing requirements
• Develop and maintain UNIX shell script for the ETL process and also for automate the system monitoring
• Develop mappings transformations like Filter, Joiner, Sequence Generator and Aggregator and perform query overrides in Lookup transformation as and when required to improve the performance of the mappings.
• Co-ordinate with team members for effective management for all project requirements and responsible for deliverables and receivables during all project phases.
• Reviewing Test Cases and preparation of Review Report based on HLD and LLD & TCS
• Involved in functional, integration, End-to-End, interface, performance, system, black box testing.
• Performed Compatibility Testing & Bug Reporting in Test Director.
• Created SQL queries to retrieve data from database to validate the input data.
• Prepared Test data for the inputs of the test cases.
• Tested the functionality of the application with multiple data including positive and negative data for multiple times.
• Re-testing the application for every new build.
• Attending client calls, status meetings.

Environment: Test Director, VB, C++, UNIX, Perl, XML, XSD, Xpath, Informatica 6.1, PL/ SQL, SQL, XSD