Financial Systems Analyst Resume Samples

Description :

1. Communicated successfully with Customer Account Managers and other staff to clearly explain billing processes and procedures and updated customer accounts.
2. Reviewed billing contracts and sales quotes before pushing into production to ensure accuracy.
3. Performed extensive research and detective work in order to reconcile accounts/contracts between Salesforce, Zuora, and Great Plains.
4. Produced reporting for claims staff to help them better track expenses and reduce manual research amounting to 10 hours of saved labor per month.
5. Streamlined extraction of data from a separate database into G/L utilizing SQL resulting in a 9-hour per month time savings for accounting staff.
6. Developed a process for extracting g/l data from eas into statutory reporting application saving accounting team an average of 40 hours per quarter.
7. Provided application support for general ledger package (EAS) and business objects/crystal reports.
8. Monitored daily batch system processes, provided all maintenance and security functions for g/l application, root-cause analysis, troubleshoot issues, and research discrepancies.
9. Managed all aspects of upgrades/patches for EAS including testing, training, and pre/post-implementation support. 

Experience

10+ Years

Level

Management

Education

Business Administration

Description :

1. Owned the AR Salesforce case queue in responding to internal and external requests regarding customer billing and account reconciliation.
2. Establishing and implementing the appropriate risk mitigation and quality control when developing and testing solutions in a tightly-regulated financial services company.
3. Performing data identification, data acquisition, data cleansing, data preparation, completeness testing, data loading.
4. Administering, populating and reporting from Microsoft SQL Server, SAS Financial Management, Bancware Asset Liability Management and Axiom Profitability Financial Systems.
5. Responsible for the production of all reporting outputs required within the finance department.
6. Facilitating meetings, defining the new business rules and requirements and establishing the standard operating procedures.
7. Reporting metrics on program execution and funding status for facilities program to higher headquarters on a daily, weekly, and monthly basis.
8. Audit liaison between directorates and various federal audit agencies.

Experience

10+ Years

Level

Senior

Education

BS

Description :

1. Supporting and advising the department of management and finance on oracle general ledger, fixed assets, cash management, web ADI, and Public Sector Budgeting (PSB) issues and topics, including maintaining current year budget, building future years budget, supporting monthly and yearly closes.
2. Working with the budget team on planning and creating an annual budget within Oracle PSB module while navigating the county's budgetary process.
3. Supporting and advising all county departments on financial system issues and opportunities.
4. Providing full-service support (requirements gathering, development, testing, training, implementation, and post-go-live support) for enhancements.
5. Working with technical resources on a day to day support as well as customizations.
6. Developed Request for Information (RFI) for a budget replacement solution, organizing and leading subsequent vendor demonstrations.
7. Built County's Comprehensive Annual Financial Reports (CAFR) and other financial statements (through Oracle FSQ) capturing actual, budget, and encumbrance balances across multiple fiscal years.

Experience

10+ Years

Level

Consultant

Education

BS

Description :

1. Stood up quality assurance management program, management internal control program to ensure the security of financial management operations.
2. Conducted in-depth business process analysis and financial data mining.
3. Developed requirements and applications to streamline processes and automate data analysis reducing manual input by 75%.
4. Developed and managed 15+ access end-user and data integration database applications to automate financial data flow and accounting processes.
5. Defined and validated the requirements, gathered financial data.
6. Conducted analysis and studies utilizing budget statistical formulas, compared current and historical program data to prepare reports, forms, and schedules due to higher headquarters for the newly consolidated air force facilities sustainment, restoration, modernization, and demolition programs, totaling over $500m annually.
7. Developed and automated daily and end-of-month financial reports and performance metrics.

Experience

10+ Years

Level

Consultant

Education

BS

Description :

1. Facilitating sessions to gather requirements across regional user base for new SAP functionality enhancements.
2. Analyzing and resolving issues related to external customer invoicing, inter-entity invoicing, order-to-cash, purchasing advanced return mgt in SAPs ECC system.
3. Creating and maintaining the end user documentation system process documentation for the accounting dept.
4. Analyzing and researching the finance customer problems, identifying resolutions to issues in a timely manner.
5. Monitoring invoicing error reports ensuring accurate timely processing of customer inter-entity invoices.
6. Auditing the monthly premiums and managed financial open enrollment for the clients.
7. Providing the clients with monthly benefit invoices as well as cobra reimbursements using a proprietary database management software.
8. Partnering with senior financial systems analyst to determine the cause of any issues within the Lawson HR/Payroll system and determine a course of action to correct them.

