MARY MCKERCHER
Pueblo CO *****
*************@*****.***
SUMMARY OF QUALIFICATIONS:
●Has 10+ years of working experience with administrative support and project support/management.
TECHNICAL SKILLS:
●Microsoft Office suite (Word, Excel, PowerPoint, Project, Publisher, Visio, Access, Outlook) – 10+ Years of Experience.
●Advanced Excel skills including: Creating Charts, Tables, Ledgers, V-lookups, Graphs, Formulas, Diagrams and Presentation Materials.
●AS400 Systems
●AIA & EJCDC Software
●Salesforce
●SAP
●PeopleSoft
●Dreamweaver
PROFESSIONAL EXPERIENCE:
Retired 11/2023 to Present
CenturyLink, Broomfield, CO 9/2018 to 11/2023
Technical Project Manager (Reason for looking, Retired)
●Manage user data-base for GUI Porting site.
●Update our customer profiles with other telecoms.
●Read through new contracts and provide management with a brief summary.
●Identify items to be included in the project sets; based on provided parameters.
●Interface with Engineers and/or ASR writers to ensure timely project processing and error mitigation.
●Removed circuits flagged for disconnection.
●Research error listing and obtain critical information to correct and continue with order processing.
●Internal coordination with CRM & Planning teams to ensure no duplicate activity.
●Initiation of project with the vendor & maintain engagement through the life of the project.
●Update/maintain project tracking spreadsheets, OneNote project updates & WIP (Work in Progress Report)
●Research Issues in ASRI, CORE, APPLE, PRO, RSI, OOV and AMDOCS & re-entry into tracking mechanisms.
●Meet with stakeholders to update on progress.
●Maintain Project Time-line. Inform management of any changes to Time-line.
●Interface with vendors to create new projects and resolve issues with ongoing ones.
Interior Specialists, Aurora CO 6/2016 to 9/2018
Sales Support Coordinator (RFP/Bid Specialist)
(Reason for looking: Corporate Buyout/Position Eliminated)
●Partner with the sales executive through creation and maintenance of the bid project in the bid tool system.
●Create & maintain material cost sheet in the bid tool system using program information provided by sales executives.
●Run and validate rebate reporting to determine eligible rebates as agreed upon during the bid process.
●Complete requested material usage reporting as requested by builder.
●Create pricing proposals as needed for models, residential construction, non-standard options and special quotes.
●Validate builder program materials are set up and extended in SAP for internal use.
●Complete program maintenance in the bid tool system for showroom inventory.
●Schedule and attend pre-construction & model meetings for assigned accounts.
●Review blueprints with Senior Account Executive (add cut lines for flooring).
Univar USA, Denver, CO 4/2014 to 5/2016
Executive Assistant/Night Transportation Logistics Coordinator
(Reason for Leaving: Laid Off/Workforce Reduction)
●Responsible for standard office procedures.
●Respond to customer inquiries both via email and telephone.
●Gather, compile and maintain data, files, record systems.
●Payroll Administrator using SAP software.
●Maintain budget records, prepare check requests and response memos.
●Receive and place telephone calls, greet callers, prioritize and handle/forward messages.
●Use UVX system to receive purchase orders (PO) and package job orders (PJO).
●Prepare Orders for billing.
●Create Reports.
●Ship orders and create Bill of Lading (BOL).
●Ensure all outbound drivers have all required transportation (DOT) paperwork.
●Create Certificates of Analysis and upload them into the EDX computer system.
●Dispatch and Receive Trucks.
●Schedule deliveries with Company equipment and set-up contract drivers for loads.
●Assist where necessary with the development of solutions to daily customer service opportunities.
●Coordinates with a variety of customers, both internal and external.
●Demonstrate initiative and independent judgement in non-routine matters.
●Coordinate the complex area of environmental and regulatory compliance.
●Understand changing priorities of workload and follow up as needed.
Syncroness Engineering, Denver, CO 12/2013 to 3/2014
Technical Project Coordinator (Contractor)
(Reason for Leaving: Contract Ended/Laid Off)
●Project Planning (Using MS Project) including Master Project Plans.
●Support to lower-level plans.
●Coordination & tracking of tasks with the team.
●Engineering Change Order (CO) generation, tracking, execution, and posting to SharePoint.
●Major Project Management (PjM) document support and coordination.
●Project Plan Updates.
●Risk Assessment.
●Weekly and Monthly Status Reports.
●RPO updates.
●Project closeout documentation.
●Monthly revenue updates to Office Manager.
●Deliverables Tracking.
●Prepare interim and completion project reports.
●Interface with Project Manager to provide financial status reports & ensure customer needs are being met.
●Adhere to company Quality System processes.
●Track & Maintain Project Dashboards.
●SharePoint and Tenrox Ownership including maintenance of Non-Disclosure Agreements (NDA)
●Project set up.
●Budget creation.
●Project closeout.
Metro Wastewater Reclamation District, Denver, CO 8/2011 to 9/2013
Executive Secretary/Wastewater Project Coordinator
(Reason for Leaving: Laid Off/Workforce Reduction)
●Developed Formatted & Typed Text for General Correspondence, Forms, Tables & Graphs, Manuals and Other Documents Using Multiple Software Packages, including Visio, Excel, MS Word, PowerPoint and Adobe to Create Charts, Tables, Ledgers, Graphs, Reports, Diagrams and Presentation Materials.
●Maintained Software Expertise in Word, Excel, MS Project, PowerPoint, Publisher, Visio, and Adobe Acrobat.
●Filed Easements and Leases with County Assessor’s Offices.
●Typed Land Descriptions, Leases and Easement Contracts.
●Generated Checks for Executed Easements.
●Typed Offers and other Correspondence.
●Coordinated and Took Responsibility for the Completion of Mass Mailings, Including Sorting Functions and Mathematical Calculations.
●Checked, Proofed, and Edited Work for Accuracy of Names, Figures, Sentence Structure, Punctuation, and Spelling.
●Performed “Final Reading” of Large Documents Including Contract Documents, O&M Manuals, and Specifications for Consistency in Terminology and Language.
●Prompted Staff when Related Documents or Sections from the Boilerplate Need to be Used, Included, or Revised for Completion.
●Followed Established District Document Standards for Preparing All Documents.
●Followed Procedures to Ensure that Completed Documents were Classified Properly & Saved in the Appropriate Electronic File Repository (EFR).
●Attended Diverse Staff Meetings, Took Notes and Composed Minutes of Meetings, as Required.
●Transcribed Dictation, Including Statistical, Technical, Non-Technical and Scientific Terminology.
●Assisted the Engineering Quality Control Division Head in Preparing, Checking, Coordinating and Updating Contract Document Standards.
●Maintained and Revised Engineering Department Information on the District’s Home Page and Intranet.
●Maintained and Updated the District Departmental Telephone List.
●Aided with Special Activities and Projects.
●Proficient in Using All Office and Document Production Equipment, Including Binding Equipment, Copiers, Postage Machine and Switchboard.
●Completed Work for Assigned Areas.
●Helped and Coverage for Co-workers, as Needed.
State of Idaho (Division of Public Works) Boise, ID 6/2006 to 6/2011
Engineering & Construction Project Coordinator
(Reason for Leaving: Moved to Denver, CO)
●Prepare and Distribute Requests for Qualifications.
●Prepare and Distribute Architect/Engineer Agreements.
●Prepare and Distribute Notices of Intent, Construction Contracts and Notices to Proceed.
●Work with Project Managers, Field Representatives, Architects/Engineers, & Agencies to Set Bid Dates.
●Prepare and Distribute Advertisements for Bid
●Prepare, Process and Distribute Amendments & Change Orders for Assigned Projects
●Complete Project Set-Up Sheets and Set-Up Files.
●Maintained Software Expertise in Word, Excel, PowerPoint, Publisher, Visio, Access and Adobe.
●Attend and Record Bid Openings.
●Type and File Correspondence.
●Worked on Construction Projects for all State Services including Criminal Justice, Health Care and Scholastic.
●Process Vendor Payments.
●Monitor and Adjust Project Budgets, as needed.
●Determine Appropriate Fund Transfers and Billings to Prepare Project Account Change (PAC) Forms to Fund, Modify Funding Source and/or Close Projects.
●Close Out Completed DPW Projects.
●Explain Technical Processing Policies and Procedures, Rules & Regulations to Staff, Outside Agency Personnel, Architects, Engineers, and Other Contractors.
●Coordinate Project Flow of ALL the Above Duties / Input and Retrieve Information and Correspondence on Word, Excel, Access and the DPW Web Database System.
●Prepare, Advertise and Distribute RFQs for Regional Architects and Engineers.
●Update DPW Webpage, as needed.
●Manage Front Desk Duties when the Receptionist Unavailable
●Serve as the Backup Person for Coding the Division Billings, Processing IFAS Payments and Deposits.
●Develop PowerPoint Presentations
●Assist DPW Management Assistant with tracking for DPW’s Annual Strategic Plan Report and Other Administrative Support Functions, as requested.