Overview

A skilled professional having over 8 years of experience in:

SUMMERY

• Extensive Experience in Vendor Management System VMS applications, Banking, Insurance Operations, Telecoms Operations tools involved in customer life cycle to expert level CBS, PIE, Business Objects, Bulk Ops Tool scripting .
• Areas of Expertise: Requirement Analysis, Functional, System Integration, ETL testing, SQL testing, Regression Testing, Reports testing, Installation Testing, Diagnostic Problem Solving, Trouble shooting, Bug Tracking Report Management, Quality Assurance, Technical Analysis Support
• Excellent knowledge of Data Warehouse fundamentals like Star schema, Slowly Changing Dimensions SCDs , Historical/Incremental loads, fact/dimension, surrogate key etc.
• Worked on different layers of Datawarehouse like staging, integration and datamarts
• Perform ETL validations like count, duplicate, CDC Change Data Capture and data validation between source and target destinations
• Execute and validate ETL jobs/workflows on Datastage
• Write complex SQLs to validate the transformation and data cleansing rules defined in data mapping documents
• Excellent working knowledge on UNIX environment and unix commands
• Experience of testing on heterogeneous datawarehouse environments like Oracle, SQL Server, Teradata
• Extensive experience in Functional, UAT Black Box testing, V-method, Agile methodologies, Experience in Identifying and Creating Scenarios to Test the Application
• Experience in devising Project planning, Test plan, and Test strategy for projects.
• Experience in executing Test Cases to test the application functionality against the requirements manually through VSTS scripts.
• Good knowledge in all stages of SDLC, STLC and Defect Life Cycle.

IT SKILLS

Exposure:

• PEGA: PRPC 5.4 / 5.5 / 6.1
• Methodologies: Agile, Waterfall, V-Method
• Bug Tracking Tools: Jira, BugZilla, HP Quality Centre, Microsoft TFS, Empirix
• Technologies: Web Services, SOAP, HTML,SSRS
• Design Tools: Microsoft Visio, UML.
• PeopleSoft 8.1, Biz Talk Server

OrGANIZATIONAL EXPERIENCE

Confidential

QA consultant Consol Vendor Management System

Key Responsibilities

• Write complex SQLs to validate the transformation and data cleansing rules in Datawarehouse
• Validate data mapping, selection criteria, aggregations, sorting, lookups, transformations, data loads
• Process and validate data loads from flat files and DB tables
• Perform different ETL validations like data-data, data-file, file-file based on source and target
• Perform duplicate, count, CDC Change Data Capture data checks on source and target
• Run and validate ETL jobs in DataStage
• Design and implement SDLC policy and procedures. Conduct gap analysis of the SDLC
• SME for PeopleSoft billing Reporting Modules.
• Tested Static, Dynamic, Adhoc and Dashboard reports.
• Understanding the Functional Requirements, Test Scenarios and Test Cases.
• Participated extensively in UAT process, new implemntations through scrum calls.
• Interacted with developers on various issues relating to software defects
• Participated in Knowledge Transfer sessions.
• Preparation of Daily and Weekly Status Report
• Defect tracking and team management
• Involved in Release testing, regression testing, User Acceptance testing.
• Writing the test cases derived from the business functional and requirements.
• Involved in testing the changes CRs and usability enhancement.
• Wrote SQL Queries, procedures and triggers for validating the data integrity.
• Involved in unit testing and functional integration testing of PL/SQL programs

Environment: Microsoft Team Foundation Server, Empirix, PeopleSoft 8.1, SoapUI, Windows Vista, SQL Server 2008, SSRS, Datastage 8.5, Unix, Teradata12.0

Confidential ETL Tester CaptiaOne Creditcard

Key Responsibilities

• Played the role of Senior Software Engineer.
• Analyzed system requirements specifications
• Developed executed detailed Test plans, Test cases, test data, TSL scripts for testing the functionality, GUI.
• Performed Verification, Validation, and Transformations on the Input data before loading into target database
• Performed full load and incremental load data validations
• Application Database integrity testing by executing SQL statements on Oracle database
• Design Doc Review.
• Test Plan Creation.
• Review Test specifications.
• Installation Deployment of test environment. Execution of test cases.
• Defect Logging, linking and tracking in QC.
• Support Development team , support team and other QA teams .
• Creating WSR weekly status report .
• Creating Traceability Matrix.
• Provide Knowledge Transfer to Team members.
• Debugging Issues based on server logs.
• Entering guiding new joinees in team.

Environment: Datastage7.5, Microsoft Team Foundation Server, Windows7, JIRA, Java, J2EE, JSP, Servlets, EJB, HTML, DHTML, Web sphere, Oracle9i, UML.

Confidential Senior QA Analyst TalkTalk Telecoms

Key Responsibilities

• Understanding the functional requirements of the application
• Creating Test plans, Test cases and Test Reports
• Executing manual test cases in QC
• Executing automation scripts and providing results to all the stakeholders
• Identifying and logging the defects in Bugzilla
• Participating in Defect triage meetings and tracking the defects to closure
• Testing the daily workflow management of all the work coming into the Rejections pots across all products LLU, WLR, ADSL, CPS in SVT.
• Used SQL Assistant tool to connect to Teradata database to validate data that was populated by ETL applications

Environment: Ascential Datastage 7.5, Siebel, TBS, Bugzilla, PeopleSoft 8.1, SoapUI, Windows XP, Business Objects, QC, Teradata.