We provide IT Staff Augmentation Services!

Test Lead (etl) Resume

4.00/5 (Submit Your Rating)

TX

SUMMARY:

  • Over 12+ years IT experience of Analysis, Design, Development and Quality Assurance in various Client/Server, Mainframe, and Web Applications (.NET/J2EE) developed for various industries engaged in Finance, Leasing, Insurance, Healthcare, Manufacturing, Logistics, Life science, ERP & Utility, Telecom.
  • Excellent work experience in projects executed under standard Software Development Life Cycle (SDLC) in Waterfall, Agile methodologies
  • Participation in JAD / Requirement collection sessions to estimate testing needs
  • Interacted with key stake holders/project team in the capacity of Test Lead/QA Lead/Test Coordinator
  • Experience in conventional and ERP applications (SAP FI/SCM/SD/PM, Scala) and experience in Production Planning and good knowledge on WMS, e - Commerce
  • Experienced in SAP End to End testing, Security testing, ETL and Data Warehouse
  • Experience in QA Effort estimation, Resource selection, Mentoring, conduct Walkthroughs
  • Coordinated with different teams during test plan preparations, test lab set up and test execution phases of UAT/SIT. Coordinated SIT/UAT, provided daily/weekly reports
  • Very good experience in use of Rational, HP Mercury Tools for Test management and Test Automation (WinRunner/Test Director/Quality Center/ALM/QTP/Load Runner)
  • Administration of test automation tools HP Quality Center, QTP
  • Configured, Project creation in defect tracking tools (ClearQuest/TestDirector/QC)
  • Experience in preparing Test Plans for Functional, GUI, Performance, Upgrade, Acceptance testing and Defect Transition plan, Requirement Traceability Matrix
  • Experience in coordinating with offshore teams and facilitate knowledge transfer
  • Hands on experience in Manual and Automated testing of Applications based on RDBMS, Non-RDBMS Databases, Data modeling, Localization, API, Configuration Management
  • Used SQL extensively for Database testing using SQL queries on TOAD/WinSQL
  • Experience in process of ETL and knowledge of data warehouse, Data migration, data feed
  • Experience in testing upgrades and enhancements, Code Review, Code development
  • Tracked defects till closure, conducted review meetings for defect fix priorities
  • Involved in Process documentation for Testing procedure for specific applications
  • Involved in automation Test management Tool evaluation and Selection
  • Creation of automation scripts in WinRunner and QTP for regression testing
  • Provided periodic Status reports, Dash board reports on Metrics to senior management
  • Good knowledge of ISO, CMM processes and was trained in SQA Auditing.
  • Very good Knowledge of programming languages(.NET, Java, C#, VB)
  • Experienced in Testing Web Services using SOAP UI, XML, XSD
  • Experienced in risk analysis to identify future problems
  • Experience in programming and good knowledge in concepts of OO design, SOA
  • Suggested process improvement techniques with in SDLC

TECHNICAL SKILLS:

WinRunner, Test Director, Load Runner, QTP 8.x/9.x/10.0, Selenium, VSS, VISIO, MS Project, ERwin, StarTeam 4.x, TSL, PVCS, Rational Rose, RUP, TOAD, ALM/Quality Center 8.x/9.x/10.x/11, MSTS, ClearQuest, SOAP UI, WSDL, SharePoint, Citrix, Agile Version One UNIX Solaris/HP, Win2000/NT/9x/XP, Visual Studio.NET, IIS, ASP, JSP, XML, XSD, ASP.NET, C#.NET, Java Script, VBScript, Shell script, Perl, Java, PHP, VB 6.0/5.0, C, Scala, SAP(MM/SCM/HR/PM), Mainframe, TSO/ISPF, TFS, MTM, GIS, SCADA,DMS

Oracle 11/10/9/8/7.x, Sybase, SQL Server2008/2005, MS Access, MS Project, SQL*Plus, PL/SQL, T-SQL, SSRS, ETL

PROFESSIONAL EXPERIENCE:

Confidential, TX

Test Lead (ETL)

Responsibilities:

  • Interact with product configuration team and SMEs to analyze the business requirements to create test plans and scripts
  • Data validation from databases SQL Server, Oracle using SQL queries
  • Verification of ETL data and processes, validation of data transfer and conversion procedures between systems using SQL
  • Validation of SSRS reports from data warehouse
  • Test Planning and Coordination for UAT and Regression cycles and End to End testing in Agile methodology
  • Test scripts management, Defect review, tracking and management using ALM
  • Integration testing of NM DMS with SCADA/Service Suite/Customer Call interfaces
  • Identification of Test scenarios per Acceptance criteria, Test Data requirements, Testing risks
  • Interface testing and validation using SQL procedures, server logs on LINUX/UNIX, psim, AQL
  • Coordinate between Sprint test teams and PSO team during FAT
  • Preparation Test summary reports, Release Notes, Test estimations

ENVIRONMENT: UNIX/LINUX, Windows, Oracle, SQL Server, Java, .Net, HP ALM, Agile, Version One, Confluence, ClearQuest, DMS/OMS, SCADA, Service Suite, TFS

Confidential, TX

Sr. QA/Lead

Responsibilities:

  • Test Planning for SIT/UAT, End to End testing and Coordination for UAT
  • Verification of enhancements in consultation with SMEs and business analysts
  • Validation of test data and conversion data from legacy systems using SQL
  • Defect analysis and Fix validation, Defect Tracking, Defect review meetings
  • Integration testing with other applications and interfaces
  • Validation of ETL processes, Data exports, Role based Security, ETL data in Source/Staging/Target
  • Identify scenarios for Automation and performance testing
  • Defects and Test scripts management, Test coordination using Quality Center
  • Upload scripts into TFS, work flow customization, Test execution in MTM
  • Tested Web services for validating customer data using SOAP UI

ENVIRONMENT: Windows, AS/400, MS SQL Server 2008, SSRS, TFS, Test Manager(MTM), VISIO, MS Project, SharePoint, SOAP UI

Confidential, CA

System Test Analyst

Responsibilities:

  • Create test scripts for Integration and Functional testing to implement Linear Asset Management Data
  • Verification of Geographic/Linear data transfer through interfaces from Intrepid GIS to SAP PM Linear Asset screens
  • Verification of Notification/Work Order creation using custom transactions zNotif/zOrder
  • Integration testing between modules PM/GIS/Documentum/Linear Asset Management(LAM)
  • Validation of custom reports (ECC) for Notifications/Work Orders/Task Lists/LAM data
  • Testing for manual/automatic creation of Maintenance items and Maintenance plans for various pipeline activities(Install/Reroute/Merge etc.)
  • Verification for creation/updates for Technical objects like FLOC/Equipment due to various Pipeline events/features, enhancements in UI and business logic based on Notification types
  • Validated LAM data and Geographic enablement(Geo.e) population from GIS/PODS
  • Verified Function Location hierarchy changes and validated configuration changes(eg: Notif. type/UOM etc.)
  • Assist user team in UAT test scripts, Upload scripts into HP Quality Center from Excel

ENVIRONMENT: UNIX, SAP R/3 (PM/LAM/MM), GIS, Oracle, HP Quality Center 11.0, VISIO, SharePoint, Citrix, Documentum

Confidential, TX

Sr. QA Analyst

Responsibilities:

  • Interact with product configuration team and SMEs to analyze the business requirements
  • Created test plans and scripts using BRD and Functional specification design
  • Data validation from databases SQL Server, Sybase using SQL queries
  • Verification of ICD 9/10 codes, Data migration validation using ETL, CPT codes
  • Functional Integration testing of feature enhancements and Regression testing, UAT support
  • Validate the Workflows, Security profiles for the applications Allscripts Confidential, GE Centricity Business, OccuSource etc.

ENVIRONMENT: Windows2003/7, .Net Framework, Allscripts Confidential, GE Centricity PM, SQL Server 2008, Sybase, XML, ETL, Quality Center 10.0, Compuware TrackRecord, Agile, Citrix

Confidential, CA

Sr. Tester

Responsibilities:

  • Test scenario identification for end to end testing and Coordination for UAT
  • Verification of new enhancements in consultation with SMEs
  • Defect analysis and Fix validation, Defect Tracking
  • Validation of test data and conversion data from legacy systems
  • End to end UAT, roles/security testing and integration testing with other modules FI/MM/PM
  • Coordinate with business users and collecting requirements, identify the custom changes to SAP objects
  • Technical mapping and verification of custom reports (ECC/BI) for Notifications/Work Orders/Service History/Task Lists/Compatible Units/Designs
  • Assist users in creating Custom Layouts, Variants, User and documentation
  • Identify scenarios for Automation and performance testing
  • Defects and Test scripts management, Test coordination using Quality Center
  • Upload scripts into Quality center, work flow customization

ENVIRONMENT: UNIX, SAP R/3 (PM/FI/MM/SD), Oracle, HP Quality Center 11.0, MS VISIO, SharePoint, VBA, QTP, Citrix, ABAP, SQL

Confidential, MA

QA Lead/Engineer

Responsibilities:

  • Interact with product designer, development teams for multiple projects in Agile environment
  • Configuration of Confidential tool to extract data from external systems of databases SQL, Sybase, Oracle, Flat files
  • Build deployment and virtual servers and validation, configuring interfaces developed in .NET framework
  • SQL Scripting for data validation and data population into database table
  • Create SOAP UI projects and validate web services for secure session authentication
  • Created test plans, strategies and scripts using BRD and Functional specification design
  • Monitor SQL trace during the web service call and verifying service trace files
  • Verification of SSO for the applications, cookie verification using Fiddler
  • Verification of ICD-10 codes, Data migration
  • Functional testing of feature enhancement and regression testing
  • Validate the CCA data with respect to the data in external systems (QNXT, FACETS) for claims related data

ENVIRONMENT: Windows2003, .Net Framework, C#.NET, HTML, Web Services, MS Visual Studio, Oracle, SQL Server 2008, Sybase, Informatica, XML, SOAP UI, TFS, Quality Center 10.0, QTP, VB Script,, Fiddler, QNXT, Agile

Confidential, AZ

QA Lead/QC Admin

Responsibilities:

  • Interact with business teams to understand the test planning needs
  • Validate the functional/technical requirements and integrated test scenarios
  • Establish templates for Test Case creations in line and export into Quality Center
  • Maintaining the Traceability matrix for Requirement/Tests/Defects through QC
  • Defect reporting and tracking in Quality Center. Participated in defect review meeting and followed up for defect fixes/closure.
  • SAP end to end UAT coordination, RICEF categorization
  • Administer and Manage Quality Center and day to day basis & troubleshoot QC issues on various operating systems
  • Create users in HPQC and manage user groups based on profile/role and User support,
  • Configured HPQC for Requirements, Test Plan, Test Lab and Defects using Workflow
  • Managed QC patches, backups for HPQC data, Uploaded Test Scripts into HPQC
  • Managed Release cycles for Assembly Testing, Product Testing, UAT
  • Created Dashboard Reports to monitor Testing progress and track defects
  • Interact with product vendors SAP/HP for licenses and issues
  • Prepared project specific user guides for QC users and trained people to use the QC modules
  • Created backups of QC projects, provided back up plan to Systems group
  • Monitored database logs and handled backend updates
  • Prepared custom reports and graphs in Excel using VBA
  • Involved in Test scenario review and execution of integrated scenarios comprising multiple modules (FIN/SCM/HRP/PM) and coordinated with teams

Environment: Windows 2003, SAP R/3 (FI/SCM/HR/MTC), Oracle, SQL Server 2005, HP Quality Center 10.0, MS VISIO, SharePoint, VBA, QTP

Confidential, UT

Sr. QA Analyst

Responsibilities:

  • Project Test plan preparation, Test case Reviews, End to End Test case design
  • Knowledge Transfer for the team, effort estimation
  • Liaison with program manager and coordination with development team and business analysts
  • Test case preparation, Test execution, Defect reporting, Test status reports
  • Requirement analysis, review of Business requirements and Functional System Design
  • Coordinate with BA and SME in conducting UAT
  • Integration testing, Regression testing for each test cycle and reporting results & prepare test summary
  • Test Data validation, Execute SQL queries using database connecting tool TOAD
  • Requirements Matrix and Test Scripts development for validating business rules
  • Web services testing using SOAP UI and review/debug C# code
  • Involved in configuration and creation of Reports in Quality Center

ENVIRONMENT: Windows 2003, .Net Framework, Windows Forms, Web Services, Visual Studio, NUnit, Oracle 10g, XAML, XML, SubVersion, Quality Center 9.0, SOAP UI, MS VISIO, Mainframe, Java, Agile

We'd love your feedback!