Ephrem G. Email & Phone Number

Alexandria, Va, Us

Washington, District Of Columbia, United States

• Designed and maintained intuitive Power BI visual displays, including dashboards and reports for clear data comprehension.• Utilize Power Query and Power Pivot for data shaping and modeling.• Collaborate with business analysts and stakeholders to understand reporting requirements and translate them into effective Power BI solutions.• Optimize Power BI reports and queries for enhanced performance and responsiveness.• Optimize Power BI reports and queries for enhanced performance and responsiveness.Integrate Power BI solutions with SharePoint for seamless data sharing and collaboration.• Utilized PowerShell scripts to improve ETL processes, data validation, and API connections, reinforcing data precision.• Design and maintain SharePoint sites, libraries, and lists to support effective document management.• Created detailed reports and visual dashboards using Power BI and Excel, assimilating data from varied sources effortlessly.• Create and maintain documentation for Power BI and SharePoint solutions, including data models, report specifications, and user guides.

Virginia, United States

Washington, District Of Columbia, United States

• Apply industry-specific knowledge to create Power BI reports tailored to insurance-related metrics and KPIs.• Develop analytics dashboards that provide insights into key performance indicators relevant to the insurance sector.• Collaborated with team members to create useful reports and dashboards, providing valuable insights and automating processes.• Developed and automated complex SQL scripts on the Snowflake platform for data profiling and addressing business questions.• Ensure compliance with data governance policies and standards in the insurance industry.Incorporate geospatial analysis into Power BI solutions for visualizing insurance data based on geographical regions.• Utilize mapping features to enhance the understanding of regional insurance trends and risks.• Design Power BI reports to analyze claims data, identify patterns, and assess the financial impact of insurance claims.• Develop visualizations that aid in understanding loss ratios and improving claims processing efficiency.Integrate external data sources, such as third-party insurance databases or market trends, into Power BI models for a comprehensive view of the insurance landscape.Implement real-time reporting capabilities in Power BI to provide instant visibility into critical insurance metrics.• Develop custom Power BI visuals or extensions to meet unique reporting requirements specific to Geico's insurance analytics.