Saurabh Raj

Senior Research Analyst at Estater Pvt. Ltd. (2024-08 – Present)

Led end-to-end research and data operations, managing team workflows and ensuring the timely delivery of high-quality, accurate outputs.
Performed advanced data analysis using Advanced Excel (Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, Dashboards) and Python for data processing, automation, and reporting.
Executed comprehensive QA/QC processes to validate large datasets, ensuring data accuracy, consistency, and integrity.
Developed interactive dashboards and analytical reports using Power BI and Excel to support business intelligence and strategic decision-making.
Utilized Azure DevOps (ADO) for task management, issue tracking, defect reporting, and collaboration with cross-functional teams.
Applied QGIS and GIS techniques for spatial data editing, transformation, visualization, and geospatial analysis.
Performed spatial data editing, validation, transformation, and map-based analysis to ensure high-quality geospatial datasets.
Possess working knowledge of SQL for querying, filtering, joining, and validating data in relational databases.
Streamlined business processes through automation and workflow optimization, improving operational efficiency and reducing manual effort.
Mentored junior analysts, conducted knowledge-sharing sessions, and supported team development through training and technical guidance.
Collaborated with stakeholders to understand business requirements, deliver analytical insights, and drive data-informed decision-making.

Senior Business Analyst at Truman Marktech Services Pvt. Ltd (2022-07 – 2024-05)

Collect, analyze, and interpret data from various sources to uncover insights that inform marketing strategies and campaign optimizations.
Develop and maintain comprehensive reports and dashboards that visualize key performance metrics and KPIs for client campaigns.
Identify market trends, consumer behaviors, and competitive landscape to recommend strategic opportunities and potential threats.
Monitor campaign performance and conduct testing to optimize marketing tactics and improve ROI.
Utilize statistical techniques and predictive modeling to forecast trends, evaluate potential scenarios, and support decision-making processes.
Work closely with marketing teams, data scientists, and other stakeholders to align analytics efforts with business goals and client expectations.
Stay updated on industry trends, emerging technologies, and best practices in marketing analytics to enhance service offerings and deliver innovative solutions.

Research Analyst at Inspired Livving Technologies Pvt. Ltd. (2021-05 – 2022-07)

Conducting thorough research to understand market trends, demographics, and economic factors influencing rental demand and pricing.
Performing detailed financial analysis, including cash flow projections, ROI calculations, and financial modeling for real estate investments.
Utilizing various valuation methods such as comparative market analysis (CMA), income approach, and cost approach to determine property values accurately.
Conducting due diligence on potential real estate acquisitions, analyzing risks, reviewing financial documents, and assessing investment viability.
Preparing comprehensive reports, presentations, and dashboards to communicate findings and insights.
Building relationships with tenants, understanding tenant needs, and implementing strategies to enhance tenant satisfaction and retention.
Utilizing real estate management software and databases to organize and analyze property data effectively, improving operational efficiency and decision-making processes.

About