SUMMARY

• Over 9 years of experience as a Hyperion Developer/Analyst and Business Analyst wif strong analytical and leadership skills.
• Extensive experience in various industry sectors, including Information Technology, Retail, Banking, Healthcare and Finance.
• Expertise in handling and delegating tasks, making sound decisions, and producing quality work.
• Highly experienced in multi - dimensional OLAP/Business Intelligence data-source building and front-end financial/sales/customer reporting solutions
• Extensively worked wif Hyperion 11, Hyperion System 9 products such as Essbase, Planning, Financial reporting, ODI, HFM and Web Analysis
• Used various ERP tools to manage monthly financial consolidation process
• Collected data by understanding business flow and interviewing the users
• Experience in Excel based custom reporting solutions using Smartview for Essbase and HFM
• Experience designing and deploying OLAP solutions
• Provided financial solutions, including: P&L, Balance Sheet, Actual Vs Budget, Forecasting, Product Analysis, Customer Service Analysis
• Experience wif Hyperion Essbase in the areas of design, deployment, and administration
• Experience in installing and configuring Oracle Hyperion EPM Suite 11.x and Patching.
• Ability to work closely wif Finance users, Testing teams, IT Teams, cross-functional teams, off shore teams and external vendors
• Excellent understanding of Software Development Life Cycle (SDLC)
• Involved in data mapping between different data models
• Experience wif Oracle SQL and PL/SQL using SQL*PLUS
• Good understanding of Object Oriented Analysis and Design (OOAD)
• Versatile team player wif excellent analytical, presentation and interpersonal skills wif an aptitude to learn new technologies.

TECHNICAL SKILLS

Databases: MS Access, SQL Server, Oracle 11, 10g/9.x/8.x/7.x/6.x

Tools: Hyperion Essbase 11.x/9.x/7,x, Essbase Integration Services/Studio, 11.x/9.x/7.x, Hyperion Planning System 11.x/9.x, Hyperion Financial Reporting release 11.1/9.3, ODI, DRM, HFM, Hyperion Smart View, Excel Add- in, Crystal reports

OS: Windows, UNIX

Others: MS Office, MS Tools, MS Visio, Test Director, Quality Center, MS Projects

PROFESSIONAL EXPERIENCE

Hyperion Consultant

Confidential, IL

Responsibilities:

• Developed Essbase cubes and Planning application replacing the existing excel based forecasting/budgeting/Planning system
• Optimized cubes and calc scripts to improve system performance and data processing time
• Developed web forms and Business Rules for planning application and supported Planning process as an administrator
• Developed ODI integration for loading actuals
• Supported system in identifying issues, root cause analysis and providing solutions.
• Performed security administration role to maintain users/groups/access control
• Involved in system upgrades and client installations based on users requirements.
• Made extensive use of Hyperion Essbase ASO and BSO calculation models, MDX calc scripting, MaxL scripting, database optimization and Excel Essbase Spread sheet Toolkit.
• Worked heavily wif senior management end users to define scope requirements for new systems and enhancements.
• Created various FR and IR Reports for HFM, Planning and ODI.
• Provided technical assistance and support to end users and documented the process.
• Documented Hyperion system processes and was responsible for complete system documentation and training
• Troubleshooting Essbase database partitioning related issues and data-load on partitioned cubes
• Helped business users in data reconciliation and validation during the accounting and financial close periods.
• Support for issues based on dimension Build Rules; Data Load Rules; Calc Scripts
• Worked extensively on Financial Reporting to build complex reports and replace their existing excel spread sheet reports

Environment: Oracle/Hyperion EPM system (11.x), (Essbase, Planning, Financial Reporting, Web Analysis, Excel-Add-in, Smart View, EAS, Studio, ODI, HFM), Oracle

Hyperion Consultant

Confidential, Dearborn, MI

Responsibilities:

• Acted as a liaison between the technology and business areas of the organization. Involved in gathering requirements, functional specifications, designing documentations, testing strategies and developing a project plan.
• Interaction wif finance and accounting customers who possessed various levels of technical knowledge.
• Assess new Business needs/ initiatives and translate them into detailed business requirements specifications.
• Worked closely wif IT and finance/accounting teams to resolve issues, upgrade, develop, test, and implement financial systems.
• Develop, derive, clarify and review functional specifications and User cases.
• Restructured and redesigned previous Essbase cubes. Maintenance of previous Essbase cubes.
• Developed Batch and Rules files to load data from financial system’s database to Essbase cube. Created and scheduled batch jobs for complete automation processes for nights and weekends application refresh and backup.
• Responsible for DBA functions such as users/groups creation, security profiles and application access to different groups.
• Developed star schema for the OLAP model, and created EIS Meta-outline for the Essbase cubes
• Developed and optimized outlines by grouping and positioning developed rules files for dimension building and data loads. Involved in performance-tuning wif Hyperion Analytic Services (Essbase) multidimensional databases including Outline, Rule Files, Calc Scripts, Reports, database optimization
• Creating shell script and MaxL script for automation of the Data load and dimension build process daily and weekly basis
• Extensively used SQL connect for dimension building and data loading.
• Involved in providing security authentication for the users of Hyperion Planning and maintaining workflow management process
• Involved in development of a data mart and develop an essbase application wif drill through functionality using Essbase integration services
• Version Control Management using PVCS and Documentation of new implementation as well as changes
• Responsible for Data tie out and Data Validation during Accounting close
• Responsible for Maintenance of End User Security and Feeder file security for Hyperion Essbase Applications
• Performed Administrator activities to maintain security, database recovery etc
• General system maintenance and support activities that include modification of calc scripts/report scripts/load rules as per requirement, analysis of production issues and issue resolution
• Timely resolution of clients/customer’s needs during monthly financial closes for the Corporate Finance group

