Data Test Cases

Mohammed Amir Uddin

Email: *********@*****.***

Cell: 647-***-****

Objective:

To find a challenging position as a Senior QA Analyst to work in quality assurance work space in any IT industry for a software development, tools upgrade, integration, migration and infrastructure project

Summary:

Having 13+ years of Software Testing and Quality Assurance experience including above 10 years of ETL, EDW, Databases, Infrastructure, BI Reporting, ESB and BIG data testing

Strong in analyzing functional, nonfunctional & technical documentation, use cases, wireframes, dataflow diagram, data mapping, Data dictionary, User Stories, IA, ER diagram and DDS

Worked closely with BA, DBA, Architects and ETL, Infrastructure, Dev lead to design effective test plan, test strategy, scenario and test cases. Executes manual and automated test cases in HPALM, DVO and Platinum

Expert in all cycles/Sprint of testing - system integration testing (SIT), regression, end to end, interface, data flow, data migration and integration

Write and execute sql queries in TOAD, SQL developer, DB Visualizer, Oracle, SQL server and Teradata

Effectively worked with ETL jobs in Control-M, Informatica, Ab Initio, BODS, Autosys, ESB (web services, SOAP UI, MIM, WMB, and WMQ) for extraction, transformation and loading the transactional and master data in Teradata, Oracle, EDW and NDW.

Manage third party data, marketing / finance data, SAP master data and transactional data in EDW and Teradata

Strong in writing SQL queries and managing master data along with the transactional data

Updates and executes shell scripts in Linux, Aix UNIX, Hadoop, Apache NIFI, Oozie systems loading data from different sources to UNIX, Teradata, Oracle, DB2 databases and servers.

Validates the flat/psv/csv/xml files, error logs for Informatica, autosys, BODS, BTEQ, shell script in UNIX systems

Validates transactional and master data in HANA, Teradata, Oracle, DB2, Hive, HBASE and BI tools for the below flows:

oPOS > Mainframes > SAP ECC, PLM, POSDM, BW, HANA >Golden Gate >ETL>Teradata > Micro Strategy

oWeb/mobile> CRM / FICO > ETL>Teradata/Oracle Staging > Core > Semantic > Reports in BOXI.

oDMIT > EBR (Stage >EBR > ESN) > IRDM (outbound file)

oCRM/BOB/Life scan>ETL>Hadoop(RAW>Hive External>Hive Managed>Analyze)>Landing Zone> Reports

Experienced with RUP, SDLC, Agile Scrum method and training on Power BI

Employment History:

Name of the Company

Designation

Address of the employer

From

To

Duration

Cognizant Technology Solutions

Senior QA Analyst

Toronto, Canada

2010

Till date

7 + years

Rogers Telecom

Senior QA Analyst

8200 Dixie Road, Canada

2010

2010

8 months

NPD Group

Senior QA Analyst

Long Island, NY, US

2009

2009

6 months

HP Company Ltd

Senior QA Analyst

Rockville, Maryland, US

2005

2009

3 + years

Chase Manhattan Bank

QA Analyst

Manhattan, NY, US

2004

2005

2 years

Technical skill:

Operating System

Windows, UNIX, AIX, Linux, OS/2/390/370/390, Mainframe, Mac OS

Programming Languages

C++, SQL, PL/SQL, VB Script, Java, VB6, .Net, HTML, XML, SOAP, Perl

Databases & Tools

Databases:

Oracle, SQL Server, DB2, Sybase, TOAD, PL/SQL Developer, POSDM/HANA/BW, PLM, CRM, Teradata SQL Assistant, HIVE, HBASE

Tools:

WINSCP, Putty, HP ALM 12.0, TOAD, FileZilla, SOAPUI, Visio, MS Project, MS Exchange, Lotus Notes, QTP, AR Remedy, Clear Quest, RQM, COGNOS, SAS, Ab Initio, Informatica, Big data, Hadoop, HDFS, Apache, NIFI, Oozie, Control-M, Ultra Edit, Middleware ESB, WMB, WMQ, MIM, BODS, ETL, OLAP, OLTP, MDM, SAP, Micro Strategy, BOXI, PVCS Tracker, BMC Remedy, Clear Case