Experience

5-7 Years

Level

Executive

Education

MBA

Description :

1. Worked for the asset services department for the support of accounting applications and reporting platforms as a software super user resource, involving in national company projects and initiatives and participating in the development of improved business applications, tools, and processes.
2. Worked for the asset services department with the support of a web-based operating platform called “CORE”.
3. Involved in the design, implementation, training, and support of the operating system.
4. Planned and prepared “CORE” with data related to each market/sub-region roll out.
5. Performed analysis and provided the solutions to complex financial system problems related to “core” real-estate functions such as accounting, property management, and client reporting.
6. Supported the asset services with all accounting applications, including MRI, Yardi, Pay, Collect and Kardin.
7. Identified the complex financial system problems and provide solutions related to real estate functions such as accounting, property management, and client reporting.

Experience

2-5 Years

Level

Junior

Education

BS

Description :

1. Assessing the validity of open balances by evaluating the key supporting documents provided by commands, determining if those documents substantiated the open balances and provided necessary feedback to commands for future testing improvements.
2. Auditing the fund's holders and budget submitting offices tri-annual submission through the joint reconciliation program process, and submitting those results to support the fiar requirements.
3. Helping to design and implement new payroll processes and system enhancements to better process payroll in lawson.
4. Set up, maintaining, training and auditing of both the staffing and scheduling and time and attendance system.
5. Helping plants solve costing issues as next period standard costs are created.
6. Administering the project management tool workfront support for the fpa department which includes gathering business requirements and creating forms and task list to accommodate business needs.
7. Administering Oracle Data Relationship Management (DRM) application support which includes data loads, validation, structural updates and trouble shooting.
8. Completed over hundred new set-ups on time and accurately, including new deals, investments, properties and companies.

Experience

10+ Years

Level

Consultant

Education

BS

Description :

1. Performing production support activities such as evaluating patches/fixes, maintaining system configurations, running batch cycles, testing, and estimating enhancements for additional funding.
2. Developing and improving the internal functional processes to create a ready environment for future employees to have instructional and informational aids in order to quickly and effectively become value-added members of the audit team.
3. Created and maintain databases, tables, views, indexes, users and groups on a QA server and a production server.
4. Created and maintained SSIS packages that pull data from several inside and outside sources into database tables.
5. Responded to member inquiries regarding their cobra, loa or retiree coverage and invoice issues.
6. Queried databases and compiled data into usable reports, both standard and on demand.
7. Responsibilities include set up, maintenance, training, and auditing of the staffing and scheduling and time and attendance system. 

Experience

10+ Years

Level

Consultant

Education

BS

Description :

1. Effectively coordinated and managed a wide range of financial projects to support federal and private foundation grants, federal and corporate contracts, and scientific portfolio management.
2. Automated lab projection processes by replacing the manual entry with a series of summary reports driven by pivot tables drawing information from the data warehouse.
3. Collaborated with IT to create and streamline a wide range of information stored in our data warehouse.
4. Helped the Project Managers, Budget Managers, and Program Coordinators to more easily retrieve the information needed to stay on target while tracking award funding.
5. Supplied multiple types of financial reports which included additional analysis of IDC rate, fringe rate, and budget variances, to the office of sponsored research to meet NIH reporting requirements.
6. Liaisoned to Project Managers, Budget Managers and Program Coordinators where accounting knowledge is indispensable. Supplied complex transactional detail for cost transfers.
7. Trained and provided ongoing support to principal investigators and research support staff on financial systems, ensuring comprehension of expectations and protocols.

Experience

7-10 Years

Level

Senior

Education

College

Description :

1. Documented enhancements for existing systems by analyzing requirements, constructing workflow charts and diagrams, determining system capabilities, assisted with writing technical specifications.
2. Analyzed and document4e business processes to help identify opportunities for improvement through automation.
3. Established the cost accounting structure of the projects.
4. Provided assistance in the budgeting and scheduling process.
5. Documents budgeting results in SAP.
6. Participated with the scheduling professionals in the creation of project schedules and product reviews.
7. Provided earned value management in accordance with the Management Control System Description (where required).
8. Monitored costs to ensure accurate accounting. Facilitated cost corrections and/or prepares account correction documents.
9. Provided the end-user application support for all ERP and related applications. This included troubleshooting errors, coordinating with vendors, managing support tickets, training and testing solutions.

Experience

10+ Years

Level

Management

Education

MS