Quality Assurance Data Warehouse

Shameer Basha Sunkesula

*******.********@*****.*** 647-***-****

PROFESSIONAL SUMMARYOver 8+ years of experience in Information Technology in the field of Software Quality Assurance of Web Applications, Client Server, Data Warehouse,CRM, Mainframe and EPOS applications. Strong experience in Manual and Automation testing.Experience in Banking,Insurance and Retail IndustriesHands on experience in System testing, Integration testing, Data Warehouse testing, Positive, Negative testing, Functional/Non Functional, Grey Box,GUI, Smoke, Regression testing, User Acceptance testing, back end database testing and Infrastructure testing.Strong experience in developing Test Strategy, Test Plans, Test cases, Test scripts and Traceability Matrix using business requirements and design documents.Experienced in problem solving and tracking bugs using Bug Tracking Tools like Quality Centre, Test Director, Jira and Bugzilla.Strong experience in Business Analysis and gathering requirements for different applications.Experience in testing methodologies like Agile/Scrum and Waterfall.Experience in ASAP methodology, requirement gathering, blueprinting & legacy data migration.Thorough knowledge of various SDLC and STLC methodology, Bug life cycle and project life cycle with a good experience in project wide reviews of requirements and analysis of BRD, SRS, use cases design documents.Proficient knowledge of shell commands, experience in runner shell scripts in batch to process the files and executing sql queries to select, update, and delete data in tables.Proficient in Design & Implementation of ETL processes, Transformation, mappings and loading data from source to target using Informatica Power center.Outstanding analytical, detail oriented, creatively resolving problems and management skills with the ability to organize activities in fast pace team environment.Extensive experience in multi-tasking and completing projects successfully in short deadlines and under pressure.

TECHNICAL SKILLS

QA/Testing

Quickest Professional 8.2, 9.2,10, Quality center, Test Director, Jira, Bugzilla, JUnit, Nunit, Load Runner, SAP, Siebel CRM 8.1.1

Languages/Scripts

C,VB Scripting,JAVA Script,.NET,COBOL,JCL,UNIX,Web Services

Database

SQL, DB2, IMS, VSAM, XML, Oracle, Informix

Tools

CVS, Lotus Notes, Microsoft Outlook, Putty, DB Visualizer,CA7,TSO/ISPF,IBM WebSphere MQ, File-Aid, FileZilla,Toad,VSS,Visio, Data Warehouse

OS

Microsoft Windows, MS DOS, Mainframe,AS400, LINUX, UNIX, AIX 5.2/5.3

ETL Tools

Informatica Power Center 7.1/5.1.2

Web Technologies

J2EE, JSP, EJB, .Net, Adobe Flex

App Servers

WAS 6.1, BEA WebLogic, Web sphere, WebMethods 7.1.2

PROFESSIONAL EXPEREINCE

Client :Scotia Bank Nov 2012 – Present

Role :QA Analyst

Platform :QC, MS Excel, Microsoft Outlook, Java,V.B,Citrix,HTML,Windows XP

Responsibilities:- Worked closely with developers to isolate, track and troubleshoot defects.Reviewed Business Requirements Documents and the Technical Specifications.Tested Various modules with – Non Registered Saving Account,Registered Saving Account,GIC,Equities,Options, Mutual funds and other financial instruments.Involved in the Defect log maintenance using HPQC.Written and executed Test Cases with Test Data.Involved in Bug Review meetings.Prioritizing the bugs and keeping track of them through Defect Tracking.Performed Backend testing using SQL.

Client :Shoppers Drug Mart Feb 2012 – Sep 2012

Role :QA Analyst

Platform :QC, Bugzilla, Informix, DB Visualizer, XML,UNIX, Putty, MS Excel, Microsoft Outlook, FileZilla,Java, Siebel CRM 8.1.1, Windows XP, Microsoft share point, POS,Agile

The details of the various projects that I have worked in Shoppers Drug Mart areE-Health for HWNG(Health Watch Next Generation)RBC Master Card(Optimum Points)255 Call Center Move(Infrastructure Project)

