Description

Hi, I'm Rajat.

I'm a Business Analyst with over 4 years of experience helping businesses turn data into meaningful insights and improve day-to-day processes. I work closely with stakeholders to understand business requirements, analyze existing workflows, and deliver solutions that support better decision-making.

My experience includes requirement gathering, business process analysis, BRD/FRD preparation, user stories, stakeholder management, UAT support, SQL, Power BI, and Advanced Excel. I've built dashboards, automated reporting, and worked with cross-functional teams to deliver projects in Agile environments.

I can help you with:

Business Analysis & Requirement Gathering

BRD, FRD & User Story Documentation

SQL Data Analysis & Reporting

Power BI Dashboards & KPI Reporting

Excel Automation & Reporting

Process Mapping & Gap Analysis

Stakeholder Management & UAT Support

Business Process Improvement

I focus on understanding the business problem first and then delivering practical, data-driven solutions that save time, improve reporting, and support informed decision-making.

If you're looking for someone who communicates well, understands business needs, and can bridge the gap between business and technology, I'd be happy to discuss your project.

Industry field of expertise

Languages

English
Native or bilingual

Workplace preferences

Can work on-site

Pune (up to 50km), Mumbai (up to 50km), Bengaluru (up to 50km), Chennai (up to 50km), Ahmedabad (up to 50km)

SG Analytics (A Straive Company),
Associate Analyst
January 2023 - Today (3 years and 7 months)
Pune, Maharashtra, India
• • Promoted internally from consultant based on performance and expanded ownership across reporting and business analysis initiatives.
• • Work closely with senior managers and stakeholders to elicit business requirements, understand reporting needs, and translate them into actionable dashboards and automated reports in Power BI and Excel.
• • Document functional requirements and reporting logic; prepare BRDs/user stories to ensure clear understanding and smooth handoffs to the
development team.
• • Identify manual reporting bottlenecks and design automation solutions using Excel (macros and templates), reducing weekly manual effort by -35% and
improving consistency across multiple teams.
• • Facilitate KPI definition workshops with cross-functional stakeholders; establish KPI frameworks, definitions, and build KPI tracking dashboards to drive data-backed decision making.
• • Support UAT for reports and dashboards by validating requirements, logging defects, coordinating sign-offs with stakeholders, and maintaining version
change logs and documentation.
• • Collaborate with data and engineering teams to improve data pipelines through logic fixes and optimization, reducing processing time by -40% and
improving report reliability and data availability.
• • Build interactive dashboards and self-service reporting solutions that enable business users to access insights independently, reducing report turnaround time from 2-3 days to near real-time.
Requirements Gathering Stakeholder Management Business intelligence Agile method Atlassian JIRA
STRAIVE
Consultant
January 2023 - Today (3 years and 7 months)
• • Worked with clients across FMCG, retail, and financial services to understand reporting needs and build dashboards used by business teams.
• • Discussed requirements with stakeholders and converted them into reports and dashboards to improve visibility and tracking
• • Used SQL, Power BI, and Tableau to prepare reports and support day-to-day business decisions.
• • Created reporting documents and coordinated with internal teams to ensure timely delivery.
Requirements Gathering Microsoft Power BI Business intelligence Stakeholder Management SQL
NatWest Group,
Reporting Analyst
September 2021 - December 2022 (1 year and 3 months)
Pune, Maharashtra, India
• • Supported finance and operations teams with monthly reporting using Excel and SQL; ensured accuracy and timely delivery of reports, reducing the
reporting cycle from 5 days to 3 days through process and data improvements.
• • Built Power BI dashboards for teams to monitor key metrics and trends, replacing manual email-based updates and enabling quicker visibility for
managers.
• • Performed data quality checks, reconciliations, and process documentation to support audit queries and maintain data integrity.
• • Collaborated with cross-functional teams to standardize reporting processes and improve data accuracy across business functions.

KEY WINS
• • Reduced a weekly manual reporting process from ~8 hours to under 2 hours using Excel automation, adopted across multiple teams.
• • Built dashboards for 5+ Agile projects that replaced slide decks in leadership updates, saving time and reducing last-minute data requests.
• • Reduced data processing time from 5 hours to 3 hours by improving SQL queries and reporting workflows
• • Enabled self-service reporting for business teams, reducing report turnaround time from 2–3 days to near real-time.
Microsoft Power BI SQL Agile method Data analysis stakeholder management