SUMMARY:

• Hyperion Hands - on SME expert at Enterprise Performance Management practice, primarily focusing on leading Hyperion implementations
• 11+ Hyperion consulting experience with proficiency in all areas of the systems life cycle from business analysis through implementation and production support
• Developed and implemented 6 full life cycle Planning solutions for budgeting, forecasting and reporting leveraging process and system best practices. Involved with more than 12 clients in implementing Hyperion at various stages
• Proficient in project management and proven track in leading Hyperion team and implementations
• Experience with designing and implementing in Oracle/Hyperion System 11 HFM,BI+ Essbase Analytics (BSO and ASO), Oracle/Hyperion System 11 Planning, Workforce Planning, Capex Planning, HFM, ODI, FDM, DRM,Cognos EP,OBIEEOracle/Hyperion System 11 BI+ Financial Reporting, and Oracle/Hyperion System 9 Web Analysis
• Specializes in HFM/Planning/Essbasedesign, development, and significant skills with the tuning and optimization of Planning and Essbase models. Knowledge about infrastructure and relational database such as oracle and SQL
• Experience in successfully leading team at various client and meeting deadline and deliverable

DETAILED EXPERIENCE:

Confidential, NJ

Responsibilities:

• Delivered on roadmap initiatives by creating efficiencies which includes streamlining of data in a simplified data integration environment.
• Responsible for all the migrations from HFM on-prem application to FCCS cloud.
• Administered WebLogic for Planning application in Linux.
• Worked as an admin maintained usersecutiry, back up’s etc and restored applications from backups and created start/stop scripts.
• Worked as a Hyperion planning and HFM administrator to support the users during budgeting and forecasting and consolidation cycles
• Contributed in assessment phase in drafting current and future state process flows and heavily involved in documentations
• Led data interface meeting with IT and architecture data and metadata movement between various data management systems such as ODI,EDW, HFM and DRM

Confidential, Dearborn, MI

Responsibilities:

• Led design sessions and workshops with various stake holders to gather requirements and understating their current model and reporting needs
• Delivered on COBRA and CFRS roadmap initiatives by creating efficiencies which includes streamlining of data in a simplified data integration environment and lead the upgrade process in unix and administered them by creating desk-procedures.
• Deployed as a technical lead to assist the business on re-engineering the L-2 and L-3 support process and all CR related process.
• Collaborated with business partners in drafting the BRD, FRD and TDD for implementing standard migration and support process.
• Led data interface meeting with IT and architecture data and metadata movement between various data management systems such as ODI,EDW, HFM and DRM
• Provide weekly status updates and project progress to PMO team

Confidential

Responsibilities:

• Led technical design sessions along with functional team to gathered requirements
• Architect whole design and created Technical design document which included HFM security and HFM Rules
• Worked close with PMO team in coordinating activities such as: project timelines, project planning, status reporting, meeting coordination, budget management and PMO updates
• Led weekly technical meetings with client in providing project update and maintaining status tracker and issues logs
• Helped in documenting UAT scripts and trained the trainer to help facilitate users training

Confidential

Responsibilities:

• Led client meetings with senior stakeholders to assess current restatements and historical reporting need
• Reviewed multiple client reports in detail as they relate to Actuals Executive Reporting from HFM
• Documented various options to meet historical reporting needs and architect viable solution to help with restatement archiving and reporting
• Worked with IT team in understanding reporting needs and discussed potential options and roadmap to meet monthly restatement business needs by updating new FDM mappings to load into HFM applications
• Involved in creating dataflow in DRM, responsible for troubleshooting and validation for data mapping
• Developed Script code for Import the data from Source Database and mapping it into DRM temporary table using custom table
• Created DRM imports and Exports for Metadata changes.
• Identified improvement opportunities to be addressed in order to reach the desired future state
• Worked directly under CFO and interviewed SME’s and technical team to understand current reporting needs and current data load process
• Redesigned current Essbase application and documented future state process for the enhancements and brought consolidation timing to less than 2 minutes and implemented EAL (Essbase Analytical Link) for the data transfer between Essbase and HFM application
• Discussed potential options to enhance hourly data load with CFO and HFM consolidation process

Confidential, Georgetown, DC

Responsibilities:

• Led strategic work stream implementation and instrumental in FP&A planning
• Led meeting with financial team in gathering requirements and assessing current state process
• Involved in documenting process flows and documenting future state road map for Ford motors planning process. Created project plan and worked closely with my director in managing it throughout the life cycle of the project
• Led team of 3 technical resources and coached non-technical members about technology used in bringing them up to speed
• Was responsible in building text input planning which is unique to Hyperion and helped in building FP&A application to meet P&L, Capex and Workforce application
• Led UTA and admin training and helped in documenting users guide and admin guide
• Provided weekly update to project director and PMO about project status, Project budget and build status and helped communicating to the client for any issues

Confidential, NYC

Responsibilities:

• Developed Versions for implementation of three subscribing systems in Master Data Management (MDM 9.3)
• Created different System Categories and Property Categories for those subscribing system (HFM, HP, and Essbase)
• Created three node type glyphs, one each for HFM, HP, and Essbase
• Created different node types and numerous properties (Defined, Derived, RWDerived, and Lookup) for dimension building in HFM, HP, and Essbase
• Created property queries to export stored and alternate dimension hierarchies
• Developed hierarchy export processes and group them into books to ease up the dimension export process
• Developed and maintained financial package canned reports in Hyperion Financial Reporting
• Back and restore/migrated reports from dev to prod and vice versa
• Created custom defined list to select desired multiple members at a time
• Extensively used different Hyperion Analyzer objects for dashboard building: combo box, services button, slider mechanism, radio button, image, text, etc
• Developed numerous dashboards for higher management team using Hyperion Web Analysis
• Involved extensively in users training and process documentation

Confidential, Stamford, CT

Responsibilities:

• Responsible for gathering financial requirements form the finance team
• Successfully build and implement 120 reporting requirements in Financial Reporting Studio
• Conducted user’s acceptance training and worked with finance group to resolve issues with reporting functionality