Patty Landrum Email & Phone Number

United States

Miamisburg, Oh

Expert knowledge of source systems and business practices to generate Web intelligence reports utilizing tools and dashboards in SAP Business Objects. Identifies workflow/system improvements and collaborates with IT and operations through the improvement cycle from request for change to testing, and deployment to production. • Program Manager for Customer Information System: Meet with stakeholders to gather new product requirements, translate them into formal written business requirements, and submit to IT developers setting prioritization. • Expert understanding of the complex Customer Information System business practices for data management and workflow. Perform large datasets analysis of the Customer Information System data using Excel spreadsheet formats.• Received end user 1st level support calls and support/incident tickets through the ServiceNow incident management system. Provide support of systems, reporting requests, and network to end users as necessary.• Created Teradata Connections page for groups to collaborate and share information that supports and encourages the use of specific applications.

Experienced business intelligence analyst adept with creating queries using business intelligence tools Business Objects XI and Cognos to meet information needs of business groups, and identify opportunities to reduce expenses and increase productivity.• Selected to serve on a team charged with creating an Executive Dashboard for corporate executives to view financial results. Co-defined business requirements and performed User Acceptance Testing with knowledge of Hyperion Financial Management to successfully complete the project on time, meeting all requirements.• Created queries using business intelligence tools Business Objects XI and Cognos to meet information needs of business groups, and identify opportunities to reduce expenses and increase productivity.• Serve as a subject matter expert for various EDW/Business Objects universes. Testing changes to source data and approve prior to deployment into production environment saving time and costly rework.• Played a major role in the replacement of Hyperion Enterprise with Hyperion Financial Management. Communicated to IT the requirements for web data capture tool designed to capture and store metadata in EDW ensuring that data warehouse was fully utilized. • Contributed to the successful migration of Cognos to Microsoft Analysis Services. Key actions included defining business requirements and partnering with outside consultant to deliver actionable financial information using Microsoft Performance Point.• Served as a liaison between senior management and IT staff to clarify business objectives resulting in transitioning the company from a business unit model to a functional group model.

Support Americas Shared Service Center monthly forecasting including P&L analysis and capital plan tracking.• Played a key role in the research and preparation of the monthly outlook review process analyzing financials and preparing commentary ensuring that accurate and timely data was available for senior management.• Eliminated 55% of variances to monthly outlook expense for travel, pension, benefits, bonuses, and telecom by reviewing with mid level management detailed statement of activity reports and identifying areas of expense reduction.• Coordinated the Shared Service Center annual plan review process resulting in stronger accountability and ensuring all centers followed annual plans direct charges and guidelines.• Consolidated Shared Service Center $13 million annual plan into Hyperion Pillar meeting all critical deadlines during the annual plan submission.

As Senior analyst in the Corporate Accounting department prepared monthly financial statements, account reconciliations and detail P&L analysis.• Performed general accounting functions focused on timely and accurate accruals and reversals for high risk items that impacted the company’s bottom line results. • Supported Corporate annual plan process. Provided detailed instructions to management to ensure accuracy for submitting annual plans into Corporate planning system.• Coordinator of the Controller’s Group Risk Review Process. Prepared quarterly Risk Review schedules used by management to enhance corporate-decision making for items that were high exposure to company operations. • Leveraged knowledge of Oracle General Ledger creating monthly P&L statements used to generate consolidated monthly reports critical to monthly closing process and enhance timely submission of financial results to Corporate Consolidations.