Apr 2024 – Nov 2024 · 7 mos · Remote

• Migrations & Automations –
•  Developed an automated solution to detect changes in media data from 12-hour feeds using Azure Data Factory, Azure Functions, and Azure Data Lake, achieving 100% automation and 48% reduction in process time.
•  Built a pipeline to parse taxonomies through API integrations, feeding data into a dashboard for weekly automated refresh using AWS Lambda, S3, SQS, Snowflake (Snowpipe), and Tableau.
•  Automated Reporting Service to detect different platforms, phases, and curate various reporting views such as WoW, geographies, etc. using Snowflake procedures & tasks.
•  Managed a Snowflake data ingestion tool, developed using Azure Databricks, Azure Data Lake, and Snowflake, scaled from 2000 to 5000+ users and for 14 to 30+ clients.
•  Led ETL process migration from Alteryx-Redshift-BQ to PySpark-Snowflake-BQ, cutting completion time by 65%, optimizing resource utilization and reducing overall cost by 60%.
• Recommendation Tool | Spend Budget Optimizer –
•  Analyzes campaign spending data based on key attributes. Recommends key campaign areas, placements, geographies, etc. generating good impressions and revenues by scoring ads. 13% increase in ROI.
• Anomaly Detection | Automated QA Pipeline –
•  To verify whether yesterday’s data is standard or an abnormality. Scaled across multiple accounts, thereby improving 20% resource utilization and 0 escalations.
• Keywords – DBScan Clustering, Isolation Forest, LOF, Moving average, Dashboarding, Snowflake.
• Forecasting | Airline Crew Standby Analysis & Catering Business –
•  Identifying Cabin Crew leaves pattern and forecasting the number of standby crew required.
•  Based on historical orders data, quantifying the different foods requirement to maintain inventory and optimize pricing.
• Keywords – Classification, Random Forest, Time Series, Pattern recognition, AWS cloud formation, Lambda, Sage Maker, Forecast.
• Generative AI | Chatbot –
•  Trained Google’s Gemini model on Company’s data corpus.

Jul 2022 – Mar 2024 · 1 yr 8 mos · Remote

Feb 2016 – Jun 2022 · 6 yrs 4 mos · Delhi, India · Hybrid

• Migrations & Automations –
•  Built automated monthly reporting service pipeline (for PAN India sites) using Azure Blob storage, Data Factory, Data lake and Power BI.
•  Adopted Parquet as the default storage format, reducing storage costs by 22% and speeding up data retrieval time.
• Clustering | Material Segmentation & Planning –
•  Developed model by interpreting the trends of price escalation of metals and classifying items into groups, thereby suggesting strategic decision to management, and saving INR 3.9 Crores.
• Keywords – Clustering, Price Analysis, Planning optimization.
• Automation | Auto-creation of Bill of Quantities –
•  Extract information to create list of materials using 3D building models. Manhours saving by 65%.
• Keywords – Azure Synapse Analytics (Data Factory), Azure Data Lake.
• Natural Language Processing (NLP) | Contract Management –
•  Reformat the whole contract in standard template. Ask any question related to that contract.
• Keywords – Transformers, Topic identification, Text Similarity, Word embeddings.
• Trend Analysis –
•  Analyzed the market trends of price variations, supply, and demand ratio, etc. of various metals for the period before, during and after COVID-19.
• Keywords – Pattern finding, Association rule mining
• Computer Vision (CV) | Construction Site Safety Monitoring –
•  Constantly monitor for safety issues and alert when there is a breach. Implemented to PAN India sites leading to 38% reduction in incidents.
• Keywords – yolov5, Object Detection