Environment: Hyperion Essbase 9.2/ 7.1/6.5.4, Hyperion Reports 7.0, Hyperion Integration Services, Hyperion Administration Services, Hyperion Analyzer 7.0, MAXL, ESSCMD, Excel Add-In, MS Project, Windows NT/2000.

Hyperion Consultant

Confidential, Farmington Hills, MI

Responsibilities:

• Developed several OLAP cubes and outlines, complex calculation scripts, data extracts and load rules in Hyperion Essbase
• Extensively involved in design and automation of Essbase cube building process through MaxL
• Added alias tables to Essbase cubes through MaxL script as per the client’s requirements
• Heavily involved in month end maintenance and support of the Hyperion Essbase cubes
• Assisted in the development of Planning Cubes for planning and forecasting purpose and also synchronized Planning and Essbase application
• Successfully handled database partitioning and user account creation function
• Created multiple users groups for different business segments and assigned security filters Essbase privileges
• Handled performance tuning and troubleshooting function in Essbase applications
• Developed batch scripts using MaxL and ESSCMD for loading data into Essbase cube
• Involved in migration of reports from the development to production environments
• Extensively used automated Excel templates for data loading and retrieval, using lock and send command
• Created and customized numerous Calc Scripts for data aggregations, allocation and rollovers
• Provided training to IT support staff and different user groups on weekly, monthly, quarterly and yearly Data and Reports rollup
• Developed several Batch scripts, Calc Scripts, MaxL Scripts for data loading and calculation automation
• Involved in database outline, data loading and calculations optimization and performance tuning
• Created several reports in MS Excel-worksheet through Essbase Excel Add-In functionalities
• Created batch scripts for loading ASO and BSO cubes from data warehouse on monthly basis
• Supported business wif Sarbanes-Oxley audit and documentation

Environment: Hyperion System 9.3.1 (Essbase, Financial Reports, Web Analyzer, Excel Add-in, Essbase API), Windows, Oracle

Essbase Developer

Confidential, Chicago, IL

Responsibilities:

• Designed and developed reports for Budgeting and Forecasting purposes facilitating Gross to Net applications.
• Involved in interacting wif users to gather requirements, understand business needs and ensure applications met the required changes.
• Developed and optimized outlines by grouping and positioning, developed rules files for dimension building and data loads
• Developed outline formulae, calc scripts; Developed MaxL and batch scripts to automate dimension build, data loading, backups and other Essbase processes.
• Responsible for Maintenance, Optimization & performance tuning
• Developed complex financial reports P&L, balance sheet, Cash Flow
• Modified and developed existing financial reports using Hyperion Reports.
• Involved in testing tasks and validating reporting data by retrieving through excel Add-in
• Automation of Quarterly, Monthly and Annual reports.

Environment: Hyperion Essbase 7.0, Hyperion Reports 7.0, Hyperion Analyzer 6.5, Essbase Spreadsheet Add-in, MS SQL Server 2000, Windows NT.

Business Analyst

Confidential, Kansas City, MO

Responsibilities:

• Participated in requirement gathering, analysis, and design.
• Participated in gathering user requirements, developing functional and non-functional requirements and technical specifications.
• Developed use cases/diagrams, conceptual model, behaviour diagrams (sequence, collaboration, state chart, Activity), using MS Visio.
• Created test strategy, test plans, test cases and test scripts
• Defect tracking and reporting through test director.
• Responsible for the delivery of Business Requirements Documents (BRD) wifin project timelines.
• Responsible for paper prototyping of the interface and usability testing
• Scheduled and join Net meetings for project related training.
• Formulating the TO-BE features based on the business requirements and pain points.
• Participated in conducting quality assurance activities and improvement concerns.
• Created and updated project status, requirements, and diagrams using RUP methodology.
• Extensively involved in coming up wif test specifications for the application.

Environment: UML, RUP, Test Director, MS Visio, Net Meeting, MS Office, MS Projects