TECHNICAL and Functional SUMMARY:

• Over 18 years Hyperion Systems especially in the area of designing, reporting, analyses and planning.
• Extensive experience developing Enterprise Financial Systems using Hyperion System 9, Hyperion Enterprise, Hyperion Analytic Services, and Hyperion Financial Management in large companies
• Accomplished systems administrator with 18 years of experience managing server infrastructures and data-center operations across multiple platforms UNIX, Linux, and Windows . Effectively plan, install, configure and optimize the IT infrastructure to consistently achieve high availability and performance.
• Proven ability to create and deliver solutions tied to business growth, organizational development and systems/network optimization. Skilled problem identifier and troubleshooter comfortable managing systems, projects and teams in a range of IT environments.
• Senior Hyperion Enterprises financial system Administrator experience in the information technology industry with multi-billion dollars corporations.
• Solid background in business, systems analysis, systems design, systems development, systems implementation, project management, data conversion and workflow.
• A highly effective problem solver. Works well under pressure without compromising quality. A strong desire for success and a high standard for quality.
• 7 years of diversified IT experience of which 5 years in working with OBIEE 10.1.3.x/11g, Siebel Analytics 7.x, Oracle BI Applications 7.9.x, which include building and configuring repository, creating and managing Oracle/Siebel Intelligent Dashboards, Oracle/Siebel Answers, Oracle/Siebel Delivers, Oracle/Siebel iBots, BI Publisher and Extraction Transformation and Loading using Informatics
• An innovative, forward-thinking, proactive, respected professional who has accomplished significant achievements in business intelligence, ETL, data warehousing, analysis, problem-solving, training, negotiating, cost-reduction, research and development.
• Senior Hyperion Enterprises financial system Administrator experience in the information technology industry with multi-billion dollars corporations.
• Solid background in business, systems analysis, systems design, systems development, systems implementation, project management, data conversion and workflow.
• 8 yrs as Hyperion Infrastructure consultant experience and worked with higher management people
• Proven experience in Accounting Auditing specialized in financial reporting
• Having 8 years of extensive experience in various Hyperion Products and Applications - Essbase, Planning, Financial Reports, DRM/MDM, HAL, and Hyper roll in the latest version of Oracle EPM/Hyperion suite 11.1.1.3.
• Extensive knowledge of Financial Statements, Reconciliation, Payroll, A/R, A/P reporting and analyses, Capital Assets Management, Budgets, Forecasts using PeopleSoft, Hyperion, Oracle, Excel, Lotus, various General Ledgers and SQL.
• Ability to design, develop, upgrade, troubleshoot and maintain complex operational and financial systems exposure to financial systems architecture/infrastructure.
• Install and configure Financial Management 11.1.2 and all related Performance Management Architect 11.1.2 products in the source and destination environments
• An innovative, forward-thinking, proactive, respected professional who has accomplished significant achievements in business intelligence, ETL, data warehousing, analysis, problem-solving, training, negotiating, cost-reduction, research and development.
• Presents experience in effectively applying in-depth technical knowledge to the design and development of new and efficient systems.
• Experience in training developers and advising technical groups on reporting best practices.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.

EXPERIENCE:

Confidential

Sr. Hyperion Business Administrator/Systems Analyst

• Consulted with client to provide Web-based and network solutions along with strategic planning and project leadership over systems migration, configuration, administration, upgrades and troubleshooting initiatives.
• Provide administrating support to data warehousing, database and server technologies
• Identify technical need of the organization and the project requirement
• Subject matter expert for Hyperion Planning and other technology applications used in Business Planning and Analysis. Serve as the Power User and assist in the resolution of system related issues.
• Support and in some cases lead the Design, Implementation, Roll Out, overall User experience and continuous improvement for technology applications used in Business Planning and Analysis.
• Support Hyperion Scriptin g by performing quality assurance reviews and testing, defining business needs, and understanding of script prioritization and sequencing
• Support the FP A team with the overall coordination and management of the budgeting and forecasting processes.
• Includes initial target setting alignment with Strategic Plan.
• Provide communication, end-user training and guidance to business operations.
• Ensure all milestones and deadlines are met.
• Maintain and track budget changes or revisions throughout the year as needed.
• Serve as primary liaison between Finance and Hyperion Development Teams.
• Participate in creation and development of various monthly and quarterly management reports for both financial and stat data using Smart View, Financial Report Studio and Web Analysis.
• Provide system and user administration managing the processes for control/audit of system user access and requests for changes to structure metadata and chart of account.
• Perform ad hoc analysis as required

