Shubhasmita Kar

Database Development, Data warehouse Project

• Spearheaded implementation of highly efficient data management strategies to seamlessly support live food service project.
• Optimized data processing by implementing efficient ETL pipelines and streamlining database design
• Leveraged Extract, Transform, Load (ETL) tool to streamline upload of data into staging table, guaranteeing smooth dataflow throughout pipeline until reaching data mart segment.
• Worked in Team of 13 and managed Database and ETL pipelines.
• Expertly utilized Business Intelligence (BI) tools to visualize data in accordance with specific customer requirements, enhancing data comprehension and decision-making processes. ORACLE, PLSQL, ETL, DATA WAREHOUSE, BI TOOL

Data Cleansing App

• Spearheaded implementation of data loading phase through Extract, Transform, Load (ETL) methodologies, ensuring efficient extraction from diverse sources and seamless transfer to staging area.
• Developed comprehensive procedures, packages, and functions to construct robust data warehouse structure, meticulously organizing data for streamlined processing and analysis.
• Identified discrepancies within data mart, recognizing undesirable values that did not align with project objectives or quality standards.
• Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance