Ranpreet Kaur

Senior Software Developer @Charger Logistics Inc.

Brampton, ON, CA

Gathered requirements from the client; Converted business requirements into technical requirements; provided effort estimation of any new change and maintained the requirement document.• Extracting, cleaning and filtering the required data from the raw formations into the warehouse.• Writing Pyspark scripts for the transformation and ingestion loads of warehouse data.• Used AWS, Python, Spark, Pyspark, SQL, Snowflake, Bigdata Hadoop, Hive and APIs to create programs that meet requirements.• Developed and maintained internal job monitoring systems to track the status of drivers, trucks, and trailers using python/pyspark.• Developed console applications to automate the process of monitoring trip status and updating their states based on business requirements.• Created visualizations for different logistics parameters that are scheduled monthly and weekly basis in Tableau and Power BI.• Build, published, scheduled customized interactive dashboards in Tableau. Identify patterns and trends in data sets.• Actively contributing to release planning, code deployments, and sprint planning. Conducted performance tuning and optimization to improve application efficiency and 25% reduction in processing times. Successfully implemented a monitoring system that reduced manual status updates by 50%, significantly improving operational efficiency.

St. Lawrence College (Alpha Campus)

Postgraduate Degree, Project Management

Mohawk College

Post Graduate Certification, Logistics, Materials, and Supply Chain Management

Guru Nanak dev engineering college,Ludhiana

Engineer's Degree, Electronics and communications Engineering