Rajiv Kumar
Senior BI & Data Analytics Lead | Power BI | SQL Server | Data Engineering | ETL | Microsoft Fabric | Python
Hire this person
Send a job offer directly to this candidate
About
Senior Business Intelligence, Data Analytics and Data Engineering professional with 15+ years of experience across BI development, database development, ETL, reporting automation, data migration and enterprise analytics. Strong hands-on expertise in Power BI, SQL Server, Microsoft Fabric, Azure, SSIS, SSRS, Python, Tableau, Excel and VBA.
Experienced across the full data lifecycle: data ingestion, validation, transformation, database design, data modeling, Power BI semantic models, dashboards, security, deployment and production support. Strong expertise in Star/Snowflake Schema, DAX, Power Query, RLS, SQL performance tuning, large datasets and BI migration. Extensive business experience in E-commerce, Retail, Supply Chain, Logistics, Inventory, Warehouse and Travel/Booking.
Experienced with Directors, MDs, senior management and investors, delivering accurate and timely information that supports faster operational, investment and business-growth decisions.
Experience
Module Lead – BI / Data Analytics - Trigent Software
(2023-11 - 2024-01)
- Lead BI, analytics and data initiatives using Power BI, SQL Server, ETL, Python, Microsoft Fabric and enterprise reporting.
- Design Power BI Semantic Models using Star and Snowflake Schema principles; develop DAX, Power Query, dashboards and executive reports.
- Implement Row-Level Security and user-level data access controls; validate large datasets and highly loaded files before database loading.
- Support ETL, data flows, integration, testing and deployment across Development, QA and Production; use GitHub and Jira for change management.
- Business impact: improve data reliability and reporting speed so stakeholders can make faster, more confident operational and growth decisions.
IT Specialist – BI / Data & Reporting - Damco Solutions Pvt. Ltd.
(2021-05 - 2023-07)
- Delivered Power BI dashboards, semantic models, SQL/ETL solutions and enterprise reporting based on business requirements.
- Developed and optimized SQL queries, performed data validation and troubleshooting, and supported data integration and reporting modernization.
- Business impact: provided centralized, reliable reporting and improved management visibility into business performance.
IT Analyst – Business Intelligence - National Cash Register (NCR)
(2018-01 - 2021-01)
- Worked on enterprise BI solutions using Power BI, SQL Server, SSRS and data modeling.
- Migrated legacy SSRS reports to Power BI; designed Semantic Models and Star Schema structures; developed dashboards and reports.
- Implemented RLS and user access controls; performed source-to-report validation and reconciliation to ensure accurate results.
- Supported Power BI Service deployment, report publishing and stakeholder requirements.
- Business impact: modernized reporting, improved accessibility and visibility of business information, and enabled faster analysis and decision-making.
IT Analyst - Shuttl.com
(2016-02 - 2017-03)
- Developed operational and management reporting using SQL, Excel, VBA and BI technologies.
- Automated recurring MIS reporting and consolidated data from multiple business sources.
- Business impact: reduced manual reporting effort and improved turnaround time for operational decisions.
Assistant Manager – Reporting - Jabong.com
(2012-03 - 2015-12)
- Managed MIS, reporting and analytics in an E-commerce environment using Excel, VBA and BI reporting.
- Developed dashboards covering retail, supply chain, logistics, inventory and warehouse operations.
- Automated repetitive reporting and translated operational requirements into management dashboards.
- Business impact: improved visibility of operational performance and enabled faster planning and business decisions.
Senior MIS Executive - Fareportal India Pvt. Ltd.
(2009-04 - 2012-03)
- Developed MIS and management reports using Excel and VBA; worked with booking, cancellation, revenue and operational datasets.
- Automated recurring reports and consolidated information from multiple sources.
- Business impact: reduced manual effort and improved consistency and speed of management reporting.
