Suresh Mendu Phone: (***) - *** **** (Cell)

***** ******** **

Ashburn, VA 20147 E-Mail: addpxh@r.postjobfree.com

Do not need a Sponsorship to work in USA

OBJECTIVE: To obtain a challenging and responsible Hyperion Architect/ Senior Hyperion Essbase Database Administrator / Senior Analyst Programmer position in an organization where I can develop my career as well as work for the growth of the Organization.

SUMMARY

22 + Years of total IT Experience.

17 + years of strong experience in application software development in Client/ Server architecture using RDBMS like Oracle, SQL Server and MS-Access.

15 + years’ experience with Hyperion Products such as Hyperion Financial Management 11.1.2.1, Hyperion Essbase 11.1.2.3.500, Hyperion Data Integration Management 11.1.2.1, Oracle Data Integrator 11.1.1, Hyperion Business Rules, Hyperion Planning 11.1.2.4.008 and Hyperion Financial Reports 11.1.2.4.901.

Team player, enthusiast and quick learner with excellent communication skills.

COMPUTER SKILLS

LANGUAGES

Java, JavaScript, HTML, C, C++, FORTRAN, Pascal, ASP, Perl, Windows Shell Scripting, DOS, Cold Fusion.

DATABASES

MS-Access, Oracle 8.x/9.x/10g, SQL, SQL*PLUS, SQL Server.

OLAP TOOLS

Hyperion System 11.1.2.x, Hyperion Essbase 6.x/7.x/9x/111.2.4.x, Hyperion Reports 2.x/7.x/9x/11.1.2.4.x, Hyperion Analyzer 6.x/7.x/7.2.x/9x/11.x, Hyperion Interactive Reports 6.5 / 8.3.2 / 9.x., Hyperion Planning 3.3x/4.x,9.x/11.1.2.x., Hyperion Business Rules 11.x, Essbase Integration Services 6.x/7.x,9.x,11.1.x, HFM 9.x/11.x, DRM 9.x/11.x and Oracle Data Integrator 11.1.1

DATA WAREHOUSING

DB Miner 2.0, SQL Server 7.0 OLAP Services.

GUI’s

Visual Basic 6.0, Crystal Reports, Actuate 4.0, Forms 4.5, Reports2.5.

OPERATING SYSTEMS

Windows 95/98/NT/2000/2003, UNIX, Sun Solaris 2.8, DOS.

HARDWARE

IBM PC compatibles, Sun Sparc, HP, Apple Macintosh, Pentium.

PACKAGES

MS Office, Photoshop, Front Page, Dream Weaver, Flash, Raiser’s Edge.

SOFTWARE TOOLS

Lisp, Yacc, Lex, Lisp

WORK EXPERIENCE

Gunnison Consulting Group Sep,16 – Present

Position: O & M Team Lead

Client: US Census

Project Title: COBRA Systems

COBRA systems is a Hyperion Planning and Budgeting Reporting application used in US Census to plan for Operating Expenses (OP Cycles) and Four year Budget Planning (BPD cycles). It mainly consists of 2 applications CPLAN and PL where CPLAN application is used for CENSUS Planning and Position Listing application is used for Operating Plans. Census has mainly three group of users who uses Hyperion Planning application to keep track of employees, Projects and Divisions which are participating in projects through out the year. They plan on 2 different cycle such as OP Cycle and BPD Cycles.

Responsibilities:

Involved in Management of ‘Security’ in shared services for Hyperion Planning, Essbase, Financial reports and Smart View. Created native users, groups and provisioned them with appropriate application roles which includes user provisioning using MSAD and native authentication.

Worked with Budget Formulation Team, Execution Team and Working Capital Team in gathering requirement for OPs and BPDs.

Updated COBRA applications with Fund Codes, Program Codes and Projects as per Sub activity Line Item Listing provided by teams.

Updates Object Classes and helped users with loading Bureau Over Head rates, IT Service rates and Other Over Head rates for Projects as per Schedule Rate Bulletins (SRB).

Involved with user fixing issues with Overhead rates calculations for Project Part Divs.

