Venkat Natani 416-***-****

QA Analyst acwsq3@r.postjobfree.com

Profile

Over 8+ years of IT experience in Software QA testing of Web Based, Client Server ETL,BI,Mobile

and windows migration Applications

Strong Testing skills in White Box, Block Box, Smoke/Sanity, Web Service, Functional, Data Driven, Regression, Integration, System Integration, UAT, BAT and Mobile Testing

Extensively used HP Quality Center for Maintaining Traceability Matrix and Defect Logging

Experience in Agile and SCRUM methodologies

Experienced working with huge volumes of data, analyzing data sets for Data Quality, Data Validation, Data Conversion, Data Migration and Metrics using SQL

Analyzed business requirements and executed test cases from Business requirements, System Specifications and User Manuals

Involved in all phases of SDLC, Testing, Proven ability to effectively plan and adapt to rapidly shifting priorities and deadlines

Worked closely with End user, Business Analyst,SMES, Project manager, Development team, system Admin, configuration team, system Architect

Ability to Learn Quickly and Adaptive / Flexible to new environments

Excellent analytical and problem solving skills with strong oral & written communication skills

Education and Training

Software Testing Methods & Process 2004

Masters in Computer Science 2002

Technical skills:

Testing Tools HP ALM, Jira, Test Director, TFS, Visual studio, Test Manager

Databases Oracle, SQL Server, MS Access

ETL: Informatica, Siebel crm, Master Data Management

Operating Systems Windows, UNIX, AS400

Expertise Domain Banking, Insurance, Telecom, Finance and sales

Microsoft Applications EXCEL, MSWORD, Power Point, MS-Office.

Other Tools Micro soft exchange, Lotus notes, TOAD, SQL Developer, Visual source safe,

Customer contact center (madi, Dialer, Edge), Customer management center.

Professional Experience

Scotia Bank, Toronto May’13 – Till Date

Project: CIM – Customer interaction management (PA and NPA Leads for Retail, Small business, Mortgage, vehicle Loan Process, Insurance, Auto Insurance, SCL) Investment Plat Form, FATCA - Corporate and Commercial, Universal Access – Scotia online, Retail Credit card Process and Risk Management, Credit cards Risk Data Aggregation and Risk Reporting, Scotia Limit changes (ABM, OPL, POS &ETL), High Interest Savings Plan (HISA), FOC, SIS (KYC) update for GIC’s and Mutual Funds, e-forms and Kofax - GCM applications.

Position: QA Analyst/QA Tester

The purpose of the CIM process is to extract specific campaign reference data from the EDW primary source of CIM Campaign Wave data and update the downstream end-channel applications (EDGE, Dialer (Madi- in & out bound), TCS Call History, Scotia Online web broker(Public site), Mobile, SPOT, PAL and ABM) into one single file.

Reviewed and Analyzed all functional and system design documents

Evaluated designed developed walkthrough and executed test cases from Business requirements, System Specifications, Process Flows, Design Documents, Applications diagrams and User Manuals

Worked on UAT, Regression testing, Functional testing, SIT, Database testing, Smoke testing, Compatibility testing, Sanity testing

Participates in integration tests, reviewing functional specifications to identify open issues

Selects and developed the integration testing techniques for ensuring the systems overall capability of fulfilling the client’s business requirements

Performed Functional, Performance, System, Integration and User Acceptance testing during different developmental phases

Tested back office admin to process the fund and fund payments

Tested the Teller(FFT) systems which involved direct deposits and clearing the cash and chequepayments

Performed and Tested for Scotia online web broker Transformation (public site)

Performed and Tested order entry and order booking for investments on RPM

Performed and Tested Taxation applications on RPM

Tested and Verified customer Matured Investment Funds and bonds Tax calculation Forms

Performed and Tested Taxation forms and calculations on RRSP, RESP, RDSP customer forms

Performed and tested products on Online(public), ABM, ATM and Mobile channels

Performed and tested products on sales Call center(EDGE, Maddi) channels

Performed and Tested on Term Transactions all Retail sales channels

Performed data validation and Tested reports on Sales Builder and BI

Performed and Tested Business Acceptance Testing and UAT testing

