Simarpreet Natt Email & Phone Number

New York, New York, United States

New York, New York, United States

• Created monthly financial analysis reports using advanced Excel techniques to track and evaluate budget performance, cash flow projections, discerning KPIs, and conducting variance analysis.• Developed monthly analytical reports, data visualizations, and financial models, ensuring accuracy and clarity in financial presentations.• Implemented VBA for task automation, reducing deliverable time by 50%.• Managed large datasets and navigated complex financial information, maintaining and analyzing financial records for over 300+ buildings.• Conducted in-depth data analysis using Excel and SQL to interpret financial trends, identify improvement areas, and provide management insights that helped save $50,000+.

New York, New York, United States

• Initiated and established a SQL Database to enhance data accessibility and simplify information retrieval, phasing out the previous file cabinet system.• Hosted SQL schema locally on MySQL, consisting of multiple tables normalized to the 3rd normal form.• Developed and optimized complex SQL queries for reporting and retrieval of crucial information.• Regularly updated database with DML whilst upholding data integrity.• Developed and utilized stored procedures to replace routine and repetitive queries.

Long Island City, New York, United States

• Managed day-to-day financial transactions using Excel to record sales, expenses, and payments, ensuring accurate and up-to-date financial records.• Reconciled bank statements monthly to align with internal financial records, identifying and resolving discrepancies.• Oversaw accounts payable and receivable, processing invoices, and sending timely payments, and overseeing collections.• Assisted in the preparation of financial statements, including Balance Sheets and Profit & Loss statements.

Master Of Science - Ms, Business Analytics

Bachelor Of Science - Bs, Finance, General