Rosalyn J. Ehlert ______ -- __________
507 W. McDowell Odessa, MO 64076 Home Phone: 816-565-2518 Cell Phone: 816-716-3359
Administrative/Clerical Support Downloading/Uploading Data Project Setup / Management
Accounts Payables Financial Analysis Proposal Cost Estimates
Accounts Receivables Fixed Asset Processing Purchase Order Generation
Account Reconciliation Forecasting/Budget Coordination Records Management / Accountability
Administrative Project Management General Ledger Analysis Reconciling Depreciation
Bank Deposits & Bank Reconciliation Handling Classified Documents Reconciling Fixed Assets
Billing and Collections Inventory Control Resolving Cost Discrepancies
Computer / Internet Competent Journal Entry Processing Revenue Recognition
Contract and Cost Analysis Managing & Reconciling Petty Cash Reviewing Financial Reports
Customized Data Queries Month-End Reporting Multiple-Line Phone Systems
Customer Service Office Management 11,000 Data Keystrokes Per Minutes
Data Entry and Transcription Payroll Compilation Type 70 Words Per Minutes
Data Review and Verification Procedure Writing 10-Key To Touch
Customer Account Representative Lincare 6/6/2010 – Present
? Research overdue accounts that are partially unpaid and follow up by phone or mail with customers on past due balances and delinquent payments.
? Respond to customer inquiries regarding account balances, account charges, EOBs, pending insurance claims, payment arrangements, and available financial assistance.
? Document all written and oral communications with patients regarding account charges, EOBs, balances, and collection activity in account activity/communication logs.
? Resolve account discrepancies with customers, service centers, insurance representatives, and supervision.
? Process adjustments and refunds as necessary and document supporting information in account communication logs.
? Process electronic fund payments for customers.
? Coordinate communication with internal collection center regarding uncollectible accounts.
? Update patient information and coordinate updates with insurance and service center representatives.
Data Specialist City of Blue Spring Police Department 2/26/2007 – 6/6/2010
? Provide records support for the Police Department and Public utilizing Vision RMS, Vision Jail, Docushare, Incode (Municipal Court Data System), Prime Court Records, ALERT, MULES, NCIC, Master Name History (MNHS) records, and Microfiche.
? Review police reports for accurate documentation and completeness. Copy documents required for distribution to the State (MSHP), Detective Unit, and Dispatch. Upload scanned incident reports to Docushare (shared database) and verify data accuracy making any necessary corrections.
? Enter police incident reports into RMS database ensuring accurate coding; enter and verify racial profile reports; enter traffic tickets into Incode; and enter DWI reports into DWITS.
? Process liquor license permits, fingerprint requests, private security requests, and video requests.
? Process criminal background checks utilizing Incode (municipal court records) and Prime Court Records for government and law enforcement agencies; and process incident report requests in accordance with Missouri Sunshine Laws.
? Manage Juvenile Files per Calea requirements.
? Handle receipts, reconcile cash, and update required statistical report data monthly.
? File reports, answer lines, and respond to administration needs as required.
? Provide Reserve Dispatch support on weekends and off-hours.
Utilities Clerk City of Sugar Creek, Missouri 6/15/2006 – 2/23/2007
? Responsible for all Utility Billing activity; verified and posted daily utility receipts; managed customer service changes; managed ACH payment processing; managed meter reading interface; maintained deposit records; maintained sewer surcharge records; maintained outstanding balance data; entered billing and receipting adjustment journal entries; and provided customer service support.
? Provided back-up support for the City Collector, Municipal Court Clerk, and Receptionist.
Temp, Temp-To-Hire Employee Office Team 2/1/2006 – 6/14/2006
? Worked on temporary assignment in the Records Department of the Blue Springs Police Department providing customer service support, data entry, liquor license badges, cash receipts reconciliation, report searches, scanning records, filing, answering phones, and handling mail.
Rosalyn J. Ehlert Page 2
Contract/Account Manager MMG Worldwide 3/2005 – 1/2006
? Managed all accounting and subcontract aspects on the Missouri Division of Tourism Account.
? Responsible for updating and interpretation of the Standard Operation Procedure Manual.
? Monitored minority owned business (MBE) and women owned business (WBE) status.
? Liaison between client, vendor, and project team leaders regarding invoice backup and account payable issues.
? Responsible for client invoices, wire transfers, bank deposits and distribution of cash receipts.
? Processed weekly vendor check run payments, monthly retainer fee, and subcontractor fees.
? Supervised and accounting clerk functions of invoicing, general ledger coding, and related data records.
? Performed month-end financial analysis and process journal entries.
? Ensured all required month-end reports and billings are complete.
? Reconciled bank account, account payables, and account receivables
Resource Manager Heartland Districts Office of the United Methodist Church 8/2002 – 3/2005
? Collected and distributed connectional information for 200 churches; administratively supported the Superintendents for the three Heartland Districts
? Supported various ministries by making available the resources of the General Church and related agencies.
? Collected apportionment payments and maintain related records.
? Maintained districts web site, bank deposit records, financial records, and personnel records.
? Designed, printed, and processed mailings of correspondence, newsletters, brochures, directories, flyers, etc.
? Maintained updated mailing lists, e-mail addresses, and phone numbers for local churches.
? Collected information, performed data entry, and maintained related files on 200 area churches.
Project Accountant Midwest Research Institute - Kansas City, MO. 11/1999 to 7/2002
? Set up and maintained project-related information for EPA, DOT, NAS, and DOE contracts in the accounting system complying with each project’s contractual requirements.
? Invoiced clients complying with contractual requirements and in compliance with DCAA overhead rates.
? Monitored project funding, performance periods, budgets, work force requirements, labor categories, labor rates, billing status, cost overrun resolutions, and revenue actions.
? Managed project-related account receivables and accounts payables.
? Maintained analytical reports supporting cost overruns.
? Reviewed project costs and recognized revenue.
? Provided project data to DCAA auditors.
? Established and maintained electronic fund transfer processes.
? Reconciled fixed assets, depreciation, service fee, and liability accounts.
? Made necessary adjusting journal entries.
? Created and ran analytical data queries supporting reconciliation and information needs.
Senior Administrative Assistant PQ Corporation - Kansas City, Ks. 5/1996 to 10/1999
? Provided administrative, payroll, customer service, and office management support.
? Supervised the activities of the office staff and conducted recruitment interviews.
? Reconciled product inventory to production data, receivals, and shipments.
? Verified raw material usages against bill-of-material standards.
? Coordinated raw material and expense item purchases.
? Analyzed and reconciled cost discrepancies ensuring proper allocation of fixed costs to established budgets.
? Reconciled labor charges to general ledger accounts.
? Ensured compliance with current accounting practices, corporate policy, and ISO requirements.
? Managed accounts payables, petty cash distributions, local bank account reconciliation, charitable contributions, and purchasing card usage.
? Coordinated monthly forecasting and compilation of annual budgets.
? Developed analytical spreadsheets to trace and control of restricted expenses.
? Installed new system software applications and upgrades, and managed systems access authorization lists.
? Trained co-workers in accounting, purchasing, software, and system application practices.
? Developed new information processes and implemented process improvements.
? Coordinated arrangements for business travel, dinner engagements, and special events.
? Coordinated design and implementation of the SAP Production Module Interface, PRISM, project.
? Coordinated and installed software upgrade for the PAF Performance Appraisal System project.
Rosalyn J. Ehlert Page 3
Project Accountant Midwest Research Institute – Kansas City, Mo. 5/1994 to 5/1996
? Managed departmental administrative functions and Supervised and trained secretarial staff.
? Set up general ledger, overhead, fringe, and project revenue accounts.
? Maintained project funding, work structures, budgets, labor categories, and labor rates.
? Ensured that funding, fringe, overhead, and fee rates applied to all projects were contractually accurate.
? Compiled project proposal estimates, project budgets, financial budgets, and monthly financial forecasts.
? Reconciled project costs, overhead costs, and project labor charges to established project budgets.
? Reconciled account payable codes, month-end project costs, and project revenues.
? Coordinated collection of past-due accounts.
Administrative Analyst AlliedSignal – Kansas City, Mo. 3/1980 to 5/1994
? Administratively supported Engineering Departments and Special Projects utilizing dictation, transcription, word processing, and analytical skills.
? Supported planning and implementation of new business systems.
? Designed data models, reporting metrics, and data verification methods.
? Prepared project cost, manpower estimates, and documented project performance.
? Supervised and managed departmental administrative operations.
? Developed administrative processes and practices; and facilitated process and informational improvements.
? Coordinated, composed, and published operating procedures, guidelines, and instructions.
? Conducted pre-employment background research.
? Monitored production workload and shipments against delivery order requirements.
? Analyzed production performance data, compiled performance statistics, and published status reports.
? Designed database files and wrote customized data queries.
? Instructed subordinates on software applications and business processes.
Part Time Work History
Self-employed Income Tax Preparer Hometown Income Tax Service 2004 – 2010
? Prepared income tax returns, provide e-file service, researched tax information, support clients regarding tax issues, maintain current tax software via Internet downloads from a home office.
Income Tax Preparer H&R Block 2003 Tax Season
? Prepared income tax returns, researched tax information, and provided advice regarding tax issues to clients.
Computer Applications Experience
Software experience in both a Windows and NT Server Environments: Vision RMS, Alert, Incode, Docushare, Court Records, Fund Balance Utilities Software, Advantage Accounting Software, CostPoint Accounting Software, Deltek Accounting Software, SAP Accounting Software, Legacy Accounting Software, Quickbooks, Internet Explorer, Microsoft Office, Microsoft Publisher, WordPerfect, QMF/SQL, FOCUS, Lotus 1-2-3, Freelance Graphics, Harvard Graphics, Smart Suite, dBase, Intellitax, TRX Pro tax software, OLTPRO tax software, and TurboTax.
February 2010 – American Heart Association, Kansas City, Missouri
December 2009 – Kansas City Missouri Police Department
February 2008 – Kansas City Missouri Police Department
October 2003 – H & R Block, Independence, Mo.
Advanced Income Tax Preparation Certification
November 2002 – H & R Block, Independence, Mo.
Basic Income Tax Preparation Certification
May 1997 – Friends University, Wichita, Ks.
Bachelor’s Degree in Human Resource Management with a Business Management Emphasis.
May 1989 – Longview Community College, Lee’s Summit, Mo.
Associate Degree in Business Administration with an Accounting Emphasis
Awards and Honors
Awarded a Federal Q Security Clearance 1980 – 1994
Member Phi Theta Kappa Honor Society 1985 – 1989