Project Management and Data Architecture Resume

SUMMARY:

Take on challenging complex business processes, design and execute.
14 years of consulting and project work.
Extensive knowledge of BI requirements and support of complex reporting
User interface design, creation and support with technical details documentation & user

TECHNICAL SKILLS:

Skills and Programming Languages: Hyperion Essbase, MDX, SQL Server, VBA (Excel, Access, Outlook, Word, PowerPoint, Project), VB6, Hyperion Analyzer, Hyperion Planning, TM1, Business Objects, Perl, SQL Server, Oracle, SAP SEM and BW

PROFESSIONAL EXPERIENCE:

Confidential

Project Management and Data Architecture

Responsibilities:

BI Schemas design
Schema, logical and physical data modules
Fact and summary table design and creation
Lookup and tables
Data maps and dictionaries
ETL I/O data cleansing and transformation
KPI Design and Calculation

Confidential

Senior Oracle Hyperion Essbase/Planning Consultant

Responsibilities:

Design and Implement Hyperion Essbase Cubes - Version 5 through 11
Dimensions design reflecting business and data Models (Accounts, Time, Attribute, etc.)
Dimension build and data load rules for dynamic cube build and restructure
Outline formulas and Calc. scripts (Business rules for planning)
MDX formulas and reports
MaxL and EssCmd automation routines
ASO/BSO, Windows and Unix
Server and DBs configuration and optimization with log files management and analysis
Shell scripts and Batch files for start to finish execution ( HAL for planning and EIS for Hybrid Analysis)
System administration, security and filters settings. User support
Excel add-in interface setup and templates automation (Web forms for planning)
Web-Analysis configuration and implementation
User (teaching Add-In and Essbase boot camp)

Confidential

Senior MicroStrategy Consultant

Responsibilities:

Design and Create MicroStrategy Dashboards - Version 9
Data modules setup, fact, metric and attribute creation (drill maps, smart and level metrics, custom groups, consolidations, etc.)
Create prompts and reports ( intelligent and OLAP cubes )
Highly graphical dashboards with Reports, Graphs and Widgets ( multiple panel stacks smart reports)
SAP and Essbase MDX interface
Version control

Confidential

TM1 Consultant

Responsibilities:

Design and Create TM1 Solutions - Version 2-8
Server Installation and User Setup
Workflows, Tasks, Chores (Dimension, Metric Builds, Data Loads)
Formulas, Calcs, Feeders
Turbo Integrator Setup and Automation
Excel Templates

Confidential

MS Office Programmer Consultant

Responsibilities:

MS Office VBA Automation - Excel, Access, Word, Powerpoint and Outlook
Excel Macros, Formulas and Pivot Tables Calcs

Confidential

Financial and Business Analyst

Responsibilities:

Analyze corporate financial statements and perform budget and variance measurement analysis
Corporate internal audits
Financial modeling
New projects and ventures analysis

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship