PAVAN

PAVAN

Data Analyst
Canada

نبذة عني

5+ years of extensive experience in Analyzing, Designing and Implementing Data Analysis and Engineering strategies for both small and large-scale data environments. Experience in all stages of the Data Lifecycle, includi…

الخبرة

Data Analystddata a

broadridge
Sep 2023 - حتى الآن · 2 سنوات 9 أشهر

• Architected and implemented scalable data pipelines using Python and Apache Airflow for ETL processes handling terabytes of data daily.
• Engineered data models and optimized database performance on PostgreSQL and Redshift for efficient query execution and storage management.
• Developed real-time monitoring dashboards in Tableau to visualize KPIs and business metrics, facilitating data-driven decisions.
• Automated data ingestion from AWS S3, API sources, and IoT devices using Lambda functions and Kinesis streams, reducing data latency by 30%.
• Implemented data validation rules and quality checks using SQL and Python scripts to ensure data integrity and compliance with GDPR regulations.
• Integrated machine learning models into data pipelines for predictive analytics and recommendation systems, improving user engagement by 25%.
• Collaborated with data science team to deploy NLP models for sentiment analysis on customer feedback data, enhancing customer experience insights.

Data Analyst

Broadridge Financial
Sep 2023 - حتى الآن · 2 سنوات 10 أشهر

Architected and implemented scalable data pipelines using Python and Apache Airflow for ETL processes handling terabytes of data daily.
Engineered data models and optimized database performance on PostgreSQL and Redshift for efficient query execution and storage management.
Developed real-time monitoring dashboards in Tableau to visualize KPIs and business metrics, facilitating data-driven decisions.
Automated data ingestion from AWS S3, API sources, and IoT devices using Lambda functions and Kinesis streams, reducing data latency by 30%.
Implemented data validation rules and quality checks using SQL and Python scripts to ensure data integrity and compliance with GDPR regulations.
Integrated machine learning models into data pipelines for predictive analytics and recommendation systems, improving user engagement by 25%.
Collaborated with data science team to deploy NLP models for sentiment analysis on customer feedback data, enhancing customer experience insights.

Data Analyst

State Bank of India, India
Mar 2019 - Nov 2022 · 3 سنوات 8 أشهر

Conducted advanced statistical analysis and machine learning modeling using Python (Pandas, scikit-learn) to derive insights and forecast trends in customer behavior.
Designed and optimized SQL queries for complex data extraction and aggregation from large-scale relational databases (Oracle, MySQL).
Developed automated reporting systems using Tableau, Google Data Studio, and Power BI, reducing report generation time by 40%.
Led A/B testing initiatives to optimize marketing campaigns and product features, resulting in a 15% increase in conversion rates.
Collaborated with cross-functional teams to implement data-driven strategies and segmentation models for personalized customer targeting.
Analyzed web traffic and user interaction data using Google Analytics to optimize SEO strategies and content performance.
Created data visualization dashboards in Tableau to track key performance indicators (KPIs) and business metrics, presenting insights to stakeholders.
Identified data requirements and created data marts to facilitate analytical reporting across departments.

Data Analyst

WIPRO, India
Dec 2017 - Feb 2019 · 1 سنة 2 أشهر

Extracted data from AWS Redshift using PostgreSQL to generate company-wide Tableau reports and dashboards.
Performed data cleaning, manipulation, and sampling on large multi-gigabyte datasets using Python and SQL.
Implemented K-Mode clustering analysis with Python on Linux to segment website visitors based on engagement patterns and time spent in specific categories.
Collaborated with internal stakeholders to drive strategic initiatives and provide actionable insights for business decisions.
Utilized advanced Excel functions to support the revenue team with ad-hoc analysis for affiliate marketing strategies.
Analyzed social media data from platforms like Facebook, Instagram, and Twitter to measure post-performance using metrics such as impressions, clicks, and CPC.
Conducted hypothesis tests to analyze the impact of new website features like CTA buttons and banners on performance metrics such as CTR and RPM.
Configured critical reports in Google Analytics using Attribution Modeling to identify conversion points and optimize marketing efforts.
Analyzed survey data to calculate Net Promoter Score (NPS) for measuring brand loyalty among website users.

المهارات

التحليلات تحليل البيانات المحترف إدارة نظم المعلومات تنقيب البيانات مايكروسوفت أكسس نظام التحليل الإحصائي (SAS) لغة الاستعلامات الهيكلية (SQL) تمثيل البيانات مهارات تحليل البيانات باور بي آي لغة البرمجة آر (R) تابلو Python Pig Hive Oracle PostgreSQL SQL Server MySQL MS Access ggplot2 Matplotlib Seaborn SAP BO OBIEE Time Series Analysis Forecasting Hypothesis Testing T Test Z Test A/B Testing Regression Analysis Decision Trees Random Forests Gradient Boosting SVM K-NN Jenkins Maven SVN GIT Apache Airflow Apache Spark Kafka AWS Redshift Lambda Kinesis Google Data Studio Google Analytics Pandas scikit-learn Linux Excel Firebase Mixpanel Talend Informatica
الإبلاغ عن هذا الملف الشخصي؟