Tested and verified windows migration on FFT Systems(Teller)

Tested and verified all retail and small business Transactions on windows migration on FFT Systems

Experienced on UI usability testing migration systems

Verified and validating the GCM application Indexes on IBM File Net Content Manager Kofax

Validated and processing the Kofax Indexes on batch manger

Performed and Tested Card processing system on AS400

Performed and Tested Loans processing system on As400

Performed and Tested Batch processing and online processing translations on AS400

Experienced on windows compatibility,localized testing and cross browser testing on migration flat forms

Tested and verified the online web broker (public site ) on Bilingual French and English versions

Tested and verified online application forms (customers& branch forms ) on French and English versions

Validating and verified end to end ETL testing

Tested and verified ETL Mapping document validation ( source and target table structure, data types, data length, data field formats, length and names)

Performed and Tested order entry and order booking for investments on RPM

Performed and Tested for Scotia online web broker Transformation (public site)

Tested back office admin to process the fund and fund payments

Performed and Tested on Term Transactions all sales channels

Performed data validation and Tested reports on Sales Builder and BI

Performed Integration and System testing for all components on CIM For Intra Link and Sales Builder

Performed Integration and System testing on CIM for EDGE Call Center in & out bound calls, SOL and Maddi in bound & out bound calls.

Handled the detailed creation, execution, results, evaluation, follow up, documentation, and coordination of test cases or scripts and expected results to prove the conformance to the requirements

Developed and maintained the requirement traceability matrix for test scenarios and test cases on ALM

Developed testing test cases; executed test cases and recorded results and logged defects using ALM

Developed & Maintained reports in ALM to report progress of the testing process

Contributed, Creation and Maintenance of test strategies, test plan

Identified prioritized logged and retested the defects and worked with developers to fix the defect on ALM

Performed front and back end testing for Data Validation and debugging of data by developing and executing SQL quires

Environment: Windows, Java, .Net, C++,HP ALM, HP QC,Power Broker, JIRA,EDGE,RPM-Investments,TFS, Visual studio, Test Manager, UA, MADI, Oracle, Toad, SQL, IBM AS/400, DB2,IOS, Android, Ripple Emulator, Web Services,ETL,BI, CRM, Intra Link, A6,IBM File Net Content Manager Kofax and Tore 39.

Imex Systems May’12 – Mar ’13

Project: e-solutions and e-payments

Position: QA Analyst

Imex Systems offers end-to-end solutions, e-solutions, e-payments, migration solutions and hosted solutions that help minimize infrastructure costs and maximize the reliability and security of data for government portals to integrate and update backend systems for accounting and auditing purposes within the government.

Providing support on product development and designing innovative reinsurance solutions to address specific client needs.

Created Test Plans and Test Scenarios based on the test strategy and business/functional requirements.

Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage in the Quality Center

Developed testing test cases; executed test cases and recorded results and logged defects using ALM / Quality Centre

Experienced and worked with JIRA to capture and organize issues

Experienced and worked with JIRA to for defect management (defect logging and Tracking)

Tested the mapping data from Source to Target

Written complex SQL Queries to validate the data conditions

