Nimra T.

Orchestrated improvements to the data infrastructure supporting advanced analytics and business intelligence through Apache Airflow, optimizing scheduling for data operations. Managed data ingestion and transformation from diverse sources on AWS S3, leveraging Amazon Redshift and PostgreSQL for improved query performance. Developed and maintained robust data pipelines across AWS and Google Cloud Platform, ensuring system resilience and scalability. Spearheaded the design and implementation of an ETL process to cleanse and transform disparate source data, integrating it into a centralized warehouse on AWS RDS. Oversaw and optimized both relational (MySQL, PostgreSQL) and NoSQL databases, as well as Amazon RDS, ensuring high availability and consistent performance. Implemented data quality checks and monitoring processes using Tableau and Power BI, significantly reducing data errors and enhancing overall data reliability.

Led MDM initiatives by overhauling existing practices to enhance data integrity and agility. Employed Data Vault 2.0 methodologies, improving robustness and flexibility in data handling processes. Utilized Alteryx for advanced data blending and transformation, employing algorithms like Damerau–Levenshtein, Jaro-Winkler, and Hamming Distance to achieve high accuracy in dataset comparisons. Created comprehensive ETL workflows to automate data ingestion, transformation, and loading from multiple CRM systems such as Salesforce, SAP, and Marketo. Integrated cleaned data into Google BigQuery, MySQL, and PostgreSQL, streamlining data integration and boosting processing efficiency. Ensured efficient data management and optimization across diverse platforms, enhancing the data infrastructure and supporting strategic business decisions.

Launched and led the AGE Viewer project to create a dedicated desktop application for Apache AGE, using Go and the Wails framework to enhance graph data visualization and management. Integrated GraphQL with PostgreSQL and MySQL for efficient data management, and used React.js to develop a responsive, user-friendly interface for graph data visualization. Oversaw Git for version control, fostering team collaboration and code management. Engaged with the Apache AGE community through platforms like LinkedIn and Stack Overflow, offering technical support and gathering user feedback.