SUMMARY:

• Self - motivated, innovative and goal-oriented professional committed to pursuing a long-term career in building Oracle EPM solutions. Offers 8+ years of Hyperion expertise demonstrating strong analytical and problem solving skills, computer proficiency and ability to follow through with projects from inception to completion, always striving to deliver the best of both industry and consulting worlds while meeting all applicable business goals and objectives.

TECHNICAL SKILLS:

ETL Tools: ODI, FDQM

Dimensional Data Modeling: Hyperion Essbase from 6.5 till 11.1.2, Hyperion Planning 11.1.2.X, Application System Administration, Excel Add-In, Smart view, Windows server 2003 & 2008.

Analytics: Oracle Essbase, OBIEE

Oracle Technologies: Oracle EPM System, ODI, Oracle Database

RDBMS: Oracle, SQL

Tools: Toad, PL/SQL-Developer, MS-Office, Appworx

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Senior Essbase/Planning Developer

Responsibilities:

• Participated in requirement gathering & analysis.
• Developed Planning Revenue/Workforce application with excellent understanding of Hyperion planning implementation.
• Build application metadata (Dimensions) and created variance reporting members.
• Designed and developed Calculation manager scripts, including Global variables & application variables.
• Designed and Developed Data load rules, calculation scripts, and Maxl Scripts for automated outline and data loading. Optimized Outline, Data load rules and Calculation Scripts.
• Designed and developed planning web forms to input data and reporting purposes.
• Designed Task list for budgeting process.
• Designed and implemented User security at dimensional level and object level (Web forms, Calc Manager Rules, Task list.)

Confidential, Acton, MA

Responsibilities:

• Involve in initial kick out meeting for project goals.
• Created Essbase and Oracle Exalytics PowerPoint slides
• Why Essbase on Exalytics? New features introduced in Exalytics just for Essbase.
• Certified and non-Certified components of EPM for Exalytics.

Confidential, Roseland, NJ

Senior Essbase/Planning Developer

Responsibilities:

• Preparation of Estimates and responding to the Change Requests.
• Plan and execute tasks to meet Organizational objectives and goals.
• Work with stake holders across the board to understand their requirements and explain available options in non-technical terms.
• Design Calc scripts to meet business requirements and manage the projects efficiently.

Confidential, Rockville, MD

Senior EPMA/Essbase Developer

Responsibilities:

• Created/Migrate Production system to Dev and test environments.
• Created automation batch script to load data.
• Created batch schedules to run daily batches using task scheduler.
• Created back up scripts using LCM to automate daily backups for entire EPM system and Essbase data backups.
• Created automated back script to load 6 months of data using date and system variables.
• Created new Essbase Calc scripts and data load rules to support automation process.
• Created data load scripts using FDM.
• Created documentation on how load data using FDM manually.

Confidential, West Kingston, RI

Lead Developer

Responsibilities:

• Involve in requirement gathering and convert to technical design.
• Designed developed Essbase ASO application, MDX formulas, data load and dimension build rule files.
• Loaded historical data from Cognos to Essbase.
• Designed automated batch process to build and load data on nightly basis.

Confidential, Roseland, NJ

Senior Developer.

Responsibilities:

• Support current production application.
• Tune/create Calculation script and member formula.
• Workforce planning application support and maintenance.
• Creating core documentation environment related.
• Excellent in providing end user .
• Maxl and Esscmd script creation.
• Involved in creating automation Maxl and Esscmd scripts to run overnight jobs.
• Execute scripts based on ad hoc request.
• Monitor every day job processing to maintain data accuracy and any job failures.

Confidential, Boston, MA

Senior Developer/Lead

Responsibilities:

• Involved in gathering requirements and developing a plan to implement Hyperion.
• Designed and developed numerous Planning applications with excellent balance of dense and sparse dimensions.
• Design and Developed web forms for data input.
• Excellent understanding of storage properties to optimize Essbase outline for performance improvement.
• Re write existing calculation script to use new design.
• Involved in designing custom currency solution which gave us the privilege to improve Essbase outline performance.
• Performed weekly meetings to keep everyone posted on current design progress.
• Redefined data load procedure to map new Hyperion design.
• Created a core documents on procedure’s & environment related.

Confidential, Canton, MA

Project Manager

Responsibilities:

• Involved in gathering requirements and developing a plan on batch jobs.
• Gather month to month job’s list that are critical for business.
• Strictly monitor nightly batch jobs using GDC support.
• Under the job dependency to avoid over collapsing of jobs.
• Submit daily status update on overnight jobs.
• Contact right person on job failures.
• During the month end reconcile the number between Hyperion & ODS.
• Involved in creating core documents on procedure’s & environment related.

Confidential, Boston, MA

Developer/Onsite Lead

Responsibilities:

• Installed EPM on Disaster Recovery environment to match production in case of production being down.
• Created automation Bat files to export HSS, Reports and Essbase backups weekly using LCM.
• Applied EPM patch sets.
• Support current HFM application and tune up its performance settings.
• Support in creation & maintenance of OBIEE dashboards and reports.
• Provide weekly status report & Monthly meetings with client to gather requirements.
• Support at environment base level to make sure reliability and high availability of the environment.
• Upgraded EPM 11.1.2.1 to 11.1.2.2.
• Installed fresh Hyperion Planning with end user .
• Create multiple workforce planning applications.

Confidential, Boston, MA

Senior Developer/Onsite Lead

Responsibilities:

• Participated in requirement analysis phase and gathered reports in several format.
• Excellent understanding of different storage in Essbase and their usage. Created really large cubes using ASO options in many companies. Also, created BSO application to support Financial Budgeting and Forecasting.
• Developed and maintained Rule files, Calc Scripts (BSO), Maxl Scripts, MDX member formulas (ASO).
• Tested Data load rules, fixed errors from the error log files, resolved issues of data retrieve from Excel, Developed Excel reports using the advanced member selection techniques.
• Create instances and data source for the planning application using configuration utility.
• Worked on ODI load data to planning application.
• Add and moved members in outline and refresh the planning.
• Re-Installed Hyperion Production environment on to a physical machine for performance improvement.
• Migrated Planning & Essbase application including metadata and security.
• Reconciliation of General Ledger & MAR for management reporting.
• Automated daily back up using Hyperion Life cycle Management.

Confidential, Valley Forge, PA

Essbase Developer

Responsibilities:

• Participated in requirement analysis phase and gathered reports in several format, analyzed the reports to design a Hyperion Essbase Cube for Sales Analysis.
• Involved in defining data mart to support Hyperion Essbase and created reports financial reports and web Analysis.
• Designed and developed numerous complex Essbase applications with excellent balance of dense and sparse dimensions.
• Developed and maintained Rule files, Calc Scripts (BSO), Maxl Scripts, MDX member formulas (ASO).
• Tested Data load rules, fixed errors from the error log files, resolved issues of data retrieve from Excel, Developed Excel reports using the advanced member selection techniques.
• Worked on Work Force Planning and used same BSO cube with default dimensions of Planning.
• Create instances and data source for the planning application using configuration utility.

Confidential, Stamford, CT

Developer

Responsibilities:

• Involved in gathering requirements and developing a project plan.
• Developed Batch files and Rules files to upload data from financial system’s database to Essbase cube.
• Involved in creating Rule files for multi-dimensional databases.
• Developed data loads and calculations.
• Optimized data loads and calc scripts.Designed and developed monthly, quarterly and yearlysales Cubes.
• Developed calc Scripts to calculate various metrics for the outline.
• Involved in weekly meetings, to discuss current project status.

Confidential, Bellevue, WA

Developer

Responsibilities:

• Participated in requirement analysis phase and gathered reports in several format.
• Analyzed the reports to design a Hyperion Essbase Cube for Counts analysis. Developed Hyperion Essbase application for files tracking and helpdesk system
• Created complete Essbase database which included Developing Outline & Data load rules, calculation scripts, and Maxl Scripts for automated outline and data loading. Optimized Outline, Data load rules and Calculation Scripts.
• Automated the Essbase Cubes using Esscmd and Batch Scripts.
• Optimization and performance tuning for Data Load/Calculations.Manipulated data columns to suit Dimension builds, Tested Data load rules, fixed errors from the error log files, resolved issues of data retrieve from Excel
• Maintained cubes and took regular backups.
• Provided technical guidance and support to end-users about by developing documentations required.

Confidential, Rochester, NY

Essbase Developer

Responsibilities:

• Migrated Essbase cubes from 6.5 to 7.1, which includes Essbase outlines, rule files, calculation scripts.
• Developed Essbase cubes for sales and marketing group.
• Extracted data from SQL Server 2000 and perform data manipulation using DTS packages.
• Loaded data using SQL interface.
• Wrote calculation scripts member formulas to calculate Essbase database.