Tarun Navlani
****************@*****.***
PROFESSIONAL SUMMARY
Ten years of experience in in all system development lifecycle aspects (design, development, implementation of test plans, test cases and test processes and executing them.
Strong knowledge of all phases of Software Development Life Cycle (SDLC) and Bug Life Cycle (BLC).
Experience in Functional Testing, Agile Testing, Regression Testing and Integration Testing and expertise in developing Test Estimations, Test Plans, Test Cases/Scenarios, Test Procedures
Worked in various domains of industry i.e. Oil & Gas, Healthcare, Hospitality, and Manufacturing & Media. .
Worked in Onsite, Offshore and Onshore model
Experience in Automation – PeopleSoft Test Frame Work
Lead team for End to end delivery from test planning through production launch
Involved in designing, implementing, executing and maintaining test plans and test strategies
Monitoring and generating defects report throughout each testing cycle for tracking and reporting
Leading the effort in design and code coverage analysis to evaluate and improve efficiency and coverage of product test strategy
Creating guidelines for determining the scope and types of testing required for various types of major, minor and maintenance releases
Ability to work with offshore team to integrate the test results for Production releases and supports as needed
Ability to manage multiple projects concurrently
Develops metrics for assessing the quality of delivered project, analyzes trends, researches anomalies and summarizes findings
Demonstrates strong communication skills. This would include raising release issues and risks, with resolution strategies for more senior managers to make informed and accurate decisions
Strong experience in converting Business requirements into Test cases & executing same
Worked for different ERP applications i.e. PEOPLESOFT, MICROSOFT DYNAMIC’S & MACONOMY.
Experienced in training and mentoring other team players.
Experience with various Defect Management and Bug Reporting tools including Quality Centre(HPQC), JIRA & RALLY
Excellent communication skills including listening and observation, interviewing / questioning, meeting facilitation and writing skills.
Excellent analytical and problem-solving skills, planning and organizational skills and strong interpersonal skills
Good experience in SQL queries and TOAD.
Excellent analytical and problem solving abilities and writing Test Scripts.
TECHNICAL SKILLS
Testing Tools
Mercury Test Director/HP Quality Center, Rational Clear Quest, QTP, Win runner
Languages
People Code, SQR, SQL, PL SQL
Technology
People Tools, Crystal Reports, Oracle 8i/9i/10g, SQL Server 2000, SQR, Data Mover
Operating Systems
Unix, MS-DOS, Linux, Windows NT/2000/XP
PeopleSoft Modules
Billing, Accounts Receivables, Accounts Payables, Order Management, e-Procurement, Expenses, Purchasing, Inventory and General Ledger
Reporting Tools
PS/Query, Crystal Report, SQR Reports
EDUCATION
M.S. Software Engineering (Dec- 2007) (University Of Houston – Clear Lake) GPA (3.7/4.0)
B.E. Computer Science – India (70% / 100%) (Jun- 2005) (RGPV)
VISA STATUS
GREEN CARD HOLDER
PROFESSIONAL EXPERIENCE
Company: Noble Soft Solutions
Client:UHG, Minneapolis, MNDomain – Health CareJul 2015 – Jan 2018
Role: – FIN/SCM (QA Manger/Lead)
Serve as a subject-matter expert in Finance IT QA arena
Liaison between functional teams and ensuring the Integration testing activities are carried out from PSOFT to Integrated systems
Provide effort estimates and Planning
Worked in Agile methodology
Migration of project from Waterfall to AGILE
Planning and allocating resources for multiple projects.
Leading the Test efforts
Identified Regression Scripts for Automation
Performed Automation by PTF.
Leading Defect Management calls
Total Test management for the Project and tracking activities to completion and managing Issues and Risk that occur during the Pre and Post Upgrade testing.
Did End-to-End Testing of BI, AR, PC and Contracts Module.
Interacted with Business teams & Developers to understand business requirements and bug fixes
Monitor and provide daily status on test execution progress with HPQC.
Lead multiple PeopleSoft projects in parallel.
Worked closely with business to set QA goals, requirements and architecture of the project
Did Analysis and reviews of Test Strategy/ Scenario/Scripts with business and IT
Lead off shore team (5-Members) to meet quality standards and deadlines
Tracked defects in Quality Center/Test director and recorded results in Test Execution reports.
Environment: PeopleSoft Financials 9.2, Oracle 10gi, Modules: PC, AR, BI, PC,People Tools 8.51, Application Engine, Crystal Reports, SQR, PS/Query & People code, QTP 9.0
Company: Noble Soft Solutions
Client:RHI, San Ramon, CADomain – StaffingMar 2015 – Jun 2015
Role: – FIN/SCM (QA Lead)
Did fit gap sessions for MACONOMY (ERP system) for specific modules in relation to PSOFT.
Analyzed requirements across modules to identify acceptance criteria, testing cases and test scenarios
Tested software to ensure that developed products meet requirement specifications and are within quality criteria and standards
Leading Project to AGILE from Waterfall
Provide feedback to manager regarding development and process optimizations.
Work closely with development teams to ensure quality testing practices are incorporated across the development cycle
Write test documentation such as test cases, scenarios, create test data and identify defects within the software products
Proactively initiate, develop, and maintain effective working relationships with team members
Provide status reports to manager in the required frequency.
Designed, Developed and executed Test Scripts for Projects, Billing, AR, BI, GL & AP Quality Center/Test Director.
Environment:MACONOMY 2.2 Oracle 10g
Company: Noble Soft Solutions
Client:BCBSA, Chicago, ILDomain – Health CareAug 2014 – Dec 2014
Role: – FIN/SCM (Sr. ERP QA Analyst/Lead)
Did fit gap sessions for AR, BI, AP, GBP (Customized), workflow and GL Quality modules.
Created scope document, fit/gap documentation and communication plan for project initiation.
Tackled PeopleSoft related issues such as functional elements that originally did not fit into the client’s business process.
Functioned as a Test Management Lead in managing Manual, Automation and Performance test teams both at onsite and Offshore and estimation planning of resources in the team based on the scope of work.
Identified Regression Scripts for Automation
Performed Automation by PTF.
Requirement Analysis and maintaining Requirements Trace matrix and Preparation of Test scenario /Test Cases /Test Data, MS Team Site is used for maintaining the documents
Defect Management and Test Execution in Quality center/Test Summary Preparation
Worked in Agile methodology
Developed test plans for integrated testing of Purchasing AR, BI and WORKFLOW modules to GL
Project Planning and allocating resources and tracking project progress.
Preparing Test Plan and test metrics& reviewing the Test Cases and approving the same
Responsible for Data Identification and Data Conditioning to meet new Functional Requirements
Tracked defects in Quality Center/Test director and recorded results in Test Execution reports
Environment: PeopleSoft Financials 9.1, People Tools 8.51, People Code, Oracle 10g, SQR, Crystal Reports, Clear quest, Quality Center 9.5
Company: Noble Soft Solutions
Client:Chicago Tribune, ChicagoDomain – MediaMay 13 - Aug14
Role: – FIN/SCM (Sr. ERP QA Analyst)
Worked closely with development team, business users and implementation partners to scope the requirements and to review the Functional Requirement documents.
Lead and managed all phases of testing including test plan, test strategy, test effort estimation. Test results and test closures.
Analyzed Business and System Requirements for gap analysis. Suggested different aspects of feature’s functionality.
Worked in Agile methodology
Prepared and reviewed Test scenarios and test case.
Performed Functional, Integration and GUI Testing.
Automated the screen shots using an inbuilt recorder in the MS Dynamics AX 2009.
Discussed the issues arising out of testing with the development team.
Tracked requirements using RTM to check the completeness of testing.
Attended weekly defect report meetings and presented progress updates.
Helped business users to create test data while User Acceptance testing (UAT).
Environment: MS dynamics AX 2009,, .net, Ajax, MS SQL Server 2008, SharePoint 2007, VSS 1.6, MS Excel 2007
Company: Noble Soft Solutions
Client:Aon Hewitt, Chicago, ILDomain – HCM ConsultingJan 13 - Feb 13
Role: – FIN/SCM (Sr. ERP QA Analyst)
Lead the UAT test efforts
Contribute and Improve QA process, procedures and methodologies
Manage all aspects of the QA project life cycle, and work with team members to oversee all phases of project completion.
Rigorously manage QA scope to ensure quality deliverables are achieved within agreed upon time, cost, and quality parameters.
Recorded and reported defects via Mercury Quality Center/Test Director and worked with business analysts and technical developer to resolve discrepancies.
Environment: PeopleSoft Financials 9.1, Oracle 10gi, Modules: AP, AR, GL, AP, Project Costing, INV, People Tools 8.51, Application Engine, Crystal Reports, SQR, PS/Query & People code, QTP 9.0
Company: Noble Soft Solutions
Client:Hilton, McLean, VADomain – HospitalityAug 12 - Dec 12
Role: – FIN/SCM (Sr. ERP QA Analyst)
Developed test cases and execute test scenarios for PeopleSoft Financials 9.0 Reimplementation Project
Recorded and reported defects via Mercury Quality Center/Test Director and worked with business analysts and technical developer to resolve discrepancies.
Created test scripts/test plans for enhancements or fixes to the PeopleSoft Financials applications
Write, maintain, and support a variety of reports or queries utilizing the reporting tool TOAD – SQL editor PL/SQL
Performed black box, negative tests, etc. of new objects added to QA database before migration to UAT environment.
Worked in Agile methodology
Ensured that various record counts reconciled between QA, Stage and Production databases
Involved in setting priority of defects; low, medium, high, critical.
Worked with end users in UAT in a lab by providing guidance where necessary, to ensure the correct execution of test scripts and resolved minor processing errors caused by users.
Adjusted test data in Spreadsheet and SQL scripts where necessary to vary the input test data for negative test and integration testing.
Assisted end users with the acceptance testing (UAT) by providing guidance where necessary to ensure correct execution of test scripts, and helped to resolve minor processing errors caused by users.
Assisted Automation programmer to develop Quick Test Pro scripts, using Manual scripts from functional testing.
Wrote test scripts for PeopleSoft Financial modules (and assisted in automating scripts using Quick Test Pro.
Performed black box, negative tests, etc. of new objects added to QA database before migration to UAT environment. Ensured that various record counts reconciled between QA, Stage and Production databases
Environment: PeopleSoft Financials 9.0, Oracle 10gi, Modules: AP, AR, GL, AP, Project Costing, INV, People Tools 8.49, Application Engine, Crystal Reports, SQR, PS/Query &People code, QTP 9.0, Test Director 8.2
Company: Noble Soft Solutions
Client:Navistar, Schaumburg, ILDomain – ManufacturingFeb 12 – Jul 12
Role: – FIN/SCM (Sr. ERP QA Analyst)
Responsibilities:
Did fit gap sessions for AR &Billing Quality modules .
Created scope document, fit/gap documentation and communication plan for project initiation.
Tackled PeopleSoft related issues such as functional elements that originally did not fit into the client’s business process.
Performing Functional Testing, Integration Testing, System Testing, Exploratory Testing, Performance Testing and Regression Testing, Localization Testing
Coordinating in administering and managing the bugs in Defect Tracking Tool
Tested GLcustomized process for conversion of Journal entries from legacy system.
Designed, Developed and executed Test Scripts for Projects, Billing, AR, AP, Purchasing, e-Pro modules in Quality Center/Test Director.
Tracked defects in Quality Center/Test director and recorded results in Test Execution reports.
Tracked Test execution results via Traceability Matrix in QC and Excel.
Assisted clients in UAT Testing with scripting, test data and environmental issues.
Involved in documentation and client demos for new functionality.
Used SQL queries in TOAD tool to test data populated by PeopleSoft AR, Purchasing and Billing Processes.
Successful in working as a team player for large initiatives and individually for ad-hoc projects.
Environment: PeopleSoft Financials 8.0/9.0, Oracle 10gi, Modules: AP, AR, GL, AP, PO, INV, People Tools 8.49, Application Engine, Crystal Reports, SQR, PS/Query &People code, QTP 9.0
Company: Noble Soft Solutions
Client:Trinet, Bradenton, FLDomain –HR ServicesOct 10– Feb 12
Role: – FIN/SCM (Sr. ERP QA Analyst)
QA Analyst on the PeopleSoft Payroll Process Improvement project on HCM suite version 8.8 and Core HRMS.
Modules tested included Payroll processing, Retroactive Payroll, Direct Deposit, Time & Attendance, and Payroll Setup data validations.
Analyzed requirements to develop manual test scripts.
Participated in Project meetings for requirements walk-through, scheduling, progress meetings and general test planning and strategy for the HRMS
Developed Test scripts for additional processes in PS Payroll such as pay sheet creation, payroll calculation and payroll confirmation.
Verified expected results with super users.
Responsible for testing various customized Business Processes, Reports and Interfaces.
Executed manual scripts for regression test of PeopleSoft payroll setup tables such as direct deposit setup, union dues setup and general deduction setup.
Wrote test scripts for the PS payroll 8.8 to include the new navigations not in 8.3.
Conducted UAT for Payroll users, providing Test scripts and ensuring that projects were successfully migrated to Production by running data count script and reconciled reports
Utilized PS Query and SQL Plus to generate test data and auditing reports during test validations.
Used Test Director to log in defects record defects severity and status such as new, open, fixed, custom bugs, delivered bugs, and PeopleSoft issues, etc.
Environment: PeopleSoftHRMS 8.8,People Tools 8.45, SQL Server 2000
Company: Noble Soft Solutions
Client:Blue Cross Blue Shield, Jacksonville, FLDomain – Health Care Jan10 – Sep 10
Role: – FIN/SCM (Sr. ERP QA Analyst)
Designed, Developed and executed Test Scripts for AP, Purchasing, e-Pro modules in Quality Center/Test Director.
Experienced in designing Modular Test Scripts to enhance reusability.
Tracked defects in Quality Center/Test director and recorded results in Test Execution reports.
Organized defect review calls.
Tracked Test execution results via Traceability Matrix in QC and Excel.
Write, maintain, and support a variety of reports or queries utilizing the reporting tool TOAD – SQL editor PL/SQL
Conducted systems, QA, integration and acceptance testing for various PeopleSoft Financials projects, applications enhancements and fixes
Did End to End Testing of Procure to Pay cycle
Interacted with Business teams & Developers to understand business requirements and bug fixes
Executed manual test scripts for various scenarios such as Matching, Different Amount of Requisitions and approvals and recording defects and actual results for analysis
Tested the functionality of new enhancements to on-line and batch objects in various modules of PeopleSoft Financials to ensure that program performance met requirements and produced data validated against production objects.
Environment: PeopleSoft Financials 9.1, People Tools 8.49, People Code, Oracle 10g, SQR, Crystal Reports. Testing Tools: HP Quality Center 9.5
Company: Noble Soft Solutions
Client:EXELON, Chicago, ILDomain – Oil &GasApr 09 – Dec09
Role: – FIN/SCM (ERP QA Analyst)
Prepared Test case and reviewed, executed the Test Cases for the application.
Used Quality center for test management and Bug tracking.
Performed functional, system, regression and integration testing.
Tracked defects to closure and regularly sent the testing progress status report.
Regularly tracked test efficiency and performed test closure activities.
Environment: PeopleSoft Financials 8.0/9.0, Oracle 10gi, Modules: AP, AR, GL, AP, PO, INV, People Tools 8.49, Application Engine, Crystal Reports, SQR, PS/Query &People code, QTP 9.0,
Test Director 8.2
Company: Noble Soft Solutions
Client:Kendle International, Cincinnati, OHDomain – Pharmacy Jan 08 – Mar 09
Role: – FIN/SCM (Sr. ERP QA Analyst)
Attended meetings and walkthroughs for project updates.
Researched testing errors for resolution as Functional analyst and recommended appropriate course of action where applicable for making adjustments to test data.
Used Excel to create test data, export data from PeopleSoft into spreadsheet.
Adjusted test data in Spreadsheet and SQL scripts where necessary to vary the input test data for negative test and integration testing.
Assisted end users with the acceptance testing (UAT) by providing guidance where necessary to ensure correct execution of test scripts, and helped to resolve minor processing errors caused by users.
Involved in setting priority of defects; low, medium, high.
Worked closely with end users and business owners in reviewing documents and getting Sign off on all QA testing documents such as Test Strategy, Test Plans, Test Case and UAT Test scripts.
Performed various tests on PS Financials including functional, integration and unit testing for customize processes
Worked closely with QA Manager and Project Manager in managing Test schedules, setting priorities and managing deadlines and testing issues.
Used PeopleSoft Query to select Test subjects and downloaded to Excel for documentation of data for test auditing.
Environment: PeopleSoft Financials 8.4, SQL Server 2000, Modules: AP, GL, AR, BI, INV, PO, People tools 8.43,Application Engine, PL/SQL, SQR, PS/Query &People code