Swapnil Mehta

Swapnil Mehta

.
Canada
English

About Me

I am writing to express my interest in the Data Analyst position. With a strong background in data analysis, programming, and machine learning, coupled with hands-on experience in optimizing backend systems and creating …

Experience

Independent Consultant

Capstone Project, Remote
Mar 2024 - Present · 2 years 4 months

Modernized scalable backend payment systems using Python, processing 180 transactions per second for web and mobile applications.
Designed and optimized payment solutions for Global Payments, Customer Disbursements, and Fraud Detection, improving transaction efficiency by 20%.
Automated refund and payout workflows with a Python-based disbursement tool, achieving a 98% reduction in duplicate refunds.
Implemented Kafka and RabbitMQ message queues in Python, processing 270 data streams per second to ensure high availability and system reliability.
Streamlined referral credit management systems, eliminating manual processes entirely and reducing errors.
Led Root Cause Analysis for 70+ customer issues, enhancing response times and improving resolution efficiency.
Mentored two junior engineers, fostering skill development and increasing team productivity.
Optimized database performance by normalizing tables, refining SQL schemas, and developing Python-based stored procedure optimizations, resulting in 40% faster data retrieval and reduced server load.

Data Analyst Intern

Capstone Project, Canada
Sep 2023 - Mar 2024 · 6 months

Validated data cleaning processes by comparing pre- and post-cleaning patient and medical data volumes, targeting an error rate below 1% to ensure data accuracy and integrity in compliance with healthcare standards.
Built a 3-stage machine learning pipeline to predict patient outcomes like blood pressure, achieving an RMSE below 0.05 to improve predictive accuracy in patient monitoring.
Prepared evaluation metrics like Mean Absolute Error (MAE) and Root Mean Squared Error (RMSE) to assess model accuracy in predicting healthcare metrics, maintaining RMSE below 0.05 for critical health indicators.
Achieved 95%+ data accuracy in identifying trends or potential performance issues within healthcare operational reports, enabling improvements in patient care processes.
Analysed a minimum of 3-5 patient cohorts monthly, identifying at least 2-3 key health risks and providing actionable recommendations for preventive care strategies based on the latest clinical guidelines and health trends.
Ensured 100% compliance with healthcare regulatory standards during patient data reviews and audits, safeguarding patient confidentiality and adhering to HIPAA regulations.

Web Developer Intern

TATA Power, India
Jul 2021 - Sep 2021 · 2 months

Designed and developed a responsive e-learning website using HTML, CSS, and Bootstrap, which increased user engagement by 30% based on usability testing.
Implemented flexible integration for educational institutions, reducing deployment time by 40% through modular backend and frontend design.
Enhanced website performance by optimizing code structure, achieving a 20% reduction in page load time.

Skills

Java Microsoft Excel Python Structured Query Language (SQL) GitHub Power BI R Programming Language (R) Tableau NumPy Pandas Seaborn Matplotlib Scikit-learn MS-SQL Server MySQL Oracle AWS S3 Redshift Appflow Lambda Data Pipeline SageMaker EC2 Snowflake Spark Hadoop Glue Apache Spark HTML CSS Bootstrap
Report this Profile?