Variance Analysis, Reporting,Month End JEs,Budget prep,Reconcilations
Resume:
NEELA KAYASTHA
*****.*******@*****.***
SUMMARY
Analytical and detail-oriented Finance and Accounting Professional with 17+ years of proven and transferable experience in financial organizations, Medical Business Company, Mortgage, Insurance, Banking, Oil & Gas, academic and non-profit organizations.
PROFESSIONAL QUALIFICATIONS
Commercial Loan Reconciliation, Bank and Account Reconciliation Variance Analysis Statistical Data Analysis Financial Reporting Portfolio Analysis Reporting Regulatory Reporting Accounts Payable GL Journals Payroll Management Inventory Management Software Development Life Cycle (SDLC) Software Testing Life Cycle (STLC) Validation, Documentation and Execution Defect Tracking
EDUCATION, CERTIFICATIONS, AND PROFESSIONAL DEVELOPMENT
Master in Business Administration, Graduate, Tribhuvan University
Bachelor in Commerce, Graduate, Tribhuvan University
Certified in Mastering Adjusting Entries, Mastering Correction of Accounting Error, Mastering Payroll, and Mastering Inventory Management and Depreciation, American Institute of Professional Bookkeepers (AIPB).
TECHNICAL SKILLS
QA Tools: ALM, Bugzilla, ClearQuest, JIRA; Database: MS SQL Server, DB2, dBase III, MS Access; Visual Basics, MS Word, Excel and Outlook, Crystal Reports, SPSS, SQL, SAS, Windows, Internet Explorer, Chrome, Safari, and Mozilla, WISP; Eller, MSP, GEM, Legend, Adobe.
ACCOUNTING SKILLS
PeopleSoft, Hyperion, Recon Plus, SAP, BI Reports, Blackline, Sabrix, Vertex, GCP (SCSD), SAP Concur, MIP, AMB, Great Plains, ACCPAC Plus, Peachtree, ProCare, QuickBooks, OFS (Overseas Financial System), Collect1, and Passport.
PROFESSIONAL EXPERIENCE
Capital One (Morgan Franklin) San Antonio, TX
Senior Staff Accountant September 2021 – August 2023
Sept 2021 to Mar 2022: Regulatory Reporting Department:
Daily, weekly, monthly, Quarterly, Semi-Annual/Annual Report
Gather input from various LOB/ partner teams using various SharePoint workflow tools and review the data.
Analyze and update reports for new and removed line items and prepare daily, weekly, monthly, quarterly reports.
Ensure the workpapers, procedures are followed and updated on any changes of the reports.
Refresh system/files on status update and inform to concerned LOBs during the reporting period.
Prepare and update SOP for daily/Weekly/quarterly reporting activities
Apr 2022 to August 2023: Commercial Accounting/Commercial Loan Reconciliation Team:
Daily, Weekly, Monthly and Quarterly Recon reporting process
Prepare and analyze various recon reports for LOB
Reconcile the commercial loan data – match clear and research the variances
Work on Aged items, allocations, Journals, Account set up, reach out to LOB and Share system (IT) when needed
Prepare and update SOPs on daily/Weekly/quarterly tasks.
Becton, Dickinson and Company San Antonio, TX
General Ledger Accountant, Revenue Accountant and General Accountant (Indirect Tax) September 2019 – August 2021
January 2021 to Present – General Ledger Accountant
Continue to support on monthly close activities, including run BI report, prepared schedules, journal entries, reconcile various accounts, variance analysis and other month end tasks.
Support on quarterly and Annual Royalty Payout.
Prepare Desktop procedures to support revenue tasks for monthly Journal entries (COS SIP Elimination Entries, Unbilled COGS and Warranty).
Support to GL-Treasury team on daily SCF entries, 1QTP entries, matching and clearing cash/bank accounts. BPC tie-out packages, Tax packages and reconciliations.
Support to Indirect tax team on Exemption Certificates (TEC request, record and validation)
Revenue Accountant (April 2020 – December 2020)
Performed monthly close activities including run BI report, prepared schedules, journal entries, reconciled various accounts, variance analysis and other month end tasks.
Supported on completion of monthly, quarterly and annual closing procedures and financial reporting requirement.
Quarterly and Annual Royalty Payout – Run quarterly/Annual BI report, analysis, calculated quarterly royalty payment, communicate with licensors, business units and stakeholders.
Worked closely with Revenue Team to support on various contract obligation (Rebates, distributor incentives).
Supported on internal and external audit and tax packages.
General Accountant (Indirect Tax) September 2019 to March 2020
Verified /validated sales and use tax exemption certificates submitted by various customers into the systems.
Followed-up, researched and provided required information on Tax Exemption Certificate, Resale and Multi-Jurisdiction to customer, other department in in order to comply regular state audit process.
Supported on state and local sales and use taxes compliance and audit.
Provided customer service to internal and external customers. Worked on GMB emails.
Marathon Petroleum (Formerly Andeavor) San Antonio, TX
Accountant November 2018 to January 2019
Collected, compiled, analyzed, verified integrity of financial data used to generate invoices (prepaids and Environmental), journal entries, debit memos, credit memos, and month-end reporting needed for reconciliation for multiple vendors.
Processed uploads for JET product line and Propane received from multiple carriers.
Monitored daily terminal statements in comparison to SAP-reported inventory balances.
Investigated and resolved discrepancies in line with department procedures.
Followed accounted processes to ensure proper control, adherence to GAAP requirements, in compliance with Sarbanes-Oxley.
Endeavors San Antonio, TX
Senior Accountant February 2018 – July 2018
Prepared and posted daily, Bi-weekly and monthly journal entries (bank transactions, payroll, prepaid, accrual, depreciation).
Verified, allocated insurance billings, prepared month-end journal entries, as well as monthly closing.
Maintained fixed assets records, updated depreciation schedules and recorded depreciation expenses.
Reconciled the monthly and quarterly balance sheet accounts and the bank accounts as well.
Reviewed and posted intercompany transactions, American Express billing (statements) in order to generate invoices.
Analyzed and researched variances in monthly financial reports and create direct report to the senior leaders.
Led special project focused on the coordination of annual audit and the SAP Concur Implementation.
Wells Fargo - Consumer Lending Group West Des Moines, IA
Business System Consultant November 2016 – June 2017
Reviewed and analyzed data on generated financial statements, accounts payable, accounts receivable, collections, fixed assets and taxes.
Provided continued support to the team members, issue analysis, resolution, tracking and documentation related to File Validation using multiple resources, such as ALM, WISP, and GEM.
Letter Operations: Letter pull requested, Image requested accessing the QA Queue and database. Retired and deleted unused letters from main database.
Received and imported EUS data and assigned to team members for daily file validation process. Uploaded and validated QC data in the WISP (main database).
Conducted reviews related to Quality Control, Engagement, and the Post-production.
Home Services Mortgage West Des Moines, IA
Senior Accountant (Finance) August 2016 – November 2016
Reviewed and validated financial data/transactions, management reports, bank and account reconciliations generated by Finance Department in order to maintain internal control.
Worked with business partners for annual budget planning and process.
Variance Analysis: Analyzed, researched and provided feedback to the management.
Coordinated and assisted on month/quarter/year-end closing.
Nationwide Advantage Mortgage Company/ Nationwide Bank Des Moines, IA
Senior Accounting and Quality Analyst October 2006 – July 2016
Accounting and Reporting:
Prepared monthly Financial Report (with detail monthly expenses by cost center/dept), Portfolio Analysis report using on-demand SQL Queries and other tools and variance analysis of the balance sheet accounts.
Assisted in preparing annual budget and month/quarter and year-end closing process as well.
Managed and reviewed corporate accounts payable, deposits, and journals (daily, month-end, accrual, prepaid).
Reconciled bank accounts, balance sheet accounts identifying reconciling items, research and resolve the variances.
Created and updated procedures for regular accounting tasks and reports.
Facilitated mid-term, annual audit with detailed support and executed other ad-hoc analysis and accounting projects as needed.
Software Testing:
Gathered requirements and assisted development team to create business specifications and functions.
Assisted development teams to test new/changed features on applications: RxCheck, RxAdmin, Unifi, and Nautalius.
Conducted performance, functional, UAT testing during transition to new accounting software (AMB).
Contact this candidate