Netsy Geb

Data Analytics/Power BI Developer
Engineered, refined, and maintained SSIS packages for efficient ETL (Extract, Transform, Load) processes, ensuring seamless data consolidation from diverse sources into data warehouses and marts.
Conducted data cleaning tasks to identify and rectify data discrepancies, preserving data integrity and accuracy throughout the ETL operations.
Created engaging and visually appealing reports and dashboards using SSRS and Power BI, assisting stakeholders in comprehending key metrics and supporting informed decision-making.
Conducted thorough data analysis to uncover trends, patterns, and outliers, providing crucial insights for business strategy enhancement and procedural optimization.
Contributed to the design and implementation of data models to streamline data analysis and reporting, aligning data structure with specific business needs.
Improved the efficiency of SQL queries, SSIS packages, and reporting queries, reducing data processing time and enhancing overall performance.
Collaborated with various teams to define data requirements and establish effective data integration strategies, ensuring consistent data exchange across systems.
Transformed intricate data sets into clear visual representations and practical reports, simplifying complex information for stakeholders' understanding.
Maintained detailed records of ETL methodologies, data models, and reporting guidelines, providing a foundation for knowledge sharing and smooth team transitions.

Data Analytics/Power BI Developer
Collaborated with the data engineering team to conceptualize and refine data models for analytics, utilizing SQL Server Analysis Services (SSAS).
Developed complex DAX (Data Analysis Expressions) measures within Power BI to precisely compute business metrics and Key Performance Indicators (KPIs).
Designed interactive Power BI dashboards with detailed drill-down capabilities, enabling in-depth data analysis for business users.
Established automated, data-driven report distribution in SQL Server Reporting Services (SSRS), streamlining report sharing with relevant stakeholders.
Conducted thorough data profiling and quality checks, identifying and addressing data discrepancies and irregularities.
Played a key role in shaping and building the data warehouse architecture, focusing on scalability and maintaining data integrity.
Actively engaged with users to understand and fulfill their specific reporting needs, ensuring the delivery of custom-tailored solutions.
Improved reporting efficiency and visualization by transitioning existing SSRS reports to dynamic, interactive Power BI dashboards.
Developed tailored SSRS reports featuring sophisticated formatting and visual components to enhance data presentation.
Analyzed and optimized SQL query performance, providing recommendations for database performance enhancements.

Data Analytics/Power BI Developer
Responsible for crafting and refining essential database components, such as views and indexes, aligned with logical design models, user needs, and physical limitations.
Engaged in the creation, upkeep, and management of sophisticated reporting systems, including data cleansing activities, report structuring, analytics, and additional BI tools like Tableau.
Authored and executed T-SQL (DDL and DML) scripts, procedures, and packages, managing slowly changing dimensions to preserve historical data integrity.
Constructed comprehensive GSHS Reports in Power BI from the ground up, involving tasks related to dimensions, measures, and MDX query formulation.
Created diverse visual representations, including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, and Scatter Plots in Power BI for various view-driven dashboards.
Utilized Power BI and Pivot/View for designing multiple dashboards and scorecards, catering to various departmental and executive management needs.
Developed data marts and designed multi-dimensional structures like Star and Snowflake schemas.
Applied various DAX functions to perform complex fact calculations, enhancing Power BI data visualizations.
Engineered intricate Power BI reports incorporating advanced graphical elements like gauges and funnels for in-depth business analysis.
Focused on converting data into accessible visualizations in Power BI to provide comprehensive insights to business users.
Integrated data into Power BI from various sources, including SQL Server and Oracle.
Participated in the setup of Power BI Report Server.
Produced Power BI reports by merging data from multiple tables and databases through complex SQL queries.
Formulated a Power BI data model incorporating several fact tables and dimensions to meet specific business needs.