Confidential

Hyperion Enterprises and HFM Administrator

• Maintain account and entity structure in HFM
• Managed and preformed all technical and functional duties related to the responsibilities as the HFM Administrator and was a utilized team member of on-going projects to automate procedures and improve Developed and documented daily and month-end closing process for administrators and accountants
• Coordinate weekly/monthly/annual processes with Hershey subsidiaries as it relates to importing data into Hyperion
• Enterprise, as well and identifying/resolving reconciliation issues
• Act as a resource for management and end users, including providing end user training on Hyperion Enterprise and Hyperion Retrieve.
• Support month end closing process and consolidation of Hershey
• Coordinate issuing, gathering and submission of Hershey subsidiary quarterly annual reports.
• Support SOX documentation and compliance.
• Group company financials, as well as other periodic reports.
• Maintained databases to ensure data integrity, security and timely, accurate reporting
• Drafted Financial Reporting Studio report writing procedures, trained staff on certain features, and served as a guru with their report design
• Created multiple HFM reports in FRS to automate the Flux Analysis and Transaction Type reporting as part of the Close Reporting Initiative project to limit manual interface and reduce the close cycle to 4 work days.
• Created and implemented revised Topside Journal Entry workflow process to capture and manage multiple entries in both Business Warehouse and HFM.
• Instrumental in the upgrade of HFM from v9.3 to v11.1 reconciling historical data and maintaining each system parallel throughout a 6 month period.
• Primary team member responsible for recast and consolidation of 08 and 09 financials from two separate HE systems as a requirement for External Reporting to create the Guarantor Financials.
• Write and maintain financial reports and VB script/rules and update as required
• Prepare HFM for monthly close and monitor outputs during and after close
• Support HFM end user community with training needs and HFM/Smart view request
• Assist Controller on financial projects including but not limited to quarterly risks opportunities, volume analysis, contribution comparison, overhead breakout, budget analysis

Confidential

Hyperion/HFM, DRM, Essbase Consultant

• I manage company's financial planning platform, serving as a key interface between the company's central finance group and the business users. I create key templates and reports, supporting financial forecasts
• This project involves in creation of planning applications and generation of reports.
• Loaded the metadata into Planning application using Hyperion Application Link HAL and refreshed into Essbase database
• Designed and developed web forms for the data input as per the business requirements using Hyperion Planning.
• Involved in migration of planning application from Development to QA to Production.
• Involved in database and security refreshes in Hyperion Planning.
• Used Business rules for allocation and budgeting in Hyperion Planning.
• Designed the cube based on the business requirements of the client.
• This project involves following high level task:
• Gathering requirements from the functional user.
• Designing the solution and architecture of the environment.
• Creating functional and technical design document for the implementation.
• Developed Web forms workflow process for the users to input data and route it to appropriate approval process before it gets added to DRM.
• Created business rules as per the business logic at workflow level and restricted user to input any wrong data, which minimized use of validation at DRM end and hence improving the tool performance.
• Full Life cycle project Implementation.
• Creating properties, Property Category as per the requirement.
• Creating imports for one time build in DRM. Further, Creating Heir and version from the import file from stage Area.
• Creating business rules using validations and verification in MDM/DRM.
• Creating custom exports as per the requirements by different target systems.
• Automating the whole end-to-end process by using tool internal ability.
• Creating standard exports and automating the process of export generation and transferring it to target systems.
• Implementing security using tool internal ability and external authentication.
• Creating export to Feed to GL tables write back capability to GL
• o Full export
• o Incremental export without creating AS of version.
• o Generation level export.
• o Export to tables.