Responsibilities:- Tested client/server based retail pharmacy application HWNG built in J2EE and using Weblogic with Informix database.Performed manual testing on E-Health ON, Newfoundland and Saskatchewan.Created Patients, Prescribers, Prescriptions, Compound drugs, security, setup, sig, refilling the prescriptions, Balance owe creation and completion of prescription.Tested HDM and CRx application to feed the data to NG system.Performed sanity testing on HWNG applications. Validated data of First data bank and HL7.Preformed testing on IVR online refilling, validated prescription labels thru FileZilla.Extensively worked on store simulation in Lab to test performance of the applications.Executed manual test cases on Pseudo and test tandem for third party prescriptions.Executed manual test cases on Shoppers web based applications Optimum application, Customer Demographic, Optimum partner and Optimum lookup.Tested legacy customer demographic systems into Siebel CRM application for better and faster service to the customers.Tested commercial off-the-shelf (COTS) POS application. Created and executed manual test cases for new application RBC Shoppers Optimum Master Card. Executed UNIX shell scripts in batch using PUTTY to process the files, to generate response files, to allocated points.Executed test cases from test batch runner. Validated test results.Encryption and decryption of files between Royal Bank of Canada and Shoppers thru secure channels. Used boundary testing to test input file values i.e maximum, minimum, typical values, error values. Performed security testing for used ids and passwords.Updated test strategy and test plans for the migration to VOIP telephony and a move of the entire call center to a new building.Participated daily Scrum meeting to update status for Enterprise Quality Assurance team.Reviewed all business requirements, use cases, process flows, data definitions and business rules for test case preparation and execution. Reported variances using defect tracking tool Quality Center and give input to the Test Completion Report.Categorized the defects found, depending upon its severity and priority and Reported to the developers using Quality Center and conducted defect resolution meetings.Understanding of SQL databases and ability to write MYSQL queries via PUTTY to verify tables, Transaction logs, test the database etc.Responsible for maintaining files, documents or general project relating information using Microsoft share point. Responsible for raising tickets to ITSD for system failures caused by software/Hardware.

Client :Express Scripts Pharmacy Canada, Mississauga, Canada July 2011 – Dec 2011

Role :QA Analyst

Platform :Quality Center, VB Script, QTP, SQL, Toad, UNIX, MS Excel, Microsoft Outlook, Windows XP, Microsoft share point,Waterfall

Responsibilities:- Development and creation of a detailed test strategy, test plan, reviewed and approved by appropriate team members. Created Carrier Id, Plan, Group, Sub Group, Client, Patient and DIN for manual and EDI claim submission.Performed manual testing on ESI adjudication system and claim reversal process.Created and executed manual test cases in English and French using decision tables. Performed validation on both English and French screens.Reviewed all business requirements, use cases, process flows, data definitions and business rules for test case preparation and execution. Conducted walkthroughs and presentation of the Test requirement group and test cases to TAG group.Developed Automated VB Scripts for GUI and Functional Testing and maintained set of re-usable scripts.Performed front end and back end testing: functional, usability, GUI, and database testing.FTPed files between Windows and Unix machine. Executed shell scripts in batch to process claims.Performed functionality of back-end claim submission and transaction validation using UNIX shell script. Tested application security features including login, session expiry, passwords and compatibility.Understanding of SQL databases and ability to write MYSQL queries via PUTTY to verify tables, Transaction logs, test the database etc.Ensured that test cases and defects are always upto date in QC.

Worked with Tata Consultancy Services Limited (Full Time) from May 2004 to June 2011. The details of the various assignments that I have handled through TCS are listed below in chronological order.

Client :AEGON Insurance, Scotland/UK June 2009 – June 2011

Role :Sr.QA Analyst

Platform :Test Director, VB Script, Java Script,Junit,QTP, SQL, Oracle, HTML, Data Warehouse, .NET, IBM MQ, Message Broker, Websphere, Siebel CRM 8.1.1, AIX, Informatica, BEA WebLogic, Business Objects XI R2, Mainframe, Apache web server, Agile

Responsibilities:- Gathered and analyzed Business, Functional Requirements, System specifications and Design documents.Created Test Strategy, System Test Plan, Test Scripts,Traceability Metrics and Status Report Templates which were used in multiple projects.Reported variances using defect tracking tool Quality Center and give input to the Test Completion Report.Validated data across legacy systems, data warehouse and transactional systems. Validated the ETL process for the data warehouse by running SQL queries against source and target databases.Developed and maintained Informatica PowerCenter solutions.Worked with a job scheduler application to design and schedule Informatica workflows.Tested the end to end ETL process in the Data Warehouse using Informatica Power Center.Tested Desktop Intelligence and Infoview reports built in Business Objects XI R2.Validated data across legacy systems, data warehouse and transactional systems.Database tuning and performance monitoring. Usage of various transformations to Develop mappings.Worked with IBM MQ and Message Broker for sending files.Performed front end and back end testing: functional, usability, GUI, and database testing.Verified defects found by users and subject matter experts during UAT.