Other Utilities

Notepad++, EditPlus, Snag it, MS Excel, MSWord, MS Power point

Location

Toronto, Canada

Project Profile:

Project Title

Informatica upgrade, RxBi ETL migration, LCL CRs

Duration

June 2017 – To date

Location

Onsite, Toronto, Canada

Operating Systems

Windows, LINUX, AIX

Programming Languages, databases and tools

Autosys, MIM, BODS, Microstrategy, Informatica, Maestro jobs, shell scripts, BTEQ, SQL, EDW, MDM,Teradata, Oracle, DB2, Netezza, DbVisualizer, Beyond comparator, DVO, Platinum

Project Description:

Informatica upgrades, integration, migration, conversion and merging of Shoppers drug mart systems into Loblaw Systems.

Clinet Description: Loblaw Canada Inc, Toronto, Canada

Role: Senior QA Analyst

Responsibilities:

Design the test strategy, test plan, requirement traceability matrix, test scenario, test cases, leverage assignments and support the offshore team members

Analyze the requirements, ER diagram, DS documents, mappings, data flow, transformation logic, look up systems, source and target output type of file/tables to design the effective test scenario

Write test cases, prepare test data, clarify missing requirements, coordinate with project teams for ambiguities, issues,clarification

Create the directory path in Linux, configure Teradata and informatica to add databases, repository, domain for Informatica 7.5, 8.1, 9.6 and 10.2. Modify scripts of .RUN file and global_va file to set the QA environment

Executes Informatica workflows, ETL jobs in BODS, MIM, workbench, shell scripts, Bteq in Aix and Linux to process and validate transactional and master data in Linux, Oracle and Teradata

Write SQL queries to validate the data in EDW, Teradata, DB2 and Oracle. Also compare data using automated tools DVO, Beyond Comparator and Platinum tool

Write complex sql queries in Teradata and Oracle to verify the data with BI tools BOXI and Microstrategy

Investigate the log details of job’s execution status, failureness, warnings to resolve the issues and assign the defects to the correct team

Executes test cases and manage defects in ALM. Coordinate with team members for clarifications and defect resolutions.

Attend agile scrum meetings, update status daily and weekly, train offshore along with knowledge transfer.

Project Profile:

Project Title

DMS – Diabetes Management Solutions

Duration

Jan 2017 – May 2017

Location

Onsite, Toronto, Canada

Operating Systems

Windows2007, LINUX, Hadoop

Programming Languages and tools

Java, SQL, HQL, Shell scripts, Oracle, SQL server, Hortonworks, Big data, HDFS, Apache Nifi, Oozie, HIVE, Hbase, WINSCP, PUTTY,HPALM,CRM

Project description:

The Collaborative Carriers (i.e. Manulife, Industrial Alliance) and Express Scripts are exploring the benefits of implementing a Diabetes Management Solution and associated processes, which will support an enhanced healthcare offering to Plan Sponsors and improve the health and well-being of members. Enrolled Members will receive alerts (whether email or text message) that will inform them they should be contacting our Therapeutic Resource Center to obtain support on the management of their condition.

Client description: Express Scripts of Canada (ESI), Toronto, Canada

Roles: Senior QA Analyst

Responsibilities:

Create test strategy, test plan, requirement traceability matrix, test scenario, allocate tasks, leverage assignments, support and knowledge transfer to offshore team members

Review test cases, prepare master data, set up environment, clarify requirements, coordinate with project teams for issues/escalation, monitor and manage QA team’s task

Executes shell scripts, jobs in Apache NIFI, Oozie for data validation in Linux, hive, hbase and oracle

Executes test cases, managed defects in HPALM; coordinate project teams for clarifications, issues and defect resolutions.

Prepare daily/weekly status reports for the project team and stakeholders

Project Profile

Project Title

EBR – Margin Lending

Duration

August 2016 - December 2016

Location

Onsite, Toronto, Canada

Operating Systems

Windows2007, LINUX

Programming Languages and tools

Java, SQL, Shell scripts, Sybase, EDW, Aqua Studio, WINSCP, PUTTY,HPALM

Project Description:

This project enhanced the input information and established a central source to automate the data transfer from which detail information for Margin Lending clients can be captured and traced.

