- Requirement gathering from business stakeholders to ascertain business needs- Designing data solutions architecture for on-premises or cloud solutions- Collecting, cleansing, organizing, and analyzing data from different sources for business intelligence purposes.- Identify, analyze and interpret trends in complex data sets- Presenting insights using clear and concise dashboards to allow stakeholders make timely and efficient decisions.- Implementing star and snowflake data models for database and data warehouse designs- Creating data ingestion pipelines on-premises (SSIS) or on-cloud (Azure Data Factory) for data migration and transformation- Developing SQL queries/ETL packages in SSIS and Azure Data Factory to ingest data from source systems, integrate, transform, and load into the data warehouse.- Developing custom conventional reports, paginated reports, and dashboards to track KPIs.

- Program design and implementation- Program Evaluation using statistical tools- Design and Implementation of Randomized Control Trials- Data cleaning and warehousing- Creating interactive reports and dashboards- Stakeholder engagement and requirement gathering

- Gathered business requirements from school/educational stakeholders- Designed and implemented a relational database using star schema- Optimized database and tables using partitioning, scale-out, and indexing- Developed SQL views and stored procedures for efficient data usage- Created automated reports and dashboards to track KPIs- Designed SQL views and stored procedures for efficient data reading and writing.- Developed data pipelines in SSIS for creating PowerBI dashboards of student academic performance- Created documentation on databases, data process flows, and data dictionaries that allowed a clear understanding and replication of data analysis and reporting processes.- Designed and implemented academic curriculum.- Managed teacher recruitment and training- Analyzed student performance data using visualization tools like Tableau, Excel, and Power BI