Sylvia M. Kapp, Cpa Email & Phone Number

Baton Rouge, Louisiana Area

• Automation of daily processes integrated with Cognos Report Studio, using PowerShell and Task Manager• Support and Development of Enterprise Reporting using Cognos BI tools - 10.2

Baton Rouge, La

• Support and Development of Enterprise Reporting using Cognos BI tools - v8.4 and 10.2 • Data used: payroll, billing, timekeeping, project management, accounts receivables and payables, account reconciliation and journal entry automation• Monitor and audit data quality; research issues and work with Data Warehouse Architect to correct ELT process and/or modeling issues• Worked with end users and business analysts to determine requirements • Development of Framework models: Payroll data for enterprise reporting and systems used by IT: learning management, safety, legal surveys• Use of MS Access, MS Excel, SharePoint and SQL Server databases for augmentation of Cognos reporting

Baton Rouge, Louisiana Area

• Develop reports to management specifications with the highest priority on quality control/data accuracy• Provided training to various levels of management on the running and interpretation of reports• Inventoried existing reports, determined usage trends and modified existing reports as necessary• Extensive use of Report Studio, Framework Manager and Cognos 8 security

Baton Rouge, Louisiana Area

• Consult and advise business users in developing solutions to meet their reporting and analysis needs• Design, Implement and Maintain data warehouse and resulting models, data structures and reports • Configure, Maintain and Administer Cognos 8 Reporting and Analytical tools to access the data warehouse

Baton Rouge, Louisiana Area

• General accounting, including payroll, tax return preparation, accounts receivable and bank reconciliations for nine entities: Three 501(c)3 charitable organizations, two Political Action Committees, two For-Profit corporations, one insurance trust, and the Louisiana Dental Association (LDA)• Marketing for Louisiana Dental Services, Inc. – affinity programs• Worked with Exhibitors and Sponsors for all LDA events• Budgeting for the LDA and two for-profit corporations• Government reporting for the two Political Action Committees• Assisted CPA in annual audit

Baton Rouge, Louisiana Area

Clients:• Oak Terrace Service Center, LLC – 2 month contract - reconstruction of Accounting Systems• The Eaton Group, Inc. – www.eatongroup.com - 6 month contract – Acting Controller• The Eaton Group, Inc. – www.eatongroup.com - 3 month contract – Process redesign and automation in I.T. Department• Our Lady of the Lake Ascension, LLC – 5 month assignment – Controller and HR Director• Century Telephone, Inc. – www.centurytel.com - 4 month OLAP contract• Lamar Advertising Company - www.lamar.com - OLAP Training• East Ascension Telephone Company, Inc. (Eatel) - www.eatel.com - Cognos PowerPlay• Associated Grocers, Inc. – www.agbr.com - Cognos Impromptu• Aegis Mortgage Corporation – www.aegismtg.com - Cognos PowerPlay & Impromptu• Balboa Life. And Casualty – www.balboainsurance.com - System designFunctions provided to clients:• Process design and documentation, including job definitions and internal controls• Determined management’s reporting requirements; then designed and created reports• Learned operational computerized systems and educate staff on those systems• Data manipulation, analysis, report design and documentation of data flows• Extraction of data for creation of multidimensional ‘datacubes’ & OLAP reports• Automation of scheduled jobs• Provided training to end-users; one-on-one, mentoring and in a classroom environment• Development of MS Access database for production piece-work• Accounting Department Controller and General Ledger functions, including daily supervision of staff• Review of staff reconciliations of balance sheet and income statement accounts• Financial statement compilation and analysis• Annual budget preparation and variance analysis• Established Human Resources procedures/documentation for hiring new employees• Review/reconciliation of all payroll and benefits functions

Baton Rouge, Louisiana Area

Technical and Decision Support Specialist - March, 1998 to July, 1999Accounting Information Systems Manager - October, 1991 to February, 1998Accounting Liaison to MIS during financial system conversion - April, 1990 – September, 1991General Accounting Supervisor - November, 1988 - March, 1990 Staff Accountant - May, 1986 - October, 1988

Baton Rouge, Louisiana Area

ON-GOING responsibilities included:• Developed, maintained and continually verified a variety of databases using SQL server 6.0 & 6.5 and MS Access 97• Maintained over 3-dozen standardized monthly reports (Cognos Impromptu and PowerPlay) as needed by management, both executive and field. These included Human Resources, G/L, financial and production information.• Developed adhoc PowerPlay reports using HR, financial, and production data to analyze and define problems, and develop solutions which enhanced the enterprise's effectiveness, and provided the basis for management decisions• Assisted with product research and performance measurement by trend analysis using PowerPlay• Coordinated with MIS during the implementation and upgrade of Cognos software for 40+ users• Provided PowerPlay general training and report development training for production staff and other corporate departments (finance and operations)PROJECTS included: • Development of automated data gathering system for an incentive program to originators• Assisted in creating reports for bankruptcy proceedings

Baton Rouge, Louisiana Area

ON-GOING responsibilities included: • Developed and maintained EMR and IE reports for both financial and statistical systems• Trouble-shooting of General Ledger, Fixed Assets, & Accounts Payable systems• Maintained report distribution system for OLAP analysis at home office (PowerPlay) and to field locations using HTML and the company intranet• Provided PowerPlay general training and report development training for production staff and other corporate departments (finance and operations)• Developed and maintained over 3-dozen standardized monthly reports (Impromptu and PowerPlay) as needed by management, both executive and field. These include Human Resources, G/L, financial and production information.• Assisted various departments with use of Lotus, Excel, Paradox & MS Access software• Oversaw requests from the Accounting department to MIS on various IT needs• Assisted on various committees in software selection (as it would effect the department) including Human Resources and Imaging & WorkflowPROJECTS included: • Development, installation and maintenance of in-house developed A/P system including documentation of system and training of users• Development, installation and maintenance of statistical info housed in the financial system• Assisted MIS in software upgrades• Developed data capture methods and data integration with the mainframe & intranet for the compilation of annual budgets for all field locations• Automated journal voucher entry and upload to mainframe• Implementation of Quality Control Audit Software including training of users• Trained users in MS Access software• Participated in a committee of “power users” in an attempt to standardized data and make it more readily available throughout the corporation• Developed report distribution system for OLAP analysis at home office (PowerPlay) and to field locations using HTML and the company intranet• Hired and trained my replacement

Baton Rouge, Louisiana Area

• Assisted in selection of financial system software• Converted Accounts Payable system from in-house design to GEAC• Converted Fixed Asset system from PC based to GEAC• Developed user guides, Trained accounting personnel• Developed procedures for regular verification of data in the two new systems

Baton Rouge, Louisiana Area

• Day to day supervision of staff (up to 13 people)• Maintained various computerized systems including General Ledger, Accounts Payable, Fixed Assets, and Bank Reconciliation systems• Monthly review/approval of accounts reconciled by staff.

Baton Rouge, Louisiana Area

• Reconciled bank accounts & various G/L accounts• Assisted in the operation of mainframe accounting system including trouble shooting for that system.

Baton Rouge, Louisiana Area

• Audit engagements, financial statements, tax returns• General Ledger system installations and training of client personnel.

Bs, Accounting

As, Computer Science

President of SLU Accounting Association - senior year