ALI ABBAS
Highland Park, NJ
571-***-**** ***.*****.*@*****.***
Consulting Professional, delivering Business and Technology Solutions, System Architecture Planning, along-with extensive experience in implementing solutions for clients with respect to Planning and Budgeting applications, Business Intelligence/Enterprise Performance Management (BI/EPM) applications and developing Executive Information System (EIS) Dashboards.
BI/EPM Applications Hyperion Performance Scorecard, Hyperion Planning [11.1.2.1-11.1.2.4], Hyperion Business Rules, Hyperion Essbase (including Excel Spread Sheet add-in, Smart View) [11.1.2.1-11.1.2.4], Hyperion Workspace, Hyperion Integration Services (formerly Essbase Integration Services/EIS), Hyperion Web Analysis (formerly Hyperion Analyzer/WIRED for OLAP), Hyperion Financial Reporting (FR -- formerly Hyperion Reports, reporting against Essbase / Planning & HFM), Hyperion Application Link (HAL), Hyperion eCRM Analysis Suite (Web Site Analysis, eCommerce Analytics, Call Center Analysis), Monarch (Datawatch Inc.), Business Objects XI R2, Business Objects Crystal Xcelsius, Business Objects Web Intelligence, AlphaBlox, Access, Excel and Power Point
PROFESSIONAL EXPERIENCE
HYPERION INDEPENDENT CONSULTANT
INSTALLATION / TROUBLESHOOTING / FUNCTIONAL / TECHNICAL / ADMINISTRATION / TRAINING / REPORTING / DASHBOARDS
LANTERNS PATH, New Brunswick, NJ February 2016-Current
The project implementation, spans across support, maintenance, and creation of new Essbase [11.1.2.4] applications. The application analyzed consumer behavior with respect to book sales, user demographics, various languages along-with different digital formats. Creation of several new Essbase applications, tuning of Essbase outlines whether they be ASO or BSO, detailed security plan to migrate users and Full life Cycle testing
HYPERION INDEPENDENT CONSULTANT
UPGRADE / FUNCTIONAL / TECHNICAL / ADMINISTRATION / TRAINING / TROUBLESHOOTING / PERFORMANCE TUNNING / REPORTING
NATIONAL GENERAL INSURANCE, Seattle, WA November 2015-January 2016
The project implementation, was to upgrade / migrate all applications from existing Essbase version to 11.1.2.4. The migration covered several aspects of the objects (a) outlines (b) calculation scripts (c) report scripts. There were several scripts related to MaxL that where then migrated over and changes were made to make sure that they executed successfully in the newer environment. These scripts were related to meta-data build and also data-loads, in a few instances report scripts. There were several Essbase partitions in place, that were also recreated and tested. Security was as simple as individual users being assigned access to Essbase applications, or Security Groups that had security provisioned against them. Complex security were those that required creation of essbase filters.
Extensive training session since the existing Essbase excel add-in has been discontinued from a support perspective. This training focused on the new reporting add-in to Excel, Essbase Smart View. The training session conducted on-line highlighted key features and addressed questions from the Client base.
HYPERION INDEPENDENT CONSULTANT
INSTALLATION / UPGRADE / FUNCTIONAL / TECHNICAL / ADMINISTRATION / TRAINING / TROUBLESHOOTING / PERFORMANCE TUNNING / REPORTING
AIG INC, New York,NY April 2014-October 2015
The project implementation, spanned across support, maintenance, creation and upgrade of new Essbase [11.1.2.4] applications. Responsibilities ranged from system migration and upgrade (from AIX to Linux), implementation for business users, with respect to data loads from GL and other Systems (SAP), user creation and filter assignment, support and creation of CLARITY reporting system. Creation of several new Essbase applications, tuning of Essbase outlines whether they be ASO or BSO, detailed security plan to migrate users and Full life Cycle testing
HYPERION INDEPENDENT CONSULTANT
FUNCTIONAL / TECHNICAL / ADMINISTRATION / TRAINING / TROUBLESHOOTING / PERFORMANCE TUNNING / REPORTING
STATE OF MN, GOVERNERS OFFICE OF BUDGET, MN January 2014-March 2014
Building of a new Financial Reporting system (utilizing Financial Reporting), with best practices for report design, database optimization, use of techniques to automate report creation, creation of templates, use of multiple grids for reporting, extensive use of functions to automate meta-data population. The primary data sources were Essbase / Planning & HFM
HYPERION INDEPENDENT CONSULTANT
INSTALLATION / UPGRADE / FUNCTIONAL / TECHNICAL / ADMINISTRATION / TRAINING / TROUBLESHOOTING / PERFORMANCE TUNNING / REPORTING
AVAYA, Basking Ridge, NJ October 2012-September 2013
Lead the planned lay-out, Installation, Configuration of Oracle EPM System 11.1.2.2 [3]. This involved working with responsible Team for preparation of the Install, the Install and post configuration of the Essbase, Planning and Budgeting System 11.1.2.2.
HYPERION INDEPENDENT CONSULTANT
INSTALLATION / UPGRADE / FUNCTIONAL / TECHNICAL / ADMINISTRATION / TRAINING / REPORTING / DASHBOARDS / TROUBLESHOOTING / PERFORMANCE TUNNING
BANK OF TOKYO, MUFG, Jersey City, NJ February 2012-September 2012
Responsible for the development and maintenance of Financial Reports, Web Analysis Dashboards and Hyperion Smartview reports, against Essbase ASO database.
DIRECTOR, OPERATIONAL RISK GROUP – HYPERION PROJECT IMPLEMENTATION
MORGAN STANLEY, Jersey City, NJ August 2007-January 2012
INSTALLATION / UPGRADE / FUNCTIONAL / TECHNICAL / ADMINISTRATION / TRAINING / TROUBLESHOOTING / PERFORMANCE TUNNING / REPORTING / DASHBOARDS
Assistant Vice President, Corporate Finance IT/Banking and Technology, Audit, Risk, Compliance by reporting to regulatory bodies, including the Chief Risk Officer office. (CRO)
Direct hands-on responsibility for the development, maintenance and production support functions of the Operational Risk Intelligence Environment for Morgan Stanley’s Global Wealth Management Group (GWMG), utilizing Essbase, Performance Scorecard, Monarch, Access and SQL Server
PRINCIPAL CONSULTANT BUSINESS OBJECTS
INSTALLATION / UPGRADE / FUNCTIONAL / TECHNICAL / ADMINISTRATION / TRAINING / TROUBLESHOOTING / PERFORMANCE TUNNING / REPORTING / DASHBOARDS
BUSINESS OBJECTS (now SAP), Edison, NJ August 2006-August 2007
Responsible for implementing solutions for Clients, specific to the EPM/BI application suite at the Clients disposal. This lead to several short and long term engagements
INSTALLATION / TROUBLESHOOTING / FUNCTIONAL / TECHNICAL / ADMINISTRATION / TRAINING / REPORTING / DASHBOARDS
United Illuminating, All State Insurance, GroupM & UNISYS
Experience with other Software Vendors within the EPM/BI space, led to my direct involvement, in crafting solutions that integrated newly acquired EPM/BI applications by SAP, with their existing set of EPM/BI application suite. Integration of Xcelsius and Web Intelligence is a case in example
Lead Consultant
Pfizer, New York, NY June 2006-August 2006
FUNCTIONAL / TECHNICAL / ADMINISTRATION / TRAINING / TROUBLESHOOTING / PERFORMANCE TUNNING / REPORTING / DASHBOARDS
Lead and completed design of an Essbase application that served as the planning tool for Pfizers Legal department, Provide a functionality for planning and budgeting, but not using the Planning application. Extensive use of Essbase calculation scripts, batch commands, database optimization techniques were utilized.
LEAD CONSULTANT – HYPERION PROJECT IMPLEMENTATION
HYPERION SOLUTIONS (now ORACLE), Stamford, CT August 1999-May 2006
INSTALLATION / UPGRADE / FUNCTIONAL / TECHNICAL / ADMINISTRATION / TRAINING / TROUBLESHOOTING / PERFORMANCE TUNNING / REPORTING
Senior Lead Consultant, Consulting Practice
Responsible for implementing solutions for Clients, specific to the EPM/BI application suite at the Clients disposal. Actively lead Implementations, served as the go to Trouble Shoot Expert, when asked to review Client application design, performance, scalability specifications, whether it be Planning, Essbase, EIS, Web Analysis and Hyperion Reports
List of Clients, Verizon Wireless, Jefferson Pilot, Rohm & Haas, Itochu Inc, World Wild Life Fund, DuPont Sabanci, KeySpan Energy, Sara Lee, Key Span Energy, Otto Industries, JnJ, Cendant, Citigroup, Thomson Financial, Hyperion Rx, Morgan Stanley, Foot Locker, Goldman Sachs, IPG of Companies, Prudential Securities
Coty, Inc
Warner Lambert, Inc. (now Pfizer)
Novient, Inc
Aetna, Inc
Sylvan Learning Systems, Inc
Indus International, Inc
USDA/Forest Service
Internet Security Systems, Inc
Vertical Net.Net
Environmental Protection Agency
BMW
KPMG
ASSOCIATE CONSULTANT – HYPERION PROJECT IMPLEMENTATION
CLAREMONT TECHNOLOGY GROUP (now COVANSYS), July 1997-July 1999
INSTALLATION / UPGRADE / FUNCTIONAL / TECHNICAL / ADMINISTRATION / TRAINING / TROUBLESHOOTING / PERFORMANCE TUNNING / REPORTING / DASHBOARDS
The American Stock Exchange (www.nasdaq.com)
Integrated Excel VBA with Essbase, to craft a planning and budgeting solution. Extensive use of Excel VBA Macros, to provide data lock and send capability against Essbase database, developed calculation scripts.
CERTIFICATIONS
University of the State of New York, Education Dept. Licensed Teacher
Oracle/Hyperion Essbase Certified Professional
Internal Hyperion Certification for Financial Reporting
Internal Hyperion Certification for Web Analysis
EDUCATION
M.S, Engineering Management, George Washington University, D.C
B.S, Electrical Engineering, Michigan Technological University, MI