I build AI agents & internal tools that act on data
13
Followers
I build AI agents & internal tools that act on data
Superstore Sales Dashboard — 3-Page Power BI Report
Built an interactive 3-page Power BI dashboard using
the Superstore Sales dataset (9,994 orders across USA).
Page 1 — Sales Overview: KPI cards, monthly trend,
regional breakdown, category performance.
Page 2 — Product Performance: Top products, category
donut, profit analysis, sales vs profit scatter.
Page 3 — Customer & Shipping: Segment breakdown,
top 10 customers, monthly growth, ship mode distribution.
Tools: Power BI, DAX, Superstore Dataset
Theme: Dark professional with interactive year filter.
0
221
I specialize in data cleaning and preprocessing, ensuring your spreadsheets or databases are accurate, well-formatted, and ready for analysis or reporting.
What Ill do for you:
Remove duplicates, nulls, and inconsistencies
Standardize date, text, and numeric formats
Fix spelling/case issues
Split/merge columns (e.g., names, addresses)
Convert file formats (CSV Excel SQL)
Python or SQL-based advanced cleaning (if required)
Supported formats: Excel, CSV, Google Sheets, SQL dumps
Clean, fast & confidential service
100% satisfaction guaranteed
Message me before ordering so I can understand your dataset and goals!
0
631
Data Analytics Project – Subscription Model Analysis (SQL & Power BI)
Analyzed a subscription-based business model for Foodie-Fi (TastyStream), a digital platform offering on-demand global cuisine content. The objective was to understand customer journeys, subscription transitions, and revenue performance using SQL and Power BI.
Key Contributions & Insights:
Segmented customers based on trial-to-paid and plan transitions.
Analyzed free trial behavior and conversion patterns.
Evaluated revenue performance across subscription plans.
Built interactive dashboards in Power BI for actionable insights.
Tools Used:
MYSQL, Power BI
Outcome:
Delivered a clear, insight-driven dashboard supporting data-driven decisions in a subscription-based business.
Procurement | Strategic Sourcing & Vendor Management | SAP
New to Contra
Procurement | Strategic Sourcing & Vendor Management | SAP
My Freelancing Experience for a USA Based Handmade Products Business
📦 India Operations | 📊 Inventory | 🚚 Shipping | 🛍️ E-commerce | 📧 Marketing
I currently support a US-based handmade products business with manufacturing operations in India, managing the connection between India-side operations and customers/orders in the US.
🔧 What I Manage
📦 Order Management
Manage and track customer orders from the US.
Coordinate order processing and fulfilment with the India team.
Ensure orders are processed accurately and on time.
📊 Inventory Management
Monitor inventory levels and product availability.
Coordinate stock requirements with the manufacturing team.
Maintain visibility of products across sales channels.
🚚 Shipping & Logistics
Coordinate shipments from India to the US.
Track shipments and provide updates on order status.
Help ensure products reach customers within expected timelines.
🛍️ Faire Wholesale Management
Manage the brand's Faire wholesale platform.
Monitor incoming wholesale orders.
Coordinate order processing, fulfilment, and shipping requirements.
📧 Email Marketing
Create and manage email marketing campaigns.
Develop customer re-engagement and abandoned-cart campaigns.
Support customer retention and repeat purchases.
🔍 Market Research
Research market and customer trends.
Identify potential product and business opportunities.
Support decisions around products, customers, and marketing.
🎯 Core Areas
Order Management · Inventory · Logistics · Faire · E-commerce Operations · Email Marketing · Market Research · Customer Retention
💻 Skills & Tools
Faire · E-commerce Operations · Email Marketing · Market Research · Inventory Tracking · Order Management · Shipping Coordination · Customer Communication
🚀 Impact
I act as an operations and e-commerce support partner, helping coordinate the journey from manufacturing in India → inventory → order processing → shipping → US customers, while also supporting the brand's wholesale and marketing activities.
1
260
End-to-End Procurement & Strategic Sourcing
I managed end-to-end procurement activities across data centre and LNG operations, supporting supplier identification, RFQs, quotation analysis, negotiations, vendor selection, order processing, expediting, and payment coordination.
What I Delivered:
1. Identified and evaluated suppliers based on commercial, technical, and compliance requirements.
2. Prepared and managed RFQs and tendering activities.
3. Analyzed vendor quotations and prepared comparative statements.
4. Supported supplier negotiations and vendor finalization.
5. Coordinated vendor onboarding and compliance documentation through SAP Ariba.
6. Managed procurement trackers and maintained accurate procurement records.
7. Coordinated with Operations, Finance, Legal, Compliance, and external stakeholders.
8. Ensured procurement activities followed internal policies and governance requirements.
Tools & Skills
Strategic Sourcing · RFQ Management · Vendor Management · Negotiation · Tendering · Quotation Analysis · SAP Ariba · SAP MM · Procurement Operations · Cost Control
1
329
📋 Vendor Onboarding & Due Diligence Kit
🚀 Simplify your supplier onboarding and vendor evaluation process with this professional Excel-based solution! This all-in-one toolkit is designed for procurement teams, sourcing professionals, supply chain managers, and businesses looking to standardize vendor qualification while reducing compliance and operational risks.
The template includes a 📄 Vendor Onboarding Form to capture complete supplier information, a ✅ Supplier Due Diligence Checklist with dropdown status tracking for document verification, and a 📊 Vendor Risk Assessment Scorecard that automatically calculates weighted risk scores and provides an overall vendor risk rating.
✨ Key Features
🏢 Professional Vendor Information Form
📑 Comprehensive Due Diligence Checklist
✅ Dropdown-Based Status Tracking
📂 Document & Compliance Verification
⚖️ Automated Weighted Risk Assessment
📈 Auto-Calculated Vendor Risk Score
🎯 Standardized Supplier Evaluation Process
📝 Fully Editable & Easy to Customize
💼 Corporate-Style Design
⚡ No Macros Required – Simple Excel Formulas
🎯 Perfect For
✔ Procurement Teams
✔ Supply Chain Professionals
✔ Vendor Management Offices
✔ Manufacturing Companies
✔ EPC & Construction Firms
✔ Startups & SMEs
✔ Consultants & Procurement Freelancers
Whether you're onboarding a new supplier or conducting periodic vendor reviews, this template helps you maintain consistency, improve compliance, minimize supplier risks, and make smarter procurement decisions—all within a clean, professional, and easy-to-use Excel workbook. 📊✨
1
201
Hi, I’m Ameya 👋
I’m a Procurement & Operations professional who combines procurement expertise, data analytics, and technology to help businesses work smarter.
I specialize in strategic sourcing, vendor management, procurement operations, SAP MM, process improvement, data analysis, and reporting.
I enjoy turning complex processes into simple, efficient, and data-driven workflows — whether it’s improving procurement processes, building reports, managing vendors, or automating repetitive tasks.
🚀 Open to freelance, remote, and project-based opportunities.
Let’s build something efficient together.
Data Specialist for Clean, Organized & Smart Reports
Data Specialist for Clean, Organized & Smart Reports
📊 Sales Tracking Dashboard | Excel + Power BI Project
Built an end-to-end interactive Sales Tracking Dashboard covering 2021–2024 across the entire US market.
Top-Line Numbers:
💰 Total Sales: $19,28,888
📈 Total Profit: $2,47,962
👥 Total Customers: 8,314 across all years
What the dashboard reveals:
🏆 Best-selling sub-categories: Phones ($2,79,464) and Chairs ($2,77,058) lead the pack — together accounting for nearly 29% of all sales
📅 Profit growth year-on-year:
→ 2021: $49,556 → 2022: $61,618 → 2023: $81,786 — consistent upward trajectory across Furniture, Office Supplies & Technology
🗺️ Geographic concentration: California dominates at $3,90,145 in sales. New York ($2,46,517) and Texas ($1,51,436) follow. West Virginia sits at the bottom with just $536 — a clear signal for regional strategy review.
📦 Technology drives profit — highest-margin category across all 4 years, despite Furniture holding significant volume
🧾 Seasonal trends: Q4 is king — November ($2,34,013) and December ($2,41,464) are the strongest months. February dips to just $59,640 — opportunity for targeted campaigns.
👤 Top customer by profit: Tamara Chand at $8,981, followed by Raymond Buch ($6,939) and Sanjit Chand ($5,757)
Tools used: Microsoft Excel · Pivot Tables · Power Query · Charts & Slicers · Dashboard Design
This project sharpened my ability to turn raw transactional data into a clean, decision-ready visual — with filters for state, date, year, sub-category, and month.
Open to feedback! 👇
#Excel #DataAnalytics #SalesDashboard #DataVisualization #BusinessIntelligence #MicrosoftExcel #DashboardDesign
0
40
🏦 Bank Loan Portfolio Analysis | Power BI Dashboard Project
Analyzed 38,576 loan records across 50 states to give a bank's lending division a unified view of portfolio health — something they simply didn't have before.
What the data revealed:
✅ Net-positive portfolio: $435.8M disbursed, $473.1M recovered
⚠️ 13.8% bad loan rate = $28.25M net capital loss
📊 Debt consolidation drives nearly half of all loan applications
⏳ 73% of borrowers chose 60-month terms over 36-month
📍 60%+ of repayments concentrated in just 5 states (CA, NY, FL, TX, NJ)
Tools used: PostgreSQL → Excel → Power Query → Power BI + DAX
Built two interactive dashboards:
→ Summary: KPI cards, good vs. bad loan segmentation, loan status grid
→ Overview: Trends, geographic maps, term/purpose/employment breakdowns
The next phase? Building a predictive risk scoring layer using DTI, interest rate, and employment length to flag at-risk loans before they default.
Open to feedback from data folks in the community 👇
#PowerBI #DataAnalytics #SQL #DAX #BankingAnalytics #PortfolioAnalysis #DataVisualization
0
51
Every hospital generates thousands of data points daily but without the right lens, it's just noise.
Built this Healthcare Analytics Dashboard to turn patient records into decisions. From tracking $1.4B in revenue across admission types to spotting a consistent dip in monthly billing trends the numbers tell a story most teams never get to read.
The insight that stood out? Diabetes and Obesity quietly lead revenue by medical condition which says a lot about where healthcare demand is heading.
This is what data visualization is actually for not prettier reports, but faster, clearer thinking.
Tools: Power BI · DAX · PostgreSQL · Power Query
0
84
I Built a two-page Power BI dashboard on 190K+ FMCG transactions — tracking revenue, SKU performance, promotional impact, and delivery across 3 channels and 3 regions. Uncovered a balanced 33% revenue split across all channels and identified the top 3 revenue-driving SKUs for smarter inventory decisions.
Tools: Power BI · DAX · Excel
Hi There!!
Visual for content writing.
created a content strategy and social media planning system for a fictional small business to demonstrate my content creation skills.
The project includes a 7-day content calendar, engaging post ideas, ready-to-use sample captions, clear calls to action, and a content performance tracker.
It also outlines content pillars, brand voice, target audience, and engagement strategies to help businesses plan consistent, audience-focused content and organize their social media marketing effectively.
All performance figures are sample data and created for skill demonstration purposes only.