Arnab S. Email & Phone Number

New York City Metropolitan Area

New York, New York, United States

• Reviewed and analyzed project spending to identify areas of risk, exposure, and budget variances; made recommendations based on actual vs forecasted time and expenses to help reallocate resources to meet budget.
• Analyzed agency's financial statements, evaluating overall financial stability using ROI & Gross Margin metrics; considered clients such as Pfizer’s market share trends to project potential layoffs and advised.
• Designed and presented to Senior Leadership impactful data visualizations, including bubble charts in Excel or Tableau, to convey revenue distribution and client size, highlighting the substantial contributions of key.
• Played pivotal role in orchestrating a seamless migration of financial systems, harnessing expertise in data extraction, validation, mapping, and fostering cross-functional collaboration among finance, and IT teams to.

New York, New York, United States

• Developed financial models, SQL queries, Macros, Power Query and Cognos Planning Analytics to extract, transform, and analyze financial data, enabling accurate forecasting, budgeting, and scenario analysis for.
• Successfully reduced Average Handling Time (AHT) by more than 50% through data-driven process improvements (e.g., invoice tracker) and streamlined workflows, resulting in increased operational efficiency for month-end.
• Assisted in financial statement audits, providing necessary documentation, data analysis, and supporting auditors

New York, New York, United States

New York, New York, United States

Data Visualization: Using tools such as Excel, Python and Tableau

New York, New York, United States

• Created Excel models to help survey possible healthcare acquisition targets by using key healthcare metrics such as EBITDA, Operating Margin, Cash Flow Coverage, and Debt-to-Capitalization ratios
• Collaborated in creating an IPO pitch book by conducting market research and financial analysis, leveraging tools like S&P Global Market Intelligence (CapIQ), Pitchbook, Preqin, and DealCloud.
• Generated various graphs in Excel, including dumbbell and combo graphs, to help investors visualize investment benefits
• Used XLookUp in Excel to audit and update investor details between CRM and 3rd party outsourced database

New York, New York, United States

• Utilize Avid and AppFolio to produce 5000 invoices per month, while ensuring accuracy and timely processing
• Created Macros in Excel to reduce processing of lengthy invoices from 1 hour to 20 minutes
• Generate process improvement ideas and collaborate with supervisor to implement
• Reconcile vendor statements and correct discrepancies related to pricing, quantity, and service
• Conduct biweekly analysis of invoices to ensure timely payments to vendors
• Review employee credit card expense receipts for accuracy and categorize them appropriately

New York, New York, United States

• Prepare 1040 and 1041 returns for high net worth individuals using SurePrep, CCH and Excel
• Analyze investment expense allocation and state municipal bond add backs based on 1099-Consolidated statements
• Input K-1’s and analyze for capital gain/loss with sale of PTP’s and passive vs portfolio

Bronx, New York, United States

• Review and process invoices, checks received, sales tax, and purchase orders, ensuring the accuracy of all data
• Write credit memos and journal entries for valid customer deductions to prevent fraud using Salesforce & QuickBooks
• Complete various ad-hoc projects, reconcile bank balances, and record general ledger entries
• Participate in various meetings and work groups to integrate activities, resolve communication issues, obtain approvals, and maintain a specified level of knowledge pertaining to new developments, requirements, and.
• Conducted credit card analysis to show company expenses and advised on reductions

Greater New York City Area

• Processed payment request vouchers from student organizations for reimbursements, vendor invoices and pre-bills
• Assisted with journal entries, bank reconciliation and recorded cash receipts and check deposits in the books
• Performed administrative duties and provided customer service by responding to inquiries regarding club budget allocations

• Mentored and prepared students for SHSAT, SAT and Regents examination
• Trained students in note-taking and time management skills

New York, New York

• Utilized QuickBooks to enter sales invoices, calculate payout to vendors, reconcile bank statements
• Reviewed payroll to discover any inaccuracies between excel file and employee records
• Issued checks to vendors by collaborating with the restaurant owner to know which checks to issue for that

New York, New York

• Provide customers the best customer service when shopping in person or over the phone
• Stock inventory to its right destination and unload inventory from a truck in a fast pace manner
• Teach customers how to use over the counter medicine or remedies

New York, New York, United States

• Facilitated Democracy Coach training to inspire youth to be engaged in community issues
• Participate in Generation Citizen’s Democracy Fellows program, talking about the GC experience in schools and community organizations
• Lead projects to improve the Generation Citizen student experience

• Mentored and prepared students for SHSAT, SAT and Regents examination
• Trained students in note-taking and time management skills

New York, New York, United States

• Helped create workshops to help fellows increase their career readiness and professional development
• Promoted action civics education in Brooklyn Tech by using Social Media
• Planned lessons for class that aligned with New York State and Common Core Standards
• Conducted research to discover how to implement the police body camera bill

New York, New York, United States

• Communicated and coordinated personal project with other fellows
• Created an advocacy plan to help eliminate police brutality in New York City
• Petitioned government officials to pass a bill that allows law enforcement to wear body cameras
• Conducted research to discover how to implement the police body camera bill

New York, United States

• Worked alongside with Leticia James to help New Yorkers resolve their tenant, harassment and other types of issues
• Documented and updated constituent’s data with details on Excel files
• Answered incoming calls and set appointments
• Reviewed cases and recommended possible solutions

Master'S Degree, Information Systems And Data Analytics

Accounting, Accounting And Finance

Education record