We provide IT Staff Augmentation Services!

Etl/bi Qa - Lead Resume

5.00/5 (Submit Your Rating)

SUMMARY

  • Senior QA Project Lead with 13+ years of IT experience including 10+ year at onsite (USA) in Manual, Penetration n Security, Usability, UAT, Mobile & Cloud, Automation, Performance, POS, Supply Chain, OMS, Manhattan WMS(TLM), ETL, EDI, Database (SQL, TSQL, DB2), Portal, Web Services (HTTP and Rest), SOA, Resiliency, Verification n Validation, Share Point, ServiceNow, MDM, Data Migration, BI Reports, Integration, Web UI,TDM, API (IBM), BPM (PEGA), Client/Server, Infrastructure, H/W, Network testing in the Agile - Scrum, Waterfall & Iterative Model.
  • ETL/DB/BI QA Lead with 8 + Year experience on developing ETL & Data base test plans including test scripts, test scenarios, RTM, test schedules, defect tracking and reporting. Perform source data extraction, Business Transformation logic, target table loading with writing SQL queries for all the various ETL Operations.
  • Scheduling and leading business/BI team meetings such as status, project kick-off, stand-ups, defect tracking, etc., and meeting with the business stakeholders to prioritize work and projects.
  • UAT Lead with 8 + Year experience on developing UAT test plans including test scripts, test scenarios, RTM, test schedules, defect tracking and reporting. Scheduling and leading UAT team meetings such as status, project kick-off, stand-ups, defect tracking, etc., and meeting with the business stakeholders to prioritize work and projects.
  • Mobile Application testing with 5+ Year experience on different Mobile Platforms, such as iOS and Android.
  • Automation Tester with 3+ Year experience in Web Application Testing using Selenium WebDriver, IDE (Java) with TestNG framework. Writing Test cases using Element locators, WebDriver methods, Java programming features and TestNG Annotations. Experience in Data driven Testing, Cross browser testing and Parallel Test execution using Selenium WebDriver, Jenkin, Cucumber (Gherkin), TestNG and selenium Grid.
  • SOA Tester with 3+ Year Experience in API testing with SOAP-UI HTTP and REST.
  • Usability Tester with 3+ Year Experience with systems, user controls, error prevention, consistency & std.
  • Security Tester with 3+ Year experience with Implementing, testing and operating advanced software security techniques in compliance with technical reference architecture. Performing on-going security testing and code review manually and with Nmap, Burp-Suite, IBM app scan few other tools to improve software security.
  • BSA with 3+ Year experience on functional, technical and security testing requirements an act as a strategic partner between the business community and IT development teams to resolve functional, security and technical issues related to business applications, to troubleshoot data or transaction issues.
  • Scrum Master cum QA Project Manager with 3 + Year experience to facilitate the daily stand-up, maintain their burn-down chart, setting up retrospectives, sprint reviews or sprint planning sessions, Shielding the team from interruptions during the sprint, removing obstacles that affect the team, Walking the product owner through more technical user stories, Encouraging collaboration between the Scrum team and product owner.
  • BPM (PEGA) with 2+ Year experience to perform BPM (PEGA PRPC) Architecting, PEGA Branding, Thought Leadership, solution Architecture, capturing and documenting non-functional (architectural) requirements, preparing estimates and defining technical solutions to proposals (RFPs) along with design to deployment related activities, provide guidance, perform reviews, prevent and resolve technical issues.
  • 8+ year experience in Agile/Scrum, 13+ Year experience in Water Fall and Iterative Model.
  • Subject Matter Expert in banking & financial, CCAR, Compliance Rules, WCAG2.0 section 508, WAI-ARIA Regulatory Compliance, Life Insurance, Annuity n Commercial line, Property and Causality(PnC), Medicare, Medicaid, Long Term Care, Pharmacy Benefit Management (PBM) Domain, Credit Ratings and Retail.
  • 13+ Year experience on documenting business requirements, burn charts, Gap Analysis, Estimation sheets, test strategy, test plan, matrix, QA project estimates, analyzing business specification documents, developing test plans, Requirement Trace Ability Matrix, defining test cases, status reports, BI Reports, analyzing test results, Defect Tracking, Bug Reporting (HP Quality Center, ALM/Jira and APPM) and dashboards.
  • Quality Management, change control, Document Management, Training Management, Release Process through QC/ALM, Jira, Rally, Confluence, share Point tools and Microsoft Team Foundation Server 2013/Microsoft visual studio 2013/Microsoft test manager.
  • Experience in test automation, script preparation and execution within framework and in Selenium/Cucumber/QTP11.5/UFT12.5 integrated environment (step generator, synchronization, data tables, actions, recovery scenarios).

