Developer Data

Jigesh P.

Jigesh (***)

***-****

***-****

Hyperion Essbase/ BI Developer

********@**************.***

Summary of Qualifications:

Over 6 years of professional IT experience working with Project Implementation, Client-Server

•

applications in a Data Warehousing environment.

Over 4 years of experience in design, analysis, development and implementation of various

•

applications in Client/Server OLAP environment using Hyperion Essbase, Hyperion Analyzer,

Hyperion Reports, Hyperion Planning, Business Intelligence.

Experience on the installation, configuration, server settings, client and server installations of

•

Hyperion products such as Hyperion Essbase, Essbase Administration Services, Essbase

Integration Services, Hyperion Financial Management, Hyperion Planning, Hyperion Analyzer,

and Hyperion Reports on Windows environments.

Knowledge of Software Development Life Cycle of OLAP applications.

•

Designed and developed numerous Essbase applications with excellent balance of dense and sparse

•

dimensions, developing various OLAP Models & Meta-Outline.

Involved in writing custom Essbase calculations scripts, automated the Essbase Cubes using MaxL,

•

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 Schema modeling and E-R modeling techniques for data warehouses/marts, and the tools

•

for automation of OLAP.

Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude

•

to learn new technologies.

Technical Expertise:

Hyperion Tools: Hyperion System 11.1 / 9.3: Essbase Administration Services, Hyperion

Financial Management, Hyperion Planning, Hyperion Workspace,

Hyperion Shared Services, Hyperion Business Rules, Hyperion Financial

Reporting, Hyperion Interactive Reporting, Hyperion Smartview.

Operating Systems: MS-DOS, UNIX, WINDOWS 98/2000/NT 5.0/XP

Databases: Oracle 9i/8i, DB2, MS SQL Server 2000, MS Access, Toad 8.0

Hardware Platform: SUN Solaris, Windows 2000/NT Servers

Languages: C, MS Visual C++, PL/SQL, Visual Basic 6.0

Dimensional Modeling: Star-Schema Modeling, Snow-Flake Modeling, Fact and Dimensions

Tables, Physical and logical data modeling

Professional Experience:

Client: Target, Minneapolis, MN

Dec’08 – Jan’10

Role: Sr. Hyperion Developer

Role & Responsibilities:

Frequent Interaction with Business Users to gather Requirements and understand the current

process in use.

Managed User Security in Hyperion Shared Services.

Responsible for creating and modifying crystal reports

Applied Security to Entity Dimension in Planning.

Developed Web Forms, User Variables, Smart Lists based on the user requirements.

Developed Microsoft Excel Template and used built in Essbase Data Load feature to load data

Developed Outline using Rules files and Parent-Child Methodology.

Developed complex Business Rules to work with Web forms on Save.

Created Substitution Variables and used them in web forms, Business Rules and Reports.

Involved in optimization and remediation process of business rules to reduce calculation time.

Educated Users in implementing Hyperion Smartview feature.

Responsible for analyzing business requirements and developing queries and reports using Brio

ad hoc query tool to provide Web-enabled data analysis solutions.

Developed Executive Dash Boards to accomplish launching various Reports.

Environment: Essbase Administration Service 9.3, Hyperion Planning 9.3, Hyperion Shared Services

9.3, Hyperion Financial Data Quality Management 9.3, Hyperion System 9- Interactive Reporting, SQL

Server 2005, Crystal Reports, .Net framework, Windows Vista/XP/2003.

Role: KnowledgePoint360, Secaucus, NJ Dec’07 –

Nov’08

Role: Hyperion Developer

Role & Responsibilities:

Worked with Business Users in understanding the current working process and understanding

their requirements.

Developed and managed application outline.

Developed WebForms, Composite WebForms, Task List and Menus based on the

requirements.

Developed WebForms using User Variables.

Owned complete application from design to development and into the implementation phase.

Developed Complex Business Rules for calculations.

Used Xref function to move data from one cube to another.

Optimized Business Rules to increase performance and reduce calculation time.

Trained users on the use of Hyperion Smartview.

Developed financial reports using Hyperion Financial Reporting Studio.

Managed reports into folders and books in Hyperion Workspace.

Provided technical assistance to end users and build documentation.

Environment: Hyperion System 9x, Hyperion Planning 9.3.1, Hyperion Financial Management,

Hyperion Financial Reporting 9.3.1, FDM 9.3.1, SmartView,, HFM 4.x, Hyperion Reports 7.x,Oracle 9I,

Hyperion Visual Explorer,, Windows 2000 Advanced Server, Windows 2000/2003NT.

Role: Cinergy, Cincinnati, OH Oct

‘06 – Nov ‘07

Role: Hyperion Developer

Role & Responsibilities:

Worked with Functional and Development team during the pre-implementation phase of the

application.

Implemented Hyperion Planning 3.5 and worked with Hyperion Planning in developing web-

based forms for the various budgeting purposes and implemented whole security matrix in

Hyperion Planning.

Using Hyperion System 9 BI interactive Reporting studio created various reports to provide

executives, business user and analyst with intuitive user-directed relational query and capabilities.

Developed and maintained metadata using Essbase Integration Services.

Configured Essbase objects like Outline, Rules File, Calc Scripts, Caches, etc to improve

application performance.

Migrated HP applications from dev to prod.

Developed Web Forms in Hyperion Planning for user data inputs.

Developed Hyperion Business Rules(HBR) for complex calculations.

Interacted with users to support analysis and provide definition and requirements for the

Financial Management reporting and other Essbase supported processes.

Created various monthly and quarterly reports using Hyperion Reports version 7.0/7.2

Environment: Essbase v7.1.5/v6.5.4.2/System 9x, Hyperion Planning 3x, EASv7.1.5, EISv6.5.4,

Essbase Add-in, Hyperion Interactive reporting, SmartView, HFM Add-in, HFM 4.x, Hyperion Reports

7.x, MS SQL Server 2000, BRIO, S.Q.R, Oracle 9i, Windows 2000 Advanced Server, Windows

2003/200NT

Client: Teradyne, Inc., Boston, MA Jul ‘05

– Aug ‘06

Role: Database Developer/Hyperion Developer

Responsibilities:

Setting up Profiles, Creating, Assigning Responsibilities and Creating Apps Users.

Developed scripts and implemented physical backups for the databases.

Coordinated with other departments to ensure implementation, monitoring of databases.

Worked with Oracle support services to resolve customer open issues.

Assisted client, prepared production procedures, troubleshooting of queries/report.

Engineered, performed migration/upgrade of Oracle 7.x, 8.0.x, 8.1.x to 8.1.7 developments,

production databases on Windows 2000/NT environments.

Performed Oracle 8i upgrade, developed, documented standards, checklist to be used by DBA’s

as guides for upgrade.

Demonstrated, provided hands-on testing of upgrade documentation on both Windows NT/

UNIX environment.

Installed, configured, upgraded Oracle software, related products.

Environment: Windows NT, Sun Solaris 2.6, Oracle (7.3.4/8.0.x/8i), UNIX Shell Scripting, SQL

Scripting.

Client: GCI (Collabera Inc), Morristown, NJ Aug ‘04 – May

‘05

Role: Information Technology Analyst

Role & Responsibilities:

Participated in gathering user requirements, developing functional and non-functional

requirements and technical specifications.

Worked on custom generated reports on Lansweeper, which is a software inventory and hardware

inventory recording application for windows networks.

Worked on technologies including .Net for developing and maintaining Sharepoint Website

portal of the MIS department of the company.

Developed a script for auto configuration of Outlook when a user logs in for the first time in the

domain using VBScript.

Partially involved with the Hyperion Essbase team in developing batch files and rules files to

upload data from financial system’s database to Essbase Cube.

Configured images of desktops and laptops to catalyze the process of Operating System setup. A

model system was build for different systems and then the system was imaged using the Norton

Ghost software.

Worked on technologies including Sharepoint, Lansweeper, Norton Ghost and VBScript.

Client: Tata Consultancy Services, India Apr ‘03

– Jul ‘04

Role: Software Engineer

Tata Consulting Services is a software services and consulting company headquartered in Mumbai, India.

The objective of this project was to develop a relationship management portal to serve as a common

rendezvous point where all the people concerned with handling the numerous project of TCS can access

the information and take guidelines for their project through it.

Role & Responsibilities:

Developed PL/SQL programming that included writing of Stored Procedures, Packages,

Functions and Database Triggers.

Created Temporary Tables to store the data from Legacy system.

Used SQL*Loader scripts to load the data into temporary tables and PL/SQL procedures to

validate the data.

Creation of Materialized views and function based indexes

Setting up various notification scripts which will notify if the database is not up and running or if

any directory space is filled up.

Used Oracle packages for automation, Oracle designer for data modeling.

Used Visual SourceSafe for version control and performing various builds.

Education and Certifications:

Oracle Database 10g Administrator Certified Associate (OCA)

Oracle Database 10g Administrator Certified Professional (OCP)

Currently pursuing Essbase Certification.

Bachelors in Computer Science Engineering, Osmania University, India.

References: Provided upon request.

Contact this candidate