Data Testing
Resume:
Niaz Morshed
*+ years of total IT experience and very good knowledge QA of Software Applications and Testing. Extensive
experience in testing of data warehouse / data marts for business applications with Banking, Financial, Brokerage,
Insurance, Pharmaceuticals, Manufacturing.
Extensive 5 years of QA experience in Data Warehousing technology in building and managing various data warehouse /
data marts using Informatica products such as Informatica Power Center/Power Mart, Power Connect, Power Analyzer and
Power Exchange Tools.
Expertise in Web Intelligence Reports, Desk Intelligence Reports, Dashboard, using Business Objects Enterprise XI
R2 / XI R3.
Testing (that includes unit, integrated, regression, and UAT) a new .NET application which uses Microsoft Visual Studio
under the Scrum (Agile) Methodology.
Experience working in using Databases like Oracle, Teradata, SQL Server, DB2, MS Access and DB2. Expertise in
Database Programming (Stored Procedures, Triggers, Packages, PL/SQL) using Oracle.
Experience in Pharmaceutical, Financial, Banking, Manufacturing, and Securities industries.
Extensive testing ETL experience using) Informatica Power Center 9.0/8.x/7.x, (Source Analyzer, Warehouse Designer,
Transformation Developer, Mapplet Designer, Mapping Designer.
Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in
a corporate-wide-ETL Solution using Informatica.
Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
Extensive experience in Business Intelligence reporting tools using Cognos Series, Power Play, Transformer, Impromptu
Web Reports (IWR).
Extensively used SQL, PLSQL to create complex queries, SQL Override, Stored Procedures, and Triggers.
Experienced in Data Modeling, Erwin, Star/Snow Flake Schema Designs, Logical Data Modeling, Normalization,
Physical Design, Data Analysis, Data Modeling, Reports and Report Design.
Expertise in writing Unix Shell Scripts.
Excellent Analytical and Logical Programming skills with a good understanding at the Conceptual Level and possess
excellent Presentation, Interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal
communication skills including experience in proposal and presentation creation.
Technical Skills:
OS : Sun Solaris 2.7/2.6, HP-UX, IBM AIX 4.3/4.2, MS DOS 6.22, Win NT/2000/98/95.
ETL Tools : Informatica PowerCenter 9.0/8.x/7.x, (Source Analyzer, Warehouse Designer,
Transformation Developer, Mapplet Designer, Mapping Designer,Datastage 7.x
BI Tools : Cognos 8.0 Series, Business Objects, SSAS, Crystal Reports and Siebel Analytics
Languages : SQL, PL/SQL, VB, C, C++, COBOL.
Databases : Oracle 10g/9i/8i, MS Access, SQL Server 2008, DB2 9.x, Teradata V2R6
Other Tools : Erwin 4.5/4.0/3.5.5/3.5.2
Testing Tools : Win Runner 8.2, Load Runner 7.8, QTP 8.2, Quality Center 10, and Test Director
Professional Experience:
AT&T,MO Aug ’11 – Till
Date
Sr. ETL /BI Tester - Holiday Sales Reporting
This project is to build BO Reports that will deliver hourly sales reports out of EDW during critical holiday events.
Responsibilities:
Analyzed the Specifications and involved in identifying the source data needs to be moved to data
1.
warehouse.
Well exposed to SDLC (Software Development Life Cycle) and Test methodologies.
2.
Configured the QA Environment for Manual Testing as well as Automation through autosys.
3.
Tested the data and data integrity among various sources and targets
4.
Designed, developed stored procedures using PL/SQL and tuned SQL queries for better performance.
5.
Used debugger to test the data flow between source and target and to fix the invalid mappings.
6.
Used Informatica Power Center 8.6.1and its all features extensively in migrating data from OLTP to
7.
Enterprise Data warehouse.
Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications
8.
OLTP environment with Business Objects for Business Intelligence reporting
Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross
9.
Tab, Master Detail and Formulae etc.
Responsible for testing Business Reports developed by Business Objects XIR2.
10.
The reports that were created in Business Objects were testing by running the SQL statements.
11.
Testing (that includes integrated and regression) an application which uses Microsoft Visual Studio under
12.
the Scrum (Agile) Methodology.
Good understanding of agile software development lifecycle (iterative and incremental)
13.
Designed and created the Microsoft Visio diagram which represents the workflow and execution process of
14.
all the process in the reinsurance world.
Extensively used SQL queries to check storage and accuracy of data in database tables.
15.
Written complex SQL queries for validating the data stored in different database tables.
16.
Helped the team in analyzing the data to be able to identify the data quality issues
17.
As a Test Lead involved in gathering System and Business requirements, studying and coordinated with the
18.
Development and Business teams to prepare Test Plans and Execution Plans.
Involved in Database testing by writing & executing SQL & PLSQL queries using TOAD to validate that
19.
data is being populated in an appropriate tables & manually comparing the results with front-end values.
Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the
20.
flow and the logic for the Data warehouse project.
Monitored the data move process through Data Extract to Flat file through Informatica Execution flows and
21.
Loading data to Data mart through NZLOAD utility.
Tested database for Data Validation, Data Verification using NZ SQL.
22.
Involved in writing the test cases and Test plans based on Informatica mappings and Data Analyst mappings,
23.
BA Visio diagrams.
Used PMCMD command to start, stop and ping server from UNIX.
24.
Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL
25.
to verify/validate my test cases. Involved in various testing phases like Functional Testing, Unit Testing, System
Testing, Integration Testing, Data Validation Testing Positive and Negative Testing, White Box Testing, Black Box
Testing, Smoke Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
Extensively worked on handling the application response for Positive and Negative sets of data using data
26.
driven testing. Also manually tested the application for each system build, for both negative and positive testing.
Involved in automation of test cases using QTP.
27.
Did functional testing using QTP
28.
Good experience in communicating with offshore team
29.
Communication with the client for weekly status report
30.
Test execution in accordance with test strategy and test schedule, review; issue identification and data
31.
mining exercises in accordance with project plan timelines.
Tested the ETL process for both before data validation and after data validation process. Tested the messages
32.
published by ETL tool and data loaded into various databases.
Generated tractability Matrices to ensure that all the requirements are covered by the test cases.
33.
Extensively used Informatica Debugger for testing the mapping logic during Unit Testing. Performed unit
34.
testing, integrated testing and validated results with Business Analyst and/or customer.
Involved in FTP process to transfer the files from one server to other.
35.
Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
36.
Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to
37.
target, row counts, random sampling and error processing.
Utilized Test Director/Quality Center for Tracking and Reporting Defects, which are assigned to developers.
38.
Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
Participated in Daily and weekly status meeting with team members and coordinated with teams
39.
(Development, Business, and QA) for the progress of the work done in application.
Environment: Informatica power center 9.1.0 1,Business Objects XIR2/6.5.1/6.0/5.1.x/4.0 (Supervisor, Designer, Reporter),
SQL, PL/SQL, SQL Server 2005/2008, Unix Shell Scripting, Micro focus COBOL, TOAD 9.2, MVS, VSAM Files, Oracle 9.2
and 10G, Teradata V2R6, HP Quality Center 10, Autosys, MQ Series, Microsoft Visio, Web Focus report
Cigna Healthcare Bloomfield CT Aug ’09 – Jul ‘11
Sr. ETL/DW/Backend Tester
Project: HP is the implementation partner for CIGNA to execute the HIPAA 4010A to 5010 Migration projects for all of the
CIGNA’s health insurance subsidiary companies. During this transaction there are so many defects. As Testing Analyst I was
involved in Defect Management Team to facilitate ETL Development and SAP Business Objects Development for Reporting
Tower consuming 5010 Compliant Claim Intake Data.
Responsibilities:
tested various historical data and department wise data.
•
Running the Ab Initio Graphs in Unix Environment by writing UNIX Shell Scripts and UNIX Commands
•
Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
1.
Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
2.
Involved in implementation of the Test plans, Test cases and Test Scripts.
3.
Created Test sets in Test Lab to move all the test cases from Test plan to execute the test cases.
4.
Tested the data and data integrity among various sources and targets.
5.
Developed and involved in both Manual Testing and Automation Test Scripts based on Use cases developed.
6.
Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test
•
cases.
Strong testing Quality Assurance experience within agile environment.
•
Tested Business Objects reports and Web Intelligence reports.
•
Managed user accounts and security using Business Objects Supervisor.
•
Tested the universes and reports in Business Objects 6.0
•
Extensively used Informatica power center for ETL process.
•
Preparation of ETL mapping specifications.
•
Worked with QTP for Regression Testing.
7.
Configured Quick Test Professional with Quality center.
8.
Executed of QTP Script for automation testing, analyzing the automation result
9.
Reviewed Informatica mappings and test cases before delivering to Client.
10.
Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ & TPUMP
11.
Trained and coordinated with the offshore team members in understanding the requirements and test cases
12.
for UAT.
Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
•
Involved in ETL Mapping Design and Performance tuning to Load mapping process.
13.
Experienced in writing complex SQL queries for extracting data from multiple tables.
14.
Reviewed the test cases written based on the Change Request document.
15.
Testing has been done based on Change Requests and Defect Requests.
16.
Involved in preparation of System Test Results after Test case execution.
17.
Experienced in writing UNIX script.
18.
Effectively coordinated with the development team.
19.
Created critical scenarios for each change request and defect request.
20.
Worked on HP Quality Center and updated defects status with appropriate information.Test cases and Test
21.
plans are managed and controlled using HP Test Director. And also used HP Test Director to manage and track
defects.
Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User
22.
Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
Used various SQL queries to validate the test case results for back-end test cases.
23.
Well exposed to Software Development Life Cycle and Test methodologies.
24.
Hands on experience with working on Autosys jobs and MQ’s. MQ’s are used for intermediate storage
25.
where the messages are stored for temporary purpose.
Hands on experience working with SQL Server DTS Packages.
26.
Environment: Informatica Power Center 8.1,Business Objects XIR2/6.5.1/6.0/5.1.x/4.0 (Supervisor, Designer,
Reporter),SQL, PL/SQL, SQL Server 2000/2005, Unix Shell Scripting, XML, XML Spy 2008, XSLT, TOAD 9.2,Oracle 9.2,
SOA, SOAP UI, REST Teradata, HP Quality Center, Rational Suite, DB Artisan 8.5.2, Autosys, MQ’s
Standard Federal Bank (ABN AMRO). Ann Arbor, MI Sep ’07 –
July ‘09
Sr. BI/Data/SQL Tester – Global Trading System
On Line Web Access Standard Federal Bank (ABN AMRO) is one of the nations leading financial institutions. It provides
complete banking and brokerage services, asset management, and innovative products for customers. Standard Federal
bank provides 24 hours online web access to its customers to login in to there account and perform various online activities
like check balance, transfer available funds from different accounts, etc. Worked on banking Online Application where
customer can login and view current and past account information, account summary, view and edit personal profile, perform
various secure online activities. Standard Federal bank provides many services to its customers, which were implemented in
this application. Front end is the user interface where the menu, data entry forms and result sets are displayed. This layer is
designed using AWT applets. Back end Oracle database will exist in this layer. The stored procedure for the actions is stored
here.
Responsibilities:
Tested and developed the graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
•
validated the data flow from Source to Target tables by verifying the mappings and transformations in ETL Tool,
•
Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts
•
Tested various historical data and department wise data.
•
Running the Ab Initio Graphs in Unix Environment by writing UNIX Shell Scripts and UNIX Commands.
•
Written SQL queries to validate data against the Business Object Reports.
•
Run various jobs in ETL Tool, Informatica using UNIX operating system
•
Developed bug report after manual testing, bugs encountered during testing and sent to developer by taking snapshot of
•
it.
Performed Data Driven Testing to test the application with different sets of data from the test database.
•
Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.
•
Creating load ready files using Ab Initio to load into database.
•
Gathered user requirements from each Business Units for test.
•
Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
•
Designed and developed Test Plans and Test Cases and executed them.
•
Involved in implementation of the Test plans, Test cases and Test scripts.
•
Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
•
Involved in ETL Mapping Design and Performance tuning to Load mapping process.
•
Organized sessions in a batch to run the sessions in a batch in sequential order or start them concurrently by the server.
•
Created 28 Reports in Web Intelligence.
•
Aided in reviewing Reports and Test Cases.
•
Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects
•
reports
Used multiple data providers, Master/Detail, cross tab, Charts.
•
Created several Ad-hoc reports in Business Objects XI R2 to validate the data.
•
Involved in testing the Business Objects performance & connectivity across different domains.
•
Involved in gathering the requirements for the Operational Reports.
•
Performed tests on various features of agile development process.
•
Initial testing was conducted manually and later phase was executed using Mercury Tools
•
Conducted the Functional, System, Regression, and Performance testing of the Web application using Mercury tools
•
Quick Test Pro and Load Runner.
Worked with Quality center to document test results and validate test scripts. Used Quality Center in routing defects,
•
defect resolution and assigning business cases to business users.
Developed Automated Test Scripts using Win Runner.
•
Designed process performance loading strategies. And also wrote the optimizing techniques to improve the process
•
loading time within the streamline using Server Manager to load the data into the Target Database.
Involved in writing Test cases and Test plans which are managed and controlled using HP Test Director.Also used HP Test
•
Director to manage and track defects.
Documented defects accurately and with sufficient information to enable developers to analyze andreproducethe defect
•
using Test Director’s defect reporting tool.
Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance
•
Testing and Performance Testing.
Used various SQL queries to validate the test case results for back-end test cases.
•
Well exposed to Software Development Life Cycle and Test methodologies.
•
Created and published Impromptu/Report Net reports.
•
Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill
•
Down and Score Cards.
Used Query Studio to test ad hoc reports.
•
Involved in Unit Testing of all reports and packages.
•
Involved in testing the Cognos reports by writing complex SQL queries.
•
Developed complex queries using different data providers in the same report.
•
Environment: Informatica Power Center 8, Oracle, SQL, PL/SQL, Erwin 4.0, UNIX Shell Scripting, XML, TOAD, HP
Quality Center, Report Net, Framework Manager, Business Objects 5.0/6.5, Report Net 1.1
State Farm Insurance, Bloomington, IL Nov ‘05 – Aug ‘07
SR. Data Tester/ETL/SQL – Insurance DWH
State Farm Insurance is one of the leading companies in the nation for the auto insurance with more than 10 million
policyholders. Its companies have consistently received high ratings for financial strength and claims paying ability from
various independent rating agencies. The Insurance DW project was developed in an effort to streamline the entire process of
Insurance and to keep track of various financials on a daily, weekly, monthly basis. Claims, Premium, Loss and Contracts were
some of the modules to deal with.
Responsibilities:
Used Informatica Power Center for Extraction, Loading and Transformation (ETL) of data into the Data Warehouse.
•
Involved in developing the Test Cases, Test Plans and Test Scripts using the Business Requirement
•
Developed Shell Scripts to perform pre-session and post-session operations.
•
Involved in writing the Test Cases, Test Plans and Test Scripts using the Business Requirement
•
Involved in Manual Testing of the Application.
•
Involved in Positive and Negative Testing.
•
Created the test data & Coordinating with Developers/Leads in resolving bugs.
•
Completely involved in developing Test Plans and developed Test Cases/Test Strategy with input from the assigned
•
Business Analysts
Extensively involved in the Performance testing of the programs, ETL Procedures and Processes
•
Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test Cases and Test Scripts.
•
Used various SQL queries to validate the test case results for back-end test cases.
•
Extensively used Mercury Quality Center (Test Director) and created Test Cases in the Test Plan according to the
•
specifications.
Environment: Informatica Power Center 7.1, Oracle, XML Files, Dat Files, MS Excel, Flat Files, SQL, PLSQL, SQL Server,
Erwin 4.0, Unix Shell Scripting
INDIA Tata Consultancy Services, Noida, INDIA
Client: Pfizer Pharmaceuticals, Groton, CT Apr ‘05
- Oct ‘05
ETL/BI Data Tester - KPI-EU Dashboard
Pfizer is one of the world’s largest Pharmaceutical/Health Care companies with offices all over the world. The project was on
the extraction of data from Siebel and other Systems and building the common operational data store for PAH. PAH
periodically assesses and prioritizes various risk areas that may affect the company’s operations and growth. As a result, Pfizer
regularly reviews and where necessary refines the several fundamental
elements that define its Compliance Program. KPI EU Dashboard is an analytics project implemented to asses and review the
companies key performance areas such as Finance, Sales, Marketing over the EU region (Both country and EU level).
Responsibilities:
Gathering of user requirements and source system analysis and establishing mappings between source to target attributes.
•
Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
•
Involved in writing the Test Cases and Test Plans based on Informatica mappings Data Analyst mappings and BA Visio
•
diagrams.
Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
•
Developed Shell Scripts to perform pre-session and post-session operations.
•
Involved in Positive and Negative Testing.
•
Extensively involved in the Performance testing of the programs, ETL Procedures and Processes
•
Power Center 6.x, Oracle 9i, SQL, PL/SQL, Erwin 4.0, UNIX Shell Scripting
•
Tested and developed the graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
•
Validated the data flow from Source to Target tables by verifying the mappings and transformations in ETL Tool, Informatica.
•
Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts
•
Contact this candidate