SUMMARY

• Having 10+ years of IT experience inQAtesting with extensiveETL, BI, Data Warehousing, Web based, Client/server, Web Service, Middleware as Sr.QA Analyst/Lead and 2+ Years of Sr.Software Developer in the domains of Finance, Insurance, Banking, Brokerage, Retail (POS), Health Care and Provincial/Federal government services.
• Successfully worked on complex testing using best QA processes like Agile & Waterfall and very well acquainted with all phases of Software Development Life Cycle (SDLC) and STLC.
• Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Validation, Data Mapping, Data Transformation applying business rules and Data Loading (ETL).
• Good knowledge and working experience in Data Warehouse concepts of Dimensional Modeling (Star Schema), ETL (Extract, Transform, Load) testing using Informatica8.1/7.1 (Power Center/ Power Mart, Designer), and SAP BODS point of QA.
• Extensive experience in testing reports using SAP BOBJ Reports tools (Crystal Reports, Webi Reports, Dashboard reports) using BI Lunch Pad and Cognos Reporting tools (Report Studio, Analysis studio).
• Experienced both Manual and Automated testing for n - tire applications, ERP, GUI and Web-based applications using tools of Mercury / HP Interactive Tools (Win Runner, Test Director, Quality Center, and LoadRunner).
• My expertise lies in creating Traceability Matrix, comprehensive Test Plans, Test Strategies, Test Cases and Executing Test Cases from Business requirements (BRD), System requirement specifications (SRS) and System Design Specifications (SDS).
• Strong experience in performing Functional, Integration, Regression, UAT, White Box, Grey box, Black Box, Load/ Stress/Performance, GUI, Infrastructure, Browser compatibility and Data Migration testing.
• Experienced in integrating four Quality Management modules - Requirements Management, Test Plan, Test Lab, and Defects Management using TestDirector/Quality Center.
• Experienced in problem solving and Defect Tracking Reports using defect tracking Tools like Test Director, Quality Center, ClearQuest and Bugzilla.
• Experienced in testing and configuration of the COTS application based on IBM Cúram Platform.
• Well versed with RDBMS both SQL Server and Oracle concepts and hands on experience with writing complex T-SQL, PL/SQL queries with/without using the client tools TOAD, SQL Management Studio.
• Establish highly effective communication with the Release Manager, Delivery Manager, and the Business / IT stake holders to coordinate test requirements, scenarios and project schedules.

TECHNICAL SKILLS

ETL TOOLS: Informatica8.1/7.1 (Power Center/ Power Mart, Designer).SAP BODS

Reporting Tools: SAP BOBJ TOOLS (Crystal Reports, Webi, Dashboard and Explorer) Cognos Reporting Tools (Report Studio, Query Studio)

TESTING TOOLS: HPQC, QTP, WinRunner, LoadRunner, Silk Test, Selenium, NeoLoad

BUG TRACKING TOOLS: HP QC, Test Director, Microsoft TFS, JIRA, IBM Clearquest

Scripting: Shell Script, VB/Java Script, CGI, PHP, HTML, XML, SOAP

Programing languages: C, Java, C#, ASP, VB.NET.

Middleware: MQ Series, BizTalk, Web Methods, Websphere, Weblogic

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 2008/2005.. , MS Access 2007 MYSQL, TOAD, T-SQL, PL/SQL

CERTIFICATION:

• Master’s Degree in Computer ApplicationApr’ 2001.
• Bachelor Degree of ScienceMay’ 1998.
• MCSE Certified 2004
• CCNA Certified 2004

PROFESSIONAL EXPERIENCE

Confidential, North York

Sr.ETL QA Analyst

Responsibilities:

• Involved in Business requirements, System requirement analysis and Design of the Data warehouse application and Data Analysis primarily Identifying Data Sets, Data source, InfoCubes, Tables, Data definitions, Data formats and Transformation business rules in Agile project environment.
• Created transformation of business rules into test scenarios, test cases using design documents like Business requirement documents (BRD) and System requirement documents (SRS).
• Tested Complex ETL Mappings based on Business requirements and business rules to load data from legacy source flat files and RDBMS tables to target tables.
• Validated the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the business rules with in the transformation.
• Developed and documented data Mappings/Transformations, and Informatica sessions as per the business requirement. Involved in the development of Informatica Mappings and also tuned them for better performance.
• Verified data integrity check on the tables for Primary Key and Foreign Key relationship.
• Performed data validation of duplicate data is not loaded, NULL value fields and record count match.
• Verified that all field data is loaded without any truncation and rejected data with proper error logs.
• Analyzed and Tested all WM reports and Labor Management reports like detailed drill down reports and visualization reports like dashboards and chats to ensure that client data and report outputs are in sync with testing backend data with writing complex SQL including sub queries from multiple data source in the Cognos Reporting Studio and Analysis Studio.
• Build and executed complex SQL queries using JOINS, UNION, Nested queries and SELECT statements to validate source data to migrate from source to staging database.
• Involved in testing various Inbound process functionalities as Interfaces, Receiving, Putaway, Cycle Counting and Vendor Performance and the Outbound process functionalities as Waves and Wave Management, Replenishment, Allocation, Picking and Packing and Transportation of WMOS. Tested RF devices and Vocollect functionality.
• Responsible for coordinating script execution between numerous functional areas and executing tasks pertaining to the Manhattan WMOS warehouse management system.
• Performed regression testing to prove that the new code has no adverse effect upon the current system particularly in the area of corrupting data used by different applications or system performance.
• Performed functional, positive, negative, integration, smoke, grey box and regression testing on Warehouse Management System implemented in 3 different Shopper Drug Mart distribution centers.
• Created defects and managed defects life cycle of the project.

