PROFESSIONAL SUMMARY:

• Around 10 years and 10 months of IT experience in advanced analytical software applications, Requirements Gathering, Design, Development, Testing, Administration and Implementation of OLAP and Client / Server projects using industry accepted methodologies and procedures.
• Expertise in Hyperion Planning, Hyperion Essbase, Essbase Studio, Essbase Integration Services, Financial Reporting Studio, Hyperion Reports, Web Forms, ESSCMD, Maxl, Excel Add - in, Hyperion Shared Services, Smart view and ODI.
• Good Hands-on experience on Implementations, Enhancements in Hyperion Planning, Essbase Integration Services, Essbase Studio and Hyperion Essbase.
• Very good hands-on experience in creating Hyperion Planning BSO Cubes from understanding Business requirements. Experience wif implementation and administration of Oracle Hyperion Planning cubes.
• Experience in creating ASO cubes using Essbase Studio and Essbase Integration services.
• Good expertise in planning and designing multi-dimensional cubes leveraging both ASO and BSO technologies.
• Complete hands-on experience in Hyperion Shared Services - creating users and groups, provisioning users and groups. Migration of application from one environment to another using Hyperion Shared Services LCM.
• Expertise in building Financial Budgeting and Forecasting OLAP applications wif Planning.
• Experience in creating Data Forms/Web Forms, Smart Lists, Calculation Scripts and Business Rules
• Very good experience in Production Support and Maintenance of Hyperion applications.
• Complete understanding of Incident Management using ServiceNow.
• Proficient in dynamically building dimensions, attributes, and shared members using rules files in an Essbase Outline by means of several build methods such as generation, level and parent-child references.
• Good hands-on experience in building Hyperion Planning metadata using Outline Load Utility, building Smart Lists using utility, automating Business Rules using Utility and Import/Export Planning security using Utility.
• Having broad understanding of database calculations such as implementing formulas on dimension members, dynamic calculations, developing calculation scripts and ESSCMD.
• Good experience wif Automation of Hyperion jobs using Autosys, Crontab and Windows Scheduler.
• Experience in knowledge transfer, preparing technical documentation, training the clients and business users.
• Very good experience in PL/SQL and Microsoft SQL, creating Stored Procedures, Packages, Creating Dimensions and Fact Tables.
• Understanding of complete Software Design Lifecycle.
• Trainer in Hyperion Essbase and Hyperion Planning - have conducted around 7 boot-camp trainings in Accenture to various levels of employees and received good trainer feedbacks.
• Created many training and guide documents for business users internally.
• Very good communication skills.

TECHNICAL SKILLS:

OLAP Tools: Oracle Hyperion Enterprise Performance Management (version 11.1.2.2), Hyperion System 9 BI+, Smart View, Excel Add-In, ESSCMD, MaxL, MDX and Hyperion Planning, ODI, Essbase Studio.

Databases: Oracle 9i/10g and MS SQL Server 2000/2005/2008

Reporting Tools: BI+, Hyperion Financial Reporting, Hyperion Web Analysis, Hyperion Reports, Hyperion Interactive Reporting, Hyperion Spreadsheet Add-in, Smart View and OBIEE.

Internet Tools: HTML, DHTML, XML,VB Script and Java Script.

Languages: SQL, PL/SQL, C/C++ and Shell Scripting.

Operating Systems: UNIX, Oracle Linux 5.0, AIX 5.0, Windows Server 2012 R2.

Automation Tools: Autosys Job Scheduling System, Linux Crontab and Windows Task Scheduler.

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, Atlanta

Hyperion Essbase and Planning Developer

Roles and Responsibilities:

• Implementation and Development of Hyperion Planning application/cube based on the Business Requirements.
• Upgrade and Migration of Oracle Hyperion EPM suite of products from version 11.1.2.2 to 11.1.2.4 in Windows 2012 and Linux servers.
• Work wif Business Users and Business Analysts to understand and gather requirements.
• Understanding of the Business requirement from Business Analysts, Client Manager and Business Users and converting them into Technical design documents.
• Build metadata for new application in Hyperion Planning.
• Loading metadata using Hyperion Planning’s Outline Load Utility.
• Loaded data into cubes using Rule files and Free-form data loading from text files.
• Created Security Groups and Users in Shared Services and Provisioning of users and groups.
• Metadata Hierarchy maintenance using Planning Workspace.
• Created Data Web Forms based on the business user requirement in Hyperion Planning.
• Maintenance of Security of entire Hyperion applications - Planning, Smart View, Essbase, HFM and Essbase Studio.
• Automating daily backups and running Business Rules using Linux Crontab and Windows Task Scheduler.
• Designed and developed Web Forms in Hyperion Planning.
• Migration of Planning application from DEV to UAT and finally to PROD using Hyperion LCM and Shared Services.
• Individual Support person of 4 Hyperion applications - Financial Statement cube, Employee workforce cube, General Ledger (GL) cube and Sub-ledger (SL) cube.
• Resolve Incidents/tickets, Issues and business users queries. Ensure smooth operation of Production environment.
• Involved in Data Forms and Smart View reports testing in UAT instance wif Business Users.
• Updated ASO Hierarchies and performed data loading using Essbase Studio.
• Build rule files, calculation scripts, report scripts, substitution variables for the BSO cubes.

