Ray Erden
Business Intelligence and Data Analytics
Key Words:
Excel and Access Development | Database Analysis | Performance and Quality Reports | Dashboards | Scorecards | BI Reporting
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.
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.
Business Analyst
OptumHealth - Care Solutions
December 2007
to July 2012
Full-time
Golden Valley
United States - Minnesota
- Prepared actionable reporting processes to update executive dashboards for the senior leadership team.
Designed Excel based ETL processes to support the BI focused reporting processes.
Delivered monthly metrics and KPI reports to track performance within the agreed upon deadlines.
Built online navigation functionalities on SharePoint for the interactive utilization of performance metrics reports.
Wrote VBA procedures in Excel to automate updates and to add customization to reporting processes.
Created and automated Hyperion Essbase queries to obtain data from G/L in PeopleSoft into Excel.
Put together various data integrity procedures to ensure accurate and efficient delivery of essential updates.
Developed MS Access database applications for billing, collections and BI reporting users.
Provided recommendations and commentaries for action items for the key business initiatives based on analysis.
Prototyped user requirements and prepared proof of concept samples for further discussions.
Converted table structures, relationships and completed data mapping process to accommodate system change.
Documented logical data flow processes capturing the essential updates in MS Visio.
