SUMMARY

• 7 years of professional IT experience working with Relational Databases, Client - Server applications in a Data Warehousing environment.
• 5 years of experience in design, analysis, development and implementation of various applications in Client/Server OLAP environment using Hyperion Essbase, Hyperion Performance Suite, Architect, Hyperion Financial Management (HFM), Hyperion Financial reporting.
• Worked on Installation and configuration of HFM for System 9 and Hyperion 7
• Upgradation experience from Hyperion 7 to 9 and from 9 to EPM 11
• Worked with Monthly cycles for consolidation and other accounting needs of the company using HFM
• Worked with accounting teams in creating reports in compliance with GAAP and SOX guidelines.
• Participated in rolling forecast application and built functionality around it.
• Worked with Smart View and created Forecast reports and pivot tables
• Used Interactive Reporting dashboards and Financial reporting for designing reports and creating financial year end books
• Developed complex formulas and calc scripts reflecting the business users requirements on the cube
• Developed and maintained Rules file for loading of data and building the Dimensions dynamically.
• Designed and developed numerous Essbase applications, developed various OLAP Models & EIS-Meta-Outline. Strong Understanding of dense and sparse strategy dimension allocation, performed dynamic calculations, developed, reviewed, and optimized report queries.
• Extensively worked on Intelligent Calculation, Two-pass calculation, hybrid analysis, data partitioning and currency conversion applications (CCA).
• Expertise in writing custom Essbase calculations scripts, automated the Essbase Cubes using MaxL, Esscmds and Batch Scripts.
• Applying quantitative methods to analyze synthesize and interpret information from multiple data sources.
• Strong database development and business intelligence modeling capabilities
• Proficient in the star and snowflake schema data modeling technique used to design data warehouses and data marts.
• Exposure to CMMI practices.

TECHNICAL SKILLS

OLAP Development Tools: Hyperion Essbase 7.1.5/6.5.x,Hyperion System 9/11, EPM, EAS 7.1.5, EIS 7.0/6.x, Esscmd

ETL Tools: Informatica 6.0

Business Intelligence Tools: Hyperion Analyzer 7.x/6.x, Hyperion Reports, H.A.L, Hyperion Enterprise Services, Hyperion Financial Management Suite (HFM)

Reporting Tools: Business Objects 5.0, Crystal reports, Hyperion Visual Explorer, Excel-Addin, Smart view, Financial Reporting, Interactive Reporting

Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 5.0/XP

Databases: Oracle 9i/8i, MS SQL Server 2000, MS Access, Toad 8.0, SQL Navigator

Hardware Platform: SUN Solaris, Windows 2000/NT Servers

Languages: C, Perl, shell scripting, SQL, Visual Basic 6.0, MaxL

Web Design: HTML, ASP 3.0, XML

Dimensional Modeling: Star-Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables, Physical and logical data modeling

PROFESSIONAL EXPERIENCE

Confidential, Blue Bell PA

Technical Architect

Responsibilities:

• Analyze and estimate efforts for business requirement.
• Improved processes for development and code versioning and tracking to move developed code from DEV to QA to Prod.
• Heading development team and providing QA support.
• Part of monthly outlook cycles and quarterly data loads as well as metadata changes.
• Completely responsible for administration and maintenance of development instance
• Performed metadata changes, loaded data, performed defrag, performed aggregations, wrote business rules, wrote calc scripts, modified data forms and prepared high level design
• Took metadata, data, security and data form backups.
• Performed ad-hoc analysis for analysis and for presenting reports to management.
• Wrote VBA add ins to automate certain load and extract tasks.
• Worked in an onsite-offshore model and worked with offshore team to provide technical solutions

Environment: Hyperion Planning 9, Smart view, Oracle 9i/ 10g, SQL Navigator 6.0, Essbase Excel-Addin, Mercury IT governance center (for workflow management), PVCS (code versioning).

Confidential, Dallas TX

Hyperion Consultant

Responsibilities:

• Custom configuration of EPM suite based on analysis of applications on server and the physical server kernel settings.
• Migration of all the existing application and metadata.
• Used Hyperion Architect to create application views and deploy them.
• Created and provisioned users with necessary roles on applications using Hyperion Shared Services.
• As the Hyperion Admin created users/groups, security profiles and application access to different groups using filters.
• Optimization of BSO cubes: Custom setting type of compression, data cache, calculator cache settings, and allocation of dense/sparse configuration relating to hourglass model to have optimum database block size.
• Automated process of all Essbase cubes. (Using shell and batch scripts) and Created and maintained users, groups and filters across Essbase servers
• Analyzed and converted compatible BSO applications to ASO applications for improved performance
• Maintenance of EIS applications across NT platforms.
• Perform immediate recovery of crashed databases and also de-fragmentation of cubes.
• Write, debug and enhance various calculation scripts and business rules.
• Optimization of Data Load Rules and Calc Scripts.
• Used Excel Add-in and pivot tables for End users.
• Prepared Reports for the management.
• Partitioned data in order to reduce network traffic and increase efficiency of service orders.
• Developed complex mappings using transformations such as the Source Qualifier, Agrregator, Expressions, Lookups, Filter, Router, Sequence Generator, Update Strategy and Joiner
• Performed Optimization using Hour glass design technique, during Data Loads and while calculations.
• Wrote automated Services start up script and shutdown script
• Set preferences for users in Workspace and exported reports and data forms from workspace to be used with Smartview.
• Used HFM for financial reporting and monthly cycles, also to create year end books and batches.
• Created journals, data forms, batch reports, grids and consolidation reports using rules files. These were designed in compliance with SOX requirements in Hyperion Financial Management.
• Determine accounting treatment of purchases through coordination with BTS Accounting, Accounts Payable, and Real Estate group.
• Developed and managed clusters of application servers for load balancing.
• Hands on experience on Hyperion System 9 reporting products like Web analysis, Financial Reporting and Interactive reporting
• Provided technical support to diagnose and troubleshoot various issues for Essbase developers and business users both within the group and across the organization.
• Created web Forms for Hyperion Planning, created users and granted then access for the same.
• Used Hyperion Planning to build interfaces and implemented Business rules
• Performed Production support for System 9, always meeting SLAs
• Worked in development environment for upgrade to EPM 11. Prepared and maintained development and test environments for EPM 11

Environment: Hyperion System 9, System 11(EPM), Essbase, Financial Management, Data Management(FDM), Hyperion Planning, Financial Reporting, Smart view, Oracle 9i/ 10g, Toad 8.0.0.47, NT 5.0, HP-UX B11.11, Essbase Excel-Addin

Confidential, Seattle, WA

Hyperion Essbase Consultant

Responsibilities:

• Developed Multidimensional cubes using Hyperion Essbase that stored the data for report generation process.
• Created OLAP Model and Meta Outline and implemented Star Schema and loaded data by interfacing to the existing Oracle systems using Essbase Integration Services.
• Created dimension building load rule and data load rule for dynamic dimension building and data loading in Essbase
• Used shared services and created single login authentication for users and externalized users
• As per requirement created new users groups and changed the access settings for the users to meet business needs created and maintained user profiles on shared services
• Worked on hybrid analysis using integration services for drill-through view of the data.
• Involved in installation of EIS, configuration and migrating from Essbase version 7.x to System 9.
• Involved in performing DBA activities like create users, password setting, group and filters.
• Performed Optimization using Hour glass design technique, during Data Loads and while calculations.
• Involved in taking regular backups and restores of Essbase application. Implemented robust data access security and user management.
• Performed Performance Tuning by using the dense/sparse settings and developed the required alternate rollups for reports.
• Retrieved reports using Excel add in and generate reports out of batch in Hyperion Reporting.
• Hands on experience on Hyperion System 9 products like Web analysis and Interactive reporting.
• Expertise in writing custom Essbase calculations scripts, automated the Essbase Cubes using MaxL, Esscmds and Batch Scripts.
• Provided training to end users in using MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases.
• Used Web Analyser to create reports and provided training to users for accessing these reports.
• Responsible for drafting technical documentation for end users.
• Managed and led development enterprise teams to implement Hyperion Essbase OLAP cubes for analysis.
• Extensively worked with Hyperion Reports and Hyperion Analyzer.
• Assessed new Business needs/ initiatives and translated them into detailed business requirements specifications.

