Shauna Schmidt Email & Phone Number

Chandler, Az, Us

Chandler, Arizona, United States

Phoenix, Arizona, United States

Responsible for the day-to-day management of the general ledger (GL) and reporting out of the GL system. Participates in the mapping and coordination of sub ledger systems information into the general ledger. In addition, is responsible for creating general ledger reports to assist in management and regulatory reporting. The FSM is also responsible for the administration and maintenance of the Accounting department reconciliation application.Oversees the configuration of the company’s general ledger, sub-ledgers and reconciliation tool to ensure accurate and timely reporting. Works with various subledger owners throughout the organization to understand impacts of various processing on the general ledger and reporting. Troubleshoots, researches & documents data integrations, file transfers, data integrity issues. Troubleshoots variances between reports, reconciling sources and ensures appropriate escalation and issue identification and documentation as needed.Responsible for the overall processing of nightly subledger files into the general ledger and ultimate balancing of those files. Primary contact with IT department for efficient processing. Primary liaison for new products and implementation of those products on the general ledger. Responsible for the configuration of daily reporting of loan and deposit balances to the company as well as executive management.Works with the Financial Reporting Managers to configure reporting to help generate specific reporting for SEC, FRB and FDIC reporting. Assists in the preparation and delivery of periodic reports to the Board of Directors.Department lead on compliance with critical spreadsheets corporate policy.Facilitates compliance with internal audit, Sarbanes-Oxley, and all issues associated with maintaining a strong internal controls environment. Coordinates with SOX testing, internal audit, external audit, FRB & FDIC examination teams.

Santa Barbara, California, United States

Unique combination of technical programming skill and knowledge of accounting and financial systems. Knowledge of programming and system design and analysis and responsible for leading other Financial Systems Analysts in the design and implementation of the core programming architecture for the most complex and/or critical financial systems.1. Lead the development of mission-critical county-wide financial applications; make core architectural decisions on the data and programming methodology based on technical and accounting requirements; guide other Financial Systems Analysts and programmers in the implementation of selected architecture.2. Write complex programming code for financial applications using up-to-date technical tools and languages; develop core programming architecture for application team to follow; oversee development of various application modules and provides oversight and technical assistance as required; responsible for overall outcomes and milestones.3. Lead special projects such as researching and recommending new technologies to the department head that will help achieve the goals of the department; serve as the expert on new technologies and develop training program for other developers and staff.4. Provide high-level troubleshooting and problem solving for all Auditor-Controller supported applications; provide high-level assistance to other developers as needed to successfully solve system problems; make core programming changes to all major Auditor-Controller applications when required by changes in use, technology, or accounting practices.5. Provide SQL Server database administration; make decisions on roles and permissions related to applications.6. Oversee the development of user guides for various Auditor systems and modules; create and maintain system documentation that describes technical architecture and system design; create and maintains database documentation to be used as a reference guide.

Santa Barbara, California Area

Participate in and coordinate the design, testing, implementation, and evaluation of automated and manual financial accounting and payroll systems. Financial Systems Analyst II is distinguished by its responsibility for coordinating the design, modification, and implementation of a full range of financial accounting and payroll systems, including large, complex, Countywide systems, such as the Financial Management Information System and Pay+.1. Evaluate manual and automated financial accounting and payroll work processes, systems, and procedures for efficiency of workflow and conformance to principles of government accounting and payroll.2. Obtain input and feedback on system needs from appropriate parties; conduct or obtain evaluations of system performance and makes modifications or adjustments as necessary. 3.Review and evaluate proposals for new departmental systems involving financial accounting and payroll methods, policies, and procedures, and recommends needed improvements; evaluate internal controls and security of new and existing automated accounting and payroll applications to ensure adherence to auditing standards; monitor the procurement, development, and implementation of those systems to ensure proper integration with other financial accounting and payroll systems;4.Prepare and present comprehensive evaluations, proposals, and recommendations to executive management, advisory committees, and elected officials; Ability to: gather and analyze data, develop solutions, project consequences, and evaluate results; establish and maintain working relationships with a variety of County staff and vendors; interact with staff with limited computer knowledge; prepare a variety of written documents; make presentations to groups; maintain impartiality and objectivity; delegate work; balance competing priorities; gain cooperation and consensus through discussion and persuasion; represent the department with tact and diplomacy.

Santa Barbara, California Area

Integrate knowledge of systems analysis and design methods, computer application systems and development procedures, Generally Accepted Accounting Principles, and Generally Accepted Auditing Standards to develop, modify, and implement financial accounting systems.Knowledge of: Generally Accepted Accounting Principles, including internal control systems; Generally Accepted Auditing Standards; methods of systems analysis and computer systems design; computer programming principles; applications development procedures; relational databases and database design methods; principles and practices of project management; Ability to: gather and analyze data, develop solutions, project consequences, and evaluate results; plan, organize, and prioritize work; establish and maintain working relationships with a variety of County staff and vendors; interact with staff with limited computer knowledge; prepare a variety of written documents; make presentations to groups; maintain impartiality and objectivity; learn principles of governmental accounting and County accounting policies and procedures; provide direction to others.• Design, develop, document and upgrade accounting systems, business applications and web service applications • Maintain a high level of security, internal controls, stability and performance of applications • Functional understanding of accounting and experience with finance based applications• Exposure/aptitude in application development/computer technology with financial related systems• General knowledge and the ability to operate and develop applications in a modern web based environment including the ability to write software code (i.e. .NET, C#, SQL, Access) • Knowledge of accounting principles and experience in auditing or accounting • Logically approach and resolve complex accounting issues • Experience in governmental accounting or auditing • Excellent communication, documentation and teamwork skills

Assists in maintaining all aspects of the Integrated Financial Administration System (IFAS), and other financial systems used by the foundation. Responsible for general system administration functions, including integrity checks with Advance, the gift system, and Fundriver, the endowment management system. Assists with web forms, work flows, security access, and reports related to the foundation’s financial systems. Apply a working knowledge of Generally Accepted Accounting Principles (GAAP) and Non-profit Reporting requirements to all work flows and reports. Provide financial system support and trouble shoot system problems, provide excellent customer service to system users, and act as a liaison between Finance and IRM (Information Resource Management, IT). Reports to the AVP of Financial Services.•Maintain access and security to the Foundation’s financial system.•Maintain the Foundation’s chart of accounts, which includes creating new accounts in both the financial and gift processing systems.•Create and modify financial system reports using VB Script.•Provide support to internal users of the financial system (accountants, development officers, etc) and to external users at the University.•Document internal procedures, e.g. desktop procedures manual.•Serve on reorganization committee.•Assist with yearly audit process.•Complete quarterly data integrity checks between several systems.•Integrate with departments across the Foundation to complete special projects.

•Supported accounting and finance department’s use of Great Plains. •Created financial statements and reports for 16 Schaller healthcare companies.•Wrote ad-hoc reports for the use of accountants and management.•When Aetna acquired Schaller Anderson, learned new systems and report writers: Oracle, Clarity, Essbase.•Filled in as an accountant for two months while the company was short staffed.•Assisted with SAS-70 audit reports.•Helped accounting with special projects, e.g. fixed asset inventory audit.

Disney'S Hollywood Studios

Trained in world class customer service at Disney University.

Master Of Business Administration (M.B.A.), Mba

Bachelor Of Science (B.S.), Computer Information Systems