Project Manager Management

Allen W. Brown

** ******* ***** ( Norwalk, Connecticut 06851 ( C 203-***-**** ( H (203)

***-**** ( *********@*****.***

SUMMARY

An analytical and goal-oriented financial systems professional, with

extensive experience in strategic and financial planning, Sarbanes-

Oxley (SOX), corporate accounting, database administration, computer

operations, hardware and software, systems analysis, systems

engineering, implementations and upgrades. Deploys financial

professional services to achieve corporate goals. Identifies tasks,

issues and risks to meet short- and long-term goals within given time

frames. A technically oriented implementer and financially savvy

problem-solver, who collaborates and brainstorms with teams to deliver

profitable solutions. An experienced implementer, with the knowledge

and ability to integrate financial reporting information and

solutions.

EXPERIENCE

PepsiCo, Purchase, New York

Manager, Financial Systems, 2003-2011

Served as manager of financial systems to implement and administrate

Hyperion Financial Reporting (HFM) Systems within controllers' group at

PepsiCo. Sustained and stabilized Frito-Lay Hyperion snack-consolidation

systems during transition period until creation, development and deployment

of new PepsiCo International financial reporting systems, and analyzed,

grew and implemented into single integrated system. Coordinated,

collected, reviewed and implemented quarterly Hyperion development changes

per user request through system entity, account, logic and report changes.

Managed security user profiles per Sarbanes-Oxley compliance. Reviewed and

cultivated current business strategies for long-term development.

. Instrumental in implementing two significantly different IT reporting

systems in the controllers' department.

. Led task force to upgrade, develop and implement to fully integrated

Web-based system, HFM.

. Gathered user requirements to build single repository for data

collection and analysis governed by standard accounting rules and

requirements.

. Deployed HFM to 60 countries and trained users on new system.

. Created and established business intelligence reports for profit and

loss, balance sheet, cash flow and corporate tax items for entire $27

billion corporation.

. Streamlined periodic data collection for snack and beverage

submissions, and reduced reporting volume by approximately 50%.

. Demonstrated project management skills through spearheading internal

projects and programs, as well as developing and delivering training

to staff.

ISA Consulting, New York, New York

Consultant, 2003

Directed and delivered business intelligence, data warehousing, and

budgeting and planning initiatives across variety of business sectors in

the distilling industry. Analyzed sales and marketing data on behalf of

various corporate and operating divisions, utilizing Cognos Business

Intelligence Tools.

. Assisted clients with development of Cognos PowerPlay on behalf of

custom user-class security views, based on security profiles.

Gathered and interpreted security requirements applied through Cognos

PowerPlay and Transformer configuration.

. Aided clients with development of Cognos business intelligence

reporting relating to travel and entertainment expense management

applications. Researched and interpreted business requirements to

develop, create and write business intelligence reports, utilizing

Cognos Impromptu and IWR to address purchase card initiatives.

. Installed, upgraded and deployed full Cognos Series 7 Version BI

Suite, PowerPlay, Transfomer, Impromptu, IWR, Upfront, Deployment

Manager, Access Manager and Netscape Directory Server. Planned

upgrade, development and coordination of system and user acceptance,

and testing with rollout strategy plan. Delivered upgrade on time

within scope of project.

Accenture, Dearborn, Michigan

Senior Consultant, 2002-2003

Served as independent subcontractor to assist world's leading automotive

interior supplier, Lear Corporation. Gathered and analyzed business

requirements to implement, configure and deploy enterprise expense

management solution.

. Create and develop user interface for expense category selections and

report management.

. Create and develop Business Intelligence reports to manage Travel and

Expenses.

Concur Technologies, Norwalk, Connecticut

Project Manager/Senior Consultant, 1998-2002

Spearheaded, designed and managed system implementation within client

framework, including business analysis, process design, application

configuration, enterprise readiness and company deployment. Produced

statement of work, project plans and cost estimates. Provided Cognos

business intelligence and report writing solutions on behalf of expense

data analysis, creating advance impromptu reports, catalogs, prompts,

filters and conditions. Created PowerPlay cubes, dimensions and measures.

Wrote status reports, logged and tracked technical issues, and guided

project implementation from pilot to full company deployment, with assigned

scope, task, time and budget parameters.

. Designed and created functional and technical specifications and

custom engineering specifications, based on user-interface, work-flow

and data-extraction designs.

. Provided Fortune 500 clients, including CitiGroup, Harvard University,

Avon, Boeing, Barnes & Noble, subject matter expertise on travel and

entertainment expense management.

. Met milestones and technical troubleshooting deadlines of Concur's Web-

based product components.

ADDITIONAL EXPERIENCE

Metromedia International, Stamford, Connecticut, Information Technology

Applications Manager, 1997-1998. Served as manager for worldwide leader in

radio, cable television, paging and telecommunications in Eastern Europe

and Central Asia. Responsible for planning, development and support of

core financial applications at company headquarters. Selected and deployed

enterprise-wide travel and entertainment expense reporting system. Chose

vendor and negotiated contract and purchase price. Designed scope of

project kickoff, assembled pilot group, ensured data integrities, and

measured results and compliances within given time parameters. Improved

accessibility of standard core financial reports and distribution to senior

and executive management.

Beatrice Foods International, New York, New York, Financial Systems

Manager, 1995-1997. Developed and maintained financial system

applications, including Hyperion, Macola General Ledger, Lotus cc:Mail and

Novell Local Area Network Administration. Improved efficiency of Hyperion

Financial Reporting System by decreasing monthly, quarterly and annual data

collection by 20%. Rolled out Lotus cc:Mail to European division. Served

as project manager for facilities group move.

THE NEW YORK TIMES COMPANY, New York, New York, Consultant, 1994-1995.

Served as independent consultant for systems administration of Hyperion

Enterprise applications

PLAYTEX APPAREL, Stamford, Connecticut, Senior Systems Analyst, 1990-1993.

Implemented micro-based financial systems for International Division.

PRUDENTIAL RELOCATION MANAGEMENT, White Plains, New York, Financial

Analyst, 1985-1990. Acted as accounting clerk, post-closing auditor and

budget analyst.

EDUCATION

Mercy College, Dobbs Ferry, New York, B.S., Business Administration

PROFESSIONAL DEVELOPMENT

Oracle HFM Systems Administration Training, 2010

COMPUTER SKILLS

Hyperion Financial Management (HFM); Smartview, FDM, Hyperion Enterprise

v6; Autopilot, Schedules, Report Client, DataExtend, LedgerLink, Retrieve,

Cognos BI Series 7 PowerPlay, Transformer, Impromptu, IWR, Upfront, Query,

Visualizer Concur Expense 6x, RDBMS Administrations MS SQL Server

2000/7.0/6.5, Oracle 7/8i, SqlNet, SqlPlus, ODBC, MDAC Language; Structure

Query Language (SQL), VB Scripting, HTML, ASP, Web Browsers, Server:

Microsoft IE 6/7/8, Internet Information Server (IIS), Netscape, iPlanet

Directory Servers Network Administration: Windows 2003, Windows NT 4.0,

Novell Netware 4.11 & 3.12 Office Suites; Microsoft Excel, Word, Access,

PowerPoint, Project and Visio Operating Systems; Microsoft Windows 7,

Vista, XP, 2000, NT 4.0, UNIX, DOS

Contact this candidate