Resume

Sign in

Etl Test

Location:
Waterloo, ON, Canada
Posted:
May 15, 2020

Contact this candidate

Resume:

NESAR AHMED

EMAIL : adc8d3@r.postjobfree.com

978-***-****

EXECUTIVE SUMMARY:

More than 20 years of overall experiences in SDLC/STLC. A solid understanding of Agile Scrum Framework, SDLC, Test Planning, Test Design, Test Execution and Defect Reporting & Tracking. Proficient in Test Automation using UFT /QTP, Cucumber and Selenium Tools. Strong Experience in Automating Web Application Testing using Selenium WebDriver with Gherkin framework. Executing Selenium Test Cases and Reporting defects. Experience in Data driven Testing, Cross browser testing and Parallel Test execution selenium Grid. Expertise in implementation of Automation framework using Selenium WebDriver and Katalon. Involvement in Test Estimations for Test Plan implementation. Self-motivated, energetic and highly ethical in all work-related assignments thus able to immediately contribute to corporate goals and objects. Good written, communication, interpersonal skills, proven team player with an analytical mind bent to problem solving and delivering solutions. Worked under testing methodologies like Agile-SCRUM/Waterfall/Hybrid, Agile Certified Scrum Master

Technical Skills

Tools: MKS, BadBoy, Jmeter, LoadRunner, HP ALM/ Protocol Analyzer, QTP, Tosca,Zeuz,

Hardware: IBM System 390, Sun Ultra, HP-9000, IBM 4598 Crypto card,

Platforms: MVS/ESA, UNIX (HP, Solaris), Netware, Windows NT /W2K/XP

Programming languages: SQL, Java, HTML, XML and Java Script, JCL

ERP & Database systems: SAP R/3, Oracle, MS SQL Server, DB2, MS Access

ETL & BI: SAP BW/BI, Informatica, MRM, Data Stage, Ab Intio, COGNOS, Business Objects

EDI Transactions: 310, 311,315,322, 997, 824, 835,837 270, 271, 276, 277 Transactions.

Data Security: Cryptographic Algorithm, Entrust 5.0 & Information Security.

Soft Skills:

Speaks English, French and working knowledge in Spanish

Strong organizational skills

A strong ability to work both independently and in a team environment

A keen desire to gain a deep understanding of a problem

Solve problem using out of the box techniques

Effective decision-making capabilities

Strong influencing and negotiation skills

Strong coaching, motivation and staff development skills

Awareness and understanding of cultural diversity

Demonstrated skill in coordinating multiple business initiatives simultaneously

Ability to influence business practices to improve the quality

Ability to partner and collaborate for win-win solutions

Demonstrated ability to manage pressure and to provide clear direction to people

Awareness and understanding of cultural diversity EDUCATION AND TRAINING

M.Sc in Software Engineering, Fairfield University, Fairfield, Connecticut, USA

Rapid Testing, South West Ontario Quality group

Six Sigma Yellow Belt Training, BlackBerry

Certified Scrum Master

ITIL/PMP in progress

Negotiation and Conflict Resolution, Macquarie Graduate School of Management

Analyzing Global Trends for Business & Society, Wharton School of Business

An Introduction to Marketing, Wharton School of Business EMPLOYMENT EXPERIENCE

Lead QA, Automation Solutionz, waterloo ontario, CA July 2019 till date

Analyze and review Requirement/design documents

Prepare test plan/test strategy/test scenarios/test cases/test data/test reports

Create Requirement Traceability Matrix

Design manual & automated test cases using ZEUZ framework

Execute manual and automates test cases.

Prioritize/retest defects

Verifiy back end data

Document and maintain test result, reports and weekly status report.

Support UAT team members.

QA Squad Lead, Fidelity Investments, Boston, MA, USA 10/2018 – 06/2019

Review requirements specifications and technical design documents to provide timely and meaningful feedback

Participate discussion meeting with development teams of issues/bugs with to drive towards root cause identification and resolution

Establish best practice in automated testing to make a well- documented and reproducible testing results.

Work with Application Developers to resolve application entrance criteria’s, defects and anomalies

Interact with Squad/Chapter Leads, Project managers and developers to drive projects to on-time, quality releases

Attend Squad/Chapter/SCRUM Team stand up meetings to discuss the progress of daily tasks

Involve in preparing test plan/scenarios/cases and execute test cases.

Reviewed Test Plan/Strategy/Test cases

Reviewed ETL test cases with mapping document