Migrating the signed off segment to production using migration utility and working with web publishing

Confidential

Hyperion Essbase Financial Management/ Hyperion Enterprise admin

The Manager of Financial Consolidations, Reporting and HFM will be responsible for America and Asia's region consolidation and submission to HQ. Work closely with financial organization to deliver, maintain, and enhance corporate Hyperion-based financial systems. Experience implementing enterprise services and providing system support in an enterprise computing environment

Confidential

Hyperion Essbase Financial Management

• As a Consultant, I am responsible for designing and implementing enterprise wide business intelligence solutions for Samsonite. I successfully implement multi-dimensional reporting solutions utilizing Hyperion Essbase, relational data modeling and ETL. As a lead Technical Consultant I am responsible include:
• Designing and building an integrated Oracle EPM 11.1.2 installation with all modules
• Upgrading all HYPERION products including HFM/FDM, ESSBASE, Planning, HYPERION Strategic Finance and legacy products such as HYPERION Enterprise. Design, develop, and manage BI solutions to meet business needs
• Design data models including multi-dimensional data models and star schemas
• Design, develop, and modify interfaces and data mappings
• Research source data locations to validate reporting requirements
• Create reporting symantic layers utilizing BI repository administration tools
• Develop standards and techniques to support aggregations as well as drill to detail reporting
• Serve as a mentor for other members of the development team to ensure data processing standards, guidelines and procedures are practiced
• Perform performance tuning activities, relational databases, SQL query writing languages, and ETL tools a plus
• Serve as an Essbase training instructor
• Team lead and management responsibilities for providing 24x7 technical supports and overall health for terabyte-sized databases 90 Microsoft SQL Servers 2005 and 2008 production, UAT, development and QA database servers with Window server 2003 and 2008.
• Providing mentoring and work directions to the DBA team and implemented high availability options such as mirroring, log shipping, load balancing, SQL clustering, and replication including Merge, snap-shot, transactional, Bidirectional and peer to peer Transactional Replication. Strong experience in designing, maintaining and setting 32-bit and 64-bit active/active, active/passive clustering. Extensive experience with installing all versions of SQL Servers on window servers. Great hands on experience with Backup Recovery, SQL Server installation, SQL server patching, extensive SQL Server performance monitoring tuning experience, troubleshooting, disaster recovery , supporting VLDB size 5 TB , documentation, managing teams, super strong DBCC and DMV utilities

Confidential

Essbase Architect - Planning - ASO - BSO - Data Integrator

• Responsible for overall architecture and strategy for the deployment of ESSBASE Planning System 11 as a technology
• Established standards for the technology including identification of appropriate uses for all options within the ESSBASE technology stack ASO, BSO, Data Integrator, System 9
• Responsible for understanding user requirements and translating those requirements into well architected solutions
• Researches and recommends alternative actions for problem resolution with minimal direction. Analyzes trends to proactively prevent problems.
• Complies with project management methodology requirements as appropriate. Develops detailed program specifications for self and others.
• Tests and implements systems and enhancements using techniques that meet generally accepted coding standards. Assists less senior members when performing system and acceptance testing.

Confidential

Hyperion Essbase Financial Management

• Different kind of project includes Project Management, Executive Level Reporting, Supervisory, Financial PLANNING and Analysis, Budgeting, Forecasting, Spreadsheet Modeling, Policies Procedures, Internal Reporting and Process Improvement
• Enterprise to HFM Global conversion Project
• Installed and configure Financial Management 11.1.2
• migrated the versions from system 9 to EPM 11
• Personally performed the first upgrade of any Oracle customer in the world to a mixed release of Hyperion System 9 and Oracle EPM 11.1.1.0. Worked closely with Oracle Product Assurance and Oracle developers to resolve bugs as they arose.
• Provided detailed feedback to Oracle, so that future Oracle customers performing this upgrade would encounter fewer issues.
• Part of Global implementation responsible for North America
• Integration through FDM by business division
• worked under DEV environment and have migrated HFM and Essbase
• HFM Essbase Training for North American counterparts
• Financial Management Statutory Reports
• Data Validations and Smart-view Reports
• SQL scripting and Crystal Reporting
• Divisionalization business by function
• Recommendation and implementation of changes to process.
• Monthly maintenance and Reporting.

