About
Data and reporting professional with 14+ years of experience supporting sales and operational decision-making through Excel-based analysis, KPI reporting, dashboards, data validation, trend analysis and management reporting. Strong hands-on experience with Advanced Excel, VLOOKUP/XLOOKUP, INDEX-MATCH, PivotTables, PivotCharts and Power Query, with working knowledge of Power BI and SQL. Experienced in cleaning and reconciling business data, investigating discrepancies, preparing daily, weekly and monthly reports, and translating findings into concise management insights. B.Tech. in Computer Science Engineering.
Skills & Expertise (23)
Work Experience
Sales Support Manager / Data & Analytics Support
Ferrite Metal Solutions Pvt. Ltd.
Feb 2010 - Present
Analyze daily, monthly and quarterly sales data to monitor performance against product-wise and monthly targets and identify deviations and priority areas. Build and maintain Excel reporting dashboards using formulas, VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, PivotTables and PivotCharts. Consolidate data from business systems and Excel sources, perform validation and reconciliation, and investigate inconsistencies before management reporting. Prepare daily sales progress, target-vs-achievement, variance and management reports used by field teams and senior management for performance reviews. Investigate unusual movements and deviations in sales data, trace underlying records and communicate findings to relevant stakeholders. Develop standardized recurring reporting formats to improve consistency, reduce manual effort and support faster review of business performance. Use Power Query for data preparation and transformation and Power BI for dashboarding and business performance visualization. Coordinate with sales, operations and other internal teams to clarify reporting requirements, resolve data issues and support business decisions. Support software implementation and internal testing by validating business reports, data outputs and process requirements. Work with enterprise business systems including Oracle ERP, SAP Ariba supplier-side processes and GeM Portal data.
Education
B.Tech in Computer Science Engineering - Guru Gobind Singh Indraprastha University (GGSIPU) Afghanistan -
2004 - 2011 · India
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Citizen
Relocation
Not Open to Relocation
Skills (23)
Click a skill to find developers with the same skill
