Management Project Manager

RICHARD MURRIETA

****************@*****.***

917-***-**** (c)

SUMMARY:

IT Professional/Business Analyst focused on managing, developing and enhancing financial reporting and data modeling systems. Organized, Creative results oriented professional. Exceptional communication skills coupled with the ability to develop relationships with management, business communities and technical teams.

AREAS OF EXPERTISE:

•Scope/Business Analysis

•Data Analysis

•Requirements Gathering/Analysis

•Project Management/Leadership

•Agile Methodology

•Financial Modeling/Reporting

•Essbase System Development

•Visual Basic

•SQL Expertise

•Toad/SQL Server

•Excel Expertise

•Hyperion Planning

•Business Objects

All Microsoft Office Application

PROFESSIONAL EXPERIENCE:

MORGAN STANLEY 10/16 – 4/1/17

Essbase SME Consultant

Work directly with finance team to design build and maintain multiple budgeting and forecast reporting systems for large areas of the business including but not limited to Asset Management, Wealth Management, Branded Cards in force, and CCAR Stress testing and assessment.

QA and submit forecasting and budgeting requests and monthly close updates. Develop ad-hoc loading and calculation mechanisms to support these requests

Analyze and test data structures for performance improvements.

Work closely with multiple teams to determine new requirements and design solutions.

BOSTON CONSULTING GROUP 6/15 – 8/16

Senior Developer

Work with a large team to design and develop a worldwide planning and reporting system for Professional Services Organization.

Working with HFM GL, HR, and Time and Billing systems to extract employee level data via SQL for use in the Hyperion Planning system

Create/Maintain Hyperion Planning/Essbase applications, write business rules, calc scripts, MXL/MDL procedures

Work closely with functional team and users to ensure usability of the systems.

NEW YORK TIMES 11/01 – 6/15

Project Manager/Essbase Developer/Business Analyst

•Design, develop and implement revolutionary new budgeting and forecasting systems for business management.

•Design, develop and maintain SQL ETL structures to extract financial information from general ledger and other KPI data from core production systems into Essbase forecasting and budgeting systems.

•Prototype and create ad hoc databases (MS Access, Essbase, Business Objects, etc.) to provide for specialized reporting and planning needs such as audits and profitability studies.

•Work directly with Finance and other internal customer areas (Billing, Vendor Payments, Syndicated Sales, etc.) to understand business needs and design data models based on those requirements.

•Design, develop and perform automated data loads and administration of financial modeling systems (EAS, Load Rules, MaxL, MDX, Calc Scripts etc).

•Maintain quality control and reconciliation of all databases.

•Troubleshoot database performance and tune Essbase systems when necessary.

•Analyze and convert BSO structures to ASO when appropriate.

RJM Consultants 07/93 - 11/01

Owner

CLIENT: AMERICAN EXPRESS COMPANY

Consultant for Global Operations Finance Department:

•Designed, developed and administered an activity-based budget and forecast costing system using Essbase and Excel VBA that tracked and forecasted a $1.5 billion operating budget.

•Managed project to develop reporting system that enabled senior management to access and analyze benchmarking information in a timely manner

•Managed Project to Create MIS Reporting system: a multi-departmental project to redesign three separate departmental reporting systems into one reporting system utilized by all three.

CLIENT: MERRILL LYNCH 06/99 - 12/00

Consultant in Risk Management Division

•Manage project to design, implement and document data repository and risk reporting system to provide multi-billion dollar treasury department with weekly funding forecasts.

•Provided senior management with funding requirements reporting by product by business unit for entire firm.

•Created and implemented VBA application to consolidate data from Oracle data structures.

•Designed, implemented and documented a data repository for collecting worldwide web based equity inventory balances to provide senior management with ability to generate daily ad-hoc risk analysis reporting for total firm inventory movements.

Additional clients and experience provided upon request.

AWARDS:

•Received NYT Publisher’s award for development of system to track Digital Subscriptions use by platform.

•Received NYT Publisher’s award for development of Digital Subscriptions by Geography system.

•Received NYT Publisher’s award for activities on The New York Times Diversity Committees

MEMBERSHIPS:

•Board Member Emeritus of the Ricardo O’Gorman Garden and Center for Humanities, New York City (ogormangarden.org)

EDUCATION:

•Certified PMP, Project Management Institute (certification #520784)

Contact this candidate