Confidential

Hyperion Essbase and SAP Financial Management Consultant and Enterprise system Admin.

• Data Quality Project at Electable between SAP ISU and SAP CRM
• Development of the New Frontiers Master Data Management Product with Map Viewer Integration.
• Migration of the reporting tool from Discover to OBIEE at Tommy Hilfiger : The complete history in Dutch
• Development of OBIEE Complement : A tool to manage the translation process and to synchronize the database comments with the obiee description
• Development of a ROLAP cube and integration of the data from the point of sales at Tommy Hilfiger
• Development in OMB Script of an automatic testing program for the Quick start data warehouse application developed on Oracle Warehouse Builder.
• As an Associate Enterprise System Administrator provide backup in the absence of the Enterprise System Administrator in order to deal with system and database issues.
• As an Enterprise System Administrator works closely with the Enterprise System Administrator, IT staff, technical users, and the Help Desk to perform routine maintenance and troubleshooting.
• Maintain proper technical documentation and business continuity information.
• Works with the Enterprise System Administrator to ensure business continuity and is cross trained for disaster recovery operations.
• Help in in the migration of the Quick start reporting tool from OBIEE to SAP Business Object
• Migrated the development environment of Essbase from System 9 to Essbase v11.1.1.3
• Monitoring and resolving Data warehouse ETL Production issues
• Key player in integrating the core mainframe payment processor along with Upstream and Downstream interfaces using Data Stage ETL solution
• Served as mentor and reviewer to junior Specialists in all areas of data warehousing and ETL.
• Extracted, transformed, cleansed, and loaded ETL Fire Prevention Department data from their legacy Access system to Oracle and Permit Plan / Advantage.
• HFM/Analytic Services/BI Reporting system administration
• System update maintenance
• Security maintenance for global users
• Stabilization of the system across the organization.
• Recommendation and implementation of changes to process.
• Monthly maintenance and Reporting.
• Completed monthly production, ad hoc programming, reporting and analysis supporting subscriber marketing and finance. Provided mainframe and SAP BI Net weaver support necessary to accomplish development projects.
• Identified and implemented schedule and processing improvements to significantly reduce time to complete assigned work.
• Identify process improvement opportunities for Hyperion and Oracle related systems.
• Partner with internal Customers to define requirements and translate into detailed Hyperion project specifications.
• Worked in coordination with the Hyperion teams to integrate DRM and Hyperion Apps.
• Was responsible for managing and auditing the master data using DRM.
• Development of integration with DRM and Hyperion Planning, HFM through ODI and SSIS

Confidential

Financial Operations Analyst /Hyperion and SAP Administrator

