Application Analyst Accounting Coordinator

Damayanthi Patchipala

(Candidate Location- Irving, Texas 75063)

Candidate Summary:

Desire a long-term opportunity within a progressive environment and challenging role where my professional experience, education, and abilities would be advantageous to the growth of my employer, team and myself.

Offer excellent communications skills, exceptional understanding and application of Accounts Receivable principles, aging, analysis, posting, billing, cash applications, invoicing, cash receipts, chargebacks, reconciliation.

Recognized as a fast learner, a team-oriented contributor who thrives in past-paced environments and enjoys any opportunity to solve customer issues.

Proficient in Oracle, SAP, MS Office Suite Word, Excel (Advanced), PowerPoint, Trintech Reconnect, Access Database, QuickBooks Pro. Familiar with SAP FICO application. Learn systems quickly. Overseas degree in computer applications.

Education:

Andhra University, Visakhapatnam, India. 1995

Masters in Accounting and Finance

Course work included Advanced Financial Accounting, Cost Accounting, and Economics

Aptech Ins., Hyderabad, India

Masters in Computer Applications

Certification:

Data analytics with SQL and TABLAEU

Professional Summary:

Collabera Inc – Jun 2021 – Jan 2023

Client : Bank of America

ATM Deposit Accounting Analyst

Customers ATM deposits exceptions analysis and resolving issues related.

Solely making discretional decisions and adjusting customer accounts appropriately.

Tracking customer claims and making adjustments in the general ledger.

Resolve customer account differences relating to ATM cash transactions, Credit card Payments not credited in customer’s accounts.

Download the data from SAP system to excel sort the data in the order

Use lookups to get the data from tables and worksheets

Insert pivot table function to arrange, group and analyze Data. It gives different ways to work with data like review summaries and calculate counts, averages or totals Using different formulas to get the calculations with the large amounts of data

Request unprocessed checks, review authenticity, take discretion process or return to customers.

Detect fraudulent transactions on customer account from ATM transactions.

Update reports, issue tracking, Notification logs.

Process numerous journal entries and perform accounting corrections to ensure accurate records.

Moving cash between general ledgers to appropriate ledger.

Clearing cash exceptions created from hardware error, cash jam and customer forced deposits.

Ensure quality service and effective support for internal and external services.

Communicate with financial institution and cash vendors to resolve outstanding cash exceptions and balance ATM.

Process Bank checks to ascertain accuracy in deposits.

Gather and analyze information, identify errors and proffer Solutions.

Perform trend Analysis using the customer account history and the error scenario to avoid future error reoccurrence.

Altice USA Nov 2020- May 2021

Sr Cash Application Analyst

Altice USA is a communications and media company that enables its customers through the power of connectivity.

Responsible for completion of timely and accurate application of customer payments received through bank lockbox, ACH, Wire, Credit Card or other methods to customer invoices, performing cash transfers between systems, balancing entries and weekly/monthly reporting to accounting.

Identifies cash received for appropriate application to customer account or GL account.

Download the data from SAP system to excel sort the data in the order

Use Vlookups to get the data from tables and worksheets

Insert pivot table function to arrange, group and analyze Data. It gives different ways to work with data like review summaries and calculate counts, averages or totals Using different formulas to get the calculations with the large amounts of data

Research all exceptions related to Cash Application Specialist entries

Ensures cash receipts are processed accurately and timely with strict adherence to daily, weekly and monthly timelines

Maintain files of payments and support in a logical system for storage and retrieval.

Takes additional steps to identify payments when necessary and ensure balancing daily to the detailed bank report

Daily and Monthly reporting for cash applications as well as billing

Processing necessary adjustments and refunds

Interact frequently with internal departments (i.e., Treasury, Billing, Collections, Accounting, etc.) for the purpose of resolving outstanding issues

Demonstrate patience and overall courteous behavior when working with internal and external customers

Ability to adapt to constantly changing environments & priorities

Able to manage multiple tasks simultaneously to completion with sound business judgement.

Performs related duties and special projects as assigned.

Cardtronics USA Inc Jul 2019 to Oct 2020

Cash Reconciliation Analyst (Settlement Accounting)

Cardtronics is the global leader in ATM deployment and management operates approximately 285,000 ATMs across four continents.

Review daily reporting from vendors to ensure correct and timely data.

