SUMMARY

• Around 8 years of experience in Software Quality Assurance and Testing of Stand Alone, Client Server, Web Based applications, Data Warehousing, BI and ETL Testing.
• Having good experience in ETL and BI Testing, Developing and supporting applications.
• Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification, identifying data mismatch.
• Experience on SQL Server Monitoring Agent tool and Azure SQL Server Installation and maintaining the administration tools.
• Expertise in automation testing using Selenium Web Driver.
• Experience in Manual and Automated testing using Java Programming language and open - source tools like Selenium IDE, RC, Web Driver, Junit, TestNG and SOAPUI.
• Experience in performance tuning of SQL Server Development queries for scalability and faster execution.
• Experience in Data Warehouse applications testing using SQL Server Integration Services (SSIS), Confidential DataStage and Informatica Power Center on multiple platforms.
• Expert in analyzing, designing, developing and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
• Extensively used SQL and PL/SQL for development of Procedures, Functions and Packages.
• Well versed in Hadoop ecosystem - Map Reduce, Pig, Hive, HBase, Oozie and Sqoop.
• Experience writing Hive Queries for analyzing data in Hive warehouse using Hive Query Language (HQL).
• Experience in Map Reduce programming model for analyzing the data stored in HDFS.
• Testing Optimization of procedures including Execution Plans, Statistics, and SQL Server Profiler. Performance tuning that includes Indexes, applying the tuning techniques to increase the performance.
• Involved in Developing UNIX shell Scripts to generate parameter files and executed Confidential procedures as batch jobs.
• Proficient in designing and developing Test scripts using SQL for Automation regression testing.
• Hands on experience Testing using Apache Hadoop ecosystems including Hadoop, HIVE, PIG, SQOOP and Spark.
• Analyzed the Data warehouse Hadoop Bigdata ETL design documents to understand the logic.
• Created test cases and test procedures for various stages of the Bigdata ETL process including source to extract, source to staging and staging to target using Hadoop.
• Well versed with various types Software Development methodologies- Waterfall, Agile, RUP, and Iterative.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Extensive experience in Test Data Management, creating test data suite, tracking the results and using for regression testing.
• Experience with Data-driven Testing, Keyword-Driven Testing and Behavior Driven Development (BDD).
• Experience in using Integration tools like Cucumber, Ant and Maven with Selenium IDE.
• Effective collaboration with Developers, AGILE Team, Project Management to achieve Selenium automation, high quality, release deadlines and QA processes improvements.
• Performed functional testing to identify several critical points in the application and automated it by using Selenium WebDriver.
• Verified soap call response in xml formatted data, worked with added test cases and Assertion Using SOAPUI NG PRO, also used Data Source loop and data Source for Data Driven Testing from Excel or from Grid itself, used Data Sink for Automated Report generations.
• Experience in RESTFULL web service Testing using Rest Assured framework java. Validated JSON formatted data, different http status code like 200, 201, 400, 415, 500etc.
• Proficient understanding of working with ETL Automation Tools like DVO.
• Extensive experience of manual and automated testing of application and use of Confidential Quality Center, Confidential Quick Test Pro, Test Director.QTP.
• Good Knowledge on Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process.
• Experience working with different automation tools like QTP, Selenium, Java and Load Runner.
• Involved in fine tuning SQL overrides for performance Enhancements.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Participated in all aspects of SDLC; build and execute test suite using Microsoft Test Manager (MTM)
• Hands on experience in Performance Tuning of mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Having excellent knowledge in Unit Testing, System testing, Integration, Regression, End to End Testing.
• Having knowledge in Doing Estimation and Preparing Schedule for Different phases of Test cycle.
• Excellent knowledge in preparing Test case plans and RTM.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs.
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Excellent team player and excellent communication skills.

TECHNICAL SKILLS

Data Warehousing: Informatica 9.5.1/9.1/8.6.1/8.1/7.1/6/5.1.1/1.75 , Data Stage 8.x, Ab initio, SSIS

Reporting Tools: OBIEE, Cognos 8.0 Suite, Business Object XI 3.1, Crystal Reports, SSAS, SSRS, MicroStrategy 8.x, Tableau, Alteryx.

