Patrick Roland

Experience

• 

  Medical Web Experts

  Jan 2015 - Jan 2015

  HR Recruiting Assistant
• 

  Rackspace, the #1 managed cloud company

  Jan 2016 - Jan 2016

  Business Intelligence Intern II

  • Prepared ad hoc data analysis for sales managers with extensive SQL and served as key point of contact between sales and sales operations stakeholders while developing documents and removing data from QlikView dashboard• Analyzed average page of opportunity to determine lack of correlation between age and opportunity value utilizing SQL to gather data from Salesforce servers resulting in new sales pipeline through renewed communication for older opportunities

• 

  Cisco

  Jan 2017 - Jan 2020

  • Coordinated collection and analysis of acquisition data in collaboration with the sale adjustment team and finance controllers to identify missing transaction data requirements and drive process improvement for future projects • Oversaw migration to software based financial model from total contract value to annual contract value utilizing SAP Business Objects in a sandbox environment ensuring successful conversion of data• Improved data flow for offering level and product level views with development of customized Cloud Software Bookings Metrics dashboards using Tableau, Python, and SAP Hana to create a streamlined access point to bookings• Analyzed sales adjustments for weekly CX data requirements for Cisco Non-Acquisitions monitoring customer discounts to ensure sales adjustments aligned with all mandatory fields and coordinated with finance controllers to ensure data integrity by collecting missing data or identifying exceptions Show less • Coordinated within IT business operation to evaluate existing software technologies and execute the implementation of industry standards into daily software development, providing unit testing and integration code review for 5K IT technical team users• Collaborated with technical teams from development and service departments with low industry standard adoption rates to identify road blocks and coordinate development of attainable metrics for application quality practices driving success from 15% to 80% adoption rate and 5% to over 50% maturity level• Facilitated training modules as in-house agile coach to integrate agile transformation across IT for 60 cross-functional stakeholders achieving the 356-Inspire Dynamic Teams Award• Analyzed efficiency of quality practices to identify relationship between code coverage for unit testing and deployment seed utilizing R programming language in assessing and regression modeling, and presented findings as part of the Sprint Demo earning the Go the Extra Mile Award-Innovation Show less

  • Financial Analyst

    Jan 2019 - Jan 2020

  • Business System Analyst

    Jan 2017 - Jan 2019
• 

  Tokyo Electron US

  Feb 2021 - Nov 2021

  Business Intelligence Intern

  • Manage requirement requests from finance and field service stakeholders and translate requests for the technical team within tight deadlines while migrating data from third party applications to a Snowflake data warehouse utilizing SQL• Oversee the Resident Information Analyst Program to develop and implement a cross-training program in terms, requirements, and best practices for stakeholders from across the business to function as department access points to Business Intelligence Department data with two fully trained access users with plan to expand to seven• Communicate updates and project developments in PowerPoint presentations to VPs and CFO translating complex data sets from ad hoc snowflake views and identifying additional requirements • Develop templates to streamline gathering of detailed functional and technical requirements to utilize during weekly and biweekly stakeholder meetings to improve requirement quality for requests and improve technical department efficiency Show less

• 

  ShiftKey

  Dec 2021 - now

  • Data Product Manager

    Apr 2024 - now

  • Associate Product Manager

    Jul 2022 - May 2024

  • Data Analyst

    Dec 2021 - Jul 2022