SUMMARY:

• More than 15 years of information technology management experience with focus as Project Manager for diverse industries, including manufacturing and high - tech environments.
• Expert in information systems technology, project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning, and tracking of results.
• Highly noledgeable in software development, requirements analysis, and database design.
• Excel at creating and implementing technical and operational plans and strategies.
• Competent liaison between management, clients, and personnel.
• Strong communication, presentation, analytical and problem solving skills.
• Vast noledge and experience of a broad range of technologies and methodologies dat is applied to global project management and business solutions.
• Full SDLC (Systems Development Life Cycle), or (Software Development Life Cycle)noledge and systems infrastructure including inception/scope definition, functional requirements, architecture/design, implementation, change management, testing, requirements matrix analysis, documentation,, service level agreements, risk and gap analysis, issue resolution management, and roll-out management for small, large and multi-project systems.
• Strong expertise in the areas of business analysis, software analysis, business process development, requirements development, requirements analysis, team leadership, systems implementation, systems integration, and development life cycle.
• Self-motivated with strong facilitation and communication skills resulting in clear and focused communication between all levels of management, internal/external customers, business stakeholders, steering committee facilitation, and technical teams.
• Work as the liaison between the IT development staff and business users to ensure dat all business needs are correctly defined, documented, and communicated during all phases of the projects life cycle.
• Understanding and articulating business requirements from user interviews and converting requirements into technical specifications.
• Vendor management experience including contract negotiation,
• Outstanding analytical, organizational, communication and problem solving skills. Masters new systems and technologies very quickly, experience with design and layout of marketing materials, strong technical writing abilities for project communications, and and user manuals.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Hyperion Consultant

Responsibilities:

• Responsible for the Hyperion Essbase and Planning applications and performance optimization.
• Served as primary leader on the Hyperion tool kit and its capabilities.
• Assessed/analyzed current state architecture, provided best practice solutions for identified areas of improvement.
• Defined application/system roadmap/design document(s) ensuring self-service, flexibility, scalability, and security.
• Developed architectural standards documents for future design, team-based development, and code release management in the new architecture in compliance with corporate development and change management process.
• Led initial design and scripting activities to adjust the current model to support new needs and eliminate constraints on flexibility.
• Aligned Hyperion architecture with enterprise architecture.
• Developed and assisted in the support/maintenance of processes related to the Hyperion Planning applications and any impacted upstream/downstream processes.
• Partnered with the IT department to understand how Hyperion Planning integrates with the supporting data warehouse and BI reporting tool.
• Hyperion technical lead for the installation, hardware and environment configuration, and administration of Oracle Essbase and Planning application.
• Batch Scripting, Performance Tuning, MaxL Scripting, Patching,
• FDMEE Data Integration, Mapping and troubleshooting, Jython Scripting.
• Developed and Maintained disaster recovery strategy.
• Determined and ensured execution of backup and recovery strategy.
• Ensured execution of archival strategy.
• Provided technical guidance and mentoring to technical and functional staff.
• Lead technical resource for reporting projects utilizing Oracle Essbase and Planning applications.
• Responsible for Performance Tuning and System patch updates for both Oracle Essbase and OS environment.

Confidential

Hyperion Senior Consultant/ Project Lead

Responsibilities:

• Hyperion Technical Lead for HFM 11.1.2.4 implementation for a 12 Billion Dollars Engineering Services Company.
• Provided technical direction for a major financial systems upgrade Including infrastructure design, requirements gathering, SOW, development of technical and functional design documents
• Oversaw the installation, Configuration and testing of EPM system 11.1.2.4. with all its required components including HFM Workspace, Shared, Services, ESSBASE, Planning,, FDMEE,DRM
• Assisted in the design and development Hyperion Applications and metadata structure
• Assisted in the development of HFM and FDMEE applications including metadata, data integration, mapping tables, security and provisioning and financial reports.
• FDMEE Data Integration, Mapping and troubleshooting, Jython Scripting.
• Assisted in the development of admin and user documentations for system and application maintenance, outlining instructions on start/stop EPM services and guidelines on managing applications in the EPM environment andmaintaining the HFM rule file.
• Helped Finance & Accounting in developing SOX compliance processes related to Corporate Accounting and Financial Reporting through the use of HFM and BI.
• Coordination with Finance and IT stakeholders, third party vendors, and consultants.
• Oversaw the development of BI Reporting tools and Dashboard Design solutions
• Jointly responsible with IT group for ensuring consistent upgrade strategy across Hyperion products, consistent operability and shared vision between Hyperion Planning and HFM users

Confidential

Hyperion Managing Consultant

