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 Confidential,Software Consultant Jul’08 to Dec’08

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

Confidential, 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

Confidential,Corporate Finance/Systems Apr’04 to Jul’07
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

Confidential, 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.

Confidential, 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

Confidential,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

Confidential,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

Confidential,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

Confidential,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.

Confidential,Feb’95 – Oct’95

Software Engineer - (Banking application)

• Responsible for Tele-banking application development.

Environment : - Windows,Borland C++

Confidential,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.

Confidential,Nov’91 – Aug’92

Systems Executive – (Accounting Software)

Involved in developing Accounting software.

EDUCATION AND PROFESSIONAL TRAINING

Bachelor of Engineering (Computer Science)