Venu Bondala

*** ********* ****, ******* +1-647-***-****

acqv1q@r.postjobfree.com

Summary: Over 11+ years of experience in Information Technology as Software Quality Assurance with two years development experience

• 11 Years experience in Finance and Telecom domains including BMO,CIBC, SYMCOR, Rogers

• Hands on experience with Amdocs- Rogers, TELUS, Cablevision and SA Telkom, CIBC, SYMCOR

• Expertise in Testing, Credit card/Cheque Process, Archiving, Imaging, Web Access to the client

• Worked in Rogers Maestro-IPTV/HIS,RSHM- E to E ordering SS/CRM/OMS/ OSS/BSS/SOM/click/MPA

• 5 years Experience in functional and non-functional testing GUI, Billing, RESTful API HTTP methods

• Back end validation with Multiple DB schemas ASMS/OMS/CRM/MPA/Click/RCIS/OSM with Toad

• Back end validation with Oracle NRIS, OSM/BACC/ASAP/LSAF/Yahoo Member centre

• Customisation, reports, edit, configure Web App with oracle integration in the backend

• Compliance with CMMI, CETM Methodology, GAP Analysis, Test Strategy, Risk, UAT, SIT, DIT

• Extensively worked in QC/RQM/ Test base, during the last 5 years and Load Runner, QTP

• Experience in ETL-Data Warehousing source, destination, mapping, data integrity

• Experience in working SS/ Mainframes/RUMBA and Traceability Matrix- Requirement PLC phases,

• Strong knowledge of Software Development Life Cycle (SDLC), Testing Methodologies, Techniques.

• Performed Data Driven, Parameterisation, Correlation Tests of Automation, QTP/LR, batch process

• Proficient in RDBMS- and PL/SQL Programming for testing database

• Expertise in Quality Centre, Testbase, JIRA, BugZilla, RQM- with Clear Quest mapping

• Extensive working knowledge in UNIX and WINDOWS platforms.

• Excellent interpersonal and customer relation Skills, Analytical skills and problem resolution

• Proven experience in testing Web-based / PC-based / E-commerce / Client-Server applications

Technical Skills

Amdocs- CRM/Ensemble/PCE OMS/OSS/BSS/MPS/AR

Oracle Hyperion Application implementation of Reports, data validations, MF/stocks

Operating Systems: MS-DOS, UNIX, Windows 9x, Windows NT/2000/XP, MS PowerPoint

Languages: C, C++, C#, XML, JAVA, PL-SQL, TSL, VB. NET, ASP.NET,MY SQL, Oracle, UNIX

RDBMS: Oracle 7&9i.x, PL-SQL Server, and DB2,

Web Technologies: HTML, ASP, Java Script, VB Script, Java, PHP and IIS, Batch process, DVB/ Unix

Packages: MS-Office, MS-Access, and MS-Excel, SharePoint, MVS/COBOL

GUI Tools: Oracle Developer 2000, TOAD and Visual Basic 4.0/5.0,PVCS Tracker, Agile, JIRA

Testing Tools WinRunner/8.2, TestDirector9.2 LoadRunner 8.0,.QTP 9.2 /Selenium/Rational Tool RQMT

Test Strategies: Integration, System, Regression, User-Acceptance, Smoke, White Box, and Black Box

Professional Experience

Bank of Montreal-Toronto, AMLS Application- Sr QA Mar-14 Mar2015

The Application is to track and report currency Transaction reports (CTRs), MIR, DOEP to finCEN.

The Anti Money Laundering Application is to track CTR, DOEP, MIR provide a greater functionality

audit compliance procedures, controls both external and internal users and Govt.

• Prepare scope of test plan, design, develop, and document test cases, in Quality Centre

• Review ‘TC’ with internal and external stakeholders include Business, IT, Dev, PM and incorporate

• Review the project document, test plans, and provides input/concerns to prime

• Verify Reports, CTR, DOEP, MIR, Tables, Filters, schedules, views, PDF, Excel, Notes, attachment

• Provide Links URL, and other DB connectivity and extend all the support for a smoother execution

• Execute test cases for end to end flow, log the defects on priority and severity in QC

• Verify the amount deposited in ATM, Vault, Mobile transactions with the back end DB systems

• Verify upstream components Teller, ATM, Vault, Mobile transactions through source feeds

• Verify downstream components and Data drives to vendor management, Walter-Kluers system

• Verify user roles, permissions, status checks, assigned, unassigned, reported, acknowledged CTR etc

