SUMMARY

• Over 9+ years of overall IT exposure in Quality Assurance using Manual & Automation testing with Data Warehousing which involves ETL, Teradata, Reporting and Data modeling experience.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP and SDLC methodology environments
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies
• Proficient in using ABInitio workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions
• Proficient in using Datastage Designer and Director for monitor to create, schedule and control workflows, tasks, and sessions
• Extensive work in ETL testing using SQL, UNIX, PL/SQL.
• Strong SQL query skills using an enterprise wide RDBMS (Oracle, MS SQL Server & MS Access) and familiar with concepts of SQL queries ranging from DML, DDL and TCL
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, MYSQL and Teradata
• Extensively tested data validation, load processes (ETL) using Toad and SQL Developer.
• Experienced in testing BI reports generated using different BI tools like MicroStrategy and Business Objects
• Experience in testing/validating the Source, Stage and Target (End - to-End).
• Experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing and Performance Testing.
• Good Knowledge in Data Modeling and HADOOP.
• Experience in Functional Testing, Data Driven Testing and Web/HTTP for Web Services using SOAP UI, iTKO LISA and SOA Test tool.
• Extensively performed automated testing for SOAP/WSDL/XML web services for the different portfolio event alterations by iTKO LISA Test.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Co-ordinate in creation and execution of QA and testing processes, test strategies and plans, bug documentation and bug tracking and used Requirement management and bug tracking testing tools like Quality Center and Clear Quest.
• Team Player with excellent communication, analytical, verbal, writing and interpersonal skills.
• Team management for onsite-offshore teams including performance tracking and technical support.
• Time management, Strong analytical, Excellent organizational, Detail oriented and problem solving skills with a consultative approach in defining solutions.

TECHNICAL SKILLS

Data Warehousing ETL: Abinitio, Data Stage, HADOOP, Repository, Metadata, Data mart, FACT & Dimensions tables.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams

BI Tools: Cognos 8.x/7.0, Micro Strategy, Business Objects XIR3/XIR2/6.x

Databases: Oracle 11g/10g/9i/8.0, MySQL 5.4, MYSQL, OLTP

Programming: SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, C, Java, HTML,XML, Perl, PHP, JavaScript

Tools: TOAD, SQL*Plus, Dream weaver

Environment: UNIX(IBM AIX, Sun Solaris), Windows XP/Vista, Linux(RHEL)

Testing Tools: HP Quality Center 10, QTP,Selenium, Test Director

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Sr. DWH System Analyst/QA Test Lead

Responsibilities:

• Interacted with clients to determine User requirements and goals.
• Participated in analysis of Business and functional requirements
• 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
• Involved in creating the design and technical specifications for the ETL process of the project.
• 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 2000
• Developed Test Cases and Test Scripts for System and UAT Testing.
• 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.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Involved in automation of test cases using QTP.
• Tested various business rule and data load rule files.
• 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
• Involved in extensive DATA validation using SQL queries and back-end testing
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Involved in offshore and onsite Coordination activities
• 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: Erwin 8.0, SQL Server2012, Business Objects XIR4, SQL, PL/SQL, MS Excel Add-in, XML, XSLT, XSD, Test Cases, Test Plan, Traceability Matrix, UNIX, QTP, HP ALM

Confidential, Eden Prairie, MN

Sr. DWH ETL Tester

Responsibilities:

• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center/ALM and performing end to end testing and created Reports.
• Participated in Regression testing after each build
• Extensively worked in agile environment, with daily scrum meeting, stand up meetings, presentations and review
• Performed Data Analysis and data profiling using SQL and ETL DataStage Data Explorer on various sources systems including Oracle and Teradata
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Datastage.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Involved in the error checking and testing of the ETL procedures and programs DataStage session log.
• Wrote Complex SQL queries to validate the standard reports, Dashboards and BI Business objects Universes.
• Involved in preparing the Data-driven and keyword-driven frameworks in QTP for system and UAT environments and performed data comparison and functional comparison.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Loading Flat file Data into database tables using Unix Shell scripts.
• Co-ordinate with development and QA team for handling of defects with respect to data
• Validated Business Objects Reports and Universes against Data warehouse/Data mart Database by writing SQL Queries
• Performed data quality analysis using advanced SQL skills.
• Expertise in bug-reporting and bug-tracking using the test management tool like Clear Quest, ALM and Quality Center.
• As an ETL Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries Microsoft SQL Server.
• 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
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server and Oracle to load into the Oracle data warehouse
• Performed Regression testing with QTP by executing the automation test scripts
• Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Tested and validated the Business Objects reports by running similar SQL queries against the source system(s).
• Working on a integration project with the SQL server data services to maintain the data quality by creating new look ups
• Used SAOP UI as an integration project to validate the request /response in data using assertions.

