SUMMARY

• Over 18 years of IT consulting experience in design, development and implementation.
• Over 12 years of analysis, design and implementation experience in Oracle Hyperion Planning and Essbase.
• Expertise in providing best Hyperion solutions to clients, that includes but not limited to - Project scoping, sizing, requirement gathering, analysis, functional and technical design, development, implementation, test, migrate, troubleshoot, backup/restore, Security architecture, automation, maintenance, upgrade, post-production support.
• Equally expert in function and technical designer roles
• More than twenty Hyperion Planning / Essbase projects for full implementations in roles of technical consultant, Lead consultant, senior architect and Principal consultant
• Worked in Hyperion Essbase (Version 5.0 to 11.1.2.3), BSO, ASO, Calc Scripts, CDF (custom defined functions), Dimension build and Data Load Rules, Hyperion Shared (foundation) Services, Open LDAP, MAXL, ESSCMD, EAS, Application manager, LCM, Smart view, Excel Add-in, EIS, Essbase studio, Financial Reporting, Web Analysis in Windows and Unix.
• Worked in Hyperion Planning (Version 3.3 to 11.1.2.3), EPMA, Workforce Planning, CAPEX, Public Sector, Calc Manager, Business Rules, Web Forms, work flow, map reporting, Outline Load, planning utilities, Hyperion Workspace, HAL, ODI, DRM, FDM, Smart view, etc.
• Expertise in application version upgrade (migrate apps from older versions to new versions), converting applications from other products to Hyperion, process automation and scripting in Windows and UNIX.
• Expertise and hands-on experience in Essbase/Planning configuration, tuning and Optimization in dimension build, data load, indexing, calculations, MDX, cache management, partitions, Shared services, Security, server configuration and tuning, EAS, workspace, EPMA, LCM, Planning web and several low level utilities.
• Developed many Essbase custom defined functions (CDF) to handle client and project’s unique requirements.
• Worked on JavaScript to customize Hyperion Planning web forms
• Created standard ETL adapters to perform planning dimension-build process, delete custom dimension or members, and other many unique functionalities (product do not have these functions).
• Experience working in Essbase Integration Service and Essbase Studio for Drill-thru process.
• Strong scripting skills in Windows, UNIX and with MAXL and ESSCMD for all types of Hyperion process automation and backup.
• Managed PM roles along with Lead consultant role as per project needs
• Prepared and delivered Proof-of-Concepts to different clients including many Fortune 500 companies.
• Experience in create Calc Scripts, Business Rules and reports etc. to help financial facilities.
• Oracle Hyperion Certified planning consultant.
• Oracle Hyperion Certified Essbase Consultant.
• Certified from Microsoft Solution Developer (MCSD)
• Proficiency with Data warehousing skills, ETL tools and techniques (e.g. SSIS, OWB, Data stage, SPSS), utilizing them with Hyperion Essbase
• Over 15 years of working experience with Oracle RDBMS (Ver. 5 to 11), MSSQL, DB2 and various ETL tools
• Worked with Oracle ACE members and directors in Hyperion world and gained valuable experience.
• Worked as Functional and technical expert to prepare and demonstrate POC to help sales and pre-sales teams, or troubleshoot difficult issues for clients.
• Designed and developed various application prototypes, models for Hyperion Sales team, such as Hyperion Public Sector Planning and Budgeting application prototypes, Essbase Log-based usage application, etc.
• Comfortable working with people at different level of management, and with business and technical teams
• Experience, understanding and adhering to Change Management Policies, Internal Controls and SOX compliance
• Good analytical and problem solving skills; understands link between business workflow and technology.
• Worked in Oracle, MSSQL, DB2, MS ACCESS, Oracle DBA; Knowledge in Oracle, SQL, PL/SQL, T-SQL J2ee, VB
• Exposure to various other products such as SAP BI, Net Weaver, FI/CO, MM, COGNOS suite of products

TECHNICAL SKILLS

ESSBASE: (Ver. 5.0 - 11.1.2.3 ) BSO, ASO, MAXL, ESSCMD scripting, MDX, Calc Scripts, Report Scripts, EAS, Load rules, Dimension build Rules, Custom-defined functions (CDF), scripting, Security architecture, ESSBASE studio, and more.

