PROFESSIONAL SUMMARY:

• Over all 7 years of experience in Quality Assurance, DWH Testing, ETL and Software Testing.
• IT industry experience in Banking, Financial, Health Insurance & Mortgage industries with strong Business and Functional knowledge.
• Excellent knowledge of Agile & Scrum development environment, multiple web browsers.
• Solid knowledge of testing methodologies, software technical documentation analysis, test documentation design & development (test plans, test cases), test execution & results analysis, defects management and reporting.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Validated various Micro Strategy reports such as ad hoc, grids, graphs.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• 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.
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Developed and tested all the informatica mappings, sessions and workflows involving several Tasks.
• Experience in using UNIX scheduling tool Autosys.
• Tested both conditional formatting and threshold level testing for several reports developed in Micro strategy.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• 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
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL)
• Involved in testing data mapping and conversion in a server - based data warehouse.
• Involved in testing the UI applications
• Extensively used Micro Strategy for report generation.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

TECHNICAL SKILLS:

Testing Tools: HP ALM/Quality Center, Rally, Putty, JIRA

GIT, Bit BucketSQL Tools: Toad, Oracle SQL Developer, Oracle 11g/12c, SQL* Loader, Teradata SQL Assistant, HIVE, IMPALA

Operating System: LINUX, UNIX, Windows 10, Mac OS

BI Tools: Cog no s

Data Modeling: Star Schema Modeling, Snow Flake Modeling

Reporting Tool: Tableau Reader, Congo s, BI testing

Databases: Oracle, Teradata, MS SQL Server, DB2, Sybase, MySQL

Job Scheduler: Control M, AutoSys

ETL Tools: Informatica Power Center, Ab Initio

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

ETL Tester

Responsibilities:

• Use of Curam to validate eligibility based on number of Claims
• Understand the gap between the Curam OOTB (Out-of-the-box) functionality and state requirements.
• Constructed an application specifically for Medicaid to assist the NC Fast Health Care, utilizing Curam.
• Involved in all phases of the software testing process, including planning tests, executing tests, and tracking defects.
• Written complex SQL queries to validate the data against the target based on ETL mapping specifications.
• Worked on conversion from Legacy system to CURAM.
• Working in Medicaid Products FNS, CA and MA using Curam Application.
• Verification of intake Application ID and the corresponding numbers are created corresponding to each Global Application ID and validate all the data elements are mapped correctly in the Curam Application
• Experience in using UNIX scheduling tool Autosys.
• Wrote many SQL query and generated reports to verify data in the DB
• Interacting with developers and trying to track/verify bugs in the corporate Bug database and ensure smooth progress and completion of the QA cycle.
• Coordinated and managed testing activities as per the agile methodology followed by project team members.
• Strong in performing backend testing using SQL on Informatics.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Involved in testing universes and reports for correct mapping of the objects and data correctness.
• Experience in documenting Functional, Technical Specifications and Test Cases.
• Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports.
• Inserted Transaction Points to test for performance and Rendezvous Points to emulate heavy load on server
• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.

Environment: Curram application, HP Quality Center12.0, JIRA, UNIX, Agile/Scrum, ETL, Informatica, SQL Developer, Autosys, putty, DVO, Cognos 8.0 Series, Notepad++, MS word, MS Excel, SharePoint.

Confidential, Des Moines, Iowa

ETL Tester

Responsibilities:

• Attended Sprint Grooming, Planning, Stand ups, and Retrospectives and was actively involved with the agile team.
• Tracked features, user stories, tasks, and defects with Rally.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide- ETL Solution using ETL tool and Data Stage.
• Tested several reports detailing price/volume trends and expense variance over previous periods by using Informatica.
• Used JIRA to state requirements, test plan, test cases, and update test run status for each iteration and to report the defect.
• Creating and executing SQL queries to perform Data Integrity testing on Oracle to validate and test data using TOAD.
• Used SQL for Querying the DB2 database in UNIX environment.
• Strong knowledge of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall, Agile.
• Experience in using UNIX scheduling tool Autosys.
• Responsible for the ETL build validation process on an ongoing basis and for the validation of any modifications to the Micro strategy reports before release to production.
• Promoted Unix/Data Stage application releases from development to QA and to UAT environments
• Prepared and executed test cases and defect tracking and reporting processes using JIRA.
• Maintained test scenarios, test cases and test summary documentation using SharePoint.
• Responsible for test coordination and test execution of the various functional areas.
• Attended in Scrum Stand-ups and Code & Design Review meetings for QA updates, defect status, priority and test deliverables, as well, participated in design review meetings to understand technical and functional systems overview.
• Worked on different tools and software such as HP ALM, JIRA, HULA, XML BLOB mapping, UCD, your loan tracker (YTL) for writing script, executed test cases, logged defect and mapping data.