Executed complex SQL queries to verify backend data

Executed end to end test cases for ETL and BI systems

Prepared test strategies for both manual and automated testing

Prepare QA Schedule

Work with minimal supervision in a fast-paced development environment

Organized and facilitated Sprint Planning- including stand-ups, review/demos, and retrospectives.

Protected team from over-commitment, managed backlog, prioritized resolution of defects/bugs, removed impediments

Mentored teams, leading them to be self-directed with strong accountability, decision making, conflict resolution and transparency

Built the team's agile knowledge and empower the team to make process improvements captured in sprint retrospective meetings

Trained team members to follow QA process and standards

Provide Weekly QA status to Squad/Chapter Leads

Prepare UAT Test Summery

Other duties related to testing as assigned Squads/Chapters State Street Corporation, MA July 2018 till

Sept 2018

Senior ETL QA Consultant

Analyze and review Requirement/Design documents for BCBS-248 Project

Involve in preparing test plan/scenarios/cases and execute test cases.

Reviewed ETL Test Plan/Strategy/Test cases

Lead Onshore and offshore QA Team

Designed QA Artifacts and improve QA process

Trained team members to follow QA process and standards Manulife, Ontario, CA July 2016 till

June 2018

QA Program Lead

Analyze and review Requirement/STM/Design documents for Healthcare projects

Actively participate in requirements and design walkthroughs

Involve in preparing test plan/scenarios/cases and execute test cases for ETL and BI projects

Executed SQL queries to verify source and target systems.

Reviewed Test Plan/Strategy/Test cases

Prepared test strategies for both manual and automated testing

Prepare QA Schedule

Lead Onshore and offshore QA Team

Estimate QA efforts based on requirements and

scope/time/resources

Review & Execute Test cases/defects

Test and Debug problematic issues.

Review team members performance

Coached a distributed cross-functional team on Scrum best practices and continuous improvement.

Removed impediments and helped the team find the right people to remove the impediment.

Facilitated discussions and team ceremonies, including the daily scrum, product backlog refinement, sprint review, sprint retrospective, and sprint planning

Managed defect triage

Create and present QA Sign off documents for production readiness

Assisted the Product Owner with refining the product backlog. Teradata, Toranto April 2016 till

June 2016

QA Consultant

Analyze and review Requirement documents, Feature documents, design documents

Involve in preparing test plan/scenarios/cases and execute test cases.

Develop and execute test cases for Functional, System, End to End, Regression for ETL projects.

Deploy and execute Batch testing

Use Tera SQL assistant to verify backend database

Test and Debug problematic issues.

Execute performance testing using Apache JMeter and Load Runner

Participate in Sprint Planning meetings

Attend daily scrum meetings

QA Delivery Lead April 2014 till Feb

2016

TCS: Clients: RBC, Genworth, Experian, Sunlife

Reviewed and analyzed project artifacts/requirements.

Facilitated discussions /team ceremonies/ daily scrum, product backlog refinement,

sprint review, retrospective/ planning

Manage resources and budget to maximize productivity & effectiveness

Oversees the Test Leads in the creation of Master Test Plans

Review automated & performance testing test plan/scenarios/test scripts

Review Test scenarios/cases and executed test cases for ETL and SFDC projects

Executed ETL and Sales Force test cases

Manage BPT components in HP QTP for regression testing

Review Data Mapping and ETL Process

Monitors testing status, issues and risks on an ongoing basis

Review and sign off test artifacts

Apply risk analysis practices

Influence and contribute to successful change

Ensure compliance with QA practice and company’s control standards & governance

Contribute to the change vision and strategy by modeling the required behaviors

Prepare management and status reports

Manage escalations

Create data migration check list and field mapping document

Manage and coach QA staff in their delivery of testing activities through the SDLC

Attend Daily meetings

Manage UAT testers

QA Lead, Autodata Solutions, Ontorio,

Oct 2011 April 2014

Acted as a Lead coordinating all QA efforts for GM projects

Managed resources and budget

Involved in preparing test plan/scenarios/cases and executed test cases for ETL, Salesforce CRM application

Identified and reported defects in Quality Center and involved in retesting the defects.

Worked with business analysts and developers in resolving the issues

Involved in Manual penetration & security testing

Evaluated vendor resource performance

Collaborate with team members to identify and improve quality, process and procedures

Monitored and validated vendor efficiency, metrics, and reports

Produced the requirements traceability matrix

