Mark Ramirez Email & Phone Number

Ontario, California, United States

• Database Management: Utilizing Quick Base to enter and monitor project details, ensuring data accuracy and up-to-date status tracking.• Project Coordination: Overseeing project progress, from initial entry to completion, and ensuring that all project milestones are met.• Billing and Payments: Managing billing processes and ensuring timely payments, maintaining financial accuracy throughout the project lifecycle.• Stakeholder Collaboration: Working closely with State and DOT projects involving FRELO, facilitating effective communication and coordination to meet project requirements and regulatory standards.

Irwindale, Ca

• Provide data with in-depth analysis on operational performance with the goal of understanding the impact of optimizing team production and successfully improving it by 10%.• Design and implement databases utilizing Power Query and Spectrum’s engineering application to reflect monthly regional growth during a regional expansion project. Create a data model using a 3-dimensional database representing all of Southern California and Hawaii. • Serve as a liaison between regional field engineering and national operations team, using self-built databases that reflect real-time geo-locational inventory and equipment data. Implement Power Bi for comprehensive visualization and analysis.• Using Visual Studio, C# and Selenium, automate reporting tasks that empower the team and leadership to make informed decisions on inefficiencies in current process flows.

Long Beach, California, United States

• Built cost-structured analytics models to assess and analyze project profitability, contributing insight on the financial performance of various jobs to identify high and low revenue projects.• Processed broken and fragmented data using various Excel functions and VBA Code to ensure accurate representation of quarterly accrued costs.• Built and maintained an interactive Excel dashboards and Pivot Tables to track sub-contractor pricings to identify optimal and cost effective routes for project execution.

• Oversaw operations and staff management at a Farmer Boys location, leading a team of 40 employees to achieve a 20% increase in customer satisfaction and a 15% rise in annual revenue through strategic improvements in service efficiency and menu enhancements.• Implemented rigorous training programs for all levels of staff, enhancing team competence and service quality, which contributed to consistently high compliance scores during corporate audits.• Spearheaded local marketing initiatives and community engagement events, increasing brand visibility and customer base by 25%, and effectively managed inventory and vendor relations to reduce operational costs by 10%.

Associate'S Degree, Business Administration And Management, General

Activities and Societies: Men of Color Scholar Gratefully apart of the MOC group surrounded by peers that were like minded to succeed.

Associate Of Math And Science, Business Administration And Management, General

Associate Of Communication & Information Systems, Business Administration And Management, General

High School Diploma, 4.0 Gpa