SUMMARY

• Fifteen years of IT experience with ten years in analysis, design, development, testing, implementation of applications using Client/Server technology Online Analytical Processing OLAP systems, Multi-Dimensional Databases and its reporting tools using Hyperion Essbase OLAP Engine.
• Extensive experience in Hyperion Planning, web forms, business rules, Hyperion reports/ Financial Reporting, Analyzer/ Web analysis, MDM with major interfaces.
• Developed business value solutions using Hyperion Planning for customers.
• Experience in both BSO and ASO technologies of Essbase
• Create/Review project plans and provide timely feedback and direction.
• Experience in whole System 9 Hyperion tool set and better understanding of the technical architecture and integration between the products.
• Extensive experience in accounting with 35 credits .
• Strong experience with Essbase calculation and report scripting.
• Extensive experience in Essbase load rules and overall system architecture.
• Extensive experience with Essbase administrative activities such as database backups, recovery, optimization and performance tuning.
• Good experience in all phases of development including defining user acceptance criteria, developing plans/scripts, documenting expected results, execution of scripts, validating actual results.
• Excellent communication, interpersonal, written, analytical and problem solving skills.
• Effective Team Player and an individual contributor with steep learning curve.
• Experience in upgrade of Hyperion tools set from pre System 9 version to latest System 9 versions 9.3.1, System 11 11.1.1.3
• Excellent Business knowledge in Finance, Accounting, Budgeting and worked on EPMA.
• Expertise in Building Financial Budgeting and Forecasting OLAP applications with Hyperion Planning/Essbase. MDM with several interfaces as per business requirement.

TECHNICAL SKILLS

• Languages: C, SQL, PL/SQL, COBOL, MaxL, ESSCMD
• OLAP Tools: Hyperion System 9, BPMA, Hyperion Essbase 6.x/7.x, EIS 7.x, Hyperion Planning 3.x/9.x, HFM. FDM, DRM and ODI
• Reporting Tools: BI , Hyperion Reports 7.x, Hyperion Analyzer 7.x, Excel Add-In, SmartView, WebAnalysis, Financial Reporting
• G U I: Visual Basic 5.0/6.0 Developer 2000
• Database: Oracle 9.x /10.x and M S Access
• Testing Tools: SQA Suite, WinRunner, LoadRunner
• Operating System: Unix, Windows 95/98 and Windows NT
• Hardware: Intel486, Pentium, Pentium II, IV all IBM compatibles

EXPERIENCE

Confidential

Sr. Hyperion Administrator

• Working on Hyperion Essbase and Planning Administrator, supporting Business users.
• Addressing to the requirements of four Business Analyst Managers BAMs in meeting their reporting requirements, of their respective Category and Marketing products.
• Attending to the monthly planning forecasting scenarios Main app besides supporting Weekly cube
• Testing of Outline and MDX/Calculation Scripts as per the requirement from time to time.
• Updating of Accounts/Products from time to time to match with OBIEE in the EPM Workspace and managing security of users in Shared Services.
• From time to time attending to the reporting requirement of Business users using Excel Spreadsheet Add-in.
• Working with IT in respect of data loads using ODI on a monthly basis and providing matching of actuals to that of Analytics' Center OBIEE for various products Gross Sales and fixing any issues and providing confirmation of results to Admins/Business Users.
• Updating on a daily basis the PIM Product information Management system process to match the product hierarchy in Category and Marketing Finance System.

Confidential

Sr. Systems Analyst

• I was working on Fannie Mae Project at Atlanta Delivery Center
• To support and create MDX and Calculations Scripts for the NSO and BSO technologies of Hyperion Essbase.
• Creation of Data load/dimensional member load rules and to support the business users
• Testing of Outline and MDX/Calculation Scripts as per the requirement from time to time.
• Essbase spreadsheet add-in and Smartview are being used for report creation/testing etc.
• Working on Web form creation for Hypeerion Planning and to support Hyperion planning application.

Prior to the above, worked on Ascension Health Care Project at St. Louis Interfaces' Document for the Hyperion Planning for automating Data loads through ODI was studied Documented.

Confidential

Principal Software Engineer:

• Project Summary: This project is to track and maintain the different projects of DOE Department of Energy at every stage of completion. Work Breakdown Structure WBS will track the minute details of expenditure incurred on several projects/types under various Business entities.

Role and Responsibilities:

• Gathered the requirements from the Business users and financial heads including PS maintenance group and documented.
• As Hyperion Essbase and Planning Administrator created new ASO/BSO cubes with required number of dimensions.
• User access profiles in Shared services and EAS maintained.
• Data interface is through PeopleSoft application. Using TOAD Quest Tool for SQL/PL/SQL generating data files for the dimensions and data.
• Using ODI Oracle Data Integrator ETL/E-LT toll for automating the data load process in due course replacing the current manual load.
• Guiding the Corporate and business users in installing and configuring Smart view 11.1.1.3 on their main system.
• Providing production Support and tracking and resolving application level/user level issues from time to time.

Environment - Hyperion 11.1.1.3, Essbase and Planning , Lotus Notes 8.6, Oracle 11g, Windows XP, Quest Toad 10.6 and MS office tools and PeopleSoft.

Hilton Worldwide

Confidential

SST Finance Project Consultant:

• Project Summary: Hotel Level Finance and Forecast System HLBFS Provided support to the User community all across globe.
• Hilton inhouse developed tool Single Source of Truth SST validated from time to time by sourcing data from PS
• Various maintenance tasks involved in maintaining the tasks rendered at a world class hotel setting are maintained through inhouse tool OnQ, which is multi functional and tasking tool.
• Provided timely and much needed help and access provided to the users at Hotel level and users in the Corporate offices.
• This Finance and Forecasting project helps users to track their reporting requirements such as daily, weekly and Monthly besides Final Statements required by governmental agencies etc.
• Essbase outline updating and moving to production from time to time
• Worked with the IT and other team members during the maintenance window, three times of the day.

