We provide IT Staff Augmentation Services!

Lead Hyperion System Administrator Resume

SUMMARY:

Skilled in the analysis, design, testing and implementation of new systems, and/or major enhancements to existing systems to ensure the effective application of computer resources to satisfy business needs. Recognized for managing the unit assignments through planning and overseeing staff activities. Supervised resolutions of all problems related to CS system to ensure rapid and accurate response. Highly involved in management and other project - related meetings to keep informed of developments. Successful track record of training new staff to perform area responsibilities, including performance tracking, and providing leadership in all assigned tasks.

CORE SKILLS:

  • Java Script
  • VBscript
  • Jscript
  • PERL
  • MAXL
  • Cshell
  • Kshell
  • BASH
  • Windows
  • Oracle Linux/Redhat UNIX
  • OS390
  • TSO

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, SQR, VB, VBA, SAS, JAVA, JCL, COBOL

Databases: Teradata 6.2, Oracle 8/8i/9i/10g/11g, DB2, Sql Server 2000/2005, Foxpro 5/6/7

Software: HPS 8.3.2-9.3, Essbase 6.5.3-9.3.1-11.1.2 ASO/BSO, Informatica Powercenter 8.11, Hyperion MDM, PeopleSoft 8.4, SAS9, JMP7, Siebel 8/OBIEE 10.1.3.4, ArcGis 8.2, Toad, Sql Loader, Oracle Forms/Reports 10g, Oracle Application Server 10g, Oracle Financials 10.3/11i/11.5

PROFESSIONAL EXPERIENCE:

Lead Hyperion System Administrator

Confidential

Responsibilities:

  • Administer distributed Exalytic production environment for 5k+ users and over 2000 cubes.
  • Setup and maintain SSL/TLS configuration.
  • Responsible for Hyperion and WebLogic patches and password maintenance
  • Responsible for Batch processing using MaxL, and schedulers (Autosys, Tidal)
  • Responsible for Cube restorations, system performance issues, general Hyperion troubleshooting
  • Responsible for setting Hyperion monitoring processes in Splunk and querying the logs in troubleshooting efforts
  • Responsible for all vendor relationships for the remediation of bugs and product enhancements

Senior Hyperion Administrator

Confidential

Responsibilities:

  • Analyze and apply system engineering for 50+ servers and deliver technical knowledge of software development frameworks and business process configuration systems using java application servers, integration and information systems, ERP systems, business rules engines, business process management and etl development frameworks.
  • Spearheaded the redesigning of the system to handle all requests while maintaining licensing restrictions
  • Leverage fluency in technical languages, operating systems, application programming interfaces, and troubleshooting

Hyperion Administrator

Confidential

Responsibilities:

  • Executed strong knowledge of software development life cycle, modeling of business processes, application design patterns, business and functional documents while providing options analysis
  • Developed and constantly updated knowledge of infrastructure subcomponents and interoperability including (but not limited to) SAN, network (application routing) and compute platforms
  • Created the current Hyperion infrastructure and recommended changes that resulted in cutting calc times in half
  • Managed data integration between Hyperion and the Data Warehouse as the senior member of the data warehousing team
  • Oversaw OBIEE RPD and report development using Hyperion Essbase and Planning sources to provide accurate data

Essbase Administrator

Confidential

Responsibilities:

  • Successfully developed automation using WSH and MaxL for greater error checking for month end close processes
  • Revamped four BSO cubes into one ASO cube that reduced processing time from two hours to 30 minutes for the month end close process
  • Instrumental in revamping the current data warehouse structures to support greater flexibility and continuity

Senior Analyst/Developer

Confidential

Responsibilities:

  • Developed and implemented enterprise wide reporting suite utilizing OBIEE and Essbase supporting 27k users
  • Effectively used Informatica to load star schemas in conjunction with native loaders to support OLAP reporting and cube loading
  • Achieved successful development in Multiple Multi-Dimensional Databases using SQL option with both ASO and BSO types of Essbase cubes
  • Applied advanced Teradata - SQL to solve Data Warehouse problems such as recursive SQL, Analytic Functions, Rollup & Cube functions

Lead ERP Systems Analyst

Confidential

Responsibilities:

  • Managed the installation and troubleshooting process of the Hyperion Performance Suite 8.3.2 while setting up the Apache/ Tomcat webservers to support the interactive web environment
  • Executed the development of an enterprise wide notification system to email all managers in the company a report showing direct report’s hours logged using Hyperion Intelligence
  • Enhanced system, designed and implemented a Confidential in Oracle 9i to support the contract management system
  • Developed the ETL process to automatically update the contract management system with PeopleSoft and collaborated with End Users to gather report requirements and develop Brio reports

Database Analyst

Confidential

Responsibilities:

  • Wrote specialized customer reports in Oracle Financials mapping out the flexfields tying the PO, AR, AP, GL modules together
  • Developed customized Access front ends to Oracle back end to aid in data entry and specialized interactive reports for end users
  • Applied ArcView 8.2 to provide geographical analysis of fleet distribution, revenue and customer analysis and also to redesign the field territories

Consultant

Confidential

Responsibilities:

  • Managed process for integrating in house data with Dun and Bradstreet data to provide customer and credit analysis
  • Responsible for data analysis with the marketing team at ICG Telecommunications
  • Used SQR with Brio Query to provide specialized interactive reports, wrote customized executive summary “Dashboard” reports using Brio Query and provided analysis for promotional effectiveness

Consultant

Confidential

Responsibilities:

  • Instrumental as consultant and mainframe programmer at IBM, applying JCL and extensive use in troubleshooting and recovering lost data
  • Supported DB2 databases; create, alter tables; create, reorganize tablespaces
  • Analyzed raw COBOL/JCL code with flat and VSAM files for Sales and Marketing applications in order to assess date compliance

Hire Now