SUMMARY:

• Overall 15+ Years of experience in DWH/BI and Hyperion tools HFM,HPCM,Essbase,Planning, DRM, FDM/FDMEE
• Extensive implementation experience on Premises and cloud based FDMEE,FCM,FCCS, EPBCS,FCCS
• 5+ Years of Project and delivery management experience in DWH/BI/EPM Hyperion Applications
• Managerial experience on client facing projects, leading offshore and onsite vendor management initiatives
• Experienced in Financial close management, HPCM, Balance Sheet planning and Public Sector budgeting
• Extensive experience in migrating / upgrading applications from Hyperion Enteriprise to HFM
• Extensive experience in implementing SAP® HANA and SAP® EHS
• Experienced with GL, Account Payable, Cash receivable from JDE, SAP, EBS, PS and Lawson Financial
• Integrated EPMA applications with several source systems such as SAP, JDE, PS and Lawson Financial
• Extensive experience in migration applications from FDM to FDMEE (both Cloud and On - Primse)
• Extensive experience of upgrading Hyperion applications, Planning, FDM, DRM, HFM, FCM, HPCM from 9.x to 11.x
• Integrated FCM application with PS and Lawson Group financial, EBS for creation task types and importing of tasks
• Hands on Hyperion admin experience of installation, performance tuning, reconstructing, migration and upgrades
• Consultation experience in technology implementation to enable business excellence and organizational efficiency
• Knowledge & hands on experience on integration tools like ODI, FDQM & reporting tools like HFR, OBIEE
• Experienced in all phases of Software Development Life Cycle (SDLC) with extensive experience in requirement gathering, design, development and testing of packaged applications
• Experienced in developing Statement of Financial Position Reports, Transaction statement reports, Trial Balance Reports, Cash Flow Statement Reports, using Hyperion Reporting tools like Financial Reports and Web analysis
• Deep analytical skills to comprehend and resolve complex issues
• Built successful client relationships by providing guidance and support on various services.
• Implemented many cost effective methods in projects lead multiple of projects at a time in implementations and transition process to offshore. created effective methods to between team and successfully handled all the projects in under one roof.
• Strong experience in operations management, Vendor Management, Client management
• More than 5 +years of experience in executing implementation, upgrades, support and maintenance projects.
• Servers sizing and Deployment Architecture preparation
• Consolidate the existing infrastructure for upgrade project
• Product selection and component distribution as per client requirements
• Pre-requisites and deployment checklist preparation
• Installation and Configuration of products on Windows and Linux operating systems
• SQL Server and Oracle DB installations, if required
• Disaster recovery environment setup and testing
• Business Requirement gathering and preparation of BRD’s
• Doing gap analysis and feasibility study between user requirements and products from design perspective.
• Involved in all aspects of Product development
• Responsible for defining and implementing Security issues like creating users, groups and filters, Integration with MSAD (Active Directory).
• Automation of complete activities like metadata load, data load, back up of Applications and, oracle database, refresh excel reports with email notifications and alerts.
• Application migration from Development to Test to UAT to Production environment.
• Actively identified and escalated issues and risks associated in the project with respect to the Design leveraging a standard methodology. Assisted in troubleshooting, and taking corrective action.
• Lead the transition process where Competency took over the Support process from SI vendor.
• Provide Hyperion specific support, maintenance and enhancement needed to ensure lights on for the financial management application.
• Lead the transition process where IBM took over the Support process from SI vendor.
• Provide Hyperion specific support, maintenance and enhancement needed to ensure lights on for the financial management application, DRM, FDM, FCM and HPCM.
• Achieve excellent rating in all Group / External / Internal / Service Quality Audits.
• Ensure the month end activities like server rebooting and backup and RFC’s maintaining are completed within time lines. Responsible to chair all status calls, along with team meetings both offshore &onshore.
• Internal and external reporting on project risks, issues and mitigation plans
• Supporting Enterprise wide Financial Management and consolidation Application. Technologies involved in this project are HFM, FDM and Financial reporting studio
• Ensure all enquiries / complaints / investigations are resolved within agreed turnaround times
• Maintenance of the necessary control mechanisms and administrations.

TECHNICAL SKILLS:

Reporting Tool: Hyperion Financial Reporting (BI Plus), web analysis, OBIEE, Cognos,Smart View

ERP: Oracle Ebiz, SAP, MXM,MYOB,JDEDWARDS & IFS, People Soft

DBA Tools/Utilities: TOAD, Putty

RDBMS: Oracle 9i,10i, 11g / MS-SQL Server 200

Applications: Hyperion Financial Management, Planning & FDD/FDMEE, DRM, HPCM, FCM, Hyperion CloudFCCS, PBCS

DWH/ETL: Informatica, ODI,Cognos

Operating Systems: Windows 9x,NT, 2000,2003 Server, 2008 Server, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