Involved with users and fixing employee transfers, missing employee properties and incorrect comp days for employees in PL application.

Involved in taking Snap shots of data after Budget is submitted for Congress for approval from ‘V- Curr’ to ‘V-Enact’ and to different versions as required.

Involved in Supporting and fine-tuning Project Management Application (PMA), a home-grown application used to keep track of meta data used in Hyperion Planning developed using ASP.net and SQL Server backend database.

Designed and implemented Strategies for Server backup and Disaster recovery for Oracle Hyperion EPM.

Involved in checking daily backup of Oracle EPM data and trouble shooting when backup fails.

Involved in Design and enhancement of Hyperion Financial Reports for HP applications using Hyperion Financial Studio.

Developed prototype of Tableau reports for Demo purpose connecting to HP and relational databases.

Involved in fine tuning of Essbase applications and improving documentation for all the data flow jobs in Oracle Data Integrator (ODI).

Involved in bug fixing of ODI jobs, created versioning of packages and regenerated Scenarios. Migrated ODI components Scenarios from DEV to TEST and PROD environments.

Developed and fine-tuned Business rules, calc scripts and report scripts on need basis.

Involved in supporting users during the data validation, Security setup, Smart View report issues, Hyperion Forms issues etc.

Migrated Hyperion Planning, Hyperion Essbase applications and Hyperion Financial Reports between the environments and is the single point of contacts for maintaining the DEV, QA and Production environments related to Hyperion Products.

Involved in day to day activities of solving user issues, bug fixes, application issues and applying patches to different Hyperion Products.

Gave a demo for Budget User’s for Business Objects flavor of financial reports from data ware house.

Worked on ODI component used for running jobs between different environment.

Involved in Daily, Weekly and Monthly activities related to Hyperion Products such as Hyperion Essbase, Hyperion Planning, Hyperion Reports, ODI, Smart view reports in all three environments DEV, TEST and PROD.

Daily Support Users on different issues such as running Lev0 Exports, granting user access, checking for Backup process, performing data validation as per tickets opened in Share point.

Installed Web logic patches, Hyperion patches on monthly basis to take care of Security SCANS.

Environment: Hyperion System 11.1.2.500, BI, BI + Financial Reporting, Hyperion Reports 11.x, Hyperion BI + Smart View for Office, Hyperion Excel Add-In, Web logic 9.x, Oracle data Integrator (ODI), EAS, Windows Shell Scripting, DB Artisan, Toad 8.6.0, Oracle 11g/12g, UNIX and Windows 2008 Adv. Server, SQL Server, ASP.Net etc.

AOL LLC, Dulles, VA Jul’08 – Aug’16

Position: Senior Software Engineer (Hyperion SME)

Project Title: CPM (Corporate Performance Management)

Corporate Performance Management System includes Planning/Forecasting, consolidations and Financial Consolidations and reporting. It replaced the present system SAP BPS/BCS at corporate level with Hyperion Planning and Hyperion Financial Management. This system creates a worldwide platform for Planning, Consolidation and Financial and Management Reporting. This system reduces the Planning and Forecasting Cycle times. It reduced the actual reporting cycle times and improved the consistency and timeliness of management reporting within the Business units as well as Corporate Level. Improved the allocation process and multicurrency consolidations and reporting.

Responsibilities:

Involved in Management of ‘Security’ in shared services for HFM, Hyperion Planning, Essbase, Financial reports and Smart View. Created native users, groups and provisioned them with appropriate application roles which includes user provisioning using MSAD and native authentication.

Involved in Design and development of Hyperion Financial Reports from HFM and HP applications using Hyperion Financial Studio.

Developed prototype of Hyperion Web Analyzer reports for Demo purpose connecting to HFM, HP and relational databases.

Developed automated batch scripts using visual basic scripts which extracts metadata security from planning application, backing up Essbase Cubes, Hyperion Shared Services, oracle repositories and refreshes the Hyperion Planning applications on demand.

Worked with users in design sessions and gathered user requirements of the project for the development of Hyperion Business rules, Web forms and calcscripts.

