mahi

mahi

DATA Analyst
United States of America

نبذة عني

Highly motivated data analyst with 3 years of experience in leveraging data to drive insights and inform business decisions. Proven ability to wrangle, analyze, and visualize data from diverse sources to identify trends,…

الخبرة

Data Analyst

adpmn
Jan 2023 - حتى الآن · 3 سنوات 6 أشهر

As a Data Analyst, I serve as the liaison between business and technical teams, translating business requirements into actionable technical specifications for data-driven projects. This involves collaborating with various departments to gather clieJiraeeds and access relevant data resources. I leverage data analysis and statistical modeling techniques to optimize operational efficiency, reduce costs, and enhance revenue streams. Additionally, I champion data quality and consistency by leading the Data Correction and Validation process, ensuring data integrity across departments. My expertise includes querying diverse data sources using complex SQL queries and utilizing Python for data gathering, cleaning, and wrangling. I excel in transforming data into compelling narratives using Power BI, controlling user access to dashboards, and monitoring key performance indicators to provide actionable insights for informed decision-making. My proficiency in Azure services and project management tools like Jira, Confluence, and ServiceNow ensures efficient project execution and collaboration.

DATA Analyst

Adpmn
Jan 2023 - حتى الآن · 3 سنوات 6 أشهر

Bridge the gap between business and technical teams by gathering, analyzing, and translating business requirements into actionable technical specifications for data-driven projects.
Proactively collaborate with other departments to collect client needs and access relevant data resources.
Leverage data analysis, statistical modeling, and strategic recommendations to optimize operational efficiency, reduce costs, and enhance revenue streams for the organization.
Champion data quality and consistency by leading the Data Correction and Validation process.
Utilized data utilities to identify and resolve mismatches between different departments, ensuring data integrity and reliability.
Possess expertise in querying diverse data sources including Oracle DB, Teradata, and Azure Synapse Analytics using complex SQL queries.
Performed data analysis and profiling to gain deeper insights.
Uncover root causes of data discrepancies between different business systems through thorough analysis of business rules and data models.
Communicated these findings to the development/bug fix team for resolution.
Utilize Python for data gathering, cleaning, and wrangling, ensuring data preparation for further analysis.
Participated in the Data Reconciliation Process, validating loaded data against user reports for accuracy.
Demonstrate proficiency in working with various data formats (CSV, XML, JSON, flat files, TSV, XLSX, PDF, parquet) for effective data manipulation and management.
Develop advanced SQL queries to troubleshoot tables, functions, joins, triggers, views, and stored procedures, contributing to efficient database management.
Transform data into compelling narratives using Power BI.
Employed DAX functions, slicers, and filters to manipulate data and generate interactive reports, effectively communicating insights to stakeholders.
Control user and group access to published dashboards within the Power BI environment, ensuring data security and accessibility based on user roles.
Monitor and report on trends in key performance indicators (KPIs), providing actionable data-driven insights with root cause analysis.
Highlighted potential areas of concern for informed decision-making.
Possess extensive knowledge of Azure services including Data Factory, Data Lake Storage, Synapse Analytics, and Azure SQL Database, leveraging them for data management and analysis tasks.
Proficiently utilize Jira, Confluence, and ServiceNow for comprehensive project management, documentation, and IT service management, ensuring project efficiency and effective collaboration.

DATA Analyst

People Prime worldwide
Jan 2019 - Nov 2020 · 1 سنة 10 أشهر

Conducted cost-benefit analysis comparing on-premises and Azure Cloud hosting solutions, identifying efficiency gains and cost reductions.
Collaborated with Application Owners and Cloud Architects to develop a phased migration strategy, minimizing operational disruptions and optimizing resource utilization.
Prepared and delivered monthly reports to stakeholders, providing insights into budget utilization, cost savings, and post-migration performance metrics.
Utilized MS SQL Server for efficient data analysis, mapping, and manipulation, writing complex SQL queries to extract and analyze large datasets.
Designed and implemented data storage solutions, including NoSQL MongoDB databases, ensuring data quality, governance, and scalability.
Developed ETL workflows using Informatica Power Center, reducing data processing time by 20% with improved accuracy.
Created Python scripts to extract and transform data from internal client sites, facilitating seamless data loading into databases.
Generated reports in Power BI on infrastructure budget analysis, inventory auditing, and financial statements, presenting findings to stakeholders.
Developed interactive dashboards and reports in Power BI using DAX formulas, Power Pivot, and Power Query, enabling insightful analysis and reporting.
Collaborated with cross-functional teams to develop data solutions, improve business processes, and develop industry trend reports and dashboards.
Utilized ServiceNow for issue tracking and resolution, ensuring consistent service level agreements.
Managed tasks and data analysis workflows using Agile methodology through JIRA.

المهارات

التحليلات تحليل البيانات المحترف إدارة نظم المعلومات تنقيب البيانات مايكروسوفت أكسس نظام التحليل الإحصائي (SAS) لغة الاستعلامات الهيكلية (SQL) تمثيل البيانات مهارات تحليل البيانات باور بي آي لغة البرمجة آر (R) تابلو Python Bash/Unix Shell Scripting PySpark Linux Java HTML CSS Pandas NumPy Matplotlib TensorFlow Informatica Power Center SSIS Azure Data Factory DBT Snowflake Google Cloud Platform (GCP) Microsoft Azure MS SQL Server MySQL Teradata Synapse Analytics MongoDB Excel SSRS Spark Hadoop JIRA ServiceNow Git GitHub Bitbucket Oracle DB Azure Synapse Analytics DAX Confluence Azure SQL Database Power Pivot Power Query Azure Functions Azure Cognitive Services Azure DevOps Azure App Service Support Vector Machines (SVM) Principal Component Analysis (PCA) Agile methodology
الإبلاغ عن هذا الملف الشخصي؟