Enterprise Portfolio Analyst

• 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 • Project Managers for project status reporting 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 • Maintain project/portfolio data • 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 • ROUND function • Basic date math • Formatting cells for presentation and sorting a list • Conditional formatting, including one condition with two criteria (using AND, OR functions) • IF function for conditional logic • 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 415-549-8397 for further query or drop your updated resume at kashif.meraj(at)talentburst(dot)com ** 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: (415) 549-8397 575 Market Street, Suite 3025 | San Francisco, CA 94105 | Certified Minority Business Enterprise (MBE)