SUMMARY:

• Over 9 years of IT experience and 8+ years of experience in OLAP/Business Intelligence.
• Extensive experience in Installation, Configuration, Maintenance, Patching Oracle EPM/Hyperion stalk of applications
• Essbase, Hyperion Planning, Data Integration Management, Profitability and Cost Management, ODI.
• Hands - on experience in all phases of Software Development Lifecycle (SDLC) using Waterfall, Iterative, Agile, RUP (Rational Unified Process), and other internal SDLCs and technology delivery frameworks.
• Excellent skills in Business Analysis, Data Analysis, Requirement Analysis, Business Process Reengineering, Automation.
• Highly proficient in creating Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class Diagrams etc.
• Worked extensively on Business Requirements Elicitation, Process Modeling, Gap analysis, Risk analysis, SWOT analysis and development of Functional SpecificationsExperienced in installation and configuration of Oracle 11 EPM 11.x on windows, Linux and AIX environment
• Involved in different Hyperion planning application integration with Mainframe and HPCM to support driver-based systems.
• Worked on scheduling jobs through, .bat files, Hyperion DIM, Autosys, ODI, Ctrl+M and Windows Scheduler
• Knowledge of integrating the Microsoft Office tools with OLAP Server.

TECHNICAL SKILLS:

Domain Expertise: Hyperion Planning and Essbase

Analytics: Hyperion Planning (11.x/9.x), Hyperion Profitability and Cost Management (11.x), Hyperion Data Integration Manager (Informatica 7.1), Oracle Data Integrator, Hyperion Essbase (11.x/9.x), Excel Add-In, Essbase Administration Services, H.A.L., ESSCMD, MaxL

Databases & Tools: Oracle 9i/10g, SQL Server 2005/2008, Informatica 7.2

Reporting Tools: Financial Reporting, Web Analysis, Interactive Reporting, Hyperion Spreadsheet Add-in, Smart View.

Operating Systems: MS-DOS, RHEL4.5,UNIX, WINDOWS 2003/2008/NT 4.0/XP/7, IBM AS400 Mainframes.

Programming languages: SQL, PL/SQL, C, C++, HTML, DHTML, XML

Oracle EPM Consultant

Confidential, NC

Responsibilities:

• Installation, configuration of Oracle EPM stalk of applications on linux and windows.
• Load balancing, clustering, load balancing and patching of EPM application servers.
• Maintenance of EPM applications deploying patches on EAS, Essbase, Smartview and Planning.
• Designed, developed and trained users on SmartView Templates for BFO efficiency project.
• Develop business rules, Calc script, planning artifacts such as Forms, Smart lists, custom menu options etc
• Designed, developed and optimized the Essbase data loads and metadata loads.
• Performed enhancements for data transfer between cubes through partitions and calc scripts.
• Created enhancements to business processes, by implementation automation using Shell scripts, Maxl Scripts and Cron Jobs.
• Developed ODI interfaces for Metadata, Data refreshes of planning applications.
• Developed ODI workflows to Extract, Load, Transform and alert the users with progress on business process automations.
• Extended the functionality of existing Planning application by adding custom artifacts for BFO Team.
• Performed migration of essbase applications from 11.1.1.3.1 to 11.1.2.1
• Automation of business processes through Cron, Autosys and ODI.

Environment: Oracle EPM Planning 11.1.2.1, Oracle Essbase 11.1.1.2.1 , Essbase 11.1.1.3.1 Hyperion Financial Reports 11.1.2.1, Hyperion DRM, Hyperion Strategic Finance, Shared Services, SmartView, Excel Add-In, Autosys, Unix, MAXL, Oracle 11i, ODI, WindowsServer 08, RHEL 5.3

Hyperion Application Developer

Confidential, GA

Responsibilities:

