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 workSalary Range
₹45000/yr - ₹200000/yrTimeline
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