PROFILE SUMMARY:

• Certified Hyperion Planning Consultant and Certified Hyperion Financial Management HFM Consultant with over 14 years experience in Hyperion/DW/BI related technologies in OBIEE, EPMA, Business Objects, Informatica, Oracle 11.5 and Oracle R12, Hyperion and Cognos.
• Management Consulting experience with financial and banking clients of Deloitte Touch Tohmatsu. 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 Deloitte Touch Tohmatsu and it sister firms for 8 years.
• Experienced with domestic and international clients and have had onsite client interaction in Europe and States.

EXTRA CURRICULAR ACTIVITIES

• Published 2 research papers on Robotics and Neural Networks Reference IIT 1998 published papers in AI Robotics.
• Mid-fielder Deloitte soccer team - San Francisco.
• Finished in top 4 in Chess championship league at state level.
• Speaker on best practices and tools in BI/DW conferences for Northern Virginia and DC clients.

EXPERIENCE

Confidential

• Designed and implemented the Planning application for Revenue and Expense planning as well as workforce salary and headcount forecasts. Lead a Hyperion team of 3 developers and did hands-on development
• Looked into the existing Hyperion Financial Management application and build anew design with new dimensionality to confirm with new CoA in DRM.
• Re-wrote CTA calculations and consolidation routines for the new HFM application.
• Build the Essbase cube out of HFM via EAL data synchronization, on the fly.
• Assisted the business do reconciliation between HFM-Essbase cube and Planning data.
• Build a solution for data transfer between Planning and the new HFM application based on new account codes and confirmed dimensionality. Enabled for month end consolidated data transfer from HFM to Planning and Forecasted Balance sheet data from Planning to HFM for cash flow statement generation.
• Implemented HFM 11.1.2.3 consolidation process for Balance sheet and Profit/Loss hierarchies.
• Implemented alternate hierarchies for Corporate, Statutory, Legal, Strategy and Treasury reporting needs.
• Wrote CTA and transfer rules as well as assisted business users do financial analysis and reconciliation process.
• Installed Planning, HFM, FDM, DRM and Essbase and configured all modules for the client on 11.1.2.3.
• 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.
• 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.
• 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

Overall Solution Architect

• 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.
• 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.
• Developed consolidation rules for HYPERION PLANNING and Essbase and implemented intra-day consolidation/calcs.
• Design Implement the Hyperion Planning instance for Corporate consolidation from all Oracle, PS and legacy ledger data.
• Implemented HYPERION PLANNING 11.1.2.3 consolidation process for Balance sheet and Profit/Loss hierarchies.
• Wrote Essbase calculation scripts.
• Created BSO and ASO cubes and converted existing BSO cubes to ASO.
• Created High-Availability Clusters using Hyperion Essbase high availability licenses for failover capacity planning.
• Installed HYPERION PLANNING, FDM and Essbase and configured all modules for the client.
• Created multiple profiles by Location and loaded data from legacy systems as well as FBS.
• Integrated ERPi adapter doe Essbase with FDM for drill through and drill down purposes back to the source ledger.
• Overall Solution Architect for the client overseeing the Development and Hyperion Support teams for HFM, DRM OBIEE.
• Provide financial statements for SEC 10K Q reporting to be fed to Financial Disclosure Management.
• Implement OrgbyPeriod functionality to accommodate changing Legal Entity/RC rollups by year.
• Mapped intercompany entities and automated intercompany eliminations via ICP dimension. Implemented InterCompany Revenue and InterCompany Expense reporting.
• Automated Cashflow accounts, YOY Roll forwarding, variance reporting and movement analysis.
• Implemented multi use of Custom1 BU , Custom2 Functional reporting , Custom 3 sub ledger accounts, Custom 4 C/F, RF, Variance .
• Automated entity roll ups for different various US and international entities/currencies combinations.
• Automated Currency Translations and implemented VALUE dimension for Entity Curr data loads, Entity Curr Adjustments, Parent Currency Adjustments and Contribution adjusts.
• Implemented alternate hierarchies for Corporate, Statutory, Legal, Strategy and Treasury reporting needs.
• Implemented HFM 11.1.2.2 consolidation process for Balance sheet and Profit/Loss hierarchies.
• Implemented DRM Workflow methodology and processes.
• Established DRM Workflow management for synchronized effort on Version approval and on managing multiple instances of orphans as well as shared nodes and leaves.
• Created Action scripts for bulk set of incremental updates.
• Loaded Hierarchies and properties for nodes, members as well as created export and import scripts in DRM.
• 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.
• Reporting by 4 areas: SEC US GAAP US REG Controller's office , DEC Management rptg CFO level , BTMU REG Japanese Regulatory, J-GAAP, JFSA .
• Minority interest calculations between banking and non-banking entities, subsidiaries to the Bank and Total Corp.
• Bring Budget and Forecast from OFSA and create FLASH scenarios to be able to analyze Rate data.
• Provide for multi calendar Japan is on Apr thru March calendar, US on Jan thru Dec .
• Automate GL adjustments and OTT Over the Top adjustments process and synchronize within the HFM App.
• 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

