Rabia Masood

Experience

• 

  Telenor

  Oct 2008 - Mar 2020

  • Gathered requirements from teams and collected parameters from business units for forecast formulation. • Cleaned and analyzed large set of financial and technical data using complex formulas and functions in Microsoft EXCEL, such as VLOOKUP, PIVOT TABLES, IF statements, MAX, MIN, TRIM, LENGTH, TEXT-TO-COLUMN function etc. to transform data in presentable form. • Sorted and formatted data using functions like Conditional Formatting, Sorting, Filter, and Freeze panes. • Prepared, maintained, and reported monthly, quarterly, and annual budgets and forecasts in Microsoft EXCEL.• Conducted variance analysis of forecasts versus actual utilization using EXCEL and reported to management for effective decision-making. • Worked closely with cross-functional technical and finance business unit teams, communicated effectively to share updates, and coordinated activities.• Collaborated and followed up with technical teams for technical assistance and troubleshooting of software glitches and digital tools, ensuring seamless operation.• Cleaned and validated financial data by identifying and correcting errors, organized data into files, and maintained accurate forecasts, approved budgets, and other financial data records.• Identified trends, patterns, and insights of network equipment utilization to support business decision-making.• Assisted in the testing and validation of financial software applications.• Provided training and guidance to department staff on best practices for gathering budget requisites, resulting in a 70% improvement in the accuracy of budget estimates.• Streamlined the order placement process by implementing an automated system, leading to a 60% decrease in order processing time.• Collaborated with the finance department to reconcile monthly inventory reports, resulting in an over 90% accuracy rate. Show less • Prepared monthly financial statements in EXCEL by creating dashboards for financial statements linked with journal entries, resulting in automatic financial statement generation reducing processing times by 90%. • Recorded and maintained Books of Accounts on daily basis, for Trust funds worth Rs. 9 billion, to enable updated financial statements.• Imported and exported data from and to csv and pdf file formats and formatted data using Text-To-Column function.• Reconciled bank statements and coordinated annual audit, resulting in decrease of audit finalization delay by 80%.• Tracked rules, regulations, accounting standards changes, and laws associated with bookkeeping of Trust Funds and applied changes as and when required.• Recorded and maintained a data base of invoices in Microsoft EXCEL for processing support and reporting to higher management.• Answered vendor queries regarding pending payments and followed up with supply chain team for pending orders. Show less

  • Senior Business Financial Analyst

    Nov 2014 - Mar 2020

  • Financial Accounting Specialist

    Oct 2008 - Nov 2014
• 

  GLOCAL Foundation of Canada

  Sept 2024 - now

  Data Analyst - Data track team (Volunteer)

  Duties assigned:- Learn various data analysis and visualization tools and apply skills towards projects assigned by GLOCAL.- Research topics related to civic engagement like housing, election, health, education, and employment.- Collect, clean and analyze data on proposed topics and present findings.- Visualize data for better visibility and decision-making using visualization tools such as Excel, Tableau and Power BI.- Document the analysis and proposed recommendations for future analysis or decision-making. Show less