Aaron Rodriguez Email & Phone Number

Minneapolis, Mn, Us

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 server.

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 dashboards for various user groups. Visuals used include matrix, flow map, cards, scatter chart, kpi, slicer etc. Additional responsibilities include query performance tuning and monitoring nightly processes for future improvement.

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 BI dashboards and mobile solutions for BI modernization effort. Reveal included executive and regional management.Created and documented future reporting templates and standards with Power BI Documenter.

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 security. Created parameterized SSRS reports, sub reports, and linked reports. Employed scheduled report execution and email delivery to executive staff. Formats included exporting to PDF and Excel workbooks.

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 Server views, complex stored procedures, and Phocas Software core technologies.Designed multiple complex data models in Power BI and SSAS using DAX, SQL Server views, and calculated columns. Secured data using row-level security. Created rich and easy to use dashboards and mobile solutions.Designed, developed, and deployed parameterized SSRS reports using stored procedures.

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 defined business requirements. Performed tasks as needed to achieve on-target development, testing, go live actions, and sustain activities.

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.