Ray Erden M.A. Business Economics Sr. Data/Business Systems Analyst Business Intelligence Reporting  
                                           Ray Erden                              M.A. Business Economics                 Sr. Data/Business Systems Analyst                                                        Business Intelligence Reporting                                           

DATABASE & SQL Skills

Access SQL/Excel skills apply to most of the jobs listed on my resume

  • Highly experienced with Access SQL both constructing via GUI to construct a complex query or creating a script for data manipulation and action queries which cannot be created by GUI. 
  • Using embedded SQL in VBA modules in Access/Excel that were running based on user action or certain database actions also to maintain the data integrity. 
  • Created user forms with user functions triggering stored queries that are activated by certain user actions.

 

Optum (UHG), Target Supply Chain, Wells Fargo Wholesale Banking and Wells Fargo Compliance/Financial Crimes

  • Used various database management tools to write SQL statements against large databases such as Teradata, Oracle, DB2, SQL Server or Hadoop (Big Data), Data Lakes and Azure. 
  • Worked with tools such as AQT (Advance Query Tool), Oracle Toad, DB Visualizer, DBeaver and Teradata SQL Assistant to write SQL scripts. 

 

UHG IT

  • Used SSIS packages to store  SQL scripts and ran against Oracle tables at UHG IT to update tables stored in Oracle whihc provided data sets feeding tables running on client web sites.

 BASF

  • Controlled SQL statements in Excel macros embedded in VBA running against external data sources such as SAP master data.
  • Power Pivots as an add on in Excel connecting to any external data source via ODBC and running from within macro statements stored in VBA modules. 
  • Utilized DAX code which is the native code for Excel Power Pivots and Power Query.
  • Developed Excel and Access based business intelligence tool for the sales and financial managers.

Wells Fargo Trust Services

  • Generated weekly reports by modifying and running SQL scripts from SQL Server database, modified and maintained the code as needed.
  • Built Excel based UAT scheduling tool to manage general testing activities.
  • Modified excel based automated reporting process based on VBA functions and procedures.

GENERAL TechnologY ACUMEN

  • MS Excel (1995-2016) – Advanced power user/developer with VBA (Industry)
  • SAP Master Data financials and supply chain modules (industry)
  • Excel Analysis Office to interact with SAP & OCEAN financials module (industry)
  • SSIS packages of SQL Server for ETL processing (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)
  • Business Objects Versions 6.5 and XI and Crystal Reports 11 (Industry and Training)
  • Oracle 8i –Certification Training, Oracle 11g with Toad & PL/SQL (Industry)
  • SPSS Statistical package (Graduate School)
  • TSP – Time Series Processor (Graduate school)
  • PeopleSoft (Industry) – People Tools SQL modules
  • Cognos Impromptu and PowerPlay (Industry) – Business Intelligence
  • Microsoft Power BI
  • Alteryx BI Data Management Software
  • MS Excel Power Pivots with Power Query and DAX code
  • AQT (Advance Query Tool for database navigation)
  • DBVisualizer (Database SQL navigation tool)
  • DBeaver (Database SQL navigation tool)
  • CA Agile Central (Rally)
  • MS Visio
  • TSF (Team Foundation Server of SQL Server)
  • Teradata Database (industry)
  • Teradata SQL Assistant (indurty)
  • ALM - Application Lifecycle Management (industry)
  • JIRA (industry)

Business ACUMEN

My core strength is in functional combination of business, finance and technology skills generating sufficient synergies which drive value add for those who consume information generated from adavance analytical processes. 

 

Ever increasing need to handle tremendous amounts of data to make sound business sense from all of the available digital sources originating in many different formats in a data driven enterprise offer the opportunities for me.  

 

My career path so far has afforded me countless valuable lessons and opportunities to develop skills and expertise working with technology and business executives in finance, sales, marketing, IT, project management also with product owners, developers, data modelers, solution architects, operations managers and analysts.

 

Effective communicator both verbally and in writing, highly organized, self sufficient and self-motivated with a good drive, can anticipate where to focus without waiting for directions, fairly comfortable working with executive leadership team, fluent with presentations, not hesitant of delving into new technologies, methodologies and tools.      

 

Excel, Access and VBA Problems?

Call or text at 612-701-6292


or send an email.

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

This website was created using 1&1 IONOS MyWebsite.