Fares Mohamed

assistant analyst - capital financial planning unit

• Job Details:collaborate cross-functionally via ms teams, ms outlook, and in person meetings to address budget data discrepancies, improving forecast accuracy for $170m+ in capital expenditures. enhance budget variance tracking by 80% using ms access, sql queries and vba code in excel, ensuring fiscal compliance for over $170 millions in capital expenditures. develop ms access sql queries, after cleaning raw data of 15,000 capital projects in excel using power query, to create ms access reports, reducing data processing time by 70% and reporting projects with variances throughout the september preliminary plan. construct capital plan variance reports, using fms2 downloads and excel sheets, for executive reporting, improving reporting accuracy by 90%, demonstrating expertise in real-time data analysis. accept weekly budget code modifications (bcms) through financial management system (fms2) and running crystal reports, resulting in 100% of the compilation of two weekly proceed directive packages to be signed by the omb director.