Horacio Hernandez Email and Phone Number

Microsoft Business Intelligence Developer with 6+ years of work experience in developing Business Intelligence solutions .Strong experience in using the Microsoft BI Stack (SQL, SSIS, SSAS, SSRS and Power BI). Worked with SQL Server versions 2012 through 2022.Good understanding in Microsoft Power BI, Power Query, Power Pivot, Power BI Service, Power BI Desktop, Microsoft Excel Pivot Table, and data models to gather information from multiple sources and deliver information to the end user.Experienced in using Power BI Premium, and Power BI Pro, Tableau.Experience with DAX skills and the ability to create and troubleshoot complex calculations and measures.Excellent back-end skills in creating SQL objects such as Tables, Complex Stored Procedures, User-defined Functions, Views, Indexes, Triggers, Rules, and SQL Performance Tuning to facilitate efficient data manipulation and consistency.Experienced in creating complex (SSIS) packages for ETL purposes. Performed data migration from various type of sources (Excel, Flat File, CSV, XML, OLTP DB, etc.), Data Conversions, Data Extraction/Transformation/Loading (ETL) using SSIS and SQL scripts.Experienced in configuring (SSIS) packages using package logging, Breakpoints, Checkpoints, and Event Handling to fix the errors. Expert in troubleshooting SSIS packages using a variety of techniques/tools.Experienced in designing and developing a considerable number of reports in SSRS using the data from ETL Loads. Proficient in developing Drill-through and Drill-down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS).Experienced in SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery, and Report security.Strong knowledge of data marts, Operational Data Store (ODS), SSAS Tabular, Star Schema modeling, and Snowflake modeling for Fact and Dimension tables