manas joshi

Pricing Analyst II

NorthEast Electrical (NED)•  May 2024 - February 2025•  Portsmouth, New Hampshire

Created Commodity Pricing Dashboard by compiling customer bid data using Power BI and Snowflake enhancing pricing strategies and resulting in a 15% increase in bid success and cost reduction by 10% by analyzing and optimizing COGS & Comm cost, Net Margin, and Replacement Cost. Collaborated cross functionally with Marketing, Purchasing, Finance, and Sales teams to support execution of pricing strategies, including managing price files, executing price changes and promotions, ensuring pricing integrity and driving 10% increase in revenue and profitability. Conducted detailed statistical analysis of price files from 30 vendors, identifying the lowest price for each SKU to optimize rebate structures. Leveraged data-insights to negotiate with vendors, securing cost reductions that enhanced profitability and delivered $70K in savings. Engineered a comprehensive customer segmentation framework, categorizing them into 5 tiers (tiny, low, medium, high, and large) and further segmenting by industrial, commercial, and residential sectors, resulting in more targeted pricing strategies and improved revenue optimization. Designed and implemented a targeted Price Elasticity Model for SKU promotions, elevating decision quality. Empowered stakeholders to harness quantitative insights, resulting in a 30% boost in profit-driven promotional choices, strategically benefiting both B2C and B2B segments.

Pricing Analyst Intern

General Electric (GE)•  June 2023 - December 2023

Promotional and Pricing analysis on electrical appliances. Harnessed cross-team collaboration for pricing trend analysis, driving a 12% increase in product margin optimization. Formulated pricing strategy with Technology, Marketing, Sales, Finance teams, and Pricing Directors leading to an impactful 20% boost in gross profit. Migrated and automated data extraction and integration process from MS Excel to Tableau leveraging Vertica database for data management to reduce manual efforts by 80% and accomplished 100% task automation through effective time management and resource allocation skills. Incorporated A/B testing into competitive and promotional pricing models, leading to a strategic implementation of revenue-maximization strategies resulting in 10% increase in revenue and significantly enhancing promotional efficiencies and strengthening market position. Performed customer-wise and brand-wise comparisons of Discounts and incremental Net Sales Margin (NSM) utilizing Pivot tables, XLOOKUP, VBA, and Power Query delivering 15% sharper pricing decisions and amplified profitability for the company.

Data Analyst

TATA Consultancy Services•  June 2021 - July 2022

Conducted Ad hoc data analysis and developed parallel algorithms for HPC systems to optimize performance by using Python, T-SQL, and Power BI, resulting in data-driven solutions to research questions demonstrating effective project coordination and resource management. Improved business performance by 20% through the development and maintenance of Power BI and T-SQL reports, dashboards, and key performance indicators (KPIs) such as Scalability, Speedup, and Memory-usage demonstrating effective planning and timely execution.