Business Intelligence

TANUSHREE PATRA

Email: - ***********@*****.***

Phone: 313-***-****

SUMMARY

•Experienced in design and development of Hyperion Essbase 11.1.2.1, Hyperion Planning,

Hyperion Shared Service,IBM Cognos10g, SAPBW and oracle SQL Query writer.

•Ambitious and self-motivated with a strong technical background.

•Good knowledge in Oracle Hyperion Essbase, Oracle Hyperion Planning, HFM, Smart view, Hyperion excel add in.

•Seeking for a challenging and interesting role in a company where my experience and knowledge can be utilize and enhance.

•Hyperion Essbase 9.3 Developer Certified Expert.

•Quick learner with creative ideas.

•Ability to work in pressurized situation.

•Provide detailed technical specifications according to the client requirements.

•Extensive knowledge of Essbase 9,11.1.1.3,Shared Services, Financial Reports, Web Analyzer, Essbase Administration Services(EAS), Hyperion Planning 9 AND 11.1.3 VERSIONS, Smart view and Essbase Spreadsheet Add-In.

•Expertise in Esscmd, MaxL Language, Calc Scripts, Business rules, Sequences, Backup and Restore, Optimization, Tuning, Partitioning and Migration.

•Tuning, Updating and Automating of Essbase Cubes, Support User Training and Acceptance Testing.

•Experienced in developing Universal Reports for various Business applications using different reporting tools.

•Experienced in development of Relational and Multidimensional databases in Oracle, SQL server and Hyperion Essbase.

•Experience of working throughout the SDLC of a project.

TECHNICAL SKILLS

OLAP Hyperion Essbase 11.1.2.1, Hyperion Planning

Business Intelligence Tools Essbase Administrative Services, Shared services

Reporting Tools Hyperion Spreadsheet Add In, Smart View. MS Excel, SAP BW, Cognos

PROFESSIONAL EXPERIENCE

Ally Financial Services, Auburn hills, MI 12/2014 - 07/2015

Essbase Developer

Actively worked in Monthly close, Managerial close and forecasting process.

Opening and closing of security during forecasting times in Tidal scheduler, Hyperion Planning.

Extensive experience of designing and developing Essbase applications with balance of Dense and Sparse Dimensions.

Working experience of developing reports using Hyperion Financial Reports, Excel Add-in and Smart View.

Designed and developed cubes using both kind of storage options ASO and BSO.

Retrieved data using Excel Add-in to analyze cube outline for data integrity.

Created various filters as per user requirements.

Responsible for granting user access based on their specific needs and assigned them to specific groups to provide security for confidential data.

Optimized outline structure, loading and calculations through appropriate dense and sparse settings of dimensions, storage allocations and by dynamic calculations.

Modified the existing outline for some applications according to the requirements.

Developed Rules files to upload data from financial system’s database to Essbase cube.

Created linked and transparent partitions between source and target cubes.

Involved in creation, update, deletion and maintenance of user accounts and groups for cube access.

Monitored the log files of the cubes to make sure there are no errors related to dimension build and data load.

Successfully used Linked Partition to achieve optimization in performance and navigation between the databases.

Worked on Design Documentation for various applications.

Mercedes Benz Financial Services, Farmington Hills, MI 03/2012 - 11/2013

Essbase developer

The aim of this project is to develop new cubes and migrate cube from old production Essbase server version 9.3.1 to 11.1.2.1 on windows with the historical data. For cube balancing process create report scripts to export data in txt files from Essbase cubes to compare with PeopleSoft materialize view and financial view.

•Developed DIM build rules and Load Rules using flat files.

•Perform quality assurance and testing of SQL server environment.

•Develop SQL scripts, indexes, and complex queries.

•Ensure data integrity is maintained through security and change management.

•Interacting with the business users and understanding the request.

•Generate the control M jobs to build dim and load full and increment data in ASO and BSO cubes.

•Prepared report scripts to create flat file to compare the flat file and Informatics extract for cube balance.

•Performed Optimization using Hour glass design technique for BSO cubes.

•Improved cube performance by increasing cache, increasing buffer size on config. file.

•Create documents for smart view installation, stop and restart the all Essbase services.

•Support business user to make connection retrieve data in the smart view from the different environment like Development, testing, Disaster recovery and Production server.

•Install, configure, and fine-tune Hyperion System 9 environment, Shared services, Analytical Provider services and smart view.

•Involved in making the Essbase backups and restores of Essbase application.

•Developed Load Rules, Calc Scripts, Report scripts and Batch Scripts using Esscmd and MaxL.

•Create Report scripts to export data in file and compare the exported file with the informatica file.

•Maintain the user and group in the Shared services.

•Create and Modify report scripts to extract and send the data for cube balancing.

•Migrate cubes from Essbase 7.1.3 to System9 using the migration wizard.

•Export data in level0, Input data and all data in the text file.

•Create web forms, Business rules and sequences for the users.

•Prepared Maxl scripts to rename the application and provisioning the users.

•Copy and move the exported and extracted data in the different environment.

Integretas, Ann Arbor Michigan 01/2012 - 03/2012

Essbase Analyst

The main purpose of this project is to prepare a Daily report by getting the data directly from SAS and feed it in essbase and make a report, which can be used for daily analysis for users.

•Support business user to make connection retrieve data in the smart view from the different environment like Development, testing, Disaster recovery and Production server.

•Create web forms, Business rules and sequences for the users.

•Developed DIM build rules and Load Rules using flat files and SQL server 2005.

•Prepared Maxl scripts to rename the application and provisioning the users.

•Create documents for silent installation of smart view on user machine.

•Add new Users and groups in the LDAP directory. Provisioning the groups and add the users in different groups.

•Create and modify the .Property and .CFG file in the Essbase and Provider services.

•Create and Modify report scripts to extract and send the data for cube balancing.

•Migrate cubes from Essbase 7.1.3 to System9 using the migration wizard.

•Export data in level0, Input data and all data in the text file.

•Copy and move the exported and extracted data in the different environment.

Environment: Essbase 9.3, planning 9, SQL server 2005, MS-Excel 2000 Spreadsheet Add-In, Smart View

Senryo Technologies, Lisle, IL 09/2011 - 12/2011

Hyperion Developer

•Maintain the different cubes, which refresh every Sunday using Vision warehouse.

•Looking into the Log files to find missing members in the cubes to support the Users.

•Maintain Intranet application to display the Essbase Cube Status in different colors.

• Involved in performing DBA activities like create users, password setting, group and filters.

•Prepare documentation.

•Modified the old intranet application to extract Warehouse information from the AS/400 and Teradata.

•Extract product Hierarchy from the Unix Server for Essbase which holds the hierarchy on UDB tables.

•Redeployed the applications in the development, test and production server.

•Support to solve the production issues and fixed the bugs in intranet application and Essbase cubes.

Environment: Hyperion Essbase 6.5.1, Microsoft Excel 2000

EDUCATION

•Bachelors Finance and Accounting

•Certified Hyperion Essbase Developer

Contact this candidate