Rao Hanan Akram Email & Phone Number

Riyadh, Sa

Riyadh, Saudi Arabia

NUPCO CCT Project • Design and implement robust, scalable data pipelines to extract, transform, andload (ETL) data from various sources into data warehouses.• Implement data quality checks and processes to ensure the accuracyCompleteness of data.• Optimize SQL queries, Stored procedures, and indexing strategies toreduce query execution time.• Ensure data is optimized for use in reporting tools like Power BIand Tableau.• Collaborate with analysts to create efficient queries and reports thatmeet business needs.• Schedule jobs in SQL Server Agent to automate maintenance and data loadprocesses.• Automate repetitive data tasks to improve efficiency and reduce manual work.• Collaborate with Stakeholder to create efficient queries and reportsthat meet business needs.• Create reports, dashboards, and visualizations to communicate insightsto stakeholders using tools like Power BI and Tableau.• Use and maintain proficiency in relevant data engineering tools andtechnologies, such as SQL and Python.

Lahore, Punjab, Pakistan

• Conducted comprehensive data analysis on diverse datasets using advanced statistical techniques and tools. Identified trends, patterns, and correlations to provide insights that guided business strategies.• Deep dive into complex systems, tools, data, and processes to identify and solve analytical problems and provide recommendations for improvement.• Managed the end-to-end data preparation process, including data extraction, transformation, and loading. Ensured data accuracy, consistency, and relevance for data analysis.• Created intuitive and informative data visualizations using tools such as MicroStrategy to monitor different KPIs. Developed insightful reports and dashboards that facilitated data-driven discussions and strategic initiatives.• Collaborated with various teams, including marketing, products, and operations, to gather requirements, understand their data needs and translate them into actionable analytical projects.• Investigated anomalies and trends within datasets to identify root causes of business challenges. Presented findings and recommendations to stakeholders for informed problem-solving.• Conducted complex and Optimize SQL queries to extract and analyze data.• Created custom dashboards in Tableau or Power BI to visualize longer trend.• Gathered data from multiple sources in BI tools for analysis e-g (Excel, Database Table or Custom SQL query)• Conducted data preparation, cleaning, and Data blending in BI tools.• Fetched data from API into Databases by using this build dashboard in Tableau and applied ML prediction model.• Built Machine learning and data science models that predict customer behavior, rank product offerings.• Performed test (Chi Square, Information Gain and Variance threshold) for feature selection and apply feature engineering techniques (One Hot encoding and Label encoding).• Also Performed Time series Forecasting using different algorithms (AR, ARIMA, ARMA and Autoregressive)

Pakistan

• Data Analysis for Covid Survey using python:• Data Analysis and Data Visualisation 5G Vs 4G Mobile handling using python• Recognizing images of handwritten using python (Keras).• Image classification(Deep learning ) using MATLAB.• Water detection from image taken by satellite using MATLAB . etc.