Ranvir Singh Email & Phone Number

• Enhanced order process efficiency by 15% by identifying bottlenecks using operations data and creating product configurators on the CPQ platform, streamlining the workflow and reducing processing time.
• Optimized configurator design for 4 product models by performing detailed testing and ensuring error-free builds, significantly enhancing customer satisfaction and product reliability.
• Delivered actionable insights by analyzing and organizing engineering data from ERP EPICOR and PLM PULSE using advanced Excel techniques, leading to the development of workflows that increased efficiency by 10%.
• Boosted revenue by $20,000 by collaborating with the finance team to analyze and revise manufacturing quotes for finished products, ensuring accurate pricing.

• Managed and organized data for 200 students prior to exams, ensuring accurate records and successful test preparation, thereby supporting course instructors effectively.
• Ensured academic integrity by monitoring 15 exam rooms, preventing potential cheating incidents and maintaining a secure testing environment.

• Enhanced data transformation efficiency by 15% by developing a No-Code ETL pipeline using AWS Glue to extract 215k records of insurance policies from an S3 bucket, optimizing the data for analysis.
• Streamlined data querying and modeling by 33% with targeted data integration into AWS Athena and Power BI, ensuring error-free and faster insights.
• Boosted data-driven decision-making by 20% with interactive Power BI dashboards, demonstrating claim settlement and customer acquisition measures with the potential to increase net promoter score by 7%.

• Led 3 social development events, raising $60k and collaborating with a 15-member team.
• Enhanced management, communication, and strategic thinking skills through successful fundraising and teamwork.

• Integrated diverse data tables using SQL and analyzed buying patterns of 9.5k superstore customers using Python, identifying key enhancement areas that resulted in a 13% reduction in customer churn.
• Redesigned discount strategy on premium products, resulting in a 6% increase in profit margins and up to a 27% boost in sales among low-selling products.
• Recommended adjusting shipping rates by 10% according to specific regions, leading to an estimated 19% increase in sales of bulky goods.

Master'S Degree, Big Data Analytics, 92.89%

Bachelor Of Technology - Btech, Computer Science