Aaron Rodriguez Email & Phone Number

Toney, AL, US

Nashville, Tennessee, United States

Designed and developed star schema data model and SSAS tabular model for Power BI reports. Also refactored Power BI reports for performance improvements.

Memphis, TN

Designed and developed reports for various stakeholders using SSAS, Power BI, and DAX. Worked closely with data engineers to determine best design approach.

Memphis, TN

Created and maintained BI solutions with SSIS, T-SQL, views, and stored procedures.

Memphis, TN

Designed and created Power BI dashboards using star schema data models and DAX for various stakeholders. Deployed dashboards to Power BI premium capacity using deployment pipelines for design and data validation Analyzed slow running Power BI reports using performance analyzer and DAX Studio. Supported reporting and troubleshooting processes on Tableau.

Memphis, TN

Design and implement new ETL pipeline for marketing project utilizing SSIS Script Task, Python, Google Reporting API, and SQL Server.Create and maintain BI solutions with SSIS, T-SQL, views, and stored procedures. Design and load data marts with star schema for SSAS OLAP models.Develop SSAS tabular models using DAX and row-level security. Design Power BI.

Collierville, TN

Created ETL channel from Oracle to SQL Server in order to demo a POC of SSAS and Power BI capabilities. Developed SSAS tabular models for subsequent reporting solutions using complex sql queries and row-level security. Ensured DAX best practices and performance over large datasets using DAX Studio to write, execute, and analyze DAX queries.Designed Power.

Oakland, TN

Developed SSIS packages to ETL data from various sources including flat files, Excel files, and SQL Server for insertion into data marts with star schema. Data marts included asset management, sales, and CRM. Extensive data modeling and dashboard design using Power BI Desktop and Power Query with DAX, views, stored procedures, parameters, and row-level.

Memphis, TN

Maintained and updated extract scripts from Progress OpenEdge source to SQL Server staging tables. Performed transformations and loading into data warehouse using SSIS. With ABL expressions, created stunning and clutter free dashboards for end-users using inmydata for live data insights.Designed and implemented reporting cubes and dashboards using SQL.

Memphis, TN

Ensured that development and project upgrades were implemented for optimal technology performance and reliability. Interfaced with packaging clients, consultants, developers, and end users to review and interpret functional requirements as directed. Assisted with the development of technical specifications, work estimates, and project schedules to meet.

Memphis, TN

Worked with team to develop solutions and manage multiple tasks.Resolved issues associated with client workstations. Provided accurate records of each call incident in Help Desk tracking tool. Installed and configured operating systems using windows images.

Huntsville, Alabama Area

Tasked with life cycle development of interactive technical manuals using structured XML formats and Arbortext Epic Editor.Utilizing SSIS, connected to multiple sources such as SQL Server and MySQL; SSIS packages were designed and loaded into data warehouse for reporting. Created SQL jobs to trigger nightly updates. Developed SSRS parameterized reports.