Environment: Informatica (ETL),Supply Chain Intelligence(SCI), HP QC, VB.Net, Oracle, Windows 2000, Visual Source Safe, Visio, MSWord, Manhattan (WMOS), Oracle, Cognos, MS SQL Server, SQL and Toad.

Confidential

Sr. System QA Analyst

Responsibilities:

• Performed testing on (Oversize/Overweight) OO application which is designed on SOA architecture which is COTS application based on IBM Cúram Platform.
• Analyzed Business and Functional documents and prepared test plans and test cases for OO application from requirement traceable matrix to cover 100% coverage.
• Prepared documents and tested data migration process and records and logic to transfer data from source to target.
• Prepared documents and data for performance testing and assisted performance team to ensure that performance testing and test results meet performance metrics.
• Performed different types of testing like sanity, integration, functional, regression, boundary conditions and performance testing.
• Performed testing on manual and automated routing for bridge clearances for trucks with overweight/oversized loads using analytical data provided from PHM server (Provides Map data and Restriction data) and OSCLIS(Ontario structure& Load information system). PRIO application uses PHM server analytical data and creates way points for truck clearance on the path, tested to check path and way points are correctly populated for clients.
• Performed testing on functionality of permits and transactions on permits like renewals, replacements, hold, cancellation, refunds and reinstate and verified credentials.
• Online payment process using cash, credit cards, store cards and certificates.
• Prepared excel documents using excel functions for reports and analyzing test efforts and defect results.
• Performed audit testing, printing permits on secure paper and invoice generation.
• Evaluate defects found during reviews to determine root cause and report to Celtic and prepare report for defect management.
• Participate in testing activities to ensure that the test results meet defined acceptance criteria.

Environment: IBM Cúram Platform, SOA, HPQC, QTP 10.0,VBScripts, LoadRunner, Oracle, DB2, JSF, HTML,XML, Internet Explorer, Team System, Windows7/XP, True Compare, Mainframes(TSO), MS Excel, SQL Server, PRISM, PRIO, Case Tools, MicrosoftVisual SourceSafe (VSS), Visual Studio.

Confidential, Mississauga

Sr.SAP ETL QA Analyst

Responsibilities:

• Documented the business requirements (BRD), developed Test Plans, Test Scenarios, Test Strategies and Test cases created for data migration tool StreamLoan Migration utility.
• Validated the load process of ETL (SAP BODS) to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Build and executed complex SQL queries to validate source data to migrate from source to staging database.
• Performed validation check on data on staging database for final migration to StreamLoan application in the ETL process.
• Involved in coordinating the gray box testing for the Data warehouse by checking ETL (SAP BODS) procedures/mappings.
• Prepared and executed test cases ensuring that specified technical requirements were achieved Involved in various data pulls for OLAP cubes for reporting.
• Executed SQL queries for validation of data and used TOAD for SQL Server to write SQL queries for validating data integrity constraints and backend testing.
• Tested the SAP BOBJ Reports (Crystal Reports, Webi Reports and Dashboard report e) using Info View and compared the data with back end Database Info Cubes, DSO’s writing complex SQL scripts.
• Performed testing on Shared securities, credit packages, tasks, insurances, migration options, migration rules and match rate for auto match, assisted match and manual match of registrations, registry testing and submitted to collateral guard.
• Performed manual functional, positive, negative, integration, UAT/BAT, smoke, grey box and regression testing on StreamLoan Migration utility and StreamLoan applications.
• Logged the valid defects and interacted with the application development teams to resolve the issues through defect calls. Provided in-depth detailed information to developer to resolve defects.

Environment: BOBJ X.3.1, SAP BW 7.0, HPQC, QTP, JAVA, Oracle, Toad, DB2, JSF, HTML, CSS, XML, Internet Explorer, Compuware, IBM Mainframes (TSO/SPF), MS Excel.

Confidential

QA Lead

Responsibilities:

• Led team of 5 testers in the development and execution QA strategy and test plans of all Confidential digital projects.
• Review project Business and Functional documentation and create detail test plans, test cases, and traceability matrix and test scripts to ensure the application performs as defined in the Business and Functional requirements using Test Manager.
• Performed manual functional, integration, smoke and regression testing on Facebook and mobile applications on IOS, android, Smartphone and tablets and iPad applications.
• Generated reports from Microsoft Team Foundation Server (TFS) to project and report Test Effort in the defects and test requirements.
• Created complex SQL queries included sub quires and nested quires to validate backend database.
• Performed web content, user maintenance testing using Adobe CQ5 on client websites (Nissan, Toyota and Toshiba).
• Tested applications on different web browsers (IE, Firefox, Safari and Chrome) in windows and Mac.
• Tested applications of HTML, Flash based web applications and mobile applications.
• Involved in walk through test cases to QA team before execution of test plans and defect investigation and procedure to escalate defects to proper channel. Report results to Project managers.

Environment: Microsoft Team Foundation Server, Team Manager, JAVA,JSF, .Net, MS SQL Server, HTML, CSS, XML, Internet Explorer, Adobe CQ5, Safari, Firefox, Mac, Windows 7/XP, MicrosoftVisual SourceSafe.

Confidential, Mississauga

Test Lead

Responsibilities:

• Mentor and Led team of 8 tester from off-shore and On-site and Involved in Business requirement (BRD), Functional requirement (FRD), Overall design and Use-case analysis, initial summary, risk analysis and documentation in SIT environment.
• I was responsible for helping to capture business requirements, identifying appropriate data sources, data quality issues, business transformation rules, mapping source to target.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Creating Test Plans, Test Strategy and Test case to support Transformation business rules based on design documents from Business requirement Documents and System Requirement Documents (SDS).
• Validating the data for duplicated data, NULL values and record count match written complex SQL scripts.
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse according to Business Rules.
• Performed both automated and manual positive, negative, Integration, functional, gray box, smoke, BAT/UAT (Business/User Acceptance Testing) and performance testing, unit testing.
• Involved in intensive functional testing of Unitrax SRP project like adhoc jobs for reports, workdoc functionality, Investment banking, Fixed Income, Capital Market, Cash Management, Wealth Management, Bonds, Payment Calculations and Derivatives.
• Performed functional testing on automatically detects Suspicious Transaction Monitoring based on behavior based logic and rule based logic in the AML Process.
• Tested a risk based approach for customer and account segmentation in the AML module.
• Tested the functionality ofscreening customers and transactions against different OFAC watch lists in the AML module.
• Created central data storage in Share point for test plans, Documents and deployment track records.
• Executed and created complex SQL scripts for data mining and for data analysis
• Logged the valid defects and interacted with the offshore development teams to resolve the issues through Quality Center, Follow-up calls and daily defect meetings.

Environment: HPQC 10, QTP 9.0, VBScripts, LoadRunner 9.1,EGL, Oracle, JSF, Web Services, HTML,DB2, IBM Websphere, .NET, Crystal Reports, Share Point,, IBM Mainframe(TSO).

Confidential, Mississauga

Test Lead

Responsibilities:

• Prepared the Business (BRD) and Functional (FRD) requirement documents, translated into Test cases according to the established standards for all releases (1, 2, 3 and 4).
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for source and target data.
• Tested data quality check for accuracy, completeness like missing data, invalid data and inconsistencies in the ETL process.
• Created complex SQL queries using TOAD to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications documents.
• Provided subject matter expertise on full QA life cycle, performed both manual and automation testing from the beginning of the project to end of the project.
• Prepared documents, test plans and test cases to execute by off shore and on-site team.
• Involved in testing mid/high frequency flow-centric fixed incomeauto-pricing strategies. Tested and monitored eTrading performance metrics.
• Involved in intensive testing of new developments of Unitrax SRP project like Pension administration, interest calculations, Credit cards, TFSA, RESP, Back office and Front office operations, Trading system, Capital market, Pricing system, Investment banking, Bonds, Trading and Mutual Funds.
• Anti-MoneyLaundering (AML)- Ensure compliance and government regulations bank-wide and adjudication of alerts for PEP, OSFI and OFACwatch lists/files.
• Performed automated and manual positive, negative, gray box, integration, functional and performance testing in SIT and BAT/UAT for different clients.
• Coordinated with Business team and gathered real time test data to be used in the UAT phase.
• Created and executed scripts in QTP using VB script for regression testing and sanity testing.

Environment: HPQC 10, QTP 9.0, LoadRunner 9.1,EGL, Oracle(RDBMS), JSF, WebMethods, Web Services, PCML, Summit(Trading system), HTML, IBM Mainframes(TSO), .NET, Internet Explorer, Biz Talk, Crystal Reports, Share Point,, Windows XP Professional.