ExcelPro Umair

Document Controller

Qatar Museums • Full-time

Jan 2012 - Nov 2016 • 4 yrs 10 mos

Excel Data Entry Specialist for Document Controller, MDR, Transmittal Logs, Drawing Register, Construction and Engineering I help document controller in construction , oil and gas and engineering firm eliminate manual excel headaches. if you are managing master document register, transmittal logs, drawing submission or vendor data across Aconex, Sharepoint, or Projectwise, I turn your messy exports and pdfs into clan automated audit ready trackers that save you 5 - 10 hours every week. Build Master Document Registers, Drawing Register, RFI Logs, Submittal Logs, and Transmittal Logs with built in revision control, status drop-downs auto calculated due dates and conditional formatting that flags overdue or rejected docs in red. No more duplicate doc numbers.... Document Control Register, Data Cleaning & Splitting Take your raw/Aconex/sharepoint exports, scanned pdfs and vendor excel sheets and standardize them. i split combined columns remove duplicates fix date formats, unify naming conventions and validate against project codes. result on master file your whole team can trust. AUTOMATION FOR DCS Use Powerr query formulas, and light vba to build 1 click refresh templates. Upload a new export, hit refresh and your dashboard updates, i also add auto numbering for transmittal, email ready cover sheets and weekly status summaries that pull straight from your register ACCURACY FIRST Document control is compliance work. My sheets use data validation locked formulas and change logs so audits are painless. I have helped DCS PASS client audits with zero findings because every revision transmittal and status change was traceable. TOOLS USE DAILY Microsoft Excel , advanced, power query VBA G