Environment: Hyperion Planning 11.1.2.2, Planning EPMA Workspace, Hyperion Financial Reports, Hyperion Shared Services, Smart-View, and Excel Add-in, Essbase Studio, Oracle 10g, Oracle Linux, and Windows Server.

Confidential, UK

Senior Hyperion Essbase and Planning Developer

Responsibilities:

• Travelled to onshore at Newcastle, UK to understand and gain knowledge of the existing Hyperion system.
• Worked wif Client side SME and Business Users to understand the requirements.
• Complete Design and Development of Hyperion Web Analyzer reports as per the requirements.
• Understanding the existing applications, business reports, budgeting and finance in the Hyperion Essbase applications.
• Developed and Supported on Hyperion Essbase BSO Cubes.
• Production support and Maintenance of 3 Hyperion Essbase BSO applications.
• Ensuring smooth operation of Production environment.
• Maintenance and Support of around 90 reports in Hyperion Web Analyzer.
• Year-end, Month-end and Daily activities on Essbase applications like Data load, back-up, introduce new members, report generation, Outline build etc.
• Team Management, Service Management, Problem Management & Incident Management using Service Now tool.
• Enhancements of BSO cubes - adding new vehicles, adding new regions etc.
• Complete maintenance of security, assigning user access, creating groups using Hyperion Shared Services.
• Streamline the existing support activities - automating few tasks and batch jobs to minimize human intervention.
• Lead a team of 4 for Hyperion, ASP.NET, and K2.NET - get daily status and ensure smooth operation of support activities, Health checks, and house-keeping activities, monitor all activities, ensure on-call support for any Production Priority issues.
• Loaded Metadata build, Hierarchy Maintenance, running automaters for the changes dat comes under Quarterly and monthly basis.
• As a Support activity, performed data backups and restoration of the data.
• Involved in Monthly and Yearly Hierarchy updates, Substitution variables update and data refresh.
• Administer day to day maintenance and loading of Hyperion Essbase cubes wif fresh data. Re-run the jobs if they fail.
• Automated data loads using ESSCMDs and MaxL in both interactive and batch modes.
• Timely Resolution of Priority tickets wifout breaching SLAs.
• Preparing Technical Design Documentations.
• Providing status updates to Client manager and Accenture manager.
• Essbase Integration Services is used as the ETL tool to load data from Relational Database to BSO Essbase cube - Made changes in OLAP Metaoutlines and Metada Catalog in EIS.
• Automated the complete EIS build process.
• My role was of an offshore Lead and me directly coordinated wif Client Manager and Business Users.

Environment: Hyperion Version 9.x, Essbase Integration Services, Hyperion Essbase Administrative Services, Hyperion Web Analysis Reports, Excel Add-in, Hyperion Shared Services 9.3.

Confidential

Senior Hyperion Essbase and Planning Developer

Responsibilities:

• Development and Implementation of Hyperion Essbase BSO cubes.
• Understand Day-in-the-Life scenarios for various domains such as Utility, Investment Banking and Telecom and tan converting them into technical design reports and finally build Hyperion applications and reports around it.
• Design the solution for new applications.
• Learned new Oracle products such as Oracle Endeca Information Discovery (EID)which halps gain new insights by combining existing data wif unstructured data as well as big data.
• Complete of Installation and Configuration of Oracle Hyperion suite of Products 11.1.2.2 on Linux, Windows and Exalytics Machine - throughin-memory technologywif Essbase, Endeca and OBIA on Exalytics, clients achieve faster access to analytical insights and large volumes of detailed information.
• Have completely owned the infrastructure of Hyperion suite of products in the project.
• Done complete installation and configuration of OBIEE on Linux.
• Installation and configuration of Oracle Endeca.
• Application of Patches in OBIEE.
• Created all how-to documentations on Installations, Configurations and apply patches.
• Write Calculation scripts as per the requirements.
• Create Budgeting and Forecasting reports in Smart View.
• Worked and integrated Essbase wif OBIEE.
• Applications created were used for Demos in Oracle Open World 2012.
• Worked in Big Data.
• Create dummy data in Oracle database.
• Wrote PLSQL stored procedures to load data into staging area in Linux.
• Responsible for the complete Life Cycle Management of development and Production.
• Involved in Metadata Refresh to capture the new changes in the Hierarchy.
• Involved in User provisioning through Shared Services and creating security filters.
• Handling all Hyperion related technical issues and any data issues.
• Having knowledge and functional aspects on the business like business assets, Liabilities, Income Statement revenue expense accounts and profit and loss accounts.
• Designed Detailed Design Documents, Run books and Guides.
• Involved in Production Support.