• Verify in Active Directory cash, conben demographic files etc. and compare with the vendor systems

• End to end test execution of TPT,DIS ATM, CIM, Smartsafe, Vision-IP FIS,IDP,AD,WK Inv Centre

Environment:.Net, MS SQL,Quality Center, FIS, IDP, WK- TA,WK-IC Windows-7, Load Runner, QTP, REST- HTTP protocol, Agile

Amdocs-Rogers-Brampton, Maestro-V-IPTV/HIS,RSHM/Provisioning Sr QA- Dec-2012-Jan 2014

Working as Senior- QA in SFT Functional on conversion of data from old legacy applications to Amdocs Maestro-V CRM Project. The application capability is to retrieve the data from super system and create contact and consolidate wireless account in Vision 21(ensemble) and Maestro.. It runs end to end scenarios for HIS/IPTV/RSHM with various flows ie tech, IMMD, courier, retail/ No Installer and processed through CRM/OMS/ASMS/SOM/WOM/Click/MPA.-,Create contact,address CBP,FA,BA, Provision order processing, NIA, soap screen, NPC CONFIG, N Form, submit OA (OMS) and provisioning the product- assign the order Action in CRM

• Prepare scope of test plan, test cases, develop document based on IA/SRD/IDD/DDD and other Docs

• Review ‘TC’ with internal and external stakeholders include Business, IT, Dev and incorporate them

• Provide Links URL, and other DB connectivity and extend all the support for a smoother execution

• Create Customer contact in Rumba App and migrate the customer to Amdocs CRM,OMS,ASMS

• Verify Address created in Rumba is in synch with RCIS DB and in Amdocs system

• Verify contact created in Rumba is in synch with downstream systems using SOAP UI

• Verify the products created in Rumba is in synch with other downstream applications as well

• Execute test cases for end to end flow provide, change, cease, re-establish, move, suspend, resume

• Verify upstream components IPTV Provision in SOM/WOM/OSM/ASAP/BACC/CVAS, ACS/ J Explorer

• Verify IPTV/STB/Modem/HIS/SHM End to End Provision in upstream and downstream components

• Verify upstream components for HSI Provision in SOM/WOM/ OSM/ASAP/BACC validations

• Verify upstream components for RSHM provisioning in SOM/WOM/ I-Control activation and validation

• Verify backend Oracle inventory equipment movement with order manipulations in Acquisition type

• Verify in all DBs OMS, ASMS, CRM, ABP, RCIS /USM/SI/PROV/SUB to run query using parameters

• Verify AP -assigned order status in CRM under search order equipment, SN, MAC_ID status in Oracle

• Verify test cases with OMS fall out order, SF process, orchestration, APM, USM, MPA, CLICK etc

• Verify test cases and tracking LOB plan, equipment, serial number, Mac ID location, error messages

• Execute test cases for cross contracts manipulating amend, cancel, withdraw amend as per scenario

• Verify in ASMS order synchronisation, work orders created and verify in OMS DB and ASMS DB

• Verify log files for the exception caused and log as a defect and forward to developer

• Verify work orders are scheduled in Click, assign tech to MPA en route, onsite, PREA, complete

• Verify logs for debugging application, env, code issues and log the defect in ‘CQ’ and assign to Dev

• Executed the sanity tests for every build and log the results in Rational RQM/CQ

• Experience in configuration management and keep track of change request, version

• Verified create, search, view, action tabs and dropdowns from Mainframe (RUMBA) super system

• Verify Conversion data of the customer postal code, address from the legacy applications to Maestro2

• Perform the comparison of the converted data synch between the two systems exactly matches

• Ensure all sign offs on deliverables test plan, test cases, pass/fail testing complies governance

Environment: J2EE,Oracle Toad 9.2,Rational Quality Manager, CQ, Unix, CRM, OMS,Windows NT, Ensemble, Account Receivables, SOAP,Mainframes, UI, Tuxedo, EIF,EAI,EAI Classic, ASMS,APM,USM,WOM, SOM, click, MPA,I Control.mJExplorer,OSM,ASAP,BACC,CVAS,ACS,DB-CRM,ASMS,OSM,ORACLE,OMS,MVS/COBOL/DB2,RESTful API, HTTP methods,Agile,JIRA

Rogers- Brampton, Maestro/SFT-Sr QA- Mobile Applications/HSI/RSHM June 2011-Feb 2012

