Ashutosh Dubey

Data Analyst | MIS Reporting | Power BI | SQL | E-Commerce Analytics

Talent

NoidaMember since June 23, 2026

PostgreSQLMySQLJoinsSubqueriesWindow FunctionsPower BIDAXPower QueryVLOOKUPHLOOKUPPivot TablesMacrosMIS ReportingData CleaningSKU MappingMAP ComplianceAWS Data EngineeringChatGPTGemini

Hire this person

Send a job offer directly to this candidate

PostgreSQLMySQLJoinsSubqueriesWindow Functions

About

Turning raw data into business decisions -- Data Analyst with 1+ year of hands-on experience delivering end-to-end data solutions in a fast-paced e-commerce environment. Expert in SQL (Joins, Subqueries, Window Functions, PostgreSQL), Power BI (DAX, Power Query), and Advanced Excel (Pivot Tables, VLOOKUP, Macros). Proven track record of building KPI dashboards, automating MIS reports, and ensuring 97.67% MAP compliance across 43,000+ SKUs for US retail brands on Amazon, Wayfair, and Home Depot.

Skilled at transforming large datasets (40,000+ rows) into clean, actionable insights for client stakeholders. Currently upskilling in AWS Data Engineering (S3, EC2).

Seeking Data

Analyst, MIS Executive, or E-Commerce Analytics roles.

Experience

Data Analyst at Masthead Technologies Pvt. Ltd. (2025-04 – Present)

E-commerce data analytics firm delivering MAP compliance, performance reporting, and content solutions for US retail brands.

Monitored MAP (Minimum Advertised Price) compliance for 43,000+ active SKUs across Amazon, Wayfair, Lowes, Home Depot, and Bed Bath & Beyond; tracked real-time pricing violations, conducted root cause analysis, and delivered weekly Excel MIS compliance reports achieving a 97.67% compliance rate for brand protection teams.
Built and maintained Power BI dashboards with custom DAX measures to visualize SKU-level MAP compliance trends, seller pricing violations, and product ranking performance, enabling data-driven decisions for US retail client stakeholders.
Completed end-to-end SKU mapping and product URL verification for 6 client accounts using SQL (Joins, Subqueries, Window Functions) and Excel VLOOKUP/HLOOKUP; resolved data discrepancies, identified missing SKUs, and ensured 100% accuracy in all client-facing reports.
Designed and maintained daily and weekly structured MIS reports and Excel dashboards tracking active products, out-of-stock SKUs, MAP violation counts, and compliance KPIs using Pivot Tables, Power Query, and advanced data filtering techniques.
Executed daily SKU Auto Pull setup and bulk product file imports across 6 client accounts via mySamm Content Management portal; automated repetitive MIS reporting workflows using Excel Macros and Power Query, reducing manual effort by 35%.
Carried out data cleaning, deduplication, and validation on large e-commerce product datasets (40,000+ rows) using Advanced Excel and SQL, ensuring zero errors in all client-facing compliance and content reports.
Leveraged AI tools (ChatGPT, Gemini) to write optimized SQL queries, automate Excel formula generation, streamline data cleaning workflows, and draft client-ready MIS report summaries, cutting report preparation time by 40%.