TECHNOLOGY ACUMEN

MS Excel (1995-2019) – Advanced power user/developer with VBA (Industry)

 

SAP/HANNA 7 Master Data financials and supply chain modules (Industry)

 

Excel Analysis Office to interact with SAP & OCEAN financials module (Industry)

 

SSIS packages of SQL Server 2012 for ETL processing (Industry)

 

SSRS - SQL Server reporting module (industry)

 

MS Access Reports (2003-2016, Forms, SQL, VBA Data Modeling (Industry)

 

Hyperion 7X Essbase Solutions – BI Tool (Industry)

 

Tableau Professional Ver. 7.0 (Industry) (Rapid Analytics and BI dev. Tool - Training)

 

SAS 9.0 with Enterprise Guide 4.0 (Training/Industry) SAS Desktop version

 

Business Objects Versions 6.5 and XI and Crystal Reports 11 (Training/Industry)

 

Oracle 8i –Certification Training, Oracle 11g with Toad & PL/SQL (Training/Industry)

 

SPSS Statistical package (Graduate School)

 

TSP – Time Series Analysis Processor (Graduate School)

 

GB STAT (Graduate School)

 

PeopleSoft (Industry) – People Tools SQL modules

 

Cognos Impromptu and PowerPlay (Industry) – Business Intelligence

 

Microsoft PowerBI (Industry)

 

Alteryx BI Data Management Software (Industry)

 

MS Excel Power Pivot and Power Query with DAX code (industry)

 

AQT (Advance Query Tool for database navigation) (Industry)

 

DBVisualizer (Database SQL navigation tool) (Industry)

 

DBeaver (Database SQL navigation tool) (Industry)

 

CA Agile Central / Rally (Industry)

 

MS Visio (Industry)

 

TSF (Team Foundation Server of SQL Server) (Industry)

 

Teradata Database (Industry)

 

Teradata SQL Assistant (Industry)

 

ALM - Application Lifecycle Management (Industry)

 

JIRA - Defect and IT project status management (Industry)

 

Oracle 19 SQL Developer (Industry)

 

MySQL (Personal Interest)

 

Power Builder (training)

 

Visual Basic - Stand Alone (training)

 

 ADVANCEd   Excel                                     Access                 databases                                       VBA macros                                       SQL scripts                                       BI Reports                                         data   integrity                                          big data                                             data science                                   data mining                                     data mapping                                   data profiling                                 data   visualization                                   data modeling                                 financial     analysis                                           SCORE CARDS                                     BENCHMARKS                                     PERFORMANCE   KPI METRICS

Print Print | Sitemap Recommend this page Recommend this page
© Ray Erden

This website was created using 1&1 IONOS MyWebsite.