SBA

Responsibilities:

• Supporting EPMA Applications, Financial Management and consolidation Application. Technologies involved in this project are HFM,FDM/FDMEE, Planning, (PBCS and Public sector) Essbase and Financial reporting studio, DRM
• Installation of Smart View on User machine and also providing support to fix the user issues also Product & Application issues
• Month end Activities of Hyperion applications of Planning, HFM, Essbase
• Maintenance of applications, Servers and also trouble shoot of issues
• Involved and supported in month end process
• Upgraded Hyperion Suite( EPMA) Planning, FDMEE, HFM DRM from 11.1.2.2 to 11.1.2.4
• Created FDMEE Import mappings and load rules to load the data from Source system to Downstream applications
• Requirement gathering for EPMA applications for Cloud Impelementation like PBCS, FCCS &FDMEE
• Created High level documents for implementation for EPM projects on Cloud
• Build the Meta Data and dimensions on Cloud
• Created import mappings and load rules in FDMEE for PBCS &FCCS
• Updating and validation of Hierarchies per business Requirements in DRM
• Created glymphs for account dimensions & developed validations and properties in DRM

Environment: EPMA Appliations: HFM, FDM, & HFR, DRM, Planning( PBCS and Public Sector), Windows, SQL

Confidential, Boston, MA

Senior Consultant

Responsibilities:

• Supporting Enterprise wide Financial Management and consolidation Application. Technologies involved in this project are HFM, FDM and Financial reporting studio. Data flow was from SAP to Hyperion and the consolidations as per GAAP. Implemented, DRM and developed calc rules, business rules for US consumer markets on allocations, Wages, premium, automation Balance sheet and Cash flows

Environment: HFM, FDM, & HFR, DRM. Essbase and PBCS, EBS, SAP, Lawson Group, Smartview

Confidential, Huston, TX

HFM & DRM Consultant

Responsibilities:

• Gather the data from different source systems as well for different Entities and load the data in HFM by using FDQM. Generate the various MIS reports through Hyperion Financial Reports tool to meet the business expectation through Hyperion. And indentified the GAPS and provided the solutions on they reporting deck. Implemented DRM and integrated to downstream systems and made automated jobs

Environment: Hyperion EPMA, DRM, ODI,HFM, Smart View,SQL server 2008, PS, SAP and LGF( LawsonGroup of Financials.

Confidential, Parsippany, NJ

Senior Manager for BI /EPM applications

Responsibilities:

• Implemented EPMA applications like HFM,HPCM, DRM,FCM and Planing( Publc sector and Capex). Planned entire road map to RB for financial support. Involved in operations, Multiple projects like OBIEE, SAP HANA, Informatica, Responsible for all the BI/DWH project in implementation, Project management, Delivery and support
• Driven many Implementation projects and efficient in handling vendor management, Operations, Cost effective methods etc
• EPM, SAP HANA, Share Point Online Approval process, SAP-EHS, BI Tools: Cognos, TM1, ODI, Informatica, OBIEE

Environment: HFM, DRM, FDM, HFR, HPCM, FCM, Cognos Planning, Project management and vendor Management, Cognos Planning, OBIEE, Informatica, ODI, SAP HANA, SAP, EHS and SAP ERP system, Smart View.

Confidential

Project Lead

Responsibilities:

• Supporting Enterprise wide Financial Management and consolidation Application. Technologies involved in thisproject are HFM, FDM and Financial reporting studio, DRM

Environment: Hyperion HFM, FDM, DRM, Oracle, Windows and SAP, Smart View.

Confidential

Support lead

Responsibilities:

• Through Sierra Atlantic,Involved in requirement gathering,to setup of whole Hyperion Setup. Installed and developed Planning and HFM applications. Implemented Cognos planning for Europe territory

Environment: HFM, Planning, Cognos Planning, Informatica

Confidential

Tech Lead

Responsibilities:

• Supported multiple application(BI/DWH). Hyperion
• Incident resolutions, Enhancement, Admin support, Debugging issues, support on Month end process
• Supported multiple application(BI/DWH)
• Had have implemented HFM, involved in creation of application, Meta Data, developing HFR reports, web forms, Consolidation rules etc. Installation of Hyperion and admin support
• Incident resolutions, Enhancement, Admin support, Debugging issues, support on Month end process
• END to END application support

Environment: HFM, HFR, Smart view, FDM, Oracle, Informatica, Cognos, Putty

Confidential

Responsibilities:

• Application performance, Patching, support on user issues, Monitoring Sessions, scheduling jobs etc.
• Creation mappings to transform the data between DWH and Data marts

Environment: Informatica, SQl,PL/SQL Windows

Confidential

Developer

Responsibilities:

• Developed Informatica mappings
• Created sessions, mapplets using designer.
• Provided production support.

Environment: Informatica, Oracle, Windows