Software Developer System Administrator
Resume:
Dale Adams
Carrollton, Texas *5007
**********@*******.***
SUMMARY
More than 12 years of experience in Oracle / Hyperion Essbase development and administration. Strong Hyperion Essbase, Reports, Planning and Workforce background. Essbase work has included the design and development of cubes, calculation scripts, load rules, reporting and automation development. Designed several automated reporting systems for finance and operations with Excel VBA and Essbase API using multiple data sources including SQL Server relational databases.
EXPERIENCE
Independent Contractor 12/15 - present
Various contract work involving the creation of automation of financial and operations reporting. Most work has been in QuickBooks for small business. Using Excel 2013 VBA, developed completely automated system to allow accountants to generate financial statements or operations reports at the click of a button.
Taco Bueno, LLC. 11/11 – 11/15
Database Administrator
Hyperion Essbase development and administration for multiple Essbase cubes including both financial and operational type databases.
Responsible for daily, weekly and monthly reporting of sales, comps and variance for all profit centers throughout 5 state regions.
Developed automated reporting processes, data loading, and calculations for all cubes and SSAS pivot tables.
Developed and distributed daily sales and operations reports for senior management.
Maintained company data warehouse and developed automated pivot tables to extract detailed product mix sales for financial analysis team.
Created Excel 2010 Addin allowing Essbase data extraction for finance/accounting team.
Reconfigured and redesigned defunct consultant designed P&L and Balance sheet cubes.
Created and administered multiple cubes for auditing various metrics for over 150 stores.
CompuCom, Inc. 4/09 – 11/11
Senior Finance Specialist
Financial systems administration responsible for the budgeting (FP&A) and financial analysis database and systems.
The system includes the Hyperion Planning/Workforce module with over 100 users.
Administration of the system includes all security, business rules, calculation scripts, Hyperion forms, Hyperion reporting, ODI, SmartView and data gathering working with financial management to develop the enterprise budget and reporting system.
Heavy use of Excel 2007.
Home Interiors & Gifts, Carrollton, TX 4/07 – 3/08
Senior Software Developer
As the Essbase and PACE system administrator, responsible for all administration, development, system modification and reporting of the company’s merchandising operations to upper management.
Developed automated reporting systems for the finance and merchandise groups using VBA in Excel.
BellSoft Inc., Dallas, TX 9/06 – 4/07
Software Developer - Contractor
Created a distributed application for security functionality in Hyperion Essbase using Visual Basic, VBA, Essbase API, and SQL Server for worldwide financial operations allowing local personnel to modify local security rules.
Created full documentation, user manual and help files for this application.
Profix Software, Irving, TX 3/05 – 9/06
Software Developer - Contractor
Designed and implemented VB.net Application Service Provider system for credit agency SQL Server as backend database.
Created full documentation and user manual for the application.
Denbury Resources, Plano, TX. 1/01-3/05
Systems Analyst, Hyperion Essbase
Using Hyperion Essbase, Microsoft SQL and ETL programming, created the accounting/finance and operational BI database and reporting requirements for this Oil/Gas Exploration company.
Created user applications for budgeting processes using VB/VBA, T-SQL.
Designed and implemented web reports for company intranet using ASP/JavaScript and the Essbase API.
In support of the production management and the financial management groups, designed an ad hoc reporting, budgeting and production analysis system.
SYSTEMS
Hyperion Essbase 11.X, Hyperion Financial Reporting, Hyperion Planning, Excel 2013, SQL Server 8/12, MS SSAS OLAP
Dodeca 6.7
SOFTWARE
Essbase/Planning/Workforce API, VBA, VBScript, MaxL, EssCmd, T-SQL, Python
EDUCATION
B.S., Business Administration – Finance Major – Economics Minor - University of Texas – Dallas (UTD), Richardson, Texas
Associates – Computer Science - DeAnza College – San Jose, CA.
Contact this candidate