Post Job Free

Resume

Sign in

Microsoft Office Project

Location:
McKinney, TX
Posted:
February 20, 2018

Contact this candidate

Resume:

Sakshi Juneja

Contact: ac4joq@r.postjobfree.com, # 773-***-****, Address: 9900 George Washington Dr, McKinney, TX-75070

Experience Summary

7+ years of IT work experience in Quality Assurance & Business Analysis with strong business understanding of Retail, Banking, Financial and Airlines domain. Sakshi is a process oriented QA resource with ISTQB certification.

QA experience includes Team management, Requirement Analysis, Effort Estimation, Test Strategy, Test plan, Test Scenarios, Test Case Design and Review, Test Case Execution, Defect Tracking & Reporting, Test Status Reporting and various Project Management Activities. Past Experience:

• QA Analyst for Randstad Technologies at Bank of America from Aug’16 to Aug’17

• QA Lead for Financial Products at TitleMax Finance in Carrolton, Texas from Sep’15 to Nov’15 and Apr’16 to Aug, 16.

• Senior QA for Ops Suites Airlines at Southwest Airlines in Dallas, Texas from Aug’15 to Sep’15.

• QA Analyst for Financial Products at Think Finance in Fort Worth, Texas from Mar’13 to Aug'13.

• QA Lead for Financial Services at Accenture in San Antonio, Texas from Oct’12 to Feb'13.

• QA Analyst for Loan Servicing at Wells Fargo in San Antonio, Texas from Apr’11 till Oct’12.

• QA Analyst at Citibank in San Antonio, Texas from Feb’10 till Apr’11.

• QA Analyst at CVM solutions in Chicago, Illinois from July’10 till Oct’10.

• QA at CVS Pharmacy in TCS, India from April ’08 till Feb’10.

Skill Specification

• Expert in QA Methodologies, Business Analysis and QA Processes

• Proficient in Functional Testing, UAT, Regression, System Integration, Database Testing, Mobile testing of Web based and Client/server applications.

• Expertise in Web Services Testing using SOAPUI

• Experienced in various phases of Software Life Cycle. (SDLC and STLC) and sound knowledge of Iterative, Agile and Waterfall models.

• Expertise in Domain: Banking and Financial services (Mortgage, Basics of Banking) and Retail.

• Expertise in Tools: HP ALM Quality Center, SOAP UI, JIRA, TFS, QTP and Clear View 4.0.

• Has complete knowledge of testing-related artifacts, such as Test Plan, Test Strategy, Test Metrics, Test Summary Report, Defect Summary Report, and QA Status Reports.

• Expertise in Test Cases Design, Review and Execution, QA Reporting, Defect Management, RTM (Requirement Traceability Matrix)

• Coordinating Onsite-Offshore modeled projects.

• Oracle, SQL, PL/SQL, MySQL and basics of UNIX, LINUX.

• Data Integration & Mapping testing, ETL Testing

• Defect Co-coordinator: Issue analysis, tracking and reporting

• Expertise in MS suite like MS Word, MS Excel, MS PowerPoint and MS Outlook.

• Ability to work independently or as a team with minimal supervision.

• Team Mentoring, Excellent Presentation Skills and exceptional communication skills.

• Delivered various Maintenance and Enhancement projects

• Assisted Automation team in Scripting Regression Suites

• Worked on Product Implementation Projects and Migration Projects.

Technical Skills

Testing Skills : Functional, Mobile, ETL, Web-Services testing.

Defect Tracking Tools : HP ALM Quality Center, JIRA, TFS, MTM.

Operating Systems : Windows, Macintosh, UNIX, LINUX and MS-DOS

Data Bases : Oracle 10g, 11i, PL/SQL, MySQL and MS Access

MS-Suite : MS Word, MS Excel, MS Power Point and MS Outlook

Other Tools : SOAPUI, Putty, TOAD, VSS 6.0, Tortoise SVN, MSP, ETL

Technology : Java, .net, SQL

Qualifications

Major and Specialization : Computer Science and Engineering

Degree and Date : Bachelors of Engineering in Computer Science, 2003-07

Institute : Career Institute of Technology & Management, India

Certification : ISTQB Certified Tester (Dec 2014)

Assignments

Bank of America MSP Migration from Aug'2016 to Aug’2017

Client

