PROFESSIONAL SUMMARY:

• Over 11 years of progressive and broad based experience in IT industry which included 7 years of Quality Assurance Software Testing on Web based and mobile applications for clients in Banking, Insurance, Telecom and Healthcare industries excludes 4 years of development of Siebel CRM, Salesforce, PeopleSoft, SAP - SD, MM modules, Mainframes, OBIEE application and ETL Testing.
• 6 years of ETL Testing and extensive knowledge of Data warehousing schemas and structures.
• Extensive experience in creating Test plans, Test scenarios, Test cases, Use case, Test reports and other documentation on Manual & Automated and for Mobile applications testing.
• Experience with Python language
• Thorough knowledge of all phases and various methodologies of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC).
• Proficient in Sanity/Smoke, System, Functional, Integration, End to End, GUI, Black Box, Performance (basics) and User acceptance testing (UAT) .
• Extensive practical experience in using Quality Center (HPQC) for test management and defect tracking and JIRA for bug reporting purposes .
• Good Understanding of software modeling techniques and software testing techniques
• Demonstrated strong analytical and problem solving skills, strong communication and interpersonal skills.
• Able to work in multiple projects with competing priorities and tight deadlines.
• Extensive experience in working in agile development environment.
• Experience with VSTS, TFS, Jira, Mecury and HPALM tools
• 5 years of Business Intelligence Development experience with OBIEE, Tableau Microstrategy along with Siebel CRM/ERP systems
• Experience with Sales, Marketing, Government, Loyalty, Telecom, Banking, NBFC and Energy Industries
• Valid Canadian Reliable Security Clearance Valid until September 2027

TECHNICAL SKILLS:

Programming Languages: C++,Java, data structures,Python.

Testing Tools: Mercury Quality Center, Hp Quality Control, Bugzill, JIRA, TFS, VSTS

Scripting Languages: VB Script, JavaScript

Relational Databases: SQL Server 2005/2008, My SQL, Oracle, DB2

Web Services: HTTP, XML, TCP/IP, UDP

Operating Systems: Windows 2000, 2003, 2008, Vista, Windows 7, LINUX.

Microsoft Suite: MS Office - Word, Excel, Power Point, Outlook.

Applications: Siebel CRM, Peoplesoft HRMS, Oracle ebiz and Finacials, Mainframes and Salesforce

ETL Tools: Informatical v9.1, Data stage, Oracle Data Integrator

Reporting Tools: OBIEE, Tableau, Micro strategy, Cognos

WORK EXPERIENCE:

Confidential

ETL Tester

Environment: OAC, BICS, ODI, TFS, Jira

Responsibilities:

• Worked on Source and Target database testing and data validation between source and target Worked on the ETL mapping testing
• Involved in ETL Source Testing while loading the data into the Staging Area for Data warehouse
• Writing queries in SQL to prepare the test cases for Data validation
• Preparing the test plans and queries for validating Data stage Transformations
• Involved in Data performance testing once the data loaded to the staging area
• Validate the data between Source and Target Applications.
• Testing Insurance application with Data extracts from Insurance application
• Testing insurance application data flow and reports functionality
• Testing the sql queries to validate the data prepare the SQL queries
• Prepare the Test Traceability matrix to prepare the testing objectives from end to end
• Responsible for logging and updatingDefect StatusinTFS
• Testing the Cognos reports to validate the target data
• PerformedRegressiontesting on bug fixes.
• Responsible for preparingTraceability Matrixreport.
• Responsible forUAT Metricsreports.

Confidential

ETL Tester, Ottawa

Environment: Datastage, SAS, Bigdata, HIVE, Jira, TFS, VSTS

Responsibilities:

• Involved in ETL Source Testing while loading the data into the Staging Area for Data warehouse
• Writing queries in SQL to prepare the test cases for Data validation
• Preparing the test plans and queries for validating Data stage Transformations
• Involved in Data performance testing once the data loaded to the staging area
• Validate the data between Source and Target Applications.
• Testing Insurance application with Data extracts from Insurance application
• Testing insurance application data flow and reports functionality
• Testing the sql queries to validate the data prepare the SQL queries
• Prepare the Test Traceability matrix to prepare the testing objectives from end to end
• Responsible for logging and updatingDefect StatusinTFS
• Testing the Cognos reports to validate the target data
• PerformedRegressiontesting on bug fixes.
• Responsible for preparingTraceability Matrixreport.
• Responsible forUAT Metricsreports.
• Responsible for updatingTestCompletion Matrix reportsto monitor testing progress.
• Responsible for testing data integration into Salesforce apps.
• Involved in ETL Source Testing while loading the data into the Staging Area for Data warehouse
• Writing queries in SQL to prepare the test cases for Data validation
• Preparing the test plans and queries for validating Data stage Transformations
• Involved in Data performance testing once the data loaded to the staging area
• Validate the data between Source and Target Applications.
• Testing Insurance application with Data extracts from Insurance application
• Testing insurance application data flow and reports functionality
• Testing the sql queries to validate the data prepare the SQL queries
• Prepare the Test Traceability matrix to prepare the testing objectives from end to end
• Responsible for logging and updatingDefect StatusinTFS
• Experienced in Data Validation and Backend testing of databases to check the integrity of data.
• And also used extensively HQL Queries to analyze the HDFS data

