JAI KUMAR JAJORIA
Delhi
Summary
A highly motivated and detail-oriented research analyst with a strong background in data analysis, statistical modeling, and research design. Seeking a challenging carrier objective in a working environment where I can maximize my productivity affectivity and career growth.
Overview
5
5
years of professional experience
Work History
Data Analyst Intern
Brillica Services Pvt Ltd
NEW DELHI
10.2023 - 04.2024
• Extracted and analyzed data from databases using SQL queries, ensuring data integrity.
• Conducted exploratory data analysis using Tableau to visualize trends, patterns, and outliers, providing actionable insights.
• Developed interactive data visualization dashboards and reports in Power BI for effective communication of key metrics to management.
• Automated data processing tasks through VBA macros in Excel, streamlining workflows and improving productivity.
• Collaborated with cross-functional teams, gathering requirements, analyzing data, and presenting insights to align data-driven solutions with organizational goals.
Senior Patent Associate
Arctic Invent
09.2022 - 10.2023
- Conduct patentability search on various projects related to aeroplane engines and semiconductor memory
- Analyze and interpret references using statistical tools and techniques
- Prepare patentability reports and presentations summarizing research findings and recommendations
- Prepare interactive dashboards on electric vehicle and semiconductors.
Patent Analyst
SAGACIOUS IP
03.2022 - 07.2022
- Conducted quantitative and qualitative research on various projects related to automotive technology and on-board devices of cars and automobiles
- Analyze and interpret data using statistical tools and techniques
- Prepare reports and presentations summarizing research findings and recommendations
- Collaborate with cross-functional teams to identify research needs and develop research plans.
Associate
Anuation Research & Consulting LLP
05.2019 - 03.2022
- Assisted with data collection, analysis, and management for various research projects
- Conducted technical literature reviews and synthesized research findings
- Contributed to the development of research protocols or search strategies and data collection instruments
- Participated in data analysis and interpretation
- Prepared research reports and presentations
- Conducted SWOT analysis for Landscape Report.
Education
GGSIP UNIVERSITY
01.2015
CBSE
01.2010
CBSE
01.2008
Skills
- Data Analytics
- Report Writing
- Data Cleaning
- Bi Tools Expertise
- Statistical Analysis
- Data Modeling
- Data Annotations
- Record Preparation And Maintenance
- Data Reporting
- Database Management
- Data Pre-processing
- Machine Learning
- Data Visualization
- Market Research
- Data Screening
Technical Skill
- SWOT analysis: based research and visualization.
- Data Analysis: Proficient in extracting, cleaning, and analyzing data to derive actionable insights.
- MS Excel: Advanced proficiency with a focus on functions like INDEX, MATCH, SUMIFS, PivotTables, and advanced charting.
- Data Cleansing: Skilled in using Excel's Text functions, TRIM, and CLEAN for effective data cleansing.
- Statistical Analysis: Familiarity with statistical functions for in-depth data analysis.
- SQL advance
- Data Visualization: Experience in creating dynamic dashboards using Power BI and Tableau, as well as crafting visualizations for effective communication of insights. Proficient in leveraging these tools to present complex data in an easily understandable and visually appealing format.
- Collaboration: Ability to work collaboratively with cross-functional teams to understand data needs and requirements.
- Good at preparing google strings.
Personal Information
- Father's Name: Sh. MAN SINGH JAJORIA
- Date of Birth: 03/27/1992
- Gender: Male
- Nationality: Indian
Patent Searches Performed
- Novelty Search
- Infringement Searches
- Patentability Searches
- EOU chart preparations
- Validity/Invalidity Searches
- Market Research
Training Skill
- CHNS soil analyzer functioning and commissioning from Shiva Logistics Pvt Ltd.
- Training of Spice Tools for VLSI Software.
Hobbies and Interests
- Travelling
- Listening Music.
Disclaimer
I here by certify that all the above state information is correct & truthful in the best of my knowledge and belief.
Languages
- English
- Hindi
Timeline
Data Analyst Intern
Brillica Services Pvt Ltd
10.2023 - 04.2024
Senior Patent Associate
Arctic Invent
09.2022 - 10.2023
Patent Analyst
SAGACIOUS IP
03.2022 - 07.2022
Associate
Anuation Research & Consulting LLP
05.2019 - 03.2022
GGSIP UNIVERSITY
CBSE
CBSE
Similar Profiles
CHITTARANJAN SINGHCHITTARANJAN SINGH
Intern at Brillica ServicesIntern at Brillica Services
Rakesh KumarRakesh Kumar
Data Analyst at Brillica ServicesData Analyst at Brillica Services
Gaurav Singh AswalGaurav Singh Aswal
DATA ANALYST(INTERN) at BRILLICA SERVICESDATA ANALYST(INTERN) at BRILLICA SERVICES
Saksham MauryaSaksham Maurya
DevOps Solution Architect – Assistant Consultant at Tata Consultancy ServicesDevOps Solution Architect – Assistant Consultant at Tata Consultancy Services
JITENDRA JANGIDJITENDRA JANGID
Assistant Manager - Consulting & Analytics at ICICI Lombard General Insurance CoAssistant Manager - Consulting & Analytics at ICICI Lombard General Insurance Co