Role and Responsibilities:

• As Hyperion Essbase Administration maintained user access profiles and production support from time to time.
• Data interface is through PeopleSoft applications. Guiding users from all across the globe to access HLBFS Hotel Level Budgeting and Forecasting systems etc.
• Involved in Actuals/Forecast data loading process for domestic and International Hotels on monthly basis.
• Guided the Corporate and large Hotels in installing and configuring Essbase tool 9.3.1 on their main system.
• Totally restructured the entire European Region Hotels in the Outline as per the revised classification and market segments.
• Calculation Scripts of varied tasks in the financial sector created/edited to meet the requirements of the users in Essbase.

Environment - Hyperion 9.3.1, Essbase and Planning , Oracle 10g, Windows 7, Hilton created Tool OnQ for helping the Business and Corporate users for rendering various tasks. MS Office tools etc.

Aetna Inc, Hartford, CT 02/2009 01/2011

Sr. Application Developer

• Project Summary: Worked as Sr. Application Developer Hyperion - The project was to design and implement Hyperion Application for Financial Performance and Operating Expense Analysis and Reporting.
• Windows scheduler was used for Batch processing and execution of Essbase scripts to automate Outline updating and data loading to Essbase database. Hyperion Report and Essbase Excel add-ins were used for reporting and analysis. Due to the presence of more dimensions using ASO cube as data mart and at a pre-determined intervals, exporting data to EMIS for use by Executives and higher officials in the hierarchy.
• Created Report Scripts for transferring data from ASO cube to EMIS system for the current and plus four years of forecast data in the given format. Project document and relevant TCs were prepared and trained users. Research on ODI was made for getting data to view with Level0 members of all the thirteen Dimensions.
• Worked on Hyperion Financial Data Quality Management FDM for extraction, Transformation and loading of data ETL with multiple ledgers to HFM, Essbase etc.
• DRM is used in Hyperion Planning implementation at the organizational level. Consistent hierarchy structures across applications was achieved using Hyperion Data Relationship Management DRM

Role Responsibilities:

• Requirement gathering from Business Analysts users and PWC team Designating team
• Designed, developed, and implemented reporting framework and applications using Hyperion Essbase. Aetna Planning, Budgeting and Forecasting Project.
• Development of Essbase components Load rules for actual and other data loads, setting up substitution variables
• Involved in creating calc scripts, generating report scripts as per the format specified for exporting to EMIS system.
• Generated reports using Excel add-in. Cube Optimization and performance tuning was done in QA environment.
• Generated level zero data files from the Aetnaplan, Reporting and Membership cubes for taking daily back-ups using Maxl statements.
• Extensively worked with Hyperion Reports to produce the consolidation reports, financial planning and analysis reports for management.
• Participated in Hyperion CRs resolution weekly meetings.
• Conducted and Involved in the requirements and design documents review and updating meetings to meet the current requirements.
• Executed test cases for manual testing and documentation of the whole process is done and test scripts stored in CC. Unit test for all the dimensions/members with and without data executed and test script created besides Stress test on server for retrieving more than 2.7 million records in less than 5 minutes of retrieval time.
• Environment: Hyperion Essbase 9.3.1/7.1.5, Hyperion Planning 9.x, Hyperion Shared Services, Hyperion Reports 7.0, Financial Reporting, Web Analysis, EIS 7.1.2, Excel Add-In, Unix, Windows NT 4.0, Perl, Oracle 10g, HAL,ODI.

Confidential

Hyperion/Essbase Developer Consultant

• Project Summary: Worked as Hyperion/Essbase Developer Consultant Merrill Lynch operated nine different Oracle instances globally. Eight were considered regional General Ledgers GL and one served as a Consolidating General Ledger. Due to the instance separation, each region had developed its own reporting structure, reports and in some cases its own reporting tools. With the FDW Financial Data Warehouse initiative, the US and Regional instances were upgraded to Oracle 11i and shared a global chart of accounts. As a result, the opportunity existed to consolidate the various reporting solutions and standardize reporting formats across regions through Hyperion Products.

Role Responsibilities:

• Involved in Production Design of Financial and Management Reporting Application. Involved in Consulting with users/Clients on database enhancements, maintenance, analytics and reporting.
• Actively involved in migration and configuration of Hyperion 7.2 version to 9.3.1 for Planning and Essbase with other 2 team members.
• Involved in development of Legal Reporting /Management Reporting cubes.
• Extensively involved in troubleshooting and managing 24/7 Production support.
• Performance tuning optimization of cubes for satisfying the users reporting requirements.
• Error Handling, Trouble shooting, handling restructuring and server problems.
• Involved in Migrations of databases from development servers to QA/Production servers.
• Guide and determine suitable technical development of database architecture for given functional requirements in collaboration with system architects, Business Analysts and Designers.
• Security Maintenance: Maintaining users, user groups and access securities for all the developers end users depending on their current privileges in Oracle GL.
• Automated monthly/annual PDF/Snapshot book generation, developed Excel Templates for user interface in Essbase database.
• Web forms for data input for income statement accounts, balance sheet accounts, drivers, stats accounts, and actual adjustments.
• Development of planning security.

Environment: Hyperion Essbase 9x/7.1.5/7.1.2/7.1, Hyperion Planning 9.x, Hyperion Shared Services, Hyperion Reports 7.0, Financial Reporting, Web Analysis, EIS 7.1.2, Excel Add-In, IBM AIX, Autosys, PVCS, Unix, Windows NT 4.0, Perl, Oracle 11i.