Data Test Cases
Resume:
Pravin Mane
Charlotte, NC
*******@*****.***
Professional Outline
Having 11 years of experience as an IT professional with a diversified experience in the areas of software quality assurance with 5+ Years of experience in ETL- DWBI Testing, Database Testing
Experience in Major tool like IBM DataStage, Oracle data Integrator(ODI) and SSIS.
Worked extensively with ETL Process (Extraction, Transformation and Loading of data) from Multiple Sources to Data Warehouse.
Manage end to end testing work for the DW application and lead the test team of
5 members to assign activity/tasks/deliverables.
Experience in Web testing, Client/Server testing and Backend/Database Testing.
Experience in Functional Testing, Regression Testing, Database Testing, System testing and User Acceptance Testing
Coordinated in creation and execution testing processes, test strategies and test plans.
Analyze and understand testing requirements from business requirement document, technical
requirement specs.
Experienced in Bug Cycle and Reporting Defects in tracking tool like RQM, JIRA and QC.
Extensive experience in Design, Review and Execution of Test Cases, Test Plans.
Worked closely with developers and QA Analysts to completeness of the developed software
Good understanding of Software Development Life Cycle (SDLC),STLC using Agile Model.
Extensive experience in executing SQL queries in Oracle and SQL server to validate data.
Understanding test specifications like Business Requirement Specifications, System design and Technical specification.
Functional Knowledge and experience in Banking and Finance domains.
Expertise using Microsoft office suite products like Word, Excel etc.
Highly self-motivated team player with excellent analytical, problem solving, quick learning, interpersonal and communication skills.
Technical Skills:
Operating Systems : Windows 2000/XP, Unix
Databases : SQL Server,DB2 and Oracle
Testing Tool : RQM, Bugzilla, JIRA, Quality Center 10
ETL Tool : ODI(Oracle data Integrator),SSIS and IBM DataStage.
Reporting/ BI Tools : ACTUATE, COGNOS, Oracle Report Generator.
Testing Platform : Functional Testing, Web testing,Database, and ETL Testing.
Experience Profile:
QA Lead - Quality
Wells Fargo, Charlotte
Dec 2014- March 2017
Wells Fargo is an American international banking and financial services holding company,who serve more than 50 million customers and it is one of the premier providers of end-to-end Opening Accounts, Mortgages and Whole sales. Operational risk management System (OPSRISK) which has the operational data coming from different sources via Archer and move to data warehouse layers (Stage, Presentation,History).
which identified the risks and management can take steps to reduce risks to an acceptable level and maintain the level of risks. The bank is using ARCHER framework for their risk management system.
Responsibilities:
Analyze and understand testing requirements from business requirement document, technical
requirement specs like Data Transformation logic and Data Mapping Document.
Design the Test Cases after analyzing Data Transformation logic and Data mapping sheet.
Preparation of Comparison Scripts to compare the Schema/Data between Source and Target tables.
Performed End to End ETL testing including Data completeness, Data transformation, Incremental load, Data Quality, Regression testing.
Complete Data Validation like the target database checks such as record counts, mandatory key fields, validation of CDC Updates, Validation for Null/Not Null Fields, schema Validation, Duplicates checks and referential integrity Validation for DB Tables.
Validating the transformation logic by performing checks such as business check, derived field check, surrogate key check
Carrying Out Regression Testing if any Design Changes/Uplift in the tables.
Carry out testing in different Environment like IQA and PreProd Env.
Identifying Defects and Tracking Defects in QC.
Follow up with the Development team and to make sure that those defects are Fixed asap.
Attending Scrum Call and Co-ordinate with the ETL Developers, DBA and product owner to implement the Proper requirements.
Agile Model Implementation.
Assist entry-level tester(s) on reviewing requirement, preparing and executing test cases, and report software defects
QA Lead -Quality
AQR Capital Management, Greenwich, CT Jun 2014 -Nov 2014
AQR is leading provider of alternative investments as well as a broad spectrum of long-only funds. It focuses on Asset management, investment and hedging the funds.
AQR Headquarters in Greenwich, CT; offices also located in Chicago, London and Sydney.
The AQR BI/Data Warehouse Solution addresses the reporting and data warehouse needs of AQR transformation project and is envisioned as a multi-phase initiative that will cover a number of subject areas within the organization and use the current source system for the data warehouse
Responsibilities:
Analyze the Data Transformation logic and Data Mapping Document.
Design the Test Cases after analyzing Data Transformation logic and Data mapping sheet.
Performed End-2-End ETL testing including Data completeness, Data transformation, Incremental load, Data Quality, Regression testing.
Prepared the Comparison Scripts to compare the data between Source and Data Warehouses.
Complete Data Validation like Initial Load validation, Compare Script, Trace back SK keys to
source and CDC Updates, Validation for Null/Not Null Fields, schema Validation and Duplicates Validation of DW tables, DIM and Fact Tables.
Carrying Out Regression Testing if any Design Changes/Uplift in the table requirement.
Carry out testing in different Environment like QA and PreProd Env.
Identifying Defects and Tracking Defects in a JIRA.
Follow up with the Development team and to make sure that those defects are Fixed asap.
Attending Scrum Call and Co-ordinate with the ETL Developers, DBA to implement the Proper requirements.
Sr. Team Member
Enbridge, North America Mar 13-Apr 2014
Enbridge operates mainly in Canada and Northen America.So the primary focus of the project is to modernization of technologies and new capability.
BI/Data Warehouse (Pipelink BIDW) Solution addresses the reporting and data warehouse needs of Enbridge’s Pipelink Transformation project and is envisioned as a multi-phase initiative that will cover a number of subject areas within the organization and use the newly developed Pipelink system (CSID) as the current source system for the data warehouse.
Responsibilities:
Understanding the Data Transformation logic and Data Mapping Document.
Design the Test Cases after analyzing Data Transformation logic and Data mapping sheet.
End to End Testing of Data Flow from Source to Data warehouses and then to Data marts.
Preparation Of Comparison Scripts to compare the data between Source and Data Warehouses.
Complete Data Validation like Initial Load validation, Compare Script, Trace back SK keys to source, CDC Updates, Validation for Null/Not Null Fields, column Testing and Duplicates Validated etc of DW tables, DIM and Fact Tables.
Carrying Out Regression Testing if any Design Changes/Uplift in the tables.
Carry out testing in different Environment like PreCAT and CAT.
Identifying Defects and Tracking Defects in RQM.
Follow up with the Development team and to make sure that those defects are Fixed asap.
Attending Scrum Call and Co-ordinate with the ETL Developers, DBA and Onsite Lead to implement the Proper requirements.
Participated in Walkthrough and defect report meetings periodically
Test Analyst
AMEX -American Express,USA Dec 2011 - Mar 2013
AMEX is one of the largest US headquartered commercial bank holding companies that offers personal, business and commercial banking services. The quality of customers experience is a critical success in the banking industry. The bank opted to move to SMART (Self Managed Analytic and Reporting Tool),Which is a self-service Web based Tool that provides the convenient access to some of the most common requested reports .
SMART enables to Merchant Services teams to take advantage of Closed-Loop network and provide unique value to merchant customers. SMART generates customized reports
SMART reports can be used to help the merchants:
Create powerful business intelligence and strategies through an enhanced understanding of customer buying patterns and spending trends.
Measure marketing effectiveness through reporting on performance of American Express marketing campaigns and promotions.
Responsibilities:
As a part of testing team, Understanding the functionality of the project. Analyzing the functional and system requirements.
Involved in BI Testing
Writing, updating and executing Test Scripts as per Functional Specifications.
Responsible for System, UI, Regression Testing and UAT Testing.
Database Testing, checking log file and Support at UAT Level.
Co-ordinate with the Developers, DBA and Onshore Lead to implement the Proper Functional requirements
Created Documents, this includes the Test Summary Results, Risk Assess and Testing Signoff
Involved in writing Positive and Negative Test cases and executed them
Executed SQL Queries for setting up Test data
Involved in Report testing and expertise in creating test scenarios & functionality testing and building test scenarios to handle Look & feel testing
Participated in Walkthrough and defect report meetings periodically
Test Analyst
Nationwide Bank (NBS), UK Oct 2010 - Dec 2011
Nationwide Bank is one of the largest UK headquartered commercial bank holding companies that offers personal, business and commercial banking services. The quality of customers experience is a critical success in the banking industry. The bank opted to move to SLFI (Strategic Loan Fulfillment Initiative), which is to automate the Fulfillment process of the personal loan which involves, proof realization and recording till fund issue. This would reduce the chance of missed sales opportunities, due to length and manual Fulfillment process.
With the help of this application gives a better user experience and enhance reliability. Enabling flexibility to amend personal loan documentation and automate the chasing of information/confirmation requested from customers through email and text (SMS).
Responsibilities:
Analyzing functional requirement, creating test plan, Test Execution Plan and distributes the task among Team Member
Understanding the test requirements, test script design based on the provided requirements, Test case Execution and Maintain Defects in QC
Test data Preparation and Key-in the application ID for Execution.
Verify the Retrieving Data through SQL Queries (DB2 database)
Participated in Walkthrough and defect report meetings periodically
Test Analyst
Deutsche Bank,UK Jan 2010 - Oct 2010
Deutsche Bank is one of the largest investment banking. Credit Risk Development-CRD Project was purely involved on of Trade settlement process on Every EOD.
Responsibilities:
Understanding the test requirements, test script design based on requirements
Performed Functional and Regression testing and System Testing.
Defect reporting and tracking process helped the development team to identify the weak areas in design and implementation to ensure overall Product quality
Task Allocation, Defect reporting and Tracking
Verify and Validate the Retrieving Data through SQL Queries
Daily status calls with onsite on the progress/reviews/clarifications required for the project
Effective communication to all stake holders for any upcoming changes into environments
Actively participate in release coordination and communication to stakeholders
Test Analyst
EBZ Online, India Mar 2008 – Dec 2009
EBZ Online is Banking Solution provider and Debit Card Transactions for Banks. It is a Financial and product base Application. It offers Debit Card Management Solution (DCMS) on 24/7 Environment, activation of cards, transaction processing, Apply the fees and charges, and other critical management of debit cards.
Responsibilities:
As a part of testing team, involved in testing phases like SRS Analysis, Test scripts preparation.
Prioritizing the Test scripts for regression testing.
Writing, updating and executing Test Scripts as per Functional Specifications.
Responsible for Functional Testing, System and Regression Testing.
Defects Logging and Tracking.
Responsible for Weekly Status Report.
Source Updates using Concurrent Versions System-(CVS).
Verify the Retrieving Data Through SQL Queries (Oracle 8i).
Prepared KT documents for new resources in Team.
Test Analyst
EBZ Online, India July 2007 – Mar 2008
BankEasy –Core Banking Solution is a Product base banking application which is a single-point contact for all banking requirements. This system captures all banking activities of Daily transactions like Cash Withdrawal, Cash Deposit, fund transfer, Cheque-book Issue, Inward Clearing,Cheque-Stop Payment, Revoke Stop Payment, Standing Instruction (S.I.) Open and Close, GL & Account maintenance, Account Creation & Closing, Minimum Balance Charges, Card Blocking & Reissue-Card, Home Branch Change and Stationary Maintenance.
Oracle Report Testing: Reports are generated through Oracle Report Generator and testing of various Reports, Reports like Statement of particular A/c, In-Active and Active Card Report, Daily Transaction Report, Inventory Stationary Stock,S.I. Report and New A/c Welcome Report etc.
Responsibilities:
Involved in entire QA Life Cycle which includes Test Designing and Execution of the entire QA process and documentation of Test Cases.
Performed Functional and Regression testing and System Testing. Through testing, defect reporting and tracking process helped the development team to identify the weak areas in design and implementation, thus ensured overall product quality
Created and Reviewed Test case with confirmation of completeness
Maintained changes in Test Case document after every round of Testing
Defect Tracking and reporting
Verify the Retrieving Data through SQL Queries.
Contact this candidate