SUMMARY

• Over 6years of detail - oriented, skilled professional experience in Relational Databases, Data warehousing (Hyperion/OLAP), Client-Server applications, Oracle and SQL Server Database Administration.
• Five plus yearsof implementation experience as Hyperion Developer, Planning Administrator, hands on experience using Hyperion ESSBASE, Planning, ESSBASE Excel Add-In, Hyperion Smart View Add-In, Hyperion Reports, Hyperion SQR, Hyperion Analyzer, Financial Reporting Studio environments.
• Thorough knowledge of the SDLC and also the entire life cycle of Data warehous design, development and implementation.
• Expertise in architecting complete data models combining multiple transaction systems ETL tools and relational and multi-dimensional data stores for star schema, snowflakes schema designs and reporting tools.
• Proficient in the development of ETL processes with a good understanding of source to target data mapping, ability to define, capture Meta data and Business rules.
• Hands on experience in installation, configuration and maintenance of Hyperion Shared services 11.x/9.x, Hyperion Essbase11.x/9.x, Administration Services 11.x/9.x.
• Responsible in migrating Hyperion 11.1.2.1. To 11.1.2.3.500 and 9.x to Hyperion 11.1
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP Models & Meta-Outline.
• Commendable knowledge and experience in automation, Essbase cube designing, partitioning and optimization of report queries in Microsoft Excel.
• Strong experience as Essbase Cube Analysis & Design, Essbase database Administration and performed upgrades, Maintenance, database backups, Performance tuning, Optimization, Dense/Sparse settings, partitioning, etc.
• Experience and proficiency in functional and technical development for Hyperion Planning application involving budgeting, strategic planning, forecasting Capex planning and workforce planning. Experience in application implementation in different industry sectors. Solid understanding of Planning architecture and solutions expected by client.
• Extensively involved in generating monthly/quarterly financial reports (Balance sheetStatement, cash flow statement) using Hyperion Intelligence, Hyperion Analyzer, Hyperion Reports and Hyperion Essbase Spreadsheet Add-in.
• Worked on financial reporting systems and Decision Support Systems (DSS) usingHyperion Essbasealso, building Financial Budgeting and Forecasting OLAP applications.
• Responsible in providing production support, maintenance, development, and administration of Essbase cubes.
• Involved extensively in developing load rules, calc scripts, automation scripts, and partitioning.
• Strong knowledge of Financial Domain using Hyperion Financial Management Suite (HFM).
• Experienced in knowledge transfer, preparing the required documentation, training the clients.
• Proficient in writing Stored Procedures and Triggers using SQL and PL/SQL on Oracle/SQL Server databases.
• Strong communication, organizational and interpersonal competencies along with detail oriented and problem solving skills in the technology arena.

TECHNICAL EXPERTISE:

OLAP Expansion Tool: Hyperion System 11/9 BI+ Analytic Administration Services, Hyperion Planning System 11.1.X/9.X, Capex Planning, Hyperion Shared Services 9.3, Web Forms, Hyperion Essbase 11.1.2/9.X/7.X/6.X, Essbase Integration Services 7.X/6.X (EIS), Hyperion System 9 Smart View, Essbase Excel Add In, ESSCMD, MAXL, MDX, Hyperion Reports 7.2/7.0, Hyperion Financial Reporting Studio 9.3,, Life Cycle Management(LCM),Hyperion Performance Suite,, Hyperion DRM, Hyperion MDM.

Reporting Tools: Hyperion Financial Reporting Studio, Hyperion Reports, Web Analysis, Hyperion Analyzer, Hyperion Spreadsheet Add-in, Hyperion System 9 Smart View.

Languages: C, C++, SQL, PL/SQL, Java, Java script and HTML.

Databases: Oracle 11,9i/8.x/7.x/6.x, DB 2, MS Access, MSSQL Server

Markup Languages: HTML, DHTML, XML, XSL

Web & Application Server: Apache Tomcat web server, Microsoft IIS, Web logic 9.x 10.x

Operating Systems: MS-Windows XP/2000-03/NT/98/95, UNIX, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, NC

Hyperion Planning / FR Reports/ Admin / Developer

Responsibilities:

• Involved in creating functional & technical specification documents depending on the Business requirements.
• The project involved in implementing a new budgeting cube for the existing General Ledger.
• Involved In upgrading Hyperion suite from 11.1.2.1. To11.1.2.3.500 and also creating interfaces with ODI and SQL.
• Migrated all the existing planning apps and Business rules.
• Created master repository and interface in ODI. Also,Automated ODI Process by creating various interfaces to load metadata into planning application.
• Created SQL scripts to extract data from Oracle EBS for GL and populate SQL staging tables.
• Created Multi currency planning applications for global users.
• Created a number of web forms to enter, update, analyze, print, and report on data. Also, created Task lists, planning units to ease the work of the users when working with the web forms.
• Performed optimization of data forms, report scripts, Calc Scripts, business rules.
• Developed simple to complex calculation scripts to arrive at the aggregated data for each application based on the functional specifications.
• Maintained database for optimum performance for using calculation scripts and business rules.
• Created various process automation using ESSCMD and MaxL Scripts.
• Involved in performance tuning of database modifying the cache &essbase.cfg file settings.
• Initiated, developed workforce planning cube with metadata and data from oracle HR with their existing employees. Created business rules to Add/Remove employees, plan departures, transfers, add/remove benefits, plan TBH’s and budget the employee expenses.
• Developed various A.S.O and B.S.O Cubes for reporting purposes.
• Created a number of new users in the native directory meeting with their security standards, setup user and group level securities using shared services and implemented dimension level security.
• Involved in Loading metadata and data into Planning and Essbase.
• Created a number of Reports for their existing Application and for the new planning application as well. Created P&L variance reports, Expenses by departments-Activity-product-project in a monthly-quarterly-yearly, using some complex FR functions, used UDA’s in the reports when needed. Also, created some Ad-hoc reports with Smart view.
• Created training content and trained all the business users on smart view 11.1.2.5.400
• Designed various financial reports on Balance Sheet, Income Statement and Cash Flow.
• Prepared Training documents for the End-users and was responsible for their training, for administration and support.
• Created automated backups procedure for the application.
• Supported users during User Acceptance Test (UAT) by troubleshooting and resolving outstanding issues/problems faced by users.

Environment: Hyperion Shared Services v11.1.2.3/11.1.2.1,Hyperion planning Web app, Workspace, Hyperion Financial reporting studio, Hyperion Web Analysis, Excel-add in, Hyperion Smart view, Essbase Administration Services(EAS), Oracle data integrator(ODI), SQL, Windows server 2003.

Confidential,Tampa, FL

Hyperion Planning / Admin

Responsibilities:

• Involved in defining requirements, functional specifications, designing documentations and testing strategies.
• Involved in creating Meta outlines using Metadata extracts from PeopleSoft files in Hyperion EPMA.
• Developed Data Load Rules, Calc Scripts & Report Scripts.
• Created ASO cube for historical data linked to forecast cubes by partition.
• Created new members into the Existing hierarchies with the desired member properties as per the client’s requirement, using the ADS files.
• Developed a Planning application from the created dimensions and successfully deployed it.
• Worked extensively on planning application for Planning, budgeting and Forecasting (PBF), Business Rules and web forms for planning users.
• Created web forms to enter, update, analyze, print, and report on data.
• Developed the Consistent Financial & Interactive Reports & moved them to Production.
• Developing numerous simple to complex Business Rules and attached them to the web forms.
• Worked on creating, maintaining, and supporting all application objects including outlines, calculation scripts, rules files for dimension building and data loading, creation and optimization of transparent partitions, and security objects through Essbase Administrative Services (EAS), MaxL, MDX queries, and ESSCMDs.
• Used Life Cycle Management (LCM) for migrations between different environments, Development to QA, QA to production.
• Worked on Excel spreadsheets using Excel-add in for data cleansing and validation.
• Prepared Quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Involved in Loading Sales, Revenue, and Head Count Data to cubes, creating current Actual/Forecast/Budget members.
• Involved in creating cubes, outline modifications, maintenance of batch scripts, scheduling runs, developing report scripts and load rules.
• Worked on in Automation using batch scripts, optimization of report queries in Microsoft Excel, creating ad-hoc reports for decision makers using Smart View and other applications.
• Developed web forms using Hyperion Planning for the users to input data.
• Developed various financial reports on Excel spreadsheets add-In using Essbase Query Designer for analyzing the data at different levels and for data validations.
• Involved in mapping data from Hyperion Essbase to the relational source, and running ad-hoc queries for providing optimized reports.
• Responsible for month-end tie-out and provide related support to financial controllers.
• Supported users during User Acceptance Test (UAT) by troubleshooting and resolving outstanding issues/problems faced by users.
• Prepared Quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers.
• Created Web Analysis reports for the users for those reports where they wanted to use the Drill down Functionality effectively and some Ad-hoc reporting.
• Involved in filing Service requests (SR) to the Oracle if there were any production issues.
• Detailed documentation for everyday- easy to use maintenance guide for DBAs and financial controllers.

