Back to Developers
Parth Mago

Parth Mago

Data Analyst

Chandigarh, India $40/hr Remote Full-time 3+ yrs exp 92 ยท Outstanding

About

Data Analyst with 3+ years of experience in SQL, Python (Pandas, NumPy), Power BI, DAX, ETL, PySpark, and Snowflake specializing in data visualization, predictive analytics, and business intelligence. Proven expertise in optimizing SQL queries and ETL pipelines, improving data retrieval efficiency by up to 25% for large-scale, multi-regional datasets. Skilled in designing and deploying interactive Power BI dashboards, enhancing real-time reporting accuracy by 20% and enabling strategic decision-making. Proficient in Python-based statistical analysis, churn prediction, and customer segmentation, driving a 15% improvement in retention and acquisition strategies. Adept at integrating diverse datasets, data cleaning, and preprocessing to ensure high-quality analytics aligned with business objectives. Strong analytical thinker with experience in cross-functional collaboration, problem-solving, and implementing data-driven strategies to optimize operational efficiency.

Skills & Expertise (27)

Python Advanced
8.0/10
3
Years Exp
Power BI Dashboard Development Advanced
8.0/10
3
Years Exp
Python Programming Advanced
8.0/10
3
Years Exp
Data Visualization Advanced
8.0/10
3
Years Exp
Power BI Advanced
8.0/10
3
Years Exp
SQL Advanced
8.0/10
3
Years Exp
DAX Advanced
7.5/10
3
Years Exp
ETL Pipeline Development Advanced
7.5/10
3
Years Exp
Pandas Advanced
7.5/10
3
Years Exp
Business Intelligence Advanced
7.5/10
3
Years Exp
Predictive Analytics Advanced
7.5/10
3
Years Exp
PySpark Advanced
7.5/10
3
Years Exp
ETL Advanced
7.5/10
3
Years Exp
NumPy Advanced
7.0/10
3
Years Exp
Microsoft Excel Advanced
7.0/10
3
Years Exp
Data Preprocessing Advanced
7.0/10
3
Years Exp
Data Cleaning Advanced
7.0/10
3
Years Exp
Workflow Automation Advanced
7.0/10
3
Years Exp
Statistical Analysis Advanced
7.0/10
3
Years Exp
Customer Segmentation Advanced
7.0/10
3
Years Exp
Snowflake Advanced
7.0/10
3
Years Exp
SQL Query Optimization Advanced
7.0/10
3
Years Exp
Seaborn Intermediate
6.0/10
2
Years Exp
scikit-learn Intermediate
6.0/10
2
Years Exp
MySql Intermediate
6.0/10
2
Years Exp
Postgresql Intermediate
6.0/10
2
Years Exp
Jira Intermediate
5.0/10
2
Years Exp

Work Experience

Senior Associate Analyst

WNS Global Services

Sep 2024 - Dec 2025

Redesigned cross-regional data pipelines, incorporating PySpark for large-scale transformation and cleansing of insurance datasets alongside optimized SQL query strategies, improving multi-layer processing speed and overall system performance by 25%. Executed large-scale churn forecasting initiatives, leveraging advanced predictive models to identify behavior trends and drive a 15% decrease in customer attrition. Developed scalable Power BI architectures featuring sophisticated DAX models and automated refresh mechanisms, ensuring real-time analytics accessibility across global teams. Designed scalable ETL pipelines using SQL, Snowflake, and PySpark to integrate multi-source datasets, improving reporting consistency and reducing data processing time by 25%. Automated enterprise reporting workflows using SQL, Snowflake, and Power BI, reducing manual reporting effort by 35% and enabling faster business insights. Implemented performance-oriented data engineering frameworks that enhanced data reliability, accelerated reporting cycles, and improved decision-support across regions. Leveraged advanced DAX calculations and Python analytics to drive global marketing strategies, contributing to a 20% increase in customer acquisition and improved campaign ROI. Translating complex, multi-source datasets into actionable insights, empowering leadership with data-driven guidance for strategic planning and operational excellence. Collaborated closely with cross-regional stakeholders to ensure data integrity, optimize analytics initiatives, and align insights with overarching business priorities. Spearheaded predictive modeling and advanced analytical frameworks, driving revenue growth, improving customer retention metrics, and supporting long-term business scalability.

Associate Analyst

WNS Global Services

May 2023 - Aug 2024

Streamlined and modular data-processing structures, applying optimized query logic and refined indexing methods that elevated throughput for large datasets by nearly 20%. Created advanced customer segmentation schemes using clustering and statistical exploration, enabling early detection of risk-prone groups and supporting targeted corrective actions. Delivered interactive, business-aligned Power BI visual suites featuring intuitive drill paths and deep-dive layers, translating operational trends into clear, executive-ready insights. Performed large-scale data transformation using PySpark and SQL, preparing analysis-ready datasets for predictive modeling and executive reporting. Introduced insights-led process enhancements that reduced functional turnaround times and boosted the efficiency of analytics workflows across teams. Developed scalable ETL workflows leveraging Snowflake, SQL, and Python, improving data quality and enterprise reporting consistency. Performed in-depth assessment of high-volume claim rejections using Python libraries and analytical querying techniques, uncovering key patterns that streamlined approval processes and improved acceptance rates by 15%. Applied predictive modeling and exploratory forecasting methods in Python to anticipate operational trends, quantify risk levels, and guide data-backed performance improvements.

Trainee Analyst

WNS Global Services

May 2022 - Apr 2023

Streamlined SQL queries, boosting data retrieval efficiency by 25% and optimizing overall database performance. Executed comprehensive data cleaning and validation processes, ensuring accuracy and reliability of business reports for informed decision-making. Developed and implemented automated test scripts, reducing defects by 30% and enabling seamless integration throughout the SDLC. Conducted root cause analysis and collaborated with cross-functional teams, enhancing system reliability and workflow efficiency by 20% while aligning testing strategies with business objectives.

Education

Bachelor of Technology in Computer Science and Engineering - Chitkara University

- 2023 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 12/15
๐Ÿ’ฐ Rate 5/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 92/100

Profile Overview

Member sinceAug 2026
Work ModeRemote
AvailabilityFull-time

Availability Details

Visa Status

Need Sponsorship

Relocation

Open to Relocation