Deepak Raj Koteeswaran

Deepak Raj Koteeswaran

Data Analyst
Canada

نبذة عني

Over 3+ years of experience in Data Analysis, proficient in utilizing tools like Power BI, for advanced data visualization, contributing to enhanced business decision-making through insightful reporting Versatile profess…

الخبرة

Data Analyst

Canada Steam Ship Lines, Canada
May 2023 - حتى الآن · 3 سنوات 2 أشهر

Conducted complex data manipulation using SQL to optimize operations, including filtering, joining, aggregating, and transforming large datasets to streamline processes.
Implemented advanced Excel Macros and VBA scripts to automate repetitive tasks, significantly increasing operational efficiency and improving data accuracy for reporting
Used Power BI for the development, and crafting of sophisticated visualizations, and managing deployments, ensuring high-quality business intelligence solutions
Involved in using the comprehensive Microsoft BI stack, including mastery of TSQL, Power BI, Power Query, DAX, M, MDX, SSAS, SSRS, and SSIS, facilitating robust data analysis and reporting frameworks
Configured and managed Microsoft Power BI Service, adept at utilizing Dataflows, DataMart’s, Dashboards, and Apps to derive actionable insights from complex datasets
Worked in SQL development team, proficient in writing advanced queries and procedures, and utilizing SQL functions to generate curated data sets for insightful reporting
Utilized SQL and Excel Pivot Tables for comprehensive analysis, uncovering insights that enhanced operational efficiency.
Thoroughly conducted statistical analysis and data mining utilizing Python and Looker, with additional support from VLOOKUP in Excel. This comprehensive approach enabled the evaluation of trends, landscapes, and preferences.
Employed Python, utilizing libraries like Pandas and NumPy, for in-depth data analysis and visualization, including creating predictive models to optimize operational strategies.

Data Analyst

Canada Steam Ship Lines, Canada
May 2023 - حتى الآن · 3 سنوات 2 أشهر

• Conducted complex data manipulation using SQL to optimize operations, including filtering, joining, aggregating, and transforming large datasets to streamline processes.
• Implemented advanced Excel Macros and VBA scripts to automate repetitive tasks, significantly increasing operational efficiency and improving data accuracy for reporting
• Used Power BI for the development, and crafting of sophisticated visualizations, and managing deployments, ensuring high-quality business intelligence solutions
• Involved in using the comprehensive Microsoft BI stack, including mastery of TSQL, Power BI, Power Query, DAX, M, MDX, SSAS, SSRS, and SSIS, facilitating robust data analysis and reporting frameworks
• Configured and managed Microsoft Power BI Service, adept at utilizing Dataflows, DataMart’s, Dashboards, and Apps to derive actionable insights from complex datasets
• Worked in SQL development team, proficient in writing advanced queries and procedures, and utilizing SQL functions to generate curated data sets for insightful reporting
• Utilized SQL and Excel Pivot Tables for comprehensive analysis, uncovering insights that enhanced operational efficiency.
• Thoroughly conducted statistical analysis and data mining utilizing Python and Looker, with additional support from VLOOKUP in Excel. This comprehensive approach enabled the evaluation of trends, landscapes, and preferences.
• Employed Python, utilizing libraries like Pandas and NumPy, for in-depth data analysis and visualization, including creating predictive models to optimize operational strategies.

Data Specialist

Greeny Homes, India
Jan 2020 - Apr 2022 · 2 سنوات 3 أشهر

Involved in documenting comprehensive business requirements, processes, and workflows using the robust capabilities of Power BI and Excel VBA
Advanced proficiency in MS Excel, including extensive knowledge of functions, macros, and VBA programming, to support complex data manipulation and analysis tasks
Thoroughly detail-oriented professional proficient in independently managing tasks, adeptly prioritizing using ETL tools, KPI tracking, and SAS and this ensures optimal efficiency and productivity, even within dynamic and fast-paced environments
Elevated data processing velocity and refined the precision of analytical models via sophisticated data manipulation and analysis methodologies within CRM and Snowflake platforms
Consistently conveyed intricate data insights in an easily comprehensible format to stakeholders, leveraging the dynamic visualization capabilities of Tableau and the structured reporting features of SSRS and SSIS
Developed and maintained sales reports and dashboards that provide real-time insights into sales metrics, KPIs, and team performance and ensured stakeholders had access to actionable data to inform sales strategies and operational adjustments
Proficiently utilized Azure and Pandas to complement exceptional written and verbal communication skills, alongside strong presentation abilities

المهارات

التحليلات تحليل البيانات المحترف إدارة نظم المعلومات تنقيب البيانات مايكروسوفت أكسس نظام التحليل الإحصائي (SAS) لغة الاستعلامات الهيكلية (SQL) تمثيل البيانات مهارات تحليل البيانات باور بي آي لغة البرمجة آر (R) تابلو Looker Advanced Excel VLOOKUP Macros Pivot Tables ETL MS SQL Server SSIS SSRS Snowflake Python VBA Power Query DAX Machine Learning Models CRM Software TSQL Power BI Service Dataflows DataMart Dashboards Apps Excel Pandas NumPy Azure Jira Confluence Agile MDX SSAS
الإبلاغ عن هذا الملف الشخصي؟