Working as Senior QA for SFT Functional on conversion of data from old legacy applications to Amdocs Maestro-2 Project. The application capability is to retrieve the data from super system to Vision 21 and the converted data works well with the new system. The application capabilities are also to run the end to end scenario of CRM/OMS,create contact,address CBP,FA,BA order processing in OMS–select the product in soap screen, NPC options, Negotiate Fulfilment type, submit OA (OMS) and provisioning the product- SOM,WOM,MPA,Click and assign the order Action in OMS/CRM. This includes roaming, rating and mediation services. The product list includes RSHM, HIS connectivity and services updates.

• Prepare test plan, test scenarios, test cases, design, develop document in RQM/CQ

• Convert the requirements into the test scenarios, test cases based on business approvals

• Prepare the test cases from Design Docs; use case scenarios, non functional requirements

• Prepare and execute the test cases separately for SFT as per the execution cycles

• Designed test cases for IVR in CRM application sending the request and get response

• Prepare Address sharing,3-way billing between SS,Vision21,Maestro II test cases and verify in CQ

•SIT Test planning, execution, Analysis as per the life cycle and measures compliances procedures

• SFT Meetings, Bridge, updates, CR Defects, Review Design, and generate defect reports

• Verify mapping, data integrity are correctly displayed in GUI as per the design and the DB synch

• Prepare traceability of test cases to the requirements mapping in RQM/CQ

• Verify the change requests, DC, documents in share point integrated with MS Team Foundation server

• Executed the smoke tests for every build and log the results in Rational RQM/CQ

• Experience in configuration management and keep track of change request, version

• Execute the test cases for various OA/provide/change, move, replace and log the defects in RQM/CQ

• Verify create, search, view, action tabs and dropdowns from Mainframe (RUMBA) super system

• Verify Conversion data of the customer postal code, address from the legacy applications to Maestro2

• Perform the comparison of the converted data between the two systems exactly matches

• Validate converted data MACID, objid, Account_ID from super system to vision 21

• Ensure all sign offs on deliverables test plan, test cases, pass/fail testing complies governance

• Verify alert, history, collection, order, action, billing, trouble shooting dropdown values of CRM

• Verify order submission in APMS, SOM, WOM, Click, MPA, Mainframes to complete provisioning

• Verify Oracle- validations and verifications for the customer info, postal code into CRM/OMS/ DB

• Execute Soap UI sending request and response of the business logic, document in RQM/CQ

• Launch CRMWebservice from SOAP UI to Radial Point via the interfaces of OSB/EIF/CRM/OMS

Environment: J2EE,Oracle Toad 9.2,Rational Quality Manager, CQ, Unix, PCE, OMS,Windows NT, Ensemble, Account Receivables, Clarify- CRM, Clarify CRM, Load Runner, SOAP,Mainframes, UI, Tuxedo, EIF,EAI,EAI Classic, OSB, SOM, click, MPA, WOM, TSO/ISPF, MVS/COBOL/DB2,RESTful API,s methods,Agile, Jira.

CIBC-Quality Predictive Analyst- Lead Toronto Jun2010- June2011

Worked in CIBC on(OBIEE) Oracle Hyperion Essbase Cube Application implementation of EBI/BAS/IPS Migration Project. The project is being migrated from BIS location of CIBC to Finance Technology location of CIBC due to the ownership changes.IPS Application is planning,budgeting,forecasting of the LOBs under SBUs and also data flow between users an approvers of the plans using various cal scripts,dyn calc,web forms,Aggregations,Business Rules etc . Hyperion Report tool to verify fx conversion to USD/CDN, mutual funds, Mortgage products of the capital markets and the reports, web forms validations and verifications.

• Build, design, develop, and execute the test cases based as per the requirement hierarchy for SIT, UAT

• Prepare test plan,test strategy, test scenarios and take the signoff from all the stakeholders

• Proficient with ETL process using Informatica tool and compare data stage to data mart files

• Conversant with data modelling logical, physical databases, entity, attributes relationship,

• Conversant with databases and extract load, transform validations using Informatica tool

• Run Oracle-Toad –PL/SQL scripts/commands validation and verification from the backend

• Drilldown the dimensions to the level ‘0’ entity, accounts members log the defects in Quality Centre

• Prepare traceability of test cases to the requirements mapping in Quality Center

• SIT Test planning, execution, Analysis as per the life cycle and measures compliances procedures

• UAT shakedown, application, business rules, data validation, verification, migration of data, webforms

