SUMMARY:

20+ years abundant Technical and Functional experience in Computer Science and 12+ years’ experience as Architect, Design, Analysis, Team Lead, Administrator and developer on a various Financial Applications e.g. Hyperion Essbase, Planning, web analysis, Financial Reporting, Financial Management, MS - Office Smart view and Add-in CATS, JDA, Moneta, and OBIEE. Strong knowledge and experience in budgeting, forecasting, planning, and reporting software development life cycle and full life cycle management and building budgeting and forecasting OLAP application with Hyperion classic/public sector planning, Essbase, Financial Management, ad-hoc reports, smart view, and spreadsheet Add-In and end to end Hyperion installation/configuration and implementations from single to multi-tier and experience restructuring, modifying and building new/existing outline, dimensions, members and their properties like dense, sparse, index files, data file, data cache, allocations, dynamic calculations, report and ESSCM and Maxl scripts, ASO/BSO data cube and loading data manually and dynamically using rule file and experience developing and administrating in Oracle ETL (Extract Transfer Load) tools e.g. DRM, ODI, FDQM/FDM, MDM, FDMEE to define meta data value mapping, validating rules and data loading. Administrator, development and troubleshooting knowledge and experience Hyperion Essbase, Planning, HFM, FR Studio, Workspace, Shared services, EPMA, OBIEE, database backups, optimization cubes and performance tuning and proven ability to consistently and repetitively update Hyperion to newest release and effective team player and an individual contributor with steep learning curve

TECHNICAL SKILLS:

Development Languages: Technologies/OLAP ToolsReporting Tools C, C++, Core Java, Batch Scripting, Maxl, MDX, ESSCMD, VB OLAP, Hyperion Essbase, Planning, PSPB, HFM, Workspace, FR Studio, EPMA, Shared Services, version6.x/9.x/11.1.x, CATS Hyperion Smart View, Spreadsheet Add-in, Hyperion Web Analysis, OBIEE, Financial Reporting, Interactive Reporting, Moneta

Web/Application Servers: WebLogic 7.0/8.1, Tomcat 4.x, WebSphere, Microsoft Web Server

Web Presentation: JSP, Servlet, JavaScript, HTML, DHTML, CSS, XML, XSLT

Operating Systems: Windows 98/XP, Windows NT 4.0, Windows 2000/2003/2008 and Linux, Unix, Solaris

Databases: Oracle 8i/9i/10g, MySQL, MS Access, EBS/ERP, PeopleSoft, Exalytics, SQL Server 2005 and 2012

PROFESSIONAL EXPERIENCE:

Business Systems Analyst Consultant

Confidential, New York, NY

Senior Hyperion Business Analyst Consultant

Confidential, Atlanta, GA

Administrator/Developer/Analyst

Confidential, Rockville, MD

Hyperion Essbase & Planning Lead Consultant

Confidential, San Diego, CA

Hyperion Essbase Administrator

Confidential, Glencoe, IL

Senior Windows System Administrator

Confidential

Intermediate Windows System Administrator

Confidential

Junior Windows Computer System Administrator

Confidential

Responsibilities:

• Liaison between IT, Finance and Oracle team to make sure each team member understand their technical and functional needs, and completing their daily and weekly task and Load revenue and expense data using FDMEE /FDQMEE from Oracle 11i /R12 to PSPB application
• Involve with Oracle and IT in the upgrading the Hyperion PSPB, ERPI Integrator, ODI, Essbase version from 11.1.2.2.x- 11.1.2.4, or to most latest version to make sure the Hyperion components are working as per clients need by performing detailed post system upgrade analysis.
• Closely working and involve with companywide ERP /E-Business R12 project and suggesting best practice methods per customer needs related to Hyperion and R12 integration steps for both GL and HR data and metadata using ODI physical, logical, context and FDMEE source and target system connection setup and metadata and data load rules and assisting business to create budget balancing process in automated and optimized way as customer being using manual process
• Co-ordinate with Budget and Capital Finance team to understand their requirements and make sure that requirements are doable in IT with various way and suggest best practice methods to IT
• Design, develop and test monthly budget and capital finance and TBH’s reports. Suggested and added data validation rule in Hyperion Web Forms to validate data and conducting business users’ training sessions and attending daily or weekly bases meeting in Finance department with Oracle Cloud Management Team
• Participate in the design of new financial reports and future systems implementation (e.g. New Chart of accounts, revenue sub-ledger) and align systems with reporting and accounting and Provides functional advice by studying operational issues, applying financial principles and practices, developing recommendations by developing sample project templates
• Designing multidimensional Hyperion Essbase ASO and BSO applications and databases, dimensions, loading data using various recommended methods i.e. data load rule files, OLU, Smart View, ETL/ELT (ODI/FDMEE, DRM, Essbase Studio) tools, calculation and aggregation techniques after carefully analyzing customer requirements. Working and administrating with Hyperion Production and Development Linux /Solaris environment
• Writing both MDX and Maxl scripts and integrated with our source system with target and writing complex batch and cmd scripts and nightly job scheduling using windows task manager and implementing complex security requirements and automating Hyperion Essbase application’s cube build process using Maxl and batch and cmd scripts and Handled ad-hoc data and information requests
• Developing repots in OBIEE and Hyperion Financial Reporting and administrating to make cure tool is fully functional per customer satisfaction and providing design recommendations based on long-term IT organization strategy on calculation scripts, business rules, employee and position data forms
• Working with SQL query and writing complex SQL query to meet customer needs and exporting data and metadata from Teradata source system and importing to DRM and Hyperion Source system and administrating Exalytics BI server and developing and managing OBIEE and Hyperion Essbase products on that server to make sure that product working up to 99.9999 per customer satisfaction
• Developing and administrating enterprise level ASO application for reporting purpose and custom integration solution including major enhancements i.e. updating and developing custom business rules per business needs, adding variance scenarios in dimension, working with member formulas, interfaces, functions, and features
• Interacting with business /financial customer to gather business requirements and working with DRM which integrated with Hyperion, Teradata and EDW and creating metadata mapping with source to target system
• Determining specification, the plans, designs and developing the most complex and business critical software solutions, utilizing appropriate software engineering process either individually or in the concern with project team and producing software that solve business problems and /or creates new business capabilities researches and maintains knowledge in emerging technologies and possible application to the business
• Working with Microsoft Visual Studio to develop new cubes by defining new projects, data sources, cubes, dimensions and extracting data from EDW Teradata System to import into Microsoft SQL Server by creating tables, views to generate customer based reports
• Developed and administrated enterprise level Hyperion Planning PSPB “Public Sector Planning and Budgeting” ASO and BSO application for financial budgeting, forecasting and reporting purpose and custom integration solution including major enhancements i.e. updating and developing custom business rules per business needs, adding variance scenarios in dimension, working with member formulas, interfaces, functions, and features
• Determined specification, the Hyperion Planning PSPB “Public Sector Planning and Budgeting” application plans, designs and developing the most complex and business critical software solutions
• Broke down Hyperion Planning PSPB “Public Sector Planning and Budgeting” Application business problems and capabilities into projects, platforms, frameworks, applications and services
• Configured both Hyperion Planning PSPB “Public Sector Planning and Budgeting” Application Compensation by defining Entity dimension and members, user defined dimensions and members, adding /modifying Smart List, Segment, Chart Fields members to the HCP Plan type and Line Item budget by linking HCP Compensation Data to Plan Type 1, 2, 3
• Export GL data from DELTEK system and Hyperion Planning PSPB “Public Sector Planning and Budgeting” Application’s HCP “Human Capital Planning” data from PeopleSoft and load into Hyperion Planning PSPB “Public Sector Planning and Budgeting” application for budgeting and forecasting purpose and synchronized both Hyperion Planning PSPB “Public Sector Planning and Budgeting” DEV and TEST environment with prod on routine basis
• Worked, developed and administrated PSPB Application’s FR (Financial Reports) using Hyperion FR studio and update existing reports after reviewing and understanding business needs
• Integrated Hyperion PSPB system with source PeopleSoft system’s GL, HRMs and Financial and Commitment Control using FDMEE tool after carefully analyzing and completing PeopleSoft, PSPB and FDMEE initial integration steps requirements
• Developed Hyperion Planning PSPB “Public Sector Planning and Budgeting” basic budget process PSPB Plan types and configured Employee, Position, Jobs, FTE, Headcount, Overtime and Vacancy Calculation, worked with Short/Long-Term Leave, Overtime, Headcount, Vacant Positions, Shared Positions, Pooled Positions, Incumbent Positions, Compensation Funding Across Departments, and Additional Earnings
• Developed /performed appropriate changes and added required information in Element, Budget Item, Entity, Account, Currency, Predefined accounts and user defend dimensions and worked and developed Salary, Compensation and Allocation and Human Capital Compensation Budgets
• Developed Smart Lists, Task Lists, Web-Data Forms and assigned provisions per given directions
• Conducted series of BR “Business Requirements” JAD “Joint, Activity and Discussions” sessions with 8 districts business finance users and understood the business needs for budget preparation in Hyperion Essbase and Planning and developed Financial Reports for each district using Hyperion Financial Reporting Studio
• Configured, administered, Monitored, Documented, Analyzed, and troubleshot the PeopleSoft and Oracle Hyperion Planning PSPB “Public Sector Planning and Budgeting” integration and architecture including software, servers, databases, and related third party tools
• Worked with business users on understanding and analyzing business problems and process by conducting series of join application decision (JAD) sessions
• Worked with business users and define/execute Hyperion Planning PSPB “Public Sector Planning and Budgeting” Application business processes and procedures, training, and documentation, dimensions, metadata, business rules, calc scripts, calc script customizations, Essbase application components, Smartview, Data forms, Web Forms, Task Lists, Hyperion security, data conversion, identifying alternate hierarchies, loading source data into Hyperion
• Configured and developed newly Hyperion Planning PSPB “Public Sector Planning and Budgeting” applications for each district per given directions and JAD discussion with customer
• Created and developed Hyperion Planning PSPB “Public Sector Planning and Budgeting” Application Task Lists per district requirement, required dimensions, custom business rules, custom forms, and assigning security to users for dimensions and business rules
• Worked and configured with Hyperion Planning PSPB “Public Sector Planning and Budgeting” Application HCP budget administration like manage salary grades, compensation elements, HR data, position and employee data, copying scenario and version and scenario version and year
• Configured and worked with Hyperion Planning PSPB “Public Sector Planning and Budgeting” Application HCP budget preparation task list like compensation defaults, working days and pay days, employee information, compensation and benefits, position and employee data, calculating compensation budgets and allocating compensation to GL accounts and also worked with TBH’s (To be Hired)
• Configured both Hyperion Planning PSPB “Public Sector Planning and Budgeting” Application Compensation by defining Entity dimension and members, user defined dimensions and members, adding /modifying Smart List, Segment, Chart Fields members to the HCP Plan type and Line Item budget by linking HCP Compensation Data to Plan Type 1, 2, 3
• Performed PSPB Application patch analysis on middleware components and provide engineering guidance and recommendations for implementation by the operations staff
• Assessed Client’s current Oracle solutions/services platform, defining long-term support requirements, and updating technology roadmap
• Developed custom PSPB Application Business rules for Financial and HCP data per given business requirements
• Delivered high-quality solutions and working with team to identify and resolve software defects and provide bug fixes related to Hyperion suite of products; Document design and results, and follow change management procedures
• Created user groups and user in Shared Services and assign provisions suing shared services according to user and county and district needs for Hyperion PSBP “Public Sector Budgeting and Planning” applications, dimensions, web forms, task lists, smart lists. Performed and developed menu, smart list, data forms and LCM migrations from source systems to new systems i.e. migration from Development to Test, Test to Production environment
• Configured .ORA file to make sure ODI “Oracle Data Integrator” working fine with during FDMEE integration process from source PeopleSoft to target PSPB application
• Led and directs Hyperion technical team on Hyperion artifacts migration process from one environment to another and continuing support in maintenance and enhancement of the current Hyperion Essbase and Planning system that were built around Oracle EBS foundation, future planning and standard development and administration practices and co-ordinates systems analysis and application development and administration
• Worked with Hyperion base and specific dimensions to Hyperion Financial Management i.e. Value Dimension, Intercompany and Custom dimensions and User Defined Elements.
• Maintained and created new Hyperion Financial Management (HFM) application profile and application by defining preferred language, calendar, period, currencies and custom dimension
• Performed testing to newly HFM created application, HFM System and Cluster testing and ETL tool integration testing to make sure all HFM system’s components are tied with each other and working per client expectation
• Loaded metadata by defining accounts, entity, scenario dimension members and organized period in HFM. Defined HFM Consolidation POWN and POWNMIN consolidation mentions and assigned manually HFM consolidation methods
• Loaded data in HFM application using various tools i.e. using smart view, HFM data forms, FDQM /FDM ETL tool and performed HFM data validation between source system data and HFM loaded data to make sure all numbers tied out per client expectation
• Set-up intercompany partners by editing system generated ICP and value members. Worked with metadata file of the APP format and metadata manage view and managed HFM member list by creating EnumMemberList, EnumMembersInList, Dynamic Member List and Dynamic POV member list in HFM
• Managed HFM Journals by defining File Format, Version, Journal Group, Standard, Recurring, Header Sections and data forms, extracting data to database, defining reports, rules, functions, HFM calculations, Intercompany Transactions, HFM process management submission phases
• Assisted and leading to create currency conversion application and @XREF rule for mapping data from one plan type to another and calculation scripts EAS, business rules in calc manger and testing script in UAT/QA system using sample data in smart view
• Design, developed/updated, administrated and optimized both new/existing Essbase ASO/BSO and Planning (Classic/Workforce) applications’ cubes, artifacts, calculation/report scripts business rule, data forms, smart list, FR/interactive/dash board/web analysis and OBIEE reports, DRM, FDQM for business users and the next year budgeting and forecasting cycle and performed application/cube’s maintenance to troubleshoot performance issue as suggested by Oracle and per business expectations
• Designed, installed and configured Hyperion Essbase, Planning, Workspace, Calc Manager, EPMA, and Shared Services on multi-tier systems and created both classic and EPMA applications in Hyperon planning with attributed dimension and loaded data values from EAS export import utility using batch procedure
• Administered, created, modified and migrated Essbase.cfg file, batch and shell scripts, calculation/report scripts, member formulas, data consolidations, migrated outlines, data cubes, data load rule, EPMA application infrastructure to newly created Development Environment/applications and cubes using LCM (Life Cycle Management) and optimizing business logic
• Configured both Compensation by defining Entity dimension and members, user defined dimensions and members, adding /modifying Smart List, Segment, Chart Fields members to the HCP Plan type and Line Item budget by linking HCP Compensation Data to Workforce Planning application
• Worked with Hyperion base and specific dimensions to Hyperion Financial Management i.e. Value Dimension, Intercompany and Custom dimensions and User Defined Elements.
• Maintained Hyperion Financial Management (HFM) application profile and Performed testing to newly HFM created application, HFM System and Cluster testing and ETL tool integration testing to make sure all HFM system’s components are tied with each other and working per client expectation
• Loaded metadata by defining accounts, entity, scenario dimension members and organized period in HFM. Defined HFM Consolidation POWN and POWNMIN consolidation mentions and assigned manually HFM consolidation methods
• Loaded data in HFM application using various tools i.e. using smart view, HFM data forms, FDQM /FDM ETL tool and performed HFM data validation between source system data and HFM loaded data to make sure all numbers tied out per client expectation
• Set-up intercompany partners by editing system generated ICP and value members. Worked with metadata file of the APP format and metadata manage view and managed HFM member list by creating EnumMemberList, EnumMembersInList, Dynamic Member List and Dynamic POV member list in HFM. Managed HFM Journals by defining File Format, Version, Journal Group, Stander, Recurring, Header Sections and data forms
• Attended weekly based meetings with management and IT personals to discuss current status of the project, issues, solutions, and short and long term goals and identified risks as associated with both system and business changes and understand the correct information about their business and usage of Hyperion Product to give best both Hyperion developer and administrator support
• Created, modified and maintained attribute dimension for employee dimension and to resolve Hyperion registry values in workspace and optimized Essbase outline, calculation, defragmentation of cube data and analyzing data using EAS prep editor and also Excel Add-In
• Provided assistance to end users relating to technical Hyperion issues and created both high and detailed level document for each process with brief description
• Translated business logic and processes into calculation scripts, member consolidations and formulas applied to the Essbase cube and designed and created both Essbase and Planning applications as per given requirements
• Participated in designing and developing database, interface application modules and provided support performing database administrative tasks on various operating systems i.e. Windows and Unix
• Designed and developed web pages using Visual Basic, HTML, C, and Java Scripts to automate the nationwide change Management system
• Highly motivated. Operates with minimum supervision and works well in a Team Environment and Excellent written and verbal communication skills. Not only, very comfortable in presenting complex ideas to various groups including Executive Management but Strong Work Ethic and excels and enjoys working in a fast-paced, multi-tasked and high-pressure environment also

Environment: Hyperion (Essbase, PSPB “Public Sector Planning and Budgeting, EPMA, HFM, Financial Reporting Studio, OBIEE Shared Services, Web Analysis, Workspace, DRM, ERPI Integrator,FDQMEE /FDMEE, ODI, HAL, Smart view, Excel Add-In, ESSCMD, OLU Scripting, CalcMgr, Maxl, MDX) virions 9.x to 11.1.x, Unix/Windows Server 2005, 2008 & 2012, Solaris, ERP/EBS Suite, R12, PeopleSoft, DelTek, Oracle 10g, SQL Database 2005,2008 & 2012, UPK, Oracle 8i/10g, MS-Visio, MS-Project, Windows Server 2003 R2 and 2008 Enterprise Edition, Visual Basic and MS-Excel, MS Access, MS Outlook, SQL Forms 3.0, PL/SQL, HTML/XHTML, DHTML, MS-Front Page, Java Script, Adobe Photoshop 7.0.1, Macromedia Flash MX Pro, Macromedia Dreamweaver, Microsoft Windows 2000/NT/XP