Hyperion Analyst Resume
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