Hiba Shajahan

Hiba Shajahan

Data Analyst
Canada

نبذة عني

Experienced data analyst with nearly 3 years of expertise in SQL, Data Analysis, Data Visualization and knowledgeable in Statistical Analysis and Predictive Modeling to uncover patterns and trends in large data sets Data…

الخبرة

Data Analyst

Delphi Technology
Oct 2022 - حتى الآن · 3 سنوات 9 أشهر

Collaborated with cross-functional team members, and with input from
relevant working groups or committees, determine data requirements, and
administer several annual and ad hoc data
Developed full ETL applications to move data within a corporate data
management platform, with MS SQL Server tools
Created interactive Power BI Dashboards, KPIs, and Reports for Monthly
Metric analysis to replace traditional excel reporting and automate data
refresh using Power BI On-Prem Gateways
Using Power BI, prepared ad hoc scenario assessments to assess potential
sales tactics or brand activities and supplied as-needed BI reporting to the
team responsible for commercial planning and operations
Developed custom dashboards and reports using Tableau, Power BI, and
Excel to provide real-time insights into business performance, and
collaborated with stakeholders to ensure they met business requirements
Performed data extraction, transformation, and loading tasks using SQL
Server Programming, Python, models to identify trends and patterns in data
Utilized VLOOKUP and DAX formulas to perform data analysis and reporting
tasks and developed VBA scripts and macros to automate data processing
and reporting workflows
Accurately maintained, transferred, and processed home data in different
databases by developing VBA and SQL scripts

Data Analyst

Delphi Technology, Toronto
Oct 2022 - حتى الآن · 3 سنوات 9 أشهر

Collaborated with cross-functional team members, and with input from relevant working groups or committees, determine data requirements, and administer several annual and ad hoc data
Developed full ETL applications to move data within a corporate data management platform, with MS SQL Server tools
Created interactive Power BI Dashboards, KPIs, and Reports for Monthly Metric analysis to replace traditional excel reporting and automate data refresh using Power BI On-Prem Gateways
Using Power BI, prepared ad hoc scenario assessments to assess potential sales tactics or brand activities and supplied as-needed BI reporting to the team responsible for commercial planning and operations
Developed custom dashboards and reports using Tableau, Power BI, and Excel to provide real-time insights into business performance, and collaborated with stakeholders to ensure they met business requirements
Performed data extraction, transformation, and loading tasks using SQL Server Programming, Python, models to identify trends and patterns in data
Utilized VLOOKUP and DAX formulas to perform data analysis and reporting tasks and developed VBA scripts and macros to automate data processing and reporting workflows
Accurately maintained, transferred, and processed home data in different databases by developing VBA and SQL scripts

Data Analyst

Doyen Remedies, Bengaluru
Jun 2020 - Aug 2022 · 2 سنوات 2 أشهر

Collected, Cleansed, and provided modeling and analysis of data for structured and unstructured data used for various business initiatives
Created impactful dashboards and Excel and Power BI for data reporting, extracting, interpreting, and analyzing the data to identify key metrics and transform data into meaningful, actionable information
Ingested data from different sources using SQL and Analytics API to construct data views for Tableau
Provided guidance and assistance for data visualization and report generation, specifically with visual data modeling tools such as Power BI
Developed and maintained large databases with complex relationships between tables using SSAS and created data-driven reports and dashboards using SSRS
Published reports via the Power BI service, managing them through the distribution of apps and monitoring usage/data refreshes using Gateways/security access
Created data extraction, cleansing, and load programs to move data from source systems to Data warehouses

المهارات

التحليلات تحليل البيانات المحترف إدارة نظم المعلومات تنقيب البيانات مايكروسوفت أكسس نظام التحليل الإحصائي (SAS) لغة الاستعلامات الهيكلية (SQL) تمثيل البيانات مهارات تحليل البيانات باور بي آي لغة البرمجة آر (R) تابلو Python Advanced Excel Pivot Table Data Validation Macros DAX Predictive Analysis ETL Tools Numpy Pandas VBA Scripting Data Analysis Data Cleaning Statistical Analysis Data Modeling Data Warehousing SSAS SSRS Microsoft SQL Server VLOOKUP Agile Communication Problem-solving
الإبلاغ عن هذا الملف الشخصي؟