Client description:

“Royal Bank of Canada”, Toronto, Canada

Roles: QA Analyst

Responsibilities:

Create test plan, requirement traceability matrix, test scenario, design test cases, allocate tasks, leverage assignments, support and knowledge transfer to offshore team members

Wrote SQL queries in Sybase to validate business and transformation logic mapping and data model.

Executed shell scripts in LINUX for data validation in database and outbound files

Executed test cases, prepared test data, managed defects in HPALM and prepared daily/weekly status reports for the project team and stakeholders

Project Title

SAP CR2, D3A/B Implementation, Release R2/R3, G3/G4 Project, ESB Upgrades, Vendor Portal, MSP Project, PC Financial, Planogram, Track, IPFR, Sales Audit and Finance, Loyalty and BI Projects/CRs

Duration

November2010 – August2016

Location

Onsite, Toronto, Canada

Operating Systems

MS Office2007,Windows, AIX, UNIX

Programming Languages and tools

SAP, ECC, BW/HANA, POSDM, CRM,PLM, Mainframe, ESB, MIM, WMB, WMQ, Web Sphere, BODS, Autosys, BTEQ Script, Big Data, Hadoop, HDFS, HIVE, Informatica Power Center, Manhattan ES, WINSCP, SOAPUI, ETL, NDW, Oracle, Teradata, SQL Developer, Micro Strategy, BOXI and HPQC

Project description:

All Non-SAP, Main Frames, EDW, WMS and more than 400 interfaces are redesigned, developed, integrated and migrated to SAP

Client description:

“Loblaw Inc” is the sixth world largest retail company located in Toronto, Canada

Roles: Test Lead/QA Analyst/Data Analyst

Responsibilities:

Create test strategy, test plan, resource plan, execution plan, entry exit criteria, defect management plan, requirement traceability matrix, test scenario, daily/weekly status report. Allocate tasks, leverage assignments, coach, mentor, and support, knowledge transfer to team members, collect day to day statics and produce report for the higher management.

Strong in writing SQL queries in Oracle, Teradata, HIVE to validate business and transformation logic as per DS doc, data model and data flow diagram.

Analyzed BRDs, DS, IAs, FDs to explore the Systems, Sub-Systems, process, flows and interfaces, connected to POS Store Systems, Legacy Systems, SAPECC, PLM, CRM, BW, HANA, LINUX, AIX, Teradata, Informatica Power Center, Big Data, Hadoop, HDFS, HIVE, Micro strategy, BOXI, Info in order to create the test scopes and scenario for the end to end data validation

Executed ETL jobs in Autosys, BODS, Informatica Power Center, WMB, MIM to load data from source to target for validation

Wrote complex SQL queries for data validation in BI tools with Datamart and EDW

Validated E2E data flow and its business logic from source to target through different stages including Source ->HDFS Staging -> Core -> View ->Outbound (Target)

Changed global variables, executed shell scripts, validated data, analyzed error logs AIX UNIX

Communicating director, PM, business team, design architects, DBA, Developers and Tech leads to design the testing process, prepare the test data, setting up test bed and monitor batch jobs for data availability in each layer of all tiers

Managing and supporting QA members stationed in on and off shore

Project Title

EDW Integration System

Duration

Feb2010 – October2010

Location

Onsite, Rogers, Mississauga, Canada

Operating Systems

Windows, UNIX, Linux

Programming Languages

MS Office2003, Windows, UNIX, Linux, Perl, Oracle10G, VB 6, ETL, Rational Functional Tester, Rational Quality Manger, Informatica, Data Mart, Data warehouse

Project description:

The Enterprise Data Warehouse will ultimately provide Rogers with a single integrated database to support both enterprise and business unit analytics and reporting across all lines of business, while phasing out or consolidating areas of redundancy.

Client description:

“Rogers telecom” is the leading Canadian telecom company in Canada

Roles: Senior QA Analyst

Responsibilities:

oRun ETL jobs in Control-M manager to validate process, flow, data, table definitions, properties, content, mapping, maplet in informatica

oPrepare test data for validation of control file, .dat files, parameter file, source files, target files

