Abhay Pal Email & Phone Number

Gurugram, Haryana, India

India

🤝 Collaborate with me to harness the potential of your data and elevate your business through insightful, customized data visualization solutions. Together, let's chart the course for your success!

Bengaluru, Karnataka, India

• Designed and maintained 40+ dashboards and reports using G-sheets app scripts to regularly analyze site productivity.• Collaborated with cross-functional teams and stakeholders to create automated reports, ensuring 99% accuracy and on-time delivery.• Collected, processed, cleansed, and prepared data using Python, SQL, and Excel to redefine and track KPIs.• Used well-maintained dashboards and reports to inform decision-making.• Collaborated effectively with cross-functional teams, ensuring accurate and timely data delivery for strategic decision-making, contributing to organizational success.Project: Route Optimization• Objective: Optimize map routes using Python libraries.• Parameters: Analyze traffic, distance, and time.• Solution: Suggest the most efficient route for a given destination.• Python Libraries: Utilize Pandas, NumPy, Scikit-learn, ortools, and others.• Key Benefit: Process large data efficiently, offering practical route optimization, enhancing efficiency, and reducing costs.Project: WhatsApp Snap Automation• Created a Python script for WhatsApp automation.• Sends hourly image updates to a WhatsApp group.• Utilizes WhatsApp API for real-time achievements tracking.• Script designed for continuous operation.• Showcases proficiency in Python programming, API integration, and automation.

Bangalore Urban, Karnataka, India

-Improving the key metrics by making daily, and weekly reports by tracking target vs achievement% and escalating it to multiple teams to ensure 100% achievement-Collecting and validating the data to administer the root cause to drive business growth.-Troubleshooting problems or issues and providing support to the team-Providing validated data to the client and improving the metrics for them, hence identifying the root cause of the hindrance and solving it thereof-Aligning projects for heading the problem-solving actionable-Automating the regular reports by running python scripts along with coordinating with different teams -Using Excel on a daily basis for efficient data cleaning and uploading it on Jupyter hub for further analysis-Improving the key metrics by making daily, weekly.

Ghaziabad, Uttar Pradesh, India

• Tracked and assessed sales and purchase finances regularly, providing insights to leadership.• Managed daily updates of 200 inventory stocks via Magento and ERP admin.• Saved 28 hours per week by automating pricing and sales reports using Python scripts.• Documented and organized recruitment data in Excel and Google Sheets.• Processed data following SOPs and applied data analysis techniques for insights.• Conducted daily data reviews, identifying and rectifying anomalies.• Compiled, clean and sorted data, creating informative G-sheet dashboards.Project: WEBSITE DEVELOPMENT:-• Developed a user-friendly website (https://pricelist.partsbigboss.in/) for a one-stop shop offering quality aftermarket car spare parts from various brands and categories.• Use HTML, CSS, Python, and JavaScript to design and build the website, ensuring a seamless user experience.• Created an online platform that simplifies the search and purchase of car spare parts, enhancing accessibility and convenience for customers.

Master Of Computer Applications - Mca, Mca

Activities and Societies: Data analyst

Bca