Business Analyst Third-Party

Leonard Rangel

**** *** ******** ******, ****** California 92882 Home Cell 951-***-****

Email: *************@********.***

Career at a Glance:

Over 20 years of Business/IT consulting and QA/UAT expertise of managing experience on-shore/off-shore in Business/IT liaison operations.

Professional Business analyst in creating Business Use Cases, Writing, reviewing, and testing Business Use Cases, and Business/Design requirements for Production Support, and UAT.

Extensive expertise in managing SAAS, COTS, and third-party vendor applications.

Experience in testing web, client server, mainframe, Tandem, Palm, iOS iPhone/iPad, Android Tablet/Phone, & Kindle applications.

Assist BSA with review and redesign of UI/UX on mobile devices (iOS and Android) and web applications

Manage defect triage meetings using an array of various defect-tracking tools (Jira, HP ALM/Quality Center, SilkCentral, qTest Manager, FogBugz, etc.)

Execute test cases utilizing a variety of manual testing technologies (HP ALM/Quality Center, Jira, SilkCentral, qTest Manager, Serena etc.).

In depth experience with Verification and Validation per FDA policies and Regulatory adherence that govern IT Detailed Operating Procedure (DOP) and Standard Operating Procedures (SOP).

Dynamic leadership experience in business/IT liaison, project management, LOE (level of efforts) system assurance projects, production support, and UAT.

Outstanding presentation skills reporting to Business Steering Committee (PowerPoint, Excel, Word)

Extensive expertise in the field of pharmaceutical, banking/finance consumer/business credit information, health care, entertainment industry and utility.

Application experience in SAAS, COTS, Customize third-party application, JSON, JAVA, .ASP, .NET, HTML, UNIX, LINUX, Cold Fusion

Continuously practice and improve in managing Systems Quality Assurance and UAT (Agile, Waterfall).

BUSINESS/TECHNICAL EXPERIENCE:

07/21-Present System Owner Business/IT Coordinator-Consultant-Contract

AstraZeneca Pharmaceutical-Patient Safety/Rangam Consulting -Somerset, New Jersey

Manage Software as a Service (SAAS) application from third-party vendor (Cognizant) to assure business requirements, epic, user stories, RAID log, and SLA are transparent and committed per contractual agreement for SAM (Smarter Agreement Management) application

Oversee third-party contract assessment with costs, resource allocation for development and QA resources and timeline of project commences and completion date

Facilitate bi-weekly standup meetings with Cognizant and business stakeholders reviewing and manage risks and issues logs during integration process with vendor

Assist Cognizant as a Product Owner during sprint planning and determining what user stories are incorporated during each sprint cycle per business needs

Oversee UK, Sweden, and India resources for business stakeholders and IT operations in decommissioning of former Software as a Service (SAAS) application SAM GxP (Smarter Agreement Management) from third party vendor (Cognizant)

Constructed decommissioning planning and timeline with (Cognizant) to proceed with the replacement of our external application SAM (Smarter Agreement Management)

Coordinate weekly conference calls with Cognizant management and senior business stakeholders and resources to determine that AZ deadline is being achieved

Create weekly Risk Assessment report to AZ management and business stakeholders per data migration, overall testing strategy, test metrics, defect accountability, and UAT progress reports from Cognizant

Delivered weekly status report to the business stakeholder current impediments and milestone accomplishments per third party vendor Cognizant

Review all artifacts and approve from Cognizant (JSON data migration, testing effort, UAT,) that are required per FDA guidelines

Create required FDA documentation for AZ to comply with all mandatory regulatory (GxP) for decommissioning of SAM application per SOP

Outline plan for Cognizant in assuring all data from AZ will not be compromised per organization requirements

Planned and schedule internal AZ resources for UAT to test data integrity from Cognizant deliverables

Create UAT test cases to assure Cognizant data has not been compromised using frontend UI data validation, end to end, functional, module-module, negative testing, backend data validation testing, and postproduction testing efforts

Facilitate daily defect triage meeting with UAT resources

Communicate with Cognizant in UAT defects accountability and recommend priority and severity level

Smoke test each build received from Cognizant prior to release in Staging environment

Train UAT users in how to create defects in Jira v9.4.5

Liaison for Business and IT offshore team in developing Pharmacovigilance Agreements Listings (PAL) application for the replacement of SAM (Smarter Agreement Management)

Oversee Project management, development, QA, and UAT resources per Agile methodology

Conducted daily standup meetings with the business, project manager, development, and QA teams

Create weekly RAID log (risks, assumptions, issues, dependencies) for business stakeholders during project assessment

Facilitate RACI (responsible, accountable, consulted, informed) meetings with IT and business partnership committee

Participated in assisting the business team in creating user stories using Jira application

Assisted Scrum master with story pointing and prioritizing what user stories will be included in each 2-week sprint cycle

Review and approve QA resources test cases and assuring that the requirements are meeting the scope of the test case

Review and approve test results and defect management reporting

Create Disaster & Recovering documentation per SOP and FDA regulations

Coordinate weekly defect triage meetings with business, development, and QA teams

Submit weekly progress and status reports to the business steering committee

Created UAT test cases for business users and trained how to execute and report defects using Jira

Coordinate post-production implementation/testing with project manager and developers

Utilize Veeva Vault 24R2 for document upload, review, approvals and version control

Continually building PAL application for future enhancements via the “wish list” from the business stakeholders

Investigated all CAPA findings internal and external from IT and business ownership

Provided RCA (root cause analysis) per CAPA findings regarding PAL application

Facilitate meetings with business and IT senior management per resolutions and “best practices” to avoid repeatable CAPA findings

Thriving to succeed and improve the work process flow from an application design perspective

Provide feedback in how we can advance the application by utilizing technology that will go above and beyond the business stakeholders expectation

09/19-12/20 Business Liaison and Test Manager Coordinator-Consultant-Contract

Southern California Edison/Judge Group-Pomona, California

Test Manager Coordinator for onshore/offshore team managing QA resources for AutoCAD 2019 Commercial off-the-shelf (COTS) application with third-party vendor

Create business functional requirements and integration, Test Plan, resource allocation, and level of efforts (LOE) per project requirement

Create weekly Risk Assessment report to management and business stakeholders

Manage weekly status meetings with third-party vendor, onshore QA test leads (functional and integration) testing progress and impediments

Review business requirements with third-party vendor and QA resources, business stakeholders

Facilitate weekly defect triage meetings with third-party vendor QA resources, developers, PMO, trainers, business stakeholders in communicating all assigned defects, defect count, roadblocks, and test execution progress utilizing HP-ALM (QC-Ver 12) test execution and defect repository reports

Review and approved test cases traceability for QA resources per business requirements

utilizing HP-ALM (QC-Ver 12)

Review and approved test case execution results from QA resources using Skype media video as their proof of validation

Utilize HP-ALM (QC-Ver 12) to import test scripts and business requirements using Excel plugin

Produce weekly reports to PMO and senior management on testing progress and defect management life cycle

Coordinate newly release build per smoke testing and advise infrastructure team to accept or reject build based on regression team results

Oversee business requirements that are ambiguous and or inconsistent with the scope of the module depicted

Instructed QA resources in proper defect reporting that are transparent to the development group and business stakeholders

Oversee Citrix execution and discrepancies with the Citrix team per performance issues and defects encountered

Assist the training group with instructional videos per pre-release on “how to” use AUD 2019

Create end-to-end test case scenarios for QA resources for AUD 2019

Assist QA resources to create negative test scenarios per functional modules and permissions

Convert E2E test scripts into UAT high level business scenarios

Train UAT group regarding test execution, reporting defects, and time management of UAT test cases

Facilitate UAT defect triage meetings with developers, QA team and business stakeholders

12/18-09/19 International UAT Lead Coordinator-US, UK, & Japan/Consultant-Contract

Sony Interactive Entertainment/R-Systems Consulting-Los Angeles, California

Create UAT test cases for Promotions Financial application from Feature stories via Jira and assigned story points

Facilitate training via WebEx for all regions on how to use qTest Manager Test execution and Jira defect management for new employees of the UAT team

Conduct daily defect triage meetings with UAT resources, developers, BSA’s and PMO identifying any high-risk defects, roadblocks, concerns, and tracking execution progress

Create user Id’s, set permissions per business requirements matrix

Cross reference user Id’s permissions based on negative UAT cases

Distribute UAT test cases to all 3 regions as well as keeping track of project test schedule

Conducted regional meetings with UAT resources for work around fixes that is road blocking testing efforts

Reviewed test cases execution from UAT resources to determine if the test case was effectively executed

Cross browser verification testing

Generate daily metrics report on how many defects have been resolved and needing re-execution of test case to determine Fix-Verified

Reviewed UAT resources defects to assure the defect was written appropriately and the defect reported is not a false-positive

Request data refresh prior to UAT start date

Personally dry run UAT cases to assure environment is working by designed

Utilized Jira Kanban Board to demonstrate progress of open defects reported

Coordinate with PMO and business stakeholders to alert if more days will be needed to complete UAT schedule testing efforts

Create “Lessons Learned-Best Practices” presentation after UAT completion

10/17-10/18 QA Manager Test Coordinator-Regression Mobile/Consultant-Contract

Bank of America/Collabra Consulting-San Francisco, California

Lead iOS and Android mobile device testing efforts for onshore/offshore regression team for consumer and business customers banking mobile application

Create test plan, test schedule, plan resource allocations, test case distribution per project timeline schedule

Create test cases based on credit card payment and reverse credit per purchases made through mobile device testing using backend/frontend verification process

Test “Reward Program” icons displayed on the user account homepage (Home Depot, Starbucks, Macy, Subway etc.)

Create end to end test scenarios on Reward Program percentage discount using calendar modification/configuration based on date/month of discount applied

Validate the correct percentage discount reward is accurate using MS-SQL and user report to reconcile the proper percentage was given to its member

Execute job process to push APN and or Android alert notification for payment alert and delinquent reminder

Work with Development team to execute job process for alerts per APN and Android, based on 30,60, and 90-day notification

Daily stand-up calls with offshore team identifying any roadblocks, concerns, tracking progress

of daily test execution using HP-ALM (QC-Ver 10)

Distribute regression test cases via HP-ALM (QC-Ver 10) to onshore team in keeping track of project test schedule when offshore falls behind testing efforts

Assist in data conditioning for user Id’s that are part of test case pre-condition

Run daily metrics of total percentage completion of testing efforts, daily number of tests executed, failed, passed, and N/A to Project Management daily standup meeting per HP-ALM (QC-Ver 10)

Execute ‘shakeout’ testing prior to new builds with option to accept/reject build

Utilize HP-ALM (QC-Ver 10) for test case creation, execute, and defect management life cycle

Review defect report and identify that all mandatory fields are properly assigned and steps to recreate scenario are clear and concise

Validate proper error handling messages for all mobile devices during “degrade mode” testing

Create and present KT (knowledge transfer) sessions to new resources on B of A mobile application

Apply B of A proprietary debugging tool to further research issues within the application and attach to defect report

Collaborate with Business Analyst on UI/UX design during project kick-off meetings

Asist Spanish resources and team lead proper direction in test execution with limited resources located in TX

Utilized SharePoint for version control of all documentations

Create UAT test cases for business community based on user roles & privileges

Create UAT user Id’s and test data environment

Assist UAT users with questions on test case execution and creating defect report

11/16-06/17 SR. QA Analyst

Peregrine Pharmaceuticals-Tustin, California

Perform Verification and Validation COTS Microsoft Dynamics AX-R3 application per

FDA and regulatory compliance guidelines

Generate Microsoft Dynamics CRM AX-R3 Verification test plan and test strategy report

per QA/FDA guidelines

Create Verification Test Specification report based on test case Id, requirement traceability, title, and summary of test cases objectives

Report defects via Excel defect tracking spreadsheet

Produce AX-R3 user “how to” work scenarios for new and existing employees in the purchasing and manufacturing department

Create user profiles and privileges per preconditions of test case and UAT test execution

Construct test case scenarios positive, negative, end to end, and regression suite

Facilitate weekly defect tracking meeting with PM, development and BSA members

Contribute to daily stand-up meetings regarding metrics of execution (pass/fail) roadblocks etc.

Coordinate with BSA regarding requirements that are ambiguous or undefined

Smoke test newly builds in QA environment to determine accept/reject build

Fix-verify defects that are included in builds and regression test affected areas

Review and approve test cases from QA resources that meet the scope of the test requirement

Randomly review open defects and determine if severity and priority of defect are aligned

Store all documentation and version control via SharePoint

Investigate and create Deviation Report (DR) and Incident Report (IR) per FDA and corporate guidelines for IT department

Utilize CRM Veeva Vault for SOP required training

Perform testing on production support defects (fix/verified)

08/13-10/16 QA Lead Mobile/Consultant-Contract

Freedom Innovations/Elevano Consulting-Irvine, California

Lead iOS and Android Validation mobile device testing efforts for Kinnex and GaitLab prosthetic device application for clinical trial amputees in an FDA regulatory environment

Ensure software Validation procedures are maintained and kept version controlled per FDA regulations

Test embedded Bluetooth communication within prosthetic device using mobile devices

Test adjustments, calibrations, and synchronization via mobile application

Reported defects via Jira defect tracker

Utilized Logcat for defect analysis

Participated with clinical trial with patient using prosthetic device while testing mobile Kinnex application

Perform IQ/OQ written procedure with developer overseeing developer code check in per FDA guidelines

Review, modify, and approve Verification business requirements per project QA schedule

Review UI/UX requirements and recommend better “user experience” in its design flow

Assist BSA in gathering requirements to align with QA “best practices”

Review and approve UAT candidate documentation in accordance with FDA compliance and regulatory policies

Assisted in reviewing and correcting UAT documentation prior to release to FDA formal review

Worked with business stakeholders improving a better user experience design in look and feel of the application and firmware

Conduct weekly status meeting with PM, BSA’s and development group on QA timeline progress

Create daily and weekly QA status reports using MS Excel & PowerPoint for PM and business stakeholders

Utilized SharePoint for version control of all documentations

Lead defect management life cycle meetings with business stakeholders (defect count, severity, fix verification, showstoppers, etc.) using MS Excel

Created and presented “Lesson Learned and Best Practices” via PowerPoint slideshow to entire project team at the end of the project

01/10-07/13 Business and QA Analyst Test Coordinator/Consultant-Contract

Capital Group/Elevate Group-Irvine, California

Accountable for successful execution of QM Coverage $6 million Large Project

Accountable for planning quality approach, business requirements, test design, and execution for investment

Application stock purchase

Review and approves test strategy and test approach per business requirements

Responsible for overall program testing progress and quality metrics using HP-QC V.8.0

Utilized SharePoint for version control of all documentations

Conduct weekly status meeting with PM, BSA’s and development group on QA timeline progress utilizing PowerPoint and MS Excel

Lead defect management life cycle meetings with business stakeholders (defect count, severity, fix verification, showstoppers, etc.) utilizing HP-QC V.8.0

Responsible for aligning CG quality methodology for duration of the project

Collaborates with other QM shared services teams during planning, and in support of the Test Approach (e.g. Performance/Automation and Integration teams, Impacted App QM teams)

Partners with Delivery QM managers for shared QM resources and to align project and BAU release

Leads QM test design and execution activities per the Test Approach, including test scenarios design including expected results using HP-QC V.8.0

Responsible to provide input to quality approach, test design, and execution plan

Coordinate System and/or Sprint effort planning and oversees defect triage meeting

Facilitate resolution of QM related risks, issues, concerns, and escalations

Create and approve resource estimates, scope estimates, and resource plan for 8 resources

First level of escalation for project QM lead

Participate in project leadership and steering committee meetings based on a need basis

Create and actively manage through project delivery lifecycle

06/08-12/09 UAT Mobile Test Lead Coordinator/Consultant-Contract

DIRECTV/Thought Creek – El Segundo, California

UAT Test Lead Coordinator for Digital Entertainment Product Group mobile division department

Conduct weekly status meeting with PM, BSA’s and development group on UAT timeline progress

Lead UAT defect management life cycle meetings with business stakeholders (defect count, severity, fix verification, showstoppers, etc.) using MS Excel

Presented PowerPoint presentation to business community on “best practices” in conducting UAT testing

Created and presented “Lesson Learned and Best Practices” via PowerPoint slideshow to entire project team at the end of each project

Oversee testing resources test execution and defect management

Review UAT end to end test case scenarios and provided correction/feedback to UAT resource

Align UAT schedule of testing with production rollout

Support post-production testing via regression suite of UAT test cases

Create UAT end to end business scenarios for each mobile device application (iPad, iPhone,

Android tablet/phone, and Kindle) testing VOD, CC, Voice Recognition.

Validate “fix-verified” for DIRECTV application for all mobile devices as part of the UAT scope of testing

Install and configure set-top box for end user acceptance testing

Maintain set-top box configuration with wireless network (WI-FI)

Report defects using standardize template and assigned priority level back to QA department

Advise on design changes (UI/UX) to enhance user experience for all mobile applications

Create regression test suite for all mobile devices

Test APN (Apple Push Notification) for alert messaging for Apple and Android devices

Create UAT test cases for CC708 (Close Captioning) governed by the FCC design and business requirements

Implemented a formal UAT Test Plan to move forward toward a more formalize methodology process of improvement

Create a traceability matrix via MS Excel to successfully identify and track the status of defects discovered during UAT cycle

Participate in weekly triage meetings with business stakeholders, QA, and development on current issues discovered during UAT

Report “showstoppers” and conducted conference call to all relevant participants

05/08-01/10 QA Mobile Test Lead Coordinator/Consultant-Contract

Experian Consumer Direct/Ryte Professionals - Irvine, California

Solely manage testing efforts for Experian Consumer Direct Mobile Initiative projects for U.S and United Kingdom

Manage offshore UK testing resources by assigning test case execution, update daily metrics schedule and review of test case execution results

Test Experian commercial service applications using iPhone, iPad, and Android mobile devices per Business Requirements and design

Manage UK testing resources by assigning test case execution, update daily metrics schedule and review of test case execution results

Directed and support testing resources with requirements and design questions

Execute and validate all (SMS) Short Message Service messaging testing on mobile devices utilizing and configuring Control-M job processing

Execute and validate (APN) Apple Push Notification for iPhone and iPad mobile devices

Per conditional alert message (credit inquiry, 30 days late, address change etc.) executing and configuring Control-M job processing

Execute and validate Android Push Notification for Samsung Galaxy phone and tablet

Per conditional alert message (credit inquiry, 30 days late, address change etc.) executing and configuring Control-M job processing

Manually triggered alerts and reconcile that the appropriate SMS was delivered to the specified mobile device/customer profile

Manually triggered alerts and reconcile that the appropriate Alert was delivered to the specified mobile device/customer profile

Perform MS 2010 SQL query to reconcile data backend with user UI information

Validate MO and MT (Mobile-Originated/Mobile-Terminated) services via short code

Test accounting and security settings within customer enrollment mobile process application

Created QA (LOE) Level of Efforts, Test Schedule, Test Plan, and Test Summary report per project basis

Oversee UI/UX with BSA and identify issues that prevent the application to achieve a more user-friendly usage

Report and manage defect lifecycle using Serena-Team Track Ver. 3.01

Conducted daily defect review meetings with project group

Performed and coordinated release management for Android and iOS application

Perform (PLV) Post Launch Verification utilizing Apple App Store and Android Market installation test process

05/06-04/10/09 QA Test Lead Coordinator/Consultant-Contract

Abbott Vascular/ManPower - Temecula, California

QA Test Lead supervising resources for ViewPoint Document Management System developed in JAVA and .ASP Waterfall methodology process

Created Verification and Validation Test Plan, Test Specification, and Test Summary report documentation for review and approved by regulatory/compliance team per FDA guidelines

Responsible for all QA testing Validation activities are adhering to SOP and DOP standards per FDA guidelines

Review and approved Validation test cases per QA resources via SilkCentral 2008

Review and approved Validation test case execution results per QA resources via SilkCentral 2008

Review defect management with QA resources and plan regression-testing accordingly using FogBugz V6.1.13

Assign project cases with estimate of start and completion per QA resources

Mentor and train QA resources on test case development, execution, and defect tracking

Create matrixes for test case execution distribution

Create (LOE) Level of Efforts prior to the inception of each project

Version control all QA documentation using Perforce repository application

Participate in Business Requirement review meetings

Case management and report defects using FogBugz v6.1.13

Create, maintain, and execute test cases using SilkCentral 2008

Perform (IQ/OQ) Install Qualification/Operation Qualification with the development team

Participate in daily standup review meetings

Create test cases that synchronized with (RTM) Requirement Traceability Matrix

Organize and participated integration testing with other departments

Coordinate, review, and approve UAT test cases per FDA guidelines

Utilize MS Visual SourceSafe v.6.0 for test case version control

Piloted, enhanced and vetted new SDLC tools for QA methodology

Coordinate, executed, and supported post-production testing

Incorporate Global System Development Methodology (GSDM) for all projects

EDUCATION: University of La Verne, La Verne, California

Bachelor of Science Degree - Business Organizational Management

Contact this candidate