Praveen

Praveen

Data Analyst
United States of America

نبذة عني

Data Analyst with experience in Power BI, SQL, Python, and Excel. Experienced in building dashboards, reports, ETL pipelines, data cleaning, data analysis, and database performance optimization.

الخبرة

Data Analyst

GEP
Aug 2019 - حتى الآن · 6 سنوات 11 أشهر

 Spearheaded the design and implementation of a dynamic monthly client report in Power BI, displaying key performance metrics and insightful visualizations to drive decision-making.
 Applied advanced SQL and Power BI skills in building intricate queries, which allow seamless data filtration, transformation, and visualization for both internal and external stakeholders.
 Pioneered the creation of comprehensive dashboards and reports offering valuable insight into critical metrics for clients, prospects, and company performance as a whole.
 Executed seamless data updates and imports into Power BI from various sources, meticulously managing the data model to ensure optimal data relationships and facilitating data analysis.
 Employed Python skills in conducting rigorous data cleaning, preprocessing, and transformation, ensuring data integrity and suitability for analysis across various platforms.
 Collaborated closely with senior data analysts to cleanse and prepare vast transactional data sets in SQL, undertaking thorough data quality assessments.
 Facilitated seamless data migration processes between staging tables in SQL and multiple data sources, including Excel, CSV files, and other SQL servers, thereby maintaining the integrity and accuracy of the data.
 Demonstrated adeptness in utilizing diverse analytical tools, such as Excel, Power BI, Python, and SQL, to conduct exhaustive data analysis and transform complex datasets into actionable insights.
 Conducted in-depth ad hoc data analysis using SQL and Power BI, which shed light on key data collection points and forecasting methodologies for product teams.
 Implemented internal process optimizations, leading to a remarkable 25% increase in operational efficiency and achieving a 100% SLA with zero errors.
 Developed robust ETL pipelines to collect, manage, and analyze datasets, contributing to a 25% boost in productivity and streamlining data analysis processes.
 Utilized advanced SQL techniques for the optimization of database performance, resulting in the improvement of query execution time and the enhancement of the overall system efficiency.
 Conducted thorough data audits and validations using SQL scripts to guarantee the accuracy and compliance of data with regulatory standards.
 Cross-functionally collaborated with stakeholders to gather requirements and translate business needs into actionable data analysis solutions.
 Participated effectively in constant learning and professional ac

Data Analyst

GEP – Navi Mumbai, India
Jun 2019 - Aug 2022 · 3 سنوات 2 أشهر

Spearheaded the design and implementation of a dynamic monthly client report in Power BI, displaying key performance metrics and insightful visualizations to drive decision-making.
Applied advanced SQL and Power BI skills in building intricate queries, which allow seamless data filtration, transformation, and visualization for both internal and external stakeholders.
Pioneered the creation of comprehensive dashboards and reports offering valuable insight into critical metrics for clients, prospects, and company performance as a whole.
Executed seamless data updates and imports into Power BI from various sources, meticulously managing the data model to ensure optimal data relationships and facilitating data analysis.
Employed Python skills in conducting rigorous data cleaning, preprocessing, and transformation, ensuring data integrity and suitability for analysis across various platforms.
Collaborated closely with senior data analysts to cleanse and prepare vast transactional data sets in SQL, undertaking thorough data quality assessments.
Facilitated seamless data migration processes between staging tables in SQL and multiple data sources, including Excel, CSV files, and other SQL servers, thereby maintaining the integrity and accuracy of the data.
Demonstrated adeptness in utilizing diverse analytical tools, such as Excel, Power BI, Python, and SQL, to conduct exhaustive data analysis and transform complex datasets into actionable insights.
Conducted in-depth ad hoc data analysis using SQL and Power BI, which shed light on key data collection points and forecasting methodologies for product teams.
Implemented internal process optimizations, leading to a remarkable 25% increase in operational efficiency and achieving a 100% SLA with zero errors.
Developed robust ETL pipelines to collect, manage, and analyze datasets, contributing to a 25% boost in productivity and streamlining data analysis processes.
Utilized advanced SQL techniques for the optimization of database performance, resulting in the improvement of query execution time and the enhancement of the overall system efficiency.
Conducted thorough data audits and validations using SQL scripts to guarantee the accuracy and compliance of data with regulatory standards.
Cross-functionally collaborated with stakeholders to gather requirements and translate business needs into actionable data analysis solutions.
Participated effectively in constant learning and professional activities to stay up with emerging trends and technologies in data analysis.
Contributed to the development of best practices and standard operating procedures for data analysis processes, ensuring consistency and efficiency across projects.

المهارات

التحليلات تحليل البيانات المحترف إدارة نظم المعلومات تنقيب البيانات مايكروسوفت أكسس نظام التحليل الإحصائي (SAS) لغة الاستعلامات الهيكلية (SQL) تمثيل البيانات مهارات تحليل البيانات باور بي آي لغة البرمجة آر (R) تابلو Microsoft Excel Python Statistical Analysis ETL Project Management Microsoft Office Suite Agile Waterfall SDLC Problem-solving Communication Presentation
الإبلاغ عن هذا الملف الشخصي؟