Software Data

SANTOSH R. FURTADO

Toms River,New Jersey

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

Phone: 609-***-****

OBJECTIVE

A senior full time/contract position that utilizes my experience with large corporates in Financial

Services,Big-4 Consulting,Global manufacturing and banking industries in project management, system

design, large databases,data warehousing, OLAP, Hyperion tool set, Essbase, Planning, Reports and other

related tools, data analysis, modeling, integration, transformation and replication of data

QUALIFYING SUMMARY

Diverse professional & technical experience with a strong record of successful project management, design,

development and implementation of software projects in various industries.

10+ years of experience in software design, development, Quality Assurance, debugging & testing, time

•

management and maintenance using various technical tools.

5+ years of Hyperion Essbase(OLAP)5.0+,6.1,7.0,Hyperion System 9,Excel VBA, Visual Basic, Oracle,

•

SQL and data warehousing experience

Strong Essbase development experience in a planning environment.

•

Experience with supporting the planning implementation at NASDAQ.

•

2+ years of project management and implementation experience.

•

Proven analytical and problem-solving skills.

•

Excellent verbal and written communication, networking and organizational skills.

•

A collaborative team player with the ability to inspire, improve and effectively support others.

•

TECHNICAL SKILLS

Visual Basic 6.0,5.0,COM, DCOM, SQL 2000, Visual Source Safe, MS Office Suite, Excel VBA, ’C’,

AS 400,Borland C++, SQL Server 6.5, Oracle 8i,9i, Ingres 6.4, SCO UNIX, Novell Netware 4.1, Peoplesoft

Financials,Commander Decision(Comshare), Hyperion Essbase (6.2), 6.1,7.0,Hyperion System 9, Hyperion

System 9 Planning, Web Analysis, Hyperion Reports, SmartView,Arc Plan, Showcase Analyzer, Shared

Services, Enterprise Reporting, Warehouse Builder, Essbase API, Brio Query, Windows API,MS Project,

Visual Interdev, Cognos.

PROFESSIONAL EXPERIENCE

Phoenix Group

Jul’08 to Dec’08

Software Consultant

Providing application support and development of Hyperion Planning and Essbase (System 9)

applications for the New York Stock Exchange(NYSE). Created report templates and supported the

Planning application during the Budgeting cycle,modified and maintained smartview templates.

Worked with Arc Plan reports. Created Essbase application and load rules for American stock

exchange data upload . Resolved issues related to actuals data update using HAL.Created Adhoc Excel

VBA Budget/Forecast variance reports for the Controllers group.

Environment : - Windows NT,Hyperion Planning System 9,Essbase,Hyperion Reports,Web

Analysis(Analyzer), HAL(Hyperion Application Link), Smart View, Excel VBA, ArcPlan, SAP

Star Point Solutions Jul’07 to Jun’08

Software Consultant

Providing application development and support of Hyperion Essbase 7.1 applications at Ernst & Young.

Performed changes to Planning template as per business requirement during the Budgeting/Forecasting cycle.

Automated batch routines for Essbase7.1 application load and calculations using SQL server scheduler.

Recommended changes to user security and resolved security related issues. Resolved Hyperion Reports

related issues. Made changes to calc scripts based on user specifications.

Environment : - Windows NT,Hyperion Essbase 7.1,Hyperion Reports,Excel VBA

NASDAQ

Apr’04 to Jul’07

Corporate Finance/Systems

Responsible for providing support to the Corporate finance/Financial Planing & Analysis team for system

changes and enhancements to the hyperion planning application. Responsible for system admin functions of

the application, creating dashboard using Hyperion Analyzer(Web Analysis) and recommended enhancements

and improvements to the various processes.

Managed the complete upgrade of application from Essbase 6.4/Hyperion Planning 3.0 to Hyperion Planning

System 9. Created adhoc actuals reports in Cognos/Peoplesoft for reconciling data between Hyperion and

Peoplesoft. Developed the Metrics application in Essbase and also developed calc scripts for consolidations.

Involved in writing scripts to load the data into the OLAP cubes using batch scripts.

Provide 24/7 supports for Hyperion System 9 BI+Servers. This includes providing Administration to

Hyperion System 9 BI+Servers.

Load Daily, Weekly, Monthly extracts into the Planning application and then build reports using Hyperion

System 9 BI+ Interactive Reporting and Oracle Essbase. Work with end users to understand the requirements

and create Technical and Functional documentation

Environment : - Windows NT,Hyperion Planning 3.1,System 9,Essbase,Hyperion Reports,Web

Analysis(Analyzer), HAL(Hyperion Application Link), Smart View,Sql Server6.5/2000,MS Access,Excel

VBA,Peoplesoft Financials

SARA LEE FOODS Apr’02-Apr’04

Corporate Reporting Developer (Knowledge Management (Data Warehousing)Team)

Responsible for requirement analysis, design, development and support of Corporate reporting.

Involved in analysis and developent of web interfaces for Hyperion Essbase 6.4 multidimensional database

