Test Lead (etl) Resume
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
