shahir basha shaik

• Designed and maintained dynamic dashboards in Power BI and Tableau to monitor project delivery performance for capital, minor works, and strategic programmes.
• Spearheaded development of 15+ interactive Power BI dashboards, consolidating data from SAP, Excel, and IoT sensors, reducing manual reporting time by 35% and enabling real-time decision-making for operations teams.
• Engineered SQL queries to automate data extraction and cleaning, improving data accuracy by 25% and streamlining monthly reporting for senior leadership.
• Collaborated with Facilities Management to analyze maintenance workflows, identifying inefficiencies that led to a 20% reduction in downtime through predictive analytics.
• Translated stakeholder requirements into scalable data models, enhancing cross-departmental alignment on key performance metrics.
• Worked with senior Estates and Operations stakeholders to define performance KPIs, ensuring reports aligned with strategic and operational goals.
• Automated manual reporting processes, improving data refresh frequency and reducing report turnaround time by 50%.
• Developed and enforced data validation protocols, enhancing data accuracy and integrity across multiple source systems.
• Created real-time reporting from Planon IWMS, identifying trends, gaps, and forecasting risks across maintenance and construction projects.
• Collaborated with cross-functional teams (strategy, IT, operations) to integrate client data from CRM (Salesforce), ERP (SAP), and third-party APIs into centralized analytics platforms, ensuring data accuracy and accessibility.
• Mentored junior analysts in data cleaning, visualization best practices, and client communication, improving team project delivery speed by 15%.

Data Analysis & Insights

• Analyzed customer behavior, sales trends, and website performance data using SQL and Python (Pandas, NumPy), identifying patterns that drove a 15% increase in conversion rates through targeted marketing campaign adjustments.
• Conducted A/B testing on product page layouts and promotional strategies, providing insights that improved add-to-cart rates by 12% and reduced bounce rates by 8%.
• Performed cohort analysis to evaluate customer retention and lifetime value (CLV), enabling the marketing team to refine segmentation strategies and reduce customer acquisition costs (CAC) by 10%.

Reporting & Visualization

• Developed automated Tableau dashboards to monitor KPIs such as daily sales, inventory turnover, and customer demographics, reducing manual reporting time by 30% and enabling real-time decision-making for stakeholders.
• Created visual reports for cross-functional teams (Marketing, Product, Supply Chain), translating complex data into actionable insights to optimize pricing strategies and inventory management.
• Tracked and visualized funnel metrics (traffic-to-purchase) to identify drop-off points, leading to a 20% improvement in checkout completion rates through UX/UI adjustments.

Data Management & Integration

• Cleaned and validated transactional data from Shopify/Magento, ERP systems, and Google Analytics, improving dataset accuracy by 25% for monthly sales forecasting.
• Collaborated with IT teams to integrate third-party APIs (e.g., payment gateways, CRM tools) into centralized databases, ensuring seamless data flow for analytics.
• Assisted in building a customer segmentation model using clustering techniques (k-means), enhancing personalized email campaign performance by 18%.

Cross-Functional Collaboration

• Partnered with the marketing team to evaluate ROI of digital ad spend (Google Ads, Meta), reallocating budgets to high-performing channels and boosting ROAS by 22%.
• Supported inventory planners by analyzing seasonal demand trends, reducing overstock waste by 15% through predictive inventory modeling.