Involved in supporting users during the data validation and system testing process throughout the life cycle of the project. Also involved in the development of Smartview reports for users as per requirements.

Migrated HFM, Hyperion Planning, Hyperion Essbase applications and Hyperion Financial Reports between the environments and is the single point of contacts for maintaining the DEV, QA and Production environments related to Hyperion Products.

Involved in day to day activities of solving user issues, bug fixes, application issues and applying patches to different Hyperion Products.

Involved in design of Security classes and native Security groups for HFM applications based upon the users’ requirements.

Involved in Design and development of Metadata Security and Native Security groups for Hyperion Planning application based upon the user requirement.

Designed and developed calcscripts and Business rules as per user requirements. Also involved in fine tuning and maintenance of the business rules.

Automated the Calculation Scripts to run as scheduled jobs using Visual basic scripts using MaxL and ESSCMD commands.

Involved in Design and Developed HFMACT cube for reporting Actuals for Field Finance Accounting users. Data is loaded into Cube from HFM using HFM Extended Analytics and Essbase SQL interface.

Involved in Monthly Master Data update for HFM application and Hyperion Planning applications using DRM.

Involved and designed the Actuals Master Data mapping and logic changes as per business for loading Actuals from SAP Systems.

Developed ‘Business Object’ reports using Oracle database for Planning Users to monitor the data in Data warehouse for Planning Purposes.

Designed and developed the Head Count Text file used to load Head count data into SAP BPC as per business requirement using SAP BODS.

Involved in testing of loading SAP – BPC data into Essbase Cubes and then validating the data.

Involved in automating Tax Extract DIM interface using VB Script and Windows batch scripting.

Environment: Hyperion System 11.1.2.1, BI + Web Analysis, BI + Financial Reporting, Hyperion Reports 11.x, Hyperion BI + Smart View for Office, Hyperion Excel Add-In, Web logic 9.x, Hyperion Data Relationship Management (DRM), Hyperion Data Integration Management (DIM), Hyperion Financial Data Quality Management (FDM), Hyperion Financial Management, Hyperion Integration Server, EAS, Windows Shell Scripting, DB Artisan, Toad 8.6.0, Oracle 10g/11g, UNIX and Windows 2003 Adv. Server.

OFFICE DEPOT, Delray Beach, FL Mar’08 – Jul’08

Position: Senior Hyperion Developer

Project Title: FMR (Financial Management Reporting)

This FMR cube (BSO) is developed using Hyperion System 9.3.1 which has Hyperion Essbase on UNIX system while AAS, Shared Services, BI+ and Workspace are installed on Windows Servers. Data was fed into cube on Monthly feeds in form of Text files which are generated from Legacy main frame, Peoplesoft Financial and Oracle Financials. Data load rules are created to load text files and calculation scripts are executed to do calculations. This cube consists of 10 dimensions and 7 attribute dimensions.

Responsibilities:

Involved in design and development of data load rule files for the cube which uses text files for loading data into cubes.

Developed a report script which retrieves the data values from FMR cube and will be loaded into FMR_RTL cube for further analysis.

Developed calculation scripts and outline calcs for different account members based upon the input level zero values for members NoOfWeeksPerMO and NoOfWksStrOpen.

Involved in design and development of PERL scripts on UNIX box for Essbase automation of FMR and FMR_RTL cube.

Involved in Supporting the ‘Tableau’ templates which are used on top of Essbase Cube for users.

Environment: Hyperion System 9.3.1, BI + Web Analysis, BI + Financial Reporting, Hyperion Reports 9.x, Hyperion Interactive Reporting 9.x, Hyperion BI + Smart View for Office, Hyperion Excel Add-In, Web logic, Hyperion Integration Server, EAS, Windows Shell Scripting, Toad 8.6.0, Oracle 9i/ 10g, UNIX and Windows 2003 Adv. Server.

WACHOVIA BANK Apr’07 – Feb’08

Position: Senior Hyperion Developer / Senior Essbase DBA

Project Title: Oracle Financials General Ledger Implementation

