SUMMARY

• Over 7+ years of IT experience in the Quality Analysis, testing and Implementation of Business Intelligence solutions using Data Warehouse, ETL, Big Data, Client/Server applications
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Experience in all phases of the QA Life Cycle and SDLC, with timely Delivery against aggressive deadlines, with QA methodologies such as Waterfall, Agile, etc.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices
• Experience in ETL Testing like Informatica, DataStage.
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata
• Experience in publishing reports and dashboards to Tableau server.
• Expertise in using Quality Center & HP ALM for designing, writing, implementing and maintaining the Test Plans, Test Cases, Test Execution, Defect management, Bug Reporting and familiarity with other features of Quality Center/HP ALM and Administration.
• Experience in Big Data projects using Hadoop, Spark, Hive and Map Reduce.
• Experience in using automation tools like HP Quality Center/HP ALM
• Experience in testing MDM strategies and solutions utilizing SQL server MDS tools.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports
• Expertise Shell Scripting experience on UNIX, Linux and Windows environment
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using ETL tools like Informatica and Datastage
• Good working experience in Oracle, Unix Shell Scripting

TECHNICAL SKILLS

Languages: SQL, Test Script Language (TSL), Shell Scripting

Databases: Oracle 10g/9i/8i, MS SQL Server 2008, Teradata, MS Access 2008, DB2 UDB 8.2/8.1, Informix

Reporting Tools: Business Objects XIR3/XIR 2/6.5.1/6.0/5.1. x/4.0 (Supervisor, Designer and Reporter), Cognos 8.0 Series

Operating Systems: Windows (95, 98, 2000, NT, XP), UNIX

Tools: MS-Office suite (Word, Excel, Project and Outlook)

Testing Tools: Mercury (HP ALM/Quality Center, Business Availability Center) MS Project, MS Visio & Visual Source Safe

ETL Tools: Informatica 9.6/5/1/8.1/7.1.2/6.1. X (Repository Manager, Designer, Workflow Manager, and Workflow Monitor) Informatica DVO, Web Intelligence, Essbase Excel Add-in, DataStage 8.5/7.1/8.x

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, RI

Sr. ETL Tester/MDM

Responsibilities:

• Working with users & analysts to understand requirements.
• Involved in bug tracing tools like Jira tickets
• Participated in client meetings to review Integrated Data approaches and to interpret results
• Closely involved in gathering requirement, design, development and implementation of the project
• Defined the testing requirement documents
• Worked with Development Team to draft the Development Checklist and Plan for Iteration Releases
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing
• Performed database validation according to the business logic by comparing the source to the target in Spreadsheet
• Work with source system personnel on source data delivery issues Interacted with DBA for setting up test environment
• Created the test environment for Staging area, loading the Staging area with data from multiple sources
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Involved in testing the Cognos reports by writing complex SQL queries.
• Extraction of test data from tables and loading of data into SQL tables
• Involved in performing the source data validations in the HDFS environment by using the different Hadoop commands
• Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master.
• Data Integration testing for products, Reference Data and Customer master data management (MDM)
• Involved in big data tools like Spark, Hadoop and Hive
• Testing the Pentagon jobs and Transformations with Hadoop on UNIX environment.
• Mapped Requirements to test cases (Traceability) for SIT and UAT
• Updated Traceability Matrix for Testing Specs changes, after change requests (CR) executed
• Involved in testing data integration, system integration and business workflow
• Reported defects in timely manner and logged the same into defect tracking tool
• Review test specifications, cases and performed manual testing
• Developed and tested UNIX shell scripts as part of the ETL process
• Automated the process of loading, pulling the data for test data setup
• Involved in Backend Database testing in Oracle using SQL
• Followed State Street defined ETL Standards and Best Practices

Environment: Jira, Oracle, Agile, Hadoop, MDM, Informatica, Cognos, SQL, UNIX, Shell Scripting, Win SQL

Confidential, Atlanta, GA

Sr. ETL Tester/MDM

Responsibilities:

