Syed U.

Data Analyst | Business Intelligence & Excel Dashboard Developer

Micro Image Technologies • Freelance

Jul 2025 - Aug 2025 • 1 mo

Worked with Micro Image Technologies, a medical technology company, to design and develop an automated Excel-based Sales Performance & Forecasting Dashboard for executive reporting and territory management. The project involved transforming fragmented sales records (2019-2025) into a structured reporting model capable of generating interactive dashboards for six regional sales representatives and a company-wide executive overview. Led the complete data preparation process by auditing data quality, identifying inconsistencies, cleaning and standardizing datasets, restructuring multiple yearly worksheets into a consolidated master database, and designing a scalable reporting framework suitable for monthly updates. Standardized sales representative names, specialties, products, procedures, hospitals, and operational fields to improve reporting accuracy and maintain data integrity. Developed dynamic PivotTables, Pivot Charts, slicer-driven dashboards, helper calculations, lookup tables, validation lists, and automated Excel templates to monitor sales performance, quota achievement, forecasting, pipeline management, and operational activities. Built executive reports covering: • Quota per Product • Percent to Plan per Product • Sales Pipeline Analysis • Portfolio Coverage • Product Performance • Sales Forecasting • Upcoming Demonstrations • Closed Deals Pending Shipment • Installation Schedule • Systems Ready for Installation • Target Account Management • Consolidated Company Overview • Individual Sales Representative Performance Collaborated directly with senior management to redesign the reporting structure, identify missing business variables, recommend improvements to the data model, define KPI calculations, and create a scalable Excel reporting system that could easily accommodate future products, territories, and reporting periods. Core Skills & Technologies: Microsoft Excel, Advanced Excel, Pivot Tables, Pivot Charts, Interactive Dashboards.

Data Analyst | Employee Survey Analytics & Executive Reporting

Symphony Energy • Freelance

Aug 2023 - Sep 2023 • 1 mo

Partnered with Symphony Energy to analyze and transform a large-scale organizational employee survey into executive-ready business intelligence reports, enabling leadership to better understand workforce sentiment, strategic alignment, organizational performance, and employee engagement across multiple business units and global regions. Managed the complete survey analytics workflow, including data cleaning, validation, quantitative analysis, qualitative response coding, demographic segmentation, cross-tabulation, statistical summaries, KPI development, and executive reporting. Converted raw survey responses into structured analytical datasets that supported evidence-based decision making for senior leadership. Designed an automated Excel reporting model and interactive dashboards to analyze employee engagement, leadership effectiveness, strategic understanding, organizational communication, regional performance, divisional trends, manager effectiveness, professional development, employee well-being, training priorities, product knowledge, workplace connectivity, and engagement initiatives. Performed comparative analysis across regions, departments, management levels, and demographic groups to identify key organizational trends and improvement opportunities. Developed executive PowerPoint reports that combined statistical findings, business storytelling, data visualization, charts, graphs, cross-tab analysis, qualitative theme analysis, and actionable recommendations. Produced clear management insights highlighting organizational strengths, improvement opportunities, employee expectations, communication effectiveness, workforce engagement, strategic alignment, leadership transparency, and organizational culture. Collaborated closely with stakeholders to interpret survey findings, identify business challenges, prioritize improvement initiatives, and deliver data-driven recommendations.