Environment: Hyperion Workspace 11.1.1.3/9.3, Enterprise Performance Management Architect (EPMA) 11.1.1.3/9.3, EAS 11.1.1.3/9.3, calculation manager, Life cycle Management (LCM), Smart view, Excel Add in, Microsoft Access, Windows XP.

Confidential, sandiego, CA

Hyperion Planning / Admin / Developer

Responsibilities:

• Coordinated Installation, Configuration and Overall Maintenance of Oracle EPM Hyperion Planning, Hyperion Financial Management, Workspace, Shared Services, Financial Reporting and Web Analysis, HFM and Smart View.
• Maintaining the Existing Hyperion Planning Environments.
• Coordinated Hyperion application migrations across the Environments, Security set-up and ongoing support.
• Configured and maintained users from Microsoft Windows Active Directory (MSAD) by setting it up in Hyperion Shared Services.
• Discussed with clients on user needs and analyzed their business requirements in converting draft outlines into technical and functional specifications of Essbase.
• Extensively involved in the financial planning model calculations i.e. (Actual, forecasts, Profit, Elimination and Consolidation and Headcount)
• Designed and developed numerous Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion. Developed Aggregate Storage Cubes using Hyperion System 9.x.
• Performed Unit testing for both break/fix and maintenance/minor enhancements.
• Coordinated Disaster Recovery Planning and Capacity Planning.
• Applied software patches to resolve the issues encountered by Hyperion system 9 bugs.
• Created and maintained batch - jobs (UNIX and Windows) which automate Data Loads, Calculation and developed scripts for automation of services start up and stop up using Control-m Scheduler.
• Maintained Hyperion Application on virtualization and remote access software CITRIX.
• Debug and enhance various calculation scripts and business rules.
• Maintain outline, metadata and member formulas as business requirements.
• Created and provision the users with necessary roles on applications using Hyperion Shared Services and in Hyperion Planning.
• Maintained Rules file for loading of data using Essbase administrative services and loading the metadata using Enterprise Performance Management Architect.
• Installed and maintained Load Balancing software BIGIP.
• Loaded planning applications using ODI.
• Conducted essbase performance tuning and troubleshooting activities such as periodic export and data load, re-arranging the dimensions for optimized performance.
• Managed Hierarchies, Business Rules, Mappings and Validations using Data Relationship Management (DRM) and Hyperion Application Link (HAL).
• Implemented robust data-access security and user management.
• Configured and maintained MSAD and OID with the shared services and implemented single sign-on.
• Automated data loading from multiple sheets using MaxL.
• Tuned Analytic services for optimal performance, data retrieval and calculation.
• Worked on Essbase Integration Services (Metadata workflow/filters/drill through reports using Hybrid Analysis).
• Provided oversight of the technical migration of the code and configuration in Hyperion Planning Environment.
• Coordinated in End-user training and developed appropriate Training materials.

Environment: Oracle EPM System 9.3.1, Hyperion Planning 9.3.1, Hyperion Analytic Services 9.3, Shared Services 9.3, Business Rules 9.3, Enterprise Performance Management Architect (EPMA), Hyperion Data Relationship Management 9.3, Workspace 9.3, Financial Reporting Studio 9.3, Hyperion Financial Management, Hyperion web Analysis Studio 9.3, Excel Add-In, Smart View, MaxLHyperion Application Link (HAL), Oracle 10g/9i, Sun Solaris 9, Red Hat Linux 4.0, Web Logic 910.

Confidential

Oracle PL/SQL Developer

Roles & Responsibilities:

• Installed and configured Oracle 9i/8i/8.05
• Designed and developed database tables, triggers, cursors using PL/SQL.
• Developed and optimized a framework for extensible automated production support in PL/SQL.
• Created spreadsheets and reports using oracle PL/ SQL, Toad and SQL.
• Developed stored procedures and complex packages using PL/SQL.
• Developed triggers and PL/SQL procedures for automation of jobs scheduling.
• Managed performance and tuning of SQL queries and fixed the slow running queries.
• Ported Oracle Database procedures, functions, triggers and PL/SQL blocks to DB2 Database.

Environment: Windows 2000 server, Windows XP, Oracle 9i/8i, Oracle enterprise server, DB2, Control Centre for importing and executing SQL scripts.