• Understood the Obligation and Cost Planning process at the CDC by Office of Finance Management FMO
• Designed the Human Capital Management system in PSPB to manage and allocate positions and salary.
• Helped CDC design a process in order to calculate the bill rates for various services provided by the Service lines to the CIOs.
• Designed an allocation and cost accounting methodology in Hyperion profitability and Cost Management utilizing the Cost Management functionality in HPCM.
• Designed a process to feed the allocated budget and the forecast numbers to Hyperion public Sector Planning application in order to calculate the unit rate.
• Designed a process to allocate the calculated costs down to the Disease lines in PSPB.
• Wrote calculations for Service Order, Service Obligation and CIO cost as well as Disease line cost allocation in HPCM and PSPB.
• Designed a process for fund allocation, appropriation based on Budget resolution by the Congress so that the Budget numbers in PSPB are up to date and thus the rate is current.
• 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.
• Created Books and snapshots. Parameterized Books and created batch jobs.
• Provided recommendations and optimized application hierarchies for Accounts, Entity and other custom dimensions.
• Created an Essbase database for sole reporting purposes.

Confidential

• Integrated the existing Planning application with newly built PSPB application in EPM 11.1.2 environment.
• Did development and administration of Planning and PSPB application. Wrote complex calculations and consolidation routines.
• Created a vanilla Hyperion Strategic Finance model application for the client
• Did minority interest calculations and currency translations.
• Built the FDM application to transport data between PSPB and Planning applications
• Built mapping rules to integrate HCM Human Capital Management to employee and position data in Peoplesoft
• Did performance optimization on existing Planning app and the merged PSPB applications.
• Did migration, administration, backup and recovery of Planning, PSPB, FDM and Essbase applications.
• Optimized Planning and PSPB applications 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 PSPB and FDM in EPM 11.1.2 suite.

Confidential

• Created an Essbase database for sole reporting purposes and linked with HYPERION PLANNING using EAL. Created data synchronization bridges.
• Did optimization on Essbase cubes and reduced load times.
• Optimized Essbase and HYPERION PLANNING calc scripts and sub routines.
• Provided recommendations and optimized application hierarchies for Accounts, Entity and other custom dimensions. Optimized Batch and scheduler scripts.
• 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.

Confidential

• 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 training, produced training 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

• 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 HYPERION PLANNING application and wrote functional design document to incorporate main Corporate hierarchy and alternate views for Statutory, legal and local reporting hierarchies.
• Performing What-If analysis on the models, Variance Analysis, analysis of cash points and asset positions.
• Integrating the Financial consolidation data from the HYPERION PLANNING application to and loading it to the HSF application for long term Cash Planning using FDM adapters for HSF.
• Designed BSO Essbase cube for Planning and an ASO cube for Reporting purposes. Used partitioning technique to copy data from BSO to ASO cube.
• 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.
• Implemented EAL for real time data synchronization between HYPERION PLANNING and Essbase.
• 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 training 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