Product Owner Business Analyst
Resume:
Scott Carmichael Hill
ad2t1j@r.postjobfree.com
Current Location: Vancouver, WA
Interview availability: Phone/ In-Person
LinkedIn: linkedin.com/in/scott-hill-4b9527115
Recruiters’ Summary:
Product Management Professional holding extensive years of experience working as SAFe Product Owner/Business Analyst and has been analyzing and evaluating business systems, processes and customer use cases while working with business partners to gather functional requirements to assess current state vs. future state analysis. Developing analytic reports, metrics, and data extracts in collaboration with Supply Chain leadership and other departments working within an agile environment and, creating new user experience websites by upgrading back-end portal and portlet services. Liaised between business groups (clients) and IT development staff and worked with developers to translate functional requirements into technical design performing various levels of application testing and ensured system produces correct results. Experience in analyzing vendor contracts, supply chain inventory and financial uploads using Cloud-Suite based products.
Summary:
18 years IT professional experience with emphasis on business analysis, product owner, finance, and project management
9 years of experience working in a Product Management capacity featuring SAFe Agile & Scrum ceremonies.
Created automated processes in Excel, Word, Access, and Database analysis.
10 years of experience creating data analytics around membership numbers including fluency in database analytics and development, MS Office, and Outlook.
9 years of Test Planning, Text Execution, and Regression, Load, & Penetration Testing with previous clients
8 years of experience with Web Analytic tools including Google Analytics and Tableau
Fluent in contract and comparative analysis for evaluation and decision-making purposes against different samples and scenarios, as well as translating the data into helpful information for decision makers.
Technical Summary:
SAFe Product Owner Certificate – IIBA Endorsed 2023
2024 Candidate SAFe Advanced Scrum Master (SASM)
Technical Summary:
Jira
SCRUM – Prioritization Backlog Management
Confluence
UAT Testing
ServiceNow
Proficient in Microsoft products (Excel, Access, Word, Power Point, Pivot Tables, Visual Basics, MS Project, SharePoint)
SQL Server Management Studio, Microsoft SQL Server Management Studio 2005 & 2008 R2
Clarity Analytics Platform
Pro-Clarity
Crystal Reports
BI Tools (SSIS, SSAS, SSRS, Power BI)
Google Analytics
Kafka
Oracle Financial Software
Hyperion Financial Reporting 9.3.1 and Hyperion Pillar
PeopleSoft
SAP
Lacerte Software
IBM DB2
AQT (QA & PROD Environments)
SAP BIP & HANA
Product Owner/SCRUM Master (Rational Team Concept software)
Education/Accreditation:
B.S. Business Administration - Finance, California State University at Northridge
Studied version 7461 and 7462 and 7463: MS SQL Server development for master level query writing and database administration certification. Business Analysis certification.
Work Experience:
MACart LLC, Freelancer (Client: Meydenbauer Convention Center)
July 2023 – Present
Product Manager
Created & collaborated with senior management a roadmap for Information Technology, Client Dashboards, Bluetooth, Point-of-Sale, and Geospatial Floor Mapping.
Led cross-functional teams in the planning, design, and execution of product initiatives.
Utilized Jira, Confluence, lucid charts, Geo-JSON and Microsoft Suite products.
Oversee the design and development of user-friendly client dashboards.
Work closely with clients, engineers, designers, and other stakeholders to ensure product vision aligns with market needs and company goals.
Performance Monitoring.
Cognizant, Fulltime – Des Moines, IA October 2022 – July 2023
(Client: Wellmark, Strategic Planning)
SAFe Technical Product Owner
Overview: Creation of a value-based payment system for the purpose of improving quality & total cost of care for providers, self-funded groups, federal employees in association with Blue Cross Blue Shield Association platform.
• Focus development surrounding Capitation, Fee-for-Service & Payment Bundling Programs
Tools & Software used: Azure ADO, Microsoft Office Suite, Microsoft Teams, Patient & Physician Reimbursement software.
Cognizant, Fulltime – Scottsdale, AZ. December 2021 – September 2022
(Client: McKesson, Strategic Planning)
SAFe Technical Product Owner
Overview: Act with Strategic Product Management, soliciting, and managing business requirements, documenting technical product requirements, and prioritizing of work. Collaborate with business stake holders, users, cross dependent technical teams to help identify defects as well as document and prioritize enhancement requests.
• Facilitate discussions and ideation sessions with key stakeholders to elicit future needs or current pain points
• Capture output (key points) of discussions to validate understanding with stakeholders and to share with the team
• Led the enhancements of the patient pharmaceutical e-commerce platforms providing patient pharmaceutical data and insurance between pharmaceutical companies and pharmacies.
• Play the primary role in analyzing needs and creating proposals for engagements detailing the hypothesis, opportunity, potential impact/value, partners/stakeholders, what will be tested/demonstrated, acceptance criteria, timeline, and estimates
• Develop an understanding of emerging tech, trends, capabilities, and potential use cases or applications
• Create and maintain an innovation backlog and roadmap of ideas along the lifecycle for visibility and awareness for leadership and other stakeholders
• Demonstrate a customer-centric mindset and an understanding of strategic intents of our area and the company
• Researched market metrics and trends to help support potential impact, success metrics, ROI, and overall value of technology and experiments
• Create content to communicate the strategy, vision, and value created through our team's output
• Engage in shaping and evolving our tech-driven innovation program through discussions and ideation around our processes, target outcomes, and potential service and product offerings
Achievements: full cycle implementation of legacy migration of application software & patient re-enrollment processes (Blizzard – Merck & Organon)
Tools & Software used: Jira, Confluence, Microsoft Teams, Patient & Physician Reimbursement software.
Cognizant, Contractor – St. Paul, MN. July 2021 – December 2021
(Client: 3M, Operations)
Product Owner/Business Systems Analyst Consultant
Overview: Act as a strategic partner to 3M bringing thought leadership across technology and business. Assist 3M to incubate ideas & disruptive technologies through an innovation accelerator framework. Establishing a sustainable thought leadership, innovation, and transformation ecosystem through the “3M Collaboratory” Initiative.
Strong business consultative skills, self-starter mentality to support client.
Utilized functional experience in industrial manufacturing processes or other similar industries (Automotive, Aerospace, High Tech, Process, etc.)
Facilitated client workshops based on their business transformation agenda using Collaboratory products such as Mural.
Severed as creative consultant for the development regarding new product offerings to Ideation, and agile delivery frameworks. Created strategy to deliver ideas to solution delivery teams.
Managed, and escalated risks and concerns communicated updates to clients and internal stakeholders on product roadmaps and ongoing development.
Assisted with the development of high-level solutions concepts and detailed features, prioritized roadmaps that makes trade-offs between features and speed-to-launch with an objective to maximize business value realization.
Conduct independent research on industry and technology trends based on client’s innovation agenda.
Achievements: Creation of project management strategy with a focus on ideation surrounding IT Software & Applications
Tools & Software used: Miro, Microsoft Teams
Keller-Schroeder – Evansville, IN. June 2021 – July 2021
(Client: United Van Lines, Operations)
Business Analyst
Overview: Configure and develop workflows, templates, and forms within Smartsheet, and work with Tech to integrate with Azure DevOps. Upload and add content to the architect tool (i.e. Lean IX) for app inventory, risk, continuity, business capability mapping, etc. Organized and facilitated the development of business ideas into business and functional requirements that can be distilled into epics and MVP’s.
Admin/Configuration experience with Smartsheet, Lucid Chart or similar tools.
Use of analytical skills to filter, prioritize and validate potentially complex and dynamic material from multiple sources.
Communicated project status with various levels in the organization.
Achievements: Developed records management layout and work sheets in Smartsheets
Tools & Software used: Lucid Charts, Smartsheets, Microsoft Teams
TEKsystems – Portland, OR. Jan 2021 – June 2021
(Client: Genesis Financial Solutions, Operations)
Business Analyst
Overview: Served as the primary point of contact between Information Technology and internal lines of business. Understanding client’s Information Technology needs, translating those into structured requirements to enable user story creation that feeds delivery teams operating in Agile-Scrum, Kanban, and traditional Waterfall. Working with cross-functional team(s) consisting of engineers, vendors, business, and operations representatives. Collaboration with a wide variety of technical and business stakeholders to deliver high quality product and process descriptions, business and functional requirements, testing, and assisting in the development of business cases.
Organize and facilitate the development of business ideas into business and functional requirements that can be distilled into epics and MVP’s.
Proactive approach and communication to stakeholder, keeping them current with status, and quickly escalating issues to assist in removing barriers and finding resolutions when needed.
Develop and measure product KPIs, Supply Chain of consumer financial information, derive key insights, and monitor system performance against objectives.
Work closely with project teams that range from product owners, scrum teams, vendors, and business stakeholders, and support the development of work plans and cost/benefit analysis.
Manage changes against project schedule, scope, and cost, lead assessment of impact on the larger portfolio.
of projects
Contract and vendor management: build partnerships across organizational, departmental, and geographical boundaries.
Achievements: System of Record (SOR) Program ‘Go-Live’ Launch- IT and Operations Platform reconfiguration and development, creation of new user stories, UAT test requirements, flow charts and diagrams
Tools & Software used: Azure DevOps, Confluence, Smartsheets, VMware, Slack, Microsoft Teams, Draw.io
Prokarma - Seattle, WA. Sep 2018 – Jul 2020
(Client: Daimler, USA -Sales & Marketing)
Business Consultant/Product Owner/Sr. Business Systems Analyst
Overview: Provided the functional needs understanding the business system as an SME along with analyzing and evaluating the system, process and use cases providing high quality services to support Business Groups and IT Development staff.
Led product development teams by defining the vision and goal creation.
Managed the project back log using RTC software.
Google Analytics traffic management thru kafka vendor product tracking.
Managed and prioritized back log tasks.
Responsible for communicating with stakeholders across the board, including customers, business managers, and the development team to make sure the goals are clear, and the vision is aligned with business objectives.
Ensured that the team maintains a cohesive vision despite the flexible and often fast-paced nature of agile product development.
Liaison between business groups (clients) and IT development staff
Assist the development teams with design and lean assessments iterating through functional issues.
As a system SME (subject matter expert) is versed in system requirements and capabilities
Perform various levels of application testing and ensure the system produces correct results.
Perform Test Planning, Test Execution, Penetration Testing and Regression Testing of Supply Chain product manufacturing.
Work with business to gather functional requirements to assess current state vs. future state analysis.
Work with developers to translate functional requirements into technical design.
Supports a variety of applications.
Consults on the integration of application systems, regarding operational and training implications.
Provides on-going project management and status reporting at all levels.
Analyze and evaluate business systems, processes, and customer use cases to provide high quality services to support them.
Achievements: Creation of new user experience websites and upgrade of back-end portal and portlet services.
Tools & Software used: SAP S/4 Hana, VMware, RTC, Google Analytics, Kafka, MS Visio
PeaceHealth - Vancouver, WA Oct 2017 – Sep 2018
Product Owner/Sr. Business Systems Analyst (Supply Chain, Purchasing)
Overview: Develop analytic reports, metrics, and data extracts in collaboration with Supply Chain leadership and other departments working within an agile environment.
Pharma e-commerce supply chain website
Led Implementation Team by managing the agile business requirement architecture.
Managed the ‘to do’ list in the project backlog using Lawson/Infor software.
Prioritized needs and stages of development of product back log initiatives.
Usage with a combination of SQL, Crystal Reports, Access, Infor/Lawson Add-ins, Infor/Lawson HCA, Tableau and/or Excel.
Assists in the development, lean processes, implementation, reporting and management of product and service contracts.
Research new product categories, renewals, updates, bid analysis, price comparisons, problem resolutions and contract compliance.
Achievements: Recognition of approximately $16M in Contract savings for Supply Chain.
Tools & Software used: Lawson Info, VMware, Microsoft Teams, MS Visio
InterDent - Vancouver, WA Jan 2016 – Oct 2017
Project Manager/Product Owner/Sr. Business Systems Analyst
Overview: Interact with Product Managers and team members to test, validate and verify solution requirements, current state vs. future state impacts, and implementation of system application development and IT infrastructure.
Managed the Implementation Team for the vendor product software architecture.
Defined and managed the Project backlog (using Smartsheet software).
Managed all priorities and tasks of the back log.
Develop process standardizations for departments to identify the top business processes that impact revenue, develop business requirement documentation, scope development involving IT application development for departments.
Write data mapping documents, data transformation rules, maintain data dictionary, data migration and interface requirement documents.
Partner with the Front Office and revenue teams to understand the business and revenue reporting challenges. Develop, socialize, and report consistent assessment of historical performance.
Engage with the stakeholder to demonstrate and test the iterative work product while ensuring along the way that the developments meet their needs.
Provide insightful analysis, database design featuring MS Visio, Smartsheet.com, projections, and reporting for enhanced decision-making capabilities.
Achievements: Managed successful installation of Great Plains 2016 upgrade. Creation of process flow and documentation process for IT Infrastructure with recognition of over $500K annual savings involving error efficiency.
Tools & Software used: Smartsheets, VMware, Microsoft Teams, MS Visio, Draw.io
Mentor Graphics - Wilsonville, OR Apr 2015 – Dec 2015
Contract Business Consultant - Report Development
Proactively engaged in multiple areas of focus within sales operations involving decision support and dataset analysis.
Developed traceability matrix for tracking of sales products through logistics channels, testing/validation, and control. Gathered requirements for sales managers to determine priority of requests for benchmark, prototypes, and context diagrams.
Created measures, performed analyses, and generated reports to support informed, fact-based business decisions which drive improved performance and results across multiple sales channels. This often involves starting with an undefined problem, identifying trends and issues, synthesizing, testing, and reporting the results.
Actively participate in the understanding of a dataset and its relation to the project implementation including methodology application, framework & system requirements, and technological solutions to effectively systematize the term renewal portfolio. Work closely with sales operations partners and IT.
Synthesize complex data into easily understood and compelling management reports and performance dashboards.
Lam Research - Tualatin, OR Jun 2014 – Apr 2015
Sr. Business Systems Analyst /Product Owner/Report Developer, Consultant
Created SQL reports using SQL Server 2008 R2 and MS SQL Server Management Studio for the purpose of maintain reporting of Master Schedule data to support a variety of functions inside and outside of the Manufacturing and Production Control Organizations by performing Test Planning, Text Execution, and Regression Testing.
Provided support for assessment of material and capacity allocation on a day-to-basis to support rapid customer commitments.
Provided metrics reporting to management to measure the effectiveness of the organization.
Tools used for data analysis: SQL Server 2008, SQL Server 2008 R2 Report Builder 3.0 (SSIS), SSRS, MS SQL Server Management Studio 2010, SharePoint 2010 (members, site owners, permissions) Certification, ASP.Net 4.0 Framework
Microsoft - Redmond, WA Nov 2013 – Jun 2014
PMO Financial Consultant
Created and designed financial reports using Microsoft SQL Server Management Studio, Microsoft Dynamic AX, Access, and Power BI.
Performed data analysis used for VP level reporting using SAP, Plan of Record, Microsoft Dynamic AX, on a monthly and quarterly basis.
Maintain, track, and update Key Performance Metrics using MS Dynamic AX.
Performed data extraction methods using a variety of software: Plan of Record, MS Financial Mgmt. (DFM), and SAP.
Prioritized and aligned business needs within manageable projects, resource scheduling management, budget management and communication to stakeholders.
Led cross-functional teams and effectively communicated across multiple stakeholders’ groups.
Tools used for data analysis: Windows 8.1, SAP, Microsoft Dynamic AX, Financial Management, Power Pivot, Advanced Excel (2013), & Microsoft Access (2013), Microsoft SQL Server Report Services Studios (SSRS)
MACart LLC - Vancouver, WA Aug 2006 – Nov 2013
Sr. Consultant/Project Manager/Product Owner
Clients: Otis Elevators (UTC), OHSU, Nike Inc., Kaiser Permanente, PeaceHealth, Hewlett Packard, Columbia United Providers
Analyzed vendor contracts, supply chain inventory and financial uploads using Lawson/Infor Cloud-Suite HCM, Infor Cloud-Suite Financials, and Infor Cloud-Suite Supply Management
Patient Claims adjudication for pharmaceuticals billing & medical claims recovery
Team Lead working with Directors, managers, and departments explaining both economic and financial impact with projects, managing budgets, headcounts, and providing detailed explanation for potential accruals, & cost overruns.
Team Lead designing, developing, creating, and testing front end user and back-end user interface reports from mainframe system integrating reports into SQL Server 2008 R2 and designing reports in MS SQL Server Management Studio.
Managed and maintained product back log.
Performed complex front-end user and back-end user data analysis, diagnostics and troubleshooting to assist with the automation of the forecasting process using SQL Server Management Tools and Excel.
Prepared and analyzed data from Data Warehouse and Business Intelligence using SQL Server Management Tools, SAP, COGNOS, Oracle, and Hyperion, to create a process to support Data Science reports and flows.
Developed and implemented key business strategies and statistical algorithms using SQL Server Management Tools.
Translated conceptual front-end user requirements into functional and technical requirements in a clear manner that is comprehensible to developers, customers, and project teams.
Team Lead with front-end and back-end user design and solution discussions that result in best-practices, processes, and services.
Designed and developed front end business intelligence reports utilizing SSRS tools for data and financial analysis of pertinent information to determine progress against strategic plan, budget, forecast, and to support external financial decisions.
Translated business needs into functional requirements and provides direction on principals and reporting requirements.
Provided Information Management Solutions including analytics, dashboards, and reports to support all levels of the company in making informative decisions that increase the bottom line through improved quality and services.
Collaborated with project managers and project sponsors to determine project scope and vision. Work with stakeholders and project team to prioritize collected requirements.
Created programming processes using project management methodology.
Conducted interviews and provided process and product analysis to gather functional requirements. Managed diverse requirements from multiple customers and consolidated the information into a comprehensive solution.
Managed front-end user support with business intelligence reports by analyzing the data accuracy, efficiency and usage of existing solutions and provided support through continuous improvement, recommendations, and modifications.
Assisted User Interface, back-end user systems process improvements and migrations as they relate to business intelligence data and financial reporting using Hyperion, Oracle, and COGNOS.
Tools used for Data Analysis: Windows 8.1, SAP, Microsoft Dynamic AX, Financial Mgmt, Power Pivot, Advanced Excel 2013 (formulas & pivot tables), & Microsoft Access (2013), Microsoft SQL Server Report Services Studios (SSRS), SQL Report Server 2008 (SSRS), SQL Server 2005 & 2008 R2 Report Builder 3.0 (SSIS), SSRS, MS Management Studio (SSAS 2008 &2010), SAP, COGNOS, Oracle OBIEE 9g, Enterprise, Lawson, SAP, SQL SMS, Pro-Clarity, MS Office Suite 2010, PeopleSoft (FMS), Hyperion Financial Reporting HCM 9.3.1, Crystal Reports, Oracle – Discoverer 10g (Payroll Data), understanding of MGMA & FPSC standards and productivity benchmarks.
Quest Diagnostic Laboratories - Tarzana, CA Jul 2002 – Jan 2006
Senior Financial Analyst - Reimbursement Claims Analyst (Contract Position)
Special projects analysis involving incorrect medical billing of medical companies using medical trend analysis involving costs, claims, and recovery, based on Outpatient Fee Schedules primarily focusing on clinical laboratory fees.
Built reports using Microsoft Excel, Word, & Access to analyze where medical billing loss was occurring. Developed spreadsheets showing differences in Pharmaceutical Fee Schedules & procedures and what was being received in revenue.
Designed reports that produced project feasibility, time frames, project costs, and headcount requirements.
Created financial database spreadsheets, management of journal entries, monthly forecasts, creating P & L and balance sheet reconciliation, revenue accruals.
Reports that were developed using PeopleSoft are now being incorporated in companywide analysis of future medical revenue recognition. The reports that were developed aided in the recognition of nearly $6 million dollars of unrecognized revenue.
Contact this candidate