The Hyperion System 9.2 with HIS is used on Windows environment for this General Ledger Implementation. Oracle financial GL feeder is fed into Oracle Data Mart from which Autosys jobs are kicked to load data into Essbase cubes through EIS Models and Metaoutlines. Cube dimensions are build using EIS metaoutlines while data is loaded into cubes through SQL-interface and using load rule. These cubes are run as “Interim” and “Final “cubes to release data to users. The cube built is BSO Model, which has a transparent partition with 4 different cubes names Day4, CLSCY0, CLSPY1 and CLSPY2. The dimensions are maintained using “Hyperion Meta Data Management (HDM)” system for all the cubes. The data mart tables are maintained in Essbase Data mart built in Oracle RDBMS.

Project Title: Enhancement of Set of Books for Hyperion Essbase cubes

This is a redesign of the Foreign and Europe Cubes, which have set of Book values for different currencies.

They are built for individual currencies based upon the country of business and the set of books is fixed. New 9 cubes are designed based upon the functional currency of the business. They are Argentin, Brazil, Chile, Uruguay, Paraguay, Euro_USD, Euro, Sterling and Japan.

Responsibilities:

Exposed and Involved in installation of System 9 BI + Software on Windows 2003 Server on development servers and on Sandbox servers.

Involved in Outline design, maintenance of batch scripts using Auto Sys jobs for running calc scripts and backup scripts.

Involved in Migration of Essbase cubes, Hyperion reports, Analyzer Report groups and EIS Models & Meta outlines from Dev Environment to Prod Environment.

Developed Set of Books Essbase cube from the SOB oracle system (which was phased out later on).

Involved in user provisioning of users for different applications from Shared Services in System 9.x.

Developed automated server start up of agents. And also automated the login scripts for automatic monitoring of the agents on all Windows servers.

Involved in designing Star schemas for loading dimensions and data into Essbase cube through EIS and SQL interface.

Involved in developing OLAP Models and Meta Outlines using EIS interacting with Oracle RDBMS Essbase data mart.

Involved in Migration of Hyperion Interactive reports, Hyperion Financial reports and Hyperion Web Analysis reports in System 9.x.

Designed Interactive Reports with charts, drill down and sorting functions.

Designed and developed Dashboards and added the components to the Dashboards.

Involved in Software upgrades from Essbase 7.1.2 to 9.2, Financial Reports and Web Analysis/ Analyzer 7.2 to 9.2.0.

Developed dynamic dim builds and data loads using ESSCMD, MAXL and WSH Scripts.

Created Web forms and loaded dims into Hyperion Planning application using HAL.

Involved in data refreshes from Planning desk top and designed business rules for data calculations.

Involved in production Support of GL Cubes, Europe and Foreign cubes and also weekend support for users.

Developed automation of User creation, granting user’s access through groups and cube build by Windows Shell scripting, Perl Scripts and Batch files.

Involved in Migration of Objects through “Harvest” version control tool.

Environment: Hyperion Essbase System 9.x.0, BI + Web Analysis, Hyperion Analyzer 9.x.0, BI + Financial Reporting, Hyperion Reports 9.x, Hyperion Interactive Reporting 9.x, Hyperion BI + Smart View for Office, Hyperion Excel Add-In, Apache Tomcat, BI + Analytic Integration Services, Hyperion Integration Server, EAS, MySQL, Windows Shell Scripting, Toad 8.6.0, Oracle 9i/ 10g, UNIX and Windows 2003 Adv. Server.

SPRINT-NEXTEL Jun’04 – Apr’07

Position: Senior Application Developer / Senior Essbase DBA

Project Title: People Soft Financial Reporting – Human Resource & Supply Chain Management

A total of 16 cubes were designed, developed and moved into production from different environments. Bad Debt, Flat fee and Tax fact are the tax cubes, which are designed to support the different tax structures, which are being used to show government. With these they are able to get tax benefits from the government. These cubes are developed initially using the text files and later on they were converted into Integration cubes and loaded data directly into them from oracle.

