Enable job alerts via email!
Generate a tailored resume in minutes
Land an interview and earn more. Learn more
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.
** 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 | www.talentburst.com
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 415-549-8397 for further query or drop your updated resume at kashif.meraj(at)talentburst(dot)com