Responsibilities:

• Managed support functions for Hyperion environment for one of the world’ largest medical device manufacturers.
• Developed applications leveraging Hyperion Planning for budgeting, Planning & forecasting, including Hyperion Workforce Planning, and Capex,
• Data Relationship Management, and Hyperion Profitability and Cost Management.
• Managed the monthly system maintenance process, patch updates, metadata changes, loading financial data, updating business rules/calculations for various Planning Applications
• Managed Planning related load processes within FDM.
• Managed User Access and Provisioning.
• Conducted scheduled classes for new and existing Planning users
• Oracle Business Intelligence Enterprise Edition, web-based dashboard reporting and analytics in order to deliver the data necessary for profitable decision making.
• Managed a staff of 12 Hyperion in-house and offshore resources to ensure sustainability, availability and reliability of company’s financial consolidation, budgeting and reporting systems for company’s multiple divisions worldwide.
• Directed the business processes and user support functions with more than 2 dozen Hyperion applications and all related forms, reports, peripheral applications including HFM, FDM, FDMEE, DRM, Planning, ESSBASE and Smart view.
• Admin and technical support, Application creation and Performance tuning.
• Server install/patching, ODI debugging. Operations support, ODI, DRM, FDMEE, ESSBASE Calc. Scripts/MDX.
• Developed/Implemented Disaster recovery strategy.
• Design and develop HFM and DRM solution. HFM, ESSBASE, Planning, Financial Reporting, SQL server, WebLogic server.
• Troubleshoot failed production runs and restarting of servers and services.
• Performance tuning EPM system, HFM, ESSBASE, Planning Applications and servers and resolved end-user application and system/infrastructure issues.
• Developed/executed plans to improve the system performance and efficiency.
• Managed primary support functions for HFM users in solving day-to-day issues.
• Implemented a System Stabilization and Application Optimization plan dat pulled the company out of frequent system freezes dat were continuing for over 90 days, saving the company millions of dollars in downtime and lost revenue.
• Managed the monthly server maintenance, performance optimization, Start/Stop services. Tuning and optimization, user security and provisioning, Rules File Editor, HFM Reports.
• Directed the issue resolution with Oracle SR, support/testing during monthly maintenance.
• Delivered status updates and prepared weekly/bi-weekly status reports.
• Development of the enterprise-wide financial system strategy (to drive Hyperion Systems and information requirements and for financial system improvements, and oversight for conversions, patches, and upgrades).
• Proactively assisted in defining the direction for future Hyperion initiatives and understand the downstream impact of system changes.
• Mentored business teams in year-end system/process analysis, planning/forecasting improvements, and overall financial system direction.
• Developed and facilitated activities, globally, and work with stakeholders to enhance the application process resulting in a stable production environment, System/data integrity, business validation, follow up and corrective action.

Confidential

Sr. HFM Consultant/Technical & Functional Support

Responsibilities:

• Responsible for providing HFM support and analyzing business processes and requirements by working with Finance to specify, design, configure, test and support HFM and all related forms, reports, and peripheral applications.
• Manage primary support functions for HFM users in solving day-today issues.
• Monitor, identify, resolve and improve Hyperion financial systems’ performance.
• Research alternatives and recommend business solutions to improve system performance, increase efficiencies and reduce costs.
• Responsible for Meta Data Changes, Copy Applications, Backup, DR. LCM Utility.
• Support monthly server maintenance, performance optimization, Start/Stop services. Tuning and optimization, user security and provisioning, Rules File Editor, HFM Reports.
• Troubleshooting advanced issues with Oracle SR, support/testing during monthly maintenance.
• Develop supporting flowcharts, tables, diagrams, formulas and methods for solving business problems, incorporating infrastructure requirements and interfaces.
• Prepare and update necessary documentation and assist in developing and maintaining system documentation.
• Support existing and developed new HFM applications including defining metadata (accounts, entities, scenarios, custom dimensions, currencies, consolidation methods, member lists, journals, data forms, intercompany transactions, process management and security, as well as rules development (expressions, functions, variables, sub procedures, conditional / consolidation / elimination rules, string comparisons, sub cubes).
• Design/build, develop and test data validation, data backup and recovery and provide key administration support for HFM users worldwide.
• Performed key functions utilizing Financial Data Quality Management (FDM) including FDM Location setup and configuration and FDM Mapping and Validation Rules Development
• Provide support in configuring client and server hardware, as well as tuning server configurations for optimizing Hyperion performance.
• Work closely with business stakeholders to ensure the application is maintained and satisfy the finance requirements for monthly Meta Data changes.
• Identify gaps and alternative solutions with current configuration and interfaces.
• Performed Project Management tasks to ensure progress against the schedule, track project financials, identify and mitigate risks and address any issues.
• Deliver status updates and prepare weekly and bi-weekly status reports to be reviewed by the senior leadership and client executives.
• Perform Day-to-day management/liaison between the off-shore development and support teams, the onsite teams and the client support teams.

Confidential

Sr. Managing Consultant (HFM)

Responsibilities:

• Led the design and development effort for a major power generation client.
• Led the Upgrade of Hyperion Enterprise to HFM 11.1.2.1. Designed, Built & Implemented the HFM application to improve the consolidation and close process for multiple entities across the globe. Created HFM applications for the Cash Flow requirements and the Fair Value Balance Sheet requirements.
• Designed the HFM Cash Flow application to store data by cash flow line item, cash flow id, and data provider/adjustment type.
• Built the application to perform automatic intercompany elimination and automatic rounding.
• Set up The HFM Fair Value Balance Sheet application to store data by fair value balance sheet line item, work stream, data provider type, balance type, and business segment.
• CreatedseparateFDMapplicationsfortheCashFlowrequirementsandtheFairValueBalanceSheetrequirementstoextract, map and load the People Soft general ledger data into HFM. This extract and submission contains all general ledger accounts for all valid Cash Flow ID’s. The application then imports, processes and loads the cash flow templates for each Cash Flow
• Worked as HFM developer on developing financial reports through data consolidation and reconciliation using HFM and Financial Reporting Studio.
• The FDM Fair Value Balance Sheet application extracts maps and loads the PeopleSoft general ledger data into HFM. This extract and submission contains all general ledger accounts for all valid business Segments. The application then imports, processes and loads the fair value templates for each fair value work stream.
• Responsible for developing reporting templates for Balance Sheet and P&L matching previously used data using Hyperion Financial Reports.
• Solely responsible to develop, implement and test Shared Services security management systems across HFM, Planning, Hyperion Financial Reporting, Web Analysis, and Essbase projects. Used Shared Services for implementing HFM Process Management activities. Also designed and developed FDM security (not involving Shared Services).
• Responsible for setting FDM security standards and administration of FDM roles across the company.
• Actively involved in project development life-cycle from analysis of Functional Specifications Document (requirements gathering), application design, development, parallel testing, rollout into production environment, implementation and end-user across subsidiaries.
• Imported, validated, and exported historical data to HFM using FDM.
• Applied Hyperion Financial Data Quality Management (FDM) for data importing, validation and exports to HFM applications. Developed FDM maps, setup of HFM and FDM security.
• Responsible for developing documentation and video tutorials for end-users across subsidiaries around the world in Hyperion Financial Management, Planning and using Web-Analysis. Interacted with subsidiaries to design documents in different languages.
• Applied HFM for data management processes for gathering data, calculating, approvals, consolidations, and submissions of data.
• Responsible to architect Hyperion Essbase platform in coordination with IT to analyze best implementation of Essbase for advanced analyses and to prepare for Hyperion Planning framework.
• Applied Hyperion Planning 11.1.2 to provide a framework for perpetual planning, managing volatility, reporting on frequent planning cycles involving both short and long term planning.
• Used Essbase Administration Services for activities such as filter creation, creation of users, creation of groups, and migration of cubes and maintenance of Essbase Servers.
• Solved several issues involving Hyperion Planning and Essbase interaction at architecture and end-user level based on business, financial and accounting department requirements.
• Designed interactive Dashboard layout to populate report specific data points for each department within the organization; ensured TEMPeffective synchronization.

Environment: Hyperion Financial Management (HFM) 11.1.2x, Hyperion Financial Reports, Hyperion Web Analysis 11.1.2.x, Workspace, Shared Services, Hyperion Planning 11.1.2, ESSCMD,UNIX,, Calc Script, SQL, Windows NT Essbase.

Confidential

Sr. Consultant

Responsibilities:

• Different kind of projects includes Project Management, Executive Level Reporting, Supervisory, Financial planning and Analysis, Budgeting, Forecasting, Spreadsheet Modeling, Policies & Procedures, Internal Reporting and Process Improvement
• Financial & Management & Statutory Reports
• Reported to the project manager on the progress of projects on weekly basis.
• Implemented new ideas with the halp of team members in planning new projects.
• Managed project budgets as part of global implementation responsible for North America
• Participated in the meetings with clients for ongoing projects.
• Performed budget/actual analysis and identified and addressed variance issues.
• Processed and settled inter-company accounting transactions and dealt extensively with foreign currency issues.
• Supervised staff, domestic and international, reviewed financial statements, analyzed variances, and compiled monthly income statements.
• Reviewed capital appropriation request, marketing plans, and expenditures

Confidential

IT Project Manager Financial Systems

Responsibilities:

• Managed to complete the project in given budget and scheduled time
• Created rapport and maintained TEMPeffective communication with the team members and external stakeholders in the project.
• Le, mentored and trained the team members.
• Prepared and presented weekly reports to the senior management on the progress of the project.
• Conducted meetings of team members to solve their queries and gave feedback on their performance
• Identified and implemented schedule and process improvements to significantly reduce time to complete assigned work.
• Identified process improvement opportunities for Hyperion and Oracle related systems.
• Partnered with internal Customers to define requirements and translate into detailed Hyperion project specifications.

Confidential, Westborough, MA

HFM and SAP Project Manager

Responsibilities:

• Project Lead for the implementation of a time tracking system across multiple regions
• Performed budget/actual analysis and identified and addressed variance issues.
• Supervised staff, domestic and international, reviewed financial statements, and compiled monthly income statements
• Consulted management and departmental staff to ascertain and implement researched technology solutions.
• Provided translation of high-level business needs into business rules, business processes, and business reporting/analysis requirements.
• Contributed in planning, creating and implementing IT vision and strategy aligned with the company’s strategic business plans.
• Developed projects from initial analysis of business requirements through design, coding, testing, and implementation.
• Coordinated hardware installation.
• Trained end users on new systems.
• Used MS Project to establish the project schedule and track progress.
• Led information technology projects through the project life cycle.
• Increased revenue within one month by leading the creation and implementation of highly TEMPeffective technology solutions.
• Evaluated existing technology platform and upgraded to a Y2K compliant platform to meet company’s future growth expectations.
• Researched and completed comparative analysis to determine specific technology solutions for each client.
• Aggressively drove issue resolution.
• Developed and launched community based web sites to promote local businesses.
• All Implementations were completed on schedule with high quality

Confidential

Financial Systems Consultant/Project Manager

Responsibilities:

• Provided critical support and leadership to meet the financial targets and budget goals.
• Furnished operational support in the execution of finance initiatives and delivery of activities to maximize financial performance.
• Assisted in preparing and maintaining budget documents and financial models.
• Built analytical models dat utilize both financial and operational data to monitor operating results.
• Developed metrics dat provide data for process management and indicators for future improvement opportunities.
• Performed Revenue and margin analysis, supported in the yearly revenue planning process to understand the dynamics in the different geographies to better evaluate revenue opportunities.

Confidential

Project Manager

Responsibilities:

• Furnished Operational support in the execution of the finance initiatives and delivery of activities to maximize financial performance.
• Prepared Gross Margin reports and analysis and recommended appropriate corrective actions on key drivers of margin performance.
• Developed and improved methods of reporting and controlling materials costs.
• Provided financial analysis and support for special projects.
• Installed materials cost control procedures and provided supervision over material cost systems and methods.
• Consulted management and departmental staff to ascertain and implement researched technology solutions.
• Trained staff on new systems leading to increased performance and customer satisfaction.
• Maintained working relations with the customer under difficult circumstances.
• Built consumer behavior models for corporate clients using multivariate techniques, including regression and discriminated analysis, and cluster analysis.
• Analyzed data from national probability survey to identify purchase intents and patterns for business to consumer direct marketers.
• Organized and presented marketing information to executive staff for in-house promotions and press releases.
• Improved efficiency by redesigning complex excels spreadsheets (multiple models, up to 61 sheets.
• Developed department costing models and comprehensive profit analysis discounting methodology.
• Worked extensively with data warehouse systems; constructed and submitted queries, built models, and maintained templates.

Confidential

Systems Analyst

Responsibilities:

• Produced financial reports and other financial analyses for the company and its subsidiaries which involved the administration of the financial reporting systems in Hyperion and spreadsheets.
• Developed the Management Information Package (MTP) & Flash Reporting.
• Developed monthly Flash Report dat captured financial information enabling management to monitor items dat were critical to its success.
• Design and development of Oracle’s Hyperion Financial Management (HFM), Financial Data Management (FDM) and Enterprise Performance Management Architect (EPMA) to meet business needs
• Financial data base administration: strong working noledge of Focus, Lotus, Excel, and Hyperion and so dat desired programs could be developed, run and updated as needed.
• Financial Management System development & Support (e.g., Hyperion & Focus): provided guidance, feedback and analysis in the Development of a financial management information system
• Financial Analysis & Special Projects such as new Management applications.