We provide IT Staff Augmentation Services!

Hyperion Analyst Resume

3.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY

  • Over 10 years of IT experience with emphasis on various Hyperion products such as Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, Shared Services, Hyperion Financial Reporting Studio, Web Analysis, and Smart View
  • Hands - on experience of Classic and EPMA applications
  • Experience in creating and maintaining Block Storage (BSO) and Aggregate Storage (ASO) applications
  • Expertise in managing applications and databases, Essbase architecture, data loads and dimension building, Calculation Scripts, MaxL, MDX Querying, Report Scripts, and performance tuning
  • Skilled in writing queries and creating tables/views, SQL procedures in various RDBMS
  • Good knowledge of automating routine administrative tasks by writing MaxL, ESSCMD, and Shell scripts
  • Good working experience in ABAP/4 Reporting (with Interactive, Classical, ALV list/grid)
  • Experience with ABAP/4 Workbench building of Data Dictionary Objects and Function Modules, data migration with BDCs and LSMW for data uploads
  • Knowledge of SAP standard functionalities using User Exits, BADIs and Enhancement Frameworks

TECHNICAL SKILLS

EPM Tools: Hyperion Essbase/Planning 11.x, Hyperion Financial Management 11.x, Financial Data Quality Management 11.x, Hyperion Shared Services 11.x, Excel Add-in, Smart View, ESSCMD, MaxL, and MDX

Reporting Tools: Hyperion Financial Reports, Excel Spreadsheet Add-in, Hyperion Smart View, and Hyperion Web Analysis

Databases: Oracle 10g, SQL Server 2008, 2005, MS Access

ERP: SAP

Programming Languages: C/C++, Java/J2EE, Python, ABAP, SQL

Operating Systems: Windows Server 2003/2008, Windows NT/, MS-DOS, Solaris

Other Tools/Languages: MySQL 5.5, COBOL, Apache Tomcat, Eclipse, NetBeans, Simply Accounting, Microsoft Office

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Hyperion Analyst

Responsibilities:

  • Used MaxL language in creating batch scripts to automate data load and dimension building
  • Created users, groups, filters and assigned different levels of security access to users in Shared Services
  • Performed performance tuning by using the dense/spares settings and developed the required alternate rollups for reports
  • Prepared reports using HFR and Smart View
  • Managed and changed database connection for reports; created books using batch scripting; scheduled reports to generate multiple output options including web, PDF, MS office format, and email notifications to users
  • Designed and created new server substitution variables thereby narrowing down the management of a single calc script for current and prior month or year
  • Developed batch scripts to automate routine administrative tasks

Environment: Hyperion Essbase 11.x, Hyperion Planning 11.x, Hyperion Financial Reporting 11.x, Excel Add-in, Smart View, Windows 7

Confidential, Atlanta, GA

Systems Engineer

Responsibilities:

  • Gathered and analyzed AT&T Translations data and resolved issues such as equipment assignments, dialing plans, trunk group types and assignments, routing and charging, announcements, and other standard switch translations
  • Batch-loaded customer data into Lucent database, corrected hardware and software mismatches, and produced software tapes for switch cutover
  • Provided Tier II Translations support to Independent and CLEC Telcos, created tickets in Remedy, dialed into customer switches to verify problems, created MOPs to correct equipment and Translations issues
  • Provided Tier II Wireless Reality(RAVS) to wireless customers
  • Provided technical phone support to installers and customers during switch cutover
  • Performed on-switch T1, PRI, SS7, and GSM provisioning
  • Provisioned secured features (SFID) and maintained customer records
  • Provided pre-sales and post sales support to Lucent Sales department
  • Performed Enhanced Onsite Retrofits for Bellsouth COs, updated retrofit tools and loaded into SUN blade workstations; coordinated retrofit dates with installers and Bellsouth CO managers; executed switch trial dumps and resolved retrofit issues; produced required software for final load
  • Developed UNIX scripts to automate data loads into the development environment
  • Maintained Local Unix servers
  • Created SQL queries to cross-check data validity
  • Mentored new employees
  • Promoted to AT&T Account Owner and SME

Environment: UNIX, ODA, TSO/ISPF, 5ESS Switch, Informix database, Microsoft Access, Remedy

We'd love your feedback!