Dec 2024 – Dec 2025 · 1 yr · Gurugram, Haryana, India · On-site

• Managed and optimized datasets of 500k+ data points, ensuring efficient data storage and retrieval.
• Automated data processes using cloud technologies (Google BigQuery and Appscript) to streamline data workflows.
• Developed and maintained automated systems for daily report generation and pre-processing of data.
• Managed and integrated data from Zomato’s API and Blinkit’s asset management system for real-time tracking and reporting.
• Leveraged Google Apps Script to automate data fetching, cleaning, and report distribution processes.
• Built and maintained interactive Looker dashboards for real-time data visualization and performance monitoring.
• Implemented robust ETL pipelines and data validation processes to ensure data integrity and consistency.
• Led efforts in automating and streamlining cross-functional reporting, improving decision-making processes.

Nov 2023 – Nov 2024 · 1 yr · Delhi, India · On-site

• Manage daily, weekly and monthly sales reports and data of GOOGLE PAY and HDFC.
• ■ Manage monthly attendance of onroll and off role staff, preparing payroll trix in google sheets/excel and prepare management reports.
• ■ Identify inaccuracy in reports, dashboards and how to prevent them.
• ■ Prepare monthly, quarterly and yearly performance reports of staff and share with managers.
• ■ Manage data repositories and update those daily, weekly and monthly.
• ■ Manage internal sales CRM tools and identify and report any issues to the management.
• ■ Manage external agencies for hiring/joining HC requirements.
• ■ Manage internal finance team requirements for external agencies.
• ■ Manage and close the monthly payroll every month within the SLA.
• ■ Manage own SOPs and projects defined existing SOPs and update them regularly.
• ■ Build good relationships with external agencies to smooth the payroll process.
• ■ Readiness to stretch when required specifically the first week of every month.
• ■ Ability to make things within the TAT and SLA.
• ■ Should be able to work under pressure and be able to manage the team
• ■ Conduct data and metrics analysis, understand patterns and derive KPIs/KRAs.
• ■ Audits all MI prepared by the Executives.
• ■ Structure data and Manage database for Ad Hoc reports.

Jan 2023 – Nov 2023 · 10 mos · On-site

• Works for US clients for analyzing, visualizing and understanding the data.
•  Build data pipelines and dashboard for marketers and apply advanced
• analytical method as per the client.
•  Execute stakeholders’ management and as well as risk analysis for one
• client. Make useful analysis dashboard for that client on Power BI.
•  Make daily reports, data extraction from APIs, clean data, draw useful insights. Handling different data processes by using python, advanced excel and SQL. Use HDFS for storing node files. Use SQL for data management and storing. And use python and R for data cleaning and analysis and also use Tableau for handling the visualization