Abhishek Singh

Senior Analyst

Anaqua LLP•  February 2024 - Present

Verify bibliographic, assignment, and priority details using PTO registers, file histories, and databases. Validate and report patent data from PTO websites. Support project managers by preparing and distributing excel reports to team members.

Data Analyst

Clarivate•  April 2021 - February 2024

Conducted analytical assessments of patent portfolio data using SQL and Power BI, delivering actionable intelligence reports in PowerPoint for decision-making by IP portfolio managers, which improved IP strategy outcomes by 20%. Utilized Advanced Excel & prepare 15 plus Excel Dashboard & Power BI Dashboard and SQL - DQL for operations on large datasets. Provided various analyses, including citation, filing and grant trends and geographical distribution, with help of BI Tools of 100K patents data records. Communicating with stakeholders to customize final analytical reports based on their requirements. Conducted secondary market research across industries to support strategic data-driven decisions. Maintained process integrity and updated SOP processes as per new business requirements.

MIS Analyst

Wipro•  July 2017 - September 2018

Conducting daily analysis on HR data for 10+ clients using SQL queries (DQL) to extract data from databases. Preparation of MIS Excel Reports of HR Data, related to participants medical coverage, deductions, and send the reports to various teams on floors like DC, DB. Performing Analysis work and after types of error id's and nature of problems/issues participants are facing using Excel formulas and Charts, Pivot Table on client’s HR Data. Worked according to SLAs (Service Level Agreements) & TATs (Turn Around Time) to meet the KPI (Key Performance Indicators.) Creation of SOP using MS Word for several clients and list down all the task on how to deal with data and later get it approved for future references.