Mak Chandra ************@*****.*** 403-***-****
****-*** *** *** ** Calgary, AB T2P 0N5
Objective
To secure a position in the field of software quality assurance, where my 7
years of professional expertise would be utilized for the benefit of the
company and its clients.
Professional Summary
. 7 years of professional experience in field of Software Quality Assurance
and Testing with major emphasis in Manual and Automated Testing
. Experienced in using HP Mercury tools like Quick Test Professional, Load
Runner and Quality Center
. Experienced in testing application in both Agile and Waterfall
methodology
. Performed extensive testing Telecommunications, Insurance, Financial,
Ministry, Banking and Educational domains
. Diverse experience in testing Web-based / Client Server/ E-commerce /
Mainframes and CRM applications on different environments
. Hands on experience in testing web based applications by applying web-
testing concepts like: Cross Browser, Navigational, Track, Security and
content testing
. Thorough knowledge of Software Development Life Cycle (SDLC), Testing
Methodologies and Testing Techniques
. In depth knowledge in developing Test Plans and Test cases based on
Business and Functional requirements
. Experience in defect login, tracking, resolution and with various
statuses throughout software testing
. Successfully accomplished Sanity/Smoke testing, Functional, Regression,
Integration, System testing, End to End testing, User Acceptance Testing
(UAT), Performance, Load, Volume and Stress Testing based on the project
and Test Plan
. Hands-on experience in testing mobiles and tablets of the Android,
Blackberry, Microsoft and iOS Platforms.
. Good knowledge in Software Performance Test Life Cycle.
. Ability to interact with ETL developers to understand business rules and
mappings to create better test cases
. Performed data validation testing (Qualitative and Quantitative) after
ETL conversion and migration
. Fair knowledge of Informatica Power center features like Filters,
Aggregation, lookup (Connected and unconnected), Expression, Stored
Procedure and Source Qualifier
. Around 3 years of experience in Automation Testing using Selenium.
. Excellent Communication, interpersonal and analytical Skills
Education
Master of Business Administration, JNT University, India 2006
Bachelor of Science (Technology), Kakatiya University, India 2004
Skills
Operating Systems: MS-DOS, LINUX, UNIX, Windows 7/XP/NT/2000 and
Mainframes (TSO, SPUFI, CICS, File-Aid, IMS, JCL),
COTS
Technologies: C, C++,C#, Power Builder, XML, PERL, Applets, Servlets,
JAVA, Java Script, ASP, .NET, SQL, UNIX Shell
scripting, HTML, JSP, ISS, PWS, JBoss, Apache, Oracle
Developer 2000, Visual Basic 4.0/5.0.
RDBMS: Oracle 9i, MS SQL Server, Developer 2000, Informix and DB2,
Database tools RAD, IBM Data Studio.
Microsoft Packages: Access, Visio, Power Point, word, project and Excel
CRM: SAP, Siebel, People Soft and Microsoft CRM, Sales Force
Testing Tools: Quick Test Professional 10.0/11.0, Quality Center
9.0/10.0/11.0, LoadRunner 9.0, WinRunner, Bugzilla,
Rational Clear Quest, Jira, JMeter, and Selenium.
Tools: Microsoft Content Management Server, Team Foundation Server,
Microsoft CRM, Oacis EMR App, SharePoint MOSS,
Crystal Reports and BI Reports
Professional Experience
The City of Calgary, AB
Sep 2012 - Jan 2014 Civic Election Results and Enumeration System QA Analyst
(CERES)
The CERES and CERES Web project is development of a web-based product to
replace The City's existing 17-year old Visual Basic 6 Civic Election
Results and Enumeration System (CERES). CERES is used by Election &
Information Services staff to enter and store voter enumeration, store and
publish the civic elections results (every 3 years).
. Responsible for testing in Voter enumeration data entry and
validation, Enable enumeration data entry from remote devices, Publish
voter register, Election results data entry, Publish election results
and voter turnout, Reporting.
. Performed Functionality, Integration, Web, Security, GUI, End-to-End,
Configuration, URL navigation and Backend testing
. Conducted Functional, System and Regression testing by executing all
the test cases
. Performed Regression testing on every build after bug fixes.
. Responsible to gather and review Business, Functional Requirements and
Use Case Documents so as to write test cases and scenarios
. Created Test Cases in Excel template which includes both positive and
negative scenarios.
. Organized walkthrough session for review and sign off on Test plan,
Test scenarios and Test cases
. conducted Mobile Testing includes Device, Tablet and App Testing
. Expertise in developing Complex Automated Script framework and utility
functions for performance testing using LoadRunner
. All performance testing project activities including requirements
gathering, planning, designing scripts and creating test data,
executing load tests, reporting observations
. Mapping client's requirements into designing performance scenarios.
. Identify and eliminate performance bottlenecks during the development
lifecycle using LoadRunner.
. Responsible for implementing LoadRunner, Performance center based
infrastructure including: Architecting the load testing
infrastructure, hardware & software integration with LoadRunner.
. Independently develop LoadRunner test scripts according to test
specifications/ requirements.
. Experience in Designing and executing the automation scripts using
Selenium.
. Ability to develop complicated SQL script for Data validation
testing by running SQL script, procedures.
. Proficient in SQL, PERL, Shell Scripting and PL/SQL coding and
experience in Performance Tuning of SQL and Stored Procedures.
. Environment: Quality Center 10.0/11.0, Quick Test Professional 11.0,
LoadRunner 11.5, Selenium, SQL, ASP.Net, ASP, Weblogic, VB Script,
Windows 7, Microsoft Content Management Server, Team Foundation
Server, Microsoft CRM, SharePoint MOSS, HTML, XML, Active X, PHP,
DB2, Oracle 9i, SAP Crystal Reports and BI Reports.
Government of Saskatchewan General
Insurance, SK
Sep 2011 - Aug 2012 Online Siebel Policy Admin System QA & UAT Analyst
Saskatchewan General Insurance Online Policy system is built using Siebel,
which is used by all the underwriters and customer service representatives
for Policy administration activities like create new policy, update
existing policy, suspended policy, calculate premiums, calculate dividends
and print annual statements.
. Responsible to gather and review Business, Functional Requirements and
Use Case Documents so as to write test cases and scenarios
. Performed Functionality, Integration, Web, Security, GUI, End-to-End,
Configuration, URL navigation, Cross Browser and Backend testing
. Conducted Functional, System and Regression testing by executing all
the test cases
. Tested the functionality of Siebel by applying both positive and
negative conditions
. Performed field level validation on crystal reports generated by Siebel
application
. Worked extensively on backend using DB2 Connect data mapping testing
. Performed defect tracking using Bugzilla
. Developed UAT Test Plan, Test Cases for User Acceptance Testing
. Performance bottleneck identification, End-to-End Root cause
Analysis on performance bottlenecks.
. All performance testing project activities including requirements
gathering, planning, designing scripts and creating test data,
executing load tests, reporting observations
. Environment: Quality Center 10.0, Quick Test Professional 9.2,
LoadRunner 9.5, ASP.Net, ASP, Weblogic, Oracle Siebel, VB Script,
Windows 7, Microsoft Content Management Server, Web spear, Web Logic,
Team Foundation Server, Microsoft CRM, SharePoint MOSS, HTML, XML,
Active X, PHP, IBM Mainframes (TSO, SPUFI, IMS, JCL, CICS), DB2, Oracle
9i, Crystal Reports, Bugzilla.
Ministry of Education, AB
May 2010 - Aug 2011 Web Portal Enhancements QA & UAT Analyst
Ministry of Education online portal application is being enhanced to
integrate Online Back to School application. Using this new enhancements
Alberta residents can learn about information to parents, students and how
to help student scores.
. Created detailed Test scenarios to ensure the test coverage and to also
identify the test data requirements
. Created Test Cases in Excel template which includes both positive and
negative scenarios.
. Executed the Test cases to perform Sanity, Functionality, Web,
Integration, End to End and Backend testing using SQL
. Performed Backend testing on the converted data with the help of
Informatica
. Performed Regression testing on every build after bug fixes
. Performed User Acceptance testing with the help of users by creating User
Acceptance test plan and Test cases
. Reported all the defects with proper priorities to the development team
using Quality Center tool
. Regression Testing was performed using QTP upon receiving new builds and
updated the scripts accordingly
. Provided daily status reports to the management during Test planning and
Test execution.
. Tracked defects using JIRA and generated defect summery reports.
. Tested integration of the tool with popular defect tracking systems and
Automation tools like JIRA.
. Performed Back end testing by writing SQL statements like Join, Inner
Joins, Outer joins and Self Joins used TOAD and SQL Developer.
. Environment: Quality Center 10.0, Quick Test Professional 9.5, JIRA,
COTS, Oracle 10g, SQL, ASP, ASP.NET, VB Script, Microsoft Content
Management Server, Team Foundation Server, Microsoft CRM, SharePoint
MOSS, Cognos Reports, WebLogic, and UNIX
Royal Bank Of Canada, ON
May 2009 - Apr 2010 Online Banking Bulk Changes QA Analyst
Royal Bank's Online Banking Bulk changes project deals in enhancing the
existing online banking application so that both personal and business
customers can also access their accounts using Single Sign On Banking. As
part of this project new online estatements are being created so that
customers can access their transaction on demand basis.
. Responsible for gathering Business, Functional Requirements, Use Cases
and Design Documents
. Created Test plan, Test Scenarios and Test cases based on Business and
Functional requirements
. Organized walkthrough session for review and sign off on Test plan, Test
scenarios and Test cases
. Performed Functional, Regression, Integration, WEB, Cross Browser, Flash,
End to end testing and User Acceptance Testing
. Performed Regression testing of the application after the defect fixes
. Tracked and Reported Defects using Mercury Quality Center
. Responsible in providing Test Execution and Defect Test reports to the
management
. Provided test planning and execution status reports to the QA manager
. Took part in Development team to develop certain modules of application
in HTML and Java Performed different type running the automation scripts
of testing on application to ensure that application is error free.
. Environment: Quality Center 9.0, QTP 9.0, JMeter, Web sphere 6.0, Java,
JSP, Flash, PHP, HTML, XML, Applet, Servlet, MS Excel, Oracle, Web Logic,
TOAD and Windows NT 4.0
Rogers Telecommunications, ON
Aug 2008 - Apr 2009 CRM Online QA Analyst
Rogers CRM is AMDOCS application that will be used by all the call center
representatives at Rogers to provide information to their clients about
products, services, orders and their status, billing and generate
statements. This CRM AMDOCS is also integrated with third party Market
Research companies to provide customer feedback on the products and
services that being offered by Rogers.
. Gathered Business, Functional Requirements and Design Documents from
Business Analyst to write System Test Plan, Test Cases and Test
Scenarios
. Created Functional Test Plan based on the requirements and provided it
to the management for signoff
. Created Test Scenarios and Test cases using Standard templates
. Analysed Test data and mapped to the related Test cases
. Performed Functionality, Integration, Web, Network, Security, GUI, End-
to-End, Configuration, URL navigation, Cross Browser and Backend
testing
. Conducted Functional, System and Regression testing by executing all
the test cases
. Tested the functionality of CSM SAP by applying both positive and
negative conditions.
. Worked extensively on backend using SQL data mapping testing
. Used Quick Test Professional for Regression testing
. Experienced in Regression Testing with reusable test suites, regression
frame works and enhancements to verify the product integrity after
enhancement.
. Proficient knowledge about the CRM principles and techniques
. Executed integration end-to-end testing scripts.
. As schedules were compressed, worked closely with developers and
business analysts towards ensuring a quick resolution of defects.
. Participated in User Acceptance Test (UAT), documented procedures
and guiding the users in using the application.
. Huge experience in Linux driver development experience, Strong passion
for QA and a deep understanding of Linux development.
. Strong technical knowledge in Jboss, Application server implementation,
support, workload management and performance tuning including Web
server setup configuration with Jboss App Server.
. Environment: Quality Center 9.0, QTP 9.0, Java, Java Script, Linux,
Apache, JBoss, JSP, EJB, Websphere 7.0, AMDOCS, PeopleSoft, Siebel,
SAP, HTML, XML, UNIX, Oracle 9i
Rocket Gaming, BC
Mar 2006 - June 2008 Online Gaming Applications QA Analyst
Rocket Gaming online applications are used in Casino game machines like
Black Jack, Roulette, Poker and Craps, these applications are connected to
the central server that monitors the games.
. Actively participated in developing Test plans, Test cases, and Test
scenarios based on the Scope, Use Case Document, Business Requirements
and Functional Requirements Specification Documents.
. Identified Test data and mapped to the related Test cases
. Executed test cases to test the Functionality, Integration, Web,
Security, GUI, End-to-End, Configuration, URL navigation, Cross Browser
and Backend testing
. Performed Test Management and Defect Tracking using Quality Center
. Worked extensively on backend using SQL data mapping testing
. Attended meetings with Business Analysts, Developers, QA manager and
Team Lead to resolve issues and analyzing risk analysis.
. Perform the tasks of managing software for testing handsets, mobile
components, and applications
. Extensive knowledge of cellular devices, applications, and
OEM platforms
. Environment: Quality Center 9.0, Java, J2EE, EJB, JUnit, Java Script,
XML, Websphere 7.0, HTML, XML, UNIX, Oracle 8i, Blackjack, VLT, Poker,
Roulette and Craps