Jeff Aalto

Jeff Aalto

Mentor
5.0
(10 reviews)
US$20.00
For every 15 mins
26
Sessions/Jobs
free badge
First 15 mins free for your first session
featured mentor
Featured mentor of the week
ABOUT ME
Data and Analytics Expert with 20 Years in Excel, SQL and Azure
Data and Analytics Expert with 20 Years in Excel, SQL and Azure

After getting out of grad school with my MBA in Finance, I began my career teaching hedge fund associates, asset managers, investment bankers, private equity associates and the like how to use my company’s web tool and excel plugin for financial modeling. Over the next 15 years, I worked as the Manager of Business Analytics leading a team of 3 and migrating analytics from excel to increasingly more technical solutions using SAS, Analysis Services and other tools and then moved to Consulting where I built Analytics solutions in the cloud learning new technologies to tackle more and more challenging problems. The past 5 years I’ve spent mastering the Azure data environment while helping countless junior technical professionals improve their skills on the job and deliver solutions that align with industry best practices.

When I’m working with people, I encourage them to be curious about what we are trying to learn and why it’s useful to gain that understanding. I encourage them to break problems down into the smallest parts possible and gain understanding of what purpose each step has and what scenarios are handled. I’m trying to teach a thought process and approach that enables people to think their way through the next slightly different problem that they are faced with and not just the one problem in front of them now.

The greatest joy that I get is when I see someone I’ve been working with take the next step, seeing a new issue and developing a solution that takes the next step beyond the patterns of the past to apply a new way of getting to the answer. Technology will never be more than an ever expanding tool belt, and an ability to correctly learn and marry the capability of the tools to the problems in front of you is far more valuable than being able to consistently mimic a pattern for a narrow use case without real understanding.

Eastern Time (US & Canada) (-05:00)
Joined July 2024
EXPERTISE
6 years experience
I have deep experience in Power BI designing engaging Reports and dashboards. I work hard at making the reports both user friendly with ...
I have deep experience in Power BI designing engaging Reports and dashboards. I work hard at making the reports both user friendly with things like the use of bookmarks to hide and unhide filter panes, modify the displayed set of visualizations, as well as powerful with drill-through, hover reports, and conditional formatting. I'm also strong in the dataset design side with 13 years of experience with SSAS. I can be considered a Senior Power BI Developer resource.
26 years experience | 1 endorsement
I've been building complex excel models for the past 20 year. After getting my MBA, I started at a company named Capital IQ where I was i...
I've been building complex excel models for the past 20 year. After getting my MBA, I started at a company named Capital IQ where I was in charge of training Investment Bankers, Private Equity Associates and other financial analyst types how to use our research platform and excel plug-in to create financial models (it pulled in public company financial data). We did operating (income statement, balance sheet, cash flow) models, Monte Carlo simulations (for Collateralized Debt Obligation financial instruments), valuation models based on comparable company and transaction multiples, Merger Arbitrage models and more. I also used VBA to create macros for task automation extensively. I have deep experience with all kinds of modeling within excel. Over my career, I've moved to overseeing and training teams of people to do both this and other technical work as I moved into the consulting space. I'm new to the Codementor platform, but I've been doing the work for the past 20 years, and in depth training and teaching of people around this stuff for the past 10 years.
6 years experience | 1 endorsement
I have designed, overseen and implemented 4 major re-platform end to end data solutions within the Azure environment with responsibility ...
I have designed, overseen and implemented 4 major re-platform end to end data solutions within the Azure environment with responsibility for the overall architecture, configuration both around component integration and security, and implementation within the various parts of the solution. These solutions all went from source database or flat-file to database (Azure SQL, Azure SQL Managed Instance or Dedicated Pool) via Data Factory or Synapse Pipelines. On top of that we implemented either SSAS or Power BI Tabular for the tabular model and Power BI for the Report and Dashboard Development. I am experienced in delivering across all of those components. I should be considered a senior architect resource in Azure Cloud.
View more
View more
14 years experience
I've been building working with MS SQL back to SQL 2000 and have built solutions in basically every version of up through today's Azure S...
I've been building working with MS SQL back to SQL 2000 and have built solutions in basically every version of up through today's Azure SQL, SQL Managed Instance and Dedicated Pool instances. Mixed in, I've also done work on Oracle, MySQL and Postgres with a mix of both analytics and application TSQL use cases for the occasional project giving me a broader understanding of SQL's place within a wide variety of data solutions as a whole. I've worked on designing, implementing and optimizing everything from strict data warehouse structures to customized reporting structures that are optimized to narrow use cases depending on the requirements of the job. I can be considered a Senior Architect with Database Design expertise in SQL.
5 years experience
I have developed in and overseen multiple Azure Data Factory implementations with deep experience leveraging Key Vault for linked service...
I have developed in and overseen multiple Azure Data Factory implementations with deep experience leveraging Key Vault for linked service configuration, Azure DevOps and GitHub for Source Control Configuration with established branching and deployment strategies, and parameterized pipelines, linked services and integration runtime instances. On the development side, I created multiple parameterized pipeline patterns for different data tasks, as well as data flow patterns for big data ETL processes. I've also worked on pipeline optimization with configuration around polybase, default DTU usage, retry logic, etc. This is a space where I have a lot of deep experience and can be considered a senior resource.
6 years experience
I've created Power Apps largely for a combination of Data Capture through forms ingesting to both Databases as well as Power BI datasets ...
I've created Power Apps largely for a combination of Data Capture through forms ingesting to both Databases as well as Power BI datasets directly. I've also embedded the Power Apps directly within Power BI.
13 years experience
I first learned SSAS multidimensional in 2011 and since then quickly moved on to SSAS Tabular and more recently (the last 5 years or so) ...
I first learned SSAS multidimensional in 2011 and since then quickly moved on to SSAS Tabular and more recently (the last 5 years or so) Power BI Tabular datasets as they came together functionally. I have deep experience designing performant models with partitioning, general star schema layouts as well as bridge based Many-to-Many relationships that enable deep analytics. I've created user friendly hierarchies, complex DAX measures and purpose driven calculated tables. I've also implemented row-level security with a custom security model allowing access to data controlled at multiple levels. I'm a senior architect level expert in this space.

REVIEWS FROM CLIENTS

5.0
(10 reviews)
Ike
Ike
October 2024
Great Resource and will guide you in the right direction.
Ryan
Ryan
September 2024
Rare to find on codementor a tutor with so much experience, would recommend 10/10. Despite the queries being app design and jeff more focussed on data. He was able to on the fly pick ideas apart and create a learning environment. Would use again.
EMPLOYMENTS
Senior Data Architect
Centric Consulting
2012-01-01-Present
I am a Senior Data Architect at Centric Consulting. We are a national full-service management consulting firm over 750 strong focused on ...
I am a Senior Data Architect at Centric Consulting. We are a national full-service management consulting firm over 750 strong focused on Business Consulting and Technology Solutions. Within the Data and Analytics service offering, I focus on Cloud Cost Optimization and Management, Cloud Data Analytics Implementation and subject matter expertise project work across multiple technology platforms. Across the company we have a wide array of technology and customer vertical experience across a range of company sizes from the Fortune 100 down to a 2 person startup.
Azure
SSAS
Power BI
View more
Azure
SSAS
Power BI
CI/CD
Azure Data Factory
Azure synapse analytics
DevOps
View more
Manager of Business Analytics
Direct Capital
2008-04-01-2012-01-01
Built and maintained SSAS cube, integrating data from 5 different source systems. The cube enabled analysis around Sales Pipeline, Email ...
Built and maintained SSAS cube, integrating data from 5 different source systems. The cube enabled analysis around Sales Pipeline, Email marketing, outbound call campaign, Pay Per Click (Google and Bing), and investment portfolio loss information (equipment lease portfolio).
SQL
Excel
SSIS
View more
SQL
Excel
SSIS
SSAS
SSRS
Access
View more
PROJECTS
Secura Insurance - Insurance Analytics Platform
Secura Insurance
2024
Technical Lead for the business analyst, development, testing and CI/CD teams on implementation of Centric’s Insurance Analytics Platform...
Technical Lead for the business analyst, development, testing and CI/CD teams on implementation of Centric’s Insurance Analytics Platform, enabling Billing, Policy and Claims analytics. Stood up full Azure based solution with Azure Synapse Analytics, Azure Data Factory, Power BI Tabular Model and Dashboards and supported by Azure DevOps and other components. Oversaw and mentored mixed team of 15 client and Centric resources across Data Modeling, ETL development, Tabular Model and Power BI Development, Azure DevOps development, and data and infrastructure testing.
SQL
Power BI
CI/CD
View more
SQL
Power BI
CI/CD
Azure SQL Database
Azure Data Factory
Azure synapse analytics
Azure synapse
DevOps
View more
Cloud Cost Assessment, Optimization and Management
Multiple
2023
Architected Cloud Cost Assessment, Analytics and Monitoring toolset for deployment as either a SaaS Solution or within a client Cloud env...
Architected Cloud Cost Assessment, Analytics and Monitoring toolset for deployment as either a SaaS Solution or within a client Cloud environment. Enabled analysis of consumption patterns, custom granular alerting around spend increases or anomalies, savings opportunities based on reserved instance purchases, savings plan purchases, configuration or solution design changes and resource orchestration changes. Completed assessments with recommendations and implementation that resulted in annualized ROI of over 300% in the first year of implementation.
Power BI
Azure SQL Database
Azure Blob Storage
View more
Power BI
Azure SQL Database
Azure Blob Storage
Azure Data Factory
View more