Harshvardhan Pareek

Data Analyst

Derrick Corporation•  January 2023 - October 2024•  Noida

Analyze multi-channel traffic, revenue, and user engagement data using Python (Pandas, NumPy) and web analytics tools like GA4 and SEMrush to drive insights. Designed and implemented data integration and ETL processes in Power BI with Python and SQL to ensure accurate data flow and reporting. Created advanced data visualizations and dashboards using Matplotlib, Power BI, and other tools to provide actionable insights for teams. Conducted audits and automated Google Tag Manager configurations using Python to ensure data accuracy and integrity across marketing campaigns.

consultant

Adobe•  July 2021 - July 2022•  Noida

Built operational reporting on Power Bi to find the areas of improvement for Adobe Acrobat and Document Cloud services Extracted raw data from databases and read and analyzed it. • Managing community forum data and creating reports and dashboards for top trending issues using SSRS • Initiated a project for improving the first-time resolution rate by mining and analyzing data in python using pandas • Deck creation and presenting monthly insights to the Product managers and core developers • Creating tabular, matrix, drill- down and drill-through reports and graphs SQL Server reporting services