Rajit Mahala

Experienced data professionals with over 5 years in the data industry, skilled in SQL Server, advanced Excel, DAX, and Power Query. Delivered interactive dashboards and automated reports for insurance, retail, Internet, and telecom industries. Strong in data modelling, KPI tracking, and turning insights into business value.

TechOps Analyst at Silverpush.co (2025-06 – Present)

• Manage end-to-end digital ad campaigns, ensuring timely setup, monitoring, and optimization.
• Perform QA checks on data, creatives, and targeting to ensure accuracy and compliance.
• Use Power BI, Power Query, and Advanced Excel for campaign reporting and dashboard creation
• Extract and analyze data using PostgreSQL for performance insights.
• Automate data extraction from YouTube API using Python scripting for scalable reporting.
• Track live metrics (impressions, clicks, conversions) and conduct root cause analysis for discrepancies, using DV360 tools and Inhouse tools (Mirror and ACM)

Advisor II, Content Moderator (BI Analyst) at Concentrix (2020-04 – 2024-12)

• Developed interactive Power BI dashboards for global retail, fashion, Internet and telecom clients, focusing on sales performance, customer satisfaction (CSAT), and service-level agreements (SLA).
• Conducted in-depth inventory analysis, utilizing advanced Excel techniques, which resulted in a notable 12% revenue growth by optimizing stock levels and minimizing overstock.
• Created interactive visuals and implemented drill-downs to allow content managers to easily monitor platform performance.
• Led the integration of data from various sources, including SQL databases, Excel, JSON and CSV files, APIs, to provide a unified view of business performance.
• Automated recurring reporting tasks by creating scheduled refreshes through Power BI Gateway.
• Automated weekly and monthly Excel reports using VBA Macros, reducing manual effort by over 60% and ensuring timely delivery to stakeholders
• Implemented row-level security in Power BI to ensure restricted data access based on user roles.
• Extracting daily moderated video data from TCS application and Cleaning and reshaping using Excel/Power BI in Power Query ETL Operation.
• Analyzing the weekly data, making report and dashboard, Publishing the weekly accuracy data of Moderators to the managers.

Associate Sales Consultant at Policybazaar.com (2019-09 – 2020-04)

• Managed end-to-end insurance sales and after-sales operations, including client onboarding, documentation, policy issuance, and customer follow-ups.
• Created and maintained Excel-based dashboards and reports to track leads, sales targets, policy renewals, and performance KPIs.
• Utilized Advanced Excel tools (VLOOKUP CHOOSE, HLOOKUP MATCH, INDEX MATCH, COUNTIFS PivotTables, VBA macros) to automate reporting tasks and enhance data accuracy.

Master of Business Management in Information Technology – NARSEE MONJEE INSTITUTE OF MANAGEMENT STUDIES (2022-06 – 2024-07)

Bachelor of Commerce in Statistics & Accounting – VIDYASAGAR UNIVERSITY (2015-06 – 2018-07)