Mannat Sareen Email & Phone Number

Gurugram, Hr, In

Gurugram, Haryana, India

- Data Modelling: Developed comprehensive data models for biologics domain, with focus on key modeling principles like scalability, flexibility, and data integrity, while also prioritizing standardization and normalization to facilitate efficient data management and analysis.- Agile Project Delivery: Delivered an end-to-end data management solution for a prominent pharma client for ~15 assays, spanning 4 therapeutic areas in an agile manner involving ingestion & ETL… Show more - Data Modelling: Developed comprehensive data models for biologics domain, with focus on key modeling principles like scalability, flexibility, and data integrity, while also prioritizing standardization and normalization to facilitate efficient data management and analysis.- Agile Project Delivery: Delivered an end-to-end data management solution for a prominent pharma client for ~15 assays, spanning 4 therapeutic areas in an agile manner involving ingestion & ETL pipeline creation, KPI analysis and creating access-controlled dashboards for different user groups bringing in $500k+ in revenue.- Automation: Lead operations effort for a client across 4+ workstreams. Helped orchestrate their ETL flows using Airflow thereby reducing manual intervention and saving ~5 hours per week of human hours. - Worked as business analyst, leading and facilitating requirements-gatheringsessions with stakeholders of varying levels, creating comprehensive BRDs, use cases, user stories and function specifications and tracking the same on JIRA.- Release Management: Serve as the lead for release management, streamlining migration processes and stabilizing project environments to ensure smooth deployment.- Stakeholder Communication: Effectively communicate complex technical concepts to both technical and non-technical stakeholders.- Well-versed in preparing Statements of Work (SOW) and Request for Proposals (RFP) to define project scope, goals, deliverables, and pricing. Show less

Gurugram, Haryana, India

- Project Leadership: Led ETL workstream for a fortune 500 pharma client on datalake based data management solution on AWS cloud architecture.- Solution Architect - Designed data warehousing solution using AWS services like AWS Glue for data ingestion, AWS S3 to act as the data lake, custom python scripts to perform ETL & AWS Redshift to query the final data products for reporting.- Data Migration: Migrated legacy on-prem data warehouses to AWS cloud and developed data… Show more - Project Leadership: Led ETL workstream for a fortune 500 pharma client on datalake based data management solution on AWS cloud architecture.- Solution Architect - Designed data warehousing solution using AWS services like AWS Glue for data ingestion, AWS S3 to act as the data lake, custom python scripts to perform ETL & AWS Redshift to query the final data products for reporting.- Data Migration: Migrated legacy on-prem data warehouses to AWS cloud and developed data pipelines using AWS Glue, AWS Athena.- Performed a PoC to compare AWS Redshift, Databricks and Snowflake across various parameters for non-clinical assay data to help clients with a POV to identify the best fit for their data management solution.- Project Lifecycle Management– Detailed out delivery schedule for an agile project, aligning on deliverables for each sprint with the stakeholders and allocatingresources with appropriate skillsets. Show less

Gurgaon, India

- Developed multiple data processing frameworks using python and PostgreSQL- Performed various PoC’s on various cloud-based services (AWS & Azure) to determine scalable and cost-effective data management solutions for clients.- Designed logical and physical data models as per the best practices and star/snowflake methodologies

Pune, Maharashtra, India

The project involved making solution models for various analytical requirements of a retail store which included connecting the local database to the cloud, querying the company’s database using SQL Server 2016, cleaning the data and creating visualizations using MS- Excel and Power BI and creating data cubes using Visual Studio.

Bachelor Of Technology - Btech, Computer Science With Specialization In Business Analytics And Optimization

Class X