Confidential

QA Analyst

Environment: OBIEE 12c, Oracle 12c, Oracle 11g, ODI 12c,, HP Quality center 12.0,Jira, mercury quality centre, Mainframe Apps

Responsibilities:

• Worked on Source and Target database comparison testing and data validation between source and target
• Worked on ODI load performance testing to the target database
• Worked on the ETL mapping testing
• Involved in ETL Source Testing while loading the data into the Staging Area for Data warehouse
• Writing queries in SQL to prepare the test cases for Data validation
• Preparing the test plans and queries for validating Informatical Transformations
• Involved in Data performance testing once the data loaded to the staging area
• Validate the data between Source and Target Applications.
• Testing Siebel Application and OBIEE Reporting application for OPS application
• Testing OBIEE Reports and dashboards functionality
• Testing the sql queries to validate the data prepare the SQL queries
• Prepare the Test Traceability matrix to prepare the testing objectives from end to end
• Responsible for logging and updatingDefect StatusinMercury Quality Center.
• PerformedRegressiontesting on bug fixes.
• Responsible for preparingTraceability Matrixreport.
• Responsible forUAT Metricsreports.
• Responsible for updatingTestCompletion Matrix reportsto monitor testing progress.

Confidential

QA TESTER, Toronto

Environment: Siebel Financial Application, Siebel Application Server, Oracle 11g, Informatica v9.1, OBIEE 11.1.1.7.1.0

Responsibilities:

• Worked on Correspondence, Accounts, Contacts, Funds, Investors, Events and Referrals modules.
• This project deals with the visibility of data and customization of UI primarily through configuration.
• Working on restricting the Bank of America different users data access to the Prime Brokerages.
• Job Responsibilities include requirement analysis of business operations from client.
• Development of system, user acceptance, unit testing, implementation.
• Testing of whole application by using written test cases.
• Worked as a QA Professional and in the Manual Testing and automation - testing phase of the Application.
• Expertise in using Quick Test Professional (QTP) for regression and functional testing
• Tested the application extensively and made enhancements by incorporating client suggested modifications.
• Performed Integration Testing and Functional Testing.
• Responsible for writing the test plan.
• Extend the columns on base tables as per the Business requirement.
• Modified the eScript to send Email notifications to the user or whoever logged in.
• Created and configured email profiles and All Response Groups for email response for different email ids. Adding the message categories to the Catalogs and created the access groups for the catalogs.
• Created custom Business Service to pass the parameters needed for workflow while sending emails once the Order is pushed to the Lawson application.
• Loaded the Accounts and Address data using EIM Process.
• Involved in ETL Source Testing while loading the data into the Staging Area for Datawarehouse
• Writing queries in SQL to prepare the test cases for Data validation
• Preparing the test plans and queries for validating Informatical Transformations
• Involved in Data performance testing once the data loaded to the staging area
• Validate the data between Source and Target Applications.
• Responsible for logging and updatingDefect StatusinMercury Quality Center.
• PerformedRegressiontesting on bug fixes.
• Responsible for preparingTraceability Matrixreport.
• Responsible forUAT Metricsreports.
• Responsible for updatingTestCompletion Matrix reportsto monitor testing progress.

Confidential

ETL Tester

Environment: Informatica 9.1, HP Quality center 12.0

Responsibilities:

• Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
• Prepared Test Strategy document, System Test Plan, Performance Test Plan, Unit Test plan, Traceability matrix and Test Summary Reports.
• Involved in creating the UAT test scenarios and worked with the business users to execute the UAT test scenarios.
• Validated the most granular data items against OLTP systems and identified the source tables from which the data warehouse extracts data.
• Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.
• Tracked defects through quality Centre.
• Involved in preparing the Mock test data for both positive and negative scenarios.
• Extensively tested several BOXI reports for data quality
• Manual verification of data in the backend using SQL.
• Maintained the Requirement Traceability Matrices (RTM) to track the coverage of Requirements v/s designed test cases.
• Testing ETL transformations, source and target databases, verifying the Transformations and pre sql - post sql logics in the Informatica designer, Data validations and comparisons prior to create the defects/bugs in the Defect tracking tool
• Testing various web-based content Management system used for reporting application deployed into general and mobile based applications for the business team
• Test on the browsers and platforms your site visitors use
• Test on various monitors and screens (for example, LCD and CRT)
• View pages using different screen resolutions
• View pages using different color settings
• Test all navigation and links
• Test items that can be downloaded (for example, PDF files)
• Test the search functionality
• Test site security
• Test the Financial applications site to ensure that all pages display correctly, links go to the specified address, and images are not broken.

