Summary
Overview
Work History
Education
Skills
Accomplishments
Work Preference
Timeline
Generic
Open To Work

Ranjan Ojha

Greater Noida

Summary

Results-driven Data Analyst with a proven track record at Ranjan, leveraging SQL querying and predictive modeling to enhance decision-making. Expert in data visualization, I transformed complex datasets into actionable insights, driving operational improvements and fostering collaboration across teams. Committed to delivering high-quality analytics that support strategic business objectives.

Overview

5
5
years of post-secondary education
1
1
year of professional experience

Work History

Data Analyst

Ranjan
05.2025 - Current
  • Data Analytics Achievements
  • Analyzed large datasets to identify trends and improve decision-making.
  • Created interactive dashboards using Excel, Power BI, or Tableau.
  • Improved data accuracy by cleaning and organizing raw data efficiently.
  • Generated business reports that helped increase operational performance.
  • Performed data visualization to present insights in an easy-to-understand format.
  • Used SQL queries to extract and manage important business data.
  • Automated repetitive reporting tasks, reducing manual work time.
  • Assisted in predicting trends through statistical and analytical techniques.
  • Conducted market research and data interpretation for business growth.
  • Improved reporting efficiency through advanced Excel functions and charts.
  • Analyzed data sets to identify trends and patterns for strategic decision-making.
  • Developed reports using Excel to present findings to team members and management.
  • Translated raw data into meaningful information using statistical techniques.

Law Firm Assistant

Ranjan
New Delhi
10.2025 - 11.2025
  • Managed client correspondence and maintained confidentiality of sensitive information.
  • Assisted attorneys in preparing legal documents and case files for court proceedings.
  • Organized case files and documentation for easy access and retrieval during trials.
  • Answered incoming calls from clients and other attorneys in a professional manner.
  • Supported team by participating in meetings, taking notes, and distributing minutes promptly.
  • Provided administrative support services, including scheduling appointments, maintaining calendars, and making travel arrangements.
  • Monitored deadlines for filings with state or federal courts.
  • Updated contact databases on a regular basis with new information about clients or potential leads.
  • Proofread all correspondence before sending it out to clients or other parties involved in the case.
  • Managed inventory of office supplies necessary for daily operations.
  • Handled confidential information with discretion and integrity.

Data Analyst

Ranjan
New Delhi
05.2025 - 06.2025
  • Analyzed data sets to identify trends and patterns for strategic decision-making.
  • Developed reports using Excel to present findings to team members and management.
  • Analyzed large datasets to identify trends, patterns and correlations for business insights.
  • Leveraged SQL queries to extract, transform and load data into databases.
  • Generated reports and obtained data to develop analytics on key performance and operational metrics.
  • Utilized advanced analytics tools such as SAS, SPSS, Excel PowerPivot, to manipulate large volumes of structured and unstructured data sets.
  • Worked closely with management to prioritize business and information needs.
  • Monitored performance and quality control plans to identify improvements in data systems.
  • Utilized predictive modeling to increase and optimize customer experiences, revenue generation, ad targeting, and other business outcomes.
  • Maintained library of model documents, templates or other reusable knowledge assets.
  • Disseminated information regarding tools, reports or metadata enhancements.
  • Analyzed data trends to support team decision-making and reporting.
  • Assisted in creating visual representations of data for presentations.
  • Collaborated with team members to identify data quality issues.
  • Utilized Excel and SQL for data extraction and manipulation tasks.
  • Assessed programs to identify risks or problems to determine appropriate responses.
  • Identified and analyzed industry or geographic trends with business strategy implications.
  • Synthesized current business intelligence or trend data to support recommendations for action.
  • Identified or monitored current and potential customers using business intelligence tools.
  • Analyzed competitive market strategies through related product, market or share trends.
  • Managed diverse projects for data capture, storage and forecast analysis.
  • Collected business intelligence data from industry reports, public information or purchased sources.
  • Identified needs of customers promptly and efficiently.
  • Generated standard or custom reports summarizing business, financial or economic data.
  • Created or reviewed technical design documentation to drive accuracy of reporting solutions.
  • Created and designed business intelligence databases, spreadsheets or outputs.
  • Gathered and organized data to analyze current industry trends.
  • Maintained or updated business intelligence tools, databases or dashboards.
  • Participated in the development of machine learning models to predict outcomes and trends.
  • Conducted data collection, cleaning, and preprocessing to ensure accuracy and reliability of datasets.
  • Participated in project planning and scope definition for analytics initiatives.
  • Provided technical support to team members on data-related issues.
  • Created visualizations using tools like Tableau and Power BI to communicate findings to non-technical stakeholders.
  • Employed Python and R for data manipulation and analysis tasks.
  • Developed and implemented data models to support business decision-making.
  • Contributed to the development of data governance and management policies.
  • Performed statistical analysis to identify data trends and patterns.
  • Conducted A/B testing to support product development and marketing strategies.
  • Engaged in continuous learning to stay updated on new data analysis tools and techniques.
  • Engaged with external vendors and consultants on data integration projects.
  • Prepared detailed reports and presentations summarizing analytical findings.
  • Implemented data quality control measures to maintain integrity of analysis.
  • Assisted in data privacy and security assessments to ensure compliance with regulations.
  • Assisted in identifying opportunities for improving data collection and analysis processes.
  • Supported the maintenance and optimization of data storage systems.
  • Collaborated with cross-functional teams to understand data requirements and deliver actionable insights.
  • Assisted in developing strategies for collecting, organizing, and storing large amounts of data efficiently.
  • Analyzed customer feedback surveys to understand user experience with products and services.
  • Collaborated with other teams to develop analytics solutions that provide value-added insights.
  • Performed exploratory data analysis on large datasets to identify trends and outliers.
  • Created SQL queries to extract relevant information from relational databases for various projects.
  • Developed data visualizations and dashboards to track business metrics using Tableau.
  • Extracted data to build metrics or create dashboards, tracking success toward KPIs.
  • Documented processes and procedures for future reference and training purposes.
  • Conducted research to gather relevant industry data for analysis purposes.
  • Participated in team meetings to discuss project updates and strategies.
  • Prepared reports summarizing findings for supervisor review and feedback.

Education

Ba.llb - Law

Subharti University
Delhi, India
08.2024 - 08.2029

Skills

  • Data analysis
  • SQL querying
  • Predictive modeling
  • Data visualization

Accomplishments

Participated in Youth Sansad (Youth Parliament) college competition and demonstrated public speaking and leadership skills.

Work Preference

Job Search Status

Open to work

Salary Range

₹45000/yr - ₹200000/yr

Timeline

Law Firm Assistant

Ranjan
10.2025 - 11.2025

Data Analyst

Ranjan
05.2025 - Current

Data Analyst

Ranjan
05.2025 - 06.2025

Ba.llb - Law

Subharti University
08.2024 - 08.2029
Ranjan Ojha