Back to list

Excel Data Analyst Resume Sample

➣ Hire now

Location

Poland

Rate

$40 / per hour

Years of experience

About

As a Senior Data Analyst, I have honed my skills in SQL, Python, and Power BI, leveraging these technologies to drive substantial business impact. Currently, as an Assistant Manager in Data Analytics at DigitalRealty, I enhance global sales performance through advanced data analysis, utilizing SQL and Oracle to develop effective sales strategies. I create Power BI reports and dashboards for data communication, design and maintain advanced SQL queries and Oracle database procedures for ETL processes, and collaborate closely with the Director of Analytics to translate business requirements into technical specifications. My work has significantly contributed to increased sales and streamlined sales processes. Previously, at Bank Alfalah, I focused on anomaly detection in the Temenos T24 Core Banking System, providing critical support to field auditors and identifying control leakages, which resulted in significant revenue recovery. I created dynamic Power BI dashboards using Python for data preprocessing and proactively conducted thorough audits of bank databases. Additionally, I automated 90% of manual data analysis using Arbutus Analyzer and Power Automate, saving valuable time and improving accuracy. My role also included developing robust data monitoring systems to detect policy violations and fraudulent activities early. My experience at Nexus Corporation involved leading a team to create data-driven KPI models and improving process performance, which boosted company output by 25%. With a Bachelor's degree in Computer Science from Iqra University and various certifications, I am dedicated to leveraging data analytics to drive business success.

Tech Stack

Data Analysis, Agile, AWS and Cloud, Git, Hive, Jira, Machine Learning, MS Excel, MySQL, Power BI, Python, Salesforce Object Query Language, Scrum, SQL, Tableau, Visual Basic (VB)

Experience

Enhanced global sales performance at DigitalRealty through advanced data analysis, leveraging SQL, Oracle, and Power BI to develop effective sales strategies and create insightful reports and dashboards.
Designed and maintained advanced SQL queries and Oracle database procedures for extracting, transforming, and loading (ETL) processes, ensuring data accuracy and availability for reporting at DigitalRealty.
Provided critical support to field auditors at Bank Alfalah by extracting and analyzing data from multiple sources to identify potential anomalies and developing an analytics reporting solution.
Created dynamic and interactive Power BI dashboards at Bank Alfalah and DigitalRealty, using Python for data preprocessing and manipulation to enhance data communication and informed decision-making.
Automated 90% of manual data analysis tasks at Bank Alfalah using Arbutus Analyzer and Power Automate, improving accuracy and efficiency.
Developed and implemented robust data monitoring systems at Bank Alfalah, employing automation and machine learning algorithms to continuously monitor and analyze large volumes of transactional data, enabling early detection of policy violations and fraudulent activities.
Led a team at Nexus Corporation to create data-driven KPI models focusing on product and process performance, which helped boost company output by 25% and improved overall process performance using Python, Snowflake, and Tableau.

Employment history

Assistant Manager Data Analytics, DigitalRealty July 2023 - Present

Utilized SQL, Oracle, and data analysis to develop effective sales strategies, contributing to increased sales.
Created Power BI reports and dashboards for enhanced data communication and informed decision-making.
Designed and maintained advanced SQL queries and Oracle database procedures for ETL processes, ensuring data accuracy and availability for reporting.
Collaborated closely with the Director of Analytics to translate business requirements into technical specifications, leading to the development of custom reports and dashboards that align with strategic goals.

Senior Data Analyst, Bank Alfalah November 2019 - July 2023

Provided critical support to field auditors by extracting and analyzing data from multiple sources to identify potential anomalies and developing an analytics reporting solution.
Successfully identified and rectified control leakage in minimum balance service charges and customer billing, resulting in the recovery of up to 25K+ USD in revenue.
Created dynamic and interactive Power BI dashboards using Python for data preprocessing and manipulation.
Conducted thorough audits of bank databases, employing advanced querying and analytical methods to identify deviations from established policies and procedures.
Automated 90% of manual data analysis by creating workflows using Arbutus Analyzer and Power Automate.
Developed and implemented robust data monitoring systems, employing automation and machine learning algorithms to continuously monitor and analyze large volumes of transactional data.
Led an Agile team of 4 developing 70+ reports and dashboards using T24 data warehouse and Hive Big Data.

Data Analyst, Nexus Corporation July 2019 - November 2019

Led a team of 3 to create data-driven KPI models focusing on product performance at customer sites, and the quality performance of processes at supplier sites.
Provided a peak view of overall process performance using Python, Snowflake, and Tableau.
Offered data-driven recommendations that helped boost company output by 25% and improved process performance.