Drove technical system integrations overseeing large data set analytics, automation processes, reconciliation standards, product engineering, and machine learning architectures. Collected critical time-series data modeling to orchestrate interpretability optimizations, relational pattern identifications, technical documentation, and automation UI quality for key insights and data usage. Managed and defined real-time data related to extract queries, spend history reporting, database connections, SQL syntax updates, Oracle and SQL sources, and system infrastructures for supply chain and open purchase department usage. Facilitated corporate-level digital collaboration focused on refactoring software applications, creating new user interface (UI) features, and implementing software systems to adapt to system changes.• Acknowledged for leading continuous integration and deployment (CI/CD) operations by optimizing data pipelines for machine learning models, automating testing and GTM deployment processes within security and compliance standards.• Selected as the Primary Systems Analyst for heading complex functional control processes using PeopleSoft and data ETL conversions of DCP Supply Chain data into a legacy SAP system for Phillips 66. • Promoted into 4 unique roles within 7 years of employment due to advancing KPIs, supporting M&A initiatives, meeting GTM deliveries, and mitigating internal risks. • Saved the company thousands after pinpointing critical deficiencies and partnering with the technical leadership team to properly transform and validate SAP-required loads. • Main SME for modifying all automated Alteryx workflow reporting, investigating, and reconciling data transferred from DCP Midstream into the Phillips 66 network.

Pipelined lifecycle financial system analysis and design infrastructures focused on data models, object-oriented design tool utilization, source control management, BI solutions, A/B testing, and operating system deliveries. Created visual dashboard reporting systems dedicated to supporting supply chain operations and strategic sourcing across supplier, purchase order, invoice, and spending analytics. Maintained incoming PeopleSoft SCM and accounts payable (A/P) queries with Query Manager/SQL, application design with Alteryx/Power BI, and existing reporting objects in Excel/Access. • Quickly moved from the Business Data Analyst for the supply chain sector position into a Senior Financial Systems Analyst role before being promoted to Principal Financial Systems Analyst due to expert experience in PeopleSoft and SQL. • Lead executive project in adopting Alteryx and providing training related to data analytics and automation education.• Saved DCP 20k annual hours in manual reconciliation processes after leading impactful quarterly hackathons.• Produced financial unit workshops to integrate fundamental knowledge in data wrangling and automation analytics.• Secured thousands in the future in operating expenses (OpEx) by implementing process improvement methodologies for digital transformation projects in automating manual/reconciliation routines and new business reports. • Executive Project and the Business Center of Excellence Lead in piloting GTM operations for adopting Alteryx at DCP.• Designed and launched over +100 financial workflows dedicated to data analytics, KPI measures, time series forecasting, reading systems and warehouses for data mining, reconciliation routines, cross-system ETL, and system automation.• Saved millions in penalties by conducting royalty calculation subsystem reverse engineering and monthly filings due to ONRR 2020 valuation reform, and redefining SOPs for automating manual inputs regarding OCR reading of supplier quotes in ERPs.

Individual Contributor for advising and supporting big data set transformations and ETL data analysis projects for various contracted companies including Fortune 500, supply chain manufacturing, and large business enterprises. Investigated ways to properly digitalize and maintain structures for data storage solutions, data cleansing activities, new technology integrations, and quality management system (QMS) foundations.• Hired by Prodigy Staff Advisors in 2017 to oversee Anadarko data integration and IVM analytics workflow projects.• Contracted by Envision Business Consulting from 2016-2017 to manage Miller Coors International’s merger (M&A) and supply chain system integration by reconstructing legacy supply chain order data and reloading data into SAP/Salesforce.

Examined and assessed SAP reporting and reconciliation solutions covering multi-system payroll configurations, mandated BSI Tax TUBS installations, vendor interface scopes, and user acceptance testing (UAT) for cross-functional HR and accounting teams. Generated custom data mining and analytics reporting for various HR, legal, I.T., corporate tax, and labor/employee relations partners in compliance with business requirements, functional specifications, W2 filing, IRS, and payroll operations. • Gained executive approval and launched a new automated reconciling routine related to 'bi-weekly' payroll pinpointing of employee tax records before quarter and annual closes. • Moved from a Senior Process Analyst to Lead Analyst in charge of reconciliation analytics after catapulting process improvement and reconciliation solutions for payroll, tax, time reporting, and accounting teams. • Spearheaded M&A transformation efforts by overseeing the PeopleSoft HRMS configuration and employee data integration into SAP HCM for payroll and time reporting processes. • Successfully executed pre-and-post conversion lifecycles dedicated to parallel testing designs, automated data comparisons, go-live data transports, and post-conversion processes of legacy and warehouse system decommissioning.

Coordinated and produced processes by designing effective business requirements and functional specifications for automating time reporting related to phone IVR, image character recognition, self-service web, and interfacing data extracts. • Curated defined business SLAs, configuration requirements, and functional project specifications for the PeopleSoft 8.0 implementation for streamlining HRMS Payroll, and periodic Tax and Patch update packages. • Completed outsourcing projects such as payroll, ADP tax filing, Ceridian, unemployment, and voluntary deduction vendors. • Organized calculation events through differential and income award computing related to the FLSA rate of overtime pay.• Mitigated $12M in FICA tax expenses after designing PeopleSoft functional specifications to manage employee and employer taxes in accordance with IRS regulations during major company restructuring. • Saved $1 million in FICA tax credits, and passed an IRS audit during the redesign of electronic W-11 processes for the 2010 New Hire Act.