• Administration of Hyperion Essbase applications, ASO and BSO.
• Worked FPRA team, to develop reporting requirement and financial reports for the group control
• Developed business rules and calc scripts for Financial Analysts and Group Control team.
• User group maintenance and administration of security for Essbase and planning applications
• Designed and developed multiple BSO applications for Headcount, In House Temporary Workers.
• Developed Financial Reports for the executive governing body of the company.
• Installed and configured ODI Metadata Navigator for use with ODI processes.

Environment: Oracle EPM Planning 11.1.2.0, Oracle Essbase 11.1.1.2.0 , Hyperion Financial Reports 11.1.2.0, Shared Services, SmartView, Excel Add-In, JDE GL, MAXL, Oracle 11i, ODI, Windows 2008 R2.

Hyperion Application Consultant

Confidential, FL

Responsibilities:

• Provided additional help on design challenges, trouble shooting on installation and configuration and infrastructure issues
• Worked IT leads, Business SME’s and end users to design, develop requirements and recommended suitable implementation options
• Interacted with business users in optimizing and designing web forms and business rules for Hyperion Planning application.
• Worked on migration and testing of Essbase cubes from 7.1.5 to 11.1.2 from a legacy UNIX environment to a windows environment.
• Designed and developed Business rules, validation scripts and calculation scripts for Hyperion Planning application.

Environment: Oracle EPM Planning 11.1.2.1, Oracle Essbase 11.1.1.2.1 , Hyperion Financial Reports 11.1.2.1, Hyperion Smart View, Shared Services, Excel Add-In, Calc Manager, MAXL, Oracle, Windows 2003, 2008 R2, Redhat 4.5, AIX 6.1

Hyperion Consultant

Confidential

Responsibilities:

• Provided additional help on design challenges, trouble shooting on installation and configuration and infrastructure issues
• Worked IT leads, Business SME’s and end users to design, develop requirements and recommended suitable implementation options
• Interacted with business users in optimizing and designing web forms and business rules for Hyperion Planning application.
• Worked on migration of Essbase cubes from 7.1.5 to 11.1.2 from a legacy UNIX environment to a windows environment.
• Created product automation scripts with MAXL, shell scripts and batch scripts to automate data load and data extractions
• Designed and developed Business rules, validation scripts and calculation scripts for Hyperion Planning application.

Environment: Oracle EPM Planning 11.1.2.1, Oracle Essbase 11.1.1.2.1 , Hyperion Financial Reports 11.1.2.1, Hyperion Smart View, Shared Services, Excel Add-In, Calc Manager, MAXL, Oracle, Windows 2003, 2008 R2, Redhat 4.5, AIX 6.1

Hyperion Essbase Consultant

Confidential, Florida

Responsibilities:

• Worked extensively on design challenges for implementing HPCM business requirements without compromising on the functionality of the cost allocation system.
• Created overview documentation to understand the scope and challenges of implementing ROSA calc on Hyperion applications.
• Involved in tuning the applications for better performance by modifying the server side, application, and database settings.
• Developed and strategically implemented, interface to deploy metadata from Planning to HPCM application.
• Worked extensively using Hyperion DIM to develop data preparation and cleansing while interfacing with Mainframe AS400 system
• Design and develop Web Analysis for the purpose of accessing the on line reports by the users. Used Maxl scripts and batch scripts to automate calc scripts and Meta data transfers.
• Involved in providing security authentication for the users of Hyperion Planning, Financial Reporting (FR) and maintaining workflow management process.

Environment: Oracle Hyperion Profitability and Cost Management, Hyperion DIM, Oracle EPM Planning 11.1.1.2, Oracle Essbase 11.1.1.2, Hyperion Reports 11.1.1.2, Web Analysis, Hyperion SmartView, Services, Excel Add-In, MAXL, Oracle, Windows 2003, CTRL+M

Hyperion Developer

Confidential, Pawtucket RI

Responsibilities:

