shri

shri

Data Analyst
Canada

نبذة عني

A Microsoft-certified Data Analyst with 3+ years of experience specializing in comprehensive customer data analysis and data warehousing. Proven expertise in database management, data visualization, and advanced data mod…

الخبرة

Data Analyst

ITC Management Group
Feb 2023 - حتى الآن · 3 سنوات 4 أشهر


Developed and implemented interactive Power BI dashboards to track and analyze billing data, resulting in a 30% reduction in time spent on manual reporting processes

Spearheaded the implementation and management of Master Data Management (MDM) solutions, focusing on customer data integration, quality, and governance to support enterprise data consistency and reliability

Contributed to the design and implementation of a scalable MS SQL Server data warehouse, centralizing data from 5+ disparate sources and significantly enhancing the team's reporting capabilities.

Created complex SQL queries and stored procedures in Microsoft SQL Server to extract and transform billing data, improving data accuracy, and reducing processing time by 20%

Responsible for rate calculations, ensuring accurate and timely billing calculations for various utility services

Utilized Azure Databricks for data cleansing and preprocessing, automating the integration of disparate data sources into a coherent dataset for analysis, which enhanced data reliability and reduced data preparation time.

Data Analyst

ITC Management Group, Toronto, Ontario
Feb 2023 - حتى الآن · 3 سنوات 5 أشهر

Developed and implemented interactive Power BI dashboards to track and analyze billing data, resulting in a 30% reduction in time spent on manual reporting processes
Spearheaded the implementation and management of Master Data Management (MDM) solutions, focusing on customer data integration, quality, and governance to support enterprise data consistency and reliability
Contributed to the design and implementation of a scalable MS SQL Server data warehouse, centralizing data from 5+ disparate sources and significantly enhancing the team's reporting capabilities
Created complex SQL queries and stored procedures in Microsoft SQL Server to extract and transform billing data, improving data accuracy, and reducing processing time by 20%
Responsible for rate calculations, ensuring accurate and timely billing calculations for various utility services
Utilized Azure Databricks for data cleansing and preprocessing, automating the integration of disparate data sources into a coherent dataset for analysis, which enhanced data reliability and reduced data preparation time

Data Analyst

TenSketch, Chennai, India
Jun 2019 - Aug 2021 · 2 سنوات 2 أشهر

Worked with cross-functional teams to gather business requirements and develop reporting solutions using Power BI, which led to increase in user satisfaction
Implemented real-time data visualization and dashboards using Power BI for financial data analysis, resulting in a 50% reduction in financial report creation time and an increase in data accuracy
Leveraged advanced features of Power BI such as DAX and R scripts to assemble customized financial reports
Utilized MS Excel and MS SQL Server to extract and manipulate data for Power BI reporting and analysis, leading to an increase in data quality
Played a key role in the migration of legacy data systems to a modern data warehouse, resulting in a more streamlined and efficient data management process
Developed and maintained ETL processes for data ingestion, transformation, and loading into the data warehouse

المهارات

التحليلات تحليل البيانات المحترف إدارة نظم المعلومات تنقيب البيانات مايكروسوفت أكسس نظام التحليل الإحصائي (SAS) تمثيل البيانات باور بي آي لغة البرمجة آر (R) تابلو Python Agile Waterfall MySQL SQL Server Oracle PostgreSQL Grafana Qlik View Microsoft Excel OLAP OLTP Star schema Snowflake schema SSRS SSIS Pivot Tables Lookup functions Match/Index functions H-lookups V-lookups Hypothesis Testing A/B Testing Regression Analysis DAX Studio Power Query Streamlit Gradio Outlook PowerPoint Microsoft Office Jira SharePoint MS Access NumPy Pandas Matplotlib Plotly Seaborn Scikit Learn OpenCV NLTK Azure Data Factory Databricks Power BI Service DAX ETL Data warehousing
الإبلاغ عن هذا الملف الشخصي؟