نبذة عني
Working as a Data Analyst with 5 years of experience in Data Analysis, Statistical Analysis, Data preparation such as Data Extraction, Data Cleansing, Data Validation and Exploratory Data Analysis to ensure the data qual…
Working as a Data Analyst with 5 years of experience in Data Analysis, Statistical Analysis, Data preparation such as Data Extraction, Data Cleansing, Data Validation and Exploratory Data Analysis to ensure the data quality. Good knowledge of Software Development Life Cycle (SDLC) including Requirements analysis, design specification and testing as per cycle in both Agile and Waterfall Framework methodologies. Experience in developing different Statistical, Data Mining solutions to various business generating and problems data visualizations using Python and Power BI Design and development of Data warehouse for Business Intelligence reporting. Good knowledge of designing stunning visualizations using Power BI software and publishing and presenting dashboards, Storyline on web and desktop platforms. Capable in designing and developing ETL objects using Informatica Power center with various transformations like joiner, aggregate, expression, SQL, lookup, filter, update strategy, stored procedures, router, rank, and normalizer transformations. Hands on experience in Stored Procedures, Functions, Triggers, and strong experience in writing complex queries, using SQL Server and MySQL. Strong attention to detail, ability to manage multiple projects and meet deadlines, while maintaining data integrity & quality standards.
الخبرة
Data Analyst
Analyzed and transformed data using various SQL functionalities using MySQL server to generate data extracts and reports.
Conducted data analysis experiments, A/B testing, and statistical modeling to optimize business processes, improve customer experience, and increase operational efficiency.
Stayed up to date with the latest cloud technologies, data analytics tools, and industry trends, and recommended innovative solutions to enhance data analytics capabilities.
Developed data wrangling through data gathering and querying process over SQL and implemented data cleaning process with R and Python.
Developed sales reports using the on-premises data on Microsoft Excel and Power BI.
Utilized Power BI to create various analytical dashboards that help business users to get a quick insight into the data.
Worked on data cleaning and reshaping, generated segmented subsets using NumPy, Pandas, matplotlib, and SciPy in Python, resulting in a 25% reduction in data errors.
Provided support to end users for production issues and built custom SQL scripts for business needs.
Continuously improve data analysis processes and methodologies.
Stay abreast of emerging technologies and industry best practices to enhance efficiency and effectiveness.
Data Analyst
data analyst
• Analyzed and transformed data using various SQL functionalities using MySQL server to generate data extracts and reports.
• Conducted data analysis experiments, A/B testing, and statistical modeling to optimize business processes, improve customer
experience, and increase operational efficiency.
• Stayed up to date with the latest cloud technologies, data analytics tools, and industry trends, and recommended innovative
solutions to enhance data analytics capabilities.
• Developed data wrangling through data gathering and querying process over SQL and implemented data cleaning process with R
and Python
Data Analyst
Creating an aggregated report daily for the client based on the analysis of data given by the client and data available at the open data sources.
Experiencing statistical methods, metrics, quantitative methods, and strategic project plans for data collection and later given the responsibility to validate the data integrity.
Analyzed data of various clients from various sources, visualized findings in dashboards, and presented to upper management across departments to draw meaningful conclusions.
Developed & maintained statistical dashboards in Tableau to track bi-weekly sprint task progress based on KPIs (user stories, the accuracy of the products, resources, budget, etc.) increasing team efficiency by 20%.
Analyzed and optimized complex SQL queries for various products reducing the total execution time by 13% across all products.
Using visualization tools Power BI, Tableau, and SQL dashboard for the process of searching, exploring, and visualizing data.
Analyzing spatial data to prepare an analysis report based on geographical regions.
Data Analyst
Leveraged expertise in Data Warehouse, SQL queries, Data pipelines, Business Applications, data synchronization, Business Process Analysis, Reporting, Database Development, Cloud Architecture, and Data Integration to drive a 25% improvement in data accuracy and efficiency.
Demonstrated proficiency in data models, data analytics, MS Excel, solution recommendations, and Team building, leading to a 30% increase in team productivity and collaboration.
Prepared the data rules spreadsheet using MS Excel that will be used to update allowed values, findings, and profiling results.
Participated in designing and developing of Relational Database Management, Database Design, and Database architecture Systems using, Monet DB, PostgreSQL, and SQL Server.