Sony Budge

Ph#: +1-669-***-****

Email: acultv@r.postjobfree.com

PROFESSIONAL SUMMARY:

* ***** ** ************ ** experience in Enterprise Performance Management Tools.

Extensive knowledge on Hyperion Planning, Hyperion Essbase 11.x/9.x/7.x/6.x, Hyperion Shared Services, Essbase Administration Services, Financial Reports, Web Analysis, Hyperion Application Link, and Essbase Spreadsheet Add-In, Hyperion Smart View.

Created, Migrated, performed Maintenance of Hyperion Essbase and Planning within the various domains.

Involved in design, analysis, support, development and implementation of various applications in Client/Server environment using with Hyperion Essbase.

Worked extensively on Essbase BSO and ASO.

Experience in creating Outline, Load Rules, Reports generation using Smart View, Financial Reporting & Hyperion Web Analysis.

Knowledge in calc scripts, Report Scripts, Batch scripts, Tuning, Optimization of cubes.

Knowledge in writing MaxL statements and Automation of process.

Hands on experience in Hyperion Planning on different applications (Classic and EPMA).

Created Different Data Forms in Hyperion Planning.

Experience in creating Smart View queries and Financial Reports for Essbase Planning and HFM Applications.

Experience in Installation, Configuration of Hyperion Version 11.x and Troubleshooting different issues.

Proficient in Server maintenance Activities like, Post Installation and Configuration Issues, Performance Tuning Related to the Applications, User Maintenance Activities, Applying Patches both on Linux and Windows Environments, Resolving the Issues on Priority and Severity Basis according to the Customer Requirements.

Experience with MSAD and SSO (Essbase security through shared services)

Strong analytical and problem solving skills along with programming experience, background includes high level over sight of management in handling various technical aspects like software scheme design, coding of modules, monitoring critical paths & taking appropriate actions.

Experience of application migration process between different environments.

Maintained security using Hyperion Shared Services created users and groups and assigned different roles.

Handling Customer escalation and strict compliance to agreed SLA.

Proficient in Oracle SQL, PL/SQL and UNIX.

Demonstrated ability to manage and deliver results on both strategic and tactical levels, with domain expertise that includes finance, e-commerce, retail, insurance.

Background includes high level over sight of management in handling various technical aspects like software scheme design, coding of modules, monitoring critical paths & taking appropriate actions.

Proficient in understanding the Customer Requirements in resolving the Issues.

Executed Application and Data Migration between different Hyperion applications.

Good Knowledge on Databases like SQL Server, Oracle and Application Server like Web Logic.

Ability to make formal presentations, to deal with complex technical issues, to adapt in a team-based organization, to formulate overall strategies and support development effort in the areas of major difficulty.

Adroit at learning new concepts quickly, working well under pressure and communicating ideas clearly and effectively.

Performance driven, Perseverant, Hardworking, proactive, and a good leader versatile team player with excellent analytical, presentation and interpersonal Skills with an aptitude to learn new technologies.

Hands on experience with data integration from multiple data sources to Hyperion Planning and Essbase through Oracle Data Integrator (ODI).

Technical Skills:

Operating Systems

Windows XP, Windows server 2003/2008/2012, Linux

Database

Oracle 10g/11g, Essbase, SQL Server 2000/2005/2008/2012

Office Tools

MS Word, MS Excel, Power Point, MS Access

Web Servers

IIS 6.0/7.0, Apache Tomcat, Oracle HTTP Server

Application Servers

Web Logic Server

Hyperion Tools Skill Set

Hyperion System 9.x / Hyperion EPM 11.x (11.1.1.1 - 11.1.2.4) Essbase, Planning, HFR, Smart View, HFM, FDM/FDMEE, Shared Services, Workspace

PROFESSIONAL EXPERIENCE:

LiDestri Foods-Rochester, NY Jan 15-Till Date

Role: Sr. Hyperion Essbase/Planning Consultant

Responsibilities:

Hands-on experience in Hyperion Essbase, Hyperion Financial Reports/Web Analysis and Hyperion Planning in Windows and Linux environment.

Experience in both Waterfall & Agile development methodologies.

Involved in the Hyperion suite installation, Multi server environment configuration, Clustering and Load Balancing.

Configured SSL Hyperion Products and user directory connection to MSAD

Involved in requirement gathering, estimation and impact analysis for new development of cubes, reports and backend process.

Involved in creating, modifying calc scripts, web forms, batch scripts using MAXL/ESSCMD as per the business requirements to solve production issues.

Automate data load process with MAXL scripts and scheduled to run Calc scripts after every data load.