Environment: Hyperion Planning, Hyperion Essbase Version 11.1.2, Hyperion Smart View, Oracle Endeca, Big Data, Oracle 10g, PL/SQL, Oracle Exalytics In-memory technology wif Essbase and OBIEE.

Confidential

Senior Hyperion Planning and Essbase Developer

Responsibilities:

• Understanding requirements for current release from Business Analysts and SME.
• Analyze current business process (As-Is) in the BRM (Business Review Meeting) application.
• Have done complete Implementation of the Essbase BRM (Business Review Meeting) Application Cube.
• Designed the Solution for new process to meet requirements (To-Be).
• Responsible for gathering requirements from Business Analyst.
• Developed the Essbase BSO Cube.
• Developed complete OLAP model (Star schema) in Essbase Integration Services.
• Extensively worked on SQL Server to build and modify the Dimension and Fact Tables.
• Extensively worked on creating stored procedures and packages in SQL Server.
• Created batch scripts and scheduled them and automating the process to run ESSCMD/Maxl to take regular backups.
• Created batch scripts to automate the EIS data load and building the hierarchy.
• Involved in making the Essbase backups and restores of Essbase application.
• Performed Performance tuning by using the dense/spares settings
• Complete owner of Hyperion application development, UAT testing and finally Go-Live (Production).
• Provided Post Go-Live Support.
• Provided Production support for Hyperion Applications.

Environment: Hyperion Essbase Version 11.1.1.3, Essbase Integration Services v11, SQL Server 2003, Microsoft Windows.

Confidential

Hyperion Essbase Developer and Administrator

Responsibilities:

• Single-handedly owned the upgrade project.
• A total of 6 Essbase BSO Cubes was upgraded and migrated.
• Understanding the present/current application architecture.
• Quickly learning the system and architecture.
• Complete upgrade of Existing 6 Hyperion BSO cubes from version 7 to version 9.3.
• Installation and configuration of Hyperion Essbase Server, EAS and Shared Services in DEV, UAT and PROD environments.
• Done configuration of LDAP.
• Backup of existing data, users list, calc scripts and rules files.
• Migration of Essbase Filters - Created Filters in EAS console, Created Groups in EAS console and Assigned the Filters to the Groups.
• Backup of critical data during the migration phase.
• Create users, securities in the new systems and validating wif the business users after each migration in respective environments - Data Validation was done using Essbase Excel Add-in and using a clone user.
• Created all the basic directories in each of the servers/environments following the norms and standards of MERCK.
• Created Windows Task Scheduler jobs (daemons) for Archival/backup process.
• Prepared the Technical Design Document for the complete project.
• Sending daily status emails to the client on the progress.

Environment: Hyperion Essbase Version 7.x, 9.x, Hyperion Shared Services, Essbase Administration Services, Oracle 10g, PL/SQL.

Confidential

Hyperion Developer

Responsibilities:

• Understanding the architecture of the in-house tool Automated Regulatory Reporting Tool (ARRT).
• Understanding the different requirements from various business users
• Attending calls/meetings wif the Business Analysts (BAs)
• Selecting areas of improvement
• Creating Technical documents of the reports
• Creating/Developing reports on PL/SQL, XML on UNIX
• SQL Performance Tuning for reducing query execution time therefore effective overall job efficiency
• Creating asset documents for the team members and new joiners

Confidential

Hyperion Developer and Support Analyst

Roles and Responsibilities:

• Owner of Production Support and Maintenance of the Greensheet Application - having 2 BSO Cubes.
• Resolve daily Production Issues/Tickets.
• Support a Monthly process where users compare the estimates wif the actual figures.
• Gathered requirements from Client SME for
• Wrote several Maxl Scripts to perform automation and load data, export data, and execute calculations as necessary.
• Wrote scripts in Autosys Job Scheduling Tool’s Job Information Language.
• Made changes in Essbase BSO Outline/Hierarchy due to merger of Bank of America and Confidential Lynch.
• Enhancements to Add New Business Units (BU) in the Hierarchy - Made changes in a complex PLSQL Package having 4 Stored Procedures.
• Created new PLSQL Package for Validation of the new BU.
• Involved in Building the dimensions dynamically. Created rule files for loading data.
• Created & provisioned the users, groups and assigned different levels of security wif necessary roles on applications using Hyperion Shared Services.
• Checked the logs and provided the resolutions related to support systems.
• Attended calls Client Manager for the daily and Weekly updates
• Optimization of Essbase Outlines, Data Loading, Calculation Scripts and Retrieval of Data from the cubes.
• Performed daily Data Health checks.
• Automated various tasks like build, load and Calc using Maxl Scripts.
• Automated the daily Data Health Check in Autosys which was being done manually.
• Involved in documentation on all Hyperion Enhancements processes for all business groups and Technical Documentation.
• Studied Essbase Studio and created a presentation for the client.

Environment: Hyperion Essbase Version 9.x, Oracle 10g, PL/SQL, UNIX AIX 5.0, Autosys Job Scheduler.

Confidential

Hyperion Developer and Oracle Developer

Responsibilities:

• Gather and understand the requirement
• Understand the existing architecture and system
• Analyze the Risk Free Rate and Dividend Yield (As-Is)
• Creating Technical Documents
• Writing/Developing the stored procedures and functions/
• DBA activities like backup of data, restore database, creation of database in MS SQL Server 2000
• Complete Unit Testing and UAT Testing.

Environment: Microsoft SQL Server 2000.

Confidential

Oracle and Crystal Reports Developer/Expert

Responsibilities:

• Extensive Analysis and Assessment of 165 Crystal reports.
• Analysis and study of the As-Is (current) reporting system.
• Get list of all reports from the several of the Lines of Business, SMEs and Client.
• Have meetings wif various stakeholders and SMEs to understand the Current (As-Is) state of all reports.
• Challenge was every Line of Business having different data source, such as, Oracle and MS SQL Server.
• Reports residing on different staging areas.
• Prepare complete Technical Design Documents of all the 150+ reports.
• Owned all Database activities like back-up/restore of databases, installation of various databases (Oracle, DB2 and SQL Server2000), creation of schemas, loading of objects & data, managing database objects, such as tables, indexes, stored procedures and views and tuning database performance, backing up the database and performing recovery operations when necessary.
• Designed and developed reports in Cognos BI.
• Unit testing and UAT testing of reports.

Environment: Cognos BI 8.3, MS SQL Server 2000, IBM DB2, Oracle10g Database.

Confidential

Consultant and Developer.

Responsibilities:

• Analysis & design of the requirement
• Major changes in UI screens in Flexcube – using XML and Javascript Language
• Preparation of test cases and testing them single-handedly.
• Production Support & UAT support.
• Domain knowledge sharing wifin & across projects.
• A client specific requirement for developing the Flexcube (me-flex’s flagship software) where changes had to be made in the Loans & Current & Savings A/C Module.
• Study and analysis of the current working of how an account number is generated in Flexcube
• Complete study and analysis of dependent Lines of Business like Loans account.
• Completely owned this major change – making changes in major code in the Product involving important Stored Procedures, JAVA, Javascript, XM and XSL.
• Installation/Qualification of flexcube on Red Hat Linux 4.0 and zLinux.
• Complete and thorough research and Development activities like installation/implementation of flexcube on IBM WAS6.0/Oracle10gAS on Unix/Linux
• Bugs fixing in the install utility source code
• Helping members from various teams wif installation activities
• Performed DBA tasks such as Installing of database, creating Oracle databases/schemas and performing upgrades of the database to new release levels.
• Changes in many PL/SQL functions, stored procedures and packages.
• Preparing analysis document, design document and unit test plan. End-to-end development of the modules
• Post-Production Support & UAT support.
• Understanding the Multi-Entity requirements – Understanding the approach used for Flexcube Multi-Entity.
• Understanding concepts such as Oracle’s VPD (Virtual Private Database) and Multi-time zone (hands-on)
• Making changes in the code – tables/views, changes in middleware code in java;
• Complete End-to-end testing of the Product.

Environment: SQL Plus, PL/SQL Developer 7.0, IBM WSAD 5.3, Windows2003 Server, Oracle9i, Red Hat Linux, C/C++, JAVA, XML Language, SQL Navigator, Crystal Reports10.