Confidential

QA Tester

Responsibilities:

• Involved in gathering and understanding Project Scope, Project Plan, Business and Functional Requirement documents required for documenting the Master Test Plan
• Created detailed Test Scenarios and developed reusable frameworks for test plans
• Responsible for testing the application with mostly Manual and partly Automated strategies
• Involved in creating test Plans based on functional specifications and user requirements
• Involved in creating test case scenarios for System and Regression testing
• Executed test cases, verified results and reported results in defect manager of Quality Center
• Responsible for performing Functional, Integration and Performance Testing
• Used Quality Center for requirement management, planning, scheduling, running tests, issue management and project status analysis
• Implemented Defect Management and worked with all the four modules of Quality Center
• Analysis of application related issues logged by clients and Re - test the functionality on receiving the fixes from the Development Team in Quality Center
• Participate in data gathering and identifying the gaps in the new developments
• Maintained automated scripts for Regression and Stress Testing using Win runner
• Involved in capturing events and Played back scripts using QTP
• Involved in testing OBIEE RPD, SQL for data migration from source to target, dashboards, reports and answers
• Involved in data validation using sql queries for source and target
• Extensive knowledge on snowflake and star schemas along with Data warehousing concepts.
• Testing ETL transformations, source and target databases, verifying the Transformations and pre sql - post sql logics in the Informatica designer, Data validations and comparisons prior to create the defects/bugs in the Defect tracking tool

Environment: Windows XP, Java, Win Runner 8.0, QTP and Quality center, SQL server SSIS (2005), SQL server SSRS (2005),Teradata V2R6

Confidential

Software Quality Assurance Tester

Responsibilities:

• As Siebel tester responsible for understanding and analyzing the functional processes and businesss cenarios.
• PerformedSystem Integration testingto verify the interaction between the Siebel system and the documentum Firstdoc system. This essentially involved triggering a request for the response items stored in the Firstdoc system and verifying the resulting response items displayed in the‘Find Response’ interface screenof the Siebel system.
• Verified themappingof the fields on the ‘Find Response’ interface screen in Siebel system with the fields displayed on each of the response components in the documentum Firstdoc system.
• Developed and executed scripts to testTask Based User Interface (TBUI)functionality of TRECnet application. This functionality involved searching an external database system called ‘TARGUS’ based on requester’s ‘Last Name’ or ‘Main Phone Number’.
• PerformedGUItesting of Siebel application upon upgradation from Siebel v7.8 to v8.0.This involved testing the data displayed, testing the layouts of the screens and views and also entities likePickapplets,MVGapplets,Static Picklists.
• DevelopedSystemtest scripts based on theFRSandSRDdocuments.
• Performedsmoketest on the new builds deployed in the test environment.
• Responsible forUATplanning and creatingUATscripts.
• Responsible for conductingPre-UATsessions for thebusinessusers to familiarize them with the application, its important functionality andbusinessprocesses.
• Configuredtemplatesin documentum Firstdoc system for verifying renditions of the responses in rtf, pdf and web formats.
• PerformedFunctionaltests formulti-lingualresponse package layouts for Americas and EMEA countries based on the rules specified in theStyle Guide.
• PerformedRegressiontests for testing customizations to theArbortext editorthrough the creation of response components such asLocalized Cover Page,Introductions,ProductIndications,Standard Body (ies), Files,Appendices,DisclaimerandClosings.
• Carried outPerformancetests to verify the response time of the system to load views.
• Exported scripts from MS word document into the Test Plan Module ofMercury Quality Centerusing macros.
• Interacted with developers to ensure early resolution of defects.
• Responsible for logging and updatingDefect StatusinMercury Quality Center.
• PerformedRegressiontesting on bug fixes.
• Responsible for preparingTraceability Matrixreport.
• Responsible forUAT Metricsreports.
• Responsible for updatingTestCompletion Matrix reportsto monitor testing progress.

Environment: OBIEE 11g, Mercury Quality Center 9, Peoplesoft HRMS, Informatica and Siebel systems