● Over Eight years of IT experience in design, analysis, development and implementation of various applications in client/server environment using Oracle RDBMS and Hyperion Essbase, Hyperion BI+, Hyperion Reports in Windows and Unix environment ● Proficient in Hyperion Essbase integration services, Essbase administration services, Smartview and Essbase spreadsheet Add-in ● Experienced as Essbase Administrator in maintaining Essbase, managing database settings, optimizations, thorough understanding of ASO and BSO cube architecture, Essbase Cache settings, optimizing calculations, attributes, storage security, optimizing reports ● Skilled in writing ESSCMD commands, creating MaxL scripts, Calculation scripts, MDX querying and Report scripts, Partitions ● Expertise in creating reports using Essbase Excel Add-In, Smart View ● Experienced in creating Closing reports and input templates using Dodeca Financial reporting tool ● Hands on experience in Hyperion planning to create planning and budgeting applications. ● Experience in managing web forms, Business Rules and Task List on Workspace ● Updated security/groups/users for User security through HSS (Hyperion Shared Services) ● Experience with Oracle database, DB Visualizer & SQL server in writing Views, Procedures and good understanding of DB objects ● Experience in Data loading & Dimension building from flat files as well as SQL files ● Good Knowledge on SAP Financials to analyze transactions and tables ● Worked as an IT Business Liaison to gather requirements and convert them in to technical specification document ● Extensive knowledge on Systems Development Life Cycle (SDLC) ● Ability to meet deadlines and coordinating multiple tasks in a work/project environment ● Versatile team player with excellent analytical, presentation and interpersonal skills. TECHNICAL SKILLS: Operating systems: Windows 7/XP/2000/NT/Vista, Mac, MS- DOS, UNIX Programming Languages: C, SQL, PL/SQL Database: Oracle 11g/10g, DB2 10.5, MS SQL Server 2000/2005/2014, MS Access, Master Data Management (MDM/MDS) Query Tools: Toad, SQL * Plus, iSQLPlus, Embarcadero, SQL* Loader, DB Visualizer 8.0.12 OLAP Development Tools: Hyperion System 11.x, 9.3.1 BI+, Hyperion System 11.x, 9.3.1 BI+ Analytic Administration Services, Hyperion System, 11x, 9 BI+ Financial Reporting, Essbase 9X/7.x, Esscmd, MaxL, Hyperion Enterprise and Hyperion Essbase Administration Services console (EAS) Reporting Tools Hyperion Financial Reports 11.x/9.x/7.x, Smart View 11.1.2.5.410, Essbase Excel Add-in, DODECA 6.7.10/7.1.11, Microstrategy Reporting, Oracle Forms 10g, Oracle Reports 10g, OBIEE Other Tools: Microsoft Office Suite, Microsoft Visio, SAP Financials, Lotus Notes, Adobe-Photoshop, Crystal Reports, Microstrategy Reports, TREE