Environment: ETL Informatica 9x, BI Business Objects XIR4, Quality Center/ALM (HP Application Lifecycle Management 11.0), QTP, SQL Server 2012, UNIX, Oracle 11g, Datastage, SQL, PL/SQL, Oracle 10g, Agile, MS Office, Teradata 12, DB2, XML, HTML, Windows and Unix, Shell Scripting, SOAP UI, SQL Server Data services 2012.

Confidential, San Francisco, CA

QA Analyst

Responsibilities:

• Analyzed the existing Process plan, requirement docs, and application functional specs in a structured RUP environment.
• Attended meetings and walkthroughs with Business Analyst, Development Lead and QA Team
• Coordinated the key strategic planning, program development, implementation and evaluation committees.
• Analyzed the all types of the document in ordered to achieve the validate all features of the product
• Developed the main automation steps in Integra and iTKO LISA automation tool
• Extensively worked with QC to develop full lifecycle Test Plans including business rules and business models for functional, end to end and User Acceptance testing
• Categorized the Test Cases based on priority and managed them in Quality Center
• Developed Test Cases to validate the functionality and business logic implementation
• Verified the workflow with different scenarios and created Test Data sets for simulating scenarios
• Developed and executed SQL scripts to validate the database activities and data generation
• Performed GREY-BOX tests on application functionalities and verified the interfaces to content
• Execute test scenarios to verify the data transfer and standard formats (XML), Web Service requests and data processing (XML, XML Spy)
• Validate the message response against message specification and against XML Schema
• Responsibility to write the major SQL commands to validate the Web Services update and feed the seed script in order to make test case is recursive
• Major involvement in Regression failures due to customer data problem. Interact with data team to fix the data problem ASAP
• Expertise in MQ and AQ concept to trouble shootings. Unix shell scripting experience for automation of processes
• Led the test engineers in analyzing the data processes and developing test cases.
• Leveraged expertise on XML and XSL, SOAP, Web Services and related tools and techniques, as well as object-oriented coding methodology for application logic, data storage and report generation.
• Extensively worked with XML Spy for editing, analyzing XSL formats and tags and verified Web Services requests and responses.
• Used Altova XML Spy to generate XML, DTD and to create a SOAP request from a WSDL file and then test the service.
• Led the functionality, integration, system and regression testing and executed various test cases to validate the web functionalities and dynamic data contents.
• Performed Regression testing using iTKO LISA test of the entire build according to the change been updated and ensuring by cross validating the entire components of the application.
• Analyzed the iteration plan and studied the task distribution diagrams.
• Worked with simulators and recorders (Web/HTTP) to simulate web transactions, and executed real time scenarios with load (Virtual Users).
• Configured simulators in iTKO LISA to measure performance of the servers (CPU Utilization, Memory, Hits/sec, Response time).
• Worked towards process improvement, and contributed with Templates and workflow formats

Environment: and Tools: iTKO LISA, SOAP UI, Integra (Automation, Simulator and Recorder), IBM MQ Series, Oracle AQ concepts, XML Spy, HP Application Lifecycle Management 11.0, Clear Quest (WIB and Windows client), Clear case, Oracle, Terra data, Java, Eclipse, MS Office, UNIX, SOA Architecture.

Confidential, Foster City, CA

QA Engineer (Performance Testing)

Responsibilities:

• Analyzed the existing Process plan, requirement docs, and application functional specs in a structured Agile environment.
• Participated as a team member in the Agile development process, working closely with the other team members to complete the set sprint assignments and meet production goals.
• Attended meetings and walkthroughs with Business Analyst, Development Lead and QA Team.
• Responsible for supervising the team in the absence of Lead.
• Conducting knowledge transfer session for testing team.
• Proficient in analyzing the SRS (Software Requirement Specifications), Functional Design Documents to formulate Test Plans and Test Strategies.
• Wrote test cases for each valid transaction and reported bugs.
• Involved in Functional, Regression, Integration and Compatibility Testing of web-based application.
• Extensively worked with QC to develop full lifecycle Test Plans including business rules and business models for functional, end to end and User Acceptance testing.
• Expertise in MQ concept to trouble shootings.
• Profound knowledge in IIS Manager.
• Validated request/response of data using assertion in SOAPUI.
• Manually performed back-end testing by writing SQL queries.
• Actively participated in daily bug triage meetings and interacted with developers diplomatically to ensure high quality of the application under test.
• Compared actual and expected test results, discussed the defects in defect meeting with development team.
• Responsible for updating and maintaining the test results in Quality Center (HP Application Lifecycle Management) and Clear Quest for all the defects found during functional and regression testing and follow up of the bug life cycle.
• Used simulators (Web/HTTP) to simulate web transactions.
• Created test data to cover all positive and negative scenarios.
• Primarily involved in Integration Testing of Web based Application and its integration with the back end application and Database.
• Validated the web elements (links, images, html tags and forms) to ensure user friendliness and verify security features.
• Reporting to QA Manager and coordinating with development team for completion of testing and fixing-bugs tasks.