• Implemented SDLC, QA methodologies and concepts in the Project.
• Participated in defining and executing test strategies using agile methodology.
• Managed and executed the test process, using Agile Methodology.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Involved in Unit testing and integration testing of Informatica mappings.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables.
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD.
• Execute SQL queries to perform Backend testing to ensure data validation.
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
• Tested several dashboards and deployed them across the organization to monitor the performance.
• Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Performed data analysis and data profiling using SQL and on various sources systems including Oracle and Teradata.
• Written test cases to test the application manually in HP ALM
• Used HP ALM for execution, tracking and reporting for Internal High-Level access and also to create reports and update bug status.
• Tested application and filed defects using HP ALM.
• Tested several reports developed using Business Objects.
• Responsible for testing Business Reports developed by Business Objects.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Test plan preparation, preparing daily status reports and defect reports.
• Interacted onsite and offshore team.
• Involved in performing the source data validations in the HDFS environment by using the different Hadoop commands
• Integration and testing of MDM system to facilitate better product management.
• Extensively test the reports for data accuracy and universe related errors.
• Preparing manual test cases and test data for Scenarios.
• Extensively used SQL queries/Unix commands for data verification and backend testing.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Created and executed Test scripts for system validation and user acceptance testing (UAT).

Environment: Informatica DVO, UAT, Hadoop, UNIX, HP ALM, Agile, Teradata, Business Objects, Oracle 11g, XML

Confidential, Atlanta, GA

Sr. ETL Tester

Responsibilities:

• Extensively worked Agile Scrum methodologies of the application and involved in System.
• Involved in the error checking and testing of the ETL programs using Informatica DVO session log and workflow logs.
• Created test plans and performed unit testing for the Informatica mappings.
• Extensively used Informatica DVO for extraction, transformation and loading process.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Extraction of test data from tables and loading of data into SQL tables.
• Load new or modified data into backend SQL server database.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Involved in extensive DATA validation using SQL queries and backend testing
• Used SQL Teradata Assistant for data retrieval from Teradata
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD
• Performed Manual Testing of web-based and client-server applications and used HP ALM for test management.
• Used HP ALM for test planning and execution and Rational Clear Quest was used for defect tracking.
• Logged defects using HP ALM, linked defects with requirements and generated defect reports in HP ALM
• Used HP ALM to track and report system defects.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Written several complex SQL queries for validating Cognos Reports.
• Created test data for testing specific Membership functionality.
• Validating the data passed to downstream systems.
• Worked with data validation, constraints, source to target row counts.
• Performed regression testing against the various builds of the application and executed manually in RQM to perform through testing.
• Performed web service testing using SOAP UI and Rest API.
• Automated REST API tests in Gatling and Scala.
• Used data conversion to protect the data and prevent data loss.
• Strong in writing sql queries and makes table queries to profile and analyze the data in MS Access.
• Created macros to automate the process of refreshing the data in MS Access.
• Provided technical support and coaching to team members about functionality of MS Access.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Used Microsoft excel and Word 2003 to document the test status reports and the Test Data.
• Performed Backend Testing/functional testing, regression testing on Application Under Test
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica DVO, HP ALM, Oracle, Agile, Teradata, Cognos, SQL, SQL Server 2008, SQL, UNIX, Shell Scripting.

Confidential

Manual Tester

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs
• Analyzed the use cases given by the business analysts and developed test cases using them
• Responsible for complete manual testing of application under test (UAT)
• Written complex SQL queries for data validation and to verify the extract rules
• Performed black box/functional testing, regression testing on Application Under Test
• Performed manual testing on various modules of the Application
• Generates functional test cases that capture actual code behavior as a deployed application is exercised
• Generated Test analysis reports and graphs using Quality Center
• Written complex SQL queries for data validation and data verification
• Executes the test suite to identify regressions and unexpected side effects
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user- defined, or from data sources)
• Monitors test coverage and achieves high coverage using branch coverage analysis
• Tests individual methods, classes, or large, complex applications
• Tracks how test results and code quality change over time
• Conducted performance and load testing using Load Runner
• Analyzed, reported and kept track of defects using Test Director

Environment: Windows NT, UAT, MS-Office Tools, SQL, XML, XSLT, Web Services, Manual Testing, Test Director.