SUMMARY:

• 10+ years of IT experience as a Hyperion developer and support engineer, extensive hands on technical experience in many aspects of various Oracle Hyperion products design and implementation.
• Accomplished Hyperion Certified Essbase Developer with extensive hands - on experience in business intelligence design and implementation.
• Developed and implemented planning, budgeting and forecasting applications using Oracle Hyperion Products.
• Experienced in analyzing, designing, developing, implementing, tuning and supporting the Oracle Hyperion Suite of tools, including Essbase, EIS, Planning, PBCS, FDMEE, Financial Reporting, Web Analysis, Shared Services; and IBM Cognos Command Center, VB Scripts with Excel, and Windows Batch scripting.
• Experience in working with OBIEE.
• Experience in maintaining and diagnosing issues in dashboards and reports using Financial Reporting, Web Analysis, and OBIEE.
• Expertise in managing applications and databases, Essbase architecture, data and dimension loading, Calc scripts, Report Scripting, and Performance tuning.
• Experience in designing Web Forms and Business rules in Hyperion Planning.
• Participating in POC for OAC.
• Expertise in managing and developing automation jobs in IBM Cognos Command Center.
• Responsible for application architecture, project management, Minor Enhancements and Rapid Application Development (RAD).
• Proven team player who keeps multiple tasks in motion while maintaining the overall project vision.
• Installing and configuration of Hyperion Essbase, Shared Services, Workspace, Excel Add-In, SmartView (All versions) and OBIEE.
• Analytical problem solver and critical thinker, innovative and creative, cooperative, result oriented, on-going learner, hands-on, self-motivated, and multi task oriented.
• Solid time management and multitasking skills, which help in conducting project meetings, reviews, and walkthroughs.
• Excellent written and oral communication skills and a team-player with a results-oriented attitude. Effectively interacted with business stakeholders and technical teams at all levels of the organization.
• Management skills earned by leading multiple teams at different locations.
• Experience in working through all phases of the SDLC including the design, development, implementation, and maintenance of financial applications.
• Mentored junior developers and provided necessary guidance wherever required.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Senior Consultant (Hyperion EPM)

Responsibilities:

• Key member of the Essbase Production Support team at Confidential for over 4 year, with knowledge of all Essbase applications at Confidential including Finance, Company Planning, Payroll and other applications.
• Management, performance improvement and complete support of 25+ Essbase applications, Hyperion Financial reports, Web Analysis and Shared Services within Confidential Essbase.
• Involved in Minor and Major enhancements, Defect/Bug fixing, Batch monitoring, Production issue resolving, batch/MaxL scripts modifications.
• Received repeated customer appreciation for quality and timely completion of work done.
• Design, develop, deploy and document various minor enhancements in Essbase (outline, calc scripts, rules files, and report scripts)
• Good experience in working on both ASO and BSO cubes.
• Lead of support staff in maintaining and administering existing Essbase systems and related operational reporting.
• Develop and maintain SQL queries to pull data from the Enterprise Data Warehouse (EDW) into Essbase.
• Created metadata files using DRM for Essbase alternate hierarchies and main hierarchies.
• Partner in maintaining and developing Excel input and reporting templates, using VBA as necessary to streamline tool efficiency and automate tasks.
• Support the Confidential Inc. ’s project management policies, including adherence to Agile methodologies.
• Develop an understanding of key financial and operational systems at Confidential Inc. and how they interface with the Essbase BI applications.
• Analyze and resolve problems of simple to hard complexity; research and recommend alternative actions for problem resolution.
• Partner with Finance professionals to improve processes through technology and automation; develop an understanding of key business concepts and operations.
• Coordinate/drive user acceptance testing, make recommendations around solution adoption and change management, and prepare the business for system readiness.
• Manage and develop the automation of Essbase cube dimension build and data load in IBM Cognos Command Center.
• Performed all admin activities including managing security groups in Shared services for 40+ Essbase cubes and 2000+ business users.
• Administering and maintaining backend services for EAS, Shared Services, HFR, Web Analysis and IBM CCC.
• Extensively involved in performing DBA activities like performance tuning the Calc scripts, database tuning, Essbase backup and recovery.
• Extensive involvement in Hyperion Essbase 11.1.1 to 11.1.2 migration.
• Participating in POC for OAC.

Environment: Hyperion Essbase 11x, Hyperion Financial Reporting 11x, DRM, VB scripted Excel Templates, Oracle SQL, SQL Server, Teradata, MS Excel Add-In, Smart View, Batch scripting, Windows server 2008 and 2012.

Confidential, Irving, TX

Principal Software Engineer

Responsibilities:

• Design, develop, deploy and document new Essbase/Planning applications (outline, calc scripts, rules files, web forms, business rules).
• Design and creation of model/metaoutline in Essbase Integration Services(EIS)/Essbase Studio.
• Designed new load procedures and business processes for Hyperion interaction and streamlined existing procedures for better performance.
• Writing/modifying Calculation scripts, member formulas and MDX queries based on the user requirements.
• Developed Calculation scripts and business rules for data transfer and allocations
• Received many customer appreciations and received the company internal prestigious awards.
• Developed financial statement (Income Statement, Balance Sheet, Cashflow statement) templates in Financial Reporting Studio.
• Optimized existing design and processes for better efficiency and usage of available resources.
• Installing and configuring various Hyperion products including Hyperion Essbase, Planning and OBIEE.
• Developed various reports and dashboards with maps (using Oracle database) to make interactive reports using OBIEE.
• Extensive involvement in migrating Hyperion products from 7.1.3 to 9x and from 9x to 11x.
• Extensively involved in creating DR systems, including install and configure of Hyperion products and migrating data from Production to DR and setting up the DR like Production.
• Maintaining the Essbase security and creating the necessary filters and groups based on the roles.
• Involved in creating static reports using Excel Add-In and web analyzer.
• When Smart View is introduced to our users, created document on Smart View functionalities and provided this as a training document to all users which helped 800+ users.
• Created batch scripts and MaxL scripts to automate the Essbase dimension build and data load using Arcana/AdTempus scheduler.

Environment: Hyperion Essbase 7x/9x/11x, EIS/Studio, Planning, OBIEE, Web Analysis, SQL Server, MS Excel Add-In, Smart View, Batch scripting, Windows server 2000 and 2003.