Your browser is outdated!

To ensure you have the best experience and security possible, update your browser. Update now

×

Ray Erden

Business Intelligence and Data Analytics

Key Words:
Excel and Access Development | Database Analysis | Performance and Quality Reports | Dashboards | Scorecards | BI Reporting
Ray Erden
Apple Valley (55124) United States (Minnesota)
Professional Status
Employed
Available
About Me
Summary:

Extensive data analysis experience in multiple industries at highly reputable corporations. Recent twelve plus years concentrating on performance measurement metrics, benchmarks, dashboards, scorecards and delivering actionable BI reports. Strong in database concepts, statistics, MS Access SQL, expert in MS Excel, along with academic training in advance quantitative techniques. Extract, manipulate and present data from various platforms to leadership teams, facilitating informed decision making process by turning data into a meaningful knowledge for all stake holders.

Synopsis:

• Experience in performance measurement metrics, scorecards, executive dashboards, benchmarking and reporting databases.
• Worked in state, pharmaceutical, retail, health care, wholesale banking, equipment leasing, insurance, car rental, food, mortgage, financial services industries as a Business Analyst, Performance Analyst, Systems Analyst, Data Analyst, Consultant, Independent Contractor and Reporting Systems Developer.
• Exposed to an advance academic training in applying quantitative analysis techniques to financial, economic and operational data series and marketing research.
• Productive with MS Access and Excel for custom complex solutions at expert level..
• Work with VBA code to enhance the functionality of and deliver custom solutions in Excel and Access.
• Experienced in activity based accounting from database and Business Analysis perspective.
• Capable working with advanced statistical concepts and SQL logic.
• Knowledge of database principles for data modeling, extract, transfer, load, map and present data from various platforms to support complex analysis needs for managerial reporting and empirical model building.

Career Direction:

• Looking for challenges to evolve my overall professional capacity into a level where, I can be instrumental to deliver full suit of business intelligence solutions.
• Working with abstract data structures of key business processes and having an oversight on the
process flows that identify and utilize key strategic drivers to facilitate informed decisions.
• To enable executive decision makers via delivering core metrics and analytics.
.

Value Add Deliverables:

• Producing information and presenting it in a timely, accurate and a user friendly manner from
data analytical perspective.
• Creating and implementing Microsoft Office based solutions for end users.
• Ensuring data integrity of reporting resources and automating manual data processes.
• Serving the mission critical business decision making process with an in depth and well rounded
data analysis utilizing available corporate data resources.
• Understanding the complex relationships among the key business drivers and entities and reflect them in data models to support a sound and reliable reporting structures.
• Producing reporting data structures to track transactional, financial and operational activities
• Compilation of related data sets to capture and model trends and patterns. Incorporating statistical procedures to build predictive models to understand ramifications of activities on performance.
Resume created on DoYouBuzz

Enterprise Process Analyst

Prime Therapeutics
February 2013 to May 2013
Consultant
Bloomington
United States - Minnesota
  •  Streamlined and enhanced fully automated performance quality metrics reports in Excel.
     Developed pivot table and VBA based toolkit to track discrepancies in multiple reports.
     Modified existing scorecards and dashboards via Excel macros and highly complex formulas.
     Applied enhancements to the existing Excel based toolkit that generates various automated reports.
     Reviewed the existing VBA code and made the requested modifications in several update routines.
     Developed new procedures for the existing metric reporting system to gain operational efficiencies.
     Supported the team with technical issues and worked together on the standard operating procedures (SOP).
     Provided IT support to performance engineer of the reporting team.