• Strong Technical & Functional experience in Application Architecture, design, analysis, development and Administration of various financial applications in Client/Server environment using Hyperion Essbase, Hyperion Essbase Integration Services, SAP BI/BW Hyperion Planning, Hyperion Financial Reporting, Hyperion Reports,Hyperion Web Analysis, Data warehousing, data modeling,Hyperion Analyzer under Windows environment
• Experienced to effectively manage the financial systems program as well as oversee multiple projects at any given time.
• Facilitate resource planning with project stakeholders at corporate level
• Implement reporting projects initiatives and manage them to timely completion
• Oversees all projects in their respective area of responsibility, including timeline, resources, budget, scope, risk, status reporting and customer expectations
• In-depth understanding of the upgrade process as well as the process of migration from Dev to Test and Test to Production Environment.
• Experience with complex IT and Finance environments with multi-tiered reporting systems
• Communicate with senior firm leadership to establish understanding of projects financial performance
• Outstanding talent in developing team building, project scope, developing and maintaining customer relationships, continuous design improvement and conducting status meetings and customer reviews
• Analyze vast amounts of data through various database computer applications
• Breadth of background ranges from Manufacturing /Financial Services that includes software application, infrastructure implementation, financial reporting, application administration and large scale system integration projects.
• Assisted in special projects i.e. process documentation, project management.
• Prepared internal financial reporting for various levels of the organization

Core Competencies

• Senior Level Financial Reporting
• Management Reports Corporate Reports
• Process Development
• Financial Analysis
• Traditional Waterfall SDLC
• Plan view SDLC
• Hyperion Essbase Tool
• Essbase Financial Planning Tool
• Integrated change management
• Audit readiness and responses
• Interpersonal relations
• Teambuilding and Communication

Leadership Competencies

• Manage Concurrent / Complex Projects
• Dedicated to relationship Building
• Balance Conflicting Needs and Priorities
• Insure High Level of Customer Satisfaction
• Effective at Influencing Others
• Calm Demeanor During Stressful Situations

Sr. Hyperion Consultant June 2010 – June 2011
Confidential
Santa Ana, CA

• Designed and developed the complex reporting system, provide user, system production support and administration for FP&A group.
• Managed planning, budgeting, forecasting and reporting processes analyzing trends and variances in actual performance to budget and recommending corrective actions
• Responsible for the overall baseline support and on-going maintenance of all environments of the Hyperion Corporate Financial Consolidation System and the Hyperion Planning System 11.1.3 budgeting and forecasting systems.
• Participated in business requirements for new enhancement of Financial reports and applications and co-coordinating the delivery of multiple projects
• Experience in budget planning, reporting, variance analysis, and month-end close process
• Demonstrated experience working with formal software life cycle methodologies
• Provided financial system support for all Accounting and Finance teams during month-end close
• Managed all production Hyperion database maintenance and administration and organized and managed database administration within the company’s network operations Center
• Lead performance tuning, execution plan analysis, and statistics monitoring activities operations
• Excellent business presentation skills.
• Reconciled month end financial statements that have been created in Hyperion EPM
• Ensure the timely and accurate generation of all corporate internal reporting, consistency and standardization amongst the various types of reports and databases and manage the various reporting tools utilized by the Company
• Analyzed, interpreted and reported financial and operational performance trends from various channels & departments, identifying areas performing outside of expected results
• Responsible for new data load for month end process
• Responsible for all management, Corporate and Budget books
• Worked closely with multiple levels of the organization including management teams to support key systems, implement infrastructure improvements and ensured business units are able to operate efficiently and effectively.
• Demonstrated experience interfacing and collaborating with peers, management, vendors, and other departments.
• Communicating status and vision to client management and stakeholders
• Change management and training of client staff for a successful deployment of the new process and system
• Intermediate excel skills using Vlookups and Pivot Tables. Good familiarity in Microsoft Access, Word and PowerPoint.

Hyperion Project Manager January 2007 - Mar 2010
Confidential.
Warrenville, IL

• Responsible for the overall baseline support and on-going maintenance of all environments of the Hyperion Enterprise 6.5 and Hyperion HFM System 9.3.1 Corporate Financial Consolidation System and the Hyperion Planning System 11.1.1 budgeting and forecasting systems.
• Depending upon assignment, interfaced with department managers, Program Managers, Consultants, Developers, Infrastructure Support
• Working knowledge of the software development lifecycle from requirements gathering to post-implementation production support, including quality assurance and system integration
• Provided security expertise, developed solutions and performed required functions, transversely with application and system environments, for the IT Audit & Compliance office.
• Experience troubleshooting issues i.e. performance, security etc in enterprise, HFM, Planning and Essbase.
• Experience in monitoring applications and creating reports throughout the financial reporting cycle to ensure high-availability of applications to the global finance community.
• Experience in management/administration of the Hyperion environment, with primary responsibilities for the Essbase, Planning and Reporting applications.
• Facilitated a clear communication channel between outsourced and off-shore development teams and internal groups
• Provided teams with advice and input on tasks throughout the project, including project plan, deliverables, issues management, and risk management.
• Provides effective and timely guidance for members of the IT Production Database Administration team
• Maintaining and updating members, outline, alias automatically using batch and MaxL.
• Analyze system and data issues, including data reconciliation, to identify root cause and required corrective actions Serve as one of the hands for implementation of Hyperion Planning, Essbase and Hyperion Web Analysis
• Wrote batch scripts and scheduled them to run MaxL for regular backups,
• Provided technical assistance and support to end-users and was involved in developing documentation required.
• Provided designing and developing data conversion solutions for Business Intelligence (BI) requirements using Hyperion Data Relationship Management and Hyperion Financial data quality Management
• Utilized Application Manager/EAS: Established user security, maximized system performance, and established substitution variables and settings for dynamic time series
• Responsible for Performance Monitoring: Backup and Recovery of the cube, Optimization and Performance tuning of Outline/Data load/Calculations.
• Work with team to create and improve processes and methodologies.
• Assisted with IT audits and responded to inquiries from various Audit agencies
• Followed and maintained Sarbene-Oxeley (SOX) compliance procedures for change management.

Environment:Hyperion Essbase 9.1.3, Hyperion Essbase 7.1.6, Hyperion Application Manager, Hyperion Web Analysis, Hyperion BI Plus V 9.3x,Hyperion Financial Reporting, IBM Alphablox, SQL Server, Business Objects Crystal Reports

Hyperion Consultant November 2006 – January 2007 
Confidential, Mettawa, IL

• Assisted with requirements gathering, developing project scope, and estimating projects, system design, development and testing of budgeting and forecasting systems
• Developed a multi-dimensional database (MDDB) application using Hyperion that stored and maintained company’s customer information.
• Importing data from different data sources including OLTP/OLAP database,Oracle Analyzer.e. Merge and aggregate data from different data sources.
• Scheduled and performed all data loads, and guided the business in establishing effective and efficient automated solutions
• Performed quality control and auditing of databases to ensure accurate and appropriate use of data
• Maintained end user security, including setting up new user accounts, and creating security filters and user groups
• Completed special projects as assigned
• Developed outlines based on the requirements specified.
• Worked with clients throughout the entire phase of the project, from scoping through implementation and eventual support.
• Loaded data into the outline developed for each data cube.
• TunedEssbasefor system and performance problems; identified and resolved information flow, and content issues
• Created and maintained Rule files, Report Scripts and Calc Scripts.
• Used SQL Server to extract the data
• Developed five cubes – all for different regions of the country.

Lead Business Analyst January 2000 - Dec 2001
Confidential

• Functioned as a liaison between thebusinessand IT organizations in the development of new solutions and enhancements to existing applications.
• Supported the business by becoming the subject matter expert for business applications.
• Responsible for creating and updating documents required as part of the system development lifecycle necessary to supportbusinessprocesses i.e. statements of work,business& functional requirements, detail functional design, technical design input, use case and process documents
• Developed integration and information exchange protocols
• Conducted requirement meetings with stakeholder and documented the results

Business Analyst Sept 1998 - Dec 1999
Confidential

• Performed the research necessary to create technical designs and logical functionality which ensured thatbusinessapplication systems were effectively developed and implemented to meet actualbusinessneeds.
• Developed and maintained an in-depth understanding of the application functionality for multiple, complex applications
• Responsible for completing other work requirements or tasks that were requested by management when necessary to meet the goals and objectives of the department
• Reviewed, analyzed, and evaluatedbusinesssystems and user needs

Education:

• Bachelor of Business Administration in Finance
• Bachelor of Arts in Social Science