Data Modeling: TOAD, Star-Schema Modeling, Snowflake-Schema Modeling, Fact and dimension tables, Pivot Tables, Erwin

Testing Tools: Confidential ALM, Win Runner, Load Runner, Test Director, Confidential Quality Center, Rational Tools

Defect Tracking Tools: TFS, JIRA, Confluence

RDBMS: Confidential 11g/10g/9i/8i/7.x, MS SQL Server 2005/2008, DB2, Sybase, Confidential, MS, Access 2008

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++, Java, SQL

Automation Testing Tools: Selenium WebDriver/RC/Grid, Cucumber

Web services: SOA, REST, SOAP UI

Environment: UNIX, MVS, Confidential AIX 4.2/4.3, Hyperion, Win 3.x/95/98, NT 4.0

Databases: Netezza NPS 8050, Confidential, Confidential, Hive, HBase, Impala, Hadoop

PROFESSIONAL EXPERIENCE

Confidential, Lake Oswego, OR

Big data/ ETL test Lead

Responsibilities:

• Tracking the defects which are encountered during testing of various modules of the application.
• Perform Backend Testing like Functional Testing, Regression Testing.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 and SQL Server database systems.
• Worked extensively with sources and target like Flat files, SQL Server tables
• Wrote complex MS SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Experience in ETL Data Warehousing, database testing using Informatica for job process.
• Performed regression testing against the various builds of the application and executed manually in RQM to perform through testing.
• Performed extensive data validations against Data Warehouse.
• Deployed SSRS reports to Report Manager and created linked reports, snapshots, and subscriptions for the reports and worked on scheduling of the reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Used automated scripts and performed functionality testing during the various phases of the application development using Selenium.
• Created Test Scripts Using Selenium web driver tool.
• Performed functional testing to identify various critical points in the application and automated it by using Selenium Web-Driver with Test-NG.
• Used Selenium IDE for Open-source web testing.
• Implemented Page Objects, Data Driven, Keyword Driven, Hybrid automation frameworks using Selenium WebDriver, JAVA, Junit.
• Tested several ETL jobs and ran on UNIX for loading purpose and checking the log files.
• Actively involved in interacting with developers for the Bug Fixes and Problem resolution.
• Created test plan, test cases, test scripts and test steps for every release and stored in Microsoft- TFS.
• Hands on experience developing complex Pig, Hive, HBase, and shell scripts required for automation of scripts on HDFS.
• Validated data between the Hive tables across different databases with HQL, PIG, SQL scripts.
• Wrote scripts in Java for Extracting Data from XML files.
• Testing and bug fixing of an embedded logging application written in Java.
• Validated the Map reduce, Pig, Hive Scripts by pulling the data from the Hadoop and validating it with the data in the files and reports.
• Validated the data load process for Hadoop using the HiveQL queries.
• Continuous monitoring and managing the Hadoop cluster through Ambari.
• Worked with Confidential SQL Assistant for data retrieval and data validation
• Created test plan, test cases, test scripts and test steps for every release and stored in Microsoft- TFS
• Testing and bug fixing of an embedded logging application written in Java.
• Use SQL, PL/SQL to validate the Data going into the Data Warehouse.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Analyzed and created the bug tracking reporting and summary report in the ALM/Quality Center
• Extracted data from various sources like Confidential, flat files and SQL Server.
• Promoted Unix/ETL application releases from development to QA and to UAT environments.
• Implemented Data Validation Option (DVO) for understanding on how to run tests and evaluated the test results.
• Co-ordinate with off-shore and on-shore team for sprint deliverables.
• Attended project meetings, release meetings, and QA status meetings.
• Attended daily status calls with on-shore and off-shore QA team to keep a track on testing activities and to discuss about the new defects raised.
• Gave demo to the project team on Test summary report to show the test cases covered as part of project and also discussed about the known open defects.
• Attended Go/NO go meeting as a Test Lead to give a QA sign off on the project.
• Maintain Project dashboards and user dashboards to reflect current sprint data.

