ROHIT KANSAL
Aspiring Data Analyst | Data Associate
Roorkee
Summary
Detail-oriented Data Analyst aspirant with 4+ years of experience in data operations and a Bachelor of Technology in Computer Science. Skilled in SQL, Excel, Power BI, and Python for data cleaning, analysis, and visualization. Experienced in transforming raw data into meaningful insights, building dashboards, and supporting business decision-making. Actively building hands-on analytics projects to transition into a full-time Data Analyst role.
Overview
6
6
years of professional experience
Work History
Data Associate
Syndigo
12.2021 - Current
- Processed, cleaned, and validated large datasets to ensure high data accuracy and consistency.
- Collaborated with cross-functional teams to support reporting and business operations.
- Worked on data standardization, categorization, and documentation.
- Assisted in basic analysis using SQL queries for data extraction.
- Supported dashboard creation and reporting in Power BI .
- Created calculated columns and measures using basic DAX.
- Used Excel (Pivot Tables, VLOOKUP, conditional formatting) for data analysis.
Digital Marketing Executive
Blink Click Media
04.2020 - 09.2021
- Increased website traffic by implementing search engine optimization strategies and keyword research.
- Increased customer retention rates with personalized email marketing campaigns tailored to individual preferences and behaviors.
- Optimized website exposure by analyzing search engine patterns to direct online placement of keywords or other content.
- Planned and executed web, SEO, database marketing and social media advertising campaigns.
Content Writer
Adda247
08.2019 - 11.2019
- Wrote and published exam-focused blogs related to government job preparation (Banking, SSC, UPSC, Teaching, Defence, etc.).
- Managed blog publishing on WordPress , including formatting, scheduling, tagging, and categorization.
- Assisted in improving user engagement and lead generation through informative, well-structured content.
Education
Bachelor of Technology (BTech) - Computer Science
College Of Engineering Roorkee (C.O.E.R)
Roorkee, India 04.2001 -
Skills
SQL (SELECT, JOINs, GROUP BY)
Timeline
Data Associate
Syndigo
12.2021 - Current
Digital Marketing Executive
Blink Click Media
04.2020 - 09.2021
Content Writer
Adda247
08.2019 - 11.2019
Bachelor of Technology (BTech) - Computer Science
College Of Engineering Roorkee (C.O.E.R)
04.2001 -