Hawi Jordan
Summary
With a proven track record at Kaiser Permanente, I excel in SQL development and stakeholder collaboration, driving data-driven decisions. My expertise in Power BI and data visualization significantly improved decision-making speed by 50%, showcasing my ability to transform complex data into actionable insights. Experienced professional with a strong background in technology-related roles. Proficient in software development, system administration, and technical support. Skilled in problem-solving and optimizing performance. Capable of managing projects and collaborating effectively with teams. Committed to continuous learning and staying current with industry trends to contribute to organizational success.
Overview
5
5
years of professional experience
Work History
SQL | Snowflake | Power BI Developer
Queens LLC
Washington, DC
02.2023 - Current
- Experienced in analyzing and understanding the business requirements, definition, and design of the data sourcing and data flows, involved in creating functional and technical specification documents after gathering requirements from the business.
- Created database objects like tables, DML, DDL, views, stored procedures, functions, joins, and indexes in T-SQL based on the functional specifications.
- Developed complex T-SQL queries and SQL scripts for efficient data load based on complex business rules.
- Designed complex ETL strategies to pull data from different sources, such as SQL Server, Oracle, and flat files, and load it to the destination database after using multiple transformations.
- Worked on Snow SQL and created a Snow pipe for continuous data load.
- Develop stored procedures and views in Snowflake, and use them in Talend for loading dimensions and facts.
- Worked with DAX/MDX queries in building expressions for various business calculations.
- Building, publishing customized interactive reports and dashboards, and report scheduling using the Power BI service.
- Involved in developing Power BI visualizations and dashboards using Power BI Desktop.
- By using Power BI Desktop connected to various data sources, and working with different visualizations.
- Developed and published reports and dashboards using Power BI, and wrote effective DAX formulas and expressions.
- Design, develop, and deploy custom applications using Power Apps, Power Automate, and Power Virtual Agents.
- Provide support and maintenance for Power Platform solutions.
- Utilized Power Query in Power BI to pivot and unpivot the data model for data cleansing and data massaging.
- Created several user roles and groups for the end user, and provided row-level security to them.
- Created Power BI reports using the Tabular SSAS models as source data in Power BI Desktop, and published reports to the service.
- Worked with table and matrix visuals, and worked with different levels of filters, such as report level, visual level, and page level filters.
- Used various data visualizations, including imported or custom visuals.
- Configured incremental refresh and deployment pipelines in Power BI.
- Designed, developed, and deployed different reports, such as Matrix and Tabular reports, with Top N, Cascaded, Parameterized, and pie chart reports using SSRS with Report Builder.
- Used parameters to configure URL report filters and capture the last data refresh date and time in Power BI.
- Environment: MS SQL Server 2019, 2017, 2016, 2014; Microsoft Visual Studio 2017, 2019; MS Access; MS Excel; MS Visio; SQL Server Profiler; Windows Server 2014, 2016.
SQL/Power BI Developer/Analyst
Kaiser Permanente
Silver Spring, MD
08.2021 - 02.2023
- Worked with the business users to understand the architecture, data model, business logic, and rules to be applied to meet the reporting needs.
- Discussed with stakeholder teams to capture high-level transformation rules, produce features, define metrics, and User Interface Design Document acceptance.
- Created complex stored procedures, triggers, functions, indexes, tables, views, SQL joins, and other T-SQL code to implement business rules.
- (Used CTE, temporary tables, and user-defined table types in codes developed.)
- Performed T-SQL tuning and optimization of queries for reports that take longer execution times using MS SQL Profiler, Index Tuning Wizard, and SQL Query Analyzer in MS SQL Server 2017/2019.
- Wrote complex SQL queries to read data from source databases to analyze the source system after joining multiple tables.
- Worked with a data modeler to understand the data model from different source systems, and was also involved in creating dashboards by extracting data from different sources. Prepared STTM (source to target mapping) for ETL and report development.
- Created data visualizations, and applied various actions (URL, filter, parameters) in Power BI Desktop.
- Develop, organize, manage, and maintain graphs, tables, and document templates for the reports.
- Used SQL, PowerPoint, InfoView, and Excel daily to generate various performance reports for analysis.
- Developed different types of visualizations, like combination charts, slicers, map visualizations, matrices and tables, scatter charts, waterfall and funnel charts, gauges, and single-number cards, as well as visual hierarchies and drill-downs in the Tableau reports.
- Used different functions, like number, string, date, type conversions, and aggregate functions.
- Developed custom SQL queries to minimize the data, to improve the performance in Power BI.
- Utilized advanced features of Tableau software, like linking data from different data sources together on one dashboard, to filter data in multiple views.
- Developed Power BI dashboards and published them onto the server, which allowed end users to understand the data on the fly with the use of quick filters for on-demand needed information.
- Scheduled data refresh for weekly and monthly increments based on business changes to ensure that the views and dashboards display the changed data accurately.
- Used an Excel sheet for multiple purposes, such as data analysis, data comparison, reporting, data mapping, etc.
- Environment: Power BI 2.7, MS Office Suite, Oracle 12c, MySQL 7.1, SQL Server 2017/2019, PowerPoint.
- Improved and corrected existing software and system applications.
Database/BI Developer
Purusha LLC
Virginia Beach, Virginia
03.2020 - 08.2021
- Developed and maintained Power BI dashboards and reports to monitor business performance, focusing on key metrics such as sales trends, customer behavior, and operational efficiency.
- Transformed raw data from multiple sources (e.g., sales, inventory, customer data) into meaningful insights by creating data models and visualizations in Power BI.
- Conducted data analysis on sales performance, identifying trends, seasonal patterns, and customer preferences to drive decision-making and strategy.
- Performed regular data cleaning, transformation, and validation using Power Query and SQL to ensure high-quality, reliable datasets.
- Collaborated with cross-functional teams to define key performance indicators (KPIs), and provided actionable insights to improve operational efficiency, customer experience, and financial performance.
- Provided data-driven recommendations to optimize inventory management, reduce waste, and improve cost-efficiency across business operations.
- Created and automated monthly and weekly reports to track business trends and operational performance, ensuring timely distribution to senior management.
- Designed and delivered interactive dashboards and reports that allowed stakeholders to explore data and derive insights independently, increasing organizational data literacy.
- Developed sales forecasting models, and helped refine pricing strategies by analyzing historical trends and customer demand.
- Key Achievements:
- Implemented a Power BI dashboard that provided real-time tracking of sales, inventory, and customer satisfaction, which led to a 50% improvement in decision-making speed.
- Identified inefficiencies in the supply chain through data analysis, leading to a reduction in stockouts and a 10% to 25% improvement in inventory turnover.
- Played a key role in a data-driven pricing strategy, which increased average order value (AOV) by 25% by tailoring offers and pricing to customer behavior trends.
- Streamlined reporting processes by automating key reports, reducing report generation time by 40 hours per week, and enabling quicker access to insights for leadership.
- Environment: Power BI Desktop 2.29, MS Office Suite, SQL Server 2014, UNIX.
Education
High School Diploma -
Addis Ketema
Skills
- Power BI
- SQL development
- Data visualization
- ETL processes
- DAX formulas
- Database design
- Data analysis
- Reporting tools
- Stakeholder collaboration
- Data structures
- Agile
- Back end development
- Microcontroller skills
- Decision-making
Clearance
Active Secret Clearance
Tools And Technologies
MS SQL Server, MS Access, Oracle, DB2, PostgreSQL, SQL Server Management, Snowflake, T-SQL, DAX, PL/SQL, Snow SQL, C#.Net, Python, SQL Server Integration Services (SSIS), IBM DataStage, Informatica Cloud, Power BI, Tableau, SQL Server Reporting Services (SSRS), Crystal Reports, Report Studio, Report builder, Windows 7/10, Windows 2016, Windows 2017, Windows 2019, Windows Server 2012, Windows Server 2014, Windows Server 2016, Windows XP
Timeline
SQL | Snowflake | Power BI Developer
Queens LLC
02.2023 - Current
SQL/Power BI Developer/Analyst
Kaiser Permanente
08.2021 - 02.2023
Database/BI Developer
Purusha LLC
03.2020 - 08.2021
High School Diploma -
Addis Ketema
Similar Profiles
HANNAH BELLANGERHANNAH BELLANGER
Manager of Operations at The Cleaning Queens LLCManager of Operations at The Cleaning Queens LLC
Renae VermilyeaRenae Vermilyea
Administrative and Operations Assistant at Volusia Coupon Queens, LLCAdministrative and Operations Assistant at Volusia Coupon Queens, LLC
VISHVAJA MEWADAVISHVAJA MEWADA
Animal Research Technician at Queens UniversityAnimal Research Technician at Queens University
Shangamitra RajaveluShangamitra Rajavelu
SQL Developer/Data Analyst (Snowflake, Power BI, MSSQL) at Tata Consultancy ServicesSQL Developer/Data Analyst (Snowflake, Power BI, MSSQL) at Tata Consultancy Services
CHETHAN H OCHETHAN H O
Lead BI (Power Bi,Azure(ADF, Snowflake, Sql) at JLL TechnologiesLead BI (Power Bi,Azure(ADF, Snowflake, Sql) at JLL Technologies