Environment: ETL Tools, SQL, Confidential , MicroStrategy, Agile, Control-M, Confidential, Microsoft Visual Studio, Java, UAT, XML, Confidential, XSLT, MS SQL, Rational DB2, Quality Manager (RQM), Hadoop, PL/SQL, Cloudera Apache Hadoop Ecosystem, UNIX, TFS, Quick Test Pro/UFT, Autosys, Web Services, Selenium web driver, Confidential ALM Quality Center.

Confidential, Charlotte, NC

Big Data/ETL Test Lead

Responsibilities:

• Wrote test scenarios and then test cases and created test data for testing the application.
• Actively involved in functional, unit and integration testing in rational methodology.
• Involved in testing all the reports that were generated through Alteryx.
• Created and executed test cases, test scripts based on ETL Mapping document.
• Used Confidential Quality Center to upload all test cases in Test plan and Test lab modules.
• Create mapping using ETL to cleanness data and feed into tables again.
• Raised defects in defect module of QC and retested when in test status.
• Tested ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files to target tables.
• Used Selenium Web Driver with java plug-in to generate automated test scripts for functional testing, GUI testing and enhancing the existing scripts.
• Generated flat files using the Confidential Export for the Segmentation process.
• Designed and documented REST/HTTP, SOAP API’s, including JSON data formats and API versioning strategy.
• Used Postman & SOAPUI for rest service testing.
• Created automated script for REST-API testing using Rest Assured framework.
• Used java and HTTP Client to automate Backend Rest Service layer.
• Used Hive to write HQL queries for validating constraints, indexes.
• Tested/Found the defects in Backend DWH staging tables, Facts and Front-End Cubes and reports.
• Involved in all over the quality controls (Hadoop & Confidential ), data validations, Key business checks, RTAS implementation of Hadoop ETL flow and Confidential landing zone/target tables.
• Experience in UNIX, RDBMS, Hadoop, HIVE (HQL), Confidential (PL/SQL), MS Access.
• Reported bugs and tracked defects using Quality Center 11.
• Validated the Map Reduce programs, Hive UDFs by using HQL queries.
• Validated the Pig, Hive Scripts by pulling the data from the Hadoop and validating it with the data in the files and reports.
• Loading Flat file Data into Confidential tables, Hive, HBase using UNIX Shell scripts.
• Involved in testing of Universes from different data sources like Confidential, Netezza, Confidential .
• Responsible for different Data mapping activities from Source systems to Confidential .
• 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.
• Testing of Business Objects and Reports which Includes, Database Connectivity, tested objects in the Universe to ensure the correct mapping of the objects.
• Performed Regression Testing for every modification made in the application and new builds using Selenium Web Driver.
• Configured Selenium Web Driver, TestNG, Maven tool and created selenium automation scripts in java using TestNG prior to agile release.
• Involved in Functionality, User Interface, and Regression testing during the various phases of development using Selenium/TestNG.
• Attended daily meetings with offshore team and onsite QA team to track the progress on Testing activities.
• Coordinated with offshore team, onshore to assign the work through handoff emails and through daily bridge calls.
• Conducted and attended meetings with project team and QA team to discuss about the open defects on the project.
• Lead 5 members offshore, 2 members onsite and gave inputs on the test cases and open defects during the test execution.
• Gave demos to the project team on Test summary report after the test execution of the sprint.
• Queried Confidential Database and validated the data using SQL Assistant.
• Used SQL for Querying the Confidential database.
• Used HQL for Querying the Hadoop database in UNIX environment.
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Environment: Informatica, Hadoop, Alteryx, Confidential ALM/Quality Center 11.5, 1A automation, SOAP UI, Selenium Web Driver, TestNG, Java, Jenkins, rational, SQL, Restful Web Service, Rest Client - Mozilla Firefox, HQL, Ambari, Confidential SQL Assistant, Confidential 11g, UNIX, Shell Scripting.

Confidential, Woonsocket, RI

