Freelance Experience

Technology Lead

The Weather Company

Remote Work

Feb 2023 - Present

Pennsylvania, USA

Key Achievements

  • Initiated B2B analytics reporting with key insights through Funnel Analysis, Forecasting, and more
  • Optimized Programmatic Advertisers pipeline, reducing processing time by 60%
  • Executed NetSuite invoice data integration with Salesforce
  • Led migration from Qlik Sense to Python for Datorama nPrinting
  • Implemented data-driven decision making across business units leading to 25% increase in revenue
  • Architected cloud-based data solutions that reduced infrastructure costs by 30%

Role Details

  • Initial Role: Started as an individual contributor, leveraging my expertise in Python and SQL.
  • Expanded Responsibilities: Took on additional roles and responsibilities due to team restructuring during multiple layoffs.
  • Current Role: Leading multiple projects across B2B and B2C, including requirements gathering, task delegation and project management.
  • Key Achievement: Successfully delivered enterprise-wide analytics platform accessed by 200+ stakeholders daily
  • Technical Innovation: Pioneered implementation of ML algorithms for predictive analytics in advertisement performance
  • Collaboration: Worked closely with Sylvia and Ivan on ad hoc requests and strategic initiatives
  • Executive Reporting: Built Google Sheets dashboard for CEO to track user behavior metrics
  • B2B Reporting: Launched comprehensive B2B reporting including Funnel Analysis, Forecasting, Renewal Metrics, and Attribution
  • Technical Growth: Advanced skills in Python (pandas, automation), SQL (advanced queries), Salesforce & Tableau CRM (QA, dashboards), Qlik Sense (debugging, dashboarding), AWS (Glue, EMR, Athena, QuickSight, Batch, S3, EC2), Airflow (DAG creation, recovery), and supporting tools like Jira, Confluence, Git Bash, Linux
  • Platforms: Gained expertise in Google Ads Manager, Cube.dev, Preset, Clickhouse, Growthbook, Amplitude, mParticle, Datorama
Data EngineeringCloud InfrastructureTeam LeadershipMachine LearningEnterprise IntegrationRemote Work

Professional Experience

Project Leader

Bitwise Solution Pvt Ltd

Remote Work

Dec 2022 - Present

Pune, Maharashtra

Key Achievements

  • Expertise in designing and developing micro services, REST APIs using python.
  • Rich work experience in Open Source frameworks like Apache Spark, Airflow and Flask framework.
  • Have good knowledge of AWS services i.e. Batch, Glue, Lambda, S3, Redshift, DynamoDB, and DMS.
  • Good experience in conducting proof-of-concept and developing prototypes.
  • Have working knowledge of JIRA, Azure DevOps for project management and collaboration.
  • Have knowledge of Docker.
  • Hands on experience with Python, SQL, HTML, Shell Script and JavaScript.
  • Used GITLAB, GITHub, Bitbucket as a code repository and versioning.
  • Good understanding of Algorithms, Data Structures and Design Patterns.
  • Working knowledge in Relational Database Systems like SQL Server and PostgreSql.
  • Work experience on Windows, Linux and UNIX environment.
  • Proficient with XML related technologies.
  • Implemented CI/CD through Jenkins.
  • Good analytical and programming capabilities coupled with excellent decision making skills.
  • Excellent team player and ability to perform well under pressure.
  • Good documentation skills and excellent technical, Communication and Interpersonal Skills with strong Client Interfacing Skills.
  • Conducting/Attending regular Conference Calls to gather requirements and preparing MOM for the activities.
  • Responsible for Analysis discussions with the end users, getting signoff, plan, lead, manage and execute a conversion process to move the existing lotus notes to development, UAT and Production deployment.
  • Implemented/developed policies and procedures, standards and best practice methods.

Client Projects

Gartner

Gartner SSC is a high visibility and critical project, the development for which was done years back, I am involved with managing the ever-increasing change requests and enhancements.This project has many end users and consumers who validate the data regularly and reach out in case of any business logic updates or refinements are required.There are several key players involved, including:OneGSD Team: They consume the data to further share it with various product owners,Sales Executives: The party who sold the services to the client and manages the account with regularly checks-ins with the client.,Salesforce Team: This team enables the Sales Executives to monitor their tasks and achievements,The pipelines are managed in Agile model in sprints and further the developments are tested and validated by the QA team and then we do the deployments.Exposure to the complete development flow, in-depth understanding of the system, technical knowledge, immense work load and high work pressure, ability to identify areas which require optimization are some of the characteristic requirements of the project.

