PROFESSIONAL SUMMARY:

• Over 15 years of experience in Financial Analysis, Business Analysis, online analytical applications (OLAP), ETL, Requirements Gathering, Development, Testing and Database Administration of Data Warehousing and Client/Server projects using industry accepted methodologies and procedures.
• Managed and Lead the full life - cycle implementation of a leading budgeting/planning, forecasting & analysis systems from design, development, implementation, administration, ongoing maintenance and production support.
• Hands on experience Developing and Supporting Financial Planning, Consolidation, Close Management and Reconciliation processes using EPM, HFM, FCM and ARM products.
• Hands on experience with Master Data analysis, Master Data Management, Systems Integration, conduct fit/gap analysis due to Master Data changes.
• Hands on experience with implementing Hyperion Enterprise Performance Suite 11.x, EPBCS, PBCS, ARCS, HFM, Hyperion Planning, Hyperion Integration Services, Hyperion Reports, Hyperion Analyzer, Excel/VBA, Essbase Studio and FCM tools.
• Strong experience as Essbase Calculation Scripting, Essbase Cube Analysis & Design, Essbase database administration and performed up gradations, Maintenance, database backups, Performance tuning, Optimization, Dense/Sparse settings, partitioning, etc.
• Developed overall Architecture, Star Schema, Data Model, and Hands on design and development of Extract Transform & Load (ETL) and OLAP Reports.
• Proficient with ETL Tools - Oracle Data Integrator, FDM, FDMEE, Informatica PowerMart v 6.1& Power Center v6.1, Custom SQL’s for Data mart building and Data warehousing.
• Familiar with Oracle Applications GL, AP, AR and Fixed Assets Modules and Sarbanes Oxley Compliance.
• Strong understanding of best practice deployment of information systems in a fast paced business environment, data integrity issues, Data Analysis, Data Acquisition.
• Strong experience in all phases of testing including defining user acceptance criteria, developing plans/scripts, documenting expected results, execution of scripts, validating actual results.
• Experienced in managing the project plan, coordinating resources, change control process, governance, ensuring project documentation, status reporting, issues management, troubleshooting and inspections.
• Experienced in knowledge transfer, preparing the required documentation, the clients.
• Posse’s excellent analytical, logical, communication skills, familiar with the SDLC methodology of system development.
• Hyperion Certified and Sun Java Certified Professional.

TECHNICAL SKILLS:

OLAP: EPBCS, ARCS, FCCS, Hyperion Enterprise Performance Suite 11.x, Hyperion DRM 11.x, Hyperion System 9+, Hyperion Essbase5.1, 6.5 & 7.x, Hyperion Analyzer, Hyperion Reports2.x, 3.x & 7.2, Hyperion Planning 3.x & 4.0, Hyperion Financial Management suite 2.2, 3.x, 11.x,, HAL, Hyperion SQL Interface, EIS, Cognos PowerPlay, Cognos Impromptu/IWR Reporting tools, Business Objects, Crystal Reports, Crystal Enterprise and Crystal Analysis.

Operating Systems: Windows NT 4.0, Linux, UNIX, and Solaris.

ETL Tools: Oracle Data Integrator, EIS, Informatica.

Databases: Oracle, DB2, Microsoft SQL Server, MS Access 97.

Application/Web Servers: Web Logic, Apache web server, Microsoft IIS4.0

Languages: Java, C++, C, VB and PL/SQL.

Tools: & Technologies ADO/OLEDB, ActiveX, IIS 4.0, MTS2.0, JDBC, Servlets, JSP, EJB.

Scripting Languages: Java Script, VB scripts

Markup Languages: HTML 4.0, DHTML, XML, XSL

Project Management Tools: MS Project 2000, Microsoft Visio 2000

PROFESSIONAL ENGAGEMENT:

Confidential, San Jose, CA

Sr. IT BSA/Developer/Architect

Responsibilities:

• Responsible to understand complex business problems and architect solutions in Hyperion, Oracle EPM Cloud and related technologies and an IT owner/ Project Manager of the Hyperion applications (Planning and FCM) landscape.
• Responsible to manage and lead design, development, testing, build, migration and support of Hyperion projects using industry accepted methodologies.
• Implemented EPM 11.1.2.4.210 and Upgraded Hyperion EPM environment from 11.1.2.3. .1.2.4.250 to improve the performance and implemented new features.
• Implemented EPBCS (Financial Planning, Workforce Planning, Capex Planning, and Custom Planning) to enhance Financial Planning and Reporting.
• Created batch scripts and automated the data and metadata loading using EPM Automate utility into EPBCS Cloud Planning application.
• Created Data Maps and Smart Push Jobs to sync up data between the different databases in EPBCS Planning application.
• Created Groovy scripts to optimize the business rules, to validate the data in the web forms and to improve the end-user performance.
• Implementing EARCS module and migrating the on-Prem ARM Reconciliation process into Oracle EPM EARCS Cloud.
• Updated the Data Load Rules, Data Load Mappings, Import Formats in FDMEE to load the data and metadata from Oracle R12.
• Migrated all the required FDM 11.1.2.x metadata artifacts to FDMEE 11.1.2.4.x and developed optimized data integration in FDMEE application.
• Developed data integration processes between Oracle and non-Oracle source systems and Oracle Enterprise Performance Management target systems utilizing Oracle FDMEE.
• Work with FP&A and regional finance teams and accounting teams to understand their issues and requirements and converted the requirements into system design and take it all the way to implementation.
• Developed Essbase BSO Financial Plan and Qtrly Commit Revenue and Weekly PL Planning applications as part of Value Chain Planning Project and developed P&L, Workforce and Capex modules.
• Developed ODI interfaces to map and integrate Hyperion data into EDW for Executive Dashboard Reports using OBIEE and Tableau.
• Working on multiple new initiatives, reengineering existing processes and architecting a new model to implement an enterprise scalable solution for Value Chain Planning and Forecasting.
• Developed the ODI packages, Calculation scripts, Business rules, MAXL scripts, MDX Scripts, Load Rules and Batch scripts to perform Annual Planning, Quarterly commit and Monthly forecasting in parallel.
• Responsible to make sure Hyperion systems follow SOX controls, IT change management processes and data governance processes.
• Responsible to partner and collaborate with other IT apps team, database administrators and business users to provide business solutions.
• Responsible to perform Fit gap analysis, Impact analysis, Business Process Mapping, Data/Information flows, Project Roadmaps, Key Metrics/KPIs to the Senior management.
• Responsible for day to day maintenance, production support, ongoing improvements to finance-related processes to ensure accuracy and integrity of planning, forecasting and financial reporting data.

Environment: EPBCS, Oracle Hyperion EPM 11.1.2.4.x, Oracle Hyperion EPM 11.1.2.1.x, Essbase, Essbase Studio, Planning, FCM, ARM, Smart View 11.1.x, Oracle Data Integrator (ODI), FDM, ERPI, FDMEE, OBIEE, SAP BO, Tableau, Oracle 11i, Oracle R12, Linux and Windows NT 4.0

Confidential, Redwood City, CA

Sr. Hyperion Engineer/Architect

Responsibilities:

• Responsible to provide architectural leadership and manage all phases of Hyperion EPM projects lifecycle including requirements, design, development, implementation, unit-testing, migration, administration, support and user- as required.
• Designed and developed Essbase ASO and BSO applications for Revenue and Expense planning and analysis with drill-through details to EBS and data warehouse.
• Built and maintained SQL views and tables, ODI staging, ERPI staging, EPMA staging in oracle database to integrate the metadata changes from source systems into Hyperion EPM Applications.
• Designed and developed FDM data integration process to enable drill-through details for Actual data from Oracle EBIZ and OBIEE Data Source.
• Worked with internal customers to consistently improve and refine process and procedures as it relates to data sourcing, staging, integration and processing within the Hyperion architecture.
• Supported the quarterly forecast and annual budget processes along with the monthly close process and weekly outlook processes.
• Responsible for Development, Maintenance and Support of P&L, Financials, Capex, Workforce and revenue Hyperion planning modules.
• Developed Business Rules/Calculation scripts and load rules required for Revenue, Expenses, Workforce and Capital Forecasting/Planning and Actuals data consolidation.
• Developed Essbase MaxL scripts and Batch scripts for automating and integrating data loads process.
• Designed & Developed ODI Interfaces/Packages to integrate the daily data loads and Master data updates form Oracle EBS into Hyperion and Planning/Forecast data into OBIEE for Variance Analysis.
• Ensure Hyperion platform update follows SOX guidelines, compliance and change control process to resolve DEV/TST/PRD issues in a timely manner.
• Responsible for and educating business users in effectively using the Hyperion client tools (Hyperion Financial reports, Smart view and Essbase Excel Add-in).

