David Carrera Email & Phone Number

Sugar Land, Tx, Us

Houston, Texas, Us

Houston, Texas, Us

Houston, Texas, Us

• Managed uniform, MRO and office product categories ensuring vendors abided by contract stipulations and pricing by identifying, analyzing and interpreting patterns in complex data sets• Provide analysis, trends, KPI’s and Power BI Dashboards based of data translated from extracted data from multiple ERP’s, helping the executive team to leverage vendor costs in new contract negotiations across multiple disciplines• Identified opportunities and generated business solutions for process improvement and developed workflows and SOP’s for project execution and organizational processes for Supply Chain and Corporate Procurement• Created Power BI dashboards which generated recommendations to minimize operational expenses for LTL, FTL and local trucking for all business units and disciplines throughout North America, Latin America, Asia, Africa, Middle East and Europe • Extracted data from multiple ERP’s to validate vendor data presented in Quarterly Business Reviews• Facilitated and resolved contractual, invoicing and service issues and consolidated billing to minimize non-electronic payments and decrease AR aging for all ledgers by collaborating with AP and AR

•Conduct data analysis to rank fuel pricing from across the US from multiple systems and data types•Support personnel by developing appropriate tools to accomplish tasks•Developed and administered SharePoint Site to help organization and optimize asset and personnel usage•Work collaboratively with all business units and departments to establish productive working relationships and effect change by setting priorities and addressing issues•Run SQL code to assess, clean validate and analyze large data sets from to support AR,AP, HR and Payroll•Conduct analysis and reporting for fuel purchasing and asset tax filing•Create Roles, Responsibilities and Workflows for personnel and organization processes•Administrator for RTA Maintenance System and conducted training for new personnel•Manage document control for finance AR/AP and Operations Assets in preparation of Federal/State audits

Conduct daily extract BI and LMS and PeopleSoft data to for analysis and transform into visualizations for the organization•Identify issues based on analysis and propose solutions •Create ad hoc reports to support training staff highlighting non-compliance or outstanding training assignments•Define, create and implement standards and procedures•Present reports and propose solutions to group and management•Identify and propose opportunities for process improvement

Extract financial and productivity data from multiple data sources such as Excel, Access, SAP, TRACK and other various industry specific programs•Conduct financial/planning/scheduling audits•Manage and train auditors in external audits and approve data for analysis•Conduct analysis on planning/scheduling/execution data extractions •Produce Week End/Month End/Quarter End/Year End financial and productivity performance reports, KPI’s and Dashboards•Make recommendations for process improvement, execution and cutting costs in existing and new contracts•Update SharePoint sites with updated reports and database extractions for clients•Investigate variances from standard cost and usages and issue in reports to client Procurement and Management•Review existing contracts to ensure vendors are in compliance with execution of work, pricing of materials, hours work and direct labor and overhead

Updated data models for undergraduate students in physical chemistry•Maintained computer systems for department

Conducted and reviewed site walk information to ensure all information is ready for designers•Managed designers to ensure deadlines are met and plans are ready to be issued for construction•Reported projections for office projects•Approved invoicing for all office expenditure•Allocated personnel for roles and projects

Completed and reviewed site walk information to ensure all information is ready for designers•Managed designers to ensure deadlines are met and plans are ready to be issued for construction•Completed plans when there was overflow for designers•Surveyed commercial and residential areas

Designed plan layout for heat tracing in pipelines using AutoCAD•Maintained computer systems for department

Updated and maintained all drawings for projects on server•Allocated drawings to personnel•Ensured that redlines from engineering is captured in updated drawings•Issued drawings on time to meet construction time frame

Designed layouts for pipelines and cable routings•Surveyed commercial and residential areas

Post Graduate Program In Data Science And Business Analytics, Data Science

Mathematics