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 99.99% data accuracy • 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 costs.• 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. • Implemented automated anomaly detection that captured $2.3M in annual savings with 94% accuracy, validated through 6-month A/B testing with finance team.• Developed interactive Tableau dashboards to monitor key financial metrics, providing real-time insights on $50M in revenue.• Implemented advanced SQL methodologies for ad-hoc analysis, leveraging complex queries and joins to extract insights from large datasets efficiently.• Conducted comprehensive data profiling to identify data anomalies and outliers, ensuring data accuracy and reliability for informed decision-making.• Developed custom reports and dashboards to monitor key business metrics, enabling real-time tracking of performance and identification of trends.

• 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 automated pipelines orchestrated with Apache Airflow and AWS Glue.• 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.• Employed AWS QuickSight for cloud-native business intelligence, creating interactive dashboards and visualizations to provide insights and drive data-driven decision-making.• Managed MySQL and PostgreSQL databases, maintaining data integrity and accessibility for various analytical applications.• Utilized Git and GitHub for version control and collaboration in data analysis projects, ensuring code quality and team coordination.• Conducted thorough data wrangling, preprocessing, and profiling to guarantee data quality and usability for downstream analysis.• Worked with RStudio and PyCharm for efficient coding and development tasks, enhancing productivity and code readability.• Utilized AWS Lambda for serverless computing, enabling automatic data processing and transformation in response to events, reducing operational overhead and improving scalability.

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