Gurleen Kaur

PII Detector: Technology Client (US)

Worked in the role of an ML Developer for a major cloud service provider to enhance GDPR compliance. The project evolved from a regex and Power Automate solution to an efficient ML-driven approach for PII data masking.

Data Transfer and Storage:

• Utilized Kusto Query Language (KQL) to seamlessly transfer data from Azure Data Explorer to Azure Storage, ensuring security and accessibility.

Data Transformation:

• Engineered automated data transformation pipelines using Azure Data Factory to cleanse and standardize incoming data, setting the stage for precise analysis
• Transformations were performed to save each cell value & corresponding meta data in .csv format using Azure Blob storage as the sink

Machine Learning :

• Developed and deployed SVM model for PII classification in .csv files, effectively addressing dataset imbalance with class weights. Emphasized recall as the key metric to reduce false negatives.
• Achieved significant improvements in classification accuracy with a precision score of 85% and recall score of 90%.

Order Intelligence Tool: Pharmaceutical Client (UK)

Guided a team of four data experts in the successful execution of various BI & DS modules. Equipped team members with proficiency in Databricks platform, PySpark and adeptness in crafting efficient Business Intelligence (BI) solutions.

Customer- 360 :

• Led a pharmacy-360 solution enabling enhanced customer insights and curated offers. Collaborated closely with stakeholders to define requirements and created an extensive feature set across 4 key dimensions, resulting in improved customer segmentation and targeted marketing strategies.

Forecast Improvement :

• Improved demand forecasting by replacing existing fbprophet model with a Multi output Random forest regressor from sklearn using market data & historical sales, reducing Mean Absolute Percentage Error (MAPE) by over 15%
• Reduce the time taken in forecast by dividing pharmacies into blocks and using parallel processing for each block's pharmacy

Automated Offer Generation :

• Led a team of two data professionals in designing and implementing an automated offer generation solution within Databricks using master pipeline for orchestration of entire process
• Enhanced efficiency by creating shared utility notebooks for code reusability and separate notebooks for specific tasks, such as data preprocessing, cleaning, model training, and evaluation.

ROI PowerBI Dashboard :

• Collaborated with the business stakeholders to define and discuss the precise metrics required for ROI calculation, including G2N investment, net revenue, gross profit, and other financial KPIs.
• Designed standard pipeline in databricks to cater to different countries, capable of handling complex data involving offered discounts, target volumes, extra offers, realization of offers, rebates, taxes, and other financial variables

Assortment Enablement App: Retail Client (EU)

Acted as application owner in a cross functional role with strategy team, category managers and data engineers to lead end-to-end development of assortment enablement PowerBI application for EU region

Descriptive analysis :

• Performed analysis by generating impactful views such as Trending Items, Productivity vs Store Distribution, White Space Analysis, and Basket Analysis, facilitating data-driven decision-making and resulting in a 15% increase in overall sales

Item Recommendation :

• Implemented data-driven recommendation algorithm for product mix optimization , using economic performance, uniqueness, and cost metrics as per discussion with strategy team; achieved a significant average unit uplift of 5% across categories

A/B Testing enhancement - Outlier Detection:

• Developed a statistical model using Python in databricks to identify outlier stores impacting A/B test outcomes, leveraging visual inspection, difference plot analysis, and statistical tests
• Successfully detected non-parallel trends in 20% of the cases, leading to more accurate interpretation of test results and refined decision-making.