Data Test
Resume:
Amgen Inc, Thousand Oaks, CA
QA Analyst
EDW: The Enterprise Data Warehouse holds data extracted from SAP,
EDH, PARIS and the Shared Repository. These data feeds are extracted
from the source systems using ETL tool and loaded into a staging
area in EDW. The subject areas covered by the scope of Release of
the EDW program include Finance, Global Strategic Sourcing,
Operations, and Human Resources. The Objective of the testing is to
find Software defects in the EDW life cycle to ensure and maintain
subject oriented, non volatile collection of EDW Tables.
Golden Gate: Golden Gate (Replication) Services (GGS) is a software
product that performs replication of data from one table to another
table that is, typically, hosted on another Teradata database.
Replication of the Enterprise Data Warehouse (EDW) tables involves
capturing the data transaction applied to the table in US core
database and applying the same data transaction to its counterpart
table in the EU database. The main aim of this project is to
leverage time between the US core database and the EU database to
get the access for the updated data at similar time.
Responsibilities:
Involved in preparation of Test plans, Created test cases and
responsible for executing the Test Scripts.
Coordinate all Testing for Back End and Front End.
Working with the end users to create user acceptance test strategies
and test scenarios to verify that the system performs the business
functions as required.
Owned the creation and ongoing maintenance of test process
documentation and test plans
Worked with the development team to create a suite of test data
(both input files and expected results) that fully exercises data
validation (detecting and rejecting bad data) and actual ETL
(Informatica) functionality (properly processing good data, i.e.,
transformations, calculations, and derivations)
Managed the ETL build validation process on an ongoing basis
Created reports for Validation activities.
Responsible for the validation of any additions/modifications to the
Business Objects reports before release to production. Validating
fields present in the reports are as agreed in the specifications.
Created Test Strategy that included Estimation, requirement
Analysis, Resource Planning, Test Planning, Execution, and Results.
Wrote SQL queries for backend testing.
Identified and logged defects using Quality center.
Owned the overall defect tracking process, by which defects are
prioritized and scheduled for resolution, including preparation of
reports that summarize overall project status for review by the
team.
Participated in stress testing activities, in collaboration with the
development and production teams, to ensure satisfactory performance
of both ETL processing and end-user reporting.
Environment: Quality Center 10.0, Oracle 9i, TOAD, XML, Teradata,
Informatica, Business objects, Loadrunner, MS-Office, MS-Visio.
Verizon, Tampa, FL
Feb 04-Jul 05
QA Tester
Verizon is the largest provider of local and long distance telephone
services in the United States, and also sells digital subscriber line
Internet access and digital television service.
RESPONSIBILITIES
. Prepared detailed Test Plan by understanding the business logic & user
requirements.
. Analyzed the Business Needs, Use Case and Functional Requirements for
the Application.
. Involved in writing and execution of test cases and interaction with
the development team to report and correct errors for every Version
release.
. Extensively communicated and guided the customer in software
installation for Home or Business.
. Build and manage the overall test process, according to the agile
methodology.
. Participated in Formal Reviews and walkthrough for preparing test
cases.
. Conducted the Functional, System, Integration, End to End,
Performance, Regression, User acceptance (UAT) and implementation
testing on the web application.
. Worked on problem solving and necessary specifications of the
hardware, software and data resources for the software installation.
. Identified and Reported Defects by classifying them based on severity
and priority
. Performed Security, System, UAT and Regression Testing.
. Used SQL queries to perform back-end testing of the database.
Environment: Windows 2003, QC 10.0, VSAM, OS/390, TSO/ISPF, CICS, DB2,
Oracle9i, Toad, MS Access, Perl.
EDUCATION
Bachelor of Engineering, Osmania University, India
. Over 7 years of IT experience with more than six years of both manual and
automated testing experience in various domains like Insurance, Retail,
Healthcare, Telecom.
. Analysis and Documentation of Web Based and Client/Server applications.
. Experience in planning, designing, developing and deploying testing
strategies for large-scale Web applications and Client/Server systems.
. Experience in analyzing technical/business specifications, reviewing
documentation and intensively monitoring the data flow in the
Client/Server environment.
. Proficient in writing test plans for the functional and system testing,
execution of test cases to verify actual results against expected
results.
. Highly proficient in working with automated testing tools like Mercury
Interactive Test Suite (Quality Center 9.0, Test Director).
. Extensive experience in System Testing, User Acceptance testing (UAT),
Black Box Testing, White Box Testing, Integration Testing, Positive
Testing and Negative Testing.
. Strong working experience in validating DSS (Decision Support Systems)
applications, and Extraction, Transformation and Load (ETL) of data from
Legacy systems using Informatica and Data Stage.
. Good experience in Cognos, Business Objects reports testing.
. Excellent in developing system test plans, test strategy, test cases,
test data, test checklists, defect tracking & reporting, preparing test
summary report, and conducting status meetings.
. Strong skills in back end testing using SQL queries, generating reports
to ensure data integrity and in validating business rules.
. Extensive knowledge in various stages of Software Development Life Cycle
(SDLC) and Project Management Methodologies.
. Strong knowledge in databases Oracle, SQL Server, DB2.
TECHNICAL SKILLS
Operating Systems MS-DOS, Windows 98/NT/00/XP/VISTA/WINDOWS7
Languages C/C++, JAVA, JSP, XML, HTML, SQL Plus, TSL
Databases DB2,Oracle 7i /8i/9i,SQL Server 2000,MS-Access
GUI Visual Basic6.0, VB .Net, JSP, ASP
Testing Tools Quality Center, WinRunner
Version Control Visual Source Safe
Browsers Netscape Navigator and Internet Explorer
Other Skills Visio 2003,MS Excel, Crystal Reports
EXPERIENCE SUMMARY
Erie Insurance, Erie, PA
Sep08- current
QA analyst & BI tester
Erie Insurance is a P&C Insurance company Located in Erie, PA. Goal of this
project is to move claim and policy information from PMS (Policy Management
System) to a warehouse built on DB2 and to provide BI reports using Cognos
reporting.
Responsibilities
. Responsible for developing test plans and test scripts for testing the
entire Data warehouse.
. Involved in writing new test scripts and modifying existing test
scripts stored in Quality Center.
. Logged defects/Issues encountered during testing using Quality Center
. Prepared test data and test procedures to test the business logic
using mapping documents.
. Analyzed system requirements and functional requirement documents to
prepare test cases and test data.
. Performed different types of tests such as Integration Tests,
Regression Tests and User Interface Tests.
. Analyzed production data to prepare test data.
. Performed white box and user acceptance testing.
. Created SQL queries for back end testing
. Interacted with control buyers to understand and test the business
specifications.
. Involved in all phases of SDLC to ensure proper quality of the system.
. Created test scenarios to test the Data populated into the warehouse.
. Good knowledge of PMS mainframe screens.
. Validated Warehouse for Row Counts, Scenarios and at element level.
. Validated Cognos reports generated for Agency Claim Ratios.
Environment: Informatica Power Center 8.1 (ETL), MVS, COBOL, Quality
Center, DB2 V9.1/9.5, SQL Server 2005, Windows 2000/2003, HP-Unix, Cognos
8X, Policy Management, System (PMS).
Payless Shoe Source, Topeka, Kansas
Mar 07- Jul 08
ETL Tester
Payless Shoe Source is a discount footwear retailer company. An integrated
data warehouse that consolidates sales information from several different
customer-facing channels, providing managers with real-time access to vital
sales information-allowing them to quickly analyze customer purchasing
patterns. This analysis paves the way for creating comprehensive sales
plans and forecasts that enable Payless to stock the most desirable items
for its customers. The new system automates the process of combining sales
data from its legacy merchandising systems-something that was done manually
in the past, when product managers had to query each data repository
separately and then aggregate the data themselves.
RESPONSIBILITIES
. Validated different interfaces from source to target.
. Created test cases, test plan and test Scenarios to validate data from
Jesta.
. Validates business objects reports created from EDW.
. Performed all aspects of verification, validation including
functional, structural, regression, load and system testing
. Prepared Test Data and scripts for UAT Testing
. Experience in data analysis and data testing and verified fields
present in the reports are as agreed in the ETL specifications
. Study of detailed requirement of end users of system & their
expectations from Applications
. Hands on experience in loading from various data sources like
Teradata, Fixed Width and Delimited Flat Files.
. Involved in testing the Cognos reports by writing complex SQL queries.
. Studied and understood the Data warehouses, and functionally analyzed
the application domains, involved in various knowledge transfers from
dependent teams understand the business activities and application
programs and document the understandings for internal team
referencing.
. Prepared the test plans and test cases for different functionalities
involved in the application.
. Used Quality Center as the test management tool for the maintenance of
the test cases and to track the defects.
. Conducted the Functional, System, Integration, Ad Hoc testing, End to
End, Performance, Regression, User acceptance (UAT) and implementation
testing on the web application
. Submitted Status and Test Evaluation Reports to Project Lead on daily
basis and Constantly updated test deliverables
Environment: Informatica, UNIX, Business Objects, JESTA, Oracle, SQL
Developer, TeraData.
Contact this candidate