Created multiple cubes with BSO technology and with multiple databases under each application to support partition and data mapping between databases to achieve corporate level reporting.

Created and Managed Filters on Essbase cubes to restrict the access to the data for various intersections based on user privilege.

Performed tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.

Created Multiple Hyperion Financial Reports, Web Analysis Dashboards, based on the requirement.

Created Multiple Template’s of Smart View and Excel Addin for every day analysis of the user.

Created the metadata for applications, considering future enhancements and current scope.

Created alternative hierarchies to meet the reporting needs.

Created the Security Matrix and implemented the complete security for various set of applications.

Responsible for writing allocation logics, Data loading activities, Building forms and reports on to meet the business requirements.

Participated in testing with end user, created test cases for individual data intersections and executed test cases and recorded results to compare with originals.

Implemented a complete maintenance sequence using VB Scripts, Batch clients, Maxl commands through which the applications performance has been enhanced.

Involved in setting up the Production environment, Server side Performance tuning.

Involved in the migration activities – from UAT to Production as a part of Go-Live activity.

Involved in creating Batch files that will sync the newly added metadata from Master library to the respective applications in EPMA.

Entire budgeting cycle was completed as a part of Warranty support, did the currency translation for those required entities and delivered flawless reports as expected.

Created versions in DRM with different hierarchies and blended the data.

Export/Import data from DRM using the DRM migration modules.

Backup and Recovery of Hyperion applications. Scheduling daily backups.

Experience on Disaster recovery and contingency.

Experience with Change/Incident/Problem Management.

Involved in maintaining and creating new data servers, connections for different data sources through the Topology manager. Created data servers for sources that included Flat files and SQL Server sources.

Decisive with strong leadership qualities and flexible in work schedules.

Responsible for Migration of application from One Environment to other.

Responsible for looking into the performance issues, Disc space.

Responsible for applying the needed Patches.

Knowledge of Change management for the System/Infrastructure Changes.

Server Administration, installing latest patches, automated backup and restoring application from backup as required.

Developed documentation of the existing Essbase cubes and financial reports to transfer knowledge for users, for administration and support

Environment: Hyperion Essbase 11.1.2.3, Shared Services 11.1.2.3, ASO & BSO, Smart View For office, Spread sheet add-in, Interactive reporting, Financial Reporting, Oracle 10g.

Frost National Bank-San Antonio, TX Nov 13 - Dec14

Role: Sr. Hyperion Essbase Planning

Responsibilities:

Created and managed planning applications using Classic and EPMA.

Created and managed applications and Databases - BSO, ASO, Multi currency and reporting applications.

Import /export metadata and data using outline load utility, planning import and export, FDMEE, EPMA etc.

Worked on financial statements - Income Statement/ P&L account, Balance sheet, Cash flow, Revenue.

Setup Dimension Build Files to load dimensions to Essbase. Setup load rule files to load data from data warehouse into Essbase Cube.

Create calculation scripts to generate quarter end financial metrics and future scenarios

Proficient working with Data forms -Simple, Composite, Master composite form, adhoc grid etc.

Create, manage and launching calculation scripts and business rules in planning as per the business requirements.

Familiar with Project finance, Operational planning and expenses, Forecasting module experience.

Used Smart view – To view, import, manipulate, distribute, and share data in MS Excel interfaces.

Maintain the planning security system-User management, security file, control access using filters& groups.

Hyperion planning administration activities – Maintain and optimize planning.

Hyperion lifecycle management administration (migration to & from DEV, UAT & PROD).

Version adjustment and copy version setup & procedures.

Expense allocation modeling, enhancements and modification.

Familiar with planning infrastructure activities - Installation, Configuration, Backup, Restore, Migration, planning services, High availability etc.

Environment: Hyperion Planning 11.1.2.3, Shared Services11.1.2.3, Excel Smart View, Report Scripts.

The PMA Insurance Group - Blue Bell, PA Oct 12-Oct 13

Role: Hyperion Essbase Developer

Responsibilities:

Coordinated with business analysts / clients to understand and develop an optimized Essbase cube.

Gathered requirements and developed a project plan.

Prepared an optimized data source.

Developed aggregate storage cubes (ASO) using Essbase.

Developed a transparent partition with ASO / BSO cubes to leverage advantages of both technologies.

Developed rule files for loading data and for dimension build.

Implemented robust data-access security and user management.

Automating of cube refresh through MaxL and UNIX Scripts.

Optimized data loads and calculation scripts and maintained existing Essbase cubes.

Optimized the applications to reduce runtime.

Retrieved reports using Excel Add-in and generated batch reports using Hyperion reports.

Maintained the OLAP application and took regular backups.

Provided technical guidance and support to end-users by developing appropriate documentation.

Environment: Essbase 11.1.1.3, Excel Smart View, Hyperion Planning 11.1.3, Hyperion Shared Services, Report Scripts, HFR (Hyperion Financial Reporting).

UCO Bank-Bangalore, INDIA Aug 11-Sep 12

Role: Hyperion Technical Analyst

Responsibilities:

Involved in installation of Hyperion on a new environment and applied all patches.

Designed BSO Cube as per the requirement.

Setup Dimension Build Files to load dimensions from Oracle Database to Essbase.

Setup load rule files to load data from data warehouse into Essbase Cube.

Developed the application, batch scripts to do automation i.e., dimension build and data load.

Created Maxl script to automate the dimension update and data load process.

Created calculation scripts to calculate the key financial metrics.

Created calculation scripts to generate quarter end financial metrics.

Setup allocation rules to run allocations.

Define Smart Slices in smart view and grant it to the users.

Build standard financial reports and operational reports using Financial Reporting tool.

Involved in the automation process for data load, tuning, backups and adhoc reports too.

Migrated the application from Development to QA to Production.

Created Daily Brief Report by looking at the existing Excel reports using Hyperion IR studio.

Worked on Validation Reports to verify the conversion of Databases. Validating the Source and Destination Schemas.

Developed various scripts like Date for the reports to run automatically in the specified time period like Monthly, Weekly, and Daily.

Provided 24/7 on call Production support.

.

Environment: Hyperion Planning, Hyperion Essbase System 9, Hyperion Financial Reports, Hyperion Planning System 9, Oracle 9i & Windows 2003.

Genex Technologies-Hyderabad, India Dec 09-Jul 11

Role: PL/SQL Developer

Responsibilities:

Actively involved in interacting with front end users and gathered User Requirement and Online System Specification.

Created number of database objects like tables, views, indexes, synonyms and materialized views using SQL Loader.

Involved in creating procedures, functions, packages and triggers to facilitate functionality in different modules.

Created data mapping files for the data coming from different web services.

Developed ad-hoc Reports (SQL or PL/SQL scripts running in Unix System) to extract data from database and deliver to user in Excel format.

Created audit tables and implemented complex business logic using triggers.

Used cursors, for cursors and Ref Cursor (dynamic SQL) for fetching data and processing it.

Avoided Mutating table errors by using different methods like pragma autonomous transaction, statement level trigger and multiple triggers.

Worked on XML along with PL/SQL to develop and modify web forms.

Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.

Developed ETL sessions for initial full loading and incremental loading.

Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Developed ETL sessions for initial full loading and incremental loading.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Monitoring nightly ETL batch flow and resolving the issues and directing it to concerned person.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Worked on requirement analysis, coding and testing various modules in a software development life cycle.

Environment: Oracle Database 9i, Toad, SQL*Plus, SQL* Navigator, SQL*LOADER, UNIX, Forms Builder 6i,

Reports Builder 6i.

Veritra IT Solutions-Hyderabad, India July 08-Dec09

Role: PL/SQL Developer

Responsibilities:

Interacted with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.

For complex business queries involving multiple tables from different databases used Joins, correlated and non-correlated sub-queries

Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of requirements.

Enforced business rules via checks and constraints.

Developed SQL queries to fetch data as per the business requirements with proper tuning techniques.

Developed and tested extraction, transformation, and load (ETL) processes

Analyzed the requirements and framed the business logic for the ETL process.

Created checks and constraints to maintain data integrity across the data in the database.

Created Stored Procedures to generate various Drill-through reports and functions to support efficient data storage and manipulation.

Migrated actuate code of data extract to PL/SQL equivalent and Created PL/SQL functions, packages, procedures and joins.

Created and manipulated stored procedures, functions, packages and triggers using TOAD.

Worked on various back-end Procedures and Functions using PL/SQL.

Wrote necessary PL/SQL API scripts for successful running of the programs.

Monitoring nightly ETL batch flow and resolving the issues and directing it to concerned person.

Created required technical documents, technical specifications, and test results.

Scheduled SQL Server Agent Jobs to run every day to update changes in the base tables.

Used Exception Handling for handling errors of programs, scripts and procedures

Environment: Oracle 9i, SQL*Loader, SQL, PL/SQL, TOAD, UNIX, Windows XP.

Education:

Bachelor's Degree in Computer Science Engineering from JNTU Hyderabad.

Contact this candidate