Quality Assurance Project

Balaji Nallajeru

**********@*****.*** Phone: 519-***-****/2362

OBJECTIVE:

Over Six years of experience in IT industry as Quality Assurance Analyst in Analyzing, Conceptualization, Design and implementation of QA testing strategy for Web based and Client/Server applications using Manual and Automation testing on Windows/Unix platforms.

PROFESSIONAL SUMMARY:Expertise in QA methodologies and Software Development Life Cycle (SDLC).Experience in conducting QA session walkthroughs with Stake Holders, Project Manager, Developers and the Business teams.Thorough understanding of Business Processes, Analyzing and optimizing the processes, Analyzing business requirements and converting them into test specifications for the Test Plan creation.Proficient in Sanity/Smoke Testing, System Testing (Functional), System Integration Testing (SIT), End to End Testing, Performance Testing, Security Testing and Regression Testing.Experience in Enterprise Reporting system using Business Objects (BOXI) well versed with complete process in executing the Test Scripts and Bug Reports.Experience in creating Test Plan using the Business Requirements.Strong experience in creating automation scripts for Front-end GUI Testing.Strong experience of MS Project, MS Visio, MS Access, MS SQL Server, Business Objects.Strong experience working with Database Management Systems like MS SQL Server, mySQL and MS Access.Excellent communication skills with the Client and IT Department and acted as a Facilitator to perform conflict resolution process. Thus possess excellent Co-Ordination, Negotiation and Interpersonal Skills.Excellent verbal and written skills along with Interpersonal, Presentation and Self-Organizing Skills.Strong Experience in Financial Services and Reconciliation Process. Thorough understanding of Corporate Standards and their application in presenting solutions.Dynamic and assertive Team Player with strong commitment.

Testing Tool

QuickTestPro9.5/9.2/8.0, Win Runner 9.2/9.0/8.0/7.5, Load Runner 9.2/9.0/ 8.0

Bug tracking tools

Mercury/HP Quality Center 8.2/9.0/10.0, Rational Clear Quest 7.0/7.1, Rational Requisite Pro 7.1, Rational Robot 7.0, Bugzilla, JIRA.

Databases

SQL Server 7, SQL Server 2005, mySQL, MS Access 2000, Oracle 10g/11i

Reporting tools

Crystal Reports 9.0 Developer Edition, Business Objects XI 3.2 SP2

Scripting Languages

HTML, XML, VBScript, Java Script, Perl, Phyton

Design Tools & Web publishing tools

MS PowerPoint, MS Visio, SmartDraw, Erwin, MS FrontPage, Macromedia DreamWeaver, Rational Rose.

Reconciliation Tools

SunGard Intellimatch 8.1, Recollector, Admin, Match Monitor, Check free, Smart

MS Suite

MS Vision, MS Word, MS Project, MS Excel, MS Outlook, MS Publisher.

Programming Languages

C, C#.NET, ASP.NET, VB6.0

ERP

SAP, Oracle, PeopleSoft

Operating System

Windows 2000, Windows NT, Windows XP, UNIX, LINUX, MAC OSX

TECHNICAL SKILLS:

Professional Experience

Professional Quality Assurance Ltd. - Fredericton, NB March 2012 – Till Date

Quality Assurance Analyst

Project 2 - Credit Bureau Request: The Credit Bureau Request Status is used to track the Credit Bureau request as it is requested from the TransUnion and Equifax and received by D+H. One single request may have two parties associated to it and will result in tracking of two Credit Bureau requests. The status value of these request are independent of one another as the Credit Bureau search is done independently. The results provided back to D+H are reflective of three status values of Requested, Received and Error.

Project 1 - Recurring Pre-Authorized Payments: RBC allows posting of Pre-Authorized Payments (PAP) for inventories assigned to RBC-Internal, RBC-Litigation, and RBC-Recoveries. These PAPs are then processed through RBC’s Cash Management system which will debit the client’s account and route the funds to an RBC account for clearing and remittance back to RBC Collections by D+H.

Roles and Responsibilities: Accessed the Credit Bureau Request screen in RBC Client-side users, RBC Internal users, RBC Recoveries users, RBC Litigation in Collection Highway, Bankruptcy Highway and Repo Highway. Created Pre-Authorized Payments scheduler within Collection Highway to support Daily, Weekly and Monthly payments schedules.Pre-Authorized Payments posted automatically by the system as per the schedule defined.Created accounts to support multiple Recurring Pre-Authorized Payments concurrently.Created the reports for active and periodic Recurring Pre-Authorized Payments.New batch ran each day and posted a Pre-Authorized Payment for any Recurring Pre-Authorized Payments.Modified the primary screen to update the status of all RPAPs associated to the inventory for closed instructions.Used MS SQL Server to check the database updates of the scripts. Worked with different applications for Asset RMS, Bankruptcy, CH-Agency, CH-CCS, Document, Insurance, Litigation, Optimus, Payment, Property, RepoDepo, Repo and Skip locator highways.Verified the quality of existing functionality and prepare reports based on test results.Prepared the data for use during testing.Developed testing programs that address areas such as regression testing, negative testing, error or bug retests, or usability tests.Communicated regularly with Team Lead and software developers to scope out changes to use cases.Report, track and prioritize reported bugs.Analyzed and attempted to reproduce reported bugs.Documented software defects, using a bug tracking system, and report defects to software developers.Reviewed escalated issues and prioritize bugs according to impact and severity.Monitor bug resolution efforts and track successes.Reported high-priority items and communicate with software developers to fix high-impact bugs.Verified bug fixes and update bug tracking software.Participated in release cycles and monitor post-release crashes.

TD Canada Trust - London, ON February 2011 - January 2012

Quality Assurance Analyst

Project 6 - In Branch Customer Authentication (IBCA): The objective of this project is to provide additional tools for the CSR to identify Closed/Lost/Stolen/Cancelled Access Card within S3. There have been a number of instances where transactions have been processed with authentication taking place against an invalid card status.

Project 5 - Trillium Cards: This will allow the customers to do online transactions, at the point of sale internationally, through the mail and telephone as well as setting up recurring bill payments. Customers will be enabled with the option to transact through a contactless interface simply by tapping their card to an Interac Flash device at the domestic point of sale.

Project 4 - Online Signature Cards: It has been identified that there is an opportunity to discontinue the use/reliance of hardcopy customer signatures, on personal accounts, by using the existing hard copy signature cards filed in the branches. This project will allow for new personal account signatures cards to be electronically displayed within S3 and B-Web for viewing.

Project 3 - Impact 360: This scheduling application is a central repository for team member information. It holds information about each team member including team member ID, name, title, guaranteed hours and work availability. The Forecasting application utilizes historical transaction volumes that are captured by the teller transaction system.

Project 2 - FX Optimization (Wire Payments): The objective of this project is to permit the user to provide a more comfortable experience to the customer by enabling and simplifying wire payment and debit amount exchange conversion/entry on the same screen.

Project 1 - Radar Multiple Prompts: This application provides to increasing the number of prompts per customer per channel to increase the probability that there will at least be one opportunity for the sales staff to discuss with the customer for each channel.

Roles and Responsibilities: Extensive knowledge in working with Service Satisfaction System (S3), Clear Customer Choices (C3), Card Based Authentication System (CBAS) and Administration (Mainframe) Applications.Performed number of transactions in S3 application for Cash, Bill Payment, Cheque, Day to Day Banking, Service Fees, General Ledger, Journal Enquiry, Passbook, Drafts, Visa and Wire Payments.Created number of accounts in C3 application for Single Account, Joint Account, and Name Changes. Created, Changed and Verified the Debit/Credit Card PINs in CBAS application with IBCA (In-Branch Customer Authentication), CSPIN (Customer Select PIN) and Card Test using PIN PAD device.Changed the account statuses in Administration application for Single to Joint Account, Joint to Single Account, created the Power of Attorney messages, Signing Authorities and closed the Accounts.Worked with S3 application in Retail Branch, Call Centre/eBank, Branch Service Center Onshore and Citrix Environments.Strong experience in genning workstations, recycling the test IDs according to branch requirements.Reviewed documentation to understand business requirements, develop test cases and test scripts. Participated in preparation of testing documentation for Test Plan, Test Scenarios, Test Cases, Test Data and Risk Assessment.Participated in requirement and design reviews to provide the feedback on test requirements.Worked with test analysts and business analysts and others to understand project data requirements, environment set ups and coordination, Test IDs and testing dependencies.Used HP Quality Center during the test case development, test cases execution and defect management.Test cases are derived from functional requirements and use cases.Executed test cases within the testing environment with a high degree of accuracy in English/French and record test results/defects.Liaised with the test environment teams and others to schedule the test lab(s) and ensured environment configurations are set up correctly.Involved in Sanity/Smoke Testing, System Testing, Integration Testing, End to End Testing and Regression Testing.Identified and clearly communicated defects, verifying that applications satisfy product requirements.Verified and validated existing defects against new builds.Timely notified of issues/problems and recommendation of process improvements.Completed assigned tasks according to project timelines/schedules and costs.Worked effectively with the team, supporting other team members in achieving project/business objectives.Participated in knowledge transfer within the team and with the business units.Contributed to the success of the overall team by collaborating with others to ensure project deliverables are implemented within time, budget and quality parameters.Adhered to the System Development Life Cycle (SDLC) and Project Management Life Cycle (PMLC) methodologies.Actively participated in meetings with technology, development and business teams to discuss critical bugs.Submission of weekly status updates showing the progress of the testing efforts and open issues to be resolved.

