Enterprise Portfolio Analyst

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

Certified Minority Business Enterprise (MBE)

• 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.

Please reach me at  for further query or drop your updated resume (Use the "Apply for this Job" box below). com