Anuja Baderia

Results-driven analyst with experience at Clarivate Analytics, specializing in statistical analysis and data visualization using SQL, Power BI, and Tableau. Proven ability to automate processes and create impactful business intelligence solutions. Strong communicator and team player, dedicated to delivering actionable insights that drive strategic decision-making.

360 DATA Science certification, CTC Training Institute, Gurgaon, 01/01/20, 11/30/20

Patent Portfolio Payment Tracking and Reporting System

To build an end-to-end reporting system using SQL and Power BI that allows a client to monitor their large portfolio of patent filings, focusing specifically on,

• Tracking payment statuses of patent applicants
• Identifying defaulters (those who haven't paid)
• Delivering clear and interactive reports to support business decisions

Methodology - Quality & Production Analysis:

This was a Tableau project in which the requester asked for the productivity summary of all his span. The need is to analyze the adjusted target hours on daily data and create a visualization of those employees whose productivity is lower than 100%, in which team they are, which director they are under, and which manager they report to

 Volvo 

Design dashboards and reports on the data that has been produced via SQL, using Power BI, and publish them on the web; also, transform data by mapping

Automated Error Analysis and Code Monitoring Dashboard

Build an automated system that tracks, analyzes, and visualizes code errors, warnings, job failures, and inefficiencies across projects, enabling early detection and reducing manual monitoring by approximately ₹1.5 lakh worth of man-hours per project

• Use SQL Agent Jobs to load new error logs from log files into SQL.
• Schedule Power BI refreshes every hour to simulate real-time monitoring
• It enabled data teams and engineers to proactively address code quality issues

DOB: September 2, 1995 

Marital Status: Single 

Gender: Female

Languages: Hindi, English 

Father's Name: Late Mr. Bhuri Singh Baderia