Shivangi Rai

Analyzed and extracted patterns, trends, and insights from large datasets to optimize queries by 15%.

Developed intuitive and meaningful dashboards and visualizations for data display

Managed data analysts, providing timely actionable insights to stakeholders

Developed an efficient data pipeline that decreased data processing time by 3.4%, enabling quicker analysis and decision-making.

Extensive experience in working with Informatica power center and SQL stored procedures for over 4 years.

Managed the extraction of data from source and employed data pipelines for loading. Performed mining, clustering, and loading onto a cloud data warehouse to support future ELT process.

Utilized expertise in data extraction and loading for a renowned pharmaceutical company during transition from Business Development Manager to Informatica Intelligence Cloud Service. Worked in creating IICS mappings and automation of job scheduling. Experience optimizing ETL workflows. Have managed end-to-end data migration and conversion.

Responsible for managing Oracle, Talend, Redshift, and Snowflake cloud warehouses and databases.

Implemented agile methodology to ensure punctual delivery of data products.

Led the development of an innovative, cloud-based data warehouse solution which enabled real-time analytics at a prominent US pharmaceutical firm.

Created a data warehouse to optimize access and analysis of intricate datasets.

· Worked on tools like Bladebridge, Snap Logic, Abinitio, ADF (for data migration), Power Bi, Tableau, Snowflake and Talend.

Created effective Hadoop interfaces to enable smooth transition of workflow between clients and users, while implementing a robust data manipulation solution to tackle challenges related to data inconsistency and redundancy.

Implemented Hive partitions to allow for timestamp modifications on truncate and load tables while preserving landing tables. Utilized the SDP framework and MapReduce to differentiate upcoming data through table creation.

· Implemented a data pipeline that automated the collection and transformation of large datasets from multiple sources like Amazon S3 bucket, External vendor (Veeva vault, hybrid excel file).