Joshua Lock
Bartlesville,OK
Summary
Analytical professional with technical knowledge and critical thinking skills to thrive in complex, data-driven environments. Tackles challenges with positivity and drive to overcome. Works great alone or with others and consistently exceeds expectations.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Consultant, Analytics & Digital Reporting
Phillips 66
Bartlesville, OK
06.2022 - Current
- Oversaw the digital reporting system (DRS) as a data owner, leveraging SAP BW queries and Alteryx jobs to curate essential financial information consumed by all levels of the company.
- Managed the transition of DRS from Alteryx and Tableau to Azure and Power BI, resulting in significant savings in software licensing costs while enhancing reporting capabilities.
- Trained dozens of employees across multiple sites how to use analytics tools to drive deeper adoption of data-driven processes across our business units.
Analytics Specialist, Midstream
Phillips 66
Bartlesville, OK
04.2017 - 06.2022
- Used Alteryx and Tableau to source actionable analytics from Midstream operational data, SCADA physical metering, and Midstream accounting transactions.
- Pioneered the creation and implementation of critical clean data from disparate source data, enabling high-value analytics solutions throughout the entire Midstream organization.
- Increased visibility into volumetric flows by developing automated systems and models for sustained accuracy.
Analyst, SAP Finance
Phillips 66
Bartlesville, OK
03.2012 - 04.2017
- Provided primary support for accounts payable, vendor master, foreign exchange, automated paper invoice processing; secondary support for treasury cash management.
- Ensured smooth execution of high-value daily banking transactions totaling $4 billion by effective management and optimization of SAP-based processes.
- Exhibited proficient configuration expertise, specializing in vendor management, payment processing, and foreign exchange.
- Facilitated effective communication between business stakeholders and ABAP developers by conveying functional and technical specifications.
Work Management Administrator
ConocoPhillips
Bartlesville, OK
10.2010 - 03.2012
- Managed and controlled custom SAP PM application as the process owner, ensuring seamless planning, tracking, and efficient allocation of IT work across diverse business units and competing priorities.
- Managed and organized IT work requests to optimize prioritization and supply/demand balance.
- Developed monthly reporting metrics using the extensive data generated by SAP BW, providing clarity on request throughput and resource allocation for senior IT management.
Analyst, Network Operations
ConocoPhillips
Bartlesville, OK
08.2009 - 10.2010
- Managed and administered internal DNS/DHCP servers.
- Coordinated the implementation of multiple DNS/DHCP appliances across various global locations, in line with company's mission to optimize critical service infrastructure.
- Performed LAN/WAN troubleshooting and effectively resolved network issues. Oversaw the execution of the Network Services work plan, ensuring timely completion of projects within allocated budget. Monitored and tracked capital spending for ongoing projects to stay on target with annual financial goals.
Education
Bachelor of Science - Management Information Systems
University of Arkansas
Fayetteville, AR05-2009
Skills
- Power BI
- Tableau
- Alteryx
- Microsoft Fabric
- Data curation
- Operations data
- Finance data
- Best Practices Implementation
- Automation
- Requirements Gathering
- Performance Tracking
- Cost Analysis
- Resource Allocation
- Continuous Improvement
- User Support
- Analytical Thinking
Affiliations
- Treasurer, Cornerstone Classical Academy
Accomplishments
- Recognized as top 10% performer for my Midstream volumetric analysis innovation.
Certification
- Power BI Data Analyst
- Azure Data Fundamentals
- Azure Fundamentals
Timeline
Consultant, Analytics & Digital Reporting
Phillips 66
06.2022 - Current
Analytics Specialist, Midstream
Phillips 66
04.2017 - 06.2022
Analyst, SAP Finance
Phillips 66
03.2012 - 04.2017
Work Management Administrator
ConocoPhillips
10.2010 - 03.2012
Analyst, Network Operations
ConocoPhillips
08.2009 - 10.2010
Bachelor of Science - Management Information Systems
University of Arkansas