Royal Bank of Canada (Capital Markets) - Manhattan, NY February 2009 – October 2010

Quality Assurance Analyst

Global Operations Exposure Reporting: The main purpose of this Data-Warehousing project is to provide Daily transparent Automated Global and Regional (Americas, Europe and APAC) Operations Exposures Trend report to

Senior Management with information required to manage risk and understand relevant Business metrics KRI’s (Key Risk Indicators) like Nostros, Fails, P&R and Suspense etc.

Roles and Responsibilities:Worked closely with Business Team to Design the Functional Specifications and system requirements and other issues throughout Project Life cycle.Analyzed business requirements, incorporated development and business objectives, and used the information to develop detailed comprehensive test strategies to verify system changes that met the needs of the client.Prepared and Executed Test Plan, Test Scripts and Test Case Document for User Acceptance Testing (UAT) based on functional and Technical Specifications.Performed UAT’s for different Source Systems to get automated feed followed by Control-M jobs and manual upload where Source systems do not exist.Executed Regression Tests for each System (FIX OPS, INSPIRE, CAMS) in INTELLIMATCH which deals with Product and Services like Fixed Income, Cash Securities, Mortgages and Whole Loans. CMBS.RMBS), Listed Derivatives, Equities, OTC Derivatives, GlobalForeignExchange, Global Money Markets, Options Asset Servicing, Security Financing. Allocate Resource for the project as per the Time lines and handle resource and project time lines issues with the upper management, Have conference call with offshore team (mostly at nights) to have a weekly status report.Managed and Analyzed requirements (business as well as system) in development of GUI, Performed GUI Automation Testing-using QTP in various development Phases for different OS (Linux, UNIX).Validated the Qry’s thru Sybase and SQL Server DB’s, Run SQL Queries to generate reports on different Key Risk Indicators like Nostros, Depots, Asset Servicing, Suspense, Fails, Payables and Receivables.SIT ed GMIS (Global Management Information System) and performed Load Testing and stress Testing using Load Runner 8.0 on Oracle 11i Repository for Consolidating Balance Sheet Exposure Related Data.Conduct Weekly meetings with the Project team and to have a weekly status report and prepare an overall QA status report and share it with the Team/upper management using HP Quality Centre 9.2.Executed Transaction Level Queries in People-Soft to Reconcile Sub-Ledger with General Ledger Accounts and address the Breaks of Risk Indicators followed by Sign-Off.Followed the Key System Development Life Cycle SDLC/SOX Project Stages to ensure quality of work effort.

Environment: SQL, Mercury Suites, HP Quality Center, Business Objects XI 3.1 Rich Client and Web Intelligence, People Soft, Load Runner, QTP with TML, Java, QA Track Message Que, SQL Server, SYBASE.

Lloyds Banking Group - Manhattan, NY December 2007 – January 2009

Quality Assurance Analyst

Flex cube: This is the core Banking System used by Lloyds Banking Group which deals with various modules such as Loans & Deposits, Loan Syndication, Foreign Exchange, Funds Transfer, Expense Processing, Standing Instructions, Journal Entries, Statement generation etc. Lloyds migrated from GBS which was AS400 based system. Involved in implementation and enhancements of Flexcube project by working closely with the I- Flex Team.

Roles and Responsibilities:Interacted with the Users, Designers, Developers and Project Manager to get a better understanding of the Business Processes and gathered Business Requirements for Personal Client Information Systems (PCIS). Documented the existing system and verified it with follow-up meetings. Worked with the team and the Business to document the Use Cases. Performed Regression and User Acceptence Testing for Online Banking System (Web Application) for Lloyds International Private Banking.Written and executed Test Scripts manually for Fedlink (Funds Transfer Replacement Project) Outgoing, Incoming, and Internal Wire Transfers.

