Shamim Ahamad

• Dashboard Development: Engineered a Service Level Target (SLT) Dashboard using Excel, formulas, and charts to track Risk Assessment requests, accelerating team bottleneck identification.
• Strategic Insights: Developed a high-impact Commercial Dashboard providing executive leadership with deep insights into the financial health of the business to drive critical decision-making.
• Vendor Performance: Created a comparative analysis dashboard mapping third-party vendor performance, successfully identifying and presenting process obstacles to upper management.
• Risk & Tax Compliance: Partnered with the KY3P Third-Party Risk Management team and Tax Utility team to validate, remediate, and report on client Tax and CRS forms, ensuring strict regulatory compliance.
• Ad-Hoc Reporting: Developed and implemented data extraction processes across multiple internal systems to deliver ad-hoc reports tailored to management requirements.

• Data Transformation: Utilized Power Query and MS Excel to transform complex, raw stakeholder data into structured performance metrics.
• KPI & Analytics: Managed campaign traffic and quality checks on Google Ad Manager (GAM) 360; built KPI reporting models using DCM and Google Analytics to optimize website clicks and acquisitions.
• Stakeholder Relations: Consulted directly with internal stakeholders to gather business requirements, plan project milestones, and communicate project KPIs clearly and timely.
• Quality Assurance: Implemented rigorous data quality checks before publishing final reports to clients, maintaining zero-error data integrity.
• Process Optimization: Upgraded legacy Excel reports and introduced custom automated templates, significantly reducing manual data processing times.