Summary
Overview
Work History
Education
Skills
Timeline
Generic

SARFARAZ KARIM

Chicago,IL

Summary

Data driven analyst with sound experience in data interpretation, statistical analysis, and trend forecasting. Strengths lie in problem-solving ability, strategic thinking, and exceptional technical skills such as proficiency in SQL and Excel. Showcased impact by contributing to data-driven decision making that increased efficiency and improved business outcomes in previous roles.

Overview

3
3
years of professional experience

Work History

Senior Analyst

Hafey & Karim Law
04.2024 - Current
  • Conducted an in-depth analysis of the Dallas immigrant population using U.S. Census data, Pew Research reports, and local government statistics, identifying that over 30% of immigrants in Dallas originated from Mexico, India, and Vietnam.
  • Identified top immigration service needs in high-immigrant-density neighborhoods (Green Cards, naturalization, asylum) by reviewing Google search trends, immigration forum discussions, and competitor case studies, refining the firm’s service positioning.
  • Launched educational content on social media, focusing on trending immigration topics such as asylum, visa processing delays, green cards, and current immigration politics, leading to a 20% increase in inbound traffic.
  • Developed a manual client tracking dashboard in Excel to analyze lead sources, case approval rates, and client retention, providing insights that improved case management efficiency.
  • Created an audience segmentation strategy by identifying the top immigrant groups in Dallas and their most common legal needs, leading to a 25% increase in relevant client inquiries.
  • Used Google Search Console and Google Analytics to track organic traffic, identifying that 'Dallas work visa attorney' and 'green card lawyer' were high-ranking keywords, leading to a 35% boost in search visibility.

IT Consultant

AbbVie
08.2023 - 01.2024
  • Company Overview: Contracted by cGMP
  • Designed and implemented 25+ financial reports and interactive dashboards (Power BI & Tableau)
  • Enabled real-time KPI tracking and driving a 10%-25% increase in operational efficiency across global factories through data-driven insights
  • Implemented data-backed solutions that achieved a 10% improvement in expense management for factory production of Humira and Skyrizi
  • Provided actionable recommendations that enhanced cross-functional collaboration through SharePoint and supported global business objectives
  • Streamlined data integration and migration processes across systems (Excel & SAP), reducing errors and improving reporting accuracy for operational metrics
  • Contracted by cGMP

Business Consultant

PanamaKare
07.2022 - 07.2023
  • Spearheaded financial analysis initiatives to improve business growth using Salesforce, Power BI, and SharePoint
  • Developed and executed targeted market expansion strategies that increased the average customer base by 35% for local businesses
  • Resulted in an average of a 20% increase in ROI and a 30% improvement in sales targets and operational growth for local businesses
  • Identified and resolved 30+ critical bottlenecks from all the B2B worked with through process mapping and root cause analysis
  • Streamlined decision-making processes by implementing data-driven frameworks and automation tools, reducing cycle times and improving project delivery success rates

Education

Bachelor of Science - Finance with Minors in Data Analytics and Management

University of Illinois at Chicago

Skills

  • Bloomberg Terminal
  • Excel
  • Data Visualization
  • Market research
  • Power BI
  • Python
  • Salesforce
  • SAP
  • SharePoint
  • SQL
  • Tableau
  • Languages: English, Spanish, Bengali, Urdu

Timeline

Senior Analyst

Hafey & Karim Law
04.2024 - Current

IT Consultant

AbbVie
08.2023 - 01.2024

Business Consultant

PanamaKare
07.2022 - 07.2023

Bachelor of Science - Finance with Minors in Data Analytics and Management

University of Illinois at Chicago
SARFARAZ KARIM