Nini Asrat Email & Phone Number

United States

New Jersey, United States

• Data Source Connectivity: Connected to diverse data sources, such as SQL Server, Db2, Azure SQL DW, and flat files. Utilized Power Query for data extraction and transformation, employing both geographical interfaces and M language designed a report and dashboard improved all overall decision making by 25%.• Demonstrated expertise in Power Query to connect to diverse data sources (SQL Server, Db2, Azure SQL DW, and flat files), utilizing geographical interfaces and M language for data extraction, transformation, and design of a Power BI report and dashboard, resulting in a remarkable 25% enhancement in overall decision-making.• Expertly utilized Power BI Desktop to create datasets, establish data table relationships, and develop visually appealing reports, leveraging the tool's powerful capabilities for effective data transformation and visualization.• Data Warehousing: Modeled data warehouses using star and snowflake schemas. Implemented appropriate design patterns to optimize data storage and retrieval.• Complex Measures and Security: Developed complex measures, columns, and implemented row-level security using Data Analysis Expressions (DAX). • Leveraged advanced expertise in Power BI to create complex measures and columns while implementing robust row-level security through Data Analysis Expressions (DAX), guaranteeing secure access to sensitive data based on user roles.• Reports and Dashboards: Generated diverse types of reports and dashboards catering to specific business requirements. • Developed a wide range of reports and dashboards tailored to specific business needs, employing Power BI to create visually captivating and interactive visualizations, contributing to effective data analysis.• Demonstrated adeptness as a Power BI Analyst by publishing reports and dashboards to Power BI Service workspaces, creating apps, and sharing workspaces to promote collaboration and knowledge sharing.

Washington, United States

• Experienced in creating and managing over 50 schema objects, including tables, views, triggers, indexes, and stored procedures, that increase the performance, ensuring efficient database structure and referential integrity. • Created and managed over 50 schema objects, including tables, views, triggers, indexes, and stored procedures, ensuring efficient database structure and referential integrity. • Worked on Business Intelligence standards processes by developing database layers with user-friendly views in SQL. Successfully deployed these layers to SSRS (SQL Server Reporting Services) and Power BI, resulting in a 30% improvement in report generation efficiency. • Standardized Business Intelligence processes by developing database layers with user-friendly views in SQL. Successfully deployed these layers to SSRS (SQL Server Reporting Services) and Power BI, resulting in a 30% improvement in report generation efficiency.• Proficient in various ways in extracting more than 100 ETL tasks, employing various transformations such as conditional splits, multitask operations, merge union all, audit derived columns, lookup operations, and slowly changing dimensions. These tasks effectively managed data flow and improved data quality by reducing data anomalies by 20%. • Proficient in writing optimized queries, subqueries, and joins for generating stored procedures and triggers, resulting in a 15% reduction in query execution time and improved system performance.• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

• Worked to analyze a variety of sources of data to 5 different projects in collaboration with USAID to support the construction and rehabilitation of access to clean drinking water in rural parts of the country that improved 15% of the health of the community.• Conducted baseline surveys at 15 hospitals, ten schools, and 5 orphanage camps, resulting in the identification of key areas for improvement in the healthcare system. These efforts contributed to a 20% decrease in maternal and child mortality rates within the targeted regions. • Determined sectors and underwent in person surveys on 15 hospitals,10 schools and 5 humanitarian associations analyzed the response and identified key areas. These efforts contributed 15% overall health care services, schools’ system, and humanitarian associations. • Developed and implemented a data-driven solution that improved access to services for women and underrepresented communities. This led to a 30% increase in the utilization of essential healthcare services and a notable enhancement in the quality and cultural competence. • Led a team of 5 members to collect, compile, and analyze diverse datasets for 10 different projects, meeting company requirements and achieving an average accuracy rate of 95%. • In collaboration, my team designed and delivered educational programs for youth and women, covering a range of topics to bridge the gap between health practices and cultural norms. Successfully reached and positively impacted five hundred individuals, fostering better understanding of an overall health, academic successes, and healthy adulthood.

Computer Science, In Progress

Bachelor'S Degree, Public Health

Certificate, Health Informatics