Data EngineeringCloud InfrastructureTeam LeadershipMachine LearningEnterprise IntegrationRemote Work

Senior Data Engineer

Novartis Healthcare Pvt Ltd

Remote Work

May 2020 - Dec 2022

Hyderabad, Telangana

Key Achievements

  • Migrated from HIVE to Snowflake, increasing pipeline performance by 60%
  • Orchestrated jobs using Apache Airflow and Alteryx, improving system speed by 40%
  • Maintained 99.5% data accuracy with 9.5/10 stakeholder satisfaction
  • Led team of 3, collaborating with 15+ data vendors and 10+ brand leaders
  • Led Data Integration for 15 brands and 50+ dosages from 20 vendors; processed over 100GB of structured and unstructured data
  • Developed sales and demand forecasting dashboards using custom models like the Elapsed Days Model and moving average method
  • Automated previously manual data ingestion pipelines, reducing processing time significantly
  • Currently automating National Demand Reports using Qlik, Alteryx, SQL, and Python
  • Built QA dashboards to monitor data quality and monthly sales projections for Oncology brands
Data MigrationProcess AutomationTeam MentoringRemote WorkHealthcare AnalyticsPharmaceutical Data

Data Engineer

Polestar Solutions and Services

Jun 2018 - Apr 2020

Noida, Uttar Pradesh

Key Achievements

  • Worked with Jubilant FoodWorks to reduce production pipeline execution time by 66%
  • Migrated IndiaMART's on-premises system to AWS
  • Delivered automated prediction model workflows for Reckitt Benckiser using Azure Databricks
  • Successfully started cloud-based services as a new vertical for the organization

Client Projects

Jubilant FoodWorks Limited

The aim of this project was to develop, maintain and upgrade data pipelines to automate and optimize the production process on AWS Infrastructure. Successfully reduced the execution time for the production pipeline by 66% and decreased the cost of Data Storage on Amazon Redshift by 50%.

IndiaMART InterMESH Ltd

This project aimed at migrating the existing on-premises system to Amazon Web Services and generate Power BI reports for Sales and HR by extracting Parquet files from Amazon S3 and creating a warehouse in Amazon Redshift while processing the data in AWS Glue using Pyspark.

Reckitt Benckiser Group

In this project, the aim was to deliver automated workflows of the prediction model using Azure Databricks. Data needed to be extracted from Azure Blob Storage and Azure SQL Data Warehouse, then process the Parquet files are shared with DataRobot and finally the output is sent to the cube.

AWS ServicesAzure DatabricksData Pipeline OptimizationE-commerce AnalyticsRetail Operations

Education

Bachelor's Degree

Delhi Technological University (DTU)

Environmental Engineering

Aug 2014 - May 2018

Rohini, Delhi

Description

Focused on environmental engineering principles and sustainable technologies. Participated in multiple research projects related to waste management and environmental impact assessment. Developed strong analytical and problem-solving skills through practical lab work and field studies. Active member of the Engineering Society and Environmental Club.

12th Education

LBS Senior Secondary School - FIITJEE

Physics, Chemistry, Mathematics

Apr 2013 - Mar 2014

R.K. Puram, Delhi

Description

Completed senior secondary education with specialization in science subjects. Achieved academic excellence with particular strength in mathematics and physics. Participated in various inter-school competitions and science exhibitions. Developed strong foundations in analytical thinking and scientific concepts that later supported engineering studies.

10th Education

MVN School, Aravalli Hills

English, Mathematics, Science, Social Studies, Sanskrit

Apr 2011 - Mar 2012

Faridabad, Haryana

Description

Completed foundational education with a strong academic record across all subjects. Actively participated in various extracurricular activities including sports, cultural events, and science exhibitions. Received recognition for academic performance and leadership skills in group projects and classroom activities.