Patrick Guerrero, CSM
PROFESSIONAL EXPERIENCE
Certified Scrum Master (CSM)
Senior Solution Delivery & Release Manager
Seasoned Business Analyst
Scenario Focused Engineering (SFE) group trainer
ITLC and ITIL methodologies
Highly familiar with Agile methodologies
External and internal customer/partner/vendor communication
Excellent verbal & written communication skills
Skilled meeting facilitator and mediator
Self-motivated, outgoing and professional
Great at removing bottle-necks and roadblocks
TECHNICAL SKILLS
Databases: SQL, Teradata, Cognos
Tools: SharePoint, Remedy, Rational Suite (ClearCase, ClearQuest), Power BI, TFS, VSO, MS Office Suite, Mercury Interactive Tools, VSS, SharePoint Microsoft Office Suite (Project, Visio)
EDUCATION
BA in Personnel Communications, University of Washington
Certified Scrum Master (CSM)
PROFESSIONAL EXPERIENCE
Microsoft
July 2010 – July 2016
Program Manager/Business Analyst/Scrum Master
Microsoft QBE
Served as Scrum Master for an Agile team, promoting the team’s abilities around both rapid deployment and standard sprint ceremonies.
Collaborated with the Solution Architect to develop a business-focused telemetry reporting solution servicing executive level scorecards.
Worked with the Product Owners and Stakeholders to develop and maintain user stories and product backlog.
Maintained communication with key stakeholders regarding requirements, issue resolution/tracking, and schedules.
Managed Visual Studio Online (VSO) for all product backlog and sprint backlog work items.
Worked directly with key stakeholders to create ad-hoc Power BI reports to ensure business rules reacting as designed.
Managed a team of onsite and offshore resources of the development team to perform continual enhancement of the enterprise level telemetry based reporting system.
Microsoft Advertising and Online
Worked with Sales and Business Excellence to document current and future business processes.
Utilized Visio process flows, use cases and SFE fundamentals.
Requirements gathering for reimplementation of upgraded CRM for A&O organization.
Worked with SMEs to streamline business processes through automation and tool functionality.
Documented existing ETLs and data feed from existing systems into new database.
Worked directly with Business on development of UAT testing materials.
Configured business process and workflows within Dynamic CRM.
XBOX Live
Managed and supported intake of server requests; new builds, management, upgrades, and decommissions.
Mapped existing processes and established new business processes based on industry best practices.
Communication of major events, such as major releases and conferences, to a distribution group of 1300+ people.
Tracked and maintained forward schedule of change communication.
Maintained portfolio within TFS.
Provided mentorship, training and direction to approximately 400 TFS users.
Responsible for XBOX Live infrastructure release calendar, deliverables and actions.
Mentorship, training and direction to approximately 400 TFS users.
MSIT Product Activation
Azure implementation for the Remote Desktop Service License Manager (RDSLM) to enable the application for the Windows 8 launch support.
Drove analysis with application owners for Performance Assessment Project of several to-be integrated systems. Managed the team’s creation of data models for the Windows 8 launch forecasts.
Successfully created and released Disaster Recovery and Business Continuity (BCDR) plans and RoB for 13 HBI and MBI applications.
Subject Matter Expert (SME) to ensure best practices were used to facilitate all Disaster Recovery testing, sign offs and risk acceptances by Senior Management.
Drove all system and process requirements through SCRUM methodology.
Re-engineered existing business processes and engineered new processes.
Subject Matter Expert for Product Activation; managed Business Continuity planning to ensure Disaster Recovery and Business Continuity plans were aligned.
Analyzed and identified gaps and recommended solutions.
T-Mobile (Consultant)
Aug. 2008 – Apr. 2009
Business Systems Analyst
Managed and mentored Junior Analysts.
Created functional specifications (FSDs) and test plans for updates to the T-Mobile.com and MyT-Mobile.com eCommerce sites.
Facilitated formal JAD sessions and interviews with project stakeholders to gather, translate and document business and system requirements.
Worked with the engineering team to determine the optimum system solutions within given project parameters (budget, scope and schedule) to satisfy business needs.
Collaborated with Business Program Managers in feature stack-ranking and prioritization exercise.
Responsible for User Acceptance Testing (UAT) and authoring scripts.
Responsible for dotted-line management of offshore engineering team.
Boeing
Mar. 2006 – Jul. 2008
Functional Analyst BCA Finance
Lead Functional Analyst for the BCA Commercial Finance Data Warehouse (CFDW) Finance Reporting Project.
Gathered financial reporting requirements from the Cost Accounting and Financial Planning organizations.
Developed and implemented new audit and performance financial reports, which included a custom user interface for ad-hoc financial queries.
Created and batched provided Asset Management reports and custom data to the BCA Finance organizations.
Facilitated working sessions (JAD) with Business Stakeholders and End Users to develop reporting requirements.
Developed and released the Unit Task Specification (P490s) documentation and prototypes based on enterprise reporting standards.
Assisted in the development and execution of test cases for both Functional Integration and User Acceptance Testing.
Initiated Impact Analysis for all change requests in ClearQuest.
Data Mapping and Data Transformation Analysis utilizing Teradata SQL Assistant and MS Access and produced ad-hoc queries within the Cognos environment.
Functional Analyst (4) - Information Systems
Developed all requirement specifications, use cases, and functional specifications for both the Web-based document configuration tool (CAM) and the Airborne EFB Document Browser Applications for 4 release cycles.
Created and drove test cases, UAT, regression testing issue resolution, risk mitigation and new enhancement requests.
Performed all QA duties, and developing all reporting metrics reports within ClearQuest for management review.
Worked directly with QA group to develop an improve defect discovery and resolution process for all EFB project teams.
Provided SME level project support for testing and development activities for the EFB Document Browser.
Knowledge management within the Rational ClearCase system for QA review.
Washington Mutual, WA
Mar. 2004 – Mar. 2006
Technical Analyst II
Analyzed and tested Teller software for checking, savings, and money market processes.
Collaborated with the Business and End-Users to develop accurate, value added requirements for system and business process enhancements.
Developed functional requirements (BRDs and FSDs) for hand-off to the engineering team.
Created and drove: test cases, UAT, regression testing issue resolution, risk mitigation and new enhancement requests.
Performed gap analysis on RFP’s and hardware specifications for an enterprise wide implementation of a signature capture device.
Created process flows for in-scope transactions and all interdependent offsets.
Performed unit, functional, smoke, assembly, and regression tests on monetary systems for all projects.
Knowledge management: artifacts, processes, defect tracking, training materials, test script validation.
Technical and QA Analyst
Performed Manual, Unit, Functional, Smoke, Assembly, and Regression Testing on LoanWorks XP.
Validated the functionality of LoanWorks on XP against OS/2 and Mainframe MTAI, MTUP, MTLL, and MT applications.
Performed Integration Testing to evaluate the interdependencies between components.
Assisted with improvement in quality standards and procedures to be followed during validation.
Created and followed the test plan for LoanWorks.
Created end-to-end scripts based on use cases and as per functional specifications.
Created and executed reusable target scripts per screen specifications.
Analyzed business requirements and technical specifications for validation with LoanWorks XP.
Performed defect tracking using Lotus Notes.
Interacted with Business Analysts and provided recommendations to close gaps between the Legacy system and the new XP product.
Communicated with the Network team to resolve issues with testing environment.
Documented testing results to discuss in regular meetings the outcomes, resolutions, and enhanced testing process.