Analyst/Developer - General 3
Irvine, CA 92612 US
Job Description
JOB SUMMARY
• Responsible for the development of new enterprise performance management (EPM) systems and process based solutions as well as by providing support, training and enhancements to existing systems/processes. Will be responsible for capturing and analyzing requirements from Finance and partner with IT and outside consultants to deliver EPM solutions. Position will be responsible for EPM applications for Finance. Will perform hand-on development and collaborate with IT as needed on infrastructure support. Will manage projects and will direct people. Will not have any direct reports.
MAJOR RESPONSIBILITIES.Description
• Project & Process Improvement
o Manages technical delivery team on a day to day basis and all technical risks and issues, including close liaison with Oracle Hyperion and IT staff amongst others to close down issues.
o Interfaces with business and IT stakeholders to anticipate requirements and mobilize available resources to deliver solutions to meet those needs.
o Drives continuous improvement and implements repeatable and sustainable processes supporting period-end close, forecast, and business plan.
• System Implementation & Enhancement
o Captures and analyze business requirements to formulate application solutions to meet those needs.
o Creates of system design concepts and detail for implementation including appropriate project plans and assessment of risk.
o Performs hand-on development as required as a member of the project team.
o Acts as system project lead as necessary to ensure the successful coordination between finance users, IT and external consultants through completion of the project.
• Maintenance and Support
o Provides ongoing maintenance and support for applications within the area of responsibility and provides production support.
o Serves as the primary administrator of EPM applications for Finance.
o Analyzes gaps in existing applications and makes necessary changes to optimize performance.
o Proactively communicates and reports issues, status, and results to management with recommended solution.
EDUCATION/EXPERIENCE REQUIREMENTS • Bachelors or Master Degree in Computer Science, Management Information System, or related field. • 8+ years of direct work experience in developing and supporting of EPM solutions including Hyperion and Cognos. • 5+ years of experience in SQL, PL/SQL, OLAP, or Essbase calc scripts. • Good understanding of Unix and experience developing shell scripts. • 5+ years of financial planning and business system analysis work in multiple areas including: financial planning, business case development, budgeting, operating plan development, pricing/proposal development, R&D, cost management, cost forecasting. KNOWLEDGE/SKILL REQUIREMENTS • Experience with leading technical projects thru full software development life cycle. • Experience with process re-engineering and driving continuous improvement. • In-depth knowledge of Oracle EPM products including Hyperion Essbase, Planning, FDMEE, and ODI • Expertise in SQL, PL/SQL, Essbase calc scripts, and data validation technics. • Ability to design, modify, develop, write, analyze and implement EPM applications supporting financial planning, reporting, and analysis. • Experience with software development using full life-cycle (Analysis, Design, Development, Testing and Implementation). • Excellent communication skills with the ability to translate business requirements into technical specifications. • Ability to independently address a company system application need with user customers, cooperatively conceive a direction, and bring forth a recommended proposal for management review. • Ability to act as an effective systems project manager and a driving force in the creation of a system application. • Ability to comprehend customer needs and implement the application on time and within budget. • Exercises judgment within defined procedures and practices to determine appropriate action.