• Developed outlines, Calc Scripts, data rules for loading dimensions and data into Essbase cube.
• Analyzed source systems to understand the relational repository needed to develop start schema in EIS.
• Developed OLAP model and Meta outline in EIS and deployed the cube.
• Developed SQL to generate user defined tables in EIS.
• Developed Essbase outline formulas and CalcScripts using advanced CalcScripts functions.
• Debugged and optimized data loading by grouping, positioning.
• Responsible for performing the Monthly and weekly Security Refresh of Users and Groups.
• Allows users to create a variety of flexible, easy-to-use displays by using Web Analysis.
• Produced ad-hoc reports by Web Analysis.
• Prepared Profitability Reports, which detail Unit Cost, Price and Volume Trends, and Expense Variances over prior periods.
• Involved in defining requirements, functional specifications, designing documentations and testing strategies.

Environment: Hyperion Essbase 9.3, Essbase Integration Services, Hyperion Web Analysis, Excel Add-In, Hyperion Planning 9.3, Hyperion Reports 9.3, H.A.L., Oracle, Windows NT/2000 and UNIX SUN Solaris 7.

Hyperion Developer

Confidential, New Jersey

Responsibilities:

• Involved in gathering the requirements, Architecting, analyzing, design, develop and deploy interfaces used for Hyperion Intelligence, Essbase database and to generate reports using Hyperion performance Suite and Excel Report.
• Analyzed user requirements and involved in the process of finalizing dimensions for cubes.
• Design and maintenance of Essbase and Planning Applications.
• Security and user access management in Hyperion.
• Assisting end users in budgeting through calculations and business rules.
• Monthly reports and scheduled tasks maintenance.
• Updating the applications and data uploads based on end user requirement
• Optimizing the environment for better performance in less time.
• Maintain current knowledge on business performance management products releases from Hyperion and related technology

Technical Environments: Hyperion Essbase 9.3, Hyperion Planning 9.3, Hyperion Reports 9.3, Hyperion Essbase Application Manager, Hyperion Integration Services, Hyperion Administration Services, Essbase Excel-Add-in, SQL Server 2000, Windows 2000/NT 4.0

Hyperion Analyst

Confidential, Chicago, IL

Responsibilities:

• Supported corporate and divisional users to ensure timely and accurate collection and consolidation of financial and operational data in Hyperion Essbase applications.
• Designed and developed many web based reports using Hyperion Analyzer, and Hyperion Reports.
• Worked on Hyperion Financial Reporting Studio (FR) for ICB Reporting based on Financial and Quantity related data.
• Performed data reconciliation and trouble shoot interface discrepancies and system issues.
• Worked with user community to identify solutions to reporting requirements and enhance system performance.
• Developed and maintained reports using tools like Hyperion Reports, and Hyperion Analyzer.
• Assisted in the development projects and other tasks as assigned.
• Conducted end user training on Essbase applications as needed.
• Assisted in the development and maintenance of training documentation.

Environment: Hyperion Essbase 7.X, EAS, Excel Spreadsheet Add-In, Hyperion Analyzer, Hyperion Reports, Oracle, Windows 2000.

Hyperion Essbase Developer/Analyst

Confidential, Dearborn MI

Responsibilities:

• Primarily responsible for reports developments and maintenance.
• Developed batch files using MaxL and ESSCMD and rule files to upload data from systems database to Essbase cube.
• Optimized the applications to bring down the runtime and database size considerably.
• Designed and developed Essbase cubes, created rules files, and performed data loads. Thoroughly considered performance optimization and data retrieval approaches.
• Training and providing technical support to junior staff using Hyperion Essbase
• Involved in system installation, configuration and software upgrades from Essbase version 6.0 to 6.5.4.

Environment: Hyperion Essbase 7, Hyperion Analyzer 7, Hyperion Reports 7, Microsoft Excel 2000, Oracle 9i, Windows NT 4.0..

Associate Software Developer

Confidential

Responsibilities:

• Gathered business requirements and performed documentation activities.
• Created Temporary Tables to store the data from Legacy system.
• Creation of Materialized views and function based indexes.
• Performed Quality Assurance activities on web forms built on .Net, and Visual SourceSafe for version control and performing various builds.