PROFESIONAL SUMMARY:

• Highly skilled accomplished professional with over 10 years of extensive TM1 and Hyperion Essbase architect and development experience
• Successfully drove TM1 implementation at Confidential Foods and Confidential establishing a budgeting and forecasting performance management system
• Over 10 years of experience as Accountant, Financial Analyst, Marketing Analytics and Budgeting and Forecasting
• Team player highly dedicated individual with strong management and leadership, analytical, organizational, planning and intrapersonal skills

TECHNICAL SKILLS:

Desktop Software: MS Office Suite (Excel, Access, Power Point, Word and Outlook) and Visio.

Programming Languages: TM1 program Language (C++), Visual Basic for Applications (Excel 2003 and Access 2003).

Databases: Expert MS Access

SQL: Over 13 year experience with Teradata, Oracle SQL and QMF writing experience

OLAP Tools: Cognos TM1, Cognos BI, Hyperion Essbase, Tableau.

Other Tools: 09 Mpower Integrated Planning & Management tool

Oral Written Presentations: Continuous experience presenting results both orally and written

PROFESSIONAL EXPERIENCE:

IT - Business Technology Consultant

Confidential

• Implementation, architect, development, administration and maintenance of IBM Cognos TM1 BHPB Production, Development and QA environments systems
• Responsible for all TM1 design, development and implementation of dimensions, cubes, rules, feeders, and processes for BHPB
• Continually collaborating with the business to further enhance and streamline the existing BHPB TM1 budgeting and forecasting performance management system
• Partner with the business leaders at BHPB to architect develop newly required TM1 models to meet the needs of the growing business units.
• Post sale of Confidential consumer products division managed a one year TSA agreement between Confidential Philippines and BHPB which involved all maintenance and tickets which enabled Confidential Philippines to continue to operate utilizing the TM1 budgeting and forecasting performance management system on a Confidential standalone server
• Develop and administer all TM1 training material for BHPB as well as conducting group and one on one training sessions
• Support the TM1 user community at BHPB by working on and resolving TM1 tickets as well as supporting the individual needs of the user community by providing one on one service to remedy any issues users may have
• Responsible for all SQL used within BHPB TM1 processes
• Project manager/architect executive summary project on 09 Intelligent Decision Management Platform
• Project manager/Cognos BI for pet specialty daily channel sales report by sales representative
• Develop, implement new TM1 reports and templates as well as support existing reports and templates

Manager Operation Finance & BI

Confidential, San Francisco CA

• Operations Finance Department TM1 systems support and maintenance
• Prepared monthly Ending Inventory reporting and variance analysis
• Continued system improvements through enhancements and streamlining
• Responsible for Confidential KPI TM1 system Architect and development
• Responsible for Training all new hires and existing users on the Operation Finance TM1 MFG system.
• Reconcile TM1 system to ensure reporting accuracy between different company systems.
• Work closely with key members of the MFG operations team to continually ensure all aspects of the TM1 reporting system are accurate at all times.
• Work with departments within operations finance to identify TM1 system areas that should be re-designed to employ efficiencies and reduce unnecessary complexities that exist from consulting team initial implementation.
• Manage TM1consulting team on system maintenance as well as addressing enhancements and issues that were put on hold during TM1 development due to low priority.

Finance Cost Manager Vegetable

Confidential, San Francisco CA

• Generate monthly Cost Bridge (Operations P&L) reporting and commentary
• Derive and provide cost for new and reformulated items for Notice of Pack (NOP) process
• Generated items costs on over 60 items for Wal-Mart bid
• Provide guidance to Customer Finance on new items, bids and discontinuations to ensure that our MFG facilities maintain production capacity
• Key member of the TM1 Deployment and production planning system team
• Integral part in the Operations Finance MFG TM1 system development and implementation
• Generate product ingredient and packaging cost for new items
• Generate AOP standard composite cost by item for all Consumer Product MFG facilities.
• Prepare bi-annual Confidential cash flow requirements by MFG facility Treasury department.
• Work with Confidential Pittsburg accounting department to ensure data integrity used to post monthly journal entries is accurate.

Finance Sr. Analyst

Confidential, San Francisco CA

• Monthly Cost Bridge (Operations P&L) reporting and commentary for Pet. Streamlined the monthly Cost Bridge setup time savings of about an hour.
• Responsible for updating and tracking Inventory waste for the DMPP manufacturing and Co-Pack facilities. Work with inventory accounting to keep this report accurate and up to date
• Developed monthly VOH/FOH MFG Spend report. Purpose of this report is to track monthly variable and fixed overhead spending by the DMPP manufacturing facilities by line item. Automated this report using MS Access and Excel.
• Responsible for updating monthly Production Plans vs. AOP and current forecast. Streamlined this reporting process using Excel and reduced time to generate report from several hours to minutes
• Developed a preliminary cost sheet reporting system that utilized BPCS (ERP) download capabilities along with MS access and Excel. Reduced report generation time form 30 minutes to less than 5 minutes per item.
• Generated AOP Cost Standards for DMPP as well as loading these cost standards into Essbase and BPCS (ERP) system
• Assisted the DMPP cost manager with the development of DMPP major scenario forecast as well as loading forecast into Essbase
• Responsible for updating the Aspect Wal-Mart item cost system with Confidential Ingredient cost by item. Also developed input templates using MS Access process to assist with the mass amounts of ingredient components that make up the DMPP items

