Data Analyst - SQL, Python, Tableau

RICHARD ASIAMAH

DATA ANALYST

Dallas, TX +1-469-***-**** **************@*****.*** LinkedIn Profile GitHub Profile Tableau Profile

SUMMARY

Data Analyst with 6 years of experience driving data analytics, business intelligence, and predictive modeling initiatives across technology, insurance, and financial sectors. Expert in SQL, Python, and SAS for statistical analysis, automation, and data-driven insights that enhance business performance. Proficient in ETL development and data pipeline optimization using SSIS, Alteryx, Tableau Prep, and Power Query, integrating multi-source data into scalable environments such as Snowflake, Azure Data Lake, and AWS. Skilled in data visualization and storytelling with Tableau, Power BI, and Excel, transforming complex data into actionable insights that improve decision-making and operational efficiency. Recognized for improving reporting accuracy, optimizing workflows, and enabling data-driven strategy execution. Strong collaborator experienced in Agile methodologies and Jira, combining technical expertise, analytical thinking, and business acumen to deliver measurable and impactful results.

SKILLS

Programming Language: SQL, Python (Pandas, NumPy, Scikit-learn), SAS

Data Visualization & BI Tools: Tableau, Power BI, Excel

Cloud Technologies: Snowflakes, MS Azure (Azure Data Lake), AWS

ETL/Other Tools: SSIS, Alteryx, Tableau Prep, Erwin Data Modeler, Power Query

Databases: SQL Server, SSMS, Oracle, Snowflake

Querying Tools: SQL Management Studio, SQL Developer

Querying Language: SQL, PL/SQL, TSQL

Project Management: Jira, Agile Methodologies

Operating Systems: Windows, Linux

Soft Skills: Communication, Collaboration, Problem-Solving, Critical Thinking, Domain Knowledge

PROFESSIONAL EXPERIENCE

Data Analyst Jan 2024 – Jun 2025

Farmers Insurance Group, Dallas, TX

•Improved reporting accuracy by 20% by developing advanced SQL queries to analyze claims data, enabling more reliable stakeholder decision-making.

•Enhanced claims processing efficiency by 15% by developing and maintaining interactive Tableau dashboards, which provided real-time visualization of key performance indicators (KPIs).

•Reduced weekly report generation time by 25% by automating claims reports using SQL and Excel Power Query, streamlining workflows, and saving significant team resources.

•Centralized and optimized data storage by designing and implementing a Snowflake data warehouse, improving data accessibility and scalability for the organization.

•Delivered actionable insights by performing ad-hoc data analysis, addressing critical business questions, and supporting data-driven decision-making.

•Developed and maintained interactive Tableau dashboards to visualize key performance indicators (KPIs) related to claims processing, resulting in a 15% improvement in reporting accuracy.

•Developed and automated complex SQL and T-SQL queries to analyze large-scale claims and operational datasets, increasing reporting accuracy by 20% and reducing manual effort.

•Collaborate with cross-functional teams to identify KPIs and develop a SQL-based querying system for easier access to key information.

Data Analyst Sep 2022 – Dec 2023

MetLife, Cary, NC

•Optimized claims processing operations, achieving a 20% reduction in turnaround time through automation of data workflows using Excel VBA and SSIS, significantly improving operational efficiency and accuracy.

•Leveraged Python (Pandas, NumPy, Scikit-learn) to perform advanced statistical modeling, trend analysis, and predictive analytics, uncovering actionable insights that directly supported strategic business decisions.

•Build and publish customized interactive reports and dashboards using Tableau, ensuring accessibility and report scheduling for stakeholders.

•Documented and maintained data transformation logic, ETL procedures, and conversion mappings to support reproducibility and facilitate cross-functional collaboration.

•Extract data from on-premise and cloud storage and Load data to Azure Data Lake by using tools like Databricks and Data Factory

•Executed comprehensive data quality assessments across multiple data sources, identifying inconsistencies and implementing remediation strategies to enhance data integrity and reporting accuracy.

•Collaborated with cross-functional teams to translate analytical insights into process improvements, optimizing claims workflows, and improving overall customer experience.

•Worked with ETL processes and optimized data pipelines for Power BI reporting and interacted with business stakeholders to gather requirements and convert them into actionable dashboards.

Data Analyst Jun 2019 – Aug 2022

Dell Technologies, Round Rock, TX

•Improved business strategies and operational efficiency by developing and deploying predictive models using Python and machine learning techniques, enabling accurate trend forecasting and optimized decision-making.

•Enhanced data completeness by implementing ETL processes to integrate data from multiple sources using Tableau Prep and Alteryx, enabling comprehensive reporting.

•Utilized Pivot Tables and VLOOKUPs in Excel to improve financial data reconciliation, reducing reporting errors by 25% and improving monthly closing efficiency by 30% through automated data validation and trend analysis.

•Analyzed sales data to identify trends, resulting in a 12% increase in revenue using SQL and Tableau.

•Developed reports to optimize inventory management, leading to a 10% reduction in stock holding costs using Excel and SAS.

•Developed and implemented predictive models using Python to accurately forecast sales trends and demand patterns, improving inventory planning accuracy and supply chain efficiency.

•Performed customer segmentation analysis to tailor marketing strategies, increasing customer retention by 15% using SQL and Excel.

•Developed Tableau dashboards to track product performance, aiding in product development decisions using Snowflake as a data source.

•Collaborate on designing and maintaining the data architecture within Snowflake, ensuring efficient data models and effective data storage.

EDUCATION

Master of Science in Analytics Aug 2022 – Dec 2024

Saint Louis University, Saint Louis, MO

Contact this candidate