Leonardo Gonzalez

PROFESSIONAL SUMMARY:

Over *2 years of Database and Process Design in different programming environments and Database BI Platforms

Over 12 year of MS SQL basic administration; more than 10 years of Development and maintenance of Stored Procedures (PL), Triggers and Queries under Informix (Unix), MS SQL and Sybase.

Over 8 years working on EssBase 7/11, using EAS for maintenance on Outlines, Rule Files, Calscripts, MaxL, Filters and Security Groups.

8 years as EssBase advanced user interaction and design/modify hierarchy with EAS Console and API programming.

Strong experience in full implementation cycles of Hyperion financial management products for global corporations (Business Analysis, Requirement Gathering through workshops, Architecture and Design of applications, development, UAT, end user training, production go-live and support).

Experience in Creating, Maintaining, and supporting all application objects including Outlines, calculation scripts, Rules files for dimension builds and data loads, and Security objects through both EssBase Administration Services (EAS) and Maxl scripts; also involved in automation of these procedures using Batch scripts

Created data forms, business rules, menus, task lists, planning units as part of application development

In depth knowledge of creating financial reports (pdf), charts, pivots, dashboards, books, batches, snapshot reports etc. using financial reporting studio.

8 years using VB6 API libraries to interact with EssBase.

Extensive experience (since 1999) with VB6 and VBA that allowed me to connect to any DBE like Oracle, DB2, MS SQL Server, Informix, Sybase or any DBE that supports OLEDB, then manipulate that information (via SQL language) to be presented on any MS Office documents like Excel, Word or PowerPoint by programmatically using those MS Office APIs

More than 2 year of Delphi 5 and 7 Programming skills under Informix and Access; 2 years of PowerBuilder 7,8 and 10 development using Sybase;

More than 4 years using OLEDB (ADO) connectivity objects over Access and MS SQL.

More than 10 years using VBA under MS Office Suites, Delphi COM Server programming and VB ActiveX Object programming. C# .NET and JavaScript Basic knowledge.

Experience as an Android developer, worked with Eclipse and Android Studio.

Spent some considerable time doing Network Administrator tasks installing Routers, Switch, Hubs and cabling over IPX and TCP/IP communication protocols, Managing users roles and gain access under Novell and Windows NT/2000 Servers; this Network Administrations job ones includes IPX Voice communication (Using Telnet).

More than 12 years of technical PC support as backup skills doing Operation System Installation (MS OS, Win 3.1, Windows 95, 98, NT4, 2000 and XP), MS Office and many Software including Antivirus, Patches and Development Tools (RADS); also Hardware maintenance. This experience includes the use of remote supports as VCL, PC Anyware and On Commands Tools.

Some other experience on a basic level CAD Software’s like AutoCAD, Micro CADAM, ProEnginner, and Pro CADAM (last 2 in UNIX), CAM Software (TekSoft) and InterCIM. Lotus Notes, MS Project, Visio and C++.

EDUCATION:

Bachelor Degree in Computer Science Engineering – CETYS

TECHNICAL SKILLS:

OLAP Tools

Hyperion EssBase 11.x/9.x/7.x/6.x, Excel Add-In, EssBase Integration services 9.x/7.x, EssBase Studio 11.x, ESSCMD, Maxl, EssBase administration services 11.x/9.x/7.x, Hyperion Enterprise performance suite 11.x, Hyperion Interactive Reporting 11.x/9.x/8.x.

GUI

Visual Basic 6.0/5.0, TOAD, Application Manager, SQL Developer

Business Intelligence Tools

Hyperion Planning 11.x/9.x

Reporting Tools

Hyperion BI+ (Web Analysis 9.x, Financial Reporting 11.x/9.x) Hyperion Reports 7.x/9.x,Hyperion Analyzer 7.x, Hyperion Excel Add-in, OBIEE 10g/11g, Smart View.

Scripting Languages

Unix shell, Maxl, ESSCMD, MDX.

Dimensional Modeling

Star-Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables, Physical and logical data modeling

Databases

EssBase, Oracle 11i/10g/9i,SQL SQL Server 2005/2008/2012, Sybase 12.5

Operating Systems

MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP/7/10

CERTIFICATIONS:

Scrum Master

International Scrum Institute. Certificate ID: 059***********

MS SQL 2008 Programming

Brainbench

C# Fundamentals

Brainbench

Programming Mobile Applications for Android. Handheld Systems: Part 1

University of Maryland

Programming Mobile Applications for Android. Handheld Systems: Part 2

University of Maryland

PROFESSIONAL EXPERIENCE:

Shire, MA

Role: Hyperion Planning Administrator – Beacon Hills Consultant

Duration: 05/2016 – 01/2018

Perform Dimension updates using DRM and sometimes HDM for Planning Metadata and EAS for Essbase ASO Outlines (7 BSO and 5 ASO).

Create flat files for an automatic metadata update process (ETL) that uses predefined rule files.

Reconcile and verify data uploads and monitoring of automatic Data Transfer process for Actuals

Responsible for Planning security using Share Services Console, and HDM to assign access at dimension level.

Create Filter and group security inside Essbase and Shared services.

Maintenance of Planning Applications including Work Force Planning; forms, Menus and Dimensions.

Maintenance of Business Rules using Calculation Manager.

Create rule files for custom requirements using EAS.

Modify Calculation Scripts using EAS when needed by a user request.

Update and modify SQL store procedures and/or tables for custom requirements.

Financial Planning user support 24/7 worldwide.

Responsible for monthly actual updates process.

Responsible for monthly FX (financial exchange) rates.

Responsible to maintain SOX monthly documentation of Metadata changes.

Tools: EPM 11.1.2.3, Planning 11.1.2.3, Hyperion EssBase 11.1.2.3, EssBase Administration Services (EAS),EssBase Studio, Smart View, EMP Maestro 13.2.0.9, CXO Cockplit 5.3, Microsoft SQL Server, Excel Add-in, MS Excel 2010,MS SQL, VB6, VBA, MS Office, Citrix.

Universal Studios, Universal City, CA and Ensenada Mex

Role: Lead Technical Analyst/ Senior Hyperion EssBase Consultant

Duration: 11/2008 – 04/2016

Participated on a Hyperion migration project to HFM/Planning, that involved configuration and setup HFM and Planning Cubes, migration from custom templates to a new HFM and Planning Forms, Reports, Webforms and ETL process (FDM and DRM).

Responsible for all VB6 development.

Provided Technical Solutions on Clients Requirements for Financial Systems based on Hyperion EssBase 11, VB6 and MS SQL.

EssBase Outline Maintenance: hierarchies, members, groups, filters, formulas, UDAs modification; Calcscripts and Maxl modifications.

Worked on financial reporting. Build various reports using Prompts, User POV, Grid POV, Conditional Suppression, and Conditional Formatting and used formula in it according to the recipe provided by users.

Analyzed, designed, updated, tested and migrated EssBase Cubes in different environments and also performed tuning and optimization of ASO applications.

Developed Rules files for data Metadata and Data loading in EssBase for BSO applications.

Extensively designed and developed monthly/quarterly financial reports (balance sheet statement, cash flow statement) using Hyperion reports scripts.

Wrote custom SQL to retrieve data from various data sources and integrated the result sets as a feed to EssBase applications

Involved in creation of Calc scripts, Rules for Hyperion EssBase Database and Application

Performed EssBase calc script tuning and debugging as well as enhancements.

Applied Hyperion Financial Reporting to design specific financial reports to serve management requirements.

Build rule files, calculation scripts, report scripts, substitution variables for the BSO cubes

Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers

Managed metadata by defining Dimension and its attributes, Application settings, Account types, consolidation methods, Intercompany transactions.

Provide detailed documentation and knowledge transfer to enable the client to manage the solutions created for them.

Worked closely with the BA doing analysis and Defining Clients Requirements, then providing VB6 development solutions using available EssBase API’s, MS Excel API, and MS SQL Server 2005 OLEDB API to provide financial information. All these technologies came together for high level financial systems to provide information extracted from EssBase and MS SQL Server DBs related to amortizations, revenues, forecasting and pacing for P&L and Cots for Films industry.

Direct contact with the BA to define Users Cases.

Did some BA role Managing, Prioritizing, Analyzing, and Assigning user requests to team and monitoring until deployed.

EssBase Outline Maintenance: Rule files, partitions, hierarchies, members, groups, filters, formulas, UDAs and Calcscripts.

Participated on EssBase and MS SQL Server upgrade project this included transition from BSO to ASO for Flix App.

Tools: Planning 11.1.2.3/11.1.2.2, Hyperion EssBase 11.1.2.3/11.1.2.2, EssBase Administration Services (EAS),EssBase Studio, Hyperion Financial reporting 11.1.2.3/11.1.2.2, Smart View, Microsoft SQL Server, Excel Add-in, MS Excel 2010,MS SQL, VB6, VBA, MS Office, Citrix, MS Visio, MS Project.

Employer: Kenworth

Role: Senior Systems Engineer

Location: Mexicali. Mex

Duration: 04/2004 – 11/2006

ERP Project Data Base Administration (LOTUS NOTES); BaaN process AS-IS and TO-BE documenter; Air Freight Bills Control System Administration and Programs Management; Company Procedures System Administration and Programs Management (supports ISO certifications); Import of Company Goods Administration and Programming; Management and Project Developer of the Import of Company Goods BaaN Adaptation; BaaN Help Desk support Area (Supply Chain attendant); Y2K compliant Test Area Supervise; CAD/CAM systems Support.

Functional Experience: Member of the ERP migration team; Project Developer of the Import of Company Goods BaaN Adaptation.

Tools: Visual Basic 4 and 6, Clipper (Dbase III), FoxPro 2.5, Access (DAO), MS SQL (ADO), MicroCADAM, ProEngineer (XWindow - UNIX), TeckSoft CADAM, BaaN (ERP)

Employer: City Council

Role: Network Engineer

Location: Mexicali, Mex

Duration: 09/1999 – 4/2004

Network and User Administration; Novell 4.1 Server Administrator; Digital channel (Data & Voice) Installation Coordinator for City Council Offices.

Functional Experience: Office Connectivity Project Leader.

Tools: Novell 4.1, Clipper (Dbase III), FoxPro 2.5, COBOL (UNIX), IPX and IP Telecommunications

Employer: State Govt. Transportation Dept

Role: Systems Engineer

Location: Mexicali, Mex

Duration: 05/1995 – 09/1999

Computer Area and Network Supervisor; Permits Control System (Traffic Licenses) for Public Transport, Management; Statistics System for Public Transport Research and Planning; Drivers Licenses Control System Project Management.

Functional Experience: Site Network Installation; Analysis and Design for all Systems (Clipper); Prototype for Drivers Licenses Control System (FoxPro 2.5).

Tools: Novell 3.1, Clipper (Dbase III), FoxPro 2.5

Employer: State Govt. IT Dept.

Role: Systems Engineer

Location: Mexicali, Mex

Duration: 02/1991 – 05/1995:

Maintained the Alcoholic Beverages Sales Permit Control System; Maintenance of the Vehicular Control System; Help Desk Management; Team member for the Finances Project (Oracle).

Functional Experience: Development of Oracle Forms, Menus and Reports; Clipper Programming

Tools: Clipper (Dbase III), Oracle (Forms, Reports, Menus) on UNIX.

Contact this candidate