Bank of America

Project Description

Working on a project – MSP: QA Team member for Data Quality and Conditioning team involved in the MSP conversion program to migrate bank hosted applications to BKFS’s vendor hosted platform.

Responsibilities

QA Analyst:

• Extensively involved in the data mapping sessions for over 30 systems of record within the bank to the industry leading mortgage application Loan sphere MSP.

• Designed and developed test scripts for over 3000 data fields in the data definition document.

• Developed SQL queries to do source to target type of validations for various work streams to confirm data transferred with the application of stated logic in the data definition.

• Helped Line of Business with scenario specific data pull from various backend systems using Toad as well as Splunk.

• Engaged in extensive KT and brainstorming sessions with various teams involved in the conversion program related to Director and Passport Scripting.

• Heavily involved in Data Conversion validation event spanning 3 to 4 weeks and over 100 members both at the backend and UI level.

• Executed Test scripts to cover various scenarios and opened defects in ALM whenever necessary, triaged them with LOB and BKFS for root cause analysis and closure.

• Involved in sending daily QA status reports to PTM’s and leadership.

• Verified all the conversion/verification messages sent by BKFS as part of the initial validation for the conversion event.

• Identify and Analyze Quality Risks in Testing

• End to End Test Planning, execution and delivery

• Identifying, prioritizing and resolving defects and tracking of defects

• Requirement Analysis, Effort Estimation, Scheduling & Planning

Tools

Toad, MSP Director, HP ALM, AS400,SQL server, Passport.

Titlemax Finance from Aug'2015 to Nov’15 and Apr’16 to Aug, 16

Client

Titlemax Finance

Project Description

The TMX Finance family of companies (“TMX”) is one of the largest and fastest growing consumer specialty finance organizations in the United States. With brands that include TitleMax, TitleBucks, InstaLoan, and TMX Credit, TMX provides a diversified product offering.

Working on a project – Collections – which offers the capability to call customers who fall under different LOT categories and defaulted in their payments before sending their vehicle for Repossession.

Responsibilities

Senior QA Engineer:

• Working in agile based scrum team model

• Determine Testing scope & Develop Test Plan & Strategy

• Implement Software Quality Assurance standards and best practices

• End to End Test Planning, execution and delivery

• Identifying, prioritizing and resolving defects and tracking of defects

• Requirement Analysis, Effort Estimation, Scheduling & Planning

• Deliver Sprint Testing and Release Testing (System Integration)

• QA activities - test planning, design and review & Test Execution.

• SQL Testing, Data Integration Testing, ETL, UAT.

• Responsible for sending the Risk assessment before the sign off.

• Selenium Test scripts execution

Proficiently managed multiple testing projects in an AGILE environment.

Tools

TFS, MTM, Microsoft office, Selenium,Oracle SQL Developer.

Southwest Airlines (Cigniti) from Aug’2015 – Sep'2015

Client

Southwest Airlines

Project Description

Op Suites and Dot Com (southwest.com)

Southwest Airlines Co. is a major U.S. airline and the world's largest low-cost carrier, headquartered in Dallas, Texas.

Roles and Responsibilities

Sr QA Engineer:

• Working in agile based scrum team model

• Task tracking in JIRA

• Requirement understanding and Analysis

• In Pod (Sprints) and Out of Pod (Release) Test Deliverables

• Daily Reporting to all stakeholders.

Tools

HP Quality Center, JIRA, SharePoint, Microsoft office, MS SQL Developer, Confluence

Think Finance (Amtex Systems) from Mar’2013 – July'2013

Client

Think Finance (at Fort worth TX)

Project Description

Financial Product Implementations: Think Finance develops financial solutions to meet the unique needs of under banked consumers. Worked on implementation of Loan Origination / Loan Servicing products some of which are delivered directly to consumers by Think Finance and some are owned by financial partners who use our technology to create and deliver leading products.

Responsibilities

QA Test Lead:

• Coordinating with Business Clients and 3rd Party for Product Implementation and Requirement Understanding.

• Day to Day QA Activities

• Defects management activities and Issue tracking

• Mobile Testing for application product “Payday1”- iOS, Androids and iPhones, iPad.

• Implemented financial products to bridge gap between payday loans and credit cards – RISE and Payday1

Tools

HP Quality Center 10.0, Target Process, SharePoint, Microsoft office, MS SQL Server management Studio, DNN, Message finder, Responsinator, Browsera, Mobile testing on Androids, iPhone, iPad.

ACCENTURE (ARTECHINFO) from OCT’2012 – FEB'2013

Client

FANNIE MAE (San Antonio)

Project Description

CASH Portfolio and handling three applications in it TCM, GPP and Actimize with the sole responsibility as a test lead for TCM – Treasury Cash Management.

Was involved in the Regression for TCM and Application Interface testing with the different Portfolios within Fannie Mae. Worked on Web Services testing of TCM and GPP.

Responsibilities

QA Lead:

• Working in agile based scrum team model

• Quality deliverables and Ownership of various releases, Daily Status meetings for all the applications,

• Sending the Reports from Clear View v4.0 to stakeholders

• QA Metrics and Release plan.

Tools

HP Quality Center 10.0, Toad For Oracle 9.5, Putty, SOAPUI pro 4.5, XML

WELLS FARGO (COLLABERA) - San Antonio, TX from April’2011 – Oct’2012

Client

WELLS FARGO

Project Description

SIT in Loss Mitigation “HAMP and MAP program” and Short Sales.

Project revolved around the Treasury’s Home Affordable Modification Program (HAMP) and Mortgage Assistance Program (MAP). The objective of HAMP is to create an affordable housing payment by modifying terms of the loan, for borrower(s) in default or in imminent danger of default.

Responsibilities

QA Analyst:

• Test Plans, traceability matrix, test case design and review, Test Execution.

• Identifying, prioritizing and resolving defects and tracking of defects

• Requirement Analysis, Effort Estimation, Scheduling & Planning

• Daily Reporting to all stakeholders.

• Onsite offshore coordination

• Managed a multi-vendor QA team

Tools

Quality Center 11.0, Rally, CPI- Mainframe, Microsoft SQL Server 2008.

Citibank (MODIS) - San Antonio, TX from Feb’2011 – April’2011

Client

Citibank

Project Description

Citibank retail banking web application - Retail banking Application: Citibank, a major international bank, is the consumer banking arm of financial services giant Citigroup. Citigroup is the third largest bank holding company in the United States by total assets.

Roles and Responsibilities

QA Analyst – Day to Day QA activities, Citibank’s Retail Banking Application: Team lead for a team of 6 entrée level Testers. Team was responsible for Test designing and Test execution for enhancement.

Tools

Quality Center 9.2, SQL Server 2000

CVM Solutions (Chicago, IL) from July'2010 – Oct’2010

Client

Morgan Stanley, BNY Mellon, T-Mobile.

Project Description

Data Enrichment Project - Clients give CVM their entire supplier list for enrichment and CVM append & update data to those suppliers returned in the Annual enrichment.

I worked as QA Analyst (Data Integration Testing) with the key responsibility of delivering the final data product to the customer, Responsible for maintaining QA Knowledge bank

Role and Responsibilities

QA Analyst: Onsite Co-coordinator:

Day to Day QA Activity, Worked on multiple projects at one time, worked on SQL scripts for Backend testing and frontend Data validations, assigned Tasks to Offshore team

Tools

PENTAHO, MS SQL Server 2000, Visual Safe Source, Excel

Tata Consultancy Services (Gurgaon, India) from Apr’08 – Feb’10

Client

CVS Pharmacy

Project Description

TPMS (Third Party Management System) is a retail domain project of CVS Pharmacy. CVS wanted to implement Third Party Management System (TPMS) in their pharmaceutical stores. Covers functionality from a customer taking a medicine and bank making Payer issuing the instructions to the Bank is covered under TPMS.

Role and Responsibilities

Test Engineer Offshore Team Member - Onshore coordination, Database Testing of PL/SQL batches (packages, stored procedures, functions, common routines, SQL queries, views), also involved in Performance engineering and performance Tuning of the PL/SQL codes, comparison between pre and post changes run statistics of the batches, looking for the culprit queries in batches, looking into tkprofs and AWR reports.

Tools

QC 9.2, PL/SQL Developer, TOAD, PUTTY, Tortoise SVN, LINUX

Personal Details

Date of Birth : 11-18-1985

Work Authorization : EAD: Authorized to work on W2. No visa sponsorship required.



Contact this candidate