Gurjot Singh

Leveraged Python (Pandas, NumPy, SciPy) for data cleansing, transformation, feature engineering and applying statistical analysis techniques to uncover insights and support data-driven decision making. Engineered robust ETL pipelines using Python and SQL to automate the extraction, transformation, and loading of data from multiple sources into a centralized database. Analyzed website and social media performance using Google Analytics, providing strategic recommendations that boosted organic traffic by 60% and improved conversion rates by 30%. Developed models to forecast customer churn supporting market research initiatives and product analytics efforts. Used Git for version control. Built and maintained Business Intelligence dashboards and visualizations in Power BI, surfacing KPIs and enabling self-serve analytics for stakeholders. Created comprehensive user guides and technical documentation for ETL workflows, predictive models, & data mining tasks.

Continued internship in the same capacity, contributing to data analytics tasks for digital marketing campaigns, including data collection, cleaning, reporting, and performance analysis.

Developed and deployed machine learning models using scikit-learn and TensorFlow, optimizing marketing campaigns and improving ROI by 20% through rigorous statistical evaluation. Automated and optimized marketing campaign data workflows within CRM (Adobe Campaign Manager) ensuring seamless campaign management and execution, reducing delays and ensuring real-time marketing updates and analysis. Used VBA Macros to automate repetitive tasks and Python, SQL, advanced Excel functions (VLOOKUPs, Index & Match) for data analysis & reporting for digital marketing campaigns and using SQL for data retrieval and updating. Led the design and execution of A/B tests, resulting in a 65% increase in email open rates. Built interactive KPI dashboards using Power BI, connecting to multiple data sources and using Power Query and DAX for data transformation and cleaning.