Responsible for setting up the various stores attributes by interacting with the DB Admins. Responsible for Product Parameter changes for Loans & Deposits, Loan Syndication modules.Used Toad to check the database updates of the scripts. Analyzed & suggested business requirements, specifications, apprised the same to the PL of the project for any additional improvements; its subsequent impacts on to the job flow. It includes finalizing the time frame to finish the task and complete project implementation. Actively came up with solutions to some of the issues. Developed the Results document which aimed at suggestions to improve the performance of the application.Participated in Functional Walk-Throughs to validate the Application Design against the Test Cases written. A separate Bug tracking process using Quality Center is being used to Track Bugs periodically. Played a major role by actively participating in scheduled conference calls with different regions to review the testing status and Defect Summit meetings to triage new defects and to follow up on new fixes, patches and builds.Reconciled Financial Reports with queries from Oracle database using TOAD.As a part of Change Management Team participated in the prioritization of the projects and made decisions regarding any changes to the Application according to their impact on the application.Worked closely with users and coordinated User Acceptance testing for different projects.

Environment: Business Objects XI R/3 3.0, SQL Server 2005, Oracle 10G, TOAD, Mercury Quality Center 9.0, Microsoft Office Products like Excel and PowerPoint, Microsoft Visio, VB.net, Java Script.

HSBC - Manhattan, NY May 2006 - November 2007

Quality Assurance Analyst

Retail Service Index: This provides to analyze the architecture and infrastructure on which to build, deploy, and manage collaborative business solutions. This windows based application enables the customer service executives to keep track of all the correspondence done by their customers. Each document is scanned and stored in the database.

The customer service executives pull these scanned documents and index them into their categories under corresponding department. Intensive testing is involved when the customers have multiple transactions.

Roles and Responsibilities: Analyzed the system specifications, business requirements for full understanding of the project.Interacted with Subject Matter Experts (SME’s), asked detailed questions and carefully recorded the requirements in a format that can be reviewed and understood by both business people and technical people.Reviewed Test Plan that contains test scenarios for testing the functionality, navigation, security, recovery of the application.Performed execution of test cases to verify the expected results.Strong experience with QA processes and methodologies (manual test processes, black box, scripting and execution of Test Scripts).Performed Software Application Testing, regression, functionality and negative tests by executing the Test Scripts.Written SQL queries to retrieve data from Oracle database and making Validations.Managed Defect tracking process, which included prioritizing bugs, assigning bugs, and verifying bug fixes, using Bug tracking software.Reported bugs in defect tracking database.

Environment: Mainframe, Java, EJB, Servlet, JSP, XML, JavaScript, Oracle, Oracle 9i App Server, Dreamviewer, JDeveloper, QTP8.2/9.0, VBScript, TestDirector8.0/8.2. Business Objects 6.5, SQL Server 2000, Citrix Meta-frame.

Nomura Holding America Inc - NY March 2005 - April 2006

Quality Assurance Analyst

Online Processing: This is an application which provides customers of Nomura Holdings various financial services like Brokerage Services (Trade Stocks), Mutual Funds (Scan for mutual funds using criteria such as performance, risk parameters, fees and expenses, Buy, Sell, Exchange Mutual Funds), Fixed Income Investments (Choose bonds and CDs from large fixed income inventory and purchase CDs), Credit card Processing Municipal and Government securities online.

Roles and Responsibilities:Involved in back end-testing scenarios based on User/ functional requirements.Worked on RM Application i.e. Fixed Income Securities Application.Generated Test conditions using the test scenarios for functional, system, integration testing. Worked for the Conversion project in modifying and launching a new co-branded credit card and converting all business from FDR (First Data Resources) platform to TSYS platform. Reported defects Using Rational Clear Quest bug tracking tool to the Developers and performed regression testing after fixing the bugs by going through all test case scenarios.Wrote and modified required UNIX scripts and other SQL validation scripts to validate the outputs.Attended various meetings with the developers, clients, and the management team to discuss major defects found during testing, enhancement issues, and future design modifications.Responsible for validating account and premium summary reports whether they are pulling correct data in SQL generated report.Involved in creating and executing test scenarios based on User/ functional requirements.Reported coverage failure rates and then provided builds and release summaries to the project development team.

Environment: UNIX, Perl, SQL, HTML, VB6.0, VBScript, Windows NT, SQL, PL/SQL, Oracle8i, DB2, Win runner7.6, Clear Quest.

Academic Qualifications:

Master of Technology in Engineering.

Bachelor of Technology in Engineering.

Post Graduate Diploma in Computer Programming.

Contact this candidate