Environment: Oracle Hyperion EPM 11.1.x, Essbase, Essbase Studio, Planning, FCM, ARM, Smart View 11.1.x, Essbase Excel Add-in, Oracle Data Integrator (ODI), FDM, ERPI, FDMEE, OBIEE, Oracle 11i, Teradata, Linux and Windows NT 4.0

Confidential, San Francisco, CA

Sr. IT BSA/Oracle Hyperion EPM Developer

Responsibilities:

• Responsible for managing and leading the Hyperion EPM projects from discovery through deployment, enhancements, changes, upgrades.
• Responsible for Development, Maintenance and Support Hyperion Planning/Budgeting, Workforce and Capital Asset planning systems using IT SDLC methodology.
• Developed CRP Financial Consolidation Application for consolidation and reporting of Local and Consolidated set of books, uploading the Adjustment Journals, Intercompany eliminations and Currency Translations.
• Created HFM Application Profile to facilitate and simplify EMEA and APAC accounting team to close their local ledgers and corporate accounting team to consolidate and produce the financial statements.
• Analyzed the current Close process tasks, Intercompany transaction processes, accounts reconciliation process and reports in oracle EBS and created task lists to stream line in HFM.
• Created metadata files and load rules to build the HFM application dimensions.
• Created consolidation rules, data forms and data grids required to input the intercompany data and intercompany transaction details report.
• Developed Business Rules/Calculation scripts and load rules required for Workforce and Capital Forecasting/Planning and Actuals data consolidation.
• Developed Essbase MaxL scripts and Shell scripts for automating data loads and daily backup and restore processes.
• Responsible for FP&A process and supporting core finance processes QTC, P2P, issue to resolution and financial reporting.
• Designed & Developed ODI Interfaces/Packages to integrate the daily data loads and dimension updates form Oracle EBS into Hyperion and Planning/Forecast data into OBIEE for Variance Analysis.
• Responsible for infrastructure development and administration of the Oracle Hyperion EPM environment from an IT perspective and also worked with Oracle Tech Support to drive resolution of product defects.
• Designed and developed Variance Analysis Reports, Reconciliation reports, Headcount reports, Capital expense reports, Balance Sheet Reports, etc. using Hyperion Financial Reports.
• Designed and developed detailed Headcount reports and Expense reports using the Hyperion Planning as the data source to provide complete details input by the analysts as supporting details, etc.
• Designed and developed the integrated Variance Analysis workbooks for Forecast review against Actuals using Smart view and Essbase Excel Add-in.
• Responsible for and educating business users in effectively using the Hyperion client tools (Hyperion Financial reports, Smart view and Essbase Excel Add-in).

Environment: Oracle Hyperion EPM 11.1.x, Smart View 11.1.x, Essbase Excel Add-in, Oracle Data Integrator (ODI), FDM, DRM, ERPI, OBIEE, Oracle 11i, Linux and Windows NT 4.0

Confidential, San Jose, CA

Hyperion Developer/Analyst/Administrator/Architect

Responsibilities:

• Managed and Lead the full life-cycle implementation of a leading Acquisition Integration Reporting/Planning, Forecasting & Analysis System from design, development, implementation, ongoing maintenance and support for CSG WebEx.
• Implemented Hyperion Enterprise Performance Management System 11.1.1.x to improve the planning and forecasting performance and for better reporting needs.
• Developed scalable and common FDM Integration process across Confidential and each of the standalone entities (acquisitions) to manage data mapping relationships and consolidate all non-core financial data in one central location.
• Identify business opportunities to increase usability and profitability of information architecture and ability to define how an enterprise information system will align with organization’s business and strategic objectives.
• Working as a Hyperion Subject Matter Expert in CSG Confidential and collaborating with Confidential IT, Finance Team and Confidential Business Support Team for systems integration and finance reporting.
• Implemented DRM for Master Data Management and Financial Systems Integration in designing hierarchies, creating properties, exports, validations and action scripts.
• Participating in driving the strategy, architecture, design, development and deployment of Hyperion products across the Confidential Corporate for financial and management reporting.
• Working with Confidential IT and Confidential Finance Teams and plays a technology leadership role with Oracle Hyperion Technology across the Confidential Corporate.
• Worked in a cross-functional environment as a liaison between the business and IT teams, and leading the Hyperion development and support projects.
• Responsible for understanding and defining Business requirements and translating those requirements into well architected solutions for better reporting capability.
• Identify opportunities for systems and processes improvement and optimization, leveraging best practices and users, while correlating complex business requirements.
• Performing analysis including defining business problem statement, current state analysis, risk analysis, cost-benefit analysis, needs analysis, business impact analysis, business process definition, mock-ups and test plans.
• Design and Develops detailed program specifications, data flow models and complies with project management methodology requirements as appropriate.
• Tests and implements systems and enhancements using techniques that meet generally accepted coding standards.
• Experienced in managing the project plan, coordinating resources, change control process, ensuring project documentation, status reporting, issues management and inspections.
• Prepared all the required functional documentation, technical documentation, user documentation, Change Control Documentation and etc,

Environment: Oracle Hyperion EPM 11.1.1.x, FDM, DRM, Web Logic Server 9.2, Oracle 11i, Linux and Windows NT 4.0

Confidential, Santa Clara, CA

Hyperion Consultant/Architect

Responsibilities:

• Managed the full life-cycle implementation of a leading budgeting/planning, forecasting & analysis system from design, development, implementation, ongoing maintenance and support for the Confidential Corporation.
• Involved with the FP&A Team in the consolidation and analysis of the annual plan, forecast submissions, and monthly and quarterly actual close processes and assisted in budgeting, forecasting, management reporting, annual reporting, quarterly reporting, audit reporting and BOD reporting.
• As a primary knowledge-expert of Hyperion solutions to support the worldwide FP&A organization at Confidential Communications, demonstrated technical aptitude in financial systems design, development, support, reporting and automation and actively involved with the forecasting, planning and close activities of a FP&A organization.
• Designed and developed Headcount module to plan, forecast and report worldwide headcount related information, Capital module to plan, forecast and report worldwide capital related information and Expense & Revenue module to plan, forecast and report worldwide operating expenses, P&L statements, Balance Sheet and Cash Flow statements.
• Developed the infrastructure including server’s setup, all software installation and configuration settings on 3 different planning environments, test, development and production.
• Upgraded Essbase Server, Hyperion planning, Hyperion Reports to Hyperion System 9.3 version to improve the performance and for better reporting needs.
• Designed and developed web enabled Forms to enable users to enter data for annual budget planning, monthly and Quarterly Forecasting Forms etc., using Hyperion Planning Form Designer.
• Designed and developed Expense Variance Reports, Function P&L Reports, Quarterly statements of operations, Headcount reports, Capital expense reports, Balance Sheet Reports, Cash Flow Reports, etc using Hyperion Reports.
• Developed and implemented Business Rules/Calculation Scripts using Hyperion Business Rules to calculate Headcount related expenses, capital depreciation & amortization, Facilities & MIS allocations, COGS to R&D Allocations, Balance Sheet calculations, Cash Flow calculations, etc.
• Developed essbase applications including Calculation Scripts (write/maintain/enhance), Load Rules, Report Scripts, Database Tuning and optimization, Dense/Sparse Outline Configuration, Esscmd and MaxL scripting, Batch Scripting, Automation, Backup/Recovery, Security Filters, importing data from RDBMS systems, etc.

Environment: Hyperion System 9.3, Hyperion Essbase6.5.x & 7.x, Hyperion Planning3.3.2, 3.5 & 4.0, HAL3.0&7.x, Hyperion Reports 2.5, 3.5, 7.2, Hyperion Analyzer 6.2, 7.x, Hyperion Performance Suite, Excel6.0.2, VBA, Tomcat, Web Logic, JRun4.0, Oracle 9i & 11i, Solaris, Linux and Windows NT 4.0

