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 7 months

<p>Modernized scalable backend payment systems using Python, processing 180 transactions per second for web and mobile applications.<br>
Designed and optimized payment solutions for Global Payments, Customer Disbursements, and Fraud Detection, improving transaction efficiency by 20%.<br>
Automated refund and payout workflows with a Python-based disbursement tool, achieving a 98% reduction in duplicate refunds.<br>
Implemented Kafka and RabbitMQ message queues in Python, processing 270 data streams per second to ensure high availability and system reliability.<br>
Streamlined referral credit management systems, eliminating manual processes entirely and reducing errors.<br>
Led Root Cause Analysis for 70+ customer issues, enhancing response times and improving resolution efficiency.<br>
Mentored two junior engineers, fostering skill development and increasing team productivity.<br>
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.</p>

Data Analyst Intern

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

<p>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.<br>
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.<br>
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.<br>
Achieved 95%+ data accuracy in identifying trends or potential performance issues within healthcare operational reports, enabling improvements in patient care processes.<br>
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.<br>
Ensured 100% compliance with healthcare regulatory standards during patient data reviews and audits, safeguarding patient confidentiality and adhering to HIPAA regulations.</p>

Web Developer Intern

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

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

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?