Rida Fathima

I work closely with engineering and finance teams in an Agile environment to align cloud data infrastructure with business goals. By centralizing transformations in Snowflake and optimizing Power BI integrations, I’ve improved data speed, reliability, and simplified access control. This role has strengthened my expertise in cloud-native architectures, data governance, and scalable data processing. -Handling enterprise-level data migration projects from legacy systems to Snowflake, establishing snowflake a production platform for Supply chain reports and maintaining data integrity. - Created Medallion architecture documentation to guide teams in adopting Snowflake and Power BI, streamlining data flow from ERP to reporting tables - immensely helping team during troubleshooting and understanding workflow. -Collaborated with data analysts, to implement dimensional schemas and deployed modular data warehouses on Snowflake lowering infrastructure costs by 18%. Also, streamlined access control eliminating the need for multi-source permissions. -Optimized Snowflake views and enabled direct Power BI connections, improving report refresh times, reducing transformation steps, simplifying troubleshooting, and boosting BI query performance by 42%. -Demonstrated ability to be flexible, adapt to changing project priorities, and manage a dynamic workload effectively. -Resolved daily tickets related to integrations, reporting, ETL, and data governance, while proactively coordinating with customers and assigning tasks based on requirements. -Investigated and resolved ETL issues during production incidents, ensuring minimal disruption and maintaining data pipeline reliability under time-sensitive conditions. -Created and managed user stories during sprint planning, ensuring timely completion within two-week sprints. Actively communicated with users and gathered business requirements required in performing the tasks.

- Graduate teaching assistant for Data Management for Analytics course. - Grade the assignments of students and provide them feedback. - Assist the course instructor with insights on improving the course efficacy.

- Creating and implementing ETL pipelines using SSIS packages within the Visual Studio environment, ensuring seamless data transformation and integration. - Creating and executing Stored Procedures in Google Big Query to efficiently load SQL Server data into the cloud, enabling fast and effective data management and retrieval. - Migrated existing pipelines and processes to the cloud (Google Cloud Platform) - Employed Cron Job schedulers to automate repetitive tasks related to table creation, loading data, and populating tables in GCP. - Developing an automation system to calculate the row count of tables in SQL and GCP, and configured it to send email notifications via SQL whenever a discrepancy in row count is detected. - Worked on Tableau for reporting data quality check analysis, created process flow diagrams and maintained detailed documentation of transformations and data lineage. - Actively participating in daily stand-up calls and demonstrating adherence to Agile Framework by engaging in sprint planning, retrospective and review sessions.

- Created an ETL Pipeline using Apache Airflow and PySpark in GCP to detect the anomalous data points in Mercedes Benz’s SAP Data Warehousing Systems. - Implemented advanced Machine Learning Models (LOF, IForest) and utilized T-SNE Plots to visualize high-dimensional data and enable the identification of Local outliers within the dataset. - Developed an interactive Dashboard on the cloud using Dash API, empowering Data Specialists to seamlessly identify and investigate anomalies in the data. - Produced reports for SQL Administrators to ensure the data accuracy and facilitate a robust product development process - Worked in a team and demonstrated Agile principles during Sprint Reviews, showcasing completed work and gathering feedback for continuous improvement.

- Developed an ETL pipeline to Automate the ingestion of flat files into Microsoft SQL Server, resulting in significant time savings (from 100 records per hour to 2000 records per hour). - Utilized data cleansing techniques to accurately identify attributes and tuples within text data, resulting in improved data integrity. - Implemented dynamic SQL statements to create databases, schemas, and tables to streamline the database creation process - Worked on recursive stored procedures, materialized views, functions and performance tuning.

Course work: - Statistical Foundations - Database Management for Analytics - Data Visualization - Data Programming - Scalable Data Analytics - Machine Learning - Deep Learning

Course work: - Data Structures - Python Programming - Java - MatLab - Linear and Advanced Calculus

Appeared for IIT JEE Mains and Advanced exams and received an admission offer from IIT Delhi.