Confidential, Milpitas, CA

Hyperion Planning Lead Consultant/ Analyst

Responsibilities:

• Implemented FP & A System to produce annual budgeting, monthly and quarterly forecasting with rolling 12-month functionality.
• Involved in Conducting JAD Sessions with Business Users and Financial Managers at Phoenix for requirements gathering and developed the Project Plan, Functional Design Documents and Technical Design documents.
• Developed the infrastructure including Server’s setup, all software installation and configuration settings on 3 different planning environments, test, development and production.

Environment: Hyperion Essbase6.5.x & 7.0, Hyperion Planning3.3.2, HAL3.0, Hyperion Reports3.x, Excel6.0.2, VBA, Tomcat, Microsoft IIS, MS SQL Server 2000, Oracle Financials, and Windows NT 4.0

Confidential, Torrance, CA

Hyperion Lead Consultant / Business Analyst

Responsibilities:

• Involved in implementing R & C System to establish a world-class financial planning and reporting process as part of Confidential Global Data Warehouse Project.
• Designed, Developed, Configured and optimized the Financial Essbase Cubes and Management Essbase Cubes.
• Developed the Esscmd scripts to automate dynamic dimension building, data loading, to backup and for maintenance.
• Designed Forms, Business Rules/Calculation Scripts using the Hyperion Planning Tool.
• Developed the Application Set up and Environment set up to integrate the Hyperion Planning, Essbase and Relational Systems.
• Defined the strategies for Testing and Production Support. Involved in providing 24/7 production support.

Environment: Hyperion Essbase6.x, Hyperion Planning2.0&3.x, HAL2.x, Hyperion Analyzer6.x, Hyperion Performance Suite, Hyperion Reports2.x, Informatica PowerCenter6.0, Informatica PowerMart6.0, Excel6.0.2, VBA, Business Objects, MS SQL Server 2000, DB2, Essbase Integration Services, AIX5.0 and Windows NT 4.0

Confidential, Farmington Hills, MI

Hyperion Lead Consultant/DBA

Responsibilities:

• Involved in implementing a Scalable, Web enabled solution to manage their worldwide Consolidation, Budgeting, Planning and Forecasting System using HFM and Planning products.
• The Budgeting system implemented to produce annual budgeting, monthly and quarterly forecasting with rolling 12-month functionality.
• Developed integrations to load actual data from SAP into Hyperion and to integrate the Budgeting and Forecasting data from Hyperion Planning to HFM to provide Variance Analysis.
• Designed and developed web enabled Forms to enable users to enter data for capital costs planning, sales and marketing planning, G&A cost planning, T&M project planning etc., using Hyperion Planning Form Designer.
• Developed and tested Business Rules/Calculation Scripts using Hyperion Planning Business Rules graphical tool to calculate Sales Adjustments, G&A calculations, Unsold revenue etc.,
• Designed and developed Capital summary Reports, Plan Bonus by entity Reports, Plan Head count summary Reports, Revenue Reports and Variance using Hyperion Reports1.7.
• Designed, Developed and Tested Flow Diagrams in VBIS (Vignette Business Integration Studio 6.1) using Hyperion Financial Management Adapter, Hyperion Planning Adapter, SAPR/3 Adapter, ODBC Database Adapter, Aggregate Functions Adapter etc. using HAL3.0.
• Developed and Tested HAL Integrations to automate dynamic building and loading metadata for the Account, Entity, Employee and Project dimensions.
• Developed HAL Integrations for metadata synchronization between Multiple Source Systems, Hyperion Planning, and Hyperion Financial Management Applications.
• Developed the Essbase Calculation scripts to calculate the different currencies for the consolidation and reporting.
• Developed the Project Design Documents, Web Data Entry Forms and Hyperion Planning User Manuals and Administration documents and Test Strategy documents.

Environment: Hyperion Essbase6.5.1, Hyperion Planning2.2, HAL3.0, Hyperion Financial Manager2.2, Hyperion Reports1.7, Hyperion Analyzer6.1, SQL 2000 Server, IIS5.0, Tomcat J2EE Server, SAP R/3, PeopleSoft, Windows 2000 Application Server.