Tested and Verified in ETL data completeness issues (source and target record counts, data truncation.

Tested and Verified in ETL data quality checking for number check, data check, Precesion check, Data check, Null check and data duplicate checks.

Experienced with mobile testing process controls

Handle responsibilities of operating and testing cell phone platforms and corresponding carriers

Having extensive knowledge in mobile technologies like GSM, GPRS, WAP

Tested and Verified Mobile Applications standards as per client requirement

Tested all functionalities which a PC version of the respective messenger have like Blocking/Unblocking a contact, adding, deleting a contact, Display of the groups etc

Tested and verified all control panels, Multitasking, Push Notifications, media contacts, Locations

Extensively worked with backend activities for testing several reports developed by BI tools.

Contributed, Creation and Maintenance of test plan

Contributed to test estimates and test completion reports

Identified prioritized logged and retested the defects and worked with developers to fix the defect

Reviewed other test analysts test cases or test scripts in order to ensure testing quality

Performed front and back end testing for Data Validation and debugging of data by developing and executing SQL quires

Environment Windows, HPQC 10, TFS, selenium, JIRA,.NET, Share Point, CRM,SQL, UNIX, ETL – Informatica, Toad, IOS, Android, I phone 4/4S, Apache Tomcat, Ripple Emulator, Jboss4.2.1 Application Server

Ingenico Mar’11- Mar’12

Project: Online Payments

Position: QA Tester

This product is easy and flexible unattended payment solution for the self-service business and unattended solutions to easily integrate. It is a cashless payment in your self-service business. Accept all payment means and comply with the latest standards and cut complexity in payment and security. Address all self-service market segments: Retail, Banking, Hospitality, Petrol, Vending and Transportation

Evaluated designed developed walkthrough and executed test cases from Business requirements, System Specifications, Process Flows, Design Documents, Applications diagrams and User Manuals

Contributed, Creation and Maintenance of test strategies, test plan

Developed and maintained the requirement traceability matrix for test scenarios and test cases

Contributed, Creation and Maintenance of test strategies, test plan

Contributed to test estimates and test completion reports

Submitted daily status report, forecasted report, Roadblocks in each iteration to Team members, QA lead and QA manager.

Identified prioritized logged and retested the defects and worked with developers to fix the defect

Manage the Defect Tracking Process including Facilitate the Defect Triage meetings and Produce Test Status and Progress Report.

Worked closely with technical and non-technical peers and with management to make sure the successful delivery of the products and services

Environment: Windows XP, TFS, EMV payment cards, HPQC, selenium, Java, Oracle 10G, UNIX, Toad, MS-OFFICE, Putty, Websphere6.1, MS Share Point, Lotus Note.

Putnam Bank thru Global Techies, MI Mar’08 – Aug’10

Project: Putnam Investments, Finance & Banking

Position: QA Tester

Putnam Bank is one of the nation's largest diversified financial services, contain Regression Test Scripts it needs to be Update for new Enhancement in Existing functionality

Excellence in all phases of SDLC,Testing Methodologies, Test Phases, Testing Processes

Identified prioritized logged and retested the defects and worked with developers to fix the defect

Reviewed other test analysts test cases or test scripts in order to ensure testing quality

Performed data validation of reports and dashboards on BI tools

Created and tested complex reports on BI tools.

Performed Integration and System testing for all components on BI tools

Tested the Security setting in admin tool to setup users, groups and access privileges

Experienced in Process testing, Functional Testing, Data Visibility testing in Siebel crm Testing and BI Testing (Siebel Analytics and OBIEE)

Tested and Debugged CRM Applications and BI Applications (Siebel CRM and Siebel Analytics

Created and Debugged ad-hoc and standard Reports

Environment: Manual Testing, HP Test director 9.5, Siebel CRM, BugZilla, Oracle 10G, Java, BI Tools, UNIX, TOAD, WINDOWS, MS-OFFICE, EXCEL

Client: COX Communications Jun’06 – Dec’07

Project: Service Configuration and Activation Position: Various Roles in QA Tester

COX Communications is Largest cable and broad band services provider in USA and offering consumers to consolidate their quality services and cost saving

Reviewed and executed test cases or test scripts in order to ensure testing quality

Created and validated test data

Environment: Test Director 9.2, Frog Star, Oracle, SQL, SQL Developer, Java, MS-OFFICE, windows

Microsoft through

Project: RBR – Role Based Reporting System Feb’04 – May’06

Position: Software Test Engineer

Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Siebel CRM, Analytics Repository using Siebel Analytics Administration Tool.

Developed calculated measures and assigned aggregation levels based on dimension hierarchies.

Worked extensively on Siebel Answers, Siebel Delivers, and Siebel Intelligent CRM Dashboards for Compliance department using Siebel Analytics stand-alone/integrated implementation.

Responsible for developing different kinds of reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.

Managed security privileges for each subject area and dashboards according to user requirements.

Developed and executed regression test cases as part of build process

Created and validated test data

Experience in DTS for Scheduling jobs, data mappings and creating users.

Environment: Test Director 9.0, Siebel Analytics, Siebel CRM, .Net, SQL Server, DTS, Auto sys, Tomcat.

Contact this candidate