Environment: and Tools: Windows, UNIX, MAC OS, SOAPUI 3.6, Quality Center 9.2, HP Application Lifecycle Management 11.0, Clear Quest, IBM WebSphere MQ 7.0, MS SQL Server, DB2, MS Office, SOA test 9.2, Putty, Agile Methodology, IIS Manager.

Confidential, Troy, MI

QA Engineer

Responsibilities:

• Involved in understanding Business Process and coordinated with Business Analysts to understand specific user requirements.
• Tested the extracted the data from heterogeneous sources like .dat file, Excel file, .csv file, flat files, Oracle etc and loaded into target tables Oracle.
• Created and implemented Business Objects reports by creating projects, schema objects and public objects, Attributes, hierarchies, metrics, filters, and templates.
• Extensively used the Sequential File, Dataset, Join, Look-up, transformer, Funnel, Xml and Connector stages provided by ABInitio to perform transformation and load the data.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Involved in developing detailed Test strategy, Test plan, Test cases and Test procedures using Quality Center for Functional and Regression Testing
• Worked in an Agile technology with Scrum
• Prepared Test Scripts and test Plan for automated testing using QTP
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the Business Objects SQL engine generated queries.
• Used standard testing techniques to test the data validity before deploying the Business Objects Reports to Users.
• Tested several ABInitio ETL mappings and ran on UNIX for loading purpose and checking the log files
• Validated ABInitio logic by executing ETL Wrappers and Autosys jobs by using SQL and Unix Shell scripts
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Expertise in MYSQL Database.
• Used SQL functions, clauses, Wildcards etc for extensive testing of the warehouse
• Tested slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Used SQL Queries to validate the data on daily basis
• Queried Teradata Database and validated the data using Sql Assistant
• Running SQL Query's in TOAD for counting the no of rows from the tables
• Monitoring the ETL jobs and coordinating the Bug fixes.
• Used Quality Center for Bug reporting, tracking & generation of Test Metrics
• Participated in the review and maintenance of data security standards to protect information assets.
• Tracked the defects to closure.
• Used Rational ClearCase to manage testing artifacts and maintained testing views and streams.
• Used Rational ClearQuest for defect logging, tracking and report generation.
• Involved in meetings with the Project Manager and provided updates of the testing team.

Environment: ABInitio 8.6, Oracle 10g/9i,QTP, Business Objects, IBM DB2, Quality Center, ClearCase 8.0, ClearQuest 8.0, MYSQL, XML, SQL, TOAD, SQL*Plus, Teradata, Agile, AutoSys, Java, Java Script, Windows, UNIX(Sun Solaris

Confidential, Delray Beach, FL

QA Engineer

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Developed automation test scripts to test the database by retrieving the data from the tables using HP QTP and VB Scripting
• Reviewed and approved database modifications
• Created ETL test data for all ETL mapping rules to test the functionality of the ABInitio graphs.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the reporting objects in the reporter against the design specification document.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Tracked the progress of the defects till end of the defect life cycle, used Mercury Quality Center for defect tracking and maintained the workflows and trail history of bugs using Mercury Quality Center.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Did testing on ETL ABInitio process for various data loading scenarios.
• 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.
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.

Environment: ABInitio,QTP, Business Objects, Quality Center 9.2, Oracle 10g/9i, Flat files, SQL, PL/SQL, TOAD 7.x, java, Windows NT, Agile, Shell Scripting, Sun Solaris

Confidential, Baltimore, MD

QA Engineer

Responsibilities:

• Wrote SQL queries on data staging and data warehouse tables to validate data results
• Wrote SQL queries to validate that actual test results match with expected results
• Checked naming standards, data integrity and referential integrity
• Compared the actual results with expected results. Validated the data by reverse engineering
• Used Clear Quest for defect tracking and reporting, updating bug status and discussed with developers to resolve bugs
• Experience in creating UNIX scripts for file transfer and manipulation
• Prepared Defect Reports and Test Summary Report
• Created Test Case documents in MS Excel template from the Test Plan, and the Business
• Requirements documents.
• Exported Manual Test Cases from MS Excel template directly to Mercury Test Director and
• Executed Test Cases in Test Director with Pass/Fail/Blocked status.
• Checked the status of ETL jobs in UNIX and tailing the log files while the loading is under processing
• Developed Test Plans and Testing Strategies for Data Warehousing projects
• Generated Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing
• Involved in extensive data validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues
• Validated format of the reports and feeds
• Effectively communicated testing activities and findings in both oral and written formats
• Extracted data from various sources like Oracle, flat files and SQL Server
• Optimizing/Tuning several complex SQL queries for better performance
• Worked on issues with migration from development to testing for different data loading jobs
• Validated cube and query data from the reporting system back to the source system
• Used Rational Clear Case for version controlling
• Extensively involved with backend testing by writing complex SQL queries

Environment: Oracle 9i/10g, SQL, PL/SQL, Quick Test Pro 8.0, VSAM, Quality Center 8.0, Business Objects 6.5.1, TOAD, Rational Clear Quest 7.0.1.