TECHNICAL SKILLS

  • Medicaid, Retail Domain, Banking & Finance, Medicare, Lending (asset & wealth), Life & Insurance/Commercial Lines, PBM (Pharma n Medicare), Portfolio Management and Regulatory Compliance
  • Retail Domain (PIM, DW, OMS, ETL, ESB, WCS, RMS, Supply Chain, WMS)
  • Structure Finance Group (ABCP, ABS, CEF, Fixed Income, Derivative, RMBS, Covered Bond, MSPG). Corporate Finance Group (Debt, Instrument, Program and Equity).Public Finance Group (Sell, Maturity...), Oracle finance accounting.
  • Lending (Asset and Wealth management)
  • Life, Annuity, Commercial Lines & Insurance, Property and Causality (PnC), Medicare, Medicaid, Long Term Care, PBM
  • Windows 95/97/2000/NT/Vista/Citrix, windows 7, window 10, UNIX, Shell and Linux
  • Functional, POS, usability, Mobile, Risk Based, ETL/Big Data, Black Box, Smoke, Database, Integration, End to End, Verification, Validation, Regression, Stress, UAT/ATDD, Compatibility, data migration, .Net Migration, GUI, SOAP UI, Penetration, BPM, Share Point, Main Frame and web services testing (HTTP and REST).
  • Defect Tracking, Test Data Management, Reports and Matrices
  • Expertise in Water Fall, Iterative, Scrum and Agile
  • Expertise in Offshore & Onsite Model
  • Sybase, RDBMS, SQL, DB2, AQT, Oracle
  • HP Quality Center/ALM, Jira/QC, RQM, MKS (version control), APPM, Rally, Confluence and Clear Quest.
  • QTP 11.5 /UFT12.0, Soap UI, Cucumber, Selenium (Rubi), Selenium (java), Appium (Mobile automation)
  • Version control: VSS, CMMI, MKS Integrity Client, Git
  • RQM, Jira, QC/ALM, ARD.
  • Security: Nmap, Burp and Metasploit
  • Transportation and Logistics Mgmt. (TLM),
  • AS/400 (IBM iSeries)
  • Other tools: Informatica, APPM, Service Now ticket management, Rapid SQL 7.6.1, Putty, Guidewire, beyond compare, Scenario Analyzer Moody's tool
  • Microsoft Team Foundation Server 2013 (TFS/MS) Microsoft visual studio 2013/Microsoft test manager (MTM), Oracle EBS and SCM
  • Soap UI, Lisa, API (IBM), BPM (PEGA PRPC), EDI, IBM - Business Monitoring Tracks, WMS, OMS, WAVE and JUICY Studio
  • Share Point, MPP, Visual Visio, Grid and RXClaim
  • Cucumber (Rubi), Rally, Confluence
  • Microsoft excel (macros and pivots)

PROFESSIONAL EXPERIENCE

Confidential

ETL/BI QA - Lead

