Summary: 15 years of IT experience , About 11 years of experience in USA, 10 years of OLAP techno-functional IT/Finance areas like Hyperion EPMA, HFM, Essbase, Planning, H Enterprise, ODI, Oracle, ESSCMD, Maxl, EIS, Analyzer, Financial Reporting, Interactive Reporting, and shared services 11.x/9.3,System 11.x/9,SQL Server. Over two years of experience on Java, J2EE, EJB, Servlets, JSP, with Weblogic 3.5. About 1 year of experience integrating PeopleSoft Financials data into Hyperion Applications. Highly experienced in maintaining the Multi-Dimensional Databases using OLAP server for Hyperion Essbase 6.x/7.x/9.3.1/11.x, Hyperion Planning, HFM, FDM, DRM, ODI, Hyperion Reports, MaxL, Essbase Spreadsheet, SmartView, Hyperion Suite and UNIX environments. Extensive experience in Planning, analysis, design, implementation, testing, quality assurance and administration in a client-server environment with expertise in developing business applications in Relational RDBMS and Multi-Dimensional MDBMS Databases. Expert in Essbase Cube Analysis, Design and Maintenance, Essbase Database Administration upgrades, Database backups, Performance tuning and Optimization. Expert in developing application security process, creating users/groups, security profile and application access to different groups using filters. Extensive experience in Hyperion reports, Hyperion Financial Reporting, Interactive Reporting BRIO and Hyperion Web analyzer. Proficient in RDBMS and SQL. Proficient in Data Modeling Techniques such as Star Schema using EIS. Technical Skills: OLAP Hyperion System 11.1.2, Hyperion System Essbase, Hyperion Planning 11.1.1.1, Hyperion Essbase 6.2 / 6.5/ 7.1.2, Hyperion Analytic Integration Services AIS 6.5/ 7.0/System 9, Essbase Excel ,Smartview, spreadsheet add-in. Reporting Tools Hyperion System 9 BI , Hyperion Web Analysis Hyperion Analyzer 5.0 / 6.5, / 7.0, Hyperion Financial Reporting Hyperion Reports 2.0 / 7.0 / 7.2 , Alphablox 3.5 and 5.0. Operating Systems MS-Dos, WinNT, Win2000, WinXP, Win9x, Unix and Linux. Programming Languages C, C , Core JAVA, SQL and PL/SQL. Databases Oracle 7.x/8.x/9.x/10g, IBM DB2, Teradata, Peoplesoft, SQL Server and MS Access. Packages and Tools MS Office. Web Tools HTML, DHTML, XML, Javascript and VB Script.

Professional summary: ConfidentialTech Lead Hyperion/ODI

Responsibilities: Gathering Requirements analyzing it, documenting business/functional requirements. Involved in new Accounts, Entities, Customers to Essbase Planning Applications. Business Rules Creation for new processes. Created Reports/Webforms for P L, Labor that are used for GAAP analysis. Coordinated the financial budgeting and planning process of the firm by interacting with different user groups by plants. Data migration/Integration with PeopleSoft/Mainframe Accounts into current Oracle's Hyperion Environment using ODI. Created interfaces/packages to load metadata using ODI. Used Hyperion Knowledge modules. Prepared Test Plan Scenario as per the requirements and UAT and migration to Prod. Supported Spread sheet, Excel's SMARTVIEW reports and trouble shooting. Scheduled batch jobs on Unix Environment using Maxl for the data loads. Develop/Trouble shoot issues with Calc scripts and Business Rules. Migrated and took backups of different Hyperion applications across Development, Test and Production environments. Maintained the security of users and groups for various Hyperion components using the native Open LDAP and User directories in User Management Console. Environment: Hyperion EPMA 11.1.2.2, .Essbase, Hyperion Planning, ODI, Oracle 11i, Hyperion Financial Reports 11.x, Windows 2007, EXCEL, SMARTVIEW.

Confidential Tech Lead/ODI Responsibilities: Involved in different enhancements to Essbase Applications including ASO and BSO. Create/change dataloads/Calc's to validate and load data. Enables users to create and manage alternate views Merged independent data sets from different sources and combines them into a master set using MDM DRM. Validated data relationships and calculates attribute values using DRM. Used desktop and webclient and FDM for dataloads into HFM. Updating shared dimension libraries whenever there are changes. Created Reports for P L statements and Variance Reporting that are used for GAAP analysis. Improved data loading and database calculation by modifying the Essbase configuration Supporting FDM data validation and loads into HFM. Data migration/Integration with EDW/ERP Accounts into current Oracle's Hyperion Environment using FDM and ODI. Involved in Creating Data Forms and Folders and Customizing Data Forms. Involved in creating End User Training documents with all the scenario's for the user groups. Supporting Month End, Quarter End and Year End close changes for the actual/budget scenarios. Environment: Hyperion EPMA 11.1.2.3.Essbase ASO,BSO , Hyperion Financial Management, FDM, ODI, Oracle 11i, SAP, Hyperion Financial Reports 9/11.x,Unix, Windows XP, EXCEL, SMARTVIEW. Confidential Module Lead Analyst Module: Hyperion Enterprise Essbase Functional IT support Responsibilities: Supporting HFM/Enterprise/Essbase Applications for Cisco/SA Finance. Migrated Enterprise applications to HFM. Data reconciliation between Enterprise and HFM. Data and metadata loads using FDM. Requirement gathering for new reports and integration with SAP Accounts into current Hyperion Environment. Loading data into applications ASO/BSO for business review. Maintaining and updating Essbase applications as per user and business requirements. Development of new application for Juarez manufacturing plant. Gathering business requirements for enhancements and create design for new reports Building Financial reports, Business formulae changes. Supporting Month End, Quarter End and Year End changes. Tie out Balance sheet/GL reports to SAP. Environment: Hyperion Enterprise6.5.1, Essbase 9/11.x, Hyperion Financial Management, Planning 9/11.x,ODI, Oracle 11i, SAP, Financial Reports 9/11.x,Unix, Windows XP, EXCEL.

Confidential Onsite Project Lead Responsibilities: Designing Applications for Capex, Opex and Workforce for Maaden. Creating Applications for Capex, Opex and Workforce using Planning's Classic wizard. Development of ODI interfaces to build dimensions from PeopleSoft. Development of ODI interfaces for dataloads from PeopleSoft. Took active part in development of ELT process to get data from PeopleSoft systems to Oracle Staging tables using ODI. Development of Business Rules for calculating Depreciation, Amortization, Accum, Licence Fee and Employee Transfers. Creating Balance sheets and Income Statements for the complete year/Cost center. Development of Business Rules for Carry Forward values into Next year Budget based on Current year's closing balance. Building webforms, Business rules for Capex, Opex and Workforce modules. Development of Business users guide to use the system including Security Aspect. Development of support activities document for each forecasting cycle for the support take over. Automating dimension builds/dataloads using ODI. Cordinating with Onsite/Offshore team. Environment: Hyperion System 9.3.Essbase 9, Planning 9.3,ODI, Shared Services, ODI, Oracle 11i, Financial Reports, Peoplesoft Fin, Java/J2EE,,Unix, Windows XP, EXCEL.

Confidential Onsite Project Lead Responsibilities: Development of Revenue, CAPEX and OPEX applications BSO Cubes . Development of Forecast and Budgeting process thru Planning Dataforms. Income statement and Balance sheet reports using Webanalysis. Dimension Building using ODI mappings from SAP. Development of Business Rules using the logic from SAP. Development of calculation scripts. Automation using Maxl. Development of Data load Rules Webform development using Java/J2EE for better presentation. Security : Provisioning is done using Shared Services with Single Sign On Authentication SSO User document preparation for easy navigation of the system. Oracle Data Integrator ODI for dimension building. Environment: Hyperion System 9.3.Essbase 9, Web Analysis 9,Planning 9.3,ODI, SAP SRM, Oracle 10 g, Windows XP, Sun Solaris 64 bit, Java/J2ee, EXCEL.

Confidential Project Lead Responsibilities: Detailed Design and Data Model for the PSI application PSI Production, Shipment and Inventory application development Creating web analysis reports Item Financial and Item Detail Reports. Adjustments captured from front end web forms for the estimated values based on the forecast from SAP. Introduced Profile concept. Developing Formulae for Measures. Security : Provisioning is done using Shared Services with Single Sign On Authentication SSO UAT: Reconciliation of reports as per the business requirements. Used Informatica for ETL Oracle Data Integrator ODI for dimension building. Environment: Hyperion System 9.3.Essbase 9, SAP Web Analysis 9,Planning 9.3,ODI, Oracle 10g, Informatica, Windows XP,HP Unix, EXCEL. Confidential Logitech Hyperion Developer Responsibilities: P L profit and loss Cube Analysis and development. Creating web analysis reports as per the business requirements. Loading budgeting, actual and Commit data as per the Logitech's fiscal calendar from SAP. Validation of the accounts formulae. Security : region wise US, EMEA and APAC . UAT: Reconciliation of reports as per the business requirements. Environment: Essbase 7.1.5 9, SAP Web Analysis 9, Oracle 8i 9i, , Java, Windows XP, EXCEL.

Confidential Sr. Hyperion Consultant/Essbase Responsibilities: Creating Applications/metadata/security in Planning and maintenance. Refreshing Applications/Security as per the metadata in SAP. Associate Business Rules with the DataForms for business users. Helping the users with Smart View to work with Excel. Web enablement for the users with Java/J2EE. Responsible for enhancements and supporting of financial reporting Profit and loss cubes for CA-Finance Responsible for enhancements and supporting of financial reporting Bookings and Revenue cubes for CA-Finance Responsible for enhancements and supporting of financial reporting Metrics cubes for CA-Finance Written calc scripts to customize the functionality Written EssCMD and shell scripts, Perl to automate the cube refresh process Responsible for developing load rules using pl/sql queries Responsible for managing security filters/groups for Planning and the underlying Essbase cubes Responsible for implementing the SOX compliance across all the cubes Responsible for upgrading the ESSBASE version 6.5.4 to 7.1 Environment: Essbase 6.x 7.1.5, SAP,Planning 4.1, Oracle 8i 9i, Windows XP, HP UNIX , Shell, Perl, EXCEL.

Confidential BI Financial Reporting Responsibilities: Responsible for creating reports for Liability Rating, estimating the finances for Opportunity Pipeline to save and Management Decision Tools Dashboard application. The process uses an automated feed of actuals from TERADATA and DB2 which in turn feeds the Essbase cubes. Developed Drill Thru functionality for certain fields using Java. Developed stored procedures to feed the data from Teradata to Essbase. Report scripts, shell scripts and calc scripts have been established to forecast the finances for rest of the current year and the next year. Developed Alphablox5.0 and Alphablox 3.5 templates for user's convenience. Attained expertise in Data warehousing and OLAP technologies. Fine tuned all applications that reduced the calculation times by 60 . Developed Batch files and scheduled. Environment: Essbase 6.5,VB, Oracle, C , XML, Planning 3.5, Alphablox 3.5 and 5.0, Java 1.4, Windows XP, EXCEL, Teradata, IBM's DB2.