Financial Reporting Analyst Resume
3.00/5 (Submit Your Rating)
Santa Clarita, CA
SUMMARY:
- Seasoned, goal - focused professional with demonstrated track record of leading cross-functional teams in the development, documentation, and delivery of process innovations driving the attainment of business goals.
- Demonstrated ability to clarify business requirements, perform gap analysis, and design process and system improvements to increase productivity and reduce costs.
- Fostered solid business and professional relationships with all levels of professionals from diverse backgrounds.
- Proven expertise in driving efficiency and productivity through evaluation of financial management systems and implementation of process improvements.
- Strong leader with success directing highly skilled financial management teams in supporting and achieving corporate objectives.
- Possess advanced Excel skills including PowerPivot, sumproduct, vlookups, nested if statements, and array formulas, as well as writing macros in Excel.
FINANCIAL AND MANAGEMENT COMPETENCIES:
- Large Scale Project Management
- Financial Reporting
- System Development
- Strategic Planning and Implementation
- Business Care Development
- Budget Planning & Allocation
- Effective Communication
- Risk Management
TECHNICAL PROFICIENCIES:
Microsoft Office Business Suite Access, Excel, PowerPoint, Word, SAP, Lawson, Crystal Report development, VBA, and SQL
CAREER EXPERIENCE:
Confidential, Santa Clarita, CA
Financial Reporting Analyst
Responsibilities:
- Facilitated the Conversion of the Chart of Accounts and re-created financial reports through the use of Crystal report designer. Partnered with Human Resources Departments to deliver reports on calculation of incentive payouts to Managing Physicians.
- Orchestrated the testing of system upgrades across numerous Lawson modules including compiling test results for the Lawson Administrator. ertified the accuracy and integrity of information by reconciling financial reports produced in Crystal to the Lawson Income Statement and Trial Balance reports.
- Created new financial reports utilizing Crystal Designer in combination with writing T-SQL queries, views, and SP’s in SQL Management Studio to retrieve data from the Lawson tables.
- Revised P&L financial reports to reflect reporting methodology and structural changes.
- Maintained the Lawson General Ledger module which included controlling the posting of entries, closing of the period, interfacing sub-modules, creating new profit centers to defining attributes for the profit centers and maintaining the Chart-Of-Accounts while maintaining the data integrity of the General Ledger.
- Championed the successful change of company reporting structures resulting in a savings of $150K.
- Spearheaded the company migration to use of the Cloud, by re-pointing all financial reports to be stored on the new cloud server saving the company approximately $100K.
- Pioneered Dashboards, Modules, and Links in Lawson Business Intelligence (LBI) so users could access reports and maintain controlled user access.
- Created graphs in Excel as well as PowerPoint to demonstrate growth across various time dimensions for upper management.
- Wrote macros in Excel to streamline manual processes for the finance department; these macros relieved individuals from the monotony of doing needless work.
- Trained users to become Super Users of the Lawson system by teaching them techniques such as creating shortcuts, working with form data, creating re-usable queries, to going on-line and searching the knowledge base including assisting users in resolving system issues as needed.
Confidential, Moorpark, CA
Accountant/Report Writer
Responsibilities:
- Composed VBA macros in Excel to automate processes as well as maintaining an Access database which tracked expenses.
- Formulated a monthly payroll journal entry from the ADP payroll report, uploading it to the SAP General Ledger.
- Held responsibility for the creation of reports in SAP, basic ABAP reports, preparation of the pro forma budget forecast; responsible for the maintenance of pre-paid and amortization schedules including reconciliation of pre-paid accounts.
- Streamlined budget compiling by merging cost and sales information to develop a proforma P&L and saved the company thousands.
- Authored operational reports which captured visit growth for multiple visit types across time dimensions including 12-month rolling, YTD, MTD, and current versus prior year comparisons.
- Utilized personal time to learn the SAP financial module, saving the company thousands in training costs.