• Researched and analysed data to offer management, insights and suggestions for establishing and achieving cost reduce on goals.• Carried out the month-end close process and conducted variance analysis against budget and forecast, identifying trends andcommunica?ng results and findings.• Monitored, analysed, and summarized subcontractor expenses for financial planning and budge?ng needs, as well as for subcontractorcost forecast and accruals.• Utilized Python libraries such as Pandas, NumPy, and SciPy to process and analyse extensive datasets, extracting valuable insights tosupport data-informed decision-making.• Conducted comprehensive financial analysis using Excel and Tableau to examine revenue, expenses, profitability, and other crucialfinancial metrics.• Provided weekly and monthly preliminary financial outcomes for company executives to review and leverage in decision-making.• Performed analysis of market trends and competive comparisons to recognize opportunities and risks within the financial environment.

• Redesigned and automated reports and applications using Excel VBA, enhancing performance and usability.• Developed weekly cash management and short-term cash flow models, as well as long-term financial forecasts and departmentalbudgets, leveraging strong analy?cal skills and proficiency in MS Excel.• Analysed monthly contract costs using the SAP financial system and collaborated with program management to monitor and evaluateprogram performance.• Implemented data processing pipelines with PySpark to automate data ingestion, transformation, and loading tasks, boosting efficiencyand accuracy in financial analysis.• Created dynamic, visual dashboards using SQL queries in Power BI and SQL Server.• Researched and applied GAAP and regulatory accounting guidance, resolving accounting discrepancies and irregularities.• Performed general ledger account variance analysis, explaining monthly reconciliations and following up on outstanding items.

Developed complex SQL queries using stored procedures, common table expressions, and temporary tables to support Power BIreports.• Maintained and optimized databases, and wrote SQL queries for data extraction, transformation, and loading (ETL) processes.• Deployed MS SQL Server platForm to store transform and query data for data analyzing and reporting.• Analyzed complex datasets using statistical, machine learning algorithms, resulting in 15% increase in customer retention rates.• Used Google Docs, Google Sheets, to collaborate in writing data and code documentation and reporting insight to the manager