Arun Rastogi
Gurgaon
Summary
Organised and results-driven Data Analyst with over 7 years of experience supporting marketing and digital campaigns through data-driven insights and performance analysis. Strong expertise in campaign reporting, data validation, and automation using Excel and Power Query. Adept at translating complex datasets into actionable business insights, improving reporting efficiency, and supporting decision-making across cross-functional teams.
Overview
9
9
years of professional experience
Work History
Associate Data Analytics L2
Publicis Global Delivery - TechMedia - India
Gurugram
08.2024 - Current
- Created interactive dashboards and data visualizations to communicate insights to key stakeholders, supporting informed decision-making.
- Developed dashboards using Tableau and Power BI, enabling easy access and interpretation of performance data.
- Managed end-to-end campaign performance reporting across multiple digital platforms with high data accuracy and timely delivery.
- Analyzed campaign KPIs including impressions, clicks, CTR, CPM, conversions, and ROI to provide actionable insights and optimization recommendations.
- Performed data cleaning, validation, and reconciliation to improve reporting accuracy and reduce manual errors.
- Documented reporting processes and best practices to support team knowledge sharing and onboarding.
- Provided guidance and support to reporting analysts on analysis and reporting best practices.
Senior Data Analyst (Contractual)
Mesky Online Private Limited
Gurgaon, India
08.2023 - 08.2024
- Highly complex data management and reporting
- Understand all the systems used in client reporting production including heritage organizations
- Prepare daily, monthly, and quarterly reporting to be distributed to both internal and external clients
- Supervise reconciliation and management of data within performance systems
- Complete ad hoc projects to further enhance and develop reporting capabilities
- Production of monthly and quarterly customized reports
- Contributed to data capture, storage and forecast for analysis projects.
- Designed and implemented dashboards and reports to visualise data for easy interpretation by non-technical users.
- Analysed customer feedback and reviews to identify areas for improvement and enhance the shopping experience.
- Coordinated with the inventory team to ensure product listings were up-to-date and accurately reflected stock levels.
- Coordinated with the customer service team to resolve issues promptly, maintaining a high level of customer satisfaction.
- Used Power BI to collate and evaluate project data, presenting findings to key stakeholders.
Senior Data Analyst
Talent edge Pvt Ltd
Gurgaon
01.2022 - 08.2023
- MIS Reporting by Using advance MS Excel at Operational and Client level Fetching data from database in PHY Admin
- Analysis the rider's data & create report
- Responsible for Preparation of MIS/ Dashboard Report and Presenting it to the Concern Department using PowerBI
- Preparation of Automated reports by using advance functions like using advance function in Excel like Pivot, Sumproduct, Sumif, Countifs, Offset, Datedif, Subtotal, Vlookup, Hlookup, Substitute, etc..
MIS Executive
UK Express Logistic Ltd
Gurgaon
07.2017 - 10.2021
- Performed analysis and presented results using Excel
- Profile consists of maintaining complete track record of service delivery of goods to various companies, coordinating with clients & branches in UK and other parts
- Maintaining documents, track record, MIS, reporting IN & OUT time
- Create automated report using advance function in Excel like Pivot, Smart Pivot, Data Validation, Text to column, Date & Time Function, Sumproduct, Sumifs, Countifs, Datedif
- Providing complex analytical support through the analysis and interpretation of data in support of cross-functional business operations by MIS Reporting
- Working cross-functionally in analyzing, designing, and developing solutions by Creating automated report using advance function in Excel
- Developing annual and Monthly Reports new business initiatives (cost/benefit analysis)
- Dashboard Report and Presenting it to the Concern Department
- Conduct adhod Analysis of Key Data Metrics for Trend and Cost Analysis
- Generate timely and Accurate Reports for analysis
- Report Automation by Using VBA Programming.
Education
Master's in business administration -
Institute of Management And Technology
Bachelor of Business Administration -
Amity International University
Skills
- Problem-solving
- Risk management
- Quantitative methods
- Logic and analysis
- Attention to detail
- Efficiency
- Advance Excel
- VBA
- PowerBI
- Tableau
- Data handling
- Data validation
- Data mapping
- SQL, MySQL
- MS Office
- Google Sheet
- Python
- Data Analysis
Timeline
Associate Data Analytics L2
Publicis Global Delivery - TechMedia - India
08.2024 - Current
Senior Data Analyst (Contractual)
Mesky Online Private Limited
08.2023 - 08.2024
Senior Data Analyst
Talent edge Pvt Ltd
01.2022 - 08.2023
MIS Executive
UK Express Logistic Ltd
07.2017 - 10.2021
Bachelor of Business Administration -
Amity International University
Master's in business administration -
Institute of Management And Technology