Kanika Monga Email & Phone Number

India

Managing end-to-end data ingestion from various EDC and non-EDC sources to support clinical trials for a life sciences client.Designing and developing ETL scripts with Python and PySpark, performing ad hoc code adjustments, and extracting essential data using SQL. Creating and monitoring DAGs in Apache Airflow for seamless data pipeline orchestration and leverage AWS services to ensure secure, scalable data processing solutions.

Noida, Uttar Pradesh, India

Led migration efforts from MS SQL Server to Snowflake, transferring SQL objects like tables, views, functions and stored proceduresDeveloped JSON mapper files to configure AWS DMS, ensuring seamless data transformationDesigned and implemented complex functions and stored procedures on Snowflake platform to optimise data processing and analysisConducted comprehensive unit testing on all SQL Objects to ensure their proper functionality and integrityUtilised AWS Glue and PySpark to create Data Validation jobs with the following key features: - Checked column count between source and target tables - Verified row count to detect any discrepancies in data transfer - Identified and resolved missing columns between source and target tables - Identified and resolved mismatched data types of columns between source and target tables - Implemented value-by-value comparison to ensure data accuracy and integrity, displaying arrays of non-matching or missing records from the sourceDeveloped Python Scripts for ETL processes, extracting data from MS SQL Server and occasionally CSV files, and transforming it before loading it into Azure Synapse for analysisTools Used: PySpark, Python, AWS Glue, AWS S3, AWS DMS, Azure Synapse, MS SQL Server, Snowflake, Excel

Mumbai Metropolitan Region

Automating the ETL process through R programming and Python scripts in order to get the data loaded in the database from different data sourcesExtracting and loading unstructured data from AWS S3 using R programming, Python and AWS CLICreating stored procedures, Views and functions for day-to-day challenges on SQLBuilding and maintaining the scheduled jobs for the timely run of the automated scripts for ETLPerforming descriptive analyses on the data to showcase the clinical and operational key performing metricsLoading data files in CSV format to Microsoft Azure for an external clientExtracting data for the operational indicators on quarterly basis running SQL queries on MS SQL Server & PostgreSQLHelping in providing with the data for the internal and external stakeholders by writing complex queries on PostgreSQLSupporting in building the internal and client- facing (external) dashboards and reports on MS Power BITools Used: RStudio, Pandas-Python, MS SQL Server, PostgreSQL, AWS CLI, AWS RDS, AWS S3, Microsoft Azure, Power BI, Excel, Google Spreadsheets

Mumbai, Maharashtra, India

Extracted data by writing complex queries on MySQL workbenchCreated stored procedures, functions and views for day-to-day challengesImported queries to make clinical, output and process indicators in dashboards on Apache SupersetBuilt quarterly clinical audit reports using Pandas and ExcelAnalysed the patient's data to get insights on the trend in the diseases and the requirement of the health worker in an area using Pandas- PythonDelivered the KT sessions to the client/stakeholders at the time of the handover of a projectTools Used: Pandas, MySQL workbench, Apache Superset,Excel

Gurugram, Haryana, India

Orchestrated the development of Python transform scripts, including creating tables and views on Snowflake using Dbt cloud platform to extract data from MongoDB and load it into Snowflake, enhancing data processing efficiencySpearheaded data visualisation efforts by creating numerous reports on the Mode platform, providing stakeholders with actionable insightsConducted thorough data validation for each report to ensure data accuracy and integrity before handing them over to stakeholdersPromoted to the role of Tech Trainer, responsible for conducting training sessions for different teams on business domain knowledge and various technologies, including advanced SQL, Excel and data validation processesDesigned and delivered training modules on advanced SQL, Excel functionalities, best practices of data validation, equipping teams with essential skills for efficient data management and analysisTools Used: Snowflake, MongoDB, Dbt cloud, Python, Excel, Mode

Bachelor Of Physical Sciences

Post Graduate Diploma In Business Administration, Marketing, A