Rajiv Kumar

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.

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.

Graduate