Profile Summary

Master of Business Administration with a robust computer science and mathematics background. Strong experience with Analytical tools like Hyperion Essbase and Planning. Strong database development and business-intelligence modeling capabilities. Excellent analytical and technical skills. Outstanding communication skills and used to perform in a team environment.Fluent in English, Spanish, Arabic and French.

• Involved in the design of a global budgeting/forecasting and consolidation platform
• Worked directly with the resources to ensure system implementation is in-line with business expectations
• Involved in the whole implementation process including documentation to simplify knowledge transfer
• Responsible for building and maintaining all the dimensions/metadata in EPMA that will be shared across all the Hyperion applications
• Designed and implemented Hyperion Workforce, Revenue module, and P&L Planning applications
• Created Business Rules for allocations to broking and corporate departments. (Facilities, IT and bonus were waterfall)
• Built Data Mappings using Financial Data Quality Management (FDQM)
• Assisted in User Acceptance Testing by creating Planning Web forms and Smart View templates for data retrieval and validation
• Documented all the testers' feedback, and highlighted the appropriate changes to the system
• Built task lists to provide guidance to the budgeters through the planning process
• Helped define the users' roles and incorporated the output into a well-defined security model in the system
• Ensured the power users have a good understanding of the Hyperion Environment.
• Analyzed the position based vs. the employee based budgeting/forecasting and highlighted the best/leading practice
• Documented all the data sources, and created the process to map/load the data to the Hyperion environment
• Developed Hyperion Financial Reports using Financial Reporting Studio
• Performed data synchronization between HFM and Planning, and between the different planning applications using EPM Architect data synchronizer.
• Updated the backend relational database to upload user email addresses for process management.
• Created custom SQL queries to feed the data to the Enterprise Repository (ER)

Environment: Oracle GL, OLAP Tools using Hyperion System 11 BI+ Essbase Analytics, Enterprise Performance Management Architect (EPMA), BI+ Web Analysis, BI+ Financial Reporting, Hyperion Interactive Reporting, Hyperion Planning/FM System 11, Hyperion scripting languages, MS Office, DOS scripting, VB scripting.

Professional Experience

Confidential
Senior Analyst, AVP Nov 2008 - Current

• Involved in the re-design of a global budgeting/forecasting and consolidation platform
• Work directly with the resources to ensure system implementation is in-line with business expectations
• Interface and coordinate with FP&A regarding reporting issues
• Interface closely with FP&A to receive budget inputs
• Create Business Rules for allocating expenses to broking departments
• Assist in User Acceptance Testing by creating Planning Web forms and Smart View templates for data retrieval and validation
• Document all the testers' feedback, and highlight the appropriate changes to the system
• Build task lists to provide guidance to the budgeters through the planning process
• Help define the users' roles and incorporate the output into a well-defined security model in the system
• Ensure the power users have a good understanding of the Hyperion Environment.
• Document all the data sources and create the process to map/load the data to the Hyperion environment
• Design and implement a reporting cube for controllership
• Support Monthly Financial Close
• Build Data Mappings using Financial Data Quality Management (FDQM).
• Assist Controllership to load data to HFM using FDM
• Preparation and submittal of deliverables associated with monthly close to Controllership
• Develop Hyperion Financial Reports using Financial Reporting Studio
• Prepare and develop financial review packages and forecast updates
• Perform data synchronization between 3 planning modules
• Create custom SQL queries to feed actuals from the Enterprise Repository (ER).
• Use DIM/Informatica workflows for metadata integration
• Point person for all Hyperion changes
• Use Microsoft excel for data analysis and manipulation, which requires advanced knowledge of the tool
• Extend system functionality using Essbase APIs

Environment: Oracle GL, OLAP Tools using Hyperion System 11 BI+ Essbase Analytics, Enterprise Performance Management Architect (EPMA), BI+ Web Analysis, BI+ Financial Reporting, Hyperion Interactive Reporting, Hyperion Planning/FM System 11, Hyperion scripting languages, MS Office, DOS scripting, VB scripting.

Confidential
Senior Hyperion Consultant Nov 2007 - Oct 2008

Planning Project Lead
Client: Confidential, CA
Responsibilities:

• Worked with the business to help define and simplify business processes & requirements in the area of budgeting and Financial Reporting
• Performed requirements analysis and worked with development resources
• Provided functional and development knowledge in designing a Hyperion Planning solution that meets business requirements.
• Developed two plan types to accommodate different planning methodologies for RHI and Protiviti
• Designed and developed business rules that replicate the company's budgeting process
• Led and coordinated a team of 3
• Established and maintained strong relationships with key applications and infrastructure teams
• Diagnosed client issues and provided them with potential solutions
• Responsible for training and assisting the finance power-users on an as needed basis
• Advised on financial processes that will achieve global efficiencies, particularly in the areas of budgeting and forecasting

Environment: SQL Server 2005, Windows NT, OLAP Data Warehousing using Hyperion System 9.3.1, SmartView, AAS, Financial Reporting.

Hyperion Consultant
Client: Confidential, GA
Responsibilities:

• Worked on a pilot project for Workflow planning. For this purpose, I created the application, webforms, web
• Analysis reports and task lists to direct users through the planning process
• Translated end user requirements into application design specifications
• Created a rolling 18 months Essbase cube for driver based Headcount and FTE projections.
• Designed web analysis reports for variance analysis and data entry
• Responsible for creating SQL queries to load data from the relational source into Essbase
• Developed complex calc script for projections based on seasonality\\

Environment: SQL Server 2005, Windows NT, OLAP Data Warehousing using Hyperion System 9.3, SmartView, EAS, Web Analysis.

Business Intelligence Admin
Client: Confidential, CA
Responsibilities:

• Responsible for maintaining and creating new reports for different divisions using Hyperion Interactive Reporting
• Responsible for daily jobs. Ensure that all jobs run successfully, and troubleshoot in case of failure
• Used warehouse builder to create jobs and schedule them to run as needed
• Loaded data into Essbase cubes in a monthly and quarterly basis
• Assigned access to users to IR reports

Environment: AS 400, Essbase 6.5, App Manager, Hyperion Performance Suite 8.x.

Confidential
Hyperion Comsultant Jan 2007 - Oct 2007

Hyperion Planning Developer
Client: Confidential, PA
Responsibilities:

• Designed and built technologies to assist with the re-design of processes
• Translated end user requirements into application design specifications
• Functioned as integrator between business needs and technology solutions
• Developed Batch files and Rules files to upload history and actual data from source systems and budget data from backups
• Used MaxL and DOS scripting for automation of back ups and data loads
• Wrote Interactive Business Rules
• Involved in Performance tuning through optimization of data and index cache settings and block size to minimize Calculation and retrieval time
• Created data sources and SQL views to load data directly into planning
• Interacted with Business Analysts and Finance Users for data reconciliation
• Performed tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports
• Managed client installations based on users' requirements
• Involved in training the users with the new Application (webforms and SmartView)

Environment: SQL Server 2005, Windows NT, OLAP Data Warehousing using Hyperion System 9, SmartView, EAS.

Confidential
Graduate Assistant Sep 2004 - Dec 2006
Responsibilities:

• Assisted professors in research using SAS and CRSP database to study the momentum in terms of the availability of information and its impact on price
• Created a macro as an alternative for Reuters to get refreshed stock market prices. Prices were downloaded from MSNMoneyCentral
• Created a custom application to evaluate stock market recommendations
• Responsible for Database analysis & Design.
• Generated reports on stock recommendations. Reports were refreshed every 15 minutes to reflect the changes in stock market prices
• Designed and developed screens in VB.Net to enter data
• Developed customized toolbar to perform specific functions
• Developed and coded classes to modularize the application to interface with the database, to display complex sets of data on the screens
• Used Crystal Reports XI as a reporting tool

Environment: VB.NET, MS-Access 2000, MS-Excel 2000, OS- Windows NT, Crystal Report XI.

Confidential, Spain
Essbase Admin/ Developer Aug 2003 - Mar 2004
Responsibilities:

• Identified and defined strategies for the clients finance department
• Advised on financial processes that will achieve global efficiencies, particularly in the areas of budgeting, planning and forecasting
• Conducted global workshops to gather requirements to re-design existing financial processes
• Created Database outlines and optimized the outlines by arranging the Dimensions in hour-glass format
• Implemented MaxL, EssCmD, Report and Calc Scripts
• Utilized HTTP web-client user interface of Hyperion Analyzer 6.5 for creating sales analysis reports to facilitate ad-hoc querying
• Created performance analysis charts and graphical presentation reports using the pre-built customer intelligence reports with Analyzer Form Design Tools
• Ported applications and migrated database from version 6.5 to 7.1
• Utilized Application Manager/EAS: Model sizing, optimized cache settings, established user security, managed applications migration, established substitution variables and settings for dynamic time series, asynchronous processing, editing/validating scripts
• Attended JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them
• Developed VBA code for incorporating data navigation in Excel Spreadsheet

Environment: OLAP Data Warehousing using Hyperion Essbase 6.5, Essbase Excel Add-In, Hyperion Reports 6.5/7.2/ BI+ Financial Reporting, BI+ Enterprise Analytics, Application Manager/EAS, Hyperion Planning, Hyperion Analyzer 6.5/ BI+ Web Analysis, Oracle 8i, Windows NT.

Confidential, Morocco
Programmer Jun 2002 - Jul 2003
Responsibilities

• Analyzed user/business requirements to design and develop new applications
• Interviewed users to gather requirements for database design
• Was responsible for the design and development of Oracle database
• Converted database from MS Access to Oracle
• Wrote, tested, and implemented application using VB.Net and Oracle
• Developed SQL and PL/SQL Queries for DDL and DML purposes
• Designed and developed screens in VB 6.0 to enter data related to daily activities
• Developed customized toolbar to perform specific functions
• Made structural changes to the database when design changes were to be implemented.
• Created materialized views for data retrievals
• Developed and coded classes to modularize the application to interface with the database, to display complex sets of data on the screens
• Used Crystal Reports as a reporting tool as well as invoicing
• Trained users on in-house software.

Environment: VB 6.0, Windows NT, Crystal Reports 9, Oracle 8i, SQL*Plus

EDUCATION

• Masters of Business Administration.
  Concentration: Accounting
• B.S. in General Engineering May.
  Concentration: Software Engineering