Laura Goldsmith

McKinney, Texas 214-***-**** abg4gm@r.postjobfree.com

Hyperion Administrator/Essbase Devloper

Seeking an innovative position to provide administration and development for Oracle Hyperion

Systems (EPM). Specializing in Essbase cube development and data analysis.

Essbase Skills:

Ten years experience with Essbase BSO cube development and administration.

Three years of SQL server data warehouse platform for data extraction and loading into sales

and marketing cubes. Over Eight years of i Series (OS400) DB2 data extraction utilizing custom

RPGILE, Query, and FTP programs.

Windows batch, Esscmd, and Maxl scripting used for data load and dimension building

automation and processing calc scripts.

Performed Backup, database restore, and designed a disaster recovery process in place and

tested periodically.

Processed Risk Assessments

Experienced with data warehouse concepts and development, architecture, data modeling,

design, mapping, extraction, data validation, testing, along with user acceptance testing.

Performed BSO conversions to ASO for sales and marketing cubes.

Security methods used for 11.1.2 – Shared Services

Security methods used for 7X EAS and App Manager

EAS used for ad hoc dimension modifications and cube development

Data reporting tools used Excel add in, Queries, and WebFOCUS Development.

analyze business requirements to design and develop appropriate solutions.

Experience in full implementation life-cycle of application design, development, rollout, and post-production

support. Able to provide technical leadership for enterprise reporting solutions utilizing a multitude of reporting

tools.

Work Experience

Overhead Door Corporation Nov 1999 – May 2011

Lewisville, Texas 75067

Senior Data Warehouse Analyst

Managed the Oracle EPM system for Sales and Marketing departments.

Responsible for daily, monthly, and year end processes. Performed program development, cube

development, scripting, system monitoring, data integrity analysis, recovery procedures, and software

upgrades.

Performed data analysis adhoc with end users and department heads. Conducted monthly & year end

reconciliations between Oracle Hyperion Essbase cube data and JD Edwards Sales, General ledger,

financials, systems and recordings.

Managed the Information builders WebFOCUS system. Created all meta data sourced from OS400

•

DB2, SQL server, and Oracle Olap data. Responsible for WebFOCUS and i way software release

upgrades on I series and Windows servers along with migration of applications.

•

Organized meetings providing business requirement analysis to design and develop appropriate

solutions based on user needs and projects. Designed and held technical and user based

presentations for both internal and external users and vendors. Provided online presentations and

documentation utilizing SharePoint.

Achievements At Overhead Door:

Developed the Sales and Marketing Data Warehouse data sourced from a JD Edwards World ERP

system residing within the IBM OS400/I series platform. The Data Warehouse provided daily, monthly,

aggregated fact tables used for dimensional hierarchy and data loading to the Oracle Essbase

applications for Sales, marketing, and financial cubes providing Dashboard, product KPI Scorecard

along with Web reporting.

Migrated 15 sales data cubes from the 7X platform to the 11.1.2 System while closely working with end

users performing data analysis and user acceptance testing.

Performed six proof of concepts for the sales and marketing BI platform, and Web reporting tools.

•

Gained hands on training utilizing Cognos, Clarity, and WebFOCUS for output of Essbase Olap and

DB2 relational data.

Skills Acquired and Utilized at Overhead Door:

Oracle Hyperion Essbase Administration, development, calc scripts, Esscmd, batch commands, Maxl scripting,

Excel Add in and knowledge of the Smart view tool.

OS400/I Series RPGILE, CL programming, PDM, SQL, SEU, DFU, SDA, World Writer, ( SVR & Implementor) change

management. FTP processing, email monitoring communication CL programming, Trigger data transaction programming

and automated processing and auditing reporting in RPGILE.

Servers Windows 2008 R2, 2003, SQL Server 2000 & 2005

Microsoft Products Excel, Word, Visio, PowerPoint, SharePoint, Project, Access

Report Writers Showcase Query 7.0, WebFOCUS, SQL Reporting, World Writer,

Knowledge of C++, VB, HTMl, Java scripting, WinAR, VNC, Cognos,Clarity

•

•

•

•

•

•

Daisytek 1998 –1999

Plano, Texas

Senior AS400 Programmer Analyst

Key responsibilities maintaining JD Edwards World software 7.3 and developing custom applications for an international

product supply distributor. Applications included sales order, Inventory and General Accounting.

Maintained and developed audit in house applications utilizing the Vertex Tax System.

Performed new development for shipping processes. Designed on line product production flow and shipping status

monitoring systems for account managers.

Proficient in subfile programming, Dream writer, World Writer, FTP scripting and data conversions.

Managed 25 client accounts and worked closely with the plant processes.

Achievements at Daisytek:

Product web sales automation system design and automatic web data integration into the JD Edwards ERP system. The

system increased production shipping and increased customer satisfaction.

Skills Acquired and Utilized at Daisytek:

OS400/I Series RPGILE, CL programming, PDM, SQL, SEU, DFU, SDA, World Writer,SVR, Implementor.

FTP scripting, Hawkeye.

Microsoft Products Excel, Word, Visio, PowerPoint, Access

Peerless Group (Jack Henry) 1996 1998

Allen, Texas

Software Engineer

Developed and maintained Custom AS400 Credit Union Software for 120 credit union accounts in the US. The custom

software application included modifications and new development for Loans, Payroll, Certificate of deposit, Electronic

Funds Transfer, and other general accounting applications.

Worked once a month in the customer support area to take customer calls and resolve support issues while providing

strategic guidance for upcoming software enhancements. Performed Application Program RPG Conversions from the

system 36 to the AS400. Converted OCL procedures to CL programming and data structure conversions. Provided both

hardware and software support/development and training to the credit union accounts.

Installed AS400 Systems, configured both 400 and System 36 Environments. Setup Security, installed PTF's and in house

Credit Union Software. Helped convert system 36 applications to the AS400 environments. Converted OCL to CL along

with SDA generation of menus. Helped implement the ADK JWALK AS400 GUI product for client server environments.

Worked closely with the customer support department.

Skills Acquired and Utilized at Peerless:

AS400 RPGII,RPGIV, CL programming, PDM, SQL, SEU, DFU, SDA

Hawkeye.

Microsoft Products Excel, Word, Visio, PowerPoint, Access

Achievements at Peerless:

Developed System monitoring software for the operation group. Completed two custom software releases each year.

Performed data integration, and data conversions between PC applications and the AS400 DB2 database systems.

Texas Turnpike Authority 1986 1995

Dallas, Texas

Data Processing Supervisor

Managed three audit data entry clerks. Performed technical and conceptual toll audit training to the data entry clerks

along with other departments within TTA. Worked under the direction of the secretary of treasurer.

Responsible for IBM system 36 upgrades, daily backups, system maintenance.

Developed toll auditing and reporting applications for external customers and auditors.

Developed custom applications on a Dec Alpha 7000 utilizing Cobol while converting from IBM system 36 RPGII.

Developed and maintained Toll Traffic Data, payroll, general accounting software applications. Implemented a Novel

network and video software package. Designed and developed Toll Tag audit reports, conducting data integrity system

testing. Conducted internal and external toll audits with the DPS personnel.

Skills Acquired and Utilized at TTA:

IBM System Hardware & Novel Networking

System 36 RPGII and OCL programming, SEU, DFU, SDA

IBM Display Write

Achievements At TTA:

Toll tag data integration from the Dec7000 Vax system into the IBM system 36. A key player for Toll Tag System

Implementation working close with the Parole group. Participated in the first group of Toll Tag users to perform system

testing and help resolve data integrity issues.

Education

North Lake College

Jan 1995

to Irving, Texas

Jan 1999 Field Of Study Business Administration

Bryan Institute

Jan 1985

to Arlington, Texas

Jan 1987 Certified computer programmer and Business Analyst

Languages studied Cobol, RPG, Basic. Hardware included IBM mainframe and PC systems

Graduated with a GPA of 3.98

Vendor Technical training

Information Builders Technical Training

Dec 2007

Hyperion Technical Training

Jan 2001

Hyperion Essbase Administration & Security

Olap DBA

Esscmd scripting

Calc scripting

Data Modeling

IBM Technical

Jan 2005

Alphablox Training

Java Scripting

Tekfocus Technical Training

Jan 2000

Dallas, Texas

SQL Server 2000 DBA

SQL Server Implementation and security

DTS programming

Data modeling

Visual Basic programming

Tekfocus Technical Training

Jan 2000

Dallas, Texas

Networking

IBM Technical Training

Jan 1997

Dallas, Texas

RPGIV, RPGILE, Visual Age, and system management.

El Centrol College

Jan 1996

Dallas, Texas

AS400 System Management

Completed the AS400 system management course.

Completed the RPG III, Subfile & CLP programming course. Completed two semesters of C++ programming.

NOVELL Technical Training

Jan 1995

Dallas, Texas

Network Administrator

System administration, security, and network design for three off site locations and 100 user in office

Digital Technical Training

Jan 1994

Dallas, Texas

Digital System Management

system management on VAX and Alpha 7000 systems.

System security, DCL programming, Networking using Decnet & pathworks, RDB data base programming, SQL and

C programming.

IBM Technical Training

Jan 1988

Dallas, Texas

IBM System 36 Administrator

Contact this candidate