Coordinated onshore/offshore team

Prepared environments for testing including test data setup f

Helped BAT/UAT testing for Workday Implementation.

Executed test cases for Mobile applications

Used SOAP UI & Fiddler for web service testing

Participated Sprint Retrospective meetings

BlackBerry, Ontario

Position: QA Project Lead Nov 2008 till July 2011

Analyze and review Requirement documents, Feature documents, design documents

web service and mobile applications

Involve in preparing test plan/scenarios/cases and execute test cases.

Develop and execute test cases for Functional, System, End to End, Regression, etc.

Removed impediments and helped the team find the right people to remove the impediment.

Facilitated discussions and team ceremonies, including the daily scrum, product backlog refinement, sprint review, sprint retrospective, and sprint planning

Test and Debug problematic issues.

Perform Web Services testing using SOAP UI, Fiddler

Developed ETL test script from the DATA mapping document.

Execute performance testing using Apache JMeter and Load Runner

Facilitate daily scrum meetings

Ford Motor Company, MI

Position: Test Lead Oct 2007 till –

June 2008

Managed QA ‘Best Practices’ implementation effort SYNC project

Created Test Strategy, Test Plan documents, test cases &executed test cases

Managed resources and budget

Performed load testing using Load Runner.

The Average CPU usage, Response time, TPS are analyzed for each scenario.

Performed back-end testing on Oracle

Developed various reports and metrics to measure and track testing effort.

Verified traceability of Test Conditions to Test Cases

Provided Test Estimates for various phases of the project

Oversaw all phases of testing & Coordinated Off-shore Test Resources

Perform Web Services testing using SOAP UI, Fiddler & Apache Jmeter. National City Corp, cleveland OH May 2007 till

Oct 2007

Position: QA Lead

Analyze and review ETL, Reporting and/or Business Intelligence Application

Requirement documents

Involve in preparation of Test Data to test the functionality of ETL Sources Mappings and Targets

Involve in preparing test plan/scenarios, test cases & executed test cases

Use various testing tools, Support UAT team members.

Document and maintain test result, reports and weekly status report. Citigroup, NY/OH Dec

2006 till May 2007

Position: Test &Quality Consultant

Created Test Strategy, Test Plan documents, test cases &executed test cases

Prepare various levels sizing for testing team.

Analysis of ETL Mappings based on Facts & Dimensions from Source to target tables

for directs moves and indirect moves based on transformation rules & lookup tables

Use TOAD for Oracle in creating & executing SQL queries for testing ETL process

Ensure that the BAT/QA Team reviews the test cases before Execution starts.

Liaison with all teams - project, business, TechOps

Identifies & resolves conflicts relating to release issues

Coordinate onshore/offshore team

NYK Line, NJ

May2005-Dec2006

Position: QA Lead

Act as an EDI/ETL/BI Test lead coordinating all the efforts in creating and maintaining QA efforts

Involve in preparing test plan/scenarios/cases .and executed test cases

Perform stress, load testing & performance testing using Mercury Load Runner.

Produce the requirements traceability matrix

Coordinates all system releases

Coordinate onshore/offshore team

Attend daily scrum like meetings

Performed test analysis - status reports

Implement SAP FICO/MM modules

RouteOne, MI Jan 2005- May

2005

Position: QA Lead

Involve in preparing test plan/scenarios/cases .and executed test cases

Develop and execute different types of test scripts for Functional testing,

Prepare test results

Support UAT/Production team

Executed performance testing using Load runner Controller. Eli Lilly & Company, Indianapolis, IN

April2004-Dec.2004

Position: Software Engineer

Extracting data from different data sources and loading in target data marts

Designing different mappings using transformations

Analyzed Data Mart applications using ETL tool and reviewed ETL workflows and ETL mappings.

Modify and review existing test Scripts, Verify Informatica Standards for ETL mappings

Prepare & execute test cases

Pitney Bowes Inc, Shelton, CT April

2001-March 2004

Position: Software QA Engineer / Systems Engineer

Involve in preparing test plan/ cases and executed test cases.

Use Mercury QC for test documentation, defect tracking & reporting.

Support UAT testing

Visa International, Foster City, California

Aug2000-March2001

Position: QA Analyst

Involve in preparing test plan/ cases and executed test cases.

Prepare environments for testing including test data setup

Produce the requirements traceability matrix

Use Mercury QC for test documentation, defect tracking & reporting

Use various testing tools, Support UAT team members.



Contact this candidate