Responsibilities:

  • Lead and Coordinate the day to day activities with all business stake holders to perform ETL and BI Testing with certifying, managing, supporting, improving process, standard, strategy, business system analyst, capacity management and delivering secure and innovative applications, software's and solutions in the Agile n Scrum Model that have driven revenue and profitability to deliver project on time.
  • Create a cross team testing calendar (by business day) to expose the required test activities on a daily/weekly projection. This will serve as a road map in test planning to ensure data, system test environments, software & hardware’s, resources, capacity management and tools are available proactively.
  • Worked as a liaison among stakeholders in order to elicit, analyze, communicate and validate requirements for changes to business processes, policies and information systems.
  • Actively involved in Business Process Engineering, Business Process Re-Engineering, Gap Analysis and Business Refinement Process.
  • Collects and defines requirements, translates into functional design documents and participates in the technical design, test planning and user documentation processes in the Agile Scrum as ARD.
  • Participates in software design, prototyping, construction, and testing of new or enhanced applications.
  • Use Unified Modeling Language (UML) diagrams (Use Case diagrams, Sequence diagrams and Activity diagrams) for specifying, visualizing, constructing, and documenting the artifacts of software system.
  • Developed Project Plan & Test Strategy, update and maintain testing standards and procedures, Risk Based Test strategy, QA Process and Procedure, QA Templates, QA Metrics (using excel macros and pivot), Reports, Test Plan, Test Cases, Test Scripts and Testing Estimation in each sprint and releases.
  • Established and control of the test environments and Test Data set up for Product Testing with manual, database, API (IBM), and Automation Testing.
  • Gathered and analyzed requirements for the ETL/BI/Analytical and create Dashboards, traceability metrics. Assistance in the development of user stories, acceptance criteria and product backlog grooming and especially related to coaching and or teaching teams.
  • Create ETL Methodology for Supporting data extraction and testing in BI applications.
  • E2E/Integration/Regression Testing of MapR/Hive/Micro Services for Medicaid DW.
  • Create Test Plan to presents the test objectives, scope, approach, assumptions, dependencies, risks and schedule for a release for Data Integration Testing.
  • Conduct structured walk-through a well as performed demo’s and participate in the retrospective meetings in each sprint for Medicaid Data and Reports.
  • Work with Test Team members to enhance their testing skills, build technical and business knowledge as well as define test team member roles, responsibilities and deliverables.
  • Determine time estimates and schedule for work efforts as well as coordinate the efforts of other testers.
  • Perform Master Data Management (TDM) with Microsoft SQL Server data services with complex queries using multiple data repositories and tables in the share point.
  • Create Test Cases for specific tests defined to ensure business requirements are met and capture defects for Claim Accept, Claim Reject and Formulary Subject Area.
  • Execute Data Integration and BI test cases based for all the Medicaid Products.
  • Conduct usability testing with systems, user controls, error prevention, consistency & std.
  • Perform manual security testing of Medicaid Products.
  • Perform DB/ETL testing executing SQL statements with complex queries using multiple data repositories & tables.
  • Analyze large amount of data provided in spreadsheets using Excel features with macros.
  • Ensure adherence to testing best practices and database testing (Store procedure testing, performance and data validation testing).
  • Performed E2E Data Integration testing with collaboration of other test teams to ensure test coverage between organizations meets expectations and exposes gaps expeditiously.
  • Debug investigate ad perform inspections to resolve issues/defects and determine root cause as well as manage expectations for daily metrics of test execution and defects in the QC/ALM, Jira.
  • Create Defect Documentation during all the test phase, defect tracking, management and reporting of found defects via Jira/ALM/QC.
  • Create and maintain high-quality Dashboards, documentation of all relevant specifications, systems, procedures, measurements and metrics to make effective and useful measures of the testing process status reports, BI Reports which provides progress toward testing objectives in MTM n TFS.
  • Signed of the projects and Involved in the software deployment in QA and production release process with DevOps tool then support to production support teams.

Confidential

QA - Lead- Manual