Environment: Hyperion system 9, Shared services, Hyperion Essbase, Hyperion Analyzer, Hyperion Reports, AIS, Hyperion system 9 BI, Hyperion Web analyzer, Microsoft Excel 2000, Oracle 8i, Windows NT 4.0.

Confidential, Minneapolis, MN

Hyperion Essbase Consultant

Responsibilities:

• Involved in system installation, configuration and software upgrades from Essbase version 6.5 to 7.1
• Developed many data load rules for loading specific type of data files.
• Developed star schema for the OLAP model, and created EIS Meta-outline for the Essbase cubes.
• Redesigned and Restructuring of existing cubes.
• Involved in reviewing the cube design, Performance Monitoring and Performance Tuning of the Essbase server. Implemented robust data-access security and user management.
• Implemented Hyperion Planning and Worked with Hyperion Planning in developing web-based forms for the various budgeting purposes and implemented whole security matrix in Hyperion Planning.
• Installed Hyperion SQR server and installed SQR for DDO to connect with Essbase server.
• Created custom designed reports using SQR by complex procedures for accessing, manipulating and reporting enterprise data. Used HTML procedures to generate complex reports and created many Web Reports. Created Repots in Brio.
• Used Hyperion Financial Management (HFM) for Financial Analysis and Reporting.
• Used HFM to consolidate and generate journal reports.
• Presented detailed analytical reports to higher administrative people using Hyperion Financial Management induced collaborative decision making.
• Used ESSCMD for various processes from the command line prompt.
• Provided technical guidance and support to end-users by developing the documentation required.
• Analyzed financial results and prepared trend reports to support business managers make profitable decisions.
• Designed and developed many web based reports using Hyperion Enterprise, Hyperion S.Q.R, Hyperion Analyzer, Hyperion Reports.

Environment: Essbase XTD Analytic, Hyperion Planning 3.3, Hyperion Enterprise Services, Microsoft Excel 2000, Oracle 9i,Business objects 5.0, Windows 2000 Advanced Server

Confidential, NJ

Hyperion Essbase Developer

Responsibilities:

• Developed and optimized Data Loads and Calculations.
• Developed calc scripts to calculate various figures for the outline.
• Used Esscmd in an interactive and batch mode to load data files.
• Analyzed all dimensions and members in the Essbase outline for performance tuning.
• Created new OLAP reporting environment for the Center Development group. Modeled 3 cubes in Essbase, covering Sales, Financial Statements, Market Share, and Customer satisfaction metrics.
• Created in depth requirements documentation detailing business requirements, data warehousing architecture, and related design considerations. All documentation was presented to upper management.
• Coded applications to automate the cube update procedures. Authored documentation for the new system.
• Created various reports using Hyperion Reports and Hyperion Analyzer.
• Maintained cubes and took regular backups.
• Oversaw day-to-day operations of the Essbase system. Resolved both system and data issues as they occurred.
• Implemented new reports and processes for users as needed.
• Installed, configured and tested new versions of Essbase, and Reports as needed.

Environment: Hyperion Essbase 6.0, Hyperion Reports 2.0, Hyperion Analyzer, Microstrategy, H.A.L, and Excel Add-in for Essbase

Confidential

Oracle Developer

Responsibilities:

• Developed PL/SQL programming that included writing of Stored Procedures, Packages, Functions and Database Triggers.
• Created Temporary Tables to store the data from Legacy system.
• Used SQL*Loader scripts to load the data into temporary tables and PL/SQL procedures to validate the data.
• Creation of Materialized views and function based indexes
• Setting up various notification scripts which will notify if the database is not up and running or if any directory space is filled up.
• Used Oracle packages for automation, Oracle designer for data modeling.
• Used Visual SourceSafe for version control and performing various builds.

Environment: Oracle 7i, SQL*Loader, UNIX