Umaima Mahmood

-Developed and optimized interactive Power BI dashboards using DAX and Power Query, driving a 19% revenue increase by enabling alliance marketers to track KPIs, perform statistical trend analysis, and identify margin optimization opportunities (2022-2024). -Created a dedicated email marketing dashboard in Power BI, leveraging data modeling and Power Query transformations to improve campaign efficiency by 12% by visualizing optimal send times to maximize open rates. -Improved data quality by 50% through targeted data cleansing initiatives and ETL processes, enhancing the accuracy and reliability of critical Power BI reports and empowering stakeholders with actionable insights aligned with business requirements. -Designed and implemented a comprehensive BI dashboard in Power BI, utilizing DAX for advanced calculations, resulting in a 7% increase in reporting accuracy and operational efficiency through streamlined data visualization. -Collaborated with email marketers to build data-driven Power BI reports, conducting ad-hoc statistical analyses to identify engagement trends and optimize targeting, achieving a 10% boost in conversions from unengaged to engaged subscribers. -Enhanced campaign performance by 30% by delivering product-centric research visualized through Power BI dashboards, leveraging data modeling to provide targeted insights that drove significant increases in form fills. -Developed and troubleshot SSIS packages to support ETL processes for seamless data integration, while designing new SSIS packages and writing SQL queries to validate data accuracy and ensure successful incorporation into BI systems.

-Collected, analyzed, and interpreted data from marketing campaigns, customer interactions, and website analytics using SQL and Power BI, delivering actionable insights to optimize marketing strategies. -Developed data visualizations and reports in Power BI, leveraging DAX and Power Query to communicate KPIs and trends to stakeholders, improving decision-making efficiency by 10%. -Provided data-driven insights to support marketing strategy, identifying opportunities for campaign optimization and increasing engagement rates through statistical trend analysis. -Collaborated with cross-functional teams, including marketing and IT, to identify trends, opportunities, and areas for improvement, enhancing campaign performance by 15%. -Acted as a liaison between marketing and IT departments, ensuring data accuracy and integrity through ETL processes and data quality checks, streamlining data workflows. -Managed data queries using SQL for marketing and partner management teams, integrating datasets from third-party vendors into internal systems and uploading to marketing automation tools, improving data accessibility by 20%. -Supported marketing-related data projects, including data modeling and ad-hoc analyses, to drive strategic initiatives and optimize targeting for stakeholder requirements. -Facilitated open communication between marketing and other departments, aligning data initiatives with business goals and ensuring seamless project execution.