Simran Nagpurkar Email & Phone Number

Westford, Massachusetts, United States

• Diagnosed and resolved data pipeline issues by debugging ETL processes, reducing data latency from 24 hours to 2 hours and ensuring up-to-date job listings for clients• Developed and implemented real-time dashboards using Tableau, increasing visibility into recruitment metrics by 40% and enabling faster, data-driven decision-making for the talent acquisition team• Automated job description conversion and optimization using advanced SQL queries and machine learning algorithms, resulting in a 30% boost in job visibility on Google for Jobs.• Conducted A/B tests on job postings to identify the most effective formats and keywords, leading to a 25% increase in the number of qualified candidates applying for top roles• Deployed Python libraries (Pandas, NumPy, Seaborn, SciPy, Matplotlib, Scikit-learn) to develop 8 machine learning algorithms, including linear regression, Naive Bayes, Random Forests, K-means, and KNN, enhancing data analysis capabilities and predictive accuracy for recruitment trends.• Created and delivered weekly reports and presentations on key performance indicators (KPIs) to seniormanagement, providing actionable insights that supported strategic decisions and reduced hiring costs by 15%

Boston, Massachusetts, United States

• Managed 30+ applications daily with Excel, achieving a 15% efficiency boost, quantified by an equivalent of 200 saved work hours• Implemented Salesforce CRM strategies, resolving 20+ daily queries, fostering a remarkable 20% improvement in data precision• Orchestrated a remarkable 95% surge in customer satisfaction rate by adeptly managing Salesforce cases, processing applications, and providing valuable assistance to applicants, ensuring a seamless application processing experience

Mumbai, Maharashtra, India

• Optimized supply chain operations by analyzing ER diagram, data modeling, and data warehouse design for freight data across 20+ routes, achieving a 15% reduction in transportation costs and a 10% increase in freight capacity utilization• Engineered ETL pipelines on AWS Redshift to automate freight and supply chain data ingestion, resulting in a 25% faster data processing and a 20% improvement in data accuracy.• Troubleshot real-time data discrepancies in asset management systems, enhancing data retrieval efficiency by 40% and ensuring uninterrupted train scheduling• Implemented predictive maintenance models using historical data analysis and machine learning, reducing unscheduled locomotive maintenance incidents by 18% and enhancing fleet efficiency• Identified KPIs, and leveraged reporting tools like Tableau to enable responsive dashboard, drill down reports for performance analysis in logistics and freight movement optimization saving 14 hrs of manual reporting per week• Engineered and implemented a new business layer, developed ETL pipelines for processing freight and logistics data from various regional depots, serving 10,000 daily freight operations, resulting in a yearly savings of $20,000 in external vendor expenses• Leveraged data integration using Alteryx to streamline data collection between Production and Disaster Recovery (DR) sites, improving supply chain efficiency for Indian Railways and saving 2 hours per day• Collaborated with cross-functional teams and business stakeholders to understand and translate supply chain requirements into technical designs using Agile methodologies, enhancing the efficiency and agility of Indian Railways' operations

South Mumbai, Maharashtra, India

• Engineered and managed databases for Indian Railways' internal department, overseeing data consistency and availability, resulting in a 15% increase in data availability• Developed SQL to create tables, stored procedures, triggers, UDFs, and SQL queries, improving database performance by 20%• Implemented data modeling techniques, including STAR Schema, SCD Type 2, and normalization, to optimize database performance, resulting in a 30% improvement in query performance• Extracted data from sources such as API’s, and cloud data warehouse, reducing data retrieval time by 25%• Resolved data issues by providing timely support to clients, resulting in a 20% decrease in operational disruptions

Master'S Degree, Information Systems, 3.63/4

Relevant Coursework: Application Engineering Development Database Management and Database Design Designing Advance Database Architecture.

Bachelor'S Degree, Computer Engineering

Main Courses: Database Management System | Data Warehouse and Mining | Distributed Database | Data Structure