• Oracle ESSBASE OLAP software, Versions 3.1 through 11.1.1.3 on Unix and Windows platforms, Complex ESSBASE calc scripting for custom applications, Esscmd Language, Visual Basic for Applications VBA , Basic, Lotus Approach Relational DATABASEs, Financial Variance Analysis, Project and Program management, ETL from Oracle, PeopleSoft and SQL Server
• Testing of DRM components post upgrade
• Integrating DRM with source EBS systems and target Hyperion applications Planning, Essbase and HFM.
• Generation of reports from DRM for audit and other transaction histories
• Work with SAP and Hyperion IT to drive Hyperion project prioritization and completion.
• Provided training and coaching to staff in project management and customer service.
• Performed market and financial analysis of concepts, platforms, and IT products that were internally developed.
• Developed the Hyperion System 9 administration and data management, cost allocation, financial analysis and planning, financial reporting, and data quality management.
• Project Lead for the implementation of a time tracking system across multiple regions
• Performed budget/actual analysis and identified and addressed variance issues utilizing SAP BW and BEx.
• Supervised staff domestic and international, reviewed financial statements, analyzed variances, and compiled monthly income statements.
• worked under DEV environment and have migrated HFM and Essbase
• Created month-end close calendar for the Department based on input from the Department issued the calendar and posted to the intranet.
• As an Informatics/ ETL Architect created ETL infrastructure for a new health care data warehouse.
• Technical PM ETL Tech Lead for onsite and offshore team of ETL Developers, ETL Analyst, Data modeler DBA.
• Team lead and management responsibilities for providing 24x7 technical supports and overall health for VLDB databases 90 Microsoft SQL Servers 2005, 2008, 2012 SQL Cluster installation production, Setup 2012 latest high availability feature Always ON on for entire SQL server with 200 databases, managing UAT, development and QA database servers with Window server 2003, 2008 and 2012. Extensive 2012 experience.
• Providing mentoring and work directions to the DBA team and implemented high availability options such as mirroring, log shipping, load balancing, SQL clustering, and replication including Merge, snap-shot, transactional, Bidirectional and peer to peer Transactional Replication. Strong experience in designing, monitoring maintaining and setting 32-bit and 64-bit active/active, active/passive clustering. Extensive experience with SQL Servers installation, window server performance along with monitoring and tuning of SQL servers and SQL queries.

Confidential

Financial Reporting operation analyst/Hyperion Enterprise Administrator

• HYPERION Systems 9 Administration Data Maintenance
• Ensure consistency between SAP, Hyperion and Expense Planning.
• Update rollups according to organizational changes.
• Review and update Cost Centre list and Chart of Accounts.
• Month-end Financial Close Process -- Implemented new Departmental month-end report card
• Global Business Initiatives --GBI Reporting
• Ensure that all GBI entries are completed and accurate per the month-end calendar.
• Accurately track the development costs for each new release..
• Maintain continuity schedule that provides support for amortized development costs.
• Deliver analysis and timely reports as requested by both internal and external clients.
• Development of DRM automates, blenders and other components to build the hierarchies
• Review the new GBI report and make recommendations on how to implement the new GBU reporting.
• Development of DRM reports/exports to generate flat files for loading into HFM
• Development of DRM reports/exports to generate flat files for loading Planning using ODI

Confidential

Hyperion Consultant

• Developed systems solutions and modified or upgraded existing systems procedures as needed.
• Developed financial and management reports for companies and their subsidiaries including:
• Completed various financial analyses which involved the administration of the financial reporting systems in Hyperion and spreadsheets.
• Developed systems documentation in support of business policies and procedures.
• Analyzed and evaluated business system needs and objectives for the customer community and developed proposals for solving business problems.
• Implemented software upgrades, quality assurance standards and document procedures.
• Performed Quality Assurance testing of the financial systems.
• Conducted Beta testing, developed test cases and managed the testing environment and backup procedures.
• Design and build of mappings in DRM to map the data between source systems to target systems
• Responsible for mapping the data through DRM.
• Worked in coordination with the Hyperion teams to integrate DRM and Hyperion Apps.
• Responsible for managing and auditing the master data using DRM
• Development of integration with DRM and Hyperion Planning, HFM through ODI and SSIS

Confidential

Hyperion Essbase Analyst-- Planning Tool

• Built the designed solution for the district/area of responsibility:
• Hyperion Application links to load meta data
• Essbase load rules to load data /Input Forms/ Reports/Security
• Hyperion Business rules or Essbase calc scripts for calculations
• Ensured alignment of the Hyperion Planning tool with the client's districts business processes
• Assisted in implementing Hyperion Planning
• Resource and Activity based budgets for Electric System Limited 95 of the company's Budget
• Knowledge transfer and end-user training
• Developed Oracle based reports for Corporate Reporting department

Confidential

Analyst Hyperion Financial Systems administrator

• 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 that captured financial information enabling management to monitor items that were critical to its success.
• Financial data base administration: strong working knowledge of Focus, Lotus, Excel, Hyperion and Capsil so that 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.