Rajanish Rajput

✓ Led end-to-end migration of enterprise reporting from on-premise data
warehouse to Azure Cloud, implementing Azure Synapse Analytics and Azure
Data Factory pipelines to land structured data into Azure Data Lake for cloud
based analytics and reporting.
✓ Designed & executed transition from Azure Synapse to Microsoft Fabric using
Synapse Link and OneLake, enabling unified Lakehouse architecture with
Fabric Dataflows Gen2, Python notebooks, Event Streams, and Fabric-native
Power BI reporting.
✓ Implemented Medallion Lakehouse Architecture (Bronze, Silver, Gold) to
standardise ingestion, transformation, and reporting layers, improving
auditability, lineage, and reuse across analytics and regulatory reporting use
cases.
✓ Developed incremental ingestion pipelines with control totals and
reconciliation checks to validate data completeness and accuracy between
source extracts and Lakehouse layers.
✓ Built governed self-service analytics using M365 Copilot Data Agent on
curated Gold Layer datasets, publishing insights securely to end users.
✓ Delivered CRM analytics & customer segmentation using RFM (Recency,
Frequency, Monetary) profiling in Power BI to support targeted decision
making.

 Design, Develop, Test, and Integrate Reports, Paginated Reports, Dashboards in DEV, QA, and PROD environment on Power BI Server (On-Premises server) and Power BI Service (On-Cloud Service) using multiple data sources (operational databases, APIs, spreadsheets, data warehouses, etc.) based on functional specifications and requirements
 Collaborate with customers/clients and internal teams to design, develop, and deliver meaningful reports, analytics, and actionable insights that help customers derive value from the Petronas Platform and operational data
 Deliver an exceptional end-user experience for our customers/client by implementing Self Service Reporting & Analytics capabilities for End users
 Ensure Delivery Excellence by delivering committed deliverables on time and with very high quality
 Work closely with all business areas to capture BI (Business Intelligence) requirements based on business objectives, initiatives, challenges, and questions
 Provide BI / reporting on all the identified KPI areas specified in the KPI requirements document by creating, developing, and maintaining BI reports in Microsoft Power BI.
 Share advice on technical aspects of BI development and integration, including the operational and maintenance aspects of systems under development, and proposed system recovery procedures.
 End-to-end migration of Power BI reports from SQL DB to Azure DB.
 Developed complex DAX formula and M language in Power Query for an SAP Process Dashboard and Incident Management Dashboard
 Reduced Power BI Report size by 25% using best practices and DAX Studio

strategic implications of business intelligence data for approx. 5, 000 Telecom Towers
•Developed data-gathering from diverse sources like MTM/Trion/Telecom system, structuring, and transforming ensuring data needs for business is befitting the purpose and accurate
•Analyzed business and technical requirements, shared feedback to improve existing processes, and established analytics infrastructure and architecture for running dashboards, KPI, and Adhoc analysis on Power BI, SQL, and Excel
•Developed analytics capabilities, scaled data-driven initiatives across all business areas, evolving analytics to influence companys strategic planning and executives decision-making
•Prepared data model, analyzed and find relationships, identify trends
•As an additional responsibility, liaise with mobile application development team for end-to-end development of mobile application
•Created reports, SOPs for daily/weekly/monthly/quarterly business reports
•Discovered 30% fake data by trend analysis and saved 15% diesel losses
•Discovered latent trends using time series analysis and saved $50, 000

BI Tools; PowerBI; SAP BO; Tableau; SQL; SAS; VBA; SharePoint; Python; AWS

✓ Developed analytics reports, dashboards and performed
operations related analysis and planning using data mining,
descriptive, predictive analysis techniques to improve processes.
✓ Extracted, compiled, tracked data, and analyzed it to generate
report.
✓ Documentation and updation of report related SOPs.
✓ Managed ad-hoc requests on daily/weekly/monthly basis.
✓ Created VBA codes which sends unique mail containing unique
info to infinite recipients which increased return rate by 5-6%.
✓ Migrated Asset Recovery Reporting Process in 2 months; managed
it independently was earlier managed by 2 analysts.

✓ Developed HR and regulatory reports supporting judiciary and compliance
cases.
✓ Delivered audit-ready reporting and data extracts for internal and external
regulatory reviews.
✓ Ensured data accuracy, traceability, and documentation for compliance
submissions.