SUMMARY:

• 15+ Years of extensive experience in IT, Project Management including 12 Years in Hyperion EPM and Business Intelligence Products.
• Certified Scrum Master
• Pursuing PMP .
• Highly efficient in managing Onshore /Offshore Team and collaborate with other Teams.
• Extensive experience in working with a range of Hyperion products including HFM, Hyperion Planning, FDMEE, Essbase Integration Services (EIS)/ Essbase Studio, SmartView and Spreadsheet Add - In in both Windows and UNIX environments.
• Possess a good understanding of all phases of the Software Development Life Cycle and Use Case Methodologies.
• Experience in Technical Documentation Write-up,
• Solid understanding of multidimensional and relational database architecture; Extensive knowledge of planning, budgeting, and forecasting procedures.
• Proficient in managing and administering the use of numerous Hyperion, OBIEE, CXO, QlikView, applications / Dashboards.
• Applied in-depth understanding of star schema and modeling techniques to develop OLAP models and meta-outlines using relational database sources.
• Extensive experience in creating, maintaining, and supporting all application objects including outlines, calculation scripts, rules files for dimension builds and data loads, partitions, and security objects through both Analytical Integration Services (EIS/AIS), Analytical Administration Services (AAS) and MaxL scripts; Also involved in automation of these procedures using batch scripts.
• Extensive experience with Installation/ Upgrade of EPM Suite (11.1.1.2,11.1.1.3,11.1.2.x )
• Experience in Financial Reporting, 9.3.1,11.1.1.x,11.1.2.x Tools.
• Highly skilled in performance monitoring, tuning, and optimization. Played an active role in debugging procedures by developing and implementing test cases.
• Demonstrated ability to work as part of a team to analyze complex business requirements and translate them into business intelligence solutions.
• Strong Knowledge of RDBMS concepts and design.
• Excellent communication, interpersonal and business interaction skills

TECHNICAL SKILLS:

Operating System: HP-UX, AIX 4.3/5.1, LINUX (Red Hat Enterprise Server), Sun Solaris 5.10, WINDOWS XP, Windows 2003 R2, Windows 2008 R2

RDBMS: ORACLE 8i/9i/10g/11g

Reporting Tools: Hyperion Reports(HPS/IR/Financial) 7.x/9.x, Hyperion Analyzer 7.x/6.x/ 9.3.0/9.3.1 Excel Spreadsheet Add-In, OBIEE 10.1.3.4, QlikView 11, CXO 5.x

OLAP TOOLS: System 9 BI+, Hyperion Essbase 7.x/9.3.1, Essbase Integration Services 7.x/9.3.1,11.x, EPM Essbase 11.1.1.x/11.1.2.x, Hyperion Planning 11.1.2.x, HFM Hyperion DRM, Informatica MDM 9.5.1

Languages: MDX, MaxL, ESSCMD, SQL, PL/SQL, UNIX Shell scripting, Java scripts, HTML, PHP, C#, .Net, Java, ODI

Modelling Tools: Rapid SQL,TOAD,Pl/SQL Developer,ERWIN, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Sr Hyperion Solution Architect

Responsibilities:

• Designing the prototype of BI Architecture, defining roadmap, gathering business requirements and deploying the Hyperion & BI applications.
• Architecting installation and upgrade projects for Hyperion ( HFM, Planning, FDMEE, Essbase, Reports ) and BI products (OBIEE ) from 11.1.2.3 to 11.1.2.4 on distributed environment with clustering and High Availability.
• Expert in Essbase performance Tuning
• Setup Automated TLOG for Essbase to reover from any kind of data loss.

Environment: Informatice 9.6.1, QlikView 11, Qlkiksense 2.0, EPM Hyperio suite 11.1.2.4, Hyperion DRM 11.1.2.4, FDMEE 11.1.2.4, SQL server 2012, Linux, Oracle 12G, SQL Server 2016, PowerBI, OBIEE 12c

Confidential, Plano, TX

EPM Solution Architect / Manager (Hyperion)

Responsibilities:

• Designed the prototype of BI Architecture, defining roadmap, gathering business requirements and deploying the Hyperion application
• Working closely with FP&A Team to manage end to end Reporting process.
• Designed, Planned, installed, configured and implemented EPM 11.1.2.3.500 within CA Finance Domain .
• Managing Onshore/Offshore Team to ensure Project is delivered on time.
• Successfully executed the upgrade Project of Hyperion EPM 11.1.2.1.102 using clustering (failover) technology and involved in applying Patches as per requirement.
• Re-engineer the BI / DWH Application including Hyperion / Business Objects / QlikView / CXO Cockpit / Informatica / Power BI etc to provide technological solution to achieve company’s business goals.
• Highly skilled in defining / designing and adopting new technologies / Innovation to support Business.
• Established a Mobile BI (Hyperion Essbase / HFM ) dashboard reporting for iPhone / iPad using cxo-cockpit for senior Management.
• Leveraging BI Concepts and tools for Data Quality and Data Governance using Hyperion DRM and Informatica MDM tools.
• Involved in creating Security Audit Reports for utilization of Hyperion System used for SOX Compliance.
• Involved as a SME in Performance optimization, monitoring and tuning of overall Hyperion System.
• Main point of contact for Business Super Users and BSA’s.
• Highly efficient in improving Performance of Applications in a cost effective and efficient way.
• Defined enterprise-wide processes, roles and methods for integrated technology strategy for various Applications and worked with various business and IT groups to ensure implementation.
• Actively engaged with stakeholders to communicate issues/changes regularly in order to minimize impact.
• Effectively managed execution of processes defined and ensured projects are complete and current.
• Effectively managed multiple projects by multi-tasking to ensure all the projects meets defined roadmaps/budget/deliverables.
• Worked with Chief of Engineering and senior Business and IT leadership for preparation of business case and formulation of systems strategy based on business goals and objectives
• Led formulation of policies, procedures, standards and guidelines, definition and deployment of controls
• Architected cross team collaboration solutions to enable teams to work across geographies. Solutions included various channels like emails, blogs, discussion forum, and shared library with multimedia content.

Environment: MS Windows 2008 R2 Server, EPM Hyperio Planning, HFM, FDM, Essbase 11.1.2.1/ 11.1.2.3.500, Excalytics, Essbase Administration services 11.1.2.3.500, Smart View 11.1.2.4, Financial Reports 11.1.2.3, SQL server 2008, Oracle 11g, Informatica 9.5.1, CXO Cockpit 4.3.4, QlikView 11, Business Objects 4.0, ODI 11g, introscope, wily, SVN, Hyperion DRM 11.1.2.3.500, MDM 9.5.1

Confidential, New York, NY

Application (Hyperion) Manager

Responsibilities:

• Responsible for gathering business requirements, defining, designing Blue Print, developing, testing and deploying the application
• Involved in the entire SDLC implementation of the Hyperion Planning and Essbase applications.
• Implemented Hyperion Planning and developed web-based forms for the various budgeting purposes and implemented whole security matrix in Hyperion Planning.
• Involved in Performance optimization and tuning of calculation times.
• Responsible for handling the day to day Hyperion environment by Processing security requests such as adding and removing authorized users, scheduling and monitoring processes and handling user questions.
• Involved in creating ad-hoc reports using Smart View.
• Designed a DR strategy for Hyperion System.
• Worked on QlikView to generate PnL Reporting.

Environment: MS Windows 2003 R2 Server, EPM Hyperio Planning and Essbase 11.1.2.0, Essbase Administration services 11.1.2.0, Smart View 11.1.2.0, Financial Reports 11.1.2.0, Oracle 11g, ODI, QlikView 10, SVN

Confidential, New York, NY

Sr BI (EPM) Analyst Lead

Responsibilities:

• Involved in gathering requirements, designing and developing the project plan.
• Involved in developing design specifications of Essbase cube with Customers.
• Managing a Team of 5 onshore and 4 offshore Developer/analyst as a Lead.
• Acted as a liaison between the Reporting and Analytics development team and the finance team to translate the business ideas into a working Hyperion Essbase model.
• Involved in creating a ASO and BSO Cubes using both techniques Analytical Integration Services (AIS) and Essbase admin Services (EAS).
• Automated Essbase operations through ESSCMD and MAXL Scripts in shell scripts to run Monthly/Daily PnL Reporting, Balance Sheets and Ledgers.
• Developed Rules Files and Report Scripts for Data Load and dimension builds.
• Developed complex CALC scripts to meet the business needs in Essbase cubes.
• Developed OLAP Models and Meta outlines using EIS from STAR Schema.
• Optimized the Essbase Applications to bring down the data load, runtime, retrieval and calc process.
• Created Users and Groups in Hyperion Shared Services and assigned privileges to them. Applied security on different applications by creating Filters on its dimension members. Migrated Essbase server into newer versions and newer operating systems.
• Extensive experience with LCM utility.
• Worked on Installation, configuration and Migration of Hyperion EPM 11.1.1.2 to 11.1.1.3
• Performed Stress Test using Load Runner on Hyperion Essbase, Shared Services and Workspace by replicating multi users to run query on database to analyze Server / Essbase Query / Workspace Load and Network Performance.
• Responsible for providing technical and production support for live applications and also for end users.
• Daily monitoring of Hyperion Essbase jobs using Control M and troubleshoots the cause of the errors if any.
• Extensive experience in creating, Managing Financial Reporting.
• Expert in optimization of database, calc scripts, cache setting and memory management.
• Involved as a SME to provide L-3 Production support for various Essbase, FR, Workspace and OBIEE issues.
• Worked on OBI Servers and support OBI Admin tasks.
• Created Data Model using star Schema and designed Business and Presentation Layers.
• Extensive experience on working with OBIEE 10.1.3.4.0 /10.1.3.4.1
• Worked on OBI Delivers to generate iBOTs .
• Worked on Cache Manager to improve the performance of Dashboard

Environment: MS Windows 2003 Server, UNIX sun solaris 5.10, Hyperion Essbase Administration services 7.1.6/ 9.3.1/11.1.1, Essbase Studio 11.1.1 Excel Spreadsheet Add-In, Financial Reports 7.x,Hyperion Planning, Oracle 10g/11g, ODI, OBIEE 10.1.3.4.0 /10.1.3.4.1, Quality Center, SVN, Control-M, HP Load Runner 9.5x/11, JDBC, ODBC, Rapid SQL

Confidential, Irving TX

Sr Essbase/Hyperion Analyst

Responsibilities:

• Worked on complete Project Life Cycle that includes requirement gathering, development, testing and production support.
• Acted as liaison between Business users and IT group as a Analyst.
• Involved in gathering requirements, designing and developing the project plan as a Architect.
• Created a ASO and BSO Cubes using both techniques Analytical Integration Services (AIS) and Essbase admin Services (EAS).
• Worked on Hyperion planning 9.3.1/11.1.1 to implement Budget Cube, Created Wave Forms.
• Designed the workflow in Hyperion planning 9.2/9.3.1/11.1.1.
• Have worked in Workspace tools for planning and uploading reports to view users.
• Involved in making web data entry web forms to allow the business users to directly input projections and adjustments into the Hyperion Planning application for LRO.
• Developed OLAP data Models and Meta outlines using EIS from star schema/snowflake schema in relational databases.
• Designed the Drill to Detail Functionality available in AIS 9.3.1/Essbase Studio 11.1.1.
• Played a integral role to migrate the Essbase system from version 7.x to 9.3.1 to 11.1.1
• Worked on MDM / DRM to manage the Dimension Hierarchy.
• Developed Rules files to upload data/metadata from financial system’s database to Essbase cube.
• Performed data loading from external sources to populate the database by free form data load method or rules file to plot values to the outline.
• Used LOCK and SEND Techniques to load the Data in the cube and calculate the FX rates on the fly for BUDGET cube.
• Designed and developed Aggregate Storage Cube using Essbase and optimized application to cut down load time and database size considerably, and to support a larger number of members.
• Implemented robust data-access security and user management.
• Extensively involved in migration of reports from the development to the production environment.
• Developed Maxl scripts and rules files to work with all database objects including outlines, formulas, caches, and security profiles; also designed calculation scripts, and batch files to automate data load and other maintenance procedures.
• Developed Calc Scripts for BSO cubes.
• Experience of Migrating the BSO cubes to ASO.
• By using BI+ Created Financial Reports, Web Analysis and Interactive reports for end user.
• Worked on ODI for ETL purpose and hands on experience on different knowledge modules
• Created a Groups and Filters using Shared Services.
• Modified Essbase configuration files to load the data using Multithreading techniques for better performance to work with all related application objects, aggregations, partitions, caches, and disk volume allocations.
• Regularly monitored performance and carried out optimization and fine-tuning tasks, provided troubleshooting services and assistance to end-users in resolving errors.
• Created various reports for users in OBIEE.
• Extensive experience with OBI Dashboards.
• Involved in customizing Oracle PL/SQL stored procedures, functions, packages, SQL scripts to facilitate the ad hoc requirement of Essbase.

Environment: MS Windows NT 4.0, UNIX,Linux, Hyperion Essbase Administration services 7.1.6/ 9.3.1/11.1.1, Essbase Integration Services 7.1.2/9.3.1, MDM, Excel Spreadsheet Add-In, Financial Reports 7.x, HPS 7.x/Interactive reports 9.x,Hyperion Planning, Oracle 10g, Toad, ODI, OBIEE 10.1.3.4.0, Autosys

Confidential

Software Engineer

Responsibilities:

• Developed Reporting cubes using Hyperion Essbase 6.x (BSO)
• Developed various cubes using application manager.
• Involved in installation and upgrade of Hyperion Essbase Products.
• Involved in dynamic dimension building and modifying outlines.
• Optimized dense and sparse database settings for improving retrieval times of Essbase Cubes
• Loaded data from flat files, Excel sheets, and SQL interface.
• Developed Excel Templates for user interface in Essbase database.
• Writing Pl/Sql procedure.
• Optimizing and Tuning the PL/SQL Procedure.
• Generated a Report using Oracle Reports 6.0
• Preparing Technical Documentation and Presentation as per Requirements.

Environment: Oracle 8i/ 7.x, running under HP-UX 11.0/10.20, Windows NT 4. Hyperion Essbase 6.5.4/7.1.5, Hyperion Reports 6.5/7.2, Erwin, TOAD, Java scripts, Java