HR cube, TNL cube and Org Rpt cube are classified as Human Resource cubes which are mainly used to keep track of employee benefits and payroll structure. They are designed to use text files, as the data available to load is less. Inv Cube, Asset Cube and Epp Boost cubes are designed to keep track of inventory, Assets and mobile phones services. They are designed to use text files as well as loading data into them using Integration server.

CC Cube, DS Cube, IP cube; JPM Cube, Open PO Cube, PS Cube and Vendor cube are classified as Supply chain Management Cubes. These cubes are mainly used to keep track of Credit Card usages, Diversity status spread, JP Morgan financials, Open Purchase orders, People Soft financial, Item price of different items across different vendors and keep track of spend on different vendors. All these cubes are developed to load data using the text files.

ITFM cube is a Hyperion Planning cube, which is designed and developed by Ranzal Company to Nextel. Involved in design of data refreshes, updating the dimensions using HAL and also in development of data entry sheets. Front end reporting is done using Analyzer, Hyperion Reports and Excel spreadsheet for data retrievals. Analyzer is installed using Web Sphere and on Windows 2003 platforms.

Responsibilities:

Involved in gathering specifications, designed and development of outlines for cubes.

Developed batch scripts using Windows Shell Scripting (WSH) and Perl Scripts to build dimensions dynamically and load data into cubes and scheduled those using windows scheduler.

Involved in design and development of OLAP Models and Meta Outlines in Essbase Integration Server. Installed Server and Client on Windows 2003 Platforms and maintained the Meta data catalog in Oracle on Unix Servers.

Installed Web sphere 5.x on Windows 2003 and Windows 2000 Advanced Servers and later on installed Analyzer, Hyperion Reports on development and production servers on Windows platforms.

Configured the Analyzer into IBM Web Sphere and involved in maintenance of Analyzer and Web Sphere.

Involved in Upgrade of Essbase from 6.5.4 Version to 7.0 Version, Essbase Integration Server from 6.5.1 to 7.1.2 and Analyzer from 6.5.1 to 7.0.1 versions.

Exposed and Involved in installation of System 9 BI + Software on Windows 2003 Server on development servers and on Sandbox servers.

Involved in migration of Essbase objects, Analyzer Reports, Hyperion Reports, Hyperion Interactive Reports and OLAP Models and Meta Outlines from different environments.

Created OCE connections, Data models and synchronized the Data models with the underlying databases.

Involved in Publishing BQY documents, scheduling BQY jobs and managing BQY jobs in the Job Manager Module.

Involved in maintenance of Hyperion Planning cube, involved in creation of Web Forms, data refreshes and user creation in Planning.

Environment: Hyperion System 9 BI + Essbase Analytics, Hyperion Essbase 6.x / 7.x, BI+ Web Analysis, Hyperion Analyzer 6.x / 7.x, BI + Financial Reporting, Hyperion Reports 4.x / 7.x, Hyperion Interactive Reporting 6.x / 8.x/ 9.x, Hyperion System 9 Financial Management, Hyperion Planning 4.x, HAL 3.x, Hyperion Business Rules, Hyperion Excel Add-In, Windows Scripting, Web Sphere 5.x / Apache Tomcat, My SQL, Essbase Administration Services 6.x / 7.x, BI + Analytic Integration Services, Essbase Integration Services 6.x / 7.x, Toad, Oracle 8.x/9.x/ 10 g, Windows NT, 2000 Advanced Server, 2003 Server and UNIX HP.

ALCOA (Aluminum Corp of America) Jun’03 – May’04

Position: Senior Essbase DBA / Senior Applications Developer

Project Title: AR Credit Report System

The Essbase 6.5.4.3 OLAP system works on Unix HP for Credit Reporting System used in Credit Analysis of the customers and cash inflow of funds. The data is fed from OLTP systems into Global data warehouse, which is built on star schema design. Fact tables are available with summarized views for data feed. From Global data warehouse the summarized data is fed into Region data warehouses. From Region data warehouse data is fed into Essbase cubes. Here four cubes are built based upon regions such AR_ NA, AR_Eur, AR_Global and AR_AUS. These cubes have eight dimensions namely Time Periods, Measures, Customer, Credit Location, Sales Location, Entities and Country. Reports are designed using Hyperion Reports and Hyperion Analyzer. Cubes are built for every 6 months.

