Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Anam Tariq

TX

Summary

Results-oriented Data Analyst with 4+ years of experience specializing in data interpretation and analysis to drive actionable business insights. Proficient in crafting and optimizing SQL queries across Oracle, SQL Server, and MySQL databases. Adept at designing and developing interactive visualizations using Power BI and building sophisticated Tableau dashboards, incorporating advanced reporting techniques such as dimensions, measures, hierarchies, and data blending. Skilled in identifying data trends, outliers, and inconsistencies, with a strong track record in data normalization, and cleaning. Possess entry-level proficiency in Python, utilizing libraries like pandas and matplotlib for basic data manipulation and visualization tasks. Known for a strong commitment to meeting project deadlines while maintaining high accuracy and quality of work. Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

5
5
years of professional experience

Work History

Data Analyst

Luminant
11.2022 - Current
  • Worked closely with stakeholders to gather requirements and understand their reporting needs
  • Crafted and optimized SQL queries to extract, transform, and analyze data from various sources, enhancing data processing efficiency by 25%
  • Developed and managed interactive Power BI dashboards that visualized key business metrics, trends, and performance indicators
  • Utilized advanced Power BI features such as DAX calculations, Power Query transformations, and custom visuals to enhance data insights and user experience
  • Established and configured Row-Level Security (RLS) in Power BI to ensure that users only have access to data relevant to their roles
  • Defined security roles and rules to control data visibility and maintain data confidentiality across various business units
  • Optimized Power BI report performance by implementing best practices in data modeling, query optimization, and dashboard design
  • Reduced report load times and improved user experience through efficient data retrieval and visualization techniques
  • Implemented incremental refresh in Power BI to optimize data processing and improve refresh times for large datasets
  • Configured refresh policies to update only new or changed data, enhancing performance and reducing resource consumption which resulted in 30% improvement in data processing time for large data sets
  • Provided training and support to team members and end-users on using Power BI, understanding RLS configurations, and leveraging incremental refresh features.
  • Produced monthly reports using advanced Excel spreadsheet functions.

Junior Data Analyst

AT&T
01.2021 - 10.2022
  • Collaborated with marketing and operational teams to gather requirements, understood their needs and translated those insights into actionable data solutions
  • Gathered and analyzed data from diverse sources, applying normalization techniques to eliminate redundancies and ensure data integrity
  • Analyzed data to uncover trends, patterns, and actionable insights
  • Created a comprehensive data dictionary for team reference, facilitating consistent data interpretation
  • Utilized SQL to extract and manipulate data from various databases, ensuring accurate and timely reporting
  • Developed and optimized complex DAX queries to create dynamic and efficient measures, calculated columns, and custom tables in Power BI, enhancing data analysis capabilities
  • Developed and maintained a Power BI dashboard to track critical operational metrics
  • Configured real-time data refreshes and interactive features to provide timely and actionable insights to management, enabling proactive decision-making
  • Integrated Scrum methodologies to enhance project management and team collaboration, ensuring timely delivery of data solutions
  • Performed exploratory analysis on customer feedback, identifying key themes and trends that led to a 15% improvement in customer satisfaction ratings through targeted experience enhancements.

Data analyst intern

Alliance Tek
03.2020 - 12.2020
  • Assisted in collecting, cleaning, and organizing data from various sources to ensure data integrity
  • Entered and maintained data in databases, ensuring consistency and reliability
  • Analyzed behavior patterns of 2K customers using cluster analysis, enhancing marketing campaigns
  • Performed basic data analysis tasks, such as calculating averages, summarizing data, and identifying trends using Excel and SQL
  • Supported senior analysts by providing preliminary data insights for ongoing projects
  • Assisted in generating simple reports and visualizations for internal stakeholders using Tableau and Excel
  • Worked with a cross-functional team to develop and implement a comprehensive data analysis project using Excel and Tableau, leading to a 20% increase in operational efficiency
  • Effectively communicated findings and recommendations to stakeholders with my team, driving a 30% increase in the adoption of suggested improvements.

Education

Scrum Master Certification -

Scrum Alliance
01.2023

Data Analytics Boot Camp -

01.2019

Bachelor's in Business Administration -

University of Punjab
01.2014

Skills

  • SQL, Basic Python
  • Microsoft SQL Server, Oracle Database, PostgreSQL
  • SQL Developer, SQL Server Management Studio, Jupyter Notebook
  • PowerBI, Tableau, MS Excel
  • Pandas, Matplotlib

Timeline

Data Analyst

Luminant
11.2022 - Current

Junior Data Analyst

AT&T
01.2021 - 10.2022

Data analyst intern

Alliance Tek
03.2020 - 12.2020

Scrum Master Certification -

Scrum Alliance

Data Analytics Boot Camp -

Bachelor's in Business Administration -

University of Punjab

Similar Profiles

CREATE PROFILE
Anam Tariq