Back to Developers
Suraj Sonkar

Suraj Sonkar

Campaign Analytics | BI Analyst | Data Analyst

80
Profile Score

About

Results-driven Data & Campaign Analytics professional with 3+ years of experience designing and executing end-to-end analytics solutions. Proven ability to collect and prepare data from CRM and digital platforms, develop interactive Power BI / Looker / Excel dashboards, and translate campaign performance data into actionable insights that drive marketing and customer engagement outcomes. Adept at stakeholder collaboration, clear communication of technical findings to non-technical audiences, and continuous learning of emerging analytics tools including GCP BigQuery and Python. Strong quantitative & analytical mindset with a growth orientation and future-ready curiosity.

Skills & Expertise (32)

Power BI Intermediate
8.3/10
1
Years Exp
SQL Intermediate
8.1/10
1
Years Exp
Excel Intermediate
7.7/10
1
Years Exp
Python Intermediate
7.5/10
1
Years Exp
DAX Intermediate
7.4/10
1
Years Exp
RLS AWS GCP Microsoft Copilot Campaign Performance Analysis KPI development Star Schema Statistical Analysis SPSS Minitab CRM Data Integration ServiceNow Jira Documentation Data Warehousing Snowflake Schema Alteryx SSIS Power Query Redshift GCP BigQuery Oracle Postgresql MS SQL Server Tableau Qlik Sense Looker

Work Experience

Programmer Analyst (Campaign Analytics & BI)

Cognizant Technology Solutions

Mar 2023 - Present

Designed and developed campaign performance dashboards in Power BI and Excel, tracking customer response rates, engagement KPIs, and conversion metrics aligned with marketing objectives. Collected and prepared data from CRM systems and digital platforms, performing data wrangling, cleansing, and transformation to enable robust campaign analysis. Wrote complex SQL queries (joins, CTEs, window functions) against MS SQL Server, PostgreSQL, and Redshift to extract and analyse large-scale campaign datasets. Developed advanced DAX calculations and KPIs, translating campaign objectives into measurable metrics and delivering actionable insights to marketing and product stakeholders. Built scalable data models (star/snowflake schema) supporting multi-source campaign reporting; optimised refresh times by 40%. Automated campaign reporting workflows using Python and Power Query, reducing manual effort by 60–80% and improving data accuracy. Implemented Row-Level Security (RLS) ensuring data compliance and appropriate access control across campaign datasets. Collaborated with marketing, product, and business teams to translate campaign objectives into analytics solutions, communicating insights clearly to non-technical audiences. Leveraged Microsoft Copilot and AI tools to automate report development and stay current with emerging analytics technologies. Maintained clear documentation of analytics processes, methodologies, and findings for transparency and knowledge sharing.

Data Analytics Intern

Cognizant Technology Solutions

Feb 2022 - Jul 2022

Developed SQL and Python scripts for data transformation and analytics supporting campaign and supply chain reporting workflows. Performed statistical analysis using R and SPSS on large datasets; supported ETL and BI reporting pipelines.

Education

BTech – Computer Science - ABES Engineering College

- 2022 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceMar 2026