Hyperion Planning: (3.3 - 11.1.2.3 ) Hyperion Classic and EPMA Planning, Workforce Planning, CAPEX, PSB (Public Sector Planning and Budgeting), Calc manager, Business Rules, Workspace, Web Forms, Customized web forms, Outline Load, Security architecture and more.

Other tools: such as, Hyperion Shared Services, LCM, DRM, ODI, FDM, HAL, EIS, Excel Add-In, Smart View, Financial Reports, Web analysis, and many other Hyperion EPM tools

ETL/Data Warehouse Tools: SSIS/SSAS/DTS, SPSS ER, Oracle Warehouse Builder etc

Dimension Modeling: Star and Snowflake, physical and logical data modeling using Erwin 4.0

Relational Databases: Oracle 5.x-11g (SQL, PL/SQL, Procedures, Packages, and many other tools from Oracle) MSSQL (SQL, T-SQL, and many other tools from MSSQL), DB2, MS ACCESS etc

Other scripting: HTML, XML, Visual Basic, C++, Java

Operating Systems: Windows 2003/NT, DOS, UNIX, AS/400

Automation Scripting and tools: Hyperion Scripting / Automation, DOS and Shell (UNIX) Automation scripting, various batch schedulers

PROFESSIONAL EXPERIENCE

Confidential

Lead Hyperion Planning & Essbase Consultant

Environment: Oracle Hyperion Fusion 11.1.2.3 (Planning and Essbase), ODI, MAXL, Smart View, MS Excel, Windows 2008, Sun Solaris (UNIX), Oracle (SQL, PL/SQL, APEX)

Responsibilities:

• Provided innovative solutions for migration of historical data from legacy systems to newly proposed solution
• Built optimal solution to integrate with existing systems that will either provide input e.g. Enhanced Data Collection Solution (EDCS), USER, No Name solutions) to feed fund disbarment to transfer payment authorization system e.g. PFIS-TP (Postsecondary Finance Information System - Transfer Payment) Module using ODI
• Built system screens (forms), task lists, workflow, menu, data access etc
• Conducted unit/integration testing to ensure full coverage of source code and component level testing is in place before handing over the solution to quality assurance analyst.
• Liaised with IT specialists, unit leads and work closely with project team members and relevant stakeholders.
• Participated in conducting feasibility analysis, project scoping and providing project work estimates to effectively manage change requests resulting from requirements elaboration phase
• Participate in joint requirements planning and joint application design sessions to ensure that final solution is built as per client expectations.
• Used ministry mandated requirement tools and templates for documenting system source code.
• Identification and resolution of problems/issues throughout project life cycle
• Proactively identified and proposed remediation strategies for project technology related risks.
• Liaised with other project teams technical resources to coordinate project interdependencies
• Documented of all artifacts in a shared project library utilizing tools in use at CSC
• Conducted and/or participated in walkthroughs at each project milestone.
• Reported status to and followed overall direction from the Project Manager and/or IT Lead.
• Conducted research and provided input into the development of presentations for ministry and cluster staff and executives.
• Provided innovative solutions to any identified limitations of the proposed technologies in meeting any of the business requirements or non-functional requirements related to security, privacy, accessibility, common look and fell and other applicable GO-ITS standards
• Effective knowledge transfer to FAAB and I&IT Cluster at all stages of this project.

Confidential

Lead Hyperion Planning and Essbase Consultant

Environment: Oracle Hyperion Fusion 11.1.2.1 (Planning and Essbase), Oracle Enterprise, EAS, LCM, Workspace, MAXL, Smart View, MS Excel, Windows 2008, Oracle (RDBMS), Oracle Warehouse Builder, Sun Solaris (Unix)

Responsibilities:

• Involved in project scope, project and servers sizing, server architecture, system / application design, development, implementation, test, backup/recovery process, DR setup, security architecture and migration
• Led multiple projects with requirement gathering, design, developments and other project tasks
• Responsible for servers and applications scoping and optimization
• Responsible for providing solution and documentation from every level of project that includes but not limited to above mentioned area.
• Worked on client’s Financial reporting applications, GL summary and KPI related key Hyperion projects.
• Defined process for each yearly Essbase and planning application maintenance
• Delivered overall automation processes such as preparing LCM backup process, Essbase and Planning metadata build, data load, security and application integration related all processes to make admin role easier.
• Prepared automation process to bring data from Oracle GL and stage / load them into Essbase applications with set of codes to audit load and data aggregation results.
• Prepared Hyperion backup process in such a way that can provide an ability to recover all applications and full Hyperion environment (including security) from last backup within couple of hours to support DR needs
• Prepared web forms in order to make them efficient and compact, to fulfill client needs.
• Prepared processes to auto-generate calculations and report scripts to integrate applications for data needs.
• Optimized Essbase and planning applications from source and server side.
• Worked in project management area as per requirements on RAD development model
• Worked on application, process and database optimization, and server configuration where applicable

Confidential, Basking Ridge, NJ

Hyperion Planning and Essbase Consultant

Environment: Oracle Hyperion Fusion 11.1.1.3 - Planning, EPMA, EAS, Workforce, MAXL, MS Excel, Windows 2008, Oracle RDBMS, UNIX (Korn Shell)

Responsibilities:

• Involved in design, development and optimization of Confidential ’s Workforce planning application
• Worked on workforce and payroll side of planning application design
• Customized the application for clients specific needs within planning forms and calculations in areas of employee transfers, new recruitments and resource management
• Import data from planning format dimensions into ADS format in order to load them into EPMA’s outline management role for existing planning applications.
• Removed some unnecessary hierarchies, added required custom dimensions, update forms in order to make them efficient and compact, improve data load and calculation process and remove extra plan types from each planning repository.
• Provided resource management structure with driver-based planning to calculate key business assumptions through models, providing the insight to proactively manage the volatility of future financial performance.
• Designed automation processes - that includes daily/weekly processes (as well as backup scripts) that are essential for a healthy Hyperion system, to provide an ability to recover entire Hyperion environment (including security) from last backup in virtually no time
• Defining process for each yearly / planning module maintenance, and plenty of other automation processes in order to provide LCM backups, EPMA deployment, data load and other processes to make admin role easier
• Worked to optimize dimensions, outlines, database, and configured Essbase server and client sides
• Redefined application dimensionality where applicable
• Worked in project management area as per requirements on iterative development model
• Redesigned one of existing Essbase reporting application - converted it from BSO to ASO to boost application performance and to reduce size significantly. Converted all processes around it (including data extraction/load process)

Confidential, Tampa, FL

Hyperion Planning and Essbase Consultant

Environment: Oracle Hyperion Fusion 11.1.1.3 - Planning, EPMA, EAS, Workforce, Workspace, Web Analysis, Financial Reports, MAXL, MS Excel, Windows 2003/NT, HFM, Oracle RDBMS, Sun Solaris (Unix)

Responsibilities:

• Involved in sessions for architecture, design and migration process for developments and optimization
• Defined process for each yearly / planning module maintenance, and plenty of other automation processes in order to provide LCM backups, EPMA deployment, data load and other processes to make admin role easier
• Redefined user security for entire Hyperion environment to new system
• Implemented numerous automation (that includes daily/weekly process routines as well as backup) scripts.
• Imported data from planning format dimensions into ADS format in order to load them into EPMA’s outline management role for existing planning applications.
• Cleansed planning applications - from Essbase and planning side
• Worked on outline optimization, database optimization, Essbase configuration and cleanse each application’s dimensionality.
• Removed some unnecessary hierarchies, added required custom dimensions, update forms in order to make them efficient and compact, improve data load and calculation process and remove extra plan types from each planning repository.
• Implemented automation scripting using Maestro tool
• Worked in project management area as per requirements on RAD development model
• Prepared sandbox on new server and helped set security modules on that server for virtual environment

Confidential, Roseland, NJ

Lead Hyperion Consultant

Environment: Oracle Hyperion Fusion 11.1.1.3 - Planning Web, Essbase, Workspace, EPMA, Workforce, Web Analysis, Financial Reports, Workspace, MSSQL 2005, SSIS, MAXL, Outline Load, EAS, MS Excel, Windows 2008, HFM

Responsibilities:

• Involved in users sessions, requirement gathering, design sessions, architecture, migration process developments and optimization
• Implemented Hyperion Workforce Planning application to estimate employee hiring, transfers, leaves, payroll expenses and different deductions.
• Migrating HAL routines from Vignette 7.1 to SSIS, (Since HAL is no more and not supported) and using Outline Load utility, loading dimensions into planning applications.
• Set a process to support EPMA for existing planning applications. Prepared automation with ETL (MSSQL and SSIS) to perform required dimension updates etc.
• Migrated five existing planning applications and two Essbase applications
• Performed upgrade / migration of about six hundred financial reports with new data sources for them
• Also took care of PM role as per project requirements in Scrum development model.
• Migrated security for entire Hyperion environment to new system
• Generating scripts that can update/refresh security from MSAD to HSS, HSS to planning/Essbase and Essbase filters to/from planning on nightly basis.
• Implement all automation scripts (for various processes as well as for backup) that are essential for any healthy Hyperion system. Set related planning repository backup scripting on daily basis as well.
• Prepared sandbox on new server and helped set security modules on that server for virtual environment
• Worked in project management area as per requirements on RAD development model
• Set log related application that can explain details of usage, as to explain enterprise wide user activities.

Confidential, Pittsburgh, PA

Lead Hyperion Consultant

Environment: Hyperion 9.3.0.1 - Planning, Workforce, Essbase, FDM 9.3.0, Financial Reports, Web Analysis, Workspace, MAXL, ESSCMD, AAS/ EAS, MS Excel, Windows 2003/NT, Oracle 9i, UNIX

Responsibilities:

• Involved in users sessions, requirement gathering, design sessions, architecture, migration process developments and optimization
• With Planning’s workforce application, implemented company’s important resource management - employees vs. money to estimate employee hiring, transfers, leaves, payroll expenses and different expenses and deductions
• Worked on Confidential ’s global financial planning and forecasting application development that loads data from various routines and sources including another planning (North American planning) and HFM application using automated FDM process (This was to replace current SAP planning/forecasting process.)
• Worked on North American sales application that gets a data feed from SAP and HFM, and is replacing another legacy OutlookSoft application.
• Generated numerous financial reports using FR studio and web analysis for ad hoc analysis purpose
• Implemented security for entire Hyperion environment to these systems and for FDM process
• Implemented all automation (job as well as backup related) scripts that are essential for any healthy Hyperion system, which covers and is able to restore entire Hyperion environment from its last backup including its security in no time.
• Set log related application that can explain details of usage, as to explain enterprise wide user activities.
• Set Shared Services backup and Essbase/Planning/HBR backup with Disaster recovery copy.
• Set Post-refresh process for planning applications and data export processes from planning/Essbase applications to feed into another application.
• Set related planning repository backup scripting on daily basis as well.
• Worked in project management area as per requirements on Prototyping and Scrum development model
• Optimized previous planning application that used to work very slow and generating lots of issues (Brought down few business rules run time from few hours to couple of minutes and full calc time from 6 hours to 10 minutes).

Confidential, Newark, NJ

Hyperion Consultant

Environment: Hyperion 11.1.1.2 (Fusion) suite - Planning, Essbase, Financial Reports, Web Analysis, Workspace, HAL 9.1.2, Legacy systems (Hyperion Planning 4.0, Hyperion Essbase 7.1.2, HAL 7.1 and other Hyperion products of suite), SQL server 2005, MAXL, ESSCMD, AAS/ EAS, SSIS, MS Visual Studio, MS Excel, Windows 2003/NT

Responsibilities:

• I was involved in user sessions, requirement gathering, design sessions, architecture, implementations, migration process, developments and performance optimization.
• Upgraded four financial budget/ forecast planning applications from Planning 4.0 to related Fusion version
• Re-defined and set post-refresh process as required for each planning application
• Performed project management skills as required with Waterfall / Agile methods during development
• Upgraded HAL routines from Vignette 7.1 to 9.2, (which is latest HAL version, and not compatible for Hyperion Fusion version any more), set related run time environment to work on the fly with that version as per user request.
• Upgraded hundreds of financial reports and implemented new data sources for reports.
• Performed security migration for entire Hyperion environment to new system
• Implemented all automation (job as well as backup related) scripts that are essential for any healthy Hyperion system, which covers and is able to restore entire Hyperion environment from its last backup including its security in no time.
• Set related planning repository backup scripting on daily basis as well.
• Set log related application that can explain details of usage, as to explain enterprise wide user activities.

Confidential, Stamford, CT

Lead Hyperion Consultant

Environment: Hyperion Essbase System 9 ( ver.9.3.1),, Hyperion Planning 9.3.1, MAXL, ESSCMD, EAS, EIS, SSAS & SSIS (DTS), MS Visual Studio, MS Excel, Windows 2003/NT, Oracle 10.0.1, UNIX (CSH)

Responsibilities:

• Involved in users sessions, requirement gathering, analysis, design, architecture, developments and optimization
• Performed developments with leading team of four developers as technical and project lead
• Involve in requirements gathering and developing a project plan. Worked directly with business users from Finance users over project plans, functional discussions and project presentations
• User sessions and training over cubes, problem identification vs. solution and documentation.
• Set automation batch scripts for system’s Shared Services, Application backup, Frozen cube’s backups, Essbase system backup and Repository backup.
• Set batch scripts, Scheduling runs through flag using schedulers.
• Prepared Risk weight and comp Balance related calculation within Oracle to reduce allocations burden from Calc scripts.
• Extensively involved in designing and modifying the outlines for Essbase Cubes
• Accompanied duties varied between development of Planning, Management Reporting and Essbase, EIS etc.
• Optimized Rule files, outlines, dim builds, Data loads and Calc scripts applying different techniques
• Generating test scripts, performing unit testing, coordinating user acceptance testing with end users to obtain sign-off, and migrating changes to production
• Extensively used Calc Scripts and ESSCMD/MAXL in automation Scripts
• Developed Calc scripts, data load and dimension build rule files.
• Calculation Script and Business Rule development and quality assurance
• Optimized the applications to bring down the runtime and database size considerably
• Working in development, test and Production with change control, internal controls and SOX compliance
• Working with access and other security layers to provide users their required controls and security management over cubes
• Set batch scripts, Scheduling runs through flag using schedulers.
• Worked in project management role as per project needs in RAD development model
• Designed the automation process comprising of development of batch scripts for cube refresh (dimension building, data loading, calculating cube) using MAXL.

Confidential, Atlanta, GA

Lead Hyperion Consultant

Environment: Hyperion Essbase System 9 ( ver.9.3.1),, Hyperion Planning 9.3.1, Web Analysis, MAXL, ESSCMD, EAS, EIS, HAL, SSIS (DTS), MS Visual Studio, MS Excel, Windows 2003/NT, Lotus Notes.

Responsibilities:

• Involved in users sessions, requirement gathering, analysis, design, architecture, developments and optimization
• Performed developments with leading team of four developers as technical and project lead
• Involved in gathering requirements and developing a project plan
• Worked directly with business users from Finance users over project plans, functional discussions and project presentations
• User sessions and training over cubes, problem identification vs. solution and documentation.
• Extensively involved in designing and modifying the outlines for Essbase Cubes
• Accompanied duties varied between development of Planning, Management Reporting and Essbase, EIS etc.
• Played important role in building Dashboards, EIS panels, and Web Analysis custom views, charts & reports
• Optimized Rule files, outlines, dim builds, Data loads and Calc scripts applying different techniques
• Generating test scripts, performing unit testing, coordinating user acceptance testing with end users to obtain sign-off, and migrating changes to production
• Takes initiative to expand knowledge base and suggests ways to improve business as well as technical processes.
• Extensively used Calc Scripts and ESSCMD/MAXL in automation Scripts
• Users input capability to the applications maintained by Filters for many applications.
• Developed Calc scripts, data load and dimension build rule files.
• Calculation Script and Business Rule development and quality assurance
• Performed data validation checks from the production system to the new Hyperion Planning system data
• Optimized the applications to bring down the runtime and database size considerably
• Upgraded the functionality of the client’s Hyperion Planning application
• Recreated the application, Web-input forms, and user task lists
• Broke one dimension out into three separate dimensions to reduced inter-dimensional irrelevance
• Worked in development, test and Production with change control, internal controls and SOX compliance
• Worked with access and other security layers to provide users their required controls and security management over cubes
• Worked in project management role as per project needs in RAD development model
• Set batch scripts, Scheduling runs through flag using schedulers.
• Designed the automation process comprising of development of batch scripts for cube refresh (dimension building, data loading, calculating cube) using MAXL.