Shruti Gupta Email & Phone Number

Gurugram, Hr, In

Gurugram, Haryana, India

India

Developed VBA code to send automatic confirmation emails to clients by MS Outlook. • Daily, Weekly, and Monthly MIS Reports, dashboard generation. • Using workbooks and worksheet data through VBA code. • Lead the development of Standard Operating Procedures (SOPs) for new and transitioned accounts. • Provided comprehensive training to new hires and doublechecked team members' work. • Managed Operating Expenses, Real Estate Tax, and Insurance Reconciliation for clients, reviewing landlord… Show more Developed VBA code to send automatic confirmation emails to clients by MS Outlook. • Daily, Weekly, and Monthly MIS Reports, dashboard generation. • Using workbooks and worksheet data through VBA code. • Lead the development of Standard Operating Procedures (SOPs) for new and transitioned accounts. • Provided comprehensive training to new hires and doublechecked team members' work. • Managed Operating Expenses, Real Estate Tax, and Insurance Reconciliation for clients, reviewing landlord invoices for compliance and updating leases. • Finalized monthly rent rolls, and scheduled payments in batches. • Performed various tasks such as indexing, invoice processing, estimates processing, Consumer Price Index (CPI), Knowledgebased Engineering (KBE), and Data Validation Audits (DVA). Show less

Gurugram, Haryana, India

Conducted account reconciliations for Insurance statements (P&C etc.) using Excel (Pivot Tables, VLOOKUP) and resolved issues with analytical precision. • Day-to-day analysis of MIS Reports, follow-up, and coordination with cross-functional teams to ensure timely flow of MIS. • A working knowledge of advanced Excel functions and ability to read, write, and debug advanced Excel formulas as required. • Analyzing data and creating final Report. • Automation and optimization of existing processes… Show more Conducted account reconciliations for Insurance statements (P&C etc.) using Excel (Pivot Tables, VLOOKUP) and resolved issues with analytical precision. • Day-to-day analysis of MIS Reports, follow-up, and coordination with cross-functional teams to ensure timely flow of MIS. • A working knowledge of advanced Excel functions and ability to read, write, and debug advanced Excel formulas as required. • Analyzing data and creating final Report. • Automation and optimization of existing processes with Macros. • Using Excel Functions, Table, PivotTable, Data Tools, Charts, Lookup, Sort and Filter. • Hands on Good Experience in MS-Excel. Using advance functions • Proficient with Data Management and Data Analytics. Show less

Gurgaon, India

Managed relocation processes, ensuring smooth transitions for employees. • Involved in Accounts payable & T&E process. • Provided comprehensive training to new hires and doublechecked team members' work. • Prepared Standard Operating Procedures (SOPs) for new and transitioned accounts. • Processed vendor invoices and relocation related expenses. • Utilized advanced Excel functions, including Pivot Tables and VLOOKUP, for data analysis. • Involved in Data Validation and MIS.

New Delhi, Delhi, India

Provided administrative support, managing daily operations and coordinating with cross-functional teams.Assisted in data entry and record keeping, ensuring accuracy and maintaining confidentiality.Utilized MS Excel for data organization and analysis, supporting decision-making processes.

Master Of Business Administration - Mba, Banking, Corporate, Finance, And Securities Law

Financial Modeling, Accounting And Finance, A

Bachelor'S Degree, B. Com (Hons)