• UAT Meetings, Bridge, updates, CR Defects, Review Design, and generate defect reports

• Action plans, version, re-test procedures, documentation, bug life cycle, status reports

• Dynamic Calc, CalcScripts, Business Rules, Aggregation, Cur Con CEQ/Local retrieval

• Drilldown the dimensions to the level ‘0’ entity, accounts members log the defects in Quality Centre

• Verify the test reports of Aliases and close ratios, FTE, Count, Traffic light, Analysis view

• Verify mapping, data integrity are correctly displayed in GUI as per the design and the DB synch

• Verify FX Reports, Curr Objects by FY, Scenario, Version both HTML and PDF version

• Performed SIT, DIT, UAT testing using Oracle Essbase cube/Workspace for web forms validation

• Performed back end validation using Oracle-Toad to verify the values in web forms and workspace

• Performed Data Warehousing Testing, queries, source, destination files, layout, design, header,

• Design develop both manual and automation scripts and log in Mercury Quality Center

• Convert the manual test cases into QTP automation scripts

• Enhancing the scripts with Check points, Data driven methods, regular expressions, output values etc

• Enhance automation scripts with functional logic like loops, conditions in Expert view

Environment: J2EE,Oracle Toad 9.2,Unix,CRM, Mercury Quality Center, Load Runner 9.2,,QTP,windows OS, Oracle Hyperion Essbase,Reports, Workspace Framework, SharePoint server, Mainframes, Excel-add-in, MS Access, VBA, VB.net, Crystal Reports, PARASOFT,Calypso, wall street, MVS/COBOL/DB2,

Rogers, Brampton, QA Performance Lead Oct2009-June2010

Worked as performance Prime for PCI Tokenization Project. The application capability is to convert the credit card number into a token number by the vault server through the encryption and decryption mechanism -cryptography and also convert the token number into a credit card number. This is to establish baseline TPS-(Transactions per second) shakeout, Volumatrix, stability, batch process and node failover, stress, endurance tests

• Build, design, develop, and execute the test cases based as per the requirement hierarchy for SIT

• Prepare the test cases from Design docs,use case scenarios,non functional requirements

• As a team lead/prime to prepare test plan, test scenarios and take the signoff from all the stakeholders

• Performed various protocols of load runner http, web service, oracle nca, tuxedo, click etc

• Prepare and execute the test cases separately for SIT, UAT as per the execution cycles

• Record the script, run time settings using Load Runner and play back the script, verify in result log

• Debug the script and enhance the scripts with programming logic to reflect client business process

• Create, build web service scripts, compile, and run in Load Runner, verify the result in replay log

• Found memory leaks, http, time out issues, complex sql Index queries, coding, web logic issues

• Created Parameterisation, correlation functions using input arguments and map to dat files stored • Set Run time Settings, Iteration, Pacing, error message, extended logs, to enhance the scripts

• Created manual correlations and various c functions, date, timestamp, counter, atoi, array

• Preparing the detailed test plan, system specks, execution plan, load generators, number of vusers etc

• Verify the web scripts, vusers, and measure the average response time, TPS, web logic, db, app server

• Performed Baseline, stress, volume, node failover test and measure the average response

• Create and establish the shakedown test performance of the application, average response time

• Establish stability test for 12 hours with remote load generators and monitored the average response

• Run with 2000 users in the web script with four load generators to measure the response time within

• Generated 1.5 million credit cards and run batch process to vault and convert that into tokens

• Analyse the performance result and submit the reports with error logs, metrics as business required

Environment: J2EE,Oracle Toad 9.2,Rational Quality Manager,Unix,PCE,OMS,Windows NT, Ensemble,,Win Runner, Account Receivables, Clarify- CRM,,Clarify E-support, Load Runner, HTTP based RESTful API,s.

AMDOCS- Senior QA-Lead–Toronto Jan06- Sep09

Worked on Amdocs for CMSS Tool to Build, design, create, develop, test, fix, enhance,

Telkom ongoing Products and Services, bundles, Product Catalogues in Telkom Prod/Dev,

and Testing environment. It includes PSTN, WIRELESS, 3G Products, PABX technical components

marketing offers features, properties, Configure, define, map, bill components, GUI objects,

Relationship between the attributes, default values, domain, valid values bundles Price Plans, Charge

Codes, SLAs, templates.IVR testing .AR Billing-account, balance, adjustment, delinquent steps, order

process OAA/CRM/

Worked in client locations onsite support for these clients

