SUMMARY

• Consulting Professional with 21 years experience in 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 Hyperion Business Rules, Hyperion Essbase (including Excel Spread Sheet add-in, Smart View) Hyperion Workspace, Hyperion Integration Services (formerly Essbase Integration Services/EIS), Hyperion Web Analysis, Hyperion Financial Reporting (reporting against Essbase / Planning & HFM), Hyperion Application Link (HAL), Hyperion eCRM Analysis Suite (Web Site Analysis, eCommerce Analytics, Call Center Analysis), Monarch, Business Objects XI R2, Business Objects Crystal Xcelsius, Business Objects Web Intelligence, AlphaBlox, Access, Excel and Power Point
• CLOUD Applications Oracle Enterprise Performance Reporting Cloud, now known as Narrative Reporting and Essbase Analytical Cloud

PROFESSIONAL EXPERIENCE

Confidential

Technical manager

Responsibilities:

• Enterprise Perfomance Reporting Cloud Lead: Participated in requirements elicitation and development of User Stories. Formulated and defined application scope and objectives; met with stakeholders, gathered requirements as well as understood and applied teh technologies that met those requirements. Participated in teh technical design and coding of interfaces, data conversions, reports. Reviewed, edited, analyzed and created detailed documentation of systems and user needs.
• Essbase OAC Technical Lead: Migrated Essbase On-premises Applications to teh Cloud. There were several design considerations related to user roles, utilization of LCM utility (for import), conversion of all applications to Unicode mode, default aggregation mode, implied sharing, different configuration settings, converting all application files and artifacts to teh data-base level, unique database security assignment, keeping in mind unsupported application and database settings.

Confidential, NY

finance manager

Responsibilities:

• As teh finance manager responsible for all teh reporting needs coming out of teh GL reporting application, along-with teh collection of data from several other planning applications that feeds to teh GL application in Essbase 11.1.2.4 . Responsible for creation of new and modification of existing member formulas to support reporting needs. Support reporting needs for several lines of business, ensure data integrity as data is moved in from various applications, when needed creating new, modifying existing reports. Utilizing ODI to ensure proper execution of data loads at given time schedules, working with IBM to ensure timely resolution of issues. Responsible for teh creation of web form, business rules, calculation scripts as needed. Maintained teh repository of all Financial Reporting reports, ensuring best practices between Essbase design and reports design.
• Installation Troubleshoot Functional Technical Administration Training Reporting Dashboards
• Teh project implementation, spans across support, maintenance, and creation of new
• Essbase 11.1.2.4 applications. Teh 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

Confidential, Seattle, WA

Independent consultant

Responsibilities:

• Teh project implementation, was to upgrade / migrate all applications from existing Essbase version to 11.1.2.4. Teh migration covered several aspects of teh objects (a) outlines (b) calculation scripts (c) report scripts. There were several scripts related to MaxL that where tan migrated over and changes were made to make sure that they executed successfully in teh 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 teh existing Essbase excel add-in TEMPhas been discontinued from a support perspective. This training focused on teh new reporting add-in to Excel, Essbase Smart View. Teh training session conducted on-line highlighted key features and addressed questions from teh Client base.

Confidential, NY

Independent consultant

Responsibilities:

• Teh 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
• Teh migration efforts also covered (a) whole-sale conversion of Essbase BSO to a Essbase ASO (b) combining 2 or more Essbase BSO into a single version in Essbase ASO which required converting existing formulae in Essbase BSO, to Essbase ASO in MDX format
• 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. Teh primary data sources were Essbase / Planning & HFM

Confidential, NJ

Independent consultant

Responsibilities:

• Lead teh planned lay - out, Installation, configuration of Oracle EPM System 11.1.2.2 3 . This involved working with responsible Team for preparation of teh Install, teh Install and post configuration of teh Essbase, Planning and Budgeting System 11.1.2.2 along with Financial Reporting. Extensively documented all procedures related to installation, tuning procedures, changed all Oracle data-sources to point to new Essbase databases.
• Teh legacy system had visual basic application that would prompt teh user for a calc script, and tan display teh list of calculations that were in teh que: allowing users to keep track of their completion time. This system was critical to their undertaking, and was also ported over and worked through teh conversion process

Confidential, NJ

Independent consultant

Responsibilities:

• Responsible for teh development and maintenance of Financial Reports, Web Analysis Dashboards and Hyperion Smartview reports, against Essbase ASO database. Lead teh design for an Essbase application that would captures all data-sources, particularly adjustments made in Excel, for a line of business. Assisted teh OFSA in tying out data between OFSA data source and Essbase. Worked with IBM Consulting Team, to establish procedures to capture adjustments that were done in Excel in a single data-source. This was to bring teh remaining 7 lines of business into teh same fold: with Essbase a single picture of teh truth
• Functional, Technical, Administration,Troubleshoot, Tuning, Training, Reporting, Dashboards

Confidential, NJ

Director

Responsibilities:

• Finance IT/Banking and Technology, Audit, Risk, Compliance by reporting to regulatory bodies, including teh Chief Risk Officer office. (CRO)
• Direct hands-on responsibility for teh development, maintenance and production support functions of teh Operational Risk Intelligence Environment for Confidential ’s Global Wealth Management Group (GWMG), utilizing Essbase, Performance Scorecard, Monarch, Access and SQL Server
• Responsible for implementing solutions for Clients, specific to teh EPM/BI application suite at teh Clients disposal. This lead to several short and long term engagements
• Experience with other Software Vendors within teh 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

Confidential, Stamford, CT

Senior Lead Consultant

Responsibilities:

• Responsible for implementing solutions for Clients, specific to teh EPM/BI application suite at teh Clients disposal. Actively lead Implementations, served as teh 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 Confidential, World Wild Life Fund, DuPont Sabanci, KeySpan Energy, Sara Lee, Key Span Energy, Otto Industries, JnJ, Cendant, Citigroup, Thomson Financial, Hyperion Rx, Confidential, Foot Locker, Glodman Sachs, IPG of Companies, Prudential Securities, Coty Confidential, Warner Lambert (now Pfizer), Novient Confidential, Aetna Confidential, Sylvan Learning Systems, Indus International Confidential, USDA/Forest Service, Internet Security Systems Confidential, Vertical Net, E.P.A (Environmental Protection Agency), BMW, KPMG
• Lead and completed design of an Executive Dashboard in Hyperion Analyzer, utilizing Essbase & Essbase Integration Services. Role was to engage with all VZW and IT teams and provide for Analyzer expertise, related to functionality, design, and support for Executive Dashboard. Teh under-lying data-warehouse being Teradata, worked close with Tera-data team, in leveraging Essbase/Hyperion EIS Hybrid Analysis functionality, along-with complex Essbase formulae creation, database design and optimization.

Confidential

Associate Consultant

Responsibilities:

• 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.