models using Visual Basic 6.0, Excel VBA 7.0, Essbase 6.4 API, Showcase Analyzer & Enterprise Reporting.

Defining report specifications for Business Analysts and Financial Analyst.

• Developing Data Analysis web reports using Hyperion Analyzer and adhoc reports using ETL fact table

work files, Excel VBA and Enterprise Reporting.

• Designing Essbase cube outlines using SQL scripts to extract data from fact tables.

• Automating the outline building process and cube calculations using Showcase Warehouse Builder.

Environment : - IBM AS400,SPSS,Showcase Analyzer,Enterprise Reporting, Ascential Data warehouse,

Excel VBA, Manugistics, JD Edwards, Siebel Analytics.

STAPLES, INC Mar’99-Mar’02

Principal Analyst/Programmer (Labor Mgmt Budget and Forecasting Decision Support applications)

Responsible for requirement analysis, design, development and support of Labor Management and Decision

Support applications for all US Stores.

• Involved in developing interfaces for Hyperion Essbase multidimensional database models using Visual

Basic 6.0, Excel VBA 7.0 & Essbase 5.1 API. Optimizing and enhancing the Labor

Budgeting/Forecasting models.

• Involved in creating Essbase cubes, calc scripts, load rules for adhoc analysis & reporting, release and

application provided upgrades.

Coordinated business requirement analysis, data analysis, cleansing & transformation for the Oracle Data

•

warehouse. Understand OLTP system architecture and create data extraction routines using SQL

Packages from the source system.

• Automated the complete process from data extraction to updating/loading model and calculations.

Environment : - Windows NT,Hyperion Essbase 5.1,Hyperion Reports,Analyzer,Excel VBA,Oracle 9i

WILLRICH SCOTT CONSULTING GROUP Aug’98 – Mar’99

Senior Business Consultant – TRICON, Texas (Cost Analysis application)

• Involved in Project management, design, development of applications for the Cost analysis department.

• Successfully developed interfaces for accessing Hyperion Essbase 5.1 Multidimensional database models.

• Optimized, automated the Essbase data load and calc process, created data entry modules and reports

based on business requirements.

Environment : - Windows NT,Hyperion Essbase 5.1,Hyperion Reports,Analyzer, Excel VBA

GULF COMPUTERS Mar’98 - Aug’98

Senior Software Consultant – United Companies Funding, Minnesota (Finance application)

• Created generic data entry forms, Timer routine, database connectivity, printing and string modification

routines for the financial department using Visual Basic 6.0.

• Involved in developing SQL scripts for querying the database in SQL Sever 6.5.

• Designed and developed generic functions, COM, DCOM objects using Visual Basic

• Developed encryption and decryption (XOR variation) routines.

Environment : - Windows NT,Visual Basic 6.0

ADVANCE BUSINESS SYSTEM Mar’97 – Feb’98

Senior Software Consultant- Emirates Telecommunications Corporation (ETISALAT)

• Responsible for system study/analysis, data modeling, extraction, integration & transformation. Involved

in complete life cycle of project.

• Creating PL/SQL scripts to extract data from OLTP system, cleansing the data, loading it to Essbase 4.0

and creating calc scripts.

• Creating reports using Crystal reports and Excel VBA and adhoc analysis screens, reports.

Environment : - Windows NT,Unix,Essbase 4.0,Oracle 7,Commander Decision,Dashboard,Excel VBA,

Visual Basic 6.0

EMIRATES GOLF CLUB Nov’95 – Mar’97

Systems Manager (Supervisor) – (Accounting, Food and Beverage, Point of Sale and Golfing applications)

• Responsible for managing software and hardware personnel for the implementation of the project and

interacting with the hardware/software vendors.

• Involved in implementing, integrating of FIDELIO (clipper), CHAMELEON (Accounting) and MICROS

(Point of Sale) software’s.

• Analysis of current system and recommending hardware/software implementation strategies & procedures

to senior management.

Environment : - Windows NT,Sco Unix,Novell Netware,Clipper,Fidelio,Chameleon,Micros.

TRILOGY, INC Feb’95 – Oct’95

Software Engineer - (Banking application)

• Responsible for Tele-banking application development.

Environment : - Windows,Borland C++

BENNETTE COLEMAN & CO. Oct’92 – Jan’95

MIS-EDP Supervisor

Responsible for handling the daily operations of EDP department

Managed development of software for supporting the corporate systems and network operations.

• Maintained and enhanced operating and associated systems & ensured efficient and secure dataset

allocation and administration.

• Monitored performance of the network and coordinated hardware maintenance with engineers.

• Handled complete computerized billing operations for the branch & performed database admin. tasks

Environment : - Unix,Ingres.

INSTITUE OF COMPUTER INFORMATION AND TECHNOLOGY Nov’91 – Aug’92

Systems Executive – (Accounting Software)

Involved in developing Accounting software.

EDUCATION AND PROFESSIONAL TRAINING

Bachelor of Engineering (Computer Science)

Contact this candidate