Sanjeev Rao
New Delhi
Summary
I am a detail-oriented Reporting Analyst with expertise in SQL development and Power BI dashboarding. My background includes cloud-based data integration using Google Big Query and a strong commitment to optimizing reporting processes. I excel in translating complex data into actionable insights, ensuring operational efficiency through effective stakeholder management, and driving strategic growth through robust BI solutions
Overview
10
10
years of professional experience
Work History
Business Analyst
British Telecom
Gurgaon
03.2021 - 03.2026
- Designed and implemented complex data solutions for cloud-based platforms, focusing on ELT processes and data integration using Oracle SQL, Google BigQuery GCP, and Power Query/DAX within Power BI.
- Collaborated with cross-functional teams to gather requirements and translate them into SQL-based data models, semantic layers, and Power BI dashboards.
- Developed and optimized SQL queries, stored procedures, and views across BigQuery and Oracle SQL, improving performance and enabling efficient data manipulation.
- Managed data ingestion pipelines across multiple sources, leveraging GCP services and metadata-driven frameworks.
- Ensured data accuracy and accessibility through robust validation checks and automated refresh schedules in Power BI dashboards.
- Built strong client relationships across multiple geographies to ensure business trust through governance-driven reporting.
- We are engaged with our client, British Telecom BT, a leading UK-based multinational company that delivers internet and telecommunications services across the United Kingdom. Our work focuses on supporting BT's products and solutions to enhance connectivity and customer experience.
Business Development Associate
Wipro
Pune
10.2015 - 02.2021
- Handled bridge cases and managed multiple applications.
- Worked on the administration aspect in OBIEE as well.
- Gathered user requirements and analyzed core business concepts.
- Analyzed the data model and designed the dimensional model after discussions with designers and customers.
- Prepared mockup screens and demo reports to present to customers for confirmation that reports met their requirements.
- Engaged in regular conversations with clients regarding the development of scenarios.
- Designed the repository after importing tables and implementing data models and business logic in RPD (metadata layer).
- Created and designed reports, charts, and dashboards.
- Customized reports using features like static text, filters, pivots, narratives, etc., as per customer requirements.
- Customized style and skin by configuring the dedicated folder.
- Created dimensional hierarchies to view detailed levels of information.
- Implemented data-level and object-level security.
- Working as a Qlik administrator, also capable of developing applications in Qlik.
Education
BCA -
Kolhan University
Skills
- SQL
- Business intelligence
- Data governance
- Microsoft Power BI
- Google BigQuery
- Python
Training
- GCP Professional Data Engineer
- Big query for Big Data engineer
Languages
- English
- Telegu
- Hindi
- English
- Telegu
Timeline
Business Analyst
British Telecom
03.2021 - 03.2026
Business Development Associate
Wipro
10.2015 - 02.2021
BCA -
Kolhan University