Etl Qa Lead Resume
Charlotte, NC
EXPERIENCE SUMMARY
- 13+ years of IT experience in QA Management, Quality Assurance and Quality Control.
- Strong domain experience in Retail, Supply chain management, Telecom and Banking applications.
- Strong experience in transforming business requirements into test scenarios/test scripts.
- Experienced in developing Test Strategy, Test Plans, and Test - Case Designs based on User Needs.
- Experienced in setting up QA processes and implement testing methodologies
- Good working experience with Agile/Scrum methodologies
- Strong working noledge of Databases like Teradata,SQL Server, Netezza, Oracle, MySQL and DB2
- Experienced working in ETL, Java, .NET, Unix, Data warehousing and Web Services environments
- Hands on experience creating and tracking project plans using MS Project tool
- Strong working noledge with QTP Automation Scripts and test management tool HP Quality Center (QC).
- Capability to apply wide technical and practical skills to managefunctional, regression, system integration (SIT), acceptance (UAT), browser compatibility and data warehousing testing.
- Strong problem solving and trouble shooting skills and an ability to come up with creative solutions.
- Sound Knowledge in Waterfall and Scrum methodologies
- Design and implement automated frameworks testing process to halp drive organizational efficiencies.
- Extensive experience in coordinating testing effort, responsible for test deliverables, status reporting to high level management, issue escalations.
- Build trusting relationships with QA team members, providing coaching and feedback.
- Testing of web applications, client-server, supply chain management and data warehouse projects on Windows, Macintosh and UNIX operating systems.
- Excellent communication and presentation skills, self-starter and quick learner.
- Good experience with working on Onsite-Offshore model.
TECHNICAL SKILLS
Operating Systems: Windows 9X/2000, Windows XP, Windows 7, UNIX
Languages: C, C++, VB, SQL, Java, Java Script, HTML, XML
CRM Packages: Siebel 7.5
Database Tools: Oracle 10i, MS-Access, IBM DB2, SQL server 2012, Teradata, Hadoop, Netezza
Testing Tools: Test Director, Win Runner, Rational Clear Quest, Quick Test Professional 9.2, Quality Center 11.0, Version One, JIRA
ETL Tools: Data stage
Special Software: MS Office 2010 & 2013, IBM’s Web Sphere Commerce, CITRIX, Documentum, Broad Vision, IBM Admin Console, IBM Accelerator, NITRO, Answers QC, Audience Watch, JIRA, Microsoft SharePoint, EPM (Enterprise Project Management), Supply Chain Management.
PROFESSIONAL EXPERIENCE
Confidential, Charlotte, NC
ETL QA Lead
Responsibilities:
- Gathering business requirements from Charter product owners.
- Translating Business Requirements into Test Scenarios and Test Cases.
- Test Planning and scheduling of tasks based on teh business objectives.
- Perform ETL/backend testing on Netezza databases for Interim Reporting.
- Analyze Sales, Marketing and Small Business data flowing from EDW and FM data sources.
- Report data discrepancies to upstream applications.
- Run data extracts using UNIX platform and ftp files to down streams.
- Work with Release management for code deployment and perform post production validations.
- Assist in solving environment configuration issues.
- Coordinating integration testing with upstream and downstream applications.
- Participate in scrum meetings and follow agile methodologies.
- Source to Target data validation and backend testing using SQL.
- Identify QA improvements and drive implementation to completion on time.
- Test Management (Test plan/Test Cases/Test Execution/Defects) using Quality Center tool.
- Publish daily test status with stakeholders.
Confidential, Charlotte, NC
ETL QA Lead
Responsibilities:
- Participate in Requirement analysis sessions and prepare test plan for counterparty credit risk(CCR) applications.
- Participate in daily meetings with stakeholders and discuss project testing progress, issues/risks.
- Coordinate and perform integration testing with up streams FX and Integral.
- Create test artifacts and upload teh documents in SharePoint.
- Perform data analysis using SQL queries on SQL server.
- Assign tasks to team members and tracking tasks for their timely completion.
- Perform ETL/backend testing on Teradata database in SIT and UAT environments.
- Perform Regression testing Confidential teh end of functional testing and provide release sign off.
- Participate in scrum meetings and follow agile methodologies.
- Perform post production testing after teh deployment.
- Manage Changes in Test Requirements and Schedule.
- Setting up goals and objectives for QA team.
- Identify project risks and mitigate them.
- Track daily test progress using JIRA burndown Chart metrics.
- Act as key point of contact for all QA aspects of releases, providing QA services and coordinating QA resources.
- Publish daily test status with stakeholders.
- Suggest/Implement process improvements.
Confidential, Charlotte, NC
Sr. QA Lead
Responsibilities:
- Prepare Test Strategy and Test plan documents based on business requirements.
- Requirements, Test Cases, Test Execution and Defects management using Quality Center.
- Participate in daily meetings with stakeholders and discuss project testing progress, issues/risks.
- Coordinate with Upstream & Downstream teams to identify project dependencies.
- Perform Data Migration testing during loan conversion projects.
- Assign tasks to team members and tracking tasks for their timely completion.
- Work with project team to create Test Escape Analysis (TEA) report and improve SIT testing.
- Perform ETL/ backend testing on Teradata, Netezza & SQL server databases.
- Perform data analysis using SQL queries.
- Perform Regression testing in stage environment after functional testing is complete.
- Participate in scrum meetings and follow agile methodologies.
- Participate in Story grooming sessions and provide work estimates.
- Participate in Sprint planning sessions and develop Sprint backlog items and Sprint goals.
- Assist production support team for rapid response during teh deployment.
- Manage Changes in Test Requirements and Schedule.
- Identify project issues and escalate accordingly.
- Track daily progress using Burndown Chart metrics.
- Offshore and onshore coordination and resource management based on present and future release requirements.
- Create weekly/monthly testing status dashboard reports and test metrics and share with stakeholders.
- Suggest/Implement process improvements.
- Index and archive test artifacts in SharePoint/ Confluence.
Confidential, Tampa, FL
Sr. QA Lead
Responsibilities:
- Gathering business process requirements through Nielsen’s client meetings and analyzing them.
- Translating Business Requirements into solutions.
- Test Planning and scheduling of tasks based on teh business objectives.
- Assist in solving environment configuration issues across multiple teams and QA personnel.
- Coordinating integration testing with other applications.
- Source to Target data validation and backend testing using SQL.
- Identify QA improvements and drive implementation to completion on time.
- Defect Management using Quality Center, JIRA and Remedy tools.
- ETL testing including logs, counts, constraints, table relations verification.
- Fixing Automation Script issues and halp team members with issues dat they run into
- Collecting and reporting system testing QA metrics to higher management
- Conducting status meetings with Product Managers and update teh status of project
- Assigning tasks to team members and tracking tasks for their timely completion.
- Review of Project Deliverables like Test Cases, Traceability Matrix and Test Results.
- Facilitate daily Scrum meetings and weekly project planning and status sessions
- Single point of contact (SPOC) for all testing activities System, Regression and UAT testing.
- Conducted defect review meetings with teh team members and analyzed teh causes
- Leverage resources and implement QA best practices.
- Managed Changes in requirements and schedule
- Identified teh project priorities
- Trained and mentored team members.
- Determined teh resource requirements and release / recruit teh resources
- Review of systems procedure, policies, etc.
- Index and archive project records during closing process
Confidential, Hoffman Estates, IL
QA Engineer
Responsibilities:
- Conducted meetings with Sears Business Analysts to understand business requirements and system requirements.
- Estimated teh efforts, developed detailed test strategy, test plan and test cases
- Prepared Traceability matrix to make sure all business requirements are covered during testing.
- Test Case Execution Defect Tracking using QTP tool
- Lead and Managed defect review meetings with teh team members and reported status to Management on daily basis
- Assigned tasks to team members and tracked tasks for their timely completion.
- Testing of Supply Chain Inventory management applications.
- Run Daily/Weekly batch jobs using IBM tools Data Stage, Admin Console and Accelerator.
- Tracked Data Stage ETL jobs to its completion and analyzing teh job if any error occurs.
- Data Migration testing for Sears customer profiles using Data Stage jobs.
- Conducted status meeting with Project Manager and update teh project status
- Create and run SQL queries against different data bases (QA, Staging and Production) and make sure teh data reflects correctly on Sears.com front end.
- Testing of pricing management applications developed using JDA software.
- Conduced daily Onsite/Offshore calls to make sure QA life cycle goes smoothly
- Been a partner of delivery team to resolve open issues, retest functionality, and acted as primary decision maker on application readiness for production
- Analyzed defects found during testing and identified their causes, dis data was provided to dev. team and halped them concentrate on teh areas of high defect rate.
Confidential
QA Analyst
Responsibilities:
- Analyzed Business requirements and prepared Test scenarios.
- Test Environment and Test data setup.
- Prepared system test cases and performed peer reviews of teh System test cases.
- Perform Reviews and walk thru for teh delivered software artifacts.
- Executed system test cases and performed System Integration tests.
- Raised defects and tracked them to closure.
- Coordinated with onsite counterparts. Responsible for quality of teh deliverables.
- Query teh tickets automatically depending on teh error type Using Quick Filter Tool which facilitates teh automation of Ticket assignment procedure.
- Analyzed teh Errors and resolved teh same Using Error Management Tool.
- Obtained teh status of teh Individual as well as Group using Ticket Tracking System tool.
- Using TCS’ Web IPMS tool for tracking teh status of work requests and overall project monitoring in accordance with TCS IQMS.