Sr. Systems Analyst

Confidential, Pleasanton CA

• Developed Automated multiple Business Unit Merchandising Scorecard Report to aid Store Layout Designers with macro space set size decisions for newly remodeled stores
• Developed an array of AVT (Oracle Advanced Visual Technology/store mapping system) reporting tools to aid with one time shelf Orders, UPC by Stocking Section reports and reporting as well as database error discovery
• Develop ROI for Galleria Space Optimization Tool to aid senior management in determining effectiveness of company investment
• Develop and maintain ROI for all Categories going through the Optura (Business Planning Process)
• Ad Hoc projects and analysis as requested
• Developed Vendor Fair Share database tool to aid in determining Fair Share cost by vendor/Broker for all store merchandise sections resets and remodel stores
• Work with newly developed AVT database on daily basis to aid all facets of the business to determine best use of micro and macro space; shelf ordering information based on AVT data

Business Planning Analyst

Confidential, Pleasanton CA

• Developed automated Strategy Plan Reporting Process to aid Confidential category management teams for yearly senior management presentations
• Involved in generating Vendor Contact list to aid in the launch of Optura (Category Business Planning process)
• Ad Hoc projects
• Placed on the Galleria (Schematic Optimization Tool) project in April 2007 to Jan 2008 involved in tool testing, trouble shooting and schematic generation

Sr. Finance Analyst

Confidential, San Francisco CA

• Prepare weekly payroll forecast/actual key metrics report
• Weekly payroll hours reporting
• Monthly payroll forecast/actual Reporting as well as presenting Payroll P&L lines outcome to finance leadership
• Variance analysis on all payroll responsibility P&L lines
• Ad Hoc projects
• Streamline weekly and monthly reporting processes
• Setup and implemented key statistical payroll measures into Essbase database hierarchy
• Develop budgeting forecasting model for hours allocating

Sr. Marketing Analyst

Confidential, Pleasanton CA

• Developed SCOP ( Confidential Category Optimization Process) Scorecard reporting application for senior management to provide management a companywide view of the business
• Maintain SCOP Scorecard application along with multiple data sources on a period end basis
• Generate monthly reconciliation between Strategic Marketing’s SCOP Scorecard application and FP&A Essbase databases
• AGP by Item & Store Project - Successfully developed a multi stem Sql process for AGP (Adjusted Gross Project) by Store by item
• Shelf Liability Project - Developed a process to generate a list of lower decile items for discontinuation and correlate them with Strategic Marketing’s customer loyalty metrics. This process presented senior management with a recommended list of items to discontinue with the least amount of customer and financial impact
• Generate automated Essbase report scripts used to populate daily and period end reports
• Ad hoc report generation and analysis

Sr. Systems Analyst

Confidential, Pleasanton CA

• Key member of the PF&A Systems Group responsible for developing and maintaining databases and automated reports for forecasting applications
• System administrator for the FP&A Gross Margin Marketing Essbase cubes (GMR)
• Responsible for aspects of the Essbase GMR application which include maintenance, new Categories setups, security and any type of business reporting requirements the company may require
• Work closely with IT to resolve system issues, generate and place into production new data sources for company reporting
• Investigate discrepancies between the Marketing Essbase reporting cubes and other finance and GL reporting cubes throughout the company
• Develop fully automated ad hoc reporting applications using Microsoft Access to support the business as needed.
• Provide training & assisting sr. management with the corporate admin plan & forecast process
• Directed and administered the QA testing for all Planning & Forecast input templates used by Finance Planning and Analysis team
• Run weekly analysis to ensure that the data integrity from the company data warehouses are in check to ensure that the data warehouse feeds are accurate before the data is loaded into the Marketing Essbase reporting production cubes
• Monthly reconciliations between the Marketing cubes and the GL and GL related Essbase cubes
• Ad Hoc Projects as assigned by group director

Marketing Analyst

Confidential, PLEASANTON CA

• Prepared weekly and period end PPD category reports for the non-perishable departments
• Developed and maintained an automated Seasonal Sell Through reporting system for the seasonal marketing group which have been adopted and used by various departments throughout the company
• Provided analysis such as IRR for the 1hr photo department, which led to the introduction of the digital 1hr photo processing machines in the Denver division. Other support would include the redevelopment and automation of the weekly 1hr photo report
• Developed a product allocation system for the seasonal group, which determined seasonal store firm order quantities, which in turn generated firm order uploads for all major seasonal holidays
• Developed a multitude of automated reporting systems, which are still in use for various departments reports would include Commodity tracking; various Sell Through reports, 1hr photo digital prints report and many others
• Duties included supporting, maintaining and monitoring the GMR Essbase operation in the Marketing analysis Department
• Prepared numerous ad hoc reports for various departments throughout the company