TELUS-Vancouver- Desktop Application, ASF order process- DT1/IPTV/WL/ADSL

Cable-Vision- NY Integration Phase- Amdocs CRM Application. Billing/IPTV/WL

South Africa Telkom- CMSS Application/PCE/BSS/OSS/AR/CRM/WL/

Rogers-Brampton – CIM Implementation- CRM 7.5 validations/IPTV/WL/HSI

• Build, design, develop, and execute the test cases based for SIT, Integration, UAT, regression tests

• SIT Test planning, execution, Analysis as per the life cycle and measures compliances procedures

• UAT shakedown, application, business rules, data validation, verification, migration of data

• UAT Meetings, Bridge, updates, CR Defects, Review Design, generate defect reports

• Prepare test cases from design, use case scenarios, non functional requirements

• As a Senior Business Analyst executed the System Testing and User Acceptance Testing

• Prepare traceability of test cases to the requirements mapping in Quality Centre

• Record script, run time settings using Load Runner and play back the script, verify in result log

• Debug the script and enhance the scripts with programming logic to reflect client business process

• Create, build web service scripts, compile, and run in Load Runner, verify the result in replay log

• Found memory leaks, http, time out issues, complex SQL Index queries, coding, web logic issues

• Created Parameterisation, correlation functions using input arguments and map to dat files stored • Set Run time Settings, Iteration, Pacing, error message, extended logs, to enhance the scripts

• Created manual correlations and various ‘c’ functions, date, timestamp, counter, atoi, int to array

• Prepare the detailed test plan, system specks, execution plan, load generators, number of vusers etc

• Verify the web scripts, vusers, and measure the average response time, TPS, web logic, db, app server

• Performed Baseline, stress, volume, node failover test and measure average response

• Create and establish the shakedown test performance of the application, average response time

• Fix, Updates the status test lab and Defect Management modules in Mercury Quality Centre

Environment: J2EE,Oracle Toad 9.2,Quality Centre, Unix, PCE, OMS,windows NT, Ensemble,,Win Runner, Account Receivables, Uni-Base, CBS, Clarify- CRM, Clarify E-support, Mercury Quality Centre, Load Runner 9.2, .NET, RESTful APIs

SYMCOR, Mississauga, QA Analyst Feb02-Dec05

Activities covering all aspects including cheque processed-process, payment process, Documentation, Data Storage, imaging, Archiving for 7 years as a standard offer and application development. Back-end cheque process, envelops, adjustment, cash, fast checks, and ATM data management of Bank of Montreal, Royal Bank of Canada, TD Bank and host of other clients. Providing the web access to the clients and the services like CD-ROM, FILE TRANSFER, PRINT AND DISPATCH, EDS.

ATM includes capturing of envelopes, cheques and payments received for ATM Processing, as well as

the power encode and sorting of these same items

• Build, design, develop, and execute the test cases based as per the requirement hierarchy for SIT,BAT

• Prepare the test cases from Design doc, use case scenarios, non functional requirements

• Prepare the test case in Excel and upload to Mercury Quality

• Prepared the system testing for the Business Acceptance Testing Extensively used Test Director

• Validating data from the ‘ATM’ and compare with the back end DB2 database for load test

• Verification and validation of CD ROM File transfer data with back end databases

• Verification of data from the command prompt and then compare the data in xml editor

• Analyzed the use case scenario for the development of the application

• Linked test cases to its business functional requirements and log into the Mercury Test Director

• Performed GUI/System, Functional, Regression, Performance, Database Testing

• Created the regression suites, test sets, test cases, test templates which can be reused for multiple

• Executed the test cases according to software development life cycles and logged the defects in QC

• Extensively used data query, database testing with DB2 database

Environment: IBM Websphere-6, ARI, PL, AEF, TWS, ON DEMAND, PARASOFT, Test Director 8.0, Windows 2000, Visual Basic 6.0, COM+, DB2, Microsoft Excel 7.0, Microsoft Project, Crystal Reports 8.5 and Visual Source Safe 6.0, Mainframes (File-Aid, DB2, SPUFI, IMS,MVS,UNIX ), Rational Robot, RFT, clear case, Rational Rose,crystal reports, RESTful APIs

Education

• Trained RDBMS, OOPS, VB, SQL, Oracle - NIIT, India

• Certified E-commerce Expert – NIIT, India

• Master of Arts in Statistics --Indore University, Indore, India

• Bachelor of Commerce – Osmania University, India

Contact this candidate