ANDY ESHTRY
Power BI Developer | Data Analyst
Irvine, CA | andyeshtry@gmail.com | https://www.linkedin.com/in/andyeshtry/ |
(310) 936 – 5135
Summary
Dedicated Data Analyst and Business Intelligence (BI) Developer with over 10 years of solid experience in designing, developing, and supporting solutions using SQL, Power BI, and SQL Server Reporting Services (SSRS). Expertise in data modeling, report migration, and dashboard development, with a focus on transforming complex data into actionable insights for decision-making. Skilled in SQL optimization, DAX calculations, and ETL processes. Currently preparing for the Power BI Data Analyst Associate (PL-300) certification.
Keywords: Power BI, SQL, DAX, SSRS, Data Modeling, Data Visualization, Dashboards, Business Intelligence, PL-300, Report Migration, ETL, Data Analysis, SQL Optimization
Professional Experience
Business Intelligence Developer
Career Development – Irvine, CA | 03/23 – Present
- Completed Power BI projects, focusing on data preparation, data modeling, relationship management, hierarchy creation, and measure writing in DAX to produce dynamic visualizations, such as Area charts and Matrix visualizations for tracking total sales by order due date and product category.
- Created Call Center Trend Analysis reports using Power BI visualizations to display insights such as answered calls by satisfaction, call resolution, and average answer speed by agent.
- Completed Power BI Dashboard in a Day training and developed comprehensive Market Analysis reports.
- Undertaking the Power BI Data Analyst (PL-300) certification course, gaining advanced skills in data transformation and visualization.
Keywords: Power BI Development, DAX, Data Modeling, Trend Analysis, Data Visualization, Dashboard Design, Data Preparation, Business Analytics, PL-300, KPI Reporting
Support Analyst / Developer
OnTrak Health – Los Angeles, CA | 06/08 – 03/23
- Migrated clinical and financial reports from SSRS to Power BI, improving data accessibility and report visualization for business users.
- Designed and developed financial reports using SSRS, SQL Server, and T-SQL stored procedures, automating billing processes based on complex business logic, reducing processing time and increasing accuracy.
- Managed ad-hoc reporting by creating data models and leveraging advanced SQL queries to produce reports with complex joins, groupings, and aggregations.
- Streamlined Power BI dataset refresh processes, ensuring timely data availability by troubleshooting SQL queries and optimizing report performance.
- Enhanced SQL query performance by introducing new indexes, optimizing query structure, and applying data filters to reduce dataset size.
- Led SQL Server database administrative tasks during DBA absence, ensuring seamless database operation in the production environment.
- Utilized MS Excel for detailed analysis of health plan data, supporting operational and management decisions.
- Implemented Star Schema models for integrating eOnTrak data into the organization's data warehouse, ensuring a reliable and scalable BI environment.
- Developed ETL processes using SQL queries and SSIS packages for data validation, cleansing, and transformation, enabling timely data access for clinical teams.
- Proactively identified and resolved data integrity issues through SQL query analysis, addressing audit requests and ensuring data accuracy.
- Collaborated with stakeholders and product owners to gather requirements, designing solutions while participating in Agile scrum sessions, and managed tasks via Azure Boards.
Keywords: SSRS to Power BI Migration, ETL, Data Warehousing, T-SQL, Data Modeling, SQL Performance Optimization, Star Schema, Data Cleansing, SSIS, Business Intelligence, Data Transformation, Agile, Azure, Stakeholder Communication
Education
Bachelor of Science in Computer Science
US Accredited University
Certifications
- In-progress: Power BI Data Analyst Associate (PL-300)