Project Title: GL – Analytics (General Ledger Implementation)

Implementation of General Ledger and Sub ledgers on GL-Analytics Cubes. Here 2 cubes are developed for Closing and forecasting of cash flow, balance sheet and asset management. Financial reports are designed using Hyperion Reports and Hyperion Analyzer. GL_Close cube is used for closing of the general ledger where all data is fed from Global data warehouse during the month close from 30 – 5th of every month. While GL_Hist is used for financial forecasting. Cubes are built monthly and also scripts are run for on demand to eliminate fragmentation. Schedule the calc scripts by Cron jobs on UNIX environment. UNIX shell scripts and Perl scripts are written for this purpose.

Responsibilities:

Involved in Outline design, maintenance of batch scripts using Cron jobs for running calc scripts and backup scripts. Backup scripts are written in Perl scripts and are activated by Unix shell scripts.

Developed automated server start up of agents. And also automated the login scripts for automatic monitoring of the agents on all Unix servers.

Developed many load rules for loading metadata from Dimensional Repository and loading data from Global data warehouse through running oracle concurrent programs. Perl scripts are used to automate the process with the help cbs files, oracle responsibilities and cbs templates. Data is loaded into cubes through EIS interfaces, which are developed in Perl scripts and are scheduled on demand.

Created security filters, groups and implemented LDAP authentication. Also involved in design of External authentication for all applications across all platforms.

Involved in Software upgrades from Essbase 6.0 to 6.5.4.3, Reports and Analyzer 2.0 to 2.6.

Involved in migration of objects, reports, analyzer report groups and business rules from one environment to another environment.

Involved in imports and exports of objects from one environment to another environment.

Involved in imports and exports of data for weekly maintenance to reduce fragmentation.

Involved in fine-tuning of cubes, calc scripts and business rules which reduced cal times and retrieval times.

Environment: Hyperion Essbase 6.X., Hyperion Analyzer 2.X, Hyperion Reports, Hyperion Business Rules, Hyperion Excel Add-In, Shell Scripting, Toad, Oracle, Windows NT and Unix HP.

DISCOVER FINANCIAL SERVICES Jan’03 – May’03

Position: Analyst Programmer

Project Title: Financial Management System

The Essbase 6.0 OLAP system works on Microsoft Windows NT for Financial Management System used in Financial Forecasting. The data is fed from FMS-GL system and feeder files from 13 other DTE applications by FTP in batch processes. The outline consists of major dimensions viz., Organization structure, Accounts, Scenario, Locations, Time. Essbase Excel add-in is used for analysis purpose. Filter authentication is used to maintain security of the database.

Responsibilities:

Involved in Outline modifications, maintenance of batch scripts, scheduling runs, developing report scripts and calc scripts.

Developed many load rules for loading specific type of data files. Extensively used ESSCMD to run calc scripts.

Involved in Essbase supervisory activities such as filter creation, creation of users, creation of groups and related activities.

Developed utilities using Visual Basic for the purpose of Essbase database administration.

Environment: Hyperion Essbase 6.5, Hyperion Analyzer, Hyperion Excel Add-In, Shell Scripting, Toad, Visual Basic 5.0, Oracle, Windows NT and Solaris.

TUFFY AUTOMOTIVES CORPORATION Nov’02-Dec’02

Position: Analyst Programmer

Project: Automated Sales Information System

This application was mainly emphasized on flow of auto part sales that has more than 250 members built on 10 different tables using Oracle database. This system provides monthly reporting of Sales of different auto parts in different regions. Users can feed the data through forms, views different reports and also search for transactions on a given day.

Responsibilities:

Responsible for system enhancement, maintenance and administration.

Interact with users to support analysis, provide definitions and requirements for the auto parts Sales report Forecasting.

Involved in development for data loading and written Calc scripts.

Involved in the development of Stored Procedures Using T-SQL.