Client :Great West Life Insurance, Winnipeg, Canada Dec 2007 – May 2009

Role :QA Analyst

Platform :JIRA, VB Script, QTP, SAP, Loadrunner, Mainframe, Oracle, .NET, ETL Informatica Power Center, Windows NT/XP

Responsibilities:- Involved in all the phases of SDLC and STLC and gathered the requirements from BRD’s.Created Test Strategy, System Test Plan, Test Scripts and Status Report Templates.Performed Functional, Regression, Performance, back end testing and User Acceptance Testing on insurance applications DCT/DCR.Tested the end to end ETL process in the Data Warehouse using Informatica Power Center.Responsible for creating Regression Suites using Quick Test Professional.Performed Data Driven testing using Quick Test Professional on DCT/DCR application.Prepared Test Estimates and participated in Weekly Status meetings, conducted walkthroughs, and documented possible enhancements, request and improvements.Responsible for reporting, updating and maintaining the Quality Centre for all the defects found during Functional and regression testing as well as following up on the bug life cycle.Wrote and executed SQL queries during back-end testing for data analysis and verification.Various batch jobs were run by using JCL commands.

Client :AVIVA Insurance, UK Jan 2007 – Nov 2007

Role :QA Analyst

Platform :Quality Center, VB Script, QTP, SQL, Oracle, Windows NT/XP

Responsibilities:- Performed a thorough analysis of business requirements, functional requirements and technical requirements to develop robust test conditions, cases and scenarios.Implemented the Test Scenarios and Test Cases for the vehicle coverage, policy coverage and driver claims page.Performed Regression and Functional Testing on Vehicle Coverage, Policy Coverage and Driver Claims Page.Providing guidance and assistance in the User Acceptance Testing phase of a project.Developed recovery handling scenarios on the driver assignment page in QTP.Performed Data Driven Testing using parameterized test data in QTP.Performed form-validation through QTP Validation and Checkpoint controls.Used Quality Center to Create Test Cases and Execute Test Cases.Tracked the bugs and reported them using Quality Center as the defect tracking tool and performed regression testing.Mentored the On-site and offshore and escalated issues accordingly.Used SQL commands to validate the data in the Oracle Database as part of back end testing effort.Liaison between the QA team, Development team and Business Team.

Client :ABN AMRO Bank, Amsterdam, Netherland June 2005- Nov 2006

Role :QA Test Analyst

Platform :Java Script,Junit,VSS, ETL, Windows 2000, Oracle, Informatica Power Center 5.1.2,Mainframe, UNIX, Business Objects 5.1.6, BEA WebLogic, Apache web server

Responsibilities:-Analyzing the Business Requirements and System Specifications to understand the application. Developed QA Test Plan from technical specifications and requirements for this project.Tested message formats in which the data is sent,network response for Credit Card application.Validated the ETL process for the data warehouse by running SQL queries against source and target databases.Conducted data testing within ETL process testing cycle.Cleansing the data & feeding it into the target system.Performed Data Validation from DB2 in SPUFI.Developed Test case and generated test data for positive and negative test scenarios based on functional specifications and design document. Validated test results of team members.Used SQL commands to validate the data in the Oracle Database as part of back end testing effort.Attended weekly status meetings, bridge meetings showing progress. Created problem tickets in Siebel CRM application and closed it out after retesting the issues.

Client :Deutsche Bank, Bangalore, INDIA May 2004 – May 2005

Role :Developer

Platform :COBOL, JCL, Db2, IMS,CA7,File-Aid,CICS, File-Aid,VSS(Visual Source Safe), Lotus Notes

Responsibilities:- Played an important role in project execution from design through the implementation.Collect the requirements from business.Impact analysis and Estimation on over Business requirements.Conducted User Accepted Testing (UAT), worked closely with business users.Transfer data using NDM/XMIT from production region to other production or test region.Worked on Capital markets and online trading of Securities & other financial instruments.Tested various modules with - Equities, Options, Mutual funds, Brokerage, Lending and other financial instruments.Tested 4DBC(Digit Batch Code) for its uniqueness, terminal validation for Credit Card application.Performed testing on EDI and credit card applications.Used QMF to query DB2 databases creating SQL statements for use in the development and maintenance of programs.Fixing different kind of errors and abends due to production issues.Preparation of Implementation Plan.

EDUCATION

B.E (Bachelor’s Degree in Engineering) in Computer Science.

CERTIFICATIONS

Certification in Insurance Competency, Certification in Financial Systems.

REFERENCES

Professional and Personal References Available upon request.

Contact this candidate