Ikra Bagwan Email & Phone Number

United States

United States

• Collaborate with teams to understand business and technology needs, streamlining data collection processes.
• Perform data manipulation, cleansing, and exploratory/statistical analysis using SQL, R, and SAS to support business decisions.
• Utilize a data-driven approach to evaluate campaign performance, developing and tracking KPI metrics to optimize future campaign strategies.
• Developed dashboards using MicroStrategy to provide cross-departmental insights, enabling more efficient tracking of campaign outcomes and optimizing marketing spend.

• Architected a cloud-native data platform using Azure Synapse Analytics and dbt that processed 3TB of daily data across 15 source systems, reducing data processing time from 6 hours to 30 minutes while maintaining.
• Developed an ML-powered demand forecasting system utilizing Python and Azure AutoML, analyzing 2 years of historical data across 500 products, achieving 91% accuracy (MAPE) and leading to a $2.1M reduction in inventory.
• Built interactive Power BI dashboards with row-level security and DirectQuery mode, serving 200+ users across 8 departments and reducing ad-hoc report requests by 75% with sub-5-second refresh times.
• Led the implementation of a data quality framework using Airflow, monitoring 100+ data quality metrics across 50 critical tables, decreasing data incidents by 60%.
• Designed and refined the ETL process with Informatica to integrate data into Snowflake and CRM, optimizing workflows and implementing error-handling mechanisms.
• Optimized critical financial analysis using Python (pandas, scipy) and SQL window functions to process 2M+ monthly transactions, identifying revenue leakage patterns in billing data.

• Utilized Python, SQL, and R for comprehensive data wrangling, preprocessing, analysis, and visualization, ensuring actionable insights from complex datasets.
• Leveraged AWS services, including S3, Redshift, and Glue, to design and implement a robust data analytics platform, enhancing processing efficiency, storage scalability, and real-time data availability through.
• Applied advanced data manipulation and analysis techniques using Pandas and NumPy, optimizing data processing workflows and improving analytical accuracy.
• Developed and maintained Tableau dashboards for business intelligence reporting, providing real-time insights into key performance indicators and driving data-driven decision-making.
• Utilized Tableau's advanced visualization capabilities to create interactive reports, enhancing the understanding of complex data sets and improving stakeholder engagement.
• Integrated Tableau with various data sources, including SQL databases and cloud platforms, to ensure seamless data flow and accessibility for comprehensive analysis.

India

• Implemented a star schema data model in Azure SQL, improving query performance by 80% for 1000+ daily queries, measured through Query Store metrics.
• Developed Power BI reports with advanced DAX measures, analyzing $100M+ in revenue across 50 business units, supporting data-driven decisions and leading to a 12% cost reduction.
• Built automated data pipelines using Azure Data Factory, reducing data processing time from 8 hours to 45 minutes while managing increased data volume.
• Led the ETL process using Talend, ensuring accurate data extraction from over 5 sources into a centralized warehouse, streamlining daily tasks.
• Monitored and optimized database performance, reducing query execution time for complex queries through detailed tuning and performance metrics tracking.
• Created Python automation scripts (Pandas, Matplotlib) to clean and transform raw data, cutting manual data entry time by 50%.

Masters, Information Systems

Bachelor Of Engineering - Be, Computer Engineering