Gulfam Ashraf Email & Phone Number

Richmond, Virginia, United States

Data Analyst supporting internal team.

Reno, Nevada, United States

Developed detailed reports and interactive dashboards using Cognos Analytics consolidating 1000+ reports under 300.Developed SQL queries directly in the new database for Cognos Reports and Tableau Dashboards, achieving 2-3x faster runtimes by bypassing the framework and using strict logical parameters.Validated outputs in Excel using Pivot Tables, VLOOKUPs, HLOOKUPs, INDEX-MATCH, SUMIFS, COUNTIFS, and IFERROR, ensuring data reliability and achieving over 95% accuracy.Translated Alteryx flows into stored procedures within the database, effectively eliminating Alteryx subscription costs.Migrated Reports from legacy systems to a new DB and BI tool, with 97% consistency in prompt pages and output.Worked with departments like Finance, Actuary, Underwriting, Claims, Sales, Marketing, IT, and Payments to improve reports and dashboards, consistently meeting ad hoc reporting requests within one business day.Wrote SQL scripts for old Sagent reports in new DB, employing advanced techniques like common table expressions (CTEs), nested subqueries, window functions, and complex joins to boost efficiency and readability by 40%.Built real-time KPI dashboards for executives to track critical metrics like Profit, policy counts, Taxes, exposure, premiums, claims, and risks, with interactive region-based filtering for deeper analysis shortening meetings by 30 mins.Built reports for claims & underwriting with claimant details, injury specifics, agency-level data, reserved amounts, indemnity, medical costs, recovery, new/renewed business, canceled policies, Hit Ratios, and conversion ratios.

Bristow, Virginia, United States

Used Power BI to create engaging and interactive data visualizations, incorporating a variety of chart types, tables, and maps to convey complex financial information into helpful images for data-driven decision making.Aggregated expense data from credit cards, fleet fuel cards, checks, EFS, and QuickBooks to create a comprehensive view of spending, leading to a 15% reduction in costs.Used Power BI to analyze maintenance data, achieving 95% accuracy in predicting equipment lifespan. Implemented automated driver alerts, cutting annual major repair costs by $70,000.Utilized Power Query to import, transform, and load varied datasets from multiple sources, enabling efficient and accurate data consolidation for comprehensive reporting.