Levent Abik

**** * ***** *** ******** Park, IL **526

Home: 773-***-**** E-mail: abls71@r.postjobfree.com

**-**** - **-**** ******* Reserve Bank of Chicago Chicago, IL

Sn. Hyperion Admin / Developer

. Technical implementation of Hyperion System 9 for Federal Reserve

Districts, including user training, calculation scripts, outlines,

MaxL, and SQL SSIS packages

. Deployed System 9 including all components of Hyperion such as

Analytical Servers, Hyperion Planning, Financial Reporting Studio,

WebAnalysis, Workspace, Shared Services, Hyperion Scorecard, Security

and Business Rules

. Developed Hyperion Planning environment with the primary focus on the

building of the outline, forms, Essbase calculations, Business Rules,

Financial reports, and the budgeting & forecasting process.

. Upgraded Hyperion Environment from version 7 to 9.0.1 and to 9.3.1

including all components of Hyperion such as Analytical Servers,

Hyperion Planning and all existing applications, Financial Reporting

Studio, WebAnalysis, Workspace, Shared Services, Hyperion Scorecard,

Business Rules and migrated Hyperion Reports and Hyperion Security

. Supported and administered Hyperion Planning, Analytical services,

Hyperion BI+ WebAnalysis, Financial Reporting Studio, Hyperion

Scorecard, Hyperion Integration Services, Informatica and DIM

. Administered Hyperion Security in Shared Services for all Federal

Reserve Districts for all Essbase, Planning and Hyperion BI users

10-2005 - 06-2006 RR Donnelley Downers Grove, IL

Essbase Admin / Developer

. Performed source data loads; maintained and upgraded source data feeds

and Essbase load rules

. Managed daily data backups

. Managed new user setup and security and provided technical support

. Conducted end-user training

. Created, automated and maintained Essbase application objects

including: database outlines, calc scripts, data load scripts,

security objects and custom security filters

. Identified, tested, and implemented enhancements to the Hyperion

Essbase infrastructure

. Automated forecast data loads' access control using Essbase API in VBA

. Optimized and tuned existing Essbase applications to enhance

application performance

. Performed systems migrations on a scheduled basis

. Assured that user manuals, system design documents, and other

documentations are kept up-to-date

. Provided end-user support for all Essbase, Planning applications

01-2004 - 10-2005 Citigroup - Citicards Deerfield, IL

Senior Admin / Analyst

. Analyzed, designed, created and tested programs, processes and

procedures of any size and any complexity to support Financial Data

accuracy using TM1

. Assisted the Finance department and any other internal customers in

determining how the technology is used to improve processes and

financial reporting

. Provided full TM1 administrative support (including server support) to

all areas using TM1 in all Citi sites internationally. This includes

all development, enhancements and changes to dimensions, security data

loads

. Validated accuracy of financial data

. Provided support to Citi Creditcard Services to develope spreadsheets

and reports

. Assisted functional team in developing TM1 databases in remote sites

. Supported Essbase as needed

02-2002 - 12- 2003 UBS Global Asset Management Chicago, IL

Data / Finacial Analyst

. Created, Administered custom security for Essbase global users

. Built SQL queries needed to retrieve and manipulate various data

needed to run the VBA applications and Financial Reports using VB

6.0's ADO and OLE DB controls

. Designed and built custom GUI to manipulate data

. Provided analysis and feedback on financial performance and key

performance measures

. Prepare monthly and year-to-date (YTD) management reports providing

root cause variance explanations

. Maintained forecast, budgeting and an Asset tracking Hyperion

applications

. Using Hyperion products created Essbase components, including

outlines, calculation scripts, EssCmd scripts, and data load rules

. Tuned and optimized Essbase databases

. Designed and created new modules for the UBS Global Asset management

system in Visual Basic 6.0 using ADO 2.6, SQL Server 7.0

. Created SQL queries to extract data from the main database and

automated these queries using DTS

. Exported SQL Server tables into Access for the user community

02-2002 - 05-2002 Computer Strategy Coordinators, Inc. Schaumburg, IL

Database Analyst

. Created custom programs in Group1 Software to meet the client's needs

. Working on AS400 platform, created custom code to output, merge and

purge reports

. Created custom queries using CODE-1 Plus identifying substantial cost

savings from postal discounts and incentives for the Bulk Mailing

. Created custom merge/purge codes to determine duplicate records in the

data files thus obtained significant cost savings in postage and

direct mail production fees associated with duplicate and

undeliverable mail pieces

01-2000 -02-2002 Experian Schaumburg, IL

Technical Analyst

. Responsible for technical processing, troubleshooting, and consulting

on projects in support of our client and services

. Analyzed projects upon receipt for possible processing and scheduling

problems

. Determined most effective and efficient steps in processing sequences.

. Created codes to split, merge and purge to create custom reports using

direct marketing data

. Validated all reports for accuracy and distributed each report to

appropriate user using Experian technology such as DB3Quest, JCL,

NCOA, DB2 and other available data access tools.

EDUCATION

2005 - Present Keller Graduate School

Chicago, Illinois

Master of Finance and Accounting Management

1997 - 2000 DeVry University

Chicago, Illinois

Bachelor of Science in Computer Information Systems

CERTIFICATIONS

. Hyperion System 9 BI+ Analytics 9.0 Certification as of 2006

. Essbase and Planning Certification as of 2003

. Hyperion Essbase Integration Certification as of 2006

. IBM Websphere Administration Certification as of 2007

. Oracle Hyperion Planning version 9.3.1 Certification as of 2008

. INFORMATICA DIM 8.1.1

Contact this candidate