Data Developer
Resume:
TANUJA M
********@*****.***
____________________________________________________________________________
__
SUMMARY:
. Over 7+ Years of experience in IT with Data Warehousing, ETL & OLAP
focusing on Hyperion Suite of Technology. Adept in preparing Hyperion
reports to measure financial performance, analyze profitability, and
facilitate effective business decision making.
. Over 5 years of functional experience in design, analysis, development
and implementation of various applications in Client/Server environment
using Oracle Essbase 11.x, Hyperion System 9 BI+, Hyperion Reports,
Hyperion Web Analysis, Hyperion Analyzer, Essbase Spreadsheet Add-in,
Essbase Query Designer on Windows 2000/NT4.0 and Unix environments.
. Experienced in all stages of Software Development Life Cycle (SDLC) with
comprehensive knowledge of business and requirements analysis, business
Process modeling, Project planning and creation of user cases.
. Designed and developed numerous Essbase applications with excellent
balance of dense and sparse dimensions, developing various OLAP Models &
Meta-Outline.
. Skilled in Architecture design of Essbase Cubes using Block/Aggregate
storage(ASO/BSO) & Partitioning.
. Involved in writing custom Essbase calculations scripts, automated the
Essbase ASO/BSO Cubes using MaxL, Mdx, Esscmds and Batch Scripts.
. Skilled in Automation, Optimization and Performance Tuning of Essbase
application data/metadata processing, upgrading, testing and migrating of
cubes in different environment
. Expertise in developing complex web reports for business and end-users.
. Versatile team player with excellent analytical, presentation and
interpersonal skills with an aptitude to learn new technologies.
. Worked extensively on developing reports & templates using Hyperion
Reports, Financial Reporting and Smartview.
. Developed, modified and customized reports using Hyperion Analyzer and
Web Analysis.
SOFTWARE SKILLS
OLAP Oracle Hyperion 11.x, Hyperion Essbase System 9
BI+
Reporting Tools Hyperion Web Analysis, Hyperion Reports,
Hyperion spreadsheet Add In Micro Strategy Web.
Languages SQL, PL/SQL, Pascal, C/C++.
Databases Essbase, Oracle 10i, MS SQL Server
2000/7.0/6.5, MS Access 7.0/2.0.
Software tools SQL *Plus, TOAD.
Operating System Windows 2000/NT 4.0/98/95, UNIX (Solaris, HP).
Microsoft Office Products PowerPoint,Excel,Word,Access.
PROFESSIONAL EXPERIENCE
Michelin Tire Corporation,
Greenville, SC
(Feb 11-Till Date)
Hyperion Essbase Developer
Responsibilities:
. Worked on Local Budgeting Project and developed reports using WebAnalysis
and Excel.
. Worked with Business Analysts and gathered the requirements.
. Designed and developed BSO cubes according to the business needs.
. Created various reports from database using Web Analysis for management
for their monthly and quarterly reviews.
. Developed Essbase outlines, Outline member formulas, load rules,
dimensions build rules etc.
. Automated the cubes using MaxL statements and running it through unix
shell scripts.
. Involved in all aspects like Development and Maintenance.
. Involved in designing, developing, Upgrading and testing applications
cubes and reports.
. Developed Rule Files in BSO cube.
. Worked with Offshore team and tested the functionality of drillthru
reports in WebAnalysis.
. Coordinated with different teams who are involved in this LBU project.
. Performed the performance testing of the drillthru reports and the
applications.
. Retrieved the reports in excel add in and performed changes.
. Made changes in the reports according to the user requirement.
. Loaded the data from tables to essbase cubes using ODI.
. Provided detail documentation of the application and performed stress
testing for the reports.
. Implemented mathematical functions for computing derived data and worked
on optimization of data loads and calc-scripts.
. Written Sql queries to load the data into essbase cubes by using rule
files.
. Involved in creating new members in outlines and optimized them by
grouping and positioning.
. Modified and developed numerous report scripts.
. Modified and created various scripts for data loads and cube
maintainance.
. Provided access to users and assigned them to groups with shared
services.
Environment: Hyperion Essbase 11.1.2, 9.3.3, Essbase Spreadsheet Add-in,
Sql Server 2005,Essbase Administration Services, Unix, Excel Add in,
Hyperion Reporting Studio, WebAnalysis.
Electric Insurance, MA
(Nov 09-Jan 11)
Hyperion Essbase Consultant
Responsibilities:
. Designed and developed reports for web based Planning Budgeting and
Forecasting purposes facilitating Gross to Net applications.
. Involved in interacting with users to gather requirements, installations,
Updates and understand business needs and ensure applications met the
required changes.
. Developed and optimized outlines by grouping and positioning, developed
rules files for dimension building and data loads.
. Responsible for Maintenance, Optimization and performance tuning of
existing cubes
. Developed complex financial reports like forecasted P&L, balance sheet
etc.
. Created ASO cubes and updated the database and written Esscmd
commands.
. Involved in testing tasks and validating reporting data by retrieving
through Excel
Add-in Smartview.
. Created users and groups and given access to them for the database.
. Created member formulas for the dimension members.
. Aggregated the reports Excel and perfomed calculation based on the yearly
reports based on product costs changing the cost values and presenting
the client latest reports.
. Written Sql Queries to load the data and created rule files to load data
into cubes.
. Created Planning Web Forms, templates and loaded the data.
. Created reporting templates, and improved financial reports on Hyperion
Financial Reporting.
. Automation of Quarterly, Monthly and Annual reports.
. Updated the database monthly for changes that took place.
Environment: Hyperion Essbase 9.3.3, Hyperion Planning, Hyperion Financial
Reporting, Smartview, Hyperion Web Analysis, Essbase Spreadsheet Add-in,
Sql Server 2005, EAS, Unix, Microsoft Excel.
Allstate Insurance, Northbrook, IL
(Oct 08 - Oct 09)
Essbase Administrator
Responsibilities:
. Developed BSO cubes, and customer analysis and also automated data loads.
. Involved extensively in modifying and optimizing outlines. Designed,
developed and implemented the expense planning and reporting system for
the financial department in Allstate.
. Depending upon the market rates allocating the costs and performing the
MaxL scripts on those.
. Optimized proper database calculations and loads by selecting appropriate
dense and sparse setting of members and storage calculations.
. Responsible for performance tuning, backup and recovery of cubes.
. Responsible for various troubleshooting procedures to recover data.
. Updated the batch scripting files every time.
. Installed the software and configured and also provided support for the
problems faced by the users.
. Responsible for giving permissions to users access based on their
specific needs and assigned them to specific groups. Also, created
filters to grant access to users based on access levels.
. Assigned owners to models and scenarios.
. Written queries and updated the changes.
. Performed the starting and stopping of application.
. Restarted the application in case of server down issues.
. Created groups in Shared service and assigned the users to those groups.
. Installed Hyperion Essbase, Hyperion Reports and Hyperion Analyzer.
. Worked closely with production team for the end user support in resolves
emergency issues.
Environment: Hyperion Essbase 9.3.1, Sql Server 2005, Data warehouse,
EIS, Windows 2000, Hyperion Reports 7.0/6.5 and Windows XP, Shared
services.
Equity Residential Properties Trust, Chicago, IL
(Aug 07 - Sep 08)
Essbase Developer
Responsibilities:
. Interacted with business analysts in gathering requirements, drafting an
outline and thus developing a project plan for Database development and
Reporting.
. Involved in performing DBA activities such as performance tuning of
calculation scripts, along with taking periodical ESSBASE backups.
. Developed ASO cube for financial data related to the cost of processing
mortgages and real estate investments.
. Automated Essbase operations through Esscmd scripts in batch programming
to run monthly balance sheets and ledgers.
. Provided seamless integration of historical, projected and derived data.
. Modified and replaced existing financial and marketing reports.
. Involved in data loading using Essbase Integration Services (EIS).
. Used ESSCMD scripting language for batch processing.
. Used EIS to interface with the company's existing data warehouse by
implementing a star schema model.
. Retrieved data using excel add-in sheets for analysis of data.
. Generated reports for annual budget, quarterly forecasts, and worked with
ad-hoc reporting and management reporting by interacting with business
development managers.
. Used Hyperion Reports & Analyzer to collect, consolidate and report
financial data globally.
Environment: Hyperion Essbase 7.x,6.5.1, Hyperion Analyzer 6.5, and
Hyperion Reports 7.0, Essbase Integration Services 6.5, Essbase Spreadsheet
add-in, Sqlserver2000, Windows NT/2000.
Client: NGM Health Care, Keene, NH
(Jan'06-Jun'07)
Hyperion Essbase Developer
Responsibilities:
. Developed BSO cubes and also automated data loads.
. Assured optimal match between cube design and report specifications.
. Optimized proper database calculations and loads by selecting appropriate
dense and sparse setting of members and storage calculations.
. Gather the requirements from the business analysts and analyze the
requirements and perfom the yearly reports based on costs.
. Responsible for performance tuning, backup and recovery of cubes.
. Implemented star schema and used EIS to interface with the company's
existing Oracle data warehouse
. Created OLAP Model and Meta Outline for Essbase OLAP Server using Essbase
Integration Services.
. Loaded data using Essbase Integration Services (EIS).
. Responsible for granting users access based on their specific needs and
assigned them to specific groups. Also, set filters to grant disparate
access to users based on access levels.
Environment: Hyperion Essbase 6.5, Essbase Integration Services 6.5 SQL,
Data warehouse, Windows 2000 and UNIX.
Microteck, Delhi, India
Oracle Developer/Essbase Developer
(Oct'04-Nov'05)
Responsibilities:
. Designed and developed Graphical User Interface using Forms.
. Developed the PL/SQL stored procedures for implementing the business
logic.
. Developed the on-line context-sensitive user help.
. Development of reports (stores ledger, invoice preparation) using Reports
2.5
. Developed test plans for invoice, order entries, billing, shipping, and
Stock maintenance.
. Configured Oracle Clients on Win NT Workstations.
. Constructed Oracle Database Triggers and Indexes.
. Written MDX scripts in the console and created reports.
. Responsible for Code Reviews and PL/SQL Code Tuning and designing ASO
cubes.
. User Management Duties involved: Create, Modify and Delete user accounts.
Environment: Developer 2000, FORMS 4.5, Reports 2.5, Oracle7.3, PL/SQL, SQL
and Windows NT
Tata InfoTech Ltd. Delhi, India
Project & Systems Engineer
(Jan'03-Aug'04)
Responsibilities:
. Analyzed, implemented and managed all information technology needs for a
Regional and four branch offices.
. Network Administrator at company's Regional office. Rendered hardware,
software and networking support to Branch Offices.
. Based on the cost allocation created while using MDX commands and getting
the latest data.
. Negotiated all information systems purchases as well as development
contracts. Authored multiple Requests for Proposals (RFP), reviewed bids,
made recommendations or acted as a decision-maker.
. Utilized Exchange/Outlook environment as an intranet to enhance staff
communication as a knowledge management solution.
. Maintained VSAT communication server/link and supervised 24/7 Support to
keep organizational communication up and running with minimal possible
downtime.
Environment : Developer 2000, SqlServer 2000.
Contact this candidate