Ryan Gerres
Business Intelligence Analyst at Vecteezy- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Vecteezy
-
United States
-
Graphic Design
-
1 - 100 Employee
-
Business Intelligence Analyst
-
Mar 2020 - Present
-
-
-
Eezy
-
United States
-
Technology, Information and Internet
-
1 - 100 Employee
-
Business Intelligence Analyst
-
Mar 2020 - Present
• Build lasting solutions to surface critical data and performance metrics • Understand the business needs and produce insightful analyses business, marketing, content, and product teams • Lead stakeholders through complex data models to gather insight on product releases and features • Create hypotheses, collect data to either support or disprove the hypothesis and recommend solutions to help move a metric • Align and partner with key business leaders to understand business objectives, Key Performance Indicators and measurements of success • Partner with engineering team to identify what information should be collected for new feature launches • Create scalable reporting solutions, data visualizations, or dashboards to track Eezy’s most important metrics and identify trends Show less
-
-
-
Esendex USA
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Business Intelligence Analyst
-
Dec 2018 - Mar 2020
● Provide in-depth business performance and system integrity insight, supporting team of 25+ with user friendly data requirements. ● Empower data scientists by creating warehoused data for predictive modeling, utilizing best practice determination for account collectability, acquisition pricing, and customer contact roadmap data points. ● Transform enterprise reporting structure, introducing Microsoft BI tools to process 4M+ calls per month by building multi-dimensional cubes in SSAS, enabling real-time data access. ● Engineer data reporting and access capabilities across 4 cubes currently in production: call records, revenue and payments generated, customer service actions, and inventory tracking, with several more metrics in development stage. ● Consolidate data dictionary, resolving report building inconsistency by standardizing metrics through research and collaboration with executive team and other key stakeholders. ● Diagnose multiple product issues, subsequently restructuring team to improve functional research based on discovered anomalies, searching for cause and implications and championing data integrity. ● Improve client reporting by collaborating with stakeholders to verify logic and produce accurate and reliable results. ● Mentor end users and data teams, training within computer software platforms as needed to drive success. Show less
-
-
-
Homes.com
-
United States
-
Leasing Real Estate
-
1 - 100 Employee
-
Data Scientist
-
Apr 2018 - Dec 2018
● Led configuration management for custom ETL jobs and SQL query schedules to warehouse data from various sources for reporting and ingestion by multiple forecasting models. ● Advised as a subject matter expert on division-wide Pentaho to Power BI conversion for business intelligence and reporting platform, performing design reviews as needed. ● Delivered troubleshooting and solutions expertise on Power BI issues, including licensing, hardware requirements, and administration. ● Collaborated with corporate office and Microsoft, verifying licensure and network administrators to confirm consistent network access, driving decision making and project success. ● Trained and mentored team on Power BI navigation and report building, delivering formal video presentation for end users within multiple divisions. ● Consolidated reports from 3+ platforms into single BI solution, ensuring adoption and end user buy-in, and reducing data manipulation risk. Show less
-
-
-
Dominion Dealer Solutions
-
United States
-
Motor Vehicle Manufacturing
-
100 - 200 Employee
-
Business Intelligence Developer
-
Feb 2018 - May 2018
● Maintained and improved a divisional level business intelligence system with routine updates, data analysis, and additional insights to cultivate and drive data warehouse efficiency and develop metrics to provide effective business insights. ● Built relationships with corporate office to enable streamlined databases and critical real-time financial data reporting for financial department use.● Assisted CRM data analysts by providing streamlined and clean data for ingestion in data analysis models, allowing clean MS Dynamics 365 data and eliminating manual processes by creating queries and jobs.● Cleansed customer address details by scripting Google Maps APIs in R/Python to enable geospatial customer base analysis.● Delivered automation to reduce user interaction and erroneous changes, freeing analysts to focus on other duties.● Automated monthly division-wide financial forecast model to project future months revenue and 3 months of expense trends, improving forecasting accuracy and accounting for seasonality and departmental financial history. Show less
-
-
Jr. Data Scientist | Business Intelligence Specialist
-
Mar 2017 - Jan 2018
● Combined accounting and BI acumen by accessing finance data, designing a robust data warehouse to include financial, CRM, and production data. ● Developed, evaluated, implemented, and managed complex ETL/ELT processes, sourcing data from internal and external systems to create a business intelligence platform for the division utilizing Power BI, SSAS, and SSRS. ● Collaborated with finance director, brainstorming data capture and warehousing options and communicating with individual departments including customer service, product deployment, sales, marketing, and finance, building BI platform in 3 months.● Recreated end user manual processes, delivering 75+ reports and dashboards in active use by 100+ end users. Show less
-
-
Senior Accountant
-
Jul 2016 - Feb 2017
● Managed finance and budgeting duties for various division product lines, developing ad-hoc reports and templates utilizing Excel, VBA, and OLAP connections.
-
-
-
Moss & Associates, PC
-
United States
-
Accounting
-
1 - 100 Employee
-
Staff Accountant
-
May 2011 - Jul 2016
● Conducted financial audits of corporations, tax-exempt organizations, and other government regulated entities while performing controllership responsibilities and monthly accounting processes for multiple large contractors. ● Conducted financial audits of corporations, tax-exempt organizations, and other government regulated entities while performing controllership responsibilities and monthly accounting processes for multiple large contractors.
-
-
Education
-
Bob Jones University
Bachelor, Accounting