SUMMARY:

• Certified Hyperion Financial Management (HFM) and Certified Hyperion Planning Consultant Consultant with over 14 years experience in Hyperion/DW/BI related technologies in OBIEE, EPMA, DRM/MDM, Informatica, Oracle 11.5 and Oracle R12, Hyperion and Cognos.
• Management consulting experience with financial and banking clients of Confidential & Confidential é Confidential . Specialize in providing and implementing optimal BI solution for specific client needs.
• Extensive knowledge of client/server configuration, systems integration, security and risk management.
• Strong emphasis on client relations with the ability to manage and built business relations.
• International travel experience deploying BI solutions in Data Integration and Data Warehouse projects with emphasis on capacity and risk management. Certified in Project Management Program.
• Exceptional technical writing skills in producing process guides, checklists, and management reports for the client.
• Worked one on one with the client and consulting partners overseas in India and UK through Confidential & Confidential and it sister firms for 8 years.
• Experienced with domestic and international clients and have had onsite client interaction in Europe and States.

PROFESSIONAL EXPERIENCE:

Confidential

Solution Architect DRM and Data Gov ernance

Responsibilities:

• Provided Data governance policies and laid out roles and governance guidelines for Data Stewardship, Data Ownership, Data Users and Data Administrations.
• Designed a mechanism to ensure CBL (Common Business Language) where duplicate codes coming from different legacy systems are handled in DRM and assigned new codes.
• Working on a process with DRM for Orphan management as well as shared node instances.
• Migrating existing hierarchies from older MDM to DRM 11.1.2.3
• Implemented DRM Workflow methodology and processes
• Wrote scripts to import DRM hierarchy feeds from the user interfacing PIM system where codes are generated.
• Design and Implement a Data Relationship Management solution for managing Brands, Class, Property Geography, Industry Geography, Operational Responsibility and Operating Details. Next is CoA information integration into the DRM application.
• Design phase wise integration of DRM with existing systems and architected a solution where DRM is the hub for all property and accounts definition and flow.
• Meeting with business on DRM process management and Operational Security management.
• Provide documentation and design DRM solution based on best industry practices on Hierarchy management aand approval workflow.
• Implement Workflow functionality within DRM for a single point Corporate hierarchy management from where hierarchy is fed to Oracle GL, HFM, FDW and Essbase cubes.
• Loaded Hierarchies and properties for nodes, members as well as created export and import scripts in DRM.
• Created Action scripts for bulk set of incremental updates.

Confidential - Los Angeles, CA

Chief Solution Architect

Responsibilities:

• Overall Solution Architect for the client overseeing the Development and Hyperion Support teams for HFM, DRM & OBIEE.
• Design and Implement a Data Relationship Management solution for managing Accounts and Responsibility Center (Cost Center) multi-hierarchies based on the new Common Chat of Accounts.
• Implement Workflow functionality within DRM for a single point Corporate hierarchy management from where hierarchy is fed to Oracle GL, HFM, FDW and Essbase cubes.
• Loaded Hierarchies and properties for nodes, members as well as created export and import scripts in DRM.
• Created Action scripts for bulk set of incremental updates.
• Established DRM Workflow management for synchronized effort on Version approval and on managing multiple instances of orphans as well as shared nodes and leaves.
• Implemented DRM Workflow methodology and processes.
• Implemented HFM 11.1.2.2 consolidation processfor Balance sheet and Proft/Loss hierarchies.
• Implemented alternate hierarchies for Corporate, Statutory, Legal, Strategy and Treasury reporting needs.
• Automated Currency Translations and implemented VALUE dimension for Entity Curr data loads, Entity Curr Adjustments, Parent Currency Adjustments and Contribution adjusts.
• Automated entity roll ups for different various US and international entities/currencies combinations.
• Implemented multi use of Custom1 (BU), Custom2 (Functional reporting), Custom 3 (sub ledger accounts, Custom 4 (C/F, RF, Variance).
• Automated Cashflow accounts, YOY Roll forwarding, variance reporting and movement analysis.
• Mapped intercompany entities and automated intercompany eliminations via ICP dimension. Implemented InterCompany Revenue and InterCompany Expense reporting.
• Implement OrgbyPeriod functionality to accommodate changing Legal Entity/RC rollups by year.
• Provide financial statements for SEC 10K & Q reporting to be fed to Financial Disclosure Management.
• Design & Implement the Hyperion Financial Management instance for Corporate consolidation from all Oracle, PS and legacy ledger data.
• Design & Implement another Hyperion Financial Management instance for Functional currency translation for 12 sets of currency with various combinations including monthly rates, daily rates and transaction rate.
• Developed consolidation rules for HFM and implemented intra-day consolidation/calcs.
• Automate GL adjustments and OTT (Over the Top) adjustments process and synchronize within the HFM App.
• Provide for multi calendar (Japanis on Apr thru March calendar, US on Jan thru Dec).
• Bring Budget and Forecast from OFSA and create FLASH scenarios to be able to analyze Rate data.
• Minority interest calculations between banking and non-banking entities, subsidiaries to the Bank and Total Corp.
• Reporting by 4 areas: SEC (US GAAP) & US REG (Controller's office), DEC (Management rptg CFO level), BTMU REG (Japanese Regulatory, J-GAAP, JFSA).
• Installed Planning, HFM, FDM, DRM and Essbase and configured all modules for the client.
• Provide an overall roadmap and strategy for the Financial Planning & Financial Consolidation (FPFC) project from the old CoA in Oracle 11i towards new R12 implementation.
• GAP Analysis and advantages of running consolidation in HFM, using DRM for a single hierarchy management for the CORP.

Confidential - Kalamazoo, MI

Responsibilities:

• 30% onsite - 70% remote project. Evaluate technical issues related to session timeouts, web form lay outs, App server issues, report rendering issues, custom API issues as part of Upgrade form EPM 11.1.1.x to 11.1.2.1
• Recommended Load testing to the client and did Performance Load testing using OATS (Oracle Application Testing Suite).
• Optimized Server parameters such as Server memory and CPU settings for better memory/processor allocation.
• Optimized Application level memory, JVM parameters and did testing on user concurrency.
• Resolved Report and Web forms formatting and rendering issues.
• Optimized Financial Reports to make them run more efficiently (less resource intensive).
• Optimized Reports and web forms to pull in a subset of information relevant in the drop downs well as customized columns/rows.
• Trained users on Financial Reports and SmartView reports/adhoc analysis for best practices without overwhelming the application server.
• Resolved issues related to Application server error, 404 error, Application unavailability, downtime etc.
• Configured and Implemented Load Balancer for the Application Server and Web Server layers. Did knowledge transfer to the Server administrator.
• Created Books and snapshots. Parameterized Books and created batch jobs.
• Optimized HFM calc scripts and sub routines.
• Provided recommendations and optimized application hierarchies for Accounts, Entity and other custom dimensions.
• Created an Essbase database for sole reporting purposes.
• Optimized Batch and scheduler scripts.

Confidential - West Palm Beach, FL

Project Director/Sr. Hyperion HFM & Planning Architect (Hyperion Strategic Finance, HFM, Planning, Essbase, FDM, EAL)

Responsibilities:

• Managed $2M budget for a full life cycle HFM and HSF implementations.
• Did Project Planning, wrote RFP, performed SI interviews and SI selection for the HFM and HSF implementations.
• Worked with the selected SI in requirement gathering, POC application, design workshops. Built the application and did hands on script writing with the SI.
• Gathered requirements from the CFO's and Controller's office for Statutory and Corporate reporting needs.
• Designed an HFM application and wrote functional design document to in corporate main Corporate hierarchy and alternate views for Statutory, legal and local reporting hierarchies.
• Leveraged Value dimension for currency data loads and currency translations as well as entity roll ups.
• Wrote routines and scripts for currency translations, adjustments, consolidation processes.
• Build a Process Management flow to be used during and after Financial Close process to facilitate faster and more streamlined close process and subsequent financial reporting.
• Build the HSF application with the customer, provided over all guidance and technical design for account mapping, rules build.
• Creating HSF Models, customizing the account structure, calculating Balance sheet movement, calculating Retained Earnings in the Strategic Finance application.
• Performing What-If analysis on the models, Variance Analysis, analysis of cash points and asset positions.
• Integrating the Financial consolidation data from the HFM application to and loading it to the HSF application for long term Cash Planning.
• Analysis of Mergers and Acquisitions, inserting new deals, consolidating the target.
• Managing Entities and Time Periods in the HSF application.
• Creating Shareholder Value reports, Dividend discount reports and other Valuation reports for Valuation Analysis.
• Worked on User via UPK content for HFM and Planning.
• Worked on Hyperion infrastructure and administration issues, resolved issues like LCM migration, HFM matching report, EAL installation etc.
• Did minority interest calculations, CTA, automated cash flow, variance, movement analysis.
• Worked with the customer to build the FDM application to load data into HFM. Built mapping rules.
• Implemented EAL for real time data synchronization between HFM and Essbase.

Confidential - Elmwood Park, NJ

HFM Architect & Sr. DRM Developer (Hyperion Enterprise, HFM, DRM, FDM)

Responsibilities:

• Reviewed and Analyzed current Hyperion Enterprise system/consolidation process and hierarchies.
• Mapped hierarchies as to be implemented in HFM from Enterprise.
• Design & Implement the Hyperion Financial Management instance for Corporate consolidation from all JD Edwards and other legacy ledger data.
• Implemented currency translations (CTA rules) for 4 sets of currency with various combinations including monthly rates, daily rates and transaction rate.
• Built automated Cashflows accounts from B/S and for movement analysis.
• Provided financial statements for SEC 10K & Q reporting to be fed to XBRL.
• Feed HFM hierarchies from the DRM application.
• Upgrade DRM from 11.1.1.3 to DRM 11.1.2.1 application. Load, blend and manage hierarchies.
• Wrote minority interest calculations and variance analysis calculations.
• Wrote different consolidation and aggregation routines.
• Loaded DRM hierarchies from a Enterprise Account Management System for products, BUS and Plants.
• Performed entity roll ups and custom dimension reporting in order to accommodate table feature in Enterprise to enable multi-view reporting.
• Gathered requirements from the CFO's office for Statutory and Corporate reporting needs.
• Wrote requirement and functional design document to in corporate main Corporate hierarchy and alternate views for Statutory, legal and local reporting hierarchies.

Confidential - Washington, DC

Principal Hyperion Architect (HFM, DRM, Planning & FDM) (US-GAAP and IFRS)

Responsibilities:

• Over all HFM, Planning and DRM architect and administrator for applications in EPM 11.1.2 environment.
• Did development and administration of DRM and HFM applications. Wrote complex calculations, translation and consolidation routines incorporating different types of rates.
• Installed/Configured DRM and designed a DRM application based on the Product, Entity and Cost Center hierarchies.
• Wrote validation rules for DRM as well as built blending routines and import/export scripts.
• Migrated the hierarchies from System 9 MDM to EPM 11.1.x DRM application.
• Created a vanilla Hyperion Strategic Finance model application for the client.
• Did minority interest calculations, CTA, automated cash flow, variance, movement analysis.
• Built the FDM application to transport data into HFM. Built mapping rules.
• Did performance optimization on existing Planning app and the merged HFM application.
• Did migration, administration, backup and recovery of Planning, HFM, FDM and Essbase applications.
• Created shared hierarchies in DRM roll up.
• Build a mechanism for notification on orphans in DRM application.
• Responsible for overall administration of the Hyperion environment as the Lead administrator for HFM and Hyperion Strategic Finance (HSF).
• Transitioning the client from a physical to virtual environment and doing performance tuning.
• Optimized Planning and HFM application servers and tuned heap size, memory cache, Disk I/O caches.
• Consolidated the Essbase cubes environment around clustered server architecture for shared resources.
• Did a finance process walkthrough to better streamline their current business and finance processes w.r.t Budgeting, Financial Consolidation and Close, Planning, Projections and Reporting.
• Used Life Cycle Management (LCM) for migration of Planning, Essbase and Financial Reporting components.
• Did installation, configuration, deployment, registration of HFM and FDM in EPM 11.1.2 suite.

Confidential - Charlotte, NC

Hyperion DRM SME/ Sr. Planning Architect

Responsibilities:

• Did road map and product evaluation along with the business needs for future capability enhancement.
• Did performance optimization on Essbase cubes and Planning application. Reduced the calc time from 16.5 hours to 3.6 hrs on 2 mega Planning cubes.
• Installed/Configured DRM and designed a DRM application based on the Product, Entity and Cost Center hierarchies.
• Wrote validation rules for DRM as well as built blending routines.
• Migrated the MDM application from System 9.3.3 to DRM EPM 11.1.1.x
• Improved the Application server performance and Web form download/upload performance for Planning application including heap size, memory cache, Planning read/writes.
• Migrated the client from a Physical to Virtual environment and implemented Planning and Essbase in entirely clustered server architecture with SAN.
• Did a P2V and V2P evaluation. Reviewed network performance, Disk I/O for reads and writes from Planning to Essbase and Planning to metadata repository and identified bottlenecks.
• Worked with the Network engg. to increase the LUN capacity on the ESX host servers that hosted the virtual servers.
• Did a finance process walkthrough to better streamline their current business and finance processes w.r.t Budgeting, Financial Consolidation and Close, Planning, Projections and Reporting.
• Used Calc Manager to write complex Calc scripts. Converted old calc scripts to Business rules.
• Used Life Cycle Management (LCM) for migration of components. Converted a Classic application into EPM application mode.
• Implemented EPM 11.1.2 for the client and migrated from System 9.3.3 DRM and Planning application to EPM 11 although Oracle does not have a support migration path from System 9 to EPM 11.1.2.
• Migrated Essbase, Planning, Hyperion Strategic Finance and Financial Reporting.
• Wrote HFM calc scripts and consolidation routines for consolidation, minority interest calculation, translations, conversion between different entities roll ups for corporate reporting
• Troubleshooted Financial Reports migrated from 9.3.1 to 11.1.2 which was not working post migration.
• Did user, produced material, Led UAT and provided Documentation and knowledge transfer.
• Re-implemented Hyperion Strategic Finance application from scratch after gathering Business requirements. .
• Did installation, configuration, deployment, registration of entire EPM 11.1.2 suite.
• Managed a Project team of developers, admin and functional resources.

Confidential - San Francisco, CA

Hyperion Project Director/HFM Solution Architect

Responsibilities:

• Implement Revenue Planning, Capital Asset Planning and Workforce Planning modules to cover all subsidiaries.
• Streamlined reporting for new acquisitions and mergers by bringing in accounts from different charts and consolidating them via FDQM.
• Implemented Financial Close Management for better and faster close cycles, prevent hard close and subsequent 10Q reporting and Management reporting.
• Provided reverse integration with the ledger from HFM 11.1.1.3 and Planning via FDQM.
• Lead design discussions and architected the Planning/Essbase layout. Did Essbase performance tuning for caches, CPU parallelization, Hierarchy re-design and overall Planning, HFM 11.1.1.3 and Essbase application optimization.
• Managed the project in 2 phases with CAPEX & Workforce modules going in phase I as part of “quick wins” and Stream lining Revenue Planning and the close process in a larger design phase II.
• Used Calc Manager to write complex Calc scripts.
• Used EPMA Architect to build ETL for dimension build and load. Experience implementing EPM Planning (and Classic) applications.
• Used Life Cycle Management (LCM) for migration of components.

Confidential - San Francisco, CA

Project Director/HFM Sr. Lead (US-GAAP & J-GAAP)

Responsibilities:

• Implement HFM 11.1.1.3 consolidation processfor corporate level reporting by legal hierarchy.
• Implement OrgbyPeriod functionality to accommodate changing Legal Entity/RC rollups by year.
• Provide Account hierarchy and financial statements for SEC 10K & Q.
• Implement REG reporting for external reporting to the Federal Reserve.
• Did minority interest calculations, CTA, automated cash flow, variance, movement analysis.
• Automate GL adjustments and OTT (Over the Top) adjustments process and synchronize within the HFM App.
• Provide for multi calendar (Japanis on Apr thru March calendar, US on Jan thru Dec).
• Bring Budget and Forecast from OFSA and create FLASH scenarios to be able to analyze Rate data.
• Create Suspense accounts and be able to accommodateone to one, one to many, many to one and many to many eliminations (plug acct by the common ancestor/parent).
• Minority interest calculations between banking and non-banking entities, subsidiaries to the Bank and Total Corp.
• Reporting by 4 areas: SEC (US GAAP) & US REG (Controller's office), DEC (Management rptg CFO level), BTMU REG (Japanese Regulatory, J-GAAP, JFSA).

Confidential - Boston, MA

Commercial Banking Sector

Responsibilities:

• Installed Planning, HFM, FDM, DRM and Essbase and configured all modules for the client.
• Installed DRM and migrated Hyperion MDM hierarchies and validation rules to DRM.
• Integrated DRM with the FDW for pushing the accounts, cost centers and business units.
• Integrated DRM with newly built HFM and existing Oracle EBS interface.
• Created roles and approval levels in DRM for accounts and cost center approvals.
• Currently on a planning, design and implementation engagement of a Global initiative on Oracle EPM 11.1.1.0 and CCOA implementation in Oracle R12/Fusion (GL and various SLA - Sub Ledger Accounting).
• Recommend solutions and work with Corp Finance team in implementing a new CCOA after Studying the Current 8 segment COA from Oracle 11.5.10 and various 3 or 4 segment legacy ledgers (50 + of them mainframe ledgers) from all international sites.
• Study the consolidated Corp ledger used for delta analysis and FOREX currency conversion, translation and re-evaluation (called FCS that stored consolidated transactions from the 50+ local ledgers from the International sites - for a CORP specific view).
• Study and Plan the architecture components of the GFS (Global Financial Systems) implementation at State Street. Components include Oracle 11i, R12, SLA, IRT, FAH & MRC from Oracle GL/sets of books and other Hyperion components including Planning, HFM, DRM, HFR, Essbase, Essbase Studio, DIM all on EPM 11 and Oracle reporting on OBIEE, Discover etc among other components.
• Design & Implement the Hyperion Financial Management instance for consolidation from all Oracle and legacy ledger data and feed to FDW.
• Design & Implement another Hyperion Financial Management instance for Functional currency translation for 9 sets of currency with various combinations including 10 spot rates, monthly rates, daily rates and transaction rate.
• Design and Implement a Data Relationship Management solution for managing Accounts and Responsibility Center (Cost Center) multi-hierarchies based on the new Common Chat of Accounts.
• Implement Workflow functionality within DRM for a single point Corporate hierarchy management from where hierarchy is fed to Oracle GL, HFM, FDW and Essbase cubes.
• Re-implemented custom tool for deposit reconciliation called Recon+ into Cash Management module of Oracle R12.
• Re-Implemented existing Essbase 6.5 cubes into EPM 11.1.1.0 and re-designed the Financial Reporting solution away from home grown Actuate reports to Hyperion Financial Reports.
• Developed consolidation rules for HFM and implemented intra-day consolidation/calcs.
• Used Essbase Studio in EPM 11 to remodel the star schema from FDW on which FinRev cube was based off of.
• Creating a new environment for HPMA and did migrations for Essbase and Hyperion Reports while doing fresh implementation for Hyperion Planning (Forecasting and Earnings Projection piece) and brand new instances for HFM.
• Provide an overall roadmap and strategy for the GFS project from the old CoA in Oracle 11i towards new R12 implementation along with bringing in new Hyperion modules and introducing EPM 11 at State Street
• Provided with a design road map for any future enablement of Oracle R12 to Oracle Fusion end state. Did Oracle 11i 8-segment chart conversion to R12 4-segment chart. Also did Chart consolidation from bringing in companies from international sites which were on legacy ledgers into Oracle ledger. Opened new sets of books for international sites (in 2 weeks with testing).
• Worked on streamlining the chart fields and maintaining a common hierarchy for the chart of accounts (CoA) within Oracle Financials R12. THICK -> THIN ledger.
• GAP Analysis and advantages of running consolidation in HFM, using DRM for a single hierarchy management for the CORP and Earnings Projects in Hyperion Planning (previously down using Java interfaces with Essbase as a back end.
• Provide consulting on the Budgeting Application and on utilizing Capital Expense Planning. Enables CAPEX module.
• Implemented data conversion rules for FDM data quality management (coming from Oracle R12) and drill down from FDQM to R12 at the account level (trial balance level).
• Re-implemented the existing Planning application for Management Reporting by defining the Product dimension after the new CCOA implementation.
• Ongoing processes in GFS initiative of transitioning from the old world to the new world.

Confidential -Hartford, CT

Hyperion Expert, Sr. MDM/DRM Developer

Responsibilities:

• Design and Implementation assignment on Oracle EPMA 11.1 and Oracle Financials 11i and R12 (AR, AP, PO, Sourcing and GL).
• Creating a new environment for migration of Hyperion Enterprise 6.3 application to System 9.3.1.1 to EPM 11.1.
• Installed Planning, DRM and Essbase and configured all modules for the client.
• Maintained the existing MDM application and enhanced the hierarchies and hierarchy groups.
• Created and associated Property definitions in MDM with the Oracle Financials.
• Upgrading Hyperion Planning & DRM from System 9.3.1 to EPMA 11.1 on SQL Server back end.
• Provide with a roadmap to implement the Sales and expense cubes.
• Provided with a design road map for upgrade from MDM to DRM.
• Through a formal, rule-driven process, used Hyperion ORACLE/HYPERION MDM to synchronize BPM business dimensions, reporting structures, hierarchies, attributes and business rules across 3 System 9 applications and an enterprise system, including FDW data warehouse, and 2 data marts (BPM mart and NA DIM mart).
• Did ORACLE/HYPERION MDM admin roles like loading Master data, export, managing security, implemented business rules and Tracked Master Data changes by managing Versions and Hierarchies.
• Worked on streamlining the chart fields and maintaining a common hierarchy for the chart of accounts (CoA) within Oracle Financials 11i.
• Provide consulting on the Budgeting Application and on utilizing Capex and Balance sheet modules to implement P&L statement within Hyperion Planning product.
• Currently working on Budgeting headcount with employee groupings (without using Workforce Planning functionality). Estimation of headcount by Cost Center and employee (FTE & Contractor) allocation by CC.
• Worked with Hierarchies, searching nodes, comparing Master Data (MDM instance) and configured Hyperion DRM instance.
• Implemented data conversion rules for FDM data quality management and Hyperion MDM repository management for maintaining central repository for COA hierarchy in Essbase.
• Currently working on laying a road map to bring data from SAP BW into OBIEE warehouse for reporting on EPMA platform off of Interactive Reporting and Web Analysis.

Confidential - Cincinnati, OH

HFM Architect & Sr. Developer (HFM, HFR, Hyperion MDM)

Responsibilities:

• Was hired by the SI (Infosys) to lead the HFM project to gathered requirements from business and design and build an HFM app based on best practices..
• Wrote requirement and functional design document to in corporate main Corporate hierarchy and alternate views for Statutory, legal and local reporting hierarchies.
• Design & Implement the Hyperion Financial Management and MDM hierarchy management instances for Corporate consolidation from all PeopleSoft and other legacy Mainframe ledger systems.
• Build Legal, Corporate, Statutory hierarchies for multi-reporting.
• Implemented currency translations (CTA rules) for 4 sets of currency with various combinations including monthly rates, daily rates and transaction rate.
• Built automated Cashflows accounts from B/S and for movement analysis.
• Provided financial statements for SEC 10K & Q reporting as well as Regulatory reporting needs for teh Federal Reserve.
• Developed consolidation rules for HFM and implemented intra-day consolidation/calcs.
• Wrote minority interest calculations and variance analysis calculations.
• Wrote different consolidation and aggregation routines.

Confidential

Sr. Planning and HFM Architect

Responsibilities:

• Hyperion System 9.4.1.1 implementation and upgrade to System 9.5 - Oracle EPMA 11.1 architecture. Oracle Apps 11i and upgrade to R12. OBIEE Integration
• Planned user base . HFM user base -85- 120. MDM user base- 40
• Architected a customization of Capital Asset Planning for building the account structures for corporate capital assets and capital Asset related expense needs.
• Enabled and customized Hyperion Workforce Planning module for efficient employee compensation planning and headcount of the workforce/employee base. This enabled for Workforce compensation planning to seamlessly integrate with their overall expense planning.
• Designed and administered Oracle GL system that fed into the HFM application and reverse feed into Oracle General Ledger.
• Worked on public and private Legal Entities and calculating minority interests and Inter-company Eliminations (InterCo Elims).
• Month end closing process, forecasting, working on books and accounting for HFM consolidation process and Planning allocations and aggregation cubes.
• Installation/Configuration of System 9.3.1 Planning, ORACLE/HYPERION MDM, SmartView, Financial Reporting, Essbase and Interactive Reporting.
• Upgrading Planning from version 9.4.1 to EPM 11. Upgrading the application and migrating the application data and security. Implementing the new EPMA on OBIEE architecture.
• To evaluate the current infrastructure and Planning/Essbase application requirements and provide recommendations.
• Understand existing HAL routines in System 9.3.1 and implement them in DIM interfaces for SAP data and ODI interfaces for Planning metadata input.
• Implemented the OBIEE architecture and Installation of Hyperion Financial Management 9.3 and creating the EPCO Consolidation Application for minority interest consolidation for accounts coming from Oracle 11.5.
• To build a reporting environment for TEPCO for Interactive and Financial reporting out of Planning application.
• Define and Design the data load mechanism and Planning forms, scenarios creation, data copy, Calculations.
• Architect and Designing optimal Essbase BSO database architecture and troubleshooting existing ones.
• Troubleshoot Planning/MDM/Essbase and Reporting issues in existing architecture.
• Remodel the existing metadata load process in HAL from System 9.3.1.1 into an ODI interface solution after upgrading to EPM 11.1 since System 9.3.1 is the last version to support HAL.
• Design BSO Essbase cube for Planning and an ASO cube for Reporting purposes. Use Partitioning technique to copy data from BSO to ASO cube.
• Mentor and knowledge transfer to the employees. Provide for use/admin of HFM, FDM and ORACLE/HYPERION MDM tools.
• Providing expertise and recommendations on SAN capacity and VMWare virtualization and redistributing the servers architecture. Providing optimal Hyperion design per user base.
• Build HAL routines and calc scripts for HFM. Build the ODI interfaces for Hyperion Planning.
• Extensive use of SmartView for Planning, Reporting and HFM applications. User in SmartView.
• Troubleshoot existing HFM application and update the HFM rules.
• Build new environment for HFM and central ORACLE/HYPERION MDM repository and migrate the applications to Enterprise Performance Management. Mapped different business segments into the ORACLE/HYPERION MDM application segments.
• Managed DRM properties, wrote formulas and business rules for validations and verifications.
• Build Extended Analysis for extracting consolidated data from HFM and push it to Oracle Financials.
• Work with the business on Defining and Designing Hyperion Planning and Financial Reporting templates.
• Did installation and configuration of all System 9 modules including Planning, Financial Reporting, HFM and Essbase, Interactive Reporting with SQL Server 2000 backend and then upgrade/migration to SQL 2005.
• Pulling data from OBIEE warehouse for Brio and then Interactive Reporting purposes.
• Work on the Planning calculation scripts/outline formulas and Planning and HFM business rules.

Environment: In depth experience in Hyperion Financial Management 9.4.1 & 9.5 and Hyperion Planning 9.4.1 and EPM 11.1, Capital Asset Planning and Hyperion Workforce Planning. FDM and ORACLE/HYPERION MDM implementation. Essbase 7 & 9.x, Financial Reporting 7 & 9.x, ODI, SmartView, HAL and Interactive Reporting 8 & 9.x, Oracle Apps 11i, Oracle Discoverer and OWB and SQL Server 2000 and 2005.

Confidential - Detroit, MI

Sr. Technical Lead/Hyperion Architect (Planning and MDM)

Responsibilities:

• Hyperion System 9.3.1.1 implementation (Planning, ORACLE/HYPERION MDM and HFM) on Unix, Sun Solaris 10
• Led a team of 16 as Sr. Lead and Architect on Short term forecasting process providing guidance and lead on the “Short Term Forecasting and Budgeting” (STFB) project from Hyperion Planning, Essbase and Financial Reporting side.
• Designed BSO Essbase cube for Planning and an ASO cube for Reporting purposes. Used partitioning technique to copy data from BSO to ASO cube.
• Evaluated the project requirement and define scope
• Define and Design the data load mechanism and provide guidance to the Bangalore team on file formats, different feeds and load types.
• Provided Load Balancer capabilities to front-end the Hyperion 9.3.1 environment.
• Customizing the Capital Asset Planning piece for efficient planning for not only capital Asset but also capital Asset related expenses. Also enabled Workforce Planning for employee headcount and salary & expense planning. The intent was to capture overall employee related expenses.
• Used Essbase Integration Services (EIS) for hybrid analysis and created star schema, meta outline and catalog.
• Creating High-Availability Clusters using Hyperion high availability licenses for failover capacity planning.
• Making sure the client side interface is secured by SSL on the load balancer.
• Provide architectural leadership in the System 9.3.0.1 and 9.3.1.1 product configuration and deployment.
• Work with the business on Defining and Designing Hyperion Planning and Financial Reporting templates.
• Provide leadership to the offshore team in India in the developmental efforts on the forms and reports design.
• Provide recommendations on the Budget Planning and Financial Management HFM architecture and recommend upgrades to System 9.3.1.1 environment with SQL Server 2000 for meta data.
• Use of SmartView for Planning and Financial Reporting applications. User in SmartView.
• Using Asymmetric and priority activation load balancing techniques for the US and Global volumes.
• Did installation and configuration of all System 9 modules including Planning Financial Reporting HFM and Essbase.
• HFM account hierarchy maintenance, creating consolidation rules and helping the client for month end closing.
• Maintenance of the GL accounts hierarchy and related metadata in ORACLE/HYPERION MDM. Used versioning.
• Provide support and guidance to production teams in Canada and educate them on the implementation of System 9 modules including Budget (Capex & Workforce) Planning, Reporting and Hyperion Financial Management.
• Work on the calculation scripts/outline formulas and business rules and provide technical guidance to the development team in India

Confidential - Memphis, TN

BI/DW Consultant/Sr. Architect Hyperion & Business Objects

Responsibilities:

• Teradata Data warehouse, Hyperion Financial Management and BO Reporting)
• This was a short term assignment with the client needing some guidance and leadership with related BI and DW technologies in a Teradata Warehouse and HFM environment and BI reporting on Business Object Universes. It overlapped with GM contract for 3 months.

Confidential - Indianapolis, IN

BI Manager/Sr. Architect Hyperion with SAP GL emphasis

Responsibilities:

• Hyperion Planning and Interactive Reporting, FDM on Linux platform
• Evaluate the current Hyperion architecture and present the future state.
• Implement System 9.3.1 for Planning, Interactive Reporting(IR) and Financial Data Management (FDM).
• Implemented Hyperion Workforce Planning to satisfy their general expense planning and to plan detailed workforce related expense and compensation by using built-in dimensions and account structures.
• Lead a team of Hyperion Administrators and finalize project plans for the team.
• Design and Implement the Hyperion Master Data Management for Agency Markets. Implemented rules driven workflow process for hierarchy comparison, verification and meta data blending.
• Work with the EDW (Enterprise Data warehouse) Manager and review the Data warehouse implementation.
• Building Virtual environment to support additional warehousing needs. SAN space for Production risk mitigation.
• Implemented FDM Data management relationship and installed/configured the FDM architecture for the production data quality management for data going to the Data Warehouse.
• Provide recommendations and implementation on load balancing and Capacity failover using Network Load Balancing Services. Cisco Application Control was recommended and implemented.
• Implemented Business rules and verification tasks to manage parallel hierarchies within FDM’s different sub-systems.
• Provide recommendations on the Planning architecture and recommend upgrades to System 9.3 environment.
• Provide recommendations and do critical analysis on the Enterprise Data warehouse.

Confidential - Washington, DC

BI Consultant / Speaker

Responsibilities:

• Spoke on the need and importance of Business Intelligence and Data warehousing solutions in financial, retail and manufacturing sectors.
• Spoke on different BI planning and Reporting tools available in the market and critically evaluate and compare them.

Confidential - Springfield, MO

Principal Consultant/Solution Architect

Responsibilities:

• Evaluate the current Decision support system on Hyperion Planning.
• Upgrade Planning from 3.5.1 to 4.0.5 and migrate the Confidential 's Payroll and Financial Planning applications to the new environment.
• Implement a "BASSPlan" Planning model for 12 month rolling forecast for the accounting cube..
• Enabled Workforce Planning to capture employee compensation and capital expenses efficiently. This enabled for Workforce compensation planning to seamlessly integrate with their overall expense planning.
• Implement the scenarios and plan of records for plan version upgrades and cost centers for Confidential 's new regional shops.
• Implement replicated partitioning for the FinPlan application to track and separate previous year's plan from the next year's.

Confidential - Juno Beach, FL

Planning, Reporting and Forecasting Architect, FDM Specialist

Responsibilities:

• Assessment work - Detailed High level Plan design
• Evaluate and assess the current Planning implementation and provide with a detailed roadmap design to implement the 2008 Budget process on System 9.2.0.2
• Provide with inputs on the current Essbase applications
• Understand existing HAL routines and engineer a DIM/ODI based data load solution from the Oracle Financials General Ledger (GL accounts).
• Designed & developed Interfaces/Extracts from Oracle Applications & OTM
• Create a high level design for 5 business models and one chart of account (CoA) from Oracle Financials.
• Analyzed Gaps between SAP Accounts Receivable and Oracle 11i Accounts receivable and designed solutions / fixes.
• An end-to-end view of the supply chain to derive significant business benefits and selected Oracle e-business suite software.
• Work with the Director of Corporate Planning to come up with an Implementation model for Oracle Apps and Hyperion integration and detailed roadmap.
• Installed Planning, HFM,FQDM and Essbase and configured all modules for the client.
• Wrote Business Rules for Planning and FDM.

Confidential -Herndon, VA

BI-DW Manager/Hyperion Solution Expert

Responsibilities:

• Provide recommendations and BI solutions for Confidential Restatement project.
• Provide detailed roadmap for the IT infrastructure and BI strategy for Corporate Budgeting, Forecasting and Reporting needs.
• Study and approve the “Catch-up” and “Get Current” landscapes for Financial Reporting infrastructure and Hyperion license needs.
• Work in tandem to integrate Hyperion with other BI & ETL solutions (Business Objects, Informatica, Ab-initio) in place at Confidential for Corporate-wide Reporting and Planning (Budgets & Forecasts)
• Lead a team of 4 System Administrators and 3 Essbase/Planning developers, report to the director.
• Guide the efforts related to consolidation at application/server level, perform Essbase server cleanup and server optimization.
• Implemented F5 BigIP in front of three Hyperion Apache Servers. F5 was used to handle SSL encryption and failover capacity while directing the users from F5 to the Apache web servers.
• Implemented Hyperion System 9.2 Planning for corporate wide Planning, Budgeting and Forecasting.
• Implement Hyperion System 9.3 on UNIX (Sun Solaris) for “Catch-up” needs.
• Built a test System 9 environment on a Linux machine and migrate the 10K and MBS cubes from Unix to Linux server.
• Upgraded Planning infrastructure from System 9.0.1 to 9.2.0.1 and then to 9.2.0.2.
• Confirm requirements from ReqPro and implement the FDM application for metadata management.
• Writing formulas and business rules for hierarchy management and synchronization.
• Put in place SOX, CM procedures and processes and other best practices in the restatement and non-restatement Hyperion landscape.
• Implement Business Rules to capture changes to accounts Hierarchy and addition of new cost centers.
• Implement ODI interfaces to capture data from Oracle Financials GL and to update the accounts hierarchy for the MBS securities and the essbase accounting cubes.
• Implemented meta data catalog and meta outline in EIS and created star schema for bringing in data from the warehouse for analysis purposes.
• Implement Aggregate Storage models for Revenue & Forecast databases and Block storage for the Expense database model.
• Implement transparent partitions for the Expense and Revenue models.
• Implement a rolling forecast model for WorkForce Planning. The idea was to assess the workforce related expenses impact on corporate performance in real-time. This module was built in phases, starting with employee headcount and salary planning, as expenses for various accounts and divisions came in from Oracle Financials and SAP.
• Enhance and stabilize Oracle application. Modules include AR, AP, GL, iProcurement, Web Expenses (iExpenses), Time & Labour (OTL) and a custom Order Entry module.
• Developed interfaces between Custom OE to AR. Workflow related enhancements and development in OTL, iProcurment and Web expenses.
• Development/Configuring Oracle 11i to fit Business needs. SOX compliant related reports and processes development.
• Designed and developed packaged procedures to convert/interface to Oracle AR 11i from legacy (11.0.2), which included Customers Header/Site records, Invoices (Project & Non-Project).
• Implementation of Oracle Applications v11i (11.5.8) using Rapid Install technics. Data Conversion/Import, Interfaces and extracts to/from Oracle 11.5.8 Apps.

Confidential - Herndon, VA

Essbase Architect & System Admin

Responsibilities:

• Data Integration: Build Essbase cubes to integrate data from Nextel Data warehouse (NDW) and Sprint sales data mart on SQL Server DB.
• Get the employee and accounts hierarchy from their SAP HR and CRM modules and integrate it with the new Essbase outline.
• Perform server level and cube level optimization to in corporate future enhancements in the merged entity cubes.
• Design the basic skeleton for the Hyperion Planning integration project cubes in order to facilitate with ease the dense and sparse dimensions migrations.

Confidential - San Francisco, CA & Greenwich, CT

Team lead - Hyperion

Responsibilities:

• Led a team of 5 Essbase developers and 1 System Admin to implement low level design for Time and Labor cubes.
• Travel on pilot trips to client site to test the application cubes for Cost-Benefit analysis on unique loan/mortgage parameters.
• Generated risk assessment reports on the cost-benefit analysis in Hyperion Analyzer.
• Migration of the credit risk model cubes from Windows to Linux environment.

Confidential - Los Angeles, CA

Project Lead

Responsibilities:

• Managed 6-10 person teams onsite and offshore of developers/testers to build an Analytical DB2 data warehouse from existing Oracle/SQL 2000 and legacy systems feeds.
• Back-Room activities: Real-time operational reporting based on improved data latency using Informatica & Trillium parsing algorithm.
• Front-Room activities: Created an Analytical Repository for Honda Motors’ marketing division.
• Core member in designing a “Marketing Research & Trend Analysis algorithm”. Implemented it by leveraging J2EE developers and QA testers.
• Lead a team of 3 Essbase developers to build marketing and finance/accounting cubes on the newly created warehouse. Reporting was done on Hyperion Reports.

Confidential - Glendale, CA

Sr. Essbase Designer & BO Designer

Responsibilities:

• Develop Essbase cubes and build BO universes to report and reconcile data from relational Oracle source and newly build cubes.
• Develop and maintain technical procedures/documentation on converting the traditional Oracle database schemas in Essbase cubes.
• Act as an on-site consultant to provide for end users on BO reporting from Oracle and Essbase sources.

Confidential - San Francisco, CA

Data Warehouse Consultant

Responsibilities:

• Implementation of Kimball methodology to build a warehouse to accept feeds from conversion and batch jobs.
• Build individual marts to accommodate online data to achieve near real time query results.
• Use Cognos Power Play transformers to convert the data between relational to multidimensional databases.

Confidential -San Francisco, CA

BO & Informatica developer

Responsibilities:

• Developed ETL Mappings to parse, transform and load data using Informatica Designer.
• Create Ad-hoc reports, single universe and complex multi-universe reports to provide drill down, drill thru, ad-hoc analysis and hierarchical flow analysis.
• Build and tune views to support business objects queries. Scheduled reports using Business Objects Broadcast Agent.