oValidate file (.dat & ctl) counts, file sizes, permissions, row count, checksum, pipe counts, system log reports and statuses in Unix

oWrote SQL queries for data validation in Teradata SQL Assistant

oWrote and update shell scripts UNIX using Perl and AWK o validate data in flat files, to generate message and move files in different sources to targets within UNIX servers.

Wrote shell scripts in UNIX to validate data in flat files, to generate message and move files in different locations of UNIX servers.

Project Title

Nexus 6 & New Architecture Applications

Duration

July2009 – December2009

Location

Onsite, New York, US

Operating Systems

Windows, UNIX, Linux

Programming Languages

MS Office,Windows,UNIX,Oracle10G,Toad9.7,VB6,ARRemedy 7.5, Quality Center 10, Ab Initio, ETL, Web Sphere, Data Mart, Data warehouse, SAS

Project Description:

Mission of this project is to deliver NPD’s POS (Point of Sale) and consumer panel data to our clients both on time and correctly. To reduce cycle times and improve data quality, while optimizing cost.

Client Description:

NPD was founded in 1966. Its services include providing market information and advisory services to companies.

Roles: Senior Test Analyst

Responsibilities:

Create testing scopes, test scenarios by analyzing project documents and performing knowledge transfer meeting with team members.

Worked for flat data validation in EDW among ETL, OLTP, ODS processes

Loading flat data from Design and develop test plan, test cases, traceability matrix, defects log, track and resolve clients to NPDs system using shell scripts, process data in Ab Initio tools and validate processes, modules, elements, input versus out data and log files

Migrate data from clients to NPD’s system by running shell scripts, FTP, JCA, MCA in ETL process

Transfer files from source to destination, ftp client to local and convert data from Ab Initio to SAS, local to excel and compare them input vs. output

Prepare test documents, QC metrics and status reports

Project Title

Form Filing

Duration

November2005 – June2009

Location

Onsite, Maryland, US

Operating Systems

Windows, UNIX, Linux, SUN Solaris

Programming Languages

MS Office2003, Windows2000/XP, Unix, SunOS, Oracle10G, Toad9.7,SQL Server, PL/SQL Developer .Net, Visio, Microsoft Project, Quality Center 9.0, QTP9.2, Load Runner, Informatica8.1, ETL, COGNOS8, Data warehouse,PVCS8.0.2

Project Description:

Regulatory Filing Applications is the project of nine applications is being used to capture and process the filings submit by 5000 firm users of NASD, AMEX, NYSE

Client Description:

The NASDAQ Stock Market, commonly known as the NASDAQ, is an American stock exchange. It is the second-largest exchange in the world by market capitalization, behind only the New York Stock Exchange.

Roles: Senior QA Analyst

Responsibilities:

Analyze, review, update the System Requirement, Details Design Specifications and Use Cases in order to write test scenarios, test strategy, test plan and traceability metrics

Root cause study and analyze the defects and resolve the issues

Wrote and executed SQL queries in TOAD, PL/SQL, Oracle to test data in Cognose

Validated ETL logic in the Informatica from Source to Staging, Staging to Data Mart, DM to EDW

Created new scripts and updated existing scripts in QTP and Load Runner for smoke and regression testing

Managed test cases and defects in Quality Center

Worked closely with development and business to resolve issues and problems

Project Title

Chase Global Private Banking System

Duration

Jan 04 – Oct 05

Location

Onsite, New York, US

Operating Systems

Windows, Unix, MacOS

Programming Languages

Java, Java script & HTML

Project Description:

Chase Global Private Banking System – Enterprise system including modules for Investments, Mortgages, Pensions, Benefits, Trading and Brokerage

Client Description:

Banking and financial organization located in Manhattan, New York, US.

Roles: QA Analyst

Responsibilities:

Prepared and executed test cases to validate the hardware, software, networking, protocol, GUI features, object, images, dynamic texts and log files

Encoded number, activate and deactivate the credit card in order to protect from fraudulence

Assisted the customer in providing data for and testing information to the UAT members

EDUCATION

Title of the Degree

College/University

BACHELOR DEGREE

Khulna University of Engineering and Technology, Bangladesh

XII

Government Technical College

X

Narayanganj High School

Contact this candidate