Environment: Windows 07/08, XML BLOB mapping, Autosys, Visio, UCD, Your loan tracker(YTL), Test Director/Quality Center 12.0, HP ALM, JIRA, UNIX, Agile/Scrum, ETL, Informatica

Confidential, Charlotte, NC

ETL Tester

Responsibilities:

• Participated in the management of testing project with the help of HP ALM and Quick Test Pro.
• Developed and executed test cases, test plans, test Scenarios and followed-up defects using QC and JIRA.
• Developed automated test scripts for performing regression testing on the application using HP ALM.
• Performed Functional Testing and Back-end Testing using the database comparable results manually.
• Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Extensively used JIRA for writing test cases, Defect tracking and report generation
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Followed Agile testing methodology, participated in daily SCRUM meetings and testing each SPRINT deliverables.
• Experience in using Unix scheduling tool Autosys.
• JIRA used for project tracking and bug tracking Generated/Tested reports using free-hand SQL which had complex Business Logics for testing environment.
• Updated the status of the testing to the QA team and accomplished tasked for the assigned work to the Project Management team regularly.
• Created the test data for interpreting positive/negative results during functional testing.
• The reports that were created in Business Objects were testing by running the SQL statements against the tables in the Oracle Database.

Environment: Windows 07/08/XP, UNIX, QTP, QC, HP ALM, JIRA, Agile, Scrum, ETL, Autosys

Confidential, Auburn Hills, MI

QA Analyst

Responsibilities:

• Experience testing API's. Maintain defects in JIRA and participate in triage sessions.
• Experience with Cross-Browser and Compatibility Testing to test whether the web applications are working as desired in different browsers and environments.
• Great communication skills, ability to collaborate with developers and Product Management
• Good writing skills, able to document tests, as well as quality standards and best practices
• Assisted in updating Acceptance Criteria based on new discoveries and requirement changes by the client.
• Designed and documented Test Plan, Test Cases, Test Scenarios, and Test Strategies based on business requirements and design documents.
• Worked with Developers, Business Analysts and Test Leads to verify create and execute the Test Cases and fill up the requirement gaps.
• Create test cases, configured and parameterize data, if needed, based on Business requirement, used cases and the document provided by Business Analyst.
• Execute negative and positive test cases and logged the defect in JIRA. Followed up the defect in status meeting and re-test, closed after fixed.
• Conditioned and prepared test data for the Automation testing team and supported them in understanding the functionalities of the application.
• Executed the test in multiple environments (QA01, UAT, DEV and Production) to ensure the requirements were met.
• Involved in Pipeline, Functional, End to End, Regression testing and Smoke Testing for the past three releases.
• Executed the automated regression test cases during every release and also executed the daily regression test suites
• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Involved in extensive DATA validation using SQL queries and back-end testing

Environment: Windows 07, Oracle UNIX, ETL, Quality Center, SQL Developer, JIRA

Confidential, Atlanta, GA

QA Tester

Responsibilities:

• Involved in the Review of Requirements Specification with functional manager and technical specialists of the application
• Design and execute Test Plans and Test Cases, generate Test Scripts and Test scenarios.
• Prepared Test Plan based on the business requirement.
• Prepared proper documentation with to company policy
• Implemented the whole life cycle of QA methodology starting from planning, capturing, creating, executing reporting and tracking the defects using QC and JIRA.
• Performed Negative and Positive testing manually.
• Recorded scripts in QTP to perform Functionality testing.
• Created text area checkpoints to test the properties of the text in the application using QTP.
• Creating scripts to generate new keywords for input, output and validation using QTP.
• Performed Back End Testing using HP ALM.
• Analyzed the results using Load Runner Analysis Graphs.
• Performed Usability Testing Manually.
• Tested online payments, pricing etc.
• Created test cases and test procedures based on functional requirement.
• Involved in creation and maintenance of Test Matrix and Traceability Matrix.
• Conducted Security Test on the application manually.
• Conducted Positive and Negative testing.
• Analyzed test results using reports and graphs generated in QC.
• Worked on QC in setting up and Customizing Project entities for Defect Module Screens.
• Walkthrough on all of test cases.
• Wrote modification request for the bugs in the UAT and helped developers to track the problem.
• Maintained strong relationships with developers which helped in better execution of test plan.
• Conducted User Acceptance Testing (UAT) at each sprint review sessions.
• Participated in regular meetings with developers for reviews and walkthroughs.

Environment: Windows 07/08, UNIX, Java, Oracle, QC, HP ALM, JIRA