SUMMARY:

• 16 years of experience working with financial planning and analysis, financial systems, financial models, databases, and reporting.
• 6 years of experience working with Cognos Business Intelligence products for report development, inclusive of financial, operational, and statistical data.
• 9 years of experience working with Cognos Planning products for financial forecasting, budgeting, and reporting.

TECHNICAL SKILLS:

SOFTWARE: Cognos EP, Cognos Report Studio, Cognos Query Studio, Cognos Contributor, Cognos Confidential, Cognos Controller, Cognos Finance, Concur, HFM, SAP, MS Excel/VBA

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Cognos Report Developer Consultant

Responsibilities:

• Develop reporting in Cognos Report Studio for implementation of SAP Concur.
• Work with financial team to obtain report specs and develop customized reports for Accounting and Finance groups to utilize for analysis.
• Initially work with reporting in development environment and migrate reports to production for final testing and user acceptance.

Confidential, Atlanta, GA

Cognos Consultant

Responsibilities:

• Maintain Cognos Finance for systems migration project. Provide financial systems support to accounting and finance departments.
• Manage support requests, report development, and maintenance.
• Correspond with IT department and consultants for system updates and issues.
• Maintain Cognos Finance data, reconciliation between Cognos Planning and ERP system, and ETL process.

Confidential, New York, NY

Systems Manager

Responsibilities:

• Project Manager for financial systems initiatives, including Cognos 10 upgrade, BI report development for Concur, launch of Revenue Planning Models, and development of an automated employee time monitoring process via VBA.
• Eliminated Cognos outsourcing costs by taking ownership of BI reporting and maintaining in - house.
• Developed strong partnership with internal Cognos Support team to improve report performance and develop HFM mapping/reporting in BI.
• Developed all new reporting in house and updated current reporting per Cognos 10 upgrade.
• Restructured Client Profitability process, reporting, and runtime.
• Reduced runtime from weeks to days as a result of conducting a system audit, increasing involvement of Senior Systems Analyst, and hiring a Junior Systems Analyst.
• Redesigned monthly data loading processes for efficient execution. Implemented a change management process to track all system changes for optimal system management and troubleshooting. Collaborated with IT to implement SharePoint to use for workflow management and documentation.

Confidential, Alpharetta, GA

Systems Analyst

Responsibilities:

• Managed financial consolidations and financial reporting for Confidential region.
• Administrator of financial consolidation and reporting system, Cognos Controller.
• Implemented a redesigned consolidation system in Cognos Controller, including dimensions reconfiguration, defining eliminations, and integration with SAP.
• Worked with consultants for setup of Confidential financial planning models and integration with Cognos Controller.
• Worked with Business Intelligence Director on Cognos BI project to develop Framework Manager for consolidated and standardized financial reporting for Confidential .
• Designed financial reporting for actuals, forecast, and budget to improve forecasting and analysis for operating companies.
• Developed automated process to import data from SAP into Cognos Controller using ETL tool, to reduce monthly reclasses and improve data integrity of financials for proper financial consolidations.

Confidential, Atlanta, GA

Senior Financial Analyst

Responsibilities:

• Managed monthly consolidation of global financials.
• Administrator of financial consolidation and reporting system, Cognos Controller, and forecasting/budgeting system Cognos Planning.
• Prepared and distributed monthly financials for over 30 global companies in accordance with Confidential standards.
• Reporting consisted of consolidated Confidential financial statements and preliminary flash reports.
• Managed annual budget process.
• Implemented and rolled out Cognos Planning to Asia Pac, Europe, South America, and North America regions.
• Researched financial system issues. Corresponded with CIO and Argentina office to implement a resolution.
• Worked with Sao Paulo, Brazil office onsite for restructuring of financial mapping and compliance with GAAP reporting.