Kevin Weilamann, CPA
Stewartsville,NJ
Summary
Detail-oriented professional focused on improving company financial operations and streamlining processes. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
27
27
years of professional experience
1
1
Certification
Work History
Lead Accountant
AT&T
Bedminster, NJ
01.2004 - Current
- Supported cross-functional organizations by providing accounting requirements and coding for custom bill implementation during contract review
- Supported the implementation of the new revenue recognition standard by engaging with partner teams to help develop the reporting application data modeling and reporting solution
- Review quarterly results by customer in designated portfolio and communicate results back to leadership
- Member of a special project team to help streamline daily work functions across the company utilizing Power Bi, Power Query and MS Access
- Continuously learning new software to help improve and streamline processes.
Accountant
AT&T
Bedminster, NJ
01.2001 - 12.2003
- Responsible for providing Revenue and Volumes assurance for Domestic and International voice results for nearly $700M in Revenue
- Created and executed SQL queries to pull the data from revenue database
- Prepared the manual journal entries for processing and importing into the General Ledger for monthly book close
- Created requirements documentation for different processes
- Established a relationship with members from our Technical staff team and communicated any discrepancies/deviations that occurred with monthly data.
Portfolio Accountant
The CIT Group
Morristown, NJ
01.2000 - 12.2001
- Developed relationship with auditors in order to verify accurate reporting
- Provided reconciliation to legal counsel for use in court ruling
- Reconciled the monthly cash account with treasury and operations staff
- Responsible for recording cash journal entries
- Analyzed and reported monthly financial income
- Verified net investment amounts provided by the operations staff
- Fostered relationships outside of business unit.
Staff Accountant / Analyst
The Prudential
Roseland, NJ
01.1998 - 12.2000
- Ensured the integrity for reporting Commission accruals by communicating and developing working relationships with outside associates
- Developed financial spreadsheet to help analysis on premiums and claims in order to improve the efficiency for group analysis
- Performed financial analysis for Income Statement
- Accounts Receivable/ Accounts Payable Reconciliation.
Education
Bachelor of Science in Accountancy -
The College of New Jersey, School of Business
Trenton, NJ05.1998
Skills
- Power Bi
- Power Query
- Power Pivot
- Microsoft Access
- Microsoft Excel
- SQL
- M Formula language
- Journal Entries
- GAAP Knowledge
- Microsoft Word
- General Ledger Accounting
- Financial Analysis
- Account Analysis
- Data Warehouse
Certification
CPA
Timeline
Lead Accountant
AT&T
01.2004 - Current
Accountant
AT&T
01.2001 - 12.2003
Portfolio Accountant
The CIT Group
01.2000 - 12.2001
Staff Accountant / Analyst
The Prudential
01.1998 - 12.2000
Bachelor of Science in Accountancy -
The College of New Jersey, School of Business