Rupam Kumar on Tal
Headline
Lead BI Engineer @HCLTech | Data Analyst | Power BI | SQL | Data Visualization | Dax, M-Dax | Measure | DSA | Python |NumPy| Pandas| AI | GIT | Docker | Jira | Confluence |Microsoft 4x certified|
About
I am a Software Engineer at HCLTech with over 4+ years of hands-on experience in Power BI Development, Data Analytics, and Business Intelligence. My experience includes designing end-to-end reporting solutions, transforming complex data into meaningful insights, and developing interactive dashboards that support business and operational decision-making. I have extensive experience working with Power BI, SQL, DAX, Power Query, and data modeling. I have developed interactive dashboards, optimized SQL views and queries, implemented complex DAX calculations, configured Row-Level Security (RLS), and worked on incremental refresh and Power BI deployment activities. I have also contributed to improving reporting efficiency by reducing manual efforts and ensuring data accuracy and consistency. I have worked with data from multiple sources, including Oracle, MySQL, Excel, APIs, and other enterprise data platforms. My responsibilities have covered the complete Power BI development lifecycle, including requirement gathering, data extraction, transformation, data modeling, visualization, testing, deployment, and post-deployment support. I am PL-300 (Microsoft Power BI Data Analyst) certified, validating my knowledge of data preparation, modeling, visualization, analysis, and Power BI best practices. I also hold certifications including AZ-900, DP-900, DP-600, GH-900, and GH-300. Alongside my current role, I am continuously developing my skills in Python, Data Science, and advanced analytics to strengthen my analytical capabilities and build more data-driven and insight-oriented solutions. I am open to full-time opportunities and freelance projects in Power BI Development, Data Analysis, and Business Intelligence, where I can contribute through strong technical expertise, problem-solving ability, adaptability, and a continuous learning mindset. 📌 Core Skills: Power BI | SQL | DAX | Power Query | Data Modeling | Data Analysis | Dashboard Development | Business Intelligence | Python | ETL | Data Visualization | RLS | Incremental Refresh | Power BI Service | Oracle | MySQL | Excel | APIs | Data Warehouse | Data Lake | OLTP | OLAP | Microsoft Fabric 📌 Certifications: PL-300 | AZ-900 | DP-900 | DP-600 | GH-900 | GH-300 | AWS AI Associate |
AI stack
aistudio
anthropic apis
antigravity
claude code
claude
codex
Work experience
Lead Engineer at HCLTech, Oct 2025 - Present · 11 mos, Noida, In my role at HCLTech, I was responsible for leading the development of Business Intelligence solutions, ensuring seamless deployment through CI/CD processes in Azure. I gathered client requirements, created impactful dashboards, and implemented RLS for data security. My expertise in SQL and Power BI allowed me to deliver comprehensive reports that met client needs effectively.
Business Intelligence Engineer at HCLTech, Jan 2024 - Present · 2 yrs 8 mos, Developed an end-to-end Fraud Analytics and Reporting platform for Allied Irish Banks (AIB) to automate fraud monitoring and reporting processes. Built real-time Power BI dashboards to track fraud cases, FIR status, customer details, and historical trends across banking fraud datasets. Designed optimized SQL views in Oracle and MySQL handling more than 1200 data fields, improving data accuracy and refresh performance. Developed advanced DAX measures, time intelligence functions, calculated tables, and Power Query transformations for fraud metrics. Created interactive Power BI dashboards with KPI cards, matrices, drill-through analysis, and trend visualizations for fraud investigations. Integrated data from Excel, Oracle, MySQL, APIs, and SQL models into a unified fraud analytics dataset. Automated report using SQL views and Power Query reducing manual Excel work by 80%. Delivered ad-hoc analytics using optimized SQL queries and automated scripts and reducing manual data extraction by 85%.
Senior Software Engineer at HCLTech, Oct 2024 - Sep 2025 · 1 yr, Noida
Education
B.tech, Computer Science and Engineering, government engineering college bikaner
Diploma of Education, Computer Engineering, Government Polytechnic College, Patna
