Pankaj's Resume
no image
Location: Boston, MA, USA
University: Birla Institute of Technology
Major: Finance

Pankaj's Resume

Work Experience
Financial Analyst
Boston Convenience
June 2019 – Present Boston, Massachusetts

 Regularly maintain & update all data on sales, purchases, income, expenses, and assets & liabilities in Quick Books
 Prepare monthly, quarterly, and year-end financial reports based on financial reconciliations
 Create forecasting & budget models using excel formulas, pivot tables and VBA macros
 Advise management on issues relating to increase in expenses and suggest ways to reduce them
 Review all financial statements to ensure their accuracy
 Oversee daily transactions related to cash and check deposits

January 2019 – May 2019

 Medical Leave

Finance Manager
N.S. Rathi & Associates Chartered Accountants
July 2017 – December 2018 Mumbai, India

 Created and maintained monthly, quarterly, and year-end client financial statements and management reports
 Assisted in the filling of tax returns for large trading houses, manufacturing companies, and high net-worth individuals
 Audited and reconciled financial transactions using client account payables and receivables
 Developed and maintained analytic reporting tools for accounting and finance groups
 Assisted in establishing procedures and controls for financial reporting


Financial Manager
Karuna Steel Trading Company
June 2015 – May 2017 Dubai, UAE

 Reviewed client profit & loss accounts and balance sheets to ensure financial strength before providing them with steel products on credit terms
 Executed and maintained daily transactions of company account payables and receivables
 Oversaw daily bank transactions such as cash deposits, issuances, and deposits of checks
 Reviewed all financial transactions monthly to ensure their accuracy

Financial Account Administrator
Saudi Investment Bank
March 2012 – March 2015 Riyadh, Saudi Arabia

 Calculated financial ratios from client statements for lending decisions
 Prepared write-ups on balance sheet ratios for the purpose of lending
 Assisted relationship managers in the preparation of credit proposals for corporate and SME sector clients
 Assisted relationship managers in generating leads and opening new corporate/SME sector accounts.
 Analyzed contract status reports to ensure that the approved financing ratios and coverages were met
 Assisted the senior relationship manager in maintaining all aspects of customer relationships
 Executed all transactions on a day-to-day basis for loan drawdowns, loan rollovers, trade products transactions, FX transactions, remittances, etc
 Monitored all accounts to ensure satisfactory usage of facilities within approved lines
 Ensured that all credit renewals and approvals were completed on a timely basis
 Supervised facility documentation and prepared line inputs in accordance with approved facilities

Education
MBA in Finance and Marketing
Birla Institute of Technology
September 2008 – July 2010
Ranchi, India

Bachelor of Commerce
Mulund Commerce College
September 2005 – July 2008
Mumbai, India

Certificates
Financial Modeling
EduPristine
January 2019 – March 2019
Mumbai, India

SQL and VBA
Aptech Computer Education
May 2018 – December 2018
Mumbai, India

Skills
 Analyzing financial statements
 Auditing financial reports
 Modeling financial data in Excel using VBA Macros, Vlookups and Pivot tables
 Building, managing, and querying SQL databases
 Financial reporting using Hyperion,TM1
 SAP ERP Modules Verification
 Creative thinking and problem solving
 Multitasking
 Good team player
 Attention to detail
 Ability to work under pressur

U.S. Green Card Holder