Environment: Hyperion Essbase 6.0, Hyperion Excel Add-In, Shell Scripting, Visual Basic 6.0, SQL Server 2000, Windows NT and Solaris.

SPECIAL OLYMPICS MICHIGAN Sep’00-Oct’02

Position: Analyst Programmer

Provided high-level support of mission-critical Hyperion Essbase applications to a community of 7000+ users worldwide, resulting in 100% customer satisfaction rating, improved data integrity, and minimal downtime in a 24x7 production environment.

Optimized AIX systems and Essbase databases, including performance tuning, monitoring of resource distribution, and security administration.

Modified Essbase report scripts, data load rules, and calculation scripts to help customers quickly and efficiently calculate and load data.

Developed Reports for the Raiser’s Edge Software Using Seagate Crystal Reports.

Import the data into Raisers edge software and perform database administration on Raisers edge software.

Designed and Developed of Car Management System using MS-Access.

Implemented Online Accreditation System Using Active Server pages, HTML, DHTML and JavaScript.

Developed and Implemented MULTIUSER Calendar using ASP, HTML and VBScript.

HAWAII PACIFIC UUNIVERSITY Feb’00-Jul’00

Position: Data Processing Assistant

Designed and developed Alumni database using MS-Access for Office of Alumni Relations.

Maintained and monitored data files, master files, mails updates and deletes.

Imported the entire database into Raisers Edge Software. By doing so it reduced maintenance bills for the Alumni office. This saved the Alumni office $10,000/year.

LINTON SDN. BHD., IPOH, MALAYSIA Sep ‘97 to Oct’ 99

Position: Senior Programmer

Project: Auto Insurance Financial System

This application was developed for Linton Sdn. Bhd. for financial analysis of their auto insurance. This system provides monthly reporting of Linton Sdn. Bhd. The key data dimensions in the database include Time, Currency, Organization and Profit & Loss Accounts. Essbase add-in is used with MS Excel for reporting purpose.

Responsibilities:

Involved in analysis, development and enhancement of database (MDDB) outlines.

Involved in development of rules file objects for data loading.

Involved in development of calc scripts and development of reports.

Also responsible for DBA functions such as user creation, security profiles, authorizations.

Environment: Hyperion Essbase 5.02, MS DOS, MS Excel 7, Windows NT, Remotely Possible 32.

Revenue Tracking System (RTS) April’96-August ‘97

This application was developed for “Super Kinta” using star schema design, Essbase OLAP Server and Hyperion Analyzer for reporting. RTS data is extracted from “Home” system that tracks distributors sales (Point Of Sale) and their backlog to End Customer. A Star Schema Data Mart is loaded with End Customer Backlog and Shipment every night. Then the MTD shipment is replaced with Actual Revenue after the Month Close. Essbase dimension build and Data Load are automated using ESSCMD scripts, embedded in UNIX Shell.

Responsibilities:

Involved in design and development of the entire modules like Plan and Analyze the Data, Defining Dimensions etc.

Build the Out Line and Developed Calc Scripts in the Hyperion Essbase for the BRM reporting.

Developed Load Rules Files, for loading data from Star Schema to the Essbase Cube.

Performed Interactive and Batch Operations using ESSCMD.

Environment: Essbase 5.02, Essbase Spread sheet Add In, Visual Basic 5.0, Shell Scripts, Windows NT

And Solaris.

BRAIN SOFT TECHNOLOGIES, INDIA Apr’91-Oct’93

Position: Junior Programmer

Steel Plant Status Monitor System: This system consists of sensors throughout a steel shop connected to PLC's and a PDP 11/84, a FORTRAN program on the PDP to provide a customizable user interface to the Shop Synchronization System program, and the Shop Synchronization program itself, and running on a Compaq Deskpro/386. The program is written in C and Assembly language.

Packing Line Control System: Completed the implementation of a supervisory control system for a group of packing machines. This system was written in C, running on a PC using the QNX real time operating system.

HYPERION TRAININGS ATTENDED

Hyperion System 9 BI + Analytic Integration Services: Create and Manage Data Structures (For Versions 7.x &

Contact this candidate