Sr. ETL/QA/BI Tester

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems.
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
• Used Selenium WebDriver to run test cases in multiple browsers and cross Platforms.
• Validating maps on Informatica to verify data from Source to Target data base & record test results.
• Managed multiple OLAP and ETL projects for various testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive Data Validation, Data Verification against Data Warehouse.
• Responsible to create, Execute Test Sets in Confidential ALM Test Lab.
• Reported defects using Confidential ALM Verified fixes and closed bugs during regression testing.
• Loading Flat file Data into Confidential tables using Unix Shell scripts.
• Used Confidential SQL to save queries to a file so they can be run automatically from the same file in the future.
• Designed and prepared scripts to monitor uptime/downtime of different system components.
• Written Test Cases for ETL to compare Source and Target database systems.
• Involved in designing of ETL mappings by translating the business requirements.
• Implemented Regression and Smoke test execution as a discrete step of the deployment process by using WebDriver.
• Used Selenium WebDriver with TestNG framework for Automation regression suite.
• 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.
• Extensively written test scripts for back-end validations.

Environment: Informatica, Cognos, Confidential ALM/Quality Center 11.5, Control-M, Agile, SQL, Selenium Web Driver, PL/SQL, TOAD, Confidential SQL Assistant, Confidential 11g, UNIX, Shell Scripting.

Confidential, Charlotte, NC

ETL/DWH QA Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document.
• Performed extensive Database Testing by writing complex SQL Queries in DB2 to test the different scenarios in the application.
• Performed data manipulation using basic functions and Informatica Transformations.
• Performed Functional, Integration, Regression and System (End-End), and Back-End Integration Testing with back end Confidential Database using SQL Queries.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Performed UAT testing.
• Responsible for testing Business Reports developed by Business Objects.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Tested several complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with ETL group for understating mappings for dimensions and facts.
• Informatica designer tasks such as creating mappings, mapplets, transformations, sessions and workflows to extract, transform and load data into data warehouse.
• Extracted data from various sources like Confidential, flat files and SQL Server.
• Worked on issues with migration from development to testing.

Environment : Informatica, Business Objects, Quality Center 10, Control-M, MS SQL Server 2012, Agile, TOAD, Confidential, PL/SQL.

Confidential, Dallas, TX

ETL QA BI Tester

Responsibilities:

• Analyzed the Business Requirements of the system. Worked with the development team to review project plans, requirements specification, design documents, and computer software.
• Created Manual Test Suites for various modules.
• Analyzed the Functional requirements using Scenarios & DDD (Detailed Design Document).
• Worked with business team to test the reports developed in Cognos.
• Utilized TFS for test case management and Defect Tracking.
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Used Informatica as an ETL Tool for Developing the Data Warehouse.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Used UNIX to verify the session log files for error and warning details.
• Responsible for creating Test Plans, Test cases, Test data based on functional and non-functional requirements (i.e. Interfaces) to test the Cognos reports
• Compared query result sets from different database systems using UNIX diff command.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Wrote complex SQL s to validate target data based on the business requirements.
• Used PL/SQL programs for performance testing.
• Implemented data verification procedures for ETL processes in load testing.
• Used SQL and PL/SQL scripts to perform backend database testing.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings, Generated the detailed reports.

Environment: Informatica, Confidential, Cognos, SQL, PL/SQL, DB2, UNIX Shell Scripting, Toad, Confidential, Windows.

Confidential

ETL Tester

Responsibilities:

• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
• Wrote test cases based on ETL mapping document for testing the entire ETL job.
• Tested several Informatica ETL jobs and ran on UNIX for loading purpose and checking the log files.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using ETL Workflow Manager.
• Involved in understanding of business processes to learn business requirements.
• Conducted System testing for each phase of the application.
• Involved in preparing Test Scripts and Test cases based on the functional specifications.
• Executed backend testing of the application by writing SQL queries.
• Used Defect Tracking System Rational Clear Quest to report bugs found in different testing stages.
• Executed Test Procedures and documented Test Results.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Executed jobs through sequencer for better performance and easy maintenance.
• Involved in performance tuning of the jobs.
• Used T-SQL for validating the data generated at OLAP server.

Environment: ETL Tools, Crystal Reports, Quality Center, SQL*Plus, SQL, Rational Clear Quest, Confidential 8.0, Clear Case, SQL Server 2000, PL/SQL, Visual Basic 6.0, Windows 95, Korn Shell scripting.