About
Analytical Data Analyst with 2 years of experience in data collection, transformation, visualization, and KPI-driven insights using SQL, Power BI, Excel, Python, and Tableau. Skilled in building dashboards, validating data, and optimizing ETL workflows to drive business decisions and improve operational performance. Experienced in translating business requirements into actionable analytical solutions.
Skills & Expertise (16)
Work Experience
E-Commerce Analytics
Brandy Melville
May 2025 - Present
Developed interactive dashboards and reports using Power BI and Tableau to support business decision making. Processed and analyzed large datasets using Python (Pandas, NumPy) for data cleaning, transformation, and automation. Wrote and optimized SQL and MySQL queries to extract and analyze data from relational databases. Utilized Power Query and advanced Excel functions for efficient data preparation and reporting. Designed and managed ETL workflows using SSIS to integrate data from multiple sources. Performed data modeling and validation to ensure high-quality business intelligence solutions.
Data Analyst
Softinton Solutions Private Limited
Jan 2024 - Present
Gather, transform, and analyze large datasets from multiple business systems to support data-driven decision making. Develop interactive dashboards, KPI scorecards, and visual reports using Power BI and Tableau. Perform detailed data validation to ensure accuracy, consistency, and reliability of insights. Optimize ETL workflows by improving data pipelines, automation, and performance tuning using SSIS. Conduct statistical analysis and exploratory data analysis to identify trends, patterns, and anomalies. Build reusable automation scripts using Python and Excel for data cleaning and preprocessing. Communicate analytical findings clearly to both technical and non-technical stakeholders. Monitor KPIs to assess performance, identify gaps, and recommend improvement strategies.
Banking Analytics
WesBanco
Jan 2024 - Apr 2025
Managed and analyzed banking data using MySQL to maintain accurate and optimized databases. Utilized Power Query for data extraction, transformation, and preparation from multiple sources. Developed advanced Excel dashboards and reports using pivot tables and data visualization techniques. Designed and implemented ETL processes using SSIS for automated data workflows. Collaborated using JIRA and Git for project tracking, version control, and team coordination. Conducted data modeling, data warehousing, statistical analysis, and validation to ensure data reliability.
Education
Bachelor of Engineering — Electrical and Electronics Engineering - Paavai Engineering College
2018 - 2022 · Afghanistan