Responsibilities:

  • Lead and Coordinate the day to day activities with all business stake holders to perform cross Functional (Online Tests), BI (Micro Services, Ingestion and integration of New from ) Validation, POS (In Store Tests), RMS Tests (Allocations), Mobile, Manhattan WMS, Supply chain (3PL), Package, High Jump WMS, Logistic, Automation, ETL, Database, Web Services (HTTP and REST), AWS Services, Performance, Share Point, MDM, UAT/ATDD, API, Data Migration, Integration, Web UI, certifying, managing, supporting, improving process, standard, strategy, business system analyst, capacity management and delivering secure and innovative applications, software's and solutions in the Agile n Scrum, Water fall and Iterative Model that have driven revenue and profitability to deliver project on time.
  • Create a cross team testing calendar (by business day) to expose the required test activities on a daily/weekly projection. This will serve as a road map in test planning to ensure data, system test environments, software & hardware’s, resources, capacity management and tools are available proactively.
  • Worked as a liaison among stakeholders in order to elicit, analyze, communicate and validate requirements for changes to business processes, policies and information systems.
  • Actively involved in Business Process Engineering, Business Process Re-Engineering, Gap Analysis and Business Refinement Process.
  • Collects and defines requirements, translates into functional design documents and participates in the technical design, test planning and user documentation processes in the Agile Scrum as ARD.
  • Participates in software design, prototyping, construction, and testing of new or enhanced applications.
  • Use Unified Modeling Language (UML) diagrams (Use Case diagrams, Sequence diagrams and Activity diagrams) for specifying, visualizing, constructing, and documenting the artifacts of software system.
  • Developed Project Plan & Test Strategy, update and maintain testing standards and procedures, Risk Based Test strategy, QA Process and Procedure, QA Templates, QA Metrics (using excel macros and pivot), Reports, Test Plan, Test Cases, Test Scripts and Testing Estimation in each sprint and releases.
  • Established and control of the test environments and Test Data set up for Product Testing with manual, database, API (IBM), and Automation Testing.
  • Gathered and analyzed requirements for the ETL/BI/Analytical, retail, supply chain, WMS, OMS, RMS Products with business users and product specialists and create traceability metrics. Assistance in the development of user stories, acceptance criteria and product backlog grooming and especially related to coaching and or teaching teams. reate Test Plan to presents the test objectives, scope, approach, assumptions, dependencies, risks and schedule for a release for Demandware & WCS web based and mobile (as iOS and Android) applications.
  • Conduct structured walk-through a well as performed demo’s and participate in the retrospective meetings in each sprint for retail, supply chain, WMS, OMS, RMS, POS Products.
  • Work with Test Team members to enhance their testing skills, build technical and business knowledge as well as define test team member roles, responsibilities and deliverables.
  • Determine time estimates and schedule for work efforts as well as coordinate the efforts of other testers.
  • Perform Master Data Management (TDM) with Microsoft SQL Server data services with complex queries using multiple data repositories and tables in the share point.
  • Create Test Cases for specific tests defined to ensure business requirements are met and capture defects for Demandware & WCS, supply chain web based and mobile (as iOS and Android ) applications.
  • Execute functional test cases based for On-Line and In Store tests on windows, C#.Net and J2EE/Java web based and mobile applications.
  • Conduct usability testing with systems, user controls, error prevention, consistency & std.
  • Perform source code analysis and programming on Java and manual validation on Git.
  • Perform functional, EDI & E2E testing on OMS (IBM Sterling), WMS-Manhattan (Transportation and Logistics Mgmt. (TLM), WMS-Blackman, High Jump WMS, OMS-Omni Channel, OMS-Sterling on AS400 Series.
  • Perform manual, penetration testing of client systems, web sites and networks to discover vulnerabilities along with configure, run and monitor automated security testing tools with Nmap, Burp and Metasploit.
  • Perform application security testing with Authentications, Authorizations, Data protections, XSS, Inter & Intra N/W, Session Management etc.
  • Perform the Inbound, Outbound flows, by online and Pick up in store, testing Labels, Pack-slips, package and integration testing with supply chain, WMS, Order Management and RMS.
  • Perform Sales and Return testing in the POS for Local and international stores for all the brands.
  • Perform Web Services testing with soap UI and Rest.
  • Perform API (with IBM tool), Testing with page filler tool for web-based applications on IBM AS 400.
  • Supporting Enterprise Service Bus (ESB) and Service Oriented Architecture (SOA) tier.
  • Perform DB/ETL testing executing SQL statements with complex queries using multiple data repositories & tables.
  • E2E/Integration/Regression Testing of MapR/Hive/Micro Services for WCS applications.
  • Create and run tests for various purposes by using a broad range of tools for tasks such as synchronizing with WSDLs and validating messages and data with IBM RIT.
  • Analyze large amount of data provided in spreadsheets using Excel features with macros.
  • Ensure adherence to testing best practices and database testing (Store procedure testing, performance and data validation testing).
  • Performed E2E & Integration testing with collaboration of other test teams to ensure test coverage between organizations meets expectations and exposes gaps expeditiously.
  • Debug, investigate ad perform inspections to resolve issues/defects and determine root cause as well as manage expectations for daily metrics of test execution and defects in the QC/ALM, Jira.
  • Involved in Development of Test automation framework and Developed automation suite (Cucumber-Selenium-Java) for regression testing.
  • Experienced in developing and implementing Data Driven Framework, generic and application-based Data, Keyword Driven Framework and Hybrid Framework in Selenium-Java.
  • Writing Test cases using Element locators, WebDriver methods, Java programming features and TestNG Annotations.
  • Experience in Data driven Testing, Cross browser testing and Parallel Test execution using Selenium WebDriver, Jenkin, Cucumber (Gherkin), TestNG and selenium Grid.
  • Executing Selenium, Jenkin and Cucumber (Gherkin) Test Cases and Reporting defects in ALM/QC.
  • Provide recommendations for execution of performance, automated tests and troubleshoot complex failures including failures of the system under test.
  • Create Defect Documentation during all the test phase, defect tracking, management and reporting of found defects via Jira/ALM/QC.
  • Create and maintain high-quality documentation of all relevant specifications, systems, procedures, measurements and metrics to make effective and useful measures of the testing process status reports, BI Reports which provides progress toward testing objectives in MTM n TFS.
  • Signed of the projects and Involved in the software deployment in QA and production release process with DevOps tool then support to production support teams.

Confidential

Senior QA Test Lead/SOA

Responsibilities:

  • Create a cross team testing calendar (by business day) to expose the required test activities on a daily/weekly projection. This will serve as a road map in test planning to ensure data, system test environments, software & hardware’s, resources and tools are available proactively.
  • Developed Project Plan & Strategy, update and maintain testing standards and procedures, Risk Based Test strategy, QA Process and Procedure, QA Templates, QA Metrics, Reports, Test Plan, Test Cases, Test Scripts and Testing Estimation in each sprint and releases within PPQA/CMMI.
  • Established and control of the test environments and Test Data set up (TDM) for manual, database, API Penetration, Performance and Automation Testing.
  • Perform as business system analyst on functional, Resiliency and security testing requirements for Life Insurance, Property and Causality (PnC) (WINNS Applications) and Medicaid to create user stories in JIRA as well as especially related to coaching and or teaching agile teams.
  • Gathered and analyzed requirements with end-users and product specialists and create traceability metrics.
  • Assistance in the development of user stories, acceptance criteria and product backlog grooming and especially related to coaching and or teaching teams.
  • Create Test Strategy to provide the overall testing approach including team members, tools, guidelines, policies & processes.
  • Create Test Plan to presents the test objectives, scope, approach, assumptions, dependencies, risks and schedule for a release for web based and mobile (as iOS and Android) applications.
  • Conduct structured walk-through a well as performed demo’s and participate in the retrospective meetings.
  • Work with Test Team members to enhance their testing skills, build technical and business knowledge as well as define test team member roles, responsibilities and deliverables.
  • Create knowledge transition plan for offshore team, implement and measure effectiveness on regular intervals.
  • Review of Manual Test scenarios (Risk Based) and Test cases prepared by Offshore and Onshore teams and get approvals from the Business Teams Prepared Requirement Traceability Matrix.
  • Allocated and supervised tasks to other team members.
  • Determine time estimates and schedule for work efforts as well as coordinate the efforts of other testers.
  • Define and utilize entry and exit criteria for testing.
  • Perform Master Data Management (TDM) with Microsoft SQL Server data services in the share point.
  • Create Test Cases for specific tests defined to ensure business requirements are met and capture defects when not met for web based and mobile (as iOS and Android) applications.
  • Execute functional test cases based on windows and mainframe, C#.Net and J2EE/Java web based and mobile (as iOS and Android) applications.
  • Perform manual, penetration testing of client systems, web sites and networks to discover vulnerabilities along with configure, run and monitor automated security testing tools with Nmap, Burp and Metasploit.
  • Perform application security testing with Authentications, Authorizations, Data protections, XSS, Inter & Intra N/W, Session Management etc.
  • Collaborate with software development, system engineering and architect peers to continually improve system design, implementation and operations.
  • Perform source code analysis and programming on Java & .Net and manual validation on Git.
  • Perform Web Services testing with soap UI and Rest.
  • Perform API testing with page filler tool for web-based applications.
  • Perform white box testing for Java and .Net Based applications.
  • Perform verification and validation on Oracle EBS and SCM apps.
  • Perform database/ETL testing executing SQL and TSQL statements to test outcomes.
  • Create and run tests for various purposes by using a broad range of tools for tasks such as synchronizing with WSDLs and validating messages and data with IBM RIT.
  • Analyze large amount of data provided in spreadsheets using Excel features with macros.
  • Ensure adherence to testing best practices and database testing (Store procedure testing, performance and data validation testing).
  • Performed E2E & Integration testing with collaboration of other test teams to ensure test coverage between organizations meets expectations and exposes gaps expeditiously.
  • Performed Manual Functional, ETL and Mobile testing in each sprint of the product using black box testing and track in the Rally/Jira/ALM/QC.
  • Performed Functional and Penetration testing of the product using black box testing.
  • Ensure adherence to testing best practices and database testing (Store procedure testing, performance and data validation testing).
  • Perform BPM (PEGA PRPC) Architecting, PEGA Branding, and Thought Leadership, solution Architecture, capturing and documenting non-functional (architectural) requirements, preparing estimates and defining technical solutions to proposals (RFPs) along with design to deployment related activities, provide guidance, perform reviews, prevent and resolve technical issues.
  • Debug, investigate ad perform inspections to resolve issues/defects and determine root cause as well as manage expectations for daily metrics of test execution and defects in the QC/ALM, Jira.
  • Perform automated regression test strategies/tools for batch, flat file and web service-based interfaces.
  • Involved in Development of Test automation framework and Developed automation suite (Cucumber-Selenium-Java) for regression testing.
  • Experienced in developing and implementing Data Driven Framework, generic and application-based Keyword Driven Framework and Hybrid Framework in Selenium-Java.
  • Writing Test cases using Element locators, WebDriver methods, Java programming features and TestNG Annotations.
  • Experience in Data driven Testing, Cross browser testing and Parallel Test execution using Selenium WebDriver, Jenkin, Cucumber (Gherkin), TestNG and selenium Grid.
  • Executing Selenium, Jenkin and Cucumber (Gherkin) Test Cases and Reporting defects in ALM/QC.
  • Analyze and interact with complex sets of automated test assets and an ability to provide insights into alternatives or improvements to test systems, test framework components, test databases and test servers.
  • Provide recommendations for execution of performance, automated tests and troubleshoot complex failures including failures of the system under test.
  • Create Defect Documentation during all the test phase, defect tracking, management and reporting of found defects via Jira/ALM/QC.

We'd love your feedback!