Financial Operations Analyst - Data-Driven Pricing & Reporting

MIHIR ITANKAR

Queens, NY • New York, NY

917-***-**** • ************@*****.*** • linkedin.com/in/mihiritankar-mba Financial Operations Analyst with 3+ years across financial reporting, pricing analysis, and operational performance metrics tracking in fast-paced environments. Built P&L, cash flow, and budget-vs-actuals systems from scratch; ran product-level pricing, margin, and cost analysis to support decision-making across B2B and e- commerce contexts. MBA candidate (Apr 2026, GPA 3.6) with advanced Excel (Pivot, XLOOKUP, VBA), Google Sheets, Power BI, SQL, and Python. Strong analytical judgment, ownership mindset, attention to detail, and clear cross-functional communication across competing deadlines. PROFESSIONAL EXPERIENCE

Marketing Manager & Business Development Lead Roy Export Dec 2022 – Dec 2023 Export trading firm specializing in rotomolding machinery and agricultural produce — Team of 15

• Conducted product-level pricing, margin, and cost analysis across rotomolding equipment and agricultural produce lines, evaluating customer demand, competitor positioning, and shipping/logistics costs to inform pricing decisions.

• Built and maintained Excel-based financial and pipeline tracking systems (customer records, supplier costs, deal stage, margin per deal) for leadership visibility into client engagement and gross-margin performance.

• Led a 15-person cross-functional team across marketing, sales, and outreach; drove daily operations and B2B client acquisition across domestic and international markets.

• Delivered ad hoc pricing and margin analyses for leadership, supporting commercial discussions, negotiations, and post-sale shipping cost reviews.

• Developed standardized reporting templates and SOPs for pricing, sales, and margin workflows to improve accuracy and reduce reporting discrepancies.

Administrative Head Shree Bhavani Organics Pvt. Ltd. Apr 2020 – Sep 2022 Organic products manufacturing — 2.5 years

• Built the company's first Excel-based financial reporting system — P&L tracker, cash flow monitor, and budget-vs-actuals view — replacing manual ledger reviews and accelerating monthly close.

• Tracked operational metrics and financial performance indicators (revenue, COGS, vendor spend, margin trends) for leadership; data analysis surfaced variances that drove cost-reduction and procurement decisions.

• Redesigned core operational workflows — audited existing processes, eliminated redundant approval steps, and consolidated vendor contracts to reduce administrative overhead.

• Coordinated cross-functional stakeholders across finance, operations, and logistics to standardize weekly reporting cadence and improve data accuracy.

Marketing & Sales Associate Vintage Grapes Wine & Spirits Jan 2025 – Apr 2025 Wine & spirits distribution — Part-time during MBA (CPT-authorized)

• Conducted competitive market and pricing analysis across NYC-area wine distributors to identify underserved segments and inform account targeting and pricing strategy.

• Designed an Excel-based CRM and pipeline tracking workflow for lead capture, response cadence, and revenue forecasting — improving response time and pipeline visibility. ANALYTICAL PORTFOLIO PROJECTS

E-Commerce Operations & Margin Dashboard • Power BI, DAX, Star Schema Data Modeling

• Built a 5-page interactive Power BI dashboard with star schema across date, region, and product category; DAX measures tracking orders, returns, revenue, cost, and gross margin — surfacing pricing and margin trends.

• End-to-end financial dashboard design: data modeling, measure definition, visualization — turning operational data into pricing- and margin-relevant insights. Operations KPI & Financial Reporting Tracker • Excel (Pivot Tables, XLOOKUP, SUMIFS, VBA)

• Automated a weekly operations and financial reporting template using XLOOKUP, SUMIFS, conditional formatting, and VBA macros — reducing manual assembly from hours to minutes.

• Designed report views for variance analysis, period-over-period comparisons, and KPI rollups to senior stakeholders.

Process Diagnosis & Statistical Validation • Python (Pandas, SciPy), SPC, Hypothesis Testing

• Analyzed 300 simulated operational observations using SPC (I/MR charts), Cp/Cpk, ANOM, Pareto, and t- tests — translating statistical signal into business recommendations. EDUCATION

MBA, Business Analysis — Monroe University, King Graduate School GPA: 3.6 Expected Apr 2026 Coursework: Statistical Process Control, Financial Analysis, Data Analytics, Operations Management, Risk Assessment BBA, Marketing & Entrepreneurship — Swarnim Startup & Innovation University Jul 2023 TECHNICAL SKILLS

Financial Operations: Financial Reporting (P&L, Cash Flow, Budget vs. Actuals) • Pricing & Margin Analysis • Variance Analysis • KPI Design & Tracking • Cost & Vendor Analysis • Forecasting Analytics & Tools: Advanced Excel (Pivot Tables, XLOOKUP, SUMIFS, VBA, Solver) • Google Sheets • Power BI

(DAX, Data Modeling) • SQL • Python (Pandas, SciPy) • Statistical Analysis (SPC, t-Tests) Business Analysis: Requirements Gathering • Process Flow & Data Flow Diagrams • SOP Design • Stakeholder Management • Microsoft Visio, PowerPoint, Word • Jira • Asana • CRM Systems CERTIFICATIONS & LANGUAGES

Certifications: Microsoft Business Analysis Fundamentals Languages: English (Fluent) • Hindi (Fluent) • Gujarati (Fluent) Work Authorization: Authorized to work in the U.S. on F-1 OPT.

Contact this candidate