Reconcile ATMs and Vaults utilizing vendor reporting of residual counts, processor reports, and overall funding of cash from the vault cash provider.

Download the data from SAP system to excel sort the data in the order

Use vlookups to get the data from tables and worksheets

Insert pívot table function to arrange, group and analyze Data.

Complete import checks to ensure reports successfully upload.

Complete ATM reconciliation using internal processes and reconciliation application

Confirm Vault balances and identify exceptions

Confirm overall cash position of each vault cash provider, identifying cash in ATMs, cash in Vaults, Cash in transit, and over/short positions.

Identify ATM out of balances, track and resolve such items.

Prepare various reports for Management such as Out of balance counts and armored performance.

Research and process exceptions to appropriately settle exception adjustments to cardholders and terminals

Sending Claims to Armored carriers for the vault differences and shared liability claims to FLM’s

Canada ATM’s reconciliation for over shorts of ATMs

7- Eleven, Inc. Dec 2015 - Jun 2019

Accounting Coordinator (Cash & Revenue)

A U.S. international chain of convenience stores, headquartered in Dallas, Texas with over 68,000 stores.

•Work in the Sales Audit Team (Cash) – Review and analyze data from stores and making necessary corrections for 15 markets/100 stores per market (1500+) stores in very fast pace, high turnover department.

•Daily review of the exceptions in the CO1 database and make necessary corrections.

•Make corrections using Mainframe; Make corrections for Missing Cash Reports.

•Download the data from SAP system to excel sort the data in the order

•Use vlookups to get the data from tables and worksheets

•Insert pívot table function to arrange, group and analyze Data

•Follow up with stores regarding Cash Report closings and resolving any issues or bringing them to the attention of Management to implement necessary action.

•Make journal entries for the prior months Missing Cash Reports.

•Provide timely and thorough responses to accounting help desk requests.

•Assist the team leader, team members and management with special projects as needed.

•Assist management with running a Cash Report update using Trintech/Reconnect.

•Assist management with updating the Missing Cash Reports using pivot tables and Oracle.

•Maintain files for Journal Entries and reports.

•Run Cash Roscoe Query to find any Missing Cash reports.

•Run MCR status report. Checks receivables registering.

•NCH stores file updates.

•SA85 – 7 Eleven Cash Book Reject Suspense file updating.

•Change fund adjustments done as and when needed.

PMAM Corporation Oct 2009 - Nov 2015

Accounts Receivables Supervisor

Global information technology (SaaS) company with world headquarters in Dallas, Texas.

•Provide robust modeling and reporting to executive-level decision making. Sort, match and process invoices and checking payment requests. Analysis of accounts.

•Monitor accounts to ensure payments are up to date. Resolve invoice discrepancies.

•Produce monthly reports. Assist in month end closing. Investigating and resolving customer queries.

•Ability to prioritize, manage, and execute high volumes of day to day receipt processing of financial transactions.

•Collaborate with Sales and Collections to research and resolve customer invoice issues.

•Process and receive checks (high volume). Verify and process transactions, comply with company policies and procedures.

•Payments processing from Lockbox for 30 cities. Research receipts needing such actions.

•Monthly Billing (Customer Billing & Vendor Billing)–Generate, print, stuff and send invoices out.

•Print and distribute daily/weekly and monthly financial reports.

•Manage and provide support to the AR department for sixty cities. Serve as an information

•source for the sales consultants regarding updates on delinquent customer accounts.

•Perform bank reconciliations, confirm bank deposits, monitor customer account details for non-payments, delayed payments and other irregularities.

•Generate reports with A/R data/analysis; account research and reconciliation and monitor overdue accounts.

•Research invoice discrepancies, debits, credits. Process NSF’s, deposit debits and post additional fees associated.

•Process of refunds and chargebacks (weekly).

•Work on month end closings.

•New Hire Training.

Crown Jewelers, Inc. Jan 2009 – Sep 2009

Assistant Accountant

• Prepare a daily sales report. Process daily deposits of cash receipts and credit card receipts.

• Manage full cycle accounts payable and accounts receivables.

• Handle high volume of invoices. Maintain a proper general ledger coding of invoices.

• Prepare a weekly check run and month end closing.

• Manage inter-company invoices and manager expense reports.

• Order office supplies as and when required.

Contact this candidate