SUMMARY:

• Sr. Quality Assurance Analyst/Lead SDET with over 12 years of experience on Database/ETL/BI/Data Warehousing, API, Web and Client server applications across Quality assurance, Test Management, Data/Business Analysis
• Configuration and Development. Currently working as Lead SDET as well as a functional analyst with a Leading Telecommunications player, managing onsite and off - shore test delivery model. Passionate, detail oriented and takes ownership of the assigned work and delivers quality work on time. Strong team player managing multiple projects with excellent communication skills, working with development, business, infrastructure, offshore and program managers.
• Data/Business Analysis
• ETL/BI/Data Warehouse/ Database Testing
• Hadoop/ Big Data Testing
• API testing (SOAP/REST)
• Test Automation
• Batch Management
• Web Security/Penetration Testing
• Mobile Testing
• Environment Build & Configuration.
• CICD (Jenkins / Gerrit / GitHub)
• Trizetto/Cognizant Facets - Payer Configuration Product
• QA Test Estimations
• Requirement Analysis/ Test Plan / Test Case / Functional Testing / UI Testing / Regression testing / End to End Testing / Integration Testing
• Defect Management
• Daily Testing Status / QA Dashboard
• Scrum/ Agile Devops / Waterfall Methodologies

TECHNICAL SKILLS:

Business Domain: Healthcare & Insurance, Telecommunications, Banking, Retail E-Commerce

RDBMS/DW Database: SQL, Oracle, Teradata, MS SQL, My SQL

Big Data Technologies: HDFS, Hive, Hbase, Oozie, Hue, Nifi

ETL/BI/Reporting Tools: Informatica, Data Stage, MS SSIS/SSAS/SSRS, SAP BO, Tableau and OBIEE, Tricentis TOSCA BI, Query Surge, Informatica DVO

Batch Administration/CICD: Control M, Cisco Tidal, Auto Sys, Jenkins, GitHub

Automation Tools /Test Management Tools: SOAP UI, POSTMAN, Selenium with TestNG, JIRA, Rally, ALM/Quality Center (HP), Bugzilla and qTest.

Languages: Unix, Python

OS: Windows 2K, Windows XP, Window 7, Windows Vista, Virtual PC, VMware

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Lead SDET - ETL, Business Analyst

Responsibilities:

• Interacting with Dev team, Business Team, Data Analyst, and Data architects for understanding project requirements, Technical design and source to target data mappings.
• Analyzing Source to Target Mapping requirements and creating high level test scenarios.
• Responsible for creating test plan, test cases, test data, test execution and reporting status ensuring accurate coverage of requirements and business processes.
• Performed Smoke, Functional, Integration, Regression and End-to-End testing.
• Involving in writing complex SQL queries based on STTM documents to validate ETL.
• Ability to run/execute and validate the BI Reports generated out of Tableau and SAP Business Objects.
• Used Terada utilities (M-LOAD & F-LOAD) to load the flat files in to temporary tables for testing.
• Developed multiple Automation Utilities which saved effort of about 5000+ hrs. in Regression Testing, QA Environment Sync ups from Prod etc.
• Use of Informatica Workflow manager/Work flow monitor to run and validate the ETL Workflows.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Worked on REST API Testing using Postman API Tool. Comprehensive knowledge in working and validating the SOAP and REST API’s
• Running the hdp jobs and understanding the logs involving HDFS, Hive, Hbase, Oozie and HUE to facilitate the job runs between IDW and Teradata Environments.
• Extensively worked on testing Hadoop ingestion and Dispatch ETL jobs to validate the ETL Requirements involving technologies such as HDFS, Hive, Hbase, Oozie, Zookeeper and HUE
• Expertise in Hadoop job execution using Unix wrapper scripts
• Proficient in trouble shooting Analysis of Hadoop jobs failures
• Performed data quality analysis using advanced SQL skills
• Worked on BI Test configuration management activities such as setting up the QA BI Environments, performing the code drops into QA environments, Running the HDP, Informatica Jobs etc.
• Worked on Golden Gate flat files for CDC from source and direct load into stage tables on Teradata
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Performed complex defect reports in various environments like UAT, SIT, and QA to ensure the proper delivery of the application into the production environment
• Tested the different sources such as Flat files, Legacy Flat Files, SQL server 2008 and Oracle to load into the Teradata data warehouse
• Used ALM and qTest for managing all STLC activities (Managing the requirements and requirement traceability matrix (RTM), test case design, test execution, defect management and reporting)
• Providing the necessary support to business users in UAT phase.
• Participate in daily status meetings to provide accurate QA status with all stakeholders.

Environment: Teradata, TPT API, Teradata SQL Assistant, Informatica, CTRL M, Jenkins, GIT, Gerrit, PL SQL, Putty, HDFS, HIVE, Hbase 0.98, Oozie 4.1

Confidential, San Francisco, CA

ETL Test Lead, Environment Config Lead, Security Tester, Automation Lead

Responsibilities:

• Interacting with Dev team, Business Team, Data Analyst, and Data architects for understanding project requirements, Technical design and source to target data mappings.
• Analyzing Source to Target Mapping requirements and creating high level test scenarios.
• Responsible for creating test plan, test cases, test data, test execution and reporting status ensuring accurate coverage of requirements and business processes.
• Performed Smoke, Functional, Integration, Regression and End-to-End testing.
• Involving in writing complex SQL queries based on STTM documents to validate ETL.
• Performed various data quality and data profiling checks using SQL queries.
• Used Netezza utilities (NZLOAD) to load the flat files in to temporary tables for testing.
• Use of Informatica Workflow manager/Work flow monitor to run and validate the ETL Workflows.
• Use of ETL Automation Tool Query Surge to create query pairs using SQL queries.
• Used ALM for managing all STLC activities (Managing the requirements and requirement traceability matrix (RTM), test case design, test execution, defect management and reporting)
• Providing the necessary support to business users in UAT phase.
• Worked on Informatica Mapping development for creating necessary source to target loads.
• Participate in daily status meetings to provide accurate QA status with all stakeholders.
• Gather, Review and Analyze the functional requirements to formulate the test scenario’s and test scripts
• Handling the offshore team and helping them in understanding the client business requirements and functionality.
• Reviewing the test scenarios and test cases before they converted into automated test scripts.
• Involved in developing and maintenance of automated test scripts and executions on a daily basis.
• Manage and maintain efficiencies in the automated script execution and script development through the implementation of automation best practices.
• Involved in creating the scripts which covers the seamless test execution of Interface functionality that ranges from creating test data, trigger batch and perform validations on outbound extracts.
• Involved in testing various Facets ETL Components such as Interfaces, Batches, and Crystal Reports.
• Conducting the build executions in a seamless manner to validate the interface functionalities in a stipulated time before deploying to QA Environments.
• Also involved in the enhancing of selenium scripts for Web Application testing of various front-end applications.
• Conducting Web application security assessment based on OWASP Standards.
• Performing web vulnerability scans using IBM AppScan and Analysis.
• Identification of misconfigured software
• Assessments of patching program effectiveness
• Analysis of hacking, penetration and defense threats

Environment: ALM, Trizetto Facets, Power center, Query Surge, IBM Netezza, Aginity workbench, UNIX & TIDAL, IBM AppScan, Tidal, Facets, ESB Servers and Web portals

Confidential, Charlotte, NC

ETL Test Lead

Responsibilities:

• Analysis and understanding of Requirements based on the business context from key stakeholders.
• Reviewing the mappings specs and coordinating in onboarding the new sources to the Trads system.
• Interaction with Client and developers on a daily basis for requirements gathering and understanding the data flow.
• Setting up defect review calls with the downstream partners and tracking them to closure.
• Early identification of defects in the dev environment so cut down the cost of defect fixing.
• Identifying Test Scenarios, supporting the test data needs and tracking the status of the development stories on rally
• Involved in effort estimation of the forecasted work based on High level scope
• Involved in ETL Testing between source and target systems based on STTM documents.
• Involved in testing of the BI Reports generated from OBIEE as well as Ad-hoc Reports generated out of Oracle ERP (Oracle E Business Suite).
• Using the Informatica DVO to create the Table pairs to do the data profiling by predefined scenarios.
• Executed test cases manually to perform Integration testing, compared and analyzed actual with expected results and reported all deviations to the appropriate individual(s) for resolution using JIRA, along with logging defects with details and following up.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports using ALM.
• Involved in web application testing for customer ecommerce portals.
• Enhanced the Automated Test Scripts using Selenium Test NG for the Customer Ecommerce web application for Regression Testing.

Environment: Web Portals, Oracle EBS, Informatica Power center, DVO, Netezza and OBIEE.

Confidential, Cincinnati, Ohio

ETL Lead/Facets Lead/ALM Administrator

Responsibilities:

• Preparation of SAD (System Appreciation Document) for the Existing System and Process flow diagrams w.r.to the new migration.
• Involved in all the STLC Related activities ranging from Analysis, Design and Execution to Closure.
• Involved in testing various Custom ETL Components such as Interfaces, Batches and Reports.
• Involved in testing the ETL Comparison of both legacy and facets systems to HPXR.
• Involved in Testing the BI Reports generated out of Business Objects/Universe.
• Test data preparation, Test execution and Presentation of Test Results and findings to the Project and Business Teams.
• Prepare Data Conversion Test Scenarios/Test Scripts to ensure complete coverage by analyzing the mapping documents from Legacy Systems to Facets DB
• Executing data migration test cases on the source and target dbs.
• Managing, improving and driving ALM usage, best practices and enhancements for Information Services across the QA Practice.
• Worked on various Site administration and Project Administration activities

Environment: HP Quality Center 10, Informatica 8.6, MS Excel, Oracle 9i/10g, Teradata 13.0, Teradata SQL Assistant, SQL, PL/SQL, ARC main, MLoad

Confidential, Minneapolis

Automation Lead, Business Analyst

Responsibilities:

• Preparing High Level Test plan (HLTP), Test Scenario Identification.
• Understanding Requirements and pose questions and get the requirements clarified from Onsite counterparts
• Preparing Knowledge Transition Document
• Taking up the KT sessions for the new joiners into team
• Design and review of Test scenarios and Scripts for given functional requirements.
• Perform Functional Testing and System testing on the Application spread across various CRM applications related to Member, Provider, and Commission Entities etc.
• Responsible for Consolidated Reports like Bug Metrics, Testing Coverage, Task Status, and Test Cycle Metrics and documentation

Environment: ISET CRM Portal, ALM, UHG in-house Core Administration System - TOPS, Selenium.

Confidential, California CA

Web Application Tester/Automation Tester

Responsibilities:

• Analyzed system requirements and designed test cases for testing the application
• Analyzed the user requirements by interacting with system architect, developers, and business users.
• Developed test cases, test scenarios, and expected results for the Application under Test.
• Preparing Requirement Traceability Matrix to map the test cases to the Requirement Id’s
• Reported defects using Remedy and re-tested fixes, closed bugs during regression testing.
• Perform Functional/System Testing on Sender Summary, Dash Board & DSS Web Services testing.
• Developed Test cases/scenarios. Log and track the Defects into QC at different phases of testing
• Performed functional and compatibility testing of the Web services (DSS) using SOAP-UI.
• Followed Agile Scrum methodology in project execution.

Environment: Siebel CRM Portal, Clear quest and ALM.