• Co-developed a server-less forecasting model using Python, SQL, and AWS Lambda, enabling clients to accurately forecast their revenue, thereby enhancing planning and decision-making processes.• Designed a statistical approach-based Marketing Attribution Model that attributed total conversions to platforms based on historical data, leading to more effective resource allocation and a 5-7% improvement in ROI.• Optimized attribution code using PySpark and SQL, reducing job costs by 70%… Show more • Co-developed a server-less forecasting model using Python, SQL, and AWS Lambda, enabling clients to accurately forecast their revenue, thereby enhancing planning and decision-making processes.• Designed a statistical approach-based Marketing Attribution Model that attributed total conversions to platforms based on historical data, leading to more effective resource allocation and a 5-7% improvement in ROI.• Optimized attribution code using PySpark and SQL, reducing job costs by 70% while analyzing 10+ million records in the Google Analytics 4 database.• Built a Machine Learning-based Marketing Attribution Model using AWS SageMaker, XGBoost, and Cluster Analysis, enhancing existing models and product capabilities.• Created multiple ETL processes in Python, PySpark, and SQL to seamlessly transfer data from various data sources in Google Cloud Platform to AWS, ensuring data integration across platforms.• Managed large and complex datasets to provide automated actionable insights, including trend evaluation, summarization, and forecasting, resulting in a 30% increase in efficiency (utilizing Python, Pandas, Scikit-Learn, and Matplotlib).• Collaborated closely with UI and DevOps teams to ensure timely project launches and smooth cross-functional transitions.• Developed multiple dashboards for clients to visualize campaign performance easily. Show less

1. Wrote two different insight generators that show monthly changes in the revenue, impressions, clicks, and many other details for various channels/sources and platform campaigns and deliver sentences/insights according to the change.2. Maintained the attribution code, which attributes the platform campaigns, UTM campaigns, and channels in the user's journey.Tools used:- Python, Pyspark, SQL, Pandas, Microsoft Excel