Enterprise Portfolio Analyst

TalentBurst Inc; Torrance (CA); Hybrid; USD 80,000 - 120,000; Full time

Job summary

A successful consulting firm in Torrance seeks a Business Analyst/Portfolio Manager with advanced Excel skills to support PMO operations. The position blends analysis with presentation responsibilities to senior executives. Ideal candidates will have operational improvement experience and strong analytical skills, contributing to effective project delivery.

Qualifications

• High proficiency in Excel for data analysis and report development.
• Experience with project and portfolio management concepts.
• Operational improvement experience is preferred.

Responsibilities

• Support PMO in daily operations and project analysis.
• Develop presentations that are clear and understandable.
• Analyze resource demands and project dependencies.

Skills

Analytical skills

Quantitative skills

Attention to detail

Operational improvement experience

Job description

** 9 time INC 500/5000, 9 time BBJ "Pacesetter ", 5 time SIA-fastest growing**
___________________________________________________________
Kashif Meraj | TalentBurst, Inc.
Boston | San Francisco | Miami | Milwaukee | Toronto | New Delhi | Bangalore
Work: [phone]
575 Market Street, Suite 3025 | San Francisco, CA 94105 | www.talentburst.com

Certified Minority Business Enterprise (MBE)

Job Description

• It will be a hybrid role of a Business Analyst (gathering PMO / reports requirements, documenting, create communications) and Portfolio Manager (understanding the full Portfolio process, understanding excel/budgets, creating PowerPoint slides).

• Must understand the Enterprise Portfolio governance and PMO process

• Must be highly proficient with Excel, Excel charting and reporting

Overview:

PMO is launching new portfolio / project reports and analyzing the performance of the portfolio, understanding trends and root causes. The PMO is designing countermeasures to address root issues and mitigate portfolio risk. The PMO BA will support these initiatives. This position requires strong Excel and PowerPoint and experience in presenting to high level executives. Some familiarity with an IT implementation is a plus; although, IT technical skills are not required.

The ideal candidate will have "Kaizen” or operational improvement experience. Specifically, the candidate will have experience in identifying operational improvement opportunities through financial analysis and benchmarking operational metrics. Doing so requires "Strong analytical and quantitative skills" demonstrated on their resume.

The PMO BA will also be responsible for supporting:

• PMO in day to day operations

The job requires analytical skills to support resource capacity and portfolio analysis of IT projects. This person should possess fundamental knowledge of project and portfolio management with a consultative approach. Advanced excel and presentation development skills is also a must.

The Consultant is expected to:

• Analyze resource demand and project dependencies based on project/department team's input and demands and constraints

• Develop standardized process on when and how to review the portfolio of projects demands

• Develop customized presentations that are clear and easily understood by the audience

Mandatory Skills:

• Knowledge of project and portfolio management concepts and fundamentals and have managed portfolio/project delivery through the full life cycle (SDLC)

• Experience with supporting cross functional teams (including IT, Business, Marketing, Portfolio and Capacity Planning)

• Advanced with using PowerPoint and creating customized presentations that are clear and easily understood by the audience

• Experience with operational improvement.

• Experience with supporting PMO, project managers and project teams

• Advanced Excel skills for data analysis and reporting (see below for more details)

• Attention to detail

Excel and Presentation (using PowerPoint Skills):

Advanced Excel and PowerPoint 2010 skills for data analysis, report development, and management views with conclusions are required. Ability to create Excel macros is desirable.

Excel Specific Skills:

(Preferred that all candidates take an advanced technical assessment on EXCEL)

HIGHLY Advanced Excel skills for data analysis, report development, and management views with conclusions are required.

• SUM, COUNT, and AVERAGE functions

• Formatting cells for presentation and sorting a list

• Conditional formatting, including one condition with two criteria (using AND, OR functions)

• VLOOKUP function to determine categorization

• Compound formulas

• SUMIF for two or more criteria (or other equivalent method, such as an array formula)

• COUNTIF for two or more criteria (or equivalent method)

• CONCATENATE to format report headings, including TEXT function for dates

• Pivot Tables with formatting

• Bar and Pie Charts with customized formatting

• Data extraction and analysis from data sources a plus

Any of the various Excel functions to get the results are acceptable. The analytical thinking to define how to answer the question is more important than knowledge of the Excel commands and syntax.

Additional Information

Please reach me at 415-549-8397 for further query or drop your updated resume at kashif.meraj(at)talentburst(dot)com